internal void MyRooms() { #region Navigator - ME ServerMessage MyRooms = new ServerMessage(Headers.MyRoomsInit); MySQL MyRoomsSQL = new MySQL(Init.ServerMySQL); MyRoomsSQL.Query("SELECT * FROM rooms WHERE ownerid = '" + (int)User.HabboUser.UserRow["Id"] + "'"); MyRooms.AppendInt32(5); MyRooms.AppendString(""); MyRooms.AppendInt32(MyRoomsSQL.Num_Rows()); // Numero de salas foreach (DataRow Data in MyRoomsSQL.Fetch_Array()) { List<string> TagList; TagList = new List<string>(); if (Data["tags"].ToString().Contains(";")) { string[] Separe = Data["tags"].ToString().Split(';'); foreach (string s in Separe) { TagList.Add(s); } } MyRooms.AppendInt32((int)Data["id"]); MyRooms.AppendBoolean(false); // events MyRooms.AppendString((string)Data["name"]); MyRooms.AppendInt32((int)Data["ownerid"]); MyRooms.AppendString((string)User.HabboUser.UserRow["username"]); MyRooms.AppendInt32(0); MyRooms.AppendInt32((int)Data["usersnow"]); MyRooms.AppendInt32((int)Data["maxusers"]); MyRooms.AppendString((string)Data["description"]); MyRooms.AppendInt32(0); MyRooms.AppendInt32((Convert.ToInt32(Data["category"]) == 3) ? 0 : 2); MyRooms.AppendInt32((int)Data["score"]); MyRooms.AppendInt32(Convert.ToInt32(Data["category"])); MyRooms.AppendString(""); MyRooms.AppendInt32(0); MyRooms.AppendInt32(0); MyRooms.AppendInt32(TagList.Count); foreach (string D in TagList) MyRooms.AppendString(D); MyRooms.AppendInt32(0); MyRooms.AppendInt32(0); MyRooms.AppendInt32(0); // booleans MyRooms.AppendBoolean(true); MyRooms.AppendBoolean(true); } MyRooms.AppendBoolean(false); User.sendPacket(MyRooms); #endregion }
public static bool userExists(int userID) { MySQL dbClient = new MySQL(Zazlak.Init.ServerMySQL); dbClient.Query("SELECT id FROM users WHERE id = '" + userID + "'"); return Convert.ToBoolean(dbClient.Num_Rows()); }
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); } }
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 }