Windows Gesior top players.

[Cornex]

Hello there,

I got this problem with top players it don't show me any players ;p

The code to this part is :

<div id="sidebar-right">
				<div class="topplayers"></div>
					<div id="vt_menu">
						<ul>
<?php
                            $players = $SQL->query('SELECT `name`,  `level`, `experience`, `online` FROM `players` WHERE `group_id` <  '.$config['site']['players_group_id_block'].' AND `name` != "Account  Manager" ORDER BY `level` DESC, `experience` DESC LIMIT 5;');
                            $i = 0;
                            foreach($players as $player)
                            {
                             $i++;
                             echo '<li  class="light">'.$i.'. <a href="index.php?subtopic=characters&name='.urlencode($player['name']).'"  >'.$player['name'].'</a> - Level:  '.$player['level'].'</li>';
                            }
                        ?>
						</ul>
					</div>

Thanks =)

 

[Ninja]

Nothing wrong with it from what I can see.

- - - Edited - - -

Works fine for me.

 

[Cornex]

Nothing wrong with it from what I can see.

- - - Edited - - -

Works fine for me.

Works fine for others i know, but not for me haha

 

[Xon vanetta]

Rep me plox ajajajaja

 

[Rallex]

Bump, how to solve this problem?

 

[Gesior.pl]

In Gesior 2012 groups/account 'hidden' in results are in other format (in old version it was number over which groups are not visible, now it's array with hidden groups [in config.php]).
To make it work you must replace:

`group_id` <  '.$config['site']['players_group_id_block'].' AND `name` != "Account  Manager"

with:

`group_id` NOT IN ('.implode(',', $config['site']['groups_hidden']).') AND `name` NOT IN ('.implode(',', $config['site']['accounts_hidden']).')

 

[Vladimir Glebov]

didnt work :/

Warning: Invalid argument supplied for foreach() inE:\xampp\htdocs\layouts\tibiacom\layout.phpon line 219

<div id="Topbar" class="Toplevelbox" style="background-image:url(<?PHP echo $layout_name; ?>/images/top_level.png);">
  <div class="top_level" style="background:url(<?PHP echo $layout_name; ?>/images/bg_top.png)" align="left">
   <?php
  $players = $SQL->query('SELECT `name`,  `level`, `experience`, `online` FROM `players` WHERE `group_id` NOT IN ('.implode(',', $config['site']['groups_hidden']).') AND `name` NOT IN ('.implode(',', $config['site']['accounts_hidden']).') ORDER BY `level` DESC, `experience` DESC LIMIT 5;');
$i = 0;
foreach($players as $player)
{
$i++;
echo '<li  class="light">'.$i.'. <a href="index.php?subtopic=characters&name='.urlencode($player['name']).'"  >'.$player['name'].'</a> - Level:  '.$player['level'].'</li>';
}
                        ?>
    <div class="Bottom1" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/box-bottom.gif);">
    </div>
  </div>
</div>
               
   
                </div>
</div>

</div>