Hello.
Perhaps there is problem with that "$wgDBprefix.x". I think it should be
"{$wgDBprefix}{$wgDBname}.x".
-Matěj Grabovský
---------------------------------------------------------
Od: Jim Hu
Přijato: 27.3.2008 15:24:34
Předmět: [Mediawiki-l] Help needed re:db access problems for UserRightsListextension
[...]
function findMyUsers(){
global $wgUser, $wgDBprefix;
$dbr =& wfGetDB( DB_SLAVE );
if(in_array('userrights',$wgUser->getRights())){
$sql = "SELECT u.user_id, u.user_name, u.user_registration FROM
$wgDBprefix.user u WHERE 1";
}else{
$sql = "SELECT u.user_id, u.user_name, u.user_registration FROM
$wgDBprefix.logging l, $wgDBprefix.user u WHERE
l.log_title = u.user_name AND
log_type = 'newusers' AND
log_user = '".$wgUser->getID()."'
";
}
if (isset($this->group) && $this->group !=''){
$sql = str_replace("FROM","FROM $wgDBprefix.user_groups, ", $sql);
$sql .= " AND ug_user = u.user_id AND ug_group =
'".$this->group."'
";
}
if (isset($this->username) && !is_null($this->username) && $this-
username != ''){
$sql .= " AND u.user_name LIKE'".mysql_real_escape_string($this-
username)."' ";
}
if (isset($this->yearfrom) && !is_null($this->yearfrom) && $this-
yearfrom != ''){
$month = '00';
if (!is_null($this->monthfrom ) ) $month = $this->monthfrom;
$fromdate = str_pad($this->yearfrom.$month, 14, '0', STR_PAD_RIGHT);
$sql .= " AND STRCMP(u.user_registration,'$fromdate') = 1 ";
}
if (isset($this->yearto) && !is_null($this->yearto) && $this-
yearto != ''){
$year = $this->yearto;
$month = '99';
if (!is_null($this->monthto ) ) $month = $this->monthto;
$todate = str_pad($year.$month, 14, '9', STR_PAD_RIGHT);
$sql .= " AND STRCMP(u.user_registration,'$todate') = -1 ";
}
$sql .= " ORDER BY u.user_name";
$sql = $dbr->limitResult($sql, $this->limit, $this->offset);
#echo $sql;
$results = $dbr->query($sql);
$this->num = $dbr->numRows($results);
if (!$results) return array();
while( $x = $dbr->fetchObject ( $results ) ) {
$arr[] = get_object_vars($x);
}
return $arr;
}
[...]