+ THREAD_MUTEX_INIT(synchronized);
+
+ MYSQL *mysql_conn = get_mysql_conn();
+
+ //check database version...
+ int version = 0;
+ if(!mysql_query(mysql_conn, "SELECT `database_version` FROM `version`")) {
+ MYSQL_RES *res = mysql_use();
+ MYSQL_ROW row;
+ if((row = mysql_fetch_row(res))) {
+ version = atoi(row[0]);
+ }
+ }
+ if(!version) {
+ //CREATE DATABASE
+ FILE *f = fopen("database.sql", "r");
+ mysql_set_server_option(mysql_conn, MYSQL_OPTION_MULTI_STATEMENTS_ON);
+ if (f) {
+ char line[512];
+ char query_buffer[8192];
+ int query_buffer_pos = 0;
+ while (fgets(line, sizeof(line), f)) {
+ query_buffer_pos += sprintf(query_buffer + query_buffer_pos, " %s", line);
+ if(line[(strlen(line) - 2)] == ';') {
+ if(mysql_query(mysql_conn, query_buffer))
+ show_mysql_error();
+ query_buffer_pos = 0;
+ }
+ }
+ fclose(f);
+ } else
+ printf_log("main", LOG_ERROR | LOG_MYSQL, "File not found: database.sql");
+ f = fopen("database.defaults.sql", "r");
+ if (f) {
+ char line[4096];
+ char query_buffer[131072];
+ int query_buffer_pos = 0;
+ while (fgets(line, sizeof(line), f)) {
+ query_buffer_pos += sprintf(query_buffer + query_buffer_pos, " %s", line);
+ if(line[(strlen(line) - 2)] == ';') {
+ if(mysql_query(mysql_conn, query_buffer))
+ show_mysql_error();
+ query_buffer_pos = 0;
+ }
+ }
+ fclose(f);
+ } else
+ printf_log("main", LOG_ERROR | LOG_MYSQL, "File not found: database.defaults.sql");
+ do {
+ MYSQL_RES *res = mysql_store_result(mysql_conn);
+ mysql_free_result(res);
+ } while(!mysql_next_result(mysql_conn));
+ mysql_set_server_option(mysql_conn, MYSQL_OPTION_MULTI_STATEMENTS_OFF);
+ mysql_query(mysql_conn, "INSERT INTO `version` (`database_version`) VALUES ('" DATABASE_VERSION "')");
+ }
+ else if(version < atoi(DATABASE_VERSION)) {
+ //UPDATE DATABASE
+ FILE *f = fopen("database.upgrade.sql", "r");
+ mysql_set_server_option(mysql_conn, MYSQL_OPTION_MULTI_STATEMENTS_ON);
+ if (f) {
+ char line[512];
+ char query_buffer[8192];
+ int query_buffer_pos = 0, use_querys = 0;
+ sprintf(query_buffer, "-- version: %d", version);
+ while (fgets(line, sizeof(line), f)) {
+ if(use_querys) {
+ query_buffer_pos += sprintf(query_buffer + query_buffer_pos, " %s", line);
+ if(line[strlen(line) - 1] == ';') {
+ mysql_query(mysql_conn, query_buffer);
+ query_buffer_pos = 0;
+ }
+ } else if(!stricmplen(query_buffer, line, strlen(query_buffer))) {
+ use_querys = 1;
+ }
+ }
+ if(query_buffer_pos) {
+ if(mysql_query(mysql_conn, query_buffer))
+ show_mysql_error();
+ }
+ fclose(f);
+ } else
+ printf_log("main", LOG_ERROR | LOG_MYSQL, "File not found: database.upgrade.sql");
+ do {
+ MYSQL_RES *res = mysql_store_result(mysql_conn);
+ mysql_free_result(res);
+ } while(!mysql_next_result(mysql_conn));
+ mysql_set_server_option(mysql_conn, MYSQL_OPTION_MULTI_STATEMENTS_OFF);
+ mysql_query(mysql_conn, "UPDATE `version` SET `database_version` = '" DATABASE_VERSION "'");