--
INSERT INTO `bots` (`id`, `active`, `nick`, `server`, `port`, `pass`, `ssl`, `bind`, `ident`, `realname`, `automodes`, `botclass`, `textbot`, `defaulttrigger`, `max_channels`, `register_priority`) VALUES
-(4, 0, 'TestBot', '127.0.0.1', 6667, NULL, 0, NULL, 'testbot', 'TestBot2', 'ix', 1, 0, '+', 0, 0);
-
+(4, 1, 'TestBot', '127.0.0.1', 6667, "", 0, NULL, 'testbot', 'TestBot2', 'ix', 1, 0, '+', 0, 0);
int loadINI(char *filename) {
FILE *f;
- int i, fpointer;
+ int i, fpointer = 0;
char SectionName[SECTION_LEN], FieldName[FIELDNAME_LEN], FieldValue[FIELDVALUE_LEN], ch;
f=fopen(filename,"rb");
removeSpace(SectionName);
while(!feof(f)) {
fread(&ch,sizeof(char),1,f);
- if (ch == 0x0d)
+ if (ch == '\r' || ch == '\n')
break;
}
- fread(&ch,sizeof(char),1,f);
if (SectionName[0] == '\0')
continue;
while(!feof(f)) {
}
}
removeSpace(FieldValue);
- fread(&ch,sizeof(char),1,f);
WriteString(SectionName,FieldName,FieldValue);
}
}
version = atoi(row[0]);
}
}
+ printf("%d \n", version);
if(!version) {
//CREATE DATABASE
FILE *f = fopen("database.sql", "r");
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) - 1)] == ';') {
- mysql_query(mysql_conn, query_buffer);
+ if(line[(strlen(line) - 2)] == ';') {
+ if(mysql_query(mysql_conn, query_buffer))
+ show_mysql_error();
query_buffer_pos = 0;
}
}
fclose(f);
}
f = fopen("database.defaults.sql", "r");
- mysql_set_server_option(mysql_conn, MYSQL_OPTION_MULTI_STATEMENTS_ON);
if (f) {
- char line[2048];
- char query_buffer[65536];
+ 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) - 1)] == ';') {
- mysql_query(mysql_conn, query_buffer);
+ if(line[(strlen(line) - 2)] == ';') {
+ if(mysql_query(mysql_conn, query_buffer))
+ show_mysql_error();
query_buffer_pos = 0;
}
}
fclose(f);
}
mysql_set_server_option(mysql_conn, MYSQL_OPTION_MULTI_STATEMENTS_OFF);
- mysql_query(mysql_conn, "UPDATE `version` SET `database_version` = '" DATABASE_VERSION "'");
+ mysql_query(mysql_conn, "INSERT INTO `version` (`database_version`) VALUES ('" DATABASE_VERSION "')");
}
else if(version < atoi(DATABASE_VERSION)) {
//UPDATE DATABASE
use_querys = 1;
}
}
+ if(query_buffer_pos) {
+ if(mysql_query(mysql_conn, query_buffer))
+ show_mysql_error();
+ }
fclose(f);
- }
+ } else
+ perror("database.sql missing!");
mysql_set_server_option(mysql_conn, MYSQL_OPTION_MULTI_STATEMENTS_OFF);
mysql_query(mysql_conn, "UPDATE `version` SET `database_version` = '" DATABASE_VERSION "'");
}