• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

Lua Help with this Website Script!

Dark ShaoOz

Member
Joined
Apr 19, 2009
Messages
80
Reaction score
5
PHP:
<?PHP
           $order = 0;
           $number_of_people = 0;
           $skills = $SQL->query('SELECT name,online,level,experience,vocation,promotion FROM players WHERE players.deleted = 0 AND players.group_id < '.$config['site']['players_group_id_block'].' AND name != "Account Manager" ORDER BY level DESC, experience DESC LIMIT 10;');
             foreach($skills as $skill) {
              $order++;
               if(is_int($number_of_people / 2))
                 $bgcolor = $config['site']['darkborder'];
               else
                 $bgcolor = $config['site']['lightborder'];
                 $number_of_people++;
                 $players_skill .= '<tr BGCOLOR="'.$bgcolor.'"><td align="center">'.$order.'.</td><td align="left"><B><a href="?subtopic=characters&name='.urlencode($skill['name']).'">'.($skill['online']>0 ? "<font color=\"green\">".$skill['name']."</font>" : "".$skill['name']."</font>").'</a></td> <td align="center"><font color="#7073FC"><em>LvL '.$skill['level'].'</em></font></td>';
             }
           echo "$players_skill";
         ?>

I get this error
Code:
Warning: Invalid argument supplied for foreach() in C:\xampp\htdocs\server\layouts\cyber\layout.php on line 271

Line 271:
Code:
foreach($skills as $skill) {

Why is that? Help me please
 
Test........

PHP:
<?PHP
        $order = 0;
        $number_of_rows = 0;
        $Sql_Query = $SQL->query('SELECT level,name,online FROM players WHERE `group_id` < 3 AND players.deleted = 0 AND name != "Account Manager" ORDER BY level DESC, experience DESC LIMIT 10;');
        if(is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++;
        foreach($Sql_Query as $row) {
            $order++;
            $players_skill .= '<tr BGCOLOR="'.$bgcolor.'"><td align="center">'.$order.'.</td><td align="left"><B><a href="?subtopic=characters&name='.urlencode($row['name']).'">'.($row['online']>0 ? "<font color=\"green\">".$row['name']."</font>" : "".$row['name']."</font>").'</a></td> <td align="center"><font color="#7073FC"><em>LvL '.$row['level'].'</em></font></td>';
        }

        echo "$players_level";
?>
 
Back
Top