public String checkUnlockMap(gameStats x) { if (x.getID() != -1 && x.getPassed() == 1) { MySqlCommand queryCommand = new MySqlCommand(); queryCommand.Connection = conn; queryCommand.CommandText = "IF NOT EXISTS (SELECT unlocked from userMaps WHERE ID = @ID AND mapName = @mapName" + "AND unlocked = 0) BEGIN INSERT INTO mapStats(personID, mapName, unlocked) VALUES (@ID,@mapName,@unlocked) END;"; queryCommand.Prepare(); queryCommand.Parameters.AddWithValue("@ID", x.getID()); queryCommand.Parameters.AddWithValue("@mapName", x.getMap()); queryCommand.Parameters.AddWithValue("@unlocked", x.getUnlocked()); try { MySqlDataReader reader = queryCommand.ExecuteReader(); return("Unlocked new map!"); } catch (Exception exc) { Console.WriteLine(exc.Message); return("Failed to save map progress into database"); } } return("Map already unlocked"); }
public String afterGameInsert(gameStats x) { if (x.getID() != -1 && x.getPassed() == 1) { checkUnlockMap(x); careerStats oldStats = getOldCareerStats(x.getID()); careerStats combinedCareerStats = getNewCareerStats(x, oldStats); insertCareerStats(combinedCareerStats); } return("Stats saved post-game!"); }