View Full Version : [Trinity SQL] Cast spell when entering a certain area

09-28-2013, 08:42 PM
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.


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 !

09-28-2013, 08:55 PM
Thanks again. \o/

09-28-2013, 09:02 PM
Thanks again. \o/
No problem ;)