public Player LoadPlayer(int id)
{
SqliteCommand cmd;
try
{
cmd = connection.CreateCommand();
}
catch (Exception)
{
return(null);
}
cmd.CommandText = "SELECT * FROM players WHERE ids = " + id;
SqliteDataReader data = cmd.ExecuteReader();
object[] objs = new object[data.FieldCount];
int i = 0;
data.Read();
while (i < data.FieldCount)
{
objs[i] = data.GetValue(i);
i++;
}
Player player = new Player();
//ID //FINISH
try
{
player.id = int.Parse(objs[0].ToString());
player.name = objs[1].ToString();
player.level = int.Parse(objs[2].ToString());//Subway
player.attacklevel = int.Parse(objs[3].ToString());
player.attackxp = int.Parse(objs[4].ToString());
player.defencelevel = int.Parse(objs[5].ToString());
player.defencexp = int.Parse(objs[6].ToString());
player.magiclevel = int.Parse(objs[7].ToString());
player.magicxp = int.Parse(objs[8].ToString());
player.kills = int.Parse(objs[9].ToString());
player.health = int.Parse(objs[10].ToString());
player.admin = MiscMethods.IntToBool(int.Parse(objs[11].ToString()));
player.banned = MiscMethods.IntToBool(int.Parse(objs[12].ToString()));
return(player);
}
catch (Exception crap)
{
Logger.LogMsg("Loading player failed", 1);
Logger.LogMsg("Reason: " + crap.Message, 2);
return(null);
}
}
public bool CreateAccount(string name, string password, int id)
{
if (id < 0)
{
return(false); //Invalid id.
}
SqliteCommand cmd = connection.CreateCommand();
int output = 0;
try {
cmd.CommandText = "INSERT INTO accounts VALUES('" + name + "','" + password + "'," + id + ")";
output = cmd.ExecuteNonQuery();
Logger.LogMsg("SQL>Creating Account '" + name + "' returned " + output, 2);
} catch (SqliteException ex) {
Logger.LogMsg("SQL>Creating Account failed, Exception " + ex.Message, 2);
}
return(MiscMethods.IntToBool(output));
}
