[Trinity SQL] Cast spell when entering a certain area

[Synth]

Hello Emudevs,today i'm going to share a simple query that will cast spell when you enter certain area the sql code actually made by Mthsena.

SQL info:
●Cast a spell when player entering a certain area.
●Query easily editable for inexperienced users.

SQL:

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');

If you find any error or you have a question feel free to ask me.

Thank you!
Best regards,
Synth !

 

[Tommy]

Thanks again. \o/

 

[Synth]

Thanks again. \o/

No problem