class DisambiguationsPage extends PageQueryPage {
function getName() {
- return 'disambiguations';
+ return 'Disambiguations';
}
-
+
function isExpensive( ) { return true; }
function isSyndicated() { return false; }
function getPageHeader( ) {
global $wgUser;
$sk = $wgUser->getSkin();
-
+
#FIXME : probably need to add a backlink to the maintenance page.
- return '<p>'.wfMsg("disambiguationstext", $sk->makeKnownLink(wfMsgForContent('disambiguationspage')) )."</p><br>\n";
+ return '<p>'.wfMsg('disambiguationstext', $sk->makeKnownLink(wfMsgForContent('disambiguationspage')) )."</p><br />\n";
}
function getSQL() {
$dbr =& wfGetDB( DB_SLAVE );
- extract( $dbr->tableNames( 'cur', 'links' ) );
-
- $dp = Title::newFromText(wfMsgForContent("disambiguationspage"));
- $dpid = $dp->getArticleID();
-
- $sql = "SELECT ca.cur_namespace AS ns_art, ca.cur_title AS title_art,"
- . " cb.cur_namespace AS ns_dis, cb.cur_title AS title_dis"
- . " FROM links as la, links as lb, cur as ca, cur as cb"
- . " WHERE la.l_to = '{$dpid}'"
- . " AND la.l_from = lb.l_to"
- . " AND ca.cur_id = lb.l_from"
- . " AND cb.cur_id = lb.l_to";
+ extract( $dbr->tableNames( 'page', 'pagelinks', 'templatelinks' ) );
+
+ $dp = Title::newFromText(wfMsgForContent('disambiguationspage'));
+ $id = $dp->getArticleId();
+ $dns = $dp->getNamespace();
+ $dtitle = $dbr->addQuotes( $dp->getDBkey() );
+ if($dns != NS_TEMPLATE) {
+ # FIXME we assume the disambiguation message is a template but
+ # the page can potentially be from another namespace :/
+ wfDebug("Mediawiki:disambiguationspage message does not refer to a template!\n");
+ }
+
+ $sql = "SELECT 'Disambiguations' AS 'type', pa.page_namespace AS namespace,"
+ ." pa.page_title AS title, la.pl_from AS value"
+ ." FROM {$templatelinks} AS lb, {$page} AS pa, {$pagelinks} AS la"
+ ." WHERE lb.tl_namespace = $dns AND lb.tl_title = $dtitle" # disambiguation template
+ .' AND pa.page_id = lb.tl_from'
+ .' AND pa.page_namespace = la.pl_namespace'
+ .' AND pa.page_title = la.pl_title';
return $sql;
}
function getOrder() {
return '';
}
-
+
function formatResult( $skin, $result ) {
- global $wgContLang ;
- $ns = $wgContLang->getNamespaces() ;
+ $title = Title::newFromId( $result->value );
+ $dp = Title::makeTitle( $result->namespace, $result->title );
+
+ $from = $skin->makeKnownLinkObj( $title,'');
+ $edit = $skin->makeBrokenLinkObj( $title, "(".wfMsg("qbedit").")" , 'redirect=no');
+ $to = $skin->makeKnownLinkObj( $dp,'');
- $from = $skin->makeKnownLink( $ns[$result->ns_art].':'.$result->title_art ,'');
- $edit = $skin->makeBrokenLink( $ns[$result->ns_art].':'.$result->title_art , "(".wfMsg("qbedit").")" , 'redirect=no');
- $to = $skin->makeKnownLink( $ns[$result->ns_dis].':'.$result->title_dis ,'');
-
return "$from $edit => $to";
}
}
*/
function wfSpecialDisambiguations() {
list( $limit, $offset ) = wfCheckLimits();
-
+
$sd = new DisambiguationsPage();
-
- return $sd->doQuery( $offset, $limit );
+ return $sd->doQuery( $offset, $limit );
}
?>