Scripts/Botanica: Rework Warp Splinter (#27621)

(cherry picked from commit 78327500d816d923ece63a940fb82bde16d8f8e9)

1 files changed, 15 insertions, 0 deletions

diff --git a/sql/updates/world/master/2022_03_25_10_world_2022_01_22_08_world.sql b/sql/updates/world/master/2022_03_25_10_world_2022_01_22_08_world.sql
new file mode 100644
index 00000000000..3b0cee0e0bb
--- /dev/null
+++ b/sql/updates/world/master/2022_03_25_10_world_2022_01_22_08_world.sql
@@ -0,0 +1,15 @@
+--
+DELETE FROM `spell_target_position` WHERE `ID` IN (34727,34730,34731,34732,34733,34734,34735,34736,34737,34739);
+INSERT INTO `spell_target_position` (`ID`, `EffectIndex`, `MapID`, `PositionX`, `PositionY`, `PositionZ`, `VerifiedBuild`) VALUES
+(34727,0,553,26,419,-25,14007),
+(34731,0,553,56,428,-25,14007),
+(34733,0,553,94,416,-27,14007),
+(34734,0,553,94,376,-27,14007),
+(34736,0,553,66,353,-26,14007),
+(34739,0,553,33,366,-25,14007);
+
+UPDATE `creature_template` SET `ScriptName` = 'npc_warp_splinter_sapling' WHERE `entry` = 19949;
+
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` = 13 AND `SourceEntry` = 34742;
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorType`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES
+(13,1,34742,0,0,31,0,3,19949,0,0,0,0,"","Group 0: Spell 'Ancestral Life' (Effect 0) targets creature 'Sapling'");