Home
Accueil
Downloads
Téléchargements
Forums
Forums
Your Account
Votre compte
Menu
· Accueil ·

· Communication ·
  · Forums
  · Messages privés
  · Contactez nous
  · Recommendez nous
  · Sondages
  · Les projets

· Nouvelles ·Stats
  · Sujets
  · Ecrire un article
  · Articles archivés
  · Articles RSS
  · Lettre de sécurité
  · Archive de lettres

· Téléchargements ·
  · Accueil
  · Nouveautés
  · Mises à jour
  · Thêmes

· Outils ·
  · Outils divers
  · Convertisseur de temps
  · Table de caractères
  · Générateur de boutons
  · Compresseur Javascript

· Documentation ·
  · Wiki
  · Questions/Réponses
  · Documents
  · Manuel PHP-Nuke
  · Manuel PHP
  · Manuel PEAR
  · Encyclopédies

· Liens ·
  · Nos liens
  · Nos fluxs RSS
  · Partenaires
  · Votre publicité
  · Sitemap
  · Mes bannières

· Infos ·
  · Rechercher
  · Votre compte
  · Liste des membres
  · Carte des membres
  · Top

· Divers ·
  · Météo
  · Galeries
  · Statistiques Phpnuke
  · MS Analysis


The database tables

28.1. The database tables

Here are the tables that comprise the PHP-Nuke database and what they serve for (FIXME: these are still from a very old version! Update! Data model!):

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.


Help us make a better PHP-Nuke HOWTO!

Want to contribute to this HOWTO? Have a suggestion or a solution to a problem that was not treated here? Post your comments on my PHP-Nuke Forum!

Chris Karakas, Maintainer PHP-Nuke HOWTO

Syndiquez notre contenu RSS, Atom, etc..
PHP-Nuke © 2007Reproduction interdite sans autorisation de ma part www.stefvar.com Copyright © 2008Thème iCGstation
Site français de la communauté PragmaMx