- Dołączył
- Kwiecień 20, 2011
- Posty
- 342
- Liczba reakcji
- 4
witam jak w temacie nie pokazuje mi 10 najlepszych graczy z serwera
b??d taki
[LUA]Warning: Invalid argument supplied for foreach() in C:\xampp\htdocs\layouts\tibiacom\layout.php on line 7[/LUA]
a tu top 10 gildi
b?ad taki
[LUA]Warning: Invalid argument supplied for foreach() in C:\xampp\htdocs\layouts\tibiacom\layout.php on line 15[/LUA]
tfs 1.2 10.98 gesior acc za pomoc +++ z g?ry dzi?ki
PHP:
<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 11;');
foreach($skills as $skill) {
$order++;
if(is_int($number_of_people / 2))
$bgcolor = $config['site'][''];
else
$bgcolor = $config['site'][''];
$number_of_people++;
$players_skill .= '<tr BGCOLOR="'.$bgcolor.'"><td align="center"><font color="#d1d1d1">'.$order.'.</td><td align="left"><B><td align="center"><font color="#d1d1d1"><a style="color:#d1d1d1;" 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="#d1d1d1"><em>'.$skill['level'].'</em></td>';
}
echo "$players_skill";
?>
</table>[LUA]Warning: Invalid argument supplied for foreach() in C:\xampp\htdocs\layouts\tibiacom\layout.php on line 7[/LUA]
a tu top 10 gildi
PHP:
<table width="100%" border="0">
<?PHP
$guilds = $SQL->query('SELECT `g`.`id` AS `id`, `g`.`name` AS `name`,
`g`.`logo_gfx_name` AS `logo`, COUNT(`g`.`name`) as `frags`
FROM `killers` k
LEFT JOIN `player_killers` pk ON `k`.`id` = `pk`.`kill_id`
LEFT JOIN `players` p ON `pk`.`player_id` = `p`.`id`
LEFT JOIN `guild_ranks` gr ON `p`.`rank_id` = `gr`.`id`
LEFT JOIN `guilds` g ON `gr`.`guild_id` = `g`.`id`
WHERE `k`.`unjustified` = 1 AND `k`.`final_hit` = 1
GROUP BY `name`
ORDER BY `frags` DESC, `name` ASC
LIMIT 0, 10;');
$i = 0;
foreach($guilds as $guild)
{
$i++;
echo '<tr BGCOLOR="'.$bgcolor.'">
<td align="center">'.$i.'. </td>
<td align="left">
<B><a href="?subtopic=guilds&action=show&guild=' . $guild['id'] . '">' . $guild['name'] . '</a></b>
</td>
<td align="center">' . $guild['frags'] . ' kills</td>
</tr>';
}
?>
</table>[LUA]Warning: Invalid argument supplied for foreach() in C:\xampp\htdocs\layouts\tibiacom\layout.php on line 15[/LUA]
tfs 1.2 10.98 gesior acc za pomoc +++ z g?ry dzi?ki
