public void Init() { if (_races.Count > 0) { _races.Clear(); } using (IQueryAdapter dbClient = NeonEnvironment.GetDatabaseManager().GetQueryReactor()) { dbClient.SetQuery("SELECT * FROM `catalog_pet_races`"); DataTable Table = dbClient.getTable(); if (Table != null) { foreach (DataRow Row in Table.Rows) { PetRace Race = new PetRace(Convert.ToInt32(Row["raceid"]), Convert.ToInt32(Row["color1"]), Convert.ToInt32(Row["color2"]), (Convert.ToString(Row["has1color"]) == "1"), (Convert.ToString(Row["has2color"]) == "1")); if (!_races.Contains(Race)) { _races.Add(Race); } } } } }
public void Execute(GameClient Session, Room Room, string[] Params) { if (Params.Length != 3) { Session.SendWhisper("Introduce el nombre del usuario a quien deseas enviar una placa!", 34); return; } GameClient TargetClient = NeonEnvironment.GetGame().GetClientManager().GetClientByUsername(Params[1]); if (TargetClient != null) { using (IQueryAdapter dbClient = NeonEnvironment.GetDatabaseManager().GetQueryReactor()) { dbClient.runFastQuery("UPDATE `users` SET `tag`= '" + Params[2] + "' WHERE `id` = '" + TargetClient.GetHabbo().Id + "'"); TargetClient.GetHabbo().Tags.Add(Params[2]); } Session.SendMessage(RoomNotificationComposer.SendBubble("definitions", "Has añadido el tag \"" + Params[2] + "\" a " + TargetClient.GetHabbo().Username + " correctamente.", "")); TargetClient.SendMessage(RoomNotificationComposer.SendBubble("definitions", Session.GetHabbo().Username + " te ha añadido el tag " + Params[2] + ".", "")); foreach (RoomUser RoomUser in Room.GetRoomUserManager().GetRoomUsers()) { RoomUser.GetClient().SendMessage(new UserTagsComposer(TargetClient.GetHabbo().Id, TargetClient)); } } }
public void Execute(GameClients.GameClient Session, Rooms.Room Room, string[] Params) { if (Room == null) { return; } //if (!NeonEnvironment.GetGame().GetCatalog().GetPredesignedRooms().Exists((uint)Room.Id)) //{ // Session.SendWhisper("La sala no existe en la lista."); // return; //} uint predesignedId = 0U; using (Database.Interfaces.IQueryAdapter dbClient = NeonEnvironment.GetDatabaseManager().GetQueryReactor()) { dbClient.SetQuery("SELECT id FROM catalog_predesigned_rooms WHERE room_id = " + Room.Id + ";"); predesignedId = (uint)dbClient.getInteger(); dbClient.runFastQuery("DELETE FROM catalog_predesigned_rooms WHERE room_id = " + Room.Id + " AND id = " + predesignedId + ";"); } NeonEnvironment.GetGame().GetCatalog().GetPredesignedRooms().predesignedRoom.Remove(predesignedId); Session.SendWhisper("La Sala se eliminó correctamente de la lista."); }
public bool Init(Habbo Player) { if (_savedSearches.Count > 0) { _savedSearches.Clear(); } DataTable GetSearches = null; using (IQueryAdapter dbClient = NeonEnvironment.GetDatabaseManager().GetQueryReactor()) { dbClient.SetQuery("SELECT `id`,`filter`,`search_code` FROM `user_saved_searches` WHERE `user_id` = @UserId"); dbClient.AddParameter("UserId", Player.Id); GetSearches = dbClient.getTable(); if (GetSearches != null) { foreach (DataRow Row in GetSearches.Rows) { _savedSearches.TryAdd(Convert.ToInt32(Row["id"]), new SavedSearch(Convert.ToInt32(Row["id"]), Convert.ToString(Row["filter"]), Convert.ToString(Row["search_code"]))); } } } return(true); }
public void Parse(HabboHotel.GameClients.GameClient Session, ClientPacket Packet) { int SlotId = Packet.PopInt(); string Look = NeonEnvironment.GetGame().GetAntiMutant().RunLook(Packet.PopString()); string Gender = Packet.PopString(); using (IQueryAdapter dbClient = NeonEnvironment.GetDatabaseManager().GetQueryReactor()) { dbClient.SetQuery("SELECT null FROM `user_wardrobe` WHERE `user_id` = " + Session.GetHabbo().Id + " AND `slot_id` = @slot"); dbClient.AddParameter("slot", SlotId); if (dbClient.getRow() != null) { dbClient.SetQuery("UPDATE `user_wardrobe` SET `look` = @look, `gender` = @gender WHERE `user_id` = '" + Session.GetHabbo().Id + "' AND `slot_id` = @slot LIMIT 1"); dbClient.AddParameter("slot", SlotId); dbClient.AddParameter("look", Look); dbClient.AddParameter("gender", Gender.ToUpper()); dbClient.RunQuery(); } else { dbClient.SetQuery("INSERT INTO `user_wardrobe` (`user_id`,`slot_id`,`look`,`gender`) VALUES ('" + Session.GetHabbo().Id + "',@slot,@look,@gender)"); dbClient.AddParameter("slot", SlotId); dbClient.AddParameter("look", Look); dbClient.AddParameter("gender", Gender.ToUpper()); dbClient.RunQuery(); } } }
public override void OnUserLeaveRoom(GameClient Client) { if (GetBotData() == null) { return; } _ = GetRoomUser(); if (Client.GetHabbo().CurrentRoom.OwnerId == Client.GetHabbo().Id) { DataTable getRoom; using (IQueryAdapter query = NeonEnvironment.GetDatabaseManager().GetQueryReactor()) { query.SetQuery("DELETE FROM room_visits WHERE roomid = @id"); query.AddParameter("id", Client.GetHabbo().CurrentRoom.RoomId); getRoom = query.getTable(); } } DataTable getUpdate; using (IQueryAdapter query = NeonEnvironment.GetDatabaseManager().GetQueryReactor()) { query.SetQuery("UPDATE room_visits SET gone = @gone WHERE roomid = @id AND username = @username"); query.AddParameter("gone", "se ha ido."); query.AddParameter("id", Client.GetHabbo().CurrentRoom.RoomId); query.AddParameter("username", Client.GetHabbo().Username); getUpdate = query.getTable(); } }
public void ClearLTDS() { UpdateItems(true); using (IQueryAdapter dbClient = NeonEnvironment.GetDatabaseManager().GetQueryReactor()) { dbClient.RunQuery("DELETE FROM items WHERE room_id='0' AND limited_number > 0 AND user_id = " + _userId); //Do join } foreach (KeyValuePair <int, Item> Fi in _floorItems) { if (Fi.Value.LimitedNo < 1) { continue; } _floorItems.Clear(); } foreach (KeyValuePair <int, Item> Wi in _wallItems) { if (Wi.Value.LimitedNo < 1) { continue; } _wallItems.Clear(); } if (_client != null) { _client.SendMessage(new FurniListUpdateComposer()); } }
public void Init() { _petCommands.Clear(); _commandRegister.Clear(); _commandDatabase.Clear(); DataTable Table = null; using (IQueryAdapter dbClient = NeonEnvironment.GetDatabaseManager().GetQueryReactor()) { dbClient.SetQuery("SELECT * FROM `bots_pet_commands`"); Table = dbClient.getTable(); if (Table != null) { foreach (DataRow row in Table.Rows) { _commandRegister.Add(Convert.ToInt32(row[0]), row[1].ToString()); _commandDatabase.Add(row[1] + ".input", row[2].ToString()); } } } foreach (KeyValuePair <int, string> pair in _commandRegister) { int commandID = pair.Key; string commandStringedID = pair.Value; string[] commandInput = _commandDatabase[commandStringedID + ".input"].Split(','); foreach (string command in commandInput) { _petCommands.Add(command, new PetCommand(commandID, command)); } } }
public static List <Item> GetItemsForUser(int UserId) { DataTable Items = null; List <Item> I = new List <Item>(); using (IQueryAdapter dbClient = NeonEnvironment.GetDatabaseManager().GetQueryReactor()) { dbClient.SetQuery("SELECT `items`.*, COALESCE(`items_groups`.`group_id`, 0) AS `group_id` FROM `items` LEFT OUTER JOIN `items_groups` ON `items`.`id` = `items_groups`.`id` WHERE `items`.`room_id` = 0 AND `items`.`user_id` = @uid;"); dbClient.AddParameter("uid", UserId); Items = dbClient.getTable(); if (Items != null) { foreach (DataRow Row in Items.Rows) { if (NeonEnvironment.GetGame().GetItemManager().GetItem(Convert.ToInt32(Row["base_item"]), out ItemData Data)) { I.Add(new Item(Convert.ToInt32(Row["id"]), Convert.ToInt32(Row["room_id"]), Convert.ToInt32(Row["base_item"]), Convert.ToString(Row["extra_data"]), Convert.ToInt32(Row["x"]), Convert.ToInt32(Row["y"]), Convert.ToDouble(Row["z"]), Convert.ToInt32(Row["rot"]), Convert.ToInt32(Row["user_id"]), Convert.ToInt32(Row["group_id"]), Convert.ToInt32(Row["limited_number"]), Convert.ToInt32(Row["limited_stack"]), Convert.ToString(Row["wall_pos"]))); } else { // Item data does not exist anymore. } } } } return(I); }
public int AvgPriceForSprite(int SpriteID) { int num = 0; int num2 = 0; if (MarketAverages.ContainsKey(SpriteID) && MarketCounts.ContainsKey(SpriteID)) { if (MarketCounts[SpriteID] > 0) { return(MarketAverages[SpriteID] / MarketCounts[SpriteID]); } return(0); } using (IQueryAdapter dbClient = NeonEnvironment.GetDatabaseManager().GetQueryReactor()) { dbClient.SetQuery("SELECT `avgprice` FROM `catalog_marketplace_data` WHERE `sprite` = '" + SpriteID + "' LIMIT 1"); num = dbClient.getInteger(); dbClient.SetQuery("SELECT `sold` FROM `catalog_marketplace_data` WHERE `sprite` = '" + SpriteID + "' LIMIT 1"); num2 = dbClient.getInteger(); } MarketAverages.Add(SpriteID, num); MarketCounts.Add(SpriteID, num2); if (num2 > 0) { return(Convert.ToInt32(Math.Ceiling((double)(num / num2)))); } return(0); }
public TonerData(int Item) { ItemId = Item; DataRow Row; using (IQueryAdapter dbClient = NeonEnvironment.GetDatabaseManager().GetQueryReactor()) { dbClient.SetQuery("SELECT enabled,data1,data2,data3 FROM room_items_toner WHERE id=" + ItemId + " LIMIT 1"); Row = dbClient.getRow(); } if (Row == null) { //throw new NullReferenceException("No toner data found in the database for " + ItemId); using (IQueryAdapter dbClient = NeonEnvironment.GetDatabaseManager().GetQueryReactor()) { dbClient.RunQuery("INSERT INTO `room_items_toner` VALUES (" + ItemId + ",'0',0,0,0)"); dbClient.SetQuery("SELECT enabled,data1,data2,data3 FROM room_items_toner WHERE id=" + ItemId + " LIMIT 1"); Row = dbClient.getRow(); } } Enabled = int.Parse(Row[0].ToString()); Hue = Convert.ToInt32(Row[1]); Saturation = Convert.ToInt32(Row[2]); Lightness = Convert.ToInt32(Row[3]); }
public static Item CreateGiftItem(ItemData Data, Habbo Habbo, string ExtraData, string DisplayFlags, int ItemId, int LimitedNumber = 0, int LimitedStack = 0) { if (Data == null) { throw new InvalidOperationException("Data cannot be null."); } Item Item = new Item(ItemId, 0, Data.Id, ExtraData, 0, 0, 0, 0, Habbo.Id, 0, LimitedNumber, LimitedStack, ""); using (IQueryAdapter dbClient = NeonEnvironment.GetDatabaseManager().GetQueryReactor()) { dbClient.SetQuery("INSERT INTO `items` (`id`,base_item,user_id,room_id,x,y,z,wall_pos,rot,extra_data,`limited_number`,`limited_stack`) VALUES (@id, @did,@uid,@rid,@x,@y,@z,@wall_pos,@rot,@extra_data, @limited_number, @limited_stack)"); dbClient.AddParameter("id", ItemId); 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("wall_pos", ""); dbClient.AddParameter("rot", 0); dbClient.AddParameter("extra_data", ExtraData); dbClient.AddParameter("limited_number", LimitedNumber); dbClient.AddParameter("limited_stack", LimitedStack); dbClient.RunQuery(); return(Item); } }
public RoomPollQuestion(int id, int pollId, string question, string type, int seriesOrder, int minimumSlections) { Id = id; PollId = pollId; Question = question; Type = RoomPollQuestionTypeUtility.GetQuestionType(type); SeriesOrder = seriesOrder; MinimumSlections = minimumSlections; _selections = new Dictionary <int, RoomPollQuestionSelection>(); DataTable GetSelections = null; using (IQueryAdapter dbClient = NeonEnvironment.GetDatabaseManager().GetQueryReactor()) { dbClient.SetQuery("SELECT * FROM `room_poll_questions_selections` WHERE `question_id` = @QuestionId"); dbClient.AddParameter("QuestionId", Id); GetSelections = dbClient.getTable(); if (GetSelections != null) { foreach (DataRow Row in GetSelections.Rows) { if (!_selections.ContainsKey(Convert.ToInt32(Row["id"]))) { _selections.Add(Convert.ToInt32(Row["id"]), new RoomPollQuestionSelection(Convert.ToInt32(Row["id"]), Id, Convert.ToString(Row["text"]), Convert.ToString(Row["value"]))); } } } } }
public void GiveBadge(string Badge, bool InDatabase, GameClient Session) { if (HasBadge(Badge)) { return; } if (InDatabase) { using (IQueryAdapter dbClient = NeonEnvironment.GetDatabaseManager().GetQueryReactor()) { dbClient.SetQuery("INSERT INTO user_badges (user_id,badge_id,badge_slot) VALUES (" + _player.Id + ",@badge," + 0 + ")"); dbClient.AddParameter("badge", Badge); dbClient.RunQuery(); } } _badges.Add(Badge, new Badge(Badge, 0)); if (Session != null) { Session.SendMessage(new BadgesComposer(Session)); Session.SendMessage(new FurniListNotificationComposer(1, 4)); } }
public void Execute(GameClients.GameClient Session, Rooms.Room Room, string[] Params) { if (!Room.CheckRights(Session, true)) { return; } if (Params.Length == 1) { Session.SendWhisper("Ingresa que velocidad desea para los roller."); return; } if (int.TryParse(Params[1], out int Speed)) { Session.GetHabbo().CurrentRoom.GetRoomItemHandler().SetSpeed(Speed); using (IQueryAdapter dbClient = NeonEnvironment.GetDatabaseManager().GetQueryReactor()) { dbClient.RunQuery("UPDATE `rooms` SET `roller_speed` = " + Speed + " WHERE `id` = '" + Room.Id + "' LIMIT 1"); } } else { Session.SendWhisper("Cantidad invalida, solo es permitido en numeros."); } }
public MoodlightData(int ItemId) { this.ItemId = ItemId; DataRow Row = null; using (IQueryAdapter dbClient = NeonEnvironment.GetDatabaseManager().GetQueryReactor()) { dbClient.SetQuery("SELECT enabled,current_preset,preset_one,preset_two,preset_three FROM room_items_moodlight WHERE item_id = '" + ItemId + "' LIMIT 1"); Row = dbClient.getRow(); } if (Row == null) { using (IQueryAdapter dbClient = NeonEnvironment.GetDatabaseManager().GetQueryReactor()) { dbClient.RunQuery("INSERT INTO `room_items_moodlight` (item_id,enabled,current_preset,preset_one,preset_two,preset_three) VALUES (" + ItemId + ",0,1,'#000000,255,0','#000000,255,0','#000000,255,0')"); dbClient.SetQuery("SELECT enabled,current_preset,preset_one,preset_two,preset_three FROM room_items_moodlight WHERE item_id=" + ItemId + " LIMIT 1"); Row = dbClient.getRow(); } } Enabled = NeonEnvironment.EnumToBool(Row["enabled"].ToString()); CurrentPreset = Convert.ToInt32(Row["current_preset"]); Presets = new List <MoodlightPreset> { GeneratePreset(Convert.ToString(Row["preset_one"])), GeneratePreset(Convert.ToString(Row["preset_two"])), GeneratePreset(Convert.ToString(Row["preset_three"])) }; }
public void Parse(GameClient Session, ClientPacket Packet) { string username = Packet.PopString(); Habbo targetData = NeonEnvironment.GetHabboByUsername(username); if (targetData == null) { Session.SendNotification("Ha ocurrido un error buscando el perfil del usuario."); return; } List <Group> groups = NeonEnvironment.GetGame().GetGroupManager().GetGroupsForUser(targetData.Id); int friendCount = 0; using (IQueryAdapter dbClient = NeonEnvironment.GetDatabaseManager().GetQueryReactor()) { dbClient.SetQuery("SELECT COUNT(0) FROM `messenger_friendships` WHERE (`user_one_id` = @userid OR `user_two_id` = @userid)"); dbClient.AddParameter("userid", targetData.Id); friendCount = dbClient.getInteger(); } Session.SendMessage(new ProfileInformationComposer(targetData, Session, groups, friendCount)); }
public void Init() { if (_leaderboards.Count > 0) { _leaderboards.Clear(); } using (IQueryAdapter dbClient = NeonEnvironment.GetDatabaseManager().GetQueryReactor()) { DataTable GetData = null; dbClient.SetQuery("SELECT * FROM `games_leaderboard`"); GetData = dbClient.getTable(); if (GetData != null) { foreach (DataRow Row in GetData.Rows) { LeaderBoardData value = new LeaderBoardData(Convert.ToInt32(Row["game_id"]), Convert.ToInt32(Row["user_id"]), Convert.ToInt32(Row["points"]), Convert.ToInt32(Row["record"]), Convert.ToInt32(Row["week"]), Convert.ToInt32(Row["year"])); _leaderboards.Add(Convert.ToInt32(Row["id"]), value); } } } log.Info(">> LeaderBoardData Manager -> READY!"); }
public void Parse(HabboHotel.GameClients.GameClient Session, ClientPacket Packet) { int CreditsOwed = 0; DataTable Table = null; using (IQueryAdapter dbClient = NeonEnvironment.GetDatabaseManager().GetQueryReactor()) { dbClient.SetQuery("SELECT `asking_price` FROM `catalog_marketplace_offers` WHERE `user_id` = '" + Session.GetHabbo().Id + "' AND state = '2'"); Table = dbClient.getTable(); } if (Table != null) { foreach (DataRow row in Table.Rows) { CreditsOwed += Convert.ToInt32(row["asking_price"]); } if (CreditsOwed >= 1) { Session.GetHabbo().Duckets += CreditsOwed; Session.SendMessage(new HabboActivityPointNotificationComposer(Session.GetHabbo().Duckets, CreditsOwed)); } using (IQueryAdapter dbClient = NeonEnvironment.GetDatabaseManager().GetQueryReactor()) { dbClient.RunQuery("DELETE FROM `catalog_marketplace_offers` WHERE `user_id` = '" + Session.GetHabbo().Id + "' AND `state` = '2'"); } } }
public void RemoveFromDatabase() { using (IQueryAdapter dbClient = NeonEnvironment.GetDatabaseManager().GetQueryReactor()) { dbClient.RunQuery("DELETE FROM room_items_songs WHERE itemid = " + itemID); } }
public Item AddNewItem(int Id, int BaseItem, string ExtraData, int Group, bool ToInsert, bool FromRoom, int LimitedNumber, int LimitedStack) { if (ToInsert) { if (FromRoom) { using (IQueryAdapter dbClient = NeonEnvironment.GetDatabaseManager().GetQueryReactor()) { dbClient.RunQuery("UPDATE `items` SET `base_item` = " + BaseItem + ", `room_id` = 0, `user_id` = " + _userId + " WHERE `id` = " + Id); } } else { using (IQueryAdapter dbClient = NeonEnvironment.GetDatabaseManager().GetQueryReactor()) { if (Id > 0) { dbClient.RunQuery("INSERT INTO `items` (`id`,`base_item`, `extradata`, `user_id`, `limited_number`, `limited_stack`) VALUES ('" + Id + "', '" + BaseItem + "', '" + ExtraData + "', '" + _userId + "', '" + LimitedNumber + "', '" + LimitedStack + "')"); } else { dbClient.SetQuery("INSERT INTO `items` (`base_item`, `user_id`, `extra_data`, `limited_number`, `limited_stack`) VALUES ('" + BaseItem + "', '" + _userId + "', '" + ExtraData + "', '" + LimitedNumber + "', '" + LimitedStack + "')"); Id = Convert.ToInt32(dbClient.InsertQuery()); } SendNewItems(Convert.ToInt32(Id)); if (Group > 0) { dbClient.RunQuery("INSERT INTO `items_groups` VALUES (" + Id + ", " + Group + ")"); } if (!string.IsNullOrEmpty(ExtraData)) { dbClient.SetQuery("UPDATE `items` SET `extra_data` = @extradata WHERE `id` = '" + Id + "' LIMIT 1"); dbClient.AddParameter("extradata", ExtraData); dbClient.RunQuery(); } } } } Item ItemToAdd = new Item(Id, 0, BaseItem, ExtraData, 0, 0, 0, 0, _userId, Group, LimitedNumber, LimitedStack, string.Empty); if (UserHoldsItem(Id)) { RemoveItem(Id); } if (ItemToAdd.IsWallItem) { _wallItems.TryAdd(ItemToAdd.Id, ItemToAdd); } else { _floorItems.TryAdd(ItemToAdd.Id, ItemToAdd); } return(ItemToAdd); }
public WardrobeComposer(GameClient Session) : base(ServerPacketHeader.WardrobeMessageComposer) { base.WriteInteger(1); using (IQueryAdapter dbClient = NeonEnvironment.GetDatabaseManager().GetQueryReactor()) { dbClient.SetQuery("SELECT `slot_id`,`look`,`gender` FROM `user_wardrobe` WHERE `user_id` = '" + Session.GetHabbo().Id + "'"); DataTable WardrobeData = dbClient.getTable(); if (WardrobeData == null) { base.WriteInteger(0); } else { base.WriteInteger(WardrobeData.Rows.Count); foreach (DataRow Row in WardrobeData.Rows) { base.WriteInteger(Convert.ToInt32(Row["slot_id"])); base.WriteString(Convert.ToString(Row["look"])); base.WriteString(Row["gender"].ToString().ToUpper()); } } } }
public void Init() { if (_clothing.Count > 0) { _clothing.Clear(); } DataTable GetClothing = null; using (Database.Interfaces.IQueryAdapter dbClient = NeonEnvironment.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(HabboHotel.GameClients.GameClient Session, ClientPacket Packet) { int GroupId = Packet.PopInt(); string Name = Packet.PopString(); Name = NeonEnvironment.GetGame().GetChatManager().GetFilter().IsUnnaceptableWord(Name, out string word) ? "Spam" : Name; string Desc = Packet.PopString(); Desc = NeonEnvironment.GetGame().GetChatManager().GetFilter().IsUnnaceptableWord(Desc, out word) ? "Spam" : Desc; if (!NeonEnvironment.GetGame().GetGroupManager().TryGetGroup(GroupId, out Group Group)) { return; } if (Group.CreatorId != Session.GetHabbo().Id) { return; } using (IQueryAdapter dbClient = NeonEnvironment.GetDatabaseManager().GetQueryReactor()) { dbClient.SetQuery("UPDATE `groups` SET `name`= @name, `desc` = @desc WHERE `id` = '" + GroupId + "' LIMIT 1"); dbClient.AddParameter("name", Name); dbClient.AddParameter("desc", Desc); dbClient.RunQuery(); } Group.Name = Name; Group.Description = Desc; Session.SendMessage(new GroupInfoComposer(Group, Session)); }
public void Init() { _items = new Dictionary <int, RentableSpaceItem>(); using (IQueryAdapter con = NeonEnvironment.GetDatabaseManager().GetQueryReactor()) { con.SetQuery("SELECT * FROM `items_rentablespace`"); DataTable table = con.getTable(); if (table != null) { for (int i = 0; i < table.Rows.Count; i++) { DataRow row = table.Rows[i]; if (row != null) { int id = Convert.ToInt32(row["item_id"].ToString()); int ownerid = Convert.ToInt32(row["owner"].ToString()); string ownername = ""; if (ownerid > 0) { Habbo owner = NeonEnvironment.GetHabboById(ownerid); if (owner != null) { ownername = owner.Username; } } int expirestamp = Convert.ToInt32(row["expire"].ToString()); int price = Convert.ToInt32(row["price"].ToString()); AddItem(new RentableSpaceItem(id, ownerid, ownername, expirestamp, price)); } } } } }
public void Init() { if (_subscriptions.Count > 0) { _subscriptions.Clear(); } using (IQueryAdapter dbClient = NeonEnvironment.GetDatabaseManager().GetQueryReactor()) { dbClient.SetQuery("SELECT * FROM `subscriptions`;"); DataTable GetSubscriptions = dbClient.getTable(); if (GetSubscriptions != null) { foreach (DataRow Row in GetSubscriptions.Rows) { if (!_subscriptions.ContainsKey(Convert.ToInt32(Row["id"]))) { _subscriptions.Add(Convert.ToInt32(Row["id"]), new SubscriptionData(Convert.ToInt32(Row["id"]), Convert.ToString(Row["name"]), Convert.ToString(Row["badge_code"]), Convert.ToInt32(Row["credits"]), Convert.ToInt32(Row["duckets"]), Convert.ToInt32(Row["respects"]))); } } } } //log.Info(">> Subscription Manager " + this._subscriptions.Count + " loaded."); log.Info(">> Subscription Manager -> READY!"); }
public void Disconnect() { try { if (GetHabbo() != null) { using (IQueryAdapter dbClient = NeonEnvironment.GetDatabaseManager().GetQueryReactor()) { dbClient.RunQuery(GetHabbo().GetQueryString); } GetHabbo().OnDisconnect(); } } catch (Exception e) { Logging.LogException(e.ToString()); } if (!_disconnected) { if (_connection != null) { _connection.Dispose(); } _disconnected = true; } }
public void GetCurrentQuest(GameClient Session, ClientPacket Message) { if (!Session.GetHabbo().InRoom) { return; } Quest UserQuest = GetQuest(Session.GetHabbo().QuestLastCompleted); Quest NextQuest = GetNextQuestInSeries(UserQuest.Category, UserQuest.Number + 1); if (NextQuest == null) { return; } using (IQueryAdapter dbClient = NeonEnvironment.GetDatabaseManager().GetQueryReactor()) { dbClient.RunQuery("REPLACE INTO `user_quests`(`user_id`,`quest_id`) VALUES (" + Session.GetHabbo().Id + ", " + NextQuest.Id + ")"); dbClient.RunQuery("UPDATE `user_stats` SET `quest_id` = '" + NextQuest.Id + "' WHERE `id` = '" + Session.GetHabbo().Id + "' LIMIT 1"); } Session.GetHabbo().GetStats().QuestID = NextQuest.Id; GetList(Session, null); Session.SendMessage(new QuestStartedComposer(Session, NextQuest)); }
/// <summary> /// Initializes the EffectsComponent. /// </summary> /// <param name="UserId"></param> public bool Init(Habbo Habbo) { if (_allClothing.Count > 0) { return(false); } using (Database.Interfaces.IQueryAdapter dbClient = NeonEnvironment.GetDatabaseManager().GetQueryReactor()) { dbClient.SetQuery("SELECT `id`,`part_id`,`part` FROM `user_clothing` WHERE `user_id` = @id;"); dbClient.AddParameter("id", Habbo.Id); DataTable GetClothing = dbClient.getTable(); if (GetClothing != null) { foreach (DataRow Row in GetClothing.Rows) { _allClothing.TryAdd(Convert.ToInt32(Row["part_id"]), new ClothingParts(Convert.ToInt32(Row["id"]), Convert.ToInt32(Row["part_id"]), Convert.ToString(Row["part"]))); } } } _habbo = Habbo; return(true); }
public void Execute(GameClients.GameClient Session, Room Room, string[] Params) { if (!Room.CheckRights(Session, false, false)) { Session.SendWhisper("¡No tienes derechos en esa sala!", 34); return; } Room.HideWired = !Room.HideWired; if (Room.HideWired) { Session.SendWhisper("Wired está oculto.", 34); } else { Session.SendWhisper("Wired fue mostrado.", 34); } using (IQueryAdapter con = NeonEnvironment.GetDatabaseManager().GetQueryReactor()) { con.SetQuery("UPDATE `rooms` SET `hide_wired` = @enum WHERE `id` = @id LIMIT 1"); con.AddParameter("enum", NeonEnvironment.BoolToEnum(Room.HideWired)); con.AddParameter("id", Room.Id); con.RunQuery(); } _ = new List <ServerPacket>(); List <ServerPacket> list = Room.HideWiredMessages(Room.HideWired); Room.SendMessage(list); }