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 void Decode(MaplePacket pPacket)
{
Stats = new GW_CharacterStat();
Stats.Decode(pPacket);
this.BuddylistSize = pPacket.ReadByte();
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); // .-.
// Unknown stuff here
int amount = pPacket.ReadInt();
UnknownIntegerList = new List <UnknownListOfIntegers>();
for (int i = 0; i < amount; i++)
{
UnknownListOfIntegers vals = new UnknownListOfIntegers();
vals.Decode(pPacket);
UnknownIntegerList.Add(vals);
}
Inventory = new CharacterInventory();
Inventory.Decode(pPacket);
UnknownIntegerListNumber2 = new List <int>();
while (true)
{
int unkval = pPacket.ReadInt();
if (unkval == -1)
{
break;
}
UnknownIntegerListNumber2.Add(unkval);
}
UnknownIntegerListNumber3 = new Dictionary <int, long>();
amount = pPacket.ReadInt();
for (int i = 0; i < amount; i++)
{
UnknownIntegerListNumber3.Add(pPacket.ReadInt(), pPacket.ReadLong());
}
{
UnknownIntegerListNumber4 = new Dictionary <long, long>();
amount = pPacket.ReadInt();
for (int i = 0; i < amount; i++)
{
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(pPacket);
Quests = new CharacterQuests();
Quests.Decode(pPacket);
// Match
for (int i = pPacket.ReadShort(); i > 0; i--)
{
pPacket.ReadInt();
pPacket.ReadInt();
pPacket.ReadInt();
pPacket.ReadInt();
pPacket.ReadInt();
}
// Couple
for (int i = pPacket.ReadShort(); i > 0; i--)
{
pPacket.ReadBytes(33);
}
// Friend
for (int i = pPacket.ReadShort(); i > 0; i--)
{
pPacket.ReadBytes(37);
}
// Marriage
for (int i = pPacket.ReadShort(); i > 0; i--)
{
pPacket.ReadBytes(48);
}
Inventory.DecodeTeleportRocks(pPacket);
}
public void Decode(MaplePacket pPacket)
{
Stats = new GW_CharacterStat();
Stats.Decode(pPacket);
this.BuddylistSize = pPacket.ReadByte();
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); // .-.
// Unknown stuff here
int amount = pPacket.ReadInt();
UnknownIntegerList = new List<UnknownListOfIntegers>();
for (int i = 0; i < amount; i++)
{
UnknownListOfIntegers vals = new UnknownListOfIntegers();
vals.Decode(pPacket);
UnknownIntegerList.Add(vals);
}
Inventory = new CharacterInventory();
Inventory.Decode(pPacket);
UnknownIntegerListNumber2 = new List<int>();
while (true)
{
int unkval = pPacket.ReadInt();
if (unkval == -1) break;
UnknownIntegerListNumber2.Add(unkval);
}
UnknownIntegerListNumber3 = new Dictionary<int, long>();
amount = pPacket.ReadInt();
for (int i = 0; i < amount; i++)
{
UnknownIntegerListNumber3.Add(pPacket.ReadInt(), pPacket.ReadLong());
}
{
UnknownIntegerListNumber4 = new Dictionary<long, long>();
amount = pPacket.ReadInt();
for (int i = 0; i < amount; i++)
{
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(pPacket);
Quests = new CharacterQuests();
Quests.Decode(pPacket);
// Match
for (int i = pPacket.ReadShort(); i > 0; i--)
{
pPacket.ReadInt();
pPacket.ReadInt();
pPacket.ReadInt();
pPacket.ReadInt();
pPacket.ReadInt();
}
// Couple
for (int i = pPacket.ReadShort(); i > 0; i--)
{
pPacket.ReadBytes(33);
}
// Friend
for (int i = pPacket.ReadShort(); i > 0; i--)
{
pPacket.ReadBytes(37);
}
// Marriage
for (int i = pPacket.ReadShort(); i > 0; i--)
{
pPacket.ReadBytes(48);
}
Inventory.DecodeTeleportRocks(pPacket);
}
public void SaveData(ClientConnection pConnection)
{
GW_CharacterStat stats = Stats;
Queries.AddOrUpdateCharacter(null, stats.ID, stats.Name, pConnection.UserID, pConnection.WorldID, stats.Level, stats.JobID,
stats.Str, stats.Dex, stats.Int, stats.Luk,
stats.HP, stats.MaxHP, stats.MP, stats.MaxMP, stats.AP, stats.SP,
stats.EXP, stats.Fame, stats.MapID, stats.MapPos, stats.Gender, stats.Skin,
stats.Face, stats.Hair);
InsertQueryBuilder itemsTable = new InsertQueryBuilder("items");
itemsTable.OnDuplicateUpdate = true;
itemsTable.AddColumn("character_id", false);
itemsTable.AddColumn("itemid", true);
itemsTable.AddColumn("inventory", false);
itemsTable.AddColumn("slot", false);
itemsTable.AddColumn("checksum", true);
itemsTable.AddColumns(true, "cashid", "amount", "slots", "scrolls", "str", "dex", "int", "luk", "maxhp", "maxmp", "weaponatt", "weapondef", "magicatt", "magicdef", "acc", "avo", "hands", "jump", "speed", "name", "flags", "hammers", "potential1", "potential2", "potential3", "potential4", "potential5", "socketstate", "socket1", "socket2", "socket3");
InsertQueryBuilder petTable = new InsertQueryBuilder("pets");
petTable.OnDuplicateUpdate = true;
petTable.AddColumn("cashid", false);
petTable.AddColumn("name", true);
petTable.AddColumn("closeness", true);
petTable.AddColumn("fullness", true);
petTable.AddColumn("level", true);
int internalid = 0;
if (Internal_Storage.Store.Instance.KnownCharlist.ContainsKey(stats.ID) &&
Internal_Storage.Store.Instance.KnownCharlist[stats.ID].ContainsKey(pConnection.WorldID))
{
// Update info!
var internalinfo = Internal_Storage.Store.Instance.KnownCharlist[stats.ID][pConnection.WorldID];
internalid = internalinfo.InternalID;
Dictionary <byte, short> updatethese = new Dictionary <byte, short>();
Dictionary <byte, short> addthese = new Dictionary <byte, short>();
CharacterInventory inventory = Inventory;
for (int i = 0; i < Inventory.EquipmentItems.Length; i++)
{
var equips = Inventory.EquipmentItems[i];
foreach (var equipdata in equips)
{
short slot = (short)(i == 2 ? equipdata.Key : -equipdata.Key);
var equip = equipdata.Value;
bool addrow = false;
if (internalinfo.SlotHashes[0].ContainsKey(slot))
{
int hash = internalinfo.SlotHashes[0][slot];
int objhash = equipdata.Value.GetChecksum();
if (hash != objhash)
{
Logger.WriteLine("{0} != {1}", hash, objhash);
addrow = true;
}
internalinfo.SlotHashes[0].Remove(slot);
}
else
{
addrow = true;
}
if (addrow)
{
itemsTable.AddRow(
internalid,
equip.ItemID,
0,
i == 2 ? equipdata.Key : -equipdata.Key,
equip.GetChecksum(),
equip.CashID,
equip.Amount,
equip.Slots, equip.Scrolls,
equip.Str, equip.Dex, equip.Int, equip.Luk,
equip.HP, equip.MP,
equip.Watk, equip.Wdef, equip.Matk, equip.Mdef,
equip.Acc, equip.Avo, equip.Hands, equip.Jump, equip.Speed,
equip.Name, equip.Flags,
equip.ViciousHammer,
equip.Potential1, equip.Potential2, equip.Potential3, equip.Potential4, equip.Potential5,
equip.SocketState, equip.Socket1, equip.Socket2, equip.Socket3
);
}
}
}
Logger.WriteLine("Done equips");
for (int i = 0; i < Inventory.InventoryItems.Length; i++)
{
var items = Inventory.InventoryItems[i];
foreach (var itemdata in items)
{
var item = itemdata.Value;
bool addrow = false;
if (internalinfo.SlotHashes[i + 1].ContainsKey(itemdata.Key))
{
int hash = internalinfo.SlotHashes[i + 1][itemdata.Key];
int objhash = itemdata.Value.GetChecksum();
if (hash != objhash)
{
Logger.WriteLine("{0} != {1}", hash, objhash);
addrow = true;
}
internalinfo.SlotHashes[i + 1].Remove(itemdata.Key);
}
else
{
addrow = true;
}
if (addrow)
{
string name = item is ItemRechargable ? (item as ItemRechargable).CraftName : null;
int flags = item is ItemRechargable ? (item as ItemRechargable).Flags : 0;
itemsTable.AddRow(
internalid,
item.ItemID,
i + 1,
itemdata.Key,
(item is ItemRechargable ? (item as ItemRechargable).GetChecksum() : item.GetChecksum()),
item.CashID,
item.Amount,
null, null,
null, null, null, null,
null, null,
null, null, null, null,
null, null, null, null, null,
name, flags,
null,
null, null, null, null, null,
null, null, null, null
);
if (item is ItemPet)
{
var pet = item as ItemPet;
petTable.AddRow(pet.CashID, pet.Petname, pet.Closeness, pet.Fullness, pet.Level);
}
}
}
}
Logger.WriteLine("Done items");
{
string removequery = "";
bool added = false;
for (byte i = 0; i < internalinfo.SlotHashes.Length; i++)
{
foreach (var leftovers in internalinfo.SlotHashes[i])
{
Logger.WriteLine("Deleting item @ inv {0} slot {1}", leftovers.Key, leftovers.Value);
added = true;
removequery += string.Format("DELETE FROM items WHERE character_id = {2} AND inventory = {0} AND slot = {1};\r\n", i, leftovers.Key, internalid);
}
}
if (added)
{
System.IO.File.WriteAllText("removequery.sql", removequery);
MySQL_Connection.Instance.RunQuery(removequery);
}
}
}
else
{
Logger.WriteLine("Saving Items");
using (var result = MySQL_Connection.Instance.RunQuery("SELECT internal_id FROM characters WHERE id = " + stats.ID + " AND world_id = " + pConnection.WorldID + "") as MySql.Data.MySqlClient.MySqlDataReader)
{
if (result.Read())
{
internalid = result.GetInt32(0);
}
else
{
Logger.WriteLine("OH GOD COULD NOT GET INTERNAL ID");
return;
}
}
string itemlist = "";
itemlist += "INSERT INTO items VALUES ";
List <string> querylist = new List <string>();
for (int i = 0; i < Inventory.EquipmentItems.Length; i++)
{
var equips = Inventory.EquipmentItems[i];
foreach (var equipdata in equips)
{
var equip = equipdata.Value;
itemsTable.AddRow(
internalid,
equip.ItemID,
0,
i == 2 ? equipdata.Key : -equipdata.Key,
equip.GetChecksum(),
equip.CashID,
equip.Amount,
equip.Slots, equip.Scrolls,
equip.Str, equip.Dex, equip.Int, equip.Luk,
equip.HP, equip.MP,
equip.Watk, equip.Wdef, equip.Matk, equip.Mdef,
equip.Acc, equip.Avo, equip.Hands, equip.Jump, equip.Speed,
equip.Name, equip.Flags,
equip.ViciousHammer,
equip.Potential1, equip.Potential2, equip.Potential3, equip.Potential4, equip.Potential5,
equip.SocketState, equip.Socket1, equip.Socket2, equip.Socket3
);
}
}
Logger.WriteLine("Done equips");
for (int i = 0; i < Inventory.InventoryItems.Length; i++)
{
var items = Inventory.InventoryItems[i];
foreach (var itemdata in items)
{
var item = itemdata.Value;
string name = item is ItemRechargable ? (item as ItemRechargable).CraftName : null;
int flags = item is ItemRechargable ? (item as ItemRechargable).Flags : 0;
itemsTable.AddRow(
internalid,
item.ItemID,
i + 1,
itemdata.Key,
(item is ItemRechargable ? (item as ItemRechargable).GetChecksum() : item.GetChecksum()),
item.CashID,
item.Amount,
null, null,
null, null, null, null,
null, null,
null, null, null, null,
null, null, null, null, null,
name, flags,
null,
null, null, null, null, null,
null, null, null, null
);
if (item is ItemPet)
{
var pet = item as ItemPet;
petTable.AddRow(pet.CashID, pet.Petname, pet.Closeness, pet.Fullness, pet.Level);
}
}
}
Logger.WriteLine("Done items");
}
if (itemsTable.RowCount > 0)
{
string q = itemsTable.ToString();
System.IO.File.WriteAllText("insert-update.sql", q);
int result = (int)MySQL_Connection.Instance.RunQuery(q);
Logger.WriteLine("Result: {0}", result);
}
Logger.WriteLine("Saved item data");
if (petTable.RowCount > 0)
{
string q = petTable.ToString();
System.IO.File.WriteAllText("insert-update-pet.sql", q);
int result = (int)MySQL_Connection.Instance.RunQuery(q);
Logger.WriteLine("Result: {0}", result);
}
Logger.WriteLine("Saved item data");
Internal_Storage.Store.Instance.LoadInventoryHashes(internalid, true);
{
InsertQueryBuilder questsTable = new InsertQueryBuilder("quests_running");
questsTable.OnDuplicateUpdate = true;
questsTable.AddColumn("character_id", false);
questsTable.AddColumn("questid", true);
questsTable.AddColumn("data", true);
foreach (var quest in Quests.Running)
{
questsTable.AddRow(internalid, quest.Key, quest.Value);
}
if (questsTable.RowCount > 0)
{
string q = questsTable.ToString();
System.IO.File.WriteAllText("insert-update-quests.sql", q);
int result = (int)MySQL_Connection.Instance.RunQuery(q);
Logger.WriteLine("Result: {0}", result);
}
}
{
InsertQueryBuilder doneTable = new InsertQueryBuilder("quests_done");
doneTable.AddColumn("character_id", false);
doneTable.AddColumn("questid", false);
doneTable.AddColumn("time", false);
foreach (var quest in Quests.Done)
{
doneTable.AddRow(internalid, quest.Key, quest.Value);
}
if (doneTable.RowCount > 0)
{
string q = doneTable.ToString();
System.IO.File.WriteAllText("insert-update-quests-done.sql", q);
int result = (int)MySQL_Connection.Instance.RunQuery(q);
Logger.WriteLine("Result: {0}", result);
}
}
pConnection.CharacterInternalID = internalid;
pConnection.CharacterID = Internal_Storage.Store.Instance.KnownCharlist_INTERNAL[internalid].ID;
}