From 3351645024ea6bd565c08dd8bbcc7a350b5d9e27 Mon Sep 17 00:00:00 2001 From: ZenoX92 Date: Tue, 26 Sep 2017 12:38:18 +0200 Subject: DB/Creature: More Texts for Ol' Beasley Closes #20433 (cherry picked from commit 948008026239fa25a1b2cc298ef965e69b2db3d4) --- .../world/master/2020_09_12_09_world_2017_09_26_13_world.sql | 8 ++++++++ 1 file changed, 8 insertions(+) create mode 100644 sql/updates/world/master/2020_09_12_09_world_2017_09_26_13_world.sql (limited to 'sql') diff --git a/sql/updates/world/master/2020_09_12_09_world_2017_09_26_13_world.sql b/sql/updates/world/master/2020_09_12_09_world_2017_09_26_13_world.sql new file mode 100644 index 00000000000..dfa45c93a2f --- /dev/null +++ b/sql/updates/world/master/2020_09_12_09_world_2017_09_26_13_world.sql @@ -0,0 +1,8 @@ +-- Ol' Beasley --> Add more texts +DELETE FROM `creature_text` WHERE `CreatureID`=1395 AND `GroupID`=0 AND `ID`>2; +INSERT INTO `creature_text` (`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES +(1395,0,3,"Could ye spare some coin?",12,7,100,0,0,0,179,0,"Ol\' Beasley"), +(1395,0,4,"Help a poor bloke out?",12,7,100,0,0,0,183,0,"Ol\' Beasley"), +(1395,0,5,"Shine yer armor for a copper.",12,7,100,0,0,0,185,0,"Ol\' Beasley"), +(1395,0,6,"It\'s all their fault, stupid orcs. Had to burn my farm to the ground.",12,7,100,0,0,0,187,0,"Ol\' Beasley"), +(1395,0,7,"Alms for the poor?",12,7,100,0,0,0,181,0,"Ol\' Beasley"); -- cgit v1.2.3