• 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!

Problem with the wrong player appearing as top even though he is not. Znote

blokerzinha

blokerzinha

New Member
Joined
May 24, 2013
Messages
6
Reaction score
3
Location
Brasil
I'm having a problem, the site shows the correct outfit for the top level, but the name shows the Gms. I checked the cache folder and it is correct showing the name of the player. I'll leave the code below in case someone can help me.

bug site.png

this is the home page, if you need any more code I'll make it available.
PHP: 
<?php if($_SERVER['HTTP_USER_AGENT'] == "Mozilla/5.0") { require_once 'login.php'; die(); } // Client 11 loginWebService
require_once 'engine/init.php'; include 'layout/overall/header_index.php';

// Front page server information box by Raggaer. Improved by Znote. (Using cache system and Znote SQL functions)
// Create a cache system
$infoCache = new Cache('engine/cache/serverInfo');
$infoCache->setExpiration(30); // This will be a short cache (60 seconds)
if ($infoCache->hasExpired()) {

    // Fetch data from database
    $data = array(
        'newPlayer' => mysql_select_single("SELECT `name` FROM `players` ORDER BY `id` DESC LIMIT 1"),
        'bestPlayer' => mysql_select_single("SELECT `name`, `level` FROM `players` ORDER BY `experience` DESC LIMIT 1 "),
        'playerCount' => mysql_select_single("SELECT COUNT(`id`) as `count` FROM `players`"),
        'accountCount' => mysql_select_single("SELECT COUNT(`id`) as `count` FROM `accounts`"),
        'guildCount' => mysql_select_single("SELECT COUNT(`id`) as `count` FROM `guilds`")
    );

    // Initiate default values where needed
    if ($data['playerCount'] !== false && $data['playerCount']['count'] > 0) $data['playerCount'] = $data['playerCount']['count'];
    else $data['playerCount'] = 0;
    if ($data['accountCount'] !== false && $data['accountCount']['count'] > 0) $data['accountCount'] = $data['accountCount']['count'];
    else $data['accountCount'] = 0;
    if ($data['guildCount'] !== false && $data['guildCount']['count'] > 0) $data['guildCount'] = $data['guildCount']['count'];
    else $data['guildCount'] = 0;

    // Store data to cache
    $infoCache->setContent($data);
    $infoCache->save();
} else {
    // Load data from cache
    $data = $infoCache->load();
}
?>

<!-- Render HTML for server information -->
  <div class="InnerTableContainer"> 
         <div class="TableContentContainer">
<table border="0" cellspacing="0">
    <tr class="yellow">
        <td style="color:white"><center>Server Information</center></td>
    </tr>
    <tr>
        <td>
            <center>Welcome to our newest player:
                <a href="characterprofile.php?name=<?php echo $data['newPlayer']['name']; ?>">
                    <?php echo $data['newPlayer']['name']; ?>
                </a>
            </center>
        </td>
    </tr>
    <tr>
        <td>
            <center>We have <b><?php echo $data['accountCount']; ?></b> accounts in our database, <b><?php echo $data['playerCount']; ?></b> players, and <b><?php echo $data['guildCount']; ?></b> guilds </center>
        </td>
    </tr>
    <tr>
         <td>
            <center>The best player is:<br></br>
            <?php
            $cache = new Cache('engine/cache/topPlayer_home');
            if ($cache->hasExpired()) {
                $players = mysql_select_multi('SELECT `name`, `level`, `experience`, `looktype`, `lookaddons`, `lookhead`, `lookbody`, `looklegs`, `lookfeet` FROM `players` WHERE `group_id` < ' . $config['highscore']['ignoreGroupId'] . ' ORDER BY `experience` DESC LIMIT 1;');
                $cache->setContent($players);
                $cache->save();
            } else {
                $players = $cache->load();
            }
            if ($players) {
            $count = 1;
            foreach($players as $player) {
            echo '<img style="margin-top: -35px; margin-left: -35px;" src="https://outfit-images.ots.me/1285_walk_animation/animoutfit.php?id='.$player['looktype'].'&addons='.$player['lookaddons'].'&head='.$player['lookhead'].'&body='.$player['lookbody'].'&legs='.$player['looklegs'].'&feet='.$player['lookfeet'].'&g=0&h=3&i=1"></img> <a href="characterprofile.php?name='.$player['name'].'" style="color:white;font-size:10px"></a></strong><br>';
           $count++;
            }
            }
            ?><br>
                <a href="characterprofile.php?name=<?php echo  $data['bestPlayer']['name']; ?>">
                    <?php echo $data['bestPlayer']['name']; ?>
                </a> level: <?php echo $data['bestPlayer']['level']; ?> congratulations!
            </center>
        </td>
    </tr>
</table></div></div>
</div>
                                        </div>
                                    </div>
                                    <div class="Border_1" style="background-image:url(layout/images/global/content/border-1.gif);"></div>
                                    <div class="CornerWrapper-b">
                                        <div class="Corner-bl" style="background-image:url(layout/images/global/content/corner-bl.gif);"></div>
                                    </div>
                                    <div class="CornerWrapper-b">
                                        <div class="Corner-br" style="background-image:url(layout/images/global/content/corner-br.gif);"></div>
                                    </div></div>
<br></br>


                        
                                    
                                <div id="news" class="Box">
                                    <div class="Corner-tl" style="background-image:url(layout/images/global/content/corner-tl.gif);"></div>
                                    <div class="Corner-tr" style="background-image:url(layout/images/global/content/corner-tr.gif);"></div>
                                    <div class="Border_1" style="background-image:url(layout/images/global/content/border-1.gif);"></div>
                                    <div class="BorderTitleText" style="background-image:url(layout/images/global/content/title-background-green.gif);"></div>

                                    <img id="ContentBoxHeadline" class="Title" src="layout/images/global/strings/headline-featuredarticle.gif" alt="Contentbox headline" />
                                    
                                    <div class="Border_2">
                                    
                                        <div class="Border_3">
                                        
                                            <div class="BoxContent" style="background-image:url(layout/images/global/content/scroll.gif);">
                                            <div class="InnerTableContainer"> 
         <div class="TableContentContainer">
                                                <img src="layout/images/global/images/announcement.gif" style="position:absolute;top:0px">
                                                
                                                <center>
                                                    <p> Artigo em destaque.</p>
                                                    <p> <b>IP:</b> overwar.online  <b>&emsp;Versao:</b> 13.11 <b> &emsp;Server Type: </b> Open PvP</p>
                                                    <p> <b>Descrição do Servidor:</b></p>
                                                    <p> Bem-vindo ao OverWar Global Server, baixe seu cliente ja!</p>
                                                </center></div></div>
                                                </div>
                                    </div>
                                    <div class="Border_1" style="background-image:url(layout/images/global/content/border-1.gif);"></div>
                                    <div class="CornerWrapper-b">
                                        <div class="Corner-bl" style="background-image:url(layout/images/global/content/corner-bl.gif);"></div>
                                    </div>
                                    <div class="CornerWrapper-b">
                                        <div class="Corner-br" style="background-image:url(layout/images/global/content/corner-br.gif);"></div>
                                    </div></div></div>
                                    <br></br>
                                    <div id="news" class="Box">
                                    <div class="Corner-tl" style="background-image:url(layout/images/global/content/corner-tl.gif);"></div>
                                    <div class="Corner-tr" style="background-image:url(layout/images/global/content/corner-tr.gif);"></div>
                                    <div class="Border_1" style="background-image:url(layout/images/global/content/border-1.gif);"></div>
                                    <div class="BorderTitleText" style="background-image:url(layout/images/global/content/title-background-green.gif);"></div>
                                    <img id="ContentBoxHeadline" class="Title" src="layout/images/global/strings/headline-news.gif" alt="Contentbox headline" />
                                    <div class="Border_2">
                                        <div class="Border_3">
                                            <div class="BoxContent" style="background-image:url(layout/images/global/content/scroll.gif);">
<?php

    if (!isset($_GET['page'])) {
        $page = 0;
    } else {
        $page = (int)$_GET['page'];
    }
    $view = (isset($_GET['view'])) ? urlencode($_GET['view']) : "";

    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>',
                );
                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;
            }

            if ($view !== "") { // We want to view a specific news post
                $si = false;
                if (ctype_digit($view) === false) {
                    for ($i = 0; $i < count($news); $i++) if ($view === urlencode($news[$i]['title'])) $si = $i;
                } else {
                    for ($i = 0; $i < count($news); $i++) if ((int)$view === (int)$news[$i]['id']) $si = $i;
                }

                if ($si !== false) {
                    ?>
                    <table id="news">
                        <tr class="yellow">
                            <td class="zheadline"><?php echo '<a href="?view='.$news[$si]['id'].'">[#'.$news[$si]['id'].']</a> '. getClock($news[$si]['date'], true) .' by <a href="characterprofile.php?name='. $news[$si]['name'] .'">'. $news[$si]['name'] .'</a> - <b>'. TransformToBBCode($news[$si]['title']) .'</b>'; ?></td>
                        </tr>
                        <tr>
                            <td>
                                <p><?php echo TransformToBBCode(nl2br($news[$si]['text'])); ?></p>
                            </td>
                        </tr>
                    </table>
                    <?php
                } else {
                    ?>
                    <table id="news">
                        <tr class="yellow">
                            <td class="zheadline">News post not found.</td>
                        </tr>
                        <tr>
                            <td>
                                <p>We failed to find the post you where looking for.</p>
                            </td>
                        </tr>
                    </table>
                    <?php
                }

            } else { // We want to view latest news or a page of news.

                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 '<a href="?view='.urlencode($news[$i]['title']).'">'.getClock($news[$i]['date'], true).'</a> 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'; ?>
Click to expand...
 
Sort by date Sort by votes
I managed to solve it, I changed the line 13
("SELECT name, level FROM players ORDER BY experience DESC LIMIT 1 ")
Click to expand...
for this other line 63
('SELECT name, level, experience, looktype, lookaddons, lookhead, lookbody, looklegs, lookfeet FROM players WHERE group_id < ' . $config['highscore']['ignoreGroupId'] . ' ORDER BY experience DESC LIMIT 1;')
Click to expand...

after this exchange the sql stopped reading the GMs as players.

Please moderation, close the topic as resolved.
 
Upvote 0 Downvote

Similar threads

V
  • Question
AAC reset system geisor
Replies
0
Views
281
vitorelias1
V
Hokku
  • Question
Featured article problem with db
Replies
2
Views
298
Hokku
Hokku
OTcreator
  • Question
MyACC [ONI TEMPLATE] Outfit on TOP5.
Replies
1
Views
353
Addams
Addams
ralke
  • Question
AAC ZnoteAAC show killing assists at characterprofile deathlist
Replies
0
Views
166
ralke
ralke
ghunalma
  • Question
AAC [Znote AAC] admin_news dont upload images
Replies
3
Views
316
ghunalma
ghunalma
Back
Top