3 function wfSpecialNewpages()
5 global $wgUser, $wgOut, $wgLang, $wgTitle;
6 global $limit, $offset; # From query string
7 $fname = "wfSpecialNewpages";
10 $limit = $wgUser->getOption( "rclimit" );
11 if ( ! $limit ) { $limit = 50; }
13 if ( ! $offset ) { $offset = 0; }
15 # $sql = "SELECT cur_title,cur_user,cur_user_text,cur_comment," .
16 # "cur_timestamp FROM cur " .
17 # "WHERE cur_is_new=1 AND cur_namespace=0 AND cur_is_redirect=0 " .
18 # " ORDER BY cur_timestamp DESC LIMIT {$offset}, {$limit}";
19 $sql = "SELECT rc_title AS cur_title,rc_user AS cur_user,rc_user_text AS cur_user_text,cur_comment," .
20 "rc_timestamp AS cur_timestamp FROM recentchanges,cur " .
21 "WHERE rc_cur_id=cur_id AND rc_new=1 AND rc_namespace=0 AND cur_text NOT LIKE '#REDIRECT%' " .
22 " ORDER BY rc_timestamp DESC LIMIT {$offset}, {$limit}";
23 $res = wfQuery( $sql, $fname );
25 $top = wfShowingResults( $offset, $limit );
26 $wgOut->addHTML( "<p>{$top}\n" );
28 $sl = wfViewPrevNext( $offset, $limit,
29 $wgLang->specialPage( "Newpages" ) );
30 $wgOut->addHTML( "<br>{$sl}\n" );
32 $sk = $wgUser->getSkin();
33 $s = "<ol start=" . ( $offset +
1 ) . ">";
34 while ( $obj = wfFetchObject( $res ) ) {
36 $ut = $obj->cur_user_text
;
37 $c = wfEscapeHTML( $obj->cur_comment
);
38 if ( 0 == $u ) { $ul = $ut; }
39 else { $ul = $sk->makeLink( $wgLang->getNsText(2).":{$ut}", $ut ); }
41 $d = $wgLang->timeanddate( $obj->cur_timestamp
, true );
42 $link = $sk->makeKnownLink( $obj->cur_title
, "" );
43 $s .= "<li>{$d} {$link} . . {$ul}";
45 if ( "" != $c && "*" != $c ) { $s .= " <em>({$c})</em>"; }
50 $wgOut->addHTML( $s );
51 $wgOut->addHTML( "<p>{$sl}\n" );