<?php
+/**
+ * @package MediaWiki
+ * @subpackage SpecialPage
+ */
-function wfSpecialAllpages( $par=NULL )
-{
- global $indexMaxperpage, $wgRequest;
- $indexMaxperpage = 480;
+/**
+ * Entry point : initialise variables and call subfunctions.
+ * @param string $par Becomes "FOO" when called like Special:Allpages/FOO (default NULL)
+ */
+function wfSpecialAllpages( $par=NULL, $specialPage ) {
+ global $wgRequest, $wgOut, $wgContLang;
+
+ # GET values
$from = $wgRequest->getVal( 'from' );
+ $namespace = $wgRequest->getInt( 'namespace' );
+
+ $namespaces = $wgContLang->getNamespaces();
+
+ $indexPage = new SpecialAllpages();
+
+ if( !in_array($namespace, array_keys($namespaces)) )
+ $namespace = 0;
+
+ $wgOut->setPagetitle( $namespace > 0 ?
+ wfMsg( 'allinnamespace', $namespaces[$namespace] ) :
+ wfMsg( 'allarticles' )
+ );
- if( $par ) {
- indexShowChunk( $par );
- } elseif( !is_null( $from ) ) {
- indexShowChunk( $from );
+ if ( isset($par) ) {
+ $indexPage->showChunk( $namespace, $par, $specialPage->including() );
+ } elseif ( isset($from) ) {
+ $indexPage->showChunk( $namespace, $from, $specialPage->including() );
} else {
- indexShowToplevel();
+ $indexPage->showToplevel ( $namespace, $specialPage->including() );
}
}
-function indexShowToplevel()
-{
- global $wgOut, $indexMaxperpage, $wgLang;
- $fname = "indexShowToplevel";
+class SpecialAllpages {
+ var $maxPerPage=960;
+ var $topLevelMax=50;
+ var $name='Allpages';
+ # Determines, which message describes the input field 'nsfrom' (->SpecialPrefixindex.php)
+ var $nsfromMsg='allpagesfrom';
- # Cache
- $vsp = $wgLang->getValidSpecialPages();
- $log = new LogPage( $vsp["Allpages"] );
- $log->mUpdateRecentChanges = false;
+/**
+ * HTML for the top form
+ * @param integer $namespace A namespace constant (default NS_MAIN).
+ * @param string $from Article name we are starting listing at.
+ */
+function namespaceForm ( $namespace = NS_MAIN, $from = '' ) {
+ global $wgContLang, $wgScript;
+ $t = Title::makeTitle( NS_SPECIAL, $this->name );
- global $wgMiserMode;
- if ( $wgMiserMode ) {
- $log->showAsDisabledPage();
- return;
- }
-
- $fromwhere = "FROM cur WHERE cur_namespace=0";
- $order = "ORDER BY cur_title";
- $out = "";
+ $namespaceselect = HTMLnamespaceselector($namespace, null);
- $sql = "SELECT COUNT(*) AS count $fromwhere";
- $res = wfQuery( $sql, DB_READ, $fname );
- $s = wfFetchObject( $res );
- $count = $s->count;
- $sections = ceil( $count / $indexMaxperpage );
+ $frombox = "<input type='text' size='20' name='from' id='nsfrom' value=\""
+ . htmlspecialchars ( $from ) . '"/>';
+ $submitbutton = '<input type="submit" value="' . wfMsgHtml( 'allpagessubmit' ) . '" />';
+
+ $out = "<div class='namespaceoptions'><form method='get' action='{$wgScript}'>";
+ $out .= '<input type="hidden" name="title" value="'.$t->getPrefixedText().'" />';
+ $out .= "
+<table id='nsselect' class='allpages'>
+ <tr>
+ <td align='right'>" . wfMsgHtml($this->nsfromMsg) . "</td>
+ <td align='left'><label for='nsfrom'>$frombox</label></td>
+ </tr>
+ <tr>
+ <td align='right'><label for='namespace'>" . wfMsgHtml('namespace') . "</label></td>
+ <td align='left'>
+ $namespaceselect $submitbutton
+ </td>
+ </tr>
+</table>
+";
+ $out .= '</form></div>';
+ return $out;
+}
- $sql = "SELECT cur_title $fromwhere $order LIMIT 1";
- $res = wfQuery( $sql, DB_READ, $fname );
- $s = wfFetchObject( $res );
- $inpoint = $s->cur_title;
+/**
+ * @param integer $namespace (default NS_MAIN)
+ */
+function showToplevel ( $namespace = NS_MAIN, $including = false ) {
+ global $wgOut, $wgContLang, $wgRequest, $wgUser;
+ $sk = $wgUser->getSkin();
+ $fname = "indexShowToplevel";
- $out .= "<table>\n";
- # There's got to be a cleaner way to do this!
- for( $i = 1; $i < $sections; $i++ ) {
- $from = $i * $indexMaxperpage;
- $sql = "SELECT cur_title $fromwhere $order ".wfLimitResult(2,$from);
- $res = wfQuery( $sql, DB_READ, $fname );
+ # TODO: Either make this *much* faster or cache the title index points
+ # in the querycache table.
- $s = wfFetchObject( $res );
- $outpoint = $s->cur_title;
- $out .= indexShowline( $inpoint, $outpoint );
+ $dbr =& wfGetDB( DB_SLAVE );
+ $page = $dbr->tableName( 'page' );
+ $fromwhere = "FROM $page WHERE page_namespace=$namespace";
+ $order_arr = array ( 'ORDER BY' => 'page_title' );
+ $order_str = 'ORDER BY page_title';
+ $out = "";
+ $where = array( 'page_namespace' => $namespace );
- $s = wfFetchObject( $res );
- $inpoint = $s->cur_title;
+ global $wgMemc, $wgDBname;
+ $key = "$wgDBname:allpages:ns:$namespace";
+ $lines = $wgMemc->get( $key );
+
+ if( !is_array( $lines ) ) {
+ $firstTitle = $dbr->selectField( 'page', 'page_title', $where, $fname, array( 'LIMIT' => 1 ) );
+ $lastTitle = $firstTitle;
+
+ # This array is going to hold the page_titles in order.
+ $lines = array( $firstTitle );
+
+ # If we are going to show n rows, we need n+1 queries to find the relevant titles.
+ $done = false;
+ for( $i = 0; !$done; ++$i ) {
+ // Fetch the last title of this chunk and the first of the next
+ $chunk = is_null( $lastTitle )
+ ? ''
+ : 'page_title >= ' . $dbr->addQuotes( $lastTitle );
+ $res = $dbr->select(
+ 'page', /* FROM */
+ 'page_title', /* WHAT */
+ $where + array( $chunk),
+ $fname,
+ array ('LIMIT' => 2, 'OFFSET' => $this->maxPerPage - 1, 'ORDER BY' => 'page_title') );
- wfFreeResult( $res );
+ if ( $s = $dbr->fetchObject( $res ) ) {
+ array_push( $lines, $s->page_title );
+ } else {
+ // Final chunk, but ended prematurely. Go back and find the end.
+ $endTitle = $dbr->selectField( 'page', 'MAX(page_title)',
+ array(
+ 'page_namespace' => $namespace,
+ $chunk
+ ), $fname );
+ array_push( $lines, $endTitle );
+ $done = true;
+ }
+ if( $s = $dbr->fetchObject( $res ) ) {
+ array_push( $lines, $s->page_title );
+ $lastTitle = $s->page_title;
+ } else {
+ // This was a final chunk and ended exactly at the limit.
+ // Rare but convenient!
+ $done = true;
+ }
+ $dbr->freeResult( $res );
+ }
+ $wgMemc->add( $key, $lines, 3600 );
+ }
+
+ // If there are only two or less sections, don't even display them.
+ // Instead, display the first section directly.
+ if( count( $lines ) <= 2 ) {
+ $this->showChunk( $namespace, '', $including );
+ return;
}
- $from = $i * $indexMaxperpage;
- $sql = "SELECT cur_title $fromwhere $order ".wfLimitResult(1,$count-1);
- $res = wfQuery( $sql, DB_READ, $fname );
- $s = wfFetchObject( $res );
- $outpoint = $s->cur_title;
- $out .= indexShowline( $inpoint, $outpoint );
- $out .= "</table>\n";
-
- # Saving cache
- $log->replaceContent( $out );
+ # At this point, $lines should contain an even number of elements.
+ $out .= "<table style='background: inherit;'>";
+ while ( count ( $lines ) > 0 ) {
+ $inpoint = array_shift ( $lines );
+ $outpoint = array_shift ( $lines );
+ $out .= $this->showline ( $inpoint, $outpoint, $namespace, false );
+ }
+ $out .= '</table>';
+ $nsForm = $this->namespaceForm ( $namespace, '', false );
+
+ # Is there more?
+ if ( $including ) {
+ $out2 = '';
+ } else {
+ $morelinks = '';
+ if ( $morelinks != '' ) {
+ $out2 = '<table style="background: inherit;" width="100%" cellpadding="0" cellspacing="0" border="0">';
+ $out2 .= '<tr valign="top"><td align="left">' . $nsForm;
+ $out2 .= '</td><td align="right" style="font-size: smaller; margin-bottom: 1em;">';
+ $out2 .= $morelinks . '</td></tr></table><hr />';
+ } else {
+ $out2 = $nsForm . '<hr />';
+ }
+ }
- $wgOut->addHtml( $out );
+ $wgOut->addHtml( $out2 . $out );
}
-function indexShowline( $inpoint, $outpoint )
-{
+/**
+ * @todo Document
+ * @param string $from
+ * @param integer $namespace (Default NS_MAIN)
+ */
+function showline( $inpoint, $outpoint, $namespace = NS_MAIN ) {
global $wgOut, $wgLang, $wgUser;
$sk = $wgUser->getSkin();
+ $dbr =& wfGetDB( DB_SLAVE );
- # Fixme: this is ugly
- $out = wfMsg(
- "alphaindexline",
- $sk->makeKnownLink( $wgLang->specialPage( "Allpages" ),
- str_replace( "_", " ", $inpoint ),
- "from=" . wfStrencode( $inpoint ) ) . "</td><td>",
- "</td><td align=\"left\">" .
- str_replace( "_", " ", $outpoint )
- );
- return "<tr><td align=\"right\">{$out}</td></tr>\n";
+ $inpointf = htmlspecialchars( str_replace( '_', ' ', $inpoint ) );
+ $outpointf = htmlspecialchars( str_replace( '_', ' ', $outpoint ) );
+ $queryparams = ($namespace ? "namespace=$namespace" : '');
+ $special = Title::makeTitle( NS_SPECIAL, $this->name . '/' . $inpoint );
+ $link = $special->escapeLocalUrl( $queryparams );
+
+ $out = wfMsgHtml(
+ 'alphaindexline',
+ "<a href=\"$link\">$inpointf</a></td><td><a href=\"$link\">",
+ "</a></td><td align=\"left\"><a href=\"$link\">$outpointf</a>"
+ );
+ return '<tr><td align="right">'.$out.'</td></tr>';
}
-function indexShowChunk( $from )
-{
- global $wgOut, $wgUser, $indexMaxperpage, $wgLang;
+/**
+ * @param integer $namespace (Default NS_MAIN)
+ * @param string $from list all pages from this name (default FALSE)
+ */
+function showChunk( $namespace = NS_MAIN, $from, $including = false ) {
+ global $wgOut, $wgUser, $wgContLang;
+
+ $fname = 'indexShowChunk';
+
$sk = $wgUser->getSkin();
- $maxPlusOne = $indexMaxperpage + 1;
- $out = "";
- $sql = "SELECT cur_title FROM cur WHERE cur_namespace=0 AND cur_title >= '"
- . wfStrencode( $from ) . "' ORDER BY cur_title LIMIT " . $maxPlusOne;
- $res = wfQuery( $sql, DB_READ, "indexShowChunk" );
+ $fromTitle = null;
+ if ($from!="") {
+ $fromTitle = Title::newFromURL( $from );
+ if (!$fromTitle) {
+ return;
+ }
+ $fromNS = $fromTitle->getNamespace();
+ if ($namespace == NS_MAIN)
+ $namespace = $fromNS;
+ }
+ $fromKey = is_null( $fromTitle ) ? '' : $fromTitle->getDBkey();
+
+ $dbr =& wfGetDB( DB_SLAVE );
+ $res = $dbr->select( 'page',
+ array( 'page_namespace', 'page_title', 'page_is_redirect' ),
+ array(
+ 'page_namespace' => $namespace,
+ 'page_title >= ' . $dbr->addQuotes( $fromKey )
+ ),
+ $fname,
+ array(
+ 'ORDER BY' => 'page_title',
+ 'LIMIT' => $this->maxPerPage + 1,
+ 'USE INDEX' => 'name_title',
+ )
+ );
### FIXME: side link to previous
$n = 0;
- $out = "<table border=\"0\" width=\"100%\">\n";
- while( ($n < $indexMaxperpage) && ($s = wfFetchObject( $res )) ) {
- $t = Title::makeTitle( 0, $s->cur_title );
+ $out = '<table style="background: inherit;" border="0" width="100%">';
+
+ $namespaces = $wgContLang->getFormattedNamespaces();
+ while( ($n < $this->maxPerPage) && ($s = $dbr->fetchObject( $res )) ) {
+ $t = Title::makeTitle( $s->page_namespace, $s->page_title );
if( $t ) {
- $link = $sk->makeKnownLinkObj( $t );
+ $link = ($s->page_is_redirect ? '<div class="allpagesredirect">' : '' ) .
+ $sk->makeKnownLinkObj( $t, htmlspecialchars( $t->getText() ), false, false ) .
+ ($s->page_is_redirect ? '</div>' : '' );
} else {
- $link = "[[" . htmlspecialchars( $s->cur_title ) . "]]";
+ $link = '[[' . htmlspecialchars( $s->page_title ) . ']]';
}
if( $n % 3 == 0 ) {
- $out .= "<tr>\n";
+ $out .= '<tr>';
}
$out .= "<td>$link</td>";
$n++;
if( $n % 3 == 0 ) {
- $out .= "</tr>\n";
+ $out .= '</tr>';
}
}
if( ($n % 3) != 0 ) {
- $out .= "</tr>\n";
+ $out .= '</tr>';
}
- $out .= "</table>";
-
- $out2 = "<div style='text-align: right; font-size: smaller; margin-bottom: 1em;'>" .
- $sk->makeKnownLink( $wgLang->specialPage( "Allpages" ),
- wfMsg ( 'allpages' ) );
- if ( ($n == $indexMaxperpage) && ($s = wfFetchObject( $res )) ) {
- $out2 .= " | " . $sk->makeKnownLink(
- $wgLang->specialPage( "Allpages" ),
- wfMsg ( 'nextpage', $s->cur_title ),
- "from=" . wfStrencode( $s->cur_title ) );
+ $out .= '</table>';
+
+
+ if ( $including ) {
+ $out2 = '';
+ } else {
+ $nsForm = $this->namespaceForm ( $namespace, $from );
+ $out2 = '<table style="background: inherit;" width="100%" cellpadding="0" cellspacing="0" border="0">';
+ $out2 .= '<tr valign="top"><td align="left">' . $nsForm;
+ $out2 .= '</td><td align="right" style="font-size: smaller; margin-bottom: 1em;">' .
+ $sk->makeKnownLink( $wgContLang->specialPage( "Allpages" ),
+ wfMsgHtml ( 'allpages' ) );
+ if ( ($n == $this->maxPerPage) && ($s = $dbr->fetchObject( $res )) ) {
+ $namespaceparam = $namespace ? "&namespace=$namespace" : "";
+ $out2 .= " | " . $sk->makeKnownLink(
+ $wgContLang->specialPage( "Allpages" ),
+ wfMsgHtml ( 'nextpage', $s->page_title ),
+ "from=" . wfUrlEncode ( $s->page_title ) . $namespaceparam );
+ }
+ $out2 .= "</td></tr></table><hr />";
}
- $out2 .= "</div>";
$wgOut->addHtml( $out2 . $out );
}
+}
?>