diff options
| author | Discover- <amort11@hotmail.com> | 2011-10-22 17:33:12 +0100 |
|---|---|---|
| committer | Nay <dnpd.dd@gmail.com> | 2011-10-22 17:33:12 +0100 |
| commit | 8cc675038803737b95b81df3447325739d166497 (patch) | |
| tree | dc7351ff2114d191c64a218eb32545c23ae04cf7 /sql | |
| parent | 6e1107f5fc10bde72119b769166493a8d6492849 (diff) | |
Scripts/Nagrand: Fix quest Finding The Survivors
Closes #442
Closes #3033
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/2011_10_22_16_world_core_script_support.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/sql/updates/world/2011_10_22_16_world_core_script_support.sql b/sql/updates/world/2011_10_22_16_world_core_script_support.sql new file mode 100644 index 00000000000..c6049d49e19 --- /dev/null +++ b/sql/updates/world/2011_10_22_16_world_core_script_support.sql @@ -0,0 +1,10 @@ +SET @ENTRY := 18428; +UPDATE `gameobject_template` SET `ScriptName`='go_warmaul_prison' WHERE `entry` IN (182484,182486,182487,182488,182489,182490,182491,182492,182493,182494,182495,182496,182497,182498,182499,182501,182502,182503,182504); +UPDATE `quest_template` SET `ReqSpellCast1`=0 WHERE `entry`=9948; +DELETE FROM `creature_text` WHERE `entry`=@ENTRY; +INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES +(@ENTRY,0,0,"Death to the ogres!",12,0,100,0,0,0,"Mag'har Prisoner"), +(@ENTRY,1,1,"Many thanks, hero!",12,0,100,0,0,0,"Mag'har Prisoner"), +(@ENTRY,2,2,"One day, a hero will rise and lift the orcs up to their former glory.",12,0,100,0,0,0,"Mag'har Prisoner"), +(@ENTRY,3,3,"Spirits watch over you, $R!",12,0,100,0,0,0,"Mag'har Prisoner"), +(@ENTRY,4,4,"Thank you, $R! Your service to the Mag'har will not be forgotten.",12,0,100,0,0,0,"Mag'har Prisoner"); |