Changeset 84754c0 in network-game for server/DataAccess.cpp

Timestamp:

Oct 17, 2014, 1:14:36 AM (10 years ago)

Author:

Dmitry Portnoy <dmp1488@…>

Branches:

master

Children:

c666518

Parents:

fb894b4

Message:

Change updatePlayer to take a Player object and update many fields of that object

File:

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

server/DataAccess.cpp

@@ -72 +72 @@
 }
 
-// this is no longer used anywhere
-int DataAccess::updatePlayer(string username, string password)
+int DataAccess::updatePlayer(Player* p)
 {
    ostringstream values, where;
 
-   values << "password='" << password << "'";
+   values << "level=" << p->level << ", experience=" << p->experience << ", honor=" << p->honor << ", wins=" << p->wins << ", losses=" << p->losses << "";
    
-   where << "name='" << username << "'";
+   where << "id=" << p->getId() << "";
 
    return update("users", values.str(), where.str());
@@ -114 +113 @@
          cout << "Class from db: " << atoi(row[3]) << endl;
       }
+      p->level = atoi(row[4]);
+      p->experience = atoi(row[5]);
+      p->honor = atoi(row[6]);
+      p->wins = atoi(row[7]);
+      p->losses = atoi(row[8]);
       cout << "Player class: " << p->playerClass << endl;
-      if (row[7] == NULL)
-          cout << "wins: NULL" << endl;
-      else
-          cout << "wins: " << atoi(row[7]) << endl;
-      if (row[8] == NULL)
-          cout << "losses: NULL" << endl;
-      else
-          cout << "losses: " << atoi(row[8]) << endl;
+      cout << "level: " << p->level << endl;
+      cout << "experience: " << p->experience << endl;
+      cout << "honor: " << p->honor << endl;
+      cout << "wins: " << p->wins << endl;
+      cout << "losses: " << p->losses << endl;
       cout << "Loaded player from db" << endl;
    }else {
@@ -140 +141 @@
 list<Player*>* DataAccess::getPlayers()
 {
+   // This method doesn't seem to ever get used. Decide whether it's actually needed
    MYSQL_RES *result;
    MYSQL_ROW row;
@@ -154 +156 @@
       cout << row[0] << ", " << row[1] << ", " << row[2] << endl;
       lstPlayers->push_back(new Player(row[1], row[2]));
+
+      // need to assign all the other db values to the player
    }
 
@@ -310 +314 @@
    query_state = mysql_query(connection, oss.str().c_str());
 
+
    if (query_state != 0) {
       cout << mysql_error(connection) << endl;