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!");
}
}
}
