SQL: Missing change in 4aaf4245646e4f117cb2de7855b5672ce2fff14f
authorjoschiwald <joschiwald.trinity@gmail.com>
Sat, 21 Apr 2018 11:54:23 +0000 (13:54 +0200)
committerjoschiwald <joschiwald.trinity@gmail.com>
Sat, 21 Apr 2018 11:54:23 +0000 (13:54 +0200)
sql/updates/world/master/2018_04_21_00_world_2016_12_09_03_world_335.sql [moved from sql/updates/world/3.3.5/2016_12_09_03_world_335.sql with 94% similarity]

similarity index 94%
rename from sql/updates/world/3.3.5/2016_12_09_03_world_335.sql
rename to sql/updates/world/master/2018_04_21_00_world_2016_12_09_03_world_335.sql
index ef71ea7ddeae3654ea0f173e24fea9058308a15b..8573650fedbf2f4108608d9009bbcae290f3afe0 100644 (file)
@@ -24,8 +24,8 @@ INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type
 (@ENTRY,9,1,0,0,0,100,0,3000,3000,0,0,19,770,0,0,0,0,0,1,0,0,0,0,0,0,0,"On Script - Remove Flags Not Attackable & Immune To Players & Immune To NPC's"),
 (@ENTRY,9,2,0,0,0,100,0,0,0,0,0,49,0,0,0,0,0,0,21,20,0,0,0,0,0,0,"On Script - Start Attacking");
 
-DELETE FROM `creature_text` WHERE `entry`=23789;
-INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextId`, `comment`) VALUES 
+DELETE FROM `creature_text` WHERE `CreatureID`=23789;
+INSERT INTO `creature_text` (`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextId`, `comment`) VALUES 
 (23789, 0, 0, 'Pitiful mortal, Onyxia answers to no one!', 14, 0, 100, 0, 0, 0, 22285, 'Smolderwing'),
 (23789, 1, 0, 'Your pathetic challenge has not gone unnoticed. I shall enjoy toying with you before you die.', 14, 0, 100, 0, 0, 0, 22286, 'Smolderwing');