<?php      
         echo "<TABLE>";      
         echo "<TR><TD colSpan=5>Список заблокированных</TD></TR>";      
             echo "<TR><TD width=10%>Аккаунт</TD><TD>Забанил</TD><TD>Причина</TD><TD>Был забанен</TD><TD>Будет разбанен</TD></TR>";      
$getban = mysql_query("SELECT * FROM account_banned WHERE active='1'");      
while($banid = mysql_fetch_array($getban))      
{      
$id = "".$banid['id']."";      
$who = "".$banid['bannedby']."";      
$unbandate = date("d.m.Y", $banid['unbandate']);      
$bandate = date("d.m.Y", $banid['bandate']);      
$reason = "".$banid['banreason']."";      
$getbanned = mysql_query("SELECT username FROM account WHERE id='$id'");      
while($banned = mysql_fetch_array($getbanned))      
{      
$acc = "".$banned['username']."";      
         echo "<TR><TD width=10%>$acc</TD><TD>$who</TD><TD width=45%>$reason</TD><TD width=20%>$bandate</TD><TD width=25%>$unbandate</TD></TR>";      
}      
}      
         echo "</TABLE>";      

?>

<?php   
$fp = fsockopen("0we.ru", 8080, $errno, $errstr, 30);   
if($fp){   
$im = imagecreatefrompng("online.png");   
}else{   
$im = imagecreatefrompng("offline.png");   
}   
header('Content-type: image/png');   
imagepng($im);   
imagedestroy($im);   
?>

<?          
$fp = @fsockopen ("$ip","$gameport",$errno,$errstr,1);          
if ($fp)          
echo "Статус Сервера: online<br>";          
else          
echo "Статус Сервера: offline<br>";          
?>

<?          
mysql_selectdb ($rdb);          
$acc = mysql_query ("select count(*) from account");          
$acc = mysql_result ($acc,0);          
mysql_selectdb ("$cdb");          
$char = mysql_query ("select count(*) from characters");          
$char = mysql_result ($char,0);          
$alliance = mysql_query ("select count(*) from characters where race in (1,3,4,7,11)");          
$alliance = mysql_result ($alliance,0);          
$horde = mysql_query ("select count(*) from characters where race in (2,5,6,8,10)");          
$horde = mysql_result ($horde,0);          
$guild = mysql_query ("select count(*) from guild");          
$guild = mysql_result ($guild,0);          
echo "Аккаунтов: $acc<br>";          
echo "Персонажей: $char<br>";          
echo "Альянса: $alliance<br>";          
echo "Орды: $horde<br>";          
echo "Гильдий: $guild<br>";          
?>

<table border="0">          
<tr>          
<td><strong>Имя:</strong></td>          
<td><strong>Раса:</strong></td>          
<td><strong>Класс:</strong></td>          
<td><strong>Уровень:</strong></td>          
</tr>          
<?          
mysql_selectdb ("$cdb");          
mysql_query ('set names cp1251');          
$result = mysql_query ("select name, race, class, data from characters where online = 1");          
$class = array          
(1=>"Воин",2=>"Паладин",3=>"Охотник",4=>"Разбойник",5=>"Жрец",6=>"Рыцарь Смерти",7=>"Шаман",8=>"Маг",9=>"Чернокнижник",11=>"Друид");          
$race = array          
(1=>"Человек",2=>"Орк",3=>"Дворф",4=>"Ночной Эльф",5=>"Нежить",6=>"Таурен",7=>"Гном",8=>"Тролль",10=>"Эльф Крови",11=>"Дреней");          
while ($row = mysql_fetch_array ($result))          
{          
$ch_name = $row['name'];          
$ch_race = $row['race'];          
$ch_class = $row['class'];          
$char_data = explode(' ',$row['data']);          
$ch_lvl = $char_data[53];          
echo "<tr><td><strong>$ch_name</strong></td>";          
echo "<td><strong>$race[$ch_race]</strong></td>";          
echo "<td><strong>$class[$ch_class]</strong></td>";          
echo "<td><strong>$ch_lvl</strong></td></tr>";          
}          
?>          
</table>

mysql_selectdb ("characters");        
$rating = mysql_query ("select max(`rating`) from arena_team_stats");          
$rating = mysql_result ($rating,0);        
$id = mysql_query ("SELECT arenateamid FROM arena_team_stats WHERE rating=$rating");        
$id = mysql_result ($id,0);        
$name = mysql_query ("SELECT name FROM arena_team WHERE arenateamid=$id");        
$name = mysql_result ($name,0);        
$player_rating = mysql_query ("select max(`personal_rating`) from arena_team_member");        
$player_rating = mysql_result ($player_rating,0);        
$player_id = mysql_query ("SELECT guid FROM arena_team_member WHERE personal_rating=$player_rating");        
$player_id = mysql_result ($player_id,0);        
$player_name = mysql_query ("SELECT name FROM characters WHERE guid=$player_id");        
$player_name = mysql_result ($player_name,0);        
echo "Самая лучшая команда: <font color=green>$name</font> (<font color=red>$rating</font>)<br>";        
echo "Самый лучший игрок Арены: <font color=blue>$player_name</font>"   

$rdb - логин база   
$cdb - база персонажей

mysql_selectdb("$rdb");        
$gm_guid_result = array();        
$i=1;        
$gm_acc_id = mysql_query("select `id` from `account` WHERE `gmlevel` > '0'");        
         while ($gm_acc_result = mysql_fetch_object($gm_acc_id))         
         {         
          mysql_selectdb("$cdb");        
          $id_gm = mysql_query ("select `guid` from `characters` WHERE `account` = '$gm_acc_result->id'");        
          while ($gm_guid = mysql_fetch_object($id_gm))         
                {         
                  $gm_guid_result[$i] = $gm_guid->guid;        
                  $i++;        
                }        
         }        
$gm_guid_string = implode(",", $gm_guid_result);        
         if (!$gm_guid_string)        
           {        
              $rating = mysql_query ("select max(`rating`) from arena_team_stats");        
              $rating = mysql_result ($rating,0);        
              $player_rating = mysql_query ("select max(`personal_rating`) from arena_team_member");         
              $player_rating = mysql_result ($player_rating,0);        
           }        
             else        
           {        
              $arena_gm_result = array();        
              $k=1;        
              $arena_gm_id = mysql_query("select `arenateamid` from `arena_team_member` WHERE `guid` in ($gm_guid_string)");        
                 while ($arena_gm = mysql_fetch_object($arena_gm_id))        
                   {        
                      $arena_gm_result[$k] = $arena_gm->arenateamid;        
                      $k++;        
                   }        
              $arena_gm_result_sort = array_unique($arena_gm_result);        
              $arena_gm_result_sort_string = implode(",", $arena_gm_result_sort);          
                        if (!$arena_gm_result_sort_string)        
                    {        
                         $rating = mysql_query ("select max(`rating`) from arena_team_stats");        
                         $rating = mysql_result ($rating,0);        
                         $player_rating = mysql_query ("select max(`personal_rating`) from arena_team_member");         
                         $player_rating = mysql_result ($player_rating,0);        
                    }        
                      else        
                    {        
                         $ rating = mysql_query ("select max(`rating`) from arena_team_stats where arenateamid not in ($arena_gm_result_sort_string)");        
                         $rating = mysql_result ($rating,0);        
                         $player_rating = mysql_query ("select max(`personal_rating`) from arena_team_member WHERE guid not in ($gm_guid_string)");        
                         $player_rating = mysql_result ($player_rating,0);        
                    }        
           }        
$id = mysql_query ("SELECT arenateamid FROM arena_team_stats WHERE rating=$rating");        
$id = mysql_result ($id,0);        
$name = mysql_query ("SELECT name FROM arena_team WHERE arenateamid=$id");        
$name = mysql_result ($name,0);        
$player_id = mysql_query ("SELECT guid FROM arena_team_member WHERE personal_rating='$player_rating'");        
$player_id = mysql_result ($player_id,0);        
$player_name = mysql_query ("SELECT name FROM characters WHERE guid=$player_id");        
$player_name = mysql_result ($player_name,0);        
echo "Самая лучшая команда: <font color=green>$name</font> (<font color=red>$rating</font>)<br>";        
echo "Самый лучший игрок Арены: <font color=blue>$player_name</font>";

<?php         
            
define("DBHOST", "localhost");        
define("DBUSER", "root");        
define("DBPASS", "mangos");        
define("COLLATE", "utf8");        
define("CDB", "characters");        

function conventNormTime($nSec) {       
                       $d = floor( $nSec / (3600*24) );       
               $nSec = ($nSec - $d * 3600 * 24);       
               $h = floor( $nSec / 3600 );       
               $nSec = ($nSec - $h * 3600);       
               $m = floor( $nSec / 60 );       
              return "{$d}д.  {$h}ч.  {$m}м.";       
               }       

             $class = array (                          
                    1=>"Воин",        
                    2=>"Паладин",        
                    3 = >"Охотник",        
                    4=>"Разбойник",        
                    5=>"Жрец",                     
                    6  =>"Рыцарь Смерти",        
                    7=>"Шаман",        
                    8=>"Маг",        
                    9=>"Чернок нижник ",        
                    11=>"Друид"        
                    );         
                      
         $race = array     (        
                    1=>"Человек",        
                    2=>"Орк",        
                    3=>"Д ворф",         
                    4=>"Ночной Эльф",        
                    5=>"Нежить",        
                    6=>"Таурен",        
                    7=>"Гном ",        
                    8 =>"Тролль",        
                    10=>"Эльф Крови",        
                    11=>"Дреней"        
                             );        
                      

           $sMySql = mysql_connect(DBHOST, DBUSER, DBPASS); // Соединяемся с базой         
             mysql_query("SET NAMES COLLATE"); // Устанавливаем кодировку соединения        
                 
               mysql_select_db(CDB, $sMySql);         
                   
         $aSql = mysql_query("SELECT `name`, `race`, `class`, `totaltime` FROM `characters` ORDER BY `totaltime` DESC LIMIT 0 , 15", $sMySql);        
                
          $szContent .= "
<table width='98%' border='1' align='center'><tr>        
<td align='center' width='20%'><font color='green'>Персонаж</font></td>        
<td align='center' width='20%'><font color='green'>Сыгранное время</font></td>        
<td align='center' width='20%'><font color='green'>Класс</font></td>        
<td align='center' width='20%'><font color='green'>Раса</font></td>        
</tr></table>";           

                       while ($row = mysql_fetch_array($aSql))                        
                          {         
                            $name = $row['name'];        
                            $totaltime = conventNormTime($row['totaltime']);        
                            $show_race = $race[$row['race']];        
                            $show_class = $class[$row['class']];        
                          
          $szContent .= "<table width='98%' border='1' align='center'><tr>        
<td align='center' width='20%'>".$name."</td>        
<td align='center' width='20%'>".$totaltime."</td>        
<td align='center' width='20%'>".$show_class."</td>         
<td align='center' width='20%'>".$show_race."</td>        
</tr></table>";           
                          }         
                        
         mysql_close($sMySql);   // Закрываем соединение mysql        
                
         echo $szContent;         
?>

<?php     
         
// Configuration.     
// Realm database.     
$r_db = "Realmd";     
// IP (and port).     
$ip = "127.0.0.1:3306";     
// Username.     
$user = "trinity";     
// Password.     
$pass = "trinity";     
// Site title.     
$title = "Registration Form";     
$title2 = "Server name";     
// End config.     
         
$page = '<?xml version="1.0" encoding="utf-8" ?>     
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">     
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">     
<head>     
<title>' . $title . '</title>     
</head>     
<body style="background-color:black;color:yellow;font-family:verdana;">     
<form method="post" action="' . $_SERVER["SCRIPT_NAME"] . '">     
<p style="text-align:center;">     
<strong>' . $title2 . ' - ' . $title . '</strong>     

      
Login:     

<input name="username" type="text" maxlength="14" />
      
Password:     

<input name="password" type="password" maxlength="12" />
      
Email:     

<input name="email" type="text" maxlength="50" />     

<input name="tbc" type="checkbox" checked="checked" /> WotLK

      
<button type="submit">Registration</button>     
</p>     
</form>     
</body>     
</html>';     
         
function error_s ($text) {     
        echo("<p style=\"background-color:black;color:yellow;font-family:verdana;\">" . $text);     
        echo("

<a style=\"color:orange;\" href=\"" . $_SERVER["SCRIPT_NAME"] . "\">Go back...</a></p>");     
};     
         
$user_chars = "#[^a-zA-Z0-9_\-]#";&

<?    
include('config.php');    
mysql_connect("$ip", "$dblogin", "$dbpass");    
mysql_select_db ("$dbc");    
$human = mysql_query ("select count(*) from characters where race = 1");    
$human = mysql_result ($human,0);    
$dwarv = mysql_query ("select count(*) from characters where race = 3");    
$dwarv = mysql_result ($dwarv,0);    
$night = mysql_query ("select count(*) from characters where race = 4");    
$night = mysql_result ($night,0);    
$gnome = mysql_query ("select count(*) from characters where race = 7");    
$gnome = mysql_result ($gnome,0);    
$draenei = mysql_query ("select count(*) from characters where race = 11");    
$draenei = mysql_result ($draenei,0);    
$orc = mysql_query ("select count(*) from characters where race = 2");    
$orc = mysql_result ($orc,0);    
$undead = mysql_query ("select count(*) from characters where race = 5");    
$undead = mysql_result ($undead,0);    
$tauren = mysql_query ("select count(*) from characters where race = 6");    
$tauren = mysql_result ($tauren,0);    
$troll = mysql_query ("select count(*) from characters where race = 8");    
$troll = mysql_result ($troll,0);    
$blood = mysql_query ("select count(*) from characters where race = 10");    
$blood = mysql_result ($blood,0);    
$druid = mysql_query ("select count(*) from characters where class = 11");    
$druid = mysql_result ($druid,0);    
$hunter = mysql_query ("select count(*) from characters where class = 3");    
$hunter = mysql_result ($hunter,0);    
$mage = mysql_query ("select count(*) from characters where class = 8");    
$mage = mysql_result ($mage,0);    
$paladin = mysql_query ("select count(*) from characters where class = 2");    
$paladin = mysql_result ($paladin,0);    
$priest = mysql_query ("select count(*) from characters where class = 5");    
$priest = mysql_result ($priest,0);    
$rogue = mysql_query ("select count(*) from characters where class = 4");    
$rogue = mysql_result ($rogue,0);    
$shaman = mysql_query ("select count(*) from characters where class = 7");    
$shaman = mysql_result ($shaman,0);    
$warlock = mysql_query ("select count(*) from characters where class = 9");    
$warlock = mysql_result ($warlock,0);    
$warrior = mysql_query ("select count(*) from characters where class = 1");    
$warrior = mysql_result ($warrior,0);    
$death = mysql_query ("select count(*) from characters where class = 6");    
$death = mysql_result ($death,0);    
echo "Людей: $human    
";    
echo "Дварфов: $dwarv    
";    
echo "Ночных Эльфов: $night    
";    
echo "Гномов: $gnome    
";    
echo "Дренейев: $draenei    
";    
echo "Орков: $orc    
";    
echo "Нежити: $undead    
";    
echo "Тауренов: $tauren    
";    
echo "Троллей: $troll    
";    
echo "Эльфов Крови: $blood    

";    
echo "Друидов: $druid    
";    
echo "Охотников: $hunter    
";    
echo "Магов: $mage    
";    
echo "Паладинов: $paladin    
";    
echo "Жрецов: $priest    
";    
echo "Разбойников: $rogue    
";    
echo "Шаманов: $shaman    
";    
echo "Чернокнижников: $warlock    
";    
echo "Воинов: $warrior    
";    
echo "Рыцарей Смерти: $death    
";    
?>

<?    
include('config.php');    
mysql_selectdb ("$dbr");    
$max = mysql_query ("select max(`maxplayers`) from uptime");    
$max = mysql_result ($max,0);    
echo "Максимальный онлайн:$max    
";    
?>

$select_db = mysql_select_db('characters');   
$select_arena_ratings = mysql_query("SELECT rating,arenateamid FROM `characters`.`arena_team_stats` ORDER BY rating DESC");   
$i = 1;   
echo "<table border=1 align=center>";   
echo "<td width=190px>Название команды</td>";   
echo "<td width=130px>Очки</td>";   
echo "<td width=130px>Состав</td>";   
echo "</table>";   
while($select_arena_rating = mysql_fetch_array($select_arena_ratings)) {   
$select_arena_tnames = mysql_query("SELECT * FROM `characters`.`arena_team` WHERE type=2 && arenateamid='".$select_arena_rating[arenateamid]."'");   
while($select_arena_tname = mysql_fetch_array($select_arena_tnames)) {   
$select_member_names = mysql_query("SELECT * FROM `characters`.`arena_team_member` WHERE arenateamid = '".$select_arena_tname[arenateamid]."'");   
$select_member_rows = mysql_num_rows($select_member_names);   
if($select_member_rows == 2) {   
echo "<table border=1 align=center>";   
echo "<td width=190px><dic style='width:110px;'><a>".$select_arena_tname['name']."</a></div></td>";   
echo "<td width=130px><dic style='width:110px;'><a>".$select_arena_rating['rating']."</a></div></td>";   
echo "<td width=130px>";   
while($select_member_name = mysql_fetch_array($select_member_names)) {   
$result_name_members = mysql_query("SELECT * FROM `characters`.`characters` WHERE guid = '".$select_member_name[guid]."'");   
$result_name_member = mysql_fetch_array($result_name_members);   
echo "<div style='width:110px;'><a>".$result_name_member['name']."</a></div>";   
}   
echo "</td>";   
}   
echo "</table>";   
$i++;   
}   
}

$select_db = mysql_select_db('characters');   
$select_arena_ratings = mysql_query("SELECT rating,arenateamid FROM `characters`.`arena_team_stats` ORDER BY rating DESC");   
$i = 1;   
echo "<table border=1 align=center>";   
echo "<td width=190px>Название команды</td>";   
echo "<td width=130px>Очки</td>";   
echo "<td width=130px>Состав</td>";   
echo "</table>";   
while($select_arena_rating = mysql_fetch_array($select_arena_ratings)) {   
$select_arena_tnames = mysql_query("SELECT * FROM `characters`.`arena_team` WHERE type=3 && arenateamid='".$select_arena_rating[arenateamid]."'");   
while($select_arena_tname = mysql_fetch_array($select_arena_tnames)) {   
$select_member_names = mysql_query("SELECT * FROM `characters`.`arena_team_member` WHERE arenateamid = '".$select_arena_tname[arenateamid]."'");   
$select_member_rows = mysql_num_rows($select_member_names);   
if($select_member_rows == 3) {   
echo "<table border=1 align=center>";   
echo "<td width=190px><dic style='width:110px;'><a>".$select_arena_tname['name']."</a></div></td>";   
echo "<td width=130px><dic style='width:110px;'><a>".$select_arena_rating['rating']."</a></div></td>";   
echo "<td width=130px>";   
while($select_member_name = mysql_fetch_array($select_member_names)) {   
$result_name_members = mysql_query("SELECT * FROM `characters`.`characters` WHERE guid = '".$select_member_name[guid]."'");   
$result_name_member = mysql_fetch_array($result_name_members);   
echo "<div style='width:110px;'><a>".$result_name_member['name']."</a></div>";   
}   
echo "</td>";   
}   
echo "</table>";   
$i++;   
}   
}

$select_db = mysql_select_db('characters');   
$select_arena_ratings = mysql_query("SELECT rating,arenateamid FROM `characters`.`arena_team_stats` ORDER BY rating DESC");   
$i = 1;   
echo "<table border=1 align=center>";   
echo "<td width=190px>Название команды</td>";   
echo "<td width=130px>Очки</td>";   
echo "<td width=130px>Состав</td>";   
echo "</table>";   
while($select_arena_rating = mysql_fetch_array($select_arena_ratings)) {   
$select_arena_tnames = mysql_query("SELECT * FROM `characters`.`arena_team` WHERE type=5 && arenateamid='".$select_arena_rating[arenateamid]."'");   
while($select_arena_tname = mysql_fetch_array($select_arena_tnames)) {   
$select_member_names = mysql_query("SELECT * FROM `characters`.`arena_team_member` WHERE arenateamid = '".$select_arena_tname[arenateamid]."'");   
$select_member_rows = mysql_num_rows($select_member_names);   
if($select_member_rows == 5) {   
echo "<table border=1 align=center>";   
echo "<td width=190px><dic style='width:110px;'><a>".$select_arena_tname['name']."</a></div></td>";   
echo "<td width=130px><dic style='width:110px;'><a>".$select_arena_rating['rating']."</a></div></td>";   
echo "<td width=130px>";   
while($select_member_name = mysql_fetch_array($select_member_names)) {   
$result_name_members = mysql_query("SELECT * FROM `characters`.`characters` WHERE guid = '".$select_member_name[guid]."'");   
$result_name_member = mysql_fetch_array($result_name_members);   
echo "<div style='width:110px;'><a>".$result_name_member['name']."</a></div>";   
}   
echo "</td>";   
}   
echo "</table>";   
$i++;   
}   
}

<?php
$conn=mysql_connect('localhost', 'root', 'ascent') or die();
mysql_select_db('forum');

$news_id = $_GET['user_id'];
$news = $_GET['user_posts'];
$i=0;

$query_news=mysql_query("SELECT user_posts, username, user_id FROM phpbb_users ORDER BY user_posts DESC LIMIT 5") or die (mysql_error());
$num_news=mysql_num_rows($query_news);
mysql_close($conn);

?>
<?php while($fetch_news=mysql_fetch_array($query_news)) { $news_id = $fetch_news['user_id']; $i++?>
<?php
$uid = $fetch_news['user_id'];
?>
[*]
<?php print(sprintf("<a href=\"http://localhost/community/memberlist.php?mode=viewprofile&u=%s\">", (string)$uid));?>
<strong class="explore-caption"><?php print $fetch_news['username']; ?></strong>
<?php print $fetch_news['user_posts']; ?> posts</a>
</li>
<?php }?>

<?php   
$dbhost = "host";   
$dbuser = "username";   
$dbpass = "password";   
$dbchar = "characters"; //Most trinity dbs have characters as db. but if u have another, edit it.   

mysql_connect($dbhost, $dbuser, $dbpass);   
mysql_select_db($dbchar);   
?>   
<strong>Top Kills Today</strong>
<hr />   
<?php   
$sql = "SELECT name, killsToday FROM characters ORDER BY killsToday DESC LIMIT 5";   
$i = '1';   
$query = @mysql_query($sql);   
$num = @mysql_num_rows($query);   
if(!$num) {   
    echo 'No kills today.';   
} else {   
    while($row = mysql_fetch_assoc(($query))) {   
     echo "" . $i . ". " . $row["name"] . " with " . $row["killsToday"] . " Honorable Kills.<hr />";   
     $i++;   
    }   
}   
?>   

    
<strong>Top Kills Total</strong>
<hr />   
<?php   
$sql = "SELECT name, killsLifeTime FROM characters ORDER BY killsLifeTime DESC LIMIT 5";   
$i='1';   
$query = @mysql_query($sql);   
$num = @mysql_num_rows($query);   
if(!$num) {   
    echo 'No kills yet.';   
} else {   
    while($row = mysql_fetch_assoc(($query))) {   
     echo "" . $i . ". " . $row["name"] . " with " . $row["killsLifeTime"] . " Honorable Kills.<hr />";   
     $i++;   
    }   
}?>