What you have make's no sense. But you didn't even pass an ID. Which I did here.
Code:
#include <amxmodx>
#include <sqlx>
public client_authorized(id)
{
new AuthID[36],plName[33],Data[1]
get_user_authid(id,AuthID,35);
get_user_name(id,plName,32);
Data[0] = id
SQL_ThreadQuery(g_SqlTuple,"SelectHandle","SELECT logged FROM users WHERE nick='%s'",plName,Data,1);
}
public SelectHandle(FailState,Handle:Query,Error[],Errcode,Data[],DataSize,id)
{
if(FailState == TQUERY_CONNECT_FAILED)
return set_fail_state("Could not connect to SQL database.")
else if(FailState == TQUERY_QUERY_FAILED)
return set_fail_state("Query failed.")
if(Errcode)
return log_amx("Error on query: %s",Error)
new id = Data[0],plName[33],AuthID[36],String[128]
while(SQL_MoreResults(Query))
{
SQL_ReadResult(Query,0,String,127);
get_user_name(id,plName,32);
get_user_authid(id,AuthID,35);
server_cmd("amx_say ^"my: %s^"",String);
SQL_NextRow(Query);
}
return PLUGIN_CONTINUE
}
I'm not sure what's saved in the SQL, so I don't know what it's even going to display. or what "amx_say" does