 |
|
Chapter 11. Programmer's tools
The database tables
Here are the tables that comprise the PHP-Nuke database and what they serve for:
- nuke_access:
Defines various users profiles.
- nuke_authors:
Defines the administrators and their access levels.
- nuke_autonews:
Manages automatic news.
- nuke_banlist:
Manages banned users (those excluded from viewing the site).
- nuke_banner:
Manages banner campaigns, impressions and clicks.
- nuke_bannerclient:
Manages the banner campaign clients.
- nuke_bbtopics:
Manages the BBCode.
- nuke_blocks:
List of created blocks.
- nuke_catagories:
List of the categories.
- nuke_comments:
Manages comments and answers.
- nuke_config:
Manages some configurations like the possibility to mail in HTML etc.
- nuke_counter:
Manages statistics.
- nuke_disallow:
Blocks a user.
- nuke_downloads_categories:
Manages categories and subcategories for the download area.
- nuke_downloads_downloads:
Manages the files present in the download area.
- nuke_downloads_editorials:
Manages the comments on the files.
- nuke_downloads_modrequest:
Manages the reporting of broken links.
- nuke_downloads_newdownload:
Manages the insertion of files from third parties.
- nuke_downloads_moddata:
Manages voting on files.
- nuke_encyclopedya:
Lists the various encyclopedias.
- nuke_encyclopedia_text:
Lists encyclopedia entries.
- nuke_ephem
Manages recurrent events.
- nuke_faqanswer:
Archives the FAQ answers.
- nuke_faqcategories:
Manages the categories in which the FAQ are subdivided.
- nuke_forum_access:
Records the last access of the users.
- nuke_forum_mods:
Defines moderators of the forums.
- nuke_forums:
Defines the active forums.
- nuke_forumtopics:
Defines forum topics.
- nuke_headlines:
Defines the sources from which to take news with the blocks.
- nuke_links_categories:
Defines the categories in which the links are subdivided.
- nuke_links_editorials:
Manages the judgments on the links.
- nuke_links_links:
Archives the links.
- nuke_links_modrequest:
Archives the messages related to the link (broken link etc.).
- nuke_links_newlink:
Archives links suggested for insertion.
- nuke_links_votedata:
Archives link votes.
- nuke_main:
Defines which is the main module that must be included in index.php.
- nuke_message:
Manages the home page messages.
- nuke_modules:
Lists and manages the installed modules.
- nuke_pages:
- nuke_pages_categories:
- nuke_poll_check:
List of the IP addresses that have voted in last 24 hours.
- nuke_poll_data:
List of survey answers.
- nuke_poll_desc:
List of present and past surveys.
- nuke_pollcomments:
Comment to the survey.
- nuke_posts:
Main titles of forum posts
- nuke_posts_text:
- nuke_priv_msgs:
Manages the module private messages.
- nuke_queue:
Lists the texts waiting for publication
- nuke_quotes:
- nuke_ranks:
Registers the votes for the news
- nuke_referer:
Lists where the last x rows come from
- nuke_related:
Associates eventual links to the topics.
- nuke_reviews:
- nuke_reviews_add:
- nuke_reviews_comments:
Comments to the reviews.
- nuke_reviews_main:
main table of the reviews.
- nuke_seccont:
Lists the section texts.
- nuke_sections:
Lists the active sections.
- nuke_session:
Lists the active sessions.
- nuke_smiles:
Lists the supported emoticons.
- nuke_stats_date:
Statistics module.
- nuke_stats_hour:
Statistics module...
- nuke_stats_month:
Statistics module.
- nuke_stats_year:
Statistics module.
- nuke_stories:
Texts of the news.
- nuke_stories_cat:
Categories of the news.
- nuke_topics:
List of topics.
- nuke_users:
List of users.
- nuke_words:
Words to censure.