Re: [Mediawiki-l] Help needed re:db access problems for UserRightsListextension

Thanks! On Mar 28, 2008, at 7:44 AM, Grabovský Matěj wrote:

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;

}

[...]

---

http://mujblog.atlas.cz/ _______________________________________________ MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l

===================================== Jim Hu Associate Professor Dept. of Biochemistry and Biophysics 2128 TAMU Texas A&M Univ. College Station, TX 77843-2128 979-862-4054