[Neil.]

Quote:

Originally Posted by ikey07 Your query syntax is abit wrong, it will always select only one row, as you set LIMIT 1, in your case you should use pawn Код: new row[24];     mysql_query( "SELECT COUNT(`name`) FROM `banlog` WHERE (`name` = '%s' OR `ip` = '%s')   AND `banned` = '1'" );     mysql_store_result();     mysql_fetch_row(row,"|")     new Count = strval(row);     mysql_free_result();

This stock

pawn Код:

stock bancount(playerid)
{
    new row[24];
    mysql_query( "SELECT COUNT(`name`) FROM `banlog` WHERE (`name` = '%s' OR `ip` = '%s')   AND `banned` = '1'" );
    mysql_store_result();
    mysql_fetch_row(row,"|");
    new Count = strval(row);
    mysql_free_result();
return rows;
}

returns as a syntax error, on this line

pawn Код:

format(string2, 130, "{FFFFFF}%s banned {FF9900}%s(%d){FFFFFF} for Spamming. %s banned %d players",anticheat, sendername,playerid,anticheat,bancount);