Changeset 579 for trunk/pages/banlist.php

Timestamp:

Apr 30, 2009, 8:10:25 AM (15 years ago)

Author:

george

Message:

• Opraveno: Doplněny ikony pro povolání death knight a soubory přejmenovány dle minimanageru.
• Upraveno: Přeformátování a pročištění různých stránek.

File:

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

trunk/pages/banlist.php

@@ -1 @@
-<center><table border="0">
-<tr><td><center><font color="green" face="verdana" size="3"><b>Kontrola ip adresy</b></font></center></td></tr>
-<tr><td><center><font color="blue" face="verdana" size="1">zadejte prosim vasi IP adresu</font></center></td></tr>
+<?php
+
+echo('<center><table border="0">
+<tr><td><center><font color="green" face="verdana" size="3"><b>Kontrola IP adresy</b></font></center></td></tr>
+<tr><td><center><font color="blue" face="verdana" size="1">Zadejte prosím vaší IP adresu</font></center></td></tr>
 <tr><td><form action="?page=banip" method="post"><input type="text" name="ip" value="127.0.0.1"><input type="submit" name="odeslat" value="zkontroluj"></form></td></tr>
-<tr><td><center><?
-$ipcko = getenv ("REMOTE_ADDR");
-if ($ipcko != false) {
-    echo "<font color=\"red\" size=\"1\" face=\"verdana\">Vaše IP adresa je: $ipcko</font>";
+<tr><td><center>');
+
+$ipcko = getenv('REMOTE_ADDR');
+if($ipcko != false) 
+{
+  echo('<font color="red" size="1" face="verdana">Vaše IP adresa je: '.$ipcko.'</font>');
 }
-?></center></td></tr>
+
+echo('</center></td></tr>
 </table></center>
 <br />
 <center><table border="0">
-<tr><td><center><font color="green" face="verdana" size="3"><b>Kontrola accountu</b></font></center></td></tr>
-<tr><td><center><font color="blue" face="verdana" size="1">zadejte prosim jmeno accountu</font></center></td></tr>
+<tr><td><center><font color="green" face="verdana" size="3"><b>Kontrola účtu</b></font></center></td></tr>
+<tr><td><center><font color="blue" face="verdana" size="1">Zadejte prosím jméno účtu</font></center></td></tr>
 <tr><td><form action="?page=banacc" method="post"><input type="text" name="jmeno" value="name"><input type="submit" name="odeslat" value="zkontroluj"></form></td></tr>
 </table></center>
-<center><font face="verdana" size="1" color="red">vas <span style="color: red">predpokladany</span> account je:
-<?
+<center><font face="verdana" size="1" color="red">váš <span style="color: red">předpokládaný</span> účet je:');
 
-mysql_connect("$db_server","$db_user","$db_pass");
-mysql_select_db("$db_realmd");
 
-$str=mysql_query("select * from `account` where `last_ip` = '$ipcko' order by `last_login` desc limit 3");
-while($str_end=MySQL_Fetch_Array($str)){
-$i=$str_end["username"];
-echo "$i, ";
+$db->select_db($Config['Mangos']['DatabaseRealmd']);
+
+$DbResult = $db->query('select * from `account` where `last_ip` = "'.$ipcko.'" order by `last_login` desc limit 3');
+while($DbRow = $DbResult->fetch_assoc())
+{
+  $i = $$DbRow['username'];
+  echo($i.', ');
 }
 
-?>
-</font></center>
-<br><center>
-<h2>Ban List</h2>
-<?php
-mysql_connect("$db_server","$db_user","$db_pass");
-mysql_select_db("$db_realmd");
+echo('</font></center>
+<br /><center>
+<h2>Seznam banů</h2>');
 
-$sqldata = mysql_query("SELECT `account`.`last_ip`,`ip_banned`.`bandate`,`ip_banned`.`unbandate`,`ip_banned`.`bannedby`,`ip_banned`.`banreason` FROM `account` INNER join `ip_banned` ON `account`.`last_ip`=`ip_banned`.`ip`");
+$sqldata = $db->query('SELECT `account`.`last_ip`,`ip_banned`.`bandate`,`ip_banned`.`unbandate`,`ip_banned`.`bannedby`,`ip_banned`.`banreason` FROM `account` INNER join `ip_banned` ON `account`.`last_ip`=`ip_banned`.`ip`');
 
-echo "<table border=1>";
-echo "<tr><th>IP</th><th>Od</th><th>Do</th><th>Banoval</th><th>Důvod</th></tr>";
+echo('<table border="1">');
+echo('<tr><th>IP</th><th>Od</th><th>Do</th><th>Banoval</th><th>Důvod</th></tr>');
 
-while($row = mysql_fetch_array($sqldata))
-
+while($row = $sqldata->fetch_assoc())
 {
-
-   $start = Date('d-m-Y H:i:s',$row[bandate]);
-   $end = Date('d-m-Y H:i:s',$row[unbandate]);
+  $start = Date('d-m-Y H:i:s', $row['bandate']);
+  $end = Date('d-m-Y H:i:s', $row['unbandate']);
   
-
-   echo "<tr><td>$row[last_ip]</td> <td>$start</td> <td>$end</td> <td>$row[bannedby]</td><td>$row[banreason]</td></tr>";
-
+  echo('<tr><td>'.$row['last_ip'].'</td><td>'.$start.'</td><td>'.$end.'</td><td>'.$row['bannedby'].'</td><td>'.$row['banreason'].'</td></tr>');
 }
-
-echo "</table>";
+echo('</table>');
 
 ?>