[TFS 1.0] Gesior 2012 Top Guilds

[imkingran]

Hello OtLand Community,

Does anyone know how to make a Top Guilds on the latest news that will work Gesior 2012 for TFS 1.0?

Thanks for your help!

 

[imkingran]

bump

 

[imkingran]

bumpie do da

 

[imkingran]

One last try ! Bump

 

[Naxtie]

                                    <?php
                            $guilds = $SQL->query('SELECT `g`.`id` AS `id`, `g`.`name` AS `name`,
                                                  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, 5;')->fetchAll();
                            $GuildCounter = 1;
                                    ?>

It works for me.. >_>

 

[imkingran]

Thanks @Naxtie , I was wondering if you could help me one more time:

I'm getting this error:

Fatal error: Call to a member function fetchAll() on a non-object in /home/otsmanager/www/public_html/pages/raids.php on line 26 Call Stack: 0.0001 635264 1. {main}() /home/otsmanager/www/public_html/index.php:0 0.0069 1796648 2. include_once('/home/otsmanager/www/public_html/system/load.page.php') /home/otsmanager/www/public_html/index.php:37 0.0069 1846000 3. include('/home/otsmanager/www/public_html/pages/raids.php') /home/otsmanager/www/public_html/system/load.page.php:7

And this is how it's set up:

 <?php
        // top kills - guilds
$main_content .= '<div class="NewsHeadline">
    <div class="NewsHeadlineBackground" style="background-image:url(' . $layout_name . '/images/news/newsheadline_background.gif)">
        <table border="0">
            <tr>
                <td style="text-align: center; font-weight: bold;">
                    <font color="white">Most powerfull guilds</font>
                </td>
            </tr>
        </table>
    </div>
</div>
<table border="0" cellspacing="3" cellpadding="4" width="100%">
    <tr>';
                            $guilds = $SQL->query('SELECT `g`.`id` AS `id`, `g`.`name` AS `name`,
                                                  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, 5;')->fetchAll();
                            $GuildCounter = 1;

    $main_content .= '        <td style="width: 25%; text-align: center;">
            <a href="?subtopic=guilds&action=show&guild=' . $guild['id'] . '"><img src="guild_image.php?id=' . $guild['id'] . '" width="64" height="64" border="0"/> <br />' . $guild['name'] . '</a><br />' . $guild['frags'] . ' kills
        </td>';
?>

Do you know how i can fix it?

 

[Naxtie]

It's not my script that caused that error, if you read closely you'll see where the problem is

 

[Ninja]

$guilds = $SQL->query('SELECT `g`.`id` AS `id`, `g`.`name` AS `name`, COUNT(`g`.`name`) as `frags` FROM `players` p LEFT JOIN `player_deaths` pd ON `pd`.`killed_by` = `p`.`name` LEFT JOIN `guild_membership` gm ON `p`.`id` = `gm`.`player_id` LEFT JOIN `guilds` g ON `gm`.`guild_id` = `g`.`id` WHERE `pd`.`unjustified` = 1 GROUP BY `name` ORDER BY `frags` DESC, `name` ASC LIMIT 0, 5;')->fetchAll();

 

[imkingran]

Thanks @Ninja

I'm having a problem where the images are not showing up. And when i click on it it says guild with ID 0 does not exists:

I'm assuming the problem is here some where but i could not figure it out the solution:

This is what it looks like now:

This is what it shows when you click on the image:

 

[imkingran]

bump

 

[Ninja]

    // top kills - guilds
    $main_content .= '<div class="NewsHeadline">
        <div class="NewsHeadlineBackground" style="background-image:url(' . $layout_name . '/images/news/newsheadline_background.gif)">
            <table border="0">
                <tr>
                    <td style="text-align: center; font-weight: bold;">
                        <font color="white">Most powerfull guilds</font>
                    </td>
                </tr>
            </table>
        </div>
    </div>
    <table border="0" cellspacing="3" cellpadding="4" width="100%"><tr>';
   
    foreach($SQL->query('SELECT `g`.`id` AS `id`, `g`.`name` AS `name`, COUNT(`g`.`name`) as `frags` FROM `players` p LEFT JOIN `player_deaths` pd ON `pd`.`killed_by` = `p`.`name` LEFT JOIN `guild_membership` gm ON `p`.`id` = `gm`.`player_id` LEFT JOIN `guilds` g ON `gm`.`guild_id` = `g`.`id` WHERE `g`.`id` > 0 AND `pd`.`unjustified` = 1 GROUP BY `name` ORDER BY `frags` DESC, `name` ASC LIMIT 4;') as $guild)
    $main_content .= '<td style="width: 25%; text-align: center;"><a href="?subtopic=guilds&action=show&guild=' . $guild['id'] . '"><img src="guild_image.php?id=' . $guild['id'] . '" width="64" height="64" border="0"/> <br />' . $guild['name'] . '</a><br />' . $guild['frags'] . ' kills
    </td>';
    $main_content .= '</tr></table>';

 

[imkingran]

    // top kills - guilds
    $main_content .= '<div class="NewsHeadline">
        <div class="NewsHeadlineBackground" style="background-image:url(' . $layout_name . '/images/news/newsheadline_background.gif)">
            <table border="0">
                <tr>
                    <td style="text-align: center; font-weight: bold;">
                        <font color="white">Most powerfull guilds</font>
                    </td>
                </tr>
            </table>
        </div>
    </div>
    <table border="0" cellspacing="3" cellpadding="4" width="100%"><tr>';
  
    foreach($SQL->query('SELECT `g`.`id` AS `id`, `g`.`name` AS `name`, COUNT(`g`.`name`) as `frags` FROM `players` p LEFT JOIN `player_deaths` pd ON `pd`.`killed_by` = `p`.`name` LEFT JOIN `guild_membership` gm ON `p`.`id` = `gm`.`player_id` LEFT JOIN `guilds` g ON `gm`.`guild_id` = `g`.`id` WHERE `g`.`id` > 0 AND `pd`.`unjustified` = 1 GROUP BY `name` ORDER BY `frags` DESC, `name` ASC LIMIT 4;') as $guild)
    $main_content .= '<td style="width: 25%; text-align: center;"><a href="?subtopic=guilds&action=show&guild=' . $guild['id'] . '"><img src="guild_image.php?id=' . $guild['id'] . '" width="64" height="64" border="0"/> <br />' . $guild['name'] . '</a><br />' . $guild['frags'] . ' kills
    </td>';
    $main_content .= '</tr></table>';

I <3 you!