aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--sql/updates/world/2012_10_25_00_world_childrens_week.sql (renamed from sql/updates/world/2012_10_20_00_world_childrens_week.sql)27
1 files changed, 14 insertions, 13 deletions
diff --git a/sql/updates/world/2012_10_20_00_world_childrens_week.sql b/sql/updates/world/2012_10_25_00_world_childrens_week.sql
index 55c874036c5..33ad3c54ad1 100644
--- a/sql/updates/world/2012_10_20_00_world_childrens_week.sql
+++ b/sql/updates/world/2012_10_25_00_world_childrens_week.sql
@@ -391,9 +391,10 @@ INSERT INTO `conditions`(`SourceTypeOrReferenceId`,`SourceEntry`,`ConditionTypeO
(20,5502,8,925,'Show quest mark 5502 - Quest 925 needs to be rewarded');
-- Home of the bear-men
-SET @GUID_GRIZZLEMAW_TRIGGER_1 = 3019842;
-SET @GUID_GRIZZLEMAW_TRIGGER_2 = 3019843;
-SET @GUID_GRIZZLEMAW_TRIGGER_3 = 3106167;
+SET @GUIDS = 85179;
+SET @GUID_GRIZZLEMAW_TRIGGER_1 = @GUIDS + 0;
+SET @GUID_GRIZZLEMAW_TRIGGER_2 = @GUIDS + 1;
+SET @GUID_GRIZZLEMAW_TRIGGER_3 = @GUIDS + 2;
UPDATE `creature_template` SET `AIName`='',`ScriptName`='npc_grizzlemaw_cw_trigger',`flags_extra`=0 WHERE `entry`=36209;
@@ -404,7 +405,7 @@ INSERT INTO `creature`(`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`)
(@GUID_GRIZZLEMAW_TRIGGER_3,36209,571,3923.109,-3763.967,165.362);
-- Elder Kekek
-SET @GUID_KEKEK = 3019845;
+SET @GUID_KEKEK = @GUIDS + 3;
SET @TEXT_ELDER_KEKEK_1 = 1;
UPDATE `creature_template` SET `ScriptName`='npc_elder_kekek' WHERE `entry`=34387;
@@ -429,7 +430,7 @@ INSERT INTO `creature_text`(`entry`,`groupid`,`text`,`type`,`emote`) VALUE
(27990,@TEXT_KRASUS_8,"Rest assured, Kekek, she is the queen of the dragons. We often take the forms of smaller beings when we work with them.",12,0);
-- High Oracle Soo Roo
-SET @GUID_SOO_ROO = 3019824;
+SET @GUID_SOO_ROO = @GUIDS + 4;
SET @TEXT_SOO_ROO_1 = 1;
UPDATE `creature_template` SET `AIName`='',`ScriptName`='npc_high_oracle_soo_roo' WHERE `entry`=34386;
@@ -450,7 +451,7 @@ INSERT INTO `creature_text`(`entry`,`groupid`,`text`,`type`,`emote`) VALUE
(27986,@TEXT_NESINGWARY_1,"Well, lad, you can start by readin' The Green Hills of Stranglethorn. Then, maybe you can join me on one of my safaris. What do you say?",12,0);
-- Snowfall Glade Playmate
-SET @GUID_SNOWFALL_GLADE_PLAYMATE = 3019844;
+SET @GUID_SNOWFALL_GLADE_PLAYMATE = @GUIDS + 5;
SET @TEXT_SNOWFALL_GLADE_PLAYMATE_1 = 1;
SET @TEXT_SNOWFALL_GLADE_PLAYMATE_2 = 2;
@@ -466,7 +467,7 @@ INSERT INTO `creature`(`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,
(@GUID_SNOWFALL_GLADE_PLAYMATE,34490,571,3325.193,1026.451,138.1712,2.062184);
-- Winterfin Playmate
-SET @GUID_WINTERFIN_PLAYMATE = 3019823;
+SET @GUID_WINTERFIN_PLAYMATE = @GUIDS + 6;
SET @TEXT_WINTERFIN_PLAYMATE_1 = 1;
SET @TEXT_WINTERFIN_PLAYMATE_2 = 2;
@@ -482,7 +483,7 @@ INSERT INTO `creature`(`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,
(@GUID_WINTERFIN_PLAYMATE,34489,571,4382.502,6066.199,0.724562,3.571894);
-- Biggest Tree Ever
-SET @GUID_BIGGEST_TREE_TRIGGER = 3019825;
+SET @GUID_BIGGEST_TREE_TRIGGER = @GUIDS + 7;
UPDATE `creature_template` SET `AIName`='',`ScriptName`='npc_the_biggest_tree',`flags_extra`=0 WHERE `entry`=34381;
@@ -521,11 +522,11 @@ INSERT INTO `quest_poi_points`(`questId`,`x`,`y`) VALUES
(13955,3530,271);
-- NPC areatriggers
-SET @GUID_AERIS_LANDING_TRIGGER = 3019827;
-SET @GUID_SILVERMOON_TRIGGER_01 = 3019838;
-SET @GUID_AUCHINDOUN_TRIGGER = 3019828;
-SET @GUID_SPOREGGAR_TRIGGER = 3019829;
-SET @GUID_THRONE_OF_ELEMENTS_TRIGGER = 3019830;
+SET @GUID_AERIS_LANDING_TRIGGER = @GUIDS + 8;
+SET @GUID_SILVERMOON_TRIGGER_01 = @GUIDS + 9;
+SET @GUID_AUCHINDOUN_TRIGGER = @GUIDS + 10;
+SET @GUID_SPOREGGAR_TRIGGER = @GUIDS + 11;
+SET @GUID_THRONE_OF_ELEMENTS_TRIGGER = @GUIDS + 12;
UPDATE `creature_template` SET `InhabitType`=7,`flags_extra`=0,`unit_flags`=33554432,`ScriptName`='npc_cw_area_trigger',`AIName`='' WHERE `entry` IN (22905,22851,22838,22866,22831,22829,22872,22839);