Changeset 556 for trunk/pages/gmlog.php

Timestamp:

Mar 29, 2009, 6:45:56 PM (15 years ago)

Author:

george

Message:

• Opraveno: Formátování stránek a validace XHTML.
• Opraveno: Opakované připojování k databází při zobraznení gmlogu. Chybně umístěný obrázek.

File:

• trunk/pages/gmlog.php (modified) (1 diff)

trunk/pages/gmlog.php

@@ -1 +1 @@
 <?php
-$gmlog = "/a/mangos1/logs/GM_Commands.log"; //CESTA K GM LOGU
-$config = "../gh_system/conn.php"; //CESTA KE CONN.PHP
+
+$gmlog = $Config['Mangos']['GMCommandsLog'];
 $pocet_radku = 50; //KOLIK RADKU Z LOGU SE BUDE ZOBRAZOVAT
 
-echo"<table align=center bordercolor='black' border=2><tr><td align=center><strong>Cas</strong><td align=center><strong>Příkaz</strong><td align=center><strong>GM</strong><td align=center><strong>Vybrán</strong></tr>";
+echo('<img src="imgs/gm.jpg" alt="gm" /><br />');
+echo('<table class="gmlog"><tr><th>Čas</th><th>Příkaz</th><th>GM</th><th>Vybrán</th></tr>');
 
-
-
-
-echo('<img src="imgs/gm.jpg" alt="gm">');
-include($config);
 $data = file($gmlog);
 $radku = count($data);
 $i = 0;
-echo "<br />";
 
-while($i < $pocet_radku){
-$radek = $radku-1;
-$pole=explode(" ",$data[$radek]);
+$db->select_db($Config['Mangos']['DatabaseCharacters']);
 
-if($pole[3]=="announce"):
-$prikaz = "announce ...";
-else:
-$prikaz=explode("[","$pole[3] $pole[4] $pole[5] $pole[6] $pole[7] $pole[8] $pole[9]");
-$prikaz = $prikaz[0];
-endif;
+while($i < $pocet_radku)
+{
+  $radek = $radku - 1;
+  $pole = explode(' ', $data[$radek]);
 
-$prikaz_pole=explode("[","$pole[3] $pole[4] $pole[5] $pole[6] $pole[7] $pole[8] $pole[9]");
-$hrac_pole=explode("Player:",$data[$radek]);
-$hrac=explode(" ",$hrac_pole[1]);
-$vybran_pole=explode("Selected:",$data[$radek]);
-$vybran=explode(" ",$vybran_pole[1]);
+  if($pole[3] == 'announce') $prikaz = 'announce ...';
+  else
+  {
+    $prikaz = explode('[', $pole[3].' '.$pole[4].' '.$pole[5].' '.$pole[6].' '.$pole[7].' '.$pole[8].' '.$pole[9]);
+    $prikaz = $prikaz[0];
+  }
 
-if($vybran[1]=="player"):
-$guid_pole=explode("GUID:",$vybran_pole[1]);
-$guid=explode(")]",$guid_pole[1]);
+  $prikaz_pole = explode('[', $pole[3].' '.$pole[4].' '.$pole[5].' '.$pole[6].' '.$pole[7].' '.$pole[8].' '.$pole[9]);
+  $hrac_pole = explode('Player:', $data[$radek]);
+  $hrac = explode(' ', $hrac_pole[1]);
+  $vybran_pole = explode('Selected:', $data[$radek]);
+  $vybran = explode(' ', $vybran_pole[1]);
 
-mysql_connect($SQL_Server, $SQL_Uzivatel, $SQL_Heslo);
-  mysql_select_db($Databaze_characters);
-  mysql_query("SET NAMES 'utf8'");
-   $pocet = mysql_num_rows(mysql_query("SELECT guid FROM characters where guid=$guid[0]"));
-   if($pocet!=0):
-  $query = mysql_query("SELECT * FROM characters where guid=$guid[0]");
-           while ($radek = mysql_fetch_array($query) ) {
-           $vybran_radek = $radek['name']; 
-           $vybran = "hráč $vybran_radek";
-           }
-else:
-$vybran = "<i>neznámý hrác</i>";
-endif;
-else:
-$vybran = $vybran[1];
-endif;
+  if($vybran[1] == 'player')
+  {
+    $guid_pole = explode('GUID:', $vybran_pole[1]);
+    $guid = explode(')]', $guid_pole[1]);    
+    
+    $DbResult = $db->query('SELECT name FROM characters WHERE guid='.$guid[0]);
+    if($DbResult->num_rows > 0)
+    {
+      $radek = $DbResult->fetch_assoc();
+      $vybran_radek = $radek['name']; 
+      $vybran = 'hráč '.$vybran_radek;
+    } else $vybran = '<i>neznámý hráč</i>';
+  } else $vybran = $vybran[1];
 
-echo"<tr><td align=center>$pole[0] $pole[1]<td align=center>$prikaz<td align=center>$hrac[1]<td align=center>$vybran</tr>";
-$i = $i+1;
-$radku = $radku-1;
+  echo('<tr><td>'.$pole[0].' '.$pole[1].'</td><td>'.$prikaz.'</td><td>'.$hrac[1].'</td><td>'.$vybran.'</td></tr>');
+  $i = $i + 1;
+  $radku = $radku - 1;
 }
-echo"</table>";
+echo('</table>');
 
 ?>