[Znote AAC] Most powerful guilds (TFS 0.3/4 and 1.0)

pierroth · Oct 12, 2015

HalfAway said:
I can't see anything on that screenshot its too small.
Post the script either with code tags or on pastebin if the code is too long.

I had probelms loading pics, duno why

HalfAway · Oct 12, 2015

pierroth said:
I had probelms loading pics, duno why

With this script you're supposed to add it on latest news for example, not in the guilds page.

pierroth · Oct 12, 2015

Here is the code, I put the code all the way at the boottom because I couldn't find foreach ($news as $n) { in index.php

Code:

<?php require_once 'engine/init.php'; include 'layout/overall/header.php';

    if (!isset($_GET['page'])) {
        $page = 0;
    } else {
        $page = (int)$_GET['page'];
    }

    if ($config['allowSubPages'] && file_exists("layout/sub/index.php")) include 'layout/sub/index.php';
    else {
        if ($config['UseChangelogTicker']) {
            //////////////////////
            // Changelog ticker //
            // Load from cache
            $changelogCache = new Cache('engine/cache/changelog');
            $changelogs = $changelogCache->load();

            if (isset($changelogs) && !empty($changelogs) && $changelogs !== false) {
                ?>
                <table id="changelogTable">
                    <tr class="yellow">
                        <td colspan="2">Latest Changelog Updates (<a href="changelog.php">Click here to see full changelog</a>)</td>
                    </tr>
                    <?php
                    for ($i = 0; $i < count($changelogs) && $i < 5; $i++) {
                        ?>
                        <tr>
                            <td><?php echo getClock($changelogs[$i]['time'], true, true); ?></td>
                            <td><?php echo $changelogs[$i]['text']; ?></td>
                        </tr>
                        <?php
                    }
                    ?>
                </table>
                <?php
            } else echo "No changelogs submitted.";
        }
       
        $cache = new Cache('engine/cache/news');
        if ($cache->hasExpired()) {
            $news = fetchAllNews();
            $cache->setContent($news);
            $cache->save();
        } else {
            $news = $cache->load();
        }
       
        // Design and present the list
        if ($news) {
           
            $total_news = count($news);
            $row_news = $total_news / $config['news_per_page'];
            $page_amount = ceil($total_news / $config['news_per_page']);
            $current = $config['news_per_page'] * $page;

            function TransformToBBCode($string) {
                $tags = array(
                    '[center]{$1}[/center]' => '<center>$1</center>',
                    '[b]{$1}[/b]' => '<b>$1</b>',
                    '[size={$1}]{$2}[/size]' => '<font size="$1">$2</font>',
                    '[img]{$1}[/img]'    => '<a href="$1" target="_BLANK"><img src="$1" alt="image" style="width: 100%"></a>',
                    '[link]{$1}[/link]'    => '<a href="$1">$1</a>',
                    '[link={$1}]{$2}[/link]'   => '<a href="$1" target="_BLANK">$2</a>',
                    '[color={$1}]{$2}[/color]' => '<font color="$1">$2</font>',
                    '[*]{$1}[/*]' => '<li>$1</li>',
                    '[youtube]{$1}[/youtube]' => '<div class="youtube"><div class="aspectratio"><iframe src="//www.youtube.com/embed/$1" frameborder="0" allowfullscreen></iframe></div></div>',
                );
// Most powerful guilds for TFS 0.3/4 and 1.0
////////////////////////
// Create a cache file to avoid high SQL load
$cache = new Cache('engine/cache/guilds');
if ($cache->hasExpired()) {
    // Fetch guild data
 
if ($config['TFSVersion'] == 'TFS_03') $guilds = mysql_select_multi('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, 3;');
elseif ($config['TFSVersion'] == 'TFS_10') $guilds = mysql_select_multi('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, 3;');
    $cache->setContent($guilds);
    $cache->save();
} else {
    $guilds = $cache->load();
}
if (!empty($guilds) || !$guilds) {
    $divsize = 400;
    ?>
    <!-- No table design -->
    <center><h1>Most powerful guilds</h1></center>
    <div style="margin: auto; width: <?php echo $divsize; ?>px;">
        <?php
        $number = 1;
        foreach ($guilds as $guild) {
            ?>
            <div style="float: left; width: <?php echo (int)$divsize / 3; ?>px;">
                <a href="guilds.php?name=<?php echo $guild['name']; ?>"><img style="max-width: <?php echo (int)$divsize / 3; ?>px;" src="medals/<?php echo $number; ?>.png" alt="<?php echo $number; ?>"><br>
                <center><b><?php echo $guild['name']; ?></b><br>
                Kills: <?php echo $guild['frags']; ?></center></a>
            </div>
            <?php
            $number++;
        }
        ?>
    </div>
    <!-- With table design -->
    <table id="news">
        <tr class="yellow">
            <td class="zheadline"><center><b>Most powerful guilds</b></center></td>
        </tr>
        <tr>
            <td>
                <div style="margin: auto; width: <?php echo $divsize; ?>px;">
                    <?php
                   $number = 1;
                   foreach ($guilds as $guild) {
                       ?>
                       <div style="float: left; width: <?php echo (int)$divsize / 3; ?>px;">
                           <a href="guilds.php?name=<?php echo $guild['name']; ?>"><img style="max-width: <?php echo (int)$divsize / 3; ?>px;" src="medals/<?php echo $number; ?>.png" alt="<?php echo $number; ?>"><br>
                           <center><b><?php echo $guild['name']; ?></b><br>
                           Kills: <?php echo $guild['frags']; ?></center></a>
                       </div>
                       <?php
                       $number++;
                   }
                   ?>
               </div>
            </td>
        </tr>
    </table>
<?php
}
// End powerful guilds
                foreach ($tags as $tag => $value) {
                    $code = preg_replace('/placeholder([0-9]+)/', '(.*?)', preg_quote(preg_replace('/\{\$([0-9]+)\}/', 'placeholder$1', $tag), '/'));
                    $string = preg_replace('/'.$code.'/i', $value, $string);
                }
                return $string;
            }
            for ($i = $current; $i < $current + $config['news_per_page']; $i++) {
                if (isset($news[$i])) {
                    ?>
                    <table id="news">
                        <tr class="yellow">
                            <td class="zheadline"><?php echo getClock($news[$i]['date'], true) .' by <a href="characterprofile.php?name='. $news[$i]['name'] .'">'. $news[$i]['name'] .'</a> - <b>'. TransformToBBCode($news[$i]['title']) .'</b>'; ?></td>
                        </tr>
                        <tr>
                            <td>
                                <p><?php echo TransformToBBCode(nl2br($news[$i]['text'])); ?></p>
                            </td>
                        </tr>
                    </table>
                    <?php
                }
            }


            echo '<select name="newspage" onchange="location = this.options[this.selectedIndex].value;">';

            for ($i = 0; $i < $page_amount; $i++) {

                if ($i == $page) {

                    echo '<option value="index.php?page='.$i.'" selected>Page '.$i.'</option>';

                } else {

                    echo '<option value="index.php?page='.$i.'">Page '.$i.'</option>';
                }
            }
           
            echo '</select>';

        } else {
            echo '<p>No news exist.</p>';
        }
    }
include 'layout/overall/footer.php'; ?>

pierroth · Oct 13, 2015

Anyone? How to add it?

There's no code

Code:

 ($news as $n) {

in index.php

Znote · Oct 24, 2015

pierroth said:
Anyone? How to add it?

There's no code

Code:

($news as $n) {

in index.php

Updated it now.

In index.php, before:

PHP:

$cache = new Cache('engine/cache/news');

Deleted member 49793 · Oct 24, 2015

Znote said:
Updated it now.

In index.php, before:

PHP:

$cache = new Cache('engine/cache/news');

Omg a wild Znote appears

ricardo231 · Sep 8, 2016

help me

Warning: Invalid argument supplied for foreach() inC:\xampp\htdocs\index.php on line 69

biagitox · Feb 21, 2017

Hi! I'm using TFS 1.x and My Web don't shows anything. Take a look:

Please, anybody can help me with? (Sorry for my English)

bok · Apr 8, 2017

please re-upload imagens with medals.

megagaea · Jul 29, 2017

Znote said:

Created 2 versions, with table design and without, just remove the one that does not fit your layout.
View attachment 29705
In index.php, before:

PHP:

$cache = new Cache('engine/cache/news');

Add this code:

PHP:

// Most powerful guilds for TFS 0.3/4 and 1.0
////////////////////////
// Create a cache file to avoid high SQL load
$cache = new Cache('engine/cache/guilds');
if ($cache->hasExpired()) {
    // Fetch guild data
 
if ($config['TFSVersion'] == 'TFS_03') $guilds = mysql_select_multi('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, 3;');
elseif ($config['TFSVersion'] == 'TFS_10') $guilds = mysql_select_multi('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, 3;');
    $cache->setContent($guilds);
    $cache->save();
} else {
    $guilds = $cache->load();
}
if (!empty($guilds) || !$guilds) {
    $divsize = 400;
    ?>
    <!-- No table design -->
    <center><h1>Most powerful guilds</h1></center>
    <div style="margin: auto; width: <?php echo $divsize; ?>px;">
        <?php
        $number = 1;
        foreach ($guilds as $guild) {
            ?>
            <div style="float: left; width: <?php echo (int)$divsize / 3; ?>px;">
                <a href="guilds.php?name=<?php echo $guild['name']; ?>"><img style="max-width: <?php echo (int)$divsize / 3; ?>px;" src="medals/<?php echo $number; ?>.png" alt="<?php echo $number; ?>"><br>
                <center><b><?php echo $guild['name']; ?></b><br>
                Kills: <?php echo $guild['frags']; ?></center></a>
            </div>
            <?php
            $number++;
        }
        ?>
    </div>
    <!-- With table design -->
    <table id="news">
        <tr class="yellow">
            <td class="zheadline"><center><b>Most powerful guilds</b></center></td>
        </tr>
        <tr>
            <td>
                <div style="margin: auto; width: <?php echo $divsize; ?>px;">
                    <?php
                   $number = 1;
                   foreach ($guilds as $guild) {
                       ?>
                       <div style="float: left; width: <?php echo (int)$divsize / 3; ?>px;">
                           <a href="guilds.php?name=<?php echo $guild['name']; ?>"><img style="max-width: <?php echo (int)$divsize / 3; ?>px;" src="medals/<?php echo $number; ?>.png" alt="<?php echo $number; ?>"><br>
                           <center><b><?php echo $guild['name']; ?></b><br>
                           Kills: <?php echo $guild['frags']; ?></center></a>
                       </div>
                       <?php
                       $number++;
                   }
                   ?>
               </div>
            </td>
        </tr>
    </table>
<?php
}
// End powerful guilds

Download medals.zip and extract it to your Znote AAC folder to make images work.

Thanks to @gremlee for letting me borrow his database while creating this.

pro Why u Dont Send the database next script i mean Createtable i cant found or make Mulit _select table soo i cant use any scripts u add ..

Pedrook · Oct 5, 2017

Znote said:
Ahh great! Thanks.

how to put their guild logo? instead of the medals?

Erickso · Feb 6, 2020

Hi @Znote , is this working on TFS1.3? tried to install but...

Code:

Warning
: Invalid argument supplied for foreach() in
/home/otsmanager/www/public_html/index.php
on line
74

Thank's in advance

Znote · Feb 6, 2020

Erickso said:
Hi @Znote , is this working on TFS1.3? tried to install but...

Code:

Warning : Invalid argument supplied for foreach() in /home/otsmanager/www/public_html/index.php on line 74

Thank's in advance

Yes, but the code assumes that at least 1 guild exist on the server, so it throws a warning when it tries to loop through an empty list of guilds.

Erickso · Feb 6, 2020

Znote said:
Yes, but the code assumes that at least 1 guild exist on the server, so it throws a warning when it tries to loop through an empty list of guilds.

Make's sence. Thanks!

dredwan · Feb 17, 2020

it's working fine in TFS 1.3?

Erickso · Feb 18, 2020

dredwan said:
it's working fine in TFS 1.3?

Yes, it work's, you only need at least 1 guild in your db or it will show a warning message.

Lurk · Jun 27, 2020

what if I want the image the players chose for their guild on the website (custom or default) to show instead of the medals?

Znote · Jun 27, 2020

Lurk said:
what if I want the image the players chose for their guild on the website (custom or default) to show instead of the medals?

Replace:

Code:

src="medals/<?php echo $number; ?>.png"

With:

Code:

src="engine/guildimg/<?php echo $guild['name']; ?>.gif"

Lurk · Jun 28, 2020

@Znote how can I clean my guilds.cache.php? there's been a loot of killing but no changes to the rank, if I simply delete eveyrhting from the file I get an error when loading the page

Znote · Jun 28, 2020

Lurk said:
@Znote how can I clean my guilds.cache.php? there's been a loot of killing but no changes to the rank, if I simply delete eveyrhting from the file I get an error when loading the page

Could be a cache write problem, what happens when you execute this SQL code in phpmyadmin -> yourDatabase:

SQL:

SELECT 
    `g`.`id` AS `id`, 
    `g`.`name` AS `name`, 
    COUNT(`g`.`name`) as `frags` 
FROM `killers` AS `k` 
LEFT JOIN `player_killers` AS `pk` 
    ON `k`.`id` = `pk`.`kill_id` 
LEFT JOIN `players` AS `p` 
    ON `pk`.`player_id` = `p`.`id` 
LEFT JOIN `guild_ranks` AS `gr` 
    ON `p`.`rank_id` = `gr`.`id` 
LEFT JOIN `guilds` AS `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, 3;

[Znote AAC] Most powerful guilds (TFS 0.3/4 and 1.0)

Mar Co.

Thanatos

Mar Co.

Mar Co.

<?php echo $title; ?>

Deleted member 49793

Guest

New Member

New Member

Member

Scripter and mapper

Advanced OT User

Omaar&Steph

<?php echo $title; ?>

Omaar&Steph

New Member

Omaar&Steph

Active Member

<?php echo $title; ?>

Active Member

<?php echo $title; ?>

Similar threads