<?PHP
##-- options
$list = $_REQUEST['list'];
$page = $_REQUEST['page'];
if(count($config['site']['worlds']) > 1)
{
    foreach($config['site']['worlds'] as $idd => $world_n)
    {
        if($idd == (int) $_GET['world'])
        {
            $world_id = $idd;
            $world_name = $world_n;
        }
    }
}
if(!isset($world_id))
{
    $world_id = 0;
    $world_name = $config['server']['serverName'];
}
if(empty($list))
{
    $list = 'kills';
    $name = "Kills";
}
switch($list)
{
    case 'kills':
        $name = "Kills";
        $querys = $SQL->query('SELECT `g`.`id` AS `id`, `g`.`name` AS `name`,
            `g`.`logo_gfx_name` AS `logo`, COUNT(`g`.`name`) as `value`
            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 `g`.`world_id` = '.$world_id.'
                GROUP BY `name`
                ORDER BY `value` DESC, `name` ASC
            LIMIT 1, 20;');
    break;
    case 'total':
        $name = "Total Level";
        $querys = $SQL->query('SELECT `g`.`id` AS `id`, `g`.`name` AS `name`,
            `g`.`logo_gfx_name` AS `logo`, SUM(`p`.`level`) AS `value`
            FROM `players` p
                LEFT JOIN `guild_ranks` gr ON `p`.`rank_id` = `gr`.`id`
                LEFT JOIN `guilds` g ON `gr`.`guild_id` = `g`.`id`
            WHERE `gr`.`id` > 0 AND `g`.`world_id` = '.$world_id.'
                GROUP BY `name`
                ORDER BY `value` DESC, `name` ASC
            LIMIT 1, 20;');
    break;
    case 'avg':
        $name = "Avg Level";
        $querys = $SQL->query('SELECT `g`.`id` AS `id`, `g`.`name` AS `name`,
            `g`.`logo_gfx_name` AS `logo`, ROUND(AVG(`p`.`level`)) AS `value`
            FROM `players` p
                LEFT JOIN `guild_ranks` gr ON `p`.`rank_id` = `gr`.`id`
                LEFT JOIN `guilds` g ON `gr`.`guild_id` = `g`.`id`
            WHERE `gr`.`id` > 0 AND `g`.`world_id` = '.$world_id.'
                GROUP BY `name`
                ORDER BY `value` DESC, `name` ASC
            LIMIT 1, 20;');
    break;
    case 'members':
        $name = "Members";
        $querys = $SQL->query('SELECT `g`.`id` AS `id`, `g`.`name` AS `name`,
            `g`.`logo_gfx_name` AS `logo`, COUNT(`gr`.`id`) AS `value`
            FROM `players` p
                LEFT JOIN `guild_ranks` gr ON `p`.`rank_id` = `gr`.`id`
                LEFT JOIN `guilds` g ON `gr`.`guild_id` = `g`.`id`
            WHERE `gr`.`id` > 0 AND `g`.`world_id` = '.$world_id.'
                GROUP BY `name`
                ORDER BY `value` DESC, `name` ASC
            LIMIT 1, 20;');
    break;
}
##-- load page
if(count($config['site']['worlds']) > 1)
{
    $main_content .= '<FORM ACTION="index.php?subtopic=topguilds&list='.$list.'&world='.$world_id.'" METHOD="get"><INPUT TYPE="hidden" NAME="subtopic" VALUE="topguilds"><INPUT TYPE="hidden" NAME="list" VALUE="'.$list.'">
    <TABLE WIDTH=100% BORDER=0 CELLSPACING=1 CELLPADDING=4><TR><TD BGCOLOR="'.$config['site']['vdarkborder'].'" CLASS=white><B>World Selection</B></TD></TR><TR><TD BGCOLOR="'.$config['site']['lightborder'].'">
    <TABLE BORDER=0 CELLPADDING=1><TR><TD>World: </TD><TD><SELECT SIZE="1" NAME="world"><OPTION VALUE="" SELECTED>(choose world)</OPTION>';
    foreach($config['site']['worlds'] as $id => $world_n)
    {
        $main_content .= '<OPTION VALUE="'.$id.'">'.$world_n.'</OPTION>';
    }
    $main_content .= '</SELECT> </TD><TD><INPUT TYPE=image NAME="Submit" ALT="Submit" SRC="'.$layout_name.'/images/buttons/sbutton_submit.gif" BORDER=0 WIDTH=120 HEIGHT=18>
    </TD></TR></TABLE></td></tr></TABLE></FORM>';
}
$main_content .= '<CENTER><H2>Ranking for '.$name.' on guilds in '.$world_name.'</H2></CENTER>';
$main_content .= '<TABLE WIDTH=100% BORDER=0 CELLPADDING=4 CELLSPACING=1>
    <tr style="background-image: url('.$layout_name.'/images/news/newsheadline_background.gif);"><td class="white"><span style="font-size: 13px; font-weight: bold;">Choose ranking</td></tr>
    <TR BGCOLOR="'.$config['site']['darkborder'].'"><TD align="center"><a href="index.php?subtopic=topguilds&list=kills&world='.$world_id.'">Kills</a> | <a href="index.php?subtopic=topguilds&list=total&world='.$world_id.'">Total Level</a> | <a href="index.php?subtopic=topguilds&list=avg&world='.$world_id.'">AVG Level</a> | <a href="index.php?subtopic=topguilds&list=members&world='.$world_id.'">Members</a></TD></TR>
</table><br>';
$i = 1;
foreach($querys as $guild)
{

        $bg_color = ($i < 11) ? 'gold' : (is_int($i/2) ? $config['site']['lightborder'] : $config['site']['darkborder']);
    $listResult .= '<tr bgcolor="'.$bg_color.'" align="center"><td>'.$i.'</td><td><img src="guilds/' . ((!empty($guild['logo']) && file_exists('guilds/' . $guild['logo'])) ? $guild['logo'] : 'default_logo.gif') . '" width="64" height="64" border="0"/></td><td><a href="?subtopic=guilds&action=show&guild=' . $guild['id'] . '">'.$guild['name'].'</a></td><td>'.$guild['value'].'</td></tr>';
        $i++;
}
$main_content .= '<TABLE WIDTH=100% BORDER=0 CELLPADDING=4 CELLSPACING=1>
    <tr style="background-image: url('.$layout_name.'/images/news/newsheadline_background.gif);"><TD width="25%"><b><font color="white">Rank</font></b></TD><TD width="25%"><b><font color="white">Logo</font></b></TD><TD width="25%"><b><font color="white">Name</font></b></TD><TD width="25%"><b><font color="white">Value</font></b></TD></TR>
    '.$listResult.'
</table>';
?>