public void parse(GameClient Session, ClientPacket Packet)
{
Room Room = UberEnvironment.GetGame().GetRoomManager().GetRoom(Session.GetHabbo().CurrentRoomId);
if (Room == null || !Room.CheckRights(Session, true))
{
return;
}
int Junk = Packet.PopWiredInt32(); // always 3
Dictionary<int, int> Items = new Dictionary<int, int>();
int Background = Packet.PopWiredInt32();
int TopLayer = Packet.PopWiredInt32();
int AmountOfItems = Packet.PopWiredInt32();
for (int i = 0; i < AmountOfItems; i++)
{
int Pos = Packet.PopWiredInt32();
int Item = Packet.PopWiredInt32();
if (Pos < 0 || Pos > 10)
{
return;
}
if (Item < 1 || Item > 27)
{
return;
}
if (Items.ContainsKey(Pos))
{
return;
}
Items.Add(Pos, Item);
}
if (Background < 1 || Background > 24)
{
return;
}
if (TopLayer < 0 || TopLayer > 11)
{
return;
}
StringBuilder FormattedItems = new StringBuilder();
int j = 0;
foreach (KeyValuePair<int, int> Item in Items)
{
if (j > 0)
{
FormattedItems.Append("|");
}
FormattedItems.Append(Item.Key + "," + Item.Value);
j++;
}
using (DatabaseClient dbClient = UberEnvironment.GetDatabase().GetClient())
{
dbClient.ExecuteQuery("UPDATE rooms SET icon_bg = '" + Background + "', icon_fg = '" + TopLayer + "', icon_items = '" + FormattedItems.ToString() + "' WHERE id = '" + Room.RoomId + "' LIMIT 1");
}
Room.Icon = new RoomIcon(Background, TopLayer, Items);
ServerPacket packet = new ServerPacket(457);
packet.AppendUInt(Room.RoomId);
packet.AppendBoolean(true);
Session.SendPacket(packet);
packet = new ServerPacket(456);
packet.AppendUInt(Room.RoomId);
Session.SendPacket(packet);
RoomData Data = new RoomData();
Data.Fill(Room);
ServerPacket _packet = new ServerPacket(454);
_packet.AppendBoolean(false);
Data.Serialize(_packet, false);
_packet.AppendBoolean(false);
_packet.AppendBoolean(false);
Session.SendPacket(_packet);
}
public ServerPacket SerializeEventListing(GameClient Session, int Category)
{
ServerPacket Message = new ServerPacket(451);
Message.AppendInt32(Category);
Message.AppendInt32(12);
Message.AppendStringWithBreak("");
List<Room> EventRooms = UberEnvironment.GetGame().GetRoomManager().GetEventRoomsForCategory(Category);
Message.AppendInt32(EventRooms.Count);
foreach (Room Room in EventRooms)
{
RoomData Data = new RoomData();
Data.Fill(Room);
Data.Serialize(Message, true);
}
return Message;
}
public ServerPacket SerializeSearchResults(string SearchQuery)
{
DataTable Data = null;
using (DatabaseClient dbClient = UberEnvironment.GetDatabase().GetClient())
{
SearchQuery = UberEnvironment.FilterInjectionChars(SearchQuery.ToLower()).Trim();
if (SearchQuery.Length > 0)
{
dbClient.AddParamWithValue("query", SearchQuery + "%");
dbClient.AddParamWithValue("tags_query", "%" + SearchQuery + "%");
Data = dbClient.ReadDataTable("SELECT * FROM rooms WHERE caption LIKE @query AND roomtype = 'private' OR tags LIKE @tags_query AND roomtype = 'private' OR owner LIKE @query AND roomtype = 'private' ORDER BY users_now DESC LIMIT 30");
}
}
List<RoomData> Results = new List<RoomData>();
if (Data != null)
{
foreach (DataRow Row in Data.Rows)
{
RoomData RData = new RoomData();
RData.Fill(Row);
Results.Add(RData);
}
}
ServerPacket Message = new ServerPacket(451);
Message.AppendInt32(1);
Message.AppendInt32(9);
Message.AppendStringWithBreak(SearchQuery);
Message.AppendInt32(Results.Count);
foreach (RoomData Room in Results)
{
Room.Serialize(Message, false);
}
return Message;
}
public ServerPacket SerializeTicketChatlog(SupportTicket Ticket, RoomData RoomData, Double Timestamp)
{
DataTable Data = null;
using (DatabaseClient dbClient = UberEnvironment.GetDatabase().GetClient())
{
Data = dbClient.ReadDataTable("SELECT user_id,user_name,hour,minute,message FROM chatlogs WHERE room_id = '" + RoomData.Id + "' AND timestamp >= '" + (Timestamp - 300) + "' AND timestamp <= '" + Timestamp + "' ORDER BY timestamp DESC");
}
ServerPacket Message = new ServerPacket(534);
Message.AppendUInt(Ticket.TicketId);
Message.AppendUInt(Ticket.SenderId);
Message.AppendUInt(Ticket.ReportedId);
Message.AppendBoolean(RoomData.IsPublicRoom);
Message.AppendUInt(RoomData.Id);
Message.AppendStringWithBreak(RoomData.Name);
if (Data != null)
{
Message.AppendInt32(Data.Rows.Count);
foreach (DataRow Row in Data.Rows)
{
Message.AppendInt32((int)Row["hour"]);
Message.AppendInt32((int)Row["minute"]);
Message.AppendUInt((uint)Row["user_id"]);
Message.AppendStringWithBreak((string)Row["user_name"]);
Message.AppendStringWithBreak((string)Row["message"]);
}
}
else
{
Message.AppendInt32(0);
}
return Message;
}
public ServerPacket SerializeRoomTool(RoomData Data)
{
Room Room = UberEnvironment.GetGame().GetRoomManager().GetRoom(Data.Id);
uint OwnerId = 0;
using (DatabaseClient dbClient = UberEnvironment.GetDatabase().GetClient())
{
try
{
OwnerId = (uint)dbClient.ReadDataRow("SELECT id FROM users WHERE username = '******' LIMIT 1")[0];
}
catch (Exception) { }
}
ServerPacket Message = new ServerPacket(538);
Message.AppendUInt(Data.Id);
Message.AppendInt32(Data.UsersNow); // user count
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 Tag in Data.Tags)
{
Message.AppendStringWithBreak(Tag);
}
if (Room != null)
{
Message.AppendBoolean(Room.HasOngoingEvent);
if (Room.Event != null)
{
Message.AppendStringWithBreak(Room.Event.Name);
Message.AppendStringWithBreak(Room.Event.Description);
Message.AppendInt32(Room.Event.Tags.Count);
foreach (string Tag in Room.Event.Tags)
{
Message.AppendStringWithBreak(Tag);
}
}
}
else
{
Message.AppendBoolean(false);
}
return Message;
}
public void parse(GameClient Session, ClientPacket Packet)
{
Room Room = UberEnvironment.GetGame().GetRoomManager().GetRoom(Session.GetHabbo().CurrentRoomId);
if (Room == null || !Room.CheckRights(Session, true))
{
return;
}
int Id = Packet.PopWiredInt32();
string Name = UberEnvironment.FilterInjectionChars(Packet.PopFixedString());
string Description = UberEnvironment.FilterInjectionChars(Packet.PopFixedString());
int State = Packet.PopWiredInt32();
string Password = UberEnvironment.FilterInjectionChars(Packet.PopFixedString());
int MaxUsers = Packet.PopWiredInt32();
int CategoryId = Packet.PopWiredInt32();
int TagCount = Packet.PopWiredInt32();
List<string> Tags = new List<string>();
StringBuilder formattedTags = new StringBuilder();
for (int i = 0; i < TagCount; i++)
{
if (i > 0)
{
formattedTags.Append(",");
}
string tag = UberEnvironment.FilterInjectionChars(Packet.PopFixedString().ToLower());
Tags.Add(tag);
formattedTags.Append(tag);
}
int AllowPets = 0;
int AllowPetsEat = 0;
int AllowWalkthrough = 0;
int Hidewall = 0;
string _AllowPets = Packet.PlainReadBytes(1)[0].ToString();
Packet.AdvancePointer(1);
string _AllowPetsEat = Packet.PlainReadBytes(1)[0].ToString();
Packet.AdvancePointer(1);
string _AllowWalkthrough = Packet.PlainReadBytes(1)[0].ToString();
Packet.AdvancePointer(1);
string _Hidewall = Packet.PlainReadBytes(1)[0].ToString();
Packet.AdvancePointer(1);
if (Name.Length < 1)
{
return;
}
if (State < 0 || State > 2)
{
return;
}
if (MaxUsers != 10 && MaxUsers != 15 && MaxUsers != 20 && MaxUsers != 25)
{
return;
}
FlatCat FlatCat = UberEnvironment.GetGame().GetNavigator().GetFlatCat(CategoryId);
if (FlatCat == null)
{
return;
}
if (FlatCat.MinRank > Session.GetHabbo().Rank)
{
Session.SendNotif("You are not allowed to use this category. Your room has been moved to no category instead.");
CategoryId = 0;
}
if (TagCount > 2)
{
return;
}
if (State < 0 || State > 2)
{
return;
}
if (_AllowPets == "65")
{
AllowPets = 1;
Room.AllowPets = true;
}
else
{
Room.AllowPets = false;
}
if (_AllowPetsEat == "65")
{
AllowPetsEat = 1;
Room.AllowPetsEating = true;
}
else
{
Room.AllowPetsEating = false;
}
if (_AllowWalkthrough == "65")
{
AllowWalkthrough = 1;
Room.AllowWalkthrough = true;
}
else
{
Room.AllowWalkthrough = false;
}
if (_Hidewall == "65")
{
Hidewall = 1;
Room.Hidewall = true;
}
else
{
Room.Hidewall = false;
}
Room.Name = Name;
Room.State = State;
Room.Description = Description;
Room.Category = CategoryId;
Room.Password = Password;
Room.Tags = Tags;
Room.UsersMax = MaxUsers;
string formattedState = "open";
if (Room.State == 1)
{
formattedState = "locked";
}
else if (Room.State > 1)
{
formattedState = "password";
}
using (DatabaseClient dbClient = UberEnvironment.GetDatabase().GetClient())
{
dbClient.AddParamWithValue("caption", Room.Name);
dbClient.AddParamWithValue("description", Room.Description);
dbClient.AddParamWithValue("password", Room.Password);
dbClient.AddParamWithValue("tags", formattedTags.ToString());
dbClient.ExecuteQuery("UPDATE rooms SET caption = @caption, description = @description, password = @password, category = '" + CategoryId + "', state = '" + formattedState + "', tags = @tags, users_max = '" + MaxUsers + "', allow_pets = '" + AllowPets + "', allow_pets_eat = '" + AllowPetsEat + "', allow_walkthrough = '" + AllowWalkthrough + "', allow_hidewall = '" + Hidewall + "' WHERE id = '" + Room.RoomId + "' LIMIT 1");
}
ServerPacket packet = new ServerPacket(467);
packet.AppendUInt(Room.RoomId);
Session.SendPacket(packet);
packet = new ServerPacket(456);
packet.AppendUInt(Room.RoomId);
Session.SendPacket(packet);
packet = new ServerPacket(472);
packet.AppendBoolean(Room.Hidewall);
UberEnvironment.GetGame().GetRoomManager().GetRoom(Session.GetHabbo().CurrentRoomId).SendMessage(packet);
RoomData Data = new RoomData();
Data.Fill(Room);
packet = new ServerPacket(454);
packet.AppendBoolean(false);
Data.Serialize(packet, false);
packet.AppendBoolean(false);
packet.AppendBoolean(false);
Session.SendPacket(packet);
}
public RoomData GenerateRoomData(uint RoomId)
{
RoomData Data = new RoomData();
if (IsRoomLoaded(RoomId))
{
Data.Fill(GetRoom(RoomId));
}
else
{
DataRow Row = null;
using (DatabaseClient dbClient = UberEnvironment.GetDatabase().GetClient())
{
Row = dbClient.ReadDataRow("SELECT * FROM rooms WHERE id = '" + RoomId + "' LIMIT 1");
}
if (Row == null)
{
return null;
}
Data.Fill(Row);
}
return Data;
}
public RoomData GenerateNullableRoomData(uint RoomId)
{
if (GenerateRoomData(RoomId) != null)
{
return GenerateRoomData(RoomId);
}
RoomData Data = new RoomData();
Data.FillNull(RoomId);
return Data;
}
