Changeset 309 for online_player.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:

• online_player.php (modified) (2 diffs)

online_player.php

@@ -13 +13 @@
         $dir = ($dir) ? 0 : 1;
         
-        $result = $Database->query("SELECT count(*) FROM `character` WHERE `online`= 1");
+        $result = $Database->query("SELECT count(*) FROM `characters` WHERE `online`= 1");
         $Row = $result->fetch_array();
         $total_online = $Row[0];
@@ -23 +23 @@
                         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 `online`= 1 $order_side ORDER BY $order_by $order_dir");
+                        FROM `characters` WHERE `online`= 1 $order_side ORDER BY $order_by $order_dir");
 
         require_once("minimanager/lang/enUS.php");