diff options
| author | offl <11556157+offl@users.noreply.github.com> | 2022-01-22 19:02:07 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2022-01-22 19:02:07 +0200 |
| commit | 78327500d816d923ece63a940fb82bde16d8f8e9 (patch) | |
| tree | 4621fe4d2785c04f119da41ec2456b4883923f40 /sql | |
| parent | 41da43d9f240ecd9976a440824507d73891eeeec (diff) | |
Scripts/Botanica: Rework Warp Splinter (#27621)
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/3.3.5/2022_01_22_08_world.sql | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2022_01_22_08_world.sql b/sql/updates/world/3.3.5/2022_01_22_08_world.sql new file mode 100644 index 00000000000..85f46bd5fc3 --- /dev/null +++ b/sql/updates/world/3.3.5/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`, `Orientation`, `VerifiedBuild`) VALUES +(34727,0,553,26,419,-25,5.096362,14007), +(34731,0,553,56,428,-25,4.782202,14007), +(34733,0,553,94,416,-27,4.049164,14007), +(34734,0,553,94,376,-27,2.9147,14007), +(34736,0,553,66,353,-26,1.815143,14007), +(34739,0,553,33,366,-25,1.186824,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'"); |