smilies order MOD

Hulp nodig bij een modificaties of op zoek naar een MOD? Bekijk ons archief. Support wordt helaas niet meer verleend.
Forumregels

Sinds 1 januari 2009 wordt phpBB2 niet meer ondersteund.
Onderstaande informatie is verouderd en dient uitsluitend als archief.
phpBB2.0.x
Gesloten
heetmeel50
Berichten: 21
Lid geworden op: 14 mei 2004, 22:04

smilies order MOD

Bericht door heetmeel50 » 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!

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" />&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>

#
#-----[ 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

Gebruikersavatar
Stef
Berichten: 9080
Lid geworden op: 04 jun 2003, 20:47

Bericht door Stef » 09 jan 2005, 00:31

Heb je hem zelf al eens doorgelopen? :)
Desnoods moet je even admin_smilies.php en smilies_list_body.tpl online zetten.

Gesloten