Adrenaline
Waiting for God
Hi,
I need small help with this query:
Namely this script dont show names guilds and need to delete images guilds (only text + amount frags need)..
I modeled at query "Top5"
I need small help with this query:
PHP:
<?php
$skills = $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`
GROUP BY `name`
ORDER BY `frags` DESC, `name` ASC
LIMIT 0, 3; as $guild')->fetchAll();
$number_of_rows = 0;
foreach($skills as $skillss)
{
$number_of_rows++;
echo '<td style="width: 25%; text-align: center;"><br></td>';
echo '<a href="?subtopic=guilds&action=show&guild=' . $guild['id'] . '"><img src="guilds/' . ((!empty($guild['logo']) && file_exists('guilds/' . $guild['logo'])) ? $guild['logo'] : 'default_logo.gif') . '" width="64" height="64" border="0"/><br />' . $guild['name'] . '</a><br />' . $guild['frags'] . ' kills</tr>';
}
?>
Namely this script dont show names guilds and need to delete images guilds (only text + amount frags need)..
I modeled at query "Top5"
PHP:
<?php
$limitt = 5;
$skills = $SQL->query('SELECT name,level,experience FROM players WHERE group_id < '.$config['site']['players_group_id_block'].' AND name != "Account Manager" ORDER BY level DESC, experience DESC LIMIT '.$limitt)->fetchAll();
$number_of_rows = 0;
foreach($skills as $skillss)
{
$number_of_rows++;
echo '<li class="bg6"><a href="index.php?subtopic=characters&name='.urlencode($skillss['name']).'" class="link2">'.$skillss['name'].'</a><br>';
echo '<em class="style2">Level: <b>'.urlencode($skillss['level']).'</b></em></li>';
}
?>