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