changed Makefile; build all commands as an own file

[NeonServV5.git] / mysqlConn.c

diff --git a/mysqlConn.c b/mysqlConn.c
index e62ef3f4b4e3f11583842f2d92d64c5fe4350cbb..66494e7f5055cf333db9d500c9bde2a605c7f2cd 100644 (file)
--- a/mysqlConn.c
+++ b/mysqlConn.c
@@ -16,13 +16,21 @@ static struct used_result *used_results;
 static struct escaped_string *escaped_strings;
 
 void check_mysql() {
-    if(mysql_ping(mysql_conn)) {
-        //mysql error
+    int errid;
+    if((errid = mysql_ping(mysql_conn))) {
+        if(mysql_errno(mysql_conn) == CR_SERVER_GONE_ERROR) {
+            if(!mysql_real_connect(mysql_conn, MYSQL_HOST, MYSQL_USER, MYSQL_PASS, MYSQL_BASE, MYSQL_PORT, NULL, 0)) {
+                show_mysql_error();
+            }
+        } else {
+            //mysql error
+            show_mysql_error();
+        }
     }
 }
 
 MYSQL_RES *mysql_use() {
-    MYSQL_RES *res = mysql_use_result(mysql_conn);
+    MYSQL_RES *res = mysql_store_result(mysql_conn);
     struct used_result *result = malloc(sizeof(*result));
     if (!result) {
         mysql_free_result(res);
@@ -48,7 +56,7 @@ void mysql_free() {
         free(escaped->string);
         free(escaped);
     }
-    escaped_strings = NULL
+    escaped_strings = NULL;
 }
 
 void init_mysql() {
@@ -80,7 +88,10 @@ void printf_mysql_query(const char *text, ...) {
     queryBuf[pos] = '\0';
     printf("MySQL: %s\n", queryBuf);
     if(mysql_query(mysql_conn, queryBuf)) {
-        show_mysql_error();
+        check_mysql();
+        if(mysql_query(mysql_conn, queryBuf)) {
+            show_mysql_error();
+        }
     }
 }