diff options
| -rw-r--r-- | sql/updates/world/master/2020_09_06_07_world_2017_09_19_14_world.sql | 109 |
1 files changed, 109 insertions, 0 deletions
diff --git a/sql/updates/world/master/2020_09_06_07_world_2017_09_19_14_world.sql b/sql/updates/world/master/2020_09_06_07_world_2017_09_19_14_world.sql new file mode 100644 index 00000000000..a3629945429 --- /dev/null +++ b/sql/updates/world/master/2020_09_06_07_world_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'); + |