source: minimanager/index.php@ 5

<?php
/*
 * Project Name: MiniManager for Mangos Server
 * Date: 17.10.2006 inital version (0.0.1a)
 * Author: Q.SA
 * Copyright: Q.SA
 * Email: *****
 * License: GNU General Public License v2(GPL)
 */
 
require_once("header.php");
valid_login(0);

require_once("scripts/get_lib.php");

$mysql = new MySQL;
$mysql->connect($mangos_db[$realm_id]['addr'], $mangos_db[$realm_id]['user'], $mangos_db[$realm_id]['pass'], $mangos_db[$realm_id]['name']);

$output .= "<div class=\"top\">";
if (test_port($server[$realm_id]['addr'],$server[$realm_id]['game_port'])) {
        
        $query = $mysql->query("SELECT uptime/60 FROM uptime ORDER BY starttime DESC LIMIT 1");
        $uptime = $mysql->result($query, 0);
        $output .= "<h1><font color=\"#55aa55\">{$lang_index['realm']} ".get_realm_name($realm_id)." {$lang_index['online']} : (".(int)($uptime/60).":".(($uptime >= 60 )?(int)($uptime-60*(int)($uptime/60)):(int)$uptime)."h)</font></h1>";
        $online = true;
        } else { 
                $output .= "<h1><font class=\"error\">{$lang_index['realm']} ".get_realm_name($realm_id)." {$lang_index['offline_or_let_height']}</font></h1>";
                $online = false;
                }
$output .= "Mangos: {$server[$realm_id]['rev']} Using DB: {$mangos_db[$realm_id]['db_rev']}</div>";

$mysql->db($mangos_db[$realm_id]['name']);
//MOTD part
$start = (isset($_GET['start'])) ? $mysql->quote_smart($_GET['start']) : 0;

$query_1 = $mysql->query("SELECT count(*) FROM bugreport");
$all_record = $mysql->result($query_1, 0);

$output .= "<center>
                        <table class=\"lined\">
                        <tr> 
                        <td class=\"head\" align=\"right\">";
if ($user_lvl) $output .= "<a href=\"motd.php?action=add_motd\" class=\"head_link\">{$lang_index['add_motd']}</a>";
$output .= "</td></tr>";
if($all_record){
        $result = $mysql->query("SELECT id, type, content FROM bugreport ORDER BY id DESC LIMIT $start, 3");
        while($post = $mysql->fetch_row($result)){
                $output .= "<tr><td align=\"left\" class=\"large\"><blockquote>$post[2]</blockquote></td></tr>
                                        <tr><td align=\"right\">$post[1] ";
                if ($user_lvl > 0) $output .= "<a href=\"motd.php?action=delete_motd&amp;id=$post[0]\">{$lang_index['delete']}</a>";                    
                $output .= "</td></tr>
                                        <tr><td class=\"hidden\"></td></tr>";
        }
   $output .= "<tr><td align=\"right\" class=\"hidden\">".generate_pagination("index.php?", $all_record, 3, $start)."</td></tr>";
 }
$output .= "</table><br />";

//print online chars
if ($online){
        $order_by = (isset($_GET['order_by'])) ? $mysql->quote_smart($_GET['order_by']) : "name";

        $dir = (isset($_GET['dir'])) ? $mysql->quote_smart($_GET['dir']) : 1;
        $order_dir = ($dir) ? "ASC" : "DESC";
        $dir = ($dir) ? 0 : 1;
        
        $result = $mysql->query("SELECT count(*) FROM `character` WHERE `online`= 1");
        $total_online = $mysql->result($result, 0);

        if( !$user_lvl && !$server[$realm_id]['both_factions']){
                $result = $mysql->query("SELECT race FROM `character` WHERE account = '$user_id' AND totaltime = (SELECT MAX(totaltime) FROM `character` WHERE account = '$user_id') LIMIT 1");
                if ($mysql->num_rows($result)){
                        $order_side = (in_array($mysql->result($result, 0, 'race'),array(2,5,6,8,10))) ?
                        " AND race IN (2,5,6,8,10) " : " AND race IN (1,3,4,7,11) ";
                } else $order_side = "";
        } else $order_side = "";

        require_once("scripts/defines.php");
        
        $result = $mysql->query("SELECT guid,name,race,class,position_x,position_y,map,
                        CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', ".(CHAR_DATA_OFFSET_HONOR_KILL+1)."), ' ', -1) AS UNSIGNED) AS highest_rank,
                        CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', ".(CHAR_DATA_OFFSET_LEVEL+1)."), ' ', -1) AS UNSIGNED) AS level,account 
                        FROM `character` WHERE `online`= 1 $order_side ORDER BY $order_by $order_dir");

        $output .= "
        <font class=\"bold\">{$lang_index['tot_users_online']} : $total_online</font><br /><br />
        <table class=\"lined\">
        <tr> 
        <td width=\"22%\" class=\"head\"><a href=\"index.php?order_by=name&amp;dir=$dir\" class=\"head_link\">{$lang_index['name']}</a></td>
        <td width=\"10%\" class=\"head\"><a href=\"index.php?order_by=race&amp;dir=$dir\" class=\"head_link\">{$lang_index['race']}</a></td>
        <td width=\"10%\" class=\"head\"><a href=\"index.php?order_by=class&amp;dir=$dir\" class=\"head_link\">{$lang_index['class']}</a></td>
        <td width=\"5%\" class=\"head\"><a href=\"index.php?order_by=level&amp;dir=$dir\" class=\"head_link\">{$lang_index['level']}</a></td>
        <td width=\"20%\" class=\"head\"><a href=\"index.php?order_by=map&amp;dir=$dir\" class=\"head_link\">{$lang_index['map']}</a></td>
        <td width=\"25%\" class=\"head\">{$lang_index['zone']}</td>
    <td width=\"8%\" class=\"head\"><a href=\"index.php?order_by=highest_rank&amp;dir=$dir\" class=\"head_link\">{$lang_index['honor_kills']}</a></td>
        </tr>";

        require_once("scripts/id_tab.php");

        while($char = $mysql->fetch_row($result)){
                $output .= "<tr>
                 <td><a href=\"char.php?id=$char[0]\">$char[1]</a></td>
         <td>".get_player_race($char[2])."</td>
                 <td>".get_player_class($char[3])."</td>
                 <td>$char[8]</td>
                 <td>".get_map_name($char[6])."</td>
                 <td>".get_zone_name($char[6], $char[4], $char[5])."</td>
                 <td>$char[7]</td>
         </tr>";
        }
   $output .= "</table><br /></center>";
}
$mysql->close();

require_once("footer.php");
?>