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