From 6e12d64f0728ddcec447ee65d7a4ac81e9d3cba7 Mon Sep 17 00:00:00 2001 From: Walter Pagani Date: Wed, 6 Jan 2021 14:35:07 -0300 Subject: docs: Converting from HTML to Markdown part #3 (#331) --- docs/achievement_dbc.md | 200 +- docs/areatrigger_scripts.md | 61 +- docs/areatrigger_tavern.md | 61 +- docs/areatrigger_template_actions.md | 77 +- docs/battlemaster_entry.md | 51 +- docs/character_battleground_random.md | 39 +- docs/character_queststatus_weekly.md | 51 +- docs/creature_onkill_reputation.md | 204 +- docs/creature_questender.md | 51 +- docs/creature_queststarter.md | 51 +- docs/exploration_basexp.md | 35 +- docs/game_event_arena_seasons.md | 51 +- docs/game_event_gameobject.md | 51 +- docs/game_event_save.md | 63 +- docs/game_graveyard_zone.md | 45 +- docs/gameobject_queststarter.md | 51 +- docs/group_instance.md | 63 +- docs/guild_rank.md | 219 +- docs/item_loot_money.md | 51 +- docs/item_template.md | 4017 ++++++--------------------------- docs/lfg_data.md | 73 +- docs/lfg_dungeon_encounters.md | 53 +- docs/mail.md | 254 +-- docs/outdoorpvp_template.md | 69 +- docs/player_xp_for_level.md | 65 +- docs/pool_quest_save.md | 51 +- docs/realmlist.md | 525 +---- docs/skill_fishing_base_level.md | 51 +- docs/spell_proc.md | 593 +---- docs/spell_threat.md | 51 +- 30 files changed, 1257 insertions(+), 6020 deletions(-) (limited to 'docs') diff --git a/docs/achievement_dbc.md b/docs/achievement_dbc.md index 0b25073..cbd9483 100644 --- a/docs/achievement_dbc.md +++ b/docs/achievement_dbc.md @@ -1,6 +1,6 @@ # achievement\_dbc -` Back-to:World ` +[<-Back-to:World](database-world.md) **The \`achievement\_dbc\` table** @@ -8,100 +8,23 @@ Stores achievement data that is missing in [Achievement.dbc](Achievement) **Structure** - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

ID

int(10)

unsigned

PRI

NO

 

 

 

requiredFaction

int(11)

signed

 

NO

-1

 

 

mapID

int(11)

signed

 

NO

-1

 

 

points

int(10)

unsigned

 

NO

0

 

Achievement points awarded for completing the achievement, has no use serverside

flags

int(10)

unsigned

 

NO

0

 

 

count

int(10)

unsigned

 

NO

0

 

 

refAchievement

int(10)

unsigned

 

NO

0

 

 

+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|----------------------|---------|------------|-----|------|---------|-------|----------------------------------------------------------------------------------| +| [ID][1] | int(10) | unsigned | PRI | NO | | | | +| [requiredFaction][2] | int(11) | signed | | NO | -1 | | | +| [mapID][3] | int(11) | signed | | NO | -1 | | | +| [points][4] | int(10) | unsigned | | NO | 0 | | Achievement points awarded for completing the achievement, has no use serverside | +| [flags][5] | int(10) | unsigned | | NO | 0 | | | +| [count][6] | int(10) | unsigned | | NO | 0 | | | +| [refAchievement][7] | int(10) | unsigned | | NO | 0 | | | + +[1]: #id +[2]: #requiredfaction +[3]: #mapid +[4]: #points +[5]: #flags +[6]: #count +[7]: #refachievement **Description of the fields** @@ -111,10 +34,11 @@ This is the ID of the achievement from [Achievement\_Criteria.dbc](Achievement+C ### requiredFaction -- Condition: - - Both: -1, - - Horde: 0, - - Alliance: 1 +| Condition | Faction | +|-----------|---------| +| Both | -1 | +| Horde | 0 | +| Alliance | 1 | ### mapID @@ -126,72 +50,18 @@ Achievement points awarded for completing the achievement, has no use serverside ### flags - ----- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Name

Value

Comment

ACHIEVEMENT_FLAG_COUNTER

0x00000001

Just count statistic (never stop and complete)

ACHIEVEMENT_FLAG_HIDDEN

0x00000002

Not sent to client - internal use only

ACHIEVEMENT_FLAG_STORE_MAX_VALUE

0x00000004

Store only max value? used only in "Reach level xx"

ACHIEVEMENT_FLAG_SUMM

0x00000008

Use summ criteria value from all reqirements (and calculate max value)

ACHIEVEMENT_FLAG_MAX_USED

0x00000010

Show max criteria (and calculate max value ??)

ACHIEVEMENT_FLAG_REQ_COUNT

0x00000020

Use not zero req count (and calculate max value)

ACHIEVEMENT_FLAG_AVERAGE

0x00000040

Show as average value (value / time_in_days) depend from other flag (by def use last criteria value)

ACHIEVEMENT_FLAG_BAR

0x00000080

Show as progress bar (value / max vale) depend from other flag (by def use last criteria value)

ACHIEVEMENT_FLAG_REALM_FIRST_REACH

0x00000100

 

ACHIEVEMENT_FLAG_REALM_FIRST_KILL

0x00000200

 

+| Name | Value | Comment | +|------------------------------------|------------|------------------------------------------------------------------------------------------------------| +| ACHIEVEMENT_FLAG_COUNTER | 0x00000001 | Just count statistic (never stop and complete) | +| ACHIEVEMENT_FLAG_HIDDEN | 0x00000002 | Not sent to client - internal use only | +| ACHIEVEMENT_FLAG_STORE_MAX_VALUE | 0x00000004 | Store only max value? used only in "Reach level xx" | +| ACHIEVEMENT_FLAG_SUMM | 0x00000008 | Use summ criteria value from all reqirements (and calculate max value) | +| ACHIEVEMENT_FLAG_MAX_USED | 0x00000010 | Show max criteria (and calculate max value ??) | +| ACHIEVEMENT_FLAG_REQ_COUNT | 0x00000020 | Use not zero req count (and calculate max value) | +| ACHIEVEMENT_FLAG_AVERAGE | 0x00000040 | Show as average value (value / time_in_days) depend from other flag (by def use last criteria value) | +| ACHIEVEMENT_FLAG_BAR | 0x00000080 | Show as progress bar (value / max vale) depend from other flag (by def use last criteria value) | +| ACHIEVEMENT_FLAG_REALM_FIRST_REACH | 0x00000100 | | +| ACHIEVEMENT_FLAG_REALM_FIRST_KILL | 0x00000200 | | ### count diff --git a/docs/areatrigger_scripts.md b/docs/areatrigger_scripts.md index ab7a988..89bf584 100644 --- a/docs/areatrigger_scripts.md +++ b/docs/areatrigger_scripts.md @@ -8,50 +8,13 @@ Allows for an area trigger to be scripted with Trinity Script. **Structure** - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

entry

mediumint(8)

signed

PRI

NO

NULL

 

 

ScriptName

char(64)

signed

 

NO

NULL

 

 

+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|-----------------|--------------|------------|-----|------|---------|-------|---------| +| [entry][1] | mediumint(8) | signed | PRI | NO | NULL | | | +| [ScriptName][2] | char(64) | signed | | NO | NULL | | | + +[1]: #entry +[2]: #scriptname **Description of the fields** @@ -63,3 +26,13 @@ This is the trigger identifier from [AreaTrigger.dbc](DBC-AreaTrigger) The ScriptName for when scripting it in the core. This might also be 'SmartTrigger'. It will than use [SmartAI](smart_scripts). + +### Examples + +| entry | ScriptName | +|-------|-------------------| +| 302 | at_sentry_point | +| 962 | SmartTrigger | +| 1447 | SmartTrigger | +| 1526 | at_ring_of_law | +| 1726 | at_scent_larkorwi | diff --git a/docs/areatrigger_tavern.md b/docs/areatrigger_tavern.md index 257a091..8a7941f 100644 --- a/docs/areatrigger_tavern.md +++ b/docs/areatrigger_tavern.md @@ -8,50 +8,13 @@ Enable a trigger when player enters a city or tavern. This causes the player to **Structure** - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

id

mediumint(8)

unsigned

PRI

NO

0

 

Identifier

name

text

signed

 

YES

NULL

 

 

+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|-----------|--------------|------------|-----|------|---------|-------|------------| +| [id][1] | mediumint(8) | unsigned | PRI | NO | 0 | | Identifier | +| [name][2] | text | signed | | YES | NULL | | | + +[1]: #id +[2]: #name **Description of the fields** @@ -62,3 +25,13 @@ This is the trigger identifier, see [AreaTrigger.dbc](DBC-AreaTrigger) ### name Name of the city or tavern. This is purely for descriptive purposes. + +### Example + +| id | name | +|-----|----------------------------------------------| +| 71 | Westfall - Sentinel Hill Inn | +| 98 | Nesingwary's Expedition | +| 178 | Strahnbrad | +| 562 | Elwynn Forest - Goldshire - Lion's Pride Inn | +| 682 | Redridge Mountains - Lakeshire Inn | diff --git a/docs/areatrigger_template_actions.md b/docs/areatrigger_template_actions.md index 9e4147e..0b9513a 100644 --- a/docs/areatrigger_template_actions.md +++ b/docs/areatrigger_template_actions.md @@ -8,72 +8,17 @@ This table contains the description of areatrigger actions. **Structure** - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

AreaTriggerId

int(10)

unsigned

PRI

NO


-


-


-

ActionType

int(10)

unsigned

PRI

NO


-


-


-

ActionParam

int(10)

unsigned

PRI

NO


-


-


-

TargetTypeint(10)unsigned
-		NO0
-
-
+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|--------------------|---------|------------|-----|------|---------|-------|---------| +| [AreaTriggerId][1] | int(10) | unsigned | PRI | NO | | | | +| [ActionType][2] | int(10) | unsigned | PRI | NO | | | | +| [ActionParam][3] | int(10) | unsigned | PRI | NO | | | | +| [TargetType][4] | int(10) | unsigned | | NO | 0 | | | + +[1]: #areatriggerid +[2]: #actiontype +[3]: #actionparam +[4]: #targettype **Description of the fields** diff --git a/docs/battlemaster_entry.md b/docs/battlemaster_entry.md index cbdfaa5..73c94a7 100644 --- a/docs/battlemaster_entry.md +++ b/docs/battlemaster_entry.md @@ -8,50 +8,13 @@ Holds information on which NPC can start what battleground or arena. **Structure** - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

entry

mediumint(8)

unsigned

PRI

NO

0

 

Entry of a creature

bg_template

mediumint(8)

unsigned

 

NO

0

 

Batleground template id

+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|------------------|--------------|------------|-----|------|---------|-------|-------------------------| +| [entry][1] | mediumint(8) | unsigned | PRI | NO | 0 | | Entry of a creature | +| [bg_template][2] | mediumint(8) | unsigned | | NO | 0 | | Batleground template id | + +[1]: #entry +[2]: #bg_template **Description of the fields** diff --git a/docs/character_battleground_random.md b/docs/character_battleground_random.md index b5787d4..f26afe5 100644 --- a/docs/character_battleground_random.md +++ b/docs/character_battleground_random.md @@ -8,40 +8,11 @@ This table stores battlegrounds IDs for random battleground sessions. **Structure** - ---------- - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

guid

int (10)

unsigned

PRI

NO

0

 

 

+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|-----------|----------|------------|-----|------|---------|-------|---------| +| [guid][1] | int (10) | unsigned | PRI | NO | 0 | | | + +[1]: #guid **Description of the fields** diff --git a/docs/character_queststatus_weekly.md b/docs/character_queststatus_weekly.md index f00c0d7..46a7336 100644 --- a/docs/character_queststatus_weekly.md +++ b/docs/character_queststatus_weekly.md @@ -8,50 +8,13 @@ Holds information on the weekly quest status of every player. The timers reset a **Structure** - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

guid

int(10)

unsigned

PRI

NO

0

 

Global Unique Identifier

quest

int(10)

unsigned

PRI

NO

0

 

Quest Identifier

+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|------------|---------|------------|-----|------|---------|-------|--------------------------| +| [guid][1] | int(10) | unsigned | PRI | NO | 0 | | Global Unique Identifier | +| [quest][2] | int(10) | unsigned | PRI | NO | 0 | | Quest Identifier | + +[1]: #guid +[2]: #quest **Description of the fields** diff --git a/docs/creature_onkill_reputation.md b/docs/creature_onkill_reputation.md index 32b1bb1..ac40b84 100644 --- a/docs/creature_onkill_reputation.md +++ b/docs/creature_onkill_reputation.md @@ -8,130 +8,29 @@ This table controls the reputation given by creatures when killed by other playe **Structure** - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

creature_id

mediumint(8)

unsigned

PRI

NO

0

 

Creature Identifier

RewOnKillRepFaction1

smallint(6)

signed

 

NO

0

 

 

RewOnKillRepFaction2

smallint(6)

signed

 

NO

0

 

 

MaxStanding1

tinyint(4)

signed

 

NO

0

 

 

IsTeamAward1

tinyint(4)

signed

 

NO

0

 

 

RewOnKillRepValue1

mediumint(9)

signed

 

NO

0

 

 

MaxStanding2

tinyint(4)

signed

 

NO

0

 

 

IsTeamAward2

tinyint(4)

signed

 

NO

0

 

 

RewOnKillRepValue2

mediumint(9)

signed

 

NO

0

 

 

TeamDependent

tinyint(3)

unsigned

 

NO

0

 

 

+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|---------------------------|--------------|------------|-----|------|---------|-------|---------------------| +| [creature_id][1] | mediumint(8) | unsigned | PRI | NO | 0 | | Creature Identifier | +| [RewOnKillRepFaction1][2] | smallint(6) | signed | | NO | 0 | | | +| [RewOnKillRepFaction2][3] | smallint(6) | signed | | NO | 0 | | | +| [MaxStanding1][4] | tinyint(4) | signed | | NO | 0 | | | +| [IsTeamAward1][5] | tinyint(4) | signed | | NO | 0 | | | +| [RewOnKillRepValue1][6] | mediumint(9) | signed | | NO | 0 | | | +| [MaxStanding2][7] | tinyint(4) | signed | | NO | 0 | | | +| [IsTeamAward2][8] | tinyint(4) | signed | | NO | 0 | | | +| [RewOnKillRepValue2][9] | mediumint(9) | signed | | NO | 0 | | | +| [TeamDependent][10] | tinyint(3) | unsigned | | NO | 0 | | | + +[1]: #creature_id +[2]: #rewonkillrepfaction1 +[3]: #rewonkillrepfaction2 +[4]: #maxstanding1 +[5]: #isteamaward1 +[6]: #rewonkillrepvalue1 +[7]: #maxstanding2 +[8]: #isteamaward2 +[9]: #rewonkillrepvalue2 +[10]: #teamdependent **Description of the fields** @@ -147,52 +46,16 @@ The faction ID of the faction that the player will gain or lose points in. See F The maximum standing that the creature will award reputation until. If the player achieves this standing or any other standing higher than this, the creature will not award any reputation. - ---- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

ID

Rank

0

Hated

1

Hostile

2

Unfriendly

3

Neutral

4

Friendly

5

Honored

6

Revered

7

Exalted

+| ID | Rank | +|----|------------| +| 0 | Hated | +| 1 | Hostile | +| 2 | Unfriendly | +| 3 | Neutral | +| 4 | Friendly | +| 5 | Honored | +| 6 | Revered | +| 7 | Exalted | ### IsTeamAward @@ -213,4 +76,3 @@ Boolean 0 or 1. - 0: The creature will give reputation to the any player from both fields (RewOnKillRepFaction1 and RewOnKillRepFaction2) if both fields are non-zero. - 1: The creature will award alliance players the reputation from RewOnKillRepFaction1 and will award horde players the reputation from RewOnKillRepFaction2 - diff --git a/docs/creature_questender.md b/docs/creature_questender.md index 5e8e190..7b78e78 100644 --- a/docs/creature_questender.md +++ b/docs/creature_questender.md @@ -8,50 +8,13 @@ Holds NPC quest ender relations on which NPCs finishes which quests. **Structure** - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

id

mediumint(8)

unsigned

PRI

NO

0

 

Identifier

quest

mediumint(8)

unsigned

PRI

NO

0

 

Quest Identifier

+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|------------|--------------|------------|-----|------|---------|-------|------------------| +| [id][1] | mediumint(8) | unsigned | PRI | NO | 0 | | Identifier | +| [quest][2] | mediumint(8) | unsigned | PRI | NO | 0 | | Quest Identifier | + +[1]: #id +[2]: #quest **Description of the fields** diff --git a/docs/creature_queststarter.md b/docs/creature_queststarter.md index b4e9869..459b25e 100644 --- a/docs/creature_queststarter.md +++ b/docs/creature_queststarter.md @@ -8,50 +8,13 @@ Holds NPC quest giver relations on which NPCs start which quests. **Structure** - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

id

mediumint(8)

unsigned

PRI

NO

0

 

Identifier

quest

mediumint(8)

unsigned

PRI

NO

0

 

Quest Identifier

+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|------------|--------------|------------|-----|------|---------|-------|------------------| +| [id][1] | mediumint(8) | unsigned | PRI | NO | 0 | | Identifier | +| [quest][2] | mediumint(8) | unsigned | PRI | NO | 0 | | Quest Identifier | + +[1]: #id +[2]: #quest **Description of the fields** diff --git a/docs/exploration_basexp.md b/docs/exploration_basexp.md index 718108b..518a0ae 100644 --- a/docs/exploration_basexp.md +++ b/docs/exploration_basexp.md @@ -4,34 +4,13 @@

This table holds the base experience point information needed for when a player explores a new zone.

- - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

level

tinyint(3)

unasigned

PRI

NO

0

basexp

mediumint(8)

signed

NO

0

+| Field | Type | Attributes | Key | Null | Default | +|-------------|--------------|------------|-----|------|---------| +| [level][1] | tinyint(3) | unasigned | PRI | NO | 0 | +| [basexp][2] | mediumint(8) | signed | | NO | 0 | + +[1]: #level +[2]: #basexp **Description of the fields** diff --git a/docs/game_event_arena_seasons.md b/docs/game_event_arena_seasons.md index dfc502e..9beb9cf 100644 --- a/docs/game_event_arena_seasons.md +++ b/docs/game_event_arena_seasons.md @@ -8,50 +8,13 @@ This information comes from sniffs and is NOT supposed to be changed. **Structure** - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

eventEntry

tinyint(3)

unsigned

 

NO

 

Unique

Entry of the game event.

season

tinyint(3)

unsigned

 

NO

 

Unique

Arena season number

+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|-----------------|------------|------------|-----|------|---------|--------|--------------------------| +| [eventEntry][1] | tinyint(3) | unsigned | | NO | | Unique | Entry of the game event. | +| [season][2] | tinyint(3) | unsigned | | NO | | Unique | Arena season number | + +[1]: #evententry +[2]: #season **Description of the fields** diff --git a/docs/game_event_gameobject.md b/docs/game_event_gameobject.md index ff6adf6..f691ab1 100644 --- a/docs/game_event_gameobject.md +++ b/docs/game_event_gameobject.md @@ -8,50 +8,13 @@ Contains all gameobjects instances that participate to any game event. **Structure** - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

eventEntry

tinyint(3)

signed

 

NO

 

 

Entry of the game event. Put negative entry to remove during event.

guid

int(10)

unsigned

PRI

NO

 

Unique

 

+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|-----------------|------------|------------|-----|------|---------|--------|---------------------------------------------------------------------| +| [eventEntry][1] | tinyint(3) | signed | | NO | | | Entry of the game event. Put negative entry to remove during event. | +| [guid][2] | int(10) | unsigned | PRI | NO | | Unique | | + +[1]: #evententry +[2]: #guid **Description of the fields** diff --git a/docs/game_event_save.md b/docs/game_event_save.md index d91599c..5031193 100644 --- a/docs/game_event_save.md +++ b/docs/game_event_save.md @@ -8,60 +8,15 @@ **Structure** - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

event_id

mediumint(8)

unsigned

PRI

NO

NULL

 

 

state

tinyint(3)

unsigned

 

NO

1

 

 

next_start

bigint(11)

unsigned

 

NO

0

 

 

+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|-----------------|--------------|------------|-----|------|---------|-------|---------| +| [event_id][1] | mediumint(8) | unsigned | PRI | NO | NULL | | | +| [state][2] | tinyint(3) | unsigned | | NO | 1 | | | +| [next_start][3] | bigint(11) | unsigned | | NO | 0 | | | + +[1]: #event_id +[2]: #state +[3]: #next_start **Description of the fields** diff --git a/docs/game_graveyard_zone.md b/docs/game_graveyard_zone.md index aaea52b..b5457d2 100644 --- a/docs/game_graveyard_zone.md +++ b/docs/game_graveyard_zone.md @@ -2,42 +2,15 @@ [<-Back-to:World](database-world.md) - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

id

mediumint(8)

unasigned

PRI

NO

0

ghost_zone

mediumint(8)

unasigned

PRI

NO

0

faction

smallint(5)

unasigned

NO

0

+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|-----------------|--------------|------------|-----|------|---------|-------|---------| +| [id][1] | mediumint(8) | unasigned | PRI | NO | 0 | | | +| [ghost_zone][2] | mediumint(8) | unasigned | PRI | NO | 0 | | | +| [faction][3] | smallint(5) | unasigned | | NO | 0 | | | + +[1]: #id +[2]: #ghost_zone +[3]: #faction **Description of the fields** diff --git a/docs/gameobject_queststarter.md b/docs/gameobject_queststarter.md index 98855bd..1cb6197 100644 --- a/docs/gameobject_queststarter.md +++ b/docs/gameobject_queststarter.md @@ -8,50 +8,13 @@ Holds game object quest giver relations. The game objects in this table should a **Structure** - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

id

mediumint(8)

unsigned

PRI

NO

0

 

 

quest

mediumint(8)

unsigned

PRI

NO

0

 

Quest Identifier

+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|------------|--------------|------------|-----|------|---------|-------|------------------| +| [id][1] | mediumint(8) | unsigned | PRI | NO | 0 | | | +| [quest][2] | mediumint(8) | unsigned | PRI | NO | 0 | | Quest Identifier | + +[1]: #id +[2]: #quest **Description of the fields** diff --git a/docs/group_instance.md b/docs/group_instance.md index ff8d6eb..3136282 100644 --- a/docs/group_instance.md +++ b/docs/group_instance.md @@ -8,60 +8,15 @@ **Structure** - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

guid

int(10)

unsigned

PRI

NO

0

 

 

instance

int(10)

unsigned

PRI

NO

0

 

 

permanent

tinyint(3)

unsigned

 

NO

0

 

 

+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|----------------|------------|------------|-----|------|---------|-------|---------| +| [guid][1] | int(10) | unsigned | PRI | NO | 0 | | | +| [instance][2] | int(10) | unsigned | PRI | NO | 0 | | | +| [permanent][3] | tinyint(3) | unsigned | | NO | 0 | | | + +[1]: #guid +[2]: #instance +[3]: #permanent **Description of the fields** diff --git a/docs/guild_rank.md b/docs/guild_rank.md index a823f6c..c2d241c 100644 --- a/docs/guild_rank.md +++ b/docs/guild_rank.md @@ -8,80 +8,19 @@ This table holds the information on all of the ranks available in a guild along **Structure** - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

guildid

int(10)

unsigned

PRI

NO

0

 

 

rid

tinyint(3)

unsigned

PRI

NO

 

 

 

rname

varchar(20)

signed

 

NO

"

 

 

rights

mediumint(8)

unsigned

 

NO

0

 

 

BankMoneyPerDay

int(10)

unsigned

 

NO

0

 

 

+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|----------------------|--------------|------------|-----|------|---------|-------|---------| +| [guildid][1] | int(10) | unsigned | PRI | NO | 0 | | | +| [rid][2] | tinyint(3) | unsigned | PRI | NO | | | | +| [rname][3] | varchar(20) | signed | | NO | " | | | +| [rights][4] | mediumint(8) | unsigned | | NO | 0 | | | +| [BankMoneyPerDay][5] | int(10) | unsigned | | NO | 0 | | | + +[1]: #guildid +[2]: #rid +[3]: #rname +[4]: #rights +[5]: #bankmoneyperday **Description of the fields** @@ -101,117 +40,27 @@ The name of the rank that is displayed in-game. The rights a player with this rank has in the guild. The calculation of multiple rights is a bit different in this case as the rights do not all have 2^n values. To combine ranks, you must do the OR operation (\|) on the two flags. - ----- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Flag

Name

Comments

64

GR_RIGHT_EMPTY

Having just this flag by itself is equivalent to having no rights at all.

65

GR_RIGHT_GCHATLISTEN

Player can read messages in the guild general chat channel.

66

GR_RIGHT_GCHATSPEAK

Player can type messages in the guild general chat channel.

68

GR_RIGHT_OFFCHATLISTEN

Player can read messages in the guild officers channel.

72

GR_RIGHT_OFFCHATSPEAK

Player can type messages in the guild officers channel.

80

GR_RIGHT_INVITE

Can invite other players to guild.

96

GR_RIGHT_REMOVE

Can kick other players out of guild.

192

GR_RIGHT_PROMOTE

Can promote other players.

320

GR_RIGHT_DEMOTE

Can demote other players.

4160

GR_RIGHT_SETMOTD

Can change the guild message of the day.

8256

GR_RIGHT_EPNOTE

Can edit other players' personal notes.

16448

GR_RIGHT_VIEWOFFNOTE

Can view the officer notes of other players.

32832

GR_RIGHT_EOFFNOTE

Can edit officer notes of other players.

65600

GR_RIGHT_MODIFY_GUILD_INFO

Can edit guild info.

131072

GR_RIGHT_WITHDRAW_GOLD_LOCK

Can remove money withdraw capacity.

262144

GR_RIGHT_WITHDRAW_REPAIR

Can withdraw for repair.

524288

GR_RIGHT_WITHDRAW_GOLD

Can withdraw gold.

1048576

GR_RIGHT_CREATE_GUILD_EVENT

Can create a guild event.

1962495

GR_RIGHT_ALL

Has all of the rights.

+| Flag | Name | Comments | +|---------|-----------------------------|---------------------------------------------------------------------------| +| 64 | GR_RIGHT_EMPTY | Having just this flag by itself is equivalent to having no rights at all. | +| 65 | GR_RIGHT_GCHATLISTEN | Player can read messages in the guild general chat channel. | +| 66 | GR_RIGHT_GCHATSPEAK | Player can type messages in the guild general chat channel. | +| 68 | GR_RIGHT_OFFCHATLISTEN | Player can read messages in the guild officers channel. | +| 72 | GR_RIGHT_OFFCHATSPEAK | Player can type messages in the guild officers channel. | +| 80 | GR_RIGHT_INVITE | Can invite other players to guild. | +| 96 | GR_RIGHT_REMOVE | Can kick other players out of guild. | +| 192 | GR_RIGHT_PROMOTE | Can promote other players. | +| 320 | GR_RIGHT_DEMOTE | Can demote other players. | +| 4160 | GR_RIGHT_SETMOTD | Can change the guild message of the day. | +| 8256 | GR_RIGHT_EPNOTE | Can edit other players' personal notes. | +| 16448 | GR_RIGHT_VIEWOFFNOTE | Can view the officer notes of other players. | +| 32832 | GR_RIGHT_EOFFNOTE | Can edit officer notes of other players. | +| 65600 | GR_RIGHT_MODIFY_GUILD_INFO | Can edit guild info. | +| 131072 | GR_RIGHT_WITHDRAW_GOLD_LOCK | Can remove money withdraw capacity. | +| 262144 | GR_RIGHT_WITHDRAW_REPAIR | Can withdraw for repair. | +| 524288 | GR_RIGHT_WITHDRAW_GOLD | Can withdraw gold. | +| 1048576 | GR_RIGHT_CREATE_GUILD_EVENT | Can create a guild event. | +| 1962495 | GR_RIGHT_ALL | Has all of the rights. | ### BankMoneyPerDay diff --git a/docs/item_loot_money.md b/docs/item_loot_money.md index fdf8e06..f1b504a 100644 --- a/docs/item_loot_money.md +++ b/docs/item_loot_money.md @@ -12,50 +12,13 @@ the player either removes the money or destroys the container item. **Structure** - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

container_id

int(10)

unsigned

 

NO

0

 

 

money

int(10)

unsigned

 

NO

0

 

 

+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|-------------------|---------|------------|-----|------|---------|-------|---------| +| [container_id][1] | int(10) | unsigned | | NO | 0 | | | +| [money][2] | int(10) | unsigned | | NO | 0 | | | + +[1]: #container_id +[2]: #money **Description of the fields** diff --git a/docs/item_template.md b/docs/item_template.md index b41f674..2f7540d 100644 --- a/docs/item_template.md +++ b/docs/item_template.md @@ -8,1280 +8,287 @@ Holds information on every item that exists in the game. All items are created f (See additional information in the *ItemPrototype.h* file.) - --------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Comment

entry

mediumint(8)

unsigned

PRI

NO

0

 

class

tinyint(3)

unsigned

 

NO

0

 

subclass

tinyint(3)

unsigned

 

NO

0

 

SoundOverrideSubclass

tinyint(3)

signed

 

NO

-1

 

name

varchar(255)

signed

 

NO

NULL

 

displayid

mediumint(8)

unsigned

 

NO

0

 

Quality

tinyint(3)

unsigned

 

NO

0

 

Flags

bigint(20)

signed

 

NO

0

 

FlagsExtra

int(10)

unsigned

 

NO

0

 

BuyCount

tinyint(3)

unsigned

 

NO

1

 

BuyPrice

bigint(20)

signed

 

NO

0

 

SellPrice

int(10)

unsigned

 

NO

0

 

InventoryType

tinyint(3)

unsigned

 

NO

0

 

AllowableClass

int(11)

signed

 

NO

-1

 

AllowableRace

int(11)

signed

 

NO

-1

 

ItemLevel

smallint(5)

unsigned

 

NO

0

 

RequiredLevel

tinyint(3)

unsigned

 

NO

0

 

RequiredSkill

smallint(5)

unsigned

 

NO

0

 

RequiredSkillRank

smallint(5)

unsigned

 

NO

0

 

requiredspell

mediumint(8)

unsigned

 

NO

0

 

requiredhonorrank

mediumint(8)

unsigned

 

NO

0

 

RequiredCityRank

mediumint(8)

unsigned

 

NO

0

 

RequiredReputationFaction

smallint(5)

unsigned

 

NO

0

 

RequiredReputationRank

smallint(5)

unsigned

 

NO

0

 

maxcount

int(11)

signed

 

NO

0

 

stackable

int(11)

signed

 

NO

1

 

ContainerSlots

smallint(5)

unsigned

 

NO

0

 

StatsCount

tinyint(3)

unsigned

 

NO

0

 

stat_type1

tinyint(3)

unsigned

 

NO

0

 

stat_value1

smallint(6)

signed

 

NO

0

 

stat_type2

tinyint(3)

unsigned

 

NO

0

 

stat_value2

smallint(6)

signed

 

NO

0

 

stat_type3

tinyint(3)

unsigned

 

NO

0

 

stat_value3

smallint(6)

signed

 

NO

0

 

stat_type4

tinyint(3)

unsigned

 

NO

0

 

stat_value4

smallint(6)

signed

 

NO

0

 

stat_type5

tinyint(3)

unsigned

 

NO

0

 

stat_value5

smallint(6)

signed

 

NO

0

 

stat_type6

tinyint(3)

unsigned

 

NO

0

 

stat_value6

smallint(6)

signed

 

NO

0

 

stat_type7

tinyint(3)

unsigned

 

NO

0

 

stat_value7

smallint(6)

signed

 

NO

0

 

stat_type8

tinyint(3)

unsigned

 

NO

0

 

stat_value8

smallint(6)