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)); }