diff options
| -rw-r--r-- | data/sql/updates/db_world/2017_08_18_00.sql | 27 | ||||
| -rw-r--r-- | data/sql/updates/db_world/2017_08_18_01.sql (renamed from data/sql/updates/pending_db_world/rev_1499101625045878500.sql) | 24 | ||||
| -rw-r--r-- | data/sql/updates/db_world/2017_08_18_02.sql | 30 | ||||
| -rw-r--r-- | data/sql/updates/db_world/2017_08_18_03.sql (renamed from data/sql/updates/pending_db_world/rev_1499118515042687600.sql) | 25 | ||||
| -rw-r--r-- | data/sql/updates/pending_db_world/rev_1498835613715251400.sql | 3 | ||||
| -rw-r--r-- | data/sql/updates/pending_db_world/rev_1499115152422618300.sql | 7 |
6 files changed, 105 insertions, 11 deletions
diff --git a/data/sql/updates/db_world/2017_08_18_00.sql b/data/sql/updates/db_world/2017_08_18_00.sql new file mode 100644 index 0000000000..bee4471ca1 --- /dev/null +++ b/data/sql/updates/db_world/2017_08_18_00.sql @@ -0,0 +1,27 @@ +-- DB update 2017_06_29_00 -> 2017_08_18_00 +DROP PROCEDURE IF EXISTS `updateDb`; +DELIMITER // +CREATE PROCEDURE updateDb () +proc:BEGIN DECLARE OK VARCHAR(100) DEFAULT 'FALSE'; +SELECT COUNT(*) INTO @COLEXISTS +FROM information_schema.COLUMNS +WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'version_db_world' AND COLUMN_NAME = '2017_06_29_00'; +IF @COLEXISTS = 0 THEN LEAVE proc; END IF; +START TRANSACTION; +ALTER TABLE version_db_world CHANGE COLUMN 2017_06_29_00 2017_08_18_00 bit; +SELECT sql_rev INTO OK FROM version_db_world WHERE sql_rev = '1498835613715251400'; IF OK <> 'FALSE' THEN LEAVE proc; END IF; +-- +-- START UPDATING QUERIES +-- +INSERT INTO version_db_world (`sql_rev`) VALUES ('1498835613715251400'); + +UPDATE `creature_template` SET `modelid1` = '6485' WHERE `entry` = '7780'; +-- +-- END UPDATING QUERIES +-- +COMMIT; +END; +// +DELIMITER ; +CALL updateDb(); +DROP PROCEDURE IF EXISTS `updateDb`; diff --git a/data/sql/updates/pending_db_world/rev_1499101625045878500.sql b/data/sql/updates/db_world/2017_08_18_01.sql index 9221034017..e2479f25f4 100644 --- a/data/sql/updates/pending_db_world/rev_1499101625045878500.sql +++ b/data/sql/updates/db_world/2017_08_18_01.sql @@ -1,3 +1,18 @@ +-- DB update 2017_08_18_00 -> 2017_08_18_01 +DROP PROCEDURE IF EXISTS `updateDb`; +DELIMITER // +CREATE PROCEDURE updateDb () +proc:BEGIN DECLARE OK VARCHAR(100) DEFAULT 'FALSE'; +SELECT COUNT(*) INTO @COLEXISTS +FROM information_schema.COLUMNS +WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'version_db_world' AND COLUMN_NAME = '2017_08_18_00'; +IF @COLEXISTS = 0 THEN LEAVE proc; END IF; +START TRANSACTION; +ALTER TABLE version_db_world CHANGE COLUMN 2017_08_18_00 2017_08_18_01 bit; +SELECT sql_rev INTO OK FROM version_db_world WHERE sql_rev = '1499101625045878500'; IF OK <> 'FALSE' THEN LEAVE proc; END IF; +-- +-- START UPDATING QUERIES +-- INSERT INTO version_db_world (`sql_rev`) VALUES ('1499101625045878500'); INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES (46337, 'spell_gen_crab_disguise'); @@ -8,3 +23,12 @@ INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_ (25863, 0, 1, 0, 0, 0, 100, 0, 0, 0, 3400, 5400, 11, 20793, 64, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Twilight Firesworn - In Combat CMC - Cast \'Fireball\''), (25863, 0, 2, 0, 2, 0, 100, 1, 0, 15, 0, 0, 25, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Twilight Firesworn - Between 0-15% Health - Flee For Assist (No Repeat)'); +-- +-- END UPDATING QUERIES +-- +COMMIT; +END; +// +DELIMITER ; +CALL updateDb(); +DROP PROCEDURE IF EXISTS `updateDb`; diff --git a/data/sql/updates/db_world/2017_08_18_02.sql b/data/sql/updates/db_world/2017_08_18_02.sql new file mode 100644 index 0000000000..6dea4971f9 --- /dev/null +++ b/data/sql/updates/db_world/2017_08_18_02.sql @@ -0,0 +1,30 @@ +-- DB update 2017_08_18_01 -> 2017_08_18_02 +DROP PROCEDURE IF EXISTS `updateDb`; +DELIMITER // +CREATE PROCEDURE updateDb () +proc:BEGIN DECLARE OK VARCHAR(100) DEFAULT 'FALSE'; +SELECT COUNT(*) INTO @COLEXISTS +FROM information_schema.COLUMNS +WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'version_db_world' AND COLUMN_NAME = '2017_08_18_01'; +IF @COLEXISTS = 0 THEN LEAVE proc; END IF; +START TRANSACTION; +ALTER TABLE version_db_world CHANGE COLUMN 2017_08_18_01 2017_08_18_02 bit; +SELECT sql_rev INTO OK FROM version_db_world WHERE sql_rev = '1499115152422618300'; IF OK <> 'FALSE' THEN LEAVE proc; END IF; +-- +-- START UPDATING QUERIES +-- +INSERT INTO version_db_world (`sql_rev`) VALUES ('1499115152422618300'); + +UPDATE `quest_template_addon` SET `SpecialFlags` = '0' WHERE `ID` = '338'; +UPDATE `quest_template_addon` SET `SpecialFlags` = '0' WHERE `ID` = '339'; +UPDATE `quest_template_addon` SET `SpecialFlags` = '0' WHERE `ID` = '340'; +UPDATE `quest_template_addon` SET `SpecialFlags` = '0' WHERE `ID` = '341'; +UPDATE `quest_template_addon` SET `SpecialFlags` = '0' WHERE `ID` = '342';-- +-- END UPDATING QUERIES +-- +COMMIT; +END; +// +DELIMITER ; +CALL updateDb(); +DROP PROCEDURE IF EXISTS `updateDb`; diff --git a/data/sql/updates/pending_db_world/rev_1499118515042687600.sql b/data/sql/updates/db_world/2017_08_18_03.sql index c6fd350aaf..01aa65afdd 100644 --- a/data/sql/updates/pending_db_world/rev_1499118515042687600.sql +++ b/data/sql/updates/db_world/2017_08_18_03.sql @@ -1,3 +1,18 @@ +-- DB update 2017_08_18_02 -> 2017_08_18_03 +DROP PROCEDURE IF EXISTS `updateDb`; +DELIMITER // +CREATE PROCEDURE updateDb () +proc:BEGIN DECLARE OK VARCHAR(100) DEFAULT 'FALSE'; +SELECT COUNT(*) INTO @COLEXISTS +FROM information_schema.COLUMNS +WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'version_db_world' AND COLUMN_NAME = '2017_08_18_02'; +IF @COLEXISTS = 0 THEN LEAVE proc; END IF; +START TRANSACTION; +ALTER TABLE version_db_world CHANGE COLUMN 2017_08_18_02 2017_08_18_03 bit; +SELECT sql_rev INTO OK FROM version_db_world WHERE sql_rev = '1499118515042687600'; IF OK <> 'FALSE' THEN LEAVE proc; END IF; +-- +-- START UPDATING QUERIES +-- INSERT INTO version_db_world (`sql_rev`) VALUES ('1499118515042687600'); -- D.E.T.H.A TEXT AND SAI @@ -109,4 +124,12 @@ SET @ENTRY := 25844; UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES -(@ENTRY,0,0,0,0,0,100,0,5000,8000,60000,65000,11,5915,0,0,0,0,0,1,0,0,0,0,0,0,0,"Northsea Thug - In Combat - Cast 'Crazed'");
\ No newline at end of file +(@ENTRY,0,0,0,0,0,100,0,5000,8000,60000,65000,11,5915,0,0,0,0,0,1,0,0,0,0,0,0,0,"Northsea Thug - In Combat - Cast 'Crazed'");-- +-- END UPDATING QUERIES +-- +COMMIT; +END; +// +DELIMITER ; +CALL updateDb(); +DROP PROCEDURE IF EXISTS `updateDb`; diff --git a/data/sql/updates/pending_db_world/rev_1498835613715251400.sql b/data/sql/updates/pending_db_world/rev_1498835613715251400.sql deleted file mode 100644 index 42fa8fbaf4..0000000000 --- a/data/sql/updates/pending_db_world/rev_1498835613715251400.sql +++ /dev/null @@ -1,3 +0,0 @@ -INSERT INTO version_db_world (`sql_rev`) VALUES ('1498835613715251400'); - -UPDATE `creature_template` SET `modelid1` = '6485' WHERE `entry` = '7780'; diff --git a/data/sql/updates/pending_db_world/rev_1499115152422618300.sql b/data/sql/updates/pending_db_world/rev_1499115152422618300.sql deleted file mode 100644 index d37fa66ebf..0000000000 --- a/data/sql/updates/pending_db_world/rev_1499115152422618300.sql +++ /dev/null @@ -1,7 +0,0 @@ -INSERT INTO version_db_world (`sql_rev`) VALUES ('1499115152422618300'); - -UPDATE `quest_template_addon` SET `SpecialFlags` = '0' WHERE `ID` = '338'; -UPDATE `quest_template_addon` SET `SpecialFlags` = '0' WHERE `ID` = '339'; -UPDATE `quest_template_addon` SET `SpecialFlags` = '0' WHERE `ID` = '340'; -UPDATE `quest_template_addon` SET `SpecialFlags` = '0' WHERE `ID` = '341'; -UPDATE `quest_template_addon` SET `SpecialFlags` = '0' WHERE `ID` = '342';
\ No newline at end of file |