class DisambiguationsPage extends PageQueryPage {
function getName() {
- return 'disambiguations';
+ return 'Disambiguations';
}
function isExpensive( ) { return true; }
$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( 'page', 'links' ) );
+ extract( $dbr->tableNames( 'page', 'pagelinks' ) );
$dp = Title::newFromText(wfMsgForContent("disambiguationspage"));
- $dpid = $dp->getArticleID();
-
- $sql = "SELECT pa.page_namespace AS ns_art, pa.page_title AS title_art,"
- . " pb.page_namespace AS ns_dis, pb.page_title AS title_dis"
- . " FROM {$links} as la, {$links} as lb, {$page} as pa, {$page} as pb"
- . " WHERE la.l_to = '{$dpid}'"
- . " AND la.l_from = lb.l_to"
- . " AND pa.page_id = lb.l_from"
- . " AND pb.page_id = lb.l_to";
+ $id = $dp->getArticleId();
+ $dns = $dp->getNamespace();
+ $dtitle = $dbr->addQuotes( $dp->getDBkey() );
+ $sql = "SELECT 'Disambiguations' AS type, pa.page_namespace AS namespace,"
+ ." pa.page_title AS title, la.pl_from AS value"
+ ." FROM {$pagelinks} AS lb, {$page} AS pa, {$pagelinks} AS la"
+ ." WHERE lb.pl_namespace = $dns AND lb.pl_title = $dtitle" # disambiguation template
+ ." AND pa.page_id = lb.pl_from"
+ ." AND pa.page_namespace = la.pl_namespace"
+ ." AND pa.page_title = la.pl_title";
return $sql;
}
function formatResult( $skin, $result ) {
global $wgContLang ;
- $ns = $wgContLang->getNamespaces() ;
+ $title = Title::newFromId( $result->value );
+ $dp = Title::makeTitle( $result->namespace, $result->title );
- $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 ,'');
+ $from = $skin->makeKnownLinkObj( $title,'');
+ $edit = $skin->makeBrokenLinkObj( $title, "(".wfMsg("qbedit").")" , 'redirect=no');
+ $to = $skin->makeKnownLinkObj( $dp,'');
return "$from $edit => $to";
}
$sd = new DisambiguationsPage();
return $sd->doQuery( $offset, $limit );
-
}
?>