public void Handle(GameClient Session, ClientMessage Event)
{
Room @class = GoldTree.GetGame().GetRoomManager().GetRoom(Session.GetHabbo().CurrentRoomId);
if (@class != null && @class.CheckRights(Session, true))
{
foreach (uint current in @class.UsersWithRights)
{
RoomUser class2 = @class.GetRoomUserByHabbo(current);
if (class2 != null && !class2.IsBot)
{
class2.GetClient().SendMessage(new ServerMessage(43u));
}
ServerMessage Message = new ServerMessage(511u);
Message.AppendUInt(@class.Id);
Message.AppendUInt(current);
Session.SendMessage(Message);
}
using (DatabaseClient class3 = GoldTree.GetDatabase().GetClient())
{
class3.ExecuteQuery("DELETE FROM room_rights WHERE room_id = '" + @class.Id + "'");
}
@class.UsersWithRights.Clear();
}
}
public void Handle(GameClient Session, ClientMessage Event)
{
if (Session.GetHabbo() == null)
{
Session.method_6(Event.PopFixedString());
if (Session.GetHabbo() != null && Session.GetHabbo().list_2 != null && Session.GetHabbo().list_2.Count > 0)
{
using (DatabaseClient @class = GoldTree.GetDatabase().GetClient())
{
try
{
ServerMessage Message = new ServerMessage(420u);
Message.AppendInt32(Session.GetHabbo().list_2.Count);
foreach (uint current in Session.GetHabbo().list_2)
{
string string_ = @class.ReadString("SELECT username FROM users WHERE Id = " + current + " LIMIT 1;");
Message.AppendStringWithBreak(string_);
}
Session.SendMessage(Message);
}
catch
{
Console.ForegroundColor = ConsoleColor.Red;
Logging.WriteLine("Login error: User is ignoring a user that no longer exists");
Console.ForegroundColor = ConsoleColor.Gray;
}
}
}
}
}
public uint method_27(string string_0)
{
GameClient @class = this.GetClientByHabbo(string_0);
uint result;
if (@class != null && @class.GetHabbo() != null)
{
result = @class.GetHabbo().Id;
}
else
{
DataRow dataRow = null;
using (DatabaseClient class2 = GoldTree.GetDatabase().GetClient())
{
dataRow = class2.ReadDataRow("SELECT Id FROM users WHERE username = '******' LIMIT 1");
}
if (dataRow == null)
{
result = 0u;
}
else
{
result = (uint)dataRow[0];
}
}
return(result);
}
public UserDataFactory(string string_0, bool bool_1)
{
using (DatabaseClient @class = GoldTree.GetDatabase().GetClient())
{
@class.AddParamWithValue("username", string_0);
this.dataRow_0 = @class.ReadDataRow("SELECT * FROM users WHERE username = @username LIMIT 1;");
if (this.dataRow_0 != null)
{
this.bool_0 = true;
uint num = (uint)this.dataRow_0["Id"];
if (bool_1)
{
this.dataTable_0 = @class.ReadDataTable("SELECT achievement_id,achievement_level FROM user_achievements WHERE user_id = '" + num + "'");
this.dataTable_1 = @class.ReadDataTable("SELECT room_id FROM user_favorites WHERE user_id = '" + num + "'");
this.dataTable_2 = @class.ReadDataTable("SELECT ignore_id FROM user_ignores WHERE user_id = '" + num + "'");
this.dataTable_3 = @class.ReadDataTable("SELECT tag FROM user_tags WHERE user_id = '" + num + "'");
this.dataTable_4 = @class.ReadDataTable("SELECT subscription_id, timestamp_activated, timestamp_expire FROM user_subscriptions WHERE user_id = '" + num + "'");
this.dataTable_5 = @class.ReadDataTable("SELECT user_badges.badge_id,user_badges.badge_slot FROM user_badges WHERE user_id = " + num);
this.dataTable_6 = @class.ReadDataTable("SELECT Id,base_item,extra_data FROM items WHERE room_id = 0 AND user_id = " + num);
this.dataTable_7 = @class.ReadDataTable("SELECT user_effects.effect_id,user_effects.total_duration,user_effects.is_activated,user_effects.activated_stamp FROM user_effects WHERE user_id = " + num);
this.dataTable_8 = @class.ReadDataTable("SELECT users.Id,users.username,users.motto,users.look,users.last_online FROM users JOIN messenger_friendships ON users.Id = messenger_friendships.user_two_id WHERE messenger_friendships.user_one_id = '" + num + "'");
this.dataTable_9 = @class.ReadDataTable("SELECT messenger_requests.Id,messenger_requests.from_id,users.username FROM users JOIN messenger_requests ON users.Id = messenger_requests.from_id WHERE messenger_requests.to_id = '" + num + "'");
@class.AddParamWithValue("name", (string)this.dataRow_0["username"]);
this.dataTable_10 = @class.ReadDataTable("SELECT * FROM rooms WHERE owner = @name ORDER BY Id ASC LIMIT " + LicenseTools.Int32_4);
}
}
else
{
this.bool_0 = false;
}
}
}
public ServerMessage method_10(string string_0)
{
DataTable dataTable = null;
using (DatabaseClient @class = GoldTree.GetDatabase().GetClient())
{
@class.AddParamWithValue("query", string_0);
dataTable = @class.ReadDataTable("SELECT Id,title FROM help_topics WHERE title LIKE @query OR body LIKE @query LIMIT 25");
}
ServerMessage Message = new ServerMessage(521u);
ServerMessage result;
if (dataTable == null)
{
Message.AppendBoolean(false);
result = Message;
}
else
{
Message.AppendInt32(dataTable.Rows.Count);
foreach (DataRow dataRow in dataTable.Rows)
{
Message.AppendUInt((uint)dataRow["Id"]);
Message.AppendStringWithBreak((string)dataRow["title"]);
}
result = Message;
}
return(result);
}
public void Action(RoomItem Item, Task Task, string ExtraData)
{
if (ExtraData == "1")
{
Task.Wait(7000);
Item.FireWorkCount--;
using (DatabaseClient dbClient = GoldTree.GetDatabase().GetClient())
{
dbClient.AddParamWithValue("itemid", Item.uint_0);
dbClient.ExecuteQuery("UPDATE items_firework SET fw_count = fw_count - 1 WHERE item_id = @itemid LIMIT 1");
}
}
if (Item.FireWorkCount == 0)
{
ExtraData = "0";
}
Item.ExtraData = ExtraData;
Item.UpdateState(true, true);
Task.Wait();
Task.Dispose();
}
internal void method_18()
{
using (DatabaseClient @class = GoldTree.GetDatabase().GetClient())
{
this.method_19(@class, false);
}
}
public void method_3(int int_1)
{
AvatarEffect @class = this.method_5(int_1, false);
if (@class != null && [email protected]_0 && [email protected]_0 && (this.method_8() != null && this.method_8().GetHabbo() != null))
{
Room class2 = this.method_9();
if (class2 != null)
{
RoomUser class3 = class2.GetRoomUserByHabbo(this.method_8().GetHabbo().Id);
if (class3.byte_1 <= 0 && class3.class34_1 == null)
{
using (DatabaseClient class4 = GoldTree.GetDatabase().GetClient())
{
class4.ExecuteQuery(string.Concat(new object[]
{
"UPDATE user_effects SET is_activated = '1', activated_stamp = '",
GoldTree.GetUnixTimestamp(),
"' WHERE user_id = '",
this.uint_0,
"' AND effect_id = '",
int_1,
"' LIMIT 1"
}));
}
@class.method_0();
ServerMessage Message = new ServerMessage(462u);
Message.AppendInt32(@class.int_0);
Message.AppendInt32(@class.int_1);
this.method_8().SendMessage(Message);
}
}
}
}
public void method_1(int int_1)
{
AvatarEffect @class = this.method_5(int_1, true);
if (@class != null && @class.Boolean_0)
{
using (DatabaseClient class2 = GoldTree.GetDatabase().GetClient())
{
class2.ExecuteQuery(string.Concat(new object[]
{
"DELETE FROM user_effects WHERE user_id = '",
this.uint_0,
"' AND effect_id = '",
int_1,
"' AND is_activated = '1' LIMIT 1"
}));
}
this.list_0.Remove(@class);
ServerMessage Message = new ServerMessage(463u);
Message.AppendInt32(int_1);
this.method_8().SendMessage(Message);
if (this.int_0 >= 0)
{
this.method_2(-1, false);
}
}
}
public ServerMessage method_7(GameClient Session)
{
ServerMessage result;
using (DatabaseClient @class = GoldTree.GetDatabase().GetClient())
{
DataTable dataTable = @class.ReadDataTable("SELECT * FROM rooms JOIN user_roomvisits ON rooms.Id = user_roomvisits.room_id WHERE user_roomvisits.user_id = '" + Session.GetHabbo().Id + "' ORDER BY entry_timestamp DESC LIMIT 50;");
List <RoomData> list = new List <RoomData>();
List <uint> list2 = new List <uint>();
if (dataTable != null)
{
foreach (DataRow dataRow in dataTable.Rows)
{
RoomData class2 = GoldTree.GetGame().GetRoomManager().method_17((uint)dataRow["Id"], dataRow);
class2.method_1(dataRow);
list.Add(class2);
list2.Add(class2.Id);
}
}
ServerMessage Message = new ServerMessage(451u);
Message.AppendInt32(0);
Message.AppendInt32(7);
Message.AppendStringWithBreak("");
Message.AppendInt32(list.Count);
foreach (RoomData current in list)
{
current.method_3(Message, false, false);
}
result = Message;
}
return(result);
}
public void method_10()
{
List <UserItem> list_ = this.method_1(this.uint_1).OfferedItems;
List <UserItem> list_2 = this.method_1(this.uint_2).OfferedItems;
foreach (UserItem current in list_)
{
if (this.method_1(this.uint_1).method_1().GetHabbo().method_23().method_10(current.uint_0) == null)
{
this.method_1(this.uint_1).method_1().SendNotif("Trade failed.");
this.method_1(this.uint_2).method_1().SendNotif("Trade failed.");
return;
}
}
foreach (UserItem current in list_2)
{
if (this.method_1(this.uint_2).method_1().GetHabbo().method_23().method_10(current.uint_0) == null)
{
this.method_1(this.uint_1).method_1().SendNotif("Trade failed.");
this.method_1(this.uint_2).method_1().SendNotif("Trade failed.");
return;
}
}
this.method_1(this.uint_2).method_1().GetHabbo().method_23().method_18();
this.method_1(this.uint_1).method_1().GetHabbo().method_23().method_18();
foreach (UserItem current in list_)
{
using (DatabaseClient @class = GoldTree.GetDatabase().GetClient())
{
@class.ExecuteQuery(string.Concat(new object[]
{
"UPDATE items SET room_id = '0', user_id = '",
this.method_1(this.uint_2).method_1().GetHabbo().Id,
"' WHERE Id = '",
current.uint_0,
"' LIMIT 1"
}));
}
this.method_1(this.uint_1).method_1().GetHabbo().method_23().method_12(current.uint_0, this.method_1(this.uint_2).method_1().GetHabbo().Id, true);
this.method_1(this.uint_2).method_1().GetHabbo().method_23().method_11(current.uint_0, current.uint_1, current.string_0, false);
}
foreach (UserItem current in list_2)
{
using (DatabaseClient @class = GoldTree.GetDatabase().GetClient())
{
@class.ExecuteQuery(string.Concat(new object[]
{
"UPDATE items SET room_id = '0', user_id = '",
this.method_1(this.uint_1).method_1().GetHabbo().Id,
"' WHERE Id = '",
current.uint_0,
"' LIMIT 1"
}));
}
this.method_1(this.uint_2).method_1().GetHabbo().method_23().method_12(current.uint_0, this.method_1(this.uint_1).method_1().GetHabbo().Id, true);
this.method_1(this.uint_1).method_1().GetHabbo().method_23().method_11(current.uint_0, current.uint_1, current.string_0, false);
}
this.method_1(this.uint_1).method_1().GetHabbo().method_23().method_9(true);
this.method_1(this.uint_2).method_1().GetHabbo().method_23().method_9(true);
}
private RoomModel method_9(uint uint_0)
{
DataRow dataRow;
using (DatabaseClient @class = GoldTree.GetDatabase().GetClient())
{
dataRow = @class.ReadDataRow("SELECT doorx,doory,height,modeldata FROM room_models_customs WHERE roomid = '" + uint_0 + "'");
}
RoomModel RoomModel = new RoomModel("custom", (int)dataRow["doorx"], (int)dataRow["doory"], (double)dataRow["height"], 2, (string)dataRow["modeldata"], "", false);
if (RoomModel != null)
{
return(RoomModel);
}
else
{
Room Room = this.GetRoom(uint_0);
if (Room != null)
{
Room.method_34();
return(null);
}
else
{
return(null);
}
}
}
public void Handle(GameClient Session, ClientMessage Event)
{
Room class14_ = Session.GetHabbo().CurrentRoom;
if (class14_ != null)
{
Event.PopWiredUInt();
string string_ = Event.PopFixedString();
RoomUser @class = class14_.method_56(string_);
if (@class != null)
{
uint uint_ = @class.GetClient().GetHabbo().Id;
if (Session.GetHabbo().list_2.Contains(uint_))
{
Session.GetHabbo().list_2.Remove(uint_);
using (DatabaseClient class2 = GoldTree.GetDatabase().GetClient())
{
class2.ExecuteQuery(string.Concat(new object[]
{
"DELETE FROM user_ignores WHERE user_id = ",
Session.GetHabbo().Id,
" AND ignore_id = ",
uint_,
" LIMIT 1;"
}));
}
ServerMessage Message = new ServerMessage(419u);
Message.AppendInt32(3);
Session.SendMessage(Message);
}
}
}
}
public void Handle(GameClient Session, ClientMessage Event)
{
Room @class = GoldTree.GetGame().GetRoomManager().GetRoom(Session.GetHabbo().CurrentRoomId);
if (@class != null && Session.GetHabbo().RespectPoints > 0)
{
RoomUser class2 = @class.GetRoomUserByHabbo(Event.PopWiredUInt());
if (class2 != null && class2.GetClient().GetHabbo().Id != Session.GetHabbo().Id&& !class2.IsBot)
{
Session.GetHabbo().RespectPoints--;
Session.GetHabbo().RespectGiven++;
class2.GetClient().GetHabbo().Respect++;
using (DatabaseClient class3 = GoldTree.GetDatabase().GetClient())
{
class3.ExecuteQuery("UPDATE user_stats SET Respect = respect + 1 WHERE Id = '" + class2.GetClient().GetHabbo().Id + "' LIMIT 1");
class3.ExecuteQuery("UPDATE user_stats SET RespectGiven = RespectGiven + 1 WHERE Id = '" + Session.GetHabbo().Id + "' LIMIT 1");
class3.ExecuteQuery("UPDATE user_stats SET dailyrespectpoints = dailyrespectpoints - 1 WHERE Id = '" + Session.GetHabbo().Id + "' LIMIT 1");
}
ServerMessage Message = new ServerMessage(440u);
Message.AppendUInt(class2.GetClient().GetHabbo().Id);
Message.AppendInt32(class2.GetClient().GetHabbo().Respect);
@class.SendMessage(Message, null);
Session.GetHabbo().CheckRespectGivedAchievements();
class2.GetClient().GetHabbo().CheckRespectReceivedAchievements();
if (Session.GetHabbo().CurrentQuestId > 0 && GoldTree.GetGame().GetQuestManager().GetQuestAction(Session.GetHabbo().CurrentQuestId) == "GIVE_RESPECT")
{
GoldTree.GetGame().GetQuestManager().ProgressUserQuest(Session.GetHabbo().CurrentQuestId, Session);
}
}
}
}
public void Handle(GameClient Session, ClientMessage Event)
{
DataTable dataTable = null;
using (DatabaseClient @class = GoldTree.GetDatabase().GetClient())
{
dataTable = @class.ReadDataTable("SELECT asking_price FROM catalog_marketplace_offers WHERE user_id = '" + Session.GetHabbo().Id + "' AND state = '2'");
}
if (dataTable != null)
{
int num = 0;
foreach (DataRow dataRow in dataTable.Rows)
{
num += (int)dataRow["asking_price"];
}
if (num >= 1)
{
Session.GetHabbo().Credits += num;
Session.GetHabbo().UpdateCredits(true);
}
using (DatabaseClient @class = GoldTree.GetDatabase().GetClient())
{
@class.ExecuteQuery("DELETE FROM catalog_marketplace_offers WHERE user_id = '" + Session.GetHabbo().Id + "' AND state = '2'");
}
}
}
internal bool method_9(uint uint_1, uint uint_2)
{
bool result;
using (DatabaseClient @class = GoldTree.GetDatabase().GetClient())
{
if (@class.ReadDataRow(string.Concat(new object[]
{
"SELECT user_one_id FROM messenger_friendships WHERE user_one_id = '",
uint_1,
"' AND user_two_id = '",
uint_2,
"' LIMIT 1"
})) != null)
{
result = true;
return(result);
}
if (@class.ReadDataRow(string.Concat(new object[]
{
"SELECT user_one_id FROM messenger_friendships WHERE user_one_id = '",
uint_2,
"' AND user_two_id = '",
uint_1,
"' LIMIT 1"
})) != null)
{
result = true;
return(result);
}
}
result = false;
return(result);
}
internal void SavePets()
{
using (DatabaseClient dbClient = GoldTree.GetDatabase().GetClient())
{
this.SavePets(dbClient, false);
}
}
public void method_8(uint uint_0, GameClient Session)
{
Session.GetHabbo().CurrentQuestId = 0u;
Session.GetHabbo().uint_7 = uint_0;
using (DatabaseClient @class = GoldTree.GetDatabase().GetClient())
{
@class.AddParamWithValue("userid", Session.GetHabbo().Id);
@class.AddParamWithValue("questid", uint_0);
@class.ExecuteQuery(string.Concat(new string[]
{
"UPDATE user_stats SET quest_id = '0',quest_progress = '0', lev_",
this.method_6(uint_0).Type.Replace("room_", ""),
" = lev_",
this.method_6(uint_0).Type.Replace("room_", ""),
" + 1 WHERE Id = @userid LIMIT 1"
}));
@class.ExecuteQuery("INSERT INTO user_quests (user_id,quest_id) VALUES (@userid,@questid)");
}
string text = this.method_6(uint_0).Type.ToLower();
if (text != null)
{
if (!(text == "identity"))
{
if (!(text == "room_builder"))
{
if (!(text == "social"))
{
if (text == "explore")
{
Session.GetHabbo().int_9++;
}
}
else
{
Session.GetHabbo().int_7++;
}
}
else
{
Session.GetHabbo().int_6++;
}
}
else
{
Session.GetHabbo().int_8++;
}
}
Session.GetHabbo().method_25();
ServerMessage Message = new ServerMessage(801u);
Quest class2 = this.method_6(uint_0);
class2.Serialize(Message, Session, true);
this.method_9(Session, Message);
Message.AppendInt32(1);
Session.SendMessage(Message);
Session.GetHabbo().ActivityPoints += class2.PixelReward;
Session.GetHabbo().method_15(true);
Session.GetHabbo().CurrentQuestProgress = 0;
}
public override void OnRemove(GameClient Session, RoomItem Item)
{
DataRow dataRow2;
using (DatabaseClient @class = GoldTree.GetDatabase().GetClient())
{
dataRow2 = @class.ReadDataRow("SELECT fw_count FROM items_firework WHERE id = '" + Item.uint_0 + "'");
if (dataRow2 != null)
{
Item.FireWorkCount = (int)dataRow2["fw_count"];
}
else
{
@class.ExecuteQuery("INSERT INTO items_firework(item_id, fw_count) VALUES ( '" + Item.uint_0 + "', '0')");
}
}
if (Item.FireWorkCount > 0)
{
Item.ExtraData = "1";
Item.UpdateState(true, true);
}
else if (Item.FireWorkCount <= 0)
{
Item.ExtraData = "0";
Item.UpdateState(true, true);
}
}
public void method_3(GameClient Session, int int_0, uint uint_0, string string_0)
{
if (Session.GetHabbo().CurrentRoomId > 0u)
{
RoomData @class = GoldTree.GetGame().GetRoomManager().method_11(Session.GetHabbo().CurrentRoomId);
uint uint_ = 0u;
using (DatabaseClient class2 = GoldTree.GetDatabase().GetClient())
{
class2.AddParamWithValue("message", string_0);
class2.AddParamWithValue("name", @class.Name);
class2.ExecuteQuery(string.Concat(new object[]
{
"INSERT INTO moderation_tickets (score,type,status,sender_id,reported_id,moderator_id,message,room_id,room_name,timestamp) VALUES (1,'",
int_0,
"','open','",
Session.GetHabbo().Id,
"','",
uint_0,
"','0',@message,'",
@class.Id,
"',@name,UNIX_TIMESTAMP())"
}));
class2.ExecuteQuery("UPDATE user_info SET cfhs = cfhs + 1 WHERE user_id = '" + Session.GetHabbo().Id + "' LIMIT 1");
uint_ = (uint)class2.ReadDataRow("SELECT Id FROM moderation_tickets WHERE sender_id = '" + Session.GetHabbo().Id + "' ORDER BY Id DESC LIMIT 1")[0];
}
SupportTicket class3 = new SupportTicket(uint_, 1, int_0, Session.GetHabbo().Id, uint_0, string_0, @class.Id, @class.Name, GoldTree.GetUnixTimestamp(), 0u);
this.Tickets.Add(class3);
this.method_11(class3);
}
}
public void AddBadge(string code, int slotId, bool addToDatabase)
{
if (this.HasBadge(code))
{
return;
}
if (addToDatabase)
{
using (DatabaseClient dbClient = GoldTree.GetDatabase().GetClient())
{
dbClient.AddParamWithValue("badge", code);
dbClient.ExecuteQuery(string.Concat(new object[]
{
"INSERT INTO user_badges (user_id,badge_id,badge_slot) VALUES ('",
this.UserId,
"',@badge,'",
slotId,
"')"
}));
}
}
this.Badges.Add(new Badge(code, slotId));
}
public ServerMessage method_14(RoomData class27_0)
{
Room @class = GoldTree.GetGame().GetRoomManager().GetRoom(class27_0.Id);
uint uint_ = 0u;
using (DatabaseClient class2 = GoldTree.GetDatabase().GetClient())
{
try
{
class2.AddParamWithValue("owner", class27_0.Owner);
uint_ = (uint)class2.ReadDataRow("SELECT Id FROM users WHERE username = @owner LIMIT 1")[0];
}
catch (Exception)
{
}
}
ServerMessage Message = new ServerMessage(538u);
Message.AppendUInt(class27_0.Id);
Message.AppendInt32(class27_0.UsersNow);
if (@class != null)
{
Message.AppendBoolean(@class.method_56(class27_0.Owner) != null);
}
else
{
Message.AppendBoolean(false);
}
Message.AppendUInt(uint_);
Message.AppendStringWithBreak(class27_0.Owner);
Message.AppendUInt(class27_0.Id);
Message.AppendStringWithBreak(class27_0.Name);
Message.AppendStringWithBreak(class27_0.Description);
Message.AppendInt32(class27_0.TagCount);
foreach (string current in class27_0.Tags)
{
Message.AppendStringWithBreak(current);
}
if (@class != null)
{
Message.AppendBoolean(@class.Boolean_0);
if (@class.Event == null)
{
return(Message);
}
Message.AppendStringWithBreak(@class.Event.Name);
Message.AppendStringWithBreak(@class.Event.Description);
Message.AppendInt32(@class.Event.Tags.Count);
using (TimedLock.Lock(@class.Event.Tags))
{
foreach (string current in @class.Event.Tags)
{
Message.AppendStringWithBreak(current);
}
return(Message);
}
}
Message.AppendBoolean(false);
return(Message);
}
public void Handle(GameClient Session, ClientMessage Event)
{
uint num = Event.PopWiredUInt();
Room room = GoldTree.GetGame().GetRoomManager().GetRoom(Session.GetHabbo().CurrentRoomId);
if (room != null)
{
RoomUser roomUserByHabbo = room.GetRoomUserByHabbo(num);
if (room != null && room.CheckRights(Session, true) && roomUserByHabbo != null && !roomUserByHabbo.IsBot && !room.UsersWithRights.Contains(num))
{
room.UsersWithRights.Add(num);
using (DatabaseClient client = GoldTree.GetDatabase().GetClient())
{
client.ExecuteQuery(string.Concat(new object[]
{
"INSERT INTO room_rights (room_id,user_id) VALUES (",
room.Id,
",",
num,
")"
}));
}
ServerMessage serverMessage = new ServerMessage(510u);
serverMessage.AppendUInt(room.Id);
serverMessage.AppendUInt(num);
serverMessage.AppendStringWithBreak(roomUserByHabbo.GetClient().GetHabbo().Username);
Session.SendMessage(serverMessage);
roomUserByHabbo.AddStatus("flatctrl", "");
roomUserByHabbo.UpdateNeeded = true;
roomUserByHabbo.GetClient().SendMessage(new ServerMessage(42u));
}
}
}
public void method_15(GameClient Session, uint uint_0, string string_0, bool bool_0)
{
GameClient @class = GoldTree.GetGame().GetClientManager().method_2(uint_0);
if (@class != null && @class.GetHabbo().CurrentRoomId >= 1u && @class.GetHabbo().Id != Session.GetHabbo().Id)
{
if (@class.GetHabbo().Rank >= Session.GetHabbo().Rank)
{
Session.SendNotif(GoldTreeEnvironment.smethod_1("mod_error_permission_kick"));
}
else
{
Room class2 = GoldTree.GetGame().GetRoomManager().GetRoom(@class.GetHabbo().CurrentRoomId);
if (class2 != null)
{
class2.method_47(@class, true, false);
if (!bool_0)
{
@class.SendNotif(string_0);
using (DatabaseClient class3 = GoldTree.GetDatabase().GetClient())
{
class3.ExecuteQuery("UPDATE user_info SET cautions = cautions + 1 WHERE user_id = '" + uint_0 + "' LIMIT 1");
}
}
}
}
}
}
public void Handle(GameClient Session, ClientMessage Event)
{
int PollId = Event.PopWiredInt32();
int QuestionId = Event.PopWiredInt32();
int AnswerCount = Event.PopWiredInt32();
string AnswerText = "";
if (AnswerCount > 1)
{
for (int i = 1; i <= AnswerCount; i++)
{
if (AnswerText == "")
{
AnswerText = Event.PopFixedString();
}
else
{
AnswerText = AnswerText + "," + Event.PopFixedString();
}
}
}
else
{
AnswerText = Event.PopFixedString();
}
using (DatabaseClient dbClient = GoldTree.GetDatabase().GetClient())
{
dbClient.ExecuteQuery("INSERT INTO `room_poll_results` (`poll_id`, `question_id`, `answer_text`, `user_id`) VALUES ('" + PollId + "', '" + QuestionId + "', '" + AnswerText + "', '" + Session.GetHabbo().Id + "')");
}
}
public void Handle(GameClient Session, ClientMessage Event)
{
uint num = Event.PopWiredUInt();
Room @class = GoldTree.GetGame().GetRoomManager().GetRoom(Session.GetHabbo().CurrentRoomId);
if (@class != null && [email protected]_3)
{
RoomUser class2 = @class.method_48(num);
if (class2 == null || class2.PetData == null)
{
DataRow dataRow = null;
using (DatabaseClient class3 = GoldTree.GetDatabase().GetClient())
{
class3.AddParamWithValue("petid", num);
dataRow = class3.ReadDataRow("SELECT Id, user_id, room_id, name, type, race, color, expirience, energy, nutrition, respect, createstamp, x, y, z FROM user_pets WHERE Id = @petid LIMIT 1");
}
if (dataRow != null)
{
Session.SendMessage(GoldTree.GetGame().GetCatalog().method_12(dataRow).SerializeInfo());
}
}
else
{
Session.SendMessage(class2.PetData.SerializeInfo());
}
}
}
public string GetNameById(uint uint_0)
{
GameClient @class = this.method_2(uint_0);
string result;
if (@class != null)
{
result = @class.GetHabbo().Username;
}
else
{
DataRow dataRow = null;
using (DatabaseClient class2 = GoldTree.GetDatabase().GetClient())
{
dataRow = class2.ReadDataRow("SELECT username FROM users WHERE Id = '" + uint_0 + "' LIMIT 1");
}
if (dataRow == null)
{
result = "Unknown User";
}
else
{
result = (string)dataRow[0];
}
}
return(result);
}
public void method_0()
{
Logging.Write("Loading Quests..");
this.Quests.Clear();
DataTable dataTable = null;
DataTable dataTable2 = null;
using (DatabaseClient @class = GoldTree.GetDatabase().GetClient())
{
dataTable = @class.ReadDataTable("SELECT Id,type,action,needofcount,level_num,pixel_reward FROM quests WHERE enabled = '1' ORDER by level_num");
dataTable2 = @class.ReadDataTable("SELECT COUNT(*) as count FROM quests GROUP BY type ORDER BY count DESC;");
}
if (dataTable != null)
{
foreach (DataRow dataRow in dataTable.Rows)
{
Quest class2 = new Quest((uint)dataRow["Id"], (string)dataRow["type"], (string)dataRow["action"], (int)dataRow["needofcount"], (int)dataRow["level_num"], (int)dataRow["pixel_reward"]);
if (class2 != null)
{
this.Quests.Add(class2);
}
}
//Logging.WriteLine("completed!", ConsoleColor.Green);
}
if (dataTable2 != null)
{
QuestsCount = dataTable2.Rows.Count;
Logging.WriteLine("completed!", ConsoleColor.Green);
}
}
public void Handle(GameClient Session, ClientMessage Event)
{
Room class14_ = Session.GetHabbo().CurrentRoom;
if (class14_ != null)
{
Event.PopWiredUInt();
string string_ = Event.PopFixedString();
RoomUser @class = class14_.method_56(string_);
if (@class != null && @class.GetClient().GetHabbo().Rank <= 2u)
{
uint uint_ = @class.GetClient().GetHabbo().Id;
if (!Session.GetHabbo().list_2.Contains(uint_))
{
Session.GetHabbo().list_2.Add(uint_);
using (DatabaseClient class2 = GoldTree.GetDatabase().GetClient())
{
class2.ExecuteQuery(string.Concat(new object[]
{
"INSERT INTO user_ignores(user_id, ignore_id) VALUES (",
Session.GetHabbo().Id,
", ",
uint_,
");"
}));
}
ServerMessage Message = new ServerMessage(419u);
Message.AppendInt32(1);
Session.SendMessage(Message);
}
}
}
}
public void ContinueLoading()
{
if (this.task_0 != null)
{
this.task_0 = null;
}
using (DatabaseClient @class = GoldTree.GetDatabase().GetClient())
{
this.method_0(@class, 0);
}
if (this.GetClientManager() != null)
{
this.GetClientManager().method_6();
this.GetClientManager().method_11();
}
if (this.GetPixelManager() != null)
{
this.PixelManager.KeepAlive = false;
}
this.ClientManager = null;
this.BanManager = null;
this.RoleManager = null;
this.HelpTool = null;
this.Catalog = null;
this.Navigator = null;
this.ItemManager = null;
this.RoomManager = null;
this.AdvertisementManager = null;
this.PixelManager = null;
}
