public HabboUser(User Info) { this.User = Info; int UserId = 1; MySQL Lol = new MySQL(Init.ServerMySQL); Lol.Query("SELECT * FROM users_characters WHERE Id = '" + UserId + "'"); this.UserRow = Lol.Fetch_Assoc(); }
public static void addUser(int userID, User User) { if (_Users.ContainsKey(userID)) { User oldUser = ((User)_Users[userID]); oldUser.Disconnect(); if (_Users.ContainsKey(userID)) _Users.Remove(userID); } MySQL dbClient = new MySQL(Zazlak.Init.ServerMySQL); dbClient.Query("SELECT IP FROM users_characters WHERE username = '******' LIMIT 1"); if (User.IP == (string)dbClient.Fetch_Assoc()["ip"]) { _Users.Add(userID, User); //dbClient.runQuery("UPDATE users SET ticket_sso = NULL WHERE id = '" + userID + "' LIMIT 1"); //dbClient.runQuery("UPDATE users SET logins = logins + 1 WHERE id = '" + userID + "'"); dbClient.Query("UPDATE users_characters SET lastaccess = '" + (int)(DateTime.UtcNow - new DateTime(1970, 1, 1)).TotalSeconds + "' WHERE id = '1'"); dbClient.Query("UPDATE users_characters SET lastaccess = '" + (int)(DateTime.UtcNow - new DateTime(1970, 1, 1)).TotalSeconds + "' WHERE id = '2'"); dbClient.Query("UPDATE users_characters SET connected = 1 WHERE id = '" + userID + "'"); Out.WriteLine(User.HabboUser.UserRow["username"] + " has connected", ConsoleColor.DarkMagenta); } }
public DataRow GetRoom(int RoomId) { MySQL RoomsRow = new MySQL(Init.ServerMySQL); RoomsRow.Query("SELECT * FROM rooms WHERE id = '" + RoomId + "' LIMIT 1"); return RoomsRow.Fetch_Assoc(); }
internal void LoadRoom() { int RoomId = User.ActualClientMessage.GetNextInt(); MySQL RoomsRow = new MySQL(Init.ServerMySQL); RoomsRow.Query("SELECT * FROM rooms WHERE id = '" + RoomId + "' LIMIT 1"); Out.WriteLine(RoomsRow.Num_Rows()); if (RoomsRow.Num_Rows() == 1) { DataRow RD = RoomsRow.Fetch_Assoc(); User.HabboUser.CurrentRoomId = RoomId; //Habbo.VisitedRooms += RoomId + ";"; //Habbo.IsOnRoom = true; BuildMessage Load = new BuildMessage(); ServerMessage LoadRooms = new ServerMessage(Headers.LOADROOMS); Load.AppendPacket(LoadRooms); ServerMessage LoadRooms2 = new ServerMessage(1059); LoadRooms2.AppendInt32(77824); LoadRooms2.AppendInt32(513); Load.AppendPacket(LoadRooms2); ServerMessage Model = new ServerMessage(Headers.LOADMODEL); Model.AppendString(RD["model"].ToString()); Model.AppendInt32(RoomId); Load.AppendPacket(Model); if (RD["wall"].ToString() != "0") { ServerMessage SendWallpaper = new ServerMessage(Headers.LOADWALLSFLOORSLANDS); SendWallpaper.AppendString("wallpaper"); SendWallpaper.AppendString(RD["wall"]); Load.AppendPacket(SendWallpaper); } if (RD["floor"].ToString() != "0") { ServerMessage SendFloor = new ServerMessage(Headers.LOADWALLSFLOORSLANDS); SendFloor.AppendString("floor"); SendFloor.AppendString(RD["floor"]); Load.AppendPacket(SendFloor); } ServerMessage SendLandscape = new ServerMessage(Headers.LOADWALLSFLOORSLANDS); SendLandscape.AppendString("landscape"); SendLandscape.AppendString(RD["landscape"] + ".0"); Load.AppendPacket(SendLandscape); ServerMessage Unk = new ServerMessage(Headers.UNK); Unk.AppendInt32(4); Load.AppendPacket(Unk); if (RD["OwnerId"] == User.HabboUser.UserRow["id"]) { ServerMessage LoadPows = new ServerMessage(Headers.LOADPOWS); Load.AppendPacket(LoadPows); } ServerMessage LoadScore = new ServerMessage(Headers.LOADSCORE); LoadScore.AppendInt32((int)RD["score"]); LoadScore.AppendBoolean(false); Load.AppendPacket(LoadScore); ServerMessage LoadEvent = new ServerMessage(Headers.LOADEVENTS); LoadEvent.AppendString("-1"); Load.AppendPacket(LoadEvent); //Habbo.Cache.Rooms; User.sendPacket(Load); } }
public static string getUserName(int userID) { MySQL dbClient = new MySQL(Zazlak.Init.ServerMySQL); dbClient.Query("SELECT name FROM users WHERE id = '" + userID + "' LIMIT 1"); return Convert.ToString(dbClient.Fetch_Assoc()["username"]); }
public static int getUserID(string userName) { MySQL dbClient = new MySQL(Zazlak.Init.ServerMySQL); dbClient.Query("SELECT id FROM users WHERE name = " + userName + "' LIMIT 1"); return Convert.ToInt32(dbClient.Fetch_Assoc()["id"]); }
internal void UserProfile() { int UserId = User.ActualClientMessage.GetNextInt(); MySQL Lol = new MySQL(Init.ServerMySQL); Lol.Query("SELECT * FROM users_characters WHERE Id = '" + UserId + "'"); this.UserRow = Lol.Fetch_Assoc(); if (UserRow["connected"].ToString() == "1") { Connected = true; } else { Connected = false; } ServerMessage Profile = new ServerMessage(Headers.SendProfile); Profile.AppendInt32(UserRow["id"]); Profile.AppendString(UserRow["username"]); Profile.AppendString(UserRow["figure"]); Profile.AppendString(UserRow["motto"]); Profile.AppendString(UserRow["createdon"]); Profile.AppendInt32(1337); Profile.AppendInt32(2); Profile.AppendBoolean(false); Profile.AppendBoolean(false); Profile.AppendBoolean(Connected); Profile.AppendInt32(0); Profile.AppendInt32(((int)(DateTime.UtcNow - new DateTime(1970, 1, 1)).TotalSeconds - (int)User.HabboUser.UserRow["lastaccess"])); Profile.AppendBoolean(true); this.User.sendPacket(Profile); ServerMessage SendCredits = new ServerMessage(Headers.SendCredits); SendCredits.AppendString("1000.0"); this.User.sendPacket(SendCredits); }
internal void sendPacket() { #region Packet ServerMessage SendCredits = new ServerMessage(Headers.SendCredits); SendCredits.AppendString(Convert.ToInt32(UserRow["credits"]) + ".0"); this.User.sendPacket(SendCredits); ServerMessage SendUser = new ServerMessage(Headers.SendUserData); SendUser.AppendInt32(Convert.ToInt32(UserRow["id"])); SendUser.AppendString(Convert.ToString(UserRow["username"])); SendUser.AppendString("hr-155-32.hd-185-2.ch-3030-62.lg-275-62.sh-290-62,s-0.g-1.d-3.h-3.a-0"); SendUser.AppendString(Convert.ToString(UserRow["gender"]).ToLower()); SendUser.AppendString(Convert.ToString(UserRow["motto"])); SendUser.AppendString("habbowall"); SendUser.AppendInt32(0); SendUser.AppendBoolean(false); SendUser.AppendInt32(0); // Friends SendUser.AppendInt32(3); SendUser.AppendInt32(3); SendUser.AppendBoolean(true); SendUser.AppendString("02-05-2012 08:05:10"); this.User.sendPacket(SendUser); ServerMessage Friends = new ServerMessage(Headers.FriendsBarInit); Friends.AppendInt32(100); // amount friends normal Friends.AppendInt32(100); // amount max friends normal Friends.AppendInt32(200); // amount max friends HC? Friends.AppendInt32(300); // amount max friends VIP? Friends.AppendInt32(0); // amount categorie MySQL FriendSQL = new MySQL(Init.ServerMySQL); FriendSQL.Query("SELECT user_two_id FROM users_friends WHERE user_one_id = '"+UserRow["id"]+"'"); Friends.AppendInt32(FriendSQL.Num_Rows()); // amount friends foreach (DataRow TheRow in FriendSQL.Fetch_Array()) { MySQL TheFriend = new MySQL(Init.ServerMySQL); TheFriend.Query("SELECT * FROM users_characters WHERE id = '"+TheRow["user_two_id"]+"'"); this.Row = TheFriend.Fetch_Assoc(); if (Row["connected"].ToString() == "1") { Connected = true; } else { Connected = false; } Friends.AppendInt32(Row["id"]); // id Friends.AppendString(Row["username"]); // name Friends.AppendInt32(1); // ? Friends.AppendBoolean(Connected); // isonline Friends.AppendBoolean(false); // isinroom Friends.AppendString(Row["figure"]); // figure Friends.AppendInt32(0); // ? Friends.AppendString(Row["motto"]); // motto Friends.AppendString("Mikkel"); // facebook name Friends.AppendString(Row["createdon"]); Friends.AppendBoolean(false); } Friends.AppendInt32(100); // ? Friends.AppendInt32(0); // ? this.User.sendPacket(Friends); ServerMessage Club = new ServerMessage(Headers.VipInit); Club.AppendString("club_habbo"); Club.AppendInt32(10); // Dias Club.AppendInt32(0); Club.AppendInt32(0); Club.AppendInt32(1); Club.AppendBoolean(false); Club.AppendBoolean(true); Club.AppendInt32(0); Club.AppendInt32(0); Club.AppendInt32(0); this.User.sendPacket(Club); ServerMessage SendPacket = new ServerMessage(2994); SendPacket.AppendString("Hola"); SendPacket.AppendBoolean(false); SendPacket.AppendBoolean(false); this.User.sendPacket(SendPacket); ServerMessage SendPixels = new ServerMessage(Headers.SendPixels); SendPixels.AppendInt32(1); SendPixels.AppendInt32(0); SendPixels.AppendInt32(UserRow["pixels"]); this.User.sendPacket(SendPixels); #endregion }