小弟已經趙大姐吩咐ㄑ作ㄌ..
代碼: 選擇全部
INSERT INTO phpbb_config VALUES ('rpg_jackpot', '100000');
ALTER TABLE phpbb_users
ADD `user_bank` int(11) unsigned NOT NULL default '0',
ADD `user_bank_time` int(11) default '0',
ADD `user_robfail` smallint(5) default '0',
ADD `rpg_rob_cnt` smallint(5) unsigned default '0',
ADD `rpg_robbed_cnt` smallint(5) unsigned default '0',
ADD `rpg_rob_succ` smallint(5) unsigned default '0',
ADD `rpg_rob_fail` smallint(5) unsigned default '0',
ADD `rpg_rob_money` int(11) unsigned default '0',
ADD `rpg_robbed_money` int(11) unsigned default '0';
CREATE TABLE `phpbb_rpg_bodyguard` (
`from_id` mediumint(8) NOT NULL default '0',
`to_id` mediumint(8) NOT NULL default '0',
`bodyguard_salary` int(11) NOT NULL default '0',
`yes_or_no` tinyint(1) NOT NULL default '0',
`invite_time` int(11) default '0'
) TYPE=MyISAM;
CREATE TABLE `phpbb_rpg_event` (
`user_id` mediumint(8) NOT NULL default '0',
`event_time` int(11) default NULL,
`event_class` smallint(5) default NULL,
`event_type` smallint(5) default NULL,
`event_money` int(11) default NULL,
`event_note` varchar(255) default NULL
) TYPE=MyISAM;
CREATE TABLE `phpbb_rpg_items` (
`item_id` mediumint(8) unsigned NOT NULL auto_increment,
`item_name` varchar(255) default NULL,
`item_description` varchar(255) default NULL,
`item_price` int(11) NOT NULL default '0',
`item_spec_price` smallint(5) NOT NULL default '0',
`item_type` tinyint(4) NOT NULL default '0',
`item_position` tinyint(4) NOT NULL default '0',
`need_to_use` tinyint(1) default '0',
`attack_property` mediumint(8) default '0',
`defense_property` mediumint(8) default '0',
`magic_property` mediumint(8) default '0',
`speed_property` mediumint(8) default '0',
`hp_property` mediumint(8) default '0',
`mp_property` mediumint(8) default '0',
PRIMARY KEY (`item_id`)
) TYPE=MyISAM;
CREATE TABLE `phpbb_rpg_jackpot` (
`username` varchar(25) default NULL,
`user_jackpot` int(11) default NULL,
`jackpot_date` int(11) default NULL
) TYPE=MyISAM;
CREATE TABLE `phpbb_rpg_owns` (
`own_id` mediumint(8) unsigned NOT NULL auto_increment,
`user_id` mediumint(8) NOT NULL default '0',
`item_id` mediumint(8) unsigned NOT NULL default '0',
PRIMARY KEY (`own_id`)
) TYPE=MyISAM;
CREATE TABLE `phpbb_rpg_rob` (
`attack_target` mediumint(8) NOT NULL default '0',
`target_name` varchar(25) default NULL,
`attack_id` mediumint(8) NOT NULL default '0',
`attack_name` varchar(25) default NULL,
`join_time` int(11) default '0',
`task_over` tinyint(1) NOT NULL default '0'
) TYPE=MyISAM;
INSERT INTO phpbb_rpg_items VALUES("1","拔釘器","解除草人的詛咒","10000","1","0","0","1","0","0","0","0","0","0");