Disables SF

From Project Skyfire
Revision as of 17:40, 4 July 2012 by Cheapgamer (talk | contribs) (Created page with "{| align="right" |- | __TOC__ |} {{Back-to:World}} <br> <big>'''The `disables` table'''</big> This table is used to disable dungeons/bgs/spells/etc. <br> <big>'''Struct...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Back to world database list of tables.


The `disables` table

This table is used to disable dungeons/bgs/spells/etc.


Structure

Field Type Attributes Key Null Default Extra Comment
sourceType int(10) unsigned PRI NO
entry int(10) unsigned PRI NO
flags tinyint(3) unsigned NO 0
params_0 varchar(255) NO "
params_1 varchar(255) NO "
comment varchar(255) NO "


Description of the fields

sourceType

Value Type
0 DISABLE_TYPE_SPELL
1 DISABLE_TYPE_QUEST
2 DISABLE_TYPE_MAP
3 DISABLE_TYPE_BATTLEGROUND
4 DISABLE_TYPE_ACHIEVEMENT_CRITERIA
5 DISABLE_TYPE_OUTDOORPVP
6 DISABLE_TYPE_VMAP

entry

Entry of Spell/Quest/Map/BG/Achievement/Map.

flags

If sourceType = DISABLE_TYPE_SPELL: Specifies who the spell is disabled for.

Value Type
0 Spell enabled
1 Spell disabled for players
2 Spell disabled for creatures
4 Spell disabled for pets
8 Spell completely disabled (used for no logner existing spells in DBCs)
16 Spell disabled for MapId
32 Spell disabled for AreaId

Example: INSERT INTO `disables` VALUES (0, 8921, (1+16+32), "571,1", "1519", "Moonfire Example");

This will disable spell Moonfire (8921) for players in maps 571,1 and area 1519.


If sourceType = DISABLE_TYPE_MAP:
Specifies what type of map is disabled (5man/10man/heroic/etc).

Value Type
1 DUNGEON_STATUSFLAG_NORMAL OR RAID_STATUSFLAG_10MAN_NORMAL
2 DUNGEON_STATUSFLAG_HEROIC OR RAID_STATUSFLAG_25MAN_NORMAL
4 RAID_STATUSFLAG_10MAN_HEROIC
8 RAID_STATUSFLAG_25MAN_HEROIC

The value is a bitmask of VALID modes for the specific map, 15 is as such NOT a valid mask on certain maps, only those actually found possible for the respective map.


If sourceType = DISABLE_TYPE_VMAP:
Specifies on which map should be vMap disabled

Value Type
1 VMAP_DISABLE_AREAFLAG
2 VMAP_DISABLE_HEIGHT
4 VMAP_DISABLE_LOS
8 VMAP_LIQUIDSTATUS

Example: INSERT INTO `disables` VALUES (6, 1, (2 + 4), 0, 0, "Disable Kalimdor vMaps");

This will disable vMaps on whole Kalimdor.

If sourceType = DISABLE_TYPE_QUEST:

No flags needed just add the entry to the table with `flags`=0.

If sourceType = DISABLE_TYPE_ACHIEVEMENT_CRITERIA:

No flags needed just add the entry to the table with `flags`=0.

If sourceType = DISABLE_TYPE_OUTDOORPVP:

No flags needed just add the entry to the table with `flags`=0.

params_0

MapId if DISABLE_TYPE_SPELL used, 0 for all maps.

params_1

AreaId if DISABLE_TYPE_SPELL used, 0 for all areas.

comment

A comment as to why the something was disabled, or any other text that you want.