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.

1 files changed, 109 insertions, 0 deletions

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');
+