Chris@76
|
1 <?php
|
Chris@76
|
2
|
Chris@76
|
3 /**
|
Chris@76
|
4 * Simple Machines Forum (SMF)
|
Chris@76
|
5 *
|
Chris@76
|
6 * @package SMF
|
Chris@76
|
7 * @author Simple Machines http://www.simplemachines.org
|
Chris@76
|
8 * @copyright 2011 Simple Machines
|
Chris@76
|
9 * @license http://www.simplemachines.org/about/smf/license.php BSD
|
Chris@76
|
10 *
|
Chris@76
|
11 * @version 2.0
|
Chris@76
|
12 */
|
Chris@76
|
13
|
Chris@76
|
14 if (!defined('SMF'))
|
Chris@76
|
15 die('Hacking attempt...');
|
Chris@76
|
16
|
Chris@76
|
17 /* // !!!
|
Chris@76
|
18
|
Chris@76
|
19 void ManageSmileys()
|
Chris@76
|
20 // !!!
|
Chris@76
|
21
|
Chris@76
|
22 void EditSmileySettings()
|
Chris@76
|
23 // !!!
|
Chris@76
|
24
|
Chris@76
|
25 void EditSmileySets()
|
Chris@76
|
26 // !!!
|
Chris@76
|
27
|
Chris@76
|
28 void AddSmiley()
|
Chris@76
|
29 // !!!
|
Chris@76
|
30
|
Chris@76
|
31 void EditSmileys()
|
Chris@76
|
32 // !!!
|
Chris@76
|
33
|
Chris@76
|
34 void EditSmileyOrder()
|
Chris@76
|
35 // !!!
|
Chris@76
|
36
|
Chris@76
|
37 void InstallSmileySet()
|
Chris@76
|
38 // !!!
|
Chris@76
|
39
|
Chris@76
|
40 void ImportSmileys($smileyPath)
|
Chris@76
|
41 // !!!
|
Chris@76
|
42
|
Chris@76
|
43 void sortSmileyTable()
|
Chris@76
|
44 // !!!
|
Chris@76
|
45 */
|
Chris@76
|
46
|
Chris@76
|
47 function ManageSmileys()
|
Chris@76
|
48 {
|
Chris@76
|
49 global $context, $txt, $scripturl, $modSettings;
|
Chris@76
|
50
|
Chris@76
|
51 isAllowedTo('manage_smileys');
|
Chris@76
|
52
|
Chris@76
|
53 loadLanguage('ManageSmileys');
|
Chris@76
|
54 loadTemplate('ManageSmileys');
|
Chris@76
|
55
|
Chris@76
|
56 $subActions = array(
|
Chris@76
|
57 'addsmiley' => 'AddSmiley',
|
Chris@76
|
58 'editicon' => 'EditMessageIcons',
|
Chris@76
|
59 'editicons' => 'EditMessageIcons',
|
Chris@76
|
60 'editsets' => 'EditSmileySets',
|
Chris@76
|
61 'editsmileys' => 'EditSmileys',
|
Chris@76
|
62 'import' => 'EditSmileySets',
|
Chris@76
|
63 'modifyset' => 'EditSmileySets',
|
Chris@76
|
64 'modifysmiley' => 'EditSmileys',
|
Chris@76
|
65 'setorder' => 'EditSmileyOrder',
|
Chris@76
|
66 'settings' => 'EditSmileySettings',
|
Chris@76
|
67 'install' => 'InstallSmileySet'
|
Chris@76
|
68 );
|
Chris@76
|
69
|
Chris@76
|
70 // Default the sub-action to 'edit smiley settings'.
|
Chris@76
|
71 $_REQUEST['sa'] = isset($_REQUEST['sa']) && isset($subActions[$_REQUEST['sa']]) ? $_REQUEST['sa'] : 'editsets';
|
Chris@76
|
72
|
Chris@76
|
73 $context['page_title'] = $txt['smileys_manage'];
|
Chris@76
|
74 $context['sub_action'] = $_REQUEST['sa'];
|
Chris@76
|
75 $context['sub_template'] = $context['sub_action'];
|
Chris@76
|
76
|
Chris@76
|
77 // Load up all the tabs...
|
Chris@76
|
78 $context[$context['admin_menu_name']]['tab_data'] = array(
|
Chris@76
|
79 'title' => $txt['smileys_manage'],
|
Chris@76
|
80 'help' => 'smileys',
|
Chris@76
|
81 'description' => $txt['smiley_settings_explain'],
|
Chris@76
|
82 'tabs' => array(
|
Chris@76
|
83 'editsets' => array(
|
Chris@76
|
84 'description' => $txt['smiley_editsets_explain'],
|
Chris@76
|
85 ),
|
Chris@76
|
86 'addsmiley' => array(
|
Chris@76
|
87 'description' => $txt['smiley_addsmiley_explain'],
|
Chris@76
|
88 ),
|
Chris@76
|
89 'editsmileys' => array(
|
Chris@76
|
90 'description' => $txt['smiley_editsmileys_explain'],
|
Chris@76
|
91 ),
|
Chris@76
|
92 'setorder' => array(
|
Chris@76
|
93 'description' => $txt['smiley_setorder_explain'],
|
Chris@76
|
94 ),
|
Chris@76
|
95 'editicons' => array(
|
Chris@76
|
96 'description' => $txt['icons_edit_icons_explain'],
|
Chris@76
|
97 ),
|
Chris@76
|
98 'settings' => array(
|
Chris@76
|
99 'description' => $txt['smiley_settings_explain'],
|
Chris@76
|
100 ),
|
Chris@76
|
101 ),
|
Chris@76
|
102 );
|
Chris@76
|
103
|
Chris@76
|
104 // Some settings may not be enabled, disallow these from the tabs as appropriate.
|
Chris@76
|
105 if (empty($modSettings['messageIcons_enable']))
|
Chris@76
|
106 $context[$context['admin_menu_name']]['tab_data']['tabs']['editicons']['disabled'] = true;
|
Chris@76
|
107 if (empty($modSettings['smiley_enable']))
|
Chris@76
|
108 {
|
Chris@76
|
109 $context[$context['admin_menu_name']]['tab_data']['tabs']['addsmiley']['disabled'] = true;
|
Chris@76
|
110 $context[$context['admin_menu_name']]['tab_data']['tabs']['editsmileys']['disabled'] = true;
|
Chris@76
|
111 $context[$context['admin_menu_name']]['tab_data']['tabs']['setorder']['disabled'] = true;
|
Chris@76
|
112 }
|
Chris@76
|
113
|
Chris@76
|
114 // Call the right function for this sub-acton.
|
Chris@76
|
115 $subActions[$_REQUEST['sa']]();
|
Chris@76
|
116 }
|
Chris@76
|
117
|
Chris@76
|
118 function EditSmileySettings($return_config = false)
|
Chris@76
|
119 {
|
Chris@76
|
120 global $modSettings, $context, $settings, $txt, $boarddir, $sourcedir, $scripturl;
|
Chris@76
|
121
|
Chris@76
|
122 // The directories...
|
Chris@76
|
123 $context['smileys_dir'] = empty($modSettings['smileys_dir']) ? $boarddir . '/Smileys' : $modSettings['smileys_dir'];
|
Chris@76
|
124 $context['smileys_dir_found'] = is_dir($context['smileys_dir']);
|
Chris@76
|
125
|
Chris@76
|
126 // Get the names of the smiley sets.
|
Chris@76
|
127 $smiley_sets = explode(',', $modSettings['smiley_sets_known']);
|
Chris@76
|
128 $set_names = explode("\n", $modSettings['smiley_sets_names']);
|
Chris@76
|
129
|
Chris@76
|
130 $smiley_context = array();
|
Chris@76
|
131 foreach ($smiley_sets as $i => $set)
|
Chris@76
|
132 $smiley_context[$set] = $set_names[$i];
|
Chris@76
|
133
|
Chris@76
|
134 // All the settings for the page...
|
Chris@76
|
135 $config_vars = array(
|
Chris@76
|
136 array('title', 'settings'),
|
Chris@76
|
137 // Inline permissions.
|
Chris@76
|
138 array('permissions', 'manage_smileys'),
|
Chris@76
|
139 '',
|
Chris@76
|
140 array('select', 'smiley_sets_default', $smiley_context),
|
Chris@76
|
141 array('check', 'smiley_sets_enable'),
|
Chris@76
|
142 array('check', 'smiley_enable', 'subtext' => $txt['smileys_enable_note']),
|
Chris@76
|
143 array('text', 'smileys_url'),
|
Chris@76
|
144 array('text', 'smileys_dir', 'invalid' => !$context['smileys_dir_found']),
|
Chris@76
|
145 '',
|
Chris@76
|
146 // Message icons.
|
Chris@76
|
147 array('check', 'messageIcons_enable', 'subtext' => $txt['setting_messageIcons_enable_note']),
|
Chris@76
|
148 );
|
Chris@76
|
149
|
Chris@76
|
150 if ($return_config)
|
Chris@76
|
151 return $config_vars;
|
Chris@76
|
152
|
Chris@76
|
153 // Setup the basics of the settings template.
|
Chris@76
|
154 require_once($sourcedir . '/ManageServer.php');
|
Chris@76
|
155 $context['sub_template'] = 'show_settings';
|
Chris@76
|
156
|
Chris@76
|
157 // Finish up the form...
|
Chris@76
|
158 $context['post_url'] = $scripturl . '?action=admin;area=smileys;save;sa=settings';
|
Chris@76
|
159 $context['permissions_excluded'] = array(-1);
|
Chris@76
|
160
|
Chris@76
|
161 // Saving the settings?
|
Chris@76
|
162 if (isset($_GET['save']))
|
Chris@76
|
163 {
|
Chris@76
|
164 checkSession();
|
Chris@76
|
165
|
Chris@76
|
166 // Validate the smiley set name.
|
Chris@76
|
167 $_POST['smiley_sets_default'] = empty($smiley_context[$_POST['smiley_sets_default']]) ? 'default' : $_POST['smiley_sets_default'];
|
Chris@76
|
168
|
Chris@76
|
169 // Make sure that the smileys are in the right order after enabling them.
|
Chris@76
|
170 if (isset($_POST['smiley_enable']))
|
Chris@76
|
171 sortSmileyTable();
|
Chris@76
|
172
|
Chris@76
|
173 saveDBSettings($config_vars);
|
Chris@76
|
174
|
Chris@76
|
175 cache_put_data('parsing_smileys', null, 480);
|
Chris@76
|
176 cache_put_data('posting_smileys', null, 480);
|
Chris@76
|
177
|
Chris@76
|
178 redirectexit('action=admin;area=smileys;sa=settings');
|
Chris@76
|
179 }
|
Chris@76
|
180
|
Chris@76
|
181 prepareDBSettingContext($config_vars);
|
Chris@76
|
182 }
|
Chris@76
|
183
|
Chris@76
|
184 function EditSmileySets()
|
Chris@76
|
185 {
|
Chris@76
|
186 global $modSettings, $context, $settings, $txt, $boarddir;
|
Chris@76
|
187 global $smcFunc, $scripturl, $sourcedir;
|
Chris@76
|
188
|
Chris@76
|
189 // Set the right tab to be selected.
|
Chris@76
|
190 $context[$context['admin_menu_name']]['current_subsection'] = 'editsets';
|
Chris@76
|
191
|
Chris@76
|
192 // They must've been submitted a form.
|
Chris@76
|
193 if (isset($_POST[$context['session_var']]))
|
Chris@76
|
194 {
|
Chris@76
|
195 checkSession();
|
Chris@76
|
196
|
Chris@76
|
197 // Delete selected smiley sets.
|
Chris@76
|
198 if (!empty($_POST['delete']) && !empty($_POST['smiley_set']))
|
Chris@76
|
199 {
|
Chris@76
|
200 $set_paths = explode(',', $modSettings['smiley_sets_known']);
|
Chris@76
|
201 $set_names = explode("\n", $modSettings['smiley_sets_names']);
|
Chris@76
|
202 foreach ($_POST['smiley_set'] as $id => $val)
|
Chris@76
|
203 if (isset($set_paths[$id], $set_names[$id]) && !empty($id))
|
Chris@76
|
204 unset($set_paths[$id], $set_names[$id]);
|
Chris@76
|
205
|
Chris@76
|
206 updateSettings(array(
|
Chris@76
|
207 'smiley_sets_known' => implode(',', $set_paths),
|
Chris@76
|
208 'smiley_sets_names' => implode("\n", $set_names),
|
Chris@76
|
209 'smiley_sets_default' => in_array($modSettings['smiley_sets_default'], $set_paths) ? $modSettings['smiley_sets_default'] : $set_paths[0],
|
Chris@76
|
210 ));
|
Chris@76
|
211
|
Chris@76
|
212 cache_put_data('parsing_smileys', null, 480);
|
Chris@76
|
213 cache_put_data('posting_smileys', null, 480);
|
Chris@76
|
214 }
|
Chris@76
|
215 // Add a new smiley set.
|
Chris@76
|
216 elseif (!empty($_POST['add']))
|
Chris@76
|
217 $context['sub_action'] = 'modifyset';
|
Chris@76
|
218 // Create or modify a smiley set.
|
Chris@76
|
219 elseif (isset($_POST['set']))
|
Chris@76
|
220 {
|
Chris@76
|
221 $set_paths = explode(',', $modSettings['smiley_sets_known']);
|
Chris@76
|
222 $set_names = explode("\n", $modSettings['smiley_sets_names']);
|
Chris@76
|
223
|
Chris@76
|
224 // Create a new smiley set.
|
Chris@76
|
225 if ($_POST['set'] == -1 && isset($_POST['smiley_sets_path']))
|
Chris@76
|
226 {
|
Chris@76
|
227 if (in_array($_POST['smiley_sets_path'], $set_paths))
|
Chris@76
|
228 fatal_lang_error('smiley_set_already_exists');
|
Chris@76
|
229
|
Chris@76
|
230 updateSettings(array(
|
Chris@76
|
231 'smiley_sets_known' => $modSettings['smiley_sets_known'] . ',' . $_POST['smiley_sets_path'],
|
Chris@76
|
232 'smiley_sets_names' => $modSettings['smiley_sets_names'] . "\n" . $_POST['smiley_sets_name'],
|
Chris@76
|
233 'smiley_sets_default' => empty($_POST['smiley_sets_default']) ? $modSettings['smiley_sets_default'] : $_POST['smiley_sets_path'],
|
Chris@76
|
234 ));
|
Chris@76
|
235 }
|
Chris@76
|
236 // Modify an existing smiley set.
|
Chris@76
|
237 else
|
Chris@76
|
238 {
|
Chris@76
|
239 // Make sure the smiley set exists.
|
Chris@76
|
240 if (!isset($set_paths[$_POST['set']]) || !isset($set_names[$_POST['set']]))
|
Chris@76
|
241 fatal_lang_error('smiley_set_not_found');
|
Chris@76
|
242
|
Chris@76
|
243 // Make sure the path is not yet used by another smileyset.
|
Chris@76
|
244 if (in_array($_POST['smiley_sets_path'], $set_paths) && $_POST['smiley_sets_path'] != $set_paths[$_POST['set']])
|
Chris@76
|
245 fatal_lang_error('smiley_set_path_already_used');
|
Chris@76
|
246
|
Chris@76
|
247 $set_paths[$_POST['set']] = $_POST['smiley_sets_path'];
|
Chris@76
|
248 $set_names[$_POST['set']] = $_POST['smiley_sets_name'];
|
Chris@76
|
249 updateSettings(array(
|
Chris@76
|
250 'smiley_sets_known' => implode(',', $set_paths),
|
Chris@76
|
251 'smiley_sets_names' => implode("\n", $set_names),
|
Chris@76
|
252 'smiley_sets_default' => empty($_POST['smiley_sets_default']) ? $modSettings['smiley_sets_default'] : $_POST['smiley_sets_path']
|
Chris@76
|
253 ));
|
Chris@76
|
254 }
|
Chris@76
|
255
|
Chris@76
|
256 // The user might have checked to also import smileys.
|
Chris@76
|
257 if (!empty($_POST['smiley_sets_import']))
|
Chris@76
|
258 ImportSmileys($_POST['smiley_sets_path']);
|
Chris@76
|
259
|
Chris@76
|
260 cache_put_data('parsing_smileys', null, 480);
|
Chris@76
|
261 cache_put_data('posting_smileys', null, 480);
|
Chris@76
|
262 }
|
Chris@76
|
263 }
|
Chris@76
|
264
|
Chris@76
|
265 // Load all available smileysets...
|
Chris@76
|
266 $context['smiley_sets'] = explode(',', $modSettings['smiley_sets_known']);
|
Chris@76
|
267 $set_names = explode("\n", $modSettings['smiley_sets_names']);
|
Chris@76
|
268 foreach ($context['smiley_sets'] as $i => $set)
|
Chris@76
|
269 $context['smiley_sets'][$i] = array(
|
Chris@76
|
270 'id' => $i,
|
Chris@76
|
271 'path' => htmlspecialchars($set),
|
Chris@76
|
272 'name' => htmlspecialchars($set_names[$i]),
|
Chris@76
|
273 'selected' => $set == $modSettings['smiley_sets_default']
|
Chris@76
|
274 );
|
Chris@76
|
275
|
Chris@76
|
276 // Importing any smileys from an existing set?
|
Chris@76
|
277 if ($context['sub_action'] == 'import')
|
Chris@76
|
278 {
|
Chris@76
|
279 checkSession('get');
|
Chris@76
|
280 $_GET['set'] = (int) $_GET['set'];
|
Chris@76
|
281
|
Chris@76
|
282 // Sanity check - then import.
|
Chris@76
|
283 if (isset($context['smiley_sets'][$_GET['set']]))
|
Chris@76
|
284 ImportSmileys(un_htmlspecialchars($context['smiley_sets'][$_GET['set']]['path']));
|
Chris@76
|
285
|
Chris@76
|
286 // Force the process to continue.
|
Chris@76
|
287 $context['sub_action'] = 'modifyset';
|
Chris@76
|
288 $context['sub_template'] = 'modifyset';
|
Chris@76
|
289 }
|
Chris@76
|
290 // If we're modifying or adding a smileyset, some context info needs to be set.
|
Chris@76
|
291 if ($context['sub_action'] == 'modifyset')
|
Chris@76
|
292 {
|
Chris@76
|
293 $_GET['set'] = !isset($_GET['set']) ? -1 : (int) $_GET['set'];
|
Chris@76
|
294 if ($_GET['set'] == -1 || !isset($context['smiley_sets'][$_GET['set']]))
|
Chris@76
|
295 $context['current_set'] = array(
|
Chris@76
|
296 'id' => '-1',
|
Chris@76
|
297 'path' => '',
|
Chris@76
|
298 'name' => '',
|
Chris@76
|
299 'selected' => false,
|
Chris@76
|
300 'is_new' => true,
|
Chris@76
|
301 );
|
Chris@76
|
302 else
|
Chris@76
|
303 {
|
Chris@76
|
304 $context['current_set'] = &$context['smiley_sets'][$_GET['set']];
|
Chris@76
|
305 $context['current_set']['is_new'] = false;
|
Chris@76
|
306
|
Chris@76
|
307 // Calculate whether there are any smileys in the directory that can be imported.
|
Chris@76
|
308 if (!empty($modSettings['smiley_enable']) && !empty($modSettings['smileys_dir']) && is_dir($modSettings['smileys_dir'] . '/' . $context['current_set']['path']))
|
Chris@76
|
309 {
|
Chris@76
|
310 $smileys = array();
|
Chris@76
|
311 $dir = dir($modSettings['smileys_dir'] . '/' . $context['current_set']['path']);
|
Chris@76
|
312 while ($entry = $dir->read())
|
Chris@76
|
313 {
|
Chris@76
|
314 if (in_array(strrchr($entry, '.'), array('.jpg', '.gif', '.jpeg', '.png')))
|
Chris@76
|
315 $smileys[strtolower($entry)] = $entry;
|
Chris@76
|
316 }
|
Chris@76
|
317 $dir->close();
|
Chris@76
|
318
|
Chris@76
|
319 // Exclude the smileys that are already in the database.
|
Chris@76
|
320 $request = $smcFunc['db_query']('', '
|
Chris@76
|
321 SELECT filename
|
Chris@76
|
322 FROM {db_prefix}smileys
|
Chris@76
|
323 WHERE filename IN ({array_string:smiley_list})',
|
Chris@76
|
324 array(
|
Chris@76
|
325 'smiley_list' => $smileys,
|
Chris@76
|
326 )
|
Chris@76
|
327 );
|
Chris@76
|
328 while ($row = $smcFunc['db_fetch_assoc']($request))
|
Chris@76
|
329 if (isset($smileys[strtolower($row['filename'])]))
|
Chris@76
|
330 unset($smileys[strtolower($row['filename'])]);
|
Chris@76
|
331 $smcFunc['db_free_result']($request);
|
Chris@76
|
332
|
Chris@76
|
333 $context['current_set']['can_import'] = count($smileys);
|
Chris@76
|
334 // Setup this string to look nice.
|
Chris@76
|
335 $txt['smiley_set_import_multiple'] = sprintf($txt['smiley_set_import_multiple'], $context['current_set']['can_import']);
|
Chris@76
|
336 }
|
Chris@76
|
337 }
|
Chris@76
|
338
|
Chris@76
|
339 // Retrieve all potential smiley set directories.
|
Chris@76
|
340 $context['smiley_set_dirs'] = array();
|
Chris@76
|
341 if (!empty($modSettings['smileys_dir']) && is_dir($modSettings['smileys_dir']))
|
Chris@76
|
342 {
|
Chris@76
|
343 $dir = dir($modSettings['smileys_dir']);
|
Chris@76
|
344 while ($entry = $dir->read())
|
Chris@76
|
345 {
|
Chris@76
|
346 if (!in_array($entry, array('.', '..')) && is_dir($modSettings['smileys_dir'] . '/' . $entry))
|
Chris@76
|
347 $context['smiley_set_dirs'][] = array(
|
Chris@76
|
348 'id' => $entry,
|
Chris@76
|
349 'path' => $modSettings['smileys_dir'] . '/' . $entry,
|
Chris@76
|
350 'selectable' => $entry == $context['current_set']['path'] || !in_array($entry, explode(',', $modSettings['smiley_sets_known'])),
|
Chris@76
|
351 'current' => $entry == $context['current_set']['path'],
|
Chris@76
|
352 );
|
Chris@76
|
353 }
|
Chris@76
|
354 $dir->close();
|
Chris@76
|
355 }
|
Chris@76
|
356 }
|
Chris@76
|
357
|
Chris@76
|
358 $listOptions = array(
|
Chris@76
|
359 'id' => 'smiley_set_list',
|
Chris@76
|
360 'base_href' => $scripturl . '?action=admin;area=smileys;sa=editsets',
|
Chris@76
|
361 'default_sort_col' => 'default',
|
Chris@76
|
362 'get_items' => array(
|
Chris@76
|
363 'function' => 'list_getSmileySets',
|
Chris@76
|
364 ),
|
Chris@76
|
365 'get_count' => array(
|
Chris@76
|
366 'function' => 'list_getNumSmileySets',
|
Chris@76
|
367 ),
|
Chris@76
|
368 'columns' => array(
|
Chris@76
|
369 'default' => array(
|
Chris@76
|
370 'header' => array(
|
Chris@76
|
371 'value' => $txt['smiley_sets_default'],
|
Chris@76
|
372 ),
|
Chris@76
|
373 'data' => array(
|
Chris@76
|
374 'function' => create_function('$rowData', '
|
Chris@76
|
375 return $rowData[\'selected\'] ? \'<strong>*</strong>\' : \'\';
|
Chris@76
|
376 '),
|
Chris@76
|
377 'style' => 'text-align: center;',
|
Chris@76
|
378 ),
|
Chris@76
|
379 'sort' => array(
|
Chris@76
|
380 'default' => 'selected DESC',
|
Chris@76
|
381 ),
|
Chris@76
|
382 ),
|
Chris@76
|
383 'name' => array(
|
Chris@76
|
384 'header' => array(
|
Chris@76
|
385 'value' => $txt['smiley_sets_name'],
|
Chris@76
|
386 ),
|
Chris@76
|
387 'data' => array(
|
Chris@76
|
388 'db_htmlsafe' => 'name',
|
Chris@76
|
389 'class' => 'windowbg',
|
Chris@76
|
390 ),
|
Chris@76
|
391 'sort' => array(
|
Chris@76
|
392 'default' => 'name',
|
Chris@76
|
393 'reverse' => 'name DESC',
|
Chris@76
|
394 ),
|
Chris@76
|
395 ),
|
Chris@76
|
396 'url' => array(
|
Chris@76
|
397 'header' => array(
|
Chris@76
|
398 'value' => $txt['smiley_sets_url'],
|
Chris@76
|
399 ),
|
Chris@76
|
400 'data' => array(
|
Chris@76
|
401 'sprintf' => array(
|
Chris@76
|
402 'format' => $modSettings['smileys_url'] . '/<strong>%1$s</strong>/...',
|
Chris@76
|
403 'params' => array(
|
Chris@76
|
404 'path' => true,
|
Chris@76
|
405 ),
|
Chris@76
|
406 ),
|
Chris@76
|
407 'class' => 'windowbg',
|
Chris@76
|
408 ),
|
Chris@76
|
409 'sort' => array(
|
Chris@76
|
410 'default' => 'path',
|
Chris@76
|
411 'reverse' => 'path DESC',
|
Chris@76
|
412 ),
|
Chris@76
|
413 ),
|
Chris@76
|
414 'modify' => array(
|
Chris@76
|
415 'header' => array(
|
Chris@76
|
416 'value' => $txt['smiley_set_modify'],
|
Chris@76
|
417 ),
|
Chris@76
|
418 'data' => array(
|
Chris@76
|
419 'sprintf' => array(
|
Chris@76
|
420 'format' => '<a href="' . $scripturl . '?action=admin;area=smileys;sa=modifyset;set=%1$d">' . $txt['smiley_set_modify'] . '</a>',
|
Chris@76
|
421 'params' => array(
|
Chris@76
|
422 'id' => true,
|
Chris@76
|
423 ),
|
Chris@76
|
424 ),
|
Chris@76
|
425 'style' => 'text-align: center;',
|
Chris@76
|
426 ),
|
Chris@76
|
427 ),
|
Chris@76
|
428 'check' => array(
|
Chris@76
|
429 'header' => array(
|
Chris@76
|
430 'value' => '<input type="checkbox" onclick="invertAll(this, this.form);" class="input_check" />',
|
Chris@76
|
431 ),
|
Chris@76
|
432 'data' => array(
|
Chris@76
|
433 'function' => create_function('$rowData', '
|
Chris@76
|
434 return $rowData[\'id\'] == 0 ? \'\' : sprintf(\'<input type="checkbox" name="smiley_set[%1$d]" class="input_check" />\', $rowData[\'id\']);
|
Chris@76
|
435 '),
|
Chris@76
|
436 'style' => 'text-align: center',
|
Chris@76
|
437 ),
|
Chris@76
|
438 ),
|
Chris@76
|
439 ),
|
Chris@76
|
440 'form' => array(
|
Chris@76
|
441 'href' => $scripturl . '?action=admin;area=smileys;sa=editsets',
|
Chris@76
|
442 ),
|
Chris@76
|
443 'additional_rows' => array(
|
Chris@76
|
444 array(
|
Chris@76
|
445 'position' => 'below_table_data',
|
Chris@76
|
446 'value' => '<input type="submit" name="delete" value="' . $txt['smiley_sets_delete'] . '" onclick="return confirm(\'' . $txt['smiley_sets_confirm'] . '\');" style="float: right;" class="button_submit" /> [<a href="' . $scripturl . '?action=admin;area=smileys;sa=modifyset' . '">' . $txt['smiley_sets_add'] . '</a>]',
|
Chris@76
|
447 ),
|
Chris@76
|
448 ),
|
Chris@76
|
449 );
|
Chris@76
|
450
|
Chris@76
|
451 require_once($sourcedir . '/Subs-List.php');
|
Chris@76
|
452 createList($listOptions);
|
Chris@76
|
453 }
|
Chris@76
|
454
|
Chris@76
|
455 // !!! to be moved to Subs-Smileys.
|
Chris@76
|
456 function list_getSmileySets($start, $items_per_page, $sort)
|
Chris@76
|
457 {
|
Chris@76
|
458 global $modSettings;
|
Chris@76
|
459
|
Chris@76
|
460 $known_sets = explode(',', $modSettings['smiley_sets_known']);
|
Chris@76
|
461 $set_names = explode("\n", $modSettings['smiley_sets_names']);
|
Chris@76
|
462 $cols = array(
|
Chris@76
|
463 'id' => array(),
|
Chris@76
|
464 'selected' => array(),
|
Chris@76
|
465 'path' => array(),
|
Chris@76
|
466 'name' => array(),
|
Chris@76
|
467 );
|
Chris@76
|
468 foreach ($known_sets as $i => $set)
|
Chris@76
|
469 {
|
Chris@76
|
470 $cols['id'][] = $i;
|
Chris@76
|
471 $cols['selected'][] = $i;
|
Chris@76
|
472 $cols['path'][] = $set;
|
Chris@76
|
473 $cols['name'][] = $set_names[$i];
|
Chris@76
|
474 }
|
Chris@76
|
475 $sort_flag = strpos($sort, 'DESC') === false ? SORT_ASC : SORT_DESC;
|
Chris@76
|
476 if (substr($sort, 0, 4) === 'name')
|
Chris@76
|
477 array_multisort($cols['name'], $sort_flag, SORT_REGULAR, $cols['path'], $cols['selected'], $cols['id']);
|
Chris@76
|
478 elseif (substr($sort, 0, 4) === 'path')
|
Chris@76
|
479 array_multisort($cols['path'], $sort_flag, SORT_REGULAR, $cols['name'], $cols['selected'], $cols['id']);
|
Chris@76
|
480 else
|
Chris@76
|
481 array_multisort($cols['selected'], $sort_flag, SORT_REGULAR, $cols['path'], $cols['name'], $cols['id']);
|
Chris@76
|
482
|
Chris@76
|
483 $smiley_sets = array();
|
Chris@76
|
484 foreach ($cols['id'] as $i => $id)
|
Chris@76
|
485 $smiley_sets[] = array(
|
Chris@76
|
486 'id' => $id,
|
Chris@76
|
487 'path' => $cols['path'][$i],
|
Chris@76
|
488 'name' => $cols['name'][$i],
|
Chris@76
|
489 'selected' => $cols['path'][$i] == $modSettings['smiley_sets_default']
|
Chris@76
|
490 );
|
Chris@76
|
491
|
Chris@76
|
492 return $smiley_sets;
|
Chris@76
|
493 }
|
Chris@76
|
494
|
Chris@76
|
495 // !!! to be moved to Subs-Smileys.
|
Chris@76
|
496 function list_getNumSmileySets()
|
Chris@76
|
497 {
|
Chris@76
|
498 global $modSettings;
|
Chris@76
|
499
|
Chris@76
|
500 return count(explode(',', $modSettings['smiley_sets_known']));
|
Chris@76
|
501 }
|
Chris@76
|
502
|
Chris@76
|
503 function AddSmiley()
|
Chris@76
|
504 {
|
Chris@76
|
505 global $modSettings, $context, $settings, $txt, $boarddir, $smcFunc;
|
Chris@76
|
506
|
Chris@76
|
507 // Get a list of all known smiley sets.
|
Chris@76
|
508 $context['smileys_dir'] = empty($modSettings['smileys_dir']) ? $boarddir . '/Smileys' : $modSettings['smileys_dir'];
|
Chris@76
|
509 $context['smileys_dir_found'] = is_dir($context['smileys_dir']);
|
Chris@76
|
510 $context['smiley_sets'] = explode(',', $modSettings['smiley_sets_known']);
|
Chris@76
|
511 $set_names = explode("\n", $modSettings['smiley_sets_names']);
|
Chris@76
|
512 foreach ($context['smiley_sets'] as $i => $set)
|
Chris@76
|
513 $context['smiley_sets'][$i] = array(
|
Chris@76
|
514 'id' => $i,
|
Chris@76
|
515 'path' => htmlspecialchars($set),
|
Chris@76
|
516 'name' => htmlspecialchars($set_names[$i]),
|
Chris@76
|
517 'selected' => $set == $modSettings['smiley_sets_default']
|
Chris@76
|
518 );
|
Chris@76
|
519
|
Chris@76
|
520 // Submitting a form?
|
Chris@76
|
521 if (isset($_POST[$context['session_var']], $_POST['smiley_code']))
|
Chris@76
|
522 {
|
Chris@76
|
523 checkSession();
|
Chris@76
|
524
|
Chris@76
|
525 // Some useful arrays... types we allow - and ports we don't!
|
Chris@76
|
526 $allowedTypes = array('jpeg', 'jpg', 'gif', 'png', 'bmp');
|
Chris@76
|
527 $disabledFiles = array('con', 'com1', 'com2', 'com3', 'com4', 'prn', 'aux', 'lpt1', '.htaccess', 'index.php');
|
Chris@76
|
528
|
Chris@76
|
529 $_POST['smiley_code'] = htmltrim__recursive($_POST['smiley_code']);
|
Chris@76
|
530 $_POST['smiley_location'] = empty($_POST['smiley_location']) || $_POST['smiley_location'] > 2 || $_POST['smiley_location'] < 0 ? 0 : (int) $_POST['smiley_location'];
|
Chris@76
|
531 $_POST['smiley_filename'] = htmltrim__recursive($_POST['smiley_filename']);
|
Chris@76
|
532
|
Chris@76
|
533 // Make sure some code was entered.
|
Chris@76
|
534 if (empty($_POST['smiley_code']))
|
Chris@76
|
535 fatal_lang_error('smiley_has_no_code');
|
Chris@76
|
536
|
Chris@76
|
537 // Check whether the new code has duplicates. It should be unique.
|
Chris@76
|
538 $request = $smcFunc['db_query']('', '
|
Chris@76
|
539 SELECT id_smiley
|
Chris@76
|
540 FROM {db_prefix}smileys
|
Chris@76
|
541 WHERE code = {raw:mysql_binary_statement} {string:smiley_code}',
|
Chris@76
|
542 array(
|
Chris@76
|
543 'mysql_binary_statement' => $smcFunc['db_title'] == 'MySQL' ? 'BINARY' : '',
|
Chris@76
|
544 'smiley_code' => $_POST['smiley_code'],
|
Chris@76
|
545 )
|
Chris@76
|
546 );
|
Chris@76
|
547 if ($smcFunc['db_num_rows']($request) > 0)
|
Chris@76
|
548 fatal_lang_error('smiley_not_unique');
|
Chris@76
|
549 $smcFunc['db_free_result']($request);
|
Chris@76
|
550
|
Chris@76
|
551 // If we are uploading - check all the smiley sets are writable!
|
Chris@76
|
552 if ($_POST['method'] != 'existing')
|
Chris@76
|
553 {
|
Chris@76
|
554 $writeErrors = array();
|
Chris@76
|
555 foreach ($context['smiley_sets'] as $set)
|
Chris@76
|
556 {
|
Chris@76
|
557 if (!is_writable($context['smileys_dir'] . '/' . un_htmlspecialchars($set['path'])))
|
Chris@76
|
558 $writeErrors[] = $set['path'];
|
Chris@76
|
559 }
|
Chris@76
|
560 if (!empty($writeErrors))
|
Chris@76
|
561 fatal_lang_error('smileys_upload_error_notwritable', true, array(implode(', ', $writeErrors)));
|
Chris@76
|
562 }
|
Chris@76
|
563
|
Chris@76
|
564 // Uploading just one smiley for all of them?
|
Chris@76
|
565 if (isset($_POST['sameall']) && isset($_FILES['uploadSmiley']['name']) && $_FILES['uploadSmiley']['name'] != '')
|
Chris@76
|
566 {
|
Chris@76
|
567 if (!is_uploaded_file($_FILES['uploadSmiley']['tmp_name']) || (@ini_get('open_basedir') == '' && !file_exists($_FILES['uploadSmiley']['tmp_name'])))
|
Chris@76
|
568 fatal_lang_error('smileys_upload_error');
|
Chris@76
|
569
|
Chris@76
|
570 // Sorry, no spaces, dots, or anything else but letters allowed.
|
Chris@76
|
571 $_FILES['uploadSmiley']['name'] = preg_replace(array('/\s/', '/\.[\.]+/', '/[^\w_\.\-]/'), array('_', '.', ''), $_FILES['uploadSmiley']['name']);
|
Chris@76
|
572
|
Chris@76
|
573 // We only allow image files - it's THAT simple - no messing around here...
|
Chris@76
|
574 if (!in_array(strtolower(substr(strrchr($_FILES['uploadSmiley']['name'], '.'), 1)), $allowedTypes))
|
Chris@76
|
575 fatal_lang_error('smileys_upload_error_types', false, array(implode(', ', $allowedTypes)));
|
Chris@76
|
576
|
Chris@76
|
577 // We only need the filename...
|
Chris@76
|
578 $destName = basename($_FILES['uploadSmiley']['name']);
|
Chris@76
|
579
|
Chris@76
|
580 // Make sure they aren't trying to upload a nasty file - for their own good here!
|
Chris@76
|
581 if (in_array(strtolower($destName), $disabledFiles))
|
Chris@76
|
582 fatal_lang_error('smileys_upload_error_illegal');
|
Chris@76
|
583
|
Chris@76
|
584 // Check if the file already exists... and if not move it to EVERY smiley set directory.
|
Chris@76
|
585 $i = 0;
|
Chris@76
|
586 // Keep going until we find a set the file doesn't exist in. (or maybe it exists in all of them?)
|
Chris@76
|
587 while (isset($context['smiley_sets'][$i]) && file_exists($context['smileys_dir'] . '/' . un_htmlspecialchars($context['smiley_sets'][$i]['path']) . '/' . $destName))
|
Chris@76
|
588 $i++;
|
Chris@76
|
589
|
Chris@76
|
590 // Okay, we're going to put the smiley right here, since it's not there yet!
|
Chris@76
|
591 if (isset($context['smiley_sets'][$i]['path']))
|
Chris@76
|
592 {
|
Chris@76
|
593 $smileyLocation = $context['smileys_dir'] . '/' . un_htmlspecialchars($context['smiley_sets'][$i]['path']) . '/' . $destName;
|
Chris@76
|
594 move_uploaded_file($_FILES['uploadSmiley']['tmp_name'], $smileyLocation);
|
Chris@76
|
595 @chmod($smileyLocation, 0644);
|
Chris@76
|
596
|
Chris@76
|
597 // Now, we want to move it from there to all the other sets.
|
Chris@76
|
598 for ($n = count($context['smiley_sets']); $i < $n; $i++)
|
Chris@76
|
599 {
|
Chris@76
|
600 $currentPath = $context['smileys_dir'] . '/' . un_htmlspecialchars($context['smiley_sets'][$i]['path']) . '/' . $destName;
|
Chris@76
|
601
|
Chris@76
|
602 // The file is already there! Don't overwrite it!
|
Chris@76
|
603 if (file_exists($currentPath))
|
Chris@76
|
604 continue;
|
Chris@76
|
605
|
Chris@76
|
606 // Okay, so copy the first one we made to here.
|
Chris@76
|
607 copy($smileyLocation, $currentPath);
|
Chris@76
|
608 @chmod($currentPath, 0644);
|
Chris@76
|
609 }
|
Chris@76
|
610 }
|
Chris@76
|
611
|
Chris@76
|
612 // Finally make sure it's saved correctly!
|
Chris@76
|
613 $_POST['smiley_filename'] = $destName;
|
Chris@76
|
614 }
|
Chris@76
|
615 // What about uploading several files?
|
Chris@76
|
616 elseif ($_POST['method'] != 'existing')
|
Chris@76
|
617 {
|
Chris@76
|
618 foreach ($_FILES as $name => $data)
|
Chris@76
|
619 {
|
Chris@76
|
620 if ($_FILES[$name]['name'] == '')
|
Chris@76
|
621 fatal_lang_error('smileys_upload_error_blank');
|
Chris@76
|
622
|
Chris@76
|
623 if (empty($newName))
|
Chris@76
|
624 $newName = basename($_FILES[$name]['name']);
|
Chris@76
|
625 elseif (basename($_FILES[$name]['name']) != $newName)
|
Chris@76
|
626 fatal_lang_error('smileys_upload_error_name');
|
Chris@76
|
627 }
|
Chris@76
|
628
|
Chris@76
|
629 foreach ($context['smiley_sets'] as $i => $set)
|
Chris@76
|
630 {
|
Chris@76
|
631 $set['name'] = un_htmlspecialchars($set['name']);
|
Chris@76
|
632 $set['path'] = un_htmlspecialchars($set['path']);
|
Chris@76
|
633
|
Chris@76
|
634 if (!isset($_FILES['individual_' . $set['name']]['name']) || $_FILES['individual_' . $set['name']]['name'] == '')
|
Chris@76
|
635 continue;
|
Chris@76
|
636
|
Chris@76
|
637 // Got one...
|
Chris@76
|
638 if (!is_uploaded_file($_FILES['individual_' . $set['name']]['tmp_name']) || (@ini_get('open_basedir') == '' && !file_exists($_FILES['individual_' . $set['name']]['tmp_name'])))
|
Chris@76
|
639 fatal_lang_error('smileys_upload_error');
|
Chris@76
|
640
|
Chris@76
|
641 // Sorry, no spaces, dots, or anything else but letters allowed.
|
Chris@76
|
642 $_FILES['individual_' . $set['name']]['name'] = preg_replace(array('/\s/', '/\.[\.]+/', '/[^\w_\.\-]/'), array('_', '.', ''), $_FILES['individual_' . $set['name']]['name']);
|
Chris@76
|
643
|
Chris@76
|
644 // We only allow image files - it's THAT simple - no messing around here...
|
Chris@76
|
645 if (!in_array(strtolower(substr(strrchr($_FILES['individual_' . $set['name']]['name'], '.'), 1)), $allowedTypes))
|
Chris@76
|
646 fatal_lang_error('smileys_upload_error_types', false, array(implode(', ', $allowedTypes)));
|
Chris@76
|
647
|
Chris@76
|
648 // We only need the filename...
|
Chris@76
|
649 $destName = basename($_FILES['individual_' . $set['name']]['name']);
|
Chris@76
|
650
|
Chris@76
|
651 // Make sure they aren't trying to upload a nasty file - for their own good here!
|
Chris@76
|
652 if (in_array(strtolower($destName), $disabledFiles))
|
Chris@76
|
653 fatal_lang_error('smileys_upload_error_illegal');
|
Chris@76
|
654
|
Chris@76
|
655 // If the file exists - ignore it.
|
Chris@76
|
656 $smileyLocation = $context['smileys_dir'] . '/' . $set['path'] . '/' . $destName;
|
Chris@76
|
657 if (file_exists($smileyLocation))
|
Chris@76
|
658 continue;
|
Chris@76
|
659
|
Chris@76
|
660 // Finally - move the image!
|
Chris@76
|
661 move_uploaded_file($_FILES['individual_' . $set['name']]['tmp_name'], $smileyLocation);
|
Chris@76
|
662 @chmod($smileyLocation, 0644);
|
Chris@76
|
663
|
Chris@76
|
664 // Should always be saved correctly!
|
Chris@76
|
665 $_POST['smiley_filename'] = $destName;
|
Chris@76
|
666 }
|
Chris@76
|
667 }
|
Chris@76
|
668
|
Chris@76
|
669 // Also make sure a filename was given.
|
Chris@76
|
670 if (empty($_POST['smiley_filename']))
|
Chris@76
|
671 fatal_lang_error('smiley_has_no_filename');
|
Chris@76
|
672
|
Chris@76
|
673 // Find the position on the right.
|
Chris@76
|
674 $smiley_order = '0';
|
Chris@76
|
675 if ($_POST['smiley_location'] != 1)
|
Chris@76
|
676 {
|
Chris@76
|
677 $request = $smcFunc['db_query']('', '
|
Chris@76
|
678 SELECT MAX(smiley_order) + 1
|
Chris@76
|
679 FROM {db_prefix}smileys
|
Chris@76
|
680 WHERE hidden = {int:smiley_location}
|
Chris@76
|
681 AND smiley_row = {int:first_row}',
|
Chris@76
|
682 array(
|
Chris@76
|
683 'smiley_location' => $_POST['smiley_location'],
|
Chris@76
|
684 'first_row' => 0,
|
Chris@76
|
685 )
|
Chris@76
|
686 );
|
Chris@76
|
687 list ($smiley_order) = $smcFunc['db_fetch_row']($request);
|
Chris@76
|
688 $smcFunc['db_free_result']($request);
|
Chris@76
|
689
|
Chris@76
|
690 if (empty($smiley_order))
|
Chris@76
|
691 $smiley_order = '0';
|
Chris@76
|
692 }
|
Chris@76
|
693 $smcFunc['db_insert']('',
|
Chris@76
|
694 '{db_prefix}smileys',
|
Chris@76
|
695 array(
|
Chris@76
|
696 'code' => 'string-30', 'filename' => 'string-48', 'description' => 'string-80', 'hidden' => 'int', 'smiley_order' => 'int',
|
Chris@76
|
697 ),
|
Chris@76
|
698 array(
|
Chris@76
|
699 $_POST['smiley_code'], $_POST['smiley_filename'], $_POST['smiley_description'], $_POST['smiley_location'], $smiley_order,
|
Chris@76
|
700 ),
|
Chris@76
|
701 array('id_smiley')
|
Chris@76
|
702 );
|
Chris@76
|
703
|
Chris@76
|
704 cache_put_data('parsing_smileys', null, 480);
|
Chris@76
|
705 cache_put_data('posting_smileys', null, 480);
|
Chris@76
|
706
|
Chris@76
|
707 // No errors? Out of here!
|
Chris@76
|
708 redirectexit('action=admin;area=smileys;sa=editsmileys');
|
Chris@76
|
709 }
|
Chris@76
|
710
|
Chris@76
|
711 $context['selected_set'] = $modSettings['smiley_sets_default'];
|
Chris@76
|
712
|
Chris@76
|
713 // Get all possible filenames for the smileys.
|
Chris@76
|
714 $context['filenames'] = array();
|
Chris@76
|
715 if ($context['smileys_dir_found'])
|
Chris@76
|
716 {
|
Chris@76
|
717 foreach ($context['smiley_sets'] as $smiley_set)
|
Chris@76
|
718 {
|
Chris@76
|
719 if (!file_exists($context['smileys_dir'] . '/' . un_htmlspecialchars($smiley_set['path'])))
|
Chris@76
|
720 continue;
|
Chris@76
|
721
|
Chris@76
|
722 $dir = dir($context['smileys_dir'] . '/' . un_htmlspecialchars($smiley_set['path']));
|
Chris@76
|
723 while ($entry = $dir->read())
|
Chris@76
|
724 {
|
Chris@76
|
725 if (!in_array($entry, $context['filenames']) && in_array(strrchr($entry, '.'), array('.jpg', '.gif', '.jpeg', '.png')))
|
Chris@76
|
726 $context['filenames'][strtolower($entry)] = array(
|
Chris@76
|
727 'id' => htmlspecialchars($entry),
|
Chris@76
|
728 'selected' => false,
|
Chris@76
|
729 );
|
Chris@76
|
730 }
|
Chris@76
|
731 $dir->close();
|
Chris@76
|
732 }
|
Chris@76
|
733 ksort($context['filenames']);
|
Chris@76
|
734 }
|
Chris@76
|
735
|
Chris@76
|
736 // Create a new smiley from scratch.
|
Chris@76
|
737 $context['filenames'] = array_values($context['filenames']);
|
Chris@76
|
738 $context['current_smiley'] = array(
|
Chris@76
|
739 'id' => 0,
|
Chris@76
|
740 'code' => '',
|
Chris@76
|
741 'filename' => $context['filenames'][0]['id'],
|
Chris@76
|
742 'description' => $txt['smileys_default_description'],
|
Chris@76
|
743 'location' => 0,
|
Chris@76
|
744 'is_new' => true,
|
Chris@76
|
745 );
|
Chris@76
|
746 }
|
Chris@76
|
747
|
Chris@76
|
748 function EditSmileys()
|
Chris@76
|
749 {
|
Chris@76
|
750 global $modSettings, $context, $settings, $txt, $boarddir;
|
Chris@76
|
751 global $smcFunc, $scripturl, $sourcedir;
|
Chris@76
|
752
|
Chris@76
|
753 // Force the correct tab to be displayed.
|
Chris@76
|
754 $context[$context['admin_menu_name']]['current_subsection'] = 'editsmileys';
|
Chris@76
|
755
|
Chris@76
|
756 // Submitting a form?
|
Chris@76
|
757 if (isset($_POST[$context['session_var']]))
|
Chris@76
|
758 {
|
Chris@76
|
759 checkSession();
|
Chris@76
|
760
|
Chris@76
|
761 // Changing the selected smileys?
|
Chris@76
|
762 if (isset($_POST['smiley_action']) && !empty($_POST['checked_smileys']))
|
Chris@76
|
763 {
|
Chris@76
|
764 foreach ($_POST['checked_smileys'] as $id => $smiley_id)
|
Chris@76
|
765 $_POST['checked_smileys'][$id] = (int) $smiley_id;
|
Chris@76
|
766
|
Chris@76
|
767 if ($_POST['smiley_action'] == 'delete')
|
Chris@76
|
768 $smcFunc['db_query']('', '
|
Chris@76
|
769 DELETE FROM {db_prefix}smileys
|
Chris@76
|
770 WHERE id_smiley IN ({array_int:checked_smileys})',
|
Chris@76
|
771 array(
|
Chris@76
|
772 'checked_smileys' => $_POST['checked_smileys'],
|
Chris@76
|
773 )
|
Chris@76
|
774 );
|
Chris@76
|
775 // Changing the status of the smiley?
|
Chris@76
|
776 else
|
Chris@76
|
777 {
|
Chris@76
|
778 // Check it's a valid type.
|
Chris@76
|
779 $displayTypes = array(
|
Chris@76
|
780 'post' => 0,
|
Chris@76
|
781 'hidden' => 1,
|
Chris@76
|
782 'popup' => 2
|
Chris@76
|
783 );
|
Chris@76
|
784 if (isset($displayTypes[$_POST['smiley_action']]))
|
Chris@76
|
785 $smcFunc['db_query']('', '
|
Chris@76
|
786 UPDATE {db_prefix}smileys
|
Chris@76
|
787 SET hidden = {int:display_type}
|
Chris@76
|
788 WHERE id_smiley IN ({array_int:checked_smileys})',
|
Chris@76
|
789 array(
|
Chris@76
|
790 'checked_smileys' => $_POST['checked_smileys'],
|
Chris@76
|
791 'display_type' => $displayTypes[$_POST['smiley_action']],
|
Chris@76
|
792 )
|
Chris@76
|
793 );
|
Chris@76
|
794 }
|
Chris@76
|
795 }
|
Chris@76
|
796 // Create/modify a smiley.
|
Chris@76
|
797 elseif (isset($_POST['smiley']))
|
Chris@76
|
798 {
|
Chris@76
|
799 // Is it a delete?
|
Chris@76
|
800 if (!empty($_POST['deletesmiley']))
|
Chris@76
|
801 {
|
Chris@76
|
802 $smcFunc['db_query']('', '
|
Chris@76
|
803 DELETE FROM {db_prefix}smileys
|
Chris@76
|
804 WHERE id_smiley = {int:current_smiley}',
|
Chris@76
|
805 array(
|
Chris@76
|
806 'current_smiley' => $_POST['smiley'],
|
Chris@76
|
807 )
|
Chris@76
|
808 );
|
Chris@76
|
809 }
|
Chris@76
|
810 // Otherwise an edit.
|
Chris@76
|
811 else
|
Chris@76
|
812 {
|
Chris@76
|
813 $_POST['smiley'] = (int) $_POST['smiley'];
|
Chris@76
|
814 $_POST['smiley_code'] = htmltrim__recursive($_POST['smiley_code']);
|
Chris@76
|
815 $_POST['smiley_filename'] = htmltrim__recursive($_POST['smiley_filename']);
|
Chris@76
|
816 $_POST['smiley_location'] = empty($_POST['smiley_location']) || $_POST['smiley_location'] > 2 || $_POST['smiley_location'] < 0 ? 0 : (int) $_POST['smiley_location'];
|
Chris@76
|
817
|
Chris@76
|
818 // Make sure some code was entered.
|
Chris@76
|
819 if (empty($_POST['smiley_code']))
|
Chris@76
|
820 fatal_lang_error('smiley_has_no_code');
|
Chris@76
|
821
|
Chris@76
|
822 // Also make sure a filename was given.
|
Chris@76
|
823 if (empty($_POST['smiley_filename']))
|
Chris@76
|
824 fatal_lang_error('smiley_has_no_filename');
|
Chris@76
|
825
|
Chris@76
|
826 // Check whether the new code has duplicates. It should be unique.
|
Chris@76
|
827 $request = $smcFunc['db_query']('', '
|
Chris@76
|
828 SELECT id_smiley
|
Chris@76
|
829 FROM {db_prefix}smileys
|
Chris@76
|
830 WHERE code = {raw:mysql_binary_type} {string:smiley_code}' . (empty($_POST['smiley']) ? '' : '
|
Chris@76
|
831 AND id_smiley != {int:current_smiley}'),
|
Chris@76
|
832 array(
|
Chris@76
|
833 'current_smiley' => $_POST['smiley'],
|
Chris@76
|
834 'mysql_binary_type' => $smcFunc['db_title'] == 'MySQL' ? 'BINARY' : '',
|
Chris@76
|
835 'smiley_code' => $_POST['smiley_code'],
|
Chris@76
|
836 )
|
Chris@76
|
837 );
|
Chris@76
|
838 if ($smcFunc['db_num_rows']($request) > 0)
|
Chris@76
|
839 fatal_lang_error('smiley_not_unique');
|
Chris@76
|
840 $smcFunc['db_free_result']($request);
|
Chris@76
|
841
|
Chris@76
|
842 $smcFunc['db_query']('', '
|
Chris@76
|
843 UPDATE {db_prefix}smileys
|
Chris@76
|
844 SET
|
Chris@76
|
845 code = {string:smiley_code},
|
Chris@76
|
846 filename = {string:smiley_filename},
|
Chris@76
|
847 description = {string:smiley_description},
|
Chris@76
|
848 hidden = {int:smiley_location}
|
Chris@76
|
849 WHERE id_smiley = {int:current_smiley}',
|
Chris@76
|
850 array(
|
Chris@76
|
851 'smiley_location' => $_POST['smiley_location'],
|
Chris@76
|
852 'current_smiley' => $_POST['smiley'],
|
Chris@76
|
853 'smiley_code' => $_POST['smiley_code'],
|
Chris@76
|
854 'smiley_filename' => $_POST['smiley_filename'],
|
Chris@76
|
855 'smiley_description' => $_POST['smiley_description'],
|
Chris@76
|
856 )
|
Chris@76
|
857 );
|
Chris@76
|
858 }
|
Chris@76
|
859
|
Chris@76
|
860 // Sort all smiley codes for more accurate parsing (longest code first).
|
Chris@76
|
861 sortSmileyTable();
|
Chris@76
|
862 }
|
Chris@76
|
863
|
Chris@76
|
864 cache_put_data('parsing_smileys', null, 480);
|
Chris@76
|
865 cache_put_data('posting_smileys', null, 480);
|
Chris@76
|
866 }
|
Chris@76
|
867
|
Chris@76
|
868 // Load all known smiley sets.
|
Chris@76
|
869 $context['smiley_sets'] = explode(',', $modSettings['smiley_sets_known']);
|
Chris@76
|
870 $set_names = explode("\n", $modSettings['smiley_sets_names']);
|
Chris@76
|
871 foreach ($context['smiley_sets'] as $i => $set)
|
Chris@76
|
872 $context['smiley_sets'][$i] = array(
|
Chris@76
|
873 'id' => $i,
|
Chris@76
|
874 'path' => htmlspecialchars($set),
|
Chris@76
|
875 'name' => htmlspecialchars($set_names[$i]),
|
Chris@76
|
876 'selected' => $set == $modSettings['smiley_sets_default']
|
Chris@76
|
877 );
|
Chris@76
|
878
|
Chris@76
|
879 // Prepare overview of all (custom) smileys.
|
Chris@76
|
880 if ($context['sub_action'] == 'editsmileys')
|
Chris@76
|
881 {
|
Chris@76
|
882 // Determine the language specific sort order of smiley locations.
|
Chris@76
|
883 $smiley_locations = array(
|
Chris@76
|
884 $txt['smileys_location_form'],
|
Chris@76
|
885 $txt['smileys_location_hidden'],
|
Chris@76
|
886 $txt['smileys_location_popup'],
|
Chris@76
|
887 );
|
Chris@76
|
888 asort($smiley_locations);
|
Chris@76
|
889
|
Chris@76
|
890 // Create a list of options for selecting smiley sets.
|
Chris@76
|
891 $smileyset_option_list = '
|
Chris@76
|
892 <select name="set" onchange="changeSet(this.options[this.selectedIndex].value);">';
|
Chris@76
|
893 foreach ($context['smiley_sets'] as $smiley_set)
|
Chris@76
|
894 $smileyset_option_list .= '
|
Chris@76
|
895 <option value="' . $smiley_set['path'] . '"' . ($modSettings['smiley_sets_default'] == $smiley_set['path'] ? ' selected="selected"' : '') . '>' . $smiley_set['name'] . '</option>';
|
Chris@76
|
896 $smileyset_option_list .= '
|
Chris@76
|
897 </select>';
|
Chris@76
|
898
|
Chris@76
|
899 $listOptions = array(
|
Chris@76
|
900 'id' => 'smiley_list',
|
Chris@76
|
901 'items_per_page' => 40,
|
Chris@76
|
902 'base_href' => $scripturl . '?action=admin;area=smileys;sa=editsmileys',
|
Chris@76
|
903 'default_sort_col' => 'filename',
|
Chris@76
|
904 'get_items' => array(
|
Chris@76
|
905 'function' => 'list_getSmileys',
|
Chris@76
|
906 ),
|
Chris@76
|
907 'get_count' => array(
|
Chris@76
|
908 'function' => 'list_getNumSmileys',
|
Chris@76
|
909 ),
|
Chris@76
|
910 'no_items_label' => $txt['smileys_no_entries'],
|
Chris@76
|
911 'columns' => array(
|
Chris@76
|
912 'picture' => array(
|
Chris@76
|
913 'data' => array(
|
Chris@76
|
914 'sprintf' => array(
|
Chris@76
|
915 'format' => '<a href="' . $scripturl . '?action=admin;area=smileys;sa=modifysmiley;smiley=%1$d"><img src="' . $modSettings['smileys_url'] . '/' . $modSettings['smiley_sets_default'] . '/%2$s" alt="%3$s" style="padding: 2px;" id="smiley%1$d" /><input type="hidden" name="smileys[%1$d][filename]" value="%2$s" /></a>',
|
Chris@76
|
916 'params' => array(
|
Chris@76
|
917 'id_smiley' => false,
|
Chris@76
|
918 'filename' => true,
|
Chris@76
|
919 'description' => true,
|
Chris@76
|
920 ),
|
Chris@76
|
921 ),
|
Chris@76
|
922 'style' => 'text-align: center;',
|
Chris@76
|
923 ),
|
Chris@76
|
924 ),
|
Chris@76
|
925 'code' => array(
|
Chris@76
|
926 'header' => array(
|
Chris@76
|
927 'value' => $txt['smileys_code'],
|
Chris@76
|
928 ),
|
Chris@76
|
929 'data' => array(
|
Chris@76
|
930 'db_htmlsafe' => 'code',
|
Chris@76
|
931 ),
|
Chris@76
|
932 'sort' => array(
|
Chris@76
|
933 'default' => 'code',
|
Chris@76
|
934 'reverse' => 'code DESC',
|
Chris@76
|
935 ),
|
Chris@76
|
936 ),
|
Chris@76
|
937 'filename' => array(
|
Chris@76
|
938 'header' => array(
|
Chris@76
|
939 'value' => $txt['smileys_filename'],
|
Chris@76
|
940 ),
|
Chris@76
|
941 'data' => array(
|
Chris@76
|
942 'db_htmlsafe' => 'filename',
|
Chris@76
|
943 'class' => 'windowbg',
|
Chris@76
|
944 ),
|
Chris@76
|
945 'sort' => array(
|
Chris@76
|
946 'default' => 'filename',
|
Chris@76
|
947 'reverse' => 'filename DESC',
|
Chris@76
|
948 ),
|
Chris@76
|
949 ),
|
Chris@76
|
950 'location' => array(
|
Chris@76
|
951 'header' => array(
|
Chris@76
|
952 'value' => $txt['smileys_location'],
|
Chris@76
|
953 ),
|
Chris@76
|
954 'data' => array(
|
Chris@76
|
955 'function' => create_function('$rowData', '
|
Chris@76
|
956 global $txt;
|
Chris@76
|
957
|
Chris@76
|
958 if (empty($rowData[\'hidden\']))
|
Chris@76
|
959 return $txt[\'smileys_location_form\'];
|
Chris@76
|
960 elseif ($rowData[\'hidden\'] == 1)
|
Chris@76
|
961 return $txt[\'smileys_location_hidden\'];
|
Chris@76
|
962 else
|
Chris@76
|
963 return $txt[\'smileys_location_popup\'];
|
Chris@76
|
964 '),
|
Chris@76
|
965 'class' => 'windowbg',
|
Chris@76
|
966 ),
|
Chris@76
|
967 'sort' => array(
|
Chris@76
|
968 'default' => 'FIND_IN_SET(hidden, \'' . implode(',', array_keys($smiley_locations)) . '\')',
|
Chris@76
|
969 'reverse' => 'FIND_IN_SET(hidden, \'' . implode(',', array_keys($smiley_locations)) . '\') DESC',
|
Chris@76
|
970 ),
|
Chris@76
|
971 ),
|
Chris@76
|
972 'tooltip' => array(
|
Chris@76
|
973 'header' => array(
|
Chris@76
|
974 'value' => $txt['smileys_description'],
|
Chris@76
|
975 ),
|
Chris@76
|
976 'data' => array(
|
Chris@76
|
977 'function' => create_function('$rowData', empty($modSettings['smileys_dir']) || !is_dir($modSettings['smileys_dir']) ? '
|
Chris@76
|
978 return htmlspecialchars($rowData[\'description\']);
|
Chris@76
|
979 ' : '
|
Chris@76
|
980 global $context, $txt, $modSettings;
|
Chris@76
|
981
|
Chris@76
|
982 // Check if there are smileys missing in some sets.
|
Chris@76
|
983 $missing_sets = array();
|
Chris@76
|
984 foreach ($context[\'smiley_sets\'] as $smiley_set)
|
Chris@76
|
985 if (!file_exists(sprintf(\'%1$s/%2$s/%3$s\', $modSettings[\'smileys_dir\'], $smiley_set[\'path\'], $rowData[\'filename\'])))
|
Chris@76
|
986 $missing_sets[] = $smiley_set[\'path\'];
|
Chris@76
|
987
|
Chris@76
|
988 $description = htmlspecialchars($rowData[\'description\']);
|
Chris@76
|
989
|
Chris@76
|
990 if (!empty($missing_sets))
|
Chris@76
|
991 $description .= sprintf(\'<br /><span class="smalltext"><strong>%1$s:</strong> %2$s</span>\', $txt[\'smileys_not_found_in_set\'], implode(\', \', $missing_sets));
|
Chris@76
|
992
|
Chris@76
|
993 return $description;
|
Chris@76
|
994 '),
|
Chris@76
|
995 'class' => 'windowbg',
|
Chris@76
|
996 ),
|
Chris@76
|
997 'sort' => array(
|
Chris@76
|
998 'default' => 'description',
|
Chris@76
|
999 'reverse' => 'description DESC',
|
Chris@76
|
1000 ),
|
Chris@76
|
1001 ),
|
Chris@76
|
1002 'modify' => array(
|
Chris@76
|
1003 'header' => array(
|
Chris@76
|
1004 'value' => $txt['smileys_modify'],
|
Chris@76
|
1005 ),
|
Chris@76
|
1006 'data' => array(
|
Chris@76
|
1007 'sprintf' => array(
|
Chris@76
|
1008 'format' => '<a href="' . $scripturl . '?action=admin;area=smileys;sa=modifysmiley;smiley=%1$d">' . $txt['smileys_modify'] . '</a>',
|
Chris@76
|
1009 'params' => array(
|
Chris@76
|
1010 'id_smiley' => false,
|
Chris@76
|
1011 ),
|
Chris@76
|
1012 ),
|
Chris@76
|
1013 'style' => 'text-align: center;',
|
Chris@76
|
1014 ),
|
Chris@76
|
1015 ),
|
Chris@76
|
1016 'check' => array(
|
Chris@76
|
1017 'header' => array(
|
Chris@76
|
1018 'value' => '<input type="checkbox" onclick="invertAll(this, this.form);" class="input_check" />',
|
Chris@76
|
1019 ),
|
Chris@76
|
1020 'data' => array(
|
Chris@76
|
1021 'sprintf' => array(
|
Chris@76
|
1022 'format' => '<input type="checkbox" name="checked_smileys[]" value="%1$d" class="input_check" />',
|
Chris@76
|
1023 'params' => array(
|
Chris@76
|
1024 'id_smiley' => false,
|
Chris@76
|
1025 ),
|
Chris@76
|
1026 ),
|
Chris@76
|
1027 'style' => 'text-align: center',
|
Chris@76
|
1028 ),
|
Chris@76
|
1029 ),
|
Chris@76
|
1030 ),
|
Chris@76
|
1031 'form' => array(
|
Chris@76
|
1032 'href' => $scripturl . '?action=admin;area=smileys;sa=editsmileys',
|
Chris@76
|
1033 'name' => 'smileyForm',
|
Chris@76
|
1034 ),
|
Chris@76
|
1035 'additional_rows' => array(
|
Chris@76
|
1036 array(
|
Chris@76
|
1037 'position' => 'above_column_headers',
|
Chris@76
|
1038 'value' => $smileyset_option_list,
|
Chris@76
|
1039 'style' => 'text-align: right;',
|
Chris@76
|
1040 ),
|
Chris@76
|
1041 array(
|
Chris@76
|
1042 'position' => 'below_table_data',
|
Chris@76
|
1043 'value' => '
|
Chris@76
|
1044 <select name="smiley_action" onchange="makeChanges(this.value);">
|
Chris@76
|
1045 <option value="-1">' . $txt['smileys_with_selected'] . ':</option>
|
Chris@76
|
1046 <option value="-1">--------------</option>
|
Chris@76
|
1047 <option value="hidden">' . $txt['smileys_make_hidden'] . '</option>
|
Chris@76
|
1048 <option value="post">' . $txt['smileys_show_on_post'] . '</option>
|
Chris@76
|
1049 <option value="popup">' . $txt['smileys_show_on_popup'] . '</option>
|
Chris@76
|
1050 <option value="delete">' . $txt['smileys_remove'] . '</option>
|
Chris@76
|
1051 </select>
|
Chris@76
|
1052 <noscript><input type="submit" name="perform_action" value="' . $txt['go'] . '" class="button_submit" /></noscript>',
|
Chris@76
|
1053 'style' => 'text-align: right;',
|
Chris@76
|
1054 ),
|
Chris@76
|
1055 ),
|
Chris@76
|
1056 'javascript' => '
|
Chris@76
|
1057 function makeChanges(action)
|
Chris@76
|
1058 {
|
Chris@76
|
1059 if (action == \'-1\')
|
Chris@76
|
1060 return false;
|
Chris@76
|
1061 else if (action == \'delete\')
|
Chris@76
|
1062 {
|
Chris@76
|
1063 if (confirm(\'' . $txt['smileys_confirm'] . '\'))
|
Chris@76
|
1064 document.forms.smileyForm.submit();
|
Chris@76
|
1065 }
|
Chris@76
|
1066 else
|
Chris@76
|
1067 document.forms.smileyForm.submit();
|
Chris@76
|
1068 return true;
|
Chris@76
|
1069 }
|
Chris@76
|
1070 function changeSet(newSet)
|
Chris@76
|
1071 {
|
Chris@76
|
1072 var currentImage, i, knownSmileys = [];
|
Chris@76
|
1073
|
Chris@76
|
1074 if (knownSmileys.length == 0)
|
Chris@76
|
1075 {
|
Chris@76
|
1076 for (var i = 0, n = document.images.length; i < n; i++)
|
Chris@76
|
1077 if (document.images[i].id.substr(0, 6) == \'smiley\')
|
Chris@76
|
1078 knownSmileys[knownSmileys.length] = document.images[i].id.substr(6);
|
Chris@76
|
1079 }
|
Chris@76
|
1080
|
Chris@76
|
1081 for (i = 0; i < knownSmileys.length; i++)
|
Chris@76
|
1082 {
|
Chris@76
|
1083 currentImage = document.getElementById("smiley" + knownSmileys[i]);
|
Chris@76
|
1084 currentImage.src = "' . $modSettings['smileys_url'] . '/" + newSet + "/" + document.forms.smileyForm["smileys[" + knownSmileys[i] + "][filename]"].value;
|
Chris@76
|
1085 }
|
Chris@76
|
1086 }',
|
Chris@76
|
1087 );
|
Chris@76
|
1088
|
Chris@76
|
1089 require_once($sourcedir . '/Subs-List.php');
|
Chris@76
|
1090 createList($listOptions);
|
Chris@76
|
1091
|
Chris@76
|
1092 // The list is the only thing to show, so make it the main template.
|
Chris@76
|
1093 $context['default_list'] = 'smiley_list';
|
Chris@76
|
1094 $context['sub_template'] = 'show_list';
|
Chris@76
|
1095 }
|
Chris@76
|
1096 // Modifying smileys.
|
Chris@76
|
1097 elseif ($context['sub_action'] == 'modifysmiley')
|
Chris@76
|
1098 {
|
Chris@76
|
1099 // Get a list of all known smiley sets.
|
Chris@76
|
1100 $context['smileys_dir'] = empty($modSettings['smileys_dir']) ? $boarddir . '/Smileys' : $modSettings['smileys_dir'];
|
Chris@76
|
1101 $context['smileys_dir_found'] = is_dir($context['smileys_dir']);
|
Chris@76
|
1102 $context['smiley_sets'] = explode(',', $modSettings['smiley_sets_known']);
|
Chris@76
|
1103 $set_names = explode("\n", $modSettings['smiley_sets_names']);
|
Chris@76
|
1104 foreach ($context['smiley_sets'] as $i => $set)
|
Chris@76
|
1105 $context['smiley_sets'][$i] = array(
|
Chris@76
|
1106 'id' => $i,
|
Chris@76
|
1107 'path' => htmlspecialchars($set),
|
Chris@76
|
1108 'name' => htmlspecialchars($set_names[$i]),
|
Chris@76
|
1109 'selected' => $set == $modSettings['smiley_sets_default']
|
Chris@76
|
1110 );
|
Chris@76
|
1111
|
Chris@76
|
1112 $context['selected_set'] = $modSettings['smiley_sets_default'];
|
Chris@76
|
1113
|
Chris@76
|
1114 // Get all possible filenames for the smileys.
|
Chris@76
|
1115 $context['filenames'] = array();
|
Chris@76
|
1116 if ($context['smileys_dir_found'])
|
Chris@76
|
1117 {
|
Chris@76
|
1118 foreach ($context['smiley_sets'] as $smiley_set)
|
Chris@76
|
1119 {
|
Chris@76
|
1120 if (!file_exists($context['smileys_dir'] . '/' . un_htmlspecialchars($smiley_set['path'])))
|
Chris@76
|
1121 continue;
|
Chris@76
|
1122
|
Chris@76
|
1123 $dir = dir($context['smileys_dir'] . '/' . un_htmlspecialchars($smiley_set['path']));
|
Chris@76
|
1124 while ($entry = $dir->read())
|
Chris@76
|
1125 {
|
Chris@76
|
1126 if (!in_array($entry, $context['filenames']) && in_array(strrchr($entry, '.'), array('.jpg', '.gif', '.jpeg', '.png')))
|
Chris@76
|
1127 $context['filenames'][strtolower($entry)] = array(
|
Chris@76
|
1128 'id' => htmlspecialchars($entry),
|
Chris@76
|
1129 'selected' => false,
|
Chris@76
|
1130 );
|
Chris@76
|
1131 }
|
Chris@76
|
1132 $dir->close();
|
Chris@76
|
1133 }
|
Chris@76
|
1134 ksort($context['filenames']);
|
Chris@76
|
1135 }
|
Chris@76
|
1136
|
Chris@76
|
1137 $request = $smcFunc['db_query']('', '
|
Chris@76
|
1138 SELECT id_smiley AS id, code, filename, description, hidden AS location, 0 AS is_new
|
Chris@76
|
1139 FROM {db_prefix}smileys
|
Chris@76
|
1140 WHERE id_smiley = {int:current_smiley}',
|
Chris@76
|
1141 array(
|
Chris@76
|
1142 'current_smiley' => (int) $_REQUEST['smiley'],
|
Chris@76
|
1143 )
|
Chris@76
|
1144 );
|
Chris@76
|
1145 if ($smcFunc['db_num_rows']($request) != 1)
|
Chris@76
|
1146 fatal_lang_error('smiley_not_found');
|
Chris@76
|
1147 $context['current_smiley'] = $smcFunc['db_fetch_assoc']($request);
|
Chris@76
|
1148 $smcFunc['db_free_result']($request);
|
Chris@76
|
1149
|
Chris@76
|
1150 $context['current_smiley']['code'] = htmlspecialchars($context['current_smiley']['code']);
|
Chris@76
|
1151 $context['current_smiley']['filename'] = htmlspecialchars($context['current_smiley']['filename']);
|
Chris@76
|
1152 $context['current_smiley']['description'] = htmlspecialchars($context['current_smiley']['description']);
|
Chris@76
|
1153
|
Chris@76
|
1154 if (isset($context['filenames'][strtolower($context['current_smiley']['filename'])]))
|
Chris@76
|
1155 $context['filenames'][strtolower($context['current_smiley']['filename'])]['selected'] = true;
|
Chris@76
|
1156 }
|
Chris@76
|
1157 }
|
Chris@76
|
1158
|
Chris@76
|
1159 function list_getSmileys($start, $items_per_page, $sort)
|
Chris@76
|
1160 {
|
Chris@76
|
1161 global $smcFunc;
|
Chris@76
|
1162
|
Chris@76
|
1163 $request = $smcFunc['db_query']('', '
|
Chris@76
|
1164 SELECT id_smiley, code, filename, description, smiley_row, smiley_order, hidden
|
Chris@76
|
1165 FROM {db_prefix}smileys
|
Chris@76
|
1166 ORDER BY ' . $sort,
|
Chris@76
|
1167 array(
|
Chris@76
|
1168 )
|
Chris@76
|
1169 );
|
Chris@76
|
1170 $smileys = array();
|
Chris@76
|
1171 while ($row = $smcFunc['db_fetch_assoc']($request))
|
Chris@76
|
1172 $smileys[] = $row;
|
Chris@76
|
1173 $smcFunc['db_free_result']($request);
|
Chris@76
|
1174
|
Chris@76
|
1175 return $smileys;
|
Chris@76
|
1176 }
|
Chris@76
|
1177
|
Chris@76
|
1178 function list_getNumSmileys()
|
Chris@76
|
1179 {
|
Chris@76
|
1180 global $smcFunc;
|
Chris@76
|
1181
|
Chris@76
|
1182 $request = $smcFunc['db_query']('', '
|
Chris@76
|
1183 SELECT COUNT(*)
|
Chris@76
|
1184 FROM {db_prefix}smileys',
|
Chris@76
|
1185 array(
|
Chris@76
|
1186 )
|
Chris@76
|
1187 );
|
Chris@76
|
1188 list($numSmileys) = $smcFunc['db_fetch_row'];
|
Chris@76
|
1189 $smcFunc['db_free_result']($request);
|
Chris@76
|
1190
|
Chris@76
|
1191 return $numSmileys;
|
Chris@76
|
1192 }
|
Chris@76
|
1193
|
Chris@76
|
1194 function EditSmileyOrder()
|
Chris@76
|
1195 {
|
Chris@76
|
1196 global $modSettings, $context, $settings, $txt, $boarddir, $smcFunc;
|
Chris@76
|
1197
|
Chris@76
|
1198 // Move smileys to another position.
|
Chris@76
|
1199 if (isset($_REQUEST['reorder']))
|
Chris@76
|
1200 {
|
Chris@76
|
1201 checkSession('get');
|
Chris@76
|
1202
|
Chris@76
|
1203 $_GET['location'] = empty($_GET['location']) || $_GET['location'] != 'popup' ? 0 : 2;
|
Chris@76
|
1204 $_GET['source'] = empty($_GET['source']) ? 0 : (int) $_GET['source'];
|
Chris@76
|
1205
|
Chris@76
|
1206 if (empty($_GET['source']))
|
Chris@76
|
1207 fatal_lang_error('smiley_not_found');
|
Chris@76
|
1208
|
Chris@76
|
1209 if (!empty($_GET['after']))
|
Chris@76
|
1210 {
|
Chris@76
|
1211 $_GET['after'] = (int) $_GET['after'];
|
Chris@76
|
1212
|
Chris@76
|
1213 $request = $smcFunc['db_query']('', '
|
Chris@76
|
1214 SELECT smiley_row, smiley_order, hidden
|
Chris@76
|
1215 FROM {db_prefix}smileys
|
Chris@76
|
1216 WHERE hidden = {int:location}
|
Chris@76
|
1217 AND id_smiley = {int:after_smiley}',
|
Chris@76
|
1218 array(
|
Chris@76
|
1219 'location' => $_GET['location'],
|
Chris@76
|
1220 'after_smiley' => $_GET['after'],
|
Chris@76
|
1221 )
|
Chris@76
|
1222 );
|
Chris@76
|
1223 if ($smcFunc['db_num_rows']($request) != 1)
|
Chris@76
|
1224 fatal_lang_error('smiley_not_found');
|
Chris@76
|
1225 list ($smiley_row, $smiley_order, $smileyLocation) = $smcFunc['db_fetch_row']($request);
|
Chris@76
|
1226 $smcFunc['db_free_result']($request);
|
Chris@76
|
1227 }
|
Chris@76
|
1228 else
|
Chris@76
|
1229 {
|
Chris@76
|
1230 $smiley_row = (int) $_GET['row'];
|
Chris@76
|
1231 $smiley_order = -1;
|
Chris@76
|
1232 $smileyLocation = (int) $_GET['location'];
|
Chris@76
|
1233 }
|
Chris@76
|
1234
|
Chris@76
|
1235 $smcFunc['db_query']('', '
|
Chris@76
|
1236 UPDATE {db_prefix}smileys
|
Chris@76
|
1237 SET smiley_order = smiley_order + 1
|
Chris@76
|
1238 WHERE hidden = {int:new_location}
|
Chris@76
|
1239 AND smiley_row = {int:smiley_row}
|
Chris@76
|
1240 AND smiley_order > {int:smiley_order}',
|
Chris@76
|
1241 array(
|
Chris@76
|
1242 'new_location' => $_GET['location'],
|
Chris@76
|
1243 'smiley_row' => $smiley_row,
|
Chris@76
|
1244 'smiley_order' => $smiley_order,
|
Chris@76
|
1245 )
|
Chris@76
|
1246 );
|
Chris@76
|
1247
|
Chris@76
|
1248 $smcFunc['db_query']('', '
|
Chris@76
|
1249 UPDATE {db_prefix}smileys
|
Chris@76
|
1250 SET
|
Chris@76
|
1251 smiley_order = {int:smiley_order} + 1,
|
Chris@76
|
1252 smiley_row = {int:smiley_row},
|
Chris@76
|
1253 hidden = {int:new_location}
|
Chris@76
|
1254 WHERE id_smiley = {int:current_smiley}',
|
Chris@76
|
1255 array(
|
Chris@76
|
1256 'smiley_order' => $smiley_order,
|
Chris@76
|
1257 'smiley_row' => $smiley_row,
|
Chris@76
|
1258 'new_location' => $smileyLocation,
|
Chris@76
|
1259 'current_smiley' => $_GET['source'],
|
Chris@76
|
1260 )
|
Chris@76
|
1261 );
|
Chris@76
|
1262
|
Chris@76
|
1263 cache_put_data('parsing_smileys', null, 480);
|
Chris@76
|
1264 cache_put_data('posting_smileys', null, 480);
|
Chris@76
|
1265 }
|
Chris@76
|
1266
|
Chris@76
|
1267 $request = $smcFunc['db_query']('', '
|
Chris@76
|
1268 SELECT id_smiley, code, filename, description, smiley_row, smiley_order, hidden
|
Chris@76
|
1269 FROM {db_prefix}smileys
|
Chris@76
|
1270 WHERE hidden != {int:popup}
|
Chris@76
|
1271 ORDER BY smiley_order, smiley_row',
|
Chris@76
|
1272 array(
|
Chris@76
|
1273 'popup' => 1,
|
Chris@76
|
1274 )
|
Chris@76
|
1275 );
|
Chris@76
|
1276 $context['smileys'] = array(
|
Chris@76
|
1277 'postform' => array(
|
Chris@76
|
1278 'rows' => array(),
|
Chris@76
|
1279 ),
|
Chris@76
|
1280 'popup' => array(
|
Chris@76
|
1281 'rows' => array(),
|
Chris@76
|
1282 ),
|
Chris@76
|
1283 );
|
Chris@76
|
1284 while ($row = $smcFunc['db_fetch_assoc']($request))
|
Chris@76
|
1285 {
|
Chris@76
|
1286 $location = empty($row['hidden']) ? 'postform' : 'popup';
|
Chris@76
|
1287 $context['smileys'][$location]['rows'][$row['smiley_row']][] = array(
|
Chris@76
|
1288 'id' => $row['id_smiley'],
|
Chris@76
|
1289 'code' => htmlspecialchars($row['code']),
|
Chris@76
|
1290 'filename' => htmlspecialchars($row['filename']),
|
Chris@76
|
1291 'description' => htmlspecialchars($row['description']),
|
Chris@76
|
1292 'row' => $row['smiley_row'],
|
Chris@76
|
1293 'order' => $row['smiley_order'],
|
Chris@76
|
1294 'selected' => !empty($_REQUEST['move']) && $_REQUEST['move'] == $row['id_smiley'],
|
Chris@76
|
1295 );
|
Chris@76
|
1296 }
|
Chris@76
|
1297 $smcFunc['db_free_result']($request);
|
Chris@76
|
1298
|
Chris@76
|
1299 $context['move_smiley'] = empty($_REQUEST['move']) ? 0 : (int) $_REQUEST['move'];
|
Chris@76
|
1300
|
Chris@76
|
1301 // Make sure all rows are sequential.
|
Chris@76
|
1302 foreach (array_keys($context['smileys']) as $location)
|
Chris@76
|
1303 $context['smileys'][$location] = array(
|
Chris@76
|
1304 'id' => $location,
|
Chris@76
|
1305 'title' => $location == 'postform' ? $txt['smileys_location_form'] : $txt['smileys_location_popup'],
|
Chris@76
|
1306 'description' => $location == 'postform' ? $txt['smileys_location_form_description'] : $txt['smileys_location_popup_description'],
|
Chris@76
|
1307 'last_row' => count($context['smileys'][$location]['rows']),
|
Chris@76
|
1308 'rows' => array_values($context['smileys'][$location]['rows']),
|
Chris@76
|
1309 );
|
Chris@76
|
1310
|
Chris@76
|
1311 // Check & fix smileys that are not ordered properly in the database.
|
Chris@76
|
1312 foreach (array_keys($context['smileys']) as $location)
|
Chris@76
|
1313 {
|
Chris@76
|
1314 foreach ($context['smileys'][$location]['rows'] as $id => $smiley_row)
|
Chris@76
|
1315 {
|
Chris@76
|
1316 // Fix empty rows if any.
|
Chris@76
|
1317 if ($id != $smiley_row[0]['row'])
|
Chris@76
|
1318 {
|
Chris@76
|
1319 $smcFunc['db_query']('', '
|
Chris@76
|
1320 UPDATE {db_prefix}smileys
|
Chris@76
|
1321 SET smiley_row = {int:new_row}
|
Chris@76
|
1322 WHERE smiley_row = {int:current_row}
|
Chris@76
|
1323 AND hidden = {int:location}',
|
Chris@76
|
1324 array(
|
Chris@76
|
1325 'new_row' => $id,
|
Chris@76
|
1326 'current_row' => $smiley_row[0]['row'],
|
Chris@76
|
1327 'location' => $location == 'postform' ? '0' : '2',
|
Chris@76
|
1328 )
|
Chris@76
|
1329 );
|
Chris@76
|
1330 // Only change the first row value of the first smiley (we don't need the others :P).
|
Chris@76
|
1331 $context['smileys'][$location]['rows'][$id][0]['row'] = $id;
|
Chris@76
|
1332 }
|
Chris@76
|
1333 // Make sure the smiley order is always sequential.
|
Chris@76
|
1334 foreach ($smiley_row as $order_id => $smiley)
|
Chris@76
|
1335 if ($order_id != $smiley['order'])
|
Chris@76
|
1336 $smcFunc['db_query']('', '
|
Chris@76
|
1337 UPDATE {db_prefix}smileys
|
Chris@76
|
1338 SET smiley_order = {int:new_order}
|
Chris@76
|
1339 WHERE id_smiley = {int:current_smiley}',
|
Chris@76
|
1340 array(
|
Chris@76
|
1341 'new_order' => $order_id,
|
Chris@76
|
1342 'current_smiley' => $smiley['id'],
|
Chris@76
|
1343 )
|
Chris@76
|
1344 );
|
Chris@76
|
1345 }
|
Chris@76
|
1346 }
|
Chris@76
|
1347
|
Chris@76
|
1348 cache_put_data('parsing_smileys', null, 480);
|
Chris@76
|
1349 cache_put_data('posting_smileys', null, 480);
|
Chris@76
|
1350 }
|
Chris@76
|
1351
|
Chris@76
|
1352 function InstallSmileySet()
|
Chris@76
|
1353 {
|
Chris@76
|
1354 global $sourcedir, $boarddir, $modSettings, $smcFunc;
|
Chris@76
|
1355
|
Chris@76
|
1356 isAllowedTo('manage_smileys');
|
Chris@76
|
1357 checkSession('request');
|
Chris@76
|
1358
|
Chris@76
|
1359 require_once($sourcedir . '/Subs-Package.php');
|
Chris@76
|
1360
|
Chris@76
|
1361 $name = strtok(basename(isset($_FILES['set_gz']) ? $_FILES['set_gz']['name'] : $_REQUEST['set_gz']), '.');
|
Chris@76
|
1362 $name = preg_replace(array('/\s/', '/\.[\.]+/', '/[^\w_\.\-]/'), array('_', '.', ''), $name);
|
Chris@76
|
1363
|
Chris@76
|
1364 // !!! Decide: overwrite or not?
|
Chris@76
|
1365 if (isset($_FILES['set_gz']) && is_uploaded_file($_FILES['set_gz']['tmp_name']) && (@ini_get('open_basedir') != '' || file_exists($_FILES['set_gz']['tmp_name'])))
|
Chris@76
|
1366 $extracted = read_tgz_file($_FILES['set_gz']['tmp_name'], $boarddir . '/Smileys/' . $name);
|
Chris@76
|
1367 elseif (isset($_REQUEST['set_gz']))
|
Chris@76
|
1368 {
|
Chris@76
|
1369 // Check that the smiley is from simplemachines.org, for now... maybe add mirroring later.
|
Chris@76
|
1370 if (preg_match('~^http://[\w_\-]+\.simplemachines\.org/~', $_REQUEST['set_gz']) == 0 || strpos($_REQUEST['set_gz'], 'dlattach') !== false)
|
Chris@76
|
1371 fatal_lang_error('not_on_simplemachines');
|
Chris@76
|
1372
|
Chris@76
|
1373 $extracted = read_tgz_file($_REQUEST['set_gz'], $boarddir . '/Smileys/' . $name);
|
Chris@76
|
1374 }
|
Chris@76
|
1375 else
|
Chris@76
|
1376 redirectexit('action=admin;area=smileys');
|
Chris@76
|
1377
|
Chris@76
|
1378 updateSettings(array(
|
Chris@76
|
1379 'smiley_sets_known' => $modSettings['smiley_sets_known'] . ',' . $name,
|
Chris@76
|
1380 'smiley_sets_names' => $modSettings['smiley_sets_names'] . "\n" . strtok(basename(isset($_FILES['set_gz']) ? $_FILES['set_gz']['name'] : $_REQUEST['set_gz']), '.'),
|
Chris@76
|
1381 ));
|
Chris@76
|
1382
|
Chris@76
|
1383 cache_put_data('parsing_smileys', null, 480);
|
Chris@76
|
1384 cache_put_data('posting_smileys', null, 480);
|
Chris@76
|
1385
|
Chris@76
|
1386 // !!! Add some confirmation?
|
Chris@76
|
1387 redirectexit('action=admin;area=smileys');
|
Chris@76
|
1388 }
|
Chris@76
|
1389
|
Chris@76
|
1390 // A function to import new smileys from an existing directory into the database.
|
Chris@76
|
1391 function ImportSmileys($smileyPath)
|
Chris@76
|
1392 {
|
Chris@76
|
1393 global $modSettings, $smcFunc;
|
Chris@76
|
1394
|
Chris@76
|
1395 if (empty($modSettings['smileys_dir']) || !is_dir($modSettings['smileys_dir'] . '/' . $smileyPath))
|
Chris@76
|
1396 fatal_lang_error('smiley_set_unable_to_import');
|
Chris@76
|
1397
|
Chris@76
|
1398 $smileys = array();
|
Chris@76
|
1399 $dir = dir($modSettings['smileys_dir'] . '/' . $smileyPath);
|
Chris@76
|
1400 while ($entry = $dir->read())
|
Chris@76
|
1401 {
|
Chris@76
|
1402 if (in_array(strrchr($entry, '.'), array('.jpg', '.gif', '.jpeg', '.png')))
|
Chris@76
|
1403 $smileys[strtolower($entry)] = $entry;
|
Chris@76
|
1404 }
|
Chris@76
|
1405 $dir->close();
|
Chris@76
|
1406
|
Chris@76
|
1407 // Exclude the smileys that are already in the database.
|
Chris@76
|
1408 $request = $smcFunc['db_query']('', '
|
Chris@76
|
1409 SELECT filename
|
Chris@76
|
1410 FROM {db_prefix}smileys
|
Chris@76
|
1411 WHERE filename IN ({array_string:smiley_list})',
|
Chris@76
|
1412 array(
|
Chris@76
|
1413 'smiley_list' => $smileys,
|
Chris@76
|
1414 )
|
Chris@76
|
1415 );
|
Chris@76
|
1416 while ($row = $smcFunc['db_fetch_assoc']($request))
|
Chris@76
|
1417 if (isset($smileys[strtolower($row['filename'])]))
|
Chris@76
|
1418 unset($smileys[strtolower($row['filename'])]);
|
Chris@76
|
1419 $smcFunc['db_free_result']($request);
|
Chris@76
|
1420
|
Chris@76
|
1421 $request = $smcFunc['db_query']('', '
|
Chris@76
|
1422 SELECT MAX(smiley_order)
|
Chris@76
|
1423 FROM {db_prefix}smileys
|
Chris@76
|
1424 WHERE hidden = {int:postform}
|
Chris@76
|
1425 AND smiley_row = {int:first_row}',
|
Chris@76
|
1426 array(
|
Chris@76
|
1427 'postform' => 0,
|
Chris@76
|
1428 'first_row' => 0,
|
Chris@76
|
1429 )
|
Chris@76
|
1430 );
|
Chris@76
|
1431 list ($smiley_order) = $smcFunc['db_fetch_row']($request);
|
Chris@76
|
1432 $smcFunc['db_free_result']($request);
|
Chris@76
|
1433
|
Chris@76
|
1434 $new_smileys = array();
|
Chris@76
|
1435 foreach ($smileys as $smiley)
|
Chris@76
|
1436 if (strlen($smiley) <= 48)
|
Chris@76
|
1437 $new_smileys[] = array(':' . strtok($smiley, '.') . ':', $smiley, strtok($smiley, '.'), 0, ++$smiley_order);
|
Chris@76
|
1438
|
Chris@76
|
1439 if (!empty($new_smileys))
|
Chris@76
|
1440 {
|
Chris@76
|
1441 $smcFunc['db_insert']('',
|
Chris@76
|
1442 '{db_prefix}smileys',
|
Chris@76
|
1443 array(
|
Chris@76
|
1444 'code' => 'string-30', 'filename' => 'string-48', 'description' => 'string-80', 'smiley_row' => 'int', 'smiley_order' => 'int',
|
Chris@76
|
1445 ),
|
Chris@76
|
1446 $new_smileys,
|
Chris@76
|
1447 array('id_smiley')
|
Chris@76
|
1448 );
|
Chris@76
|
1449
|
Chris@76
|
1450 // Make sure the smiley codes are still in the right order.
|
Chris@76
|
1451 sortSmileyTable();
|
Chris@76
|
1452
|
Chris@76
|
1453 cache_put_data('parsing_smileys', null, 480);
|
Chris@76
|
1454 cache_put_data('posting_smileys', null, 480);
|
Chris@76
|
1455 }
|
Chris@76
|
1456 }
|
Chris@76
|
1457
|
Chris@76
|
1458 function EditMessageIcons()
|
Chris@76
|
1459 {
|
Chris@76
|
1460 global $user_info, $modSettings, $context, $settings, $txt;
|
Chris@76
|
1461 global $boarddir, $smcFunc, $scripturl, $sourcedir;
|
Chris@76
|
1462
|
Chris@76
|
1463 // Get a list of icons.
|
Chris@76
|
1464 $context['icons'] = array();
|
Chris@76
|
1465 $request = $smcFunc['db_query']('', '
|
Chris@76
|
1466 SELECT m.id_icon, m.title, m.filename, m.icon_order, m.id_board, b.name AS board_name
|
Chris@76
|
1467 FROM {db_prefix}message_icons AS m
|
Chris@76
|
1468 LEFT JOIN {db_prefix}boards AS b ON (b.id_board = m.id_board)
|
Chris@76
|
1469 WHERE ({query_see_board} OR b.id_board IS NULL)',
|
Chris@76
|
1470 array(
|
Chris@76
|
1471 )
|
Chris@76
|
1472 );
|
Chris@76
|
1473 $last_icon = 0;
|
Chris@76
|
1474 $trueOrder = 0;
|
Chris@76
|
1475 while ($row = $smcFunc['db_fetch_assoc']($request))
|
Chris@76
|
1476 {
|
Chris@76
|
1477 $context['icons'][$row['id_icon']] = array(
|
Chris@76
|
1478 'id' => $row['id_icon'],
|
Chris@76
|
1479 'title' => $row['title'],
|
Chris@76
|
1480 'filename' => $row['filename'],
|
Chris@76
|
1481 'image_url' => $settings[file_exists($settings['theme_dir'] . '/images/post/' . $row['filename'] . '.gif') ? 'actual_images_url' : 'default_images_url'] . '/post/' . $row['filename'] . '.gif',
|
Chris@76
|
1482 'board_id' => $row['id_board'],
|
Chris@76
|
1483 'board' => empty($row['board_name']) ? $txt['icons_edit_icons_all_boards'] : $row['board_name'],
|
Chris@76
|
1484 'order' => $row['icon_order'],
|
Chris@76
|
1485 'true_order' => $trueOrder++,
|
Chris@76
|
1486 'after' => $last_icon,
|
Chris@76
|
1487 );
|
Chris@76
|
1488 $last_icon = $row['id_icon'];
|
Chris@76
|
1489 }
|
Chris@76
|
1490 $smcFunc['db_free_result']($request);
|
Chris@76
|
1491
|
Chris@76
|
1492 // Submitting a form?
|
Chris@76
|
1493 if (isset($_POST[$context['session_var']]))
|
Chris@76
|
1494 {
|
Chris@76
|
1495 checkSession();
|
Chris@76
|
1496
|
Chris@76
|
1497 // Deleting icons?
|
Chris@76
|
1498 if (isset($_POST['delete']) && !empty($_POST['checked_icons']))
|
Chris@76
|
1499 {
|
Chris@76
|
1500 $deleteIcons = array();
|
Chris@76
|
1501 foreach ($_POST['checked_icons'] as $icon)
|
Chris@76
|
1502 $deleteIcons[] = (int) $icon;
|
Chris@76
|
1503
|
Chris@76
|
1504 // Do the actual delete!
|
Chris@76
|
1505 $smcFunc['db_query']('', '
|
Chris@76
|
1506 DELETE FROM {db_prefix}message_icons
|
Chris@76
|
1507 WHERE id_icon IN ({array_int:icon_list})',
|
Chris@76
|
1508 array(
|
Chris@76
|
1509 'icon_list' => $deleteIcons,
|
Chris@76
|
1510 )
|
Chris@76
|
1511 );
|
Chris@76
|
1512 }
|
Chris@76
|
1513 // Editing/Adding an icon?
|
Chris@76
|
1514 elseif ($context['sub_action'] == 'editicon' && isset($_GET['icon']))
|
Chris@76
|
1515 {
|
Chris@76
|
1516 $_GET['icon'] = (int) $_GET['icon'];
|
Chris@76
|
1517
|
Chris@76
|
1518 // Do some preperation with the data... like check the icon exists *somewhere*
|
Chris@76
|
1519 if (strpos($_POST['icon_filename'], '.gif') !== false)
|
Chris@76
|
1520 $_POST['icon_filename'] = substr($_POST['icon_filename'], 0, -4);
|
Chris@76
|
1521 if (!file_exists($settings['default_theme_dir'] . '/images/post/' . $_POST['icon_filename'] . '.gif'))
|
Chris@76
|
1522 fatal_lang_error('icon_not_found');
|
Chris@76
|
1523 // There is a 16 character limit on message icons...
|
Chris@76
|
1524 elseif (strlen($_POST['icon_filename']) > 16)
|
Chris@76
|
1525 fatal_lang_error('icon_name_too_long');
|
Chris@76
|
1526 elseif ($_POST['icon_location'] == $_GET['icon'] && !empty($_GET['icon']))
|
Chris@76
|
1527 fatal_lang_error('icon_after_itself');
|
Chris@76
|
1528
|
Chris@76
|
1529 // First do the sorting... if this is an edit reduce the order of everything after it by one ;)
|
Chris@76
|
1530 if ($_GET['icon'] != 0)
|
Chris@76
|
1531 {
|
Chris@76
|
1532 $oldOrder = $context['icons'][$_GET['icon']]['true_order'];
|
Chris@76
|
1533 foreach ($context['icons'] as $id => $data)
|
Chris@76
|
1534 if ($data['true_order'] > $oldOrder)
|
Chris@76
|
1535 $context['icons'][$id]['true_order']--;
|
Chris@76
|
1536 }
|
Chris@76
|
1537
|
Chris@76
|
1538 // If there are no existing icons and this is a new one, set the id to 1 (mainly for non-mysql)
|
Chris@76
|
1539 if (empty($_GET['icon']) && empty($context['icons']))
|
Chris@76
|
1540 $_GET['icon'] = 1;
|
Chris@76
|
1541
|
Chris@76
|
1542 // Get the new order.
|
Chris@76
|
1543 $newOrder = $_POST['icon_location'] == 0 ? 0 : $context['icons'][$_POST['icon_location']]['true_order'] + 1;
|
Chris@76
|
1544 // Do the same, but with the one that used to be after this icon, done to avoid conflict.
|
Chris@76
|
1545 foreach ($context['icons'] as $id => $data)
|
Chris@76
|
1546 if ($data['true_order'] >= $newOrder)
|
Chris@76
|
1547 $context['icons'][$id]['true_order']++;
|
Chris@76
|
1548
|
Chris@76
|
1549 // Finally set the current icon's position!
|
Chris@76
|
1550 $context['icons'][$_GET['icon']]['true_order'] = $newOrder;
|
Chris@76
|
1551
|
Chris@76
|
1552 // Simply replace the existing data for the other bits.
|
Chris@76
|
1553 $context['icons'][$_GET['icon']]['title'] = $_POST['icon_description'];
|
Chris@76
|
1554 $context['icons'][$_GET['icon']]['filename'] = $_POST['icon_filename'];
|
Chris@76
|
1555 $context['icons'][$_GET['icon']]['board_id'] = (int) $_POST['icon_board'];
|
Chris@76
|
1556
|
Chris@76
|
1557 // Do a huge replace ;)
|
Chris@76
|
1558 $iconInsert = array();
|
Chris@76
|
1559 $iconInsert_new = array();
|
Chris@76
|
1560 foreach ($context['icons'] as $id => $icon)
|
Chris@76
|
1561 {
|
Chris@76
|
1562 if ($id != 0)
|
Chris@76
|
1563 {
|
Chris@76
|
1564 $iconInsert[] = array($id, $icon['board_id'], $icon['title'], $icon['filename'], $icon['true_order']);
|
Chris@76
|
1565 }
|
Chris@76
|
1566 else
|
Chris@76
|
1567 {
|
Chris@76
|
1568 $iconInsert_new[] = array($icon['board_id'], $icon['title'], $icon['filename'], $icon['true_order']);
|
Chris@76
|
1569 }
|
Chris@76
|
1570 }
|
Chris@76
|
1571
|
Chris@76
|
1572 $smcFunc['db_insert']('replace',
|
Chris@76
|
1573 '{db_prefix}message_icons',
|
Chris@76
|
1574 array('id_icon' => 'int', 'id_board' => 'int', 'title' => 'string-80', 'filename' => 'string-80', 'icon_order' => 'int'),
|
Chris@76
|
1575 $iconInsert,
|
Chris@76
|
1576 array('id_icon')
|
Chris@76
|
1577 );
|
Chris@76
|
1578
|
Chris@76
|
1579 if (!empty($iconInsert_new))
|
Chris@76
|
1580 {
|
Chris@76
|
1581 $smcFunc['db_insert']('replace',
|
Chris@76
|
1582 '{db_prefix}message_icons',
|
Chris@76
|
1583 array('id_board' => 'int', 'title' => 'string-80', 'filename' => 'string-80', 'icon_order' => 'int'),
|
Chris@76
|
1584 $iconInsert_new,
|
Chris@76
|
1585 array('id_icon')
|
Chris@76
|
1586 );
|
Chris@76
|
1587 }
|
Chris@76
|
1588 }
|
Chris@76
|
1589
|
Chris@76
|
1590 // Sort by order, so it is quicker :)
|
Chris@76
|
1591 $smcFunc['db_query']('alter_table_icons', '
|
Chris@76
|
1592 ALTER TABLE {db_prefix}message_icons
|
Chris@76
|
1593 ORDER BY icon_order',
|
Chris@76
|
1594 array(
|
Chris@76
|
1595 'db_error_skip' => true,
|
Chris@76
|
1596 )
|
Chris@76
|
1597 );
|
Chris@76
|
1598
|
Chris@76
|
1599 // Unless we're adding a new thing, we'll escape
|
Chris@76
|
1600 if (!isset($_POST['add']))
|
Chris@76
|
1601 redirectexit('action=admin;area=smileys;sa=editicons');
|
Chris@76
|
1602 }
|
Chris@76
|
1603
|
Chris@76
|
1604 $context[$context['admin_menu_name']]['current_subsection'] = 'editicons';
|
Chris@76
|
1605
|
Chris@76
|
1606 $listOptions = array(
|
Chris@76
|
1607 'id' => 'message_icon_list',
|
Chris@76
|
1608 'base_href' => $scripturl . '?action=admin;area=smileys;sa=editicons',
|
Chris@76
|
1609 'get_items' => array(
|
Chris@76
|
1610 'function' => 'list_getMessageIcons',
|
Chris@76
|
1611 ),
|
Chris@76
|
1612 'no_items_label' => $txt['icons_no_entries'],
|
Chris@76
|
1613 'columns' => array(
|
Chris@76
|
1614 'icon' => array(
|
Chris@76
|
1615 'data' => array(
|
Chris@76
|
1616 'function' => create_function('$rowData', '
|
Chris@76
|
1617 global $settings;
|
Chris@76
|
1618
|
Chris@76
|
1619 $images_url = $settings[file_exists(sprintf(\'%1$s/images/post/%2$s.gif\', $settings[\'theme_dir\'], $rowData[\'filename\'])) ? \'actual_images_url\' : \'default_images_url\'];
|
Chris@76
|
1620 return sprintf(\'<img src="%1$s/post/%2$s.gif" alt="%3$s" />\', $images_url, $rowData[\'filename\'], htmlspecialchars($rowData[\'title\']));
|
Chris@76
|
1621 '),
|
Chris@76
|
1622 ),
|
Chris@76
|
1623 'style' => 'text-align: center;',
|
Chris@76
|
1624 ),
|
Chris@76
|
1625 'filename' => array(
|
Chris@76
|
1626 'header' => array(
|
Chris@76
|
1627 'value' => $txt['smileys_filename'],
|
Chris@76
|
1628 ),
|
Chris@76
|
1629 'data' => array(
|
Chris@76
|
1630 'sprintf' => array(
|
Chris@76
|
1631 'format' => '%1$s.gif',
|
Chris@76
|
1632 'params' => array(
|
Chris@76
|
1633 'filename' => true,
|
Chris@76
|
1634 ),
|
Chris@76
|
1635 ),
|
Chris@76
|
1636 ),
|
Chris@76
|
1637 ),
|
Chris@76
|
1638 'tooltip' => array(
|
Chris@76
|
1639 'header' => array(
|
Chris@76
|
1640 'value' => $txt['smileys_description'],
|
Chris@76
|
1641 ),
|
Chris@76
|
1642 'data' => array(
|
Chris@76
|
1643 'db_htmlsafe' => 'title',
|
Chris@76
|
1644 'class' => 'windowbg',
|
Chris@76
|
1645 ),
|
Chris@76
|
1646 ),
|
Chris@76
|
1647 'board' => array(
|
Chris@76
|
1648 'header' => array(
|
Chris@76
|
1649 'value' => $txt['icons_board'],
|
Chris@76
|
1650 ),
|
Chris@76
|
1651 'data' => array(
|
Chris@76
|
1652 'function' => create_function('$rowData', '
|
Chris@76
|
1653 global $txt;
|
Chris@76
|
1654
|
Chris@76
|
1655 return empty($rowData[\'board_name\']) ? $txt[\'icons_edit_icons_all_boards\'] : $rowData[\'board_name\'];
|
Chris@76
|
1656 '),
|
Chris@76
|
1657 ),
|
Chris@76
|
1658 ),
|
Chris@76
|
1659 'modify' => array(
|
Chris@76
|
1660 'header' => array(
|
Chris@76
|
1661 'value' => $txt['smileys_modify'],
|
Chris@76
|
1662 ),
|
Chris@76
|
1663 'data' => array(
|
Chris@76
|
1664 'sprintf' => array(
|
Chris@76
|
1665 'format' => '<a href="' . $scripturl . '?action=admin;area=smileys;sa=editicon;icon=%1$s">' . $txt['smileys_modify'] . '</a>',
|
Chris@76
|
1666 'params' => array(
|
Chris@76
|
1667 'id_icon' => false,
|
Chris@76
|
1668 ),
|
Chris@76
|
1669 ),
|
Chris@76
|
1670 'style' => 'text-align: center',
|
Chris@76
|
1671 ),
|
Chris@76
|
1672 ),
|
Chris@76
|
1673 'check' => array(
|
Chris@76
|
1674 'header' => array(
|
Chris@76
|
1675 'value' => '<input type="checkbox" onclick="invertAll(this, this.form);" class="input_check" />',
|
Chris@76
|
1676 ),
|
Chris@76
|
1677 'data' => array(
|
Chris@76
|
1678 'sprintf' => array(
|
Chris@76
|
1679 'format' => '<input type="checkbox" name="checked_icons[]" value="%1$d" class="input_check" />',
|
Chris@76
|
1680 'params' => array(
|
Chris@76
|
1681 'id_icon' => false,
|
Chris@76
|
1682 ),
|
Chris@76
|
1683 ),
|
Chris@76
|
1684 'style' => 'text-align: center',
|
Chris@76
|
1685 ),
|
Chris@76
|
1686 ),
|
Chris@76
|
1687 ),
|
Chris@76
|
1688 'form' => array(
|
Chris@76
|
1689 'href' => $scripturl . '?action=admin;area=smileys;sa=editicons',
|
Chris@76
|
1690 ),
|
Chris@76
|
1691 'additional_rows' => array(
|
Chris@76
|
1692 array(
|
Chris@76
|
1693 'position' => 'below_table_data',
|
Chris@76
|
1694 'value' => '<input type="submit" name="delete" value="' . $txt['quickmod_delete_selected'] . '" style="float: right" class="button_submit" />[<a href="' . $scripturl . '?action=admin;area=smileys;sa=editicon">' . $txt['icons_add_new'] . '</a>]',
|
Chris@76
|
1695 ),
|
Chris@76
|
1696 ),
|
Chris@76
|
1697 );
|
Chris@76
|
1698
|
Chris@76
|
1699 require_once($sourcedir . '/Subs-List.php');
|
Chris@76
|
1700 createList($listOptions);
|
Chris@76
|
1701
|
Chris@76
|
1702 // If we're adding/editing an icon we'll need a list of boards
|
Chris@76
|
1703 if ($context['sub_action'] == 'editicon' || isset($_POST['add']))
|
Chris@76
|
1704 {
|
Chris@76
|
1705 // Force the sub_template just in case.
|
Chris@76
|
1706 $context['sub_template'] = 'editicon';
|
Chris@76
|
1707
|
Chris@76
|
1708 $context['new_icon'] = !isset($_GET['icon']);
|
Chris@76
|
1709
|
Chris@76
|
1710 // Get the properties of the current icon from the icon list.
|
Chris@76
|
1711 if (!$context['new_icon'])
|
Chris@76
|
1712 $context['icon'] = $context['icons'][$_GET['icon']];
|
Chris@76
|
1713
|
Chris@76
|
1714 // Get a list of boards needed for assigning this icon to a specific board.
|
Chris@76
|
1715 $boardListOptions = array(
|
Chris@76
|
1716 'use_permissions' => true,
|
Chris@76
|
1717 'selected_board' => isset($context['icon']['board_id']) ? $context['icon']['board_id'] : 0,
|
Chris@76
|
1718 );
|
Chris@76
|
1719 require_once($sourcedir . '/Subs-MessageIndex.php');
|
Chris@76
|
1720 $context['categories'] = getBoardList($boardListOptions);
|
Chris@76
|
1721 }
|
Chris@76
|
1722 }
|
Chris@76
|
1723
|
Chris@76
|
1724 function list_getMessageIcons($start, $items_per_page, $sort)
|
Chris@76
|
1725 {
|
Chris@76
|
1726 global $smcFunc, $user_info;
|
Chris@76
|
1727
|
Chris@76
|
1728 $request = $smcFunc['db_query']('', '
|
Chris@76
|
1729 SELECT m.id_icon, m.title, m.filename, m.icon_order, m.id_board, b.name AS board_name
|
Chris@76
|
1730 FROM {db_prefix}message_icons AS m
|
Chris@76
|
1731 LEFT JOIN {db_prefix}boards AS b ON (b.id_board = m.id_board)
|
Chris@76
|
1732 WHERE ({query_see_board} OR b.id_board IS NULL)',
|
Chris@76
|
1733 array(
|
Chris@76
|
1734 )
|
Chris@76
|
1735 );
|
Chris@76
|
1736
|
Chris@76
|
1737 $message_icons = array();
|
Chris@76
|
1738 while ($row = $smcFunc['db_fetch_assoc']($request))
|
Chris@76
|
1739 $message_icons[] = $row;
|
Chris@76
|
1740 $smcFunc['db_free_result']($request);
|
Chris@76
|
1741
|
Chris@76
|
1742 return $message_icons;
|
Chris@76
|
1743 }
|
Chris@76
|
1744
|
Chris@76
|
1745 // This function sorts the smiley table by code length, it is needed as MySQL withdrew support for functions in order by.
|
Chris@76
|
1746 function sortSmileyTable()
|
Chris@76
|
1747 {
|
Chris@76
|
1748 global $smcFunc;
|
Chris@76
|
1749
|
Chris@76
|
1750 db_extend('packages');
|
Chris@76
|
1751
|
Chris@76
|
1752 // Add a sorting column.
|
Chris@76
|
1753 $smcFunc['db_add_column']('{db_prefix}smileys', array('name' => 'temp_order', 'size' => 8, 'type' => 'mediumint', 'null' => false));
|
Chris@76
|
1754
|
Chris@76
|
1755 // Set the contents of this column.
|
Chris@76
|
1756 $smcFunc['db_query']('set_smiley_order', '
|
Chris@76
|
1757 UPDATE {db_prefix}smileys
|
Chris@76
|
1758 SET temp_order = LENGTH(code)',
|
Chris@76
|
1759 array(
|
Chris@76
|
1760 )
|
Chris@76
|
1761 );
|
Chris@76
|
1762
|
Chris@76
|
1763 // Order the table by this column.
|
Chris@76
|
1764 $smcFunc['db_query']('alter_table_smileys', '
|
Chris@76
|
1765 ALTER TABLE {db_prefix}smileys
|
Chris@76
|
1766 ORDER BY temp_order DESC',
|
Chris@76
|
1767 array(
|
Chris@76
|
1768 'db_error_skip' => true,
|
Chris@76
|
1769 )
|
Chris@76
|
1770 );
|
Chris@76
|
1771
|
Chris@76
|
1772 // Remove the sorting column.
|
Chris@76
|
1773 $smcFunc['db_remove_column']('{db_prefix}smileys', 'temp_order');
|
Chris@76
|
1774 }
|
Chris@76
|
1775
|
Chris@76
|
1776 ?> |