Changes in server/DataAccess.cpp [7fa452f:426fb84] in network-game

File:

• server/DataAccess.cpp (modified) (4 diffs)

server/DataAccess.cpp

@@ -178 +178 @@
 {
    // each array is the score for one game
-   // the columns are result, team, blue score, and red score
+   // the columns are result, team, blue score, red score, and time the game ended
    // for result 0 is defeat and 1 is victory
    // for team, 1 is blue and 2 is red
@@ -197 +197 @@
    int i=0;
    while ( ( row = mysql_fetch_row(result)) != NULL ) {
-      gameHistory[i] = new int[4];
+      gameHistory[i] = new int[5];
 
       int userTeam = atoi(row[2]);
-      int blueScore = atoi(row[4]);
-      int redScore = atoi(row[3]);
+      int blueScore = atoi(row[3]);
+      int redScore = atoi(row[4]);
+      time_t timeFinished = atoi(row[5]);
       int gameResult = -1;
 
@@ -222 +223 @@
       gameHistory[i][2] = blueScore;
       gameHistory[i][3] = redScore;
+      gameHistory[i][4] = timeFinished;
 
       i++;
@@ -236 +238 @@
 }
 
-int DataAccess::saveGameHistory(int playerId, int team, int blueScore, int redScore)
+int DataAccess::saveGameHistory(int playerId, int team, int blueScore, int redScore, time_t timeFinished)
 {
    ostringstream oss;
 
    cout << "Saving game to db" << endl;
-   oss << playerId << ", " << team << ", " << blueScore << ", " << redScore;
-
-   return insert("gameHistory", "user_id, user_team, blue_score, red_score", oss.str());
+   oss << playerId << ", " << team << ", " << blueScore << ", " << redScore << ", " << timeFinished;
+
+   return insert("gameHistory", "user_id, user_team, blue_score, red_score, time_finished", oss.str());
 }