##############################################################
## MOD Title:		UPDATE Smilies Album
## MOD Author: OXPUS < webmaster@oxpus.de > (Karsten Ude) http://www.oxpus.de
## MOD Description:	Update Smilies Album from 1.1.0 to 1.2.0
## MOD Version:		1.0.0
##
## Installation Level:	Easy
## Installation Time:	1-2 minutes
## Files To Edit:	n/a
##
## Included Files:	n/a
##############################################################
## 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
## sp_db_update_120.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.
##
##############################################################
## MOD History:
##
##   2004-02-22 - 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_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;

#
#-----[ COPY ]-------------------------------------------------------
#
copy smilies.php to smilies.php
copy smilies_rate.php to milies_rate.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/smilies_common.php to smilies_mod/smilies_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


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