##############################################################
## MOD Title:		Smilies Album
## MOD Author: OXPUS < webmaster@oxpus.de > (Karsten Ude) http://www.oxpus.de
## MOD Description:	This is a phpBB-based smilies album.
## MOD Version:		1.3.4
##
## Installation Level:	easy
## Installation Time:	2-5 minutes
## Files To Edit:	5
##			viewonline.php
##			admin/index.php
##			includes/page_header.php
##			templates/subSilver/overall_header.tpl
##			templates/subSilver/subSilver.cfg
##
## Included Files:	16
##			smilies.php
##			smilies_delete.php
##			smilies_rate.php
##			smilies_upload.php
##			admin/admin_smilies_config.tpl
##			language/lang_english/lang_admin_smilies.php
##			language/lang_german/lang_admin_smilies.php
##			language/lang_english/lang_main_smilies.php
##			language/lang_german/lang_main_smilies.php
##			smilies_mod/smilie_common.php
##			templates/subSilver/smilies_cat_body.tpl
##			templates/subSilver/smilies_rate_body.tpl
##			templates/subSilver/smilies_upload_body.tpl
##			templates/subSilver/admin/smilies_config_body.tpl
##			templates/subSilver/images/lang_english/upload_pic.gif
##			templates/subSilver/images/lang_german/upload_pic.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:
##
## Instead entering the given SQL-Statement, you can upload the file
## smilies_page_db_update.php to your phpbb root directory and run this with your browser.
## This file will do all nessassary changes in the database for you.
## After using this file, please delete it to avoid errors.
##
## Create folder: smilies_mod/upload
## CHMOD 777 smilies_mod/upload
##
##############################################################
## MOD History:
##
##   2005-04-03 - Version 1.3.4
##	- Replace rate window with a popup
##	  For update just replace all files which comes with this mod
##
##   2005-04-02 - Version 1.3.3
##	- Fix issue on canceling rating
##	  For update replace the files smilies_rate.php and smilies_rate_body.tpl
##
##   2004-11-11 - Version 1.3.2
##	- Fix lang error for guests or not installed languages
##	  For update replace smilies_common.php
##
##   2004-10-22 - Version 1.3.1
##	- Fix returning to last page after rating
##	  For update replace
##		smilies.php
##		smilies_rate.php
##		smilies_cat_body.tpl
##		smilies_rate_body.tpl
##
##   2004-10-21 - Version 1.3.0
##	- ADD Sorting smilies by rate points.
##	  For update replace smilies.php and smilies_cat_body.tpl
##
##   2004-03-04 - Version 1.2.2
##	- Fix little layout bug.
##	  For update replace smilies.php
##
##   2004-02-29 - Version 1.2.1
##	- Fix reload album after rating. Rating window is now not longer a popup.
##	  For update replace templates/subSilver/smilies_cat_body.tpl
##
##   2004-02-22 - Version 1.2.0
##	- Add smilies rating
##
##   2004-02-14 - Version 1.1.0
##	- Add configuration per ACP for various settings
##
##   2004-02-08 - Version 1.0.2
##      - Fix a typo in the HowTo
##
##   2004-01-29 - Version 1.0.1
##      - Fix some bugs. Replace for update:
##	  smilies.php
##	  smilies_update.php
##	  smilies_mod/smilies_common.php
##	  templates/subSilver/smilies_cat_body.tpl
##
##   2004-01-27 - Version 1.0.0
##      - First release
##
##############################################################
## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD
##############################################################

#
#-----[ SQL ]-------------------------------------------------------
#
CREATE TABLE phpbb_smilies_page (
	pic_id int(11) UNSIGNED NOT NULL auto_increment,
	pic_filename varchar(255) NOT NULL,
	pic_title varchar(255) NOT NULL,
	pic_user_id mediumint(8) NOT NULL,
	pic_username varchar(32),
	pic_time int(11) UNSIGNED NOT NULL,
PRIMARY KEY (pic_id),
KEY pic_user_id (pic_user_id),
KEY pic_time (pic_time)
);

CREATE TABLE phpbb_smilies_config (
  config_name varchar(255) NOT NULL default '',
  config_value varchar(255) NOT NULL default '',
  PRIMARY KEY  (config_name)
) TYPE=MyISAM;

CREATE TABLE phpbb_smilies_album_rate (
	rate_pic_id int(11) UNSIGNED NOT NULL,
	rate_user_id mediumint(8) NOT NULL,
	rate_point tinyint(3) UNSIGNED NOT NULL,
	KEY rate_pic_id (rate_pic_id),
	KEY rate_user_id (rate_user_id),
	KEY rate_point (rate_point)
) TYPE=MyISAM;

INSERT INTO phpbb_smilies_config (config_name, config_value) VALUES ('max_file_size', 50000);
INSERT INTO phpbb_smilies_config (config_name, config_value) VALUES ('cols_per_page', 10);
INSERT INTO phpbb_smilies_config (config_name, config_value) VALUES ('rows_per_page', 10);
INSERT INTO phpbb_smilies_config (config_name, config_value) VALUES ('access_level', 0);
INSERT INTO phpbb_smilies_config (config_name, config_value) VALUES ('version', '1.1.0');

#
#-----[ COPY ]-------------------------------------------------------
#
copy smilies.php to smilies.php
copy smilies_delete.php to smilies_delete.php
copy smilies_rate.php to smilies_rate.php
copy smilies_upload.tpl to smilies_upload.tpl
copy admin/admin_smilies_config.php to admin/admin_smilies_config.php
copy language/lang_english/lang_admin_smilies.php to language/lang_english/lang_admin_smilies.php
copy language/lang_german/lang_admin_smilies.php to language/lang_german/lang_admin_smilies.php
copy language/lang_english/lang_main_smilies.php to language/lang_english/lang_main_smilies.php
copy language/lang_german/lang_main_smilies.php to language/lang_german/lang_main_smilies.php
copy smilies_mod/smilie_common.php to smilies_mod/smilie_common.php
copy templates/subSilver/smilies_cat_body.tpl to templates/subSilver/smilies_cat_body.tpl
copy templates/subSilver/smilies_rate_body.tpl to templates/subSilver/smilies_rate_body.tpl
copy templates/subSilver/smilies_upload_body.tpl to templates/subSilver/smilies_upload_body.tpl
copy templates/subSilver/admin/smilies_config_body.tpl to templates/subSilver/admin/smilies_config_body.tpl
copy templates/subSilver/images/lang_english/upload_pic.gif to templates/subSilver/images/lang_english/upload_pic.gif
copy templates/subSilver/images/lang_german/upload_pic.gif to templates/subSilver/images/lang_german/upload_pic.gif

#
#-----[ OPEN ]-------------------------------------------------------
#
viewonline.php

#
#-----[ FIND ]----------------------------------------
#
				case PAGE_FAQ:
					$location = $lang['Viewing_FAQ'];
					$location_url = "faq.$phpEx";
					break;

#
#-----[ AFTER, ADD ]----------------------------------
#
				case PAGE_SMILIES:
					$location = 'Smilie Album';
					$location_url = "smilies.$phpEx";
					break;


#
#-----[ OPEN ]-------------------------------------------------------
#
admin/index.php

#
#-----[ FIND ]----------------------------------------
#
						case PAGE_FAQ:
							$location = $lang['Viewing_FAQ'];
							$location_url = "index.$phpEx?pane=right";
							break;

#
#-----[ AFTER, ADD ]----------------------------------
#
						case PAGE_SMILIES:
							$location = 'Smilies';
							$location_url = "index.$phpEx?pane=right";
							break;

#
#-----[ FIND ]----------------------------------------
#
					case PAGE_FAQ:
						$location = $lang['Viewing_FAQ'];
						$location_url = "index.$phpEx?pane=right";
						break;

#
#-----[ AFTER, ADD ]----------------------------------
#
					case PAGE_SMILIES:
						$location = 'Smilies';
						$location_url = "index.$phpEx?pane=right";
						break;

#
#-----[ OPEN ]-------------------------------------------------------
#
includes/constants.php

#
#-----[ FIND ]-------------------------------------------------------
#
define('PAGE_GROUPCP', -11);

#
#-----[ AFTER, ADD ]-------------------------------------------------------
# Increase -12 to the next free number if already in use
define('PAGE_SMILIES', -12);

#
#-----[ OPEN ]-------------------------------------------------------
#
includes/page_header.php

#
#-----[ FIND ]----------------------------------------
#
	'U_GROUP_CP' => append_sid('groupcp.'.$phpEx),

#
#-----[ AFTER, ADD ]----------------------------------
#
	// Smilies MOD
	'L_SMILIES' => 'Smilie Album',
	'U_SMILIES' => append_sid('smilies.'.$phpEx),

#
#-----[ OPEN ]-------------------------------------------------------
#
templates/subSilver/overall_header.tpl

#
#-----[ FIND ]----------------------------------------
#
<td align="center" width="100%" valign="middle"><span class="maintitle">{SITENAME}</span><br /><span class="gen">{SITE_DESCRIPTION}<br />&nbsp; </span>
				<table cellspacing="0" cellpadding="2" border="0">
					<tr>
						<td align="center" valign="top" nowrap="nowrap"><span class="mainmenu">

#
#-----[ AFTER, ADD ]----------------------------------
#
<a href="{U_SMILIES}" class="mainmenu">{L_SMILIES}</a>&nbsp;

#
#-----[ OPEN ]-------------------------------------------------------
#
templates/subSilver/subSilver.cfg

#
#-----[ FIND ]----------------------------------------
#
?>

#
#-----[ BEFORE, ADD ]---------------------------------
#
$images['upload_pic'] = "$current_template_images/{LANG}/upload_pic.gif";


#
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------
#
# EoM