Convert probem related with gesior AAC

[StevenTrembly]

Hello all.
i used to convert from 8.6 gesior aac to 10.9 tfs 1.2 gesior aac

but in my layout something went wrong related with sql query what is looking for top 5 levels in layout.php
so for some reason it dosent work beause:

Invalid argument supplied for foreach()

$limitt = 5;
$zap = $SQL->query('SELECT name,online,level,experience,vocation,promotion FROM players WHERE players.deleted = 0 AND group_id != "6" AND account_id != "1" ORDER BY level DESC, experience DESC LIMIT 5;');
       $number_of_rows = 0;
         foreach($zap as $wynik)
            {
                  $number_of_rows++;
      echo '<li><a href="index.php?subtopic=characters&name='.urlencode($wynik['name']).'" ><font color="RED">'.$number_of_rows.'.</font> '.$wynik['name']  .'<br/><small></a><h2d>Level: ('.$wynik['level'].')</font></h2d></small><br/></li>';
                                        }

so what i need is to fix this sql query to be compiled with 10.9 tfs 1.2


Regards

 

[StevenTrembly]

BUMP

 

[Roddet]

$zap = $SQL->query('SELECT name,level,experience FROM players WHERE (account_id > 1 AND group_id = 1 AND deleted = 0) ORDER BY experience DESC LIMIT '.$limitt);

 

[StevenTrembly]

thanks