From 949fde098aeb7bff60e56783a0f116e34dfeae5d Mon Sep 17 00:00:00 2001 From: nelegalno Date: Mon, 27 Aug 2012 16:34:26 +0100 Subject: DB/GOs: Spawn Blackened Urn in Karazhan, should fix Nightbane summoning and the quest chain Closes #975 --- sql/updates/world/2012_08_27_00_creature_template.sql | 2 -- sql/updates/world/2012_08_27_00_world_creature_template.sql | 2 ++ sql/updates/world/2012_08_27_02_playercreateinfo_spell.sql | 9 --------- sql/updates/world/2012_08_27_02_world_playercreateinfo_spell.sql | 9 +++++++++ sql/updates/world/2012_08_27_03_world_gameobject.sql | 6 ++++++ 5 files changed, 17 insertions(+), 11 deletions(-) delete mode 100644 sql/updates/world/2012_08_27_00_creature_template.sql create mode 100644 sql/updates/world/2012_08_27_00_world_creature_template.sql delete mode 100644 sql/updates/world/2012_08_27_02_playercreateinfo_spell.sql create mode 100644 sql/updates/world/2012_08_27_02_world_playercreateinfo_spell.sql create mode 100644 sql/updates/world/2012_08_27_03_world_gameobject.sql (limited to 'sql') diff --git a/sql/updates/world/2012_08_27_00_creature_template.sql b/sql/updates/world/2012_08_27_00_creature_template.sql deleted file mode 100644 index 804d7b5c61d..00000000000 --- a/sql/updates/world/2012_08_27_00_creature_template.sql +++ /dev/null @@ -1,2 +0,0 @@ --- NPC script linking for Wyrmrest Defender ID: 27629 -UPDATE `creature_template` SET `ScriptName`='npc_wyrmrest_defender' WHERE `entry`=27629; diff --git a/sql/updates/world/2012_08_27_00_world_creature_template.sql b/sql/updates/world/2012_08_27_00_world_creature_template.sql new file mode 100644 index 00000000000..804d7b5c61d --- /dev/null +++ b/sql/updates/world/2012_08_27_00_world_creature_template.sql @@ -0,0 +1,2 @@ +-- NPC script linking for Wyrmrest Defender ID: 27629 +UPDATE `creature_template` SET `ScriptName`='npc_wyrmrest_defender' WHERE `entry`=27629; diff --git a/sql/updates/world/2012_08_27_02_playercreateinfo_spell.sql b/sql/updates/world/2012_08_27_02_playercreateinfo_spell.sql deleted file mode 100644 index 9c664142bba..00000000000 --- a/sql/updates/world/2012_08_27_02_playercreateinfo_spell.sql +++ /dev/null @@ -1,9 +0,0 @@ -DELETE FROM `playercreateinfo_spell` WHERE `Spell` IN (59221,59535,59536,59538,59539,59540,59541); -INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES -(11,1,59221,'Shadow Resistance'), -(11,2,59535,'Shadow Resistance'), -(11,3,59536,'Shadow Resistance'), -(11,5,59538,'Shadow Resistance'), -(11,6,59539,'Shadow Resistance'), -(11,7,59540,'Shadow Resistance'), -(11,8,59541,'Shadow Resistance'); diff --git a/sql/updates/world/2012_08_27_02_world_playercreateinfo_spell.sql b/sql/updates/world/2012_08_27_02_world_playercreateinfo_spell.sql new file mode 100644 index 00000000000..9c664142bba --- /dev/null +++ b/sql/updates/world/2012_08_27_02_world_playercreateinfo_spell.sql @@ -0,0 +1,9 @@ +DELETE FROM `playercreateinfo_spell` WHERE `Spell` IN (59221,59535,59536,59538,59539,59540,59541); +INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES +(11,1,59221,'Shadow Resistance'), +(11,2,59535,'Shadow Resistance'), +(11,3,59536,'Shadow Resistance'), +(11,5,59538,'Shadow Resistance'), +(11,6,59539,'Shadow Resistance'), +(11,7,59540,'Shadow Resistance'), +(11,8,59541,'Shadow Resistance'); diff --git a/sql/updates/world/2012_08_27_03_world_gameobject.sql b/sql/updates/world/2012_08_27_03_world_gameobject.sql new file mode 100644 index 00000000000..1bf836c96e0 --- /dev/null +++ b/sql/updates/world/2012_08_27_03_world_gameobject.sql @@ -0,0 +1,6 @@ +-- Spawn Blackened Urn (194092) GO based on sniff by Aokromes +SET @GUID := 334; -- Set by TDB team + +DELETE FROM `gameobject` WHERE `id`=194092; +INSERT INTO `gameobject` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`) VALUES +(@GUID,194092,532,1,1,-11126.87,-1874.455,91.47264,6.056293,0,0,-0.113203,0.9935719,180,100,1); -- cgit v1.2.3