1 (edited by robthewizz 2015-08-06 22:56:44)

Hi I came accross the below and im wondering how to do this in oregon core.
-------------------------------------------------------------------------------------------------------------------------------------------------------------
SQL info:
●Cast a spell when player entering a certain area.

SQL:
Code:
SET @SPELL_ID := ''; -- Type your Spell ID
SET @AREA_ID := ''; -- Type your Area ID
SET @STAY_AURA := '0'; -- If you want to spell stay when player leaves from area, type the o id of the spell as negative value, example: -69874, If 0 the spell will be removed when player leaves from area.
--
-- Data
INSERT INTO `spell_area` (`spell`, `area`, `quest_start`, `quest_end`, `aura_spell`, `racemask`, `gender`, `autocast`, `quest_start_status`, `quest_end_status`) VALUES(@SPELL_ID,@AREA_ID,'0','0',@STAY_AURA,'0','2','1','0','0');

-------------------------------------------------------------------------------------------------------------------------------------------------------------

Thanks in advance,

Rob

Hey, Adding support for spell_area is definitely on my todo list. Currently there's no way to do this without making core modifications.

Currently you can use UpdateZoneDependentAuras method in Player class.