16.04.2014, 13:44
Hi.
I've made my own registration system, but when I start the server and when someone registers, the player is automatically kicked.
And a file called mysql_log is created in my server folder.
The MySQL log tells me this :
When i process a query, i do like this :
Then, I use cache_num_rows to chose which dialog must displays
What's wrong ? Or how must I set an active cache ?
I read the wiki about cache_set_active but I didn't understood at all.
I've made my own registration system, but when I start the server and when someone registers, the player is automatically kicked.
And a file called mysql_log is created in my server folder.
The MySQL log tells me this :
Quote:
Originally Posted by mysql_log
[WARNING] cache_get_row_count - no active cache
[WARNING] cache_affected_rows - no active cache [ERROR] CMySQLQuery::Execute[] - (error #1136) Column count doesn't match value count at row 1 |
PHP Code:
new query[512];
format(query, sizeof(query), "SELECT * FROM `Joueurs` WHERE `pseudo` = '%s'", GetName(playerid));
mysql_tquery(handle, query);
PHP Code:
if(cache_num_rows() > 0)
{
ShowPlayerDialog(playerid, D_LOGIN, DPSW, login, "Valider", "");
return 1;
}
else
{
ShowPlayerDialog(playerid, D_REGISTER, DPSW, regis, "Valider", "");
return 1;
}
I read the wiki about cache_set_active but I didn't understood at all.