seven sign reset???
Posted: Tue Apr 15, 2008 2:42 pm
Hello...How can i reset seven seal status?
Code: Select all
DROP TABLE `seven_signs_status`;
DROP TABLE `seven_signs_festival`;
DROP TABLE `seven_signs`;Code: Select all
-- ---------------------------
-- Table structure for `seven_signs_status`
-- ---------------------------
CREATE TABLE IF NOT EXISTS `seven_signs_status` (
`id` int(3) NOT NULL default '0',
`current_cycle` int(10) NOT NULL default '1',
`festival_cycle` int(10) NOT NULL default '1',
`active_period` int(10) NOT NULL default '1',
`date` int(10) NOT NULL default '1',
`previous_winner` int(10) NOT NULL default '0',
`dawn_stone_score` DECIMAL(20,0) NOT NULL default '0',
`dawn_festival_score` int(10) NOT NULL default '0',
`dusk_stone_score` DECIMAL(20,0) NOT NULL default '0',
`dusk_festival_score` int(10) NOT NULL default '0',
`avarice_owner` int(10) NOT NULL default '0',
`gnosis_owner` int(10) NOT NULL default '0',
`strife_owner` int(10) NOT NULL default '0',
`avarice_dawn_score` int(10) NOT NULL default '0',
`gnosis_dawn_score` int(10) NOT NULL default '0',
`strife_dawn_score` int(10) NOT NULL default '0',
`avarice_dusk_score` int(10) NOT NULL default '0',
`gnosis_dusk_score` int(10) NOT NULL default '0',
`strife_dusk_score` int(10) NOT NULL default '0',
`accumulated_bonus0` int(10) NOT NULL default '0',
`accumulated_bonus1` int(10) NOT NULL default '0',
`accumulated_bonus2` int(10) NOT NULL default '0',
`accumulated_bonus3` int(10) NOT NULL default '0',
`accumulated_bonus4` int(10) NOT NULL default '0',
PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8;
INSERT IGNORE INTO `seven_signs_status` VALUES
(0,1,1,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);Code: Select all
-- ----------------------------
-- Table structure for `seven_signs_festival`
-- ----------------------------
CREATE TABLE IF NOT EXISTS `seven_signs_festival` (
`festivalId` int(1) NOT NULL default '0',
`cabal` varchar(4) NOT NULL default '',
`cycle` int(4) NOT NULL default '0',
`date` bigint(50) default '0',
`score` int(5) NOT NULL default '0',
`members` varchar(255) NOT NULL default '',
PRIMARY KEY (`festivalId`,`cabal`,`cycle`))
DEFAULT CHARSET=utf8;
INSERT IGNORE INTO `seven_signs_festival` VALUES
(0, "dawn", 1, 0, 0, ""),
(1, "dawn", 1, 0, 0, ""),
(2, "dawn", 1, 0, 0, ""),
(3, "dawn", 1, 0, 0, ""),
(4, "dawn", 1, 0, 0, ""),
(0, "dusk", 1, 0, 0, ""),
(1, "dusk", 1, 0, 0, ""),
(2, "dusk", 1, 0, 0, ""),
(3, "dusk", 1, 0, 0, ""),
(4, "dusk", 1, 0, 0, "");Code: Select all
-- ---------------------------
-- Table structure for `seven_signs`
-- ---------------------------
CREATE TABLE IF NOT EXISTS `seven_signs` (
`char_obj_id` INT NOT NULL default '0',
`cabal` VARCHAR(4) NOT NULL default '',
`seal` INT(1) NOT NULL default '0',
`red_stones` INT NOT NULL default '0',
`green_stones` INT NOT NULL default '0',
`blue_stones` INT NOT NULL default '0',
`ancient_adena_amount` DECIMAL(20,0) NOT NULL default '0',
`contribution_score` DECIMAL(20,0) NOT NULL default '0',
PRIMARY KEY (`char_obj_id`)
) DEFAULT CHARSET=utf8;
