From 9c4cf9b39c17854fac3c1323e5e3bd1d2f164e3d Mon Sep 17 00:00:00 2001 From: Gacko Date: Sun, 21 Oct 2012 14:33:20 +0200 Subject: Core/DB: Children's Week --- .../world/2012_10_20_00_world_childrens_week.sql | 573 +++++++++++++++++++++ 1 file changed, 573 insertions(+) create mode 100644 sql/updates/world/2012_10_20_00_world_childrens_week.sql (limited to 'sql') diff --git a/sql/updates/world/2012_10_20_00_world_childrens_week.sql b/sql/updates/world/2012_10_20_00_world_childrens_week.sql new file mode 100644 index 00000000000..55c874036c5 --- /dev/null +++ b/sql/updates/world/2012_10_20_00_world_childrens_week.sql @@ -0,0 +1,573 @@ +-- Orphan Matron Aria +UPDATE `creature_template` SET `AIName`='SmartAI',`ScriptName`='' WHERE `entry`=34365; + +DELETE FROM `smart_scripts` WHERE `entryorguid`=34365 AND `source_type`=0; +INSERT INTO `smart_scripts`(`entryorguid`,`id`,`link`,`event_type`,`event_param1`,`event_param2`,`action_type`,`action_param1`,`target_type`,`comment`) VALUES +(34365,1,4,62,10502,1,33,34365,7,'Orphan Matron Aria - On gossip select - Give quest credit'), +(34365,2,4,62,10502,2,11,65359,7,'Orphan Matron Aria - On gossip select - Create oracle orphan whistle'), +(34365,3,4,62,10502,3,11,65360,7,'Orphan Matron Aria - On gossip select - Create wolvar orphan whistle'), +(34365,4,0,61,0,0,72,0,7,'Orphan Matron Aria - On gossip select - Close gossip'); + +DELETE FROM `gossip_menu_option` WHERE `menu_id`=10502; +INSERT INTO `gossip_menu_option`(`menu_id`,`id`,`option_icon`,`option_text`,`option_id`,`npc_option_npcflag`) VALUES +(10502,1,0,'Tell me about the orphans.',1,1), +(10502,2,0,'I need a new Oracle Orphan Whistle.',1,1), +(10502,3,0,'I need a new Wolvar Orphan Whistle.',1,1); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=10502; +INSERT INTO `conditions`(`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`NegativeCondition`,`Comment`) VALUES +(15,10502,1,1,12,10,0,0,'Childrens Week must be active'), +(15,10502,1,1,1,58818,0,0,'Needs aura 58818'), +(15,10502,1,1,9,13927,0,0,'Quest 13927 must be active'), +(15,10502,1,2,12,10,0,0,'Childrens Week must be active'), +(15,10502,1,2,1,58818,0,0,'Needs aura 58818'), +(15,10502,1,2,9,13926,0,0,'Quest 13926 must be active'), +(15,10502,2,0,12,10,0,0,'Childrens Week must be active'), +(15,10502,2,0,8,13926,0,0,'Quest 13926 must be rewarded'), +(15,10502,2,0,2,46397,1,1,'Must not have item 46397'), +(15,10502,3,0,12,10,0,0,'Childrens Week must be active'), +(15,10502,3,0,8,13927,0,0,'Quest 13926 must be rewarded'), +(15,10502,3,0,2,46396,1,1,'Must not have item 46397'); + +-- Orphan Matron Battlewail +UPDATE `creature_template` SET `AIName`='SmartAI',`ScriptName`='' WHERE `entry`=14451; + +DELETE FROM `smart_scripts` WHERE `entryorguid`=14451 AND `source_type`=0; +INSERT INTO `smart_scripts`(`entryorguid`,`id`,`link`,`event_type`,`event_param1`,`event_param2`,`action_type`,`action_param1`,`target_type`,`comment`) VALUES +(14451,1,2,62,5848,1,11,23125,7,'Orphan Matron Battlewail - On gossip select - Create orc orphan whistle'), +(14451,2,0,61,0,0,72,0,7,'Orphan Matron Battlewail - On gossip select - Close gossip'); + +DELETE FROM `gossip_menu_option` WHERE `menu_id`=5848; +INSERT INTO `gossip_menu_option`(`menu_id`,`id`,`option_icon`,`option_text`,`option_id`,`npc_option_npcflag`) VALUES +(5848,1,0,'I need a new Orc Orphan Whistle.',1,1); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=5848; +INSERT INTO `conditions`(`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`NegativeCondition`,`Comment`) VALUES +(15,5848,1,0,12,10,0,0,'Childrens Week must be active'), +(15,5848,1,0,8,172,0,0,'Quest 172 must be rewarded'), +(15,5848,1,0,2,18597,1,1,'Must not have item 18597'); + +-- Orphan Matron Mercy +UPDATE `creature_template` SET `AIName`='SmartAI',`ScriptName`='' WHERE `entry`=22819; + +DELETE FROM `smart_scripts` WHERE `entryorguid`=22819 AND `source_type`=0; +INSERT INTO `smart_scripts`(`entryorguid`,`id`,`link`,`event_type`,`event_param1`,`event_param2`,`action_type`,`action_param1`,`target_type`,`comment`) VALUES +(22819,1,3,62,8568,1,11,39512,7,'Orphan Matron Mercy - On gossip select - Create blood elf orphan whistle'), +(22819,2,3,62,8568,2,11,39513,7,'Orphan Matron Mercy - On gossip select - Create draenei orphan whistle'), +(22819,3,0,61,0,0,72,0,7,'Orphan Matron Mercy - On gossip select - Close gossip'); + +DELETE FROM `gossip_menu_option` WHERE `menu_id`=8568; +INSERT INTO `gossip_menu_option`(`menu_id`,`id`,`option_icon`,`option_text`,`option_id`,`npc_option_npcflag`) VALUES +(8568,1,0,'I need a new Blood Elf Orphan Whistle.',1,1), +(8568,2,0,'I need a new Draenei Orphan Whistle.',1,1); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=8568; +INSERT INTO `conditions`(`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`NegativeCondition`,`Comment`) VALUES +(15,8568,1,0,12,10,0,0,'Childrens Week must be active'), +(15,8568,1,0,8,10942,0,0,'Quest 10942 must be rewarded'), +(15,8568,1,0,2,31880,1,1,'Must not have item 31880'), +(15,8568,2,0,12,10,0,0,'Childrens Week must be active'), +(15,8568,2,0,8,10943,0,0,'Quest 10943 must be rewarded'), +(15,8568,2,0,2,31881,1,1,'Must not have item 31881'); + +-- Orphan Matron Nightingale +UPDATE `creature_template` SET `AIName`='SmartAI',`ScriptName`='' WHERE `entry`=14450; + +DELETE FROM `smart_scripts` WHERE `entryorguid`=14450 AND `source_type`=0; +INSERT INTO `smart_scripts`(`entryorguid`,`id`,`link`,`event_type`,`event_param1`,`event_param2`,`action_type`,`action_param1`,`target_type`,`comment`) VALUES +(14450,1,2,62,5849,1,11,23124,7,'Orphan Matron Nightingale - On gossip select - Create human orphan whistle'), +(14450,2,0,61,0,0,72,0,7,'Orphan Matron Nightingale - On gossip select - Close gossip'); + +DELETE FROM `gossip_menu_option` WHERE `menu_id`=5849; +INSERT INTO `gossip_menu_option`(`menu_id`,`id`,`option_icon`,`option_text`,`option_id`,`npc_option_npcflag`) VALUES +(5849,1,0,'I need a new Human Orphan Whistle.',1,1); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=5849; +INSERT INTO `conditions`(`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`NegativeCondition`,`Comment`) VALUES +(15,5849,1,0,12,10,0,0,'Childrens Week must be active'), +(15,5849,1,0,8,1468,0,0,'Quest 1468 must be rewarded'), +(15,5849,1,0,2,18598,1,1,'Must not have item 18598'); + +-- Oracle Orphan +SET @TEXT_ORACLE_ORPHAN_1 = 1; +SET @TEXT_ORACLE_ORPHAN_2 = 2; +SET @TEXT_ORACLE_ORPHAN_3 = 3; +SET @TEXT_ORACLE_ORPHAN_4 = 4; +SET @TEXT_ORACLE_ORPHAN_5 = 5; +SET @TEXT_ORACLE_ORPHAN_6 = 6; +SET @TEXT_ORACLE_ORPHAN_7 = 7; +SET @TEXT_ORACLE_ORPHAN_8 = 8; +SET @TEXT_ORACLE_ORPHAN_9 = 9; +SET @TEXT_ORACLE_ORPHAN_10 = 10; +SET @TEXT_ORACLE_ORPHAN_11 = 11; +SET @TEXT_ORACLE_ORPHAN_12 = 12; +SET @TEXT_ORACLE_ORPHAN_13 = 13; +SET @TEXT_ORACLE_ORPHAN_14 = 14; + +UPDATE `creature_template` SET `AIName`='SmartAI',`ScriptName`='' WHERE `entry`=33533; + +DELETE FROM `smart_scripts` WHERE `entryorguid`=33533 AND `source_type`=0; +INSERT INTO `smart_scripts`(`entryorguid`,`event_type`,`event_param1`,`action_type`,`action_param1`,`target_type`,`comment`) VALUES +(33533,8,65357,33,36209,7,'Oracle Orphan - On spellhit - Give quest credit'); + +DELETE FROM `creature_text` WHERE `entry`=33533; +INSERT INTO `creature_text`(`entry`,`groupid`,`text`,`type`,`emote`) VALUE +(33533,@TEXT_ORACLE_ORPHAN_1,"Look!",12,0), +(33533,@TEXT_ORACLE_ORPHAN_2,"We can dance too!",12,0), +(33533,@TEXT_ORACLE_ORPHAN_3,"We made a new friend!",12,0), +(33533,@TEXT_ORACLE_ORPHAN_4,"We here! Only, if this is world tree, how come it broke when they tried to put whole world in?",12,0), +(33533,@TEXT_ORACLE_ORPHAN_5,"Look! Is that us? We think it's us. A bit older, maybe?",12,0), +(33533,@TEXT_ORACLE_ORPHAN_6,"Looks like we blessed by Great Ones! Shrines give magic, make us high-oracle someday? Maybe?",12,0), +(33533,@TEXT_ORACLE_ORPHAN_7,"Wow! A real Great One? We don't even think Soo-say has met a real Great One!",12,0), +(33533,@TEXT_ORACLE_ORPHAN_8,"Um, hello, Mr. Great One. We are honored to meet you.",12,0), +(33533,@TEXT_ORACLE_ORPHAN_9,"Maybe you're asleep, Mr. Great One? We stand. Must be hard working being Great One, collecting all the shinies we leave for you.",12,0), +(33533,@TEXT_ORACLE_ORPHAN_10,"We brought you a gift, Great One. Maybe you see it when you wake up. Maybe you remember we came to see you, oki?",12,0), +(33533,@TEXT_ORACLE_ORPHAN_11,"So that's the queen of the dragons? Hmm... we thought she'd be bigger. Yes, we did.",12,0), +(33533,@TEXT_ORACLE_ORPHAN_12,"How come she doesn't look like the other dragons? could she turn into a big ol' dragon if she wanted to?",12,0), +(33533,@TEXT_ORACLE_ORPHAN_13,"Um... Your Majesty, would you turn into a dragon for us?",12,0), +(33533,@TEXT_ORACLE_ORPHAN_14,"Oki... How about now?",12,0); + +DELETE FROM `creature_questrelation` WHERE `id`=33533; + +DELETE FROM `game_event_creature_quest` WHERE `id`=33533; +INSERT INTO `game_event_creature_quest`(`eventEntry`,`id`,`quest`) VALUES +(10,33533,13929), +(10,33533,13933), +(10,33533,13950), +(10,33533,13954), +(10,33533,13956), +(10,33533,13937), +(10,33533,13959); + +DELETE FROM `creature_involvedrelation` WHERE `id`=33533; +INSERT INTO `creature_involvedrelation`(`id`,`quest`) VALUES +(33533,13929), +(33533,13933), +(33533,13950), +(33533,13954), +(33533,13956), +(33533,13937), +(33533,13926); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (19,20) AND `SourceEntry` IN (13954,13956,13937); +INSERT INTO `conditions`(`SourceTypeOrReferenceId`,`SourceEntry`,`ConditionTypeOrReference`,`ConditionValue1`,`comment`) VALUES +(19,13954,8,13929,'Accept quest 13954 - Quest 13929 needs to be rewarded'), +(19,13954,8,13933,'Accept quest 13954 - Quest 13933 needs to be rewarded'), +(19,13954,8,13950,'Accept quest 13954 - Quest 13950 needs to be rewarded'), +(19,13956,8,13929,'Accept quest 13956 - Quest 13929 needs to be rewarded'), +(19,13956,8,13933,'Accept quest 13956 - Quest 13933 needs to be rewarded'), +(19,13956,8,13950,'Accept quest 13956 - Quest 13950 needs to be rewarded'), +(19,13937,8,13956,'Accept quest 13937 - Quest 13956 needs to be rewarded'), +(20,13954,8,13929,'Show quest mark 13954 - Quest 13929 needs to be rewarded'), +(20,13954,8,13933,'Show quest mark 13954 - Quest 13933 needs to be rewarded'), +(20,13954,8,13950,'Show quest mark 13954 - Quest 13950 needs to be rewarded'), +(20,13956,8,13929,'Show quest mark 13956 - Quest 13929 needs to be rewarded'), +(20,13956,8,13933,'Show quest mark 13956 - Quest 13933 needs to be rewarded'), +(20,13956,8,13950,'Show quest mark 13956 - Quest 13950 needs to be rewarded'), +(20,13937,8,13956,'Show quest mark 13937 - Quest 13956 needs to be rewarded'); + +-- Wolvar Orphan +SET @TEXT_WOLVAR_ORPHAN_1 = 1; +SET @TEXT_WOLVAR_ORPHAN_2 = 2; +SET @TEXT_WOLVAR_ORPHAN_3 = 3; +SET @TEXT_WOLVAR_ORPHAN_4 = 4; +SET @TEXT_WOLVAR_ORPHAN_5 = 5; +SET @TEXT_WOLVAR_ORPHAN_6 = 6; +SET @TEXT_WOLVAR_ORPHAN_7 = 7; +SET @TEXT_WOLVAR_ORPHAN_8 = 8; +SET @TEXT_WOLVAR_ORPHAN_9 = 9; +SET @TEXT_WOLVAR_ORPHAN_10 = 10; +SET @TEXT_WOLVAR_ORPHAN_11 = 11; +SET @TEXT_WOLVAR_ORPHAN_12 = 12; +SET @TEXT_WOLVAR_ORPHAN_13 = 13; + +UPDATE `creature_template` SET `AIName`='SmartAI',`ScriptName`='' WHERE `entry`=33532; + +DELETE FROM `smart_scripts` WHERE `entryorguid`=33532 AND `source_type`=0; +INSERT INTO `smart_scripts`(`entryorguid`,`event_type`,`event_param1`,`action_type`,`action_param1`,`target_type`,`comment`) VALUES +(33532,8,65357,33,36209,7,'Wolvar Orphan - On spellhit - Give quest credit'); + +DELETE FROM `creature_text` WHERE `entry`=33532; +INSERT INTO `creature_text`(`entry`,`groupid`,`text`,`type`,`emote`) VALUE +(33532,@TEXT_WOLVAR_ORPHAN_1,"Look!",12,0), +(33532,@TEXT_WOLVAR_ORPHAN_2,"Got you back!",12,0), +(33532,@TEXT_WOLVAR_ORPHAN_3,"Good snowball fight!",12,0), +(33532,@TEXT_WOLVAR_ORPHAN_4,"Look! That must be Kekek as a mighty warrior! See? What Kekek tell you?",12,0), +(33532,@TEXT_WOLVAR_ORPHAN_5,"Hmm... that Kekek very old. Must be elder, leader of Frenzyheart. This good. Kekek have good future as warrior and leader. Kekek very happy you bring him here. Orphan-lady never do that for Kekek.",12,0), +(33532,@TEXT_WOLVAR_ORPHAN_6,"Wow. At last, Kekek get to meet Hemet Nesingwary!",12,0), +(33532,@TEXT_WOLVAR_ORPHAN_7,"Even Frenzyheart know all about you after you come to Sholazar. Maybe you teach Kekek your tricks?",12,0), +(33532,@TEXT_WOLVAR_ORPHAN_8,"Not sure how reading helps. Kekek can't read anyway, but if Hemet Nesingwary say, Kekek try.",12,0), +(33532,@TEXT_WOLVAR_ORPHAN_9,"Maybe give up and throw book at animals, but try.",12,0), +(33532,@TEXT_WOLVAR_ORPHAN_10,"You think maybe one day, Kekek lead Frenzyheart home, like bear-men fight to get tree-city back? Kekek want own home, not city with purple men, not jungle with big-tongues.",12,0), +(33532,@TEXT_WOLVAR_ORPHAN_11,"Kekek thought we go see dragon queen. This just some elf-lady with funny horns.",12,0), +(33532,@TEXT_WOLVAR_ORPHAN_12,"But why? Dragons big and powerful. Elf-lady weak. Kekek want to see dragon queen's real form.",12,0), +(33532,@TEXT_WOLVAR_ORPHAN_13,"Oh! Now Kekek understand. Not want to be crushed by big dragon-lady. Maybe come back sometime when not so crowded. Nice to meet you, dragon-lady.",12,0); + +DELETE FROM `game_event_creature_quest` WHERE `id`=33532; +INSERT INTO `game_event_creature_quest`(`eventEntry`,`id`,`quest`) VALUES +(10,33532,13938), +(10,33532,13960), +(10,33532,13930), +(10,33532,13951), +(10,33532,13934), +(10,33532,13955), +(10,33532,13957); + +DELETE FROM `creature_involvedrelation` WHERE `id`=33532; +INSERT INTO `creature_involvedrelation`(`id`,`quest`) VALUES +(33532,13938), +(33532,13930), +(33532,13927), +(33532,13951), +(33532,13934), +(33532,13955), +(33532,13957); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (19,20) AND `SourceEntry` IN (13955,13957,13938); +INSERT INTO `conditions`(`SourceTypeOrReferenceId`,`SourceEntry`,`ConditionTypeOrReference`,`ConditionValue1`,`comment`) VALUES +(19,13955,8,13930,'Accept quest 13955 - Quest 13930 needs to be rewarded'), +(19,13955,8,13934,'Accept quest 13955 - Quest 13934 needs to be rewarded'), +(19,13955,8,13951,'Accept quest 13955 - Quest 13951 needs to be rewarded'), +(19,13957,8,13930,'Accept quest 13957 - Quest 13930 needs to be rewarded'), +(19,13957,8,13934,'Accept quest 13957 - Quest 13934 needs to be rewarded'), +(19,13957,8,13951,'Accept quest 13957 - Quest 13951 needs to be rewarded'), +(19,13938,8,13957,'Accept quest 13938 - Quest 13957 needs to be rewarded'), +(20,13955,8,13930,'Show quest mark 13955 - Quest 13930 needs to be rewarded'), +(20,13955,8,13934,'Show quest mark 13955 - Quest 13934 needs to be rewarded'), +(20,13955,8,13951,'Show quest mark 13955 - Quest 13951 needs to be rewarded'), +(20,13957,8,13930,'Show quest mark 13957 - Quest 13930 needs to be rewarded'), +(20,13957,8,13934,'Show quest mark 13957 - Quest 13934 needs to be rewarded'), +(20,13957,8,13951,'Show quest mark 13957 - Quest 13951 needs to be rewarded'), +(20,13938,8,13957,'Show quest mark 13938 - Quest 13957 needs to be rewarded'); + +-- Blood Elf Orphan +UPDATE `quest_template` SET `SpecialFlags`=`SpecialFlags`|2 WHERE `Id` IN (10945,10953,10951,10963); + +DELETE FROM `game_event_creature_quest` WHERE `id`=22817; +INSERT INTO `game_event_creature_quest`(`eventEntry`,`id`,`quest`) VALUES +(10,22817,10945), +(10,22817,10953), +(10,22817,10951), +(10,22817,10963), +(10,22817,11975), +(10,22817,10967); + +DELETE FROM `creature_involvedrelation` WHERE `id`=22817; +INSERT INTO `creature_involvedrelation`(`id`,`quest`) VALUES +(22817,10942), +(22817,10951), +(22817,11975), +(22817,10963); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (19,20) AND `SourceEntry` IN (11975,10963,10967); +INSERT INTO `conditions`(`SourceTypeOrReferenceId`,`SourceEntry`,`ConditionTypeOrReference`,`ConditionValue1`,`comment`) VALUES +(19,11975,8,10945,'Accept quest 11975 - Quest 10945 needs to be rewarded'), +(19,11975,8,10953,'Accept quest 11975 - Quest 10953 needs to be rewarded'), +(19,11975,8,10951,'Accept quest 11975 - Quest 10951 needs to be rewarded'), +(19,10963,8,10945,'Accept quest 10963 - Quest 10945 needs to be rewarded'), +(19,10963,8,10953,'Accept quest 10963 - Quest 10953 needs to be rewarded'), +(19,10963,8,10951,'Accept quest 10963 - Quest 10951 needs to be rewarded'), +(19,10967,8,10963,'Accept quest 10967 - Quest 10963 needs to be rewarded'), +(20,11975,8,10945,'Show quest mark 11975 - Quest 10945 needs to be rewarded'), +(20,11975,8,10953,'Show quest mark 11975 - Quest 10953 needs to be rewarded'), +(20,11975,8,10951,'Show quest mark 11975 - Quest 10951 needs to be rewarded'), +(20,10963,8,10945,'Show quest mark 10963 - Quest 10945 needs to be rewarded'), +(20,10963,8,10953,'Show quest mark 10963 - Quest 10953 needs to be rewarded'), +(20,10963,8,10951,'Show quest mark 10963 - Quest 10951 needs to be rewarded'), +(20,10967,8,10963,'Show quest mark 10967 - Quest 10963 needs to be rewarded'); + +-- Draenei Orphan +UPDATE `quest_template` SET `SpecialFlags`=`SpecialFlags`|2 WHERE `Id` IN (10956,10968,10950,10952,10954,10962); + +DELETE FROM `game_event_creature_quest` WHERE `id`=22818; +INSERT INTO `game_event_creature_quest`(`eventEntry`,`id`,`quest`) VALUES +(10,22818,10952), +(10,22818,10950), +(10,22818,10966), +(10,22818,10954), +(10,22818,10956), +(10,22818,10962); + +DELETE FROM `creature_involvedrelation` WHERE `id`=22818; +INSERT INTO `creature_involvedrelation`(`id`,`quest`) VALUES +(22818,10950), +(22818,10952), +(22818,10943), +(22818,10962); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (19,20) AND `SourceEntry` IN (10956,10962,10966); +INSERT INTO `conditions`(`SourceTypeOrReferenceId`,`SourceEntry`,`ConditionTypeOrReference`,`ConditionValue1`,`comment`) VALUES +(19,10956,8,10950,'Accept quest 10956 - Quest 10950 needs to be rewarded'), +(19,10956,8,10954,'Accept quest 10956 - Quest 10954 needs to be rewarded'), +(19,10956,8,10952,'Accept quest 10956 - Quest 10952 needs to be rewarded'), +(19,10962,8,10950,'Accept quest 10962 - Quest 10950 needs to be rewarded'), +(19,10962,8,10954,'Accept quest 10962 - Quest 10954 needs to be rewarded'), +(19,10962,8,10952,'Accept quest 10962 - Quest 10952 needs to be rewarded'), +(19,10966,8,10962,'Accept quest 10966 - Quest 10962 needs to be rewarded'), +(20,10956,8,10950,'Show quest mark 10956 - Quest 10950 needs to be rewarded'), +(20,10956,8,10954,'Show quest mark 10956 - Quest 10954 needs to be rewarded'), +(20,10956,8,10952,'Show quest mark 10956 - Quest 10952 needs to be rewarded'), +(20,10962,8,10950,'Show quest mark 10962 - Quest 10950 needs to be rewarded'), +(20,10962,8,10954,'Show quest mark 10962 - Quest 10954 needs to be rewarded'), +(20,10962,8,10952,'Show quest mark 10962 - Quest 10952 needs to be rewarded'), +(20,10966,8,10962,'Show quest mark 10966 - Quest 10962 needs to be rewarded'); + +-- Human Orphan +DELETE FROM `creature_questrelation` WHERE `id`=14305; + +DELETE FROM `game_event_creature_quest` WHERE `id`=14305; +INSERT INTO `game_event_creature_quest`(`eventEntry`,`id`,`quest`) VALUES +(10,14305,171), +(10,14305,558), +(10,14305,1687), +(10,14305,1479), +(10,14305,1558), +(10,14305,4822); + +DELETE FROM `creature_involvedrelation` WHERE `id`=14305; +INSERT INTO `creature_involvedrelation`(`id`,`quest`) VALUES +(14305,1468), +(14305,558), +(14305,1687), +(14305,1479), +(14305,1558), +(14305,4822); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (19,20) AND `SourceEntry` IN (558,4822,171); +INSERT INTO `conditions`(`SourceTypeOrReferenceId`,`SourceEntry`,`ConditionTypeOrReference`,`ConditionValue1`,`comment`) VALUES +(19,558,8,1687,'Accept quest 558 - Quest 1687 needs to be rewarded'), +(19,558,8,1558,'Accept quest 558 - Quest 1558 needs to be rewarded'), +(19,558,8,1479,'Accept quest 558 - Quest 1479 needs to be rewarded'), +(19,558,16,1101,'Accept quest 558 - Needs to be in race mask 1101'), +(19,4822,8,1687,'Accept quest 4822 - Quest 1687 needs to be rewarded'), +(19,4822,8,1558,'Accept quest 4822 - Quest 1558 needs to be rewarded'), +(19,4822,8,1479,'Accept quest 4822 - Quest 1479 needs to be rewarded'), +(19,171,8,4822,'Accept quest 171 - Quest 4822 needs to be rewarded'), +(20,558,8,1687,'Show quest mark 558 - Quest 1687 needs to be rewarded'), +(20,558,8,1558,'Show quest mark 558 - Quest 1558 needs to be rewarded'), +(20,558,8,1479,'Show quest mark 558 - Quest 1479 needs to be rewarded'), +(20,558,16,1101,'Show quest mark 558 - Needs to be in race mask 1101'), +(20,4822,8,1687,'Show quest mark 4822 - Quest 1687 needs to be rewarded'), +(20,4822,8,1558,'Show quest mark 4822 - Quest 1558 needs to be rewarded'), +(20,4822,8,1479,'Show quest mark 4822 - Quest 1479 needs to be rewarded'), +(20,171,8,4822,'Show quest mark 171 - Quest 4822 needs to be rewarded'); + +-- Orcish Orphan +DELETE FROM `creature_questrelation` WHERE `id`=14444; + +DELETE FROM `game_event_creature_quest` WHERE `id`=14444; +INSERT INTO `game_event_creature_quest`(`eventEntry`,`id`,`quest`) VALUES +(10,14444,910), +(10,14444,911), +(10,14444,1800), +(10,14444,925), +(10,14444,915), +(10,14444,5502); + +DELETE FROM `creature_involvedrelation` WHERE `id`=14444; +INSERT INTO `creature_involvedrelation`(`id`,`quest`) VALUES +(14444,925), +(14444,172), +(14444,910), +(14444,911), +(14444,1800), +(14444,915); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (19,20) AND `SourceEntry` IN (915,925,5502); +INSERT INTO `conditions`(`SourceTypeOrReferenceId`,`SourceEntry`,`ConditionTypeOrReference`,`ConditionValue1`,`comment`) VALUES +(19,925,8,910,'Accept quest 925 - Quest 910 needs to be rewarded'), +(19,925,8,911,'Accept quest 925 - Quest 911 needs to be rewarded'), +(19,925,8,1800,'Accept quest 925 - Quest 1800 needs to be rewarded'), +(19,915,8,910,'Accept quest 915 - Quest 910 needs to be rewarded'), +(19,915,8,911,'Accept quest 915 - Quest 911 needs to be rewarded'), +(19,915,8,1800,'Accept quest 915 - Quest 1800 needs to be rewarded'), +(19,5502,8,925,'Accept quest 5502 - Quest 925 needs to be rewarded'), +(20,925,8,910,'Show quest mark 925 - Quest 910 needs to be rewarded'), +(20,925,8,911,'Show quest mark 925 - Quest 911 needs to be rewarded'), +(20,925,8,1800,'Show quest mark 925 - Quest 1800 needs to be rewarded'), +(20,915,8,910,'Show quest mark 915 - Quest 910 needs to be rewarded'), +(20,915,8,911,'Show quest mark 915 - Quest 911 needs to be rewarded'), +(20,915,8,1800,'Show quest mark 915 - Quest 1800 needs to be rewarded'), +(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; + +UPDATE `creature_template` SET `AIName`='',`ScriptName`='npc_grizzlemaw_cw_trigger',`flags_extra`=0 WHERE `entry`=36209; + +DELETE FROM `creature` WHERE `guid` IN (@GUID_GRIZZLEMAW_TRIGGER_1,@GUID_GRIZZLEMAW_TRIGGER_2,@GUID_GRIZZLEMAW_TRIGGER_3); +INSERT INTO `creature`(`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`) VALUES +(@GUID_GRIZZLEMAW_TRIGGER_1,36209,571,4068.82,-3811,223.4), +(@GUID_GRIZZLEMAW_TRIGGER_2,36209,571,4073.2,-3734.354,222.6634), +(@GUID_GRIZZLEMAW_TRIGGER_3,36209,571,3923.109,-3763.967,165.362); + +-- Elder Kekek +SET @GUID_KEKEK = 3019845; +SET @TEXT_ELDER_KEKEK_1 = 1; + +UPDATE `creature_template` SET `ScriptName`='npc_elder_kekek' WHERE `entry`=34387; + +DELETE FROM `creature` WHERE `guid`=@GUID_KEKEK OR `id`=34387; +INSERT INTO `creature`(`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`) VALUES +(@GUID_KEKEK,34387,571,4181.482,-461.453,120.728,1.398097); + +DELETE FROM `creature_text` WHERE `entry`=34387; +INSERT INTO `creature_text`(`entry`,`groupid`,`text`,`type`,`emote`) VALUE +(34387,@TEXT_ELDER_KEKEK_1,"No worry, Kekek. You grow up, be strong for Frenzyheart. You lead people back to old home, where there no big-tongue babies.",12,0); + +-- Alexstraza +SET @TEXT_ALEXSTRASZA_2 = 2; +SET @TEXT_KRASUS_8 = 8; + +UPDATE `creature_template` SET `AIName`='',`ScriptName`='npc_alexstraza_the_lifebinder' WHERE `entry`=26917; + +DELETE FROM `creature_text` WHERE (`entry`=26917 AND `groupid`=@TEXT_ALEXSTRASZA_2) OR (`entry`=27990 AND `groupid`=@TEXT_KRASUS_8); +INSERT INTO `creature_text`(`entry`,`groupid`,`text`,`type`,`emote`) VALUE +(26917,@TEXT_ALEXSTRASZA_2,"If I was in my dragon form, there wouldn't be any room for anyone else, little one.",12,0), +(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 @TEXT_SOO_ROO_1 = 1; + +UPDATE `creature_template` SET `AIName`='',`ScriptName`='npc_high_oracle_soo_roo' WHERE `entry`=34386; + +DELETE FROM `creature_text` WHERE `entry`=34386; +INSERT INTO `creature_text`(`entry`,`groupid`,`text`,`type`,`emote`) VALUE +(34386,@TEXT_SOO_ROO_1,"We remember this visit, yes we do. Never forget what you learn from your new friend, little Roo. You got great future ahead.",12,0); + +DELETE FROM `creature` WHERE `guid`=@GUID_SOO_ROO OR `id`=34386; +INSERT INTO `creature`(`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`) VALUES +(@GUID_SOO_ROO,34386,571,4120.996,-329.486,121.443817,0.299253); + +-- Nesingwary +SET @TEXT_NESINGWARY_1 = 1; + +DELETE FROM `creature_text` WHERE `entry`=27986; +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 @TEXT_SNOWFALL_GLADE_PLAYMATE_1 = 1; +SET @TEXT_SNOWFALL_GLADE_PLAYMATE_2 = 2; + +UPDATE `creature_template` SET `AIName`='',`ScriptName`='npc_snowfall_glade_playmate' WHERE `entry`=34490; + +DELETE FROM `creature_text` WHERE `entry`=34490; +INSERT INTO `creature_text`(`entry`,`groupid`,`text`,`type`,`emote`) VALUE +(34490,@TEXT_SNOWFALL_GLADE_PLAYMATE_1,"Better watch out!",12,0), +(34490,@TEXT_SNOWFALL_GLADE_PLAYMATE_2,"Got you good!",12,0); + +DELETE FROM `creature` WHERE `guid`=@GUID_SNOWFALL_GLADE_PLAYMATE OR `id`=34490; +INSERT INTO `creature`(`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`) VALUES +(@GUID_SNOWFALL_GLADE_PLAYMATE,34490,571,3325.193,1026.451,138.1712,2.062184); + +-- Winterfin Playmate +SET @GUID_WINTERFIN_PLAYMATE = 3019823; +SET @TEXT_WINTERFIN_PLAYMATE_1 = 1; +SET @TEXT_WINTERFIN_PLAYMATE_2 = 2; + +UPDATE `creature_template` SET `AIName`='',`ScriptName`='npc_winterfin_playmate' WHERE `entry`=34489; + +DELETE FROM `creature_text` WHERE `entry`=34489; +INSERT INTO `creature_text`(`entry`,`groupid`,`text`,`type`,`emote`) VALUE +(34489,@TEXT_WINTERFIN_PLAYMATE_1,"Wanna see what I can do?",12,0), +(34489,@TEXT_WINTERFIN_PLAYMATE_2,"Now dance together!",12,0); + +DELETE FROM `creature` WHERE `guid`=@GUID_WINTERFIN_PLAYMATE OR `id`=34489; +INSERT INTO `creature`(`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`) VALUES +(@GUID_WINTERFIN_PLAYMATE,34489,571,4382.502,6066.199,0.724562,3.571894); + +-- Biggest Tree Ever +SET @GUID_BIGGEST_TREE_TRIGGER = 3019825; + +UPDATE `creature_template` SET `AIName`='',`ScriptName`='npc_the_biggest_tree',`flags_extra`=0 WHERE `entry`=34381; + +DELETE FROM `creature` WHERE `guid`=@GUID_BIGGEST_TREE_TRIGGER OR `id`=34381; +INSERT INTO `creature`(`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`) VALUES +(@GUID_BIGGEST_TREE_TRIGGER,34381,571,4022.666,-3777.682,115.443588,4.857019); + +-- Meeting A Great One +UPDATE `creature_template` SET `ScriptName`='npc_the_etymidian' WHERE `entry`=28092; + +-- POIs +DELETE FROM `quest_poi` WHERE `questId` IN (13956,13929,13950,13951,13957,13933,13934,13930,13954,13955); +INSERT INTO `quest_poi`(`questId`,`objIndex`,`mapid`,`WorldMapAreaId`,`unk4`) VALUES +(13956,16,1,201,3), +(13929,16,571,490,3), +(13950,16,571,486,3), +(13951,16,571,488,3), +(13957,16,571,493,3), +(13933,16,571,488,3), +(13934,16,571,488,3), +(13930,16,571,490,3), +(13954,16,571,488,3), +(13955,16,571,488,3); + +DELETE FROM `quest_poi_points` WHERE `questid` IN (13956,13929,13950,13951,13957,13933,13934,13930,13954,13955); +INSERT INTO `quest_poi_points`(`questId`,`x`,`y`) VALUES +(13956,-6193,-1223), +(13929,4022,-3777), +(13950,4382,6066), +(13951,3325,1026), +(13957,5584,5748), +(13933,4121,-329), +(13934,4181,-461), +(13930,4071,-3773), +(13954,3530,271), +(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; + +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); + +DELETE FROM `creature` WHERE `guid` IN (@GUID_SILVERMOON_TRIGGER_01,@GUID_AERIS_LANDING_TRIGGER,@GUID_AUCHINDOUN_TRIGGER,@GUID_SPOREGGAR_TRIGGER,@GUID_THRONE_OF_ELEMENTS_TRIGGER); +INSERT INTO `creature`(`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`) VALUES +(@GUID_AERIS_LANDING_TRIGGER,22838,530,-2075.759,8559.336,23.027,4.857019), +(@GUID_SILVERMOON_TRIGGER_01,22866,530,9506.086,-7329.313,14.397272,0), +(@GUID_AUCHINDOUN_TRIGGER,22831,530,-3320.860,4925.095,-101.1,0), +(@GUID_SPOREGGAR_TRIGGER,22829,530,203.587,8550.11,22.3256,0), +(@GUID_THRONE_OF_ELEMENTS_TRIGGER,22839,530,-781.294,6943.52,33.3344,0); + +-- Misc +DELETE `game_event_creature` FROM `game_event_creature` INNER JOIN `creature` ON `creature`.`guid`=`game_event_creature`.`guid` +WHERE `id` IN (22905,22851,22838,22866,22831,22829,22872,22839,14450,22819,14451,34365,34387,34386,34490,34489,34381,36209); +INSERT INTO `game_event_creature`(`eventEntry`,`guid`) SELECT 10,`guid` FROM `creature` +WHERE `id` IN (22905,22851,22838,22866,22831,22829,22872,22839,14450,22819,14451,34365,34387,34386,34490,34489,34381,36209); + +DELETE FROM `game_event_npc_vendor` WHERE `eventEntry`=10 AND `item`=46693; +INSERT INTO `game_event_npc_vendor` (`eventEntry`, `guid`, `item`) VALUES +(10,99369,46693), +(10,97984,46693); + +UPDATE `item_template` SET `minMoneyLoot`=50000,`maxMoneyLoot`=50000 WHERE `entry`=23022; +UPDATE `item_template` SET `HolidayId`=201 WHERE `entry` IN (46396,46397,31880,31881,18598,18597); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=17 AND `SourceEntry` IN (23012,23013,39478,39479,65352,65353); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ErrorTextId`,`Comment`) VALUES +(17,0,23012,0,12,10,0,"Orphan Whistle only while children's week"), +(17,0,23013,0,12,10,0,"Orphan Whistle only while children's week"), +(17,0,39478,0,12,10,0,"Orphan Whistle only while children's week"), +(17,0,39479,0,12,10,0,"Orphan Whistle only while children's week"), +(17,0,65352,0,12,10,0,"Orphan Whistle only while children's week"), +(17,0,65353,0,12,10,0,"Orphan Whistle only while children's week"); + +UPDATE `quest_poi_points` SET `x`=1642,`y`=239 WHERE `questId`=1800 AND `id`=0 AND `idx`=0; +UPDATE `quest_poi_points` SET `x`=-248,`y`=956 WHERE `questId`=10952 AND `id`=0 AND `idx`=0; +UPDATE `quest_poi_points` SET `x`=-11400.211,`y`=1944.599 WHERE `questId`=1687 AND `id`=0 AND `idx`=0; +UPDATE `quest_poi_points` SET `x`=-998.183,`y`=-3822.07 WHERE `questId`=910 AND `id`=0 AND `idx`=0; +UPDATE `quest_poi_points` SET `x`=1260.812,`y`=-2223.765 WHERE `questId`=911 AND `id`=0 AND `idx`=0; +UPDATE `quest_poi_points` SET `x`=9933,`y`=2500 WHERE `questId`=1479 AND `id`=0 AND `idx`=0; +UPDATE `quest_poi_points` SET `x`=-2075.759,`y`=8559.336 WHERE `questId`=10954 AND `id`=0 AND `idx`=0; +UPDATE `quest_poi_points` SET `x`=9506,`y`=-7329 WHERE `questId`=11975 AND `id`=0 AND `idx`=0; +UPDATE `quest_poi_points` SET `x`=-3320.860,`y`=4925.095 WHERE `questId`=10950 AND `id`=0 AND `idx`=0; +UPDATE `quest_poi_points` SET `x`=203.587,`y`=8550.11 WHERE `questId`=10945 AND `id`=0 AND `idx`=0; +UPDATE `quest_poi_points` SET `x`=-781.294,`y`=6943.52 WHERE `questId`=10953 AND `id`=0 AND `idx`=0; -- cgit v1.2.3 From 0a840fcb21cc0ac94004af4843f97557b5fd80e2 Mon Sep 17 00:00:00 2001 From: w1sht0l1v3 Date: Wed, 24 Oct 2012 17:36:19 +0300 Subject: SQL: Typo fixes. --- sql/updates/world/2012_10_20_01_world_spell_script_names.sql | 2 +- sql/updates/world/2012_10_21_00_world_conditions.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) (limited to 'sql') diff --git a/sql/updates/world/2012_10_20_01_world_spell_script_names.sql b/sql/updates/world/2012_10_20_01_world_spell_script_names.sql index d0eefb17943..814f1b40e65 100644 --- a/sql/updates/world/2012_10_20_01_world_spell_script_names.sql +++ b/sql/updates/world/2012_10_20_01_world_spell_script_names.sql @@ -1,4 +1,4 @@ --- Spellscript and conditions for spells of quest Gordunni Cobalt +-- Spellscript and conditions for spells of quest Gordunni Cobalt DELETE FROM `spell_script_names` WHERE `spell_id`=19395; INSERT INTO `spell_script_names`(`spell_id`,`ScriptName`) VALUES (19395,'spell_gordunni_trap'); diff --git a/sql/updates/world/2012_10_21_00_world_conditions.sql b/sql/updates/world/2012_10_21_00_world_conditions.sql index 35b44fec196..62161a932f9 100644 --- a/sql/updates/world/2012_10_21_00_world_conditions.sql +++ b/sql/updates/world/2012_10_21_00_world_conditions.sql @@ -1 +1 @@ -ALTER TABLE `conditions` CHANGE COLUMN `SourceEntry` `SourceEntry` MEDIUMINT(8) NOT NULL DEFAULT 0 +ALTER TABLE `conditions` CHANGE COLUMN `SourceEntry` `SourceEntry` MEDIUMINT(8) NOT NULL DEFAULT 0; -- cgit v1.2.3 From 9084c89ea84a67065cd3f062d3ea606f3c1137e2 Mon Sep 17 00:00:00 2001 From: Subv Date: Thu, 25 Oct 2012 10:11:56 -0500 Subject: Core/SQL: Renamed file from previous merge. Corrected the guids. --- .../world/2012_10_20_00_world_childrens_week.sql | 573 -------------------- .../world/2012_10_25_00_world_childrens_week.sql | 574 +++++++++++++++++++++ 2 files changed, 574 insertions(+), 573 deletions(-) delete mode 100644 sql/updates/world/2012_10_20_00_world_childrens_week.sql create mode 100644 sql/updates/world/2012_10_25_00_world_childrens_week.sql (limited to 'sql') diff --git a/sql/updates/world/2012_10_20_00_world_childrens_week.sql b/sql/updates/world/2012_10_20_00_world_childrens_week.sql deleted file mode 100644 index 55c874036c5..00000000000 --- a/sql/updates/world/2012_10_20_00_world_childrens_week.sql +++ /dev/null @@ -1,573 +0,0 @@ --- Orphan Matron Aria -UPDATE `creature_template` SET `AIName`='SmartAI',`ScriptName`='' WHERE `entry`=34365; - -DELETE FROM `smart_scripts` WHERE `entryorguid`=34365 AND `source_type`=0; -INSERT INTO `smart_scripts`(`entryorguid`,`id`,`link`,`event_type`,`event_param1`,`event_param2`,`action_type`,`action_param1`,`target_type`,`comment`) VALUES -(34365,1,4,62,10502,1,33,34365,7,'Orphan Matron Aria - On gossip select - Give quest credit'), -(34365,2,4,62,10502,2,11,65359,7,'Orphan Matron Aria - On gossip select - Create oracle orphan whistle'), -(34365,3,4,62,10502,3,11,65360,7,'Orphan Matron Aria - On gossip select - Create wolvar orphan whistle'), -(34365,4,0,61,0,0,72,0,7,'Orphan Matron Aria - On gossip select - Close gossip'); - -DELETE FROM `gossip_menu_option` WHERE `menu_id`=10502; -INSERT INTO `gossip_menu_option`(`menu_id`,`id`,`option_icon`,`option_text`,`option_id`,`npc_option_npcflag`) VALUES -(10502,1,0,'Tell me about the orphans.',1,1), -(10502,2,0,'I need a new Oracle Orphan Whistle.',1,1), -(10502,3,0,'I need a new Wolvar Orphan Whistle.',1,1); - -DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=10502; -INSERT INTO `conditions`(`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`NegativeCondition`,`Comment`) VALUES -(15,10502,1,1,12,10,0,0,'Childrens Week must be active'), -(15,10502,1,1,1,58818,0,0,'Needs aura 58818'), -(15,10502,1,1,9,13927,0,0,'Quest 13927 must be active'), -(15,10502,1,2,12,10,0,0,'Childrens Week must be active'), -(15,10502,1,2,1,58818,0,0,'Needs aura 58818'), -(15,10502,1,2,9,13926,0,0,'Quest 13926 must be active'), -(15,10502,2,0,12,10,0,0,'Childrens Week must be active'), -(15,10502,2,0,8,13926,0,0,'Quest 13926 must be rewarded'), -(15,10502,2,0,2,46397,1,1,'Must not have item 46397'), -(15,10502,3,0,12,10,0,0,'Childrens Week must be active'), -(15,10502,3,0,8,13927,0,0,'Quest 13926 must be rewarded'), -(15,10502,3,0,2,46396,1,1,'Must not have item 46397'); - --- Orphan Matron Battlewail -UPDATE `creature_template` SET `AIName`='SmartAI',`ScriptName`='' WHERE `entry`=14451; - -DELETE FROM `smart_scripts` WHERE `entryorguid`=14451 AND `source_type`=0; -INSERT INTO `smart_scripts`(`entryorguid`,`id`,`link`,`event_type`,`event_param1`,`event_param2`,`action_type`,`action_param1`,`target_type`,`comment`) VALUES -(14451,1,2,62,5848,1,11,23125,7,'Orphan Matron Battlewail - On gossip select - Create orc orphan whistle'), -(14451,2,0,61,0,0,72,0,7,'Orphan Matron Battlewail - On gossip select - Close gossip'); - -DELETE FROM `gossip_menu_option` WHERE `menu_id`=5848; -INSERT INTO `gossip_menu_option`(`menu_id`,`id`,`option_icon`,`option_text`,`option_id`,`npc_option_npcflag`) VALUES -(5848,1,0,'I need a new Orc Orphan Whistle.',1,1); - -DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=5848; -INSERT INTO `conditions`(`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`NegativeCondition`,`Comment`) VALUES -(15,5848,1,0,12,10,0,0,'Childrens Week must be active'), -(15,5848,1,0,8,172,0,0,'Quest 172 must be rewarded'), -(15,5848,1,0,2,18597,1,1,'Must not have item 18597'); - --- Orphan Matron Mercy -UPDATE `creature_template` SET `AIName`='SmartAI',`ScriptName`='' WHERE `entry`=22819; - -DELETE FROM `smart_scripts` WHERE `entryorguid`=22819 AND `source_type`=0; -INSERT INTO `smart_scripts`(`entryorguid`,`id`,`link`,`event_type`,`event_param1`,`event_param2`,`action_type`,`action_param1`,`target_type`,`comment`) VALUES -(22819,1,3,62,8568,1,11,39512,7,'Orphan Matron Mercy - On gossip select - Create blood elf orphan whistle'), -(22819,2,3,62,8568,2,11,39513,7,'Orphan Matron Mercy - On gossip select - Create draenei orphan whistle'), -(22819,3,0,61,0,0,72,0,7,'Orphan Matron Mercy - On gossip select - Close gossip'); - -DELETE FROM `gossip_menu_option` WHERE `menu_id`=8568; -INSERT INTO `gossip_menu_option`(`menu_id`,`id`,`option_icon`,`option_text`,`option_id`,`npc_option_npcflag`) VALUES -(8568,1,0,'I need a new Blood Elf Orphan Whistle.',1,1), -(8568,2,0,'I need a new Draenei Orphan Whistle.',1,1); - -DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=8568; -INSERT INTO `conditions`(`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`NegativeCondition`,`Comment`) VALUES -(15,8568,1,0,12,10,0,0,'Childrens Week must be active'), -(15,8568,1,0,8,10942,0,0,'Quest 10942 must be rewarded'), -(15,8568,1,0,2,31880,1,1,'Must not have item 31880'), -(15,8568,2,0,12,10,0,0,'Childrens Week must be active'), -(15,8568,2,0,8,10943,0,0,'Quest 10943 must be rewarded'), -(15,8568,2,0,2,31881,1,1,'Must not have item 31881'); - --- Orphan Matron Nightingale -UPDATE `creature_template` SET `AIName`='SmartAI',`ScriptName`='' WHERE `entry`=14450; - -DELETE FROM `smart_scripts` WHERE `entryorguid`=14450 AND `source_type`=0; -INSERT INTO `smart_scripts`(`entryorguid`,`id`,`link`,`event_type`,`event_param1`,`event_param2`,`action_type`,`action_param1`,`target_type`,`comment`) VALUES -(14450,1,2,62,5849,1,11,23124,7,'Orphan Matron Nightingale - On gossip select - Create human orphan whistle'), -(14450,2,0,61,0,0,72,0,7,'Orphan Matron Nightingale - On gossip select - Close gossip'); - -DELETE FROM `gossip_menu_option` WHERE `menu_id`=5849; -INSERT INTO `gossip_menu_option`(`menu_id`,`id`,`option_icon`,`option_text`,`option_id`,`npc_option_npcflag`) VALUES -(5849,1,0,'I need a new Human Orphan Whistle.',1,1); - -DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=5849; -INSERT INTO `conditions`(`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`NegativeCondition`,`Comment`) VALUES -(15,5849,1,0,12,10,0,0,'Childrens Week must be active'), -(15,5849,1,0,8,1468,0,0,'Quest 1468 must be rewarded'), -(15,5849,1,0,2,18598,1,1,'Must not have item 18598'); - --- Oracle Orphan -SET @TEXT_ORACLE_ORPHAN_1 = 1; -SET @TEXT_ORACLE_ORPHAN_2 = 2; -SET @TEXT_ORACLE_ORPHAN_3 = 3; -SET @TEXT_ORACLE_ORPHAN_4 = 4; -SET @TEXT_ORACLE_ORPHAN_5 = 5; -SET @TEXT_ORACLE_ORPHAN_6 = 6; -SET @TEXT_ORACLE_ORPHAN_7 = 7; -SET @TEXT_ORACLE_ORPHAN_8 = 8; -SET @TEXT_ORACLE_ORPHAN_9 = 9; -SET @TEXT_ORACLE_ORPHAN_10 = 10; -SET @TEXT_ORACLE_ORPHAN_11 = 11; -SET @TEXT_ORACLE_ORPHAN_12 = 12; -SET @TEXT_ORACLE_ORPHAN_13 = 13; -SET @TEXT_ORACLE_ORPHAN_14 = 14; - -UPDATE `creature_template` SET `AIName`='SmartAI',`ScriptName`='' WHERE `entry`=33533; - -DELETE FROM `smart_scripts` WHERE `entryorguid`=33533 AND `source_type`=0; -INSERT INTO `smart_scripts`(`entryorguid`,`event_type`,`event_param1`,`action_type`,`action_param1`,`target_type`,`comment`) VALUES -(33533,8,65357,33,36209,7,'Oracle Orphan - On spellhit - Give quest credit'); - -DELETE FROM `creature_text` WHERE `entry`=33533; -INSERT INTO `creature_text`(`entry`,`groupid`,`text`,`type`,`emote`) VALUE -(33533,@TEXT_ORACLE_ORPHAN_1,"Look!",12,0), -(33533,@TEXT_ORACLE_ORPHAN_2,"We can dance too!",12,0), -(33533,@TEXT_ORACLE_ORPHAN_3,"We made a new friend!",12,0), -(33533,@TEXT_ORACLE_ORPHAN_4,"We here! Only, if this is world tree, how come it broke when they tried to put whole world in?",12,0), -(33533,@TEXT_ORACLE_ORPHAN_5,"Look! Is that us? We think it's us. A bit older, maybe?",12,0), -(33533,@TEXT_ORACLE_ORPHAN_6,"Looks like we blessed by Great Ones! Shrines give magic, make us high-oracle someday? Maybe?",12,0), -(33533,@TEXT_ORACLE_ORPHAN_7,"Wow! A real Great One? We don't even think Soo-say has met a real Great One!",12,0), -(33533,@TEXT_ORACLE_ORPHAN_8,"Um, hello, Mr. Great One. We are honored to meet you.",12,0), -(33533,@TEXT_ORACLE_ORPHAN_9,"Maybe you're asleep, Mr. Great One? We stand. Must be hard working being Great One, collecting all the shinies we leave for you.",12,0), -(33533,@TEXT_ORACLE_ORPHAN_10,"We brought you a gift, Great One. Maybe you see it when you wake up. Maybe you remember we came to see you, oki?",12,0), -(33533,@TEXT_ORACLE_ORPHAN_11,"So that's the queen of the dragons? Hmm... we thought she'd be bigger. Yes, we did.",12,0), -(33533,@TEXT_ORACLE_ORPHAN_12,"How come she doesn't look like the other dragons? could she turn into a big ol' dragon if she wanted to?",12,0), -(33533,@TEXT_ORACLE_ORPHAN_13,"Um... Your Majesty, would you turn into a dragon for us?",12,0), -(33533,@TEXT_ORACLE_ORPHAN_14,"Oki... How about now?",12,0); - -DELETE FROM `creature_questrelation` WHERE `id`=33533; - -DELETE FROM `game_event_creature_quest` WHERE `id`=33533; -INSERT INTO `game_event_creature_quest`(`eventEntry`,`id`,`quest`) VALUES -(10,33533,13929), -(10,33533,13933), -(10,33533,13950), -(10,33533,13954), -(10,33533,13956), -(10,33533,13937), -(10,33533,13959); - -DELETE FROM `creature_involvedrelation` WHERE `id`=33533; -INSERT INTO `creature_involvedrelation`(`id`,`quest`) VALUES -(33533,13929), -(33533,13933), -(33533,13950), -(33533,13954), -(33533,13956), -(33533,13937), -(33533,13926); - -DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (19,20) AND `SourceEntry` IN (13954,13956,13937); -INSERT INTO `conditions`(`SourceTypeOrReferenceId`,`SourceEntry`,`ConditionTypeOrReference`,`ConditionValue1`,`comment`) VALUES -(19,13954,8,13929,'Accept quest 13954 - Quest 13929 needs to be rewarded'), -(19,13954,8,13933,'Accept quest 13954 - Quest 13933 needs to be rewarded'), -(19,13954,8,13950,'Accept quest 13954 - Quest 13950 needs to be rewarded'), -(19,13956,8,13929,'Accept quest 13956 - Quest 13929 needs to be rewarded'), -(19,13956,8,13933,'Accept quest 13956 - Quest 13933 needs to be rewarded'), -(19,13956,8,13950,'Accept quest 13956 - Quest 13950 needs to be rewarded'), -(19,13937,8,13956,'Accept quest 13937 - Quest 13956 needs to be rewarded'), -(20,13954,8,13929,'Show quest mark 13954 - Quest 13929 needs to be rewarded'), -(20,13954,8,13933,'Show quest mark 13954 - Quest 13933 needs to be rewarded'), -(20,13954,8,13950,'Show quest mark 13954 - Quest 13950 needs to be rewarded'), -(20,13956,8,13929,'Show quest mark 13956 - Quest 13929 needs to be rewarded'), -(20,13956,8,13933,'Show quest mark 13956 - Quest 13933 needs to be rewarded'), -(20,13956,8,13950,'Show quest mark 13956 - Quest 13950 needs to be rewarded'), -(20,13937,8,13956,'Show quest mark 13937 - Quest 13956 needs to be rewarded'); - --- Wolvar Orphan -SET @TEXT_WOLVAR_ORPHAN_1 = 1; -SET @TEXT_WOLVAR_ORPHAN_2 = 2; -SET @TEXT_WOLVAR_ORPHAN_3 = 3; -SET @TEXT_WOLVAR_ORPHAN_4 = 4; -SET @TEXT_WOLVAR_ORPHAN_5 = 5; -SET @TEXT_WOLVAR_ORPHAN_6 = 6; -SET @TEXT_WOLVAR_ORPHAN_7 = 7; -SET @TEXT_WOLVAR_ORPHAN_8 = 8; -SET @TEXT_WOLVAR_ORPHAN_9 = 9; -SET @TEXT_WOLVAR_ORPHAN_10 = 10; -SET @TEXT_WOLVAR_ORPHAN_11 = 11; -SET @TEXT_WOLVAR_ORPHAN_12 = 12; -SET @TEXT_WOLVAR_ORPHAN_13 = 13; - -UPDATE `creature_template` SET `AIName`='SmartAI',`ScriptName`='' WHERE `entry`=33532; - -DELETE FROM `smart_scripts` WHERE `entryorguid`=33532 AND `source_type`=0; -INSERT INTO `smart_scripts`(`entryorguid`,`event_type`,`event_param1`,`action_type`,`action_param1`,`target_type`,`comment`) VALUES -(33532,8,65357,33,36209,7,'Wolvar Orphan - On spellhit - Give quest credit'); - -DELETE FROM `creature_text` WHERE `entry`=33532; -INSERT INTO `creature_text`(`entry`,`groupid`,`text`,`type`,`emote`) VALUE -(33532,@TEXT_WOLVAR_ORPHAN_1,"Look!",12,0), -(33532,@TEXT_WOLVAR_ORPHAN_2,"Got you back!",12,0), -(33532,@TEXT_WOLVAR_ORPHAN_3,"Good snowball fight!",12,0), -(33532,@TEXT_WOLVAR_ORPHAN_4,"Look! That must be Kekek as a mighty warrior! See? What Kekek tell you?",12,0), -(33532,@TEXT_WOLVAR_ORPHAN_5,"Hmm... that Kekek very old. Must be elder, leader of Frenzyheart. This good. Kekek have good future as warrior and leader. Kekek very happy you bring him here. Orphan-lady never do that for Kekek.",12,0), -(33532,@TEXT_WOLVAR_ORPHAN_6,"Wow. At last, Kekek get to meet Hemet Nesingwary!",12,0), -(33532,@TEXT_WOLVAR_ORPHAN_7,"Even Frenzyheart know all about you after you come to Sholazar. Maybe you teach Kekek your tricks?",12,0), -(33532,@TEXT_WOLVAR_ORPHAN_8,"Not sure how reading helps. Kekek can't read anyway, but if Hemet Nesingwary say, Kekek try.",12,0), -(33532,@TEXT_WOLVAR_ORPHAN_9,"Maybe give up and throw book at animals, but try.",12,0), -(33532,@TEXT_WOLVAR_ORPHAN_10,"You think maybe one day, Kekek lead Frenzyheart home, like bear-men fight to get tree-city back? Kekek want own home, not city with purple men, not jungle with big-tongues.",12,0), -(33532,@TEXT_WOLVAR_ORPHAN_11,"Kekek thought we go see dragon queen. This just some elf-lady with funny horns.",12,0), -(33532,@TEXT_WOLVAR_ORPHAN_12,"But why? Dragons big and powerful. Elf-lady weak. Kekek want to see dragon queen's real form.",12,0), -(33532,@TEXT_WOLVAR_ORPHAN_13,"Oh! Now Kekek understand. Not want to be crushed by big dragon-lady. Maybe come back sometime when not so crowded. Nice to meet you, dragon-lady.",12,0); - -DELETE FROM `game_event_creature_quest` WHERE `id`=33532; -INSERT INTO `game_event_creature_quest`(`eventEntry`,`id`,`quest`) VALUES -(10,33532,13938), -(10,33532,13960), -(10,33532,13930), -(10,33532,13951), -(10,33532,13934), -(10,33532,13955), -(10,33532,13957); - -DELETE FROM `creature_involvedrelation` WHERE `id`=33532; -INSERT INTO `creature_involvedrelation`(`id`,`quest`) VALUES -(33532,13938), -(33532,13930), -(33532,13927), -(33532,13951), -(33532,13934), -(33532,13955), -(33532,13957); - -DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (19,20) AND `SourceEntry` IN (13955,13957,13938); -INSERT INTO `conditions`(`SourceTypeOrReferenceId`,`SourceEntry`,`ConditionTypeOrReference`,`ConditionValue1`,`comment`) VALUES -(19,13955,8,13930,'Accept quest 13955 - Quest 13930 needs to be rewarded'), -(19,13955,8,13934,'Accept quest 13955 - Quest 13934 needs to be rewarded'), -(19,13955,8,13951,'Accept quest 13955 - Quest 13951 needs to be rewarded'), -(19,13957,8,13930,'Accept quest 13957 - Quest 13930 needs to be rewarded'), -(19,13957,8,13934,'Accept quest 13957 - Quest 13934 needs to be rewarded'), -(19,13957,8,13951,'Accept quest 13957 - Quest 13951 needs to be rewarded'), -(19,13938,8,13957,'Accept quest 13938 - Quest 13957 needs to be rewarded'), -(20,13955,8,13930,'Show quest mark 13955 - Quest 13930 needs to be rewarded'), -(20,13955,8,13934,'Show quest mark 13955 - Quest 13934 needs to be rewarded'), -(20,13955,8,13951,'Show quest mark 13955 - Quest 13951 needs to be rewarded'), -(20,13957,8,13930,'Show quest mark 13957 - Quest 13930 needs to be rewarded'), -(20,13957,8,13934,'Show quest mark 13957 - Quest 13934 needs to be rewarded'), -(20,13957,8,13951,'Show quest mark 13957 - Quest 13951 needs to be rewarded'), -(20,13938,8,13957,'Show quest mark 13938 - Quest 13957 needs to be rewarded'); - --- Blood Elf Orphan -UPDATE `quest_template` SET `SpecialFlags`=`SpecialFlags`|2 WHERE `Id` IN (10945,10953,10951,10963); - -DELETE FROM `game_event_creature_quest` WHERE `id`=22817; -INSERT INTO `game_event_creature_quest`(`eventEntry`,`id`,`quest`) VALUES -(10,22817,10945), -(10,22817,10953), -(10,22817,10951), -(10,22817,10963), -(10,22817,11975), -(10,22817,10967); - -DELETE FROM `creature_involvedrelation` WHERE `id`=22817; -INSERT INTO `creature_involvedrelation`(`id`,`quest`) VALUES -(22817,10942), -(22817,10951), -(22817,11975), -(22817,10963); - -DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (19,20) AND `SourceEntry` IN (11975,10963,10967); -INSERT INTO `conditions`(`SourceTypeOrReferenceId`,`SourceEntry`,`ConditionTypeOrReference`,`ConditionValue1`,`comment`) VALUES -(19,11975,8,10945,'Accept quest 11975 - Quest 10945 needs to be rewarded'), -(19,11975,8,10953,'Accept quest 11975 - Quest 10953 needs to be rewarded'), -(19,11975,8,10951,'Accept quest 11975 - Quest 10951 needs to be rewarded'), -(19,10963,8,10945,'Accept quest 10963 - Quest 10945 needs to be rewarded'), -(19,10963,8,10953,'Accept quest 10963 - Quest 10953 needs to be rewarded'), -(19,10963,8,10951,'Accept quest 10963 - Quest 10951 needs to be rewarded'), -(19,10967,8,10963,'Accept quest 10967 - Quest 10963 needs to be rewarded'), -(20,11975,8,10945,'Show quest mark 11975 - Quest 10945 needs to be rewarded'), -(20,11975,8,10953,'Show quest mark 11975 - Quest 10953 needs to be rewarded'), -(20,11975,8,10951,'Show quest mark 11975 - Quest 10951 needs to be rewarded'), -(20,10963,8,10945,'Show quest mark 10963 - Quest 10945 needs to be rewarded'), -(20,10963,8,10953,'Show quest mark 10963 - Quest 10953 needs to be rewarded'), -(20,10963,8,10951,'Show quest mark 10963 - Quest 10951 needs to be rewarded'), -(20,10967,8,10963,'Show quest mark 10967 - Quest 10963 needs to be rewarded'); - --- Draenei Orphan -UPDATE `quest_template` SET `SpecialFlags`=`SpecialFlags`|2 WHERE `Id` IN (10956,10968,10950,10952,10954,10962); - -DELETE FROM `game_event_creature_quest` WHERE `id`=22818; -INSERT INTO `game_event_creature_quest`(`eventEntry`,`id`,`quest`) VALUES -(10,22818,10952), -(10,22818,10950), -(10,22818,10966), -(10,22818,10954), -(10,22818,10956), -(10,22818,10962); - -DELETE FROM `creature_involvedrelation` WHERE `id`=22818; -INSERT INTO `creature_involvedrelation`(`id`,`quest`) VALUES -(22818,10950), -(22818,10952), -(22818,10943), -(22818,10962); - -DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (19,20) AND `SourceEntry` IN (10956,10962,10966); -INSERT INTO `conditions`(`SourceTypeOrReferenceId`,`SourceEntry`,`ConditionTypeOrReference`,`ConditionValue1`,`comment`) VALUES -(19,10956,8,10950,'Accept quest 10956 - Quest 10950 needs to be rewarded'), -(19,10956,8,10954,'Accept quest 10956 - Quest 10954 needs to be rewarded'), -(19,10956,8,10952,'Accept quest 10956 - Quest 10952 needs to be rewarded'), -(19,10962,8,10950,'Accept quest 10962 - Quest 10950 needs to be rewarded'), -(19,10962,8,10954,'Accept quest 10962 - Quest 10954 needs to be rewarded'), -(19,10962,8,10952,'Accept quest 10962 - Quest 10952 needs to be rewarded'), -(19,10966,8,10962,'Accept quest 10966 - Quest 10962 needs to be rewarded'), -(20,10956,8,10950,'Show quest mark 10956 - Quest 10950 needs to be rewarded'), -(20,10956,8,10954,'Show quest mark 10956 - Quest 10954 needs to be rewarded'), -(20,10956,8,10952,'Show quest mark 10956 - Quest 10952 needs to be rewarded'), -(20,10962,8,10950,'Show quest mark 10962 - Quest 10950 needs to be rewarded'), -(20,10962,8,10954,'Show quest mark 10962 - Quest 10954 needs to be rewarded'), -(20,10962,8,10952,'Show quest mark 10962 - Quest 10952 needs to be rewarded'), -(20,10966,8,10962,'Show quest mark 10966 - Quest 10962 needs to be rewarded'); - --- Human Orphan -DELETE FROM `creature_questrelation` WHERE `id`=14305; - -DELETE FROM `game_event_creature_quest` WHERE `id`=14305; -INSERT INTO `game_event_creature_quest`(`eventEntry`,`id`,`quest`) VALUES -(10,14305,171), -(10,14305,558), -(10,14305,1687), -(10,14305,1479), -(10,14305,1558), -(10,14305,4822); - -DELETE FROM `creature_involvedrelation` WHERE `id`=14305; -INSERT INTO `creature_involvedrelation`(`id`,`quest`) VALUES -(14305,1468), -(14305,558), -(14305,1687), -(14305,1479), -(14305,1558), -(14305,4822); - -DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (19,20) AND `SourceEntry` IN (558,4822,171); -INSERT INTO `conditions`(`SourceTypeOrReferenceId`,`SourceEntry`,`ConditionTypeOrReference`,`ConditionValue1`,`comment`) VALUES -(19,558,8,1687,'Accept quest 558 - Quest 1687 needs to be rewarded'), -(19,558,8,1558,'Accept quest 558 - Quest 1558 needs to be rewarded'), -(19,558,8,1479,'Accept quest 558 - Quest 1479 needs to be rewarded'), -(19,558,16,1101,'Accept quest 558 - Needs to be in race mask 1101'), -(19,4822,8,1687,'Accept quest 4822 - Quest 1687 needs to be rewarded'), -(19,4822,8,1558,'Accept quest 4822 - Quest 1558 needs to be rewarded'), -(19,4822,8,1479,'Accept quest 4822 - Quest 1479 needs to be rewarded'), -(19,171,8,4822,'Accept quest 171 - Quest 4822 needs to be rewarded'), -(20,558,8,1687,'Show quest mark 558 - Quest 1687 needs to be rewarded'), -(20,558,8,1558,'Show quest mark 558 - Quest 1558 needs to be rewarded'), -(20,558,8,1479,'Show quest mark 558 - Quest 1479 needs to be rewarded'), -(20,558,16,1101,'Show quest mark 558 - Needs to be in race mask 1101'), -(20,4822,8,1687,'Show quest mark 4822 - Quest 1687 needs to be rewarded'), -(20,4822,8,1558,'Show quest mark 4822 - Quest 1558 needs to be rewarded'), -(20,4822,8,1479,'Show quest mark 4822 - Quest 1479 needs to be rewarded'), -(20,171,8,4822,'Show quest mark 171 - Quest 4822 needs to be rewarded'); - --- Orcish Orphan -DELETE FROM `creature_questrelation` WHERE `id`=14444; - -DELETE FROM `game_event_creature_quest` WHERE `id`=14444; -INSERT INTO `game_event_creature_quest`(`eventEntry`,`id`,`quest`) VALUES -(10,14444,910), -(10,14444,911), -(10,14444,1800), -(10,14444,925), -(10,14444,915), -(10,14444,5502); - -DELETE FROM `creature_involvedrelation` WHERE `id`=14444; -INSERT INTO `creature_involvedrelation`(`id`,`quest`) VALUES -(14444,925), -(14444,172), -(14444,910), -(14444,911), -(14444,1800), -(14444,915); - -DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (19,20) AND `SourceEntry` IN (915,925,5502); -INSERT INTO `conditions`(`SourceTypeOrReferenceId`,`SourceEntry`,`ConditionTypeOrReference`,`ConditionValue1`,`comment`) VALUES -(19,925,8,910,'Accept quest 925 - Quest 910 needs to be rewarded'), -(19,925,8,911,'Accept quest 925 - Quest 911 needs to be rewarded'), -(19,925,8,1800,'Accept quest 925 - Quest 1800 needs to be rewarded'), -(19,915,8,910,'Accept quest 915 - Quest 910 needs to be rewarded'), -(19,915,8,911,'Accept quest 915 - Quest 911 needs to be rewarded'), -(19,915,8,1800,'Accept quest 915 - Quest 1800 needs to be rewarded'), -(19,5502,8,925,'Accept quest 5502 - Quest 925 needs to be rewarded'), -(20,925,8,910,'Show quest mark 925 - Quest 910 needs to be rewarded'), -(20,925,8,911,'Show quest mark 925 - Quest 911 needs to be rewarded'), -(20,925,8,1800,'Show quest mark 925 - Quest 1800 needs to be rewarded'), -(20,915,8,910,'Show quest mark 915 - Quest 910 needs to be rewarded'), -(20,915,8,911,'Show quest mark 915 - Quest 911 needs to be rewarded'), -(20,915,8,1800,'Show quest mark 915 - Quest 1800 needs to be rewarded'), -(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; - -UPDATE `creature_template` SET `AIName`='',`ScriptName`='npc_grizzlemaw_cw_trigger',`flags_extra`=0 WHERE `entry`=36209; - -DELETE FROM `creature` WHERE `guid` IN (@GUID_GRIZZLEMAW_TRIGGER_1,@GUID_GRIZZLEMAW_TRIGGER_2,@GUID_GRIZZLEMAW_TRIGGER_3); -INSERT INTO `creature`(`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`) VALUES -(@GUID_GRIZZLEMAW_TRIGGER_1,36209,571,4068.82,-3811,223.4), -(@GUID_GRIZZLEMAW_TRIGGER_2,36209,571,4073.2,-3734.354,222.6634), -(@GUID_GRIZZLEMAW_TRIGGER_3,36209,571,3923.109,-3763.967,165.362); - --- Elder Kekek -SET @GUID_KEKEK = 3019845; -SET @TEXT_ELDER_KEKEK_1 = 1; - -UPDATE `creature_template` SET `ScriptName`='npc_elder_kekek' WHERE `entry`=34387; - -DELETE FROM `creature` WHERE `guid`=@GUID_KEKEK OR `id`=34387; -INSERT INTO `creature`(`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`) VALUES -(@GUID_KEKEK,34387,571,4181.482,-461.453,120.728,1.398097); - -DELETE FROM `creature_text` WHERE `entry`=34387; -INSERT INTO `creature_text`(`entry`,`groupid`,`text`,`type`,`emote`) VALUE -(34387,@TEXT_ELDER_KEKEK_1,"No worry, Kekek. You grow up, be strong for Frenzyheart. You lead people back to old home, where there no big-tongue babies.",12,0); - --- Alexstraza -SET @TEXT_ALEXSTRASZA_2 = 2; -SET @TEXT_KRASUS_8 = 8; - -UPDATE `creature_template` SET `AIName`='',`ScriptName`='npc_alexstraza_the_lifebinder' WHERE `entry`=26917; - -DELETE FROM `creature_text` WHERE (`entry`=26917 AND `groupid`=@TEXT_ALEXSTRASZA_2) OR (`entry`=27990 AND `groupid`=@TEXT_KRASUS_8); -INSERT INTO `creature_text`(`entry`,`groupid`,`text`,`type`,`emote`) VALUE -(26917,@TEXT_ALEXSTRASZA_2,"If I was in my dragon form, there wouldn't be any room for anyone else, little one.",12,0), -(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 @TEXT_SOO_ROO_1 = 1; - -UPDATE `creature_template` SET `AIName`='',`ScriptName`='npc_high_oracle_soo_roo' WHERE `entry`=34386; - -DELETE FROM `creature_text` WHERE `entry`=34386; -INSERT INTO `creature_text`(`entry`,`groupid`,`text`,`type`,`emote`) VALUE -(34386,@TEXT_SOO_ROO_1,"We remember this visit, yes we do. Never forget what you learn from your new friend, little Roo. You got great future ahead.",12,0); - -DELETE FROM `creature` WHERE `guid`=@GUID_SOO_ROO OR `id`=34386; -INSERT INTO `creature`(`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`) VALUES -(@GUID_SOO_ROO,34386,571,4120.996,-329.486,121.443817,0.299253); - --- Nesingwary -SET @TEXT_NESINGWARY_1 = 1; - -DELETE FROM `creature_text` WHERE `entry`=27986; -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 @TEXT_SNOWFALL_GLADE_PLAYMATE_1 = 1; -SET @TEXT_SNOWFALL_GLADE_PLAYMATE_2 = 2; - -UPDATE `creature_template` SET `AIName`='',`ScriptName`='npc_snowfall_glade_playmate' WHERE `entry`=34490; - -DELETE FROM `creature_text` WHERE `entry`=34490; -INSERT INTO `creature_text`(`entry`,`groupid`,`text`,`type`,`emote`) VALUE -(34490,@TEXT_SNOWFALL_GLADE_PLAYMATE_1,"Better watch out!",12,0), -(34490,@TEXT_SNOWFALL_GLADE_PLAYMATE_2,"Got you good!",12,0); - -DELETE FROM `creature` WHERE `guid`=@GUID_SNOWFALL_GLADE_PLAYMATE OR `id`=34490; -INSERT INTO `creature`(`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`) VALUES -(@GUID_SNOWFALL_GLADE_PLAYMATE,34490,571,3325.193,1026.451,138.1712,2.062184); - --- Winterfin Playmate -SET @GUID_WINTERFIN_PLAYMATE = 3019823; -SET @TEXT_WINTERFIN_PLAYMATE_1 = 1; -SET @TEXT_WINTERFIN_PLAYMATE_2 = 2; - -UPDATE `creature_template` SET `AIName`='',`ScriptName`='npc_winterfin_playmate' WHERE `entry`=34489; - -DELETE FROM `creature_text` WHERE `entry`=34489; -INSERT INTO `creature_text`(`entry`,`groupid`,`text`,`type`,`emote`) VALUE -(34489,@TEXT_WINTERFIN_PLAYMATE_1,"Wanna see what I can do?",12,0), -(34489,@TEXT_WINTERFIN_PLAYMATE_2,"Now dance together!",12,0); - -DELETE FROM `creature` WHERE `guid`=@GUID_WINTERFIN_PLAYMATE OR `id`=34489; -INSERT INTO `creature`(`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`) VALUES -(@GUID_WINTERFIN_PLAYMATE,34489,571,4382.502,6066.199,0.724562,3.571894); - --- Biggest Tree Ever -SET @GUID_BIGGEST_TREE_TRIGGER = 3019825; - -UPDATE `creature_template` SET `AIName`='',`ScriptName`='npc_the_biggest_tree',`flags_extra`=0 WHERE `entry`=34381; - -DELETE FROM `creature` WHERE `guid`=@GUID_BIGGEST_TREE_TRIGGER OR `id`=34381; -INSERT INTO `creature`(`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`) VALUES -(@GUID_BIGGEST_TREE_TRIGGER,34381,571,4022.666,-3777.682,115.443588,4.857019); - --- Meeting A Great One -UPDATE `creature_template` SET `ScriptName`='npc_the_etymidian' WHERE `entry`=28092; - --- POIs -DELETE FROM `quest_poi` WHERE `questId` IN (13956,13929,13950,13951,13957,13933,13934,13930,13954,13955); -INSERT INTO `quest_poi`(`questId`,`objIndex`,`mapid`,`WorldMapAreaId`,`unk4`) VALUES -(13956,16,1,201,3), -(13929,16,571,490,3), -(13950,16,571,486,3), -(13951,16,571,488,3), -(13957,16,571,493,3), -(13933,16,571,488,3), -(13934,16,571,488,3), -(13930,16,571,490,3), -(13954,16,571,488,3), -(13955,16,571,488,3); - -DELETE FROM `quest_poi_points` WHERE `questid` IN (13956,13929,13950,13951,13957,13933,13934,13930,13954,13955); -INSERT INTO `quest_poi_points`(`questId`,`x`,`y`) VALUES -(13956,-6193,-1223), -(13929,4022,-3777), -(13950,4382,6066), -(13951,3325,1026), -(13957,5584,5748), -(13933,4121,-329), -(13934,4181,-461), -(13930,4071,-3773), -(13954,3530,271), -(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; - -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); - -DELETE FROM `creature` WHERE `guid` IN (@GUID_SILVERMOON_TRIGGER_01,@GUID_AERIS_LANDING_TRIGGER,@GUID_AUCHINDOUN_TRIGGER,@GUID_SPOREGGAR_TRIGGER,@GUID_THRONE_OF_ELEMENTS_TRIGGER); -INSERT INTO `creature`(`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`) VALUES -(@GUID_AERIS_LANDING_TRIGGER,22838,530,-2075.759,8559.336,23.027,4.857019), -(@GUID_SILVERMOON_TRIGGER_01,22866,530,9506.086,-7329.313,14.397272,0), -(@GUID_AUCHINDOUN_TRIGGER,22831,530,-3320.860,4925.095,-101.1,0), -(@GUID_SPOREGGAR_TRIGGER,22829,530,203.587,8550.11,22.3256,0), -(@GUID_THRONE_OF_ELEMENTS_TRIGGER,22839,530,-781.294,6943.52,33.3344,0); - --- Misc -DELETE `game_event_creature` FROM `game_event_creature` INNER JOIN `creature` ON `creature`.`guid`=`game_event_creature`.`guid` -WHERE `id` IN (22905,22851,22838,22866,22831,22829,22872,22839,14450,22819,14451,34365,34387,34386,34490,34489,34381,36209); -INSERT INTO `game_event_creature`(`eventEntry`,`guid`) SELECT 10,`guid` FROM `creature` -WHERE `id` IN (22905,22851,22838,22866,22831,22829,22872,22839,14450,22819,14451,34365,34387,34386,34490,34489,34381,36209); - -DELETE FROM `game_event_npc_vendor` WHERE `eventEntry`=10 AND `item`=46693; -INSERT INTO `game_event_npc_vendor` (`eventEntry`, `guid`, `item`) VALUES -(10,99369,46693), -(10,97984,46693); - -UPDATE `item_template` SET `minMoneyLoot`=50000,`maxMoneyLoot`=50000 WHERE `entry`=23022; -UPDATE `item_template` SET `HolidayId`=201 WHERE `entry` IN (46396,46397,31880,31881,18598,18597); - -DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=17 AND `SourceEntry` IN (23012,23013,39478,39479,65352,65353); -INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ErrorTextId`,`Comment`) VALUES -(17,0,23012,0,12,10,0,"Orphan Whistle only while children's week"), -(17,0,23013,0,12,10,0,"Orphan Whistle only while children's week"), -(17,0,39478,0,12,10,0,"Orphan Whistle only while children's week"), -(17,0,39479,0,12,10,0,"Orphan Whistle only while children's week"), -(17,0,65352,0,12,10,0,"Orphan Whistle only while children's week"), -(17,0,65353,0,12,10,0,"Orphan Whistle only while children's week"); - -UPDATE `quest_poi_points` SET `x`=1642,`y`=239 WHERE `questId`=1800 AND `id`=0 AND `idx`=0; -UPDATE `quest_poi_points` SET `x`=-248,`y`=956 WHERE `questId`=10952 AND `id`=0 AND `idx`=0; -UPDATE `quest_poi_points` SET `x`=-11400.211,`y`=1944.599 WHERE `questId`=1687 AND `id`=0 AND `idx`=0; -UPDATE `quest_poi_points` SET `x`=-998.183,`y`=-3822.07 WHERE `questId`=910 AND `id`=0 AND `idx`=0; -UPDATE `quest_poi_points` SET `x`=1260.812,`y`=-2223.765 WHERE `questId`=911 AND `id`=0 AND `idx`=0; -UPDATE `quest_poi_points` SET `x`=9933,`y`=2500 WHERE `questId`=1479 AND `id`=0 AND `idx`=0; -UPDATE `quest_poi_points` SET `x`=-2075.759,`y`=8559.336 WHERE `questId`=10954 AND `id`=0 AND `idx`=0; -UPDATE `quest_poi_points` SET `x`=9506,`y`=-7329 WHERE `questId`=11975 AND `id`=0 AND `idx`=0; -UPDATE `quest_poi_points` SET `x`=-3320.860,`y`=4925.095 WHERE `questId`=10950 AND `id`=0 AND `idx`=0; -UPDATE `quest_poi_points` SET `x`=203.587,`y`=8550.11 WHERE `questId`=10945 AND `id`=0 AND `idx`=0; -UPDATE `quest_poi_points` SET `x`=-781.294,`y`=6943.52 WHERE `questId`=10953 AND `id`=0 AND `idx`=0; diff --git a/sql/updates/world/2012_10_25_00_world_childrens_week.sql b/sql/updates/world/2012_10_25_00_world_childrens_week.sql new file mode 100644 index 00000000000..33ad3c54ad1 --- /dev/null +++ b/sql/updates/world/2012_10_25_00_world_childrens_week.sql @@ -0,0 +1,574 @@ +-- Orphan Matron Aria +UPDATE `creature_template` SET `AIName`='SmartAI',`ScriptName`='' WHERE `entry`=34365; + +DELETE FROM `smart_scripts` WHERE `entryorguid`=34365 AND `source_type`=0; +INSERT INTO `smart_scripts`(`entryorguid`,`id`,`link`,`event_type`,`event_param1`,`event_param2`,`action_type`,`action_param1`,`target_type`,`comment`) VALUES +(34365,1,4,62,10502,1,33,34365,7,'Orphan Matron Aria - On gossip select - Give quest credit'), +(34365,2,4,62,10502,2,11,65359,7,'Orphan Matron Aria - On gossip select - Create oracle orphan whistle'), +(34365,3,4,62,10502,3,11,65360,7,'Orphan Matron Aria - On gossip select - Create wolvar orphan whistle'), +(34365,4,0,61,0,0,72,0,7,'Orphan Matron Aria - On gossip select - Close gossip'); + +DELETE FROM `gossip_menu_option` WHERE `menu_id`=10502; +INSERT INTO `gossip_menu_option`(`menu_id`,`id`,`option_icon`,`option_text`,`option_id`,`npc_option_npcflag`) VALUES +(10502,1,0,'Tell me about the orphans.',1,1), +(10502,2,0,'I need a new Oracle Orphan Whistle.',1,1), +(10502,3,0,'I need a new Wolvar Orphan Whistle.',1,1); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=10502; +INSERT INTO `conditions`(`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`NegativeCondition`,`Comment`) VALUES +(15,10502,1,1,12,10,0,0,'Childrens Week must be active'), +(15,10502,1,1,1,58818,0,0,'Needs aura 58818'), +(15,10502,1,1,9,13927,0,0,'Quest 13927 must be active'), +(15,10502,1,2,12,10,0,0,'Childrens Week must be active'), +(15,10502,1,2,1,58818,0,0,'Needs aura 58818'), +(15,10502,1,2,9,13926,0,0,'Quest 13926 must be active'), +(15,10502,2,0,12,10,0,0,'Childrens Week must be active'), +(15,10502,2,0,8,13926,0,0,'Quest 13926 must be rewarded'), +(15,10502,2,0,2,46397,1,1,'Must not have item 46397'), +(15,10502,3,0,12,10,0,0,'Childrens Week must be active'), +(15,10502,3,0,8,13927,0,0,'Quest 13926 must be rewarded'), +(15,10502,3,0,2,46396,1,1,'Must not have item 46397'); + +-- Orphan Matron Battlewail +UPDATE `creature_template` SET `AIName`='SmartAI',`ScriptName`='' WHERE `entry`=14451; + +DELETE FROM `smart_scripts` WHERE `entryorguid`=14451 AND `source_type`=0; +INSERT INTO `smart_scripts`(`entryorguid`,`id`,`link`,`event_type`,`event_param1`,`event_param2`,`action_type`,`action_param1`,`target_type`,`comment`) VALUES +(14451,1,2,62,5848,1,11,23125,7,'Orphan Matron Battlewail - On gossip select - Create orc orphan whistle'), +(14451,2,0,61,0,0,72,0,7,'Orphan Matron Battlewail - On gossip select - Close gossip'); + +DELETE FROM `gossip_menu_option` WHERE `menu_id`=5848; +INSERT INTO `gossip_menu_option`(`menu_id`,`id`,`option_icon`,`option_text`,`option_id`,`npc_option_npcflag`) VALUES +(5848,1,0,'I need a new Orc Orphan Whistle.',1,1); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=5848; +INSERT INTO `conditions`(`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`NegativeCondition`,`Comment`) VALUES +(15,5848,1,0,12,10,0,0,'Childrens Week must be active'), +(15,5848,1,0,8,172,0,0,'Quest 172 must be rewarded'), +(15,5848,1,0,2,18597,1,1,'Must not have item 18597'); + +-- Orphan Matron Mercy +UPDATE `creature_template` SET `AIName`='SmartAI',`ScriptName`='' WHERE `entry`=22819; + +DELETE FROM `smart_scripts` WHERE `entryorguid`=22819 AND `source_type`=0; +INSERT INTO `smart_scripts`(`entryorguid`,`id`,`link`,`event_type`,`event_param1`,`event_param2`,`action_type`,`action_param1`,`target_type`,`comment`) VALUES +(22819,1,3,62,8568,1,11,39512,7,'Orphan Matron Mercy - On gossip select - Create blood elf orphan whistle'), +(22819,2,3,62,8568,2,11,39513,7,'Orphan Matron Mercy - On gossip select - Create draenei orphan whistle'), +(22819,3,0,61,0,0,72,0,7,'Orphan Matron Mercy - On gossip select - Close gossip'); + +DELETE FROM `gossip_menu_option` WHERE `menu_id`=8568; +INSERT INTO `gossip_menu_option`(`menu_id`,`id`,`option_icon`,`option_text`,`option_id`,`npc_option_npcflag`) VALUES +(8568,1,0,'I need a new Blood Elf Orphan Whistle.',1,1), +(8568,2,0,'I need a new Draenei Orphan Whistle.',1,1); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=8568; +INSERT INTO `conditions`(`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`NegativeCondition`,`Comment`) VALUES +(15,8568,1,0,12,10,0,0,'Childrens Week must be active'), +(15,8568,1,0,8,10942,0,0,'Quest 10942 must be rewarded'), +(15,8568,1,0,2,31880,1,1,'Must not have item 31880'), +(15,8568,2,0,12,10,0,0,'Childrens Week must be active'), +(15,8568,2,0,8,10943,0,0,'Quest 10943 must be rewarded'), +(15,8568,2,0,2,31881,1,1,'Must not have item 31881'); + +-- Orphan Matron Nightingale +UPDATE `creature_template` SET `AIName`='SmartAI',`ScriptName`='' WHERE `entry`=14450; + +DELETE FROM `smart_scripts` WHERE `entryorguid`=14450 AND `source_type`=0; +INSERT INTO `smart_scripts`(`entryorguid`,`id`,`link`,`event_type`,`event_param1`,`event_param2`,`action_type`,`action_param1`,`target_type`,`comment`) VALUES +(14450,1,2,62,5849,1,11,23124,7,'Orphan Matron Nightingale - On gossip select - Create human orphan whistle'), +(14450,2,0,61,0,0,72,0,7,'Orphan Matron Nightingale - On gossip select - Close gossip'); + +DELETE FROM `gossip_menu_option` WHERE `menu_id`=5849; +INSERT INTO `gossip_menu_option`(`menu_id`,`id`,`option_icon`,`option_text`,`option_id`,`npc_option_npcflag`) VALUES +(5849,1,0,'I need a new Human Orphan Whistle.',1,1); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=5849; +INSERT INTO `conditions`(`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`NegativeCondition`,`Comment`) VALUES +(15,5849,1,0,12,10,0,0,'Childrens Week must be active'), +(15,5849,1,0,8,1468,0,0,'Quest 1468 must be rewarded'), +(15,5849,1,0,2,18598,1,1,'Must not have item 18598'); + +-- Oracle Orphan +SET @TEXT_ORACLE_ORPHAN_1 = 1; +SET @TEXT_ORACLE_ORPHAN_2 = 2; +SET @TEXT_ORACLE_ORPHAN_3 = 3; +SET @TEXT_ORACLE_ORPHAN_4 = 4; +SET @TEXT_ORACLE_ORPHAN_5 = 5; +SET @TEXT_ORACLE_ORPHAN_6 = 6; +SET @TEXT_ORACLE_ORPHAN_7 = 7; +SET @TEXT_ORACLE_ORPHAN_8 = 8; +SET @TEXT_ORACLE_ORPHAN_9 = 9; +SET @TEXT_ORACLE_ORPHAN_10 = 10; +SET @TEXT_ORACLE_ORPHAN_11 = 11; +SET @TEXT_ORACLE_ORPHAN_12 = 12; +SET @TEXT_ORACLE_ORPHAN_13 = 13; +SET @TEXT_ORACLE_ORPHAN_14 = 14; + +UPDATE `creature_template` SET `AIName`='SmartAI',`ScriptName`='' WHERE `entry`=33533; + +DELETE FROM `smart_scripts` WHERE `entryorguid`=33533 AND `source_type`=0; +INSERT INTO `smart_scripts`(`entryorguid`,`event_type`,`event_param1`,`action_type`,`action_param1`,`target_type`,`comment`) VALUES +(33533,8,65357,33,36209,7,'Oracle Orphan - On spellhit - Give quest credit'); + +DELETE FROM `creature_text` WHERE `entry`=33533; +INSERT INTO `creature_text`(`entry`,`groupid`,`text`,`type`,`emote`) VALUE +(33533,@TEXT_ORACLE_ORPHAN_1,"Look!",12,0), +(33533,@TEXT_ORACLE_ORPHAN_2,"We can dance too!",12,0), +(33533,@TEXT_ORACLE_ORPHAN_3,"We made a new friend!",12,0), +(33533,@TEXT_ORACLE_ORPHAN_4,"We here! Only, if this is world tree, how come it broke when they tried to put whole world in?",12,0), +(33533,@TEXT_ORACLE_ORPHAN_5,"Look! Is that us? We think it's us. A bit older, maybe?",12,0), +(33533,@TEXT_ORACLE_ORPHAN_6,"Looks like we blessed by Great Ones! Shrines give magic, make us high-oracle someday? Maybe?",12,0), +(33533,@TEXT_ORACLE_ORPHAN_7,"Wow! A real Great One? We don't even think Soo-say has met a real Great One!",12,0), +(33533,@TEXT_ORACLE_ORPHAN_8,"Um, hello, Mr. Great One. We are honored to meet you.",12,0), +(33533,@TEXT_ORACLE_ORPHAN_9,"Maybe you're asleep, Mr. Great One? We stand. Must be hard working being Great One, collecting all the shinies we leave for you.",12,0), +(33533,@TEXT_ORACLE_ORPHAN_10,"We brought you a gift, Great One. Maybe you see it when you wake up. Maybe you remember we came to see you, oki?",12,0), +(33533,@TEXT_ORACLE_ORPHAN_11,"So that's the queen of the dragons? Hmm... we thought she'd be bigger. Yes, we did.",12,0), +(33533,@TEXT_ORACLE_ORPHAN_12,"How come she doesn't look like the other dragons? could she turn into a big ol' dragon if she wanted to?",12,0), +(33533,@TEXT_ORACLE_ORPHAN_13,"Um... Your Majesty, would you turn into a dragon for us?",12,0), +(33533,@TEXT_ORACLE_ORPHAN_14,"Oki... How about now?",12,0); + +DELETE FROM `creature_questrelation` WHERE `id`=33533; + +DELETE FROM `game_event_creature_quest` WHERE `id`=33533; +INSERT INTO `game_event_creature_quest`(`eventEntry`,`id`,`quest`) VALUES +(10,33533,13929), +(10,33533,13933), +(10,33533,13950), +(10,33533,13954), +(10,33533,13956), +(10,33533,13937), +(10,33533,13959); + +DELETE FROM `creature_involvedrelation` WHERE `id`=33533; +INSERT INTO `creature_involvedrelation`(`id`,`quest`) VALUES +(33533,13929), +(33533,13933), +(33533,13950), +(33533,13954), +(33533,13956), +(33533,13937), +(33533,13926); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (19,20) AND `SourceEntry` IN (13954,13956,13937); +INSERT INTO `conditions`(`SourceTypeOrReferenceId`,`SourceEntry`,`ConditionTypeOrReference`,`ConditionValue1`,`comment`) VALUES +(19,13954,8,13929,'Accept quest 13954 - Quest 13929 needs to be rewarded'), +(19,13954,8,13933,'Accept quest 13954 - Quest 13933 needs to be rewarded'), +(19,13954,8,13950,'Accept quest 13954 - Quest 13950 needs to be rewarded'), +(19,13956,8,13929,'Accept quest 13956 - Quest 13929 needs to be rewarded'), +(19,13956,8,13933,'Accept quest 13956 - Quest 13933 needs to be rewarded'), +(19,13956,8,13950,'Accept quest 13956 - Quest 13950 needs to be rewarded'), +(19,13937,8,13956,'Accept quest 13937 - Quest 13956 needs to be rewarded'), +(20,13954,8,13929,'Show quest mark 13954 - Quest 13929 needs to be rewarded'), +(20,13954,8,13933,'Show quest mark 13954 - Quest 13933 needs to be rewarded'), +(20,13954,8,13950,'Show quest mark 13954 - Quest 13950 needs to be rewarded'), +(20,13956,8,13929,'Show quest mark 13956 - Quest 13929 needs to be rewarded'), +(20,13956,8,13933,'Show quest mark 13956 - Quest 13933 needs to be rewarded'), +(20,13956,8,13950,'Show quest mark 13956 - Quest 13950 needs to be rewarded'), +(20,13937,8,13956,'Show quest mark 13937 - Quest 13956 needs to be rewarded'); + +-- Wolvar Orphan +SET @TEXT_WOLVAR_ORPHAN_1 = 1; +SET @TEXT_WOLVAR_ORPHAN_2 = 2; +SET @TEXT_WOLVAR_ORPHAN_3 = 3; +SET @TEXT_WOLVAR_ORPHAN_4 = 4; +SET @TEXT_WOLVAR_ORPHAN_5 = 5; +SET @TEXT_WOLVAR_ORPHAN_6 = 6; +SET @TEXT_WOLVAR_ORPHAN_7 = 7; +SET @TEXT_WOLVAR_ORPHAN_8 = 8; +SET @TEXT_WOLVAR_ORPHAN_9 = 9; +SET @TEXT_WOLVAR_ORPHAN_10 = 10; +SET @TEXT_WOLVAR_ORPHAN_11 = 11; +SET @TEXT_WOLVAR_ORPHAN_12 = 12; +SET @TEXT_WOLVAR_ORPHAN_13 = 13; + +UPDATE `creature_template` SET `AIName`='SmartAI',`ScriptName`='' WHERE `entry`=33532; + +DELETE FROM `smart_scripts` WHERE `entryorguid`=33532 AND `source_type`=0; +INSERT INTO `smart_scripts`(`entryorguid`,`event_type`,`event_param1`,`action_type`,`action_param1`,`target_type`,`comment`) VALUES +(33532,8,65357,33,36209,7,'Wolvar Orphan - On spellhit - Give quest credit'); + +DELETE FROM `creature_text` WHERE `entry`=33532; +INSERT INTO `creature_text`(`entry`,`groupid`,`text`,`type`,`emote`) VALUE +(33532,@TEXT_WOLVAR_ORPHAN_1,"Look!",12,0), +(33532,@TEXT_WOLVAR_ORPHAN_2,"Got you back!",12,0), +(33532,@TEXT_WOLVAR_ORPHAN_3,"Good snowball fight!",12,0), +(33532,@TEXT_WOLVAR_ORPHAN_4,"Look! That must be Kekek as a mighty warrior! See? What Kekek tell you?",12,0), +(33532,@TEXT_WOLVAR_ORPHAN_5,"Hmm... that Kekek very old. Must be elder, leader of Frenzyheart. This good. Kekek have good future as warrior and leader. Kekek very happy you bring him here. Orphan-lady never do that for Kekek.",12,0), +(33532,@TEXT_WOLVAR_ORPHAN_6,"Wow. At last, Kekek get to meet Hemet Nesingwary!",12,0), +(33532,@TEXT_WOLVAR_ORPHAN_7,"Even Frenzyheart know all about you after you come to Sholazar. Maybe you teach Kekek your tricks?",12,0), +(33532,@TEXT_WOLVAR_ORPHAN_8,"Not sure how reading helps. Kekek can't read anyway, but if Hemet Nesingwary say, Kekek try.",12,0), +(33532,@TEXT_WOLVAR_ORPHAN_9,"Maybe give up and throw book at animals, but try.",12,0), +(33532,@TEXT_WOLVAR_ORPHAN_10,"You think maybe one day, Kekek lead Frenzyheart home, like bear-men fight to get tree-city back? Kekek want own home, not city with purple men, not jungle with big-tongues.",12,0), +(33532,@TEXT_WOLVAR_ORPHAN_11,"Kekek thought we go see dragon queen. This just some elf-lady with funny horns.",12,0), +(33532,@TEXT_WOLVAR_ORPHAN_12,"But why? Dragons big and powerful. Elf-lady weak. Kekek want to see dragon queen's real form.",12,0), +(33532,@TEXT_WOLVAR_ORPHAN_13,"Oh! Now Kekek understand. Not want to be crushed by big dragon-lady. Maybe come back sometime when not so crowded. Nice to meet you, dragon-lady.",12,0); + +DELETE FROM `game_event_creature_quest` WHERE `id`=33532; +INSERT INTO `game_event_creature_quest`(`eventEntry`,`id`,`quest`) VALUES +(10,33532,13938), +(10,33532,13960), +(10,33532,13930), +(10,33532,13951), +(10,33532,13934), +(10,33532,13955), +(10,33532,13957); + +DELETE FROM `creature_involvedrelation` WHERE `id`=33532; +INSERT INTO `creature_involvedrelation`(`id`,`quest`) VALUES +(33532,13938), +(33532,13930), +(33532,13927), +(33532,13951), +(33532,13934), +(33532,13955), +(33532,13957); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (19,20) AND `SourceEntry` IN (13955,13957,13938); +INSERT INTO `conditions`(`SourceTypeOrReferenceId`,`SourceEntry`,`ConditionTypeOrReference`,`ConditionValue1`,`comment`) VALUES +(19,13955,8,13930,'Accept quest 13955 - Quest 13930 needs to be rewarded'), +(19,13955,8,13934,'Accept quest 13955 - Quest 13934 needs to be rewarded'), +(19,13955,8,13951,'Accept quest 13955 - Quest 13951 needs to be rewarded'), +(19,13957,8,13930,'Accept quest 13957 - Quest 13930 needs to be rewarded'), +(19,13957,8,13934,'Accept quest 13957 - Quest 13934 needs to be rewarded'), +(19,13957,8,13951,'Accept quest 13957 - Quest 13951 needs to be rewarded'), +(19,13938,8,13957,'Accept quest 13938 - Quest 13957 needs to be rewarded'), +(20,13955,8,13930,'Show quest mark 13955 - Quest 13930 needs to be rewarded'), +(20,13955,8,13934,'Show quest mark 13955 - Quest 13934 needs to be rewarded'), +(20,13955,8,13951,'Show quest mark 13955 - Quest 13951 needs to be rewarded'), +(20,13957,8,13930,'Show quest mark 13957 - Quest 13930 needs to be rewarded'), +(20,13957,8,13934,'Show quest mark 13957 - Quest 13934 needs to be rewarded'), +(20,13957,8,13951,'Show quest mark 13957 - Quest 13951 needs to be rewarded'), +(20,13938,8,13957,'Show quest mark 13938 - Quest 13957 needs to be rewarded'); + +-- Blood Elf Orphan +UPDATE `quest_template` SET `SpecialFlags`=`SpecialFlags`|2 WHERE `Id` IN (10945,10953,10951,10963); + +DELETE FROM `game_event_creature_quest` WHERE `id`=22817; +INSERT INTO `game_event_creature_quest`(`eventEntry`,`id`,`quest`) VALUES +(10,22817,10945), +(10,22817,10953), +(10,22817,10951), +(10,22817,10963), +(10,22817,11975), +(10,22817,10967); + +DELETE FROM `creature_involvedrelation` WHERE `id`=22817; +INSERT INTO `creature_involvedrelation`(`id`,`quest`) VALUES +(22817,10942), +(22817,10951), +(22817,11975), +(22817,10963); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (19,20) AND `SourceEntry` IN (11975,10963,10967); +INSERT INTO `conditions`(`SourceTypeOrReferenceId`,`SourceEntry`,`ConditionTypeOrReference`,`ConditionValue1`,`comment`) VALUES +(19,11975,8,10945,'Accept quest 11975 - Quest 10945 needs to be rewarded'), +(19,11975,8,10953,'Accept quest 11975 - Quest 10953 needs to be rewarded'), +(19,11975,8,10951,'Accept quest 11975 - Quest 10951 needs to be rewarded'), +(19,10963,8,10945,'Accept quest 10963 - Quest 10945 needs to be rewarded'), +(19,10963,8,10953,'Accept quest 10963 - Quest 10953 needs to be rewarded'), +(19,10963,8,10951,'Accept quest 10963 - Quest 10951 needs to be rewarded'), +(19,10967,8,10963,'Accept quest 10967 - Quest 10963 needs to be rewarded'), +(20,11975,8,10945,'Show quest mark 11975 - Quest 10945 needs to be rewarded'), +(20,11975,8,10953,'Show quest mark 11975 - Quest 10953 needs to be rewarded'), +(20,11975,8,10951,'Show quest mark 11975 - Quest 10951 needs to be rewarded'), +(20,10963,8,10945,'Show quest mark 10963 - Quest 10945 needs to be rewarded'), +(20,10963,8,10953,'Show quest mark 10963 - Quest 10953 needs to be rewarded'), +(20,10963,8,10951,'Show quest mark 10963 - Quest 10951 needs to be rewarded'), +(20,10967,8,10963,'Show quest mark 10967 - Quest 10963 needs to be rewarded'); + +-- Draenei Orphan +UPDATE `quest_template` SET `SpecialFlags`=`SpecialFlags`|2 WHERE `Id` IN (10956,10968,10950,10952,10954,10962); + +DELETE FROM `game_event_creature_quest` WHERE `id`=22818; +INSERT INTO `game_event_creature_quest`(`eventEntry`,`id`,`quest`) VALUES +(10,22818,10952), +(10,22818,10950), +(10,22818,10966), +(10,22818,10954), +(10,22818,10956), +(10,22818,10962); + +DELETE FROM `creature_involvedrelation` WHERE `id`=22818; +INSERT INTO `creature_involvedrelation`(`id`,`quest`) VALUES +(22818,10950), +(22818,10952), +(22818,10943), +(22818,10962); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (19,20) AND `SourceEntry` IN (10956,10962,10966); +INSERT INTO `conditions`(`SourceTypeOrReferenceId`,`SourceEntry`,`ConditionTypeOrReference`,`ConditionValue1`,`comment`) VALUES +(19,10956,8,10950,'Accept quest 10956 - Quest 10950 needs to be rewarded'), +(19,10956,8,10954,'Accept quest 10956 - Quest 10954 needs to be rewarded'), +(19,10956,8,10952,'Accept quest 10956 - Quest 10952 needs to be rewarded'), +(19,10962,8,10950,'Accept quest 10962 - Quest 10950 needs to be rewarded'), +(19,10962,8,10954,'Accept quest 10962 - Quest 10954 needs to be rewarded'), +(19,10962,8,10952,'Accept quest 10962 - Quest 10952 needs to be rewarded'), +(19,10966,8,10962,'Accept quest 10966 - Quest 10962 needs to be rewarded'), +(20,10956,8,10950,'Show quest mark 10956 - Quest 10950 needs to be rewarded'), +(20,10956,8,10954,'Show quest mark 10956 - Quest 10954 needs to be rewarded'), +(20,10956,8,10952,'Show quest mark 10956 - Quest 10952 needs to be rewarded'), +(20,10962,8,10950,'Show quest mark 10962 - Quest 10950 needs to be rewarded'), +(20,10962,8,10954,'Show quest mark 10962 - Quest 10954 needs to be rewarded'), +(20,10962,8,10952,'Show quest mark 10962 - Quest 10952 needs to be rewarded'), +(20,10966,8,10962,'Show quest mark 10966 - Quest 10962 needs to be rewarded'); + +-- Human Orphan +DELETE FROM `creature_questrelation` WHERE `id`=14305; + +DELETE FROM `game_event_creature_quest` WHERE `id`=14305; +INSERT INTO `game_event_creature_quest`(`eventEntry`,`id`,`quest`) VALUES +(10,14305,171), +(10,14305,558), +(10,14305,1687), +(10,14305,1479), +(10,14305,1558), +(10,14305,4822); + +DELETE FROM `creature_involvedrelation` WHERE `id`=14305; +INSERT INTO `creature_involvedrelation`(`id`,`quest`) VALUES +(14305,1468), +(14305,558), +(14305,1687), +(14305,1479), +(14305,1558), +(14305,4822); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (19,20) AND `SourceEntry` IN (558,4822,171); +INSERT INTO `conditions`(`SourceTypeOrReferenceId`,`SourceEntry`,`ConditionTypeOrReference`,`ConditionValue1`,`comment`) VALUES +(19,558,8,1687,'Accept quest 558 - Quest 1687 needs to be rewarded'), +(19,558,8,1558,'Accept quest 558 - Quest 1558 needs to be rewarded'), +(19,558,8,1479,'Accept quest 558 - Quest 1479 needs to be rewarded'), +(19,558,16,1101,'Accept quest 558 - Needs to be in race mask 1101'), +(19,4822,8,1687,'Accept quest 4822 - Quest 1687 needs to be rewarded'), +(19,4822,8,1558,'Accept quest 4822 - Quest 1558 needs to be rewarded'), +(19,4822,8,1479,'Accept quest 4822 - Quest 1479 needs to be rewarded'), +(19,171,8,4822,'Accept quest 171 - Quest 4822 needs to be rewarded'), +(20,558,8,1687,'Show quest mark 558 - Quest 1687 needs to be rewarded'), +(20,558,8,1558,'Show quest mark 558 - Quest 1558 needs to be rewarded'), +(20,558,8,1479,'Show quest mark 558 - Quest 1479 needs to be rewarded'), +(20,558,16,1101,'Show quest mark 558 - Needs to be in race mask 1101'), +(20,4822,8,1687,'Show quest mark 4822 - Quest 1687 needs to be rewarded'), +(20,4822,8,1558,'Show quest mark 4822 - Quest 1558 needs to be rewarded'), +(20,4822,8,1479,'Show quest mark 4822 - Quest 1479 needs to be rewarded'), +(20,171,8,4822,'Show quest mark 171 - Quest 4822 needs to be rewarded'); + +-- Orcish Orphan +DELETE FROM `creature_questrelation` WHERE `id`=14444; + +DELETE FROM `game_event_creature_quest` WHERE `id`=14444; +INSERT INTO `game_event_creature_quest`(`eventEntry`,`id`,`quest`) VALUES +(10,14444,910), +(10,14444,911), +(10,14444,1800), +(10,14444,925), +(10,14444,915), +(10,14444,5502); + +DELETE FROM `creature_involvedrelation` WHERE `id`=14444; +INSERT INTO `creature_involvedrelation`(`id`,`quest`) VALUES +(14444,925), +(14444,172), +(14444,910), +(14444,911), +(14444,1800), +(14444,915); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (19,20) AND `SourceEntry` IN (915,925,5502); +INSERT INTO `conditions`(`SourceTypeOrReferenceId`,`SourceEntry`,`ConditionTypeOrReference`,`ConditionValue1`,`comment`) VALUES +(19,925,8,910,'Accept quest 925 - Quest 910 needs to be rewarded'), +(19,925,8,911,'Accept quest 925 - Quest 911 needs to be rewarded'), +(19,925,8,1800,'Accept quest 925 - Quest 1800 needs to be rewarded'), +(19,915,8,910,'Accept quest 915 - Quest 910 needs to be rewarded'), +(19,915,8,911,'Accept quest 915 - Quest 911 needs to be rewarded'), +(19,915,8,1800,'Accept quest 915 - Quest 1800 needs to be rewarded'), +(19,5502,8,925,'Accept quest 5502 - Quest 925 needs to be rewarded'), +(20,925,8,910,'Show quest mark 925 - Quest 910 needs to be rewarded'), +(20,925,8,911,'Show quest mark 925 - Quest 911 needs to be rewarded'), +(20,925,8,1800,'Show quest mark 925 - Quest 1800 needs to be rewarded'), +(20,915,8,910,'Show quest mark 915 - Quest 910 needs to be rewarded'), +(20,915,8,911,'Show quest mark 915 - Quest 911 needs to be rewarded'), +(20,915,8,1800,'Show quest mark 915 - Quest 1800 needs to be rewarded'), +(20,5502,8,925,'Show quest mark 5502 - Quest 925 needs to be rewarded'); + +-- Home of the bear-men +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; + +DELETE FROM `creature` WHERE `guid` IN (@GUID_GRIZZLEMAW_TRIGGER_1,@GUID_GRIZZLEMAW_TRIGGER_2,@GUID_GRIZZLEMAW_TRIGGER_3); +INSERT INTO `creature`(`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`) VALUES +(@GUID_GRIZZLEMAW_TRIGGER_1,36209,571,4068.82,-3811,223.4), +(@GUID_GRIZZLEMAW_TRIGGER_2,36209,571,4073.2,-3734.354,222.6634), +(@GUID_GRIZZLEMAW_TRIGGER_3,36209,571,3923.109,-3763.967,165.362); + +-- Elder Kekek +SET @GUID_KEKEK = @GUIDS + 3; +SET @TEXT_ELDER_KEKEK_1 = 1; + +UPDATE `creature_template` SET `ScriptName`='npc_elder_kekek' WHERE `entry`=34387; + +DELETE FROM `creature` WHERE `guid`=@GUID_KEKEK OR `id`=34387; +INSERT INTO `creature`(`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`) VALUES +(@GUID_KEKEK,34387,571,4181.482,-461.453,120.728,1.398097); + +DELETE FROM `creature_text` WHERE `entry`=34387; +INSERT INTO `creature_text`(`entry`,`groupid`,`text`,`type`,`emote`) VALUE +(34387,@TEXT_ELDER_KEKEK_1,"No worry, Kekek. You grow up, be strong for Frenzyheart. You lead people back to old home, where there no big-tongue babies.",12,0); + +-- Alexstraza +SET @TEXT_ALEXSTRASZA_2 = 2; +SET @TEXT_KRASUS_8 = 8; + +UPDATE `creature_template` SET `AIName`='',`ScriptName`='npc_alexstraza_the_lifebinder' WHERE `entry`=26917; + +DELETE FROM `creature_text` WHERE (`entry`=26917 AND `groupid`=@TEXT_ALEXSTRASZA_2) OR (`entry`=27990 AND `groupid`=@TEXT_KRASUS_8); +INSERT INTO `creature_text`(`entry`,`groupid`,`text`,`type`,`emote`) VALUE +(26917,@TEXT_ALEXSTRASZA_2,"If I was in my dragon form, there wouldn't be any room for anyone else, little one.",12,0), +(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 = @GUIDS + 4; +SET @TEXT_SOO_ROO_1 = 1; + +UPDATE `creature_template` SET `AIName`='',`ScriptName`='npc_high_oracle_soo_roo' WHERE `entry`=34386; + +DELETE FROM `creature_text` WHERE `entry`=34386; +INSERT INTO `creature_text`(`entry`,`groupid`,`text`,`type`,`emote`) VALUE +(34386,@TEXT_SOO_ROO_1,"We remember this visit, yes we do. Never forget what you learn from your new friend, little Roo. You got great future ahead.",12,0); + +DELETE FROM `creature` WHERE `guid`=@GUID_SOO_ROO OR `id`=34386; +INSERT INTO `creature`(`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`) VALUES +(@GUID_SOO_ROO,34386,571,4120.996,-329.486,121.443817,0.299253); + +-- Nesingwary +SET @TEXT_NESINGWARY_1 = 1; + +DELETE FROM `creature_text` WHERE `entry`=27986; +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 = @GUIDS + 5; +SET @TEXT_SNOWFALL_GLADE_PLAYMATE_1 = 1; +SET @TEXT_SNOWFALL_GLADE_PLAYMATE_2 = 2; + +UPDATE `creature_template` SET `AIName`='',`ScriptName`='npc_snowfall_glade_playmate' WHERE `entry`=34490; + +DELETE FROM `creature_text` WHERE `entry`=34490; +INSERT INTO `creature_text`(`entry`,`groupid`,`text`,`type`,`emote`) VALUE +(34490,@TEXT_SNOWFALL_GLADE_PLAYMATE_1,"Better watch out!",12,0), +(34490,@TEXT_SNOWFALL_GLADE_PLAYMATE_2,"Got you good!",12,0); + +DELETE FROM `creature` WHERE `guid`=@GUID_SNOWFALL_GLADE_PLAYMATE OR `id`=34490; +INSERT INTO `creature`(`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`) VALUES +(@GUID_SNOWFALL_GLADE_PLAYMATE,34490,571,3325.193,1026.451,138.1712,2.062184); + +-- Winterfin Playmate +SET @GUID_WINTERFIN_PLAYMATE = @GUIDS + 6; +SET @TEXT_WINTERFIN_PLAYMATE_1 = 1; +SET @TEXT_WINTERFIN_PLAYMATE_2 = 2; + +UPDATE `creature_template` SET `AIName`='',`ScriptName`='npc_winterfin_playmate' WHERE `entry`=34489; + +DELETE FROM `creature_text` WHERE `entry`=34489; +INSERT INTO `creature_text`(`entry`,`groupid`,`text`,`type`,`emote`) VALUE +(34489,@TEXT_WINTERFIN_PLAYMATE_1,"Wanna see what I can do?",12,0), +(34489,@TEXT_WINTERFIN_PLAYMATE_2,"Now dance together!",12,0); + +DELETE FROM `creature` WHERE `guid`=@GUID_WINTERFIN_PLAYMATE OR `id`=34489; +INSERT INTO `creature`(`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`) VALUES +(@GUID_WINTERFIN_PLAYMATE,34489,571,4382.502,6066.199,0.724562,3.571894); + +-- Biggest Tree Ever +SET @GUID_BIGGEST_TREE_TRIGGER = @GUIDS + 7; + +UPDATE `creature_template` SET `AIName`='',`ScriptName`='npc_the_biggest_tree',`flags_extra`=0 WHERE `entry`=34381; + +DELETE FROM `creature` WHERE `guid`=@GUID_BIGGEST_TREE_TRIGGER OR `id`=34381; +INSERT INTO `creature`(`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`) VALUES +(@GUID_BIGGEST_TREE_TRIGGER,34381,571,4022.666,-3777.682,115.443588,4.857019); + +-- Meeting A Great One +UPDATE `creature_template` SET `ScriptName`='npc_the_etymidian' WHERE `entry`=28092; + +-- POIs +DELETE FROM `quest_poi` WHERE `questId` IN (13956,13929,13950,13951,13957,13933,13934,13930,13954,13955); +INSERT INTO `quest_poi`(`questId`,`objIndex`,`mapid`,`WorldMapAreaId`,`unk4`) VALUES +(13956,16,1,201,3), +(13929,16,571,490,3), +(13950,16,571,486,3), +(13951,16,571,488,3), +(13957,16,571,493,3), +(13933,16,571,488,3), +(13934,16,571,488,3), +(13930,16,571,490,3), +(13954,16,571,488,3), +(13955,16,571,488,3); + +DELETE FROM `quest_poi_points` WHERE `questid` IN (13956,13929,13950,13951,13957,13933,13934,13930,13954,13955); +INSERT INTO `quest_poi_points`(`questId`,`x`,`y`) VALUES +(13956,-6193,-1223), +(13929,4022,-3777), +(13950,4382,6066), +(13951,3325,1026), +(13957,5584,5748), +(13933,4121,-329), +(13934,4181,-461), +(13930,4071,-3773), +(13954,3530,271), +(13955,3530,271); + +-- NPC areatriggers +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); + +DELETE FROM `creature` WHERE `guid` IN (@GUID_SILVERMOON_TRIGGER_01,@GUID_AERIS_LANDING_TRIGGER,@GUID_AUCHINDOUN_TRIGGER,@GUID_SPOREGGAR_TRIGGER,@GUID_THRONE_OF_ELEMENTS_TRIGGER); +INSERT INTO `creature`(`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`) VALUES +(@GUID_AERIS_LANDING_TRIGGER,22838,530,-2075.759,8559.336,23.027,4.857019), +(@GUID_SILVERMOON_TRIGGER_01,22866,530,9506.086,-7329.313,14.397272,0), +(@GUID_AUCHINDOUN_TRIGGER,22831,530,-3320.860,4925.095,-101.1,0), +(@GUID_SPOREGGAR_TRIGGER,22829,530,203.587,8550.11,22.3256,0), +(@GUID_THRONE_OF_ELEMENTS_TRIGGER,22839,530,-781.294,6943.52,33.3344,0); + +-- Misc +DELETE `game_event_creature` FROM `game_event_creature` INNER JOIN `creature` ON `creature`.`guid`=`game_event_creature`.`guid` +WHERE `id` IN (22905,22851,22838,22866,22831,22829,22872,22839,14450,22819,14451,34365,34387,34386,34490,34489,34381,36209); +INSERT INTO `game_event_creature`(`eventEntry`,`guid`) SELECT 10,`guid` FROM `creature` +WHERE `id` IN (22905,22851,22838,22866,22831,22829,22872,22839,14450,22819,14451,34365,34387,34386,34490,34489,34381,36209); + +DELETE FROM `game_event_npc_vendor` WHERE `eventEntry`=10 AND `item`=46693; +INSERT INTO `game_event_npc_vendor` (`eventEntry`, `guid`, `item`) VALUES +(10,99369,46693), +(10,97984,46693); + +UPDATE `item_template` SET `minMoneyLoot`=50000,`maxMoneyLoot`=50000 WHERE `entry`=23022; +UPDATE `item_template` SET `HolidayId`=201 WHERE `entry` IN (46396,46397,31880,31881,18598,18597); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=17 AND `SourceEntry` IN (23012,23013,39478,39479,65352,65353); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ErrorTextId`,`Comment`) VALUES +(17,0,23012,0,12,10,0,"Orphan Whistle only while children's week"), +(17,0,23013,0,12,10,0,"Orphan Whistle only while children's week"), +(17,0,39478,0,12,10,0,"Orphan Whistle only while children's week"), +(17,0,39479,0,12,10,0,"Orphan Whistle only while children's week"), +(17,0,65352,0,12,10,0,"Orphan Whistle only while children's week"), +(17,0,65353,0,12,10,0,"Orphan Whistle only while children's week"); + +UPDATE `quest_poi_points` SET `x`=1642,`y`=239 WHERE `questId`=1800 AND `id`=0 AND `idx`=0; +UPDATE `quest_poi_points` SET `x`=-248,`y`=956 WHERE `questId`=10952 AND `id`=0 AND `idx`=0; +UPDATE `quest_poi_points` SET `x`=-11400.211,`y`=1944.599 WHERE `questId`=1687 AND `id`=0 AND `idx`=0; +UPDATE `quest_poi_points` SET `x`=-998.183,`y`=-3822.07 WHERE `questId`=910 AND `id`=0 AND `idx`=0; +UPDATE `quest_poi_points` SET `x`=1260.812,`y`=-2223.765 WHERE `questId`=911 AND `id`=0 AND `idx`=0; +UPDATE `quest_poi_points` SET `x`=9933,`y`=2500 WHERE `questId`=1479 AND `id`=0 AND `idx`=0; +UPDATE `quest_poi_points` SET `x`=-2075.759,`y`=8559.336 WHERE `questId`=10954 AND `id`=0 AND `idx`=0; +UPDATE `quest_poi_points` SET `x`=9506,`y`=-7329 WHERE `questId`=11975 AND `id`=0 AND `idx`=0; +UPDATE `quest_poi_points` SET `x`=-3320.860,`y`=4925.095 WHERE `questId`=10950 AND `id`=0 AND `idx`=0; +UPDATE `quest_poi_points` SET `x`=203.587,`y`=8550.11 WHERE `questId`=10945 AND `id`=0 AND `idx`=0; +UPDATE `quest_poi_points` SET `x`=-781.294,`y`=6943.52 WHERE `questId`=10953 AND `id`=0 AND `idx`=0; -- cgit v1.2.3 From ebdbe869afa6ebe1c5c7805c9a68c47928cf9e9a Mon Sep 17 00:00:00 2001 From: Subv Date: Thu, 25 Oct 2012 10:54:22 -0500 Subject: Core/SQL: Changed codification of recent SQL file to ANSI --- sql/updates/world/2012_10_25_00_world_childrens_week.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'sql') diff --git a/sql/updates/world/2012_10_25_00_world_childrens_week.sql b/sql/updates/world/2012_10_25_00_world_childrens_week.sql index 33ad3c54ad1..e2d6eec4dd2 100644 --- a/sql/updates/world/2012_10_25_00_world_childrens_week.sql +++ b/sql/updates/world/2012_10_25_00_world_childrens_week.sql @@ -1,4 +1,4 @@ --- Orphan Matron Aria +-- Orphan Matron Aria UPDATE `creature_template` SET `AIName`='SmartAI',`ScriptName`='' WHERE `entry`=34365; DELETE FROM `smart_scripts` WHERE `entryorguid`=34365 AND `source_type`=0; -- cgit v1.2.3 From 14c0d7b4219ce1a31f43f18b07bfb86d1089a337 Mon Sep 17 00:00:00 2001 From: w1sht0l1v3 Date: Fri, 26 Oct 2012 22:27:16 +0300 Subject: Scripts/SAI: Fix an assert error. Closes #8106 --- sql/updates/world/2012_10_26_00_world_sai.sql | 1 + 1 file changed, 1 insertion(+) create mode 100644 sql/updates/world/2012_10_26_00_world_sai.sql (limited to 'sql') diff --git a/sql/updates/world/2012_10_26_00_world_sai.sql b/sql/updates/world/2012_10_26_00_world_sai.sql new file mode 100644 index 00000000000..8e4c2fa0922 --- /dev/null +++ b/sql/updates/world/2012_10_26_00_world_sai.sql @@ -0,0 +1 @@ +UPDATE `smart_scripts` SET `action_param3`=3500,`action_param4`=6000 WHERE `entryorguid`=9458 AND `source_type`=0 AND `id`=0; -- cgit v1.2.3 From d180478596b3c981f19fe2efa6d46ee6dae53a47 Mon Sep 17 00:00:00 2001 From: Pitcrawler Date: Sat, 27 Oct 2012 09:42:16 +0200 Subject: DB/Creatures: Correct movement for Dragonbone Condor, Carrion Condor and Courier Lanson Closes #8145,#8139,#8128 --- sql/updates/world/2012_10_27_00_world_creature.sql | 13 +++++++++++++ 1 file changed, 13 insertions(+) create mode 100644 sql/updates/world/2012_10_27_00_world_creature.sql (limited to 'sql') diff --git a/sql/updates/world/2012_10_27_00_world_creature.sql b/sql/updates/world/2012_10_27_00_world_creature.sql new file mode 100644 index 00000000000..c00c450aeca --- /dev/null +++ b/sql/updates/world/2012_10_27_00_world_creature.sql @@ -0,0 +1,13 @@ +-- Dragonbone Condor +UPDATE `creature` SET `spawndist`=0, `MovementType`=0 WHERE `guid` IN (106595,106596,106597,106598,106603,106604,106605,106607,106608,106626,106629,106631,106643,106646,106658,106663,106665,106668,106669,106675,106676,106679,106680,106681,106682,106683,106684,106685,106686,106687,106688,106692,106693,106696,106702,106703,106706,106722,106723,106724,106726,106727,106728,106733,106737,106741,106749,106755,106757,131072); +UPDATE `creature` SET `position_z`=72.130 WHERE `guid`=106631; +UPDATE `creature` SET `position_z`=72.902 WHERE `guid`=106675; +UPDATE `creature` SET `position_z`=69.505 WHERE `guid`=131072; +/* Carrion Condor + * All these have unitfieldbyte1=1 which means sitting. Obviously that makes no sense when they are moving randomly within their spawndist. They should be sitting on the pillars in Borean Tundra. + * There are some that are spawned very close to dead Taunka. From retail I know they should be flying directly on top of them not moving so I changed them, too. */ +UPDATE `creature` SET `spawndist`=0, `MovementType`=0 WHERE `guid` IN (101804,101805,101806,101807,101808,101809,101810,101814,101815,101818,101819,101820,101823,101824,101825,101832,101834,101836,101837,101838,101839,101842,101845,101849,101850,101856,101859,101860,101862,101866,101872,101876,101877,101890,101921,101923); +-- Courier Lanson: The npc should be sleeping on the bed instead of just standing there. +DELETE FROM `creature_template_addon` WHERE `entry`=27060; +INSERT INTO `creature_template_addon` (`entry`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES +(27060,0,0,3,0,0,''); -- cgit v1.2.3 From 57f84c920b17e7a2d788626d7d745d36c0618c72 Mon Sep 17 00:00:00 2001 From: ZxBiohazardZx Date: Sat, 27 Oct 2012 10:44:49 +0200 Subject: DB/Conditions: slightly modify the conditions for Sealed Chest: it only drops IF: you dont have it already AND you are wielding Shadowmourne AND you are on The Lich Kings Last Stand AND if you did not do Personal Property quest yet Closes #8167 --- .../2012_10_27_01_world_creature_loot_template.sql | 22 ++++++++++++++++++++++ 1 file changed, 22 insertions(+) create mode 100644 sql/updates/world/2012_10_27_01_world_creature_loot_template.sql (limited to 'sql') diff --git a/sql/updates/world/2012_10_27_01_world_creature_loot_template.sql b/sql/updates/world/2012_10_27_01_world_creature_loot_template.sql new file mode 100644 index 00000000000..3367dbf0fa8 --- /dev/null +++ b/sql/updates/world/2012_10_27_01_world_creature_loot_template.sql @@ -0,0 +1,22 @@ +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=1 AND `SourceEntry`=51315; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorTextId`,`Scriptname`,`Comment`) VALUES +-- Lich King 10N +(1,36597,51315,0,1,2,0,51315,1,1,1,0 ,'' , 'Sealed Chest will drop only if the player doesn''t have it already'), +(1,36597,51315,0,1,3,0,49623,1,1,1,0 ,'' , 'Sealed Chest will drop only if the player is wielding Shadowmourne'), +(1,36597,51315,0,1,9,0,24748,0,0,0,0 ,'' , 'Sealed Chest will drop only if the player has "The Lich King''s Last Stand" in their quest log'), +(1,36597,51315,0,1,14,0,24914,0,0,0,0,'' , 'Sealed Chest will drop only if the player has not completed the quest Personal Property'), +-- Lich King 25N +(1,39166,51315,0,1,2,0,51315,1,1,1,0 ,'' , 'Sealed Chest will drop only if the player doesn''t have it already'), +(1,39166,51315,0,1,3,0,49623,1,1,1,0 ,'' , 'Sealed Chest will drop only if the player is wielding Shadowmourne'), +(1,39166,51315,0,1,9,0,24748,0,0,0,0 ,'' , 'Sealed Chest will drop only if the player has "The Lich King''s Last Stand" in their quest log'), +(1,39166,51315,0,1,14,0,24914,0,0,0,0,'' , 'Sealed Chest will drop only if the player has not completed the quest Personal Property'), +-- Lich King 10H +(1,39167,51315,0,1,2,0,51315,1,1,1,0 ,'' , 'Sealed Chest will drop only if the player doesn''t have it already'), +(1,39167,51315,0,1,3,0,49623,1,1,1,0 ,'' , 'Sealed Chest will drop only if the player is wielding Shadowmourne'), +(1,39167,51315,0,1,9,0,24748,0,0,0,0 ,'' , 'Sealed Chest will drop only if the player has "The Lich King''s Last Stand" in their quest log'), +(1,39167,51315,0,1,14,0,24914,0,0,0,0,'' , 'Sealed Chest will drop only if the player has not completed the quest Personal Property'), +-- Lich King 25H +(1,39168,51315,0,1,2,0,51315,1,1,1,0 ,'' , 'Sealed Chest will drop only if the player doesn''t have it already'), +(1,39168,51315,0,1,3,0,49623,1,1,1,0 ,'' , 'Sealed Chest will drop only if the player is wielding Shadowmourne'), +(1,39168,51315,0,1,9,0,24748,0,0,0,0 ,'' , 'Sealed Chest will drop only if the player has "The Lich King''s Last Stand" in their quest log'), +(1,39168,51315,0,1,14,0,24914,0,0,0,0,'' , 'Sealed Chest will drop only if the player has not completed the quest Personal Property'); -- cgit v1.2.3 From cd8e9dfb5213f6e299065cc1f87535a26c2f2936 Mon Sep 17 00:00:00 2001 From: ZxBiohazardZx Date: Mon, 29 Oct 2012 23:41:10 +0100 Subject: DB/Conditions: update ItemEquipped Condition2/3 values to 0 --- sql/updates/world/2012_10_29_00_world_conditions.sql | 2 ++ 1 file changed, 2 insertions(+) create mode 100644 sql/updates/world/2012_10_29_00_world_conditions.sql (limited to 'sql') diff --git a/sql/updates/world/2012_10_29_00_world_conditions.sql b/sql/updates/world/2012_10_29_00_world_conditions.sql new file mode 100644 index 00000000000..d1fac5361fb --- /dev/null +++ b/sql/updates/world/2012_10_29_00_world_conditions.sql @@ -0,0 +1,2 @@ +-- fix bad condition2/3 values on ItemEquip Conditions +UPDATE `conditions` SET `ConditionValue2`=0,`ConditionValue3`=0 WHERE `ConditionTypeOrReference`=3; -- cgit v1.2.3