Comparación de páginas

...

Within quest_end_status,  you can define the mask of quest status inadmissible for required for quest_end. 

Example:Quest 29761 applies a buff on accepting a quest and removes it on handing it in. You also want the spell to remain after completing the quest. Thus, you combine the QUEST_STATUS_ flags for *_INCOMPLETE (8), *_REWARDED (64) and *_COMPLETE (2) within quest_start_status mask. Thus, you end up with a `quest_start_status`=

Area 257 is a cavern on Teldrassil. What we want is simple : When the player take the 28725 quest, he have the aura in the cavern. When he finish the 28727 quest, the aura disappear.

You should have the spell 92237 when entering the cavern IF :

    The start quest 28725 is incomplete, complete or rewarded (2 | 8 | 64 ). If at the same time you need to remove the buff when an other quest XXXX is accepted (and restore the buff when this quest is handed in), you define `quest_end` = XXXX and `quest_end_status`=(2|8|32).

Guiding principle:

...

= 74)

    The end quest 28727 is not taked (none), incomplete or complete BUT not rewarded (1 | 2 | 8 = 11)

Here is the SQL for this example : 

INSERT INTO spell_area (spell, area, quest_start, quest_end, autocast, quest_start_status, quest_end_status) VALUES (92237, 257, 28725, 28727, 1, 74, 11);

...