public bool CheckCodeExists(string gcode) { MySqlCommand cmd = CreateQuery(); cmd.CommandText = "SELECT * FROM giftcodes WHERE code=@code;"; cmd.Parameters.AddWithValue("@code", gcode); using (MySqlDataReader rdr = cmd.ExecuteReader()) { if (!rdr.HasRows) { return(false); } rdr.Read(); JohnDog.Say("Database", "SEARCHING FOR CODE!"); if (rdr.GetString("code") == gcode) { JohnDog.Say("Database", "Code found."); return(true); } else { JohnDog.Say("Database", "No code found!"); return(false); } } }
public void SetInventory(string username, string inventory) { JohnDog.Say("Database Manager", "Getting inventory for " + username); string id = FindIDFromName(username); string charname = FindCharNameFromID(id); MySqlCommand cmd = CreateQuery(); cmd.CommandText = "UPDATE inventories SET inventory=@inv WHERE accId=@accId AND charname=@charname;"; cmd.Parameters.AddWithValue("@inv", inventory); cmd.Parameters.AddWithValue("@accId", id); cmd.Parameters.AddWithValue("@charname", charname); cmd.ExecuteScalar(); }
public string GetEquipment(string username) { JohnDog.Say("Database Manager", "Getting equipment for " + username); string id = FindIDFromName(username); string charname = FindCharNameFromID(id); MySqlCommand cmd = CreateQuery(); cmd.CommandText = "SELECT equipment FROM inventories WHERE accId=@accId AND charname=@charname;"; cmd.Parameters.AddWithValue("@accId", Convert.ToInt32(id)); cmd.Parameters.AddWithValue("@charname", charname); string meme = (string)cmd.ExecuteScalar(); return(meme); }