Chapter 11. Programmer's tools

Table of Contents
The database tables
The syntax of SQL code
PHPMyadmin, administering MySQL via web
MySQL Front, how to administer a MySQL DB from Windows
Foxserv, making PHP-Nuke work on Windows Systems

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.