flower 寫:請執行 medal_db_update.php
root/templates/subSilver/images/icon_mini_medal.gif 複製到 templates/subSilver/images/icon_mini_medal.gif
CREATE TABLE `phpbb_medal` ( `medal_id` mediumint(8) NOT NULL auto_increment, `cat_id` mediumint(8) unsigned NOT NULL default '1', `medal_name` varchar(40) NOT NULL default '', `medal_description` varchar(255) NOT NULL default '', `medal_image` varchar(40) default NULL, PRIMARY KEY (`medal_id`) ) TYPE=MyISAM
+++ Error: Table 'phpbb_medal' already exists
CREATE TABLE `phpbb_medal_user` ( `issue_id` mediumint(8) NOT NULL auto_increment, `medal_id` mediumint(8) NOT NULL default '', `user_id` mediumint(8) NOT NULL default '', `issue_reason` varchar(255) NOT NULL default '', `issue_time` int(11) NOT NULL default '', PRIMARY KEY (`issue_id`) ) TYPE=MyISAM
+++ Error: Table 'phpbb_medal_user' already exists
CREATE TABLE `phpbb_medal_mod` ( `mod_id` mediumint(8) unsigned NOT NULL auto_increment, `medal_id` mediumint(8) NOT NULL default '', `user_id` mediumint(8) NOT NULL default '', PRIMARY KEY (`mod_id`) ) TYPE=MyISAM
+++ Error: Table 'phpbb_medal_mod' already exists
CREATE TABLE `phpbb_medal_cat` ( `cat_id` mediumint(8) unsigned NOT NULL auto_increment, `cat_title` varchar(100) NOT NULL default '', `cat_order` mediumint(8) UNSIGNED NOT NULL default '0', PRIMARY KEY (`cat_id`), KEY `cat_order` (`cat_order`) ) TYPE=MyISAM AUTO_INCREMENT=2
+++ Error: Table 'phpbb_medal_cat' already exists
INSERT INTO `phpbb_config` VALUES ('allow_medal_dispaly', '0')
+++ Error: Duplicate entry 'allow_medal_dispaly' for key 1
INSERT INTO `phpbb_config` VALUES ('medal_display_row', '1')
+++ Error: Duplicate entry 'medal_display_row' for key 1
INSERT INTO `phpbb_config` VALUES ('medal_display_col', '1')
+++ Error: Duplicate entry 'medal_display_col' for key 1
INSERT INTO `phpbb_config` VALUES ('medal_display_width', '')
+++ Error: Duplicate entry 'medal_display_width' for key 1
INSERT INTO `phpbb_config` VALUES ('medal_display_height', '')
+++ Error: Duplicate entry 'medal_display_height' for key 1
INSERT INTO `phpbb_config` VALUES ('medal_display_order', '')
+++ Error: Duplicate entry 'medal_display_order' for key 1
INSERT INTO `phpbb_medal_cat` VALUES ('1', 'Default', '10')
+++ Error: Duplicate entry '1' for key 1
出現以上畫面.. 還是沒辦法正常運作...
gif 移過去了...