Difference between revisions of "Extension:RecentActivity"

From Organic Design wiki
(ensure images and cats show as links)
(last created articles query)
Line 13: Line 13:
 
if (!defined('MEDIAWIKI')) die('Not an entry point.');
 
if (!defined('MEDIAWIKI')) die('Not an entry point.');
 
   
 
   
define('RECENTACTIVITY_VERSION', '1.0.1, 2009-03-14');
+
define('RECENTACTIVITY_VERSION', '1.0.2, 2009-03-16');
 
   
 
   
 
$egRecentActivityMagic        = "RecentActivity";
 
$egRecentActivityMagic        = "RecentActivity";
Line 69: Line 69:
  
 
case 'new':
 
case 'new':
 +
$dbr  = wfGetDB( DB_SLAVE );
 +
$tbl  = $dbr->tableName( 'revision' );
 +
$user = $user ? 'rev_user_text = '.$dbr->addQuotes( $user ) : '';
 +
$res  = $dbr->select(
 +
$tbl,
 +
'rev_page, MIN(rev_id) as minid',
 +
$user,
 +
__METHOD__,
 +
array( 'GROUP BY' => 'rev_page', 'ORDER BY' => 'minid DESC', 'LIMIT' => $count )
 +
);
 +
while ( $row = $dbr->fetchRow( $res ) ) {
 +
$page = Title::newFromId($row['rev_page'])->getPrefixedText();
 +
$items[] = $format."[[$page]]";
 +
}
 
break;
 
break;
  

Revision as of 09:57, 16 March 2009

<?php /**

* RecentActivity extension - Adds parser functions for listing recently created and edited articles
*
Info.svg These are the MediaWiki extensions we're using and/or developing. Please refer to the information on the mediawiki.org wiki for installation and usage details. Extensions here which have no corresponding mediawiki article are either not ready for use or have been superseded. You can also browse our extension code in our local Subversion repository or our GitHub mirror.

Template:PhpCategory:Extensions created with Template:Extension

* See http://www.mediawiki.org/wiki/Extension:RecentActivity for installation and usage details
*
* @package MediaWiki
* @subpackage Extensions
* @author User:Nad
* @copyright © 2007 User:Nad
* @licence GNU General Public Licence 2.0 or later
*/

if (!defined('MEDIAWIKI')) die('Not an entry point.');

define('RECENTACTIVITY_VERSION', '1.0.2, 2009-03-16');

$egRecentActivityMagic = "RecentActivity"; $wgExtensionFunctions[] = 'efSetupRecentActivity'; $wgHooks['LanguageGetMagic'][] = 'efRecentActivityLanguageGetMagic';

$wgExtensionCredits['parserhook'][] = array( 'name' => 'RecentActivity', 'author' => 'User:Nad', 'description' => 'Adds parser functions for listing recently created and edited articles', 'url' => 'http://www.mediawiki.org/wiki/Extension:RecentActivity', 'version' => RECENTACTIVITY_VERSION );

class RecentActivity {

function __construct() { global $wgParser, $egRecentActivityMagic;

		$wgParser->setFunctionHook($egRecentActivityMagic, array($this, 'expandMagic'), SFH_NO_HASH);

}

function expandMagic(&$parser) {

# Populate $argv with both named and numeric parameters $argv = array(); foreach (func_get_args() as $arg) if (!is_object($arg)) { if (preg_match('/^(.+?)\\s*=\\s*(.+)$/',$arg,$match)) $argv[$match[1]] = $match[2]; else $argv[] = $arg; } $type = isset($argv['type'])  ? strtolower($argv['type']) : ; $user = isset($argv['user'])  ? $argv['user']  : false; $count = isset($argv['count'])  ? $argv['count']  : 5; $format = isset($argv['format']) ? $argv['format'] : '*';

# Build the list $items = array(); switch ($type) {

case 'edits': $dbr = wfGetDB( DB_SLAVE ); $tbl = $dbr->tableName( 'revision' ); $user = $user ? $dbr->addQuotes( $user ) : ; #select rev_page,max(rev_id) as maxid from revision group by rev_page order by maxid desc limit 5; $res = $dbr->select( $tbl, 'distinct rev_page', $user, __METHOD__, array( 'ORDER BY' => 'rev_timestamp DESC', 'LIMIT' => $count ) ); while ( $row = $dbr->fetchRow( $res ) ) { $page = Title::newFromId($row['rev_page'])->getPrefixedText(); $items[] = $format."$page"; } break;

case 'new': $dbr = wfGetDB( DB_SLAVE ); $tbl = $dbr->tableName( 'revision' ); $user = $user ? 'rev_user_text = '.$dbr->addQuotes( $user ) : ; $res = $dbr->select( $tbl, 'rev_page, MIN(rev_id) as minid', $user, __METHOD__, array( 'GROUP BY' => 'rev_page', 'ORDER BY' => 'minid DESC', 'LIMIT' => $count ) ); while ( $row = $dbr->fetchRow( $res ) ) { $page = Title::newFromId($row['rev_page'])->getPrefixedText(); $items[] = $format."$page"; } break;

default: $items[] = 'Bad activity type specified!'; }

return join("\n", $items); } }

/**

* Called from $wgExtensionFunctions array when initialising extensions
*/

function efSetupRecentActivity() { global $egRecentActivity; $egRecentActivity = new RecentActivity(); }

/**

* Register magic words
*/

function efRecentActivityLanguageGetMagic(&$magicWords, $langCode = 0) { global $egRecentActivityMagic; $magicWords[$egRecentActivityMagic] = array($langCode, $egRecentActivityMagic); return true; }