Lua GESIOR ACC - Quest Makers.

[Potar]

How to change it for display only 30 results, not all player on the server...

<?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>';
?>

 

[Potar]

When i added DESC LIMIT 25 to $SQL->.... i see only blank page.

 

[Potar]

Still need help, refresh.

 

[SpiderOT]

Try this

$players = $SQL->query('SELECT * FROM players WHERE deleted = 0 AND group_id < '.$config['site']['players_group_id_block'].' AND account_id != 1 ORDER BY `players`.`id` DESC LIMIT 25');

 

[Xavicrak]

Try this

$players = $SQL->query('SELECT * FROM players WHERE deleted = 0 AND group_id < '.$config['site']['players_group_id_block'].' AND account_id != 1 ORDER BY `players`.`id` DESC LIMIT 25');

i have same problem

(ORDER BY `players`.`id` DESC LIMIT 25 )not work...
is a order by players ids(last 25 player created)

 

[Ninja]

Desc limit 25;

 

[Xavicrak]

not work...

 

[Ninja]

Should be working?

<?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 ORDER BY `players`.`id` DESC LIMIT 25');
$nr_gracza = 0;
$main_content .= '<h2 align="center">Best Quest Makers on '. $config['server']['serverName'] .'</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="index.php?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>';
?>

 

[Xavicrak]

No
if i use this, appear the last joined 25 players.
ORDER BY `players`.`id` DESC LIMIT 25' ----> is a order by player id, i need order by % of quest complete.

 

[zaneria hoster]

can someone say how to do this?

 

[zaneria hoster]

refresh

 

[zaneria hoster]

bump

 

[zaneria hoster]

bump

 

[HeberPcL]

Bump