Description of FUDforum table fud30_nntp. This table is used to track USENET posts that are synced with the forum. For more information, see Newsgroup Manager.
Fields
| Column Name | Datatype | Can be Null? | Key? | Default | Description
|
| id | int(11) | NO | PRI | | auto_increment
|
| forum_id | int(11) | NO | MUL | 0 | References fud30_forum.id.
|
| nntp_opt | int(11) | NO | | 44 | Options (see below).
|
| server | varchar(255) | NO | | | Name of the news server.
|
| newsgroup | varchar(255) | NO | | | Newsgroup name.
|
| port | int(11) | NO | | 0 | Server port.
|
| timeout | int(11) | NO | | 0 | Time before timing out a connection.
|
| login | varchar(255) | YES | | | Username to login.
|
| pass | varchar(255) | YES | | | Password to login.
|
| imp_limit | int(11) | NO | | 0 | Number of posts to import in one go.
|
| custom_sig | text | YES | | |
|
| tracker | int(11) | NO | | 0 | Track already loaded posts.
|
Keys
| Index Name | Uniqueness | Column Name | Seq in index | Comments
|
| PRIMARY | UNIQUE | id | 1 |
|
| fud30_nntp_i_f | NOT UNIQUE | forum_id | 1 |
|
Options
- 1 = nntp_post_apr
- 2 = allow_frm_post
- 4 = frm_post_apr
- 8 = allow_nntp_attch
- 16 = complex_reply_match
- 32 = create_users
- 64 = auth NONE
- 128 = auth (ORIGINAL/SIMPLE)
- 256 = skip_non_forum_users (ON/OFF)