Changeset 141 for index.php

Timestamp:

Nov 23, 2007, 11:20:39 PM (17 years ago)

Author:

george

Message:

Opraveno: Výběry oddělené databáze characters

File:

• index.php (modified) (4 diffs)

index.php

@@ -1 +1 @@
 <?php
-  include('global.php');
-  include('news.php');
-  ShowHeader();
-  echo('<TABLE width="100%" border="0">
+
+function Events()
+{
+  global $Database;
+  $Database->select_db('mangos');
+  $DbResult = $Database->select('game_event', '*,UNIX_TIMESTAMP(start) as start', 'end > NOW() AND start < NOW()');
+  $Result = '<strong>Probíhající události ve høe:</strong><br>';
+  while($Row = $DbResult->fetch_array())
+  { 
+    $Start = floor((time() - $Row['start']) / ($Row['occurence'] * 60)) * $Row['occurence'] + $Row['start'];
+    $End = $Start + $Row['length'] * 60;
+    $Result .= $Row['description'].' '.date('H:i:s j.n.Y', $Start).' '.date('H:i:s j.n.Y', $End).'<br>';    
+  }
+  
+  return($Result);
+}
+
+include('global.php');
+include('news.php');
+ShowHeader();
+echo('<TABLE width="100%" border="0">
   <TR>
     <TD id="MainCell" valign="top">
@@ -15 +32 @@
 <tr><td width="60%" valign="top">');
 
+
 echo(ShowNews()); 
 echo('
-</td><td id="EmuInfo" valign="top">
-<br>
+</td><td id="EmuInfo" valign="top">');
+
+// Second column
+
+//echo(Events());
+
+echo('<br>
 <div align="center">
 <table class="MiniTable" border="1" cellspacing="0" cellpadding="2">
@@ -38 +61 @@
 
 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>');
@@ -68 +92 @@
 <tr><th>Postav</th><td>');
 
-$Database->select_db('mangos');
+$Database->select_db('characters');
 $Result = $Database->select('character', 'COUNT(*)');
 $Row = $Result->fetch_array();