The Forum module tables
Forum Groups
| Field | Description | Type | Required | Default |
|---|---|---|---|---|
| ID | The forum group ID. Unique. | Int | Yes | |
| SORT | Sort weight. | Int | Yes | 150 |
Site-dependent parameters of the forum groups
| Field | Description | Type | Required | Default |
|---|---|---|---|---|
| FORUM_GROUP_ID | The forum group ID | Int | Yes | |
| LID | The site ID | Char(2) | Yes | |
| NAME | Name of the forum group | String(255) | Yes | |
| DESCRIPTION | Description of the forum group | String(255) | No |
Forums
| Field | Description | Type | Required | Default |
|---|---|---|---|---|
| ID | The forum ID. Unique. | Int | Yes | |
| NAME | The forum name. | String(128) | Yes | |
| DESCRIPTION | The forum description. | String(255) | No | |
| SORT | Sort weight | Int | Yes | 150 |
| ACTIVE | Specifies the forum is active (Y|N) | Char(1) | Yes | Y |
| ALLOW_HTML | Allow HTML in messages (Y|N) | Char(1) | Yes | N |
| ALLOW_NL2BR | Convert carriage returns to <br> in HTML mode (Y|N) | Char(1) | Yes | N |
| ALLOW_ANCHOR | Allow tags <a> / [a] (Y|N) | Char(1) | Yes | Y |
| ALLOW_BIU | Allow tags <b> / [b], <i> / [i], <u> / [u] (Y|N) | Char(1) | Yes | Y |
| ALLOW_IMG | Allow tag <img> / [img] (Y|N) | Char(1) | Yes | Y |
| ALLOW_LIST | Allow tag <ul> / [list] (Y|N) | Char(1) | Yes | Y |
| ALLOW_QUOTE | Allow tag <quote> / [quote] (Y|N) | Char(1) | Yes | Y |
| ALLOW_CODE | Allow tag <code> / [code] (Y|N) | Char(1) | Yes | Y |
| ALLOW_FONT | Allow tag <font> / [color], [font] (Y|N) | Char(1) | Yes | Y |
| ALLOW_SMILES | Allow smiley images (Y|N) | Char(1) | Yes | Y |
| ALLOW_UPLOAD | Allow uploading files attached to messages. Possible values: N - deny upload, Y - only images, F - files with extensions specified in ALLOW_UPLOAD_EXT, A - all files. | Char(1) | Yes | N |
| MODERATION | Specifies the forum is pre-moderated (Y|N) | Char(1) | Yes | N |
| ORDER_BY | Default sorting of the forum topics. Possible values: T - topic title, N - number of messages, A - author, V - topic views, D - creation date, P - the date of the last message. | Char(1) | Yes | P |
| ORDER_DIRECTION | Default sort order of the forum topics. Possible values: ASC - ascending, DESC - descending. | Char(4) | Yes | DESC |
| TOPICS | Number of topics in the forum. | Int | Yes | 0 |
| POSTS | Number of posts in the forum | Int | Yes | 0 |
| LAST_POSTER_ID | The ID of the last message author. | Int | No | |
| LAST_POSTER_NAME | The name of the last message author. | String(64) | No | |
| LAST_POST_DATE | The date of the last message.. | DateTime | No | |
| LAST_MESSAGE_ID | The ID of the last message. | Int | No | |
| ALLOW_UPLOAD_EXT | Comma-separated extensions of files allowed to be uploaded. Applicable if only ALLOW_UPLOAD is "F". | String(255) | No | |
| FORUM_GROUP_ID | The forum group ID. | Int | No | |
| ASK_GUEST_EMAIL | Require the e-mail address to be provided by unregistered authors (Y/N) | Char(1) | No | N |
Forum and site relation
| Field | Description | Type | Required | Default |
|---|---|---|---|---|
| FORUM_ID | The forum ID. | Int | Yes | |
| SITE_ID | The site ID. | Char(2) | Yes | |
| PATH2FORUM_MESSAGE | Forum message path template. Can contain macros #FORUM_ID#, #TOPIC_ID#, #MESSAGE_ID# which must be replaced with the real forum ID, topic ID and message ID. | varchar(250) | No |
Forum topics
| Field | Description | Type | Required | Default |
|---|---|---|---|---|
| ID | The forum topic ID. Unique. | Int | Yes | |
| TITLE | The topic title. | String(70) | Yes | |
| DESCRIPTION | The topic description. | String(70) | No | |
| STATE | The topic status: open or closed (Y|N). | Char(1) | Yes | Y |
| USER_START_ID | The topic author ID. | Int | No | |
| USER_START_NAME | The topic author name. | String(64) | Yes | |
| START_DATE | The topic creation date. | DateTime | Yes | |
| ICON_ID | The topic icon ID. | Int | No | |
| POSTS | Number of replies (posts). | Int | Yes | 0 |
| VIEWS | Number of views. | Int | Yes | 0 |
| FORUM_ID | The parent forum ID. | Int | Yes | |
| APPROVED | Specifies the topic is published (Y|N). The topic is published if it contains at least one post. | Char(1) | Yes | Y |
| SORT | Sort weight. | Int | Yes | 150 |
| LAST_POSTER_ID | The ID of the last message author. | Int | No | |
| LAST_POSTER_NAME | The name of the last message author. | String(64) | Yes | |
| LAST_POST_DATE | The date of the last message.. | DateTime | Yes | |
| LAST_MESSAGE_ID | The ID of the last message. | Int | Yes |
Posts (forum messages)
| Field | Description | Type | Required | Default |
|---|---|---|---|---|
| ID | The post ID. Unique. | Int | Yes | |
| AUTHOR_ID | The post author ID. | Int | No | |
| AUTHOR_NAME | The post author name. | String(128) | Yes | |
| AUTHOR_IP | The post author ID. | String(128) | No | |
| USE_SMILES | The user chooses to replace text smileys with icons (Y|N). | Char(1) | Yes | Y |
| POST_DATE | The date the post is created. | Datetime | Yes | |
| POST_MESSAGE | The post text. | Text | Yes | |
| FORUM_ID | The ID of the forum in which the post occurred. | Int | Yes | |
| TOPIC_ID | The ID of the topic in which the post occurred. | Int | Yes | |
| APPROVED | The post is published (Y|N) | Char(1) | Yes | Y |
| GUEST_ID | The visitor ID. | Int | No | |
| AUTHOR_REAL_IP | The real IP of the post author. | Int | No | |
| ATTACH_IMG | Attachment. | Int | No |
Forum user profile
| Field | Description | Type | Required | Default |
|---|---|---|---|---|
| ID | The profile ID. Unique. | Int | Yes | |
| USER_ID | The user ID. Unique. | Int | Yes | |
| DESCRIPTION | The user description. | String(64) | No | |
| IP_ADDRESS | The IP address from which the last message was sent. | String(128) | Yes | |
| AVATAR | The avatar. | Int | No | |
| NUM_POSTS | Total number of posts. | Int | Yes | 0 |
| INTERESTS | The user personal information (text). | Text | No | |
| LAST_POST | The ID of the last message created by the user. | Int | No | |
| ALLOW_POST | The user is not banned. | Char(1) | Yes | Y |
| LAST_VISIT | The date of the last visit. | DateTime | Yes | |
| DATE_REG | The date the user was registered. | DateTime | Yes | |
| REAL_IP_ADDRESS | The real IP address used to create the last message. | String(128) | No | |
| SIGNATURE | Signature text. | String(255) | No | |
| SHOW_NAME | Denotes to show name instead of login (Y|N) | Char(1) | Yes | Y |
| HIDE_FROM_ONLINE | Do not show in the "Who is online" list (Y/N) | Char(1) | No | N |
| POINTS | Current points count. | Int | No | 0 |
User ranks
| Field | Description | Type | Required | Default |
|---|---|---|---|---|
| ID | The user rank ID. Unique. | Yes | ||
| MIN_POINTS | Number of points required to gain this rank. | Int | Yes | 0 |
| CODE | Mnemonic code of the rank. | varchar(100) | No | |
| VOTES | Number of votes that a user in this rank can give to other users. | Int | Yes | 0 |
Language parameters of points
| Field | Description | Type | Required | Default |
|---|---|---|---|---|
| POINTS_ID | The rank ID. | Int | Yes | |
| LID | The language ID. | Char(2) | Yes | |
| NAME | The rank name. | String(250) | Yes |
Point-per-post lookup table
| Field | Description | Type | Required | Default |
|---|---|---|---|---|
| ID | The primary record ID. | Int | Yes | |
| MIN_NUM_POSTS | Number of messages required to gain this number of points per message. | Int | Yes | 0 |
| POINTS_PER_POST | Number of points per message. Can be fractional. | decimal(18, 4) | Yes | 0 |
Smileys and icons
| Field | Description | Type | Required | Default |
|---|---|---|---|---|
| ID | The smiley ID. Unique. | Yes | ||
| TYPE | The smiley type: S - smiley, I - icon. | Char(2) | Yes | S |
| TYPING | Smiley text variants. Separated with spaces. | String(100) | Yes | |
| IMAGE | The image name. | String(128) | Yes | |
| SORT | Sort weight. | Int | Yes | 150 |
| IMAGE_WIDTH | Image width. | Int | Yes | 0 |
| IMAGE_HEIGHT | Image height. | Int | Yes | 0 |
Language parameters of smileys
| Field | Description | Type | Required | Default |
|---|---|---|---|---|
| SMILE_ID | The smiley ID. | Int | Yes | |
| LID | The language ID. | Char(2) | Yes | |
| NAME | The smiley name. | String(255) | Yes |
Subscription
| Field | Description | Type | Required | Default |
|---|---|---|---|---|
| ID | The subscription ID. | Int | Yes | |
| USER_ID | The subscriber ID. | Int | Yes | |
| FORUM_ID | The ID of the forum whose messages a subscriber wants to receive. | Int | Yes | |
| TOPIC_ID | The ID of the topic whose messages a subscriber wants to receive. | Int | No | |
| START_DATE | The date of subscription. | DateTime | Yes | |
| LAST_SEND | The ID of the last message sent. | Int | No | |
| NEW_TOPIC_ONLY | Subscribed to new topics only (Y/N) | Char(1) | Yes | N |
| SITE_ID | The ID of the site from which the subscription has been made. | Char(2) | Yes | en |
Private messages
| Field | Description | Type | Required | Default |
|---|---|---|---|---|
| ID | The unique message ID. | Int | Yes | |
| AUTHOR_ID | The message author ID. | Int | Yes | |
| USER_ID | The message recipient user ID. | Int | Yes | |
| FOLDER_ID | The user folder ID. | Int | Yes | |
| IS_READ | Indicates that the message is read. | Int | Yes | |
| USE_SMILES | Replace text smileys with images (Y|N). | Int | Yes | |
| POST_DATE | The date the message was created. | DateTime | Yes | |
| POST_SUBJ | The message subject. | String(255) | No | |
| POST_MESSAGE | The message body. | Text | No |
User folders
| Field | Description | Type | Required | Default |
|---|---|---|---|---|
| ID | The unique folder ID. | Int | Yes | |
| TITLE | The message author ID. | String(50) | Yes | |
| USER_ID | The folder owner ID. | Int | Yes |
Dictionary of obscene words
| Field | Description | Type | Required | Default |
|---|---|---|---|---|
| ID | The unique record ID. | Int | Yes | |
| TITLE | The dictionary name. | String(50) | Yes | |
| TYPE | The dictionary type. | Char | Yes |
Dictionary of letters
| Field | Description | Type | Required | Default |
|---|---|---|---|---|
| ID | The unique record ID. | Int | Yes | |
| DICTIONARY_ID | The dictionary ID. | Int | Yes | |
| LETTER | The original letter to be substituted. | String(50) | Yes | |
| REPLACEMENT | The replacement letter. | String(50) | Yes |
Dictionary of unquotable words
| Field | Description | Type | Required | Default |
|---|---|---|---|---|
| ID | The unique record ID. | Int | Yes | |
| DICTIONARY_ID | The dictionary ID. | Int | Yes | |
| WORDS | A word. | String(255) | No | |
| PATTERN | A pattern which would match words under this dictionary record. | String(255) | No | |
| REPLACEMENT | A word with which the matching words will be replaced. | String(255) | No | |
| DESCRIPTION | The description. | Text | No | |
| REPLACEMENT | The replacement word. | String(50) | Yes | |
| USE_IT | Use this pattern (Y|N). | Char | Yes |
© «Bitrix24», 2001-2024