Help with the website

[GOD Kubus]

how to add a caption Top Fraggers. I can not find this anywhere.
Plz help

 

[GOD Kubus]

<?PHP
//start :)
session_start();
ob_start("ob_gzhandler");
//require('./exaBD.php');
function microtime_float()
{
    list($usec, $sec) = explode(" ", microtime());
    return ((float)$usec + (float)$sec);
}
$time_start = microtime_float();
//##### CONFIG #####
include('config-and-functions.php');
$action = $_REQUEST['action'];
//##### LOGOUT #####
if($action == "logout")
{
    unset($_SESSION['account']);
    unset($_SESSION['password']);
}
//##### LOGIN #####
//check is player logged
$logged = FALSE;
if(isset($_SESSION['account']))
{
    $account_logged = $ots->createObject('Account');
    $account_logged->load($_SESSION['account']);
    if($account_logged->isLoaded() && $account_logged->getPassword() == $_SESSION['password'])
    {
        $logged = TRUE;
        $group_id_of_acc_logged = $account_logged->getPageAccess();
    }
    else
    {
        $logged = FALSE;
        unset($_SESSION['account']);
        unset($account_logged);
    }
}
$login_account = strtoupper(trim($_POST['account_login']));
$login_password = trim($_POST['password_login']);
if(!$logged && !empty($login_account) && !empty($login_password))
{
    $login_password = password_ency($login_password);
    $account_logged = $ots->createObject('Account');
    $account_logged->find($login_account);
    if($account_logged->isLoaded())
    {
        if($login_password == $account_logged->getPassword())
        {
            $_SESSION['account'] = $account_logged->getId();
            $_SESSION['password'] = $login_password;
            $logged = TRUE;
            $account_logged->setCustomField("page_lastday", time());
            $group_id_of_acc_logged = $account_logged->getPageAccess();
        }
        else
            $logged = FALSE;
    }
}
//#### LOAD PAGE ##########
//load subtopic page
if(empty($_REQUEST['subtopic'])) {
    $_REQUEST['subtopic'] = "latestnews";
    $subtopic = "latestnews";
}
switch($_REQUEST['subtopic']) {
    case "latestnews":
        $topic = "Latest News";
        $subtopic = "latestnews";
        include("latestnews.php");
    break;
    case "archive";
        $subtopic = "archive";
        $topic = "News Archives";
        include("archive.php");
    break;

    case "creatures";
        $topic = "Creatures";
        $subtopic = "creatures";
        include("creatures.php");
    break;
    case "spells";
        $topic = "Spells";
        $subtopic = "spells";
        include("spells.php");
    break;
    case "addons";
        $topic = "Addons";
        $subtopic = "addons";
        include("addons.php");
    break;
    case "serverinfo";
        $subtopic = "serverinfo";
        $topic = "Server Info";
        include("serverinfo.php");
    break;
    case "experiencetable";
        $topic = "Experience Table";
        $subtopic = "experiencetable";
        include("experiencetable.php");
    break;

    case "characters";
        $topic = "Characters";
        $subtopic = "characters";
        include("characters.php");
    break;
    case "whoisonline";
        $topic = "Who is online?";
        $subtopic = "whoisonline";
        include("whoisonline.php");
    break;
    case "highscores";
        $topic = "Highscores";
        $subtopic = "highscores";
        include("highscores.php");
    break;
    case "killstatistics";
        $topic = "Last Kills";
        $subtopic = "killstatistics";
        include("killstatistics.php");
    break;
    case "wars";
                $topic = "wars";
                $subtopic = "wars";
                include("wars.php");
        break;
    case "frags";
                $topic = "frags";
                $subtopic = "frags";
                include("frags.php");
        break;
    case "powergamers";
                $topic = "powergamers";
                $subtopic = "powergamers";
                include("powergamers.php");
        break;
      case "bans":
        $topic = "Banishments";
        $subtopic = "bans";
        include("bans.php");
    break;
    case "houses";
        $topic = "Houses";
        $subtopic = "houses";
        include("houses.php");
    break;
    case "guilds";
        $topic = "Guilds";
        $subtopic = "guilds";
        include("guilds.php");
    break;

    case "forum":
        $topic = "Forum";
        $subtopic = "forum";
        include("forum.php");
    break;

    case "accountmanagement";
        $topic = "Account Management";
        $subtopic = "accountmanagement";
        include("accountmanagement.php");
    break;
    case "createaccount";
        $topic = "Create Account";
        $subtopic = "createaccount";
        include("createaccount.php");
    break;
    case "lostaccount";
        $topic = "Lost Account Interface";
        $subtopic = "lostaccount";
        include("lostaccount.php");
    break;
    case "downloads";
        $subtopic = "downloads";
        $topic = "Downloads";
        include("downloads.php");
    break;

    case "tibiarules";
        $topic = "Server Rules";
        $subtopic = "tibiarules";
        include("tibiarules.php");
    break;
    case "tracker";
        $subtopic = "tracker";
        $topic = "Tracker";
        include("tracker.php");
    break;
    case "changelog";
        $subtopic = "changelog";
        $topic = "Change Log";
        include("changelog.php");
    break;
    case "team";
        $subtopic = "team";
        $topic = "Gamemasters List";
        include("team.php");
    break;
    case "adminpanel":
        $topic = "Admin Panel";
        $subtopic = "adminpanel";
        include("adminpanel.php");
    break;
    case "namelock";
        $subtopic = "namelock";
        $topic = "Namelock Manager";
        include("namelocks.php");
    break;

    case "buypoints";
        $subtopic = "buypoints";
        $topic = "Buy Points";
        include("buypoints.php");
    break;
    case "shopsystem";
        $subtopic = "shopsystem";
        $topic = "Shop System";
        include("shopsystem.php");
    break;
   
    case "shopadmin";
        $subtopic = "shopadmin";
        $topic = "shopadmin";
        include("shopadmin.php");
    break;

      case "credits":
        $topic = "Credits";
        $subtopic = "credits";
        include("credits.php");
    break;
}
// ##### generate title of page
if(empty($topic))
{
    $title = $GLOBALS['config']['server']["serverName"]." - OTS";
    $main_content .= 'Invalid subtopic. Can\'t load page.';
}
else
{
    $title = $GLOBALS['config']['server']["serverName"]." - ".$topic;
}
// ##### ADD Fotter for Credits
function getFooter()
{
    echo 'Account maker by <a href="index.php?subtopic=credits">Credits</a>. Layout by '.$GLOBALS['config']['site']['layout'].'.';
}
// ##### LAYOUT
$layout_header = '<script type=\'text/javascript\'>
function GetXmlHttpObject()
{
    var xmlHttp=null;
    try
    {
        xmlHttp=new XMLHttpRequest();
    }
    catch (e)
    {
        try
        {
            xmlHttp=new ActiveXObject("Msxml2.XMLHTTP");
        }
        catch (e)
        {
            xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");
        }
    }
    return xmlHttp;
}
function MouseOverBigButton(source)
{
  source.firstChild.style.visibility = "visible";
}
function MouseOutBigButton(source)
{
  source.firstChild.style.visibility = "hidden";
}
function BigButtonAction(path)
{
  window.location = path;
}
var';
if($logged) { $layout_header .= "loginStatus=1; loginStatus='true';"; } else { $layout_header .= "loginStatus=0; loginStatus='false';"; };
$layout_header .= " var activeSubmenuItem='".$subtopic."';</script>";
include($layout_name."/layout.php");
ob_end_flush();
?>

 

[GOD Kubus]

<?php
if(!defined('INITIALIZED'))
    exit;

$main_content .= '<div style="text-align: center; font-weight: bold;">Top 30 fraggers on ' . htmlspecialchars($config['server']['serverName']) . '</div>
<table border="0" cellspacing="1" cellpadding="4" width="100%">
    <tr bgcolor="' . $config['site']['vdarkborder'] . '">
        <td class="white" style="text-align: center; font-weight: bold;">Name</td>
        <td class="white" style="text-align: center; font-weight: bold;">Frags</td>
    </tr>';

$i = 0;
foreach($SQL->query('SELECT ' . $SQL->tableName('p') . '.' . $SQL->fieldName('name') . ' AS ' . $SQL->fieldName('name') . ', COUNT(' . $SQL->tableName('p') . '.' . $SQL->fieldName('name') . ') as ' . $SQL->fieldName('frags') . ' FROM ' . $SQL->tableName('killers') . ' k LEFT JOIN ' . $SQL->tableName('player_killers') . ' pk ON ' . $SQL->tableName('k') . '.' . $SQL->fieldName('id') . ' = ' . $SQL->tableName('pk') . '.' . $SQL->fieldName('kill_id') . ' LEFT JOIN ' . $SQL->tableName('players') . ' p ON ' . $SQL->tableName('pk') . '.' . $SQL->fieldName('player_id') . ' = ' . $SQL->tableName('p') . '.' . $SQL->fieldName('id') . ' WHERE ' . $SQL->tableName('k') . '.' . $SQL->fieldName('unjustified') . ' = 1 AND ' . $SQL->tableName('k') . '.' . $SQL->fieldName('final_hit') . ' = 1 GROUP BY ' . $SQL->fieldName('name') . ' ORDER BY ' . $SQL->fieldName('frags') . ' DESC, ' . $SQL->fieldName('name') . ' ASC LIMIT 30;') as $player)
{
    $i++;
    $main_content .= '<tr bgcolor="' . (is_int($i / 2) ? $config['site']['lightborder'] : $config['site']['darkborder']) . '">
        <td><a href="?subtopic=characters&name=' . urlencode($player['name']) . '">' . htmlspecialchars($player['name']) . '</a></td>
        <td style="text-align: center;">' . $player['frags'] . '</td>
    </tr>';
}

$main_content .= '</table>';

 

[Wartio]

Easiest way, Download this rar file and copy both files inside and extract to "www/pages" or "htdocs/pages"

https://www.mediafire.com/?g9yadg57o7kimjt

 

[GOD Kubus]

Don't work