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 careerStats getNewCareerStats(gameStats y, careerStats x)
{
careerStats combinedStats = new careerStats(y.getID(), (y.getpawnsEaten() + x.getpawnsEaten()),
(y.getPawnsLost() + x.getPawnsLost()), (y.getFinalScore() + x.getFinalScore()));
return(combinedStats);
}
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!");
}
