diff options
46 files changed, 803 insertions, 128 deletions
diff --git a/data/sql/updates/pending_db_world/rev_1617170212396609300.sql b/data/sql/updates/db_world/2021_04_11_00.sql index d22a5e19db..7ea76ffd41 100644 --- a/data/sql/updates/pending_db_world/rev_1617170212396609300.sql +++ b/data/sql/updates/db_world/2021_04_11_00.sql @@ -1,3 +1,19 @@ +-- DB update 2021_04_09_00 -> 2021_04_11_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 = '2021_04_09_00'; +IF @COLEXISTS = 0 THEN LEAVE proc; END IF; +START TRANSACTION; +ALTER TABLE version_db_world CHANGE COLUMN 2021_04_09_00 2021_04_11_00 bit; +SELECT sql_rev INTO OK FROM version_db_world WHERE sql_rev = '1617170212396609300'; IF OK <> 'FALSE' THEN LEAVE proc; END IF; +-- +-- START UPDATING QUERIES +-- + INSERT INTO `version_db_world` (`sql_rev`) VALUES ('1617170212396609300'); /* Slim is walking just barely too far to target and send data back to Mikhail on a failed quest*/ @@ -19,3 +35,12 @@ DELETE FROM `smart_scripts` WHERE `entryorguid` = 496300 AND `source_type` = 9 A 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`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES (4963,0,6,0,19,0,100,0,1249,0,0,0,0,48,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Mikhail - On Quest 'The Missing Diplomat (Part 11)' Taken - Set Active On"), (496300,9,2,0,0,0,100,0,0,0,0,0,0,48,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Mikhail - On Script - Set Active Off"); + +-- +-- END UPDATING QUERIES +-- +COMMIT; +END // +DELIMITER ; +CALL updateDb(); +DROP PROCEDURE IF EXISTS `updateDb`; diff --git a/data/sql/updates/db_world/2021_04_11_01.sql b/data/sql/updates/db_world/2021_04_11_01.sql new file mode 100644 index 0000000000..b0b68dd6a8 --- /dev/null +++ b/data/sql/updates/db_world/2021_04_11_01.sql @@ -0,0 +1,31 @@ +-- DB update 2021_04_11_00 -> 2021_04_11_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 = '2021_04_11_00'; +IF @COLEXISTS = 0 THEN LEAVE proc; END IF; +START TRANSACTION; +ALTER TABLE version_db_world CHANGE COLUMN 2021_04_11_00 2021_04_11_01 bit; +SELECT sql_rev INTO OK FROM version_db_world WHERE sql_rev = '1617475678754474649'; IF OK <> 'FALSE' THEN LEAVE proc; END IF; +-- +-- START UPDATING QUERIES +-- + +INSERT INTO `version_db_world` (`sql_rev`) VALUES ('1617475678754474649'); + +DELETE FROM `creature` WHERE (`id` = 2960) AND (`guid` IN (25623)); +INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES +(25623, 2960, 1, 0, 0, 1, 1, 161, 0, -718.670898, -677.328979, -15.930156, 5.17604, 250, 20, 0, 176, 0, 1, 0, 0, 0, '', 0); + + +-- +-- END UPDATING QUERIES +-- +COMMIT; +END // +DELIMITER ; +CALL updateDb(); +DROP PROCEDURE IF EXISTS `updateDb`; diff --git a/data/sql/updates/db_world/2021_04_11_02.sql b/data/sql/updates/db_world/2021_04_11_02.sql new file mode 100644 index 0000000000..c971ad7474 --- /dev/null +++ b/data/sql/updates/db_world/2021_04_11_02.sql @@ -0,0 +1,31 @@ +-- DB update 2021_04_11_01 -> 2021_04_11_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 = '2021_04_11_01'; +IF @COLEXISTS = 0 THEN LEAVE proc; END IF; +START TRANSACTION; +ALTER TABLE version_db_world CHANGE COLUMN 2021_04_11_01 2021_04_11_02 bit; +SELECT sql_rev INTO OK FROM version_db_world WHERE sql_rev = '1617560891918432300'; IF OK <> 'FALSE' THEN LEAVE proc; END IF; +-- +-- START UPDATING QUERIES +-- + +INSERT INTO `version_db_world` (`sql_rev`) VALUES ('1617560891918432300'); + +DELETE FROM `quest_poi_points` WHERE `QuestID` = 6127; +INSERT INTO `quest_poi_points` VALUES +(6127, 0, 0, -544, -2672, 0), +(6127, 1, 0, 336, -2280, 0); + +-- +-- END UPDATING QUERIES +-- +COMMIT; +END // +DELIMITER ; +CALL updateDb(); +DROP PROCEDURE IF EXISTS `updateDb`; diff --git a/data/sql/updates/db_world/2021_04_11_03.sql b/data/sql/updates/db_world/2021_04_11_03.sql new file mode 100644 index 0000000000..bdcc83b70b --- /dev/null +++ b/data/sql/updates/db_world/2021_04_11_03.sql @@ -0,0 +1,31 @@ +-- DB update 2021_04_11_02 -> 2021_04_11_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 = '2021_04_11_02'; +IF @COLEXISTS = 0 THEN LEAVE proc; END IF; +START TRANSACTION; +ALTER TABLE version_db_world CHANGE COLUMN 2021_04_11_02 2021_04_11_03 bit; +SELECT sql_rev INTO OK FROM version_db_world WHERE sql_rev = '1617612991251140137'; IF OK <> 'FALSE' THEN LEAVE proc; END IF; +-- +-- START UPDATING QUERIES +-- + +INSERT INTO `version_db_world` (`sql_rev`) VALUES ('1617612991251140137'); + +DELETE FROM `creature` WHERE (`id` = 3273) AND (`guid` IN (20534)); +INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES +(20534, 3273, 1, 0, 0, 1, 1, 9443, 1, 1.525501, -1759.818481, 95.022011, 1.5666, 275, 0, 0, 253, 264, 0, 0, 0, 0, '', 0); + + +-- +-- END UPDATING QUERIES +-- +COMMIT; +END // +DELIMITER ; +CALL updateDb(); +DROP PROCEDURE IF EXISTS `updateDb`; diff --git a/data/sql/updates/db_world/2021_04_11_04.sql b/data/sql/updates/db_world/2021_04_11_04.sql new file mode 100644 index 0000000000..48eb0aede0 --- /dev/null +++ b/data/sql/updates/db_world/2021_04_11_04.sql @@ -0,0 +1,28 @@ +-- DB update 2021_04_11_03 -> 2021_04_11_04 +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 = '2021_04_11_03'; +IF @COLEXISTS = 0 THEN LEAVE proc; END IF; +START TRANSACTION; +ALTER TABLE version_db_world CHANGE COLUMN 2021_04_11_03 2021_04_11_04 bit; +SELECT sql_rev INTO OK FROM version_db_world WHERE sql_rev = '1617614528274234003'; IF OK <> 'FALSE' THEN LEAVE proc; END IF; +-- +-- START UPDATING QUERIES +-- + +INSERT INTO `version_db_world` (`sql_rev`) VALUES ('1617614528274234003'); + +UPDATE `quest_template` SET `AllowableRaces` = 690 WHERE (`ID` = 5761); + +-- +-- END UPDATING QUERIES +-- +COMMIT; +END // +DELIMITER ; +CALL updateDb(); +DROP PROCEDURE IF EXISTS `updateDb`; diff --git a/data/sql/updates/db_world/2021_04_11_05.sql b/data/sql/updates/db_world/2021_04_11_05.sql new file mode 100644 index 0000000000..ce30f605e8 --- /dev/null +++ b/data/sql/updates/db_world/2021_04_11_05.sql @@ -0,0 +1,32 @@ +-- DB update 2021_04_11_04 -> 2021_04_11_05 +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 = '2021_04_11_04'; +IF @COLEXISTS = 0 THEN LEAVE proc; END IF; +START TRANSACTION; +ALTER TABLE version_db_world CHANGE COLUMN 2021_04_11_04 2021_04_11_05 bit; +SELECT sql_rev INTO OK FROM version_db_world WHERE sql_rev = '1617620649041950300'; IF OK <> 'FALSE' THEN LEAVE proc; END IF; +-- +-- START UPDATING QUERIES +-- + +INSERT INTO `version_db_world` (`sql_rev`) VALUES ('1617620649041950300'); + +UPDATE `gameobject_template` SET `AIName` = 'SmartGameObjectAI' WHERE `entry` = 3740; + +DELETE FROM `smart_scripts` WHERE (`source_type` = 1 AND `entryorguid` = 3740); +INSERT INTO `smart_scripts` VALUES +(3740, 1, 0, 0, 60, 0, 100, 0, 500, 500, 3500, 3500, 0, 75, 17775, 0, 0, 0, 0, 0, 18, 10, 0, 0, 0, 0, 0, 0, 0, 'Bubbling Fissure - On Update - Add Aura \'Air Bubbles\''); + +-- +-- END UPDATING QUERIES +-- +COMMIT; +END // +DELIMITER ; +CALL updateDb(); +DROP PROCEDURE IF EXISTS `updateDb`; diff --git a/data/sql/updates/db_world/2021_04_11_06.sql b/data/sql/updates/db_world/2021_04_11_06.sql new file mode 100644 index 0000000000..3bcf9c0137 --- /dev/null +++ b/data/sql/updates/db_world/2021_04_11_06.sql @@ -0,0 +1,31 @@ +-- DB update 2021_04_11_05 -> 2021_04_11_06 +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 = '2021_04_11_05'; +IF @COLEXISTS = 0 THEN LEAVE proc; END IF; +START TRANSACTION; +ALTER TABLE version_db_world CHANGE COLUMN 2021_04_11_05 2021_04_11_06 bit; +SELECT sql_rev INTO OK FROM version_db_world WHERE sql_rev = '1617634980911314885'; IF OK <> 'FALSE' THEN LEAVE proc; END IF; +-- +-- START UPDATING QUERIES +-- + +INSERT INTO `version_db_world` (`sql_rev`) VALUES ('1617634980911314885'); + +DELETE FROM `creature` WHERE (`id` = 7318) AND (`guid` IN (46818)); +INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES +(46818, 7318, 1, 0, 0, 1, 1, 6231, 1, 9843.19, 1496.22, 1257.25, 2.34654, 300, 0, 0, 186, 191, 2, 0, 0, 0, '', 0); + + +-- +-- END UPDATING QUERIES +-- +COMMIT; +END // +DELIMITER ; +CALL updateDb(); +DROP PROCEDURE IF EXISTS `updateDb`; diff --git a/data/sql/updates/db_world/2021_04_11_07.sql b/data/sql/updates/db_world/2021_04_11_07.sql new file mode 100644 index 0000000000..25f2e400ac --- /dev/null +++ b/data/sql/updates/db_world/2021_04_11_07.sql @@ -0,0 +1,32 @@ +-- DB update 2021_04_11_06 -> 2021_04_11_07 +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 = '2021_04_11_06'; +IF @COLEXISTS = 0 THEN LEAVE proc; END IF; +START TRANSACTION; +ALTER TABLE version_db_world CHANGE COLUMN 2021_04_11_06 2021_04_11_07 bit; +SELECT sql_rev INTO OK FROM version_db_world WHERE sql_rev = '1617661090934443600'; IF OK <> 'FALSE' THEN LEAVE proc; END IF; +-- +-- START UPDATING QUERIES +-- + +INSERT INTO `version_db_world` (`sql_rev`) VALUES ('1617661090934443600'); + +UPDATE `creature_template` SET `InhabitType` = 3 WHERE (`entry` IN (1018, 1019, 1140)); + +DELETE FROM `creature` WHERE (`id` = 1018) AND (`guid` IN (9981)); +INSERT INTO `creature` VALUES +(9981, 1018, 0, 0, 0, 1, 1, 180, 0, -3112.84, -3252.45, 65.1154, 5.6466, 300, 0, 0, 896, 0, 0, 0, 0, 0, '', 0); + +-- +-- END UPDATING QUERIES +-- +COMMIT; +END // +DELIMITER ; +CALL updateDb(); +DROP PROCEDURE IF EXISTS `updateDb`; diff --git a/data/sql/updates/pending_db_world/rev_1617726900389263800.sql b/data/sql/updates/db_world/2021_04_11_08.sql index 4bf3fe9a81..303ad8c3b5 100644 --- a/data/sql/updates/pending_db_world/rev_1617726900389263800.sql +++ b/data/sql/updates/db_world/2021_04_11_08.sql @@ -1,4 +1,29 @@ +-- DB update 2021_04_11_07 -> 2021_04_11_08 +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 = '2021_04_11_07'; +IF @COLEXISTS = 0 THEN LEAVE proc; END IF; +START TRANSACTION; +ALTER TABLE version_db_world CHANGE COLUMN 2021_04_11_07 2021_04_11_08 bit; +SELECT sql_rev INTO OK FROM version_db_world WHERE sql_rev = '1617726900389263800'; IF OK <> 'FALSE' THEN LEAVE proc; END IF; +-- +-- START UPDATING QUERIES +-- + INSERT INTO `version_db_world` (`sql_rev`) VALUES ('1617726900389263800'); DELETE FROM `spell_dbc` WHERE (`ID` = 46393); INSERT INTO `spell_dbc` VALUES (46393, 0, 0, 0, 738213888, 1024, 0, 2048, 131072, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 524288, 0, 0, 101, 0, 0, 0, 0, 21, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 6, 6, 0, 1, 1, 0, 0, 0, 0, 99, 6, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 87, 191, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 127, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2615, 0, 0, 'Brutal Assault','','','','','','','','', 0, 0, 0, 0, 0, 0, 0, 16712190,'','','','','','','','','', 0, 0, 0, 0, 0, 0, 0, 16712190, 'The strength of the enemy bears down upon the flag carrier, increasing damage taken by $s1%, and limiting movement speed.', null, null, null, null, null, null, null, null, 0, 0, 0, 0, 0, 0, 0, 16712190, 'The strength of the enemy bears down upon the flag carrier, increasing damage taken by $s1%, and limiting movement speed.','','','','','','','','', 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0); + +-- +-- END UPDATING QUERIES +-- +COMMIT; +END // +DELIMITER ; +CALL updateDb(); +DROP PROCEDURE IF EXISTS `updateDb`; diff --git a/data/sql/updates/pending_db_world/rev_1617732568440189700.sql b/data/sql/updates/db_world/2021_04_11_09.sql index a3b3e1f4ca..17010c60ed 100644 --- a/data/sql/updates/pending_db_world/rev_1617732568440189700.sql +++ b/data/sql/updates/db_world/2021_04_11_09.sql @@ -1,3 +1,19 @@ +-- DB update 2021_04_11_08 -> 2021_04_11_09 +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 = '2021_04_11_08'; +IF @COLEXISTS = 0 THEN LEAVE proc; END IF; +START TRANSACTION; +ALTER TABLE version_db_world CHANGE COLUMN 2021_04_11_08 2021_04_11_09 bit; +SELECT sql_rev INTO OK FROM version_db_world WHERE sql_rev = '1617732568440189700'; IF OK <> 'FALSE' THEN LEAVE proc; END IF; +-- +-- START UPDATING QUERIES +-- + INSERT INTO `version_db_world` (`sql_rev`) VALUES ('1617732568440189700'); DELETE FROM `smart_scripts` WHERE (`source_type` = 0 AND `entryorguid` = 8996); @@ -14,3 +30,12 @@ INSERT INTO `smart_scripts` VALUES (12922, 0, 1, 0, 54, 0, 100, 0, 0, 0, 0, 0, 0, 8, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Imp Minion - On Just Summoned - Set Reactstate Aggressive'), (12922, 0, 2, 3, 74, 0, 100, 0, 1, 99, 100, 20000, 0, 49, 0, 0, 0, 0, 0, 0, 19, 3725, 5, 0, 0, 0, 0, 0, 0, 'Imp Minion - On Friendly Between 1-99% Health - Start Attacking'), (12922, 0, 3, 0, 61, 0, 100, 0, 1, 99, 100, 20000, 0, 49, 0, 0, 0, 0, 0, 0, 18, 33, 0, 0, 0, 0, 0, 0, 0, 'Imp Minion - On Friendly Between 1-99% Health - Start Attacking'); + +-- +-- END UPDATING QUERIES +-- +COMMIT; +END // +DELIMITER ; +CALL updateDb(); +DROP PROCEDURE IF EXISTS `updateDb`; diff --git a/data/sql/updates/db_world/2021_04_11_10.sql b/data/sql/updates/db_world/2021_04_11_10.sql new file mode 100644 index 0000000000..80d569c6e2 --- /dev/null +++ b/data/sql/updates/db_world/2021_04_11_10.sql @@ -0,0 +1,36 @@ +-- DB update 2021_04_11_09 -> 2021_04_11_10 +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 = '2021_04_11_09'; +IF @COLEXISTS = 0 THEN LEAVE proc; END IF; +START TRANSACTION; +ALTER TABLE version_db_world CHANGE COLUMN 2021_04_11_09 2021_04_11_10 bit; +SELECT sql_rev INTO OK FROM version_db_world WHERE sql_rev = '1617739461755573400'; IF OK <> 'FALSE' THEN LEAVE proc; END IF; +-- +-- START UPDATING QUERIES +-- + +INSERT INTO `version_db_world` (`sql_rev`) VALUES ('1617739461755573400'); + +DELETE FROM `spell_script_names` WHERE (`spell_id` IN (23567, 23568, 23569, 23696, 24412, 24413, 24414)); +INSERT INTO `spell_script_names` VALUES +(23567, 'spell_gen_bandage'), +(23568, 'spell_gen_bandage'), +(23569, 'spell_gen_bandage'), +(23696, 'spell_gen_bandage'), +(24412, 'spell_gen_bandage'), +(24413, 'spell_gen_bandage'), +(24414, 'spell_gen_bandage'); + +-- +-- END UPDATING QUERIES +-- +COMMIT; +END // +DELIMITER ; +CALL updateDb(); +DROP PROCEDURE IF EXISTS `updateDb`; diff --git a/data/sql/updates/pending_db_world/rev_1617772431626528000.sql b/data/sql/updates/db_world/2021_04_11_11.sql index c117fa8962..d1369a4076 100644 --- a/data/sql/updates/pending_db_world/rev_1617772431626528000.sql +++ b/data/sql/updates/db_world/2021_04_11_11.sql @@ -1,3 +1,19 @@ +-- DB update 2021_04_11_10 -> 2021_04_11_11 +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 = '2021_04_11_10'; +IF @COLEXISTS = 0 THEN LEAVE proc; END IF; +START TRANSACTION; +ALTER TABLE version_db_world CHANGE COLUMN 2021_04_11_10 2021_04_11_11 bit; +SELECT sql_rev INTO OK FROM version_db_world WHERE sql_rev = '1617772431626528000'; IF OK <> 'FALSE' THEN LEAVE proc; END IF; +-- +-- START UPDATING QUERIES +-- + INSERT INTO `version_db_world` (`sql_rev`) VALUES ('1617772431626528000'); UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 3939; @@ -9,3 +25,12 @@ INSERT INTO `smart_scripts` VALUES (3939, 0, 2, 0, 1, 0, 100, 0, 100, 100, 60000, 60000, 0, 8, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Razormane Wolf - Out of Combat - Set Reactstate Aggressive'), (3939, 0, 3, 4, 74, 0, 100, 0, 1, 99, 0, 0, 0, 49, 0, 0, 0, 0, 0, 0, 19, 3265, 5, 0, 0, 0, 0, 0, 0, 'Razormane Wolf - On Friendly Between 1-99% Health - Start Attacking'), (3939, 0, 4, 0, 61, 0, 100, 0, 1, 99, 0, 0, 0, 49, 0, 0, 0, 0, 0, 0, 18, 33, 0, 0, 0, 0, 0, 0, 0, 'Razormane Wolf - On Friendly Between 1-99% Health - Start Attacking'); + +-- +-- END UPDATING QUERIES +-- +COMMIT; +END // +DELIMITER ; +CALL updateDb(); +DROP PROCEDURE IF EXISTS `updateDb`; diff --git a/data/sql/updates/db_world/2021_04_11_12.sql b/data/sql/updates/db_world/2021_04_11_12.sql new file mode 100644 index 0000000000..293b511ac5 --- /dev/null +++ b/data/sql/updates/db_world/2021_04_11_12.sql @@ -0,0 +1,30 @@ +-- DB update 2021_04_11_11 -> 2021_04_11_12 +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 = '2021_04_11_11'; +IF @COLEXISTS = 0 THEN LEAVE proc; END IF; +START TRANSACTION; +ALTER TABLE version_db_world CHANGE COLUMN 2021_04_11_11 2021_04_11_12 bit; +SELECT sql_rev INTO OK FROM version_db_world WHERE sql_rev = '1617774706114876200'; IF OK <> 'FALSE' THEN LEAVE proc; END IF; +-- +-- START UPDATING QUERIES +-- + +INSERT INTO `version_db_world` (`sql_rev`) VALUES ('1617774706114876200'); + +DELETE FROM `creature` WHERE (`id` = 16313) AND (`guid` IN (81792)); +INSERT INTO `creature` VALUES +(81792, 16313, 530, 0, 0, 1, 1, 0, 0, 7937.95, -7354.2, 144.804, 5.9059, 300, 0, 0, 166, 178, 0, 0, 0, 0, '', 0); + +-- +-- END UPDATING QUERIES +-- +COMMIT; +END // +DELIMITER ; +CALL updateDb(); +DROP PROCEDURE IF EXISTS `updateDb`; diff --git a/data/sql/updates/pending_db_world/rev_1617779221786870600.sql b/data/sql/updates/db_world/2021_04_11_13.sql index b2bbcae6fc..701cec2750 100644 --- a/data/sql/updates/pending_db_world/rev_1617779221786870600.sql +++ b/data/sql/updates/db_world/2021_04_11_13.sql @@ -1,3 +1,19 @@ +-- DB update 2021_04_11_12 -> 2021_04_11_13 +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 = '2021_04_11_12'; +IF @COLEXISTS = 0 THEN LEAVE proc; END IF; +START TRANSACTION; +ALTER TABLE version_db_world CHANGE COLUMN 2021_04_11_12 2021_04_11_13 bit; +SELECT sql_rev INTO OK FROM version_db_world WHERE sql_rev = '1617779221786870600'; IF OK <> 'FALSE' THEN LEAVE proc; END IF; +-- +-- START UPDATING QUERIES +-- + INSERT INTO `version_db_world` (`sql_rev`) VALUES ('1617779221786870600'); UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 12818; @@ -23,3 +39,12 @@ INSERT INTO `smart_scripts` VALUES (12818, 0, 16, 17, 58, 1, 100, 1, 15, 0, 0, 0, 0, 1, 1, 2000, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Ruul Snowhoof - On Waypoint Finished - Say Line 1 (Phase 1) (No Repeat)'), (12818, 0, 17, 0, 61, 0, 100, 0, 15, 0, 0, 0, 0, 3, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Ruul Snowhoof - On Waypoint Finished - Demorph (Phase 1) (No Repeat)'), (12818, 0, 18, 0, 11, 0, 100, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Ruul Snowhoof - On Respawn - Set Reactstate Passive'); + +-- +-- END UPDATING QUERIES +-- +COMMIT; +END // +DELIMITER ; +CALL updateDb(); +DROP PROCEDURE IF EXISTS `updateDb`; diff --git a/data/sql/updates/pending_db_world/rev_1617795276143794300.sql b/data/sql/updates/db_world/2021_04_11_14.sql index f05f022eda..2e633209b1 100644 --- a/data/sql/updates/pending_db_world/rev_1617795276143794300.sql +++ b/data/sql/updates/db_world/2021_04_11_14.sql @@ -1,3 +1,19 @@ +-- DB update 2021_04_11_13 -> 2021_04_11_14 +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 = '2021_04_11_13'; +IF @COLEXISTS = 0 THEN LEAVE proc; END IF; +START TRANSACTION; +ALTER TABLE version_db_world CHANGE COLUMN 2021_04_11_13 2021_04_11_14 bit; +SELECT sql_rev INTO OK FROM version_db_world WHERE sql_rev = '1617795276143794300'; IF OK <> 'FALSE' THEN LEAVE proc; END IF; +-- +-- START UPDATING QUERIES +-- + INSERT INTO `version_db_world` (`sql_rev`) VALUES ('1617795276143794300'); DELETE FROM `item_loot_template` WHERE (`Entry` = 16882); @@ -47,3 +63,12 @@ INSERT INTO `item_loot_template` VALUES (16882, 16746, 0, 2.5, 0, 1, 0, 1, 1, 'Battered Junkbox - Warsong Report'), (16882, 16882, 0, 2.5, 0, 1, 0, 1, 1, 'Battered Junkbox - Battered Junkbox'), (16882, 17124, 0, 2.5, 0, 1, 0, 1, 1, 'Battered Junkbox - Syndicate Emblem'); + +-- +-- END UPDATING QUERIES +-- +COMMIT; +END // +DELIMITER ; +CALL updateDb(); +DROP PROCEDURE IF EXISTS `updateDb`; diff --git a/data/sql/updates/db_world/2021_04_11_15.sql b/data/sql/updates/db_world/2021_04_11_15.sql new file mode 100644 index 0000000000..3569b95853 --- /dev/null +++ b/data/sql/updates/db_world/2021_04_11_15.sql @@ -0,0 +1,33 @@ +-- DB update 2021_04_11_14 -> 2021_04_11_15 +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 = '2021_04_11_14'; +IF @COLEXISTS = 0 THEN LEAVE proc; END IF; +START TRANSACTION; +ALTER TABLE version_db_world CHANGE COLUMN 2021_04_11_14 2021_04_11_15 bit; +SELECT sql_rev INTO OK FROM version_db_world WHERE sql_rev = '1617830328758041600'; IF OK <> 'FALSE' THEN LEAVE proc; END IF; +-- +-- START UPDATING QUERIES +-- + +INSERT INTO `version_db_world` (`sql_rev`) VALUES ('1617830328758041600'); + +DELETE FROM `gameobject` WHERE (`id` = 86492) AND (`guid` IN (48637, 48639, 48793, 48796)); +INSERT INTO `gameobject` VALUES +(48637, 86492, 1, 0, 0, 1, 1, 6392.77, 725.474, -16.2576, 2.46091, 0, 0, 0.942641, 0.333807, 180, 100, 1, '', 0), +(48639, 86492, 1, 0, 0, 1, 1, 6402.14, 742.257, -17.73105, -2.30383, 0, 0, 0.913545, -0.406737, 180, 100, 1, '', 0), +(48793, 86492, 1, 0, 0, 1, 1, 6305.19, 801.911, -12.4957, -0.942478, 0, 0, 0.453991, -0.891006, 180, 100, 1, '', 0), +(48796, 86492, 1, 0, 0, 1, 1, 6309.88, 846.544, -12.4766, 1.64846, 0, 0, 0.34202, 0.939693, 180, 100, 1, '', 0); + +-- +-- END UPDATING QUERIES +-- +COMMIT; +END // +DELIMITER ; +CALL updateDb(); +DROP PROCEDURE IF EXISTS `updateDb`; diff --git a/data/sql/updates/db_world/2021_04_11_16.sql b/data/sql/updates/db_world/2021_04_11_16.sql new file mode 100644 index 0000000000..bc473f088a --- /dev/null +++ b/data/sql/updates/db_world/2021_04_11_16.sql @@ -0,0 +1,28 @@ +-- DB update 2021_04_11_15 -> 2021_04_11_16 +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 = '2021_04_11_15'; +IF @COLEXISTS = 0 THEN LEAVE proc; END IF; +START TRANSACTION; +ALTER TABLE version_db_world CHANGE COLUMN 2021_04_11_15 2021_04_11_16 bit; +SELECT sql_rev INTO OK FROM version_db_world WHERE sql_rev = '1617865372308647700'; IF OK <> 'FALSE' THEN LEAVE proc; END IF; +-- +-- START UPDATING QUERIES +-- + +INSERT INTO `version_db_world` (`sql_rev`) VALUES ('1617865372308647700'); + +UPDATE `creature_template` SET `skinloot` = 100002 WHERE (`entry` = 3098); + +-- +-- END UPDATING QUERIES +-- +COMMIT; +END // +DELIMITER ; +CALL updateDb(); +DROP PROCEDURE IF EXISTS `updateDb`; diff --git a/data/sql/updates/pending_db_world/rev_1617867794413109600.sql b/data/sql/updates/db_world/2021_04_11_17.sql index b17b013840..3c40c9f5d4 100644 --- a/data/sql/updates/pending_db_world/rev_1617867794413109600.sql +++ b/data/sql/updates/db_world/2021_04_11_17.sql @@ -1,3 +1,19 @@ +-- DB update 2021_04_11_16 -> 2021_04_11_17 +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 = '2021_04_11_16'; +IF @COLEXISTS = 0 THEN LEAVE proc; END IF; +START TRANSACTION; +ALTER TABLE version_db_world CHANGE COLUMN 2021_04_11_16 2021_04_11_17 bit; +SELECT sql_rev INTO OK FROM version_db_world WHERE sql_rev = '1617867794413109600'; IF OK <> 'FALSE' THEN LEAVE proc; END IF; +-- +-- START UPDATING QUERIES +-- + INSERT INTO `version_db_world` (`sql_rev`) VALUES ('1617867794413109600'); UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE (`entry` IN (2951, 3382)); @@ -10,3 +26,12 @@ INSERT INTO `smart_scripts` VALUES DELETE FROM `smart_scripts` WHERE (`source_type` = 0 AND `entryorguid` = 3382); INSERT INTO `smart_scripts` VALUES (3382, 0, 0, 0, 0, 0, 100, 0, 100, 100, 3500, 3500, 0, 11, 6660, 64, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 'Southsea Cannoneer - In Combat - Cast \'Shoot\''); + +-- +-- END UPDATING QUERIES +-- +COMMIT; +END // +DELIMITER ; +CALL updateDb(); +DROP PROCEDURE IF EXISTS `updateDb`; diff --git a/data/sql/updates/db_world/2021_04_11_18.sql b/data/sql/updates/db_world/2021_04_11_18.sql new file mode 100644 index 0000000000..2bd630814f --- /dev/null +++ b/data/sql/updates/db_world/2021_04_11_18.sql @@ -0,0 +1,34 @@ +-- DB update 2021_04_11_17 -> 2021_04_11_18 +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 = '2021_04_11_17'; +IF @COLEXISTS = 0 THEN LEAVE proc; END IF; +START TRANSACTION; +ALTER TABLE version_db_world CHANGE COLUMN 2021_04_11_17 2021_04_11_18 bit; +SELECT sql_rev INTO OK FROM version_db_world WHERE sql_rev = '1617902440529783360'; IF OK <> 'FALSE' THEN LEAVE proc; END IF; +-- +-- START UPDATING QUERIES +-- + +INSERT INTO `version_db_world` (`sql_rev`) VALUES ('1617902440529783360'); + +-- Remove Flesh Piercer from Reference Table +DELETE FROM `reference_loot_template` WHERE `Entry` = 24068 AND `Item` = 3336; + +-- Adds Flesh Piercer to Daggerspine Shorestalkers and Screamers loot tables +INSERT INTO `creature_loot_template` VALUES +(2368, 3336, 0, 1.5, 0, 1, 0, 1, 1, "Daggerspine Shorestalker - Flesh Piercer"), +(2370, 3336, 0, 1.1, 0, 1, 0, 1, 1, "Daggerspine Screamer - Flesh Piercer"); + +-- +-- END UPDATING QUERIES +-- +COMMIT; +END // +DELIMITER ; +CALL updateDb(); +DROP PROCEDURE IF EXISTS `updateDb`; diff --git a/data/sql/updates/db_world/2021_04_11_19.sql b/data/sql/updates/db_world/2021_04_11_19.sql new file mode 100644 index 0000000000..fbe2dc3112 --- /dev/null +++ b/data/sql/updates/db_world/2021_04_11_19.sql @@ -0,0 +1,35 @@ +-- DB update 2021_04_11_18 -> 2021_04_11_19 +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 = '2021_04_11_18'; +IF @COLEXISTS = 0 THEN LEAVE proc; END IF; +START TRANSACTION; +ALTER TABLE version_db_world CHANGE COLUMN 2021_04_11_18 2021_04_11_19 bit; +SELECT sql_rev INTO OK FROM version_db_world WHERE sql_rev = '1617913282545327642'; IF OK <> 'FALSE' THEN LEAVE proc; END IF; +-- +-- START UPDATING QUERIES +-- + +INSERT INTO `version_db_world` (`sql_rev`) VALUES ('1617913282545327642'); + +-- Silverpine Forest +DELETE FROM `gameobject` WHERE `guid`=35525; + +-- Darkshore +DELETE FROM `gameobject` WHERE `guid` in (4729, 5079, 5055, 5078, 5079, 5392, 5351); + +-- Durotar +DELETE FROM `gameobject` WHERE `guid`=12383; + +-- +-- END UPDATING QUERIES +-- +COMMIT; +END // +DELIMITER ; +CALL updateDb(); +DROP PROCEDURE IF EXISTS `updateDb`; diff --git a/data/sql/updates/db_world/2021_04_11_20.sql b/data/sql/updates/db_world/2021_04_11_20.sql new file mode 100644 index 0000000000..1e57ebada0 --- /dev/null +++ b/data/sql/updates/db_world/2021_04_11_20.sql @@ -0,0 +1,28 @@ +-- DB update 2021_04_11_19 -> 2021_04_11_20 +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 = '2021_04_11_19'; +IF @COLEXISTS = 0 THEN LEAVE proc; END IF; +START TRANSACTION; +ALTER TABLE version_db_world CHANGE COLUMN 2021_04_11_19 2021_04_11_20 bit; +SELECT sql_rev INTO OK FROM version_db_world WHERE sql_rev = '1617915554384852400'; IF OK <> 'FALSE' THEN LEAVE proc; END IF; +-- +-- START UPDATING QUERIES +-- + +INSERT INTO `version_db_world` (`sql_rev`) VALUES ('1617915554384852400'); + +DELETE FROM `spell_custom_attr` WHERE `spell_id` IN (99, 1735, 9490, 9747, 9898, 26998, 48559, 48560); + +-- +-- END UPDATING QUERIES +-- +COMMIT; +END // +DELIMITER ; +CALL updateDb(); +DROP PROCEDURE IF EXISTS `updateDb`; diff --git a/data/sql/updates/db_world/2021_04_11_21.sql b/data/sql/updates/db_world/2021_04_11_21.sql new file mode 100644 index 0000000000..1f90c7e008 --- /dev/null +++ b/data/sql/updates/db_world/2021_04_11_21.sql @@ -0,0 +1,29 @@ +-- DB update 2021_04_11_20 -> 2021_04_11_21 +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 = '2021_04_11_20'; +IF @COLEXISTS = 0 THEN LEAVE proc; END IF; +START TRANSACTION; +ALTER TABLE version_db_world CHANGE COLUMN 2021_04_11_20 2021_04_11_21 bit; +SELECT sql_rev INTO OK FROM version_db_world WHERE sql_rev = '1617919651657315506'; IF OK <> 'FALSE' THEN LEAVE proc; END IF; +-- +-- START UPDATING QUERIES +-- + +INSERT INTO `version_db_world` (`sql_rev`) VALUES ('1617919651657315506'); + +-- Azuremyst Isle - Timberstrider Fledgling spawn +UPDATE `creature` SET `position_x`=-4660.85, `position_y`=-12176.9, `position_z`=31.6266, `orientation`=0.746134 WHERE `guid`=62767 and `id`=17372; + +-- +-- END UPDATING QUERIES +-- +COMMIT; +END // +DELIMITER ; +CALL updateDb(); +DROP PROCEDURE IF EXISTS `updateDb`; diff --git a/data/sql/updates/db_world/2021_04_11_22.sql b/data/sql/updates/db_world/2021_04_11_22.sql new file mode 100644 index 0000000000..6893d94bd8 --- /dev/null +++ b/data/sql/updates/db_world/2021_04_11_22.sql @@ -0,0 +1,35 @@ +-- DB update 2021_04_11_21 -> 2021_04_11_22 +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 = '2021_04_11_21'; +IF @COLEXISTS = 0 THEN LEAVE proc; END IF; +START TRANSACTION; +ALTER TABLE version_db_world CHANGE COLUMN 2021_04_11_21 2021_04_11_22 bit; +SELECT sql_rev INTO OK FROM version_db_world WHERE sql_rev = '1617936479961800600'; IF OK <> 'FALSE' THEN LEAVE proc; END IF; +-- +-- START UPDATING QUERIES +-- + +INSERT INTO `version_db_world` (`sql_rev`) VALUES ('1617936479961800600'); + + +UPDATE `gameobject` SET `position_x`=1234.406, `position_y`=-4135.120, `position_z`=26.184, `orientation`=0.517706 WHERE `guid`=12381; + +UPDATE `gameobject` SET `position_x`=857.312, `position_y`=-4118.451, `position_z`=26.625, `orientation`=2.861797 WHERE `guid`=5361; + +-- Silver Vein + +UPDATE `gameobject` SET `position_x`=345.075, `position_y`=-3199.625, `position_z`=99.877, `orientation`=4.398968 WHERE `guid`=5756; + +-- +-- END UPDATING QUERIES +-- +COMMIT; +END // +DELIMITER ; +CALL updateDb(); +DROP PROCEDURE IF EXISTS `updateDb`; diff --git a/data/sql/updates/pending_db_world/rev_1617946428490261300.sql b/data/sql/updates/db_world/2021_04_11_23.sql index 0bf18efe0c..5b4ceb6424 100644 --- a/data/sql/updates/pending_db_world/rev_1617946428490261300.sql +++ b/data/sql/updates/db_world/2021_04_11_23.sql @@ -1,3 +1,19 @@ +-- DB update 2021_04_11_22 -> 2021_04_11_23 +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 = '2021_04_11_22'; +IF @COLEXISTS = 0 THEN LEAVE proc; END IF; +START TRANSACTION; +ALTER TABLE version_db_world CHANGE COLUMN 2021_04_11_22 2021_04_11_23 bit; +SELECT sql_rev INTO OK FROM version_db_world WHERE sql_rev = '1617946428490261300'; IF OK <> 'FALSE' THEN LEAVE proc; END IF; +-- +-- START UPDATING QUERIES +-- + INSERT INTO `version_db_world` (`sql_rev`) VALUES ('1617946428490261300'); -- New GUIDs game_event 87, CREATURE 300007 - 300015*/ @@ -311,3 +327,12 @@ INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type (11878,0,6,0,38,0,100,0,1,1,0,0,0,80,1187800,0,0,0,0,0,1,0,0,0,0,0,0,0,0,'Nathanos Blightcaller - On Data Set 1 1 - Run Script'), (1187800,9,0,0,0,0,100,0,300000,300000,300000,300000,0,111,87,0,0,0,0,0,1,0,0,0,0,0,0,0,0,'Nathanos Blightcaller - Script - Stop Event'), (1187800,9,1,0,0,0,100,0,1000,1000,0,0,0,48,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,'Nathanos Blightcaller - On Game Event \'Demetria\' End - Set Active Off'); + +-- +-- END UPDATING QUERIES +-- +COMMIT; +END // +DELIMITER ; +CALL updateDb(); +DROP PROCEDURE IF EXISTS `updateDb`; diff --git a/data/sql/updates/db_world/2021_04_11_24.sql b/data/sql/updates/db_world/2021_04_11_24.sql new file mode 100644 index 0000000000..f39d8514e6 --- /dev/null +++ b/data/sql/updates/db_world/2021_04_11_24.sql @@ -0,0 +1,28 @@ +-- DB update 2021_04_11_23 -> 2021_04_11_24 +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 = '2021_04_11_23'; +IF @COLEXISTS = 0 THEN LEAVE proc; END IF; +START TRANSACTION; +ALTER TABLE version_db_world CHANGE COLUMN 2021_04_11_23 2021_04_11_24 bit; +SELECT sql_rev INTO OK FROM version_db_world WHERE sql_rev = '1617986524556683595'; IF OK <> 'FALSE' THEN LEAVE proc; END IF; +-- +-- START UPDATING QUERIES +-- + +INSERT INTO `version_db_world` (`sql_rev`) VALUES ('1617986524556683595'); + +UPDATE `gameobject` SET `spawntimesecs` = 7200 WHERE `guid` IN (100067); + +-- +-- END UPDATING QUERIES +-- +COMMIT; +END // +DELIMITER ; +CALL updateDb(); +DROP PROCEDURE IF EXISTS `updateDb`; diff --git a/data/sql/updates/db_world/2021_04_11_25.sql b/data/sql/updates/db_world/2021_04_11_25.sql new file mode 100644 index 0000000000..268f8101e7 --- /dev/null +++ b/data/sql/updates/db_world/2021_04_11_25.sql @@ -0,0 +1,41 @@ +-- DB update 2021_04_11_24 -> 2021_04_11_25 +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 = '2021_04_11_24'; +IF @COLEXISTS = 0 THEN LEAVE proc; END IF; +START TRANSACTION; +ALTER TABLE version_db_world CHANGE COLUMN 2021_04_11_24 2021_04_11_25 bit; +SELECT sql_rev INTO OK FROM version_db_world WHERE sql_rev = '1617988329167837335'; IF OK <> 'FALSE' THEN LEAVE proc; END IF; +-- +-- START UPDATING QUERIES +-- + +INSERT INTO `version_db_world` (`sql_rev`) VALUES ('1617988329167837335'); + +-- Create pooling, 11651 is the latest+2 entry in `pool_template` +DELETE FROM `pool_template` WHERE `entry` IN (11651); +INSERT INTO `pool_template` (`entry`,`max_limit`,`description`) VALUES +(11651,1,"Solid Chests, Northfold Manor"); + +-- Add gameobjects to pools +DELETE FROM `pool_gameobject` WHERE `guid` IN (16946,100068); +INSERT INTO `pool_gameobject` (`guid`,`pool_entry`,`chance`,`description`) VALUES +(16946,11651,0,"Solid Chests, Northfold Manor, node 1"), +(100068,11651,0,"Solid Chests, Northfold Manor, node 2"); + +-- Set spawn time to 15 minutes +UPDATE `gameobject` SET `spawntimesecs`=900 WHERE `guid` IN (16946,100068); + + +-- +-- END UPDATING QUERIES +-- +COMMIT; +END // +DELIMITER ; +CALL updateDb(); +DROP PROCEDURE IF EXISTS `updateDb`; diff --git a/data/sql/updates/db_world/2021_04_11_26.sql b/data/sql/updates/db_world/2021_04_11_26.sql new file mode 100644 index 0000000000..fa838a5aa3 --- /dev/null +++ b/data/sql/updates/db_world/2021_04_11_26.sql @@ -0,0 +1,30 @@ +-- DB update 2021_04_11_25 -> 2021_04_11_26 +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 = '2021_04_11_25'; +IF @COLEXISTS = 0 THEN LEAVE proc; END IF; +START TRANSACTION; +ALTER TABLE version_db_world CHANGE COLUMN 2021_04_11_25 2021_04_11_26 bit; +SELECT sql_rev INTO OK FROM version_db_world WHERE sql_rev = '1618037276986031900'; IF OK <> 'FALSE' THEN LEAVE proc; END IF; +-- +-- START UPDATING QUERIES +-- + +INSERT INTO `version_db_world` (`sql_rev`) VALUES ('1618037276986031900'); + +DELETE FROM `skinning_loot_template` WHERE (`entry` = 1984); + +UPDATE `creature_template` SET `skinloot` = 100002 WHERE (`entry` IN (2032, 1984)); + +-- +-- END UPDATING QUERIES +-- +COMMIT; +END // +DELIMITER ; +CALL updateDb(); +DROP PROCEDURE IF EXISTS `updateDb`; diff --git a/data/sql/updates/pending_db_world/rev_1617475678754474649.sql b/data/sql/updates/pending_db_world/rev_1617475678754474649.sql deleted file mode 100644 index 74602dbcb2..0000000000 --- a/data/sql/updates/pending_db_world/rev_1617475678754474649.sql +++ /dev/null @@ -1,6 +0,0 @@ -INSERT INTO `version_db_world` (`sql_rev`) VALUES ('1617475678754474649'); - -DELETE FROM `creature` WHERE (`id` = 2960) AND (`guid` IN (25623)); -INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES -(25623, 2960, 1, 0, 0, 1, 1, 161, 0, -718.670898, -677.328979, -15.930156, 5.17604, 250, 20, 0, 176, 0, 1, 0, 0, 0, '', 0); - diff --git a/data/sql/updates/pending_db_world/rev_1617560891918432300.sql b/data/sql/updates/pending_db_world/rev_1617560891918432300.sql deleted file mode 100644 index 0617e620c8..0000000000 --- a/data/sql/updates/pending_db_world/rev_1617560891918432300.sql +++ /dev/null @@ -1,6 +0,0 @@ -INSERT INTO `version_db_world` (`sql_rev`) VALUES ('1617560891918432300'); - -DELETE FROM `quest_poi_points` WHERE `QuestID` = 6127; -INSERT INTO `quest_poi_points` VALUES -(6127, 0, 0, -544, -2672, 0), -(6127, 1, 0, 336, -2280, 0); diff --git a/data/sql/updates/pending_db_world/rev_1617612991251140137.sql b/data/sql/updates/pending_db_world/rev_1617612991251140137.sql deleted file mode 100644 index 100c019f94..0000000000 --- a/data/sql/updates/pending_db_world/rev_1617612991251140137.sql +++ /dev/null @@ -1,6 +0,0 @@ -INSERT INTO `version_db_world` (`sql_rev`) VALUES ('1617612991251140137'); - -DELETE FROM `creature` WHERE (`id` = 3273) AND (`guid` IN (20534)); -INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES -(20534, 3273, 1, 0, 0, 1, 1, 9443, 1, 1.525501, -1759.818481, 95.022011, 1.5666, 275, 0, 0, 253, 264, 0, 0, 0, 0, '', 0); - diff --git a/data/sql/updates/pending_db_world/rev_1617614528274234003.sql b/data/sql/updates/pending_db_world/rev_1617614528274234003.sql deleted file mode 100644 index 4f01ca812d..0000000000 --- a/data/sql/updates/pending_db_world/rev_1617614528274234003.sql +++ /dev/null @@ -1,3 +0,0 @@ -INSERT INTO `version_db_world` (`sql_rev`) VALUES ('1617614528274234003'); - -UPDATE `quest_template` SET `AllowableRaces` = 690 WHERE (`ID` = 5761); diff --git a/data/sql/updates/pending_db_world/rev_1617620649041950300.sql b/data/sql/updates/pending_db_world/rev_1617620649041950300.sql deleted file mode 100644 index b885904066..0000000000 --- a/data/sql/updates/pending_db_world/rev_1617620649041950300.sql +++ /dev/null @@ -1,7 +0,0 @@ -INSERT INTO `version_db_world` (`sql_rev`) VALUES ('1617620649041950300'); - -UPDATE `gameobject_template` SET `AIName` = 'SmartGameObjectAI' WHERE `entry` = 3740; - -DELETE FROM `smart_scripts` WHERE (`source_type` = 1 AND `entryorguid` = 3740); -INSERT INTO `smart_scripts` VALUES -(3740, 1, 0, 0, 60, 0, 100, 0, 500, 500, 3500, 3500, 0, 75, 17775, 0, 0, 0, 0, 0, 18, 10, 0, 0, 0, 0, 0, 0, 0, 'Bubbling Fissure - On Update - Add Aura \'Air Bubbles\''); diff --git a/data/sql/updates/pending_db_world/rev_1617634980911314885.sql b/data/sql/updates/pending_db_world/rev_1617634980911314885.sql deleted file mode 100644 index f660955787..0000000000 --- a/data/sql/updates/pending_db_world/rev_1617634980911314885.sql +++ /dev/null @@ -1,6 +0,0 @@ -INSERT INTO `version_db_world` (`sql_rev`) VALUES ('1617634980911314885'); - -DELETE FROM `creature` WHERE (`id` = 7318) AND (`guid` IN (46818)); -INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES -(46818, 7318, 1, 0, 0, 1, 1, 6231, 1, 9843.19, 1496.22, 1257.25, 2.34654, 300, 0, 0, 186, 191, 2, 0, 0, 0, '', 0); - diff --git a/data/sql/updates/pending_db_world/rev_1617661090934443600.sql b/data/sql/updates/pending_db_world/rev_1617661090934443600.sql deleted file mode 100644 index f7d5909ddf..0000000000 --- a/data/sql/updates/pending_db_world/rev_1617661090934443600.sql +++ /dev/null @@ -1,7 +0,0 @@ -INSERT INTO `version_db_world` (`sql_rev`) VALUES ('1617661090934443600'); - -UPDATE `creature_template` SET `InhabitType` = 3 WHERE (`entry` IN (1018, 1019, 1140)); - -DELETE FROM `creature` WHERE (`id` = 1018) AND (`guid` IN (9981)); -INSERT INTO `creature` VALUES -(9981, 1018, 0, 0, 0, 1, 1, 180, 0, -3112.84, -3252.45, 65.1154, 5.6466, 300, 0, 0, 896, 0, 0, 0, 0, 0, '', 0); diff --git a/data/sql/updates/pending_db_world/rev_1617739461755573400.sql b/data/sql/updates/pending_db_world/rev_1617739461755573400.sql deleted file mode 100644 index ac0829bc6d..0000000000 --- a/data/sql/updates/pending_db_world/rev_1617739461755573400.sql +++ /dev/null @@ -1,11 +0,0 @@ -INSERT INTO `version_db_world` (`sql_rev`) VALUES ('1617739461755573400'); - -DELETE FROM `spell_script_names` WHERE (`spell_id` IN (23567, 23568, 23569, 23696, 24412, 24413, 24414)); -INSERT INTO `spell_script_names` VALUES -(23567, 'spell_gen_bandage'), -(23568, 'spell_gen_bandage'), -(23569, 'spell_gen_bandage'), -(23696, 'spell_gen_bandage'), -(24412, 'spell_gen_bandage'), -(24413, 'spell_gen_bandage'), -(24414, 'spell_gen_bandage'); diff --git a/data/sql/updates/pending_db_world/rev_1617774706114876200.sql b/data/sql/updates/pending_db_world/rev_1617774706114876200.sql deleted file mode 100644 index 11771af405..0000000000 --- a/data/sql/updates/pending_db_world/rev_1617774706114876200.sql +++ /dev/null @@ -1,5 +0,0 @@ -INSERT INTO `version_db_world` (`sql_rev`) VALUES ('1617774706114876200'); - -DELETE FROM `creature` WHERE (`id` = 16313) AND (`guid` IN (81792)); -INSERT INTO `creature` VALUES -(81792, 16313, 530, 0, 0, 1, 1, 0, 0, 7937.95, -7354.2, 144.804, 5.9059, 300, 0, 0, 166, 178, 0, 0, 0, 0, '', 0); diff --git a/data/sql/updates/pending_db_world/rev_1617830328758041600.sql b/data/sql/updates/pending_db_world/rev_1617830328758041600.sql deleted file mode 100644 index 65b2fc3d3d..0000000000 --- a/data/sql/updates/pending_db_world/rev_1617830328758041600.sql +++ /dev/null @@ -1,8 +0,0 @@ -INSERT INTO `version_db_world` (`sql_rev`) VALUES ('1617830328758041600'); - -DELETE FROM `gameobject` WHERE (`id` = 86492) AND (`guid` IN (48637, 48639, 48793, 48796)); -INSERT INTO `gameobject` VALUES -(48637, 86492, 1, 0, 0, 1, 1, 6392.77, 725.474, -16.2576, 2.46091, 0, 0, 0.942641, 0.333807, 180, 100, 1, '', 0), -(48639, 86492, 1, 0, 0, 1, 1, 6402.14, 742.257, -17.73105, -2.30383, 0, 0, 0.913545, -0.406737, 180, 100, 1, '', 0), -(48793, 86492, 1, 0, 0, 1, 1, 6305.19, 801.911, -12.4957, -0.942478, 0, 0, 0.453991, -0.891006, 180, 100, 1, '', 0), -(48796, 86492, 1, 0, 0, 1, 1, 6309.88, 846.544, -12.4766, 1.64846, 0, 0, 0.34202, 0.939693, 180, 100, 1, '', 0); diff --git a/data/sql/updates/pending_db_world/rev_1617865372308647700.sql b/data/sql/updates/pending_db_world/rev_1617865372308647700.sql deleted file mode 100644 index 2ef6476c92..0000000000 --- a/data/sql/updates/pending_db_world/rev_1617865372308647700.sql +++ /dev/null @@ -1,3 +0,0 @@ -INSERT INTO `version_db_world` (`sql_rev`) VALUES ('1617865372308647700'); - -UPDATE `creature_template` SET `skinloot` = 100002 WHERE (`entry` = 3098); diff --git a/data/sql/updates/pending_db_world/rev_1617902440529783360.sql b/data/sql/updates/pending_db_world/rev_1617902440529783360.sql deleted file mode 100644 index 82e10f625c..0000000000 --- a/data/sql/updates/pending_db_world/rev_1617902440529783360.sql +++ /dev/null @@ -1,9 +0,0 @@ -INSERT INTO `version_db_world` (`sql_rev`) VALUES ('1617902440529783360'); - --- Remove Flesh Piercer from Reference Table -DELETE FROM `reference_loot_template` WHERE `Entry` = 24068 AND `Item` = 3336; - --- Adds Flesh Piercer to Daggerspine Shorestalkers and Screamers loot tables -INSERT INTO `creature_loot_template` VALUES -(2368, 3336, 0, 1.5, 0, 1, 0, 1, 1, "Daggerspine Shorestalker - Flesh Piercer"), -(2370, 3336, 0, 1.1, 0, 1, 0, 1, 1, "Daggerspine Screamer - Flesh Piercer"); diff --git a/data/sql/updates/pending_db_world/rev_1617913282545327642.sql b/data/sql/updates/pending_db_world/rev_1617913282545327642.sql deleted file mode 100644 index f730bfae9b..0000000000 --- a/data/sql/updates/pending_db_world/rev_1617913282545327642.sql +++ /dev/null @@ -1,10 +0,0 @@ -INSERT INTO `version_db_world` (`sql_rev`) VALUES ('1617913282545327642'); - --- Silverpine Forest -DELETE FROM `gameobject` WHERE `guid`=35525; - --- Darkshore -DELETE FROM `gameobject` WHERE `guid` in (4729, 5079, 5055, 5078, 5079, 5392, 5351); - --- Durotar -DELETE FROM `gameobject` WHERE `guid`=12383; diff --git a/data/sql/updates/pending_db_world/rev_1617915554384852400.sql b/data/sql/updates/pending_db_world/rev_1617915554384852400.sql deleted file mode 100644 index 2003cd561b..0000000000 --- a/data/sql/updates/pending_db_world/rev_1617915554384852400.sql +++ /dev/null @@ -1,3 +0,0 @@ -INSERT INTO `version_db_world` (`sql_rev`) VALUES ('1617915554384852400'); - -DELETE FROM `spell_custom_attr` WHERE `spell_id` IN (99, 1735, 9490, 9747, 9898, 26998, 48559, 48560); diff --git a/data/sql/updates/pending_db_world/rev_1617919651657315506.sql b/data/sql/updates/pending_db_world/rev_1617919651657315506.sql deleted file mode 100644 index bea4a923e8..0000000000 --- a/data/sql/updates/pending_db_world/rev_1617919651657315506.sql +++ /dev/null @@ -1,4 +0,0 @@ -INSERT INTO `version_db_world` (`sql_rev`) VALUES ('1617919651657315506'); - --- Azuremyst Isle - Timberstrider Fledgling spawn -UPDATE `creature` SET `position_x`=-4660.85, `position_y`=-12176.9, `position_z`=31.6266, `orientation`=0.746134 WHERE `guid`=62767 and `id`=17372; diff --git a/data/sql/updates/pending_db_world/rev_1617936479961800600.sql b/data/sql/updates/pending_db_world/rev_1617936479961800600.sql deleted file mode 100644 index 675455d04f..0000000000 --- a/data/sql/updates/pending_db_world/rev_1617936479961800600.sql +++ /dev/null @@ -1,10 +0,0 @@ -INSERT INTO `version_db_world` (`sql_rev`) VALUES ('1617936479961800600'); - - -UPDATE `gameobject` SET `position_x`=1234.406, `position_y`=-4135.120, `position_z`=26.184, `orientation`=0.517706 WHERE `guid`=12381; - -UPDATE `gameobject` SET `position_x`=857.312, `position_y`=-4118.451, `position_z`=26.625, `orientation`=2.861797 WHERE `guid`=5361; - --- Silver Vein - -UPDATE `gameobject` SET `position_x`=345.075, `position_y`=-3199.625, `position_z`=99.877, `orientation`=4.398968 WHERE `guid`=5756; diff --git a/data/sql/updates/pending_db_world/rev_1617986524556683595.sql b/data/sql/updates/pending_db_world/rev_1617986524556683595.sql deleted file mode 100644 index 75498884c9..0000000000 --- a/data/sql/updates/pending_db_world/rev_1617986524556683595.sql +++ /dev/null @@ -1,3 +0,0 @@ -INSERT INTO `version_db_world` (`sql_rev`) VALUES ('1617986524556683595'); - -UPDATE `gameobject` SET `spawntimesecs` = 7200 WHERE `guid` IN (100067); diff --git a/data/sql/updates/pending_db_world/rev_1617988329167837335.sql b/data/sql/updates/pending_db_world/rev_1617988329167837335.sql deleted file mode 100644 index 60cdf24286..0000000000 --- a/data/sql/updates/pending_db_world/rev_1617988329167837335.sql +++ /dev/null @@ -1,16 +0,0 @@ -INSERT INTO `version_db_world` (`sql_rev`) VALUES ('1617988329167837335'); - --- Create pooling, 11651 is the latest+2 entry in `pool_template` -DELETE FROM `pool_template` WHERE `entry` IN (11651); -INSERT INTO `pool_template` (`entry`,`max_limit`,`description`) VALUES -(11651,1,"Solid Chests, Northfold Manor"); - --- Add gameobjects to pools -DELETE FROM `pool_gameobject` WHERE `guid` IN (16946,100068); -INSERT INTO `pool_gameobject` (`guid`,`pool_entry`,`chance`,`description`) VALUES -(16946,11651,0,"Solid Chests, Northfold Manor, node 1"), -(100068,11651,0,"Solid Chests, Northfold Manor, node 2"); - --- Set spawn time to 15 minutes -UPDATE `gameobject` SET `spawntimesecs`=900 WHERE `guid` IN (16946,100068); - diff --git a/data/sql/updates/pending_db_world/rev_1618037276986031900.sql b/data/sql/updates/pending_db_world/rev_1618037276986031900.sql deleted file mode 100644 index de07690151..0000000000 --- a/data/sql/updates/pending_db_world/rev_1618037276986031900.sql +++ /dev/null @@ -1,5 +0,0 @@ -INSERT INTO `version_db_world` (`sql_rev`) VALUES ('1618037276986031900'); - -DELETE FROM `skinning_loot_template` WHERE (`entry` = 1984); - -UPDATE `creature_template` SET `skinloot` = 100002 WHERE (`entry` IN (2032, 1984)); |