static void certifi_saving(Certification_info *C, Database_manager *d_manager) {
char *stmt;
char *values;
MYSQL_ROW row;
// Is username already exists ?
stmt = strgen("SELECT count(", C->username, ") FROM users;", END);
if ((row = mysql_fetch_row(d_manager->database_action(d_manager, stmt))) == NULL) {
release(stmt);
printf("mysql error in certifi_saving()\n");
exit;
}
release(stmt);
if (strcmp(row[0], "0"))
exit(0);
// Account Register
values = strgen("VALUES(", S_QUOTES(C->imei),",", S_QUOTES(C->username),
",", S_QUOTES(C->password), ")", "\0");
stmt = strgen(SP_APP("INSERT INTO"), SP_APP("users"), values, ";", END);
d_manager->database_action(d_manager, stmt);
release(values);
release(stmt);
}
int main(void)
{
char *str,*str2;
uint32_t len;
len = (randInt() % 10) + 1;
str = strgen(len);
str2 = mirror(str);
printf("%s%s\n",str,str2);
return 0;
}
static int info_check(Certification_info *C, Database_manager *d_manager) {
MYSQL_RES *res;
MYSQL_ROW row;
MYSQL *conn;
char *stmt = strgen(SP_APP("SELECT"), SP_APP("name,pass"),
SP_APP("FROM"), SP_APP("users"), SP_APP("WHERE"),
"users.imei", "=", S_QUOTES(C->imei), ";", "\0");
res = d_manager->database_action(d_manager, stmt);
release(stmt);
if ((row = mysql_fetch_row(res)) != NULL) {
if (strcmp(row[0], C->username) == 0 &&
strcmp(row[1], C->password) == 0)
return 1;
else
return 0;
} else {
return 2;
}
}
