From 9f89717915c73bde77491b165dadcf4f2bcd7a41 Mon Sep 17 00:00:00 2001 From: Dr-J Date: Tue, 19 Sep 2017 20:02:46 +0100 Subject: DB/Misc: Into the soulgrinder turn in event Script https://youtu.be/R5Wm6Xsxz-M?t=5m40s still seem to be missing a spell here which may still be missing from spell dbc which should have a effect (6 aura) effectapply auraname (139 force reaction) and effectmiscvalue 1001 (yes am looking for the spell which should cause all ogres in blades edge to become neutral once this is turned in. --- sql/updates/world/3.3.5/2017_09_19_14_world.sql | 109 ++++++++++++++++++++++++ 1 file changed, 109 insertions(+) create mode 100644 sql/updates/world/3.3.5/2017_09_19_14_world.sql (limited to 'sql') diff --git a/sql/updates/world/3.3.5/2017_09_19_14_world.sql b/sql/updates/world/3.3.5/2017_09_19_14_world.sql new file mode 100644 index 00000000000..a3629945429 --- /dev/null +++ b/sql/updates/world/3.3.5/2017_09_19_14_world.sql @@ -0,0 +1,109 @@ +DELETE FROM `creature_summon_groups` WHERE `summonerId`=22941; +INSERT INTO `creature_summon_groups` (`summonerId`, `summonerType`, `groupId`, `entry`, `position_x`, `position_y`, `position_z`, `orientation`, `summonType`, `summonTime`) VALUES +(22941, 0, 1, 23052, 2739.617, 5850.988, -0.7879967, 6.004031,1, 60000), -- 23052 (Area: 3522) +(22941, 0, 1, 23052, 2734.678, 5812.071, -7.892187, 0.4388094,1, 60000), -- 23052 (Area: 3522) +(22941, 0, 1, 23053, 2730.656, 5819.917, -9.735991, 0.2911542,1, 60000), -- 23053 (Area: 3522) +(22941, 0, 1, 23052, 2751.154, 5839.311, -3.240088, 6.223591,1, 60000), -- 23052 (Area: 3522) +(22941, 0, 1, 23053, 2755.514, 5861.03, -0.01289567, 5.648959,1, 60000), -- 23053 (Area: 3522) +(22941, 0, 1, 23052, 2740.929, 5826.928, -6.440495, 0.2129089,1, 60000), -- 23052 (Area: 3522) +(22941, 0, 1, 23052, 2762.146, 5825.248, -3.420345, 0.4297356,1, 60000), -- 23052 (Area: 3522) +(22941, 0, 1, 23052, 2739.496, 5817.305, -7.570641, 0.3874599,1, 60000), -- 23052 (Area: 3522) +(22941, 0, 1, 23053, 2745.614, 5845.916, -1.776619, 6.078503,1, 60000), -- 23053 (Area: 3522) +(22941, 0, 1, 23052, 2772.646, 5817.649, -0.8886007, 0.9018898,1, 60000), -- 23052 (Area: 3522) +(22941, 0, 1, 23053, 2758.238, 5832.049, -3.559237, 0.1682872,1, 60000), -- 23053 (Area: 3522) +(22941, 0, 1, 23053, 2754.574, 5846.337, -2.505016, 6.014104,1, 60000), -- 23053 (Area: 3522) +(22941, 0, 1, 23052, 2739.599, 5839.685, -3.164296, 6.230093,1, 60000), -- 23052 (Area: 3522) +(22941, 0, 1, 23052, 2752.079, 5824.336, -4.99764, 0.3414167,1, 60000), -- 23052 (Area: 3522) +(22941, 0, 1, 23053, 2751.385, 5810.043, -7.20096, 0.6361925,1, 60000), -- 23053 (Area: 3522) +(22941, 0, 1, 23053, 2748.693, 5819.53, -6.327135, 0.4203024,1, 60000), -- 23053 (Area: 3522) +(22941, 0, 1, 23052, 2732.273, 5825.77, -8.409297, 0.2006606,1, 60000), -- 23052 (Area: 3522) +(22941, 0, 1, 23052, 2749.196, 5856.374, -0.2547106, 5.822727,1, 60000), -- 23052 (Area: 3522) +(22941, 0, 1, 23053, 2759.586, 5816.921, -4.292243, 0.6172886,1, 60000), -- 23053 (Area: 3522) +(22941, 0, 1, 23053, 2743.603, 5858.121, -0.6288747, 5.84145,1, 60000), -- 23053 (Area: 3522) +(22941, 0, 1, 23053, 2745.669, 5831.537, -4.913702, 0.130838,1, 60000), -- 23053 (Area: 3522) +(22941, 0, 1, 23053, 2767.659, 5820.182, -2.214573, 0.6933811,1, 60000), -- 23053 (Area: 3522) +(22941, 0, 1, 23052, 2756.677, 5854.316, -1.418432, 5.781288,1, 60000), -- 23052 (Area: 3522) +(22941, 0, 1, 23053, 2737.804, 5833.646, -5.154177, 0.06887551,1, 60000), -- 23053 (Area: 3522) +(22941, 0, 1, 23052, 2754.409, 5814.579, -6.256382, 0.5904319,1, 60000), -- 23052 (Area: 3522) +(22941, 0, 1, 23053, 2707.26, 5855.679, -15.43325, 6.05722,1, 60000), -- 23053 (Area: 3522) +(22941, 0, 1, 23052, 2709.725, 5804.641, -13.96786, 0.393079,1, 60000), -- 23052 (Area: 3522) +(22941, 0, 1, 23053, 2705.106, 5824.687, -15.1272, 0.1487214,1, 60000), -- 23053 (Area: 3522) +(22941, 0, 1, 23052, 2706.538, 5834.85, -15.44075, 0.02773463,1, 60000), -- 23052 (Area: 3522) +(22941, 0, 1, 23052, 2722.473, 5821.006, -11.93857, 0.2408938,1, 60000), -- 23052 (Area: 3522) +(22941, 0, 1, 23053, 2716.655, 5804.323, -12.6736, 0.430625,1, 60000), -- 23053 (Area: 3522) +(22941, 0, 1, 23053, 2702.978, 5839.67, -15.57351, 6.253106,1, 60000), -- 23053 (Area: 3522) +(22941, 0, 1, 23053, 2714.311, 5842.397, -15.23648, 6.211601,1, 60000), -- 23053 (Area: 3522) +(22941, 0, 1, 23052, 2714.796, 5813.435, -13.14151, 0.3126825,1, 60000), -- 23052 (Area: 3522) +(22941, 0, 1, 23052, 2710.641, 5852.413, -15.35385, 6.087978,1, 60000), -- 23052 (Area: 3522) +(22941, 0, 1, 23053, 2721.566, 5814.438, -12.09889, 0.3287558,1, 60000), -- 23053 (Area: 3522) +(22941, 0, 1, 23052, 2716.531, 5835.825, -15.13918, 0.01797923,1, 60000), -- 23052 (Area: 3522) +(22941, 0, 1, 23056, 2705.111, 5817.062, -14.82143, 0.9599311,1, 60000), -- 23056 (Area: 3522) +(22941, 0, 1, 23053, 2706.644, 5847.776, -15.49038, 6.15288,1, 60000), -- 23053 (Area: 3522) +(22941, 0, 1, 23053, 2723.902, 5827.151, -11.43457, 0.1540743,1, 60000), -- 23053 (Area: 3522) +(22941, 0, 1, 23052, 2708.62, 5842.039, -15.37756, 6.221204,1, 60000), -- 23052 (Area: 3522) +(22941, 0, 1, 23052, 2713.041, 5826.883, -14.73765, 0.1355577,1, 60000), -- 23052 (Area: 3522) +(22941, 0, 1, 23053, 2728.983, 5812.26, -9.931931, 0.3983646,1, 60000), -- 23053 (Area: 3522) +(22941, 0, 1, 23052, 2708.627, 5861.856, -15.54748, 5.981085,1, 60000), -- 23052 (Area: 3522) +(22941, 0, 1, 23053, 2718.166, 5822.354, -13.37906, 0.2081611,1, 60000), -- 23053 (Area: 3522) +(22941, 0, 1, 23052, 2725.352, 5807.081, -11.02464, 0.4468045,1, 60000), -- 23052 (Area: 3522) +(22941, 0, 1, 23052, 2690.235, 5847.786, -15.49406, 6.174456,1, 60000), -- 23052 (Area: 3522) +(22941, 0, 1, 23053, 2690.06, 5830.619, -14.64328, 0.06616557,1, 60000), -- 23053 (Area: 3522) +(22941, 0, 1, 23052, 2704.865, 5808.66, -14.82297, 0.3296189,1, 60000), -- 23052 (Area: 3522) +(22941, 0, 1, 23052, 2696.707, 5837.702, -15.4793, 6.276711,1, 60000), -- 23052 (Area: 3522) +(22941, 0, 1, 23053, 2700.236, 5861.428, -15.93911, 6.012979,1, 60000), -- 23053 (Area: 3522) +(22941, 0, 1, 23052, 2693.179, 5866.683, -16.04778, 5.98096,1, 60000), -- 23052 (Area: 3522) +(22941, 0, 1, 23052, 2703.155, 5792.928, -15.30062, 0.479963,1, 60000), -- 23052 (Area: 3522) +(22941, 0, 1, 23053, 2700.724, 5830.671, -15.1589, 0.0736298,1, 60000), -- 23053 (Area: 3522) +(22941, 0, 1, 23052, 2695.537, 5814.8, -15.35081, 0.2366927,1, 60000), -- 23052 (Area: 3522) +(22941, 0, 1, 23052, 2700.039, 5803.477, -15.57214, 0.3651041,1, 60000), -- 23052 (Area: 3522) +(22941, 0, 1, 23052, 2693.921, 5820.99, -14.99893, 0.1696508,1, 60000), -- 23052 (Area: 3522) +(22941, 0, 1, 23053, 2692.451, 5841.281, -15.50815, 6.23958,1, 60000), -- 23053 (Area: 3522) +(22941, 0, 1, 23053, 2696.342, 5806.063, -15.89385, 0.3265095,1, 60000), -- 23053 (Area: 3522) +(22941, 0, 1, 23053, 2704.536, 5868.829, -15.65267, 5.920142,1, 60000), -- 23053 (Area: 3522) +(22941, 0, 1, 23053, 2696.569, 5848.355, -15.5579, 6.160855,1, 60000), -- 23053 (Area: 3522) +(22941, 0, 1, 23052, 2695.319, 5828.696, -14.8074, 0.09051862,1, 60000), -- 23052 (Area: 3522) +(22941, 0, 1, 23053, 2705.801, 5800.709, -14.69386, 0.4167551,1, 60000), -- 23053 (Area: 3522) +(22941, 0, 1, 23053, 2700.278, 5795.283, -15.7762, 0.444801,1, 60000), -- 23053 (Area: 3522) +(22941, 0, 1, 23052, 2701.346, 5847.94, -15.57445, 6.158898,1, 60000), -- 23052 (Area: 3522) +(22941, 0, 1, 23053, 2698.397, 5823.464, -15.04335, 0.1510885,1, 60000), -- 23053 (Area: 3522) +(22941, 0, 1, 23052, 2701.62, 5855.959, -15.6445, 6.068419,1, 60000), -- 23052 (Area: 3522) +(22941, 0, 1, 23052, 2693.602, 5855.765, -15.61896, 6.088152,1, 60000), -- 23052 (Area: 3522) +(22941, 0, 1, 23052, 2687.632, 5835.818, -15.01108, 0.01287773,1, 60000), -- 23052 (Area: 3522) +(22941, 0, 1, 23052, 2684.6, 5857.132, -15.33362, 6.09198,1, 60000), -- 23052 (Area: 3522) +(22941, 0, 1, 23053, 2685.47, 5843.786, -15.29153, 6.21819,1, 60000), -- 23053 (Area: 3522) +(22941, 0, 1, 23053, 2673.782, 5845.839, -15.33225, 6.206934,1, 60000), -- 23053 (Area: 3522) +(22941, 0, 1, 23053, 2682.196, 5837.667, -15.16663, 6.277935,1, 60000), -- 23053 (Area: 3522) +(22941, 0, 1, 23053, 2670.344, 5853.094, -15.42004, 6.148201,1, 60000), -- 23053 (Area: 3522) +(22941, 0, 1, 23052, 2677.164, 5857.225, -15.12731, 6.10371,1, 60000), -- 23052 (Area: 3522) +(22941, 0, 1, 23053, 2682.673, 5850.268, -15.30297, 6.158951,1, 60000), -- 23053 (Area: 3522) +(22941, 0, 1, 23053, 2689.857, 5859.694, -15.7386, 6.057081,1, 60000), -- 23053 (Area: 3522) +(22941, 0, 1, 23052, 2678.947, 5845.084, -15.34514, 6.210223,1, 60000), -- 23052 (Area: 3522) +(22941, 0, 1, 23053, 2681.091, 5862.079, -15.47492, 6.053813,1, 60000); -- 23053 (Area: 3522) + +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry` IN(22941,23052,23053); +DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid` IN(22941,23052,23053); +DELETE FROM `smart_scripts` WHERE `source_type`=9 AND `entryorguid` IN(2294100); + +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 +(22941, 0, 0, 1, 20, 0, 100, 0, 11000, 0, 0, 0, 64, 1, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Mog\'dorg the Wizened - On Quest Complete (Into the Soulgrinder) - Store Target List'), +(22941, 0, 1, 0, 61, 0, 100, 0, 11000, 0, 0, 0, 80, 2294100, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Mog\'dorg the Wizened - On Quest Complete (Into the Soulgrinder) - Run Script'), +(23052, 0, 0, 1, 54, 0, 100, 0, 0, 0, 0, 0, 2, 7, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Bloodmaul Supplicant - On Just Summoned - Set Faction'), +(23052, 0, 1, 2, 61, 0, 100, 0, 0, 0, 0, 0, 18, 33536, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Bloodmaul Supplicant - On Just Summoned - Set Unit Flags'), +(23052, 0, 2, 0, 61, 0, 100, 0, 0, 0, 0, 0, 81, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Bloodmaul Supplicant - On Just Summoned - Set NPC Flags'), +(23052, 0, 3, 0, 38, 0, 100, 0, 1, 1, 0, 0, 22, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Bloodmaul Supplicant - On Data Set - Set Phase 2'), +(23052, 0, 4, 5, 1, 2, 100, 0, 1000, 1000, 1000, 1000, 66, 0, 0, 0, 0, 0, 0, 12, 1, 0, 0, 0, 0, 0, 0, 'Bloodmaul Supplicant - OOC (Phase 2) - Face Target'), +(23052, 0, 5, 0, 61, 0, 100, 0, 0, 0, 0, 0, 90, 8, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Bloodmaul Supplicant - OOC (Phase 2) - Set Bytes 1'), +(23053, 0, 0, 1, 54, 0, 100, 0, 0, 0, 0, 0, 2, 7, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Bladespire Supplicant - On Just Summoned - Set Faction'), +(23053, 0, 1, 2, 61, 0, 100, 0, 0, 0, 0, 0, 18, 33536, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Bladespire Supplicant - On Just Summoned - Set Unit Flags'), +(23053, 0, 2, 0, 61, 0, 100, 0, 0, 0, 0, 0, 81, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Bladespirr Supplicant - On Just Summoned - Set NPC Flags'), +(23053, 0, 3, 0, 38, 0, 100, 0, 1, 1, 0, 0, 22, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Bladespire Supplicant - On Data Set - Set Phase 2'), +(23053, 0, 4, 5, 1, 2, 100, 0, 1000, 1000, 1000, 1000, 66, 0, 0, 0, 0, 0, 0, 12, 1, 0, 0, 0, 0, 0, 0, 'Bladespire Supplicant - OOC (Phase 2) - Face Target'), +(23053, 0, 5, 0, 61, 0, 100, 0, 0, 0, 0, 0, 90, 8, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Bladespire Supplicant - OOC (Phase 2) - Set Bytes 1'), +(2294100, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 107, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Mog\'dorg the Wizened - Script - Summon Group'), -- 01:06:26.797 +(2294100, 9, 1, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 4, 402, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Mog\'dorg the Wizened - Script - Play Sound'), -- 01:06:28.907 +(2294100, 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 12, 1, 0, 0, 0, 0, 0, 0, 'Mog\'dorg the Wizened - Script - Say'), -- 01:06:28.907 +(2294100, 9, 3, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 100, 1, 0, 0, 0, 0, 0, 9, 23052, 0, 200, 0, 0, 0, 0, 'Mog\'dorg the Wizened - Script - Send Targetlist to Bloodmaul Supplicant'), +(2294100, 9, 4, 0, 0, 0, 100, 0, 0, 0, 0, 0, 100, 1, 0, 0, 0, 0, 0, 9, 23053, 0, 200, 0, 0, 0, 0, 'Mog\'dorg the Wizened - Script - Send Targetlist to Bladespire Supplicant'), +(2294100, 9, 5, 0, 0, 0, 100, 0, 0, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 9, 23052, 0, 200, 0, 0, 0, 0, 'Mog\'dorg the Wizened - Script - Set Data to Bloodmaul Supplicant'), +(2294100, 9, 6, 0, 0, 0, 100, 0, 0, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 9, 23053, 0, 200, 0, 0, 0, 0, 'Mog\'dorg the Wizened - Script - Set Data to Bladespire Supplicant'); + -- cgit v1.2.3