smilies order MOD
Geplaatst: 09 jan 2005, 00:28
als ik een smilie naar boven of onder wil verplaatsen in het admin gedeelte dan redirect die me weer naar index.php zonder de smilie te hebben verplaats 
ik heb de mod op phpbb.com getest en gaf geen error!
ik heb de mod op phpbb.com getest en gaf geen error!
Code: Selecteer alles
########################################################
## MOD Title: Smilies Order
## MOD Author: LifeIsPain < brian@orvp.net > (Brian Evans) n/a
## MOD Description: Allows for the smilies order to be changed from the admin panel and gives
## the ability to the Admin to specify if new smilies should be added before or after
## existing smilies.
## MOD Version: 1.0.0
##
## Installation Level: Intermediate
## Installation Time: 15 Minutes
##
## Files To Edit: 5
## - admin/admin_smilies.php
## - templates/subSilver/admin/smile_list_body.tpl
## - includes/functions_post.php
## - includes/constants.php
## - language/lang_english/lang_admin.php
##
## Included Files: arrow_down.gif, arrow_end.gif, arrow_top.gif, arrow_up.gif
##############################################################
## For Security Purposes, Please Check: http://www.phpbb.com/mods/ for the
## latest version of this MOD. Downloading this MOD from other sites could cause malicious code
## to enter into your phpBB Forum. As such, phpBB will not offer support for MOD's not offered
## in our MOD-Database, located at: http://www.phpbb.com/mods/
##############################################################
## Author Notes: At the bottom of the Smilies Editing Utilities main page, there will be an
## option for how to add smilies. This setting will effect how all smilies are added, both
## for one at a time smilies and imports from .pak files.
########################################################
## MOD History:
##
## v1.0.0 - 08/09/2003
## + submitted to MODs database
##
##############################################################
## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD
##############################################################
#
#-----[ SQL ]------------------------------------------
#
ALTER TABLE phpbb_smilies ADD smilies_order INT( 5 ) NOT NULL;
#
#-----[ SQL ]------------------------------------------
#
INSERT INTO phpbb_config VALUES ('smilies_insert', 1);
#
#-----[ COPY ]------------------------------------------
#
copy arrow_down.gif to templates/subSilver/images/arrow_down.gif
copy arrow_end.gif to templates/subSilver/images/arrow_end.gif
copy arrow_top.gif to templates/subSilver/images/arrow_top.gif
copy arrow_up.gif to templates/subSilver/images/arrow_up.gif
#
#-----[ OPEN ]------------------------------------------
#
admin/admin_smilies.php
#
#-----[ FIND ]------------------------------------------
#
for( $i = 0; $i < count($fcontents); $i++ )
#
#-----[ BEFORE, ADD ]------------------------------------------
#
if( $board_config['smilies_insert'] == TOP_LIST )
{
$sql = "SELECT MIN(smilies_order) AS smilies_extreme
FROM " . SMILIES_TABLE;
$shift_it = -10;
}
else
{
$sql = "SELECT MAX(smilies_order) AS smilies_extreme
FROM " . SMILIES_TABLE;
$shift_it = 10;
}
if( !$result = $db->sql_query($sql) )
{
message_die(GENERAL_ERROR, "Couldn't get extreme values from the smilies table", "", __LINE__, __FILE__, $sql);
}
$row = $db->sql_fetchrow($result);
$order_extreme = $row['smilies_extreme'] + $shift_it;
#
#-----[ FIND ]------------------------------------------
# NOTE: There are two instances of this, this is the first instance
#
$sql = "INSERT INTO " . SMILIES_TABLE
#
#-----[ IN-LINE FIND ]------------------------------------------
#
emoticon
#
#-----[ IN-LINE AFTER, ADD ]------------------------------------------
#
, smilies_order
#
#-----[ FIND ]------------------------------------------
#
VALUES('" . str_replace("\'", "''", $smile_data[$j])
#
#-----[ IN-LINE FIND ]------------------------------------------
#
$smile_data[1]) . "'
#
#-----[ IN-LINE AFTER, ADD ]------------------------------------------
#
, $order_extreme
#
#-----[ AFTER, ADD ]------------------------------------------
# NOTE: This line is to be the next full line after the line just edited
#
$order_extreme = $order_extreme + $shift_it;
#
#-----[ FIND ]------------------------------------------
#
$sql = "SELECT *
FROM " . SMILIES_TABLE;
#
#-----[ REPLACE WITH ]------------------------------------------
#
$sql = "SELECT *
FROM " . SMILIES_TABLE ."
ORDER BY smilies_order";
#
#-----[ FIND ]------------------------------------------
#
// Save the data to the smiley table.
//
#
#-----[ AFTER, ADD ]------------------------------------------
#
if( $board_config['smilies_insert'] == TOP_LIST )
{
$sql = "SELECT MIN(smilies_order) AS smilies_extreme
FROM " . SMILIES_TABLE;
$shift_it = -10;
}
else
{
$sql = "SELECT MAX(smilies_order) AS smilies_extreme
FROM " . SMILIES_TABLE;
$shift_it = 10;
}
if( !$result = $db->sql_query($sql) )
{
message_die(GENERAL_ERROR, "Couldn't get extreme values from the smilies table", "", __LINE__, __FILE__, $sql);
}
$row = $db->sql_fetchrow($result);
$order_extreme = $row['smilies_extreme'] + $shift_it;
#
#-----[ FIND ]------------------------------------------
#
$sql = "INSERT INTO " . SMILIES_TABLE
#
#-----[ IN-LINE FIND ]------------------------------------------
#
emoticon
#
#-----[ IN-LINE AFTER, ADD ]------------------------------------------
#
, smilies_order
#
#-----[ FIND ]------------------------------------------
#
VALUES ('" . str_replace("\'", "''", $smile_code)
#
#-----[ IN-LINE FIND ]------------------------------------------
#
$smile_emotion) . "'
#
#-----[ IN-LINE AFTER, ADD ]------------------------------------------
#
, $order_extreme
#
#-----[ FIND ]------------------------------------------
#
//
// This is the main display of the page before the admin has selected
#
#-----[ BEFORE, ADD ]------------------------------------------
#
if( $HTTP_GET_VARS['option'] == 'select' && isset($HTTP_POST_VARS['insert_position']) )
{
$sql = "UPDATE " . CONFIG_TABLE . " SET
config_value = '" . $HTTP_POST_VARS['insert_position'] . "'
WHERE config_name = 'smilies_insert'";
if( !$db->sql_query($sql) )
{
message_die(GENERAL_ERROR, "Failed to update general configuration for smilies_insert", "", __LINE__, __FILE__, $sql);
}
$board_config['smilies_insert'] = $HTTP_POST_VARS['insert_position'];
}
if( $board_config['smilies_insert'] == TOP_LIST )
{
$pos_top_checked = ' selected="selected"';
$pos_bot_checked = '';
}
else
{
$pos_top_checked = '';
$pos_bot_checked = ' selected="selected"';
}
$position_select = '<select name="insert_position"><option value="' . TOP_LIST . '"' . $pos_top_checked . '>' . $lang['before'] . '</option><option value="' . BOTTOM_LIST . '"' . $pos_bot_checked . '>' . $lang['after'] . '</option></select>';
if( isset($HTTP_GET_VARS['move']) && isset($HTTP_GET_VARS['id']) )
{
$moveit = ($HTTP_GET_VARS['move'] == 'up') ? -15 : 15;
$sql = "UPDATE " . SMILIES_TABLE . "
SET smilies_order = smilies_order + $moveit
WHERE smilies_id = " . $HTTP_GET_VARS['id'];
if( !$result = $db->sql_query($sql) )
{
message_die(GENERAL_ERROR, "Couldn't change smilies order", "", __LINE__, __FILE__, $sql);
}
$i = 10;
$inc = 10;
$sql = "SELECT *
FROM " . SMILIES_TABLE . "
ORDER BY smilies_order";
if( !$result = $db->sql_query($sql) )
{
message_die(GENERAL_ERROR, "Couldn't query smilies order", "", __LINE__, __FILE__, $sql);
}
while ( $row = $db->sql_fetchrow($result) )
{
if ($row['smilies_order'] != $i)
{
$sql = "UPDATE " . SMILIES_TABLE . "
SET smilies_order = $i
WHERE smilies_id = " . $row['smilies_id'];
if( !$db->sql_query($sql) )
{
message_die(GENERAL_ERROR, "Couldn't update order fields", "", __LINE__, __FILE__, $sql);
}
}
$i += $inc;
}
}
else if( isset($HTTP_GET_VARS['send']) && isset($HTTP_GET_VARS['id']) )
{
if( $HTTP_GET_VARS['send'] == 'top' )
{
$sql = "SELECT MIN(smilies_order) AS smilies_extreme
FROM " . SMILIES_TABLE;
$shift_it = -10;
}
else
{
$sql = "SELECT MAX(smilies_order) AS smilies_extreme
FROM " . SMILIES_TABLE;
$shift_it = 10;
}
if( !$result = $db->sql_query($sql) )
{
message_die(GENERAL_ERROR, "Couldn't get extreme values from the smilies table", "", __LINE__, __FILE__, $sql);
}
$row = $db->sql_fetchrow($result);
$order_extreme = $row['smilies_extreme'] + $shift_it;
$sql = "UPDATE " . SMILIES_TABLE . "
SET smilies_order = $order_extreme
WHERE smilies_id = " . $HTTP_GET_VARS['id'];
if( !$result = $db->sql_query($sql) )
{
message_die(GENERAL_ERROR, "Couldn't change smilies order", "", __LINE__, __FILE__, $sql);
}
}
#
#-----[ FIND ]------------------------------------------
#
FROM " . SMILIES_TABLE;
#
#-----[ REPLACE WITH ]------------------------------------------
#
FROM " . SMILIES_TABLE . "
ORDER BY smilies_order";
#
#-----[ FIND ]------------------------------------------
#
"L_EXPORT_PACK" => $lang['export_smile_pack'],
#
#-----[ AFTER, ADD ]------------------------------------------
#
'L_MOVE' => $lang['Move'],
'L_MOVE_UP' => $lang['Move_up'],
'L_MOVE_DOWN' => $lang['Move_down'],
'L_MOVE_TOP' => $lang['Move_top'],
'L_MOVE_END' => $lang['Move_end'],
'L_POSITION_NEW_SMILIES' => $lang['position_new_smilies'],
'L_SMILEY_CHANGE_POSITION' => $lang['smiley_change_position'],
'L_SMILEY_CONFIG' => $lang['smiley_config'],
'POSITION_SELECT' => $position_select,
'S_POSITION_ACTION' => append_sid('admin_smilies.' . $phpEx . '?option=select'),
#
#-----[ FIND ]------------------------------------------
#
"U_SMILEY_EDIT" => append_sid("admin_smilies.$phpEx?mode=edit&id=" . $smilies[$i]['smilies_id']),
#
#-----[ BEFORE, ADD ]------------------------------------------
#
'U_SMILEY_MOVE_UP' => append_sid("admin_smilies.$phpEx?move=up&id=" . $smilies[$i]['smilies_id']),
'U_SMILEY_MOVE_DOWN' => append_sid("admin_smilies.$phpEx?move=down&id=" . $smilies[$i]['smilies_id']),
'U_SMILEY_MOVE_TOP' => append_sid("admin_smilies.$phpEx?send=top&id=" . $smilies[$i]['smilies_id']),
'U_SMILEY_MOVE_END' => append_sid("admin_smilies.$phpEx?send=end&id=" . $smilies[$i]['smilies_id']),
#
#-----[ OPEN ]------------------------------------------
#
templates/subSilver/admin/smile_list_body.tpl
#
#-----[ FIND ]------------------------------------------
#
<th class="thTop">{L_EMOT}</th>
#
#-----[ AFTER, ADD ]------------------------------------------
#
<th class="thTop">{L_MOVE}</th>
#
#-----[ FIND ]------------------------------------------
#
<td class="{smiles.ROW_CLASS}">{smiles.EMOT}</td>
#
#-----[ AFTER, ADD ]------------------------------------------
#
<td class="{smiles.ROW_CLASS}" align="center"><a href="{smiles.U_SMILEY_MOVE_TOP}"><img src="../templates/subSilver/images/arrow_top.gif" border="0" alt="{L_MOVE_TOP} " title="{L_MOVE_TOP}" /></a><a href="{smiles.U_SMILEY_MOVE_UP}"><img src="../templates/subSilver/images/arrow_up.gif" border="0" alt="{L_MOVE_UP} " title="{L_MOVE_UP}" /></a><a href="{smiles.U_SMILEY_MOVE_DOWN}"><img src="../templates/subSilver/images/arrow_down.gif" border="0" alt="{L_MOVE_DOWN} " title="{L_MOVE_DOWN}" /></a><a href="{smiles.U_SMILEY_MOVE_END}"><img src="../templates/subSilver/images/arrow_end.gif" border="0" alt="{L_MOVE_END} " title="{L_MOVE_END}" /></a></td>
#
#-----[ FIND ]------------------------------------------
#
<td class="catBottom" colspan="5" align="center">{S_HIDDEN_FIELDS}<input type="submit" name="add" value="{L_SMILEY_ADD}" class="mainoption" /> <input class="liteoption" type="submit" name="import_pack" value="{L_IMPORT_PACK}"> <input class="liteoption" type="submit" name="export_pack" value="{L_EXPORT_PACK}"></td>
#
#-----[ IN-LINE FIND ]------------------------------------------
#
5
#
#-----[ IN-LINE REPLACE WITH ]------------------------------------------
#
6
#
#-----[ FIND ]------------------------------------------
#
</table></form>
#
#-----[ AFTER, ADD ]------------------------------------------
#
<form method="post" action="{S_POSITION_ACTION}"><table cellspacing="1" cellpadding="4" border="0" align="center" class="forumline">
<tr><th class="thTop" colspan="2">{L_SMILEY_CONFIG}</th></tr>
<tr><td class="row1">{L_POSITION_NEW_SMILIES}</td><td class="row2">{POSITION_SELECT}</td></tr>
<tr><td class="catBottom" align="center" colspan="2">{S_HIDDEN_FIELDS}<input type="submit" name="change" value="{L_SMILEY_CHANGE_POSITION}" class="mainoption" /></td></tr>
</table></form>
#
#-----[ OPEN ]------------------------------------------
#
includes/functions_post.php
#
#-----[ FIND ]------------------------------------------
#
ORDER BY smilies_id";
#
#-----[ REPLACE WITH ]------------------------------------------
#
ORDER BY smilies_order";
#
#-----[ OPEN ]------------------------------------------
#
language/lang_english/lang_admin.php
#
#-----[ FIND ]------------------------------------------
# NOTE: This line is longer, add the next bit on a blank line
#
$lang['Click_return_smileadmin']
#
#-----[ AFTER, ADD ]------------------------------------------
#
$lang['position_new_smilies'] = 'Should new smilies be added before or after existing smilies?';
$lang['smiley_change_position'] = 'Change Insert Location';
$lang['before'] = 'Before';
$lang['after'] = 'After';
$lang['Move_top'] = 'Send to Top';
$lang['Move_end'] = 'Send to End';
#
#-----[ OPEN ]------------------------------------------
#
includes/constants.php
#
#-----[ FIND ]------------------------------------------
#
// Debug Level
#
#-----[ BEFORE, ADD ]------------------------------------------
#
// Smilies Order
define('TOP_LIST', -1);
define('BOTTOM_LIST', 1);
#
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------
#
# EoM