1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
|
<?php
/**
* @file
* @ingroup SpecialPage
*/
/**
* @ingroup SpecialPage
*/
class DisambiguationsPage extends PageQueryPage {
function getName() {
return 'Disambiguations';
}
function isExpensive( ) { return true; }
function isSyndicated() { return false; }
function getPageHeader( ) {
return wfMsgExt( 'disambiguations-text', array( 'parse' ) );
}
function getSQL() {
$dbr = wfGetDB( DB_SLAVE );
$dMsgText = wfMsgForContent('disambiguationspage');
$linkBatch = new LinkBatch;
# If the text can be treated as a title, use it verbatim.
# Otherwise, pull the titles from the links table
$dp = Title::newFromText($dMsgText);
if( $dp ) {
if($dp->getNamespace() != 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");
}
$linkBatch->addObj( $dp );
} else {
# Get all the templates linked from the Mediawiki:Disambiguationspage
$disPageObj = Title::makeTitleSafe( NS_MEDIAWIKI, 'disambiguationspage' );
$res = $dbr->select(
array('pagelinks', 'page'),
'pl_title',
array('page_id = pl_from', 'pl_namespace' => NS_TEMPLATE,
'page_namespace' => $disPageObj->getNamespace(), 'page_title' => $disPageObj->getDBkey()),
__METHOD__ );
while ( $row = $dbr->fetchObject( $res ) ) {
$linkBatch->addObj( Title::makeTitle( NS_TEMPLATE, $row->pl_title ));
}
$dbr->freeResult( $res );
}
$set = $linkBatch->constructSet( 'lb.tl', $dbr );
if( $set === false ) {
# We must always return a valid sql query, but this way DB will always quicly return an empty result
$set = 'FALSE';
wfDebug("Mediawiki:disambiguationspage message does not link to any templates!\n");
}
list( $page, $pagelinks, $templatelinks) = $dbr->tableNamesN( 'page', 'pagelinks', 'templatelinks' );
$sql = "SELECT 'Disambiguations' AS \"type\", pb.page_namespace AS namespace,"
." pb.page_title AS title, la.pl_from AS value"
." FROM {$templatelinks} AS lb, {$page} AS pb, {$pagelinks} AS la, {$page} AS pa"
." WHERE $set" # disambiguation template(s)
.' AND pa.page_id = la.pl_from'
.' AND pa.page_namespace = ' . NS_MAIN # Limit to just articles in the main namespace
.' AND pb.page_id = lb.tl_from'
.' AND pb.page_namespace = la.pl_namespace'
.' AND pb.page_title = la.pl_title'
.' ORDER BY lb.tl_namespace, lb.tl_title';
return $sql;
}
function getOrder() {
return '';
}
function formatResult( $skin, $result ) {
global $wgContLang;
$title = Title::newFromID( $result->value );
$dp = Title::makeTitle( $result->namespace, $result->title );
$from = $skin->link( $title );
$edit = $skin->link( $title, "(".wfMsgHtml("qbedit").")", array(), array( 'redirect' => 'no', 'action' => 'edit' ) );
$arr = $wgContLang->getArrow();
$to = $skin->link( $dp );
return "$from $edit $arr $to";
}
}
/**
* Constructor
*/
function wfSpecialDisambiguations() {
list( $limit, $offset ) = wfCheckLimits();
$sd = new DisambiguationsPage();
return $sd->doQuery( $offset, $limit );
}
|