811 lines
9.3 KiB
HTML
811 lines
9.3 KiB
HTML
<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
|
|
> |