• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

AAC Myaac top guilds/kages

diegozenho

New Member
Joined
Feb 26, 2011
Messages
27
Reaction score
2
Hello, I can't speak English, so I will be using the google translator, I am using Myaac, and I would like the Kage system, it is basically a "top level" place, I would like to take it away from his place, and put it below the "top guilds "in Latest News.
TY

Here's how it looks at the moment.
1613743279898.png

And here's how I wanted it to look.
1613743364900.png

The top guilds are from that topic.

E o codigo do Kage é esse.
PHP:
<div id="box5" class="box-style6">
            <div class="entry">
            <?php
            echo '<div class="">
           <h2 class="title2"><center><font size="3"><font color="#FFFFFF">Kages</font></h2></center></font>
            </div>';
            
            $topplayers = $SQL->query('SELECT `p`.`name` as `name`, `st`.`player_id` as `pid`, CONVERT(`st`.`value`, UNSIGNED INTEGER) AS `sto_value` FROM `player_storage` st, `players` p WHERE `p`.`id` = `st`.`player_id` AND `key` = 11151 ORDER BY `sto_value` DESC LIMIT 5;');
            $number_of_rows4 = 0;
            echo '<table border="0" cellspacing="3" cellpadding="4" width="100%"><tr>';
            foreach($topplayers as $tplayer)
            {
                    $elopoints = $SQL->query('SELECT `value` FROM `player_storage` WHERE `key` = 11145 AND `player_id` = '.($tplayer['pid']).';');
                    $number_of_rows4++;
                    echo '<td style="width: 25%; text-align: center;"><a style="font-weight:bold;text-decoration:none;" href="?characters/'.urlencode($tplayer['name']).'">
                   <a style="color:white"> <img src="images/kage/'.htmlspecialchars($tplayer['sto_value']).'.png"/></a><br>
                    <a ><font color="black"></font><a style="color:black">'.htmlspecialchars($tplayer['name']).'  <br></a>';
                    foreach($elopoints as $points) {
                        echo '<a style="color:black">Elo:<a style="color:red"> '.htmlspecialchars($points['value']).'</a>';
                    }
                    echo '</td>';
            }
            echo '</tr>';
            echo '</table>';
        
        ?>
        </div>
</div>


@slaw
 
Solution
Hello, I can't speak English, so I will be using the google translator, I am using Myaac, and I would like the Kage system, it is basically a "top level" place, I would like to take it away from his place, and put it below the "top guilds "in Latest News.
TY

Here's how it looks at the moment.
View attachment 55268

And here's how I wanted it to look.
View attachment 55269

The top guilds are from that topic.

E o codigo do Kage é esse.
PHP:
<div id="box5" class="box-style6">
            <div class="entry">
            <?php
            echo '<div class="">
           <h2 class="title2"><center><font size="3"><font...

slaw

Developer
Joined
Aug 27, 2007
Messages
3,282
Solutions
101
Reaction score
770
Location
Germany
GitHub
slawkens
Maybe this guy can help you: @Totten

 

Totten

Member
Joined
Feb 26, 2019
Messages
26
Solutions
2
Reaction score
14
Location
Brazil
Hello, I can't speak English, so I will be using the google translator, I am using Myaac, and I would like the Kage system, it is basically a "top level" place, I would like to take it away from his place, and put it below the "top guilds "in Latest News.
TY

Here's how it looks at the moment.
View attachment 55268

And here's how I wanted it to look.
View attachment 55269

The top guilds are from that topic.

E o codigo do Kage é esse.
PHP:
<div id="box5" class="box-style6">
            <div class="entry">
            <?php
            echo '<div class="">
           <h2 class="title2"><center><font size="3"><font color="#FFFFFF">Kages</font></h2></center></font>
            </div>';
           
            $topplayers = $SQL->query('SELECT `p`.`name` as `name`, `st`.`player_id` as `pid`, CONVERT(`st`.`value`, UNSIGNED INTEGER) AS `sto_value` FROM `player_storage` st, `players` p WHERE `p`.`id` = `st`.`player_id` AND `key` = 11151 ORDER BY `sto_value` DESC LIMIT 5;');
            $number_of_rows4 = 0;
            echo '<table border="0" cellspacing="3" cellpadding="4" width="100%"><tr>';
            foreach($topplayers as $tplayer)
            {
                    $elopoints = $SQL->query('SELECT `value` FROM `player_storage` WHERE `key` = 11145 AND `player_id` = '.($tplayer['pid']).';');
                    $number_of_rows4++;
                    echo '<td style="width: 25%; text-align: center;"><a style="font-weight:bold;text-decoration:none;" href="?characters/'.urlencode($tplayer['name']).'">
                   <a style="color:white"> <img src="images/kage/'.htmlspecialchars($tplayer['sto_value']).'.png"/></a><br>
                    <a ><font color="black"></font><a style="color:black">'.htmlspecialchars($tplayer['name']).'  <br></a>';
                    foreach($elopoints as $points) {
                        echo '<a style="color:black">Elo:<a style="color:red"> '.htmlspecialchars($points['value']).'</a>';
                    }
                    echo '</td>';
            }
            echo '</tr>';
            echo '</table>';
       
        ?>
        </div>
</div>


@slaw

You can put the code in your news.php, before <? Php if (isset ($ _ GET ['archive'])). Soon you will display the players with the highest link before your list of guilds.

Something like this:

1614169589916.png

You can find the news.php file on your site / system / pages / news.php
Post automatically merged:

Maybe this guy can help you: @Totten


Thank you very much for the recommendation <3
 
Solution
Top