Verzeichnisstruktur phpBB-3.1.0
- Veröffentlicht
- 27.10.2014
So funktioniert es
|
|
Auf das letzte Element klicken. Dies geht jeweils ein Schritt zurück |
Auf das Icon klicken, dies öffnet das Verzeichnis. Nochmal klicken schließt das Verzeichnis. |
|
|
(Beispiel Datei-Icons)
|
Auf das Icon klicken um den Quellcode anzuzeigen |
acp_icons.php
001 <?php
002 /**
003 *
004 * This file is part of the phpBB Forum Software package.
005 *
006 * @copyright (c) phpBB Limited <https://www.phpbb.com>
007 * @license GNU General Public License, version 2 (GPL-2.0)
008 *
009 * For full copyright and license information, please see
010 * the docs/CREDITS.txt file.
011 *
012 */
013
014 /**
015 * @ignore
016 */
017 if (!defined('IN_PHPBB'))
018 {
019 exit;
020 }
021
022 /**
023 * @todo [smilies] check regular expressions for special char replacements (stored specialchared in db)
024 */
025 class acp_icons
026 {
027 var $u_action;
028
029 function main($id, $mode)
030 {
031 global $db, $user, $auth, $template, $cache;
032 global $config, $phpbb_root_path, $phpbb_admin_path, $phpEx;
033 global $request, $phpbb_container;
034
035 $user->add_lang('acp/posting');
036
037 // Set up general vars
038 $action = request_var('action', '');
039 $action = (isset($_POST['add'])) ? 'add' : $action;
040 $action = (isset($_POST['edit'])) ? 'edit' : $action;
041 $action = (isset($_POST['import'])) ? 'import' : $action;
042 $icon_id = request_var('id', 0);
043
044 $mode = ($mode == 'smilies') ? 'smilies' : 'icons';
045
046 $this->tpl_name = 'acp_icons';
047
048 // What are we working on?
049 switch ($mode)
050 {
051 case 'smilies':
052 $table = SMILIES_TABLE;
053 $lang = 'SMILIES';
054 $fields = 'smiley';
055 $img_path = $config['smilies_path'];
056 break;
057
058 case 'icons':
059 $table = ICONS_TABLE;
060 $lang = 'ICONS';
061 $fields = 'icons';
062 $img_path = $config['icons_path'];
063 break;
064 }
065
066 $this->page_title = 'ACP_' . $lang;
067
068 // Clear some arrays
069 $_images = $_paks = array();
070 $notice = '';
071
072 // Grab file list of paks and images
073 if ($action == 'edit' || $action == 'add' || $action == 'import')
074 {
075 $imglist = filelist($phpbb_root_path . $img_path, '');
076
077 foreach ($imglist as $path => $img_ary)
078 {
079 if (empty($img_ary))
080 {
081 continue;
082 }
083
084 asort($img_ary, SORT_STRING);
085
086 foreach ($img_ary as $img)
087 {
088 $img_size = getimagesize($phpbb_root_path . $img_path . '/' . $path . $img);
089
090 if (!$img_size[0] || !$img_size[1] || strlen($img) > 255)
091 {
092 continue;
093 }
094
095 // adjust the width and height to be lower than 128px while perserving the aspect ratio (for icons)
096 if ($mode == 'icons')
097 {
098 if ($img_size[0] > 127 && $img_size[0] > $img_size[1])
099 {
100 $img_size[1] = (int) ($img_size[1] * (127 / $img_size[0]));
101 $img_size[0] = 127;
102 }
103 else if ($img_size[1] > 127)
104 {
105 $img_size[0] = (int) ($img_size[0] * (127 / $img_size[1]));
106 $img_size[1] = 127;
107 }
108 }
109
110 $_images[$path . $img]['file'] = $path . $img;
111 $_images[$path . $img]['width'] = $img_size[0];
112 $_images[$path . $img]['height'] = $img_size[1];
113 }
114 }
115 unset($imglist);
116
117 if ($dir = @opendir($phpbb_root_path . $img_path))
118 {
119 while (($file = readdir($dir)) !== false)
120 {
121 if (is_file($phpbb_root_path . $img_path . '/' . $file) && preg_match('#\.pak$#i', $file))
122 {
123 $_paks[] = $file;
124 }
125 }
126 closedir($dir);
127
128 if (!empty($_paks))
129 {
130 asort($_paks, SORT_STRING);
131 }
132 }
133 }
134
135 // What shall we do today? Oops, I believe that's trademarked ...
136 switch ($action)
137 {
138 case 'edit':
139 unset($_images);
140 $_images = array();
141
142 // no break;
143
144 case 'add':
145
146 $smilies = $default_row = array();
147 $smiley_options = $order_list = $add_order_list = '';
148
149 if ($action == 'add' && $mode == 'smilies')
150 {
151 $sql = 'SELECT *
152 FROM ' . SMILIES_TABLE . '
153 ORDER BY smiley_order';
154 $result = $db->sql_query($sql);
155
156 while ($row = $db->sql_fetchrow($result))
157 {
158 if (empty($smilies[$row['smiley_url']]))
159 {
160 $smilies[$row['smiley_url']] = $row;
161 }
162 }
163 $db->sql_freeresult($result);
164
165 if (sizeof($smilies))
166 {
167 foreach ($smilies as $row)
168 {
169 $selected = false;
170
171 if (!$smiley_options)
172 {
173 $selected = true;
174 $default_row = $row;
175 }
176 $smiley_options .= '<option value="' . $row['smiley_url'] . '"' . (($selected) ? ' selected="selected"' : '') . '>' . $row['smiley_url'] . '</option>';
177
178 $template->assign_block_vars('smile', array(
179 'SMILEY_URL' => addslashes($row['smiley_url']),
180 'CODE' => addslashes($row['code']),
181 'EMOTION' => addslashes($row['emotion']),
182 'WIDTH' => $row['smiley_width'],
183 'HEIGHT' => $row['smiley_height'],
184 'ORDER' => $row['smiley_order'] + 1,
185 ));
186 }
187 }
188 }
189
190 $sql = "SELECT *
191 FROM $table
192 ORDER BY {$fields}_order " . (($icon_id || $action == 'add') ? 'DESC' : 'ASC');
193 $result = $db->sql_query($sql);
194
195 $data = array();
196 $after = false;
197 $display = 0;
198 $order_lists = array('', '');
199 $add_order_lists = array('', '');
200 $display_count = 0;
201
202 while ($row = $db->sql_fetchrow($result))
203 {
204 if ($action == 'add')
205 {
206 unset($_images[$row[$fields . '_url']]);
207 }
208
209 if ($row[$fields . '_id'] == $icon_id)
210 {
211 $after = true;
212 $display = $row['display_on_posting'];
213 $data[$row[$fields . '_url']] = $row;
214 }
215 else
216 {
217 if ($action == 'edit' && !$icon_id)
218 {
219 $data[$row[$fields . '_url']] = $row;
220 }
221
222 $selected = '';
223 if (!empty($after))
224 {
225 $selected = ' selected="selected"';
226 $after = false;
227 }
228 if ($row['display_on_posting'])
229 {
230 $display_count++;
231 }
232 $after_txt = ($mode == 'smilies') ? $row['code'] : $row['icons_url'];
233 $order_lists[$row['display_on_posting']] = '<option value="' . ($row[$fields . '_order'] + 1) . '"' . $selected . '>' . sprintf($user->lang['AFTER_' . $lang], ' -> ' . $after_txt) . '</option>' . $order_lists[$row['display_on_posting']];
234
235 if (!empty($default_row))
236 {
237 $add_order_lists[$row['display_on_posting']] = '<option value="' . ($row[$fields . '_order'] + 1) . '"' . (($row[$fields . '_id'] == $default_row['smiley_id']) ? ' selected="selected"' : '') . '>' . sprintf($user->lang['AFTER_' . $lang], ' -> ' . $after_txt) . '</option>' . $add_order_lists[$row['display_on_posting']];
238 }
239 }
240 }
241 $db->sql_freeresult($result);
242
243 $order_list = '<option value="1"' . ((!isset($after)) ? ' selected="selected"' : '') . '>' . $user->lang['FIRST'] . '</option>';
244 $add_order_list = '<option value="1">' . $user->lang['FIRST'] . '</option>';
245
246 if ($action == 'add')
247 {
248 $data = $_images;
249 }
250
251 $colspan = (($mode == 'smilies') ? 7 : 5);
252 $colspan += ($icon_id) ? 1 : 0;
253 $colspan += ($action == 'add') ? 2 : 0;
254
255 $template->assign_vars(array(
256 'S_EDIT' => true,
257 'S_SMILIES' => ($mode == 'smilies') ? true : false,
258 'S_ADD' => ($action == 'add') ? true : false,
259
260 'S_ORDER_LIST_DISPLAY' => $order_list . $order_lists[1],
261 'S_ORDER_LIST_UNDISPLAY' => $order_list . $order_lists[0],
262 'S_ORDER_LIST_DISPLAY_COUNT' => $display_count + 1,
263
264 'L_TITLE' => $user->lang['ACP_' . $lang],
265 'L_EXPLAIN' => $user->lang['ACP_' . $lang . '_EXPLAIN'],
266 'L_CONFIG' => $user->lang[$lang . '_CONFIG'],
267 'L_URL' => $user->lang[$lang . '_URL'],
268 'L_LOCATION' => $user->lang[$lang . '_LOCATION'],
269 'L_WIDTH' => $user->lang[$lang . '_WIDTH'],
270 'L_HEIGHT' => $user->lang[$lang . '_HEIGHT'],
271 'L_ORDER' => $user->lang[$lang . '_ORDER'],
272 'L_NO_ICONS' => $user->lang['NO_' . $lang . '_' . strtoupper($action)],
273
274 'COLSPAN' => $colspan,
275 'ID' => $icon_id,
276
277 'U_BACK' => $this->u_action,
278 'U_ACTION' => $this->u_action . '&action=' . (($action == 'add') ? 'create' : 'modify'),
279 ));
280
281 foreach ($data as $img => $img_row)
282 {
283 $template->assign_block_vars('items', array(
284 'IMG' => $img,
285 'A_IMG' => addslashes($img),
286 'IMG_SRC' => $phpbb_root_path . $img_path . '/' . $img,
287
288 'CODE' => ($mode == 'smilies' && isset($img_row['code'])) ? $img_row['code'] : '',
289 'EMOTION' => ($mode == 'smilies' && isset($img_row['emotion'])) ? $img_row['emotion'] : '',
290
291 'S_ID' => (isset($img_row[$fields . '_id'])) ? true : false,
292 'ID' => (isset($img_row[$fields . '_id'])) ? $img_row[$fields . '_id'] : 0,
293 'WIDTH' => (!empty($img_row[$fields .'_width'])) ? $img_row[$fields .'_width'] : $img_row['width'],
294 'HEIGHT' => (!empty($img_row[$fields .'_height'])) ? $img_row[$fields .'_height'] : $img_row['height'],
295 'POSTING_CHECKED' => (!empty($img_row['display_on_posting']) || $action == 'add') ? ' checked="checked"' : '',
296 ));
297 }
298
299 // Ok, another row for adding an addition code for a pre-existing image...
300 if ($action == 'add' && $mode == 'smilies' && sizeof($smilies))
301 {
302 $template->assign_vars(array(
303 'S_ADD_CODE' => true,
304
305 'S_IMG_OPTIONS' => $smiley_options,
306
307 'S_ADD_ORDER_LIST_DISPLAY' => $add_order_list . $add_order_lists[1],
308 'S_ADD_ORDER_LIST_UNDISPLAY' => $add_order_list . $add_order_lists[0],
309
310 'IMG_SRC' => $phpbb_root_path . $img_path . '/' . $default_row['smiley_url'],
311 'IMG_PATH' => $img_path,
312
313 'CODE' => $default_row['code'],
314 'EMOTION' => $default_row['emotion'],
315
316 'WIDTH' => $default_row['smiley_width'],
317 'HEIGHT' => $default_row['smiley_height'],
318 ));
319 }
320
321 return;
322
323 break;
324
325 case 'create':
326 case 'modify':
327
328 // Get items to create/modify
329 $images = (isset($_POST['image'])) ? array_keys(request_var('image', array('' => 0))) : array();
330
331 // Now really get the items
332 $image_id = (isset($_POST['id'])) ? request_var('id', array('' => 0)) : array();
333 $image_order = (isset($_POST['order'])) ? request_var('order', array('' => 0)) : array();
334 $image_width = (isset($_POST['width'])) ? request_var('width', array('' => 0)) : array();
335 $image_height = (isset($_POST['height'])) ? request_var('height', array('' => 0)) : array();
336 $image_add = (isset($_POST['add_img'])) ? request_var('add_img', array('' => 0)) : array();
337 $image_emotion = utf8_normalize_nfc(request_var('emotion', array('' => ''), true));
338 $image_code = utf8_normalize_nfc(request_var('code', array('' => ''), true));
339 $image_display_on_posting = (isset($_POST['display_on_posting'])) ? request_var('display_on_posting', array('' => 0)) : array();
340
341 // Ok, add the relevant bits if we are adding new codes to existing emoticons...
342 if ($request->variable('add_additional_code', false, false, \phpbb\request\request_interface::POST))
343 {
344 $add_image = request_var('add_image', '');
345 $add_code = utf8_normalize_nfc(request_var('add_code', '', true));
346 $add_emotion = utf8_normalize_nfc(request_var('add_emotion', '', true));
347
348 if ($add_image && $add_emotion && $add_code)
349 {
350 $images[] = $add_image;
351 $image_add[$add_image] = true;
352
353 $image_code[$add_image] = $add_code;
354 $image_emotion[$add_image] = $add_emotion;
355 $image_width[$add_image] = request_var('add_width', 0);
356 $image_height[$add_image] = request_var('add_height', 0);
357
358 if ($request->variable('add_display_on_posting', false, false, \phpbb\request\request_interface::POST))
359 {
360 $image_display_on_posting[$add_image] = 1;
361 }
362
363 $image_order[$add_image] = request_var('add_order', 0);
364 }
365 }
366
367 if ($mode == 'smilies' && $action == 'create')
368 {
369 $smiley_count = $this->item_count($table);
370
371 $addable_smileys_count = sizeof($images);
372 foreach ($images as $image)
373 {
374 if (!isset($image_add[$image]))
375 {
376 --$addable_smileys_count;
377 }
378 }
379
380 if ($smiley_count + $addable_smileys_count > SMILEY_LIMIT)
381 {
382 trigger_error($user->lang('TOO_MANY_SMILIES', SMILEY_LIMIT) . adm_back_link($this->u_action), E_USER_WARNING);
383 }
384 }
385
386 $icons_updated = 0;
387 $errors = array();
388 foreach ($images as $image)
389 {
390 if ($mode == 'smilies' && ($image_emotion[$image] == '' || $image_code[$image] == ''))
391 {
392 $errors[$image] = 'SMILIE_NO_' . (($image_emotion[$image] == '') ? 'EMOTION' : 'CODE');
393 }
394 else if ($action == 'create' && !isset($image_add[$image]))
395 {
396 // skip images where add wasn't checked
397 }
398 else if (!file_exists($phpbb_root_path . $img_path . '/' . $image))
399 {
400 $errors[$image] = 'SMILIE_NO_FILE';
401 }
402 else
403 {
404 if ($image_width[$image] == 0 || $image_height[$image] == 0)
405 {
406 $img_size = getimagesize($phpbb_root_path . $img_path . '/' . $image);
407 $image_width[$image] = $img_size[0];
408 $image_height[$image] = $img_size[1];
409 }
410
411 // Adjust image width/height for icons
412 if ($mode == 'icons')
413 {
414 if ($image_width[$image] > 127 && $image_width[$image] > $image_height[$image])
415 {
416 $image_height[$image] = (int) ($image_height[$image] * (127 / $image_width[$image]));
417 $image_width[$image] = 127;
418 }
419 else if ($image_height[$image] > 127)
420 {
421 $image_width[$image] = (int) ($image_width[$image] * (127 / $image_height[$image]));
422 $image_height[$image] = 127;
423 }
424 }
425
426 $img_sql = array(
427 $fields . '_url' => $image,
428 $fields . '_width' => $image_width[$image],
429 $fields . '_height' => $image_height[$image],
430 'display_on_posting' => (isset($image_display_on_posting[$image])) ? 1 : 0,
431 );
432
433 if ($mode == 'smilies')
434 {
435 $img_sql = array_merge($img_sql, array(
436 'emotion' => $image_emotion[$image],
437 'code' => $image_code[$image])
438 );
439 }
440
441 // Image_order holds the 'new' order value
442 if (!empty($image_order[$image]))
443 {
444 $img_sql = array_merge($img_sql, array(
445 $fields . '_order' => $image_order[$image])
446 );
447
448 // Since we always add 'after' an item, we just need to increase all following + the current by one
449 $sql = "UPDATE $table
450 SET {$fields}_order = {$fields}_order + 1
451 WHERE {$fields}_order >= {$image_order[$image]}";
452 $db->sql_query($sql);
453
454 // If we adjust the order, we need to adjust all other orders too - they became inaccurate...
455 foreach ($image_order as $_image => $_order)
456 {
457 if ($_image == $image)
458 {
459 continue;
460 }
461
462 if ($_order >= $image_order[$image])
463 {
464 $image_order[$_image]++;
465 }
466 }
467 }
468
469 if ($action == 'modify' && !empty($image_id[$image]))
470 {
471 $sql = "UPDATE $table
472 SET " . $db->sql_build_array('UPDATE', $img_sql) . "
473 WHERE {$fields}_id = " . $image_id[$image];
474 $db->sql_query($sql);
475 $icons_updated++;
476 }
477 else if ($action !== 'modify')
478 {
479 $sql = "INSERT INTO $table " . $db->sql_build_array('INSERT', $img_sql);
480 $db->sql_query($sql);
481 $icons_updated++;
482 }
483
484 }
485 }
486
487 $cache->destroy('_icons');
488 $cache->destroy('sql', $table);
489
490 $level = ($icons_updated) ? E_USER_NOTICE : E_USER_WARNING;
491 $errormsgs = '';
492 foreach ($errors as $img => $error)
493 {
494 $errormsgs .= '<br />' . sprintf($user->lang[$error], $img);
495 }
496 if ($action == 'modify')
497 {
498 trigger_error($user->lang($lang . '_EDITED', $icons_updated) . $errormsgs . adm_back_link($this->u_action), $level);
499 }
500 else
501 {
502 trigger_error($user->lang($lang . '_ADDED', $icons_updated) . $errormsgs . adm_back_link($this->u_action), $level);
503 }
504
505 break;
506
507 case 'import':
508
509 $pak = request_var('pak', '');
510 $current = request_var('current', '');
511
512 if ($pak != '')
513 {
514 $order = 0;
515
516 if (!($pak_ary = @file($phpbb_root_path . $img_path . '/' . $pak)))
517 {
518 trigger_error($user->lang['PAK_FILE_NOT_READABLE'] . adm_back_link($this->u_action), E_USER_WARNING);
519 }
520
521 // Make sure the pak_ary is valid
522 foreach ($pak_ary as $pak_entry)
523 {
524 if (preg_match_all("#'(.*?)', ?#", $pak_entry, $data))
525 {
526 if ((sizeof($data[1]) != 4 && $mode == 'icons') ||
527 ((sizeof($data[1]) != 6 || (empty($data[1][4]) || empty($data[1][5]))) && $mode == 'smilies' ))
528 {
529 trigger_error($user->lang['WRONG_PAK_TYPE'] . adm_back_link($this->u_action), E_USER_WARNING);
530 }
531 }
532 else
533 {
534 trigger_error($user->lang['WRONG_PAK_TYPE'] . adm_back_link($this->u_action), E_USER_WARNING);
535 }
536 }
537
538 // The user has already selected a smilies_pak file
539 if ($current == 'delete')
540 {
541 switch ($db->get_sql_layer())
542 {
543 case 'sqlite':
544 case 'sqlite3':
545 $db->sql_query('DELETE FROM ' . $table);
546 break;
547
548 default:
549 $db->sql_query('TRUNCATE TABLE ' . $table);
550 break;
551 }
552
553 switch ($mode)
554 {
555 case 'smilies':
556 break;
557
558 case 'icons':
559 // Reset all icon_ids
560 $db->sql_query('UPDATE ' . TOPICS_TABLE . ' SET icon_id = 0');
561 $db->sql_query('UPDATE ' . POSTS_TABLE . ' SET icon_id = 0');
562 break;
563 }
564 }
565 else
566 {
567 $cur_img = array();
568
569 $field_sql = ($mode == 'smilies') ? 'code' : 'icons_url';
570
571 $sql = "SELECT $field_sql
572 FROM $table";
573 $result = $db->sql_query($sql);
574
575 while ($row = $db->sql_fetchrow($result))
576 {
577 ++$order;
578 $cur_img[$row[$field_sql]] = 1;
579 }
580 $db->sql_freeresult($result);
581 }
582
583 if ($mode == 'smilies')
584 {
585 $smiley_count = $this->item_count($table);
586 if ($smiley_count + sizeof($pak_ary) > SMILEY_LIMIT)
587 {
588 trigger_error($user->lang('TOO_MANY_SMILIES', SMILEY_LIMIT) . adm_back_link($this->u_action), E_USER_WARNING);
589 }
590 }
591
592 foreach ($pak_ary as $pak_entry)
593 {
594 $data = array();
595 if (preg_match_all("#'(.*?)', ?#", $pak_entry, $data))
596 {
597 if ((sizeof($data[1]) != 4 && $mode == 'icons') ||
598 (sizeof($data[1]) != 6 && $mode == 'smilies'))
599 {
600 trigger_error($user->lang['WRONG_PAK_TYPE'] . adm_back_link($this->u_action), E_USER_WARNING);
601 }
602
603 // Stripslash here because it got addslashed before... (on export)
604 $img = stripslashes($data[1][0]);
605 $width = stripslashes($data[1][1]);
606 $height = stripslashes($data[1][2]);
607 $display_on_posting = stripslashes($data[1][3]);
608
609 if (isset($data[1][4]) && isset($data[1][5]))
610 {
611 $emotion = stripslashes($data[1][4]);
612 $code = stripslashes($data[1][5]);
613 }
614
615 if ($current == 'replace' &&
616 (($mode == 'smilies' && !empty($cur_img[$code])) ||
617 ($mode == 'icons' && !empty($cur_img[$img]))))
618 {
619 $replace_sql = ($mode == 'smilies') ? $code : $img;
620 $sql = array(
621 $fields . '_url' => $img,
622 $fields . '_height' => (int) $height,
623 $fields . '_width' => (int) $width,
624 'display_on_posting' => (int) $display_on_posting,
625 );
626
627 if ($mode == 'smilies')
628 {
629 $sql = array_merge($sql, array(
630 'emotion' => $emotion,
631 ));
632 }
633
634 $sql = "UPDATE $table SET " . $db->sql_build_array('UPDATE', $sql) . "
635 WHERE $field_sql = '" . $db->sql_escape($replace_sql) . "'";
636 $db->sql_query($sql);
637 }
638 else
639 {
640 ++$order;
641
642 $sql = array(
643 $fields . '_url' => $img,
644 $fields . '_height' => (int) $height,
645 $fields . '_width' => (int) $width,
646 $fields . '_order' => (int) $order,
647 'display_on_posting'=> (int) $display_on_posting,
648 );
649
650 if ($mode == 'smilies')
651 {
652 $sql = array_merge($sql, array(
653 'code' => $code,
654 'emotion' => $emotion,
655 ));
656 }
657 $db->sql_query("INSERT INTO $table " . $db->sql_build_array('INSERT', $sql));
658 }
659 }
660 }
661
662 $cache->destroy('_icons');
663 $cache->destroy('sql', $table);
664
665 trigger_error($user->lang[$lang . '_IMPORT_SUCCESS'] . adm_back_link($this->u_action));
666 }
667 else
668 {
669 $pak_options = '';
670
671 foreach ($_paks as $pak)
672 {
673 $pak_options .= '<option value="' . $pak . '">' . htmlspecialchars($pak) . '</option>';
674 }
675
676 $template->assign_vars(array(
677 'S_CHOOSE_PAK' => true,
678 'S_PAK_OPTIONS' => $pak_options,
679
680 'L_TITLE' => $user->lang['ACP_' . $lang],
681 'L_EXPLAIN' => $user->lang['ACP_' . $lang . '_EXPLAIN'],
682 'L_NO_PAK_OPTIONS' => $user->lang['NO_' . $lang . '_PAK'],
683 'L_CURRENT' => $user->lang['CURRENT_' . $lang],
684 'L_CURRENT_EXPLAIN' => $user->lang['CURRENT_' . $lang . '_EXPLAIN'],
685 'L_IMPORT_SUBMIT' => $user->lang['IMPORT_' . $lang],
686
687 'U_BACK' => $this->u_action,
688 'U_ACTION' => $this->u_action . '&action=import',
689 )
690 );
691 }
692 break;
693
694 case 'export':
695
696 $this->page_title = 'EXPORT_' . $lang;
697 $this->tpl_name = 'message_body';
698
699 $template->assign_vars(array(
700 'MESSAGE_TITLE' => $user->lang['EXPORT_' . $lang],
701 'MESSAGE_TEXT' => sprintf($user->lang['EXPORT_' . $lang . '_EXPLAIN'], '<a href="' . $this->u_action . '&action=send">', '</a>'),
702
703 'S_USER_NOTICE' => true,
704 )
705 );
706
707 return;
708
709 break;
710
711 case 'send':
712
713 $sql = "SELECT *
714 FROM $table
715 ORDER BY {$fields}_order";
716 $result = $db->sql_query($sql);
717
718 $pak = '';
719 while ($row = $db->sql_fetchrow($result))
720 {
721 $pak .= "'" . addslashes($row[$fields . '_url']) . "', ";
722 $pak .= "'" . addslashes($row[$fields . '_width']) . "', ";
723 $pak .= "'" . addslashes($row[$fields . '_height']) . "', ";
724 $pak .= "'" . addslashes($row['display_on_posting']) . "', ";
725
726 if ($mode == 'smilies')
727 {
728 $pak .= "'" . addslashes($row['emotion']) . "', ";
729 $pak .= "'" . addslashes($row['code']) . "', ";
730 }
731
732 $pak .= "\n";
733 }
734 $db->sql_freeresult($result);
735
736 if ($pak != '')
737 {
738 garbage_collection();
739
740 header('Cache-Control: public');
741
742 // Send out the Headers
743 header('Content-Type: text/x-delimtext; name="' . $mode . '.pak"');
744 header('Content-Disposition: inline; filename="' . $mode . '.pak"');
745 echo $pak;
746
747 flush();
748 exit;
749 }
750 else
751 {
752 trigger_error($user->lang['NO_' . strtoupper($fields) . '_EXPORT'] . adm_back_link($this->u_action), E_USER_WARNING);
753 }
754
755 break;
756
757 case 'delete':
758
759 if (confirm_box(true))
760 {
761 $sql = "DELETE FROM $table
762 WHERE {$fields}_id = $icon_id";
763 $db->sql_query($sql);
764
765 switch ($mode)
766 {
767 case 'smilies':
768 break;
769
770 case 'icons':
771 // Reset appropriate icon_ids
772 $db->sql_query('UPDATE ' . TOPICS_TABLE . "
773 SET icon_id = 0
774 WHERE icon_id = $icon_id");
775
776 $db->sql_query('UPDATE ' . POSTS_TABLE . "
777 SET icon_id = 0
778 WHERE icon_id = $icon_id");
779 break;
780 }
781
782 $notice = $user->lang[$lang . '_DELETED'];
783
784 $cache->destroy('_icons');
785 $cache->destroy('sql', $table);
786
787 if ($request->is_ajax())
788 {
789 $json_response = new \phpbb\json_response;
790 $json_response->send(array(
791 'MESSAGE_TITLE' => $user->lang['INFORMATION'],
792 'MESSAGE_TEXT' => $notice,
793 'REFRESH_DATA' => array(
794 'time' => 3
795 )
796 ));
797 }
798 }
799 else
800 {
801 confirm_box(false, $user->lang['CONFIRM_OPERATION'], build_hidden_fields(array(
802 'i' => $id,
803 'mode' => $mode,
804 'id' => $icon_id,
805 'action' => 'delete',
806 )));
807 }
808
809 break;
810
811 case 'move_up':
812 case 'move_down':
813
814 // Get current order id...
815 $sql = "SELECT {$fields}_order as current_order
816 FROM $table
817 WHERE {$fields}_id = $icon_id";
818 $result = $db->sql_query($sql);
819 $current_order = (int) $db->sql_fetchfield('current_order');
820 $db->sql_freeresult($result);
821
822 if ($current_order == 0 && $action == 'move_up')
823 {
824 break;
825 }
826
827 // on move_down, switch position with next order_id...
828 // on move_up, switch position with previous order_id...
829 $switch_order_id = ($action == 'move_down') ? $current_order + 1 : $current_order - 1;
830
831 //
832 $sql = "UPDATE $table
833 SET {$fields}_order = $current_order
834 WHERE {$fields}_order = $switch_order_id
835 AND {$fields}_id <> $icon_id";
836 $db->sql_query($sql);
837 $move_executed = (bool) $db->sql_affectedrows();
838
839 // Only update the other entry too if the previous entry got updated
840 if ($move_executed)
841 {
842 $sql = "UPDATE $table
843 SET {$fields}_order = $switch_order_id
844 WHERE {$fields}_order = $current_order
845 AND {$fields}_id = $icon_id";
846 $db->sql_query($sql);
847 }
848
849 $cache->destroy('_icons');
850 $cache->destroy('sql', $table);
851
852 if ($request->is_ajax())
853 {
854 $json_response = new \phpbb\json_response;
855 $json_response->send(array(
856 'success' => $move_executed,
857 ));
858 }
859
860 break;
861 }
862
863 // By default, check that image_order is valid and fix it if necessary
864 $sql = "SELECT {$fields}_id AS order_id, {$fields}_order AS fields_order
865 FROM $table
866 ORDER BY display_on_posting DESC, {$fields}_order";
867 $result = $db->sql_query($sql);
868
869 if ($row = $db->sql_fetchrow($result))
870 {
871 $order = 0;
872 do
873 {
874 ++$order;
875 if ($row['fields_order'] != $order)
876 {
877 $db->sql_query("UPDATE $table
878 SET {$fields}_order = $order
879 WHERE {$fields}_id = " . $row['order_id']);
880 }
881 }
882 while ($row = $db->sql_fetchrow($result));
883 }
884 $db->sql_freeresult($result);
885
886 $template->assign_vars(array(
887 'L_TITLE' => $user->lang['ACP_' . $lang],
888 'L_EXPLAIN' => $user->lang['ACP_' . $lang . '_EXPLAIN'],
889 'L_IMPORT' => $user->lang['IMPORT_' . $lang],
890 'L_EXPORT' => $user->lang['EXPORT_' . $lang],
891 'L_NOT_DISPLAYED' => $user->lang[$lang . '_NOT_DISPLAYED'],
892 'L_ICON_ADD' => $user->lang['ADD_' . $lang],
893 'L_ICON_EDIT' => $user->lang['EDIT_' . $lang],
894
895 'NOTICE' => $notice,
896 'COLSPAN' => ($mode == 'smilies') ? 5 : 3,
897
898 'S_SMILIES' => ($mode == 'smilies') ? true : false,
899
900 'U_ACTION' => $this->u_action,
901 'U_IMPORT' => $this->u_action . '&action=import',
902 'U_EXPORT' => $this->u_action . '&action=export',
903 )
904 );
905
906 $spacer = false;
907 $pagination = $phpbb_container->get('pagination');
908 $pagination_start = request_var('start', 0);
909
910 $item_count = $this->item_count($table);
911
912 $sql = "SELECT *
913 FROM $table
914 ORDER BY {$fields}_order ASC";
915 $result = $db->sql_query_limit($sql, $config['smilies_per_page'], $pagination_start);
916
917 while ($row = $db->sql_fetchrow($result))
918 {
919 $alt_text = ($mode == 'smilies') ? $row['code'] : '';
920
921 $template->assign_block_vars('items', array(
922 'S_SPACER' => (!$spacer && !$row['display_on_posting']) ? true : false,
923 'ALT_TEXT' => $alt_text,
924 'IMG_SRC' => $phpbb_root_path . $img_path . '/' . $row[$fields . '_url'],
925 'WIDTH' => $row[$fields . '_width'],
926 'HEIGHT' => $row[$fields . '_height'],
927 'CODE' => (isset($row['code'])) ? $row['code'] : '',
928 'EMOTION' => (isset($row['emotion'])) ? $row['emotion'] : '',
929 'U_EDIT' => $this->u_action . '&action=edit&id=' . $row[$fields . '_id'],
930 'U_DELETE' => $this->u_action . '&action=delete&id=' . $row[$fields . '_id'],
931 'U_MOVE_UP' => $this->u_action . '&action=move_up&id=' . $row[$fields . '_id'] . '&start=' . $pagination_start,
932 'U_MOVE_DOWN' => $this->u_action . '&action=move_down&id=' . $row[$fields . '_id'] . '&start=' . $pagination_start,
933 ));
934
935 if (!$spacer && !$row['display_on_posting'])
936 {
937 $spacer = true;
938 }
939 }
940 $db->sql_freeresult($result);
941
942 $pagination->generate_template_pagination($this->u_action, 'pagination', 'start', $item_count, $config['smilies_per_page'], $pagination_start);
943 }
944
945 /**
946 * Returns the count of smilies or icons in the database
947 *
948 * @param string $table The table of items to count.
949 * @return int number of items
950 */
951 /* private */ function item_count($table)
952 {
953 global $db;
954
955 $sql = "SELECT COUNT(*) AS item_count
956 FROM $table";
957 $result = $db->sql_query($sql);
958 $item_count = (int) $db->sql_fetchfield('item_count');
959 $db->sql_freeresult($result);
960
961 return $item_count;
962 }
963 }
964