[WEBSITE] top lvl & ss time

[raf]

Hiya, i need help with top 5 lvl php code/sql query, below u can find code i found on otland, to show top 5 magic level, but i edited it to show level.

<?php
                                $zap = $SQL->query('SELECT `name`, `level` FROM `players` WHERE `group_id` < '.$config['site']['groups_hidden'].' AND `name` != "Account Manager" ORDER BY `level` DESC, `experience` DESC LIMIT 5;');
                                $number_of_rows = 0;
                                foreach($zap as $wynik)
                                {
                                 $number_of_rows++;
                                 echo '<tr><td style="width: 80%"><strong>'.$number_of_rows.'</strong>. <a href="index.php?subtopic=characters&name='.urlencode($wynik['name']).'" >'.$wynik['name'].'</a><td> <td><span class="label label-info">Lvl. '.$wynik['level'].'</span></td></tr>';
                                }
                            ?>

also, if anyone has / could write, code for time left to server save, like on shadowcores.twifysoft.net

thanks in advance!

 

[Evil Puncker]

just learn basic javascript

 

[raf]

just learn basic javascript

you mean it can be simple counter, and loop ? it doesnt has to connect somehow to server files ?

 

[mariante]

You want some thing like this?

@Edit

If is that you want:

Spoiler: Tutorial

1 Download:
http://www.sendspace.com/file/ejr1jt
(Virus Check: https://www.virustotal.com/pt/file/...823ba8037d1759f2151a13fa/analysis/1360784756/)

2 Open layout.php find:
<divid="Themeboxes">

3 Insert this where you want inside Themeboxes div:
<?php include($layout_name.'/widget_rank.php');?>

Credits:
CreditosKekezitolhp TibiaKing

 

[raf]

You want some thing like this?

@Edit

If is that you want:

Spoiler: Tutorial

1 Download:
http://www.sendspace.com/file/ejr1jt
(Virus Check: https://www.virustotal.com/pt/file/...823ba8037d1759f2151a13fa/analysis/1360784756/)

2 Open layout.php find:
<divid="Themeboxes">

3 Insert this where you want inside Themeboxes div:
<?php include($layout_name.'/widget_rank.php');?>

Credits:
CreditosKekezitolhp TibiaKing

yes, that's almost perfect but i will modify it ok ?


--edit
i bet it wont work, because i don't have players_group_id_block in my site config

 

[mariante]

What is the website that you use? That system i tested in Gesior