Changeset 309 for honor.php

Timestamp:

Mar 13, 2008, 8:45:46 PM (17 years ago)

Author:

george

Message:

Opravy související s přejmenování sloupce character na characters.

File:

• honor.php (modified) (2 diffs)

honor.php

@@ -34 +34 @@
         $order_dir = ($dir) ? "ASC" : "DESC";
         
-        $result = $Database->query("SELECT count(*) FROM `character`");
+        $result = $Database->query("SELECT count(*) FROM `characters`");
         $Row = $result->fetch_array();
         $total_online = $Row[0];
@@ -48 +48 @@
                         CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', ".(CHAR_DATA_OFFSET_HONOR_POINTS+1)."), ' ', -1) AS UNSIGNED) AS highest_rank,
                         CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', ".(CHAR_DATA_OFFSET_LEVEL+1).'), " ", -1) AS UNSIGNED) AS level,account
-                        FROM `character` WHERE 1 '.$order_side.' ORDER BY '.$order_by.' '.$order_dir.' LIMIT '.$Page*$PerPage.','.$PerPage);
+                        FROM `characters` WHERE 1 '.$order_side.' ORDER BY '.$order_by.' '.$order_dir.' LIMIT '.$Page*$PerPage.','.$PerPage);
 
         require_once("minimanager/lang/enUS.php");