From a35d4f08a3f9f086eae94dccbfda2ff0c8eb5ae3 Mon Sep 17 00:00:00 2001 From: FrancescoBorzi Date: Mon, 25 Feb 2019 19:24:20 +0100 Subject: Import DB wiki from TC 335 --- docs/disables.md | 229 ++++++++++++++++++++++++++++++++++++++++++++++++++++--- 1 file changed, 219 insertions(+), 10 deletions(-) (limited to 'docs/disables.md') diff --git a/docs/disables.md b/docs/disables.md index f432a65..0cbf107 100644 --- a/docs/disables.md +++ b/docs/disables.md @@ -1,10 +1,219 @@ -[Database Structure](Database-Structure) > [World-Database](World-Database) > [disables](disables) - -Column | Type | Description ---- | --- | --- -SourceType | int(10) unsigned | -Entry | int(10) unsigned | -Flags | tinyint(3) unsigned | -Params_0 | varchar(255) | -Params_1 | varchar(255) | -Comment | varchar(255) | +# disables + +`Back-to:World` + +**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

NULL


+


+

entry

int(10)

unsigned

PRI

NO

NULL


+


+

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 | +| 7 | DISABLE\_TYPE\_MMAP | +| 8 | DISABLE\_TYPE\_LFG\_MAP | + +### 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 | +| 64 | Line of Sight (LOS) is disabled for this spell (replaces "vmap.ignoreSpellIds" config option) | + +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:*** + +***If sourceType = DISABLE\_TYPE\_ACHIEVEMENT\_CRITERIA:*** + +***If sourceType = DISABLE\_TYPE\_OUTDOORPVP:*** + +***If sourceType = DISABLE\_TYPE\_MMAP:*** + +******If sourceType = DISABLE\_TYPE\_LFG\_MAP:*** +*** + +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. -- cgit