[Gesior AAC] Top Guilds.

Kekox · Apr 17, 2011

Well this script is based on elf's code, you can see here: http://otland.net/f118/0-3-6-0-4-top-fragers-top-guilds-one-database-query-68893/

I made it as a complete section to gesior aac.
If you are going to use it, please respect credits.

Here an example: Link
topguilds.php

PHP:

<?PHP
    $main_content .= '<div style="text-align: center; font-weight: bold;"><h2>Top 15 guilds on ' . $config['server']['serverName'] . '</h2></div>
<center><table border="0" cellspacing="1" cellpadding="4" width="80%">
    <tr bgcolor="'.$config['site']['vdarkborder'].'">
        <td width="10%"><b><font color=white><center>Pos</font></center></b></td>
        <td width="20%"><b><font color=white><center>Logo</center></b></font></td>
        <td width="30%"><b><font color=white><center>Guild Name</center></b></font></td>
        <td width="20%"><b><font color=white><center>Kills</center></b></font></td>
    </tr>';
$i = 0;
foreach($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, 15;') as $guild)
{
    $i++;
    $main_content .= '<tr bgcolor="' . (is_int($i / 2) ? $config['site']['lightborder'] : $config['site']['darkborder']). '">
        <td>            
            <center>'.$i.'</center>
        </td>
        <td>            
            <center><img src="guilds/' . ((!empty($guild['logo']) && file_exists('guilds/' . $guild['logo'])) ? $guild['logo'] : 'default_logo.gif') . '" width="64" height="64" border="0"/></center>
        </td>
        <td>
            <center><a href="?subtopic=guilds&action=show&guild=' . $guild['id'] . '">' . $guild['name'] . '</a></center>
        </td>
        <td>
            <center>' . $guild['frags'] . ' kills</center>
        </td>
    </tr>';
}
$main_content .= '</table><br />';
$main_content .= '<div style="text-align: right; font-size: 10;">Based on <a href=http://otland.net/members/elf>Elf\'s</a> code. System  made by <a href=http://otland.net/members/kekox>Kekox.</a></div>';
?>

roberty · May 11, 2011

Rep++

Kekox · May 11, 2011

Thank you for bump. xD

Govern · May 11, 2011

Very nice! Thanks man.

HeberPcL · May 12, 2011

Very Nice!

I was trying to convert to ModernACC, i could not.

=z

Kekox,
Nice LastItems
http://otservlatino.net/server/?subtopic=lastitems

;]]

raelpsf · May 19, 2011

How it works? For eg. One guild have 200 kills, but in this guild have 01 players, and he (alone) have 300 kills.. idk what happens!

Kekox · Jun 1, 2011

The guild which has the player alone with 300 kills will be first because this guild have more kills.

@Heber
Thank you

I made my own shop system, and addons for it.. its pretty cool.

killing · Jul 10, 2012

Thanks !!!!

damianjoker · Jul 10, 2012

Very Nice... Working

killing · Jul 10, 2012

Bro pls help imgur: the simple image sharer

Tachi · Jan 31, 2013

Warning: Invalid argument supplied for foreach() in D:\xampp\htdocs\pages\topguild.php on line 21

Gesior 2012, Version: 1.0.1....
TFS 0.3.7 Crying Damson

Any ideas?

- - - Updated - - -

OPPS here's Line 21... Although its from the main posts script...

Code:

    LIMIT 0, 15;') as $guild)

But here is the WHOLE for function... Although its from the main posts script...

Code:

foreach($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, 15;') as $guild)

Sirion_Mido · Feb 2, 2013

how can i put it , in a list in layout.php , so it make list like highscore in the tables

ligus · Dec 4, 2013

Tachi said:
Warning: Invalid argument supplied for foreach() in D:\xampp\htdocs\pages\topguild.php on line 21

Gesior 2012, Version: 1.0.1....
TFS 0.3.7 Crying Damson

Any ideas?

- - - Updated - - -

OPPS here's Line 21... Although its from the main posts script...

Code:

LIMIT 0, 15;') as $guild)

But here is the WHOLE for function... Although its from the main posts script...

Code:

foreach($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, 15;') as $guild)

I have the same problem... what's wrong?

raf · Jun 22, 2014

not showing top guilds, no errors, is query wrong?

DonHagman · Sep 27, 2014

Tachi said:
Warning: Invalid argument supplied for foreach() in D:\xampp\htdocs\pages\topguild.php on line 21

Gesior 2012, Version: 1.0.1....
TFS 0.3.7 Crying Damson

Any ideas?

- - - Updated - - -

OPPS here's Line 21... Although its from the main posts script...

Code:

LIMIT 0, 15;') as $guild)

But here is the WHOLE for function... Although its from the main posts script...

Code:

foreach($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, 15;') as $guild)

Bumping this since I have the same problem. I got the error at the bottom:

Code:

Warning: Invalid argument supplied for foreach() in D:\xampp\htdocs\pages\topguild.php on line 21

Does anyone know the solution for it? It would really be appreciated!

wikutag · Oct 4, 2014

same problem as these people

Szeroki368 · May 1, 2015

ja mam z tym problem z topgildia takie cos Invalid subtopic. Can't load page.

God Mythera · Jul 14, 2015

any way to make this work with guild frags and normal frags?

[Gesior AAC] Top Guilds.

Kekox

Well-Known Member

roberty

New Member

Kekox

Well-Known Member

Govern

Member

HeberPcL

[PowerOT.com.br]

raelpsf

Member

Kekox

Well-Known Member

killing

Member

damianjoker

Gr3m3K

killing

Member

Tachi

New Member

Sirion_Mido

Experienced Member

ligus

New Member

raf

Active Member

DonHagman

Chill'Reward2014

wikutag

SoulBound 8.6 100% custom

Szeroki368

New Member

God Mythera

Veteran OT User

Similar threads