錯誤
SQL 語法 :
INSERT INTO phpbb_config( config_name, config_value )
VALUES (
'allow_post_cash', '0'
)
MySQL 傳回：
#1062 - Duplicate entry 'allow_post_cash' for key 1
##############################################################
## MOD Title: Appraise Post Mod
## MOD Author: Ray < blue_sky_ray@hotmail.com > (Ray Fung) http://optional.iradio.com.tw/phpbbx
## MOD Description: Appraise Post Mod for users to appraise a post good or bad.
## MOD Version: 1.1.0
##
## Installation Level: Intermediate
## Installation Time: 30 Minutes
## Files To Edit: viewtopic.php
## admin/admin_board.php
## includes/usercp_viewprofile.php
## language/lang_english/lang_main.php
## language/lang_english/lang_admin.php
## templates/subSilver/profile_view_body.tpl
## templates/subSilver/subSilver.cfg
## templates/subSilver/viewtopic_body.tpl
## templates/subSilver/admin/board_config_body.tpl
## Included Files: includes/functions_appraise.php
## templates/subSilver/images/good.gif
## templates/subSilver/images/bad.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:
##
## This is my mod... (I don't know what can i say
)##
##############################################################
## MOD History:
##
## 2003-04-11 - Version 1.1.0
## - Appraise Post Mod rewrited
##
## 2003-04-10 - Version 1.0.1
## 2003-04-10 - Version 1.0.0
##
##############################################################
## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD
##############################################################
#
#-----[ COPY ]------------------------------------------
#
copy root/includes/functions_appraise.php to includes/functions_appraise.php
copy root/templates/subSilver/images/good.gif to templates/subSilver/images/good.gif
copy root/templates/subSilver/images/bad.gif to templates/subSilver/images/bad.gif
#
#-----[ SQL ]------------------------------------------
#
INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_post_cash','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('goodpost_cash','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('badpost_cash','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('appraise_post_cash','');
ALTER TABLE phpbb_users ADD user_goodpost MEDIUMINT(8) NOT NULL default '0';
ALTER TABLE phpbb_users ADD user_badpost MEDIUMINT(8) NOT NULL default '0';
ALTER TABLE phpbb_users ADD user_givengoodpost MEDIUMINT(8) NOT NULL default '0';
ALTER TABLE phpbb_users ADD user_givenbadpost MEDIUMINT(8) NOT NULL default '0';
ALTER TABLE phpbb_posts_text ADD goodpost MEDIUMINT(8) UNSIGNED DEFAULT '0' NOT NULL,
ALTER TABLE phpbb_posts_text ADD badpost MEDIUMINT(8) UNSIGNED DEFAULT '0' NOT NULL,
ALTER TABLE phpbb_posts_text ADD appraise_post_user TEXT NOT NULL;
