User:Meffiem~metawiki/Newpages

A proposal to move this page to MediaWiki.org was rejected.

Description

Newpages is a Mediawiki extension to display a list of links to newly created pages in the main namespace. This could be useful on the Main Page of a small project, where the number of new pages is not overwhelming, but enough that you want the list to be automatically updated.

The wiki code syntax is,

   <newpages>
      limit={a positive number}
   </newpages>

where limit is the maximum number of links to new pages generated. The default value is 5 if the limit parameter is not present. If there are more newpages on the site than the limit then a link to the Newpages special page is also generated, labelled as more....

The creation date is appended to each new page link.

Example

The following wiki code will generate a list of the three most recent new pages in the main namespace.

   <newpages> limit=3 </newpages>

The output will be something like the following (but with links to the pages);

Yet another page, 18 January 2006
Some other page, 17 January 2006
About something, 15 Janurary 2006
more ...

Installation

This extension was developed and tested on MediaWiki v1.5.3.

Copy the source code to a file called NewPages.php into the mediawiki extensions directory.
Add the following line to your LocalSettings.php file:

require_once("extensions/NewPages.php");

Code

Copy this code to extensions/NewPages.php.

<?php
#
# This Mediawiki extension creates a bullet list of the most
# recent new pages.  This can be useful for a small project's
# main page to give visitors a quick view of the new pages 
# created since the last visit.
#
# The wiki syntax is,
# 
#  <newpages>
#     limit=10
#  </newpages>
#
# where limit is the maximum number of new pages to show.
# 
# To activate the extension, include it from your LocalSettings.php
# with: require_once("extensions/NewPages.php"); 
#
# Author: Michael Meffie
# Date: Jan 17 2006
# Credits: This extension was derived from SpecialNewpages.php.
# License: GPL v2.0
#

$wgExtensionFunctions[] = "wfNewPagesExtension";

$wgExtensionCredits['parserhook'][] = array(
    'name' => 'NewPages',
    'author' => 'Michael Meffie',
    'url' => 'http://meta.wikimedia.org/wiki/User:Meffiem',
);

function wfNewPagesExtension() {
    global $wgParser;
    $wgParser->setHook( "newpages", "renderNewPages" );
}

function renderNewPages( $input ) {
    global $wgOut;
    $output = "<br />No new pages since last database cleaning<br />";
    $limit = 5;    
    getBoxOption($limit,$input,'limit',true);    

    $dbr =& wfGetDB( DB_SLAVE );
    extract( $dbr->tableNames( 'recentchanges', 'page' ) );

    $query_limit = $limit + 1;  # to determine if we should display (more...)
    $sql = "SELECT  rc_namespace AS namespace,
                    rc_title AS title,
                    rc_cur_id AS value,
                    rc_user AS user,
                    rc_user_text AS user_text,
                    rc_comment as comment,
                    rc_timestamp AS timestamp,
                    rc_id AS rcid,
                    page_len as length,
                    page_latest as rev_id
            FROM $recentchanges,$page
            WHERE rc_cur_id=page_id AND rc_new=1
              AND rc_namespace=".NS_MAIN." AND page_is_redirect=0
              ORDER BY value DESC
              LIMIT $query_limit";

    $result = $dbr->query( $sql );
    $num = $dbr->numRows( $result );
    if ($num > 0) {
        $output = "<ul>\n";
        for ($i=0; $i<$num && $i<$limit; $i++) {
           $row = $dbr->fetchObject( $result );
           $s = formatRow( $row );
           $output .= "<li>$s</li>\n";
        }
        if ($num > $limit) {
           $more = $wgOut->parse("[[Special:Newpages|more...]]", false);  
           $output .= "<li>$more</li>\n";
        }
        $output .= "</ul>\n";
    }    

    $dbr->freeResult( $result );
    return $output;
}

function formatRow( $row ) {
    global $wgLang, $wgUser;
    
    $skin = $wgUser->getSkin();
    $link = $skin->makeKnownLink( $row->title, '' );
    $d = $wgLang->date( $row->timestamp, true );

    $s = "$link, $d";
    return $s;
}

function getBoxOption(&$value,&$input,$name,$isNumber=false) {
    if(preg_match("/^\s*$name\s*=\s*(.*)/mi",$input,$matches)) {
         if($isNumber) {
            $value=intval($matches[1]);
        } else {
            $value=htmlspecialchars($matches[1]);
        }
    }
}

?>

QINU problem

In case of inproper output, similar to:

UNIQ67b7fa85308204de-newpages-00000001-QINU

please use below version of NewPages.php:

<?php
#
# This Mediawiki extension creates a bullet list of the most
# recent new pages.  This can be useful for a small project's
# main page to give visitors a quick view of the new pages 
# created since the last visit.
#
# The wiki syntax is,
# 
#  <newpages>
#     limit=10
#  </newpages>
#
# where limit is the maximum number of new pages to show.
# 
# To activate the extension, include it from your LocalSettings.php
# with: require_once("extensions/NewPages.php"); 
#
# Author: Michael Meffie
# Date: Jan 17 2006
# Credits: This extension was derived from SpecialNewpages.php.
# License: GPL v2.0
#

$wgExtensionFunctions[] = "wfNewPagesExtension";

$wgExtensionCredits['parserhook'][] = array(
    'name' => 'NewPages',
    'author' => 'Michael Meffie',
    'url' => 'http://meta.wikimedia.org/wiki/User:Meffiem',
);

function wfNewPagesExtension() {
    global $wgParser;
    $wgParser->setHook( "newpages", "renderNewPages" );
}

function renderNewPages( $input, $args=null, &$parser) {
    $localParser = new Parser();

    $output = "<br />No new pages since last database cleaning<br />";
    $limit = 5;    
    getBoxOption($limit,$input,'limit',true);    

    $dbr =& wfGetDB( DB_SLAVE );
    extract( $dbr->tableNames( 'recentchanges', 'page' ) );

    $query_limit = $limit + 1;  # to determine if we should display (more...)
    $sql = "SELECT  rc_namespace AS namespace,
                    rc_title AS title,
                    rc_cur_id AS value,
                    rc_user AS user,
                    rc_user_text AS user_text,
                    rc_comment as comment,
                    rc_timestamp AS timestamp,
                    rc_id AS rcid,
                    page_len as length,
                    page_latest as rev_id
            FROM $recentchanges,$page
            WHERE rc_cur_id=page_id AND rc_new=1
              AND rc_namespace=".NS_MAIN." AND page_is_redirect=0
              ORDER BY value DESC
              LIMIT $query_limit";

    $result = $dbr->query( $sql );
    $num = $dbr->numRows( $result );
    if ($num > 0) {
        $output = "<ul>\n";
        for ($i=0; $i<$num && $i<$limit; $i++) {
           $row = $dbr->fetchObject( $result );           
	   $s = formatRow( $row );
           $output .= "<li>$s</li>\n";
        }
        if ($num > $limit) {
           $more = $localParser->parse("[[Special:Newpages|more...]]", $parser->mTitle, $parser->mOptions);  
	         $output .= "<li>".$more->getText()."</li>\n";
        }
        $output .= "</ul>\n";
    }    

    $dbr->freeResult( $result );
     
return $output;
}

function formatRow( $row ) {
    global $wgLang, $wgUser;
    
    $skin = $wgUser->getSkin();
    $link = $skin->makeKnownLink( $row->title, '' );
    $d = $wgLang->date( $row->timestamp, true );

    $s = "$link, $d";
    return $s;
}

function getBoxOption(&$value,&$input,$name,$isNumber=false) {
    if(preg_match("/^\s*$name\s*=\s*(.*)/mi",$input,$matches)) {
         if($isNumber) {
            $value=intval($matches[1]);
        } else {
            $value=htmlspecialchars($matches[1]);
        }
    }
}

?>

Credits

The newpage query was adapted from SpecialNewpages.php and QueryPage.php. The getOption function was adapted from the inputbox extension.