diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2017_09_21_01_world_335.sql | 31 |
1 files changed, 31 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2017_09_21_01_world_335.sql b/sql/updates/world/3.3.5/2017_09_21_01_world_335.sql new file mode 100644 index 00000000000..2dfc1941c32 --- /dev/null +++ b/sql/updates/world/3.3.5/2017_09_21_01_world_335.sql @@ -0,0 +1,31 @@ +-- Enticing Negolash +DELETE FROM `smart_scripts` WHERE `entryorguid`=2289 AND `source_type`=1; +DELETE FROM `smart_scripts` WHERE `entryorguid`=1494; +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 +(2289, 1, 0, 1, 20, 0, 100, 0, 619, 0, 0, 0, 50, 2332, 30, 0, 0, 0, 0, 8, 0, 0, 0, -14655.1, 148.229, 3.01744, 3.45635, "Ruined Lifeboat - On Quest 'Enticing Negolash' Finished - Summon GameObject 'Barbequed Buzzard Wings'"), +(2289, 1, 1, 2, 61, 0, 100, 0, 0, 0, 0, 0, 50, 2332, 30, 0, 0, 0, 0, 8, 0, 0, 0, -14655.6, 146.111, 2.29463, 1.43766, "Ruined Lifeboat - On Quest 'Enticing Negolash' Finished - Summon GameObject 'Barbequed Buzzard Wings'"), +(2289, 1, 2, 3, 61, 0, 100, 0, 0, 0, 0, 0, 50, 2332, 30, 0, 0, 0, 0, 8, 0, 0, 0, -14655.1, 147.721, 2.64111, 3.99435, "Ruined Lifeboat - On Quest 'Enticing Negolash' Finished - Summon GameObject 'Barbequed Buzzard Wings'"), +(2289, 1, 3, 4, 61, 0, 100, 0, 0, 0, 0, 0, 50, 2332, 30, 0, 0, 0, 0, 8, 0, 0, 0, -14654.3, 147.015, 2.21427, 2.44821, "Ruined Lifeboat - On Quest 'Enticing Negolash' Finished - Summon GameObject 'Barbequed Buzzard Wings'"), +(2289, 1, 4, 5, 61, 0, 100, 0, 0, 0, 0, 0, 50, 2332, 30, 0, 0, 0, 0, 8, 0, 0, 0, -14655.8, 147.092, 2.36460, 0.66155, "Ruined Lifeboat - On Quest 'Enticing Negolash' Finished - Summon GameObject 'Barbequed Buzzard Wings'"), +(2289, 1, 5, 6, 61, 0, 100, 0, 0, 0, 0, 0, 50, 2332, 30, 0, 0, 0, 0, 8, 0, 0, 0, -14654.3, 147.866, 2.90964, 0.05732, "Ruined Lifeboat - On Quest 'Enticing Negolash' Finished - Summon GameObject 'Barbequed Buzzard Wings'"), +(2289, 1, 6, 7, 61, 0, 100, 0, 0, 0, 0, 0, 50, 2332, 30, 0, 0, 0, 0, 8, 0, 0, 0, -14653.5, 147.004, 2.36253, 2.80556, "Ruined Lifeboat - On Quest 'Enticing Negolash' Finished - Summon GameObject 'Barbequed Buzzard Wings'"), +(2289, 1, 7, 8, 61, 0, 100, 0, 0, 0, 0, 0, 50, 2332, 30, 0, 0, 0, 0, 8, 0, 0, 0, -14652.2, 146.926, 3.63756, 6.06693, "Ruined Lifeboat - On Quest 'Enticing Negolash' Finished - Summon GameObject 'Barbequed Buzzard Wings'"), +(2289, 1, 8, 9, 61, 0, 100, 0, 0, 0, 0, 0, 50, 2332, 30, 0, 0, 0, 0, 8, 0, 0, 0, -14653, 145.274, 2.76439, 6.06279, "Ruined Lifeboat - On Quest 'Enticing Negolash' Finished - Summon GameObject 'Barbequed Buzzard Wings'"), +(2289, 1, 9, 10, 61, 0, 100, 0, 0, 0, 0, 0, 50, 2687, 30, 0, 0, 0, 0, 8, 0, 0, 0, -14653.5, 145.711, 2.01005, 1.14750, "Ruined Lifeboat - On Quest 'Enticing Negolash' Finished - Summon GameObject 'Bottle'"), +(2289, 1, 10, 11, 61, 0, 100, 0, 0, 0, 0, 0, 50, 2687, 30, 0, 0, 0, 0, 8, 0, 0, 0, -14656.7, 147.404, 3.05695, 1.44181, "Ruined Lifeboat - On Quest 'Enticing Negolash' Finished - Summon GameObject 'Bottle'"), +(2289, 1, 11, 12, 61, 0, 100, 0, 0, 0, 0, 0, 50, 2687, 30, 0, 0, 0, 0, 8, 0, 0, 0, -14657.1, 147.068, 2.94368, 1.40036, "Ruined Lifeboat - On Quest 'Enticing Negolash' Finished - Summon GameObject 'Bottle'"), +(2289, 1, 12, 13, 61, 0, 100, 0, 0, 0, 0, 0, 50, 2687, 30, 0, 0, 0, 0, 8, 0, 0, 0, -14657.5, 147.567, 2.83560, 2.14234, "Ruined Lifeboat - On Quest 'Enticing Negolash' Finished - Summon GameObject 'Bottle'"), +(2289, 1, 13, 14, 61, 0, 100, 0, 0, 0, 0, 0, 50, 2687, 30, 0, 0, 0, 0, 8, 0, 0, 0, -14655.9, 148.848, 3.93732, 2.79728, "Ruined Lifeboat - On Quest 'Enticing Negolash' Finished - Summon GameObject 'Bottle'"), +(2289, 1, 14, 15, 61, 0, 100, 0, 0, 0, 0, 0, 50, 2562, 30, 0, 0, 0, 0, 8, 0, 0, 0, -14654.6, 146.299, 2.04134, 5.47387, "Ruined Lifeboat - On Quest 'Enticing Negolash' Finished - Summon GameObject 'Baked Bread'"), +(2289, 1, 15, 16, 61, 0, 100, 0, 0, 0, 0, 0, 50, 2562, 30, 0, 0, 0, 0, 8, 0, 0, 0, -14656.5, 148.372, 3.50805, 5.76817, "Ruined Lifeboat - On Quest 'Enticing Negolash' Finished - Summon GameObject 'Baked Bread'"), +(2289, 1, 16, 17, 61, 0, 100, 0, 0, 0, 0, 0, 50, 2562, 30, 0, 0, 0, 0, 8, 0, 0, 0, -14652.6, 146.079, 3.35855, 2.89231, "Ruined Lifeboat - On Quest 'Enticing Negolash' Finished - Summon GameObject 'Baked Bread'"), +(2289, 1, 17, 0, 61, 0, 100, 0, 0, 0, 0, 0, 12, 1494, 3, 120000, 0, 0, 0, 8, 0, 0, 0, -14611.439453, 113.867699, -6.543651, 1.871764, "Ruined Lifeboat - On Quest 'Enticing Negolash' Finished - Summon Creature 'Negolash'"), +(1494, 0, 0, 1, 63, 0, 100, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Negolash - Just created - Say Line 0 (No Repeat)"), +(1494, 0, 1, 0, 61, 0, 100, 0, 0, 0, 0, 0, 69, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, -14647.526367, 143.710052, 1.164550, 0, "Negolash - Out Of Combat - Move To Position"), +(1494, 0, 2, 0, 7, 0, 100, 0, 0, 0, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Negolash - On evade - despawn"), +(1494, 0, 3, 0, 63, 0, 100, 0, 0, 0, 0, 0, 11, 7095, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Negolash - Just created - Cast Knockdown Proc"); + +UPDATE `gameobject` SET `rotation0`=0.2217236, `rotation1`=0.4712582, `rotation2`=0.8480644, `rotation3`=0.0976788 WHERE `id`=2289; +DELETE FROM `conditions` WHERE `SourceEntry`= 2289 AND `SourceTypeOrReferenceId`=22 AND `SourceId`=1; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(22, 1, 2289, 1, 0, 29, 0, 1494, 100, 0, 1, 0, 0, '', 'Ruined Lifeboat execute SAI if there''s no Negolash around'); |