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; }