Most Popular by Votes Extension

From Zedomax Wiki

Simple Voting Extension v.0.1

Orignally by Mizanur Rahman, the author of MediaWiki Administrator Hacked by Max Lee from http://zedomax.com/wiki

Installation

Copy the following file SpecialPageRating.php into your extensions folder.

To activate the extension, include it from your LocalSettings.php with: require_once("extensions/SpecialPageRating.php");

SpecialPageRating.php

<?php
$wgExtensionCredits['parserhook'][] = array(
'name' => 'Most Popular by votes, need Simple Voting Extension in order to work - 11/16/2007',
'author' => 'Max Lee http://zedomax.com/wiki',
'url' => 'http://zedomax.com/wiki',
'version' => 'v.0.1',
'description' => 'Voting extension for MediaWiki',
);
if( defined( 'MEDIAWIKI' ) )
{
require_once( 'SpecialPage.php' );
$wgExtensionFunctions[] = 'wfSpecialPageRating';
$wgExtensionCredits['specialpage'][] = array( 'name' =>
'Most Popular by User Votes', 'author' => 'Max Lee', 'url' => 'http://Zedomax.com/Wiki' );
function wfSpecialPageRating()
{
global $wgMessageCache;
SpecialPage::addPage( new PageRating() );
$wgMessageCache->addMessage( 'pagerating', 'Most Popular by User Votes' );
$wgMessageCache->addMessage( 'pagerating-header', "'''This page
lists the $1 ranked pages on the wiki.'''" );

$wgMessageCache->addMessage( 'pagerating-limitlinks', 'Show
up to $1 pages' );
$wgMessageCache->addMessage( 'pagerating-showing',
'Found $1 pages;
listing newest first:' );
$wgMessageCache->addMessage( 'pagerating-none', 'No entries
were found.' );
}
class PageRating extends IncludableSpecialPage
{
var $limit = 100;
function PageRating()
{
SpecialPage::SpecialPage( 'PageRating', '', true, false,
'default', true );
}
function execute( $par )
{
global $wgOut;
$this->setLimit( $par );
# Don't show the navigation if we're including the page
if( !$this->mIncluding )
{
$this->setHeaders();
$wgOut->addHTML( '<a href="/Special:Popularpages">Click Here for Most Popular by Views</a>');
$wgOut->addWikiText( wfMsg( 'pagerating-header',
$this->limit ));
$wgOut->addHTML( $this->makeLimitLinks() );
}
$dbr =& wfGetDB( DB_SLAVE );
$res = $dbr->query( "SELECT * from articlerating ORDER BY
totalPoints DESC LIMIT 0,{$this->limit}" );
$count = $dbr->numRows( $res );
if( $count > 0 )
{
# Make tabled list
if( !$this->mIncluding )
$wgOut->addWikiText( wfMsg ( 'pagerating-showing', $count ) );
$wgOut->addHTML( "<br><br><table align=center border=0
cellspacing=0 cellpadding=0 width=70%
style='background:transparent'>\n" );
$wgOut->addHTML( "<tr><Td width=5%><B>#</td>
<Td width=50%><B>Page Title</td><td><B> Current
Rating</td><td><B>Number of Rating</td></tr>");
$i=1;
while( $row = $dbr->fetchObject( $res ) )
$wgOut->addHTML( $this->makeListItem ( $row, $i++ ) );
$wgOut->addHTML( "</table>\n" );
}
else
{
$wgOut->addWikiText( wfMsg( 'pagerating-none' ) );
}
$dbr->freeResult( $res );
}
function setLimit( $par )
{
if( $par )
{
$this->limit = intval( $par );
}
else
{
global $wgRequest;
if( $limit = $wgRequest->getIntOrNull( 'limit' ) )
{
$this->limit = $limit;
}
else
{
$this->limit = 100;
}
}
}
function makeListItem( $row , $i )
{
global $wgUser;
$title = $row->articleName;
$ratingpoint = $row->totalPoints;
$totalrating = $row->totalRatings;
$currentRating = sprintf("%.2f",$ratingpoint/$totalrating);
if( !is_null( $title ) )
{
return( "<tr><td>$i.</td><td><a href=\"/$title\" title=\"$title\">$title</a></td><td align=center>
$currentRating</td><td align=center>$totalrating</td></tr>\n");
}
else
{
return( "<!-- Invalid title "
. htmlspecialchars( $row->page_title ) . " in namespace "
. htmlspecialchars( $row->page_namespace ) . " -->\n" );
}
}
function makeLimitLinks()
{
global $wgUser;
$skin = $wgUser->getSkin();
$title = Title::makeTitle( NS_SPECIAL, 'PageRating' );
$limits = array( 100, 500, 1000, 2000, 3000,4000,5000,6000,7000,8000,9000,10000);
foreach( $limits as $limit )
{
if( $limit != $this->limit )
{
$links[] = $skin->makeKnownLinkObj( $title, $limit,
'limit=' . $limit );
}
Else
{
$links[] = (string)$limit;
}
}
return( wfMsgHtml( 'pagerating-limitlinks',
implode( ' | ', $links ) ) );
}
}
}
else
{
echo( "This is an extension to the MediaWiki package and cannot
be run standalone.\n" );
die( -1 );
}
?>