Page text SF

From Project Skyfire
Jump to: navigation, search

Back to world database list of tables.


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.


Structure

Field Type Attributes Key Null Default Extra Comment
entry mediumint(8) unsigned PRI NO 0
text longtext signed NO NULL
next_page mediumint(8) unsigned NO 0
WDBVerified smallint(5) signed YES 1


Description of the fields

entry

The ID of the text in the page. This number is unique to every text entry.

text

The actual text. The message in this field will be shown as the text on a page.

next_page

The ID of the next page's text entry.

WDBVerified

This field is used by the TrinityDB Team to determine whether a template has been verified from WDB files. Not sure if it is used by Skyfire. It is best to get the correct data to add to database rather than waste time with wrong info.

If value is 0 then it has not been parsed yet.

If value is above 0 then it has been parsed with WDB files from that specific client build.

If value is -1 then it is just a place holder until proper data are found on WDBs.

If value is - client build then it was parsed with WDB files from that specific client build and manually edited later for some special necessity.