public static bool Read(NetState State, string Name, string Password, out Account Acc)
{
Acc = new Account();
Acc.Netstate = State;
ResultTable table = Core.Database.Query("SELECT * FROM accounts WHERE name = '{0}' AND password = '******' LIMIT 0,1", Name.MysqlEscape(), Password.MysqlEscape());
table.TableName = "Account Table";
if (table.Rows.Count == 0)
{
return(false);
}
ResultRow row = table[0];
Acc.Serial = new Serial(row["account_id"].GetInt(), ESerialType.Account);
Acc.Name = row["name"].GetString();
Acc.Password = row["password"].GetString();
Acc.LastIP = row["last_ip"].GetString();
Acc.LastLogin = row["last_login"].GetInt();
Acc.Email = row["email"].GetString();
Acc.UpdateLastLogin();
table = Core.Database.Query("SELECT * FROM chars WHERE account_id = {0}", Acc.Serial.Value);
table.TableName = "Char Table";
if (table.Rows.Count == 0)
{
return(true);
}
Character c;
while ((row = table.GetNext()) != null)
{
c = new Character(Acc, row["char_id"].GetInt(), row["name"].GetString());
Acc.Chars.Add(c.Serial, c);
}
return(true);
}
