public void Parse(HabboHotel.GameClients.GameClient session, ClientPacket packet)
{
if (!session.GetHabbo().InRoom)
{
return;
}
Room Room = session.GetHabbo().CurrentRoom;
if (Room == null)
{
return;
}
string Username = packet.PopString();
Habbo Player = BiosEmuThiago.GetHabboByUsername(Username);
if (Player == null)
{
return;
}
if (!session.GetHabbo().GetIgnores().TryGet(Player.Id))
{
return;
}
if (session.GetHabbo().GetIgnores().TryRemove(Player.Id))
{
using (IQueryAdapter dbClient = BiosEmuThiago.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("DELETE FROM `user_ignores` WHERE `user_id` = @uid AND `ignore_id` = @ignoreId");
dbClient.AddParameter("uid", session.GetHabbo().Id);
dbClient.AddParameter("ignoreId", Player.Id);
dbClient.RunQuery();
}
session.SendMessage(new IgnoreStatusComposer(3, Player.Username));
}
}
public bool TryGetGroup(int id, out Group Group)
{
Group = null;
if (this._groups.ContainsKey(id))
{
return(this._groups.TryGetValue(id, out Group));
}
lock (this._groupLoadingSync)
{
if (this._groups.ContainsKey(id))
{
return(this._groups.TryGetValue(id, out Group));
}
DataRow Row = null;
using (IQueryAdapter dbClient = BiosEmuThiago.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("SELECT * FROM `groups` WHERE `id` = @id LIMIT 1");
dbClient.AddParameter("id", id);
Row = dbClient.getRow();
if (Row != null)
{
int created;
try
{
int.TryParse(Row["created"].ToString(), out created);
}
catch { created = BiosEmuThiago.GetIUnixTimestamp(); }
Group = new Group(
Convert.ToInt32(Row["id"]), Convert.ToString(Row["name"]), Convert.ToString(Row["desc"]), Convert.ToString(Row["badge"]), Convert.ToInt32(Row["room_id"]), Convert.ToInt32(Row["owner_id"]),
Convert.ToInt32(Row["created"]), Convert.ToInt32(Row["state"]), Convert.ToInt32(Row["colour1"]), Convert.ToInt32(Row["colour2"]), Convert.ToInt32(Row["admindeco"]), Convert.ToInt32(Row["forum_enabled"]) == 1, Convert.ToInt32(Row["has_chat"]) == 1);
this._groups.TryAdd(Group.Id, Group);
return(true);
}
}
}
return(false);
}
public RoomData CreateRoom(GameClient Session, string Name, string Description, string Model, int Category, int MaxVisitors, int TradeSettings,
string wallpaper = "0.0", string floor = "0.0", string landscape = "0.0", int wallthick = 0, int floorthick = 0)
{
if (!_roomModels.ContainsKey(Model))
{
Session.SendNotification(BiosEmuThiago.GetGame().GetLanguageManager().TryGetValue("room.creation.model.not_found"));
return(null);
}
if (Name.Length < 3)
{
Session.SendNotification(BiosEmuThiago.GetGame().GetLanguageManager().TryGetValue("room.creation.name.too_short"));
return(null);
}
int RoomId = 0;
using (IQueryAdapter dbClient = BiosEmuThiago.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("INSERT INTO `rooms` (`roomtype`,`caption`,`description`,`owner`,`model_name`,`category`,`users_max`,`trade_settings`,`wallpaper`,`floor`,`landscape`,`floorthick`,`wallthick`) VALUES ('private',@caption,@description,@UserId,@model,@category,@usersmax,@tradesettings,@wallpaper,@floor,@landscape,@floorthick,@wallthick)");
dbClient.AddParameter("caption", Name);
dbClient.AddParameter("description", Description);
dbClient.AddParameter("UserId", Session.GetHabbo().Id);
dbClient.AddParameter("model", Model);
dbClient.AddParameter("category", Category);
dbClient.AddParameter("usersmax", MaxVisitors);
dbClient.AddParameter("tradesettings", TradeSettings);
dbClient.AddParameter("wallpaper", wallpaper);
dbClient.AddParameter("floor", floor);
dbClient.AddParameter("landscape", landscape);
dbClient.AddParameter("floorthick", floorthick);
dbClient.AddParameter("wallthick", wallthick);
RoomId = Convert.ToInt32(dbClient.InsertQuery());
}
RoomData newRoomData = GenerateRoomData(RoomId);
Session.GetHabbo().UsersRooms.Add(newRoomData);
return(newRoomData);
}
public void Parse(GameClient Session, ClientPacket Packet)
{
if (Session == null || Session.GetHabbo() == null || !Session.GetHabbo().GetPermissions().HasRight("mod_tool"))
{
return;
}
int Result = Packet.PopInt(); // 1 = useless, 2 = abusive, 3 = resolved
int Junk = Packet.PopInt();
int TicketId = Packet.PopInt();
ModerationTicket Ticket = null;
if (!BiosEmuThiago.GetGame().GetModerationManager().TryGetTicket(TicketId, out Ticket))
{
return;
}
if (Ticket.Moderator.Id != Session.GetHabbo().Id)
{
return;
}
GameClient Client = BiosEmuThiago.GetGame().GetClientManager().GetClientByUserID(Ticket.Sender.Id);
if (Client != null)
{
Client.SendMessage(new ModeratorSupportTicketResponseComposer(Result));
}
if (Result == 2)
{
using (IQueryAdapter dbClient = BiosEmuThiago.GetDatabaseManager().GetQueryReactor())
{
dbClient.runFastQuery("UPDATE `user_info` SET `cfhs_abusive` = `cfhs_abusive` + 1 WHERE `user_id` = '" + Ticket.Sender.Id + "' LIMIT 1");
}
}
Ticket.Answered = true;
BiosEmuThiago.GetGame().GetClientManager().SendMessage(new ModeratorSupportTicketComposer(Session.GetHabbo().Id, Ticket), "mod_tool");
}
public void Parse(GameClient Session, ClientPacket Packet)
{
var pic = HabboCameraManager.GetUserPurchasePic(Session);
if (pic == null)
{
return;
}
int InsetId;
using (var Adap = BiosEmuThiago.GetDatabaseManager().GetQueryReactor())
{
Adap.SetQuery("INSERT INTO server_pictures_publish (picture_id, usuariothiago) VALUES (@pic, @thiago)");
Adap.AddParameter("pic", pic.Id);
Adap.AddParameter("thiago", Session.GetHabbo().Username);
InsetId = (int)Adap.InsertQuery();
}
Session.SendMessage(new CameraFinishPublishComposer(InsetId));
}
public static Bot CreateBot(ItemData Data, int OwnerId)
{
DataRow BotData = null;
CatalogBot CataBot = null;
if (!BiosEmuThiago.GetGame().GetCatalog().TryGetBot(Data.Id, out CataBot))
{
return(null);
}
using (IQueryAdapter dbClient = BiosEmuThiago.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("INSERT INTO bots (`user_id`,`name`,`motto`,`look`,`gender`,`ai_type`) VALUES ('" + OwnerId + "', '" + CataBot.Name + "', '" + CataBot.Motto + "', '" + CataBot.Figure + "', '" + CataBot.Gender + "', '" + CataBot.AIType + "')");
int Id = Convert.ToInt32(dbClient.InsertQuery());
dbClient.SetQuery("SELECT `id`,`user_id`,`name`,`motto`,`look`,`gender` FROM `bots` WHERE `user_id` = '" + OwnerId + "' AND `id` = '" + Id + "' LIMIT 1");
BotData = dbClient.getRow();
}
return(new Bot(Convert.ToInt32(BotData["id"]), Convert.ToInt32(BotData["user_id"]), Convert.ToString(BotData["name"]), Convert.ToString(BotData["motto"]), Convert.ToString(BotData["look"]), Convert.ToString(BotData["gender"])));
}
public void Init()
{
if (_responses.Count > 0)
{
_responses.Clear();
}
using (IQueryAdapter dbClient = BiosEmuThiago.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("SELECT `bot_ai`,`chat_keywords`,`response_text`,`response_mode`,`response_beverage` FROM `bots_responses`");
DataTable BotResponses = dbClient.getTable();
if (BotResponses != null)
{
foreach (DataRow Response in BotResponses.Rows)
{
_responses.Add(new BotResponse(Convert.ToString(Response["bot_ai"]), Convert.ToString(Response["chat_keywords"]), Convert.ToString(Response["response_text"]), Response["response_mode"].ToString(), Convert.ToString(Response["response_beverage"])));
}
}
}
}
public void Init()
{
DataTable Table = null;
using (IQueryAdapter dbClient = BiosEmuThiago.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("SELECT * FROM `questions`");
Table = dbClient.getTable();
}
if (Table != null)
{
foreach (DataRow Row in Table.Rows)
{
if (!this._questions.ContainsKey(Convert.ToInt32(Row["id"])))
{
this._questions.TryAdd(Convert.ToInt32(Row["id"]), new Question());
}
}
}
}
public void InitWords()
{
if (this._filteredWords.Count > 0)
{
this._filteredWords.Clear();
}
DataTable Data = null;
using (var dbClient = BiosEmuThiago.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("SELECT word FROM `wordfilter`");
Data = dbClient.getTable();
if (Data != null)
{
foreach (DataRow Row in Data.Rows)
{
this._filteredWords.Add(Convert.ToString(Row["word"]));
}
}
}
}
public void Execute(GameClients.GameClient Session, Rooms.Room Room, string[] Params)
{
if (ExtraSettings.STAFF_EFFECT_ENABLED_ROOM)
{
if (Session.GetHabbo().isLoggedIn&& Session.GetHabbo().Rank > Convert.ToInt32(BiosEmuThiago.GetConfig().data["MineRankStaff"]))
{
}
else
{
Session.SendWhisper("Você precisa estar logado como staff para usar este comando.");
return;
}
}
RoomUser User = Room.GetRoomUserManager().GetRoomUserByHabbo(Session.GetHabbo().Id);
if (User == null)
{
return;
}
if (Params.Length == 1)
{
Session.SendWhisper("Oh, não se esqueça de inserir o nome do bot!");
return;
}
if (Params.Length == 2)
{
Session.SendWhisper("Oh, esqueceu-se de introduzir um ID!");
return;
}
string BotName = CommandManager.MergeParams(Params, 1);
string Bubble = CommandManager.MergeParams(Params, 2);
using (IQueryAdapter dbClient = BiosEmuThiago.GetDatabaseManager().GetQueryReactor())
{
dbClient.runFastQuery("UPDATE `bots` SET `chat_bubble` = '" + Params[2] + "' WHERE `name` = '" + Params[1] + "' AND `room_id` = '" + Session.GetHabbo().CurrentRoomId + "'");
Session.LogsNotif("Você mudou a fala do bot: " + Params[1] + "!", "command_notification");
}
}
public void Parse(HabboHotel.GameClients.GameClient Session, ClientPacket Packet)
{
if (!Session.GetHabbo().InRoom)
{
return;
}
Room Room = null;
if (!BiosEmuThiago.GetGame().GetRoomManager().TryGetRoom(Session.GetHabbo().CurrentRoomId, out Room))
{
return;
}
int PetId = Packet.PopInt();
RoomUser Pet = null;
if (!Room.GetRoomUserManager().TryGetPet(PetId, out Pet))
{
return;
}
if (Pet.PetData.AnyoneCanRide == 1)
{
Pet.PetData.AnyoneCanRide = 0;
}
else
{
Pet.PetData.AnyoneCanRide = 1;
}
using (IQueryAdapter dbClient = BiosEmuThiago.GetDatabaseManager().GetQueryReactor())
{
dbClient.runFastQuery("UPDATE `bots_petdata` SET `anyone_ride` = '" + Pet.PetData.AnyoneCanRide + "' WHERE `id` = '" + PetId + "' LIMIT 1");
}
Room.SendMessage(new PetInformationComposer(Pet.PetData));
}
public void Init()
{
this._bases.Clear();
this._symbols.Clear();
this._baseColours.Clear();
this._symbolColours.Clear();
this._backgroundColours.Clear();
using (IQueryAdapter dbClient = BiosEmuThiago.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("SELECT `id`,`type`,`firstvalue`,`secondvalue` FROM `groups_items` WHERE `enabled` = '1'");
DataTable dItems = dbClient.getTable();
foreach (DataRow dRow in dItems.Rows)
{
switch (dRow["type"].ToString())
{
case "base":
this._bases.Add(new GroupBadgeParts(Convert.ToInt32(dRow["id"]), dRow["firstvalue"].ToString(), dRow["secondvalue"].ToString()));
break;
case "symbol":
this._symbols.Add(new GroupBadgeParts(Convert.ToInt32(dRow["id"]), dRow["firstvalue"].ToString(), dRow["secondvalue"].ToString()));
break;
case "color":
this._baseColours.Add(new GroupColours(Convert.ToInt32(dRow["id"]), dRow["firstvalue"].ToString()));
break;
case "color2":
this._symbolColours.Add(Convert.ToInt32(dRow["id"]), new GroupColours(Convert.ToInt32(dRow["id"]), dRow["firstvalue"].ToString()));
break;
case "color3":
this._backgroundColours.Add(Convert.ToInt32(dRow["id"]), new GroupColours(Convert.ToInt32(dRow["id"]), dRow["firstvalue"].ToString()));
break;
}
}
}
}
public void UpdatePreset(int Preset, string Color, int Intensity, bool BgOnly, bool Hax = false)
{
if (!IsValidColor(Color) || !IsValidIntensity(Intensity) && !Hax)
{
return;
}
string Pr;
switch (Preset)
{
case 3:
Pr = "three";
break;
case 2:
Pr = "two";
break;
case 1:
default:
Pr = "one";
break;
}
using (IQueryAdapter dbClient = BiosEmuThiago.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("UPDATE room_items_moodlight SET preset_" + Pr + " = '@color," + Intensity + "," + BiosEmuThiago.BoolToEnum(BgOnly) + "' WHERE item_id = '" + ItemId + "' LIMIT 1");
dbClient.AddParameter("color", Color);
dbClient.RunQuery();
}
GetPreset(Preset).ColorCode = Color;
GetPreset(Preset).ColorIntensity = Intensity;
GetPreset(Preset).BackgroundOnly = BgOnly;
}
public void Parse(HabboHotel.GameClients.GameClient Session, ClientPacket Packet)
{
Room Room = Session.GetHabbo().CurrentRoom;
if (Room == null || !Room.CheckRights(Session, true))
{
return;
}
int ItemId = Packet.PopInt();
string Name = Packet.PopString();
Item Item = Session.GetHabbo().CurrentRoom.GetRoomItemHandler().GetItem(ItemId);
if (Item == null)
{
return;
}
if (Item.ExtraData.Contains(Convert.ToChar(5)))
{
string[] Flags = Item.ExtraData.Split(Convert.ToChar(5));
Item.ExtraData = Flags[0] + Convert.ToChar(5) + Flags[1] + Convert.ToChar(5) + Name;
}
else
{
Item.ExtraData = "m" + Convert.ToChar(5) + ".ch-210-1321.lg-285-92" + Convert.ToChar(5) + "Default Mannequin";
}
using (IQueryAdapter dbClient = BiosEmuThiago.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("UPDATE `items` SET `extra_data` = @Ed WHERE `id` = @itemId LIMIT 1");
dbClient.AddParameter("itemId", Item.Id);
dbClient.AddParameter("Ed", Item.ExtraData);
dbClient.RunQuery();
}
Item.UpdateState(true, true);
}
public bool TryCreateGroup(Habbo Player, string Name, string Description, int RoomId, string Badge, int Colour1, int Colour2, out Group Group)
{
Group = new Group(0, Name, Description, Badge, RoomId, Player.Id, (int)BiosEmuThiago.GetUnixTimestamp(), 0, Colour1, Colour2, 0, false, false);
if (string.IsNullOrWhiteSpace(Name) || string.IsNullOrWhiteSpace(Badge))
{
return(false);
}
using (IQueryAdapter dbClient = BiosEmuThiago.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("INSERT INTO `groups` (`name`, `desc`, `badge`, `owner_id`, `created`, `room_id`, `state`, `colour1`, `colour2`, `admindeco`) VALUES (@name, @desc, @badge, @owner, UNIX_TIMESTAMP(), @room, '0', @colour1, @colour2, '0')");
dbClient.AddParameter("name", Group.Name);
dbClient.AddParameter("desc", Group.Description);
dbClient.AddParameter("owner", Group.CreatorId);
dbClient.AddParameter("badge", Group.Badge);
dbClient.AddParameter("room", Group.RoomId);
dbClient.AddParameter("colour1", Group.Colour1);
dbClient.AddParameter("colour2", Group.Colour2);
Group.Id = Convert.ToInt32(dbClient.InsertQuery());
Group.AddMember(Player.Id);
Group.MakeAdmin(Player.Id);
if (!this._groups.TryAdd(Group.Id, Group))
{
return(false);
}
else
{
dbClient.SetQuery("UPDATE `rooms` SET `group_id` = @gid WHERE `id` = @rid LIMIT 1");
dbClient.AddParameter("gid", Group.Id);
dbClient.AddParameter("rid", Group.RoomId);
dbClient.RunQuery();
dbClient.runFastQuery("DELETE FROM `room_rights` WHERE `room_id` = '" + RoomId + "'");
}
}
return(true);
}
public void InitCharacters()
{
if (this._filterReplacements.Count > 0)
{
this._filterReplacements.Clear();
}
DataTable Data = null;
using (var dbClient = BiosEmuThiago.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("SELECT * FROM `wordfilter_characters`");
Data = dbClient.getTable();
if (Data != null)
{
foreach (DataRow Row in Data.Rows)
{
this._filterReplacements.Add(new WordFilterReplacements(Convert.ToString(Row["character"]),
Convert.ToString(Row["replacement"])));
}
}
}
}
public void LoadBans()
{
this.Bans = new Dictionary <int, double>();
DataTable Bans;
using (IQueryAdapter dbClient = BiosEmuThiago.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("SELECT user_id, expire FROM room_bans WHERE room_id = " + Id);
Bans = dbClient.getTable();
}
if (Bans == null)
{
return;
}
foreach (DataRow ban in Bans.Rows)
{
this.Bans.Add(Convert.ToInt32(ban[0]), Convert.ToDouble(ban[1]));
}
}
public static List <Bot> GetBotsForUser(int UserId)
{
List <Bot> B = new List <Bot>();
DataTable dBots = null;
using (IQueryAdapter dbClient = BiosEmuThiago.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("SELECT `id`,`user_id`,`name`,`motto`,`look`,`gender`FROM `bots` WHERE `user_id` = '" + UserId + "' AND `room_id` = '0' AND `ai_type` != 'pet'");
dBots = dbClient.getTable();
if (dBots != null)
{
foreach (DataRow dRow in dBots.Rows)
{
B.Add(new Bot(Convert.ToInt32(dRow["id"]), Convert.ToInt32(dRow["user_id"]), Convert.ToString(dRow["name"]),
Convert.ToString(dRow["motto"]), Convert.ToString(dRow["look"]), Convert.ToString(dRow["gender"])));
}
}
}
return(B);
}
public static List <Item> CreateMultipleItems(ItemData Data, Habbo Habbo, string ExtraData, int Amount, int GroupId = 0)
{
if (Data == null)
{
throw new InvalidOperationException("Data cannot be null.");
}
List <Item> Items = new List <Item>();
using (IQueryAdapter dbClient = BiosEmuThiago.GetDatabaseManager().GetQueryReactor())
{
for (int i = 0; i < Amount; i++)
{
dbClient.SetQuery("INSERT INTO `items` (base_item,user_id,room_id,x,y,z,wall_pos,rot,extra_data) VALUES(@did,@uid,@rid,@x,@y,@z,@wallpos,@rot,@flags);");
dbClient.AddParameter("did", Data.Id);
dbClient.AddParameter("uid", Habbo.Id);
dbClient.AddParameter("rid", 0);
dbClient.AddParameter("x", 0);
dbClient.AddParameter("y", 0);
dbClient.AddParameter("z", 0);
dbClient.AddParameter("wallpos", "");
dbClient.AddParameter("rot", 0);
dbClient.AddParameter("flags", ExtraData);
Item Item = new Item(Convert.ToInt32(dbClient.InsertQuery()), 0, Data.Id, ExtraData, 0, 0, 0, 0, Habbo.Id, GroupId, 0, 0, "");
if (GroupId > 0)
{
dbClient.SetQuery("INSERT INTO `items_groups` (`id`, `group_id`) VALUES (@id, @gid)");
dbClient.AddParameter("id", Item.Id);
dbClient.AddParameter("gid", GroupId);
dbClient.RunQuery();
}
Items.Add(Item);
}
}
return(Items);
}
public void LoadModel(string Id)
{
DataRow Row = null;
using (IQueryAdapter dbClient = BiosEmuThiago.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("SELECT id,door_x,door_y,door_z,door_dir,heightmap,public_items,club_only,poolmap,`wall_height` FROM `room_models` WHERE `custom` = '1' AND `id` = '" + Id + "' LIMIT 1");
Row = dbClient.getRow();
if (Row == null)
{
return;
}
string Modelname = Convert.ToString(Row["id"]);
if (!this._roomModels.ContainsKey(Id))
{
this._roomModels.Add(Modelname, new RoomModel(Convert.ToInt32(Row["door_x"]), Convert.ToInt32(Row["door_y"]), Convert.ToDouble(Row["door_z"]), Convert.ToInt32(Row["door_dir"]),
Convert.ToString(Row["heightmap"]), Convert.ToString(Row["public_items"]), BiosEmuThiago.EnumToBool(Row["club_only"].ToString()), Convert.ToString(Row["poolmap"]), Convert.ToInt32(Row["wall_height"])));
}
}
}
public void Execute(GameClients.GameClient Session, Rooms.Room Room, string[] Params)
{
if (Params.Length == 1)
{
Session.SendWhisper("Por favor, coloque o nome do usuário que deseja copiar!");
return;
}
GameClient TargetClient = BiosEmuThiago.GetGame().GetClientManager().GetClientByUsername(Params[1]);
DataRow Table;
using (IQueryAdapter dbClient = BiosEmuThiago.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("SELECT * FROM `users` WHERE username = '******' LIMIT 1");
Table = dbClient.getRow();
}
Session.GetHabbo().Gender = Table["gender"].ToString();
Session.GetHabbo().Look = Table["look"].ToString();
using (IQueryAdapter dbClient = BiosEmuThiago.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("UPDATE `users` SET `gender` = @gender, `look` = @look WHERE `id` = @id LIMIT 1");
dbClient.AddParameter("gender", Session.GetHabbo().Gender);
dbClient.AddParameter("look", Session.GetHabbo().Look);
dbClient.AddParameter("id", Session.GetHabbo().Id);
dbClient.RunQuery();
}
RoomUser User = Room.GetRoomUserManager().GetRoomUserByHabbo(Session.GetHabbo().Id);
if (User != null)
{
Session.SendMessage(new UserChangeComposer(User, true));
Room.SendMessage(new UserChangeComposer(User, false));
Session.SendMessage(new AvatarAspectUpdateMessageComposer(Session.GetHabbo().Look, Session.GetHabbo().Gender)); //esto
}
}
public void Parse(HabboHotel.GameClients.GameClient Session, ClientPacket Packet)
{
if (Session == null || Session.GetHabbo() == null || !Session.GetHabbo().GetPermissions().HasRight("mod_mute"))
{
return;
}
int UserId = Packet.PopInt();
string Message = Packet.PopString();
double Length = (Packet.PopInt() * 60);
string Unknown1 = Packet.PopString();
string Unknown2 = Packet.PopString();
Habbo Habbo = BiosEmuThiago.GetHabboById(UserId);
if (Habbo == null)
{
Session.SendWhisper("Ocorreu um erro em encontrar esse usuário no banco de dados.");
return;
}
if (Habbo.GetPermissions().HasRight("mod_mute") && !Session.GetHabbo().GetPermissions().HasRight("mod_mute_any"))
{
Session.SendWhisper("Ops, você não pode silenciar esse usuário.");
return;
}
using (IQueryAdapter dbClient = BiosEmuThiago.GetDatabaseManager().GetQueryReactor())
{
dbClient.runFastQuery("UPDATE `users` SET `time_muted` = '" + Length + "' WHERE `id` = '" + Habbo.Id + "' LIMIT 1");
}
if (Habbo.GetClient() != null)
{
Habbo.TimeMuted = Length;
Habbo.GetClient().SendNotification("Você foi silenciando por " + Length + " segundos!");
}
}
public RoomData GenerateRoomData(int RoomId)
{
if (_loadedRoomData.ContainsKey(RoomId))
{
return((RoomData)_loadedRoomData[RoomId]);
}
RoomData Data = new RoomData();
Room Room;
if (TryGetRoom(RoomId, out Room))
{
return(Room.RoomData);
}
DataRow Row = null;
using (IQueryAdapter dbClient = BiosEmuThiago.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("SELECT * FROM rooms WHERE id = " + RoomId + " LIMIT 1");
Row = dbClient.getRow();
}
if (Row == null)
{
return(null);
}
Data.Fill(Row);
if (!_loadedRoomData.ContainsKey(RoomId))
{
_loadedRoomData.TryAdd(RoomId, Data);
}
return(Data);
}
public void Init()
{
if (this._vouchers.Count > 0)
{
this._vouchers.Clear();
}
DataTable GetVouchers = null;
using (IQueryAdapter dbClient = BiosEmuThiago.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("SELECT `voucher`,`type`,`value`,`current_uses`,`max_uses` FROM `catalog_vouchers` WHERE `enabled` = '1'");
GetVouchers = dbClient.getTable();
}
if (GetVouchers != null)
{
foreach (DataRow Row in GetVouchers.Rows)
{
this._vouchers.Add(Convert.ToString(Row["voucher"]), new Voucher(Convert.ToString(Row["voucher"]), Convert.ToString(Row["type"]), Convert.ToInt32(Row["value"]), Convert.ToInt32(Row["current_uses"]), Convert.ToInt32(Row["max_uses"])));
}
}
}
public void Init()
{
if (_clothing.Count > 0)
{
_clothing.Clear();
}
DataTable GetClothing = null;
using (IQueryAdapter dbClient = BiosEmuThiago.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("SELECT `id`,`clothing_name`,`clothing_parts` FROM `catalog_clothing`");
GetClothing = dbClient.getTable();
}
if (GetClothing != null)
{
foreach (DataRow Row in GetClothing.Rows)
{
_clothing.Add(Convert.ToInt32(Row["id"]), new ClothingItem(Convert.ToInt32(Row["id"]), Convert.ToString(Row["clothing_name"]), Convert.ToString(Row["clothing_parts"])));
}
}
}
public void Parse(GameClient Session, ClientPacket Packet)
{
if (Session == null)
{
return;
}
int RoomId = Packet.PopInt();
if (Session.GetHabbo().FavoriteRooms.Count >= 30 || Session.GetHabbo().FavoriteRooms.Contains(RoomId))
{
// send packet that favourites is full.
return;
}
Session.GetHabbo().FavoriteRooms.Add(RoomId);
Session.SendMessage(new UpdateFavouriteRoomComposer(RoomId, true));
using (IQueryAdapter dbClient = BiosEmuThiago.GetDatabaseManager().GetQueryReactor())
{
dbClient.runFastQuery("INSERT INTO user_favorites (user_id,room_id) VALUES (" + Session.GetHabbo().Id + "," + RoomId + ")");
}
}
/// <summary>
/// Run a quick database check to see if this ban exists in the database.
/// </summary>
/// <param name="Username">The value of the ban.</param>
/// <returns></returns>
public bool UsernameBanCheck(string Username)
{
ModerationBan UsernameBanRecord = null;
if (BiosEmuThiago.GetGame().GetModerationManager().IsBanned(Username, out UsernameBanRecord))
{
DataRow BanRow = null;
using (IQueryAdapter dbClient = BiosEmuThiago.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("SELECT * FROM `bans` WHERE `bantype` = 'user' AND `value` = @value LIMIT 1");
dbClient.AddParameter("value", Username);
BanRow = dbClient.getRow();
//If there is no more ban record, then we can simply remove it from our cache!
if (BanRow == null)
{
BiosEmuThiago.GetGame().GetModerationManager().RemoveBan(Username);
return(false);
}
}
}
return(true);
}
private void LoadFilter()
{
this._wordFilterList = new List <string>();
DataTable Data = null;
using (IQueryAdapter dbClient = BiosEmuThiago.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("SELECT * FROM `room_filter` WHERE `room_id` = @roomid;");
dbClient.AddParameter("roomid", Id);
Data = dbClient.getTable();
}
if (Data == null)
{
return;
}
foreach (DataRow Row in Data.Rows)
{
this._wordFilterList.Add(Convert.ToString(Row["word"]));
}
}
public bool Init(Habbo player)
{
if (this._ignoredUsers.Count > 0)
{
return(false);
}
using (IQueryAdapter dbClient = BiosEmuThiago.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("SELECT * FROM `user_ignores` WHERE `user_id` = @uid;");
dbClient.AddParameter("uid", player.Id);
DataTable GetIgnores = dbClient.getTable();
if (GetIgnores != null)
{
foreach (DataRow Row in GetIgnores.Rows)
{
this._ignoredUsers.Add(Convert.ToInt32(Row["ignore_id"]));
}
}
}
return(true);
}
public void Init()
{
if (_settings.Count > 0)
{
_settings.Clear();
}
using (IQueryAdapter dbClient = BiosEmuThiago.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("SELECT * FROM `server_settings`");
DataTable Table = dbClient.getTable();
if (Table != null)
{
foreach (DataRow Row in Table.Rows)
{
_settings.Add(Row["key"].ToString().ToLower(), Row["value"].ToString().ToLower());
}
}
}
log.Info("» Pronto(s): " + _settings.Count + " configurações do servidor! - BY: Thiago Araujo");
}