Added 'DELETE FROM linkscc' in case table exists, since it's serialized objects whose...
[mediawiki.git] / includes / SpecialLongpages.php
blob0ebcb7e3c95fec35d719c483334c1803f6a00a49
1 <?
3 function wfSpecialLongpages()
5 global $wgUser, $wgOut, $wgLang, $wgTitle;
6 $fname = "wfSpecialLongpages";
8 # Cache
9 $vsp = $wgLang->getValidSpecialPages();
10 $log = new LogPage( $vsp["Longpages"] );
11 $log->mUpdateRecentChanges = false;
13 global $wgMiserMode;
14 if ( $wgMiserMode ) {
15 $log->showAsDisabledPage();
16 return;
19 list( $limit, $offset ) = wfCheckLimits();
21 $sql = "SELECT cur_title, LENGTH(cur_text) AS len FROM cur " .
22 "WHERE cur_namespace=0 AND cur_is_redirect=0 ORDER BY " .
23 "LENGTH(cur_text) DESC LIMIT {$offset}, {$limit}";
24 $res = wfQuery( $sql, DB_READ, $fname );
26 $sk = $wgUser->getSkin();
28 $top = wfShowingResults( $offset, $limit );
29 $wgOut->addHTML( "<p>{$top}\n" );
31 $sl = wfViewPrevNext( $offset, $limit,
32 $wgLang->specialPage( "Longpages" ) );
33 $wgOut->addHTML( "<br>{$sl}\n" );
35 $s = "<ol start=" . ( $offset + 1 ) . ">";
36 while ( $obj = wfFetchObject( $res ) ) {
37 $nb = wfMsg( "nbytes", $obj->len );
38 $link = $sk->makeKnownLink( $obj->cur_title, "" );
39 $s .= "<li>{$link} ({$nb})</li>\n";
41 wfFreeResult( $res );
42 $s .= "</ol>";
43 $wgOut->addHTML( $s );
44 $wgOut->addHTML( "<p>{$sl}\n" );
46 # Saving cache
47 if ( $offset > 0 OR $limit < 50 ) return ; #Not suitable
48 $log->replaceContent( $s );