SQL Querying
Hey!
I've a problem with SQL querying.
Here's my code:
PHP Code:
public client_putinserver(id) { if( is_user_hltv(id) || is_user_bot(id) ) { return PLUGIN_CONTINUE; } get_user_authid( id , g_PData[ id ][ AuthID ] , charsmax( g_PData[][ AuthID ] ) );
new cData[ 2 ]; cData[ 0 ] = id; new createinto[1001] formatex(createinto, 1000, "SELECT num FROM kz_procount WHERE authid='%s' LIMIT 1", g_PData[ id ][ AuthID ] ) SQL_ThreadQuery(g_SqlTuple, "Get_ProCountHandle", createinto, cData, 1) return PLUGIN_CONTINUE; } public Get_ProCountHandle(iFailState, Handle:hQuery, szError[], iErrnum, cData[], iSize, Float:fQueueTime) { if( iFailState != TQUERY_SUCCESS ) { return log_amx("SQL: SQL Error #%d - %s", iErrnum, szError) } new id = cData[0] if( SQL_MoreResults(hQuery) ) { SQL_ReadResult(hQuery, 0, g_PData[ id ][ Records ], 32) //client_print... } return PLUGIN_CONTINUE; }
|