page_text
The `page_text` table
This table holds the text for letter items or any items that when moused-over turn the cursor into a magnifying glass and on right-click will open up a window where you can read the contents of the letter.
Table Structure
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| ID | INT | UNSIGNED | PRI | NO | 0 | ||
| Text | LONGTEXT | SIGNED | NO | ||||
| NextPageID | INT | UNSIGNED | NO | 0 | |||
| VerifiedBuild | INT | SIGNED | YES | NULL |
Description of the fields
ID
Unique identifier
Text
The actual text. The message in this field will be shown as the text on a page.
NextPageID
The ID of the next page. page_text.id.
VerifiedBuild
This field is used by the TrinityCore DB Team to determine whether a template has been verified from WDB files.
- If value is 0, it has not been parsed yet.
- If value is > 0, it has been parsed with WDB files from that specific Client Build.
- If value is -1, it is just a place holder until proper data are found on WDBs.
- If value is -Client Build, it was parsed with WDB files from that specific client build and manually edited later for some specific necessity.