From b698f1ae91c570ad532ed935aeb47f69bd5c487c Mon Sep 17 00:00:00 2001 From: Walter Pagani Date: Fri, 8 Jan 2021 15:23:34 -0300 Subject: docs: Converting from HTML to Markdown part #6 (#335) --- docs/account_tutorial.md | 141 +++------------ docs/achievement_reward.md | 113 ++---------- docs/areatrigger.md | 166 +++--------------- docs/areatrigger_teleport.md | 125 +++---------- docs/areatrigger_template.md | 183 +++---------------- docs/auctionhouse.md | 147 +++------------- docs/channels.md | 132 +++----------- docs/character_banned.md | 99 ++--------- docs/character_battleground_data.md | 168 ++++-------------- docs/character_homebind.md | 99 ++--------- docs/creature.md | 320 ++++++---------------------------- docs/creature_equip_template.md | 91 ++-------- docs/creature_formations.md | 137 +++------------ docs/creature_model_info.md | 111 ++---------- docs/game_event_npc_vendor.md | 111 ++---------- docs/game_tele.md | 115 +++--------- docs/guild.md | 171 +++--------------- docs/guild_bank_eventlog.md | 163 ++++------------- docs/guild_bank_right.md | 109 +++--------- docs/guild_eventlog.md | 130 +++----------- docs/instance.md | 109 +++--------- docs/instance_encounters.md | 87 ++------- docs/item_effect.md | 82 ++++----- docs/item_set_names_locale.md | 135 +++----------- docs/lfg_dungeon_rewards.md | 123 ++----------- docs/logs.md | 127 ++++---------- docs/phase_area.md | 58 ++---- docs/player_factionchange_items.md | 101 ++--------- docs/player_levelstats.md | 141 ++++----------- docs/playercreateinfo.md | 129 +++----------- docs/points_of_interest.md | 207 +++++++--------------- docs/pool_creature.md | 75 ++------ docs/pool_gameobject.md | 75 ++------ docs/pool_pool.md | 77 ++------ docs/pvpstats_players.md | 199 ++++----------------- docs/quest_greeting.md | 97 +++-------- docs/quest_poi.md | 135 ++------------ docs/reputation_spillover_template.md | 219 ++++------------------- docs/spell_bonus_data.md | 115 +++--------- docs/spell_linked_spell.md | 98 ++--------- docs/spell_target_position.md | 99 ++--------- 41 files changed, 955 insertions(+), 4364 deletions(-) diff --git a/docs/account_tutorial.md b/docs/account_tutorial.md index 145273d..5b0f874 100644 --- a/docs/account_tutorial.md +++ b/docs/account_tutorial.md @@ -8,120 +8,27 @@ This table is used to store the tutorial state of all the accounts. **Structure** - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

accountId

int(10)

unsigned

PRI

NO

0

Unique

Account Identifier

tut0

int(10)

unsigned

 

NO

0

 

 

tut1

int(10)

unsigned

 

NO

0

 

 

tut2

int(10)

unsigned

 

NO

0

 

 

tut3

int(10)

unsigned

 

NO

0

 

 

tut4

int(10)

unsigned

 

NO

0

 

 

tut5

int(10)

unsigned

 

NO

0

 

 

tut6

int(10)

unsigned

 

NO

0

 

 

tut7

int(10)

unsigned

 

NO

0

 

 

+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|----------------|---------|------------|-----|------|---------|--------|--------------------| +| [accountId][1] | int(10) | unsigned | PRI | NO | 0 | Unique | Account Identifier | +| [tut0][2] | int(10) | unsigned | | NO | 0 | | | +| [tut1][3] | int(10) | unsigned | | NO | 0 | | | +| [tut2][4] | int(10) | unsigned | | NO | 0 | | | +| [tut3][5] | int(10) | unsigned | | NO | 0 | | | +| [tut4][6] | int(10) | unsigned | | NO | 0 | | | +| [tut5][7] | int(10) | unsigned | | NO | 0 | | | +| [tut6][8] | int(10) | unsigned | | NO | 0 | | | +| [tut7][9] | int(10) | unsigned | | NO | 0 | | | + +[1]: #accountid +[2]: #tut0 +[3]: #tut1 +[4]: #tut2 +[5]: #tut3 +[6]: #tut4 +[7]: #tut5 +[8]: #tut6 +[9]: #tut7 **Description of the fields** @@ -135,10 +42,8 @@ These values 32bits flags. So 8 x 32bits values makes 256 bits available to stor Each bit means: -``` cpp - 0 - Not yet shown - 1 - Shown -``` +- 0 - Not yet shown +- 1 - Shown This is used to diplay only tutorial messages the character did not see before. diff --git a/docs/achievement_reward.md b/docs/achievement_reward.md index 697a26c..e99b55a 100644 --- a/docs/achievement_reward.md +++ b/docs/achievement_reward.md @@ -8,100 +8,25 @@ This table describes the reward that you will receive when you obtain a given ac **Structure** - --------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

ID

mediumint(8)

unsigned

PRI

NO

0

 

TitleA

mediumint(8)

unsigned

 

NO

0

 

TitleH

mediumint(8)

unsigned

 

NO

0

 

ItemID

mediumint(8)

unsigned

 

NO

0

 

Sender

mediumint(8)

unsigned

 

NO

0

 

Subject

varchar(255)

signed

 

YES

NULL

 

Body

text

signed

 

YES

 

 

MailTemplateIDmediumint(8)unsigned YES0 
+| Field | Type | Attributes | Key | Null | Default | Extra | +|---------------------|--------------|------------|-----|------|---------|-------| +| [ID][1] | mediumint(8) | unsigned | PRI | NO | 0 | | +| [TitleA][2] | mediumint(8) | unsigned | | NO | 0 | | +| [TitleH][3] | mediumint(8) | unsigned | | NO | 0 | | +| [ItemID][4] | mediumint(8) | unsigned | | NO | 0 | | +| [Sender][5] | mediumint(8) | unsigned | | NO | 0 | | +| [Subject][6] | varchar(255) | signed | | YES | NULL | | +| [Body][7] | text | signed | | YES | | | +| [MailTemplateID][8] | mediumint(8) | unsigned | | YES | 0 | | + +[1]: #id +[2]: #titlea +[3]: #titleh +[4]: #itemid +[5]: #sender +[6]: #subject +[7]: #body +[8]: #mailtemplateid **Description of the fields** diff --git a/docs/areatrigger.md b/docs/areatrigger.md index 165bcaa..87a179b 100644 --- a/docs/areatrigger.md +++ b/docs/areatrigger.md @@ -8,148 +8,29 @@ This table contains trigger points for events in certain coordinates in the maps **Structure** - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

entry

int (10)

unsigned

PRI

NO

NULL

auto_increment
-


-

map

int(10)

unsigned

PRI

NO

0


-


-

x

FLOAT


-

NO

0


-


-

y

FLOAT


-

NO

0


-


-

zFLOAT
-		NO0
-
-

radius

FLOAT


-

NO

0


-


-

length

FLOAT


-

NO

0


-


-

width

FLOAT


-

NO

0


-


-

height

FLOAT


-

NO

0


-


-

orientation

FLOAT


-

NO

0


-


-

+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|-------------------|----------|------------|-----|------|---------|----------------|---------| +| [entry][1] | int (10) | unsigned | PRI | NO | NULL | auto_increment | | +| [map][2] | int(10) | unsigned | PRI | NO | 0 | | | +| [x][3] | FLOAT | | | NO | 0 | | | +| [y][4] | FLOAT | | | NO | 0 | | | +| [z][5] | FLOAT | | | NO | 0 | | | +| [radius][6] | FLOAT | | | NO | 0 | | | +| [length][7] | FLOAT | | | NO | 0 | | | +| [width][8] | FLOAT | | | NO | 0 | | | +| [height][9] | FLOAT | | | NO | 0 | | | +| [orientation][10] | FLOAT | | | NO | 0 | | | + +[1]: #entry +[2]: #map +[3]: #x +[4]: #y +[5]: #z +[6]: #radius +[7]: #length +[8]: #width +[9]: #height +[10]: #orientation **Description of the fields** @@ -172,4 +53,3 @@ This contains the radius of activation of the trigger. ### Length, Width, Height and Orientation these fields contain the values for the physics and behavior of a given trigger. - diff --git a/docs/areatrigger_teleport.md b/docs/areatrigger_teleport.md index 6cd6336..5a70778 100644 --- a/docs/areatrigger_teleport.md +++ b/docs/areatrigger_teleport.md @@ -1,6 +1,6 @@ # areatrigger\_teleport -` Back-to:World ` +[<-Back-to:World](database-world.md) **The \`areatrigger\_teleport\` table** @@ -8,110 +8,25 @@ Contains all the teleport triggers definition. This table is used to complete .d **Structure** - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

id

mediumint(8)

unsigned

PRI

NO

0

 

Identifier

name

text

signed

 

YES

NULL

 

 

target_map

smallint(5)

unsigned

 

NO

0

 

 

target_position_x

float

signed

 

NO

0

 

 

target_position_y

float

signed

 

NO

0

 

 

target_position_z

float

signed

 

NO

0

 

 

target_orientation

float

signed

 

NO

0

 

 

VerifiedBuild

smallint(5)

signed

 

YES

0

 

 

+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|-------------------------|--------------|------------|-----|------|---------|-------|------------| +| [id][1] | mediumint(8) | unsigned | PRI | NO | 0 | | Identifier | +| [name][2] | text | signed | | YES | NULL | | | +| [target_map][3] | smallint(5) | unsigned | | NO | 0 | | | +| [target_position_x][4] | float | signed | | NO | 0 | | | +| [target_position_y][5] | float | signed | | NO | 0 | | | +| [target_position_z][6] | float | signed | | NO | 0 | | | +| [target_orientation][7] | float | signed | | NO | 0 | | | +| [VerifiedBuild][8] | smallint(5) | signed | | YES | 0 | | | + +[1]: #id +[2]: #name +[3]: #target_map +[4]: #target_position_x +[5]: #target_position_y +[6]: #target_position_z +[7]: #target_orientation +[8]: #verifiedbuild **Description of the fields** diff --git a/docs/areatrigger_template.md b/docs/areatrigger_template.md index e30a243..1096660 100644 --- a/docs/areatrigger_template.md +++ b/docs/areatrigger_template.md @@ -8,162 +8,31 @@ This table contains the description of areatrigger. **Structure** - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

id

int(10)

unsigned

PRI

NO


-


-

Identifier

Type

tinyint(3)

unsigned


-

NO

0


-


-

Flags

int(10)

unsigned


-

NO

0


-


-

Data0floatsigned
-		NO0
-
-
Data1floatsigned
-		NO0
-
-
Data2

float

signed


-

NO

0


-


-

Data3

float

signed


-

NO

0


-


-

Data4

float

signed


-

NO

0


-


-

Data5

float

signed


-

NO

0


-


-

ScriptNamechar(64)signed
-		NO''
-
-

VerifiedBuild

int(10)

signed


-

YES

0


-


-

+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|---------------------|------------|------------|-----|------|---------|-------|------------| +| [id][1] | int(10) | unsigned | PRI | NO | | | Identifier | +| [Type][2] | tinyint(3) | unsigned | | NO | 0 | | | +| [Flags][3] | int(10) | unsigned | | NO | 0 | | | +| [Data0][4] | float | signed | | NO | 0 | | | +| [Data1][5] | float | signed | | NO | 0 | | | +| [Data2][6] | float | signed | | NO | 0 | | | +| [Data3][7] | float | signed | | NO | 0 | | | +| [Data4][8] | float | signed | | NO | 0 | | | +| [Data5][9] | float | signed | | NO | 0 | | | +| [ScriptName][10] | char(64) | signed | | NO | '' | | | +| [VerifiedBuild][11] | int(10) | signed | | YES | 0 | | | + +[1]: #id +[2]: #type +[3]: #flags +[4]: #data0 +[5]: #data1 +[6]: #data2 +[7]: #data3 +[8]: #data4 +[9]: #data5 +[10]: #scriptname +[11]: #verifiedbuild **Description of the fields** @@ -198,5 +67,3 @@ If value is above 0 then it has been parsed with WDB files from that specific cl If value is -1 then it is just a place holder until proper data are found on WDBs. If value is -Client Build then it was parsed with WDB files from that specific [client build](http://archive.trinitycore.info/DB:Auth:realmlist#gamebuild "DB:Auth:realmlist") and manually edited later for some special necessity. - - diff --git a/docs/auctionhouse.md b/docs/auctionhouse.md index 4bb02ca..bf4603d 100644 --- a/docs/auctionhouse.md +++ b/docs/auctionhouse.md @@ -10,130 +10,29 @@ This table is used by Trinity while running and not a table that you would usual **Structure** - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

id

int(10)

unsigned

PRI

NO

0

 

 

auctioneerguid

int(10)

unsigned

 

NO

0

 

 

itemguid

int(10)

unsigned

UNI

NO

0

 

 

itemowner

int(10)

unsigned

 

NO

0

 

 

buyoutprice

int(10)

unsigned

 

NO

0

 

 

time

int(10)

unsigned

 

NO

0

 

 

buyguid

int(10)

unsigned

 

NO

0

 

 

lastbid

int(10)

unsigned

 

NO

0

 

 

startbid

int(10)

unsigned

 

NO

0

 

 

deposit

int(10)

unsigned

 

NO

0

 

 

+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|---------------------|---------|------------|-----|------|---------|-------|---------| +| [id][1] | int(10) | unsigned | PRI | NO | 0 | | | +| [auctioneerguid][2] | int(10) | unsigned | | NO | 0 | | | +| [itemguid][3] | int(10) | unsigned | UNI | NO | 0 | | | +| [itemowner][4] | int(10) | unsigned | | NO | 0 | | | +| [buyoutprice][5] | int(10) | unsigned | | NO | 0 | | | +| [time][6] | int(10) | unsigned | | NO | 0 | | | +| [buyguid][7] | int(10) | unsigned | | NO | 0 | | | +| [lastbid][8] | int(10) | unsigned | | NO | 0 | | | +| [startbid][9] | int(10) | unsigned | | NO | 0 | | | +| [deposit][10] | int(10) | unsigned | | NO | 0 | | | + +[1]: #id +[2]: #auctioneerguid +[3]: #itemguid +[4]: #itemowner +[5]: #buyoutprice +[6]: #time +[7]: #buyguid +[8]: #lastbid +[9]: #startbid +[10]: #deposit **Description of the fields** diff --git a/docs/channels.md b/docs/channels.md index 61d672f..ea23c67 100644 --- a/docs/channels.md +++ b/docs/channels.md @@ -8,100 +8,23 @@ Information and settings for ingame, player-based chat channels (not affecting t ## Structure - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

name

varchar(128)

signed

PRI

NO

 

 

 

team

int(10)

unsigned

PRI

NO

 

 

 

announce

tinyint(3)

unsigned

 

NO

1

 

 

ownership

tinyint(3)

unsigned

 

NO

1

 

 

password

varchar(32)

signed

 

YES

NULL

 

 

bannedList (NOT IMPLEMENTED FOR NOW)

text

signed

 

YES

 

 

 

lastUsed

int(10)

unsigned

 

NO

 

 

 

+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|-----------------|--------------|------------|-----|------|---------|-------|---------| +| [name][1] | varchar(128) | signed | PRI | NO | | | | +| [team][2] | int(10) | unsigned | PRI | NO | | | | +| [announce][3] | tinyint(3) | unsigned | | NO | 1 | | | +| [ownership][4] | tinyint(3) | unsigned | | NO | 1 | | | +| [password][5] | varchar(32) | signed | | YES | NULL | | | +| [bannedList][6] | text | signed | | YES | | | | +| [lastUsed][7] | int(10) | unsigned | | NO | | | | + +[1]: #name +[2]: #team +[3]: #announce +[4]: #ownership +[5]: #password +[6]: #bannedlist +[7]: #lastused ## Description of the fields @@ -113,29 +36,28 @@ Name of the channel ### team -**<team id> Allow access to channel from specified player faction ID** +**team id** Allow access to channel from specified player faction ID -For multirace channels, two (or more) separate entries must exist with the EXACT same settings for all fields apart from this (it needs a different <team id>) +For multirace channels, two (or more) separate entries must exist with the EXACT same settings for all fields apart from this (it needs a different **team id**) -Horde -> 67 - -Alliance -> 469 +| Faction | Value | +|----------|-------| +| Horde | 67 | +| Alliance | 469 | ### announce **Channel announce (0/1)** -0 = Channel join/part actions will not be sent - -1 = Channel join/part actions will be sent +- 0 = Channel join/part actions will not be sent +- 1 = Channel join/part actions will be sent ### ownership **Channel ownership (0/1)** -0 = No one will ever be an owner. - -1 = Ownership is the first person in the channel. +- 0 = No one will ever be an owner. +- 1 = Ownership is the first person in the channel. ### password diff --git a/docs/character_banned.md b/docs/character_banned.md index 3a083a4..7ab81fb 100644 --- a/docs/character_banned.md +++ b/docs/character_banned.md @@ -8,90 +8,21 @@ This table lists all of the characters that have been banned along with the date **Structure** - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

guid

int(10)

unsigned

PRI

NO

0

 

Global Unique Identifier

bandate

int(10)

unsigned

PRI

NO

0

 

 

unbandate

int(10)

unsigned

 

NO

0

 

 

bannedby

varchar(50)

signed

 

NO

 

 

 

banreason

varchar(255)

signed

 

NO

 

 

 

active

tinyint(3)

unsigned

 

NO

1

 

 

+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|----------------|--------------|------------|-----|------|---------|-------|--------------------------| +| [guid][1] | int(10) | unsigned | PRI | NO | 0 | | Global Unique Identifier | +| [bandate][2] | int(10) | unsigned | PRI | NO | 0 | | | +| [unbandate][3] | int(10) | unsigned | | NO | 0 | | | +| [bannedby][4] | varchar(50) | signed | | NO | | | | +| [banreason][5] | varchar(255) | signed | | NO | | | | +| [active][6] | tinyint(3) | unsigned | | NO | 1 | | | + +[1]: #guid +[2]: #bandate +[3]: #unbandate +[4]: #bannedby +[5]: #banreason +[6]: #active **Description of the fields** diff --git a/docs/character_battleground_data.md b/docs/character_battleground_data.md index 7c717b3..c894870 100644 --- a/docs/character_battleground_data.md +++ b/docs/character_battleground_data.md @@ -8,140 +8,31 @@ This table holds information for each character in a battleground. Also hold inf **Structure** - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

guid

int(10)

unsigned

PRI

NO

0

 

Global Unique Identifier

instanceId

int(10)

unsigned

 

NO

0

 

Instance Identifier

team

smallint(5)

unsigned

 

NO

 

 

 

joinX

float

signed

 

NO

0

 

 

joinY

float

signed

 

NO

0

 

 

joinZ

float

signed

 

NO

0

 

 

joinO

float

signed

 

NO

0

 

 

joinMapId

smallint(5)

unsigned

 

NO

0

 

Map Identifier

taxiStart

int(10)

unsigned

 

NO

0

 

 

taxiEnd

int(10)

unsigned

 

NO

0

 

 

mountSpell

mediumint(8)

unsigned

 

NO

0

 

 

+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|------------------|--------------|------------|-----|------|---------|-------|--------------------------| +| [guid][1] | int(10) | unsigned | PRI | NO | 0 | | Global Unique Identifier | +| [instanceId][2] | int(10) | unsigned | | NO | 0 | | Instance Identifier | +| [team][3] | smallint(5) | unsigned | | NO | | | | +| [joinX][4] | float | signed | | NO | 0 | | | +| [joinY][5] | float | signed | | NO | 0 | | | +| [joinZ][6] | float | signed | | NO | 0 | | | +| [joinO][7] | float | signed | | NO | 0 | | | +| [joinMapId][8] | smallint(5) | unsigned | | NO | 0 | | Map Identifier | +| [taxiStart][9] | int(10) | unsigned | | NO | 0 | | | +| [taxiEnd][10] | int(10) | unsigned | | NO | 0 | | | +| [mountSpell][11] | mediumint(8) | unsigned | | NO | 0 | | | + +[1]: #guid +[2]: #instanceid +[3]: #team +[4]: #joinx +[5]: #joiny +[6]: #joinz +[7]: #joino +[8]: #joinmapid +[9]: #taxistart +[10]: #taxiend +[11]: #mountspell **Description of the fields** @@ -157,10 +48,11 @@ This is the battleground instanceId. It's shared with [instance.id](instance_213 teamId: -469 - Alliance - -67 - Horde -0 - GM +| ID | Description | +|-----|-------------| +| 0 | GM | +| 67 | Horde | +| 469 | Alliance | ### joinX diff --git a/docs/character_homebind.md b/docs/character_homebind.md index 829c6ec..f241d6d 100644 --- a/docs/character_homebind.md +++ b/docs/character_homebind.md @@ -8,90 +8,21 @@ Contains information on the location where characters get teleported when they u **Structure** - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

guid

int(10)

unsigned

PRI

NO

0

 

Global Unique Identifier

mapId

smallint(5)

unsigned

 

NO

0

 

Map Identifier

zoneId

smallint(5)

unsigned

 

NO

0

 

Zone Identifier

posX

float

signed

 

NO

0

 

 

posY

float

signed

 

NO

0

 

 

posZ

float

signed

 

NO

0

 

 

+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|-------------|-------------|------------|-----|------|---------|-------|--------------------------| +| [guid][1] | int(10) | unsigned | PRI | NO | 0 | | Global Unique Identifier | +| [mapId][2] | smallint(5) | unsigned | | NO | 0 | | Map Identifier | +| [zoneId][3] | smallint(5) | unsigned | | NO | 0 | | Zone Identifier | +| [posX][4] | float | signed | | NO | 0 | | Coordinate x | +| [posY][5] | float | signed | | NO | 0 | | Coordinate y | +| [posZ][6] | float | signed | | NO | 0 | | Coordinate z | + +[1]: #guid +[2]: #mapid +[3]: #zoneid +[4]: #posx +[5]: #posy +[6]: #posz **Description of the fields** diff --git a/docs/creature.md b/docs/creature.md index e8f4097..128360c 100644 --- a/docs/creature.md +++ b/docs/creature.md @@ -6,230 +6,49 @@ Contains individual creature spawn data for each individual spawn of each individual creature in the game world. - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

guid

int(10)

unsigned

PRI

NO

NULL

Auto Increment

Global Unique Identifier

id

mediumint(8)

unsigned

 

NO

0

 

Creature Identifier

map

smallint(5)

unsigned

 

NO

0

 

Map Identifier

spawnMask

tinyint(3)

unsigned

 

NO

1

 

 

phaseMask

smallint(5)

unsigned

 

NO

1

 

 

modelid

mediumint(8)

unsigned

 

NO

0

 

0 core determined random model or model_id to prevent random model selection by core.

equipment_id

tinyint(3)

unsigned

 

NO

1

 

 

position_x

float

signed

 

NO

0

 

 

position_y

float

signed

 

NO

0

 

 

position_z

float

signed

 

NO

0

 

 

orientation

float

signed

 

NO

0

 

 

spawntimesecs

int(10)

unsigned

 

NO

120

 

 

wander_distance

float

signed

 

NO

5

 

Dist in yards for random movement.

currentwaypoint

mediumint(8)

unsigned

 

NO

0

 

Storage used by core. "Always set as 0"

curhealth

int(10)

unsigned

 

NO

1

 

Storage used by core. "Always set as 1"

curmana

int(10)

unsigned

 

NO

0

 

Storage used by core. "Always set as 0"

MovementType

tinyint(3)

unsigned

 

NO

0

 

0 No movement, 1 random, 2 path

npcflag

int(10)

unsigned

 

NO

0

 

 

unit_flags

int(10)

unsigned

 

NO

0

 

 

dynamicflags

int(10)

unsigned

 

NO

0

 

 

+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|-----------------------|--------------|------------|-----|------|---------|----------------|---------------------------------------------------------------------------------------| +| [guid][1] | int(10) | unsigned | PRI | NO | NULL | Auto Increment | Global Unique Identifier | +| [id][2] | mediumint(8) | unsigned | | NO | 0 | | Creature Identifier | +| [map][3] | smallint(5) | unsigned | | NO | 0 | | Map Identifier | +| [spawnMask][4] | tinyint(3) | unsigned | | NO | 1 | | | +| [phaseMask][5] | smallint(5) | unsigned | | NO | 1 | | | +| [modelid][6] | mediumint(8) | unsigned | | NO | 0 | | 0 core determined random model or model_id to prevent random model selection by core. | +| [equipment_id][7] | tinyint(3) | unsigned | | NO | 1 | | | +| [position_x][8] | float | signed | | NO | 0 | | | +| [position_y][9] | float | signed | | NO | 0 | | | +| [position_z][10] | float | signed | | NO | 0 | | | +| [orientation][11] | float | signed | | NO | 0 | | | +| [spawntimesecs][12] | int(10) | unsigned | | NO | 120 | | | +| [wander_distance][13] | float | signed | | NO | 5 | | Dist in yards for random movement. | +| [currentwaypoint][14] | mediumint(8) | unsigned | | NO | 0 | | Storage used by core. "Always set as 0" | +| [curhealth][15] | int(10) | unsigned | | NO | 1 | | Storage used by core. "Always set as 1" | +| [curmana][16] | int(10) | unsigned | | NO | 0 | | Storage used by core. "Always set as 0" | +| [MovementType][17] | tinyint(3) | unsigned | | NO | 0 | | 0 No movement, 1 random, 2 path | +| [npcflag][18] | int(10) | unsigned | | NO | 0 | | | +| [unit_flags][19] | int(10) | unsigned | | NO | 0 | | | +| [dynamicflags][20] | int(10) | unsigned | | NO | 0 | | | + +[1]: #guid +[2]: #id +[3]: #map +[4]: #spawnmask +[5]: #phasemask +[6]: #modelid +[7]: #equipment_id +[8]: #position_x +[9]: #position_y +[10]: #position_z +[11]: #orientation +[12]: #spawntimesecs +[13]: #wander_distance +[14]: #currentwaypoint +[15]: #curhealth +[16]: #curmana +[17]: #movementtype +[18]: #npcflag +[19]: #unit_flags +[20]: #dynamicflags **Field Descriptions** @@ -255,47 +74,14 @@ Example: The creature will spawn in only the 10 and 25 man heroic versions of the map that the creature is spawned on. - -  - - ---- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Value

Comment

0

Not spawned

1

Spawned only in 10-man-normal versions of maps (includes maps without a heroic mode)

2

Spawned only in 25-man-normal versions of maps (or heroics pre 3.2)

4

Spawned only in 10-man heroic versions of maps

8

Spawned only in 25-man-heroic versions of maps

15

Spawned in all versions of maps

+| Value | Comment | +|-------|--------------------------------------------------------------------------------------| +| 0 | Not spawned | +| 1 | Spawned only in 10-man-normal versions of maps (includes maps without a heroic mode) | +| 2 | Spawned only in 25-man-normal versions of maps (or heroics pre 3.2) | +| 4 | Spawned only in 10-man heroic versions of maps | +| 8 | Spawned only in 25-man-heroic versions of maps | +| 15 | Spawned in all versions of maps | ### phaseMask @@ -313,8 +99,8 @@ This can be left at 0 and a random model from its assigned models in [creature\_ The ID as defined within [creature\_equip\_template](creature_equip_template) corresponding to the [entry](creature_template). The value essential defines the equip: -- ** -1**: A random equip from the set of equips in [creature\_equip\_template](creature_equip_template) will be chosen. -- **  0**: No equipment defined. +- **-1**: A random equip from the set of equips in [creature\_equip\_template](creature_equip_template) will be chosen. +- **0**: No equipment defined. - **1+**: The individual id within creature\_equip\_template. If creature spawned with `.npc add`, then this value will be set automatically (0 if nothing in creature_equip_template). diff --git a/docs/creature_equip_template.md b/docs/creature_equip_template.md index 2a84edb..81cb845 100644 --- a/docs/creature_equip_template.md +++ b/docs/creature_equip_template.md @@ -8,84 +8,19 @@ This table contains all the equipment combinations that can be sent for each cre ## Structure - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

CreatureID

mediumint(8)

unsigned

PRI

NO

0


-

Unique entry

ID

tinyint(3)

unsigned

PRI

NO

1


-

Unique entry

ItemID1

mediumint(8)

unsigned


-

NO

0


-


-

ItemID2

mediumint(8)

unsigned


-

NO

0


-


-

ItemID3

mediumint(8)unsigned
-		NO0
-
-
- -** -** +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|-----------------|--------------|------------|-----|------|---------|-------|--------------| +| [CreatureID][1] | mediumint(8) | unsigned | PRI | NO | 0 | | Unique entry | +| [ID][2] | tinyint(3) | unsigned | PRI | NO | 1 | | Unique entry | +| [ItemID1][3] | mediumint(8) | unsigned | | NO | 0 | | | +| [ItemID2][4] | mediumint(8) | unsigned | | NO | 0 | | | +| [ItemID3][5] | mediumint(8) | unsigned | | NO | 0 | | | + +[1]: #creatureid +[2]: #id +[3]: #itemid1 +[4]: #itemid2 +[5]: #itemid3 ## Description of the fields diff --git a/docs/creature_formations.md b/docs/creature_formations.md index b170b5e..9e25748 100644 --- a/docs/creature_formations.md +++ b/docs/creature_formations.md @@ -8,100 +8,23 @@ This table allows to group mobs. Members of group will follow others, and attack **Structure** - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

leaderGUID

int(11)

unsigned

 

NO

NULL

 

 

memberGUID

int(11)

unsigned

PRI

NO

NULL

 

 

dist

float

unsigned

 

NO

NULL

 

 

angle

float

unsigned

 

NO

NULL

 

 

groupAIint(11)unsigned NONULL  
point_1int(11)unsigned NO0  

point_2

int(11)

unsigned

 

NO

0

 

 

+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|-----------------|---------|------------|-----|------|---------|-------|---------| +| [leaderGUID][1] | int(11) | unsigned | | NO | NULL | | | +| [memberGUID][2] | int(11) | unsigned | PRI | NO | NULL | | | +| [dist][3] | float | unsigned | | NO | NULL | | | +| [angle][4] | float | unsigned | | NO | NULL | | | +| [groupAI][5] | int(11) | unsigned | | NO | NULL | | | +| [point_1][6] | int(11) | unsigned | | NO | 0 | | | +| [point_2][7] | int(11) | unsigned | | NO | 0 | | | + +[1]: #leaderguid +[2]: #memberguid +[3]: #dist +[4]: #angle +[5]: #groupai +[6]: #point_1 +[7]: #point_2 ## leaderGUID @@ -126,14 +49,13 @@ Note: Only degrees are used! Values should be between 0 and 360 Sets group member behaviours, values are: -| | | -|-------|--------------------------------------------------------------| | Value | Behaviour | +|-------|--------------------------------------------------------------| | 0 | Noone assists noone and member don't follow the leader | -| 512 | Noone assists noone and member follow the leader | | 1 | The member aggroes if the leader aggroes | | 2 | The leader aggroes if the member aggroes | | 3 | Everyone assists everyone and member don't follow the leader | +| 512 | Noone assists noone and member follow the leader | | 515 | Everyone assists everyone and member follow the leader | ## point\_1   @@ -142,25 +64,18 @@ Sets group member behaviours, values are: These values are used to set leaderGUID pre ending path points for memberGUID's where the path is a straight return path and memberGUID's should not crossover to other side of leaderGUID on direction change. -If your leader has a path like the one below where he moves to point 5 then back to 1 you would set point\_1 = 4 and point\_2 = 8 on the memberGUID. If the memberGUID is at angle 90 up to point 5 it will switch to angle 270 for the return trip. This is only needed to keep creatures on the correct side. these values can be left at 0 for creatures following directly behind leaderGUID or any creatures in a circular path.  - -  +If your leader has a path like the one below where he moves to point 5 then back to 1 you would set point\_1 = 4 and point\_2 = 8 on the memberGUID. If the memberGUID is at angle 90 up to point 5 it will switch to angle 270 for the return trip. This is only needed to keep creatures on the correct side. these values can be left at 0 for creatures following directly behind leaderGUID or any creatures in a circular path. -1     2     3