public static void loadCargo(Character chr)
{
Cargo cargo = chr.getCargo();
using(var con = new MySqlConnection(MasterServer.Instance.SqlConnection.mConnectionString))
using(var cmd = con.CreateCommand())
{
con.Open();
cmd.CommandText = "SELECT * FROM chars_inv WHERE charID=" + chr.getuID();
using(var reader = cmd.ExecuteReader())
{
reader.Read();
if(!reader.HasRows)
{
return;
}
else
{
List<int> seqhash = new List<int>();
int val = 0;
long ending;
short amount;
Item it;
for(int i = 0;i < 240;i++)
{
val = reader.GetInt32(i * 4 + 1);
amount = reader.GetInt16(i * 4 + 3);
it = null;
if(val != 0 && amount != 0)
{
it = new Item(val, amount);
}
val = reader.GetInt32(i * 4 + 2);
ending = reader.GetInt64(i * 4 + 4);
seqhash.Add(val);
if(it != null)
{
cargo.putIntoCargo(val % 100, val / 100, it);
}
}
cargo.saveCargo();
cargo.setSeqSaved(seqhash);
}
}
}
}
public static void SaveCargo(Character chr)
{
Cargo cargo = chr.getCargo();
StringBuilder sb = new StringBuilder();
for(int i = 0;i < 120;i++)
{
Item item = new Item();
if(cargo.getSeqSaved()[i] != -1)
item = cargo.getCargoSaved()[cargo.getSeqSaved()[i]];
sb.Append(",i" + i + "=" + item.getItemID());
sb.Append(",h" + i + "=" + cargo.getSeqSaved()[i]);
sb.Append(",q" + i + "=" + item.getQuantity());
sb.Append(",e" + i + "=" + item.getEnding());
}
Save("chars_cargo", sb, "charID", chr.getuID());
return;
}
