aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authoroffl <offl@users.noreply.github.com>2020-08-10 03:40:17 +0300
committerShauren <shauren.trinity@gmail.com>2022-01-26 19:24:12 +0100
commit7afcd3f4a218098d0512d10edf9c9f673ca6152b (patch)
tree434511b075c606af85ae2e40bde13bf8c26ef956
parente11e1938b5237a198c82cfdf128a9b6c1e3686ad (diff)
DB/SAI: Rework support for corrupted & cleansed plants from Felwood
Closes #4960 (cherry picked from commit 2ff51396c008a7eeffa6ed596e84b2f3cd616b1d)
-rw-r--r--sql/updates/world/master/2022_01_26_26_world_2020_08_10_00_world_335.sql103
1 files changed, 103 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_01_26_26_world_2020_08_10_00_world_335.sql b/sql/updates/world/master/2022_01_26_26_world_2020_08_10_00_world_335.sql
new file mode 100644
index 00000000000..edbe4dff148
--- /dev/null
+++ b/sql/updates/world/master/2022_01_26_26_world_2020_08_10_00_world_335.sql
@@ -0,0 +1,103 @@
+--
+UPDATE `gameobject` SET `spawntimesecs` = 7200 WHERE `id` IN (164885,173324,174608,174684,164886,171939,171942,174594,174595,174596,174597,174598,174712,174713,164888,173284,174605,174606,174607,174686,164887,173327,174599,174600,174601,174602,174603,174604,174708,174709);
+
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (164885,173324,174608,174684,164886,171939,171942,174594,174595,174596,174597,174598,174712,174713,164888,173284,174605,174606,174607,174686,164887,173327,174599,174600,174601,174602,174603,174604,174708,174709) AND `source_type` = 1;
+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`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES
+(164885,1,0,1,20,0,100,0,4119,0,0,0,0,50,164881,7200,0,0,0,0,1,0,0,0,0,0,0,0,0,"Corrupted Night Dragon - On Quest 'Corrupted Night Dragon' Finished - Summon Gameobject 'Cleansed Night Dragon'"),
+(164886,1,0,1,20,0,100,0,2523,0,0,0,0,50,164882,7200,0,0,0,0,1,0,0,0,0,0,0,0,0,"Corrupted Songflower - On Quest 'Corrupted Songflower' Finished - Summon Gameobject 'Cleansed Songflower'"),
+(164887,1,0,1,20,0,100,0,996,0,0,0,0,50,164884,7200,0,0,0,0,1,0,0,0,0,0,0,0,0,"Corrupted Windblossom - On Quest 'Corrupted Windblossom' Finished - Summon Gameobject 'Cleansed Windblossom'"),
+(164888,1,0,1,20,0,100,0,4117,0,0,0,0,50,164883,7200,0,0,0,0,1,0,0,0,0,0,0,0,0,"Corrupted Whipper Root - On Quest 'Corrupted Whipper Root' Finished - Summon Gameobject 'Cleansed Whipper Root'"),
+(171939,1,0,1,20,0,100,0,2878,0,0,0,0,50,171940,7200,0,0,0,0,1,0,0,0,0,0,0,0,0,"Corrupted Songflower - On Quest 'Corrupted Songflower' Finished - Summon Gameobject 'Cleansed Songflower'"),
+(171942,1,0,1,20,0,100,0,3363,0,0,0,0,50,171943,7200,0,0,0,0,1,0,0,0,0,0,0,0,0,"Corrupted Songflower - On Quest 'Corrupted Songflower' Finished - Summon Gameobject 'Cleansed Songflower'"),
+(173284,1,0,1,20,0,100,0,4443,0,0,0,0,50,174622,7200,0,0,0,0,1,0,0,0,0,0,0,0,0,"Corrupted Whipper Root - On Quest 'Corrupted Whipper Root' Finished - Summon Gameobject 'Cleansed Whipper Root'"),
+(173324,1,0,1,20,0,100,0,4448,0,0,0,0,50,174609,7200,0,0,0,0,1,0,0,0,0,0,0,0,0,"Corrupted Night Dragon - On Quest 'Corrupted Night Dragon' Finished - Summon Gameobject 'Cleansed Night Dragon'"),
+(173327,1,0,1,20,0,100,0,998,0,0,0,0,50,174711,7200,0,0,0,0,1,0,0,0,0,0,0,0,0,"Corrupted Windblossom - On Quest 'Corrupted Windblossom' Finished - Summon Gameobject 'Cleansed Windblossom'"),
+(174594,1,0,1,20,0,100,0,4113,0,0,0,0,50,174610,7200,0,0,0,0,1,0,0,0,0,0,0,0,0,"Corrupted Songflower - On Quest 'Corrupted Songflower' Finished - Summon Gameobject 'Cleansed Songflower'"),
+(174595,1,0,1,20,0,100,0,4114,0,0,0,0,50,174612,7200,0,0,0,0,1,0,0,0,0,0,0,0,0,"Corrupted Songflower - On Quest 'Corrupted Songflower' Finished - Summon Gameobject 'Cleansed Songflower'"),
+(174596,1,0,1,20,0,100,0,4116,0,0,0,0,50,174613,7200,0,0,0,0,1,0,0,0,0,0,0,0,0,"Corrupted Songflower - On Quest 'Corrupted Songflower' Finished - Summon Gameobject 'Cleansed Songflower'"),
+(174597,1,0,1,20,0,100,0,4118,0,0,0,0,50,174614,7200,0,0,0,0,1,0,0,0,0,0,0,0,0,"Corrupted Songflower - On Quest 'Corrupted Songflower' Finished - Summon Gameobject 'Cleansed Songflower'"),
+(174598,1,0,1,20,0,100,0,4401,0,0,0,0,50,174615,7200,0,0,0,0,1,0,0,0,0,0,0,0,0,"Corrupted Songflower - On Quest 'Corrupted Songflower' Finished - Summon Gameobject 'Cleansed Songflower'"),
+(174599,1,0,1,20,0,100,0,1514,0,0,0,0,50,173326,7200,0,0,0,0,1,0,0,0,0,0,0,0,0,"Corrupted Windblossom - On Quest 'Corrupted Windblossom' Finished - Summon Gameobject 'Cleansed Windblossom'"),
+(174600,1,0,1,20,0,100,0,4115,0,0,0,0,50,174619,7200,0,0,0,0,1,0,0,0,0,0,0,0,0,"Corrupted Windblossom - On Quest 'Corrupted Windblossom' Finished - Summon Gameobject 'Cleansed Windblossom'"),
+(174601,1,0,1,20,0,100,0,4221,0,0,0,0,50,174620,7200,0,0,0,0,1,0,0,0,0,0,0,0,0,"Corrupted Windblossom - On Quest 'Corrupted Windblossom' Finished - Summon Gameobject 'Cleansed Windblossom'"),
+(174602,1,0,1,20,0,100,0,4222,0,0,0,0,50,174616,7200,0,0,0,0,1,0,0,0,0,0,0,0,0,"Corrupted Windblossom - On Quest 'Corrupted Windblossom' Finished - Summon Gameobject 'Cleansed Windblossom'"),
+(174603,1,0,1,20,0,100,0,4343,0,0,0,0,50,174617,7200,0,0,0,0,1,0,0,0,0,0,0,0,0,"Corrupted Windblossom - On Quest 'Corrupted Windblossom' Finished - Summon Gameobject 'Cleansed Windblossom'"),
+(174604,1,0,1,20,0,100,0,4403,0,0,0,0,50,174618,7200,0,0,0,0,1,0,0,0,0,0,0,0,0,"Corrupted Windblossom - On Quest 'Corrupted Windblossom' Finished - Summon Gameobject 'Cleansed Windblossom'"),
+(174605,1,0,1,20,0,100,0,4444,0,0,0,0,50,174623,7200,0,0,0,0,1,0,0,0,0,0,0,0,0,"Corrupted Whipper Root - On Quest 'Corrupted Whipper Root' Finished - Summon Gameobject 'Cleansed Whipper Root'"),
+(174606,1,0,1,20,0,100,0,4445,0,0,0,0,50,174624,7200,0,0,0,0,1,0,0,0,0,0,0,0,0,"Corrupted Whipper Root - On Quest 'Corrupted Whipper Root' Finished - Summon Gameobject 'Cleansed Whipper Root'"),
+(174607,1,0,1,20,0,100,0,4446,0,0,0,0,50,174625,7200,0,0,0,0,1,0,0,0,0,0,0,0,0,"Corrupted Whipper Root - On Quest 'Corrupted Whipper Root' Finished - Summon Gameobject 'Cleansed Whipper Root'"),
+(174608,1,0,1,20,0,100,0,4462,0,0,0,0,50,174685,7200,0,0,0,0,1,0,0,0,0,0,0,0,0,"Corrupted Night Dragon - On Quest 'Corrupted Night Dragon' Finished - Summon Gameobject 'Cleansed Night Dragon'"),
+(174684,1,0,1,20,0,100,0,4447,0,0,0,0,50,173325,7200,0,0,0,0,1,0,0,0,0,0,0,0,0,"Corrupted Night Dragon - On Quest 'Corrupted Night Dragon' Finished - Summon Gameobject 'Cleansed Night Dragon'"),
+(174686,1,0,1,20,0,100,0,4461,0,0,0,0,50,174687,7200,0,0,0,0,1,0,0,0,0,0,0,0,0,"Corrupted Whipper Root - On Quest 'Corrupted Whipper Root' Finished - Summon Gameobject 'Cleansed Whipper Root'"),
+(174708,1,0,1,20,0,100,0,4466,0,0,0,0,50,174621,7200,0,0,0,0,1,0,0,0,0,0,0,0,0,"Corrupted Windblossom - On Quest 'Corrupted Windblossom' Finished - Summon Gameobject 'Cleansed Windblossom'"),
+(174709,1,0,1,20,0,100,0,4467,0,0,0,0,50,174710,7200,0,0,0,0,1,0,0,0,0,0,0,0,0,"Corrupted Windblossom - On Quest 'Corrupted Windblossom' Finished - Summon Gameobject 'Cleansed Windblossom'"),
+(174712,1,0,1,20,0,100,0,4464,0,0,0,0,50,174714,7200,0,0,0,0,1,0,0,0,0,0,0,0,0,"Corrupted Songflower - On Quest 'Corrupted Songflower' Finished - Summon Gameobject 'Cleansed Songflower'"),
+(174713,1,0,1,20,0,100,0,4465,0,0,0,0,50,174715,7200,0,0,0,0,1,0,0,0,0,0,0,0,0,"Corrupted Songflower - On Quest 'Corrupted Songflower' Finished - Summon Gameobject 'Cleansed Songflower'"),
+(164885,1,1,0,61,0,100,0,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Corrupted Night Dragon - On Link - Despawn"),
+(173324,1,1,0,61,0,100,0,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Corrupted Night Dragon - On Link - Despawn"),
+(174608,1,1,0,61,0,100,0,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Corrupted Night Dragon - On Link - Despawn"),
+(174684,1,1,0,61,0,100,0,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Corrupted Night Dragon - On Link - Despawn"),
+(164886,1,1,0,61,0,100,0,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Corrupted Songflower - On Link - Despawn"),
+(171939,1,1,0,61,0,100,0,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Corrupted Songflower - On Link - Despawn"),
+(171942,1,1,0,61,0,100,0,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Corrupted Songflower - On Link - Despawn"),
+(174594,1,1,0,61,0,100,0,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Corrupted Songflower - On Link - Despawn"),
+(174595,1,1,0,61,0,100,0,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Corrupted Songflower - On Link - Despawn"),
+(174596,1,1,0,61,0,100,0,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Corrupted Songflower - On Link - Despawn"),
+(174597,1,1,0,61,0,100,0,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Corrupted Songflower - On Link - Despawn"),
+(174598,1,1,0,61,0,100,0,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Corrupted Songflower - On Link - Despawn"),
+(174712,1,1,0,61,0,100,0,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Corrupted Songflower - On Link - Despawn"),
+(174713,1,1,0,61,0,100,0,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Corrupted Songflower - On Link - Despawn"),
+(164888,1,1,0,61,0,100,0,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Corrupted Whipper Root - On Link - Despawn"),
+(173284,1,1,0,61,0,100,0,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Corrupted Whipper Root - On Link - Despawn"),
+(174605,1,1,0,61,0,100,0,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Corrupted Whipper Root - On Link - Despawn"),
+(174606,1,1,0,61,0,100,0,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Corrupted Whipper Root - On Link - Despawn"),
+(174607,1,1,0,61,0,100,0,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Corrupted Whipper Root - On Link - Despawn"),
+(174686,1,1,0,61,0,100,0,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Corrupted Whipper Root - On Link - Despawn"),
+(164887,1,1,0,61,0,100,0,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Corrupted Windblossom - On Link - Despawn"),
+(173327,1,1,0,61,0,100,0,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Corrupted Windblossom - On Link - Despawn"),
+(174599,1,1,0,61,0,100,0,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Corrupted Windblossom - On Link - Despawn"),
+(174600,1,1,0,61,0,100,0,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Corrupted Windblossom - On Link - Despawn"),
+(174601,1,1,0,61,0,100,0,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Corrupted Windblossom - On Link - Despawn"),
+(174602,1,1,0,61,0,100,0,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Corrupted Windblossom - On Link - Despawn"),
+(174603,1,1,0,61,0,100,0,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Corrupted Windblossom - On Link - Despawn"),
+(174604,1,1,0,61,0,100,0,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Corrupted Windblossom - On Link - Despawn"),
+(174708,1,1,0,61,0,100,0,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Corrupted Windblossom - On Link - Despawn"),
+(174709,1,1,0,61,0,100,0,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Corrupted Windblossom - On Link - Despawn");
+
+-- Fix messed up data
+-- UPDATE `gameobject_template` SET `Data2` = 2244, `Data3` = 0 WHERE `entry` = 171943;
+UPDATE `gameobject_template` SET `AIName` = "SmartGameObjectAI" WHERE `entry` IN (171943,164881,173325,174609,174685,164882,171940,174610,174612,174613,174614,174615,174714,174715,164883,174622,174623,174624,174625,174687,164884,173326,174616,174617,174618,174619,174620,174621,174710,174711);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (171943,164881,173325,174609,174685,164882,171940,174610,174612,174613,174614,174615,174714,174715,164883,174622,174623,174624,174625,174687,164884,173326,174616,174617,174618,174619,174620,174621,174710,174711) AND `source_type` = 1;
+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`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES
+(164881,1,0,0,71,0,100,0,293,0,0,0,0,105,16,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cleansed Night Dragon - On Event 293 Inform - Add Flag Not Selectable"),
+(173325,1,0,0,71,0,100,0,4178,0,0,0,0,105,16,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cleansed Night Dragon - On Event 4178 Inform - Add Flag Not Selectable"),
+(174609,1,0,0,71,0,100,0,4247,0,0,0,0,105,16,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cleansed Night Dragon - On Event 4247 Inform - Add Flag Not Selectable"),
+(174685,1,0,0,71,0,100,0,4265,0,0,0,0,105,16,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cleansed Night Dragon - On Event 4265 Inform - Add Flag Not Selectable"),
+(171943,1,0,0,71,0,100,0,2244,0,0,0,0,105,16,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cleansed Songflower - On Event 2244 Inform - Add Flag Not Selectable"),
+(164882,1,0,0,71,0,100,0,4059,0,0,0,0,105,16,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cleansed Songflower - On Event 4059 Inform - Add Flag Not Selectable"),
+(171940,1,0,0,71,0,100,0,4079,0,0,0,0,105,16,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cleansed Songflower - On Event 4079 Inform - Add Flag Not Selectable"),
+(174610,1,0,0,71,0,100,0,4215,0,0,0,0,105,16,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cleansed Songflower - On Event 4215 Inform - Add Flag Not Selectable"),
+(174612,1,0,0,71,0,100,0,4216,0,0,0,0,105,16,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cleansed Songflower - On Event 4216 Inform - Add Flag Not Selectable"),
+(174613,1,0,0,71,0,100,0,4217,0,0,0,0,105,16,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cleansed Songflower - On Event 4217 Inform - Add Flag Not Selectable"),
+(174614,1,0,0,71,0,100,0,4218,0,0,0,0,105,16,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cleansed Songflower - On Event 4218 Inform - Add Flag Not Selectable"),
+(174615,1,0,0,71,0,100,0,4219,0,0,0,0,105,16,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cleansed Songflower - On Event 4219 Inform - Add Flag Not Selectable"),
+(174714,1,0,0,71,0,100,0,4276,0,0,0,0,105,16,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cleansed Songflower - On Event 4276 Inform - Add Flag Not Selectable"),
+(174715,1,0,0,71,0,100,0,4280,0,0,0,0,105,16,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cleansed Songflower - On Event 4280 Inform - Add Flag Not Selectable"),
+(164883,1,0,0,71,0,100,0,4118,0,0,0,0,105,16,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cleansed Whipper Root - On Event 4118 Inform - Add Flag Not Selectable"),
+(174622,1,0,0,71,0,100,0,4234,0,0,0,0,105,16,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cleansed Whipper Root - On Event 4234 Inform - Add Flag Not Selectable"),
+(174623,1,0,0,71,0,100,0,4235,0,0,0,0,105,16,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cleansed Whipper Root - On Event 4235 Inform - Add Flag Not Selectable"),
+(174624,1,0,0,71,0,100,0,4236,0,0,0,0,105,16,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cleansed Whipper Root - On Event 4236 Inform - Add Flag Not Selectable"),
+(174625,1,0,0,71,0,100,0,4237,0,0,0,0,105,16,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cleansed Whipper Root - On Event 4237 Inform - Add Flag Not Selectable"),
+(174687,1,0,0,71,0,100,0,4260,0,0,0,0,105,16,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cleansed Whipper Root - On Event 4260 Inform - Add Flag Not Selectable"),
+(164884,1,0,0,71,0,100,0,4102,0,0,0,0,105,16,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cleansed Windblossom - On Event 4102 Inform - Add Flag Not Selectable"),
+(173326,1,0,0,71,0,100,0,4185,0,0,0,0,105,16,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cleansed Windblossom - On Event 4185 Inform - Add Flag Not Selectable"),
+(174616,1,0,0,71,0,100,0,4192,0,0,0,0,105,16,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cleansed Windblossom - On Event 4192 Inform - Add Flag Not Selectable"),
+(174617,1,0,0,71,0,100,0,4193,0,0,0,0,105,16,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cleansed Windblossom - On Event 4193 Inform - Add Flag Not Selectable"),
+(174618,1,0,0,71,0,100,0,4194,0,0,0,0,105,16,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cleansed Windblossom - On Event 4194 Inform - Add Flag Not Selectable"),
+(174619,1,0,0,71,0,100,0,4195,0,0,0,0,105,16,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cleansed Windblossom - On Event 4195 Inform - Add Flag Not Selectable"),
+(174620,1,0,0,71,0,100,0,4196,0,0,0,0,105,16,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cleansed Windblossom - On Event 4196 Inform - Add Flag Not Selectable"),
+(174621,1,0,0,71,0,100,0,4197,0,0,0,0,105,16,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cleansed Windblossom - On Event 4197 Inform - Add Flag Not Selectable"),
+(174710,1,0,0,71,0,100,0,4284,0,0,0,0,105,16,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cleansed Windblossom - On Event 4284 Inform - Add Flag Not Selectable"),
+(174711,1,0,0,71,0,100,0,4288,0,0,0,0,105,16,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cleansed Windblossom - On Event 4288 Inform - Add Flag Not Selectable");
+
+DELETE FROM `gameobject` WHERE `id` IN (171943,164881,173325,174609,174685,164882,171940,174610,174612,174613,174614,174615,174714,174715,164883,174622,174623,174624,174625,174687,164884,173326,174616,174617,174618,174619,174620,174621,174710,174711);