Admin: Update structure and add DB structure.

2021-08-08T23:10:39Z

Update structure and add DB structure.

@@ Line 75: / Line 75: @@
+|
 |}
+<br> <big>'''DB Structure'''</big>
 <br> <big>'''Description of the fields'''</big>

Admin: Add content

2021-08-08T23:08:22Z

Add content

New page

{| align="right"
| __TOC__
|}
{{Back-to:World_18414}}

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

This table holds the information for awarding items to players via in-game mail when the earn certain achievements.

<big>'''Structure'''</big>
{| border="1"
|'''Field'''
|'''Type'''
|'''Attributes'''
|'''Key'''
|'''Null'''
|'''Default'''
|'''Comment'''
|-
|[[#entry|entry]]
|mediumint(8)
|unsigned
|PRI
|NO
|0
|
|-
|[[#title_A|title_A]]
|mediumint(8)
|unsigned
|
|NO
|0
|
|-
|[[#title_H|title_H]]
|mediumint(8)
|unsigned
|
|NO
|0
|
|-
|[[#item|item]]
|mediumint(8)
|unsigned
|
|NO
|0
|
|-
|[[#sender|sender]]
|mediumint(8)
|unsigned
|
|NO
|0
|
|-
|[[#subject|subject]]
|varchar(225)
|signed
|
|YES
|
|
|-
|[[#text|text]]
|text
|signed
|
|YES
|
|
|}

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

===entry===

The ID# of the achievement. Found in [[Achievements.dbc SF|Achievements.dbc]].

===title_A===

The ID# of the title to award to Alliance players who gain the achievement. Found in [[CharTitles.dbc SF|CharTitles.dbc]].

===title_H===

The ID# of the title to award to Horde players who gain the achievement. Found in [[CharTitles.dbc SF|CharTitles.dbc]]

===item===

The ID# of the item to be mailed to the player. Found in [[Item_template_SF|Item_template]].

===sender===

The ID# of the creature who sends the mail. Found in [[Creature_template_SF|Creature_template]].

===subject===

The subject of the mail to be sent. 225 character limit.

===text===

The text contained in the mail to be sent.

Achievement reward 548 - Revision history

Admin: Update structure and add DB structure.

Admin: Add content