public virtual void HandleLogin(ClientConnection pConnection, MaplePacket pPacket) { int error = pPacket.ReadInt(); pPacket.ReadShort(); if (error != 0) { pConnection.Logger_WriteLine("Got Status: {0}", error); if (error == 0x07) { pConnection.Logger_WriteLine("Already logged in!"); } return; } int userid = pPacket.ReadInt(); byte gender = pPacket.ReadByte(); // Gender or GenderSelect/PinSelect pPacket.ReadByte(); short admin = pPacket.ReadShort(); pPacket.ReadInt(); // ReadBytes(4) pPacket.ReadByte(); // 0x95 string username = pPacket.ReadString(); // Username pPacket.ReadByte(); // 0? byte qban = pPacket.ReadByte(); // Quiet Ban DateTime qban_time = DateTime.FromFileTime(pPacket.ReadLong()); // Quiet Ban Time DateTime creationtime = DateTime.FromFileTime(pPacket.ReadLong()); // Creation Time pPacket.ReadInt(); // 78? pPacket.Skip(2); // 1 1 pPacket.ReadBytes(8); // CC key ParseLogin(pConnection, userid, username, creationtime); }
public override void HandleLogin(ClientConnection pConnection, MaplePacket pPacket) { byte error = pPacket.ReadByte(); if (error != 0) { pConnection.Logger_WriteLine("Got Status: {0}", error); if (error == 0x07) { pConnection.Logger_WriteLine("Already logged in?"); } return; } int userid = pPacket.ReadInt(); pPacket.ReadByte(); // Gender or GenderSelect/PinSelect pPacket.ReadByte(); pPacket.ReadByte(); // Admin? Has bitflag 5 string username = pPacket.ReadString(); // Username pPacket.ReadByte(); pPacket.ReadByte(); DateTime creationtime = DateTime.FromFileTime(pPacket.ReadLong()); // Incorrect :/. Nowhere to be found if (pPacket.ReadBool() == false) pPacket.ReadString(); // Username, with astriks as protection: 'd**mondo2*' pPacket.ReadString(); // wat. if (pPacket.ReadBool()) pPacket.ReadBytes(15); // Every job that can be chosen pPacket.ReadInt(); // YYYYMMDDHH, as in character info -.-? ParseLogin(pConnection, userid, username, creationtime); }
public virtual void HandleLoginFromWeb(ClientConnection pConnection, MaplePacket pPacket) { byte error = pPacket.ReadByte(); if (error != 0) { pConnection.Logger_WriteLine("Got Status: {0}", error); if (error == 0x07) { pConnection.Logger_WriteLine("Already logged in!"); } return; } int userid = pPacket.ReadInt(); pPacket.ReadByte(); // Gender or GenderSelect/PinSelect pPacket.ReadByte(); pPacket.ReadShort(); // Admin info! pPacket.ReadInt(); // ReadBytes(4) pPacket.ReadByte(); // 0x95 string username = pPacket.ReadString(); // Username pPacket.ReadByte(); // 0? pPacket.ReadByte(); // Quiet Ban pPacket.ReadLong(); // Quiet Ban Time pPacket.ReadString(); // Username. Again. DateTime creationtime = DateTime.FromFileTime(pPacket.ReadLong()); // creation datetime pPacket.ReadInt(); pPacket.ReadBytes(8); // CC key pPacket.ReadString(); ParseLogin(pConnection, userid, username, creationtime); }
public void Decode(MaplePacket pPacket) { this.ID = pPacket.ReadInt(); this.Name = pPacket.ReadString(); this.Ranks = new string[5]; for (int i = 0; i < 5; i++) this.Ranks[i] = pPacket.ReadString(); byte guilds = pPacket.ReadByte(); this.GuildIDs = new int[guilds]; for (int i = 0; i < guilds; i++) this.GuildIDs[i] = pPacket.ReadInt(); this.Capacity = pPacket.ReadInt(); this.Notice = pPacket.ReadString(); }
public virtual void Decode(ClientConnection pConnection, MaplePacket pPacket) { ItemID = pPacket.ReadInt(); if (pPacket.ReadBool()) { CashID = pPacket.ReadLong(); } else { CashID = 0; } Expires = pPacket.ReadLong(); BagID = pPacket.ReadInt(); }
public void DecodeTeleportRocks(MaplePacket pPacket) { TeleportRocks = new int[NORMAL_ROCKS + VIP_ROCKS + HYPER_ROCKS + HYPER_ROCKS2]; int i = 0; for (; i < TeleportRocks.Length; i++) { TeleportRocks[i] = pPacket.ReadInt(); } }
public Ring(Ring.Type pType, MaplePacket pPacket, string pOwnName = null) { RingType = pType; if (pType == Type.Marriage) { int marriageID = pPacket.ReadInt(); int characterID = pPacket.ReadInt(); int partnerID = pPacket.ReadInt(); pPacket.ReadShort(); // Most likely 3, marriage type? int characterItemID = pPacket.ReadInt(); int partnerItemID = pPacket.ReadInt(); string characterName = pPacket.ReadString(13); string partnerName = pPacket.ReadString(13); if (pOwnName != FriendName) { FriendID = partnerID; FriendName = partnerName; RingCashID1 = characterItemID; RingCashID2 = partnerItemID; } else { FriendID = characterID; FriendName = characterName; RingCashID1 = partnerItemID; RingCashID2 = characterItemID; } } else { FriendID = pPacket.ReadInt(); FriendName = pPacket.ReadString(13); RingCashID1 = pPacket.ReadLong(); RingCashID2 = pPacket.ReadLong(); if (pType == Type.Friend) { int itemID = pPacket.ReadInt(); } } }
public void Decode(MaplePacket pPacket) { this.ID = pPacket.ReadInt(); this.Type = pPacket.ReadByte(); pPacket.ReadShort(); // X pPacket.ReadShort(); // Y pPacket.ReadByte(); // Stance pPacket.ReadShort(); // Foothold this.Skin = (byte)pPacket.ReadShort(); this.Hair = pPacket.ReadShort(); this.Face = pPacket.ReadShort(); this.Name = pPacket.ReadString(); this.Equips = new int[7]; for (int i = 0; i < 7; i++) this.Equips[i] = pPacket.ReadInt(); }
public static void DecodeGuilds(MaplePacket pPacket, byte pWorldID) { pWorldID = GameHelper.GetAllianceWorldID(pWorldID); int guilds = pPacket.ReadInt(); for (int i = 0; i < guilds; i++) { Guild guild = new Guild(); guild.Decode(pPacket); guild.Save(pWorldID); } }
public void Decode(MaplePacket pPacket) { Values = new int[AmountOfValues]; string tmp = ""; for (int i = 0; i < AmountOfValues; i++) { Values[i] = pPacket.ReadInt(); tmp += string.Format("{0} |", Values[i]); } Logger.WriteLine("ULOI: {0}", tmp); }
public virtual void HandleKeymapUpdate(ClientConnection pConnection, MaplePacket pPacket) { int mode = pPacket.ReadInt(); if (mode == 0) { Dictionary<byte, KeyValuePair<byte, int>> modifieds = new Dictionary<byte, KeyValuePair<byte, int>>(); int amount = pPacket.ReadInt(); for (int i = 0; i < amount; i++) { int idx = pPacket.ReadInt(); byte type = pPacket.ReadByte(); int value = pPacket.ReadInt(); if (idx < 0 || idx > ServerMapleInfo.KEYMAP_SLOTS) { pConnection.Logger_WriteLine("ERROR: Keymap contained invalid index!"); return; } if (modifieds.ContainsKey((byte)idx)) continue; // -.-'' modifieds.Add((byte)idx, new KeyValuePair<byte, int>(type, value)); } if (modifieds.Count == 0) return; StringBuilder sb = new StringBuilder(); sb.Append("UPDATE character_keymaps SET "); foreach (var kvp in modifieds) sb.AppendFormat("map_{0}_type = {1}, map_{0}_value = {2},", kvp.Key, kvp.Value.Key, kvp.Value.Value); sb.Append(" WHERE character_id = " + pConnection.CharacterInternalID); MySQL_Connection.Instance.RunQuery(sb.ToString().Replace(", WHERE", " WHERE")); } }
public virtual void HandleCharacterLoadRequest(ClientConnection pConnection, MaplePacket pPacket) { if (!(pConnection.ConnectedToPort >= 8585 && pConnection.ConnectedToPort <= 8600)) { pConnection.Logger_WriteLine("Ignoring Character Load Request; not connected to a channel server"); return; } int characterid = pPacket.ReadInt(); byte[] machineid = pPacket.ReadBytes(16); pConnection.MachineID = machineid; if (pConnection.UserID == -1) { SessionRestartCache.Instance.TryRestartSession(pConnection, characterid, machineid); } }
public void Decode(MaplePacket pPacket) { ChosenCardID = pPacket.ReadInt(); if (pPacket.ReadBool() == false) { for (short cards = pPacket.ReadShort(); cards > 0; cards--) { pPacket.ReadShort(); // CardID pPacket.ReadByte(); // Level } } else { // Unknown stuff... pPacket.ReadShort(); short size = pPacket.ReadShort(); pPacket.Skip(size); // Card block size = pPacket.ReadShort(); pPacket.Skip(size); // Levels } }
public void Decode(ClientConnection pConnection, MaplePacket pPacket) { InventorySlots = new byte[INVENTORIES]; for (int i = 0; i < INVENTORIES; i++) InventorySlots[i] = pPacket.ReadByte(); pPacket.ReadLong(); // 94354848000000000 | 1-1-1900 EquipmentItems = new Dictionary<short, ItemEquip>[EQUIP_INVENTORIES]; #if LOCALE_EMS for (byte i = 0; i < 3; i++) { EquipmentItems[i] = new Dictionary<short, ItemEquip>(); while (true) { short slot = pPacket.ReadShort(); if (slot == 0) break; slot = CharacterInventory.CorrectEquipSlot(i, slot); ItemEquip equip = (ItemEquip)ItemBase.DecodeItemData(pConnection, pPacket); EquipmentItems[i].Add(slot, equip); } } pPacket.ReadBool(); // EMS only -.- for (byte i = 3; i < EQUIP_INVENTORIES; i++) { EquipmentItems[i] = new Dictionary<short, ItemEquip>(); while (true) { short slot = pPacket.ReadShort(); if (slot == 0) break; slot = CharacterInventory.CorrectEquipSlot(i, slot); ItemEquip equip = (ItemEquip)ItemBase.DecodeItemData(pConnection, pPacket); EquipmentItems[i].Add(slot, equip); } } #else for (byte i = 0; i < EQUIP_INVENTORIES; i++) { EquipmentItems[i] = new Dictionary<short, ItemEquip>(); while (true) { short slot = pPacket.ReadShort(); if (slot == 0) break; slot = CharacterInventory.CorrectEquipSlot(i, slot); ItemEquip equip = (ItemEquip)ItemBase.DecodeItemData(pConnection, pPacket); EquipmentItems[i].Add(slot, equip); } } #endif InventoryItems = new Dictionary<byte, ItemBase>[NORMAL_INVENTORIES]; BagItems = new Dictionary<int, BagItem>(); for (byte i = 0; i < NORMAL_INVENTORIES; i++) { InventoryItems[i] = new Dictionary<byte, ItemBase>(); while (true) { byte slot = pPacket.ReadByte(); if (slot == 0) break; ItemBase item = ItemBase.DecodeItemData(pConnection, pPacket); InventoryItems[i].Add(slot, item); if (item.BagID != -1) { // Update BagID... O.o item.BagID = GameHelper.GetBagID(item.BagID, i); BagItem bi = new BagItem(item); BagItems.Add(item.BagID, bi); } } } // Bagzzz for (int inv = 3; inv <= 4; inv++) { var bags = pPacket.ReadInt(); for (int i = 0; i < bags; i++) { int bagid = pPacket.ReadInt(); int bagitemid = pPacket.ReadInt(); BagItem bi = BagItems[GameHelper.GetBagID(bagid, inv - 2)]; // No addition to inv...! while (true) { int slotid = pPacket.ReadInt(); if (slotid == -1) break; ItemBase item = ItemBase.DecodeItemData(pConnection, pPacket); bi.Items.Add((byte)slotid, item); } } } }
public void Decode(ClientConnection pConnection, MaplePacket pPacket) { pPacket.Skip(8); // Flag #if LOCALE_GMS pPacket.Skip(1); #endif { // Added GMS V.132 pPacket.ReadInt(); pPacket.ReadInt(); pPacket.ReadInt(); } #if LOCALE_EMS pPacket.Skip(1); #endif int tmp = pPacket.ReadByte(); pPacket.Skip(tmp * 4); tmp = pPacket.ReadInt(); pPacket.Skip(tmp * (4 + 8)); #if LOCALE_GMS pPacket.Skip(1); #endif if (pPacket.ReadBool()) { tmp = pPacket.ReadInt(); pPacket.Skip(tmp * 8); tmp = pPacket.ReadInt(); pPacket.Skip(tmp * 8); } Stats = new GW_CharacterStat(); Stats.Decode(pPacket); this.BuddylistSize = pPacket.ReadByte(); #if LOCALE_EMS pPacket.ReadByte(); #endif if (pPacket.ReadBool()) BlessingOfTheFairy = pPacket.ReadString(); else BlessingOfTheFairy = null; if (pPacket.ReadBool()) BlessingOfEmpress = pPacket.ReadString(); else BlessingOfEmpress = null; if (pPacket.ReadBool()) UltimateExplorer = pPacket.ReadString(); else UltimateExplorer = null; Stats.DecodeMesos(pPacket); // .-. #if LOCALE_EMS pPacket.ReadByte(); // Bool check pPacket.ReadInt(); #endif // Unknown stuff here for (int i = pPacket.ReadInt(); i > 0; i--) { pPacket.ReadInt(); pPacket.ReadInt(); pPacket.ReadInt(); pPacket.ReadLong(); } #if LOCALE_GMS // Magical potion pots!!! for (int i = pPacket.ReadInt(); i > 0; i--) // V.126 { pPacket.ReadInt(); // Potion pot ID pPacket.ReadInt(); // Max value pPacket.ReadInt(); // HP pPacket.ReadInt(); // ??? (Not max value of MP) pPacket.ReadInt(); // MP pPacket.ReadLong(); // Start date O.o? pPacket.ReadLong(); // End date O.o? } #endif #if LOCALE_GMS // V.142 - RED stuff? for (int i = pPacket.ReadInt(); i > 0; i--) { pPacket.ReadInt(); pPacket.ReadInt(); pPacket.ReadInt(); pPacket.ReadInt(); pPacket.ReadInt(); pPacket.ReadInt(); pPacket.ReadByte(); pPacket.ReadInt(); pPacket.ReadInt(); } { pPacket.ReadInt(); for (int i = 3; i > 0; i--) { pPacket.ReadInt(); pPacket.ReadInt(); } } for (int i = pPacket.ReadInt(); i > 0; i--) pPacket.ReadInt(); if (pPacket.ReadBool()) { pPacket.ReadInt(); pPacket.ReadInt(); pPacket.ReadInt(); pPacket.ReadInt(); pPacket.ReadInt(); pPacket.ReadInt(); pPacket.ReadInt(); pPacket.ReadInt(); pPacket.ReadInt(); pPacket.ReadLong(); pPacket.ReadLong(); pPacket.ReadLong(); } for (int j = 0; j < 2; j++) // called 2 times under each other! { for (int i = pPacket.ReadByte(); i > 0; i--) { pPacket.ReadByte(); pPacket.ReadInt(); pPacket.ReadByte(); pPacket.ReadInt(); pPacket.ReadInt(); pPacket.ReadInt(); pPacket.ReadInt(); pPacket.ReadInt(); pPacket.ReadInt(); pPacket.ReadString(); } } #endif #if LOCALE_EMS // REMOVED GMS V.141?! for (int i = pPacket.ReadInt(); i > 0; i--) // V.137 { pPacket.ReadInt(); pPacket.ReadInt(); pPacket.ReadInt(); pPacket.ReadInt(); pPacket.ReadInt(); pPacket.ReadInt(); pPacket.ReadInt(); } pPacket.ReadInt(); for (int i = 6; i > 0; i--) { pPacket.ReadInt(); } for (int i = pPacket.ReadInt(); i > 0; i--) { pPacket.ReadInt(); } for (int i = pPacket.ReadInt(); i > 0; i--) { pPacket.ReadInt(); pPacket.ReadInt(); pPacket.ReadInt(); pPacket.ReadInt(); pPacket.ReadString(); } for (int i = pPacket.ReadInt(); i > 0; i--) { pPacket.ReadInt(); pPacket.ReadInt(); pPacket.ReadInt(); pPacket.ReadInt(); pPacket.ReadString(); } #endif Inventory = new CharacterInventory(); Inventory.Decode(pConnection, pPacket); //UnknownIntegerListNumber3 = new Dictionary<int, long>(); for (int i = pPacket.ReadInt(); i > 0; i--) { pPacket.ReadInt(); pPacket.ReadLong(); //UnknownIntegerListNumber3.Add(pPacket.ReadInt(), pPacket.ReadLong()); } //UnknownIntegerListNumber4 = new Dictionary<long, long>(); for (int i = pPacket.ReadInt(); i > 0; i--) { pPacket.ReadLong(); pPacket.ReadLong(); //UnknownIntegerListNumber4.Add(pPacket.ReadLong(), pPacket.ReadLong()); } while (true) { byte val = pPacket.ReadByte(); if (val == 0) break; { pPacket.ReadInt(); pPacket.ReadByte(); pPacket.ReadByte(); pPacket.ReadInt(); pPacket.ReadInt(); pPacket.ReadInt(); pPacket.ReadInt(); pPacket.ReadByte(); pPacket.ReadInt(); pPacket.ReadLong(); pPacket.ReadLong(); pPacket.ReadLong(); pPacket.ReadLong(); } } Skills = new CharacterSkills(); Skills.Decode(pConnection, pPacket); Quests = new CharacterQuests(); Quests.Decode(pConnection, pPacket); // Match for (int i = pPacket.ReadShort(); i > 0; i--) { pPacket.ReadInt(); pPacket.ReadInt(); pPacket.ReadInt(); pPacket.ReadInt(); pPacket.ReadInt(); } { Rings = new List<Ring>(); MarriedWith = null; // Couple for (int i = pPacket.ReadShort(); i > 0; i--) { Rings.Add(new Ring(Ring.Type.Couple, pPacket)); } // Friend for (int i = pPacket.ReadShort(); i > 0; i--) { Rings.Add(new Ring(Ring.Type.Friend, pPacket)); } // Marriage for (int i = pPacket.ReadShort(); i > 0; i--) { Ring ring = new Ring(Ring.Type.Marriage, pPacket, Stats.Name); Rings.Add(ring); MarriedWith = ring.FriendName; } } Inventory.DecodeTeleportRocks(pPacket); #if LOCALE_GMS Monsterbook = new CharacterMonsterBook(); Monsterbook.Decode(pPacket); pPacket.ReadInt(); // -1? for (int i = pPacket.ReadShort(); i > 0; i--) { pPacket.ReadShort(); } { // Newyear cards... meh // WHAT MEH, SOMEONE HAS THIS FFS D:!!! for (short i = pPacket.ReadShort(); i > 0; i--) { pPacket.ReadInt(); // Card ID? pPacket.ReadInt(); // Sender ID pPacket.ReadString(); // Sender name pPacket.ReadByte(); // GENDER..? pPacket.ReadLong(); // Sent at? pPacket.ReadInt(); // Receiver ID pPacket.ReadString(); // Receiver name pPacket.ReadByte(); pPacket.ReadByte(); pPacket.ReadLong(); // Receive date? pPacket.ReadString(); // Message } } #else for (int i = pPacket.ReadShort(); i > 0; i--) { pPacket.ReadShort(); pPacket.ReadString(); } #endif Quests.DecodePQ(pConnection, pPacket); if (GameHelper.IsWildHunter(Stats.JobID)) { pPacket.ReadByte(); // Level pPacket.ReadInt(); pPacket.ReadInt(); pPacket.ReadInt(); pPacket.ReadInt(); pPacket.ReadInt(); // Caught mob } Quests.DecodePQDone(pConnection, pPacket); for (int i = pPacket.ReadShort(); i > 0; i--) { short cnt = pPacket.ReadShort(); int unk = pPacket.ReadInt(); // 9010040 | Conor (NPC) if (cnt > 0 && unk > 0) { for (short j = 0; j < cnt; j++) { pPacket.ReadInt(); // 9010040 | Conor (NPC) pPacket.ReadShort(); pPacket.ReadInt(); // 4330019 | Pink Coin Purse pPacket.ReadShort(); } } } for (int i = 13; i > 0; i--) { pPacket.ReadInt(); // Stolen Skills } for (int i = 4; i > 0; i--) { pPacket.ReadInt(); // Chosen Skills? } // Inner Stats Abilities = new List<Tuple<byte, int, byte>>(); for (int i = pPacket.ReadShort(); i > 0; i--) { byte id = pPacket.ReadByte(); // 'ID' int skillid = pPacket.ReadInt(); // Skill ID byte level = pPacket.ReadByte(); // Level pPacket.ReadByte(); // Rank Abilities.Add(new Tuple<byte, int, byte>(id, skillid, level)); } #if LOCALE_GMS { // V.134 for (int i = pPacket.ReadInt(); i > 0; i--) { pPacket.ReadString(); pPacket.ReadInt(); pPacket.ReadString(); for (int j = pPacket.ReadInt(); j > 0; j--) { pPacket.ReadByte(); } } pPacket.ReadByte(); } #endif Stats.HonourLevel = pPacket.ReadInt(); Stats.HonourExp = pPacket.ReadInt(); { byte unk = pPacket.ReadByte(); if (unk == 1) { while (true) { tmp = pPacket.ReadUShort(); if (tmp <= 0) break; while (true) { ushort tmp2 = pPacket.ReadUShort(); if (tmp2 <= 0) break; pPacket.ReadInt(); pPacket.ReadInt(); } } } else { while (true) { tmp = pPacket.ReadUShort(); if (tmp <= 0) break; pPacket.ReadUShort(); pPacket.ReadInt(); pPacket.ReadInt(); } } } if (pPacket.ReadBool()) { // Wat. ItemBase.DecodeItemData(pConnection, pPacket); pPacket.ReadInt(); } { pPacket.ReadInt(); pPacket.ReadInt(); pPacket.ReadInt(); pPacket.ReadByte(); } { pPacket.ReadInt(); pPacket.ReadInt(); pPacket.ReadLong(); } #if LOCALE_EMS pPacket.ReadBool(); pPacket.ReadBool(); #endif { EvolutionCards = new List<EvolutionCard>(); for (short i = pPacket.ReadShort(); i > 0; i--) { var card = new EvolutionCard(); card.Decode(pConnection, pPacket); card.Block = 1; EvolutionCards.Add(card); } for (short i = pPacket.ReadShort(); i > 0; i--) { var card = new EvolutionCard(); card.Decode(pConnection, pPacket); card.Block = 2; EvolutionCards.Add(card); } } #if LOCALE_EMS if (pPacket.ReadBool()) { // Wat. ItemBase.DecodeItemData(pConnection, pPacket); pPacket.ReadInt(); pPacket.ReadInt(); } #endif #if LOCALE_EMS // No farm info for (short i = pPacket.ReadShort(); i > 0; i--) { pPacket.Skip(20); } #else { // V.134 for (byte i = pPacket.ReadByte(); i > 0; i--) { pPacket.ReadInt(); pPacket.ReadLong(); } } { // V.134 // FARM INFO. Creating... = not yet created farm. Else: farmname pPacket.ReadString(); // Creating... pPacket.ReadInt(); pPacket.ReadInt(); pPacket.ReadInt(); pPacket.ReadInt(); pPacket.ReadInt(); pPacket.ReadByte(); pPacket.ReadInt(); pPacket.ReadInt(); pPacket.ReadInt(); pPacket.ReadInt(); pPacket.ReadInt(); } #if LOCALE_GMS if (pPacket.ReadBool()) { // Wat. ItemBase.DecodeItemData(pConnection, pPacket); pPacket.ReadInt(); pPacket.ReadInt(); } #endif { // V.141 pPacket.ReadInt(); pPacket.ReadLong(); // A bit off here, should be filetime value pPacket.ReadInt(); } pPacket.Skip(84); // I don't even pPacket.ReadByte(); { for (short i = pPacket.ReadShort(); i > 0; i--) { pPacket.ReadShort(); pPacket.ReadShort(); } } { pPacket.ReadInt(); pPacket.ReadInt(); pPacket.ReadInt(); pPacket.ReadInt(); pPacket.Skip(32); } { if (pPacket.ReadInt() > 0) { for (int i = 0; i < 3; i++) { pPacket.Skip(4 + 4 + 4); pPacket.ReadString(); pPacket.Skip(4 * 7); pPacket.Skip(8 * 4); pPacket.Skip(4 * 4); pPacket.Skip(1 * 5); pPacket.Skip(4 * 3); pPacket.ReadString(); pPacket.Skip(4 * 2); pPacket.ReadByte(); byte tmptmp = pPacket.ReadByte(); if ((tmptmp & 0x01) != 0) { pPacket.ReadInt(); pPacket.ReadString(); pPacket.Skip(24); } for (int j = pPacket.ReadInt(); j > 0; j++) { pPacket.Skip(4 * 9); } } } } // Removed in V.141 //pPacket.ReadInt(); // I DONT EVEN D: #endif }
public override void Decode(MaplePacket pPacket) { base.Decode(pPacket); this.Slots = pPacket.ReadByte(); this.Scrolls = pPacket.ReadByte(); this.Str = pPacket.ReadShort(); this.Dex = pPacket.ReadShort(); this.Int = pPacket.ReadShort(); this.Luk = pPacket.ReadShort(); this.HP = pPacket.ReadShort(); this.MP = pPacket.ReadShort(); this.Watk = pPacket.ReadShort(); this.Matk = pPacket.ReadShort(); this.Wdef = pPacket.ReadShort(); this.Mdef = pPacket.ReadShort(); this.Acc = pPacket.ReadShort(); this.Avo = pPacket.ReadShort(); this.Hands = pPacket.ReadShort(); this.Speed = pPacket.ReadShort(); this.Jump = pPacket.ReadShort(); this.Name = pPacket.ReadString(); this.Flags = pPacket.ReadShort(); pPacket.ReadByte(); // Increases Skill this.Level = pPacket.ReadByte(); pPacket.ReadInt(); pPacket.ReadInt(); // this.ViciousHammer = pPacket.ReadInt(); pPacket.ReadShort(); // PVP damage pPacket.ReadByte(); pPacket.ReadByte(); this.Potential1 = pPacket.ReadShort(); this.Potential2 = pPacket.ReadShort(); this.Potential3 = pPacket.ReadShort(); this.Potential4 = pPacket.ReadShort(); this.Potential5 = pPacket.ReadShort(); pPacket.ReadShort(); // New? this.SocketState = pPacket.ReadShort(); this.Socket1 = pPacket.ReadShort(); this.Socket2 = pPacket.ReadShort(); this.Socket3 = pPacket.ReadShort(); pPacket.ReadLong(); pPacket.ReadLong(); pPacket.ReadInt(); }
public virtual void HandleMaplePointAmount(ClientConnection pConnection, MaplePacket pPacket) { int amount = pPacket.ReadInt(); // Life can be so easy using (UpdateQueryBuilder q = new UpdateQueryBuilder("users")) { q.SetWhereColumn("account_id", pConnection.AccountID); q.SetColumn("maplepoints", amount); q.RunQuery(); } }
public virtual void HandleCharacterDeletion(ClientConnection pConnection, MaplePacket pPacket) { int id = pPacket.ReadInt(); bool notok = pPacket.ReadBool(); if (!notok && pConnection.UserID != -1) { pConnection.Logger_WriteLine("Deleting character with ID {0}", id); // Oh jolly... // *crosses fingers* // Delete from local cache int internalid = 0; if (AccountDataCache.Instance.DeleteCharacterInfo(id, pConnection.WorldID, pConnection.AccountID, out internalid)) { MySQL_Connection.Instance.RunQuery("DELETE FROM characters WHERE internal_id = " + internalid); } else { Logger.WriteLine("Failed to delete character. Invalid accountid, worldid, characterid or maybe not stored?"); } } else { pConnection.Logger_WriteLine("Account failed deleting ID {0}", id); } }
public virtual void Decode(MaplePacket pPacket) { ItemID = pPacket.ReadInt(); if (pPacket.ReadBool()) { CashID = pPacket.ReadLong(); } else { CashID = 0; } Expires = pPacket.ReadLong(); pPacket.ReadInt(); // -1? }
public override void Decode(ClientConnection pConnection, MaplePacket pPacket) { base.Decode(pConnection, pPacket); List<string> flagsList = new List<string>(); { { uint flag = pPacket.ReadUInt(); this.Slots = FlaggedValue(pConnection, this.ItemID, flag, 0x01, pPacket, this.Slots); this.Scrolls = FlaggedValue(pConnection, this.ItemID, flag, 0x02, pPacket, this.Scrolls); this.Str = FlaggedValue(pConnection, this.ItemID, flag, 0x04, pPacket, this.Str); this.Dex = FlaggedValue(pConnection, this.ItemID, flag, 0x08, pPacket, this.Dex); this.Int = FlaggedValue(pConnection, this.ItemID, flag, 0x10, pPacket, this.Int); this.Luk = FlaggedValue(pConnection, this.ItemID, flag, 0x20, pPacket, this.Luk); this.HP = FlaggedValue(pConnection, this.ItemID, flag, 0x40, pPacket, this.HP); this.MP = FlaggedValue(pConnection, this.ItemID, flag, 0x80, pPacket, this.MP); this.Watk = FlaggedValue(pConnection, this.ItemID, flag, 0x100, pPacket, this.Watk); this.Matk = FlaggedValue(pConnection, this.ItemID, flag, 0x200, pPacket, this.Matk); this.Wdef = FlaggedValue(pConnection, this.ItemID, flag, 0x400, pPacket, this.Wdef); this.Mdef = FlaggedValue(pConnection, this.ItemID, flag, 0x800, pPacket, this.Mdef); this.Acc = FlaggedValue(pConnection, this.ItemID, flag, 0x1000, pPacket, this.Acc); this.Avo = FlaggedValue(pConnection, this.ItemID, flag, 0x2000, pPacket, this.Avo); this.Hands = FlaggedValue(pConnection, this.ItemID, flag, 0x4000, pPacket, this.Hands); this.Speed = FlaggedValue(pConnection, this.ItemID, flag, 0x8000, pPacket, this.Speed); this.Jump = FlaggedValue(pConnection, this.ItemID, flag, 0x10000, pPacket, this.Jump); this.Flags = FlaggedValue(pConnection, this.ItemID, flag, 0x20000, pPacket, this.Flags); this.IncreasesSkills = FlaggedValue(pConnection, this.ItemID, flag, 0x40000, pPacket, this.IncreasesSkills); this.ItemLevel = FlaggedValue(pConnection, this.ItemID, flag, 0x80000, pPacket, this.ItemLevel); this.ItemEXP = FlaggedValue(pConnection, this.ItemID, flag, 0x100000, pPacket, this.ItemEXP); this.Durability = FlaggedValue(pConnection, this.ItemID, flag, 0x200000, pPacket, this.Durability); this.ViciousHammer = FlaggedValue(pConnection, this.ItemID, flag, 0x400000, pPacket, this.ViciousHammer); this.BattleModeDamage = FlaggedValue(pConnection, this.ItemID, flag, 0x800000, pPacket, this.BattleModeDamage); FlaggedValue(pConnection, this.ItemID, flag, 0x1000000, pPacket, (byte)0, true); // Item level changer? FlaggedValue(pConnection, this.ItemID, flag, 0x2000000, pPacket, (short)0, true); // Enhancement buff? FlaggedValue(pConnection, this.ItemID, flag, 0x4000000, pPacket, (int)0, true); FlaggedValue(pConnection, this.ItemID, flag, 0x8000000, pPacket, (byte)0, true); // Required level changer?! FlaggedValue(pConnection, this.ItemID, flag, 0x10000000, pPacket, (byte)0, true); // Yggdrasil Wisdom? FlaggedValue(pConnection, this.ItemID, flag, 0x20000000, pPacket, (byte)0, true); // Final Strike? FlaggedValue(pConnection, this.ItemID, flag, 0x40000000, pPacket, (byte)0, true); // Boss Damage %? FlaggedValue(pConnection, this.ItemID, flag, 0x80000000, pPacket, (byte)0, true); // Ignore Damage %? } { uint flag = pPacket.ReadUInt(); FlaggedValue(pConnection, this.ItemID, flag, 0x01, pPacket, (byte)0, true); // Total damage? FlaggedValue(pConnection, this.ItemID, flag, 0x02, pPacket, (byte)0, true); // All stats? this.MaxScissors = FlaggedValue(pConnection, this.ItemID, flag, 0x04, pPacket, this.MaxScissors); FlaggedValue(pConnection, this.ItemID, flag, 0x08, pPacket, (long)0, true); FlaggedValue(pConnection, this.ItemID, flag, 0x10, pPacket, (int)0, true); } } this.Name = pPacket.ReadString(); this.StatusFlags = pPacket.ReadUShort(); // Actually 2 bytes this.Potential1 = pPacket.ReadUShort(); this.Potential2 = pPacket.ReadUShort(); this.Potential3 = pPacket.ReadUShort(); this.Potential4 = pPacket.ReadUShort(); this.Potential5 = pPacket.ReadUShort(); this.Potential6 = pPacket.ReadUShort(); this.DisplayID = pPacket.ReadUShort(); #if LOCALE_GMS this.SocketState = pPacket.ReadUShort(); this.Nebulite1 = pPacket.ReadShort(); this.Nebulite2 = pPacket.ReadShort(); this.Nebulite3 = pPacket.ReadShort(); #else pPacket.ReadShort(); #endif if (CashID == 0) this.UniqueID = pPacket.ReadLong(); else this.UniqueID = 0; pPacket.ReadLong(); // Some weird expiration time pPacket.ReadInt(); // always -1? #if (LOCALE_EMS || LOCALE_GMS) // Prolly RED patch related pPacket.ReadLong(); pPacket.ReadLong(); // This is 94354848000000000; a default date for no expiration. pPacket.ReadInt(); for (int i = 0; i < 3; i++) pPacket.ReadInt(); #endif // Fix setflags if ((this.Flags & 0x80) == 0x80 && this.Name != "") { flagsList.Add("crafted"); } this.SetFlags = string.Join(",", flagsList); }
private static int FlaggedValue(ClientConnection pConnection, int pItemID, uint pValue, uint pFlag, MaplePacket pPacket, int pTypeValue, bool pLogIfFound = false) { if (pValue.HasFlag(pFlag)) { var val = pPacket.ReadInt(); if (pLogIfFound) pConnection.Logger_WriteLine("Found flag {3} {0:X8}: {1} | ItemID: {2}", pFlag, val, pItemID, pTypeValue.GetType().Name); return val; } else return 0; }
public virtual void HandleSpawnPlayer(ClientConnection pConnection, MaplePacket pPacket) { int id = pPacket.ReadInt(); byte level = pPacket.ReadByte(); #if LOCALE_EMS pPacket.ReadByte(); #endif string name = pPacket.ReadString(); string successor = pPacket.ReadString(); string guildname = pPacket.ReadString(); // pConnection.Logger_WriteLine("I see {0}! ID {1} Level {2}{3}, guild {4}", name, id, level, successor.Length == 0 ? "" : " (" + name + "'s Successor)", guildname); Queries.SeePlayer(id, name, GameHelper.GetAllianceWorldID(pConnection.WorldID), level, guildname, pConnection.CharData.Stats.MapID, pConnection.CharacterInternalID); if (!pConnection._CharactersInMap.Contains(name)) pConnection._CharactersInMap.Add(name); }
public virtual void HandleStatUpdate(ClientConnection pConnection, MaplePacket pPacket) { pPacket.ReadByte(); long updateFlag = pPacket.ReadLong(); if (updateFlag == 0) return; // Fake Update -.- / Unstuck bool didsomething = false; if (CheckFlag(updateFlag, 1)) // Skin { didsomething = true; pConnection.CharData.Stats.Skin = pPacket.ReadByte(); } if (CheckFlag(updateFlag, 2)) // Eyes { didsomething = true; pConnection.CharData.Stats.Face = pPacket.ReadInt(); } if (CheckFlag(updateFlag, 4)) // Eyes { didsomething = true; pConnection.CharData.Stats.Hair = pPacket.ReadInt(); } if (CheckFlag(updateFlag, 8)) { didsomething = true; pConnection.CharData.Stats.Pets[0] = pPacket.ReadLong(); } if (CheckFlag(updateFlag, 0x80000)) { var value = pPacket.ReadLong(); pConnection.Logger_WriteLine("0x80000 | {0}", value); } if (CheckFlag(updateFlag, 0x100000)) { var value = pPacket.ReadLong(); pConnection.Logger_WriteLine("0x100000 | {0}", value); } if (CheckFlag(updateFlag, 0x10)) { didsomething = true; var level = pPacket.ReadByte(); Timeline.Instance.PushLevelUP(pConnection, level); pConnection.CharData.Stats.Level = level; pConnection.Logger_WriteLine("{0} leveled up to level {1}!!!", pConnection.CharData.Stats.Name, level); } if (CheckFlag(updateFlag, 0x20)) { didsomething = true; var jobid = pPacket.ReadShort(); Timeline.Instance.PushJobUP(pConnection, (ushort)jobid); pConnection.CharData.Stats.JobID = jobid; pConnection.Logger_WriteLine("{0} changed to job {1}!!!", pConnection.CharData.Stats.Name, jobid); } if (CheckFlag(updateFlag, 0x40)) { didsomething = true; pConnection.CharData.Stats.Str = pPacket.ReadShort(); } if (CheckFlag(updateFlag, 0x80)) { didsomething = true; pConnection.CharData.Stats.Dex = pPacket.ReadShort(); } if (CheckFlag(updateFlag, 0x100)) { didsomething = true; pConnection.CharData.Stats.Int = pPacket.ReadShort(); } if (CheckFlag(updateFlag, 0x200)) { didsomething = true; pConnection.CharData.Stats.Luk = pPacket.ReadShort(); } if (CheckFlag(updateFlag, 0x400)) { didsomething = true; pConnection.CharData.Stats.HP = pPacket.ReadInt(); } if (CheckFlag(updateFlag, 0x800)) { didsomething = true; pConnection.CharData.Stats.MaxHP = pPacket.ReadInt(); } if (CheckFlag(updateFlag, 0x1000)) { didsomething = true; pConnection.CharData.Stats.MP = pPacket.ReadInt(); } if (CheckFlag(updateFlag, 0x2000)) { didsomething = true; pConnection.CharData.Stats.MaxMP = pPacket.ReadInt(); } if (CheckFlag(updateFlag, 0x4000)) { didsomething = true; pConnection.CharData.Stats.AP = pPacket.ReadShort(); } if (CheckFlag(updateFlag, 0x8000)) { didsomething = true; short a1 = pConnection.CharData.Stats.JobID; pConnection.CharData.Stats.SPData.Clear(); if (GameHelper.IsExtendedSPJob(pConnection.CharData.Stats.JobID)) { byte amnt = pPacket.ReadByte(); List<byte> haslist = new List<byte>(); for (int j = 0; j < amnt; j++) { byte v1 = pPacket.ReadByte(); // Job ID int v2 = pPacket.ReadInt(); // Amount pConnection.CharData.Stats.SPData.Add(new KeyValuePair<byte, int>(v1, v2)); haslist.Add(v1); } for (byte j = 1; j < 20; j++) { if (!haslist.Contains(j)) pConnection.CharData.Stats.SPData.Add(new KeyValuePair<byte, int>(j, 0)); } } else { pConnection.CharData.Stats.SPData.Add(new KeyValuePair<byte, int>(0, pPacket.ReadShort())); } } if (CheckFlag(updateFlag, 0x10000)) { didsomething = true; long newexp = pPacket.ReadLong(); byte point = (byte)EXPTable.GetLevelPercentage(pConnection.CharData.Stats.Level, newexp); if (pConnection.LastExpPoint != point) { // Ohhh Timeline.Instance.PushExpPoint(pConnection, point); } pConnection.CharData.Stats.EXP = newexp; pConnection.LastExpPoint = point; } if (CheckFlag(updateFlag, 0x20000)) { didsomething = true; int fame = pPacket.ReadInt(); Timeline.Instance.PushGotFame(pConnection, fame - pConnection.CharData.Stats.Fame, fame); pConnection.CharData.Stats.Fame = fame; } if (CheckFlag(updateFlag, 0x40000)) { didsomething = true; pConnection.CharData.Stats.Mesos = pPacket.ReadLong(); } if (CheckFlag(updateFlag, 0x200000)) { var value = pPacket.ReadInt(); pConnection.Logger_WriteLine("0x200000 | {0}", value); } if (CheckFlag(updateFlag, 0x400000)) { var value = pPacket.ReadByte(); pConnection.Logger_WriteLine("0x400000 | {0}", value); } if (CheckFlag(updateFlag, 0x800000)) { // Ambition/Charisma D: pConnection.CharData.Stats.Traits[(int)GW_CharacterStat.TraitVals.Charisma] = pPacket.ReadInt(); } if (CheckFlag(updateFlag, 0x1000000)) { pConnection.CharData.Stats.Traits[(int)GW_CharacterStat.TraitVals.Insight] = pPacket.ReadInt(); didsomething = true; } if (CheckFlag(updateFlag, 0x2000000)) { pConnection.CharData.Stats.Traits[(int)GW_CharacterStat.TraitVals.Willpower] = pPacket.ReadInt(); didsomething = true; } if (CheckFlag(updateFlag, 0x4000000)) { pConnection.CharData.Stats.Traits[(int)GW_CharacterStat.TraitVals.CraftDiligence] = pPacket.ReadInt(); didsomething = true; } if (CheckFlag(updateFlag, 0x8000000)) { pConnection.CharData.Stats.Traits[(int)GW_CharacterStat.TraitVals.Empathy] = pPacket.ReadInt(); didsomething = true; } if (CheckFlag(updateFlag, 0x10000000)) { pConnection.CharData.Stats.Traits[(int)GW_CharacterStat.TraitVals.Charm] = pPacket.ReadInt(); didsomething = true; } if (CheckFlag(updateFlag, 0x20000000)) { pPacket.ReadBytes(21); } if (CheckFlag(updateFlag, 0x40000000)) { pPacket.ReadByte(); pPacket.ReadInt(); pPacket.ReadInt(); pPacket.ReadInt(); pPacket.ReadByte(); } if (CheckFlag(updateFlag, 0x80000000)) { for (byte i = 0; i < 9; i++) { pPacket.ReadInt(); pPacket.ReadByte(); pPacket.ReadInt(); } } if (CheckFlag(updateFlag, 0x100000000)) { var value1 = pPacket.ReadByte(); var value2 = pPacket.ReadByte(); pConnection.Logger_WriteLine("0x100000000 | {0} | {1}", value1, value2); } if (CheckFlag(updateFlag, 0x200000000)) { var value = pPacket.ReadInt(); pConnection.Logger_WriteLine("0x200000000 | {0}", value); } if (didsomething) { pConnection.CharData.SaveCharacterInfo(pConnection); pConnection.SendTimeUpdate(); } }
public void Decode(ClientConnection pConnection, MaplePacket pPacket) { ID = pPacket.ReadShort(); ItemID = pPacket.ReadInt(); Level = (byte)pPacket.ReadInt(); }
public virtual void HandleAbilityInfoUpdate(ClientConnection pConnection, MaplePacket pPacket) { pPacket.ReadByte(); // Unlock if (pPacket.ReadBool() == false) return; var stat = new Tuple<byte, int, byte>((byte)pPacket.ReadShort(), pPacket.ReadInt(), (byte)pPacket.ReadShort()); pPacket.ReadShort(); using (InsertQueryBuilder table = new InsertQueryBuilder("character_abilities")) { table.OnDuplicateUpdate = true; table.AddColumn("character_id"); table.AddColumn("id"); table.AddColumn("skill_id", true); table.AddColumn("level", true); table.AddRow( pConnection.CharacterInternalID, stat.Item1, stat.Item2, stat.Item3 ); table.RunQuery(); } }
public virtual void HandleSkillMacros(ClientConnection pConnection, MaplePacket pPacket) { byte count = pPacket.ReadByte(); if (count == 0) return; string q = string.Format("DELETE FROM skillmacros WHERE character_id = {0};\r\n", pConnection.CharacterInternalID); q += "INSERT INTO skillmacros VALUES \r\n"; for (int i = 0; i < count; i++) { string name = pPacket.ReadString(); bool shout = pPacket.ReadBool(); int skill1 = pPacket.ReadInt(); int skill2 = pPacket.ReadInt(); int skill3 = pPacket.ReadInt(); q += string.Format("({0}, {1}, '{2}', {3}, {4}, {5}, {6}),", pConnection.CharacterInternalID, i, MySql.Data.MySqlClient.MySqlHelper.EscapeString(name), shout, skill1, skill2, skill3); } q = q.TrimEnd(','); MySQL_Connection.Instance.RunQuery(q); }
public virtual void HandleFamiliarList(ClientConnection pConnection, MaplePacket pPacket) { using (InsertQueryBuilder familiars = new InsertQueryBuilder("familiars")) { familiars.OnDuplicateUpdate = true; familiars.AddColumn("character_id"); familiars.AddColumn("mobid"); familiars.AddColumns(true, "name", "fitality_cur", "fitality_max", "starttime", "endtime", "unktime" ); for (int i = pPacket.ReadInt(); i > 0; i--) { pPacket.ReadInt(); // Weird id? int mobid = pPacket.ReadInt(); string name = pPacket.ReadString(13); byte currentfit = pPacket.ReadByte(); byte maxfit = pPacket.ReadByte(); pPacket.ReadInt(); pPacket.ReadByte(); DateTime starttime = DateTime.FromFileTime(pPacket.ReadLong()); DateTime unktime = DateTime.FromFileTime(pPacket.ReadLong()); DateTime endtime = DateTime.FromFileTime(pPacket.ReadLong()); pPacket.ReadByte(); pPacket.ReadByte(); familiars.AddRow( pConnection.CharacterInternalID, mobid, name, currentfit, maxfit, starttime, endtime, unktime ); } familiars.RunQuery(); } }
public virtual void HandleSkillUpdate(ClientConnection pConnection, MaplePacket pPacket) { pPacket.ReadByte(); // Unstuck pPacket.ReadByte(); ushort amount = pPacket.ReadUShort(); using (InsertQueryBuilder skillTable = new InsertQueryBuilder("skills")) { skillTable.OnDuplicateUpdate = true; skillTable.AddColumn("character_id", false); skillTable.AddColumn("skillid", false); skillTable.AddColumn("level", true); skillTable.AddColumn("maxlevel", true); skillTable.AddColumn("expires", true); for (ushort i = 0; i < amount; i++) { int skillid = pPacket.ReadInt(); int level = pPacket.ReadInt(); int masterlevel = pPacket.ReadInt(); long expiration = pPacket.ReadLong(); Timeline.Instance.PushSkillUP(pConnection, skillid, level); skillTable.AddRow(pConnection.CharacterInternalID, skillid, level, masterlevel == 0 ? null : (object)masterlevel, expiration); } if (skillTable.RowCount > 0) { string q = skillTable.ToString(); System.IO.File.WriteAllText("insert-update-skills-packet.sql", q); int result = (int)MySQL_Connection.Instance.RunQuery(q); pConnection.Logger_WriteLine("Result Skills: {0}", result); pConnection.SendTimeUpdate(); } } }
public virtual void HandleBuddyList(ClientConnection pConnection, MaplePacket pPacket) { byte mode = pPacket.ReadByte(); if (mode != 0x07) return; MySQL_Connection.Instance.RunQuery(string.Format("DELETE FROM buddies WHERE character_id = {0}", pConnection.CharacterInternalID)); using (InsertQueryBuilder buddies = new InsertQueryBuilder("buddies")) { buddies.OnDuplicateUpdate = true; buddies.AddColumn("character_id"); buddies.AddColumn("friend_id"); buddies.AddColumns(true, "friend_name", "group_name"); byte amount = pPacket.ReadByte(); for (byte i = 0; i < amount; i++) { int bid = pPacket.ReadInt(); string bname = pPacket.ReadString(13); pPacket.Skip(1 + 4); string gname = pPacket.ReadString(13); pPacket.Skip(4); buddies.AddRow( pConnection.CharacterInternalID, bid, bname, gname ); } buddies.RunQuery(); } }
public virtual void HandleTradeData(ClientConnection pConnection, MaplePacket pPacket) { byte type = pPacket.ReadByte(); pPacket.ReadByte(); if (type == 0x0A) { pPacket.ReadByte(); pPacket.ReadShort(); int merchid = pPacket.ReadInt(); string merchname = pPacket.ReadString(); pPacket.ReadByte(); while (true) { byte slot = pPacket.ReadByte(); if (slot == 255) break; pPacket.ReadInt(); // Player ID ParseAvatar(pPacket); pPacket.ReadString(); // Player Name pPacket.ReadShort(); // Job } pPacket.ReadShort(); pPacket.ReadString(); // Owner name pPacket.ReadShort(); // Shop cash ID pPacket.ReadString(); // Shop name pPacket.ReadInt(); // ??? pPacket.ReadByte(); // ??? byte items = pPacket.ReadByte(); using (InsertQueryBuilder itemsTable = new InsertQueryBuilder("items_trades")) { for (int i = 0; i < items; i++) { short slot = pPacket.ReadShort(); // Slot? pPacket.ReadShort(); pPacket.ReadInt(); // Price Queries.SaveItem(pConnection, (ushort)0, slot, ItemBase.DecodeItemData(pConnection, pPacket), itemsTable, true); } MySQL_Connection.Instance.RunQuery("DELETE FROM items_trades"); // Clear table itemsTable.RunQuery(); } } }