public void DatabaseCleanup(DatabaseClient adapter, int serverStatus)
{
Logging.Write(TextManager.GetText("emu_cleandb"));
bool debug = true;
try
{
if (int.Parse(PhoenixEnvironment.GetConfig().data["debug"]) == 1)
{
debug = false;
}
}
catch
{
}
if (debug)
{
adapter.ExecuteQuery("UPDATE users SET online = '0' WHERE online != '0'");
adapter.ExecuteQuery("UPDATE rooms SET users_now = '0' WHERE users_now != '0'");
adapter.ExecuteQuery("UPDATE user_roomvisits SET exit_timestamp = UNIX_TIMESTAMP() WHERE exit_timestamp <= 0");
adapter.ExecuteQuery(string.Concat(new object[] { "UPDATE server_status SET status = '", serverStatus, "', users_online = '0', rooms_loaded = '0', server_ver = '", PhoenixEnvironment.PrettyVersion, "', stamp = UNIX_TIMESTAMP() LIMIT 1;" }));
}
Logging.WriteLine("completed!");
}
public List <HauspaketAttributZuord> GetAllHauspaketAttributZuordInsert()
{
ClientDB2 = DatabaseClientFactory.GetClient(DatabaseType.DB2);
DataTable hauspaketAttributZuordTable = ClientDB2.ExecuteQuery(new HauspaketAttributZuord().GetSelectAllString(), null);
var resultSet = from hauspaketAttributZuord in hauspaketAttributZuordTable.AsEnumerable()
select new HauspaketAttributZuord()
{
SyncOperation = "INSERT",
HauspaketId = HandleInt(hauspaketAttributZuord[0].ToString()),
WertId = HandleInt(hauspaketAttributZuord[1].ToString())
};
return(resultSet.ToList <HauspaketAttributZuord>());
}
public List <Hersteller> GetAllHerstellerInsert()
{
ClientDB2 = DatabaseClientFactory.GetClient(DatabaseType.DB2);
DataTable herstellerTable = ClientDB2.ExecuteQuery(new Hersteller().GetSelectAllString(), null);
var resultSet = from hersteller in herstellerTable.AsEnumerable()
select new Hersteller()
{
SyncOperation = "INSERT",
HerstellerId = HandleInt(hersteller[0].ToString()),
Name = hersteller[0].ToString()
};
return(resultSet.ToList <Hersteller>());
}
public void UpdateCredits(bool save)
{
this.GetSession().SendMessage(BasicUtilies.GetRevisionPacketManager(this.GetSession().Revision).GetOutgoing(OutgoingPacketsEnum.UpdateCredits).Handle(new ValueHolder().AddValue("Credits", this.Credits)));
if (save)
{
using (DatabaseClient dbClient = Skylight.GetDatabaseManager().GetClient())
{
dbClient.AddParamWithValue("credits", this.Credits);
dbClient.AddParamWithValue("userId", this.ID);
dbClient.ExecuteQuery("UPDATE users SET credits = @credits WHERE id = @userId LIMIT 1");
}
}
}
public void Handle(GameClient Session, ClientMessage Event)
{
Room @class = GoldTree.GetGame().GetRoomManager().GetRoom(Session.GetHabbo().CurrentRoomId);
if (@class != null && !Session.GetHabbo().list_4.Contains(@class.Id) && [email protected](Session, true))
{
switch (Event.PopWiredInt32())
{
case -1:
@class.Score--;
break;
case 0:
return;
case 1:
@class.Score++;
if (Session.GetHabbo().FriendStreamEnabled)
{
using (DatabaseClient class2 = GoldTree.GetDatabase().GetClient())
{
string look = GoldTree.FilterString(Session.GetHabbo().Figure);
class2.AddParamWithValue("look", look);
class2.ExecuteQuery("INSERT INTO `friend_stream` (`id`, `type`, `userid`, `gender`, `look`, `time`, `data`) VALUES (NULL, '1', '" + Session.GetHabbo().Id + "', '" + Session.GetHabbo().Gender + "', @look, UNIX_TIMESTAMP(), '" + Session.GetHabbo().CurrentRoomId + "');");
}
}
break;
default:
return;
}
using (DatabaseClient class2 = GoldTree.GetDatabase().GetClient())
{
class2.ExecuteQuery(string.Concat(new object[]
{
"UPDATE rooms SET score = '",
@class.Score,
"' WHERE Id = '",
@class.Id,
"' LIMIT 1"
}));
}
Session.GetHabbo().list_4.Add(@class.Id);
ServerMessage Message = new ServerMessage(345u);
Message.AppendInt32(@class.Score);
Session.SendMessage(Message);
}
}
public void method_11(uint uint_1, uint uint_2, string string_0, bool bool_0)
{
UserItem item = new UserItem(uint_1, uint_2, string_0);
this.list_0.Add(item);
if (this.list_1.Contains(uint_1))
{
this.list_1.Remove(uint_1);
}
if (!this.hashtable_1.ContainsKey(uint_1))
{
if (bool_0)
{
using (DatabaseClient @class = GoldTree.GetDatabase().GetClient())
{
@class.AddParamWithValue("extra_data", string_0);
@class.ExecuteQuery(string.Concat(new object[]
{
"INSERT INTO items (Id,user_id,base_item,extra_data,wall_pos) VALUES ('",
uint_1,
"','",
this.uint_0,
"','",
uint_2,
"',@extra_data, '')"
}));
return;
}
}
if (item.method_1().InteractionType == "musicdisc")
{
this.discs.Add(item.uint_0, item);
}
using (DatabaseClient @class = GoldTree.GetDatabase().GetClient())
{
@class.ExecuteQuery(string.Concat(new object[]
{
"UPDATE items SET room_id = 0, user_id = '",
this.uint_0,
"' WHERE Id = '",
uint_1,
"'"
}));
}
}
}
public void GiveBadge(string Badge, int Slot, bool InDatabase)
{
if (HasBadge(Badge))
{
return;
}
if (InDatabase)
{
using (DatabaseClient adapter = PhoenixEnvironment.GetDatabase().GetClient())
{
adapter.AddParamWithValue("badge", Badge);
adapter.ExecuteQuery("INSERT INTO user_badges (user_id,badge_id,badge_slot) VALUES ('" + UserId + "',@badge,'" + Slot + "')");
}
}
Badges.Add(new Badge(Badge, Slot));
}
public void ClearItems()
{
using (DatabaseClient adapter = PhoenixEnvironment.GetDatabase().GetClient())
{
adapter.AddParamWithValue("userid", UserId);
adapter.ExecuteQuery("DELETE FROM items WHERE room_id = 0 AND user_id = @userid;");
}
this.discs.Clear();
this.mAddedItems.Clear();
this.mRemovedItems.Clear();
this.InventoryItems.Clear();
ServerMessage Message = new ServerMessage(101);
this.GetClient().SendMessage(Message);
}
private static void TestDB2()
{
Logger.Info("Start TestDB2 ");
Logger.Info("Obtaining DB2 Client");
DatabaseClient mysqlClient = DatabaseClientFactory.GetClient(DatabaseType.DB2);
Logger.Info("Executing query DB2: " + DB2_TEST_QUERY);
DataTable dataTable = mysqlClient.ExecuteQuery(DB2_TEST_QUERY, null);
Logger.Info("Printing ResultSet");
foreach (DataRow row in dataTable.Rows)
{
Console.WriteLine(row);
}
}
private static void TestMySQL()
{
Logger.Info("Start TestMySQL ");
Logger.Info("Obtaining MYSQL Client");
DatabaseClient mysqlClient = DatabaseClientFactory.GetClient(DatabaseType.MYSQL);
Logger.Info("Executing query MYSQL: " + MYSQL_TEST_QUERY);
DataTable dataTable = mysqlClient.ExecuteQuery(MYSQL_TEST_QUERY, null);
Logger.Info("Printing ResultSet");
foreach (DataRow row in dataTable.Rows)
{
Console.WriteLine(row);
}
}
public List <HauspaketAttribut> GetAllHauspaketAttributInsert()
{
ClientDB2 = DatabaseClientFactory.GetClient(DatabaseType.DB2);
DataTable hauspaketAttributTable = ClientDB2.ExecuteQuery(new HauspaketAttribut().GetSelectAllString(), null);
var resultSet = from hauspaketAttribut in hauspaketAttributTable.AsEnumerable()
select new HauspaketAttribut()
{
SyncOperation = "INSERT",
AttributId = HandleInt(hauspaketAttribut[0].ToString()),
AttributTyp = hauspaketAttribut[1].ToString(),
AttributTypAnzeige = "" + hauspaketAttribut[2]
};
return(resultSet.ToList <HauspaketAttribut>());
}
public void ClearInventory()
{
using (DatabaseClient dbClient = Essential.GetDatabase().GetClient())
{
dbClient.ExecuteQuery("DELETE FROM items WHERE room_id = 0 AND user_id = '" + this.UserId + "';");
}
this.Discs.Clear();
this.hashtable_1.Clear();
this.list_1.Clear();
this.Items.Clear();
ServerMessage Message5_ = new ServerMessage(Outgoing.UpdateInventary); // Updated
this.GetClient().SendMessage(Message5_);
}
public void ClearInventory()
{
using (DatabaseClient dbClient = HabboIM.GetDatabase().GetClient())
{
dbClient.ExecuteQuery("DELETE FROM items WHERE room_id = 0 AND user_id = '" + this.UserId + "';");
}
this.Discs.Clear();
this.hashtable_1.Clear();
this.list_1.Clear();
this.Items.Clear();
ServerMessage Message5_ = new ServerMessage(101u);
this.GetClient().SendMessage(Message5_);
}
public void RemoveItemFromHand(uint id, bool delete)
{
if (delete)
{
using (DatabaseClient dbClient = Skylight.GetDatabaseManager().GetClient())
{
dbClient.AddParamWithValue("itemId", id);
dbClient.ExecuteQuery("DELETE FROM items WHERE id = @itemId LIMIT 1;");
}
}
this.SendData(BasicUtilies.GetRevisionPacketManager(this.Session.Revision).GetOutgoing(OutgoingPacketsEnum.RemoveItemFromHand).Handle(new ValueHolder("InventoryManager", this, "ID", id)));
this.FloorItems.Remove(id);
this.WallItems.Remove(id);
}
public void SetCurrentPresetSettings(int preset, bool backgroundOnly, string colorCode, int colorIntensity)
{
if (this.IsValidColor(colorCode) && colorIntensity >= 0 && colorIntensity <= 255)
{
using (DatabaseClient dbClient = Skylight.GetDatabaseManager().GetClient())
{
dbClient.AddParamWithValue("data", colorCode + "," + colorIntensity + "," + TextUtilies.BoolToString(backgroundOnly));
dbClient.AddParamWithValue("itemId", this.ItemID);
dbClient.ExecuteQuery("UPDATE items_moodlight SET preset_" + (this.CurrentPreset == 1 ? "one" : this.CurrentPreset == 2 ? "two" : "three") + " = @data WHERE item_id = @itemId LIMIT 1");
}
this.GetPreset(preset).BackgroundOnly = backgroundOnly;
this.GetPreset(preset).ColorCode = colorCode;
this.GetPreset(preset).ColorIntensity = colorIntensity;
}
}
public void RemovePetsFromInventory()
{
using (DatabaseClient dbClient = HabboIM.GetDatabase().GetClient())
{
dbClient.ExecuteQuery("DELETE FROM user_pets WHERE user_id = " + this.UserId + " AND room_id = 0;");
}
foreach (Pet pet in Pets.Values)
{
ServerMessage Message = new ServerMessage(604u);
Message.AppendUInt(pet.PetId);
this.GetClient().SendMessage(Message);
}
this.Pets.Clear();
}
public void method_3(string string_0, int int_0)
{
string_0 = string_0.ToLower();
if (this.dictionary_0.ContainsKey(string_0))
{
Subscription @class = this.dictionary_0[string_0];
@class.method_1(int_0);
if (@class.Int32_0 <= 0 || @class.Int32_0 >= 2147483647)
{
return;
}
using (DatabaseClient class2 = GoldTree.GetDatabase().GetClient())
{
class2.AddParamWithValue("subcrbr", string_0);
class2.ExecuteQuery(string.Concat(new object[]
{
"UPDATE user_subscriptions SET timestamp_expire = '",
@class.Int32_0,
"' WHERE user_id = '",
this.uint_0,
"' AND subscription_id = @subcrbr LIMIT 1"
}));
return;
}
}
if (!this.dictionary_0.ContainsKey("habbo_vip"))
{
int num = (int)GoldTree.GetUnixTimestamp();
int num2 = (int)GoldTree.GetUnixTimestamp() + int_0;
Subscription class3 = new Subscription(string_0, num, num2);
using (DatabaseClient class2 = GoldTree.GetDatabase().GetClient())
{
class2.AddParamWithValue("subcrbr", string_0);
class2.ExecuteQuery(string.Concat(new object[]
{
"INSERT INTO user_subscriptions (user_id,subscription_id,timestamp_activated,timestamp_expire) VALUES ('",
this.uint_0,
"',@subcrbr,'",
num,
"','",
num2,
"')"
}));
}
this.dictionary_0.Add(class3.String_0.ToLower(), class3);
}
}
public void doInsertQuery(string Table, Dictionary <string, object> mcollection)
{
int ValueInt32 = 0, KeyInt32 = 0;
//Inialize the query builder
StringBuilder queryBuilder = new StringBuilder("INSERT INTO " + Table + " ");
//Initalize the key builder
StringBuilder keyBuilder = new StringBuilder("(");
//Initalize the insert builder
StringBuilder valueBuilder = new StringBuilder(") VALUES (");
foreach (string Key in mcollection.Keys)
{
KeyInt32++;
if (KeyInt32 != mcollection.Count)
{
keyBuilder.Append("`" + Filter(Key) + "`, ");
}
else
{
keyBuilder.Append("`" + Filter(Key) + "`");
}
}
foreach (object Value in mcollection.Values)
{
ValueInt32++;
if (ValueInt32 != mcollection.Count)
{
valueBuilder.Append("'" + Filter(Convert.ToString(Value)) + "', ");
}
else
{
valueBuilder.Append("'" + Filter(Convert.ToString(Value)) + "')");
}
}
using (DatabaseClient dbClient = AleedaEnvironment.GetDatabase().GetClient())
{
dbClient.ExecuteQuery(queryBuilder.ToString() + keyBuilder.ToString() + valueBuilder.ToString());
}
//Clears them
mcollection.Clear();
}
public void UnloadRoom()
{
if (!this.RoomUnloaded)
{
this.RoomUnloaded = true;
ServerMessage Message = BasicUtilies.GetRevisionServerMessage(Revision.RELEASE63_35255_34886_201108111108);
Message.Init(r63aOutgoing.LeaveRoom);
byte[] bytes = Message.GetBytes();
foreach (RoomUnitUser user in this.RoomUserManager.GetRealUsers())
{
user.Session.GetHabbo().GetRoomSession().LeavedRoom();
user.Session.SendData(bytes);
}
this.RoomItemManager.SaveAll();
this.RoomUserManager.SaveAll();
using (DatabaseClient dbClient = Skylight.GetDatabaseManager().GetClient())
{
dbClient.AddParamWithValue("roomId", this.ID);
dbClient.AddParamWithValue("data", JsonConvert.SerializeObject(this.RoomData.ExtraData));
dbClient.ExecuteQuery("UPDATE rooms SET data = @data WHERE id = @roomId LIMIT 1");
}
//achievement saving
if (!this.EquestrianTrackHost(0) || !this.FootballGoalHost(0) || !this.RoomHost(0))
{
using (DatabaseClient dbClient = Skylight.GetDatabaseManager().GetClient())
{
dbClient.AddParamWithValue("ownerId", this.RoomData.OwnerID);
dbClient.AddParamWithValue("equestrianTrackHost", this.EquestrianTrackHost_Offline);
dbClient.AddParamWithValue("footballGoalHost", this.FootballGoalHost_Offline);
dbClient.AddParamWithValue("roomHost", this.RoomHost_Offline);
dbClient.ExecuteQuery("UPDATE user_stats SET equestrian_track_host = equestrian_track_host + @equestrianTrackHost, football_goal_host = football_goal_host + @footballGoalHost, room_host = room_host + @roomHost WHERE user_id = @ownerId LIMIT 1");
}
this.EquestrianTrackHost_Offline = 0;
this.FootballGoalHost_Offline = 0;
this.RoomHost_Offline = 0;
}
}
GC.SuppressFinalize(this);
}
public List <Berater> GetAllBeraterInsert()
{
ClientDB2 = DatabaseClientFactory.GetClient(DatabaseType.DB2);
DataTable beraterTable = ClientDB2.ExecuteQuery(new Berater().GetSelectAllString(), null);
var resultSet = from berater in beraterTable.AsEnumerable()
select new Berater()
{
SyncOperation = "INSERT",
BeraterId = HandleInt(berater[0].ToString()),
HerstellerId = HandleInt(berater[1].ToString()),
BenutzerId = HandleInt(berater[2].ToString()),
Bild = berater[3].ToString()
};
return(resultSet.ToList <Berater>());
}
public void remove_tags()
{
if (Session.GetHabbo().HasFuse("fuse_admin") || Session.GetHabbo().HasFuse("fuse_sysadmin") || Session.GetHabbo().HasFuse("fuse_mod") || RoomUser.CalculateRights(Session.GetHabbo().RoomId, Session.GetHabbo().ID))
{
using (DatabaseClient dbClient = AleedaEnvironment.GetDatabase().GetClient())
{
dbClient.ExecuteQuery("UPDATE private_rooms SET tags = '' WHERE id = '" + Session.GetHabbo().RoomId + "'");
//Set the variable
AleedaEnvironment.GetCache().GetPrivateRooms().getRoom(Session.GetHabbo().RoomId).Tags = "";
ServerMessage msg = new ServerMessage(139); // "BK"
msg.Append("Removed all tags");
Session.GetMessageHandler().SendRoom(msg);
}
}
}
public virtual void Handle(GameClient session, ClientMessage message)
{
if (session?.GetHabbo()?.GetMessenger() != null)
{
foreach (uint userId in this.RemovedFriends)
{
session.GetHabbo().GetMessenger().RemoveFriendFromBoth(userId);
}
string friendIds = string.Join(",", this.RemovedFriends);
using (DatabaseClient dbClient = Skylight.GetDatabaseManager().GetClient())
{
dbClient.AddParamWithValue("userid", session.GetHabbo().ID);
dbClient.ExecuteQuery("DELETE FROM messenger_friends WHERE (user_one_id = @userid AND user_two_id IN(" + friendIds + ")) OR (user_one_id IN(" + friendIds + ") AND user_two_id = @userid) LIMIT " + this.RemovedFriends.Length);
}
}
}
public void Pick(GameClient picker, bool updateToDB)
{
this.Status = SupportTicketStatus.Picked;
this.PickerID = picker.GetHabbo().ID;
this.PickerUsername = picker.GetHabbo().Username;
if (updateToDB)
{
using (DatabaseClient dbClient = Skylight.GetDatabaseManager().GetClient())
{
dbClient.AddParamWithValue("ticketId", this.ID);
dbClient.AddParamWithValue("pickerId", this.PickerID);
dbClient.AddParamWithValue("pickerUsername", this.PickerUsername);
dbClient.ExecuteQuery("UPDATE moderation_tickets SET status = 'picked', picker_id = @pickerId WHERE id = @ticketId LIMIT 1");
}
}
}
public void parse(GameClient Session, ClientMessage Event)
{
uint HomeRoom = Event.PopWiredUInt();
RoomData Data = PhoenixEnvironment.GetGame().GetRoomManager().GenerateRoomData(HomeRoom);
if (HomeRoom == 0 || (Data != null && !(Data.Owner.ToLower() != Session.GetHabbo().Username.ToLower())))
{
Session.GetHabbo().HomeRoom = HomeRoom;
using (DatabaseClient adapter = PhoenixEnvironment.GetDatabase().GetClient())
{
adapter.ExecuteQuery("UPDATE users SET home_room = '" + HomeRoom + "' WHERE Id = '" + Session.GetHabbo().Id + "' LIMIT 1;");
}
ServerMessage Message = new ServerMessage(455);
Message.AppendUInt(HomeRoom);
Session.SendMessage(Message);
}
}
public void Handle(GameClient session, ClientMessage message)
{
if (session != null && session.GetHabbo() != null)
{
RoomUnitUser roomUser = session.GetHabbo().GetRoomSession().GetRoomUser();
if (roomUser != null)
{
string gender = message.PopFixedString().ToUpper();
string figure = message.PopFixedString();
session.GetHabbo().Gender = gender;
session.GetHabbo().Look = figure;
roomUser.FootballGateFigureActive = false;
using (DatabaseClient dbClient = Skylight.GetDatabaseManager().GetClient())
{
dbClient.AddParamWithValue("userId", session.GetHabbo().ID);
dbClient.AddParamWithValue("look", figure);
dbClient.AddParamWithValue("gender", gender);
dbClient.ExecuteQuery("UPDATE users SET look = @look, gender = @gender WHERE id = @userId LIMIT 1");
}
ServerMessage message_ = BasicUtilies.GetRevisionServerMessage(Revision.RELEASE63_35255_34886_201108111108);
message_.Init(r63aOutgoing.UpdateUser);
message_.AppendInt32(-1);
message_.AppendString(session.GetHabbo().Look);
message_.AppendString(session.GetHabbo().Gender.ToLower());
message_.AppendString(session.GetHabbo().Motto);
message_.AppendInt32(session.GetHabbo().GetUserStats().AchievementPoints);
session.SendMessage(message_);
ServerMessage message_2 = BasicUtilies.GetRevisionServerMessage(Revision.RELEASE63_35255_34886_201108111108);
message_2.Init(r63aOutgoing.UpdateUser);
message_2.AppendInt32(roomUser.VirtualID);
message_2.AppendString(session.GetHabbo().Look);
message_2.AppendString(session.GetHabbo().Gender.ToLower());
message_2.AppendString(session.GetHabbo().Motto);
message_2.AppendInt32(session.GetHabbo().GetUserStats().AchievementPoints);
roomUser.Room.SendToAll(message_2);
Skylight.GetGame().GetAchievementManager().AddAchievement(session, "AvatarLook", 1);
}
}
}
public void ActivateQuest(uint uint_0, GameClient Session)
{
if (Session != null && Session.GetHabbo() != null)
{
if (Session.GetHabbo().CurrentQuestId != uint_0)
{
Session.GetHabbo().CurrentQuestId = uint_0;
Session.GetHabbo().CurrentQuestProgress = 0;
using (DatabaseClient @class = Essential.GetDatabase().GetClient())
{
@class.AddParamWithValue("uid", Session.GetHabbo().Id);
@class.AddParamWithValue("qid", uint_0);
@class.ExecuteQuery("UPDATE user_stats SET quest_id = @qid, quest_progress = '0' WHERE Id = @uid LIMIT 1");
}
}
if (uint_0 == 0u)
{
Session.SendMessage(this.SerializeQuests(Session));
ServerMessage Message5_ = new ServerMessage(Outgoing.QuestCancel); // Updated QuestCancel 803 old
Message5_.AppendBoolean(false); // Is expired
Session.SendMessage(Message5_);
}
else
{
Quest class2 = this.GetQuest(uint_0);
if (class2.NeedForLevel <= Session.GetHabbo().CurrentQuestProgress)
{
this.CompleteQuest(uint_0, Session);
}
else
{
/*ServerMessage Message = new ServerMessage(Outgoing.LoadQuests); // Updated
* Message.AppendInt32(QuestsCount);
* this.method_9(Session, Message);
* Message.AppendBoolean(true);
* Session.SendMessage(Message);*/
ServerMessage message1 = new ServerMessage(Outgoing.ActivateQuest);
this.GetQuest(uint_0).Serialize(message1, Session, true);
//this.method_9(Session, message1);
message1.AppendBoolean(true);
Session.SendMessage(message1);
}
}
}
}
internal void StoreCommand(GameClient class16_1, string string_0, string string_1)
{
if (ServerConfiguration.EnableCommandLog)
{
using (DatabaseClient @class = Essential.GetDatabase().GetClient())
{
@class.AddParamWithValue("extra_data", string_1);
@class.AddParamWithValue("username", class16_1.GetHabbo().Username);
@class.AddParamWithValue("cmd", string_0);
@class.ExecuteQuery(string.Concat(new object[]
{
"INSERT INTO cmdlogs (user_id,user_name,command,extra_data,timestamp) VALUES ('",
class16_1.GetHabbo().Id,
"',@username,@cmd, @extra_data, UNIX_TIMESTAMP())"
}));
}
}
}
public void LogIn(string username, string password, uint userId, int time)
{
if (!string.IsNullOrEmpty(username) && !string.IsNullOrEmpty(password))
{
password = BitConverter.ToString(MD5CryptoServiceProvider.Create().ComputeHash(Encoding.UTF8.GetBytes(password))).Replace("-", "").ToLower();
string sso = "Temp-SSO-Login-With-Username-And-Password-" + username + "-" + time + "-" + TimeUtilies.GetUnixTimestamp();
using (DatabaseClient dbClient = Skylight.GetDatabaseManager().GetClient())
{
dbClient.AddParamWithValue("username", username);
dbClient.AddParamWithValue("password", password);
dbClient.AddParamWithValue("sso", sso);
dbClient.ExecuteQuery("UPDATE users SET auth_ticket = @sso WHERE `username` = @username AND `password` = @password LIMIT 1");
}
this.LogIn(sso, true);
}
}
public void Handle(GameClient session, ClientMessage message)
{
uint roomId = message.PopWiredUInt();
if (session.GetHabbo().HomeRoom != roomId)
{
session.GetHabbo().HomeRoom = roomId;
using (DatabaseClient dbClient = Skylight.GetDatabaseManager().GetClient())
{
dbClient.AddParamWithValue("roomId", roomId);
dbClient.AddParamWithValue("userId", session.GetHabbo().ID);
dbClient.ExecuteQuery("UPDATE users SET home_room = @roomId WHERE id = @userId LIMIT 1");
}
session.SendMessage(OutgoingPacketsEnum.HomeRoom, new ValueHolder("HomeRoom", session.GetHabbo().HomeRoom));
}
}
public void UpdateShellsBalance(bool FromDatabase, bool ToDatabase)
{
if (FromDatabase)
{
using (DatabaseClient adapter = PhoenixEnvironment.GetDatabase().GetClient())
{
this.shells = adapter.ReadInt32("SELECT vip_points FROM users WHERE Id = '" + Id + "' LIMIT 1;");
}
}
if (ToDatabase)
{
using (DatabaseClient adapter = PhoenixEnvironment.GetDatabase().GetClient())
{
adapter.ExecuteQuery("UPDATE users SET vip_points = '" + shells + "' WHERE Id = '" + Id + "' LIMIT 1;");
}
}
UpdateActivityPointsBalance(0);
}