[NeXoR]

Hey guys, this is a mysql CMD to retrieve all registered accounts on an IP address, do you have any suggestions to make it faster & more efficient ?

PHP код:

CMD:checkalts(playerid, params[])
{
    if(!IsAllowed(playerid, 3)) return NoAuth(playerid);
    new playerb;
    if(sscanf(params, "u", playerb)) return SendClientMessage(playerid, COLOR_WHITE, "USAGE: /checkalts [playerid]");
    if(!IsPlayerConnected(playerb)) return SendClientMessage(playerid, COLOR_WHITE, "Invalid ID.");
    if(IsImmune(playerid, playerb)) return NotImmune(playerid);
    new query[128], Cache:result, rows, tempname[24], tempdate[12];
    mysql_format(mysql, query, sizeof(query), "SELECT `Username`, `Score`, `Registration` FROM `Users` WHERE `IP`='%s' ORDER BY `UserID`", RPIP(playerb));
    result = mysql_query(mysql, query);
    rows = cache_get_row_count(mysql);
    format(query, sizeof(query), "Active & Registered accounts on %s.", RPIP(playerb));
    SendClientMessage(playerid, COLOR_REPORT, query);
    if(rows)
    {
        for(new i = 0; i < rows; i++)
        {
            cache_get_field_content(i, "Username", tempname, mysql, sizeof(tempname));
            cache_get_field_content(i, "Registration", tempdate, mysql, sizeof(tempdate));
            format(query, sizeof(query), "Username: %s || Registration Date: %s || Score: %d", tempname, tempdate, cache_get_field_content_int(i, "Score"));
            SendClientMessage(playerid, COLOR_RED, query);
        }
    }
    cache_delete(result);
    return 1;
}