public void parse(GameClient Session, ClientMessage Event) { Room class14_ = Session.GetHabbo().CurrentRoom; if (class14_ != null) { Event.PopWiredUInt(); string string_ = Event.PopFixedString(); RoomUser @class = class14_.GetRoomUserByHabbo(string_); if (@class != null) { uint uint_ = @class.GetClient().GetHabbo().Id; if (Session.GetHabbo().MutedUsers.Contains(uint_)) { Session.GetHabbo().MutedUsers.Remove(uint_); using (DatabaseClient class2 = PhoenixEnvironment.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 parse(GameClient Session, ClientMessage Event) { if (Session.GetHabbo() == null) { Session.Login(Event.PopFixedString()); if (Session.GetHabbo() != null && Session.GetHabbo().MutedUsers != null && Session.GetHabbo().MutedUsers.Count > 0) { using (DatabaseClient adapter = PhoenixEnvironment.GetDatabase().GetClient()) { try { ServerMessage Message = new ServerMessage(420); Message.AppendInt32(Session.GetHabbo().MutedUsers.Count); foreach (uint Id in Session.GetHabbo().MutedUsers) { string string_ = adapter.ReadString("SELECT username FROM users WHERE Id = " + Id + " 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 RoomData CreateRoom(GameClient Session, string Name, string Model) { Name = PhoenixEnvironment.FilterInjectionChars(Name); if (!this.Models.ContainsKey(Model)) { Session.SendNotif("Sorry, this room model has not been added yet. Try again later."); return(null); } else if (Models[Model].ClubOnly && !Session.GetHabbo().GetSubscriptionManager().HasSubscription("habbo_club") && !Session.GetHabbo().GetSubscriptionManager().HasSubscription("habbo_vip")) { Session.SendNotif("You must be an Phoenix Club member to use that room layout."); return(null); } else if (Name.Length < 3) { Session.SendNotif("Room name is too short for room creation!"); return(null); } else { uint RoomId = 0; using (DatabaseClient adapter = PhoenixEnvironment.GetDatabase().GetClient()) { adapter.AddParamWithValue("caption", Name); adapter.AddParamWithValue("model", Model); adapter.AddParamWithValue("username", Session.GetHabbo().Username); adapter.ExecuteQuery("INSERT INTO rooms (roomtype,caption,owner,model_name) VALUES ('private',@caption,@username,@model)"); Session.GetHabbo().GetHabboData.GetUsersRooms = adapter.ReadDataTable("SELECT * FROM rooms WHERE owner = @username ORDER BY Id ASC"); RoomId = (uint)adapter.ReadDataRow("SELECT Id FROM rooms WHERE owner = @username AND caption = @caption ORDER BY Id DESC")[0]; Session.GetHabbo().UpdateRooms(adapter); } return(this.GenerateRoomData(RoomId)); } }
internal bool method_9(uint uint_1, uint uint_2) { using (DatabaseClient @class = PhoenixEnvironment.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) { return(true); } 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) { return(true); } } return(false); }
internal void OnEnterRoom(uint RoomId) { if (GlobalClass.RecordRoomVisits) { using (DatabaseClient adapter = PhoenixEnvironment.GetDatabase().GetClient()) { adapter.ExecuteQuery(string.Concat(new object[] { "INSERT INTO user_roomvisits (user_id,room_id,entry_timestamp,exit_timestamp,hour,minute) VALUES ('", Id, "','", RoomId, "',UNIX_TIMESTAMP(),'0','", DateTime.Now.Hour, "','", DateTime.Now.Minute, "')" })); } } this.CurrentRoomId = RoomId; if (CurrentRoom.Owner != Username && CurrentQuestId == 15) { PhoenixEnvironment.GetGame().GetQuestManager().ProgressUserQuest(15, GetClient()); } this.Messenger.OnStatusChanged(false); }
public void OnLeaveRoom() { try { if (GlobalClass.RecordRoomVisits) { using (DatabaseClient adapter = PhoenixEnvironment.GetDatabase().GetClient()) { adapter.ExecuteQuery(string.Concat(new object[] { "UPDATE user_roomvisits SET exit_timestamp = UNIX_TIMESTAMP() WHERE room_id = '", CurrentRoomId, "' AND user_id = '", Id, "' ORDER BY entry_timestamp DESC LIMIT 1" })); } } } catch { } this.CurrentRoomId = 0; if (Messenger != null) { Messenger.OnStatusChanged(false); } }
public void Close(TicketStatus NewStatus, bool UpdateInDb) { String dbType = null; Status = NewStatus; if (UpdateInDb) { switch (NewStatus) { case TicketStatus.RESOLVED: dbType = "resolved"; break; case TicketStatus.ABUSIVE: dbType = "abusive"; break; case TicketStatus.INVALID: dbType = "invalid"; break; } using (DatabaseClient adapter = PhoenixEnvironment.GetDatabase().GetClient()) { adapter.ExecuteQuery("UPDATE moderation_tickets SET status = '" + dbType + "' WHERE Id = '" + Id + "' LIMIT 1"); } } }
internal void RunDBUpdate() { using (DatabaseClient adapter = PhoenixEnvironment.GetDatabase().GetClient()) { this.RunDBUpdate(adapter, false); } }
public void parse(GameClient Session, ClientMessage Event) { DataTable dataTable = null; using (DatabaseClient adapter = PhoenixEnvironment.GetDatabase().GetClient()) { dataTable = adapter.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().UpdateCreditsBalance(true); } using (DatabaseClient adapter = PhoenixEnvironment.GetDatabase().GetClient()) { adapter.ExecuteQuery("DELETE FROM catalog_marketplace_offers WHERE user_id = '" + Session.GetHabbo().Id + "' AND state = '2'"); } } }
public void Destroy() { if (Task != null) { Task = null; } using (DatabaseClient adapter = PhoenixEnvironment.GetDatabase().GetClient()) { DatabaseCleanup(adapter, 0); } if (GetClientManager() != null) { GetClientManager().Clear(); GetClientManager().StopConnectionChecker(); } if (GetPixelManager() != null) { PixelManager.KeepAlive = false; } ClientManager = null; BanManager = null; RoleManager = null; HelpTool = null; Catalog = null; Navigator = null; ItemManager = null; RoomManager = null; AdvertisementManager = null; PixelManager = null; }
public ServerMessage SerializeRecentRooms(GameClient Session) { using (DatabaseClient @class = PhoenixEnvironment.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 = PhoenixEnvironment.GetGame().GetRoomManager().FetchRoomData((uint)dataRow["Id"], dataRow); class2.method_1(dataRow); list.Add(class2); list2.Add(class2.Id); } } ServerMessage Message = new ServerMessage(451); Message.AppendInt32(0); Message.AppendInt32(7); Message.AppendStringWithBreak(""); Message.AppendInt32(list.Count); foreach (RoomData current in list) { current.Serialize(Message, false, false); } return(Message); } }
public void parse(GameClient Session, ClientMessage Event) { uint num = Event.PopWiredUInt(); Room @class = PhoenixEnvironment.GetGame().GetRoomManager().GetRoom(Session.GetHabbo().CurrentRoomId); if (@class != null && [email protected]) { RoomUser class2 = @class.method_48(num); if (class2 == null || class2.PetData == null) { DataRow dataRow = null; using (DatabaseClient class3 = PhoenixEnvironment.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(PhoenixEnvironment.GetGame().GetCatalog().GeneratePetFromRow(dataRow).SerializeInfo()); } } else { Session.SendMessage(class2.PetData.SerializeInfo()); } } }
public string GetNameById(uint Id) { GameClient clientByHabbo = this.GetClientByHabbo(Id); if (clientByHabbo != null) { return(clientByHabbo.GetHabbo().Username); } else { DataRow Row = null; using (DatabaseClient adapter = PhoenixEnvironment.GetDatabase().GetClient()) { Row = adapter.ReadDataRow("SELECT username FROM users WHERE Id = '" + Id + "' LIMIT 1"); } if (Row == null) { return("Unknown User"); } else { return((string)Row[0]); } } }
public void AddOrExtendSubscription(string SubscriptionId, int DurationSeconds) { SubscriptionId = SubscriptionId.ToLower(); if (Subscriptions.ContainsKey(SubscriptionId)) { Subscription Sub = Subscriptions[SubscriptionId]; Sub.ExtendSubscription(DurationSeconds); if (Sub.ExpireTime <= 0 || Sub.ExpireTime >= 2147483647) { return; } using (DatabaseClient adapter = PhoenixEnvironment.GetDatabase().GetClient()) { adapter.AddParamWithValue("subcrbr", SubscriptionId); adapter.ExecuteQuery("UPDATE user_subscriptions SET timestamp_expire = '" + Sub.ExpireTime + "' WHERE user_id = '" + UserId + "' AND subscription_id = @subcrbr LIMIT 1"); return; } } if (!Subscriptions.ContainsKey("habbo_vip")) { int TimeCreated = (int)PhoenixEnvironment.GetUnixTimestamp(); int TimeExpire = (int)PhoenixEnvironment.GetUnixTimestamp() + DurationSeconds; Subscription NewSub = new Subscription(SubscriptionId, TimeCreated, TimeExpire); using (DatabaseClient adapter = PhoenixEnvironment.GetDatabase().GetClient()) { adapter.AddParamWithValue("subcrbr", SubscriptionId); adapter.ExecuteQuery("INSERT INTO user_subscriptions (user_id,subscription_id,timestamp_activated,timestamp_expire) VALUES ('" + UserId + "',@subcrbr,'" + TimeCreated + "','" + TimeExpire + "')"); } Subscriptions.Add(NewSub.SubscriptionId.ToLower(), NewSub); } }
public void parse(GameClient session, ClientMessage message) { int id = message.PopWiredInt32(); int userid = message.PopWiredInt32(); if (id <= 0 || userid <= 0) { return; } using (DatabaseClient dbclient = PhoenixEnvironment.GetDatabase().GetClient()) { DataRow datarow = dbclient.ReadDataRow("SELECT id FROM friend_stream_likes WHERE friend_stream_id = '" + id + "' AND userid = '" + userid + "' LIMIT 1"); if (datarow == null) { dbclient.AddParamWithValue("fsi", id); dbclient.AddParamWithValue("userid", userid); dbclient.ExecuteQuery("INSERT INTO friend_stream_likes (friend_stream_id, userid) VALUES (@fsi, @userid)"); } else { session.SendNotif("You cant like twice!"); } } }
public ServerMessage SerializeRoomTool(RoomData Data) { Room Room = PhoenixEnvironment.GetGame().GetRoomManager().GetRoom(Data.Id); uint OwnerId = 0; using (DatabaseClient adapter = PhoenixEnvironment.GetDatabase().GetClient()) { try { adapter.AddParamWithValue("owner", Data.Owner); OwnerId = (uint)adapter.ReadDataRow("SELECT Id FROM users WHERE username = @owner LIMIT 1")[0]; } catch (Exception) { } } ServerMessage Message = new ServerMessage(538); Message.AppendUInt(Data.Id); Message.AppendInt32(Data.UsersNow); if (Room != null) { Message.AppendBoolean(Room.GetRoomUserByHabbo(Data.Owner) != null); } else { Message.AppendBoolean(false); } Message.AppendUInt(OwnerId); Message.AppendStringWithBreak(Data.Owner); Message.AppendUInt(Data.Id); Message.AppendStringWithBreak(Data.Name); Message.AppendStringWithBreak(Data.Description); Message.AppendInt32(Data.TagCount); foreach (string current in Data.Tags) { Message.AppendStringWithBreak(current); } if (Room != null) { Message.AppendBoolean(Room.HasOngoingEvent); if (Room.Event == null) { return(Message); } Message.AppendStringWithBreak(Room.Event.Name); Message.AppendStringWithBreak(Room.Event.Description); Message.AppendInt32(Room.Event.Tags.Count); using (TimedLock.Lock(Room.Event.Tags)) { foreach (string current in Room.Event.Tags) { Message.AppendStringWithBreak(current); } return(Message); } } Message.AppendBoolean(false); return(Message); }
public void KickUser(GameClient ModSession, uint UserId, string Message, bool Soft) { GameClient Client = PhoenixEnvironment.GetGame().GetClientManager().GetClientByHabbo(UserId); if (Client == null || Client.GetHabbo().CurrentRoomId < 1 || Client.GetHabbo().Id == ModSession.GetHabbo().Id) { return; } if (Client.GetHabbo().Rank >= ModSession.GetHabbo().Rank) { ModSession.SendNotif(TextManager.GetText("mod_error_permission_kick")); } Room Room = PhoenixEnvironment.GetGame().GetRoomManager().GetRoom(Client.GetHabbo().CurrentRoomId); if (Room != null) { Room.RemoveUserFromRoom(Client, true, false); if (!Soft) { Client.SendNotif(Message); using (DatabaseClient adapter = PhoenixEnvironment.GetDatabase().GetClient()) { adapter.ExecuteQuery("UPDATE user_info SET cautions = cautions + 1 WHERE user_id = '" + UserId + "' LIMIT 1"); } } } }
public void parse(GameClient Session, ClientMessage Event) { Room @class = PhoenixEnvironment.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.RoomId); Message.AppendUInt(current); Session.SendMessage(Message); } using (DatabaseClient class3 = PhoenixEnvironment.GetDatabase().GetClient()) { class3.ExecuteQuery("DELETE FROM room_rights WHERE room_id = '" + @class.RoomId + "'"); } @class.UsersWithRights.Clear(); } }
public void EnableEffect(int EffectId) { AvatarEffect Effect = this.GetEffect(EffectId, false); if (Effect != null && !Effect.HasExpired && !Effect.Activated && (this.GetClient() != null && this.GetClient().GetHabbo() != null)) { Room class2 = this.GetUserRoom(); if (class2 != null) { RoomUser User = class2.GetRoomUserByHabbo(this.GetClient().GetHabbo().Id); if (User.byte_1 <= 0 && User.Riding == null) { using (DatabaseClient adapter = PhoenixEnvironment.GetDatabase().GetClient()) { adapter.ExecuteQuery("UPDATE user_effects SET is_activated = '1', activated_stamp = '" + PhoenixEnvironment.GetUnixTimestamp() + "' WHERE user_id = '" + UserId + "' AND effect_id = '" + EffectId + "' LIMIT 1"); } Effect.Activate(); ServerMessage Message = new ServerMessage(462); Message.AppendInt32(Effect.EffectId); Message.AppendInt32(Effect.TotalDuration); this.GetClient().SendMessage(Message); } } } }
public uint GetIdByName(string Name) { GameClient clientByHabbo = this.GetClientByHabbo(Name); if (clientByHabbo != null) { return(clientByHabbo.GetHabbo().Id); } else { DataRow dataRow = null; using (DatabaseClient adapter = PhoenixEnvironment.GetDatabase().GetClient()) { dataRow = adapter.ReadDataRow("SELECT Id FROM users WHERE username = '******' LIMIT 1"); } if (dataRow == null) { return(0); } else { return((uint)dataRow[0]); } } }
public void parse(GameClient Session, ClientMessage Event) { Room class14_ = Session.GetHabbo().CurrentRoom; if (class14_ != null) { Event.PopWiredUInt(); string string_ = Event.PopFixedString(); RoomUser @class = class14_.GetRoomUserByHabbo(string_); if (@class != null && @class.GetClient().GetHabbo().Rank <= 2u) { uint uint_ = @class.GetClient().GetHabbo().Id; if (!Session.GetHabbo().MutedUsers.Contains(uint_)) { Session.GetHabbo().MutedUsers.Add(uint_); using (DatabaseClient class2 = PhoenixEnvironment.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); } } } }
private DataTable mFriendStream; //FriendStream fix public HabboData(string Username, bool LoadFull) { using (DatabaseClient adapter = PhoenixEnvironment.GetDatabase().GetClient()) { adapter.AddParamWithValue("username", Username); this.mUserInformation = adapter.ReadDataRow("SELECT * FROM users WHERE username = @username LIMIT 1;"); if (this.mUserInformation != null) { this.mUserFound = true; uint num = (uint)this.mUserInformation["Id"]; if (LoadFull) { this.mAchievementData = adapter.ReadDataTable("SELECT achievement_id,achievement_level FROM user_achievements WHERE user_id = '" + num + "'"); this.mUserFavouriteRooms = adapter.ReadDataTable("SELECT room_id FROM user_favorites WHERE user_id = '" + num + "'"); this.mUserIgnores = adapter.ReadDataTable("SELECT ignore_id FROM user_ignores WHERE user_id = '" + num + "'"); this.mUsertags = adapter.ReadDataTable("SELECT tag FROM user_tags WHERE user_id = '" + num + "'"); this.mSubscriptionData = adapter.ReadDataTable("SELECT subscription_id, timestamp_activated, timestamp_expire FROM user_subscriptions WHERE user_id = '" + num + "'"); this.mUserBadges = adapter.ReadDataTable("SELECT user_badges.badge_id,user_badges.badge_slot FROM user_badges WHERE user_id = " + num + " ORDER BY badge_slot ASC"); this.mUserInventory = adapter.ReadDataTable("SELECT Id,base_item,extra_data FROM items WHERE room_id = 0 AND user_id = " + num); this.mUserEffects = adapter.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.mUserFriends = adapter.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.mUserRequests = adapter.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 + "'"); adapter.AddParamWithValue("name", (string)this.mUserInformation["username"]); this.mUsersRooms = adapter.ReadDataTable("SELECT * FROM rooms WHERE owner = @name ORDER BY Id ASC LIMIT " + GlobalClass.MaxRoomsPerUser); this.mFriendStream = adapter.ReadDataTable("SELECT friend_stream.id, friend_stream.type, friend_stream.userid, friend_stream.gender, friend_stream.look, friend_stream.time, friend_stream.data, friend_stream.data_extra FROM friend_stream JOIN messenger_friendships ON friend_stream.userid = messenger_friendships.user_two_id WHERE messenger_friendships.user_one_id = '" + num + "' ORDER BY friend_stream.time DESC LIMIT 15"); //FriendStream fix } } else { this.mUserFound = false; } } }
public void parse(GameClient Session, ClientMessage Event) { uint num = Event.PopWiredUInt(); Room room = PhoenixEnvironment.GetGame().GetRoomManager().GetRoom(Session.GetHabbo().CurrentRoomId); 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 adapter = PhoenixEnvironment.GetDatabase().GetClient()) { adapter.ExecuteQuery(string.Concat(new object[] { "INSERT INTO room_rights (room_id,user_id) VALUES ('", room.RoomId, "','", num, "')" })); } ServerMessage Message = new ServerMessage(510); Message.AppendUInt(room.RoomId); Message.AppendUInt(num); Message.AppendStringWithBreak(roomUserByHabbo.GetClient().GetHabbo().Username); Session.SendMessage(Message); roomUserByHabbo.AddStatus("flatctrl", ""); roomUserByHabbo.UpdateNeeded = true; roomUserByHabbo.GetClient().SendMessage(new ServerMessage(42)); } }
public HabboData(string pSSOTicket, string pIPAddress, bool LoadFull) { using (DatabaseClient adapter = PhoenixEnvironment.GetDatabase().GetClient()) { adapter.AddParamWithValue("auth_ticket", pSSOTicket); string str = ""; if (GlobalClass.SecureSessions) { str = "AND ip_last = '" + pIPAddress + "' "; } try { if (int.Parse(PhoenixEnvironment.GetConfig().data["debug"]) == 1) { str = ""; } } catch { } this.mUserInformation = adapter.ReadDataRow("SELECT * FROM users WHERE auth_ticket = @auth_ticket " + str + " LIMIT 1;"); if (this.mUserInformation != null) { this.mUserFound = true; uint Id = (uint)this.mUserInformation["Id"]; if (LoadFull) { this.mAchievementData = adapter.ReadDataTable("SELECT achievement_id,achievement_level FROM user_achievements WHERE user_id = '" + Id + "'"); this.mUserFavouriteRooms = adapter.ReadDataTable("SELECT room_id FROM user_favorites WHERE user_id = '" + Id + "'"); this.mUserIgnores = adapter.ReadDataTable("SELECT ignore_id FROM user_ignores WHERE user_id = '" + Id + "'"); this.mUsertags = adapter.ReadDataTable("SELECT tag FROM user_tags WHERE user_id = '" + Id + "'"); this.mSubscriptionData = adapter.ReadDataTable("SELECT subscription_id, timestamp_activated, timestamp_expire FROM user_subscriptions WHERE user_id = '" + Id + "'"); this.mUserBadges = adapter.ReadDataTable("SELECT user_badges.badge_id,user_badges.badge_slot FROM user_badges WHERE user_id = " + Id + " ORDER BY badge_slot ASC"); this.mUserInventory = adapter.ReadDataTable("SELECT Id,base_item,extra_data FROM items WHERE room_id = 0 AND user_id = " + Id); this.mUserEffects = adapter.ReadDataTable("SELECT user_effects.effect_id,user_effects.total_duration,user_effects.is_activated,user_effects.activated_stamp FROM user_effects WHERE user_id = " + Id); this.mUserFriends = adapter.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 = '" + Id + "'"); this.mUserRequests = adapter.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 = '" + Id + "'"); adapter.AddParamWithValue("name", this.mUserInformation["username"]); this.mUsersRooms = adapter.ReadDataTable("SELECT * FROM rooms WHERE owner = @name ORDER BY Id ASC LIMIT " + GlobalClass.MaxRoomsPerUser); this.mUserPets = adapter.ReadDataTable("SELECT Id, user_id, room_id, name, type, race, color, expirience, energy, nutrition, respect, createstamp, x, y, z FROM user_pets WHERE user_id = " + Id + " AND room_id = 0"); this.mFriendStream = adapter.ReadDataTable("SELECT friend_stream.id, friend_stream.type, friend_stream.userid, friend_stream.gender, friend_stream.look, friend_stream.time, friend_stream.data, friend_stream.data_extra FROM friend_stream JOIN messenger_friendships ON friend_stream.userid = messenger_friendships.user_two_id WHERE messenger_friendships.user_one_id = '" + Id + "' ORDER BY friend_stream.time DESC LIMIT 15"); //FriendStream fix adapter.ExecuteQuery(string.Concat(new object[] { "UPDATE users SET online = '1'" + /*auth_ticket = ''*/ "WHERE Id = '", Id, "' LIMIT 1; UPDATE user_info SET login_timestamp = '", PhoenixEnvironment.GetUnixTimestamp(), "' WHERE user_id = '", Id, "' LIMIT 1;" })); } } else { this.mUserFound = false; } } }
public void OnView() { this.Views++; using (DatabaseClient client = PhoenixEnvironment.GetDatabase().GetClient()) { client.ExecuteQuery("UPDATE room_ads SET views = views + 1 WHERE Id = '" + this.Id + "' LIMIT 1"); } }
public void UpdateFriendStream() { using (DatabaseClient dbClient = PhoenixEnvironment.GetDatabase().GetClient()) { uint id = (uint)this.mUserInformation["Id"]; this.mFriendStream = dbClient.ReadDataTable("SELECT friend_stream.id, friend_stream.type, friend_stream.userid, friend_stream.gender, friend_stream.look, friend_stream.time, friend_stream.data, friend_stream.data_extra FROM friend_stream JOIN messenger_friendships ON friend_stream.userid = messenger_friendships.user_two_id WHERE messenger_friendships.user_one_id = '" + id + "' ORDER BY friend_stream.id DESC LIMIT 15"); } }
public void method_1() { this.Enabled = false; using (DatabaseClient @class = PhoenixEnvironment.GetDatabase().GetClient()) { @class.ExecuteQuery("UPDATE room_items_moodlight SET enabled = '0' WHERE item_id = '" + this.ItemId + "' LIMIT 1"); } }
public void DeleteVoucher(string Code) { using (DatabaseClient dbClient = PhoenixEnvironment.GetDatabase().GetClient()) { dbClient.AddParamWithValue("code", Code); dbClient.ExecuteQuery("DELETE FROM vouchers WHERE code = @code LIMIT 1"); } }
public void parse(GameClient Session, ClientMessage Event) { Room Room = PhoenixEnvironment.GetGame().GetRoomManager().GetRoom(Session.GetHabbo().CurrentRoomId); if (Room != null && Room.CheckRights(Session, true)) { Event.PopWiredInt32(); Dictionary <int, int> Items = new Dictionary <int, int>(); int BackgroundImage = Event.PopWiredInt32(); int ForegroundImage = Event.PopWiredInt32(); int num3 = Event.PopWiredInt32(); for (int i = 0; i < num3; i++) { int num4 = Event.PopWiredInt32(); int num5 = Event.PopWiredInt32(); if (num4 < 0 || num4 > 10 || (num5 < 1 || num5 > 27) || Items.ContainsKey(num4)) { return; } Items.Add(num4, num5); } if (BackgroundImage >= 1 && BackgroundImage <= 24 && (ForegroundImage >= 0 && ForegroundImage <= 11)) { StringBuilder stringBuilder = new StringBuilder(); int num6 = 0; foreach (KeyValuePair <int, int> Item in Items) { if (num6 > 0) { stringBuilder.Append("|"); } stringBuilder.Append(Item.Key + "," + Item.Value); num6++; } using (DatabaseClient adapter = PhoenixEnvironment.GetDatabase().GetClient()) { adapter.ExecuteQuery("UPDATE rooms SET icon_bg = '" + BackgroundImage + "', icon_fg = '" + ForegroundImage + "', icon_items = '" + stringBuilder.ToString() + "' WHERE Id = '" + Room.RoomId + "' LIMIT 1"); } Room.myIcon = new RoomIcon(BackgroundImage, ForegroundImage, Items); ServerMessage Message = new ServerMessage(457); Message.AppendUInt(Room.RoomId); Message.AppendBoolean(true); Session.SendMessage(Message); ServerMessage Message2 = new ServerMessage(456); Message2.AppendUInt(Room.RoomId); Session.SendMessage(Message2); RoomData Data = Room.RoomData; ServerMessage Message3 = new ServerMessage(454); Message3.AppendBoolean(false); Data.Serialize(Message3, false, false); Session.SendMessage(Message3); } } }
internal void RemoveAllRooms() { using (ClonedTable class26_ = this.Rooms.GetThreadSafeTable) { IEnumerator enumerator; using (DatabaseClient @class = PhoenixEnvironment.GetDatabase().GetClient()) { enumerator = class26_.Values.GetEnumerator(); try { while (enumerator.MoveNext()) { Room class2 = (Room)enumerator.Current; class2.method_65(@class); } } finally { IDisposable disposable = enumerator as IDisposable; if (disposable != null) { disposable.Dispose(); } } } if (PhoenixEnvironment.GetConfig().data["emu.messages.roommgr"] == "1") { Console.WriteLine("[RoomMgr] Done with furniture saving, disposing rooms"); } enumerator = class26_.Values.GetEnumerator(); try { while (enumerator.MoveNext()) { Room class2 = (Room)enumerator.Current; try { class2.method_62(); } catch { } } } finally { IDisposable disposable = enumerator as IDisposable; if (disposable != null) { disposable.Dispose(); } } if (PhoenixEnvironment.GetConfig().data["emu.messages.roommgr"] == "1") { Console.WriteLine("[RoomMgr] Done disposing rooms!"); } } }