diff options
| author | Shauren <shauren.trinity@gmail.com> | 2017-11-03 23:30:56 +0100 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2017-11-03 23:30:56 +0100 |
| commit | e64f7a5ed8716b8aecde5cc4c0cd86f0a4d81f36 (patch) | |
| tree | 355764c61cbc747e3ba371bb174be5d0a588cefc | |
| parent | bc974cd2f78f7cd8eda340d89fac557920b0fd76 (diff) | |
Fixed column name
| -rw-r--r-- | sql/updates/world/master/2017_11_03_00_world.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/sql/updates/world/master/2017_11_03_00_world.sql b/sql/updates/world/master/2017_11_03_00_world.sql index f73d74bbf82..d8e9dfa3b3e 100644 --- a/sql/updates/world/master/2017_11_03_00_world.sql +++ b/sql/updates/world/master/2017_11_03_00_world.sql @@ -5,8 +5,8 @@ DELETE FROM `smart_scripts` WHERE `entryorguid`= 42218 AND `action_param1`= 7885 UPDATE `creature` SET `spawndist`= 3 WHERE `guid` IN (279925, 279890, 279892, 279976, 280117); -- Stormwind Infantry and Borhter Paxton Texts -DELETE FROM `creature_text` WHERE `CreatureID` IN (49869, 951); -INSERT INTO `creature_text` (`CreatureID`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextId`, `comment`) VALUES +DELETE FROM `creature_text` WHERE `entry` IN (49869, 951); +INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextId`, `comment`) VALUES (49869, 0, 0, 'I could use a heal, brother!', 12, 0, 100, 0, 0, 0, 49895, 'Stormwind Infantry'), (49869, 0, 1, 'I need a heal!', 12, 0, 100, 0, 0, 0, 49898, 'Stormwind Infantry'), (49869, 0, 2, 'Make yourself useful and heal me, Paxton!', 12, 0, 100, 0, 0, 0, 49896, 'Stormwind Infantry'), |