Gesior[Quest makers] limit??

[Xavicrak]

How to change it for display only 30 results, not all player on the server?
and how i can add a rank(1,2,3,4...)?

<?PHP
$quest_list = $config['site']['quests'];
if(!$quest_list)
{
        $main_content .= 'Check your Quests on Config';
        break;
}
$players = $SQL->query('SELECT * FROM players WHERE deleted = 0 AND group_id < '.$config['site']['players_group_id_block'].' AND account_id != 1');
$nr_gracza = 0;
$main_content .= '<h2 align="center">Best Quest Makers on Exodis.pl</h2>
<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%>
<table border="0" cellspacing="1" cellpadding="4" width="100%">
    <tr bgcolor="#505050" >
        <td class="white" style="text-align: center; font-weight: bold;" >Name</td>
        <td class="white" style="text-align: center; font-weight: bold; width: 255px" width="255">Progress</td>
        <td class="white" style="text-align: center; font-weight: bold;" width="50">%</td>
    </tr><tr bgcolor="#D4C0A1">';
foreach ($players as $player) 
{
        $ilosc_questow_wykonanych = 0;
        $ilosc_questow = 0;
        foreach($quest_list as $storage => $name)
        {
                $ilosc_questow++;
                $quest_baza = $SQL->query("SELECT * FROM player_storage WHERE player_id = ".$player['id']." AND `key` = '".$quest_list[$storage]."'");
                foreach($quest_baza as $idd)
                        $ilosc_questow_wykonanych++;
        }
        $ilosc_procent =($ilosc_questow_wykonanych / $ilosc_questow) * 100;
        $gracz_wynik[$player['name']] = $ilosc_procent;
}
$gracze_wyniki = arsort($gracz_wynik);
foreach($gracz_wynik as $gracz => $procent)
{
        if(is_int($nr_gracza / 2))
                $bgcolor = $config['site']['darkborder'];
        else
                $bgcolor = $config['site']['lightborder'];
        $nr_gracza++;
        $main_content .= '<TR BGCOLOR="'.$bgcolor.'"><TD width=60%><a href="http://exodis.pl/?subtopic=characters&name='.$gracz.'">'.$gracz.'</a></td><td><div title="'.number_format($procent,0).'%" style="width: 100%; height: 10px; border: 1px solid #000;"><div style="background: green; width: '.$procent.'%; height: 10px;"></td><td>'.number_format($procent,0).'%</td></tr>';
}
$main_content .= '</table>';
?>

 

[Tibiamakers]

<?PHP
$quest_list = $config['site']['quests'];
if(!$quest_list)
{
        $main_content .= 'Check your Quests on Config';
        break;
}
$players = $SQL->query('SELECT * FROM players WHERE deleted = 0 AND group_id < '.$config['site']['players_group_id_block'].' AND account_id != 1'  LIMIT 30);
$nr_gracza = 0;
$main_content .= '<h2 align="center">Best Quest Makers on Exodis.pl</h2>
<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%>
<table border="0" cellspacing="1" cellpadding="4" width="100%">
    <tr bgcolor="#505050" >
        <td class="white" style="text-align: center; font-weight: bold;" >Name</td>
        <td class="white" style="text-align: center; font-weight: bold; width: 255px" width="255">Progress</td>
        <td class="white" style="text-align: center; font-weight: bold;" width="50">%</td>
    </tr><tr bgcolor="#D4C0A1">';
foreach ($players as $player) 
{
        $ilosc_questow_wykonanych = 0;
        $ilosc_questow = 0;
        foreach($quest_list as $storage => $name)
        {
                $ilosc_questow++;
                $quest_baza = $SQL->query("SELECT * FROM player_storage WHERE player_id = ".$player['id']." AND `key` = '".$quest_list[$storage]."'  LIMIT 30");
                foreach($quest_baza as $idd)
                        $ilosc_questow_wykonanych++;
        }
        $ilosc_procent =($ilosc_questow_wykonanych / $ilosc_questow) * 100;
        $gracz_wynik[$player['name']] = $ilosc_procent;
}
$gracze_wyniki = arsort($gracz_wynik);
foreach($gracz_wynik as $gracz => $procent)
{
        if(is_int($nr_gracza / 2))
                $bgcolor = $config['site']['darkborder'];
        else
                $bgcolor = $config['site']['lightborder'];
        $nr_gracza++;
        $main_content .= '<TR BGCOLOR="'.$bgcolor.'"><TD width=60%><a href="http://exodis.pl/?subtopic=characters&name='.$gracz.'">'.$gracz.'</a></td><td><div title="'.number_format($procent,0).'%" style="width: 100%; height: 10px; border: 1px solid #000;"><div style="background: green; width: '.$procent.'%; height: 10px;"></td><td>'.number_format($procent,0).'%</td></tr>';
}
$main_content .= '</table>';
?>

? not tested

 

[Xavicrak]

Not work ;/

nobody know... ;/

http://otland.net/f16/gesior-acc-quest-makers-148609/#post1489076

 

[TGYoshi]

What does the script do in first place?

I have trouble understanding the script at all because some guy thought it was funny to write the variable names in polish or something.

 

[Xavicrak]

i have same problem... polish!!