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
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
|
<?php
/**
* This template is used to generate cache images. Running it will process the entire gallery,
* supplying an album name (ex: loadAlbums.php?album=newalbum) will only process the album named.
* Passing clear=on will purge the designated cache before generating cache images
* @package plugins
*/
// force UTF-8 Ø
define('OFFSET_PATH', 3);
require_once("../../admin-globals.php");
require_once(SERVERPATH . '/' . ZENFOLDER . '/template-functions.php');
require_once(SERVERPATH . '/' . ZENFOLDER . '/' . PLUGIN_FOLDER . '/cacheManager/functions.php');
admin_securityChecks(NULL, $return = currentRelativeURL());
XSRFdefender('cacheDBImages');
$zenphoto_tabs['overview']['subtabs'] = array(gettext('Cache images') => PLUGIN_FOLDER . '/cacheManager/cacheImages.php?page=overview&tab=images',
gettext('Cache stored images') => PLUGIN_FOLDER . '/cacheManager/cacheDBImages.php?page=overview&tab=DB&XSRFToken=' . getXSRFToken('cacheDBImages'));
printAdminHeader('overview', 'DB');
echo "\n</head>";
echo "\n<body>";
printLogoAndLinks();
echo "\n" . '<div id="main">';
printTabs();
echo "\n" . '<div id="content">';
?>
<?php printSubtabs('Cache'); ?>
<div class="tabbox">
<?php
zp_apply_filter('admin_note', 'cache', '');
?>
<p class="notebox">
<?php
echo gettext('This utility scans the database for images references that have been stored there.') . ' ';
echo gettext('If an image processor URI is discovered it will be converted to a cache file URI.') . ' ';
echo gettext('If the cache file for the image does not exist, a caching image reference will be made for the image.');
?>
</p>
<?php
$tables = array('albums' => array('desc'),
'images' => array('desc'),
'pages' => array('content', 'extracontent'),
'news' => array('content', 'extracontent'));
?>
<form name="size_selections" action="?select" method="post">
<?php
$refresh = $imageprocessor = $found = $fixed = $fixedFolder = 0;
XSRFToken('cacheDBImages');
$watermarks = getWatermarks();
$missingImages = NULL;
foreach ($tables as $table => $fields) {
foreach ($fields as $field) {
$sql = 'SELECT * FROM ' . prefix($table) . ' WHERE `' . $field . '` REGEXP "<img.*src\s*=\s*\".*i.php((\\.|[^\"])*)"';
$result = query($sql);
if ($result) {
while ($row = db_fetch_assoc($result)) {
$imageprocessor++;
preg_match_all('|\<\s*img.*?\ssrc\s*=\s*"(.*i\.php\?([^"]*)).*/\>|', $row[$field], $matches);
foreach ($matches[2] as $uri) {
$params = parse_url($uri);
if (array_key_exists('query', $params)) {
parse_str($params['query'], $query);
if (!file_exists(getAlbumFolder() . $query['a'] . '/' . $query['i'])) {
recordMissing($table, $row);
} else {
$url = '<img src="' . WEBPATH . '/' . ZENFOLDER . '/i.php?' . $uri . '" height="20" width="20" alt="X" />';
$text = zpFunctions::updateImageProcessorLink($url);
if ($text == $url) {
?>
<a href="<?php echo $uri; ?>&debug" title="<?php echo gettext('image processor reference'); ?>">
<?php echo $url . "\n"; ?>
</a>
<?php
}
$text = zpFunctions::updateImageProcessorLink($row[$field]);
if ($text != $row[$field]) {
$sql = 'UPDATE ' . prefix($table) . ' SET `' . $field . '`=' . db_quote($text) . ' WHERE `id`=' . $row['id'];
query($sql);
} else {
$refresh++;
}
}
}
}
}
}
$sql = 'SELECT * FROM ' . prefix($table) . ' WHERE `' . $field . '` REGEXP "<img.*src\s*=\s*\".*' . CACHEFOLDER . '((\\.|[^\"])*)"';
$result = query($sql);
if ($result) {
while ($row = db_fetch_assoc($result)) {
preg_match_all('~\<img.*src\s*=\s*"((\\.|[^"])*)~', $row[$field], $matches);
foreach ($matches[1] as $key => $match) {
$found++;
list($image, $args) = getImageProcessorURIFromCacheName($match, $watermarks);
if (!file_exists(getAlbumFolder() . $image)) {
recordMissing($table, $row);
} else {
$uri = getImageURI($args, dirname($image), basename($image), NULL);
if (strpos($uri, 'i.php?') !== false) {
$fixed++;
switch ($table) {
case 'images':
$album = query_single_row('SELECT `folder` FROM ' . prefix('albums') . ' WHERE `id`=' . $row[albumid]);
$title = sprintf(gettext('%1$s: image %2$s'), $album['folder'], $row[$filename]);
break;
case 'albums':
$title = sprintf(gettext('album %s'), $row[$folder]);
break;
case 'news':
case 'pages':
$title = sprintf(gettext('%1$s: %2$s'), $table, $row['titlelink']);
break;
}
?>
<a href="<?php echo html_encode($uri); ?>&debug" title="<?php echo $title; ?>">
<?php
if (isset($set['t'])) {
echo '<img src="' . html_encode(pathurlencode($uri)) . '" height="8" width="8" alt="x" />' . "\n";
} else {
echo '<img src="' . html_encode(pathurlencode($uri)) . '" height="20" width="20" alt="X" />' . "\n";
}
?>
</a>
<?php
}
//Check for cache folder having moved (Site relocated?)
preg_match('~(.*/)' . CACHEFOLDER . '~', $match, $foldermatches);
if ($foldermatches[1] != WEBPATH . '/') {
$fixedFolder++;
$target = $foldermatches[1] . CACHEFOLDER . '/' . stripSuffix($image);
$update = WEBPATH . '/' . CACHEFOLDER . '/' . stripSuffix($image);
$row[$field] = updateCacheFolder($row[$field], $target, $update);
$sql = 'UPDATE ' . prefix($table) . ' SET `' . $field . '`=' . db_quote($row[$field]) . ' WHERE `id`=' . $row['id'];
query($sql);
}
}
}
}
}
}
}
if (!empty($missingImages)) {
?>
<div class="errorbox">
<p>
<?php
echo gettext('<strong>Note:</strong> the following objects have images that appear to no longer exist.');
?>
</p>
<?php
foreach ($missingImages as $link => $missing) {
?>
<a href="<?php echo $link; ?>"><?php echo $missing; ?></a><br />
<?php
}
?>
</div>
<?php
}
$button = array('text' => gettext("Refresh"), 'title' => gettext('Refresh the caching of the images stored in the database if some images did not render.'));
?>
<p>
<?php
printf(ngettext('%u image processor reference found.', '%u image processor references found.', $imageprocessor), $imageprocessor);
if ($refresh) {
echo ' ' . gettext('You should use the refresh button to convert these to cached image references');
}
?>
<br />
<?php
printf(ngettext('%u cached image reference found.', '%u cached image references found.', $found), $found);
?>
<br />
<?php
printf(ngettext('%s reference re-cached.', '%s references re-cached.', $fixed), $fixed);
?>
<br />
<?php
if ($fixedFolder) {
printf(ngettext('%s cache folder reference fixed.', '%s cache folder references fixed.', $fixedFolder), $fixedFolder);
}
?>
</p>
<p class="buttons">
<a title="<?php echo gettext('Back to the overview'); ?>"href="<?php echo WEBPATH . '/' . ZENFOLDER; ?>"> <img src="<?php echo FULLWEBPATH . '/' . ZENFOLDER; ?>/images/cache.png" alt="" />
<strong><?php echo gettext("Back"); ?> </strong>
</a>
</p>
<?php
if ($button) {
?>
<p class="buttons">
<button class="tooltip" type="submit" title="<?php echo $button['title']; ?>" >
<img src="<?php echo WEBPATH . '/' . ZENFOLDER; ?>/images/redo.png" alt="" />
<?php echo $button['text']; ?>
</button>
</p>
<?php
}
?>
<br class="clearall" />
</form>
<?php
echo "\n" . '</div>';
echo "\n" . '</div>';
echo "\n" . '</div>';
printAdminFooter();
echo "\n</body>";
echo "\n</head>";
/**
* Updates the path to the cache folder
* @param mixed $text
* @param string $target
* @param string $update
* @return mixed
*/
function updateCacheFolder($text, $target, $update) {
if (is_string($text) && preg_match('/^a:[0-9]+:{/', $text)) { // serialized array
$text = getSerializedArray($text);
$serial = true;
} else {
$serial = false;
}
if (is_array($text)) {
foreach ($text as $key => $textelement) {
$text[$key] = updateCacheFolder($textelement, $target, $update);
}
if ($serial) {
$text = serialize($text);
}
} else {
$text = str_replace($target, $update, $text);
}
return $text;
}
function recordMissing($table, $row) {
global $missingImages;
$obj = getItemByID($table, $row['id']);
switch ($table) {
case 'news':
$obj_link = $obj->getNewsLink();
break;
case 'pages':
$obj_link = $obj->getPageLink();
break;
case 'news_categories':
$obj_link = $obj->getCategoryLink();
break;
case 'images':
$obj_link = $obj->getImageLink();
break;
case 'albums':
$obj_link = $obj->getAlbumLink();
break;
}
$missingImages[$obj_link] = $obj->getTitle();
}
?>
|