thanks now i do this and it now working you can help with this ?
PHP Code:
public client_authorized(id)
{
new AuthID[32],plName[32]
get_user_authid(id,AuthID,32);
get_user_name(id,plName,32);
SQL_ThreadQuery(g_SqlTuple,"SelectHandle","SELECT logged FROM users WHERE nick='%s'",plName);
}
public SelectHandle(FailState,Handle:Query,Error[],Errcode,Data[],DataSize,id)
{
new name[32], authid[32]
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 str[33]
while(SQL_MoreResults(Query))
{
SQL_ReadResult(Query,0,str,33)
get_user_name(id,name,31)
get_user_authid(id,authid,31)
server_cmd("amx_say ^"my: %s^"",str)
SQL_NextRow(Query)
}
return PLUGIN_CONTINUE
}