+ <td class="cat" colspan="2" align="center"><input type="hidden" name="mode" value="<?php echo $newmode ?>" /><input type="hidden" name="forum_id" value="<?php echo $forum_id ?>" /><input type="submit" name="submit" value="<?php echo $buttonvalue ?>" class="mainoption" /></td>

+ <td class="cat" colspan="2" align="center"><input type="submit" name="submit" value="<?php echo $lang['Move_and_Delete'] ?>" class="mainoption" /></td>

+ <td width="100%" colspan="9" class="cat"><input type="text" name="forum_name[<? echo $parent_id ?>]" /> <input type="submit" class="liteoption" name="parent_id[<? echo $parent_id ?>]" value="<?php echo $lang['Create_forum'] ?>" /></td>

+ $smile_order = 0;

+ ++$smile_order;

+ ++$smile_order;

+

+ 'smile_order' => $smile_order,

+ if (document.smile_image.height)

+ {

+ document.forms[0].smile_height.value = document.smile_image.height;

+ document.forms[0].smile_width.value = document.smile_image.width;

+ }

+ <td class="row1"><select name="smile_url" onChange="update_smile(this.options[selectedIndex].value);"><?php echo $filename_list ?></select> &nbsp; <img name="smile_image" src="<?php echo (!empty($default_image)) ? $phpbb_root_path . $board_config['smilies_path'] . '/' . $default_image : '../images/spacer.gif' ?>" border="0" alt="" onLoad="update_smile_dimensions()" /> &nbsp;</td>

+/*

+*/

+ $order_list = '';

+ $result = $db->sql_query('SELECT * FROM ' . SMILIES_TABLE . ' ORDER BY smile_order DESC');

+ while ($row = $db->sql_fetchrow($result))

+ {

+ if ($row['smilies_id'] == $smile_id)

+ {

+ $after = TRUE;

+ $smile_data = $row;

+ }

+ else

+ {

+ $selected = '';

+ if (!empty($after))

+ {

+ $selected = ' selected="selected"';

+ $after = FALSE;

+ }

+ $order_list = '<option value="' . ($row['smile_order'] + 1) . '"' . $selected . '>' . sprintf($lang['After_smile'], htmlspecialchars($row['code'])) . '</option>' . $order_list;

+ }

+ }

+ $order_list = '<option value="1"' . ((!isset($after)) ? ' selected="selected"' : '') . '>' . $lang['First'] . '</option>' . $order_list;

+ $smile_edit_img = $smile_url;

+ <th class="thHead" colspan="2"><?php echo $lang['Smile_config'] ?></th>

+ <td class="row1"><?php echo $lang['Display_on_posting'] ?></td>

+ <td class="row1"><input type="checkbox" name="smile_on_posting" <?php echo ($smile_data['smile_on_posting']) ? ' checked="checked"' : '' ?>/></td>

+ </tr>

+ <tr>

+ <td class="row2"><?php echo $lang['Smile_order'] ?></td>

+ <td class="row2"><select name="smile_order"><?php echo $order_list ?></select></td>

+ </tr>

+ <tr>

+ $smile_width = intval($HTTP_POST_VARS['smile_width']);

+ $smile_height = intval($HTTP_POST_VARS['smile_height']);

+ if ($smile_width == 0 || $smile_height == 0)

+ {

+ $img_size = @getimagesize($phpbb_root_path . $board_config['smilies_path'] . '/' . stripslashes($HTTP_POST_VARS['smile_url']));

+ $smile_width = $img_size[0];

+ $smile_height = $img_size[1];

+ }

+ 'code' => htmlspecialchars(stripslashes($HTTP_POST_VARS['smile_code'])),

+ 'smile_url' => stripslashes($HTTP_POST_VARS['smile_url']),

+ 'smile_width' => $smile_width,

+ 'smile_height' => $smile_height,

+ 'smile_order' => $smile_order,

+ 'emoticon' => stripslashes($HTTP_POST_VARS['smile_emotion']),

+ 'smile_on_posting' => (!empty($HTTP_POST_VARS['smile_on_posting'])) ? 1 : 0

+ $smile_id = $HTTP_POST_VARS['smile_id'];

+ $smile_order = $HTTP_POST_VARS['smile_order'];

+

+ if ($mode == 'modify')

+ {

+ $result = $db->sql_query('SELECT smile_order FROM ' . SMILIES_TABLE . " WHERE smilies_id = $smile_id");

+ $order_old = $db->sql_fetchfield('smile_order', 0, $result);

+

+ if ($order_old == $smile_order)

+ {

+ $no_update = TRUE;

+ }

+ if ($order_old > $smile_order)

+ {

+ $sign = '+';

+ $where = "smile_order >= $smile_order AND smile_order < $order_old";

+ }

+ else

+ {

+ $sign = '-';

+ $where = "smile_order > $order_old AND smile_order < $smile_order";

+ $sql['smile_order'] = $smile_order - 1;

+ }

+ }

+ else

+ {

+ $sign = '+';

+ $where = "smile_order > $smile_order";

+ }

+

+ if (empty($no_update))

+ {

+ $qry = 'UPDATE ' . SMILIES_TABLE . "

+ SET smile_order = smile_order $sign 1

+ WHERE $where";

+ $db->sql_query($qry);

+ }

+

+ $db->sql_query_array('UPDATE ' . SMILIES_TABLE . " SET WHERE smilies_id = $smile_id", $sql);

+ case 'move_up':

+ case 'move_down':

+ $smile_order = intval($HTTP_GET_VARS['smile_order']);

+ $order_total = $smile_order * 2 + (($mode == 'move_up') ? -1 : 1);

+

+ $sql = 'UPDATE ' . SMILIES_TABLE . "

+ SET smile_order = $order_total - smile_order

+ WHERE smile_order IN ($smile_order, " . (($mode == 'move_up') ? $smile_order - 1 : $smile_order + 1) . ')';

+ $db->sql_query($sql);

+

+ //

+ // No break; here, display the smilies admin back

+ //

+

+ //

+ // By default, check that smile_order is valid and fix it if necessary

+ //

+ $order = 0;

+ $result = $db->sql_query('SELECT * FROM ' . SMILIES_TABLE . ' ORDER BY smile_order');

+ while ($row = $db->sql_fetchrow($result))

+ {

+ ++$order;

+ if ($row['smile_order'] != $order)

+ {

+ $db->sql_query('UPDATE ' . SMILIES_TABLE . " SET smile_order = $order WHERE smilies_id = " . $row['smilies_id']);

+ }

+ }

+ $sql = 'SELECT *

+ FROM ' . SMILIES_TABLE . '

+ ORDER BY smile_on_posting DESC, smile_order ASC';

+ $result = $db->sql_query($sql);

+ <th colspan="2"><?php echo $lang['Reorder']; ?></th>

+

+ $spacer = FALSE;

+ while ($row = $db->sql_fetchrow($result))

+ if (!$spacer && !$row['smile_on_posting'])

+ $spacer = TRUE;

+?>

+ <tr>

+ <td class="row3" colspan="7" align="center"><?php echo $lang['Smilies_not_displayed'] ?></td>

+ </tr>

+<?php

+ }

+ $row_class = ( $row_class != 'row1' ) ? 'row1' : 'row2';

+ <td class="<?php echo $row_class; ?>" align="center"><a href="<?php echo "admin_smilies.$phpEx$SID&amp;mode=move_up&amp;smile_order=" . $row['smile_order']; ?>"><?php echo $lang['Up']; ?></a></td>

+ <td class="<?php echo $row_class; ?>" align="center"><a href="<?php echo "admin_smilies.$phpEx$SID&amp;mode=move_down&amp;smile_order=" . $row['smile_order']; ?>"><?php echo $lang['Down']; ?></a></td>

+ <td class="cat" colspan="7" align="center"><input type="submit" name="add" value="<?php echo $lang['Add_smile']; ?>" class="mainoption" />&nbsp;&nbsp;<input class="liteoption" type="submit" name="import_pak" value="<?php echo $lang['Import_smilies']; ?>">&nbsp;&nbsp;<input class="liteoption" type="submit" name="export_pak" value="<?php echo $lang['Export_smilies']; ?>"></td>

+ $values[] = (is_bool($var)) ? intval($var) : $var;

+ $values[] = (is_bool($var)) ? "$key = " . intval($var) : "$key = $var";

+ smile_order tinyint(4) UNSIGNED NOT NULL,

+ smile_on_posting tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,

+$lang['Emoticons_explain'] = 'From this page you can add, remove and edit the emoticons or emoticons users can use in their posts and private messages.';

+$lang['Import_smilies'] = 'Import emoticons pak';

+$lang['Import_smilies_explain'] = 'Unzip the emoticons package to your emoticons directory then select the correct information in this form to import it.';

+$lang['Smilies_import'] = 'Emoticons pack import';

+$lang['No_smilies_pak'] = 'No emoticons pack found';

+$lang['Delete_existing_smilies'] = 'Delete existing emoticons before import';

+$lang['Keep_existing_smilies'] = 'Keep existing emoticons';

+$lang['Replace_existing_smilies'] = 'Replace existing emoticons';

+$lang['Smilies_import_success'] = 'The emoticons pack was imported successfully';

+

+$lang['Export_smilies'] = 'Create emoticons pak';

+$lang['Export_smilies_explain'] = 'To create a package of your currently installed emoticons, %sclick here%s to download the emoticons.pak file. Name this file appropriately, making sure to keep the .pak file extension then create a zip file containing all of your emoticons images plus this .pak configuration file.';

+

+$lang['Add_smile'] = 'Add a new emoticon';

+$lang['Edit_smile'] = 'Edit emoticon';

+

+$lang['Smilies_not_displayed'] = 'The following emoticons are not displayed on posting page';

+$lang['Reorder'] = 'Reorder';

+$lang['Up'] = 'Up';

+$lang['Down'] = 'Down';

+$lang['First'] = 'First';

+$lang['After_smile'] = 'After %s';

+$lang['Display_on_posting'] = 'Display on posting';

+

+$lang['Smile_config'] = 'Emoticon configuration';

+$lang['Smile_code'] = 'Emoticon code';

+$lang['Smile_url'] = 'Emoticon image file';

+$lang['Smile_height'] = 'Emoticon height';

+$lang['Smile_width'] = 'Emoticon width';

+$lang['Smile_order'] = 'Emoticon order';

+$lang['Smile_emotion'] = 'Emotion';

+$lang['Smile_add'] = 'Add a new emoticon';

+$lang['Smile_edit'] = 'Edit emoticon';

+$lang['Smile_deleted'] = 'This emoticon has been successfully removed';

+$lang['Smile_edited'] = 'This emoticon has been successfully updated';

+$lang['Smile_added'] = 'This emoticon has been successfully added';

+$lang['Smilies_imported'] = 'The emoticons pack has been successfully imported';

+$lang['Click_return_smileadmin'] = 'Click %sHere%s to return to Emoticons Administration';