PHP Code:
new players[32], pnum, tempid;
get_players(players, pnum);
for( new i; i<pnum; i++ )
{
tempid = players[i];
new Player[32]
get_user_name(tempid,Player,31)
query = SQL_PrepareQuery(con2, "SELECT * FROM players WHERE username='%s'",Player)
SQL_Execute(query)
SQL_NextRow(query)
new kills = SQL_ReadResult(query, 3)
new deaths = SQL_ReadResult(query, 4)
set_hudmessage(255, 170, 42, 0.1, 0.0, 0, 0.1, 99999.0, 0.0, 0.0, 534)
show_hudmessage(tempid, "Kills: %s ^n Deaths: %s",kills,deaths)
}
Quote:
L 07/26/2009 - 13:27:09: [MySQL] No result set in this query!
L 07/26/2009 - 13:27:09: [AMXX] Run time error 10 (plugin "gather.amxx") (native "SQL_NextRow") - debug not enabled!
|
__________________
function rb return $regsubex($$1-,/(.)/g,$+($chr(2) $+ $chr(3),$r(2,15),$chr(2),\1))