diff options
| author | SnapperRy <snapperryen@gmail.com> | 2016-10-27 14:43:40 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2016-10-27 14:43:40 +0200 |
| commit | 3d9fca1e04d1bf580362da221869fc304780916b (patch) | |
| tree | 41804ac54da4b94b908820b29641c4921b332df9 | |
| parent | a056cb2978956046d135579d11cedde0a81d3c9d (diff) | |
DB/SAI: Otonambusi.
| -rw-r--r-- | sql/updates/world/3.3.5/2016_10_27_03_world.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2016_10_27_03_world.sql b/sql/updates/world/3.3.5/2016_10_27_03_world.sql new file mode 100644 index 00000000000..9f793145936 --- /dev/null +++ b/sql/updates/world/3.3.5/2016_10_27_03_world.sql @@ -0,0 +1,10 @@ +-- +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=18810; +DELETE FROM `smart_scripts` WHERE `entryorguid`=18810; +INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(18810, 0, 0, 0, 1, 0, 100, 0, 120000, 240000, 300000, 420000, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Otonambusi - Out of Combat - Talk 0"); + +DELETE FROM `creature_text` WHERE `entry`=18810; +INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES +(18810, 0, 0, "How can you have any pudding if you don't eat your fish?", 12, 7, 100, 5, 0, 0, 15941, 0, "Otonambusi"), +(18810, 0, 1, "If you don't eat your fish, you can't have any pudding!", 12, 7, 100, 5, 0, 0, 15942, 0, "Otonambusi"); |
