====== achievement_reward 表 ====== ---- [[数据库:world数据库:首页|<-返回:World 数据库]] This table describes the reward that you will receive when you obtain a given achievement. **表结构** ^Field^Type^Attributes^Key^Null^Default^Extra^Comment^ |[[#ID|ID]]|MEDIUMINT|UNSIGNED|PRI|NO|0| | | |[[#TitleA|TitleA]]|MEDIUMINT|UNSIGNED| |NO|0| | | |[[#TitleH|TitleH]]|MEDIUMINT|UNSIGNED| |NO|0| | | |[[#ItemID|ItemID]]|MEDIUMINT|UNSIGNED| |NO|0| | | |[[#Sender|Sender]]|MEDIUMINT|UNSIGNED| |NO|0| | | |[[#Subject|Subject]]|VARCHAR(255)| | |YES| | | | |[[#Body|Body]]|text| | |YES| | | | |[[#MailTemplateID|MailTemplateID]]|MEDIUMINT|UNSIGNED| |YES|0| | | ===== 字段说明 ===== ---- ==== 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. ==== Example ==== ID TitleA TitleH ItemID Sender Subject 13 0 0 41426 16128 Level 80 45 0 0 43348 28070 You've Been Around!