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
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
|
<?php
/**
*
* @package MediaWiki
* @subpackage SpecialPage
*/
/**
*
*/
function wfSpecialImagelist() {
global $wgUser, $wgOut, $wgLang, $wgContLang, $wgRequest;
$sort = $wgRequest->getVal( 'sort' );
$wpIlMatch = $wgRequest->getText( 'wpIlMatch' );
$dbr =& wfGetDB( DB_SLAVE );
$image = $dbr->tableName( 'image' );
$sql = "SELECT img_size,img_name,img_user,img_user_text," .
"img_description,img_timestamp FROM $image";
$byname = wfMsg( "byname" );
$bydate = wfMsg( "bydate" );
$bysize = wfMsg( "bysize" );
if ( !empty( $wpIlMatch ) ) {
$nt = Title::newFromUrl( $wpIlMatch );
if($nt ) {
$m = $dbr->strencode( strtolower( $nt->getDBkey() ) );
$m = str_replace( "%", "\\%", $m );
$m = str_replace( "_", "\\_", $m );
$sql .= " WHERE LCASE(img_name) LIKE '%{$m}%'";
}
}
if ( "bysize" == $sort ) {
$sql .= " ORDER BY img_size DESC";
$st = $bysize;
} else if ( "byname" == $sort ) {
$sql .= " ORDER BY img_name";
$st = $byname;
} else {
$sort = "bydate";
$sql .= " ORDER BY img_timestamp DESC";
$st = $bydate;
}
list( $limit, $offset ) = wfCheckLimits( 50 );
if ( 0 == $limit ) {
$lt = wfMsg( 'imagelistall' );
} else {
$lt = $wgLang->formatNum( "${limit}" );
$sql .= " LIMIT {$limit}";
}
$wgOut->addHTML( "<p>" . wfMsg( "imglegend" ) . "</p>\n" );
$text = wfMsg( "imagelisttext",
"<strong>{$lt}</strong>", "<strong>{$st}</strong>" );
$wgOut->addHTML( "<p>{$text}\n</p>" );
$sk = $wgUser->getSkin();
$cap = wfMsg( "ilshowmatch" );
$sub = wfMsg( "ilsubmit" );
$titleObj = Title::makeTitle( NS_SPECIAL, "Imagelist" );
$action = $titleObj->escapeLocalURL( "sort={$sort}&limit={$limit}" );
$wgOut->addHTML( "<form id=\"imagesearch\" method=\"post\" action=\"" .
"{$action}\">" .
"{$cap}: <input type='text' size='8' name=\"wpIlMatch\" value=\"" .
htmlspecialchars( $wpIlMatch ) . "\" /> " .
"<input type='submit' name=\"wpIlSubmit\" value=\"{$sub}\" /></form>" );
$nums = array( 50, 100, 250, 500 );
$here = Title::makeTitle( NS_SPECIAL, 'Imagelist' );
$fill = "";
$first = true;
foreach ( $nums as $num ) {
if ( ! $first ) { $fill .= " | "; }
$first = false;
$fill .= $sk->makeKnownLinkObj( $here, $wgLang->formatNum( $num ),
"sort=byname&limit={$num}&wpIlMatch=" . urlencode( $wpIlMatch ) );
}
$text = wfMsg( "showlast", $fill, $byname );
$wgOut->addHTML( "<p>{$text}<br />\n" );
$fill = "";
$first = true;
foreach ( $nums as $num ) {
if ( ! $first ) { $fill .= " | "; }
$first = false;
$fill .= $sk->makeKnownLinkObj( $here, $wgLang->formatNum( $num ),
"sort=bysize&limit={$num}&wpIlMatch=" . urlencode( $wpIlMatch ) );
}
$text = wfMsg( "showlast", $fill, $bysize );
$wgOut->addHTML( "{$text}<br />\n" );
$fill = "";
$first = true;
foreach ( $nums as $num ) {
if ( ! $first ) { $fill .= " | "; }
$first = false;
$fill .= $sk->makeKnownLinkObj( $here, $wgLang->formatNum( $num ),
"sort=bydate&limit={$num}&wpIlMatch=" . urlencode( $wpIlMatch ) );
}
$text = wfMsg( "showlast", $fill, $bydate );
$wgOut->addHTML( "{$text}</p>\n<p>" );
$res = $dbr->query( $sql, "wfSpecialImagelist" );
while ( $s = $dbr->fetchObject( $res ) ) {
$name = $s->img_name;
$ut = $s->img_user_text;
if ( 0 == $s->img_user ) {
$ul = $ut;
} else {
$ul = $sk->makeLinkObj( Title::makeTitle( NS_USER, $ut ), $ut );
}
$ilink = "<a href=\"" . htmlspecialchars( Image::wfImageUrl( $name ) ) .
"\">" . htmlspecialchars( $name ) . "</a>";
$nb = wfMsg( "nbytes", $wgLang->formatNum( $s->img_size ) );
$l = "(" .
$sk->makeKnownLinkObj( Title::makeTitle( NS_IMAGE, $name ),
wfMsg( "imgdesc" ) ) .
") {$ilink} . . {$nb} . . {$ul} . . " .
$wgLang->timeanddate( $s->img_timestamp, true );
$l .= $sk->commentBlock( $s->img_description );
$wgOut->addHTML( "{$l}<br />\n" );
}
$wgOut->addHTML( "</p>" );
$dbr->freeResult( $res );
}
?>
|
