stock IsUserNameAvailable(playername[]) { format(query,sizeof(query),"select * FROM `users` WHERE `username`='%s' limit 0,1;",playername); mysql_query(query); mysql_store_result(); playername[0]=mysql_fetch_int(); mysql_free_result(); if(playername[0]==1)return 1; return 0; }
if(!IsUserNameAvailable(PlayerName(playerid))) { //if(OnPlayerAutoLogin(playerid)){SetPVarInt(playerid, "playerstatus",2); return SpawnPlayer(playerid);} ShowPlayerDialog(playerid,DIALOGID+1,DIALOG_STYLE_MSGBOX,ServerInfo[sName],"The system found an account by your nickname. \nYou have to login to continue.","Login","Quit"); }else{ ShowPlayerDialog(playerid,DIALOGID+2,DIALOG_STYLE_MSGBOX,ServerInfo[sName],"The system didn't found an account by your nickname. You can play with or without an account. \nIf you don't register, you stats won't be restored. If you register your stats will be stored. \nPlease make your choice.","Register","Don't Reg."); }
stock IsUserNameAvailable(playername[]) { format(query,sizeof(query),"SELECT COUNT(username) FROM `users` WHERE `username`='%s' limit 0,1;",playername); mysql_query(query); mysql_store_result(); playername[0]=mysql_fetch_int(); mysql_free_result(); if(playername[0]==0)return 1; return 0; }
[23:41:46] CMySQLHandler::Query(SELECT COUNT(username) FROM `users` WHERE `username`='BritishBoy' limit 0,1;) - An error has occured. (Error ID: 2013, Lost connection to MySQL server during query) [23:41:46] >> mysql_store_result( Connection handle: 1 ) [23:41:46] CMySQLHandler::StoreResult() - No data to store. [23:41:46] >> mysql_fetch_int( Connection handle: 1 ) [23:41:46] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Empty Result) [23:41:46] >> mysql_free_result( Connection handle: 1 ) [23:41:46] CMySQLHandler::FreeResult() - The result is already empty.
stock IsUserNameAvailable(playername[])
{
new esc[24],query[256];
mysql_real_escape_string(playername,esc);
format(query,sizeof(query),"SELECT COUNT(username) FROM `users` WHERE `username`='%s'",esc);
mysql_query(query);
mysql_store_result();
if(mysql_fetch_int() > 0) { return 0; }
else { return 1; }
}
stock IsUserNameAvailable(playername[]) { new esc[24],query2[256]; mysql_real_escape_string(playername,esc); format(query2,sizeof(query2),"SELECT COUNT(username) FROM `users` WHERE `username`='%s'",esc); mysql_query(query2); mysql_store_result(); if(mysql_fetch_int() > 0) { return 0; } else { return 1; } }
[00:20:01] CMySQLHandler::Query(SELECT COUNT(username) FROM `users` WHERE `username`='TestName') - An error has occured. (Error ID: 2013, Lost connection to MySQL server during query) [00:20:01] >> mysql_store_result( Connection handle: 1 ) [00:20:01] CMySQLHandler::StoreResult() - No data to store. [00:20:01] >> mysql_fetch_int( Connection handle: 1 ) [00:20:01] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Empty Result)
stock IsUserNameAvailable(playername[])
{
new esc[24],query2[256];
mysql_real_escape_string(playername,esc);
format(query2,sizeof(query2),"SELECT * FROM `users` WHERE `username`='%s'",esc);
mysql_query(query2);
mysql_store_result();
if(mysql_num_rows()){
mysql_free_result();
return 1;
} else {
mysql_free_result();
return 0;
}
}
The fact that you're loosing connection during the query is the most major issue! Have you correctly opened a connection and where is the MySQL server relative to the SA:MP server?
|