DB/SAI: Use c_s_g for some big summon groups

Closes #24753

1 files changed, 123 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2020_06_14_13_world.sql b/sql/updates/world/3.3.5/2020_06_14_13_world.sql
new file mode 100644
index 00000000000..0e194cb115d
--- /dev/null
+++ b/sql/updates/world/3.3.5/2020_06_14_13_world.sql
@@ -0,0 +1,123 @@
+--
+UPDATE `smart_scripts` SET `action_type` = 107, `action_param1` = 0, `action_param2` = 0, `action_param3` = 0, `target_type` = 0, `target_x` = 0, `target_y` = 0, `target_z` = 0, `target_o` = 0, `comment` = "Witch Doctor Hez'tok - On Script - Summon Group 0" WHERE `entryorguid` = 4035200 AND `source_type` = 9 AND `id` = 2;
+UPDATE `smart_scripts` SET `action_type` = 107, `action_param1` = 1, `action_param2` = 0, `action_param3` = 0, `target_type` = 0, `target_x` = 0, `target_y` = 0, `target_z` = 0, `target_o` = 0, `comment` = "Witch Doctor Hez'tok - On Script - Summon Group 1" WHERE `entryorguid` = 4035200 AND `source_type` = 9 AND `id` = 14;
+UPDATE `smart_scripts` SET `action_type` = 107, `action_param1` = 2, `action_param2` = 0, `action_param3` = 0, `target_type` = 0, `target_x` = 0, `target_y` = 0, `target_z` = 0, `target_o` = 0, `comment` = "Witch Doctor Hez'tok - On Script - Summon Group 2" WHERE `entryorguid` = 4035200 AND `source_type` = 9 AND `id` = 22;
+DELETE FROM `smart_scripts` WHERE `entryorguid` = 4035200 AND `source_type` = 9 AND `id` BETWEEN 3 AND 4;
+DELETE FROM `smart_scripts` WHERE `entryorguid` = 4035200 AND `source_type` = 9 AND `id` BETWEEN 15 AND 21;
+DELETE FROM `smart_scripts` WHERE `entryorguid` = 4035200 AND `source_type` = 9 AND `id` BETWEEN 23 AND 31;
+
+UPDATE `smart_scripts` SET `action_type` = 107, `action_param1` = 0, `action_param2` = 0, `action_param3` = 0, `target_type` = 0, `target_x` = 0, `target_y` = 0, `target_z` = 0, `target_o` = 0, `comment` = "Pusillin - On Script - Summon Group 0" WHERE `entryorguid` = 1435404 AND `source_type` = 9 AND `id` = 4;
+DELETE FROM `smart_scripts` WHERE `entryorguid` = 1435404 AND `source_type` = 9 AND `id` BETWEEN 5 AND 8;
+
+UPDATE `smart_scripts` SET `action_type` = 107, `action_param1` = 0, `action_param2` = 0, `action_param3` = 0, `target_type` = 0, `target_x` = 0, `target_y` = 0, `target_z` = 0, `target_o` = 0, `comment` = "Major Mills - On Script - Summon Group 0" WHERE `entryorguid` = 2390500 AND `source_type` = 9 AND `id` = 2;
+DELETE FROM `smart_scripts` WHERE `entryorguid` = 2390500 AND `source_type` = 9 AND `id` BETWEEN 3 AND 14;
+
+UPDATE `smart_scripts` SET `action_type` = 107, `action_param1` = 0, `action_param2` = 0, `action_param3` = 0, `target_type` = 0, `target_x` = 0, `target_y` = 0, `target_z` = 0, `target_o` = 0, `comment` = "Harrison Jones - On Script - Summon Group 0" WHERE `entryorguid` = 2681402 AND `source_type` = 9 AND `id` = 14;
+DELETE FROM `smart_scripts` WHERE `entryorguid` = 2681402 AND `source_type` = 9 AND `id` BETWEEN 15 AND 23;
+
+UPDATE `smart_scripts` SET `action_type` = 107, `action_param1` = 0, `action_param2` = 0, `action_param3` = 0, `target_type` = 0, `target_x` = 0, `target_y` = 0, `target_z` = 0, `target_o` = 0, `comment` = "Nergeld - On Script - Summon Group 0" WHERE `entryorguid` = 3040300 AND `source_type` = 9 AND `id` = 0;
+UPDATE `smart_scripts` SET `action_type` = 107, `action_param1` = 1, `action_param2` = 0, `action_param3` = 0, `target_type` = 0, `target_x` = 0, `target_y` = 0, `target_z` = 0, `target_o` = 0, `comment` = "Nergeld - On Script - Summon Group 1" WHERE `entryorguid` = 3040300 AND `source_type` = 9 AND `id` = 6;
+UPDATE `smart_scripts` SET `action_type` = 107, `action_param1` = 2, `action_param2` = 0, `action_param3` = 0, `target_type` = 0, `target_x` = 0, `target_y` = 0, `target_z` = 0, `target_o` = 0, `comment` = "Nergeld - On Script - Summon Group 2" WHERE `entryorguid` = 3040300 AND `source_type` = 9 AND `id` = 12;
+UPDATE `smart_scripts` SET `action_type` = 107, `action_param1` = 3, `action_param2` = 0, `action_param3` = 0, `target_type` = 0, `target_x` = 0, `target_y` = 0, `target_z` = 0, `target_o` = 0, `comment` = "Nergeld - On Script - Summon Group 3" WHERE `entryorguid` = 3040300 AND `source_type` = 9 AND `id` = 18;
+DELETE FROM `smart_scripts` WHERE `entryorguid` = 3040300 AND `source_type` = 9 AND `id` BETWEEN 1 AND 5;
+DELETE FROM `smart_scripts` WHERE `entryorguid` = 3040300 AND `source_type` = 9 AND `id` BETWEEN 7 AND 11;
+DELETE FROM `smart_scripts` WHERE `entryorguid` = 3040300 AND `source_type` = 9 AND `id` BETWEEN 13 AND 17;
+DELETE FROM `smart_scripts` WHERE `entryorguid` = 3040300 AND `source_type` = 9 AND `id` BETWEEN 19 AND 20;
+
+UPDATE `smart_scripts` SET `action_type` = 107, `action_param1` = 0, `action_param2` = 0, `action_param3` = 0, `target_type` = 0, `target_x` = 0, `target_y` = 0, `target_z` = 0, `target_o` = 0, `comment` = "Wind Tamer Barah - On Script - Summon Group 0" WHERE `entryorguid` = 2473000 AND `source_type` = 9 AND `id` = 2;
+UPDATE `smart_scripts` SET `action_type` = 107, `action_param1` = 1, `action_param2` = 0, `action_param3` = 0, `target_type` = 0, `target_x` = 0, `target_y` = 0, `target_z` = 0, `target_o` = 0, `comment` = "Wind Tamer Barah - On Script - Summon Group 1" WHERE `entryorguid` = 2473000 AND `source_type` = 9 AND `id` = 9;
+DELETE FROM `smart_scripts` WHERE `entryorguid` = 2473000 AND `source_type` = 9 AND `id` BETWEEN 3 AND 8;
+
+UPDATE `smart_scripts` SET `action_type` = 107, `action_param1` = 0, `action_param2` = 0, `action_param3` = 0, `target_type` = 0, `target_x` = 0, `target_y` = 0, `target_z` = 0, `target_o` = 0, `comment` = "Stillpine the Younger - On Script - Summon Group 0" WHERE `entryorguid` = 1744500 AND `source_type` = 9 AND `id` = 1;
+DELETE FROM `smart_scripts` WHERE `entryorguid` = 1744500 AND `source_type` = 9 AND `id` BETWEEN 2 AND 10;
+
+DELETE FROM `creature_summon_groups` WHERE `summonerId` IN (40352,14354,23905,26814,30403,21797,24730,17445) AND `summonerType` = 0;
+INSERT INTO `creature_summon_groups` (`summonerId`,`summonerType`,`groupId`,`entry`,`position_x`,`position_y`,`position_z`,`orientation`,`summonType`,`summonTime`,`Comment`) VALUES
+(40352,0,0,40373,-812.137,-4986.7,17.3759,5.89921,1,50000,"Witch Doctor Hez'tok - Group 0 - Ritual Drummer"),
+(40352,0,0,40373,-798.187,-4985.52,17.7904,4.41568,1,50000,"Witch Doctor Hez'tok - Group 0 - Ritual Drummer"),
+(40352,0,0,40373,-799.888,-4975.01,17.9325,0.942478,1,50000,"Witch Doctor Hez'tok - Group 0 - Ritual Drummer"),
+(40352,0,1,40363,-805.848,-5003.04,20.1833,5.89921,1,40000,"Witch Doctor Hez'tok - Group 1 - Dance Participant"),
+(40352,0,1,40363,-801.06,-4998.5,18.5936,4.41568,1,40000,"Witch Doctor Hez'tok - Group 1 - Dance Participant"),
+(40352,0,1,40363,-808.24,-4985.21,19.5431,0.942478,1,40000,"Witch Doctor Hez'tok - Group 1 - Dance Participant"),
+(40352,0,1,40363,-799.262,-4994.35,19.6193,5.89921,1,40000,"Witch Doctor Hez'tok - Group 1 - Dance Participant"),
+(40352,0,1,40363,-797.818,-4986.6,21.6016,4.41568,1,40000,"Witch Doctor Hez'tok - Group 1 - Dance Participant"),
+(40352,0,1,40363,-805.128,-4987.55,18.79,0.942478,1,40000,"Witch Doctor Hez'tok - Group 1 - Dance Participant"),
+(40352,0,1,40363,-814.111,-5001.68,19.4441,5.89921,1,40000,"Witch Doctor Hez'tok - Group 1 - Dance Participant"),
+(40352,0,1,40363,-795.756,-4993.67,21.8073,5.89921,1,40000,"Witch Doctor Hez'tok - Group 1 - Dance Participant"),
+(40352,0,2,40388,-790.217,-4999.73,17.1718,2.84489,1,40000,"Witch Doctor Hez'tok - Group 2 - Darkspear Ancestor"),
+(40352,0,2,40388,-792.005,-4994.14,17.484,2.70526,1,40000,"Witch Doctor Hez'tok - Group 2 - Darkspear Ancestor"),
+(40352,0,2,40388,-795.205,-5003.08,17.7161,2.46091,1,40000,"Witch Doctor Hez'tok - Group 2 - Darkspear Ancestor"),
+(40352,0,2,40388,-799.227,-5005.68,16.6323,2.11185,1,40000,"Witch Doctor Hez'tok - Group 2 - Darkspear Ancestor"),
+(40352,0,2,40388,-799.256,-4990.76,17.6279,2.70527,1,40000,"Witch Doctor Hez'tok - Group 2 - Darkspear Ancestor"),
+(40352,0,2,40388,-801.422,-4998.04,17.0009,2.46089,1,40000,"Witch Doctor Hez'tok - Group 2 - Darkspear Ancestor"),
+(40352,0,2,40388,-805.436,-5002.89,16.5445,1.72788,1,40000,"Witch Doctor Hez'tok - Group 2 - Darkspear Ancestor"),
+(40352,0,2,40388,-807.135,-4997.47,17.0009,1.15,1,40000,"Witch Doctor Hez'tok - Group 2 - Darkspear Ancestor"),
+(40352,0,2,40388,-810.37,-4993.83,17.1259,0.808654,1,40000,"Witch Doctor Hez'tok - Group 2 - Darkspear Ancestor"),
+(40352,0,2,40388,-810.389,-5004.78,16.1241,1.15192,1,40000,"Witch Doctor Hez'tok - Group 2 - Darkspear Ancestor"),
+(14354,0,0,13276,25.1447,-703.067,-12.6426,0,7,0,"Pusillin - Group 0 - Wildspawn Imp"),
+(14354,0,0,13276,13.1924,-709.858,-12.6426,1.38546,7,0,"Pusillin - Group 0 - Wildspawn Imp"),
+(14354,0,0,13276,24.2691,-694.881,-12.6426,3.78172,7,0,"Pusillin - Group 0 - Wildspawn Imp"),
+(14354,0,0,13276,15.6403,-690.705,-12.6426,4.66842,7,0,"Pusillin - Group 0 - Wildspawn Imp"),
+(14354,0,0,13276,22.6902,-710.312,-12.6426,2.08054,7,0,"Pusillin - Group 0 - Wildspawn Imp"),
+(23905,0,0,23900,-3904.77,-4635.09,9.62735,5.49334,1,900000,"Major Mills - Group 0 - Theramore Marksman"),
+(23905,0,0,23900,-3856.59,-4622.45,9.24753,3.87856,1,900000,"Major Mills - Group 0 - Theramore Marksman"),
+(23905,0,0,23900,-3917.6,-4648.53,9.32604,5.56795,1,900000,"Major Mills - Group 0 - Theramore Marksman"),
+(23905,0,0,23900,-3890.48,-4620.7,9.55527,4.99383,1,900000,"Major Mills - Group 0 - Theramore Marksman"),
+(23905,0,0,23900,-3865.94,-4617.2,9.26262,4.16523,1,900000,"Major Mills - Group 0 - Theramore Marksman"),
+(23905,0,0,23900,-3834.8,-4645.41,9.25827,3.61152,1,900000,"Major Mills - Group 0 - Theramore Marksman"),
+(23905,0,0,23900,-3826.61,-4655.32,9.21484,3.13243,1,900000,"Major Mills - Group 0 - Theramore Marksman"),
+(23905,0,0,23900,-3830.76,-4673.74,9.50962,2.70832,1,900000,"Major Mills - Group 0 - Theramore Marksman"),
+(23905,0,0,23900,-3843.65,-4687.59,9.6436,2.43735,1,900000,"Major Mills - Group 0 - Theramore Marksman"),
+(23905,0,0,23900,-3858.49,-4703.49,9.17411,2.33525,1,900000,"Major Mills - Group 0 - Theramore Marksman"),
+(23905,0,0,23900,-3851.97,-4697.24,9.36834,2.33525,1,900000,"Major Mills - Group 0 - Theramore Marksman"),
+(23905,0,0,23900,-3924.35,-4656.55,9.15409,5.80749,1,900000,"Major Mills - Group 0 - Theramore Marksman"),
+(23905,0,0,23899,-3897.37,-4750.63,-1.71901,1.79105,1,900000,"Major Mills - Group 0 - Tethyr"),
+(26814,0,0,26867,4902.23,-4827.56,32.6125,2.44346,2,300000,"Harrison Jones - Group 0 - Mummy Effect Bunny"),
+(26814,0,0,26867,4876.61,-4805.58,32.5825,6.17846,2,300000,"Harrison Jones - Group 0 - Mummy Effect Bunny"),
+(26814,0,0,26867,4877.39,-4815.75,32.5835,0.15708,2,300000,"Harrison Jones - Group 0 - Mummy Effect Bunny"),
+(26814,0,0,26867,4883.1,-4823.98,32.5884,0.872665,2,300000,"Harrison Jones - Group 0 - Mummy Effect Bunny"),
+(26814,0,0,26867,4892.31,-4828.58,32.5958,1.5708,2,300000,"Harrison Jones - Group 0 - Mummy Effect Bunny"),
+(26814,0,0,26867,4908.68,-4794.35,32.6706,3.97935,2,300000,"Harrison Jones - Group 0 - Mummy Effect Bunny"),
+(26814,0,0,26867,4899.54,-4789.86,32.5981,4.76475,2,300000,"Harrison Jones - Group 0 - Mummy Effect Bunny"),
+(26814,0,0,26867,4889.96,-4790.65,32.5985,5.20108,2,300000,"Harrison Jones - Group 0 - Mummy Effect Bunny"),
+(26814,0,0,26867,4914.76,-4813.24,32.5866,3.01942,2,300000,"Harrison Jones - Group 0 - Mummy Effect Bunny"),
+(26814,0,0,26867,4914.13,-4802.8,32.6696,3.42085,2,300000,"Harrison Jones - Group 0 - Mummy Effect Bunny"),
+(30403,0,0,30471,7993.9,3336.91,632.396,0.14577,2,300000,"Nergeld - Group 0 - Vargul Assailant"),
+(30403,0,0,30471,8003.72,3323.56,632.396,0.648783,2,300000,"Nergeld - Group 0 - Vargul Assailant"),
+(30403,0,0,30471,8026.94,3307.58,632.396,1.48207,2,300000,"Nergeld - Group 0 - Vargul Assailant"),
+(30403,0,0,30471,8001.77,3306.38,632.396,0.863447,2,300000,"Nergeld - Group 0 - Vargul Assailant"),
+(30403,0,0,30471,7987.9,3308.9,632.396,0.68058,2,300000,"Nergeld - Group 0 - Vargul Assailant"),
+(30403,0,0,30471,8016.52,3318.92,632.396,0.940311,2,300000,"Nergeld - Group 0 - Vargul Assailant"),
+(30403,0,1,30432,7996.66,3308.78,632.396,0.773231,2,300000,"Nergeld - Group 1 - Grimmr Hound"),
+(30403,0,1,30432,8011.71,3315.36,632.396,0.901169,2,300000,"Nergeld - Group 1 - Grimmr Hound"),
+(30403,0,1,30471,8000.67,3317.23,632.396,0.710591,2,300000,"Nergeld - Group 1 - Vargul Assailant"),
+(30403,0,1,30471,8025.24,3313.55,632.396,1.28693,2,300000,"Nergeld - Group 1 - Vargul Assailant"),
+(30403,0,1,30471,8007.71,3337.13,632.396,0.407285,2,300000,"Nergeld - Group 1 - Vargul Assailant"),
+(30403,0,1,30471,8009.92,3319.81,632.396,0.804842,2,300000,"Nergeld - Group 1 - Vargul Assailant"),
+(30403,0,2,30432,8021.79,3312.45,632.396,1.13086,2,300000,"Nergeld - Group 2 - Grimmr Hound"),
+(30403,0,2,30432,8001.36,3332.71,632.396,0.443351,2,300000,"Nergeld - Group 2 - Grimmr Hound"),
+(30403,0,2,30432,7999.22,3302.52,632.396,0.872342,2,300000,"Nergeld - Group 2 - Grimmr Hound"),
+(30403,0,2,30471,8000.5,3345.77,632.396,5.82389,2,300000,"Nergeld - Group 2 - Vargul Assailant"),
+(30403,0,2,30471,8001.77,3311.95,632.396,0.797157,2,300000,"Nergeld - Group 2 - Vargul Assailant"),
+(30403,0,2,30471,8012.21,3325.82,632.396,0.737667,2,300000,"Nergeld - Group 2 - Vargul Assailant"),
+(30403,0,3,30404,7985.9,3296.68,632.479,0.837758,2,300000,"Nergeld - Group 3 - Dr. Terrible"),
+(30403,0,3,30432,7982.59,3301.81,632.479,0.698132,2,300000,"Nergeld - Group 3 - Grimmr Hound"),
+(30403,0,3,30432,7991.37,3293.51,632.479,0.907571,2,300000,"Nergeld - Group 3 - Grimmr Hound"),
+(24730,0,0,25771,3526.86,4215.89,16.8978,0.959931,1,12000,"Wind Tamer Barah - Group 0 - Ice Elemental Target"),
+(24730,0,0,25769,3526.76,4208.78,12.5158,0.959931,1,10000,"Wind Tamer Barah - Group 0 - Small Elemental"),
+(24730,0,0,25769,3530.08,4210.27,12.5575,1.02974,1,10000,"Wind Tamer Barah - Group 0 - Small Elemental"),
+(24730,0,0,25769,3533.23,4213.77,12.5506,2.80998,1,10000,"Wind Tamer Barah - Group 0 - Small Elemental"),
+(24730,0,0,25769,3531.66,4218.42,12.5783,0.925025,1,10000,"Wind Tamer Barah - Group 0 - Small Elemental"),
+(24730,0,0,25769,3528.85,4221.31,12.5228,2.75762,1,10000,"Wind Tamer Barah - Group 0 - Small Elemental"),
+(24730,0,0,25769,3524.51,4220.79,12.5992,3.63029,1,10000,"Wind Tamer Barah - Group 0 - Small Elemental"),
+(24730,0,1,25742,3526.81,4215.75,13.3075,3.75246,1,7000,"Wind Tamer Barah - Group 1 - Alluvius"),
+(17445,0,0,17495,-3367.84,-12424.6,26.1425,1.85513,6,30000,"Stillpine the Younger - Group 0 - Stillpine Raider"),
+(17445,0,0,17495,-3363.8,-12428.6,27.3273,1.98472,6,30000,"Stillpine the Younger - Group 0 - Stillpine Raider"),
+(17445,0,0,17495,-3364.07,-12432.9,27.338,1.9965,6,30000,"Stillpine the Younger - Group 0 - Stillpine Raider"),
+(17445,0,0,17495,-3360.59,-12433.1,28.084,2.08289,6,30000,"Stillpine the Younger - Group 0 - Stillpine Raider"),
+(17445,0,0,17495,-3356.08,-12434.3,29.6136,2.49915,6,30000,"Stillpine the Younger - Group 0 - Stillpine Raider"),
+(17445,0,0,17495,-3357.16,-12430.5,28.9967,2.46774,6,30000,"Stillpine the Younger - Group 0 - Stillpine Raider"),
+(17445,0,0,17495,-3355.98,-12438.2,29.8503,2.46224,6,30000,"Stillpine the Younger - Group 0 - Stillpine Raider"),
+(17445,0,0,17495,-3350.3,-12437.5,32.3999,2.41119,6,30000,"Stillpine the Younger - Group 0 - Stillpine Raider"),
+(17445,0,0,17495,-3348.27,-12442.5,34.3653,2.58005,6,30000,"Stillpine the Younger - Group 0 - Stillpine Raider"),
+(17445,0,0,17495,-3344.08,-12441.7,36.8811,2.36014,6,30000,"Stillpine the Younger - Group 0 - Stillpine Raider");