diff options
| author | Ander <cooler19860212@yahoo.com> | 2016-10-08 23:23:24 +0300 |
|---|---|---|
| committer | Shin <borzifrancesco@gmail.com> | 2016-10-08 22:23:24 +0200 |
| commit | c15d2b4e19596d5e05ef9aba13626a4b21688c01 (patch) | |
| tree | c7189e402206e6cbcb320dec4f1fbd68a64c9ca5 /data | |
| parent | baa148b2b129db44f024f1e42e93333433457cf4 (diff) | |
I close issue 119 (#170)
* close https://github.com/azerothcore/azerothcore-wotlk/issues/119
* I close issue https://github.com/azerothcore/azerothcore-wotlk/issues/119
* Should be fixed now
* Deleted unused
Diffstat (limited to 'data')
| -rw-r--r-- | data/sql/updates/pending_db_world/rev_1475785264262766400.sql | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/data/sql/updates/pending_db_world/rev_1475785264262766400.sql b/data/sql/updates/pending_db_world/rev_1475785264262766400.sql new file mode 100644 index 0000000000..5c5bea3387 --- /dev/null +++ b/data/sql/updates/pending_db_world/rev_1475785264262766400.sql @@ -0,0 +1,15 @@ +INSERT INTO version_db_world(`sql_rev`) VALUES ('1475785264262766400'); +-- Winterfin Oracle +SET @ENTRY := 25216; +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@ENTRY; +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 +(@ENTRY,0,0,0,0,0,100,0,0,0,3400,4700,11,9532,64,0,0,0,0,2,0,0,0,0,0,0,0,'Cast bolt'), +(@ENTRY,0,1,2,2,0,100,1,0,15,0,0,25,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Flee at 15% HP'), +(@ENTRY,0,2,0,61,0,100,1,0,15,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Say Text at 15% HP'), +(@ENTRY,0,3,0,9,0,100,0,0,5,12300,19800,11,50272,0,0,0,0,0,1,0,0,0,0,0,0,0,'Cast Unstable Magic on Close'); +-- NPC talk text insert +SET @ENTRY := 25216; +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, '%s attempts to run away in fear!',16,0,100,0,0,0, 'combat Flee'); |