function wfSpecialAllpages( $par=NULL )
{
- global $from, $indexMaxperpage;
+ global $indexMaxperpage, $toplevelMaxperpage, $wgRequest, $wgOut, $wgLang;
$indexMaxperpage = 480;
+ $toplevelMaxperpage = 50;
+ $from = $wgRequest->getVal( 'from' );
+ $namespace = $wgRequest->getInt( 'namespace' );
+ $names = $wgLang->getNamespaces();
+ if( !isset( $names[$namespace] ) ) {
+ $namespace = 0;
+ }
+ $wgOut->setPagetitle ( $namespace > 0 ? wfMsg ( 'allpagesnamespace', $names[$namespace] )
+ : wfMsg ( 'allarticles' ) );
- if( $par ) {
- indexShowChunk( $par );
- } elseif( isset( $from ) ) {
- indexShowChunk( $from );
+ if ( $par ) {
+ indexShowChunk( $par, $namespace );
+ } elseif ( $from ) {
+ indexShowChunk( $from, $namespace );
} else {
- indexShowToplevel();
+ indexShowToplevel ( $namespace );
}
}
-function indexShowToplevel()
+function namespaceForm ( $namespace = 0, $from = "" )
{
- global $wgOut, $indexMaxperpage, $wgLang;
- $fname = "indexShowToplevel";
+ global $wgLang, $wgScript;
- # Cache
- $vsp = $wgLang->getValidSpecialPages();
- $log = new LogPage( $vsp["Allpages"] );
- $log->mUpdateRecentChanges = false;
+ $t = Title::makeTitle( NS_SPECIAL, "Allpages" );
- global $wgMiserMode;
- if ( $wgMiserMode ) {
- $log->showAsDisabledPage();
- return;
+ $namespaceselect = '<select name="namespace">';
+ $arr = $wgLang->getNamespaces();
+ for ( $i = 0; $i < 14; $i++ ) {
+ $namespacename = str_replace ( "_", " ", $arr[$i] );
+ $n = ($i == 0) ? wfMsg ( 'articlenamespace' ) : $namespacename;
+ $sel = ($i == $namespace) ? ' selected="selected"' : '';
+ $namespaceselect .= "<option value='{$i}'{$sel}>{$n}</option>";
}
+ $namespaceselect .= '</select>';
+ $frombox = '<input type="text" size="20" name="from" value="'
+ . htmlspecialchars ( $from ) . '"/>';
+ $submitbutton = '<input type="submit" value="' . wfMsg( 'allpagessubmit' ) . '" />';
-# $fromwhere = "FROM cur WHERE cur_namespace=0 AND cur_is_redirect=0";
- $fromwhere = "FROM cur WHERE cur_namespace=0";
- $order = "ORDER BY cur_title";
+ $out = "<div class='namespaceselector'><form method='get' action='{$wgScript}'>";
+ $out .= '<input type="hidden" name="title" value="'.$t->getPrefixedText().'" />';
+ $out .= wfMsg ( 'allpagesformtext', $frombox, $namespaceselect, $submitbutton );
+ $out .= '</form></div>';
+ return $out;
+}
+
+function indexShowToplevel ( $namespace = 0 )
+{
+ global $wgOut, $indexMaxperpage, $toplevelMaxperpage, $wgLang, $wgRequest, $wgUser;
+ $sk = $wgUser->getSkin();
+ $fname = "indexShowToplevel";
+ $namespace = intval ($namespace);
+
+ # TODO: Either make this *much* faster or cache the title index points
+ # in the querycache table.
+
+ $dbr =& wfGetDB( DB_SLAVE );
+ $cur = $dbr->tableName( 'cur' );
+ $fromwhere = "FROM $cur WHERE cur_namespace=$namespace";
+ $order_arr = array ( 'ORDER BY' => 'cur_title' );
+ $order_str = 'ORDER BY cur_title';
$out = "";
-
- $sql = "SELECT COUNT(*) AS count $fromwhere";
- $res = wfQuery( $sql, DB_READ, $fname );
- $s = wfFetchObject( $res );
- $count = $s->count;
+ $where = array( 'cur_namespace' => $namespace );
+
+ $count = $dbr->selectField( 'cur', 'COUNT(*)', $where, $fname );
$sections = ceil( $count / $indexMaxperpage );
-
- $sql = "SELECT cur_title $fromwhere $order LIMIT 1";
- $res = wfQuery( $sql, DB_READ, $fname );
- $s = wfFetchObject( $res );
- $inpoint = $s->cur_title;
-
- $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 LIMIT $from,2";
- $res = wfQuery( $sql, DB_READ, $fname );
-
- $s = wfFetchObject( $res );
- $outpoint = $s->cur_title;
- $out .= indexShowline( $inpoint, $outpoint );
-
- $s = wfFetchObject( $res );
- $inpoint = $s->cur_title;
-
- wfFreeResult( $res );
+
+ if ( $sections < 3 ) {
+ # If there are only two or less sections, don't even display them.
+ # Instead, display the first section directly.
+ indexShowChunk( '', $namespace );
+ return;
}
-
- $from = $i * $indexMaxperpage;
- $sql = "SELECT cur_title $fromwhere $order LIMIT " . ($count-1) . ",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 );
-
- $wgOut->addHtml( $out );
+
+ # We want to display $toplevelMaxperpage lines starting at $offset.
+ # NOTICE: $offset starts at 0
+ $offset = intval ( $wgRequest->getVal( 'offset' ) );
+ if ( $offset < 0 ) { $offset = 0; }
+ if ( $offset >= $sections ) { $offset = $sections - 1; }
+
+ # Where to stop? Notice that this can take the value of $sections, but $offset can't, because if
+ # we're displaying only the very last section, we still need two DB queries to find the titles
+ $stopat = ( $offset + $toplevelMaxperpage < $sections )
+ ? $offset + $toplevelMaxperpage : $sections ;
+
+ # This array is going to hold the cur_titles in order.
+ $lines = array();
+
+ # If we are going to show n rows, we need n+1 queries to find the relevant titles.
+ for ( $i = $offset; $i <= $stopat; $i++ ) {
+ if ( $i == $sections ) # if we're displaying the last section, we need to
+ $from = $count-1; # find the last cur_title in the DB
+ else if ( $i > $offset )
+ $from = $i * $indexMaxperpage - 1;
+ else
+ $from = $i * $indexMaxperpage;
+ $limit = ( $i == $offset || $i == $stopat ) ? 1 : 2;
+ $sql = "SELECT cur_title $fromwhere $order_str " . $dbr->limitResult ( $limit, $from );
+ $res = $dbr->query( $sql, $fname );
+ $s = $dbr->fetchObject( $res );
+ array_push ( $lines, $s->cur_title );
+ if ( $s = $dbr->fetchObject( $res ) ) {
+ array_push ( $lines, $s->cur_title );
+ }
+ $dbr->freeResult( $res );
+ }
+
+ # 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 .= indexShowline ( $inpoint, $outpoint, $namespace );
+ }
+ $out .= "</table>";
+
+ $nsForm = namespaceForm ( $namespace );
+
+ # Is there more?
+ $morelinks = "";
+ if ( $offset > 0 ) {
+ $morelinks = $sk->makeKnownLink (
+ $wgLang->specialPage ( "Allpages" ),
+ wfMsg ( 'allpagesprev' ),
+ ( $offset > $toplevelMaxperpage ) ? 'offset='.($offset-$toplevelMaxperpage) : ''
+ );
+ }
+ if ( $stopat < $sections-1 ) {
+ if ( $morelinks != "" ) { $morelinks .= " | "; }
+ $morelinks .= $sk->makeKnownLink (
+ $wgLang->specialPage ( "Allpages" ),
+ wfMsg ( 'allpagesnext' ),
+ 'offset=' . ($offset + $toplevelMaxperpage)
+ );
+ }
+
+ 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( $out2 . $out );
}
-function indexShowline( $inpoint, $outpoint )
+function indexShowline( $inpoint, $outpoint, $namespace = 0 )
{
global $wgOut, $wgLang, $wgUser;
$sk = $wgUser->getSkin();
+ $dbr =& wfGetDB( DB_SLAVE );
- # Fixme: this is ugly
+ $inpointf = htmlspecialchars( str_replace( "_", " ", $inpoint ) );
+ $outpointf = htmlspecialchars( str_replace( "_", " ", $outpoint ) );
+ $queryparams = $namespace ? ('namespace='.intval($namespace)) : '';
+ $special = Title::makeTitle( NS_SPECIAL, 'Allpages/' . $inpoint );
+ $link = $special->escapeLocalUrl( $queryparams );
+
$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";
+ '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 )
+function indexShowChunk( $from, $namespace = 0 )
{
- global $wgOut, $wgUser, $indexMaxperpage;
+ global $wgOut, $wgUser, $indexMaxperpage, $wgLang;
$sk = $wgUser->getSkin();
-
+ $maxPlusOne = $indexMaxperpage + 1;
+ $namespacee = intval($namespace);
+
$out = "";
- $sql = "SELECT cur_title
-FROM cur
-WHERE cur_namespace=0 AND cur_title >= '" . wfStrencode( $from ) . "'
-ORDER BY cur_title
-LIMIT {$indexMaxperpage}";
- $res = wfQuery( $sql, DB_READ, "indexShowChunk" );
-
-# FIXME: Dynamic column widths, backlink to main list,
-# side links to next and previous
+ $dbr =& wfGetDB( DB_SLAVE );
+ $cur = $dbr->tableName( 'cur' );
+ $sql = "SELECT cur_title FROM $cur WHERE cur_namespace=$namespacee AND cur_title >= '"
+ . $dbr->strencode( $from ) . "' ORDER BY cur_title LIMIT " . $maxPlusOne;
+ $res = $dbr->query( $sql, "indexShowChunk" );
+
+ ### FIXME: side link to previous
+
$n = 0;
- $out = "<table border=\"0\">\n<tr>";
- while( $s = wfFetchObject( $res ) ) {
- $t = Title::makeTitle( 0, $s->cur_title );
+ $out = '<table style="background: inherit;" border="0" width="100%">';
+ while( ($n < $indexMaxperpage) && ($s = $dbr->fetchObject( $res )) ) {
+ $t = Title::makeTitle( $namespacee, $s->cur_title );
if( $t ) {
- $link = $sk->makeKnownLinkObj( $t );
+ $link = $sk->makeKnownLinkObj( $t, $t->getText() );
} else {
- $link = "[[" . htmlspecialchars( $s->cur_title ) . "]]";
+ $link = '[[' . htmlspecialchars( $s->cur_title ) . ']]';
+ }
+ if( $n % 3 == 0 ) {
+ $out .= '<tr>';
}
- $out .= "<td width=\"33%\">$link</td>";
- $n = ++$n % 3;
- if( $n == 0 ) {
- $out .= "</tr>\n<tr>";
+ $out .= "<td>$link</td>";
+ $n++;
+ if( $n % 3 == 0 ) {
+ $out .= '</tr>';
}
}
- if( $n != 0 ) {
- $out .= "</tr>\n";
+ if( ($n % 3) != 0 ) {
+ $out .= '</tr>';
}
- $out .= "</table>";
-#return $out;
- $wgOut->addHtml( $out );
+ $out .= '</table>';
+
+ $nsForm = 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( $wgLang->specialPage( "Allpages" ),
+ wfMsg ( 'allpages' ) );
+ if ( ($n == $indexMaxperpage) && ($s = $dbr->fetchObject( $res )) ) {
+ $out2 .= " | " . $sk->makeKnownLink(
+ $wgLang->specialPage( "Allpages" ),
+ wfMsg ( 'nextpage', $s->cur_title ),
+ "from=" . wfUrlEncode ( $s->cur_title ) );
+ }
+ $out2 .= "</td></tr></table><hr />";
+
+ $wgOut->addHtml( $out2 . $out );
}
?>