Achievement reward SF - Revision history

Admin at 06:09, 9 January 2013

2013-01-09T06:09:41Z

← Older revision		Revision as of 01:09, 9 January 2013
Line 3:		Line 3:
	\|}		\|}
	{{Back-to:World}}		{{Back-to:World}}
	~~[[DB:World\|Return to world database structure]]~~

	<big>'''The `achievement_reward` table'''</big>		<big>'''The `achievement_reward` table'''</big>
Line 106:		Line 105:

	The text contained in the mail to be sent.		The text contained in the mail to be sent.

			[[DB:World\|Return to world database structure]]

Admin at 06:09, 9 January 2013

2013-01-09T06:09:15Z

← Older revision		Revision as of 01:09, 9 January 2013
Line 3:		Line 3:
	\|}		\|}
	{{Back-to:World}}		{{Back-to:World}}
	[[~~Category~~: ~~SkyFire~~ World database ~~tables~~]]		[[DB:World\|Return to world database structure]]

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

Cheapgamer at 23:47, 9 July 2012

2012-07-09T23:47:26Z

New page

{| align="right"
| __TOC__
|}
{{Back-to:World}}
[[Category: SkyFire World database tables]]

<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.

Marqin at 12:35, 17 September 2011

2011-09-17T12:35:29Z

New page

{| align="right"
| __TOC__
|}
{{Back-to:World}}
[[Category: SkyFire World database tables]]

<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'''
|'''Attribute'''
|'''Default'''
|'''Comment'''
|-
|[[#entry|entry]]
|mediumint(8)
|unsigned
|
|The ID of the achievement. Found in Achievements.dbc.
|-
|[[#title_A|title_A]]
|mediumint(8)
|unsigned
|
|The ID of the title to award to Alliance players who gain the achievement. Found in CharTitles.dbc.
|-
|[[#title_H|title_H]]
|mediumint(8)
|unsigned
|
|The ID of the title to award to Horde players who gain the achievement. Found in CharTitles.dbc
|-
|[[#item|item]]
|mediumint(8)
|unsigned
|
|The ID of the item to be mailed to the player. Found in [[Item_template_SF|item_template]].
|-
|[[#sender|sender]]
|mediumint(8)
|unsigned
|
|The ID of the creature who sends the mail. Found in [[Creature_template_SF|creature_template]]
|-
|[[#subject|subject]]
|varchar(225)
|signed
|
|The subject of the mail to be sent.
|-
|[[#text|text]]
|text
|signed
|
|The text contained in the mail to be sent.
|}