public void LoadCharacters(Account acc, Chars chrs)
{
MySqlCommand cmd = CreateQuery();
cmd.CommandText = "SELECT * FROM characters WHERE accId=@accId AND dead = FALSE;";
cmd.Parameters.AddWithValue("@accId", acc.AccountId);
using (MySqlDataReader rdr = cmd.ExecuteReader())
{
while (rdr.Read())
{
int[] stats = Utils.FromCommaSepString32(rdr.GetString("stats"));
chrs.Characters.Add(new Char
{
ObjectType = (short)rdr.GetInt32("charType"),
CharacterId = rdr.GetInt32("charId"),
Level = rdr.GetInt32("level"),
Exp = rdr.GetInt32("exp"),
CurrentFame = rdr.GetInt32("fame"),
_Equipment = rdr.GetString("items"),
MaxHitPoints = stats[0],
HitPoints = rdr.GetInt32("hp"),
MaxMagicPoints = stats[1],
MagicPoints = rdr.GetInt32("mp"),
Attack = stats[2],
Defense = stats[3],
Speed = stats[4],
Dexterity = stats[5],
HpRegen = stats[6],
MpRegen = stats[7],
Tex1 = rdr.GetInt32("tex1"),
Tex2 = rdr.GetInt32("tex2"),
Dead = false,
PCStats = rdr.GetString("fameStats"),
Pet = rdr.GetInt32("pet"),
});
}
}
foreach (Char i in chrs.Characters)
{
i.Backpacks = GetBackpacks(i, acc);
i.Backpack = 1;
i._Equipment += ", " + Utils.GetCommaSepString(i.Backpacks[i.Backpack]);
}
}