Differences

This shows you the differences between the selected revision and the current version of the page.

punbb12:syndication 2009/07/09 02:26 punbb12:syndication 2020/02/06 11:04 current
Line 16: Line 16:
  * **type:** RSS. Anything else means HTML output.   * **type:** RSS. Anything else means HTML output.
-Here are some examples using PHP include().+==== Examples ==== 
 + 
 +== Here are some examples using PHP include(). ==
  * Show the 15 most recently active topics from all forums:   * Show the 15 most recently active topics from all forums:
    include('http://host.com/forums/extern.php?action=active');     include('http://host.com/forums/extern.php?action=active');
Line 28: Line 30:
    include('http://host.com/forums/extern.php?action=stats');     include('http://host.com/forums/extern.php?action=stats');
-Here are some examples using SSI.+== Here are some examples using SSI. ==
  * Show the 5 newest topics from forums with ID 11 and 22:   * Show the 5 newest topics from forums with ID 11 and 22:
    ''<!--#include virtual="forums/extern.php?action=new&show=5&fid=11,22" -->''     ''<!--#include virtual="forums/extern.php?action=new&show=5&fid=11,22" -->''
Line 34: Line 36:
    ''<!--#include virtual="forums/extern.php?action=stats" -->''     ''<!--#include virtual="forums/extern.php?action=stats" -->''
-And finally some examples using extern.php to output an RSS 0.91 feed.+== And finally some examples using extern.php to output an RSS 0.91 feed. ==
  * Output the 15 most recently active topics:   * Output the 15 most recently active topics:
    http://host.com/extern.php?action=active&type=RSS     http://host.com/extern.php?action=active&type=RSS
  * Output the 15 newest topics from forum with ID=2:   * Output the 15 newest topics from forum with ID=2:
    http://host.com/extern.php?action=active&type=RSS&fid=2     http://host.com/extern.php?action=active&type=RSS&fid=2
- 
- 
- 
- 
- 
- 
- 
- 
- 
- 
- 
- 
- 
- 
- 
- 
- 
-==== forums ==== 
- 
-^ **Field** ^ **Type** ^ **Default** ^ **Description** ^ 
-| id | int |  | The auto-incrementing (identity) primary key identifier for this table. | 
-| forum_name | varchar(80) | 'New forum' | The name of the forum. | 
-| forum_desc | text | NULL | A description of the forum. | 
-| redirect_url | varchar(100) | NULL | The URL to redirect users to upon clicking the forum link on the index page. | 
-| moderators | text | NULL | A serialized PHP array of moderators. | 
-| num_topics | mediumint/int | 0 | The number of topics the forum contains. | 
-| num_posts | mediumint/int | 0 | The number of posts the forum contains. | 
-| last_post | int | NULL | A UNIX timestamp representing the date/time the last post was made in the forum. | 
-| last_post_id | int | NULL | The ID of the last post that was made in the forum. | 
-| last_poster | varchar(200) | NULL | The username (or guest name) of the user that made the last post in the forum. | 
-| sort_by | tinyint/smallint | 0 | 0 = Display topics sorted by last post. 1 = Display topics sorted by topic start. | 
-| disp_position | int | 0 | The vertical display position of the forum (relative to other forums in the same category). | 
-| cat_id | int | 0 | The category in which the forum resides. | 
- 
-==== groups ==== 
- 
-^ **Field** ^ **Type** ^ **Default** ^ **Description** ^ 
-| g_id | int |  | The auto-incrementing (identity) primary key identifier for this table. | 
-| g_title | varchar(50) |  | The name of the group. | 
-| g_user_title | varchar(50) | NULL | The title of users in this group. | 
-| g_read_board | tinyint/smallint | 1 | 0 = Deny. 1 = Allow. | 
-| g_post_replies | tinyint/smallint | 1 | 0 = Deny. 1 = Allow. | 
-| g_post_topics | tinyint/smallint | 1 | 0 = Deny. 1 = Allow. | 
-| g_post_polls | tinyint/smallint | 1 | 0 = Deny. 1 = Allow. | 
-| g_edit_posts | tinyint/smallint | 1 | 0 = Deny. 1 = Allow. | 
-| g_delete_posts | tinyint/smallint | 1 | 0 = Deny. 1 = Allow. | 
-| g_delete_topics | tinyint/smallint | 1 | 0 = Deny. 1 = Allow. | 
-| g_set_title | tinyint/smallint | 1 | 0 = Deny. 1 = Allow. | 
-| g_search | tinyint/smallint | 1 | 0 = Deny. 1 = Allow. | 
-| g_search_users | tinyint/smallint | 1 | 0 = Deny. 1 = Allow. | 
-| g_edit_subjects_interval | smallint | 300 | Number of seconds after post time that users in this group may edit the subject of topics they've posted. | 
-| g_post_flood | smallint | 30 | Number of seconds that users in this group have to wait between posts. | 
-| g_search_flood | smallint | 30 | Number of seconds that users in this group have to wait between searches. | 
- 
-==== online ==== 
- 
-^ **Field** ^ **Type** ^ **Default** ^ **Description** ^ 
-| user_id | int | 1 | ID of the user (always 1 for guests). | 
-| ident | varchar(200) |  | Identification string for the user. Username for logged in users and IP address for guests. | 
-| logged | int | 0 | A UNIX timestamp representing the date/time for the user's last activity. | 
-| idle | tinyint/smallint | 0 | 0 = User has been active within the last "Online timeout" seconds. 1 = User has timed out. | 
- 
-==== posts ==== 
- 
-^ **Field** ^ **Type** ^ **Default** ^ **Description** ^ 
-| id | int |  | The auto-incrementing (identity) primary key identifier for this table. | 
-| poster | varchar(200) |  | The username (or guest name) of the user that made the post. | 
-| poster_id | int | 1 | The user ID of the user that made the post (always 1 for guests). | 
-| poster_ip | varchar(15) | NULL | The IP address the post was made from. | 
-| poster_email | varchar(50) | NULL | The guest e-mail address (if supplied). | 
-| message | text |  | The actual message contents. | 
-| hide_smilies | tinyint/smallint | 0 | 0 = Let users decide whether to show smilies as images or not in this post. 1 = Never show smilies as images in this post. | 
-| posted | int | 0 | A UNIX timestamp representing the date/time the post was made. | 
-| edited | int | NULL | A UNIX timestamp representing the date/time the post was last edited. | 
-| edited_by | varchar(200) | NULL | The username of the user that last edited the post. | 
-| topic_id | int | 0 | The topic ID in which the post resides. | 
- 
-==== ranks ==== 
- 
-^ **Field** ^ **Type** ^ **Default** ^ **Description** ^ 
-| id | int |  | The auto-incrementing (identity) primary key identifier for this table. | 
-| rank | varchar(50) |  | The rank title. | 
-| min_posts | mediumint/int | 0 | The number of posts a user must attain in order to reach the rank. | 
- 
-==== reports ==== 
- 
-^ **Field** ^ **Type** ^ **Default** ^ **Description** ^ 
-| id | int |  | The auto-incrementing (identity) primary key identifier for this table. | 
-| post_id | int | 0 | The post the report relates to. | 
-| topic_id | int | 0 | The topic in which the reported post resides in. | 
-| forum_id | int | 0 | The forum in which the reported post resides in. | 
-| reported_by | int | 0 | The user ID of the user that reported the post. | 
-| created | int | 0 | A UNIX timestamp representing the date/time the post was last edited. | 
-| message | text |  | The report message. | 
-| zapped | int | NULL | A UNIX timestamp representing the date/time the report was zapped (marked as read). | 
-| zapped_by | int | NULL | The username of the administrator or moderator that zapped the report. | 
- 
-==== search_cache ==== 
- 
-^ **Field** ^ **Type** ^ **Default** ^ **Description** ^ 
-| id | int | 0 | The primary key identifier for this table. | 
-| ident | varchar(200) |  | Identification string for the searcher. Username for logged in users and IP address for guests. | 
-| search_data | text |  | A serialized PHP array of search data (e.g. post ID's, sort direction etc.). | 
- 
-==== search_matches ==== 
- 
-^ **Field** ^ **Type** ^ **Default** ^ **Description** ^ 
-| post_id | int | 0 | The post this match relates to. | 
-| word_id | mediumint/int | 0 | The word this match relates to. | 
-| subject_match | tinyint/smallint | 0 | 0 = Match is in the post message. 1 = Match is in the topic subject. | 
- 
-==== search_words ==== 
- 
-^ **Field** ^ **Type** ^ **Default** ^ **Description** ^ 
-| id | mediumint/int |  | An integer identifier for this table. | 
-| word | varchar(20) |  | The indexed word (primary key). | 
- 
-==== subscriptions ==== 
- 
-^ **Field** ^ **Type** ^ **Default** ^ **Description** ^ 
-| user_id | int | 0 | The user that subscribes to topic_id. Primary key identifier together with topic_id for this table. | 
-| topic_id | int | 0 | The topic user_id subscribes to. Primary key identifier together with user_id for this table. | 
- 
-==== topics ==== 
- 
-^ **Field** ^ **Type** ^ **Default** ^ **Description** ^ 
-| id | int |  | The auto-incrementing (identity) primary key identifier for this table. | 
-| poster | varchar(200) |  | The username (or guest name) of the user that posted the topic. | 
-| subject | varchar(255) |  | The topic subject. | 
-| posted | int | 0 | A UNIX timestamp representing the date/time the topic was posted. | 
-| last_post | int | NULL | A UNIX timestamp representing the date/time the last post was made in the topic. | 
-| last_post_id | int | NULL | The ID of the last post that was made in the topic. | 
-| last_poster | varchar(200) | NULL | The username (or guest name) of the user that made the last post in the topic. | 
-| num_views | mediumint/int | 0 | The number of times the topic has been viewed. | 
-| num_replies | mediumint/int | 0 | The number of replies that have been posted in the topic. | 
-| closed | tinyint/smallint | 0 | 0 = Topic is open. 1 = Topic is closed. | 
-| sticky | tinyint/smallint | 0 | 0 = Topic is a regular topic. 1 = Topic is a sticky topic. | 
-| moved_to | int | NULL | The forum to which the topic has been moved. | 
-| forum_id | int | 0 | The forum in which the topic resides. | 
- 
-==== users ==== 
- 
-^ **Field** ^ **Type** ^ **Default** ^ **Description** ^ 
-| id | int |  | The auto-incrementing (identity) primary key identifier for this table. | 
-| group_id | int | 4 | The user group to which this user belongs. | 
-| username | varchar(200) |  | The user's username. | 
-| password | varchar(40) |  | The user password as an 40 byte SHA1 hash or an 32 byte MD5 hash. | 
-| email | varchar(50) |  | The user e-mail address. | 
-| title | varchar(50) | NULL | The user custom title. | 
-| realname | varchar(40) | NULL | The user's name. | 
-| url | varchar(100) | NULL | A link to the user's website. | 
-| jabber | varchar(75) | NULL | The user's Jabber address. | 
-| icq | varchar(12) | NULL | The user's ICQ UIN. | 
-| msn | varchar(50) | NULL | The user's MSN Messenger e-mail address. | 
-| aim | varchar(30) | NULL | The user's AOL Instant Messenger username. | 
-| yahoo | varchar(30) | NULL | The user's Yahoo Messenger username. | 
-| location | varchar(30) | NULL | The user's geographical location. | 
-| use_avatar | tinyint/smallint | 0 | 0 = Don't show avatar to other users. 1 = Show avatar to other users. | 
-| signature | text | NULL | The user's signature. | 
-| disp_topics | tinyint/smallint | NULL | The number of topics to display on forum page (uses forum default if left blank). | 
-| disp_posts | tinyint/smallint | NULL | The number of posts to display on topic page (uses forum default if left blank). | 
-| email_setting | tinyint/smallint | 1 | 0 = Show e-mail address to other users. 1 = Hide e-mail address, but allow form e-mail. 2 = Hide e-mail address and disallow form e-mail. | 
-| save_pass | tinyint/smallint | 1 | 0 = Don't remember user between visits. 1 = Remember user between visits. | 
-| notify_with_post | tinyint/smallint | 0 | 0 = Include only topic subject in subscription notification e-mails. 1 = Include both topic subject and post content in subscription notification e-mails. | 
-| show_smilies | tinyint/smallint | 1 | Show smilies as images. | 
-| show_img | tinyint/smallint | 1 | Show images in posts. | 
-| show_img_sig | tinyint/smallint | 1 | Show images in signatures. | 
-| show_avatars | tinyint/smallint | 1 | Show avatars. | 
-| show_sig | tinyint/smallint | 1 | Show signatures. | 
-| timezone | float | 0 | The user's timezone. | 
-| language | varchar(25) | 'English' | The user's preferred language for the forum UI. | 
-| style | varchar(25) | 'Oxygen' | The user's preferred style. | 
-| num_posts | int | 0 | The number of posts the user has made. | 
-| last_post | int | NULL | A UNIX timestamp representing the date/time the last post by the user was made. | 
-| registered | int | 0 | A UNIX timestamp representing the date the user registered. | 
-| registration_ip | varchar(15) | 0.0.0.0 | The IP address used when registering. | 
-| last_visit | int | 0 | A UNIX timestamp representing the date/time the last visit by the user commenced. | 
-| admin_note | varchar(30) | NULL | A user note only viewable and editable by administrators and moderators. | 
-| activate_string | varchar(50) | NULL | A temporary storage string for new passwords and new e-mail addresses. | 
-| activate_key | varchar(8) | NULL | A temporary storage string for new password and new e-mail address activation keys. | 

Personal Tools