Changeset 36082e8 in network-game for server

Timestamp:

Nov 27, 2012, 4:24:49 PM (12 years ago)

Author:

dportnoy <dmp1488@…>

Branches:

master

Children:

59061f6

Parents:

8e540f4

Message:

Moved the database code to a new class

Location:

server

Files:

• DataAccess.cpp (added)
• DataAccess.h (added)
• makefile (modified) (1 diff)
• server.cpp (modified) (3 diffs)

server/makefile

@@ -3 +3 @@
 FLAGS = $(LIB_FLAGS)
 COMMON_PATH = ../common
-DEPENDENCIES = message.o Player.o
+DEPENDENCIES = message.o Player.o DataAccess.o
 
 server : server.cpp $(DEPENDENCIES)

server/server.cpp

@@ -14 +14 @@
 #include <arpa/inet.h>
 
-#include <mysql/mysql.h>
-
 #include <openssl/bio.h>
 #include <openssl/ssl.h>
@@ -21 +19 @@
 
 #include "Player.h"
+#include "DataAccess.h"
 #include "../common/message.h"
 
@@ -239 +238 @@
    }
 }
-
-int dbtest()
-{
-        MYSQL *connection, mysql;
-        MYSQL_RES *result;
-        MYSQL_ROW row;
-        int query_state;
-
-        mysql_init(&mysql);
-
-        connection = mysql_real_connect(&mysql,"localhost","pythonAdmin","pyMaster09*","pythondb",0,0,0);
-
-        if (connection == NULL) {
-                cout << mysql_error(&mysql) << endl;
-                return 1;
-        }else
-                cout << "Connection successful" << endl;
-
-        query_state = mysql_query(connection, "SELECT * FROM users");
-
-        if (query_state !=0) {
-                cout << mysql_error(connection) << endl;
-                return 1;
-        }
-
-        result = mysql_store_result(connection);
-
-        while ( ( row = mysql_fetch_row(result)) != NULL ) {
-                cout << row[0] << ", " << row[1] << ", " << row[2] << endl;
-        }
-
-        mysql_free_result(result);
-        mysql_close(connection);
-
-        cout << "Test finished" << endl;
-
-        return 0;
-}