diff options
| author | Shocker <shocker@freakz.ro> | 2012-01-06 07:55:10 +0200 |
|---|---|---|
| committer | Shocker <shocker@freakz.ro> | 2012-01-06 07:55:10 +0200 |
| commit | 736bf37d044b3d702da964658bac3565e1b5f860 (patch) | |
| tree | 904959daa9236dd11e26317c015d17c371a6a8dc | |
| parent | bad912e69d843135734fca3ec3f753b5c0da6c60 (diff) | |
SQL: Fix an sql error
Closes #4647
| -rw-r--r-- | sql/updates/world/2012_01_04_02_world_sai.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/sql/updates/world/2012_01_04_02_world_sai.sql b/sql/updates/world/2012_01_04_02_world_sai.sql index 5a302205a6d..70cb3fc9a04 100644 --- a/sql/updates/world/2012_01_04_02_world_sai.sql +++ b/sql/updates/world/2012_01_04_02_world_sai.sql @@ -141,8 +141,8 @@ INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type SET @ENTRY := @NPC_WILDSPAWN_HELLCALLER; DELETE FROM `creature_ai_scripts` WHERE `creature_id`=@ENTRY; UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY; -UPDATE creature SET `MovementType`=1,`spawndist`=3 WHERE `id`=@ENTRY -;DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +UPDATE creature SET `MovementType`=1,`spawndist`=3 WHERE `id`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; 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,4,0,100,0,0,0,0,0,21,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Wildspawn Hellcaller - On Aggro - Prevent Combat Movement'), (@ENTRY,0,1,2,4,0,100,0,0,0,0,0,11,15228,0,0,0,0,0,2,0,0,0,0,0,0,0,'Wildspawn Hellcaller - On Aggro - Cast Fireball '),(@ENTRY,0,2,0,61,0,100,0,0,0,0,0,22,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Wildspawn Hellcaller - On Aggro - Set Phase 1'),(@ENTRY,0,3,0,9,1,100,0,0,40,2400,3800,11,15228,0,0,0,0,0,2,0,0,0,0,0,0,0,'Wildspawn Hellcaller - Phase 1 - Cast Fireball'), (@ENTRY,0,4,5,3,1,100,0,0,15,0,0,21,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Wildspawn Hellcaller -In Phase 1 - Start Combat Movement'), |