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 fffb5bf..5d05730 100644 (file)
--- a/includes/SpecialListadmins.php
+++ b/includes/SpecialListadmins.php
@@ -1,6 +1,8 @@
 <?php
 /**
  *
+ * @package MediaWiki
+ * @subpackage SpecialPage
  */
 
 /**
@@ -11,6 +13,8 @@ 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 {
 
@@ -27,9 +31,9 @@ class ListAdminsPage extends PageQueryPage {
                $user = $dbr->tableName( 'user' );
                $user_rights = $dbr->tableName( 'user_rights' );
                $userspace = Namespace::getUser();
-               return "SELECT r.user_rights as type,{$userspace} as namespace,".
-                      "u.user_name as title, u.user_name as value ".
-                      "FROM {$user} u,{$user_rights} r WHERE r.user_id=u.user_id AND r.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%'";
        }
 }