top 10 players

[Skonelapper]

Witam , mam problez accmangerem gesior 2012 , otóż mam taki skrypt na top players działa on na starszym gesior acc lecz na tym nowy nie dziala , poprostu nic sie nie wyswietla . Oto skrypt :

// Skrypt na stary gesior acc

<table width="100%" border="0">
<?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";
				?>	</table>

Ok już sobie poradziłem , oto poprawiony skrypt na gesior acc 2012

<table width="100%" border="0">

	<?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 NOT IN ('.implode(',', $config['site']['groups_hidden']).')  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=""><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";
				?>
					</table>

 

[Vladimir Glebov]

didnt work