Changeset 589 for trunk/pages/tophraci.php

Timestamp:

May 18, 2009, 9:01:38 PM (15 years ago)

Author:

george

Message:

• Upraveno: Stránka Top hráči poopravena.
• Přidáno: Datum založení serveru.

File:

• trunk/pages/tophraci.php (modified) (2 diffs)

trunk/pages/tophraci.php

@@ -1 +1 @@
 <?php
 $top = 40; //kolik nejlepších
-$connect = mysql_pconnect($db_server, $db_user, $db_pass)  or die ("Spojení se serverem $ip nebylo uspesne");
 
 function getTime($total)
 {
-  $dny = (int)($total/86400);
-  $total = $total - ($dny*86400);
-  $hodiny = (int)($total/3600);
-  $total = $total - ($hodiny*3600);
-  $minuty = (int)($total/60);
+  $dny = (int)($total / 86400);
+  $total = $total - ($dny * 86400);
+  $hodiny = (int)($total / 3600);
+  $total = $total - ($hodiny * 3600);
+  $minuty = (int)($total / 60);
 
-  $cas = $dny."d ".$hodiny."h ".$minuty."m";
-  return $cas;
+  $cas = $dny.'d '.$hodiny.'h '.$minuty.'m';
+  return($cas);
 }
 
@@ -19 +18 @@
 {
   if ($online == 1):
-    $status = "<font color=green>Online</font>";
+    $status = '<span style="color: green;">Online</span>';
   else:
-    $status = "<font color=red>Offline</font>";
+    $status = '<span style="color: red;">Offline</span>';
   endif;
   
-  return $status;
+  return($status);
 }
 
+$db->select_db($Config['Mangos']['DatabaseCharacters']);
+$sql = 'SELECT name, totaltime, online FROM characters ORDER BY totaltime DESC LIMIT '.$top;
+$result = $db->query($sql);
 
-mysql_select_db($db_characters, $connect);
+$i = 0;
+echo('<h3 class="PageTitle">Nejlepších '.$top.' herních časů</h3>');
 
-
-$sql = "SELECT * FROM characters ORDER BY totaltime DESC LIMIT $top";
-$result = mysql_query($sql);
-
-
-$i=0;
-
-
-echo "<center><h2> Nejlepších $top herních časů</h2>
-      <table>";
-      
-
-while ($vypis=mysql_fetch_array($result))
+echo('<table class="SimpleTable">');      
+while($vypis = $result->fetch_assoc())
 {    
-  $i=$i+1;
-  echo "<tr><td>$i)<th>".$vypis['name']."</th>
-        <td>".getTime($vypis['totaltime'])."</td>
-        <td>".getOnline($vypis['online'])."</td></tr>";
+  $i = $i + 1;
+  echo('<tr><td>'.$i.')<th>'.$vypis['name'].'</th>
+        <td>'.getTime($vypis['totaltime']).'</td>
+        <td>'.getOnline($vypis['online']).'</td></tr>');
 
 }
-
-
-echo "<center></table>";
-
-
-mysql_close();
+echo('</table>');
 
 ?>