Rename fields of user_rights and user_groups table to tablename_columnname schema

[lhc/web/wiklou.git] / includes / SpecialListadmins.php

diff --git a/includes/SpecialListadmins.php b/includes/SpecialListadmins.php
index 8518c43..5d05730 100644 (file)
--- a/includes/SpecialListadmins.php
+++ b/includes/SpecialListadmins.php
@@ -1,10 +1,21 @@
 <?php
-#
-# This class is used to get a list of users flagged with "sysop"
-# right.
-
+/**
+ *
+ * @package MediaWiki
+ * @subpackage SpecialPage
+ */
+
+/**
+ *
+ */
 require_once("QueryPage.php");
 
+/**
+ * This class is used to get a list of users flagged with "sysop" right.
+ *
+ * @package MediaWiki
+ * @subpackage SpecialPage
+ */
 class ListAdminsPage extends PageQueryPage {
 
        function getName() {
@@ -16,16 +27,19 @@ class ListAdminsPage extends PageQueryPage {
        }
 
        function getSQL() {
-               global $wgIsPg;
-               $usertable = $wgIsPg?'"user"':'user';
+               $dbr =& wfGetDB( DB_SLAVE );
+               $user = $dbr->tableName( 'user' );
+               $user_rights = $dbr->tableName( 'user_rights' );
                $userspace = Namespace::getUser();
-               return 'SELECT user_rights as type,'.$userspace.' as namespace,'.
-                      'user_name as title, user_name as value '.
-                      "FROM $usertable ".
-                          'WHERE user_rights LIKE "%sysop%"';
+               return "SELECT ur_rights as type,{$userspace} as namespace,".
+                      "user_name as title, user_name as value ".
+                      "FROM {$user} ,{$user_rights} WHERE user_id=ur_uid AND ur_rights LIKE '%sysop%'";
        }
 }
 
+/**
+ * constructor
+ */
 function wfSpecialListadmins() {
        list( $limit, $offset ) = wfCheckLimits();