private MySqlCommand UpdateDictionaryCommand(MySqlConnection Connection, String ServerName)
{
MySqlCommand Cmd = Connection.CreateCommand();
Cmd.Parameters.AddWithValue("@servername", ServerName);
Cmd.Parameters.AddWithValue("@dictionary", BArrayManager.ToArray(Loadout.Instance.playerInvs));
Cmd.CommandText = "Update loadout set dictionary = @dictionary where servername = @servername";
return(Cmd);
}
private MySqlCommand SaveDictionaryCommand(MySqlConnection Connection, String ServerName)
{
MySqlCommand Cmd = Connection.CreateCommand();
Cmd.Parameters.AddWithValue("@servername", ServerName);
Cmd.Parameters.AddWithValue("@dictionary", BArrayManager.ToArray(Loadout.Instance.playerInvs));
Cmd.CommandText = "Insert into loadout " +
"(servername, dictionary) " +
"values " +
"(@servername, @dictionary);";
return(Cmd);
}
public void LoadDictionary(String ServerName)
{
using (MySqlConnection Connection = CreateConnection())
{
Connection.Open();
using (MySqlCommand Cmd = Connection.CreateCommand())
{
Cmd.CommandText = "Select * from loadout where servername = " + ServerName + ";";
object Result = Cmd.ExecuteNonQuery();
using (MySqlDataReader Reader = Cmd.ExecuteReader())
{
if (Reader.HasRows)
{
if (Reader.Read())
{
Loadout.Instance.playerInvs = (Dictionary <ulong, LoadoutList>)BArrayManager.ToObject((byte[])Reader.GetValue(1));
}
}
Reader.Close();
}
}
Connection.Close();
}
}