public List <MarginInventoryItem> loadInventory(int charId)
{
conn.Open();
string sqlQuery = "SELECT slot, goid, count, purity FROM inventory WHERE charId = '" + charId.ToString() + "' ORDER BY slot ASC ";
queryExecuter = conn.CreateCommand();
queryExecuter.CommandText = sqlQuery;
dr = queryExecuter.ExecuteReader();
List <MarginInventoryItem> Inventory = new List <MarginInventoryItem>();
while (dr.Read())
{
MarginInventoryItem item = new MarginInventoryItem();
item.setItemID((UInt32)dr.GetInt64(1));
item.setPurity((UInt16)dr.GetInt16(3));
item.setAmount((UInt16)dr.GetInt16(2));
item.setSlot((UInt16)dr.GetInt16(0));
Inventory.Add(item);
}
conn.Close();
return(Inventory);
}
public List<MarginInventoryItem> loadInventory(int charId)
{
conn.Open();
string sqlQuery = "SELECT slot, goid, count, purity FROM inventory WHERE charId = '" + charId.ToString() + "' ORDER BY slot ASC ";
queryExecuter = conn.CreateCommand();
queryExecuter.CommandText = sqlQuery;
dr = queryExecuter.ExecuteReader();
List<MarginInventoryItem> Inventory = new List<MarginInventoryItem>();
while (dr.Read())
{
MarginInventoryItem item = new MarginInventoryItem();
item.setItemID((UInt32)dr.GetInt64(1));
item.setPurity((UInt16)dr.GetInt16(3));
item.setAmount((UInt16)dr.GetInt16(2));
item.setSlot((UInt16)dr.GetInt16(0));
Inventory.Add(item);
}
conn.Close();
return Inventory;
}