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"); }