diff options
| author | ZenoX92 <ZenoX92@users.noreply.github.com> | 2018-01-25 14:57:12 +0100 |
|---|---|---|
| committer | tkrokli <tkrokli@gmail.com> | 2018-01-25 14:57:45 +0100 |
| commit | 74f3c08e584007220bb97bc52b5b220a5a196878 (patch) | |
| tree | 09b37649fa4c9d33e1a7cadfa4642bcb7c45159f | |
| parent | 51e28ae76a40bb40bdd6f163773d2e3bd8f76ec4 (diff) | |
DB/Quest: The End of the Deserters (11134) - fix quest credit cast
by ZenoX92
Closes #21293
| -rw-r--r-- | sql/updates/world/3.3.5/2018_01_25_02_world_335.sql | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2018_01_25_02_world_335.sql b/sql/updates/world/3.3.5/2018_01_25_02_world_335.sql new file mode 100644 index 00000000000..e52cd25de07 --- /dev/null +++ b/sql/updates/world/3.3.5/2018_01_25_02_world_335.sql @@ -0,0 +1,12 @@ +-- Gavis Greyshield +DELETE FROM `smart_scripts` WHERE `entryorguid`= 23941 AND `source_type`= 0; +DELETE FROM `smart_scripts` WHERE `entryorguid`= 2394100 AND `source_type`= 9; +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 +(23941, 0,0,0, 2,0,100, 1, 0, 15,0,0, 11, 42660,0,0,0,0,0,1,0,0,0,0,0,0,0,"Gavis Greyshield - Between 0-15% Health - Cast 'Gavis Greyshield Credit' (No Repeat)"), +(23941, 0,1,2, 2,0,100, 1, 0, 15,0,0, 80,2394100,2,0,0,0,0,1,0,0,0,0,0,0,0,"Gavis Greyshield - Between 0-15% Health - Run Script (No Repeat)"), +(23941, 0,2,3,61,0,100,512, 0, 0,0,0, 2, 35,0,0,0,0,0,1,0,0,0,0,0,0,0,"Gavis Greyshield - Between 0-15% Health - Set Faction 35"), +(23941, 0,3,4,61,0,100,512, 0, 0,0,0, 24, 0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Gavis Greyshield - Between 0-15% Health - Evade"), +(23941, 0,4,0,61,0,100,512, 0, 0,0,0,103, 1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Gavis Greyshield - Between 0-15% Health - Set Root On"), +(2394100,9,0,0, 0,0,100, 0, 1000, 1000,0,0, 1, 0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Gavis Greyshield - On Script - Say Line 0"), +(2394100,9,1,0, 0,0,100, 0, 4000, 4000,0,0, 1, 1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Gavis Greyshield - On Script - Say Line 1"), +(2394100,9,2,0, 0,0,100, 0,10000,10000,0,0, 41, 0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Gavis Greyshield - On Script - Despawn"); |