22.06.2014, 22:43
hello how can i check with mySQL if the nick chosen is exists?
because this way is not working :
(if someone can also tell me why this way isnt working, please fix me thanks!)
With alot thanks, Equality.
because this way is not working :
(if someone can also tell me why this way isnt working, please fix me thanks!)
PHP код:
new rows,fields;
format(db,sizeof(db),"SELECT * FROM accounts WHERE username='%s'",newnick);
mysql_function_query(Handle,db,false,"","");
cache_get_data(rows,fields,Handle);
if(rows != 0) return SendClientMessage(playerid,-1,"NICK IS ALREADY TAKEN"):
if(rows == 0) return SendClientMessage(playerid,-1,"NICK IS AVAILABLE");