RatingExtension/Source Code - Revision history

Trevorp at 13:59, 7 August 2006

Trevorp — Mon, 07 Aug 2006 13:59:10 GMT

←Older revision		Revision as of 13:59, 7 August 2006
Line 104:		Line 104:
	$wgExtensionCredits["parserhook"][]=array(		$wgExtensionCredits["parserhook"][]=array(
	'name' => 'Rating Extension',		'name' => 'Rating Extension',
-	'version' => '0.3',	+	'version' => '0.3.1',
	'url' => 'http://wiki.peacocktech.com/wiki/RatingExtension',		'url' => 'http://wiki.peacocktech.com/wiki/RatingExtension',
	'author' => '[http://about.peacocktech.com/trevorp/ Trevor Peacock]',		'author' => '[http://about.peacocktech.com/trevorp/ Trevor Peacock]',
Line 148:		Line 148:
	{		{
	$parameters=splitParameters($input);		$parameters=splitParameters($input);
-	$sortdata=getSortData(isset($parameters['namespace'])?$parameters['namespace']:array());	+	$sortdata=getSortData(isset($parameters['namespace'])?
-	$ratings=getRatingList(	+	$parameters['namespace']:array());
-	isset($parameters['namespace'])?$parameters['namespace']:array(), $sortdata['column'], $sortdata['order'], isset($parameters['limit'])?$parameters['limit'][0]:10);	+	$ratings=getRatingList(isset($parameters['namespace'])?
		+	$parameters['namespace']:array(), $sortdata['column'], $sortdata['order'],
		+	isset($parameters['limit'])?$parameters['limit'][0]:10);
	$output='';		$output='';
	$displayCount=(isset($parameters['displaycount'])?		$displayCount=(isset($parameters['displaycount'])?
Line 162:		Line 164:
	{		{
	$output.=str_replace(array('$1', '$2', '$3', '$4', '$5'),		$output.=str_replace(array('$1', '$2', '$3', '$4', '$5'),
-	array($rating['title'], strtr($rating['title'], '_', ' '),	+	array(($rating['namespace']==6?':':'').$rating['title'],
		+	strtr($rating['title'], '_', ' '),
	number_format($rating['rating'], 2),		number_format($rating['rating'], 2),
	$rating['count'], $rating['oldid']), $pattern)."\n\n";		$rating['count'], $rating['oldid']), $pattern)."\n\n";
Line 285:		Line 288:
	$namespacestring=substr($namespacestring, 2);		$namespacestring=substr($namespacestring, 2);
	$sql="SELECT `page_latest` AS `oldid` FROM `page` WHERE".		$sql="SELECT `page_latest` AS `oldid` FROM `page` WHERE".
-	' `page_namespace` IN ('.$namespacestring.') AND'.' `page_latest` NOT IN (SELECT `page_oldid` FROM `ratings_cache`);';	+	' `page_namespace` IN ('.$namespacestring.') AND'.' `page_latest` NOT IN '.
		+	'(SELECT `page_oldid` FROM `ratings_cache`);';
	$articles=runQuery2($sql);		$articles=runQuery2($sql);
	foreach($articles as $article)		foreach($articles as $article)
Line 295:		Line 299:
	# Optionally it may return sorting rating information for results #		# Optionally it may return sorting rating information for results #
	#-------------------------------------------------------------------------------		#-------------------------------------------------------------------------------
-	function getPageList($namespace=array(), $ratings=false, $sort='title', $order=SORT_ASC, $limit=100)	+	function getPageList($namespace=array(), $ratings=false, $sort='title',
		+	$order=SORT_ASC, $limit=100)
	{		{
	global $renderLimit, $allowedNamespaces;		global $renderLimit, $allowedNamespaces;
Line 316:		Line 321:
	if($ratings)		if($ratings)
	$sql="SELECT `page_title` AS `title`, `page_namespace` AS `namespace`, ".		$sql="SELECT `page_title` AS `title`, `page_namespace` AS `namespace`, ".
-	"`page_latest` AS `oldid`, `page_oldid`, `page_rating` AS `rating`, `page_rating_count` AS `count` FROM `page`, `ratings_cache` WHERE `page_latest`=`page_oldid`".($filterByNamespace?	+	"`page_latest` AS `oldid`, `page_oldid`, `page_rating` AS `rating`, ".
		+	"`page_rating_count` AS `count` FROM `page`, `ratings_cache` ".
		+	"WHERE `page_latest`=`page_oldid`".($filterByNamespace?
	' AND `page_namespace` IN ('.$namespacestring.')':"").		' AND `page_namespace` IN ('.$namespacestring.')':"").
-	' ORDER BY '.$sort.($order==SORT_ASC?'':'').($order==SORT_DESC?' DESC':'').' LIMIT '.$limit.';';	+	' ORDER BY '.$sort.($order==SORT_ASC?'':'').
		+	($order==SORT_DESC?' DESC':'').' LIMIT '.$limit.';';
	return runQuery2($sql);		return runQuery2($sql);
	}		}
Line 326:		Line 334:
	# namespaces #		# namespaces #
	#-------------------------------------------------------------------------------		#-------------------------------------------------------------------------------
-	function getRatingList($namespace=array(), $sort='title', $order=SORT_ASC, $limit=100)	+	function getRatingList($namespace=array(), $sort='title', $order=SORT_ASC,
		+	$limit=100)
	{		{
	global $wgNamespaceNamesEn, $renderLimit;		global $wgNamespaceNamesEn, $renderLimit;
Line 335:		Line 344:
	foreach($articles as $article)		foreach($articles as $article)
	{		{
-	$rating=formatRating(array('count'=>$article->count, 'rating'=>$article->rating));	+	$rating=formatRating(array('count'=>$article->count,
		+	'rating'=>$article->rating));
	$ratings[]=array('title' => $wgNamespaceNamesEn[$article->namespace].		$ratings[]=array('title' => $wgNamespaceNamesEn[$article->namespace].
	($article->namespace==0?'':':').$article->title,		($article->namespace==0?'':':').$article->title,
-	'rating' => $rating['rating'], 'count' => $rating['count'], 'oldid'=>$article->oldid);	+	'rating' => $rating['rating'], 'count' => $rating['count'],
		+	'oldid'=>$article->oldid, 'title_name'=>$article->title,
		+	'namespace_name'=>$wgNamespaceNamesEn[$article->namespace],
		+	'namespace'=>$article->namespace);
	}		}
	return $ratings;		return $ratings;
Line 516:		Line 529:
	$sql='SELECT * FROM `ratings_cache` WHERE `page_oldid`='.intval($oldid).';';		$sql='SELECT * FROM `ratings_cache` WHERE `page_oldid`='.intval($oldid).';';
	$rating=runQuery($sql);		$rating=runQuery($sql);
-	$rating=array('rating'=>$rating->page_rating, 'count'=>$rating->age_rating_count);	+	$rating=array('rating'=>$rating->page_rating,
		+	'count'=>$rating->age_rating_count);
	if($rating->page_oldid==null)		if($rating->page_oldid==null)
	$rating=calculateRating($oldid);		$rating=calculateRating($oldid);

Trevorp at 00:33, 2 August 2006

Trevorp — Wed, 02 Aug 2006 00:33:20 GMT

←Older revision		Revision as of 00:33, 2 August 2006
Line 284:		Line 284:
	}		}
	$namespacestring=substr($namespacestring, 2);		$namespacestring=substr($namespacestring, 2);
-	$sql="SELECT `page_latest` AS `oldid` FROM `page` WHERE".($filterByNamespace?	+	$sql="SELECT `page_latest` AS `oldid` FROM `page` WHERE".
-	' `page_namespace` IN ('.$namespacestring.') AND':"").' `page_latest` NOT IN (SELECT `page_oldid` FROM `ratings_cache`);';	+	' `page_namespace` IN ('.$namespacestring.') AND'.' `page_latest` NOT IN (SELECT `page_oldid` FROM `ratings_cache`);';
	$articles=runQuery2($sql);		$articles=runQuery2($sql);
	foreach($articles as $article)		foreach($articles as $article)

Trevorp at 00:21, 2 August 2006

Trevorp — Wed, 02 Aug 2006 00:21:01 GMT

(Difference between revisions)

Trevorp at 04:37, 30 July 2006

Trevorp — Sun, 30 Jul 2006 04:37:30 GMT

←Older revision		Revision as of 04:37, 30 July 2006
Line 122:		Line 122:
	return $oldid;		return $oldid;
	$dbr =& wfGetDB( DB_SLAVE );		$dbr =& wfGetDB( DB_SLAVE );
-	$sql = "SELECT MAX(`rc_this_oldid`) AS `rc_this_oldid` FROM recentchanges '.	+	$sql = "SELECT MAX(`rc_this_oldid`) AS `rc_this_oldid` FROM recentchanges ".
-	'WHERE rc_cur_id=".$article->getID().";";	+	"WHERE rc_cur_id=".$article->getID().";";
	$res=wfQuery($sql, DB_SLAVE, "");		$res=wfQuery($sql, DB_SLAVE, "");
	$row=$dbr->fetchObject( $res );		$row=$dbr->fetchObject( $res );
Line 136:		Line 136:
	function getRatingData($oldid)		function getRatingData($oldid)
	{		{
-	$sql="SELECT COUNT(*) AS `count`, AVG(`page_rating`) AS `rating` '.	+	$sql="SELECT COUNT(*) AS `count`, AVG(`page_rating`) AS `rating` ".
-	'FROM ratings WHERE `page_oldid`=".$oldid." GROUP BY `page_oldid`;";	+	"FROM ratings WHERE `page_oldid`=".$oldid." GROUP BY `page_oldid`;";
	return runQuery($sql);		return runQuery($sql);
	}		}

Trevorp at 04:34, 30 July 2006

Trevorp — Sun, 30 Jul 2006 04:34:23 GMT

(Difference between revisions)

Trevorp at 02:11, 30 July 2006

Trevorp — Sun, 30 Jul 2006 02:11:32 GMT

←Older revision		Revision as of 02:11, 30 July 2006
Line 20:		Line 20:
	#Record Rating		#Record Rating
	#----------------		#----------------
-	$sql = "CREATE TABLE IF NOT EXISTS `ratings` (\n".
-	" `page_oldid` int(8) unsigned NOT NULL auto_increment,\n".
-	" `user_id` int(11) NOT NULL,\n".
-	" `page_rating` int(8) unsigned NOT NULL,\n".
-	" PRIMARY KEY (`page_oldid`, `user_id`)\n".
-	") ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;";
	$sql = "REPLACE INTO `ratings` (`page_oldid`, `user_id`, `page_rating`) VALUES (".$_GET['oldid'].", '".($wgUser->getID()?$wgUser->getID():$wgUser->getName())."', ".$_GET['rate'].")";		$sql = "REPLACE INTO `ratings` (`page_oldid`, `user_id`, `page_rating`) VALUES (".$_GET['oldid'].", '".($wgUser->getID()?$wgUser->getID():$wgUser->getName())."', ".$_GET['rate'].")";
	$dbr =& wfGetDB( DB_WRITE );		$dbr =& wfGetDB( DB_WRITE );
Line 105:		Line 99:
	$finalrating=$rating/$count;		$finalrating=$rating/$count;

-	$finalrating=($finalrating-1)*1.25;	+	if(is_numeric($finalrating))
		+	$finalrating=($finalrating-1)*1.25;
	$ratingarray=array('display'=>(is_numeric($finalrating)?number_format($finalrating, 2):$finalrating)." ($currentcount ratings)",		$ratingarray=array('display'=>(is_numeric($finalrating)?number_format($finalrating, 2):$finalrating)." ($currentcount ratings)",
	'count'=>$currentcount,		'count'=>$currentcount,
-	'rating'=>$finalrating);	+	'rating'=>(is_numeric($finalrating)?$finalrating:0));
	return $ratingarray;		return $ratingarray;
	}		}

Trevorp at 01:55, 30 July 2006

Trevorp — Sun, 30 Jul 2006 01:55:52 GMT

New page

<pre><?php

#If html request requests file, serve file
if(isset($_GET['file']))
doFile();

#If html request contains rate information, process it
if(isset($_GET['rate']))
{
#Init
#----------------
require_once( 'includes/Setup.php' );
require_once( "includes/Wiki.php" );
$mediaWiki = new MediaWiki();
$action = $wgRequest->getVal( 'action', 'view' );
$title = $wgRequest->getVal( 'title' );
$wgTitle = $mediaWiki->checkInitialQueries( $title,$action,$wgOut, $wgRequest, $wgContLang );

#Record Rating
#----------------
$sql = "CREATE TABLE IF NOT EXISTS `ratings` (\n".
" `page_oldid` int(8) unsigned NOT NULL auto_increment,\n".
" `user_id` int(11) NOT NULL,\n".
" `page_rating` int(8) unsigned NOT NULL,\n".
" PRIMARY KEY (`page_oldid`, `user_id`)\n".
") ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;";
$sql = "REPLACE INTO `ratings` (`page_oldid`, `user_id`, `page_rating`) VALUES (".$_GET['oldid'].", '".($wgUser->getID()?$wgUser->getID():$wgUser->getName())."', ".$_GET['rate'].")";
$dbr =& wfGetDB( DB_WRITE );
$res=wfQuery($sql, DB_WRITE, "");

#Return to refering page and exit
#----------------
$wgTitle->invalidateCache();
header( 'Location: '.$_SERVER["HTTP_REFERER"] ) ;
die();
}

#get oldid of current page
function getOldID($article)
{
$oldid=$article->getOldIDFromRequest();
if($oldid!=0)
return $oldid;
$dbr =& wfGetDB( DB_SLAVE );
$sql = "SELECT MAX(`rc_this_oldid`) AS `rc_this_oldid` FROM recentchanges WHERE rc_cur_id=".$article->getID().";";
$res=wfQuery($sql, DB_WRITE, "");
$row=$dbr->fetchObject( $res );
if($row->rc_this_oldid)
return $row->rc_this_oldid;
return null;
}

#run sql code
function runQuery($sql)
{
$dbr =& wfGetDB( DB_SLAVE );
$res=wfQuery($sql, DB_SLAVE, "");
return $dbr->fetchObject( $res );
}

#perform sql query to fetch rating for a given oldid
function getRatingData($oldid)
{
$sql="SELECT COUNT(*) AS `count`, AVG(`page_rating`) AS `rating` FROM ratings WHERE `page_oldid`=".$oldid." GROUP BY `page_oldid`;";
return runQuery($sql);
}

#fetch/calculate rating from database
function getRating($oldid)
{
global $wgTitle;

$countlimit=3;

$ratingdata=getRatingData($oldid);
$finalrating='?';
$currentcount=number_format($ratingdata->count, 0);
if($rating->count<$countlimit)
{
$count=$ratingdata->count;
$rating=$count*$ratingdata->rating;
# echo "not enough data ($rating/$count)\n";
while($oldid=$wgTitle->getPreviousRevisionID($oldid))
{
# echo "trying previous ratings\n";
$ratingdata=getRatingData($oldid);
if($count+$ratingdata->count<$countlimit)
{
$count+=$ratingdata->count;
$rating+=$ratingdata->count*$ratingdata->rating;
# echo "still not enough data ($rating/$count)\n";
}
else
{
$rating+=($countlimit-$count)*$ratingdata->rating;
$count=$countlimit;
# echo "enough data ($rating/$count)\n";
$finalrating=$rating/$count;
$oldid=false;
}
}
}
else
$finalrating=$rating/$count;

$finalrating=($finalrating-1)*1.25;
$ratingarray=array('display'=>(is_numeric($finalrating)?number_format($finalrating, 2):$finalrating)." ($currentcount ratings)",
'count'=>$currentcount,
'rating'=>$finalrating);
return $ratingarray;
}

#Generate html code to insert into page
function getRatingHTML($rating, $oldid)
{
global $wgTitle, $wgScriptPath;
$countlimit=3;
$html='';
for($x=0;$x<=4;$x++)
{
$html.='<a href="'.$wgTitle->getFullURL('oldid='.$oldid.'&rate='.($x+1)).'">'.
'<img src="'.$wgScriptPath.'/extensions/rating/star';
if($rating['rating']>=$x+1)
$html.='4'.($rating['count']<$countlimit?'b':'');
elseif($rating['rating']>$x+0.75)
$html.='3'.($rating['count']<$countlimit?'b':'');
elseif($rating['rating']>$x+0.5)
$html.='2'.($rating['count']<$countlimit?'b':'');
elseif($rating['rating']>$x+0.25)
$html.='1'.($rating['count']<$countlimit?'b':'');
else
$html.='0';
$html.='.png" align=bottom/></a>'."\n";
}
$html.=' '.$rating['display'].'';
$html=($rating['count']<$countlimit?'<b>'.$html.'</b>':$html);
return $html;
}

#Insert rating to top of page
function InsertRating($parserOutput, $text) {
global $wgArticle;
$oldid=getOldID($wgArticle);
if($oldid)
$text='<div id="ratingsection">'.getRatingHTML(getRating($oldid), $oldid).'</div>'.$text;
}

#set up extension info
if(isset($wgScriptPath))
{
$wgExtensionCredits["parserhook"][]=array(
'name' => 'Rating Extension',
'version' => '0.1',
'url' => 'http://wiki.peacocktech.com/wiki/RatingExtension',
'author' => '[http://about.peacocktech.com/trevorp/ Trevor Peacock]',
'description' => 'Adds rating mechanism' );
$wgHooks['OutputPageBeforeHTML'][] = 'InsertRating';
$wgHooks['SkinTemplateSetupPageCss'][] = 'RatingCss';
}

#Add CSS into skin for rating
function RatingCss(&$css) {
global $wgScriptPath;
$css = "/*<![CDATA[*/".
" @import \"$wgScriptPath/?file=rating.css\"; ".
"/*]]>*/";
return true;
}

#Return file if requested
function doFile()
{
switch ($_GET['file'])
{
case "rating.css":
header("Content-type: text/css");
?>
#ratingsection {
float: right;
margin-top: -3.7em;
padding: 3px;
}

#ratingsection b {
// border: 1px solid black;
color: red;
padding: 4px;
}
<?php
die();
}
}

?></pre>