seven sign reset???

[rix4mees]

Hello...How can i reset seven seal status?

[Shaigan]

Find the seven sign table, delete them :

Code: Select all

DROP TABLE `seven_signs_status`;
DROP TABLE `seven_signs_festival`;
DROP TABLE `seven_signs`;

Then, after that, apply the SQL queries located in the SQL folder of your datapack :

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;

[rix4mees]

TY

[Shaigan]

NP

[GodKratos]

or much easier.... just truncate each table.

[Shaigan]

Are you sure ?

He'll need to update his database after that, and I'm not sure the update forum will repair the lost data.

Looking (with attention, not just reading in 15 seconds) the SQL queries will learn you that only the "seven_signs" table have no data by default. The two other have only one line and this line is always modified by game server. Trunkate will make the server buggy... Erasing all and redoing it with the original files from SVN is, I think, the best solution to learn how it works and to make no bug.

[Shaigan]

-sorry, lag-

[GodKratos]

Oh you are actually adding data back into those tables?

Thought you were just removing the data from them

Maybe I shoulda read the sql imports properly lol

[Shaigan]

Code: Select all

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

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, "");