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

TFS 1.X+ Znote Acc Undefined index

Joriku

Joriku

Working in the mines, need something?
Joined
Jul 16, 2016
Messages
1,085
Solutions
15
Reaction score
379
Location
Sweden
YouTube
Joriku
ea442e6105fbe6c1727e4054e9a3867c.png

Screenshot - ea442e6105fbe6c1727e4054e9a3867c - Gyazo (https://gyazo.com/ea442e6105fbe6c1727e4054e9a3867c)
Lua: 
<?php require_once 'engine/init.php';

if ($config['log_ip']) {
    znote_visitor_insert_detailed_data(3);
}

function fetchAllScoresh($rows, $tfs, $g, $v = -1) {
    // Return scores ordered by type and vocation (if set)
    $data = array();
    if ($tfs == 'TFS_10') {

        // Generate SQL WHERE-clause for vocation if $v is set
        $v = ($v > -1) ? 'AND `vocation` = '. intval($v) : NULL;

        $data[1] = mysql_select_multi("SELECT `id`, `name`, `vocation`, `skill_club` AS `value` FROM `players` WHERE `group_id` < $g $v ORDER BY `skill_club` DESC LIMIT 0, $rows;");
        $data[2] = mysql_select_multi("SELECT `id`, `name`, `vocation`, `skill_sword` AS `value` FROM `players` WHERE `group_id` < $g $v ORDER BY `skill_sword` DESC LIMIT 0, $rows;");
        $data[3] = mysql_select_multi("SELECT `id`, `name`, `vocation`, `skill_axe` AS `value` FROM `players` WHERE `group_id` < $g $v ORDER BY `skill_axe` DESC LIMIT 0, $rows;");
        $data[4] = mysql_select_multi("SELECT `id`, `name`, `vocation`, `skill_dist` AS `value` FROM `players` WHERE `group_id` < $g $v ORDER BY `skill_dist` DESC LIMIT 0, $rows;");
        $data[5] = mysql_select_multi("SELECT `id`, `name`, `vocation`, `skill_shielding` AS `value` FROM `players` WHERE `group_id` < $g $v ORDER BY `skill_shielding` DESC LIMIT 0, $rows;");
        $data[6] = mysql_select_multi("SELECT `id`, `name`, `vocation`, `skill_fishing` AS `value` FROM `players` WHERE `group_id` < $g $v ORDER BY `skill_fishing` DESC LIMIT 0, $rows;");
        $data[7] = mysql_select_multi("SELECT `id`, `name`, `vocation`, `experience`, `level` AS `value` FROM `players` WHERE `group_id` < $g $v ORDER BY `experience` DESC LIMIT 0, $rows;");
        $data[8] = mysql_select_multi("SELECT `id`, `name`, `vocation`, `maglevel` AS `value` FROM `players` WHERE `group_id` < $g $v ORDER BY `maglevel` DESC LIMIT 0, $rows;");
        $data[9] = mysql_select_multi("SELECT `id`, `name`, `vocation`, `skill_fist` AS `value` FROM `players` WHERE `group_id` < $g $v ORDER BY `skill_fist` DESC LIMIT 0, $rows;");
    } else {

        // Generate SQL WHERE-clause for vocation if $v is set
        $v = ($v > -1) ? 'AND `vocation` = '. intval($v) : NULL;

        $data[9] = mysql_select_multi("SELECT `looktype`, `lookhead`, `lookbody`, `looklegs`, `lookfeet`, `s`.`player_id` AS `id`, `s`.`value` AS `value`, `p`.`name` AS `name`, `p`.`vocation` AS `vocation` FROM `player_skills` AS `s` LEFT JOIN `players` AS `p` ON `s`.`player_id`=`p`.`id` WHERE `s`.`skillid` = 0 AND `p`.`group_id` < $g $v ORDER BY `s`.`value` DESC LIMIT 0, $rows;");
        $data[1] = mysql_select_multi("SELECT `looktype`, `lookhead`, `lookbody`, `looklegs`, `lookfeet`, `s`.`player_id` AS `id`, `s`.`value` AS `value`, `p`.`name` AS `name`, `p`.`vocation` AS `vocation` FROM `player_skills` AS `s` LEFT JOIN `players` AS `p` ON `s`.`player_id`=`p`.`id` WHERE `s`.`skillid` = 1 AND `p`.`group_id` < $g $v ORDER BY `s`.`value` DESC LIMIT 0, $rows;");
        $data[2] = mysql_select_multi("SELECT `looktype`, `lookhead`, `lookbody`, `looklegs`, `lookfeet`, `s`.`player_id` AS `id`, `s`.`value` AS `value`, `p`.`name` AS `name`, `p`.`vocation` AS `vocation` FROM `player_skills` AS `s` LEFT JOIN `players` AS `p` ON `s`.`player_id`=`p`.`id` WHERE `s`.`skillid` = 2 AND `p`.`group_id` < $g $v ORDER BY `s`.`value` DESC LIMIT 0, $rows;");
        $data[3] = mysql_select_multi("SELECT `looktype`, `lookhead`, `lookbody`, `looklegs`, `lookfeet`, `s`.`player_id` AS `id`, `s`.`value` AS `value`, `p`.`name` AS `name`, `p`.`vocation` AS `vocation` FROM `player_skills` AS `s` LEFT JOIN `players` AS `p` ON `s`.`player_id`=`p`.`id` WHERE `s`.`skillid` = 3 AND `p`.`group_id` < $g $v ORDER BY `s`.`value` DESC LIMIT 0, $rows;");
        $data[4] = mysql_select_multi("SELECT `looktype`, `lookhead`, `lookbody`, `looklegs`, `lookfeet`, `s`.`player_id` AS `id`, `s`.`value` AS `value`, `p`.`name` AS `name`, `p`.`vocation` AS `vocation` FROM `player_skills` AS `s` LEFT JOIN `players` AS `p` ON `s`.`player_id`=`p`.`id` WHERE `s`.`skillid` = 4 AND `p`.`group_id` < $g $v ORDER BY `s`.`value` DESC LIMIT 0, $rows;");
        $data[5] = mysql_select_multi("SELECT `looktype`, `lookhead`, `lookbody`, `looklegs`, `lookfeet`, `s`.`player_id` AS `id`, `s`.`value` AS `value`, `p`.`name` AS `name`, `p`.`vocation` AS `vocation` FROM `player_skills` AS `s` LEFT JOIN `players` AS `p` ON `s`.`player_id`=`p`.`id` WHERE `s`.`skillid` = 5 AND `p`.`group_id` < $g $v ORDER BY `s`.`value` DESC LIMIT 0, $rows;");
        $data[6] = mysql_select_multi("SELECT `looktype`, `lookhead`, `lookbody`, `looklegs`, `lookfeet`, `s`.`player_id` AS `id`, `s`.`value` AS `value`, `p`.`name` AS `name`, `p`.`vocation` AS `vocation` FROM `player_skills` AS `s` LEFT JOIN `players` AS `p` ON `s`.`player_id`=`p`.`id` WHERE `s`.`skillid` = 6 AND `p`.`group_id` < $g $v ORDER BY `s`.`value` DESC LIMIT 0, $rows;");
        $data[7] = mysql_select_multi("SELECT `looktype`, `lookhead`, `lookbody`, `looklegs`, `lookfeet`, `id`, `name`, `vocation`, `experience`, `level` AS `value` FROM `players` WHERE `group_id` < $g $v ORDER BY `experience` DESC limit 0, $rows;");
        $data[8] = mysql_select_multi("SELECT `looktype`, `lookhead`, `lookbody`, `looklegs`, `lookfeet`, `id`, `name`, `vocation`, `maglevel` AS `value` FROM `players` WHERE `group_id` < $g $v ORDER BY `maglevel` DESC limit 0, $rows;");
    }
    return $data;
}

// Fetch highscore type
$type = (isset($_GET['type'])) ? (int)getValue($_GET['type']) : 7;
if ($type > 9) $type = 7;

// Fetch highscore vocation
$vocation = (isset($_GET['vocation'])) ? (int)getValue($_GET['vocation']) : -1;
if ($vocation > 8) $vocation = -1;

// Fetch highscore page
$page = getValue(@$_GET['pag']);
if (!$page || $page == 0) $page = 1;
else $page = (int)$page;

$highscore = $config['highscore'];

$rows = $highscore['rows'];
$rowsPerPage = $highscore['rowsPerPage'];

function skillName($type) {
    $types = array(
        1 => "Club",
        2 => "Sword",
        3 => "Axe",
        4 => "Distance",
        5 => "Shield",
        6 => "Fish",
        7 => "Experience", // Hardcoded
        8 => "Magic Level", // Hardcoded
        9 => "Fist", // Since 0 returns false I will make 9 = 0. :)
    );
    return $types[(int)$type];
}

function pageCheck($index, $page, $rowPerPage) {
    return ($index < ($page * $rowPerPage) && $index >= ($page * $rowPerPage) - $rowPerPage) ? true : false;
}

$cache = new Cache('engine/cache/highscores');
if ($cache->hasExpired()) {
    $scores = fetchAllScoresh($rows, $config['TFSVersion'], $highscore['ignoreGroupId'], $vocation);
    
    $cache->setContent($scores);
    $cache->save();
} else {
    $scores = $cache->load();
}

if ($scores) {
    ?>
        <style>
            .newstext img
            {
                max-width: 562px;
                height: auto;
                margin: 0 5px;
            }
            .pagination
            {
                text-align: center;
                margin: 10px 0;
            }
            .pagination a
            {
                display: inline-block;
                color: #52412f;
                font-size: 14px;
                line-height: 24px;
                height: 24px;
                width: 24px;
                font-weight: bold;
                text-align: center;
                border: 1px solid #886a4d;
                margin: 0 5px 0 0;
                border-radius: 24px;
                box-shadow: 0 2px 3px rgb(255, 214, 175) inset;
                background: #dcaf83;
                transition: opacity 0.1s linear;
            }
            .pagination a:hover
            {
                opacity: 0.7;
            }
            .pagination a.current
            {
                background: #ad1a1a;
                color: #fff;
                border: 1px solid #000000;
                box-shadow: 0 2px 3px rgb(255, 62, 62) inset;
            }
        </style>
        
    <form type="submit" action="" method="GET">
    <br>
    <center>Skill: <input type="hidden" name="page" value="highscores"/>
        <select style="vertical-align:middle;" name="type">
            <option value="7" <?php if ($type == 7) echo "selected"; ?>>Experience</option>
            <option value="8" <?php if ($type == 8) echo "selected"; ?>>Magic</option>
            <option value="5" <?php if ($type == 5) echo "selected"; ?>>Shield</option>
            <option value="2" <?php if ($type == 2) echo "selected"; ?>>Sword</option>
            <option value="1" <?php if ($type == 1) echo "selected"; ?>>Club</option>
            <option value="3" <?php if ($type == 3) echo "selected"; ?>>Axe</option>
            <option value="4" <?php if ($type == 4) echo "selected"; ?>>Distance</option>
            <option value="6" <?php if ($type == 6) echo "selected"; ?>>Fish</option>
            <option value="9" <?php if ($type == 9) echo "selected"; ?>>Fist</option>
        </select>
        &nbsp;&nbsp;Vocation: <select style="vertical-align:middle;" name="vocation">
            <option value="-1" <?php if ($vocation < 0) echo "selected"; ?>>Any vocation</option>

            <?php
            foreach (config('vocations') as $v_id => $v_name) {
                $selected = ($vocation == $v_id) ? " selected" : NULL;

                echo '<option value="'. $v_id .'"'. $selected .'>'. $v_name .'</option>';
            }
            ?>
        </select>
        
         <input type="submit" class="hover" value=""
    style="background-image: url(layout/tibia_img/sbutton_submit.gif); vertical-align:middle; border: solid 0px #000000; width: 120px; height: 18px;" />
        </center>
    </form>
    
    
        <br><center><span class="pagination">
            <?php
            $pages = ceil(min(($highscore['rows'] / $highscore['rowsPerPage']), (count($scores[$type]) / $highscore['rowsPerPage'])));
            for ($i = 0; $i < $pages; $i++) {
                $x = $i + 1;
                if ($x == $page) echo "<a href=\"?".$_SERVER['QUERY_STRING']."&pag=".$x."\" class=\"current\">".$x."</a>";
                else echo "<a href=\"?".$_SERVER['QUERY_STRING']."&pag=".$x."\">".$x."</a>";
            }
            ?>
        </span></center>
        
        
    <table id="highscoresTable" cellpadding="4" class="stripped">
        <tr>    
            <th colspan="7">Ranking for <?php echo skillName($type) .", ". (($vocation < 0) ? 'any vocation' : vocation_id_to_name($vocation)) ?></th>
        </tr>
        <tr>
            <td width="8%"><center>#</center></td>
            <td width="8%"><center><strong>outfit</strong></center></td>
            <?php if ($config['country_flags'] === true) echo'<td width="5%"><center><strong>flag</strong></center></td>'; ?>
            <td><strong>Name</strong></td>
            <td><center><strong>Vocation</strong></center></td>
            <td width="15%"><center><strong>Level</strong></center></td>
            <?php if ($type === 7) echo "<td width=\"15%\"><center><strong>Points</strong></center></td>"; ?>
        </tr>
        <?php
        for ($i = 0; $i < count($scores[$type]); $i++) {
            if ($scores[$type] === false) {
                ?>
                <tr>
                    <td colspan="7">Nothing to show here yet.</td>
                </tr>
                <?php
            } else {
                if (pageCheck($i, $page, $rowsPerPage)) {
                    $profile_data = user_character_data($scores[$type][$i]['id'], 'account_id');

                    $account_data = user_znote_account_data($profile_data['account_id'], 'flag');
                    if ($config['country_flags'] === true) $flag = '<td><center><img src="flags/' . $account_data['flag'] . '.png"></center></td>';
                    else $flag = '';
                    ?>
                    <tr>
                        <td><center><?php echo $i+1; ?>.</center></td>
                        <td>
                        <?php
                            echo '<div style="position:relative; left:-32px; top:-32px;width: 32px;height:32px;">
                            <div style="background-image: url(layout/outfitter/outfit.php?id='.$scores[$type][$i]['looktype'].'&head='.$scores[$type][$i]['lookhead'].'&body='.$scores[$type][$i]['lookbody'].'&legs='.$scores[$type][$i]['looklegs'].'&feet='.$scores[$type][$i]['lookfeet'].');
                                width:64px;height:64px;position:absolute;background-repeat:no-repeat;background-position:right bottom;">
                            </div>';
                        ?>
                    
                        </td>
                        <?php echo $flag; ?>
                        <td><strong><a href="characterprofile.php?name=<?php echo $scores[$type][$i]['name']; ?>"><?php echo $scores[$type][$i]['name']; ?></a></strong></td>
                        <td><center><?php echo vocation_id_to_name($scores[$type][$i]['vocation']); ?></center></td>
                        <td><center><?php echo $scores[$type][$i]['value']; ?></center></td>
                        <?php if ($type === 7) echo "<td><center>". $scores[$type][$i]['experience'] ."</center></td>"; ?>
                    </tr>
                    <?php
                }
            }
        }
        ?>
    </table>
        <center><span class="pagination">
            <?php
            $pages = ceil(min(($highscore['rows'] / $highscore['rowsPerPage']), (count($scores[$type]) / $highscore['rowsPerPage'])));
            for ($i = 0; $i < $pages; $i++) {
                $x = $i + 1;
                if ($x == $page) echo "<a href=\"?".$_SERVER['QUERY_STRING']."&pag=".$x."\" class=\"current\">".$x."</a>";
                else echo "<a  href=\"?".$_SERVER['QUERY_STRING']."&pag=".$x."\">".$x."</a>";
            }
            ?>
        </span></center>
    <?php
 
Sort by date Sort by votes
Select lines 209 to 214 which is this
PHP: 
                        <?php
                            echo '<div style="position:relative; left:-32px; top:-32px;width: 32px;height:32px;">
                            <div style="background-image: url(layout/outfitter/outfit.php?id='.$scores[$type][$i]['looktype'].'&head='.$scores[$type][$i]['lookhead'].'&body='.$scores[$type][$i]['lookbody'].'&legs='.$scores[$type][$i]['looklegs'].'&feet='.$scores[$type][$i]['lookfeet'].');
                                width:64px;height:64px;position:absolute;background-repeat:no-repeat;background-position:right bottom;">
                            </div>';
                        ?>
Then copy this and put it in its place
PHP: 
<?php
            function outfitUrl($arr){
              $url = "'?id=0";
              $str = '';
              foreach($arr as $key => $value){
                if(isset($key) && $key != 'looktype'){
                  $str .= '&'. substr($key, 4) . '=' . $value; 

                }else if(isset($key) && $key == 'looktype'){
                  $url = substr($url, 0, -1) . $value;
                }
              }
             return $url . $str . "'";
            };


                            echo '<div style="position:relative; left:-32px; top:-32px;width: 32px;height:32px;">
                            <div style="background-image: url(layout/outfitter/outfit.php' . outfitUrl($scores[$type][$i]) );
                                width:64px;height:64px;position:absolute;background-repeat:no-repeat;background-position:right bottom;">
                            </div>';
?>
 
Upvote 0 Downvote
I tested this online and it works.
PHP: 
$a = array(
  'looktype' => 10,
  'lookhead' => 22,
  'lookbody' => 1,
  'looklegs' => 33,
  'lookfeet' => 20,
);



function outfitUrl($arr){
  $url = "'?id=0";
  $str = '';
  foreach($arr as $key => $value){
    if(isset($key) && $key != 'looktype'){
      $str .= '&'. substr($key, 4) . '=' . $value; 

    }else if(isset($key) && $key == 'looktype'){
      $url = substr($url, 0, -1) . $value;
    }
  }
 return $url . $str . "'";
};

echo outfitUrl($a);
Code: 
'?id=10&head=22&body=1&legs=33&feet=20'
 
Upvote 0 Downvote
Steve Albert said:
Select lines 209 to 214 which is this
PHP: 
                        <?php
                            echo '<div style="position:relative; left:-32px; top:-32px;width: 32px;height:32px;">
                            <div style="background-image: url(layout/outfitter/outfit.php?id='.$scores[$type][$i]['looktype'].'&head='.$scores[$type][$i]['lookhead'].'&body='.$scores[$type][$i]['lookbody'].'&legs='.$scores[$type][$i]['looklegs'].'&feet='.$scores[$type][$i]['lookfeet'].');
                                width:64px;height:64px;position:absolute;background-repeat:no-repeat;background-position:right bottom;">
                            </div>';
                        ?>
Then copy this and put it in its place
PHP: 
<?php
            function outfitUrl($arr){
              $url = "'?id=0";
              $str = '';
              foreach($arr as $key => $value){
                if(isset($key) && $key != 'looktype'){
                  $str .= '&'. substr($key, 4) . '=' . $value;

                }else if(isset($key) && $key == 'looktype'){
                  $url = substr($url, 0, -1) . $value;
                }
              }
             return $url . $str . "'";
            };


                            echo '<div style="position:relative; left:-32px; top:-32px;width: 32px;height:32px;">
                            <div style="background-image: url(layout/outfitter/outfit.php' . outfitUrl($scores[$type][$i]) );
                                width:64px;height:64px;position:absolute;background-repeat:no-repeat;background-position:right bottom;">
                            </div>';
?>
Click to expand...
Parse error: syntax error, unexpected ')', expecting ',' or ';' in /home/otsmanager/www/public_html/layout/sub/highscores.php on line 226

and on the other one this happens,
58d72bee2dff4cddbcea1ea36a383ffb.png

Screenshot - 58d72bee2dff4cddbcea1ea36a383ffb - Gyazo (https://gyazo.com/58d72bee2dff4cddbcea1ea36a383ffb)
 
Upvote 0 Downvote
Klonera said:
Parse error: syntax error, unexpected ')', expecting ',' or ';' in /home/otsmanager/www/public_html/layout/sub/highscores.php on line 226

and on the other one this happens,
58d72bee2dff4cddbcea1ea36a383ffb.png

Screenshot - 58d72bee2dff4cddbcea1ea36a383ffb - Gyazo (https://gyazo.com/58d72bee2dff4cddbcea1ea36a383ffb)
Click to expand...
LOL sorry but did you copy and paste both posts?

You are not suppose to post both scripts and if there is an error located it at the line number in the error and make the adjustments. The 2nd post was to show it working as an example.
 
Upvote 0 Downvote
Steve Albert said:
LOL sorry but did you copy and paste both posts?

You are not suppose to post both scripts and if there is an error located it at the line number in the error and make the adjustments. The 2nd post was to show it working as an example.
Click to expand...
No, i did not use both at same time. first one and scond one isn't working
 
Upvote 0 Downvote
Klonera said:
No, i did not use both at same time. first one and scond one isn't working
Click to expand...
Then you did something wrong because both codes work. You're not suppose to copy and paste both pieces of code. Just the 1st one the 2nd one is an example to show you that the code works.
 
Upvote 0 Downvote
Steve Albert said:
Then you did something wrong because both codes work. You're not suppose to copy and paste both pieces of code. Just the 1st one the 2nd one is an example to show you that the code works.
Click to expand...
The first one didn't even work, i did replase what you told me to and i got this
Parse error: syntax error, unexpected ')', expecting ',' or ';' in /home/otsmanager/www/public_html/layout/sub/highscores.php on line 226
 
Upvote 0 Downvote
i'm having the same issue hwo did you solve it?
edit: now im having this
Cannot redeclare outfitUrl() (previously declared in
Fatal error: Cannot redeclare outfitUrl() (previously declared in D:\xampp\htdocs\layout\sub\highscores.php:210) in D:\xampp\htdocs\layout\sub\highscores.php on line 210
which is

function outfitUrl($arr){
$url = "'?id=0";
$str = '';
foreach($arr as $key => $value){
if(isset($key) && $key != 'looktype'){
$str .= '&'. substr($key, 4) . '=' . $value;

}else if(isset($key) && $key == 'looktype'){
$url = substr($url, 0, -1) . $value;
}
}
return $url . $str . "'";
};
 
Last edited:
Upvote 0 Downvote
Steve Albert said:
I tested this online and it works.
PHP: 
$a = array(
  'looktype' => 10,
  'lookhead' => 22,
  'lookbody' => 1,
  'looklegs' => 33,
  'lookfeet' => 20,
);



function outfitUrl($arr){
  $url = "'?id=0";
  $str = '';
  foreach($arr as $key => $value){
    if(isset($key) && $key != 'looktype'){
      $str .= '&'. substr($key, 4) . '=' . $value;

    }else if(isset($key) && $key == 'looktype'){
      $url = substr($url, 0, -1) . $value;
    }
  }
 return $url . $str . "'";
};

echo outfitUrl($a);
Code: 
'?id=10&head=22&body=1&legs=33&feet=20'
Click to expand...
help
Parse error: Unclosed '{' on line 199 does not match ')' in D:\xampp\htdocs\layout\sub\highscores.php on line 238

PHP: 
<?php
                   
                    $a = array(
  'looktype' => 10,
  'lookhead' => 22,
  'lookbody' => 1,
  'looklegs' => 33,
  'lookfeet' => 20,
);



function outfitUrl($arr){
  $url = "'?id=0";
  $str = '';
  foreach($arr as $key => $value){
    if(isset($key) && $key != 'looktype'){
      $str .= '&'. substr($key, 4) . '=' . $value;

    }else if(isset($key) && $key == 'looktype'){
      $url = substr($url, 0, -1) . $value;
    }
  }
 return $url . $str . "'";
};

echo outfitUrl($a);

                            echo '<div style="position:relative; left:-32px; top:-32px;width: 32px;height:32px;">
                            <div style="background-image: url(layout/outfitter/outfit.php' . outfitUrl($scores[$type][$i]) );
                                width:64px;height:64px;position:absolute;background-repeat:no-repeat;background-position:right bottom;">
                            </div>';
?>
                   
                        </td>
                        <?php echo $flag; ?>
                        <td><strong><a href="characterprofile.php?name=<?php echo $scores[$type][$i]['name']; ?>"><?php echo $scores[$type][$i]['name']; ?></a></strong></td>
                        <td><center><?php echo vocation_id_to_name($scores[$type][$i]['vocation']); ?></center></td>
                        <td><center><?php echo $scores[$type][$i]['value']; ?></center></td>
                        <?php if ($type === 7) echo "<td><center>". $scores[$type][$i]['experience'] ."</center></td>"; ?>
                    </tr>
                    <?php
                }
            }
        }
        ?>
@Znote could you help us out please?
 
Last edited:
Upvote 0 Downvote
Up
i'm trying to do a workaround with this issue. So i have removed the code
related with displaying outfit at highscores.

The thing is that the vocations are not being displayed properly. could somebody guide me please?. Thanks

tere is appearing the text any vocation and array. Not ek, pall, druid etc.
I'm aware that something might be undefinied or undeclared or not working, but i don't know exactly where or how to start.
website error.png

This is what i have done so far:

PHP: 
<?php require_once 'engine/init.php';

if ($config['log_ip']) {
    znote_visitor_insert_detailed_data(3);
}

function fetchAllScoresh($rows, $tfs, $g, $v = -1) {
    // Return scores ordered by type and vocation (if set)
    $data = array();
    if ($tfs == 'TFS_10') {

        // Generate SQL WHERE-clause for vocation if $v is set
        $v = ($v > -1) ? 'AND `vocation` = '. intval($v) : NULL;

        $data[1] = mysql_select_multi("SELECT `id`, `name`, `vocation`, `skill_club` AS `value` FROM `players` WHERE `group_id` < $g $v ORDER BY `skill_club` DESC LIMIT 0, $rows;");
        $data[2] = mysql_select_multi("SELECT `id`, `name`, `vocation`, `skill_sword` AS `value` FROM `players` WHERE `group_id` < $g $v ORDER BY `skill_sword` DESC LIMIT 0, $rows;");
        $data[3] = mysql_select_multi("SELECT `id`, `name`, `vocation`, `skill_axe` AS `value` FROM `players` WHERE `group_id` < $g $v ORDER BY `skill_axe` DESC LIMIT 0, $rows;");
        $data[4] = mysql_select_multi("SELECT `id`, `name`, `vocation`, `skill_dist` AS `value` FROM `players` WHERE `group_id` < $g $v ORDER BY `skill_dist` DESC LIMIT 0, $rows;");
        $data[5] = mysql_select_multi("SELECT `id`, `name`, `vocation`, `skill_shielding` AS `value` FROM `players` WHERE `group_id` < $g $v ORDER BY `skill_shielding` DESC LIMIT 0, $rows;");
        $data[6] = mysql_select_multi("SELECT `id`, `name`, `vocation`, `skill_fishing` AS `value` FROM `players` WHERE `group_id` < $g $v ORDER BY `skill_fishing` DESC LIMIT 0, $rows;");
        $data[7] = mysql_select_multi("SELECT `id`, `name`, `vocation`, `experience`, `level` AS `value` FROM `players` WHERE `group_id` < $g $v ORDER BY `experience` DESC LIMIT 0, $rows;");
        $data[8] = mysql_select_multi("SELECT `id`, `name`, `vocation`, `maglevel` AS `value` FROM `players` WHERE `group_id` < $g $v ORDER BY `maglevel` DESC LIMIT 0, $rows;");
        $data[9] = mysql_select_multi("SELECT `id`, `name`, `vocation`, `skill_fist` AS `value` FROM `players` WHERE `group_id` < $g $v ORDER BY `skill_fist` DESC LIMIT 0, $rows;");
    } else {

        // Generate SQL WHERE-clause for vocation if $v is set
        $v = ($v > -1) ? 'AND `vocation` = '. intval($v) : NULL;

        $data[9] = mysql_select_multi("SELECT `looktype`, `lookhead`, `lookbody`, `looklegs`, `lookfeet`, `s`.`player_id` AS `id`, `s`.`value` AS `value`, `p`.`name` AS `name`, `p`.`vocation` AS `vocation` FROM `player_skills` AS `s` LEFT JOIN `players` AS `p` ON `s`.`player_id`=`p`.`id` WHERE `s`.`skillid` = 0 AND `p`.`group_id` < $g $v ORDER BY `s`.`value` DESC LIMIT 0, $rows;");
        $data[1] = mysql_select_multi("SELECT `looktype`, `lookhead`, `lookbody`, `looklegs`, `lookfeet`, `s`.`player_id` AS `id`, `s`.`value` AS `value`, `p`.`name` AS `name`, `p`.`vocation` AS `vocation` FROM `player_skills` AS `s` LEFT JOIN `players` AS `p` ON `s`.`player_id`=`p`.`id` WHERE `s`.`skillid` = 1 AND `p`.`group_id` < $g $v ORDER BY `s`.`value` DESC LIMIT 0, $rows;");
        $data[2] = mysql_select_multi("SELECT `looktype`, `lookhead`, `lookbody`, `looklegs`, `lookfeet`, `s`.`player_id` AS `id`, `s`.`value` AS `value`, `p`.`name` AS `name`, `p`.`vocation` AS `vocation` FROM `player_skills` AS `s` LEFT JOIN `players` AS `p` ON `s`.`player_id`=`p`.`id` WHERE `s`.`skillid` = 2 AND `p`.`group_id` < $g $v ORDER BY `s`.`value` DESC LIMIT 0, $rows;");
        $data[3] = mysql_select_multi("SELECT `looktype`, `lookhead`, `lookbody`, `looklegs`, `lookfeet`, `s`.`player_id` AS `id`, `s`.`value` AS `value`, `p`.`name` AS `name`, `p`.`vocation` AS `vocation` FROM `player_skills` AS `s` LEFT JOIN `players` AS `p` ON `s`.`player_id`=`p`.`id` WHERE `s`.`skillid` = 3 AND `p`.`group_id` < $g $v ORDER BY `s`.`value` DESC LIMIT 0, $rows;");
        $data[4] = mysql_select_multi("SELECT `looktype`, `lookhead`, `lookbody`, `looklegs`, `lookfeet`, `s`.`player_id` AS `id`, `s`.`value` AS `value`, `p`.`name` AS `name`, `p`.`vocation` AS `vocation` FROM `player_skills` AS `s` LEFT JOIN `players` AS `p` ON `s`.`player_id`=`p`.`id` WHERE `s`.`skillid` = 4 AND `p`.`group_id` < $g $v ORDER BY `s`.`value` DESC LIMIT 0, $rows;");
        $data[5] = mysql_select_multi("SELECT `looktype`, `lookhead`, `lookbody`, `looklegs`, `lookfeet`, `s`.`player_id` AS `id`, `s`.`value` AS `value`, `p`.`name` AS `name`, `p`.`vocation` AS `vocation` FROM `player_skills` AS `s` LEFT JOIN `players` AS `p` ON `s`.`player_id`=`p`.`id` WHERE `s`.`skillid` = 5 AND `p`.`group_id` < $g $v ORDER BY `s`.`value` DESC LIMIT 0, $rows;");
        $data[6] = mysql_select_multi("SELECT `looktype`, `lookhead`, `lookbody`, `looklegs`, `lookfeet`, `s`.`player_id` AS `id`, `s`.`value` AS `value`, `p`.`name` AS `name`, `p`.`vocation` AS `vocation` FROM `player_skills` AS `s` LEFT JOIN `players` AS `p` ON `s`.`player_id`=`p`.`id` WHERE `s`.`skillid` = 6 AND `p`.`group_id` < $g $v ORDER BY `s`.`value` DESC LIMIT 0, $rows;");
        $data[7] = mysql_select_multi("SELECT `looktype`, `lookhead`, `lookbody`, `looklegs`, `lookfeet`, `id`, `name`, `vocation`, `experience`, `level` AS `value` FROM `players` WHERE `group_id` < $g $v ORDER BY `experience` DESC limit 0, $rows;");
        $data[8] = mysql_select_multi("SELECT `looktype`, `lookhead`, `lookbody`, `looklegs`, `lookfeet`, `id`, `name`, `vocation`, `maglevel` AS `value` FROM `players` WHERE `group_id` < $g $v ORDER BY `maglevel` DESC limit 0, $rows;");
    }
    return $data;
}

// Fetch highscore type
$type = (isset($_GET['type'])) ? (int)getValue($_GET['type']) : 7;
if ($type > 9) $type = 7;

// Fetch highscore vocation
$vocation = (isset($_GET['vocation'])) ? (int)getValue($_GET['vocation']) : -1;
if ($vocation > 8) $vocation = -1;

// Fetch highscore page
$page = getValue(@$_GET['pag']);
if (!$page || $page == 0) $page = 1;
else $page = (int)$page;

$highscore = $config['highscore'];

$rows = $highscore['rows'];
$rowsPerPage = $highscore['rowsPerPage'];

function skillName($type) {
    $types = array(
        1 => "Club",
        2 => "Sword",
        3 => "Axe",
        4 => "Distance",
        5 => "Shield",
        6 => "Fish",
        7 => "Experience", // Hardcoded
        8 => "Magic Level", // Hardcoded
        9 => "Fist", // Since 0 returns false I will make 9 = 0. :)
    );
    return $types[(int)$type];
}

function pageCheck($index, $page, $rowPerPage) {
    return ($index < ($page * $rowPerPage) && $index >= ($page * $rowPerPage) - $rowPerPage) ? true : false;
}

$cache = new Cache('engine/cache/highscores');
if ($cache->hasExpired()) {
    $scores = fetchAllScoresh($rows, $config['TFSVersion'], $highscore['ignoreGroupId'], $vocation);
    
    $cache->setContent($scores);
    $cache->save();
} else {
    $scores = $cache->load();
}

if ($scores) {
    ?>
        <style>
            .newstext img
            {
                max-width: 562px;
                height: auto;
                margin: 0 5px;
            }
            .pagination
            {
                text-align: center;
                margin: 10px 0;
            }
            .pagination a
            {
                display: inline-block;
                color: #52412f;
                font-size: 14px;
                line-height: 24px;
                height: 24px;
                width: 24px;
                font-weight: bold;
                text-align: center;
                border: 1px solid #886a4d;
                margin: 0 5px 0 0;
                border-radius: 24px;
                box-shadow: 0 2px 3px rgb(255, 214, 175) inset;
                background: #dcaf83;
                transition: opacity 0.1s linear;
            }
            .pagination a:hover
            {
                opacity: 0.7;
            }
            .pagination a.current
            {
                background: #ad1a1a;
                color: #fff;
                border: 1px solid #000000;
                box-shadow: 0 2px 3px rgb(255, 62, 62) inset;
            }
        </style>
        
    <form type="submit" action="" method="GET">
    <br>
    <center>Skill: <input type="hidden" name="page" value="highscores"/>
        <select style="vertical-align:middle;" name="type">
            <option value="7" <?php if ($type == 7) echo "selected"; ?>>Experience</option>
            <option value="8" <?php if ($type == 8) echo "selected"; ?>>Magic</option>
            <option value="5" <?php if ($type == 5) echo "selected"; ?>>Shield</option>
            <option value="2" <?php if ($type == 2) echo "selected"; ?>>Sword</option>
            <option value="1" <?php if ($type == 1) echo "selected"; ?>>Club</option>
            <option value="3" <?php if ($type == 3) echo "selected"; ?>>Axe</option>
            <option value="4" <?php if ($type == 4) echo "selected"; ?>>Distance</option>
            <option value="6" <?php if ($type == 6) echo "selected"; ?>>Fish</option>
            <option value="9" <?php if ($type == 9) echo "selected"; ?>>Fist</option>
        </select>
        &nbsp;&nbsp;Vocation: <select style="vertical-align:middle;" name="vocation">
            <option value="-1" <?php if ($vocation < 0) echo "selected"; ?>>Any vocation</option>

            <?php
            foreach (config('vocations') as $v_id => $v_name) {
                $selected = ($vocation == $v_id) ? " selected" : NULL;

                echo '<option value="'. $v_id .'"'. $selected .'>'. $v_name .'</option>';
            }
            ?>
        </select>
        
         <input type="submit" class="hover" value=""
    style="background-image: url(layout/tibia_img/sbutton_submit.gif); vertical-align:middle; border: solid 0px #000000; width: 120px; height: 18px;" />
        </center>
    </form>
    
    
        <br><center><span class="pagination">
            <?php
            $pages = ceil(min(($highscore['rows'] / $highscore['rowsPerPage']), (count($scores[$type]) / $highscore['rowsPerPage'])));
            for ($i = 0; $i < $pages; $i++) {
                $x = $i + 1;
                if ($x == $page) echo "<a href=\"?".$_SERVER['QUERY_STRING']."&pag=".$x."\" class=\"current\">".$x."</a>";
                else echo "<a href=\"?".$_SERVER['QUERY_STRING']."&pag=".$x."\">".$x."</a>";
            }
            ?>
        </span></center>
        
        
    <table id="highscoresTable" cellpadding="4" class="stripped">
        <tr>   
            <th colspan="7">Ranking for <?php echo skillName($type) .", ". (($vocation < 0) ? 'any vocation' : vocation_id_to_name($vocation)) ?></th>
        </tr>
        <tr>
            <td width="8%"><center>#</center></td>
            <td width="8%"><center><strong>outfit</strong></center></td>
            <?php if ($config['country_flags'] === true) echo'<td width="5%"><center><strong>flag</strong></center></td>'; ?>
            <td><strong>Name</strong></td>
            <td><center><strong>Vocation</strong></center></td>
            <td width="15%"><center><strong>Level</strong></center></td>
            <?php if ($type === 7) echo "<td width=\"15%\"><center><strong>Points</strong></center></td>"; ?>
        </tr>
        <?php
        for ($i = 0; $i < count($scores[$type]); $i++) {
            if ($scores[$type] === false) {
                ?>
                <tr>
                    <td colspan="7">Nothing to show here yet.</td>
                </tr>
                <?php
            } else {
                if (pageCheck($i, $page, $rowsPerPage)) {
                    $profile_data = user_character_data($scores[$type][$i]['id'], 'account_id');

                    $account_data = user_znote_account_data($profile_data['account_id'], 'flag');
                    if ($config['country_flags'] === true) $flag = '<td><center><img src="flags/' . $account_data['flag'] . '.png"></center></td>';
                    else $flag = '';
                    ?>
                    <tr>
                        <td><center><?php echo $i+1; ?>.</center></td>
                        <td>
                        <!-- >?php -->
                            <!-- echo '<div style="position:relative; left:-32px; top:-32px;width: 32px;height:32px;"> -->
                            <!-- <div style="background-image: url(layout/outfitter/outfit.php?id='.$scores[$type][$i]['looktype'].'&head='.$scores[$type][$i]['lookhead'].'&body='.$scores[$type][$i]['lookbody'].'&legs='.$scores[$type][$i]['looklegs'].'&feet='.$scores[$type][$i]['lookfeet'].'); -->
                                <!-- width:64px;height:64px;position:absolute;background-repeat:no-repeat;background-position:right bottom;"> -->
                            <!-- </div>'; -->
                        <!-- ?> -->
                    
                        </td>
                        <?php echo $flag; ?>
                        <td><strong><a href="characterprofile.php?name=<?php echo $scores[$type][$i]['name']; ?>"><?php echo $scores[$type][$i]['name']; ?></a></strong></td>
                        <td><center><?php echo vocation_id_to_name($scores[$type][$i]['vocation']); ?></center></td>
                        <td><center><?php echo $scores[$type][$i]['value']; ?></center></td>
                        <?php if ($type === 7) echo "<td><center>". $scores[$type][$i]['experience'] ."</center></td>"; ?>
                    </tr>
                    <?php
                }
            }
        }
        ?>
    </table>
        <center><span class="pagination">
            <?php
            $pages = ceil(min(($highscore['rows'] / $highscore['rowsPerPage']), (count($scores[$type]) / $highscore['rowsPerPage'])));
            for ($i = 0; $i < $pages; $i++) {
                $x = $i + 1;
                if ($x == $page) echo "<a href=\"?".$_SERVER['QUERY_STRING']."&pag=".$x."\" class=\"current\">".$x."</a>";
                else echo "<a  href=\"?".$_SERVER['QUERY_STRING']."&pag=".$x."\">".$x."</a>";
            }
            ?>
        </span></center>
    <?php
}
?>
 
Upvote 0 Downvote

Similar threads

ghunalma
  • Question
AAC [Znote AAC] admin_news dont upload images
Replies
3
Views
317
ghunalma
ghunalma
ralke
  • Question
AAC ZnoteAAC show killing assists at characterprofile deathlist
Replies
0
Views
168
ralke
ralke
Czorcik
  • Question
Highscore reborn system in acc maker
Replies
0
Views
260
Czorcik
Czorcik
Czorcik
  • Question
Problem with Gesior Acc HIGHSCORE (offline player)
Replies
2
Views
466
Czorcik
Czorcik
blokerzinha
  • Question
Problem with the wrong player appearing as top even though he is not. Znote
Replies
1
Views
329
blokerzinha
blokerzinha
WikiArk21
  • Question
Error MySql
Replies
0
Views
217
WikiArk21
WikiArk21
Back
Top