Top 5 Players script

[Hanoger]

Hello, does anyone have top 5 players script?

Thanks for reply.

 

[Deleted member 148307]

In terms of level, frag, or what?

 

[Hanoger]

In terms of level, frag, or what?

Just 1. Name
2. Name
3. Name
4. Name
5. Name

It will be showing on main page at right, I just need the script..

 

[Ninja]

Search

 

[Deleted member 148307]

Just 1. Name
2. Name
3. Name
4. Name
5. Name

It will be showing on main page at right, I just need the script..

<h1>Top 5<small> Players</small></h1> 
            <ul> 
<?php 
                            $limitt = 5; 
                            $zap = $SQL->query('SELECT `name`, `level` FROM `players` WHERE `group_id` < '.$config['site']['players_group_id_block'].' AND `name` != "Account Manager" ORDER BY `level` DESC, `experience` DESC LIMIT 5;'); 
                            $number_of_rows = 0; 
                            foreach($zap as $wynik) 
                            { 
                             $number_of_rows++; 
                             echo '<li class="light">'.$number_of_rows.'. <a href="index.php?subtopic=characters&name='.urlencode($wynik['name']).'" >'.$wynik['name'].'</a> <br> Level: <b>('.$wynik['levell'].')</b></li>'; 
                            } 
                        ?> 
            </ul>

Don't know is workin cuz i didn't check.

 

[Hanoger]

Also, I'm using Gesior AAC Dwarf Layout..

 

[Ninja]

Add that in layout.php then?

 

[Scarlet Ayleid]

Moved to Requests

 

[Hanoger]

You no understand, check my website - tibia.gameteam.cz - on the right there is what I want, nothing else, thanks.

 

[Ninja]

As I said, Open layout.php and paste the script under Top 5 Players

 

[Hanoger]

Thanks, Solved, please lock

 

[Hanoger]

Bumping this thread, that script got one problem, the levels won't show in the script, it shows like this:

1. Sorcerer Sample
Level: ()

Anyone know how to fix it?
Thanks.

 

[Bogart]

lil typo:

<h1>Top 5<small> Players</small></h1> 
            <ul> 
<?php 
                            $limitt = 5; 
                            $zap = $SQL->query('SELECT `name`, `level` FROM `players` WHERE `group_id` < '.$config['site']['players_group_id_block'].' AND `name` != "Account Manager" ORDER BY `level` DESC, `experience` DESC LIMIT 5;'); 
                            $number_of_rows = 0; 
                            foreach($zap as $wynik) 
                            { 
                             $number_of_rows++; 
                             echo '<li class="light">'.$number_of_rows.'. <a href="index.php?subtopic=characters&name='.urlencode($wynik['name']).'" >'.$wynik['name'].'</a> <br> Level: <b>('.$wynik['level'].')</b></li>'; 
                            } 
                        ?> 
            </ul>

 

[Hanoger]

Heh, yeah, it works! Thanks! Rep+!

 

[Wutang]

And for top donors? like the counting instead of level premium_points :?

 

[Hanoger]

You probably need to change some things in the script, but It will work, I think

 

[Wutang]

What should I change? ;s

 

[sebbe hbk]

Bump

 

[Ninja]

What exactly are you looking after? Showing the ones who have spent most premium points or got the most points at their account?

lil typo:

<h1>Top 5<small> Players</small></h1> 
            <ul> 
<?php 
                            $limitt = 5; 
                            $zap = $SQL->query('SELECT `name`,  `level` FROM `players` WHERE `group_id` <  '.$config['site']['players_group_id_block'].' AND `name` != "Account  Manager" ORDER BY `level` DESC, `experience` DESC LIMIT 5;'); 
                            $number_of_rows = 0; 
                            foreach($zap as $wynik) 
                            { 
                             $number_of_rows++; 
                             echo '<li  class="light">'.$number_of_rows.'. <a rel="nofollow"  href="index.php?subtopic=characters&amp;name='.urlencode($wynik['name']).'"  >'.($wynik['online']>0 ? "<font color=\"green\">".$wynik['name']."</font>" : "<font color=\"red\">".$wynik['name']."</font>").'</a> <br> Level:  <b>('.$wynik['level'].')</b></li>'; 
                            } 
                        ?> 
            </ul>

Added so it shows if the player is online or offline x)

 

[Wutang]

most points at their account