getOption( "rclimit" );
if ( ! $limit ) { $limit = 50; }
}
if ( ! $offset ) { $offset = 0; }
# $sql = "SELECT cur_title,cur_user,cur_user_text,cur_comment," .
# "cur_timestamp FROM cur " .
# "WHERE cur_is_new=1 AND cur_namespace=0 AND cur_is_redirect=0 " .
# " ORDER BY cur_timestamp DESC LIMIT {$offset}, {$limit}";
$sql = "SELECT rc_title AS cur_title,rc_user AS cur_user,rc_user_text AS cur_user_text,cur_comment," .
"rc_timestamp AS cur_timestamp FROM recentchanges,cur " .
"WHERE rc_cur_id=cur_id AND rc_new=1 AND rc_namespace=0 AND cur_text NOT LIKE '#REDIRECT%' " .
" ORDER BY rc_timestamp DESC LIMIT {$offset}, {$limit}";
$res = wfQuery( $sql, $fname );
$top = wfShowingResults( $offset, $limit );
$wgOut->addHTML( "{$top}\n" );
$sl = wfViewPrevNext( $offset, $limit,
$wgLang->specialPage( "Newpages" ) );
$wgOut->addHTML( "
{$sl}\n" );
$sk = $wgUser->getSkin();
$s = "
";
while ( $obj = wfFetchObject( $res ) ) {
$u = $obj->cur_user;
$ut = $obj->cur_user_text;
$c = wfEscapeHTML( $obj->cur_comment );
if ( 0 == $u ) { $ul = $ut; }
else { $ul = $sk->makeLink( $wgLang->getNsText(2).":{$ut}", $ut ); }
$d = $wgLang->timeanddate( $obj->cur_timestamp, true );
$link = $sk->makeKnownLink( $obj->cur_title, "" );
$s .= "- {$d} {$link} . . {$ul}";
if ( "" != $c && "*" != $c ) { $s .= " ({$c})"; }
$s .= "
\n";
}
wfFreeResult( $res );
$s .= "
";
$wgOut->addHTML( $s );
$wgOut->addHTML( "{$sl}\n" );
}
?>