﻿<?php

$DbResult = $System->Database->query('SELECT COUNT(*) FROM Realm WHERE Enabled=1');
$DbRow = $DbResult->fetch_row();
$RealmCount = $DbRow[0];

 // Check servers online state.
$DbResult = $System->Database->query('SELECT COUNT(*) FROM Logon WHERE Online = 1 AND Enabled=1');
$DbRow = $DbResult->fetch_row();
$OnlineState = $DbRow[0] > 0; // Report online state if one of all servers is online.

$Output = '<h2 class="PageTitle">O serveru</h2>'.
'<table class="BaseTable">
  <tr>
    <th colspan="2">Statistiky</th>
  </tr>
  <tr>
    <td>Přihlašovací server je</td>
    <td>'.$server->OnlineStateImage($OnlineState).'</td>
  </tr>
  <tr>
    <td>Celkem světů</td>
    <td>'.$RealmCount.'</td>
  </tr>
  <tr>
    <td>Ve všech světech přítomno</td>
    <td>'.$server->OnlineCharactersCount().' hráčů</td>
  </tr>
  <tr>
    <td>V databázi uloženo</td>
    <td>'.$server->AccountCount().' účtů</td>
  </tr>
  <tr>
    <td>Ve všech světech uloženo</td>
    <td>'.$server->CharacterCount().' postav</td>
  </tr>
  <tr>
    <td><a href="'.$html->Link('/teamspeak/').'">TeamSpeak</a> server je</td>
    <td>'.$server->OnlineStateImage($System->NetworkPortState($Config['Web']['WoWServerAddr'], 9987)).'</td>
  </tr>
  <tr>
    <td><a href="http://www.heroesoffantasy.cz:6969/">Torrent</a> server je</td>
    <td>'.$server->OnlineStateImage($System->NetworkPortState($Config['Web']['WoWServerAddr'], 6969)).'</td>
  </tr>
  <tr>
    <td>Datum založení</td>
    <td>'.$Config['Web']['ServerFounded'].'</td>
  </tr>
  <tr>
    <th colspan="2">Software</th>
  </tr>
  <tr>
    <td>Aktuální WoW emulátor</td>
    <td>MaNGOS rev.'.$Config['Mangos']['Revision'].'</td>
  </tr>
  <tr>
    <td>Aktuální WoW databáze</td>
    <td>UDB '.$Config['Mangos']['UDBVersion'].' rev. '.$Config['Mangos']['UDBRevision'].'</td>
  </tr>
  <tr>
    <td>ScriptDev2</td>
    <td>Scriptdev2 rev. '.$Config['Mangos']['ScriptDev2Revision'].'</td>
  </tr>
  <tr>
    <th colspan="2">Servery</th>
  </tr>
  <tr><td colspan="2" style="padding: 5px;">';

$DbResult = $System->Database->query('SELECT * FROM Host');
while($Host = $DbResult->fetch_assoc())
{
  $Realms = array();
  $DbResult2 = $System->Database->query('SELECT * FROM Realm');
  while($Realm = $DbResult2->fetch_assoc())
  {
    if($Realm['Host'] == $Host['Id']) $Realms[] = $Realm['Name'];
  }
    
  $Output .= '<table class="BaseTable" style="width: 100%; margin: 5px;">
  <tr>
    <th colspan="2">Server '.$Index.'</td>
  </tr>
  <tr>
    <td>Operační systém</td>
    <td>'.$Host['OS'].'</td>
  </tr>
  <tr>
    <td>Procesor</td>
    <td>'.$Host['CPU'].'</td>
  </tr>
  <tr>
    <td>Operační paměť</td>
    <td>'.$Host['Memory'].'</td>
  </tr>
  <tr>
    <td>Pevný disk</td>
    <td>'.$Host['HDD'].'</td>
  </tr>
  <tr>
    <td>Adresa serveru</td>
    <td>'.$Host['Address'].'</td>
  </tr>
  <tr>
    <td>Internetová linka</td>
    <td>'.$Host['Internet'].'</td>
  </tr>
  <tr>
    <td>Světy</td>
    <td>'.implode(', ', $Realms).'</td>
  </tr>
  <tr>
    <td>Grafy</td>
    <td><a href="'.$Host['Statistic'].'">'.$Host['Statistic'].'</a></td>
  </tr>
  </table>';
}
$Output .= '</td></tr>
</table>';

echo($Output);

?>
