- $sql = 'SELECT f.*, s.*

- FROM ' . FORUMS_TABLE . ' f

- LEFT JOIN ' . STYLES_TABLE . " s ON f.forum_style = s.style_id

- WHERE f.forum_id = $forum_id";

-* admin_icons.php

-if ( !$acl->get_acl_admin('general') )

-if ( isset($HTTP_POST_VARS['mode']) || isset($HTTP_GET_VARS['mode']) )

- $mode = ( isset($HTTP_POST_VARS['mode']) ) ? $HTTP_POST_VARS['mode'] : $HTTP_GET_VARS['mode'];

-$delimeter = '=+:';

-//

-// Read a listing of uploaded smilies for use in the add or edit smliey code...

-//

-$dir = @opendir($phpbb_root_path . $board_config['smilies_path']);

-

-while( $file = @readdir($dir) )

- if ( is_file($phpbb_root_path . $board_config['smilies_path'] . '/' . $file) )

- $img_size = @getimagesize($phpbb_root_path . $board_config['smilies_path'] . '/' . $file);

-

- if ( $img_size[0] && $img_size[1] )

- $smiley_images[] = $file;

- }

- else if( eregi('.pak$', $file) )

- {

- $smiley_paks[] = $file;

-@closedir($dir);

-

-if ( isset($HTTP_GET_VARS['import_pack']) || isset($HTTP_POST_VARS['import_pack']) )

- //

- // Import a list a "Smiley Pack"

- //

- $smile_pak = ( isset($HTTP_POST_VARS['smile_pak']) ) ? $HTTP_POST_VARS['smile_pak'] : $HTTP_GET_VARS['smile_pak'];

- $clear_current = ( isset($HTTP_POST_VARS['clear_current']) ) ? $HTTP_POST_VARS['clear_current'] : $HTTP_GET_VARS['clear_current'];

- $replace_existing = ( isset($HTTP_POST_VARS['replace']) ) ? intval($HTTP_POST_VARS['replace']) : intval($HTTP_GET_VARS['replace']);

-

- if ( !empty($smile_pak) )

- // The user has already selected a smile_pak file.. Import it.

- if ( !empty($clear_current) )

- $sql = "DELETE

- FROM " . SMILIES_TABLE;

- $db->sql_query($sql);

- $sql = "SELECT code

- FROM ". SMILIES_TABLE;

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

- $cur_smilies = $db->sql_fetchrowset($result);

-

- for( $i = 0; $i < count($cur_smilies); $i++ )

- $k = $cur_smilies[$i]['code'];

- $smiles[$k] = 1;

- $fcontents = @file($phpbb_root_path . $board_config['smilies_path'] . '/'. $smile_pak);

- if ( empty($fcontents) )

- message_die(ERROR, "Couldn't read smiley pak file", "", __LINE__, __FILE__, $sql);

- for( $i = 0; $i < count($fcontents); $i++ )

- $smile_data = explode($delimeter, trim(addslashes($fcontents[$i])));

- for( $j = 2; $j < count($smile_data); $j++)

- // Replace > and < with the proper html_entities for matching.

- $smile_data[$j] = htmlentities($smile_data[$j]);

- $k = $smile_data[$j];

-

- if ( $smiles[$k] == 1 )

- {

- if ( !empty($replace_existing) )

- {

- $sql = "UPDATE " . SMILIES_TABLE . "

- SET smile_url = '" . str_replace("\'", "''", $smile_data[0]) . "', emoticon = '" . str_replace("\'", "''", $smile_data[1]) . "'

- WHERE code = '" . str_replace("\'", "''", $smile_data[$j]) . "'";

- }

- else

- {

- $sql = '';

- }

- }

- else

- {

- $sql = "INSERT INTO " . SMILIES_TABLE . " (code, smile_url, emoticon)

- VALUES('" . str_replace("\'", "''", $smile_data[$j]) . "', '" . str_replace("\'", "''", $smile_data[0]) . "', '" . str_replace("\'", "''", $smile_data[1]) . "')";

- }

- if ( $sql != '' )

- $db->sql_query($sql);

- message_die(MESSAGE, $lang['smiley_import_success']);

-

- //

- // Display the script to get the smile_pak cfg file...

- //

- $smile_paks_select = "<select name='smile_pak'><option value=''>" . $lang['Select_pak'] . "</option>";

-

- foreach ( $smiley_paks as $key => $value )

- if ( !empty($value) )

- $smile_paks_select .= "<option>" . $value . "</option>";

- $smile_paks_select .= "</select>";

- $hidden_vars = "<input type='hidden' name='mode' value='import'>";

- $template->set_filenames(array(

- "body" => "admin/smile_import_body.tpl")

- );

- $template->assign_vars(array(

- "L_SMILEY_TITLE" => $lang['smiley_title'],

- "L_SMILEY_EXPLAIN" => $lang['smiley_import_inst'],

- "L_SMILEY_IMPORT" => $lang['smiley_import'],

- "L_SELECT_LBL" => $lang['choose_smile_pak'],

- "L_IMPORT" => $lang['import'],

- "L_CONFLICTS" => $lang['smile_conflicts'],

- "L_DEL_EXISTING" => $lang['del_existing_smileys'],

- "L_REPLACE_EXISTING" => $lang['replace_existing'],

- "L_KEEP_EXISTING" => $lang['keep_existing'],

-

- "S_SMILEY_ACTION" => append_sid("admin_smilies.$phpEx"),

- "S_SMILE_SELECT" => $smile_paks_select,

- "S_HIDDEN_FIELDS" => $hidden_vars)

- );

- $template->pparse("body");

-else if ( isset($HTTP_POST_VARS['export_pack']) || isset($HTTP_GET_VARS['export_pack']) )

- //

- // Export our smiley config as a smiley pak...

- //

- if ( $HTTP_GET_VARS['export_pack'] == "send" )

- {

- $sql = "SELECT *

- FROM " . SMILIES_TABLE;

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

-

- $resultset = $db->sql_fetchrowset($result);

-

- $smile_pak = '';

- for($i = 0; $i < count($resultset); $i++ )

- {

- $smile_pak .= $resultset[$i]['smile_url'] . $delimeter;

- $smile_pak .= $resultset[$i]['emoticon'] . $delimeter;

- $smile_pak .= $resultset[$i]['code'] . "\n";

- }

- header("Content-Type: text/x-delimtext; name=\"smiles.pak\"");

- header("Content-disposition: attachment; filename=smiles.pak");

-

- echo $smile_pak;

-

- exit;

- message_die(MESSAGE, sprintf($lang['export_smiles'], '<a href="' . "admin_smilies.$phpEx$SID&amp;export_pack=send" . '">', '</a>'));

-else if( isset($HTTP_POST_VARS['add']) )

- //

- // Admin has selected to add a smiley.

- //

-

- $template->set_filenames(array(

- "body" => "admin/smile_edit_body.tpl")

- );

-

- $filename_list = "";

- for( $i = 0; $i < count($smiley_images); $i++ )

- $filename_list .= '<option value="' . $smiley_images[$i] . '">' . $smiley_images[$i] . '</option>';

- $s_hidden_fields = '<input type="hidden" name="mode" value="savenew" />';

-

- $template->assign_vars(array(

- "L_SMILEY_TITLE" => $lang['smiley_title'],

- "L_SMILEY_CONFIG" => $lang['smiley_config'],

- "L_SMILEY_EXPLAIN" => $lang['smiley_instr'],

- "L_SMILEY_CODE" => $lang['smiley_code'],

- "L_SMILEY_URL" => $lang['smiley_url'],

- "L_SMILEY_EMOTION" => $lang['smiley_emot'],

- "L_SUBMIT" => $lang['Submit'],

- "L_RESET" => $lang['Reset'],

- "SMILEY_IMG" => $phpbb_root_path . $board_config['smilies_path'] . '/' . $smiley_images[0],

- "S_SMILEY_ACTION" => append_sid("admin_smilies.$phpEx"),

- "S_HIDDEN_FIELDS" => $s_hidden_fields,

- "S_FILENAME_OPTIONS" => $filename_list,

- "S_SMILEY_BASEDIR" => $phpbb_root_path . $board_config['smilies_path'])

- );

- $template->pparse("body");

-//

-//

-//

-switch( $mode )

-

- $smiley_id = ( !empty($HTTP_POST_VARS['id']) ) ? intval($HTTP_POST_VARS['id']) : intval($HTTP_GET_VARS['id']);

-

- $sql = "DELETE FROM " . SMILIES_TABLE . "

- WHERE smilies_id = " . $smiley_id;

- $db->sql_query($sql);

-

- message_die(GENERAL_MESSAGE, $lang['smiley_del_success']);

- break;

- $smiley_id = ( !empty($HTTP_POST_VARS['id']) ) ? intval($HTTP_POST_VARS['id']) : intval($HTTP_GET_VARS['id']);

-

- $sql = "SELECT *

- FROM " . SMILIES_TABLE . "

- WHERE smilies_id = " . $smiley_id;

-

- $filename_list = "";

- for( $i = 0; $i < count($smiley_images); $i++ )

-// $selected =

- if( $smiley_images[$i] == $smile_data['smile_url'] )

- $smiley_selected = "selected=\"selected\"";

- $smiley_edit_img = $smiley_images[$i];

- $smiley_selected = "";

- $filename_list .= '<option value="' . $smiley_images[$i] . '"' . $smiley_selected . '>' . $smiley_images[$i] . '</option>';

- $template->set_filenames(array(

- "body" => "admin/smile_edit_body.tpl")

- );

-

- $s_hidden_fields = '<input type="hidden" name="mode" value="save" /><input type="hidden" name="smile_id" value="' . $smile_data['smilies_id'] . '" />';

-

- $template->assign_vars(array(

- "SMILEY_CODE" => $smile_data['code'],

- "SMILEY_EMOTICON" => $smile_data['emoticon'],

-

- "L_SMILEY_TITLE" => $lang['smiley_title'],

- "L_SMILEY_CONFIG" => $lang['smiley_config'],

- "L_SMILEY_EXPLAIN" => $lang['smile_desc'],

- "L_SMILEY_CODE" => $lang['smiley_code'],

- "L_SMILEY_URL" => $lang['smiley_url'],

- "L_SMILEY_EMOTION" => $lang['smiley_emot'],

- "L_SUBMIT" => $lang['Submit'],

- "L_RESET" => $lang['Reset'],

-

- "SMILEY_IMG" => $phpbb_root_path . $board_config['smilies_path'] . '/' . $smiley_edit_img,

-

- "S_SMILEY_ACTION" => append_sid("admin_smilies.$phpEx"),

- "S_HIDDEN_FIELDS" => $s_hidden_fields,

- "S_FILENAME_OPTIONS" => $filename_list,

- "S_SMILEY_BASEDIR" => $phpbb_root_path . $board_config['smilies_path'])

- );

-

- $template->pparse("body");

- break;

-

- case 'save':

-

- //

- // Get the submitted data, being careful to ensure that we only

- // accept the data we are looking for.

- //

- $smile_code = ( isset($HTTP_POST_VARS['smile_code']) ) ? $HTTP_POST_VARS['smile_code'] : $HTTP_GET_VARS['smile_code'];

- $smile_url = ( isset($HTTP_POST_VARS['smile_url']) ) ? $HTTP_POST_VARS['smile_url'] : $HTTP_GET_VARS['smile_url'];

- $smile_emotion = ( isset($HTTP_POST_VARS['smile_emotion']) ) ? $HTTP_POST_VARS['smile_emotion'] : $HTTP_GET_VARS['smile_emotion'];

- $smile_id = ( isset($HTTP_POST_VARS['smile_id']) ) ? intval($HTTP_POST_VARS['smile_id']) : intval($HTTP_GET_VARS['smile_id']);

- $smile_code = htmlspecialchars($smile_code);

- //

- // Proceed with updating the smiley table.

- //

- $sql = "UPDATE " . SMILIES_TABLE . "

- SET code = '" . str_replace("\'", "''", $smile_code) . "', smile_url = '" . str_replace("\'", "''", $smile_url) . "', emoticon = '" . str_replace("\'", "''", $smile_emotion) . "'

- WHERE smilies_id = $smile_id";

- $db->sql_query($sql);

- message_die(MESSAGE, $lang['smiley_edit_success']);

- case 'savenew':

- //

- // Get the submitted data being careful to ensure the the data

- // we recieve and process is only the data we are looking for.

- //

- $smile_code = ( isset($HTTP_POST_VARS['smile_code']) ) ? $HTTP_POST_VARS['smile_code'] : $HTTP_GET_VARS['smile_code'];

- $smile_url = ( isset($HTTP_POST_VARS['smile_url']) ) ? $HTTP_POST_VARS['smile_url'] : $HTTP_GET_VARS['smile_url'];

- $smile_emotion = ( isset($HTTP_POST_VARS['smile_emotion']) ) ? $HTTP_POST_VARS['smile_emotion'] : $HTTP_GET_VARS['smile_emotion'];

-

- $smile_code = htmlspecialchars($smile_code);

-

- //

- // Save the data to the smiley table.

- //

- $sql = "INSERT INTO " . SMILIES_TABLE . " (code, smile_url, emoticon)

- VALUES ('" . str_replace("\'", "''", $smile_code) . "', '" . str_replace("\'", "''", $smile_url) . "', '" . str_replace("\'", "''", $smile_emotion) . "')";

- $db->sql_query($sql);

-

- message_die(MESSAGE, $lang['smiley_add_success']);

- break;

- $sql = "SELECT *

- FROM " . SMILIES_TABLE;

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

-

-

-<form method="post" action="<?php echo "admin_smilies.$phpEx$SID"; ?>"><table class="bg" cellspacing="1" cellpadding="4" border="0" align="center">

- if ( $row = $db->sql_fetchrow($result) )

- <td class="<?php echo $row_class; ?>" align="center"><a href="<?php echo "admin_smilies.$phpEx$SID&amp;mode=edit&amp;id=" . $row['smilies_id']; ?>"><?php echo $lang['Edit']; ?></a></td>

- <td class="<?php echo $row_class; ?>" align="center"><a href="<?php echo "admin_smilies.$phpEx$SID&amp;mode=delete&amp;id=" . $row['smilies_id']; ?>"><?php echo $lang['Delete']; ?></a></td>

- <td class="cat" colspan="5" align="center"><input type="submit" name="add" value="<?php echo $lang['smile_add']; ?>" class="mainoption" />&nbsp;&nbsp;<input class="liteoption" type="submit" name="import_pack" value="<?php echo $lang['import_smile_pack']; ?>">&nbsp;&nbsp;<input class="liteoption" type="submit" name="export_pack" value="<?php echo $lang['export_smile_pack']; ?>"></td>

-

- $values[] = str_replace("'", "''", $var);

- if (is_null($var)

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

-

-$lang['smiley_config'] = 'Smiley Configuration';

-$lang['smiley_code'] = 'Smiley Code';

-$lang['smiley_url'] = 'Smiley Image File';

-$lang['smiley_emot'] = 'Smiley Emotion';

-$lang['smile_add'] = 'Add a new Smiley';

-$lang['Select_pak'] = 'Select Pack (.pak) File';

-$lang['replace_existing'] = 'Replace Existing Smiley';

-$lang['keep_existing'] = 'Keep Existing Smiley';

-$lang['smiley_import_inst'] = 'You should unzip the smiley package and upload all files to the appropriate Smiley directory for your installation. Then select the correct information in this form to import the smiley pack.';

-$lang['smiley_import'] = 'Smiley Pack Import';

-$lang['choose_smile_pak'] = 'Choose a Smile Pack .pak file';

-$lang['import'] = 'Import Smileys';

-$lang['smile_conflicts'] = 'What should be done in case of conflicts';

-$lang['del_existing_smileys'] = 'Delete existing smileys before import';

-$lang['import_smile_pack'] = 'Import Smiley Pack';

-$lang['export_smile_pack'] = 'Create Smiley Pack';

-$lang['export_smiles'] = 'To create a smiley pack from your currently installed smileys, click %sHere%s to download the smiles.pak file. Name this file appropriately making sure to keep the .pak file extension. Then create a zip file containing all of your smiley images plus this .pak configuration file.';

-

-$lang['smiley_add_success'] = 'The Smiley was successfully added';

-$lang['smiley_edit_success'] = 'The Smiley was successfully updated';

-$lang['smiley_import_success'] = 'The Smiley Pack was imported successfully!';

-$lang['smiley_del_success'] = 'The Smiley was successfully removed';

-$lang['Click_return_smileadmin'] = 'Click %sHere%s to return to Smiley Administration';

-

-<h1>{L_SMILEY_TITLE}</h1>

-

-<p>{L_SMILEY_EXPLAIN}</p>

-

-<script language="javascript" type="text/javascript">

-<!--

-function update_smiley(newimage)

-{

- document.smiley_image.src = "{S_SMILEY_BASEDIR}/" + newimage;

-}

-//-->

-</script>

-

-<form method="post" action="{S_SMILEY_ACTION}"><table class="forumline" cellspacing="1" cellpadding="4" border="0" align="center">

- <tr>

- <th class="thHead" colspan="2">{L_SMILEY_CONFIG}</th>

- </tr>

- <tr>

- <td class="row2">{L_SMILEY_CODE}</td>

- <td class="row2"><input type="text" name="smile_code" value="{SMILEY_CODE}" /></td>

- </tr>

- <tr>

- <td class="row1">{L_SMILEY_URL}</td>

- <td class="row1"><select name="smile_url" onchange="update_smiley(this.options[selectedIndex].value);">{S_FILENAME_OPTIONS}</select> &nbsp; <img name="smiley_image" src="{SMILEY_IMG}" border="0" alt="" /> &nbsp;</td>

- </tr>

- <tr>

- <td class="row2">{L_SMILEY_EMOTION}</td>

- <td class="row2"><input type="text" name="smile_emotion" value="{SMILEY_EMOTICON}" /></td>

- </tr>

- <tr>

- <td class="catBottom" colspan="2" align="center">{S_HIDDEN_FIELDS}<input class="mainoption" type="submit" value="{L_SUBMIT}" /></td>

- </tr>

-</table></form>

-

-<h1>{L_SMILEY_TITLE}</h1>

-

-<p>{L_SMILEY_EXPLAIN}</p>

-

-<form method="post" action="{S_SMILEY_ACTION}"><table class="forumline" cellspacing="1" cellpadding="4" border="0" align="center">

- <tr>

- <th class="thHead" colspan="2">{L_SMILEY_IMPORT}</th>

- </tr>

- <tr>

- <td class="row2">{L_SELECT_LBL}</td>

- <td class="row2">{S_SMILE_SELECT}</td>

- </tr>

- <tr>

- <td class="row1">{L_DEL_EXISTING}</td>

- <td class="row1"><input type="checkbox" name="clear_current" value="1" /></td>

- </tr>

- <tr>

- <td class="row2" colspan="2" align="center">{L_CONFLICTS}<br /><input type="radio" name="replace" value="1" checked="checked"/> {L_REPLACE_EXISTING} &nbsp; <input type="radio" name="replace" value="0" /> {L_KEEP_EXISTING}</td>

- </tr>

- <tr>

- <td class="catBottom" colspan="2" align="center">{S_HIDDEN_FIELDS}<input class="mainoption" name="import_pack" type="submit" value="{L_IMPORT}" /></td>

- </tr>

-</table></form>

-

-<h1>{L_SMILEY_TITLE}</h1>

-

-<P>{L_SMILEY_TEXT}</p>

-

-<form method="post" action="{S_SMILEY_ACTION}"><table cellspacing="1" cellpadding="4" border="0" align="center" class="forumline">

- <tr>

- <th class="thCornerL">{L_CODE}</th>

- <th class="thTop">{L_SMILE}</th>

- <th class="thTop">{L_EMOT}</th>

- <th colspan="2" class="thCornerR">{L_ACTION}</th>

- </tr>

- <!-- BEGIN smiles -->

- <tr>

- <td class="{smiles.ROW_CLASS}">{smiles.CODE}</td>

- <td class="{smiles.ROW_CLASS}"><img src="{smiles.SMILEY_IMG}" alt="{smiles.CODE}" /></td>

- <td class="{smiles.ROW_CLASS}">{smiles.EMOT}</td>

- <td class="{smiles.ROW_CLASS}"><a href="{smiles.U_SMILEY_EDIT}">{L_EDIT}</a></td>

- <td class="{smiles.ROW_CLASS}"><a href="{smiles.U_SMILEY_DELETE}">{L_DELETE}</a></td>

- </tr>

- <!-- END smiles -->

- <tr>

- <td class="catBottom" colspan="5" align="center">{S_HIDDEN_FIELDS}<input type="submit" name="add" value="{L_SMILEY_ADD}" class="mainoption" />&nbsp;&nbsp;<input class="liteoption" type="submit" name="import_pack" value="{L_IMPORT_PACK}">&nbsp;&nbsp;<input class="liteoption" type="submit" name="export_pack" value="{L_EXPORT_PACK}"></td>

- </tr>

-</table></form>