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