PHP-Nuke: Management and Programming
Prev		Next

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.

Prev	Home	Next
Cookies - timeout and configuration		The syntax of SQL code