From 3d84ab74b0fa7bcc8e8b2775e1919c071fa7b6fb Mon Sep 17 00:00:00 2001 From: Rat Date: Sun, 29 Mar 2015 15:36:56 +0200 Subject: Core/Phases: updated packet handling to new format --- .../characters/2015_03_15_00_characters.sql | 11 ----- .../characters/2015_03_29_00_characters.sql | 11 +++++ sql/updates/world/2015_03_15_00_world.sql | 53 ---------------------- sql/updates/world/2015_03_29_01_world.sql | 53 ++++++++++++++++++++++ 4 files changed, 64 insertions(+), 64 deletions(-) delete mode 100644 sql/updates/characters/2015_03_15_00_characters.sql create mode 100644 sql/updates/characters/2015_03_29_00_characters.sql delete mode 100644 sql/updates/world/2015_03_15_00_world.sql create mode 100644 sql/updates/world/2015_03_29_01_world.sql (limited to 'sql') diff --git a/sql/updates/characters/2015_03_15_00_characters.sql b/sql/updates/characters/2015_03_15_00_characters.sql deleted file mode 100644 index b9bb746c2f7..00000000000 --- a/sql/updates/characters/2015_03_15_00_characters.sql +++ /dev/null @@ -1,11 +0,0 @@ -ALTER TABLE `corpse` DROP `phaseMask`; - -DROP TABLE IF EXISTS `corpse_phases`; -CREATE TABLE `corpse_phases` ( - `Guid` int(10) unsigned NOT NULL, - `PhaseId` int(10) unsigned NOT NULL, - `OwnerGuid` int(10) unsigned NOT NULL, - `Time` int(10) unsigned NOT NULL DEFAULT '0', - `CorpseType` tinyint(3) unsigned NOT NULL DEFAULT '0', - PRIMARY KEY (`Guid`,`PhaseId`) -); \ No newline at end of file diff --git a/sql/updates/characters/2015_03_29_00_characters.sql b/sql/updates/characters/2015_03_29_00_characters.sql new file mode 100644 index 00000000000..b9bb746c2f7 --- /dev/null +++ b/sql/updates/characters/2015_03_29_00_characters.sql @@ -0,0 +1,11 @@ +ALTER TABLE `corpse` DROP `phaseMask`; + +DROP TABLE IF EXISTS `corpse_phases`; +CREATE TABLE `corpse_phases` ( + `Guid` int(10) unsigned NOT NULL, + `PhaseId` int(10) unsigned NOT NULL, + `OwnerGuid` int(10) unsigned NOT NULL, + `Time` int(10) unsigned NOT NULL DEFAULT '0', + `CorpseType` tinyint(3) unsigned NOT NULL DEFAULT '0', + PRIMARY KEY (`Guid`,`PhaseId`) +); \ No newline at end of file diff --git a/sql/updates/world/2015_03_15_00_world.sql b/sql/updates/world/2015_03_15_00_world.sql deleted file mode 100644 index 3eee1cae11a..00000000000 --- a/sql/updates/world/2015_03_15_00_world.sql +++ /dev/null @@ -1,53 +0,0 @@ -DROP TABLE IF EXISTS `phase_definitions`; -DROP TABLE IF EXISTS `phase_info`; -DROP TABLE IF EXISTS `terrain_phase_info`; -DROP TABLE IF EXISTS `terrain_map_info`; -DROP TABLE IF EXISTS `terrain_swap_defaults`; -DROP TABLE IF EXISTS `terrain_worldmap`; -DROP TABLE IF EXISTS `phase_area`; - -CREATE TABLE `terrain_phase_info`( - `Id` INT(10) unsigned NOT NULL, - `TerrainSwapMap` INT(10) unsigned NOT NULL, - `Comment` VARCHAR(255), - PRIMARY KEY (`Id`, `TerrainSwapMap`) -); - -CREATE TABLE `terrain_swap_defaults`( - `MapId` INT(10) unsigned NOT NULL, - `TerrainSwapMap` INT(10) unsigned NOT NULL, - `Comment` VARCHAR(255), - PRIMARY KEY (`MapId`, `TerrainSwapMap`) -); - -CREATE TABLE `terrain_worldmap`( - `TerrainSwapMap` INT(10) unsigned NOT NULL, - `WorldMapArea` INT(10) unsigned NOT NULL, - `Comment` VARCHAR(255), - PRIMARY KEY (`TerrainSwapMap`, `WorldMapArea`) -); - -CREATE TABLE `phase_area` ( - `AreaId` int(10) unsigned NOT NULL, - `PhaseId` int(10) unsigned NOT NULL, - `Comment` varchar(255) DEFAULT NULL, - PRIMARY KEY (`AreaId`,`PhaseId`) -); - -INSERT INTO `terrain_phase_info` (Id, TerrainSwapMap, Comment) VALUES -(182, 655, 'Quest Zone-Specific 07'), -(186, 656, 'Quest Zone-Specific 11'); - -INSERT INTO `terrain_worldmap` (TerrainSwapMap, WorldMapArea, Comment) VALUES -(638, 545, 'Gilneas'), -(655, 678, 'Gilneas_terrain1'), -(719, 683, 'Hyjal_terrain1'), -(656, 679, 'Gilneas_terrain2'); - -INSERT INTO `terrain_swap_defaults` (MapId, TerrainSwapMap, Comment) VALUES -(1, 719, 'Mount Hyjal default terrain'), -(654, 638, 'Gilneas default terrain'); - -DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=25 AND `SourceEntry`=719; -INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES -(25, 0, 719, 0, 0, 8, 0, 25372, 0, 0, 1, 0, 0, '', 'Hyjal terrain swap if Aessina''s Miracle quest is not rewarded'); diff --git a/sql/updates/world/2015_03_29_01_world.sql b/sql/updates/world/2015_03_29_01_world.sql new file mode 100644 index 00000000000..3eee1cae11a --- /dev/null +++ b/sql/updates/world/2015_03_29_01_world.sql @@ -0,0 +1,53 @@ +DROP TABLE IF EXISTS `phase_definitions`; +DROP TABLE IF EXISTS `phase_info`; +DROP TABLE IF EXISTS `terrain_phase_info`; +DROP TABLE IF EXISTS `terrain_map_info`; +DROP TABLE IF EXISTS `terrain_swap_defaults`; +DROP TABLE IF EXISTS `terrain_worldmap`; +DROP TABLE IF EXISTS `phase_area`; + +CREATE TABLE `terrain_phase_info`( + `Id` INT(10) unsigned NOT NULL, + `TerrainSwapMap` INT(10) unsigned NOT NULL, + `Comment` VARCHAR(255), + PRIMARY KEY (`Id`, `TerrainSwapMap`) +); + +CREATE TABLE `terrain_swap_defaults`( + `MapId` INT(10) unsigned NOT NULL, + `TerrainSwapMap` INT(10) unsigned NOT NULL, + `Comment` VARCHAR(255), + PRIMARY KEY (`MapId`, `TerrainSwapMap`) +); + +CREATE TABLE `terrain_worldmap`( + `TerrainSwapMap` INT(10) unsigned NOT NULL, + `WorldMapArea` INT(10) unsigned NOT NULL, + `Comment` VARCHAR(255), + PRIMARY KEY (`TerrainSwapMap`, `WorldMapArea`) +); + +CREATE TABLE `phase_area` ( + `AreaId` int(10) unsigned NOT NULL, + `PhaseId` int(10) unsigned NOT NULL, + `Comment` varchar(255) DEFAULT NULL, + PRIMARY KEY (`AreaId`,`PhaseId`) +); + +INSERT INTO `terrain_phase_info` (Id, TerrainSwapMap, Comment) VALUES +(182, 655, 'Quest Zone-Specific 07'), +(186, 656, 'Quest Zone-Specific 11'); + +INSERT INTO `terrain_worldmap` (TerrainSwapMap, WorldMapArea, Comment) VALUES +(638, 545, 'Gilneas'), +(655, 678, 'Gilneas_terrain1'), +(719, 683, 'Hyjal_terrain1'), +(656, 679, 'Gilneas_terrain2'); + +INSERT INTO `terrain_swap_defaults` (MapId, TerrainSwapMap, Comment) VALUES +(1, 719, 'Mount Hyjal default terrain'), +(654, 638, 'Gilneas default terrain'); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=25 AND `SourceEntry`=719; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(25, 0, 719, 0, 0, 8, 0, 25372, 0, 0, 1, 0, 0, '', 'Hyjal terrain swap if Aessina''s Miracle quest is not rewarded'); -- cgit v1.2.3