/// <summary> /// Initializes a new instance of the <see cref="SongItem" /> class. /// </summary> /// <param name="item">The item.</param> public SongItem(UserItem item) { ItemId = item.Id; SongId = SoundMachineSongManager.GetSongId(item.SongCode); BaseItem = item.BaseItem; ExtraData = item.ExtraData; SongCode = item.SongCode; }
/// <summary> /// Takes the back item. /// </summary> /// <param name="userId">The user identifier.</param> /// <param name="item">The item.</param> internal void TakeBackItem(uint userId, UserItem item) { var tradeUser = GetTradeUser(userId); if (tradeUser == null || item == null || tradeUser.HasAccepted || _tradeStage != 1) { return; } ClearAccepted(); tradeUser.OfferedItems.Remove(item); UpdateTradeWindow(); }
/// <summary> /// Offers the item. /// </summary> /// <param name="userId">The user identifier.</param> /// <param name="item">The item.</param> internal void OfferItem(uint userId, UserItem item) { var tradeUser = GetTradeUser(userId); if (tradeUser == null || item == null || !item.BaseItem.AllowTrade || tradeUser.HasAccepted || _tradeStage != 1) { return; } ClearAccepted(); if (!tradeUser.OfferedItems.Contains(item)) { tradeUser.OfferedItems.Add(item); } UpdateTradeWindow(); }
/// <summary> /// Adds the new item. /// </summary> /// <param name="id">The identifier.</param> /// <param name="baseItem">The base item.</param> /// <param name="extraData">The extra data.</param> /// <param name="thGroup">The thGroup.</param> /// <param name="insert">if set to <c>true</c> [insert].</param> /// <param name="fromRoom">if set to <c>true</c> [from room].</param> /// <param name="limno">The limno.</param> /// <param name="limtot">The limtot.</param> /// <param name="songCode">The song code.</param> /// <returns>UserItem.</returns> internal UserItem AddNewItem(uint id, uint baseItem, string extraData, uint thGroup, bool insert, bool fromRoom, int limno, int limtot, string songCode = "") { _isUpdated = false; if (insert) { if (fromRoom) { using (var queryReactor = Azure.GetDatabaseManager().GetQueryReactor()) queryReactor.RunFastQuery("UPDATE items_rooms SET user_id = '" + UserId + "', room_id= '0' WHERE (id='" + id + "')"); } else { using (var queryReactor = Azure.GetDatabaseManager().GetQueryReactor()) { queryReactor.SetQuery($"INSERT INTO items_rooms (base_item, user_id, group_id) VALUES ('{baseItem}', '{UserId}', '{thGroup}');"); if (id == 0) id = ((uint) queryReactor.InsertQuery()); SendNewItems(id); if (!string.IsNullOrEmpty(extraData)) { queryReactor.SetQuery("UPDATE items_rooms SET extra_data = @extraData WHERE id = " + id); queryReactor.AddParameter("extraData", extraData); queryReactor.RunQuery(); } if (limno > 0) queryReactor.RunFastQuery($"INSERT INTO items_limited VALUES ('{id}', '{limno}', '{limtot}');"); if (!string.IsNullOrEmpty(songCode)) { queryReactor.SetQuery($"UPDATE items_rooms SET songcode='{songCode}' WHERE id='{id}' LIMIT 1"); queryReactor.RunQuery(); } } } } if (id == 0) return null; var userItem = new UserItem(id, baseItem, extraData, thGroup, songCode); if (UserHoldsItem(id)) RemoveItem(id, false); if (userItem.BaseItem.InteractionType == Interaction.MusicDisc) SongDisks.Add(userItem.Id, userItem); if (userItem.IsWallItem) _wallItems.Add(userItem.Id, userItem); else _floorItems.Add(userItem.Id, userItem); if (_mRemovedItems.Contains(id)) _mRemovedItems.Remove(id); if (!_mAddedItems.Contains(id)) _mAddedItems.Add(id, userItem); return userItem; }
/// <summary> /// Loads the inventory. /// </summary> internal void LoadInventory() { _floorItems.Clear(); _wallItems.Clear(); DataTable table; using (var queryReactor = Azure.GetDatabaseManager().GetQueryReactor()) { queryReactor.SetQuery("SELECT * FROM items_rooms WHERE user_id=@userid AND room_id='0' LIMIT 8000;"); queryReactor.AddParameter("userid", ((int) UserId)); table = queryReactor.GetTable(); } foreach (DataRow dataRow in table.Rows) { var id = Convert.ToUInt32(dataRow[0]); var itemId = Convert.ToUInt32(dataRow[3]); if (!Azure.GetGame().GetItemManager().ContainsItem(itemId)) continue; string extraData; if (!DBNull.Value.Equals(dataRow[4])) extraData = (string) dataRow[4]; else extraData = string.Empty; var group = Convert.ToUInt32(dataRow["group_id"]); string songCode; if (!DBNull.Value.Equals(dataRow["songcode"])) songCode = (string) dataRow["songcode"]; else songCode = string.Empty; var userItem = new UserItem(id, itemId, extraData, group, songCode); if (userItem.BaseItem.InteractionType == Interaction.MusicDisc && !SongDisks.Contains(id)) SongDisks.Add(id, userItem); if (userItem.IsWallItem) { if (!_wallItems.Contains(id)) _wallItems.Add(id, userItem); } else if (!_floorItems.Contains(id)) _floorItems.Add(id, userItem); } //SongDisks.Clear(); _inventoryPets.Clear(); _inventoryBots.Clear(); using (var queryReactor2 = Azure.GetDatabaseManager().GetQueryReactor()) { queryReactor2.SetQuery($"SELECT * FROM bots WHERE user_id = {UserId} AND room_id = 0"); var table2 = queryReactor2.GetTable(); if (table2 == null) return; foreach (DataRow botRow in table2.Rows) { if ((string) botRow["ai_type"] == "pet") { queryReactor2.SetQuery($"SELECT * FROM pets_data WHERE id={botRow[0]} LIMIT 1"); var row = queryReactor2.GetRow(); if (row == null) continue; var pet = CatalogManager.GeneratePetFromRow(botRow, row); if (_inventoryPets.Contains(pet.PetId)) _inventoryPets.Remove(pet.PetId); _inventoryPets.Add(pet.PetId, pet); } else if ((string) botRow["ai_type"] == "generic") AddBot(BotManager.GenerateBotFromRow(botRow)); } } }