Changeset 353

Timestamp:

May 1, 2008, 1:20:20 PM (16 years ago)

Author:

george

Message:

Upraveno: Info tabulka na hlavní stránce. Zobrazení počtu hráčů podle tabulky characters namísto account.

Files:

• global.php (modified) (1 diff)
• index.php (modified) (3 diffs)

global.php

@@ -38 +38 @@
 }
 
-function ShowOnlinePlayerCount()
-{
-  global $Database;
- //ini_set('allow_url_fopen', 'On');
-  // World of Warcraft user stat
-  //$Content = @file_get_contents('http://wow.zdechov.net:8080/stat.xml');
-  //$File = fopen('http://'.$WoWServer.'/mangos/inc/stat.xml', 'r');
-  //$Content = fgets($File, 1000000);
-  //fclose($File);
+function OnlinePlayerCount()
+{
+  global $Database;
   $Database->select_db('characters');
   $Result = $Database->select('characters', 'COUNT(*)', 'online=1');
   $Row = $Result->fetch_array();
-  $PlayerCount = $Row[0];
-  
+  return($Row[0]); 
+}
+
+function CharacterCount()
+{
+  global $Database;
+  $Database->select_db('characters');
+  $Result = $Database->select('characters', 'COUNT(*)');
+  $Row = $Result->fetch_array();
+  return($Row[0]);
+}
+
+function AccountCount()
+{
+  global $Database;
+  $Database->select_db('realmd');
+  $DbResult = $Database->query('SELECT COUNT(*) FROM account');
+  $Row = $DbResult->fetch_array();
+  return($Row[0]);
+}
+
+function MangosUptime()
+{
+  global $Database;
+  $Database->select_db('mangos');
+  $DbResult = $Database->query('SELECT `starttime`, `uptime` FROM `uptime` ORDER BY `starttime` DESC LIMIT 1');
+  $Row = $DbResult->fetch_array();
+  $Uptime = $Row['uptime'];
+  //$Uptime = 0;
+  $Days = floor($Uptime / 3600 / 24);
+  if($Days == 0) $DaysText = '';
+  else if($Days == 1) $DaysText = $Days.' den';
+  else if(($Days > 1) and ($Days < 5)) $DaysText = $Days.' dny';
+  else if(($Days > 5)) $DaysText = $Days.' dnù';
+  $Seconds = $Uptime - 3600 * 19;
+  return($DaysText.' '.date('G:i', $Seconds));
+}
+
+function RunningEventCount()
+{
+  global $Database;
+  $Count = 0;
+  $Database->select_db('mangos');
+  $DbResult = $Database->select('game_event', '*, UNIX_TIMESTAMP(start_time) as start', 'end_time > NOW() AND start_time < NOW()');
+  while($Row = $DbResult->fetch_array())
+  { 
+    $Start = (floor((time() - $Row['start']) / ($Row['occurence'] * 60))) * $Row['occurence'] * 60 + $Row['start'];
+    $End = $Start + $Row['length'] * 60;
+    if((time() > $Start) and (time() < $End)) $Count++;
+  }
+  return($Count);
+}
+
+function ShowOnlinePlayerCount()
+{
+  $PlayerCount = OnlinePlayerCount();
   if($PlayerCount == 1) $P = 'hráè';
   else if(($PlayerCount >= 2) and ($PlayerCount <= 4)) $P = 'hráèi';

index.php

@@ -9 +9 @@
 <div>
 Vítejte na serveru <span class="Nadpis">Heroes of Fantasy</span>, neoficiálním herním serveru hry <a href="http://www.worldofwarcraft.com/">World of Warcraft</a>!<br>
-WoW je <acronym title="Massive Multiplayer Online Role Playing Game">MMORPG</acronym> její¾ tvùrcem je spoleènost <a href="http://www.blizzard.com/">Blizzard Entertainment</a>.
-Existují oficiální servery, na kterých je nutno platit mìsíèní poplatek. Tento server je v¹ak neoficiální a mù¾ete zde hrát zdarma. Pøesto¾e neoficiální servery nikdy nedosáhnou takové kvality jako oficiální, mù¾ete zde za¾ít mnoho pøíjemných chvil a seznámit se zajímavými lidmi.
+WoW je <acronym title="Massive Multiplayer Online Role Playing Game">MMORPG</acronym> vytvoøená spoleèností <a href="http://www.blizzard.com/">Blizzard Entertainment</a>.
+Ta provozuje oficiální servery, na kterých je nutno platit mìsíèní poplatek. Tento server je v¹ak neoficiální a mù¾ete zde hrát zdarma. Pøesto¾e neoficiální servery nikdy nedosáhnou takové kvality jako oficiální, mù¾ete zde za¾ít mnoho pøíjemných chvil a seznámit se zajímavými lidmi.
 Nyní je ji¾ potøeba se jenom zaregistrovat, pøipojit do hry a v¾ít se do role hrdiny, který putuje svìtem fantasie a utkává se v boji s rozliènými stvùrami.     
 </div>
 <table id="SplitTable" cellspacing="5" cellpadding="0" width="100%">
 <tr><td width="60%" valign="top">');
-
 
 echo(ShowNews()); 
@@ -23 +22 @@
 // Second column
 
-//echo(Events());
-
 echo('<br>
 <div align="center">
 <table class="MiniTable" border="1" cellspacing="0" cellpadding="2">
 <tr><th>Emulátor</th><td>MaNGOS</td></tr>
-<tr><th>Verze hry</th><td>');
-echo($Config['Mangos']['ClientVersion']); 
-echo('</td></tr>'.
+<tr><th>Verze hry</th><td>'.$Config['Mangos']['ClientVersion'].'</td></tr>'.
 '<tr><th>Stav</th><td>');
 if(CheckPortStatus($WoWServer, 8085)) echo('<span style="color: #33ff33;">ONLINE</span>'); 
   else echo('<span style="color: red;">OFFLINE</span>'); 
 echo('</td></tr>
-<tr><th>Online hráèù</th><td><a href="http://'.$WoWServer.'/online_player.php">');
+<tr><th>Doba bìhu</th><td>'.MangosUptime().'</td></tr>
+<tr><th>Online hráèù</th><td><a href="'.$BaseUrl.'/online_player.php">'.OnlinePlayerCount().'</a></td></tr>
 
-$Database->select_db('realmd');
-$Result = $Database->select('account', 'COUNT(*)', 'online=1');
-$Row = $Result->fetch_array();
-$PlayersOnlineCount = $Row[0];
-echo($PlayersOnlineCount);
-
-echo('</a></td></tr>
-
-<tr><th>Návod</th><td><a href="jak_zacit.php">zde</a></td></tr>
 <tr><th>Stav registrací</th><td>');
 include('registrace/reg_config.php');
-$Database->select_db('realmd');
-$DbResult = $Database->query('SELECT COUNT(*) FROM account');
-$Row = $DbResult->fetch_array();
-$AccountCount = $Row[0];
+$AccountCount = AccountCount();
 $Remain = $MaximumAccountCount-$AccountCount;
 if($Remain <= 0) echo('VYÈERPANÉ'); else echo('VOLNÉ'); 
-echo('</td></tr>
+echo('</td></tr>');
+/*
+<tr><th>Návod</th><td><a href="jak_zacit.php">zde</a></td></tr>
 <tr><th>Registrace</th><td>');
 echo('<a href="'.$BaseUrl.'registrace/">zde</a>'); 
@@ -61 +47 @@
 <tr><th>Správa úètu</th><td>');
 echo('<a href="'.$BaseUrl.'minimanager/">zde</a>');
-echo('</td></tr>
+echo('</td></tr>');
 <tr><th>Existuje dnù</th><td>');
 echo(round((time()-mktime (0,0,0,4,21,2007))/3600/24)); 
 echo('</td></tr>
-<tr><th>Úètù</th><td>');
-
-$Database->select_db('realmd');
-$Result = $Database->select('account', 'COUNT(*)');
-$Row = $Result->fetch_array();
-$AccountCount = $Row[0];
-echo($AccountCount);
-
-echo('</td></tr>
-<tr><th>Postav</th><td>');
-
-$Database->select_db('characters');
-$Result = $Database->select('characters', 'COUNT(*)');
-$Row = $Result->fetch_array();
-$CharactersCount = $Row[0];
-echo($CharactersCount);
-
-echo('</td></tr>
+*/
+echo('<tr><th>Úètù</th><td>'.$AccountCount.'</td></tr>
+<tr><th>Postav</th><td>'.CharacterCount().'</td></tr>
+<tr><th>Bì¾ících akcí</th><td><a href="'.$BaseUrl.'events.php">'.RunningEventCount().'</a></td></tr>
 </table>
 </div>