diff options
| author | Discover- <amort11@hotmail.com> | 2011-10-25 23:52:55 +0100 |
|---|---|---|
| committer | kaelima <kaelima@live.se> | 2011-10-25 23:52:55 +0100 |
| commit | 80720358f0c88b0333193c2dbd35d9b2e7feb3ea (patch) | |
| tree | 439cdee709d94eeb874f2354f7f00aa71359cf05 /sql | |
| parent | f958fdf246b16b11103d0b8ce6a9d17909da42a9 (diff) | |
Scripts/Nagrand: Fix creature text of Maghar Prisoner and remove useless RAND() in go_warmaul_prison.
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/2011_10_24_01_world_creature_text.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/sql/updates/world/2011_10_24_01_world_creature_text.sql b/sql/updates/world/2011_10_24_01_world_creature_text.sql new file mode 100644 index 00000000000..a8d4a2f80db --- /dev/null +++ b/sql/updates/world/2011_10_24_01_world_creature_text.sql @@ -0,0 +1,9 @@ +-- Mag'har Prisoner +SET @ENTRY := 18428; +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,0,1,"Many thanks, hero!",12,0,100,0,0,0,"Mag'har Prisoner"), +(@ENTRY,0,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,0,3,"Spirits watch over you, $r!",12,0,100,0,0,0,"Mag'har Prisoner"), +(@ENTRY,0,4,"Thank you, $r! Your service to the Mag'har will not be forgotten.",12,0,100,0,0,0,"Mag'har Prisoner"); |