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
|
<?php
/**
*
* @package MediaWiki
* @subpackage SpecialPage
*/
/**
*
*/
require_once ( 'QueryPage.php' ) ;
/**
*
* @package MediaWiki
* @subpackage SpecialPage
*/
class CategoryTreePage extends QueryPage {
function getName() {
return 'CategoryTree';
}
function isExpensive() {
return true;
}
function isSyndicated() { return false; }
function getSQL() {
$dbr =& wfGetDB( DB_SLAVE );
$rootnodes = $dbr->tableName( 'rootnodes' );
return
"SELECT DISTINCT `node` as value
FROM $rootnodes";
}
function sortDescending() {
return false;
}
function isArticle($art) {
$dbr =& wfGetDB( DB_SLAVE );
$query = "SELECT COUNT(cl_sortkey) as count FROM `categorylinks` WHERE `cl_to`='" . str_replace(' ', '_', addslashes( $art )) . "'";
$res = $dbr->query( $query );
$row = $dbr->fetchObject( $res );
return ($row->count > 0) ? false : true;
}
function showSubCategories($skin, $cat) {
$dbr =& wfGetDB( DB_SLAVE );
$query = "SELECT `cl_sortkey` FROM `categorylinks` WHERE `cl_to`='" . addslashes( $cat ) . "'";
$res = $dbr->query( $query );
$out = '<br/><dir>';
while ( $row = $dbr->fetchObject( $res ) ) {
$sart = $this->isArticle( $row->cl_sortkey );
if ( str_replace('_', ' ', $cat) != $row->cl_sortkey && !(preg_match('/^Raw /', $row->cl_sortkey) && $sart)) {
$title = Title::makeTitle( $sart ? NS_ARTICLE : NS_CATEGORY, $row->cl_sortkey );
$out .= '<li>' . $skin->makeLinkObj( $title, $title->getText() );
if (!$sart) {
$out .= $this->showSubCategories($skin, str_replace(' ', '_', $row->cl_sortkey));
}
$out .= '</li>';
}
}
$out .= '</dir>';
return $out;
}
function formatResult( $skin, $result ) {
$title = Title::makeTitle( NS_CATEGORY, $result->value );
return $skin->makeLinkObj( $title, $title->getText() ) . $this->showSubCategories( $skin, $result->value );
}
}
/**
* constructor
*/
function wfSpecialCategoryTree() {
list( $limit, $offset ) = wfCheckLimits();
$wpp = new CategoryTreePage();
$wpp->doQuery( $offset, $limit );
}
?>
|