MediawikiExtensions/Top Pages

A new extension to display the most popular wiki pages, ordered by number of hits.

example

<toppages>10</toppages>

adipex online pill adipex online valium order valium pill pill

xanax cheap xanax order    buy phentermine order  phentermine pill    buy adipex cheap  adipex cheap    order 
phentermine buy phentermine order    cheap 
adipex cheap adipex pill    pill adipex cheap  adipex buy    online 
  online xanax pill  xanax online 
hydrocodone online hydrocodone buy    online tramadol cheap    pill  tramadol pill 

result

<toppages>10</toppages>

extension source

<?php
# Top Pages Mediawiki extension
# display a list of the most popular pages on the wiki
# <toppages>23</toppages>
# where "23" would be the number of results to display
# by mutante 31.10.2005

$wgExtensionFunctions[] = "wfTopPagesExtension";

function wfTopPagesExtension() {
global $wgParser;
$wgParser->setHook( "toppages", "renderTopPages" );
}

function renderTopPages( $input ) {

$input = mysql_escape_string($input);

# check if input is integer else set to 5
if (is_int($input)){
$limit = $input;
} else {
$limit = 5;
}

$hd = mysql_connect("localhost", "wikiuser", "password") or die ("Unable to connect");
mysql_select_db ("wikidb", $hd) or die ("Unable to select database");

$res= mysql_query("select cur_title,cur_counter from cur order by cur_counter DESC limit $input", $hd) or die ("Unable to run query");

$output="<table border=\"1\"><tr><th colspan=\"2\" align=\"center\">Top $input wiki pages</th></tr><tr><th align=\"right\">page</th><th align=\"right\"># of hits</th></tr>";

while ($row = mysql_fetch_assoc($res))
{
$page = $row["cur_title"];
$hits = $row["cur_counter"];
$output.="<tr><td align=\"right\"><a href=\"http://s23.org/wiki/$page\">$page</a></td><td align=\"right\">$hits</td></tr>";
}
$output.="</table>";

return $output;
}