6 struct used_result *next;
9 struct escaped_string {
11 struct escaped_string *next;
14 MYSQL *mysql_conn = NULL;
15 static struct used_result *used_results;
16 static struct escaped_string *escaped_strings;
20 if((errid = mysql_ping(mysql_conn))) {
21 if(mysql_errno(mysql_conn) == CR_SERVER_GONE_ERROR) {
22 if(!mysql_real_connect(mysql_conn, MYSQL_HOST, MYSQL_USER, MYSQL_PASS, MYSQL_BASE, MYSQL_PORT, NULL, 0)) {
32 MYSQL_RES *mysql_use() {
33 MYSQL_RES *res = mysql_store_result(mysql_conn);
34 struct used_result *result = malloc(sizeof(*result));
36 mysql_free_result(res);
40 result->next = used_results;
41 used_results = result;
46 struct used_result *result, *next_result;
47 for(result = used_results; result; result = next_result) {
48 next_result = result->next;
49 mysql_free_result(result->result);
53 struct escaped_string *escaped, *next_escaped;
54 for(escaped = escaped_strings; escaped; escaped = next_escaped) {
55 next_escaped = escaped->next;
56 free(escaped->string);
59 escaped_strings = NULL;
63 mysql_conn = mysql_init(NULL);
64 if (!mysql_real_connect(mysql_conn, MYSQL_HOST, MYSQL_USER, MYSQL_PASS, MYSQL_BASE, MYSQL_PORT, NULL, 0)) {
71 mysql_close(mysql_conn);
74 void show_mysql_error() {
76 printf("MySQL Error: %s\n", mysql_error(mysql_conn));
79 void printf_mysql_query(const char *text, ...) {
81 char queryBuf[MYSQLMAXLEN];
84 va_start(arg_list, text);
85 pos = vsnprintf(queryBuf, MYSQLMAXLEN - 2, text, arg_list);
87 if (pos < 0 || pos > (MYSQLMAXLEN - 2)) pos = MYSQLMAXLEN - 2;
89 printf("MySQL: %s\n", queryBuf);
90 if(mysql_query(mysql_conn, queryBuf)) {
92 if(mysql_query(mysql_conn, queryBuf)) {
98 char* escape_string(const char *str) {
99 struct escaped_string *escapedstr = malloc(sizeof(*escapedstr));
103 char escaped[strlen(str)*2+1];
104 mysql_real_escape_string(mysql_conn, escaped, str, strlen(str));
105 escapedstr->string = strdup(escaped);
106 escapedstr->next = escaped_strings;
107 escaped_strings = escapedstr;
108 return escapedstr->string;