blob: 697a26c26a2eb51d7800192ea34d4f65b24144f7 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
|
# achievement\_reward
[<-Back-to:World](database-world.md)
**The \`achievement\_reward\` table**
This table describes the reward that you will receive when you obtain a given achievement.
**Structure**
<table>
<colgroup>
<col width="14%" />
<col width="14%" />
<col width="14%" />
<col width="14%" />
<col width="14%" />
<col width="14%" />
<col width="14%" />
</colgroup>
<tbody>
<tr class="odd">
<td><p><strong>Field</strong></p></td>
<td><p><strong>Type</strong></p></td>
<td><p><strong>Attributes</strong></p></td>
<td><p><strong>Key</strong></p></td>
<td><p><strong>Null</strong></p></td>
<td><p><strong>Default</strong></p></td>
<td><p><strong>Extra</strong></p></td>
</tr>
<tr class="even">
<td><p><a href="#id">ID</a></p></td>
<td><p>mediumint(8)</p></td>
<td><p>unsigned</p></td>
<td><p>PRI</p></td>
<td><p>NO</p></td>
<td><p>0</p></td>
<td><p> </p></td>
</tr>
<tr class="odd">
<td><p><a href="#titlea">TitleA</a></p></td>
<td><p>mediumint(8)</p></td>
<td><p>unsigned</p></td>
<td><p> </p></td>
<td><p>NO</p></td>
<td><p>0</p></td>
<td><p> </p></td>
</tr>
<tr class="even">
<td><p><a href="#titleh">TitleH</a></p></td>
<td><p>mediumint(8)</p></td>
<td><p>unsigned</p></td>
<td><p> </p></td>
<td><p>NO</p></td>
<td><p>0</p></td>
<td><p> </p></td>
</tr>
<tr class="odd">
<td><p><a href="#itemid">ItemID</a></p></td>
<td><p>mediumint(8)</p></td>
<td><p>unsigned</p></td>
<td><p> </p></td>
<td><p>NO</p></td>
<td><p>0</p></td>
<td><p> </p></td>
</tr>
<tr class="even">
<td><p><a href="#sender">Sender</a></p></td>
<td><p>mediumint(8)</p></td>
<td><p>unsigned</p></td>
<td><p> </p></td>
<td><p>NO</p></td>
<td><p>0</p></td>
<td><p> </p></td>
</tr>
<tr class="odd">
<td><p><a href="#subject">Subject</a></p></td>
<td><p>varchar(255)</p></td>
<td><p>signed</p></td>
<td><p> </p></td>
<td><p>YES</p></td>
<td><p>NULL</p></td>
<td><p> </p></td>
</tr>
<tr class="even">
<td><p><a href="#body">Body</a></p></td>
<td><p>text</p></td>
<td><p>signed</p></td>
<td><p> </p></td>
<td><p>YES</p></td>
<td><p> </p></td>
<td><p> </p></td>
</tr>
<tr class="odd">
<td><a href="#mailtemplateid">MailTemplateID</a></td>
<td>mediumint(8)</td>
<td>unsigned</td>
<td> </td>
<td>YES</td>
<td>0</td>
<td> </td>
</tr>
</tbody>
</table>
**Description of the fields**
### ID
This is the ID of the achievement taken from the DBC `Achievement.dbc`.
### TitleA
This is the ID of the title for Alliance from `CharTitles.dbc` if the achievement rewards a title.
### TitleH
This is the ID of the title for Horde from `CharTitles.dbc` if the achievement rewards a title.
### ItemID
This is the item that that the player will receive if the achievement rewards an item. The player will get this item in a mail.
### Sender
This is the sender of the mail that the player will receive.
### Subject
This is the subject of the mail that the player will receive.
### Body
This is the body (text) of the mail that the player will receive.
### MailTemplateID
Id of the MailTemplate from `MailTemplate.dbc` of that mail that the player will receive. To use this column, `Subject` and `Body` must be empty as they are loaded from the DBC file.
|
