Cheapgamer: Created page with "{| align="right" |- | TOC |} {{Back-to:World}}
'''The `disables` table''' This table is used to disable dungeons/bgs/spells/etc.
'''Struct..."

2012-07-04T23:40:40Z

Created page with "{| align="right" |- | __TOC__ |} {{Back-to:World}} <big>'''The `disables` table'''</big> This table is used to disable dungeons/bgs/spells/etc. <big>'''Struct..."

New page

{| align="right"
|-
| __TOC__
|}

{{Back-to:World}}

 <big>'''The `disables` table'''</big>

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

 <big>'''Structure'''</big>

{| border="1"
|-
| '''Field'''
| '''Type'''
| '''Attributes'''
| '''Key'''
| '''Null'''
| '''Default'''
| '''Extra'''
| '''Comment'''
|-
| [[#sourceType|sourceType]]
| int(10)
| unsigned
| PRI
| NO
|
|
|
|-
| [[#entry|entry]]
| int(10)
| unsigned
| PRI
| NO
|
|
|
|-
| [[#flags|flags]]
| tinyint(3)
| unsigned
|
| NO
| 0
|
|
|-
| [[#params_0|params_0]]
| varchar(255)
|
|
| NO
| "
|
|
|-
| [[#params_1|params_1]]
| varchar(255)
|
|
| NO
| "
|
|
|-
| [[#comment|comment]]
| varchar(255)
|
|
| NO
| "
|
|
|}

 <big>'''Description of the fields'''</big>

==== sourceType ====

{| cellspacing="0" cellpadding="3" border="1"
|-
! 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.

{| cellspacing="0" cellpadding="3" border="1"
|-
! 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 [[Maps.dbc SF|MapId]]
|-
| 32
| Spell disabled for [[AreaTable.dbc SF|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).

{| cellspacing="0" cellpadding="3" border="1"
|-
! 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

{| cellspacing="0" cellpadding="3" border="1"
|-
! 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 ====

[[Maps.dbc SF|MapId]] if DISABLE_TYPE_SPELL used, 0 for all maps.

==== params_1 ====

[[AreaTable.dbc SF|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.

[[Category:SkyFire_World_database_tables]]

Disables SF - Revision history

Cheapgamer: Created page with "{| align="right" |- | __TOC__ |} {{Back-to:World}} '''The `disables` table''' This table is used to disable dungeons/bgs/spells/etc. '''Struct..."

Cheapgamer: Created page with "{| align="right" |- | TOC |} {{Back-to:World}}
'''The `disables` table''' This table is used to disable dungeons/bgs/spells/etc.
'''Struct..."