数据库:world数据库:spell_area

差别

这里会显示出您选择的修订版和当前版本之间的差别。

到此差别页面的链接

--- 数据库:world数据库:spell_area [2023/10/03 18:10] – 创建 admin
+++ 数据库:world数据库:spell_area [2023/10/03 18:12] (当前版本) – [quest_start_status, quest_end_status] admin
@@ 行 82: / 行 82: @@
 You should have the spell 92237 when entering the cavern IF :
-The start quest 28725 is incomplete, complete or rewarded (2 | 8 | 64 = 74)
+  * The start quest 28725 is incomplete, complete or rewarded (2 | 8 | 64 = 74)
-The end quest 28727 is not taked (none), incomplete or complete BUT not rewarded (1 | 2 | 8 = 11)
+  * 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 :
+<code>
 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);
-Quest Status	Flag	Explanation
+</code>
-QUEST_STATUS_NONE = 0	1	Player does not have or had quest at all. He could accept it, but he did not (yet).
+^Quest Status^Flag^Explanation^
-QUEST_STATUS_COMPLETE = 1	2	Player fulfilled objectives, but did not hand it in yet.
+|QUEST_STATUS_NONE = 0|1|Player does not have or had quest at all. He could accept it, but he did not (yet).|
-QUEST_STATUS_UNAVAILABLE = 2	4 (NOT USED)	(Not used)
+|QUEST_STATUS_COMPLETE = 1|2|Player fulfilled objectives, but did not hand it in yet.|
-QUEST_STATUS_INCOMPLETE = 3	8	Player did not fulfill objectives yet
+|<del>QUEST_STATUS_UNAVAILABLE = 2</del>|4 (NOT USED)|(Not used)|
-QUEST_STATUS_AVAILABLE = 4	16 (NOT USED)	(Not used)
+|QUEST_STATUS_INCOMPLETE = 3|8|Player did not fulfill objectives yet|
-QUEST_STATUS_FAILED = 5	32	Player failed to fulfill objectives for any reason, e.g. time limit
+|<del>QUEST_STATUS_AVAILABLE = 4</del>|16 (NOT USED)|(Not used)|
-QUEST_STATUS_REWARDED = 6	64	Player handed quest in and this is sort of a post-quest interaction
+|QUEST_STATUS_FAILED = 5|32|Player failed to fulfill objectives for any reason, e.g. time limit|
+|QUEST_STATUS_REWARDED = 6|64|Player handed quest in and this is sort of a post-quest interaction|
 Example for a SQL
  For a `quest_end_status` that should contain QUEST_STATUS_NONE (1), QUEST_STATUS_COMPLETE (2) and QUEST_STATUS_INCOMPLETE (8):
+<code>
 -- equivalent to `quest_end_status`= 11
 UPDATE `spell_area` SET `quest_end_status`= (1|2|8) WHERE `spell`=XXXXX AND `area`=YYYY;
+</code>
 Some examples:
-An area could pacify all players (spell 39331)
+  * An area could pacify all players (spell 39331)
-Another area could full heal every 1 second (spell 48591)
+  * Another area could full heal every 1 second (spell 48591)
-Teleport player out of an area (spell 53141)
+  * Teleport player out of an area (spell 53141)
-Factions-specific buffs, e.g. in Icecrown Citadel:
+  * Factions-specific buffs, e.g. in Icecrown Citadel:
-"Hellscream's Warsong" (spell 73822) for horde
+  * "Hellscream's Warsong" (spell 73822) for horde
-"Strength of Wrynn" (spell 73828) for alliance
+  * "Strength of Wrynn" (spell 73828) for alliance
-Even region-based buffs, such as area 440 - Tanaris.
+  * Even region-based buffs, such as area 440 - Tanaris.

数据库/world数据库/spell_area.1696327810.txt.gz · 最后更改: 2023/10/03 18:10 由 admin