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