View Single Post
Author Message
jonatat
Senior Member
Join Date: Dec 2017
Old 04-17-2021 , 05:44   Whats wrong in this mysql?
Reply With Quote #1

I need to kick player if they STEAMID are not in database.

PHP Code:
public client_authorized(id

new 
auth[32]; 
get_user_authid(idauthsizeof (auth));

new 
Handle:query SQL_PrepareQuery(g_sql"SELECT `steam_id` FROM `users` WHERE (`steam_id` = '%s')"auth); 
SQL_Execute(query); 

new 
res[32]; 

if (
SQL_MoreResults(query)) 

SQL_ReadResult(query0ressizeof (res)); 
SQL_FreeHandle(query); 


if (!
strlen(res)) 

server_cmd("kick #%i %s"get_user_userid(id), restrict_msg); 


But i'm allways getting kick. Any suggestions what im doing wrong?
jonatat is offline