Changeset 353 for global.php

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.

File:

• global.php (modified) (1 diff)

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';