<HTML ><HEAD ><TITLE >Programmer's tools </TITLE ><META NAME="GENERATOR" CONTENT="Modular DocBook HTML Stylesheet Version 1.7"><LINK REL="HOME" TITLE="PHP-Nuke: Management and Programming" HREF="book1.htm"><LINK REL="PREVIOUS" TITLE="Cookies - timeout and configuration" HREF="x2144.htm"><LINK REL="NEXT" TITLE="The syntax of SQL code" HREF="x2643.htm"></HEAD ><BODY CLASS="CHAPTER" BGCOLOR="#FFFFFF" TEXT="#000000" LINK="#0000FF" VLINK="#840084" ALINK="#0000FF" ><DIV CLASS="NAVHEADER" ><TABLE SUMMARY="Header navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TH COLSPAN="3" ALIGN="center" >PHP-Nuke: Management and Programming</TH ></TR ><TR ><TD WIDTH="10%" ALIGN="left" VALIGN="bottom" ><A HREF="x2144.htm" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="80%" ALIGN="center" VALIGN="bottom" ></TD ><TD WIDTH="10%" ALIGN="right" VALIGN="bottom" ><A HREF="x2643.htm" ACCESSKEY="N" >Next</A ></TD ></TR ></TABLE ><HR ALIGN="LEFT" WIDTH="100%"></DIV ><DIV CLASS="CHAPTER" ><H1 ><A NAME="TOOLS" ></A >Chapter 11. Programmer's tools </H1 ><DIV CLASS="TOC" ><DL ><DT ><B >Table of Contents</B ></DT ><DT ><A HREF="c2221.htm#DATABASE-TABLES" >The database tables</A ></DT ><DT ><A HREF="x2643.htm" >The syntax of SQL code</A ></DT ><DT ><A HREF="x2692.htm" >PHPMyadmin, administering MySQL via web</A ></DT ><DT ><A HREF="x2753.htm" >MySQL Front, how to administer a MySQL DB from Windows</A ></DT ><DT ><A HREF="x2797.htm" >Foxserv, making PHP-Nuke work on Windows Systems</A ></DT ></DL ></DIV ><DIV CLASS="SECT1" ><H1 CLASS="SECT1" ><A NAME="DATABASE-TABLES" ></A >The database tables</H1 ><P >Here are the tables<A NAME="AEN2226" ></A > that comprise the PHP-Nuke database and what they serve for:</P ><P ></P ><DIV CLASS="VARIABLELIST" ><DL ><DT >nuke_access<A NAME="AEN2231" ></A >:</DT ><DD ><P >Defines various users profiles.</P ></DD ><DT >nuke_authors<A NAME="AEN2237" ></A >:</DT ><DD ><P >Defines the administrators and their access levels.</P ></DD ><DT >nuke_autonews<A NAME="AEN2243" ></A >:</DT ><DD ><P >Manages automatic news.</P ></DD ><DT >nuke_banlist<A NAME="AEN2249" ></A >:</DT ><DD ><P >Manages banned users (those excluded from viewing the site).</P ></DD ><DT >nuke_banner<A NAME="AEN2255" ></A >:</DT ><DD ><P >Manages banner campaigns, impressions and clicks.</P ></DD ><DT >nuke_bannerclient<A NAME="AEN2261" ></A >:</DT ><DD ><P >Manages the banner campaign clients.</P ></DD ><DT >nuke_bbtopics<A NAME="AEN2267" ></A >:</DT ><DD ><P >Manages the BBCode.</P ></DD ><DT >nuke_blocks<A NAME="AEN2273" ></A >:</DT ><DD ><P >List of created blocks.</P ></DD ><DT >nuke_catagories<A NAME="AEN2279" ></A >:</DT ><DD ><P >List of the categories.</P ></DD ><DT >nuke_comments<A NAME="AEN2285" ></A >:</DT ><DD ><P >Manages comments and answers.</P ></DD ><DT >nuke_config<A NAME="AEN2291" ></A >:</DT ><DD ><P >Manages some configurations like the possibility to mail in HTML etc.</P ></DD ><DT >nuke_counter<A NAME="AEN2297" ></A >:</DT ><DD ><P >Manages statistics.</P ></DD ><DT >nuke_disallow<A NAME="AEN2303" ></A >:</DT ><DD ><P >Blocks a user.</P ></DD ><DT >nuke_downloads_categories<A NAME="AEN2309" ></A >:</DT ><DD ><P >Manages categories and subcategories for the download area.</P ></DD ><DT >nuke_downloads_downloads<A NAME="AEN2315" ></A >:</DT ><DD ><P >Manages the files present in the download area.</P ></DD ><DT >nuke_downloads_editorials<A NAME="AEN2321" ></A >:</DT ><DD ><P >Manages the comments on the files.</P ></DD ><DT >nuke_downloads_modrequest<A NAME="AEN2327" ></A >:</DT ><DD ><P >Manages the reporting of broken links.</P ></DD ><DT >nuke_downloads_newdownload<A NAME="AEN2333" ></A >:</DT ><DD ><P >Manages the insertion of files from third parties.</P ></DD ><DT >nuke_downloads_moddata<A NAME="AEN2339" ></A >:</DT ><DD ><P >Manages voting on files.</P ></DD ><DT >nuke_encyclopedya<A NAME="AEN2345" ></A >:</DT ><DD ><P >Lists the various encyclopedias.</P ></DD ><DT >nuke_encyclopedia_text<A NAME="AEN2351" ></A >:</DT ><DD ><P >Lists encyclopedia entries.</P ></DD ><DT >nuke_ephem<A NAME="AEN2357" ></A ></DT ><DD ><P >Manages recurrent events.</P ></DD ><DT >nuke_faqanswer<A NAME="AEN2363" ></A >:</DT ><DD ><P >Archives the FAQ answers.</P ></DD ><DT >nuke_faqcategories<A NAME="AEN2369" ></A >:</DT ><DD ><P >Manages the categories in which the FAQ are subdivided.</P ></DD ><DT >nuke_forum_access<A NAME="AEN2375" ></A >:</DT ><DD ><P >Records the last access of the users.</P ></DD ><DT >nuke_forum_mods<A NAME="AEN2381" ></A >:</DT ><DD ><P >Defines moderators of the forums.</P ></DD ><DT >nuke_forums<A NAME="AEN2387" ></A >:</DT ><DD ><P >Defines the active forums.</P ></DD ><DT >nuke_forumtopics<A NAME="AEN2393" ></A >:</DT ><DD ><P >Defines forum topics.</P ></DD ><DT >nuke_headlines<A NAME="AEN2399" ></A >:</DT ><DD ><P >Defines the sources from which to take news with the blocks.</P ></DD ><DT >nuke_links_categories<A NAME="AEN2405" ></A >:</DT ><DD ><P >Defines the categories in which the links are subdivided. </P ></DD ><DT >nuke_links_editorials<A NAME="AEN2411" ></A >:</DT ><DD ><P >Manages the judgments on the links.</P ></DD ><DT >nuke_links_links<A NAME="AEN2417" ></A >:</DT ><DD ><P >Archives the links.</P ></DD ><DT >nuke_links_modrequest<A NAME="AEN2423" ></A >:</DT ><DD ><P >Archives the messages related to the link (broken link etc.).</P ></DD ><DT >nuke_links_newlink<A NAME="AEN2429" ></A >:</DT ><DD ><P >Archives links suggested for insertion.</P ></DD ><DT >nuke_links_votedata<A NAME="AEN2435" ></A >:</DT ><DD ><P >Archives link votes.</P ></DD ><DT >nuke_main<A NAME="AEN2441" ></A >:</DT ><DD ><P >Defines which is the main module that must be included in index.php.</P ></DD ><DT >nuke_message<A NAME="AEN2447" ></A >:</DT ><DD ><P >Manages the home page messages.</P ></DD ><DT >nuke_modules<A NAME="AEN2453" ></A >:</DT ><DD ><P >Lists and manages the installed modules.</P ></DD ><DT >nuke_pages<A NAME="AEN2459" ></A >:</DT ><DD ><P > </P ></DD ><DT >nuke_pages_categories<A NAME="AEN2465" ></A >:</DT ><DD ><P > </P ></DD ><DT >nuke_poll_check<A NAME="AEN2471" ></A >:</DT ><DD ><P >List of the IP addresses that have voted in last 24 hours.</P ></DD ><DT >nuke_poll_data<A NAME="AEN2477" ></A >:</DT ><DD ><P >List of survey answers.</P ></DD ><DT >nuke_poll_desc<A NAME="AEN2483" ></A >:</DT ><DD ><P >List of present and past surveys.</P ></DD ><DT >nuke_pollcomments<A NAME="AEN2489" ></A >:</DT ><DD ><P >Comment to the survey.</P ></DD ><DT >nuke_posts<A NAME="AEN2495" ></A >:</DT ><DD ><P >Main titles of forum posts</P ></DD ><DT >nuke_posts_text<A NAME="AEN2501" ></A >:</DT ><DD ><P > </P ></DD ><DT >nuke_priv_msgs<A NAME="AEN2507" ></A >:</DT ><DD ><P >Manages the module private messages.</P ></DD ><DT >nuke_queue<A NAME="AEN2513" ></A >:</DT ><DD ><P >Lists the texts waiting for publication</P ></DD ><DT >nuke_quotes<A NAME="AEN2519" ></A >:</DT ><DD ><P > </P ></DD ><DT >nuke_ranks<A NAME="AEN2525" ></A >:</DT ><DD ><P >Registers the votes for the news</P ></DD ><DT >nuke_referer<A NAME="AEN2531" ></A >:</DT ><DD ><P >Lists where the last x rows come from</P ></DD ><DT >nuke_related<A NAME="AEN2537" ></A >:</DT ><DD ><P >Associates eventual links to the topics.</P ></DD ><DT >nuke_reviews<A NAME="AEN2543" ></A >:</DT ><DD ><P > </P ></DD ><DT >nuke_reviews_add<A NAME="AEN2549" ></A >:</DT ><DD ><P > </P ></DD ><DT >nuke_reviews_comments<A NAME="AEN2555" ></A >:</DT ><DD ><P >Comments to the reviews.</P ></DD ><DT >nuke_reviews_main<A NAME="AEN2561" ></A >:</DT ><DD ><P >main table of the reviews.</P ></DD ><DT >nuke_seccont<A NAME="AEN2567" ></A >:</DT ><DD ><P >Lists the section texts.</P ></DD ><DT >nuke_sections<A NAME="AEN2573" ></A >:</DT ><DD ><P >Lists the active sections.</P ></DD ><DT >nuke_session<A NAME="AEN2579" ></A >:</DT ><DD ><P >Lists the active sessions.</P ></DD ><DT >nuke_smiles<A NAME="AEN2585" ></A >:</DT ><DD ><P >Lists the supported emoticons.</P ></DD ><DT >nuke_stats_date<A NAME="AEN2591" ></A >:</DT ><DD ><P >Statistics module.</P ></DD ><DT >nuke_stats_hour<A NAME="AEN2597" ></A >:</DT ><DD ><P >Statistics module...</P ></DD ><DT >nuke_stats_month<A NAME="AEN2603" ></A >:</DT ><DD ><P >Statistics module.</P ></DD ><DT >nuke_stats_year<A NAME="AEN2609" ></A >:</DT ><DD ><P >Statistics module.</P ></DD ><DT >nuke_stories<A NAME="AEN2615" ></A >:</DT ><DD ><P >Texts of the news.</P ></DD ><DT >nuke_stories_cat<A NAME="AEN2621" ></A >:</DT ><DD ><P >Categories of the news.</P ></DD ><DT >nuke_topics<A NAME="AEN2627" ></A >:</DT ><DD ><P >List of topics.</P ></DD ><DT >nuke_users<A NAME="AEN2633" ></A >:</DT ><DD ><P >List of users.</P ></DD ><DT >nuke_words<A NAME="AEN2639" ></A >:</DT ><DD ><P >Words to censure.</P ></DD ></DL ></DIV ></DIV ></DIV ><DIV CLASS="NAVFOOTER" ><HR ALIGN="LEFT" WIDTH="100%"><TABLE SUMMARY="Footer navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" ><A HREF="x2144.htm" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="book1.htm" ACCESSKEY="H" >Home</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" ><A HREF="x2643.htm" ACCESSKEY="N" >Next</A ></TD ></TR ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" >Cookies - timeout and configuration</TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" > </TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" >The syntax of SQL code</TD ></TR ></TABLE ></DIV ></BODY ></HTML >