achievement_reward

This table contains the achievement rewards to send them by mail.

Structure

Field Type Default Comment
entry mediumint(8) 0  
gender tinyint(3) 2  
title_A mediumint(8) 0  
title_H mediumint(8) 0  
item mediumint(8) 0  
sender mediumint(8) 0  
subject varchar(255)    
text text    

entry

The entry ID of the achievement.

gender

0 = Male
1 = Female
2 = all Genders

title_A

The title ID for Alliance.

title_H

The title ID for Horde.

item

The recieve item entry ID from item_properties table (mail).

sender

The sender entry id mostly from creature_properties table.

subject

The text shown in subject field (mail).

text

The text shown in body (mail).