[StR_MaRy]

why is showing me only player who have more than 500.000$ in the bank ? i added to see in the hand and bank if you have 500k dosen't matter where you have more than 500k

Код HTML:

CMD:richlist(playerid, params[])
{
    if(gLogged[playerid] == 0) return SendClientMessage(playerid, COLOR_ERROR, "Tu nu esti logat si nu poti sa folosesti aceasta comanda!");
    if(PlayerInfo[playerid][pAdmin] < 3) return SendClientMessage(playerid, COLOR_ERROR, "Nu ai gradul necesar ca sa folosesti aceasta comanda!");
    const max_sort = 20;
    new string[500 + (MAX_PLAYER_NAME+1)*max_sort];
    new Cache:result = mysql_query(handle, "SELECT `Name`,`Cash`,`Account`,`HoursPlayed` FROM `players` WHERE `Cash` > 500000 AND `Account` > 500000 ORDER BY `Cash` > 500000 AND `Account` > 500000 DESC LIMIT 20");
    new tmp = cache_num_rows();
    if(tmp)
    {
        strcat(string,"Nume\tBani la el\tBani in banca\tOre jucate\n");
        for(new i,a[11],c[11],h[11],n[MAX_PLAYER_NAME]; i<tmp; i++)
        {
            cache_get_field_content(i, "Name", n);
            cache_get_field_content(i, "Cash", c);
            cache_get_field_content(i, "Account", a);
            cache_get_field_content(i, "HoursPlayed", h);
            format(string,sizeof(string),"%s%s\t%d\t%d\t%d\t%d\n",string,n,strval©,strval(a),strval(h));
        }
    }
    cache_delete(result);
    if(string[0] == EOS) return SendClientMessage(playerid, COLOR_ERROR, "Nu sunt playeri ce au peste 500.000$ la ei sau in banca");
    ShowPlayerDialog(playerid, 525242, DIALOG_STYLE_TABLIST_HEADERS, "Top 10 jucatori bogati", string, "Iesi", "");
    return 1;
}

[X337]

Код:

new Cache:result = mysql_query(handle, "SELECT `Name`,`Cash`,`Account`,`HoursPlayed` FROM `players` ORDER BY `Cash` DESC LIMIT 20");

You can remove "where" clause if you don't want to show only players with cash more than $500.000