$topSnake = $SQL->query('SELECT name, highscore, lookbody, lookfeet, lookhead, looklegs, looktype, lookaddons FROM snake WHERE group_id = 1 AND account_id != 1 ORDER BY highscore DESC LIMIT 30');
$bgcount = 0;
$number_of_rows = 0;
foreach ($topSnake as $member) {
$bgcount++;
$number_of_rows++;
if(is_int($bgcount / 2)):
$bgcolor = $config['site']['darkborder'];
else:
$bgcolor = $config['site']['lightborder'];
endif;
$main_content .= '<tr bgcolor="'.$bgcolor.'">
<td style="text-align: center;">'.$number_of_rows.'</td>
<td style="text-align: center;"><img style="margin-top: -45px; margin-left: -40px;" src="outfit.php?id='.$member['looktype'].'&addons='.$member['lookaddons'].'&head='.$member['lookhead'].'&body='.$member['lookbody'].'&legs='.$member['looklegs'].'&feet='.$member['lookfeet'].'" width="65" height="65" /></td>
<td style="text-align: center;"><a href="?subtopic=characters&name='.$member['name'].'">'.$member['name'].'</a></td>
<td style="text-align: center;"><div class="progress"><span class="text">'.$member['highscore'].'</span></div></td>
</tr>';
};
--
-- Table structure for table
snake
--
CREATE TABLE IF NOT EXISTS
snake
(id
mediumint(9) NOT NULL,player_id
int(11) NOT NULL,highscore
smallint(6) NOT NULL) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
--
-- Dumping data for table
snake
--
Attachments
-
Screenshot_2.png8.8 KB · Views: 8 · VirusTotal