Update of /cvsroot/phpbt/phpbt/docs/html In directory usw-pr-cvs1:/tmp/cvs-serv28734/html Modified Files: adminguide.html bugsearch.html configuration.html devguide.html devstandards.html index.html schema.html Added Files: installation.html Log Message: Updating for 0.8.0 --- NEW FILE: installation.html --- <HTML ><HEAD ><TITLE >Installation Instructions</TITLE ><META NAME="GENERATOR" CONTENT="Modular DocBook HTML Stylesheet Version 1.76b+ "><LINK REL="HOME" TITLE="phpBugTracker" HREF="index.html"><LINK REL="UP" TITLE="Administrator's Guide" HREF="adminguide.html"><LINK REL="PREVIOUS" TITLE="Administrator's Guide" HREF="adminguide.html"><LINK REL="NEXT" TITLE="Configuration Options" HREF="configuration.html"><LINK REL="STYLESHEET" TYPE="text/css" HREF="docs.css"></HEAD ><BODY CLASS="SECT1" BGCOLOR="#FFFFFF" TEXT="#000000" LINK="#0000FF" VLINK="#800080" ALINK="#FF0000" ><DIV CLASS="NAVHEADER" ><TABLE SUMMARY="Header navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TH COLSPAN="3" ALIGN="center" >phpBugTracker</TH ></TR ><TR ><TD WIDTH="10%" ALIGN="left" VALIGN="bottom" ><A HREF="adminguide.html" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="80%" ALIGN="center" VALIGN="bottom" >Chapter 2. Administrator's Guide</TD ><TD WIDTH="10%" ALIGN="right" VALIGN="bottom" ><A HREF="configuration.html" ACCESSKEY="N" >Next</A ></TD ></TR ></TABLE ><HR ALIGN="LEFT" WIDTH="100%"></DIV ><DIV CLASS="SECT1" ><H1 CLASS="SECT1" ><A NAME="INSTALLATION">2.2. Installation Instructions</H1 ><DIV CLASS="PROCEDURE" ><A NAME="INSTALL-PROCEDURE" ></A ><OL TYPE="1" ><LI ><P >Copy the directory tree from the tarball (or zip archive) to a location suitable for serving web pages.</P ></LI ><LI ><P >With your web browser, go the location where you installed the package. You will be presented with a web page that will help you configure and install the application.</P ></LI ><LI ><P >After completing the installation, login and start reporting bugs.</P ><DIV CLASS="NOTE" ><TABLE CLASS="NOTE" WIDTH="100%" BORDER="0" ><TR ><TD WIDTH="25" ALIGN="CENTER" VALIGN="TOP" ><IMG SRC="images/note.gif" HSPACE="5" ALT="Note"></TD ><TD ALIGN="LEFT" VALIGN="TOP" ><P >Optional: Install JpGraph (<A HREF="http://www.aditus.nu/jpgraph/" TARGET="_top" >http://www.aditus.nu/jpgraph</A >) if you wish to use it for the summary bug display on the home page.</P ></TD ></TR ></TABLE ></DIV ></LI ></OL ></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="adminguide.html" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="index.html" ACCESSKEY="H" >Home</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" ><A HREF="configuration.html" ACCESSKEY="N" >Next</A ></TD ></TR ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" >Administrator's Guide</TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="adminguide.html" ACCESSKEY="U" >Up</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" >Configuration Options</TD ></TR ></TABLE ></DIV ></BODY ></HTML > Index: adminguide.html =================================================================== RCS file: /cvsroot/phpbt/phpbt/docs/html/adminguide.html,v retrieving revision 1.13 retrieving revision 1.14 diff -u -r1.13 -r1.14 --- adminguide.html 28 Feb 2002 18:55:43 -0000 1.13 +++ adminguide.html 5 Apr 2002 19:06:07 -0000 1.14 @@ -13,8 +13,8 @@ TITLE="Working with Bugs" HREF="bugdetail.html"><LINK REL="NEXT" -TITLE="Configuration Options" -HREF="configuration.html"><LINK +TITLE="Installation Instructions" +HREF="installation.html"><LINK REL="STYLESHEET" TYPE="text/css" HREF="docs.css"></HEAD @@ -59,7 +59,7 @@ ALIGN="right" VALIGN="bottom" ><A -HREF="configuration.html" +HREF="installation.html" ACCESSKEY="N" >Next</A ></TD @@ -82,11 +82,16 @@ ></DT ><DT >2.1. <A -HREF="adminguide.html#INSTALLATION" ->Installation Instructions</A +HREF="adminguide.html#REQUIREMENTS" +>Requirements</A ></DT ><DT >2.2. <A +HREF="installation.html" +>Installation Instructions</A +></DT +><DT +>2.3. <A HREF="configuration.html" >Configuration Options</A ></DT @@ -106,93 +111,35 @@ ><H1 CLASS="SECT1" ><A -NAME="INSTALLATION">2.1. Installation Instructions</H1 -><DIV -CLASS="PROCEDURE" -><A -NAME="INSTALL-PROCEDURE" -></A -><OL -TYPE="1" +NAME="REQUIREMENTS">2.1. Requirements</H1 +><P +>Here is a list of things you need to have installed before you can install phpBugTracker:</P +><UL ><LI ><P ->Copy the directory tree from the tarball (or zip archive) to a location suitable for serving web pages.</P +>A web server (Apache, IIS, etc.) configured to run PHP scripts. The PHP version must be later than 4.0.6.</P ></LI ><LI ><P ->With your web browser, go the location where you installed the package. You will be presented with a web page that will help you configure and install the application.</P +>PEAR::DB. This is the database abstraction layer that comes with PEAR, which is included with recent distributions of PHP.</P ></LI ><LI ><P ->After completing the installation, login and start reporting bugs.</P -><DIV -CLASS="IMPORTANT" -><TABLE -CLASS="IMPORTANT" -WIDTH="100%" -BORDER="0" -><TR -><TD -WIDTH="25" -ALIGN="CENTER" -VALIGN="TOP" -><IMG -SRC="images/important.gif" -HSPACE="5" -ALT="Important"></TD -><TD -ALIGN="LEFT" -VALIGN="TOP" +>A database server. phpBugTracker has been tested with MySQL, PostgreSQL (>= 7.1 required) and Oracle 8. If you wish to run this package on another type of database, I am more than willing to support more types of databases if you are willing to help with testing.</P +></LI +><LI ><P ->You must have <TT -CLASS="VARNAME" ->magic_quotes_gpc</TT -> set to On either in <TT -CLASS="FILENAME" ->php.ini</TT -> or in <TT -CLASS="FILENAME" ->.htaccess</TT -> (see <A -HREF="http://www.php.net/manual/en/configuration.php" -TARGET="_top" ->http://www.php.net/manual/en/configuration.php</A -> for more info).</P -></TD -></TR -></TABLE -></DIV -><DIV -CLASS="NOTE" -><TABLE -CLASS="NOTE" -WIDTH="100%" -BORDER="0" -><TR -><TD -WIDTH="25" -ALIGN="CENTER" -VALIGN="TOP" -><IMG -SRC="images/note.gif" -HSPACE="5" -ALT="Note"></TD -><TD -ALIGN="LEFT" -VALIGN="TOP" +>A database created on your database server for use with phpBugTracker. You will need to supply this database name during the installation process.</P +></LI +><LI ><P ->Optional: Install JpGraph (<A -HREF="http://www.aditus.nu/jpgraph/" +>Smarty templates (<A +HREF="http://smarty.php.net/" TARGET="_top" ->http://www.aditus.nu/jpgraph</A ->) if you wish to use it for the summary bug display on the home page.</P -></TD -></TR -></TABLE -></DIV +>http://smarty.php.net/</A +>). If you do not have smarty templates already installed, a package of phpBugTracker is distributed that has smarty included and ready to go.</P ></LI -></OL -></DIV +></UL ></DIV ></DIV ><DIV @@ -229,7 +176,7 @@ ALIGN="right" VALIGN="top" ><A -HREF="configuration.html" +HREF="installation.html" ACCESSKEY="N" >Next</A ></TD @@ -249,7 +196,7 @@ WIDTH="33%" ALIGN="right" VALIGN="top" ->Configuration Options</TD +>Installation Instructions</TD ></TR ></TABLE ></DIV Index: bugsearch.html =================================================================== RCS file: /cvsroot/phpbt/phpbt/docs/html/bugsearch.html,v retrieving revision 1.4 retrieving revision 1.5 diff -u -r1.4 -r1.5 --- bugsearch.html 28 Feb 2002 18:55:43 -0000 1.4 +++ bugsearch.html 5 Apr 2002 19:06:08 -0000 1.5 @@ -97,7 +97,7 @@ > and <SPAN CLASS="GUILABEL" >Unconfirmed</SPAN ->from the <SPAN +> from the <SPAN CLASS="GUILABEL" >Status</SPAN > box and <SPAN Index: configuration.html =================================================================== RCS file: /cvsroot/phpbt/phpbt/docs/html/configuration.html,v retrieving revision 1.13 retrieving revision 1.14 diff -u -r1.13 -r1.14 --- configuration.html 28 Feb 2002 18:55:43 -0000 1.13 +++ configuration.html 5 Apr 2002 19:06:08 -0000 1.14 @@ -13,8 +13,8 @@ TITLE="Administrator's Guide" HREF="adminguide.html"><LINK REL="PREVIOUS" -TITLE="Administrator's Guide" -HREF="adminguide.html"><LINK +TITLE="Installation Instructions" +HREF="installation.html"><LINK REL="NEXT" TITLE="Developer's Guide" HREF="devguide.html"><LINK @@ -48,7 +48,7 @@ ALIGN="left" VALIGN="bottom" ><A -HREF="adminguide.html" +HREF="installation.html" ACCESSKEY="P" >Prev</A ></TD @@ -76,20 +76,20 @@ ><H1 CLASS="SECT1" ><A -NAME="CONFIGURATION">2.2. Configuration Options</H1 +NAME="CONFIGURATION">2.3. Configuration Options</H1 ><BLOCKQUOTE CLASS="ABSTRACT" ><DIV CLASS="ABSTRACT" ><A -NAME="AEN141"><P +NAME="AEN150"><P >Most of the options listed here can be configured via the Configuration page of the admin tools. The <TT CLASS="VARNAME" >DB_</TT > options can be found in <TT CLASS="FILENAME" >config.php</TT ->.</P +> and are specified during the installation process via the installation web page.</P ></DIV ></BLOCKQUOTE ><DIV @@ -123,7 +123,7 @@ >DB_TYPE</DT ><DD ><P ->The type of database server you are using, according to PHPlib's naming convention. Possible choices are msql, mssql, mysql, oci8, odbc, oracle, pgsql, and sybase. Note that only MySQL and PostgreSQL have been tested with phpBugTracker</P +>The type of database server you are using, according to PEAR's naming convention. Possible choices are fbsql, ibase, ifx, msql, mssql, mysql, oci8, odbc, pgsql, and sybase. Note that only MySQL, PostgreSQL and Oracle 8 have been tested with phpBugTracker</P ></DD ><DT >DB_HOST</DT @@ -182,6 +182,15 @@ > template files are located. This makes it easy to wrap the bug tracker in a completely different look.</P ></DD ><DT +>STYLE</DT +><DD +><P +>The CSS file to be used from the <TT +CLASS="FILENAME" +>styles</TT +> directory. This makes it easy to change the color scheme and other CSS properties.</P +></DD +><DT >USE_JPGRAPH</DT ><DD ><P @@ -292,6 +301,42 @@ >languages</TT > sub-directory to use for error and warning messages.</P ></DD +><DT +>STRICT_UPDATING</DT +><DD +><P +>If false, any logged-in user can make changes to a bug. If true, only the reporter, the person to whom the bug is currently assigned, and members of the Manager or Admin group can make changes to a bug.</P +></DD +><DT +>PROMOTE_VOTES</DT +><DD +><P +>The number of votes required to automatically promote a bug from the Unconfirmed to the New status. A value of 0 disables auto-promotion.</P +></DD +><DT +>MAX_USER_VOTES</DT +><DD +><P +>The total number of votes a user may file on bugs. A value of 0 disables the limit.</P +></DD +><DT +>RECALL_LOGIN</DT +><DD +><P +>Whether to show the "Remember Me" checkbox in the login form. When checked, that box will cause a cookie to be set that stores the user's login name or email address and will prefill the login area with that value the next time the user attempts to log in.</P +></DD +><DT +>SHOW_PROJECT_SUMMARIES</DT +><DD +><P +>Whether to show the detailed project stats on the home page.</P +></DD +><DT +>FORCE_LOGIN</DT +><DD +><P +>Whether users must log in before being able to browse the bugs or reports.</P +></DD ></DL ></DIV ></DIV @@ -311,7 +356,7 @@ ALIGN="left" VALIGN="top" ><A -HREF="adminguide.html" +HREF="installation.html" ACCESSKEY="P" >Prev</A ></TD @@ -339,7 +384,7 @@ WIDTH="33%" ALIGN="left" VALIGN="top" ->Administrator's Guide</TD +>Installation Instructions</TD ><TD WIDTH="34%" ALIGN="center" Index: devguide.html =================================================================== RCS file: /cvsroot/phpbt/phpbt/docs/html/devguide.html,v retrieving revision 1.19 retrieving revision 1.20 diff -u -r1.19 -r1.20 --- devguide.html 28 Feb 2002 18:55:43 -0000 1.19 +++ devguide.html 5 Apr 2002 19:06:08 -0000 1.20 @@ -82,23 +82,9 @@ ></DT ><DT >3.1. <A -HREF="devguide.html#DEPENDENCIES" ->Dependencies</A +HREF="devguide.html#MANIFEST" +>What's where?</A ></DT -><DD -><DL -><DT ->3.1.1. <A -HREF="devguide.html#DEP-PHPLIB" ->PHPlib</A -></DT -><DT ->3.1.2. <A -HREF="devguide.html#DEP-JPGRAPH" ->JpGraph</A -></DT -></DL -></DD ><DT >3.2. <A HREF="devstandards.html" @@ -130,7 +116,7 @@ ><DIV CLASS="ABSTRACT" ><A -NAME="AEN259"><P +NAME="AEN297"><P >Adding on to or extending phpBugTracker should be easy for those with a knowledge of PHP and SQL. New developers are always welcome to join the project at <A HREF="http://www.sourceforge.net/projects/phpbt/" TARGET="_top" @@ -143,254 +129,173 @@ ><H1 CLASS="SECT1" ><A -NAME="DEPENDENCIES">3.1. Dependencies</H1 -><BLOCKQUOTE -CLASS="ABSTRACT" -><DIV -CLASS="ABSTRACT" -><A -NAME="AEN264"><P ->phpBugTracker requires one external package, PHPlib, and can optionally use JpGraph. Of course a web server running a version of PHP later than 4.0 and a database server are also necessary.</P -></DIV -></BLOCKQUOTE -><DIV -CLASS="SECT2" -><H2 -CLASS="SECT2" -><A -NAME="DEP-PHPLIB">3.1.1. PHPlib</H2 +NAME="MANIFEST">3.1. What's where?</H1 +><P +>Following is a list of the PHP files that make up phpBugTracker and the functionality contained within them:</P +><UL +><LI ><P ->As of version 0.6.0, phpBugTracker includes the required portions of the PHPlib package in the <TT +><TT CLASS="FILENAME" ->inc</TT -> sub-directory. The PHPlib code provides the database abstraction layer, html templates, and session and authentication management.</P -><DIV -CLASS="SECT3" -><H3 -CLASS="SECT3" -><A -NAME="AEN270">3.1.1.1. Database Abstraction</H3 +>attachment.php</TT +></P ><P ->Instead of using PHP's database functions directly, interactions are done via database objects, which extend PHPlib's <TT -CLASS="CLASSNAME" ->DB_Sql</TT -> class.</P -><P ->The global variable <TT -CLASS="VARNAME" ->$q</TT -> is available as an instance of the class <TT -CLASS="CLASSNAME" ->dbclass</TT ->. This class adds two functions to the <TT -CLASS="CLASSNAME" ->DB_Sql</TT -> class, <TT -CLASS="FUNCTION" ->grab()</TT -> and <TT -CLASS="FUNCTION" ->grab_field()</TT ->. If they are called with an argument, the argument is passed as a query to the database and the results are returned from that query. If no argument is passed, they return results from the previous call to <TT -CLASS="FUNCTION" ->query()</TT ->. Here are some examples:</P -><DIV -CLASS="EXAMPLE" -><A -NAME="AEN281"><P -><B ->Example 3-1. Using the database class</B -></P -><TABLE -BORDER="0" -BGCOLOR="#EEEEEE" -WIDTH="100%" -><TR -><TD -><PRE -CLASS="PROGRAMLISTING" -> // Grab one field from one record in the database - $user_email = $q->grab_field("select email from ".TBL_AUTH_USER." where user_id = 1"); - echo $user_email; - - // Stuff all the fields from a user record into an array - $user_info = $q->grab("select * from ".TBL_AUTH_USER." where user_id = 1"); - echo $user_info['email']; - - // Work with a set of records - $q->query("select * from ".TBL_AUTH_USER); - while ($row = $q->grab()) { - echo $row['email'].'<br>'; - } - </PRE -></TD -></TR -></TABLE -></DIV -></DIV -><DIV -CLASS="SECT3" -><H3 -CLASS="SECT3" -><A -NAME="AEN284">3.1.1.2. Templates</H3 +>Adding, deleting, and viewing attachment information.</P +></LI +><LI ><P ->Instead of outputting HTML from the scripts, templates are used to separate the code from the HTML. The templates contain tokens that are replaced by the scripts with values. The general process for using templates is as follows:</P -><DIV -CLASS="EXAMPLE" -><A -NAME="AEN287"><P -><B ->Example 3-2. Using the template class</B -></P -><TABLE -BORDER="0" -BGCOLOR="#EEEEEE" -WIDTH="100%" -><TR -><TD -><PRE -CLASS="PROGRAMLISTING" -> // Set up the file to be used - $t->set_file('content', 'bugdisplay.html'); - - // Substitute the tokens with data - $t->set_var(array( - 'title' => $buginfo['title'], - 'description' => $buginfo['description'], - .... - )); - - // Parse the template and print it out (inside a wrap template) - $t->pparse('main', array('content', 'wrap', 'main')); - </PRE -></TD -></TR -></TABLE -></DIV -></DIV -><DIV -CLASS="SECT3" -><H3 -CLASS="SECT3" -><A -NAME="AEN290">3.1.1.3. Session and Authentication</H3 +><TT +CLASS="FILENAME" +>bug.php</TT +></P +><P +>Adding, displaying, and editing bugs. This includes the detailed view of a bug, printable view, bug history, a view of the votes for a bug, and the code that emails users about bug changes.</P +></LI +><LI ><P ->The session start and authentication code is included in <TT +><TT +CLASS="FILENAME" +>config-dist.php</TT +></P +><P +>This file is used as a template for generating the configuration file during installation.</P +></LI +><LI +><P +><TT +CLASS="FILENAME" +>config.php</TT +></P +><P +>This file is empty in the distribution package. When phpBugTracker has been installed this is the main configuration file that contains the table name definitions and includes the required packages.</P +></LI +><LI +><P +><TT CLASS="FILENAME" >include.php</TT ->. The session is started by a call to <TT -CLASS="FUNCTION" ->page_open()</TT ->, with the arguments specifying which session elements should be created. phpBugTracker uses the <TT -CLASS="CLASSNAME" ->Auth</TT -> and <TT -CLASS="CLASSNAME" ->Perm</TT -> classes from PHPlib in addition to the base <TT -CLASS="CLASSNAME" ->Session</TT -> class. </P -><DIV -CLASS="FORMALPARA" +></P +><P +>This file is included by every other script at page load, and contains page set-up such as creating the database connection, initializing the template object, and doing authentication checks.</P +></LI +><LI +><P +><TT +CLASS="FILENAME" +>install.php</TT +></P +><P +>This file is used during the installation process to gather configuration information from the user and to set up the database.</P +></LI +><LI ><P -><B ->Session. </B ->Session variables, or variables that should be retained from page to page, are set via the <TT -CLASS="VARNAME" ->$sess</TT -> variable, which is an instantiation of the <TT -CLASS="CLASSNAME" ->usess</TT -> class. You can register a session variable with <TT +><TT +CLASS="FILENAME" +>logout.php</TT +></P +><P +>This is used to end the user's session.</P +></LI +><LI +><P +><TT +CLASS="FILENAME" +>newaccount.php</TT +></P +><P +>The code for creating new accounts and emailing accout information to new sers is located here.</P +></LI +><LI +><P +><TT +CLASS="FILENAME" +>query.php</TT +></P +><P +>The bug search form is rendered and handled by this script, along with the resulting list of bugs from a query.</P +></LI +><LI +><P +><TT +CLASS="FILENAME" +>report.php</TT +></P +><P +>Various summary reports.</P +></LI +><LI +><P +><TT +CLASS="FILENAME" +>upgrade.php</TT +></P +><P +>Used when upgrading to a new verison of phpBugTracker. This file is changed with every release to include (mainly) the database queries required to upgrade the installation to the latest version.</P +></LI +><LI +><P +><TT +CLASS="FILENAME" +>user.php</TT +></P +><P +>User preferences and password changes are handled via this script.</P +></LI +><LI +><P +><TT +CLASS="FILENAME" +>admin/*.php</TT +></P +><P +>Each of these files handles a segment of the adminsitration. That is, <TT +CLASS="FILENAME" +>group.php</TT +> handles all the group adminstration, <TT +CLASS="FILENAME" +>project.php</TT +> is used for the project administration, etc.</P +></LI +><LI +><P +><TT +CLASS="FILENAME" +>inc/auth.php</TT +></P +><P +>Authentication class.</P +></LI +><LI +><P +><TT +CLASS="FILENAME" +>inc/functions.php</TT +></P +><P +>Supporting functions such as <TT CLASS="FUNCTION" ->$sess->register('<TT -CLASS="REPLACEABLE" -><I ->varname</I -></TT ->')</TT ->. When registering, make sure you don't include the $ with <TT -CLASS="REPLACEABLE" -><I ->varname</I -></TT ->. This variable will now be available in the global scope until the session is destroyed by the user closing the browser.</P -></DIV -><DIV -CLASS="FORMALPARA" +>build_select()</TT +>, etc.</P +></LI +><LI ><P -><B ->Auth. </B ->The login handler is located near the end of <TT +><TT CLASS="FILENAME" ->include.php</TT ->. Via the <TT -CLASS="CLASSNAME" ->uath</TT -> class, the global variable <TT -CLASS="VARNAME" ->$u</TT -> is set to the user id of the user if logged in, or to 'nobody' if not logged in. This variable should be used as the CreatedBy or LastModifiedBy value for database inserts and updates.</P -></DIV -><DIV -CLASS="FORMALPARA" +>inc/db/*.php</TT +></P ><P -><B ->Perm. </B ->There are two types of checks that are made in phpBugTracker: permission and group membership. These checks can be made two different ways -- one that exits and displays an access denied message (useful for protecting an entire page) or one that returns whether the user passed the check (useful for determining whether to display a piece of information).</P -></DIV -><DIV -CLASS="EXAMPLE" -><A -NAME="AEN315"><P -><B ->Example 3-3. Permission and Group Checking</B -></P -><TABLE -BORDER="0" -BGCOLOR="#EEEEEE" -WIDTH="100%" -><TR -><TD -><PRE -CLASS="PROGRAMLISTING" -> // Non-failing checks - if ($perm->have_perm('EditBug')) { - echo 'You can edit a bug!'; - } - if ($perm->in_group('User')) { - echo 'You are logged in and belong to the User group'; - } - - // Failing checks -- the script exits at this point if the check fails - $perm->check('Admin'); - $perm->check_group('Developer'); - </PRE -></TD -></TR -></TABLE -></DIV -></DIV -></DIV -><DIV -CLASS="SECT2" -><H2 -CLASS="SECT2" -><A -NAME="DEP-JPGRAPH">3.1.2. JpGraph</H2 +>These files, named by database type, contain queries (such as left joins) that have different syntaxes among various database types.</P +></LI +><LI ><P ->This section will not cover the usage of JpGraph in any detail, since it is not an integral part of phpBugTracker. Developers who are interested in using this class for generating bug reports or charting activity can see <TT +><TT CLASS="FILENAME" ->index.php</TT -> for an example and are encouraged to visit JpGraph's web site at <A -HREF="http://www.aditus.nu/jpgraph/" -TARGET="_top" ->http://www.aditus.nu/jpgraph</A ->.</P -></DIV +>languages/*.php</TT +></P +><P +>Named by language code, these files contain the localization of the text used throughout phpBugTracker.</P +></LI +></UL ></DIV ></DIV ><DIV Index: devstandards.html =================================================================== RCS file: /cvsroot/phpbt/phpbt/docs/html/devstandards.html,v retrieving revision 1.20 retrieving revision 1.21 diff -u -r1.20 -r1.21 --- devstandards.html 28 Feb 2002 18:55:43 -0000 1.20 +++ devstandards.html 5 Apr 2002 19:06:08 -0000 1.21 @@ -82,7 +82,7 @@ ><DIV CLASS="ABSTRACT" ><A -NAME="AEN325"><P +NAME="AEN377"><P > This section details the coding and process standards to be followed by the developers working on phpBugTracker. </P Index: index.html =================================================================== RCS file: /cvsroot/phpbt/phpbt/docs/html/index.html,v retrieving revision 1.17 retrieving revision 1.18 diff -u -r1.17 -r1.18 --- index.html 28 Feb 2002 18:55:44 -0000 1.17 +++ index.html 5 Apr 2002 19:06:08 -0000 1.18 @@ -77,11 +77,16 @@ ><DL ><DT >2.1. <A -HREF="adminguide.html#INSTALLATION" ->Installation Instructions</A +HREF="adminguide.html#REQUIREMENTS" +>Requirements</A ></DT ><DT >2.2. <A +HREF="installation.html" +>Installation Instructions</A +></DT +><DT +>2.3. <A HREF="configuration.html" >Configuration Options</A ></DT @@ -96,8 +101,8 @@ ><DL ><DT >3.1. <A -HREF="devguide.html#DEPENDENCIES" ->Dependencies</A +HREF="devguide.html#MANIFEST" +>What's where?</A ></DT ><DT >3.2. <A @@ -111,31 +116,6 @@ ></DT ></DL ></DD -></DL -></DIV -><DIV -CLASS="LOT" -><DL -CLASS="LOT" -><DT -><B ->List of Examples</B -></DT -><DT ->3-1. <A -HREF="devguide.html#AEN281" ->Using the database class</A -></DT -><DT ->3-2. <A -HREF="devguide.html#AEN287" ->Using the template class</A -></DT -><DT ->3-3. <A -HREF="devguide.html#AEN315" ->Permission and Group Checking</A -></DT ></DL ></DIV ></DIV Index: schema.html =================================================================== RCS file: /cvsroot/phpbt/phpbt/docs/html/schema.html,v retrieving revision 1.5 retrieving revision 1.6 diff -u -r1.5 -r1.6 --- schema.html 28 Feb 2002 18:55:44 -0000 1.5 +++ schema.html 5 Apr 2002 19:06:08 -0000 1.6 @@ -73,120 +73,9 @@ ><DIV CLASS="TABLE" ><A -NAME="AEN383"><P +NAME="AEN435"><P ><B ->Table 3-1. Schema for table active_sessions</B -></P -><TABLE -BORDER="1" -CLASS="CALSTABLE" -><THEAD -><TR -><TH -ALIGN="LEFT" -VALIGN="TOP" ->Field</TH -><TH -ALIGN="LEFT" -VALIGN="TOP" ->Type</TH -><TH -ALIGN="LEFT" -VALIGN="TOP" ->Key</TH -><TH -ALIGN="LEFT" -VALIGN="TOP" ->Description</TH -></TR -></THEAD -><TBODY -><TR -><TD -ALIGN="LEFT" -VALIGN="TOP" ->sid</TD -><TD -ALIGN="LEFT" -VALIGN="TOP" ->varchar(32)</TD -><TD -ALIGN="LEFT" -VALIGN="TOP" ->Primary</TD -><TD -ALIGN="LEFT" -VALIGN="TOP" -> </TD -></TR -><TR -><TD -ALIGN="LEFT" -VALIGN="TOP" ->name</TD -><TD -ALIGN="LEFT" -VALIGN="TOP" ->varchar(32)</TD -><TD -ALIGN="LEFT" -VALIGN="TOP" ->Primary</TD -><TD -ALIGN="LEFT" -VALIGN="TOP" -> </TD -></TR -><TR -><TD -ALIGN="LEFT" -VALIGN="TOP" ->val</TD -><TD -ALIGN="LEFT" -VALIGN="TOP" ->text</TD -><TD -ALIGN="LEFT" -VALIGN="TOP" -> </TD -><TD -ALIGN="LEFT" -VALIGN="TOP" -> </TD -></TR -><TR -><TD -ALIGN="LEFT" -VALIGN="TOP" ->changed</TD -><TD -ALIGN="LEFT" -VALIGN="TOP" ->varchar(14)</TD -><TD -ALIGN="LEFT" -VALIGN="TOP" -> </TD -><TD -ALIGN="LEFT" -VALIGN="TOP" -> </TD -></TR -></TBODY -></TABLE -></DIV -><P ->This table is used by PHPlib to store session information. It is updated with every call to <TT -CLASS="FUNCTION" ->page_close()</TT ->.</P -><DIV -CLASS="TABLE" -><A -NAME="AEN415"><P -><B ->Table 3-2. Schema for table attachment</B +>Table 3-1. Schema for table attachment</B ></P ><TABLE BORDER="1" @@ -362,9 +251,9 @@ ><DIV CLASS="TABLE" ><A -NAME="AEN465"><P +NAME="AEN485"><P ><B ->Table 3-3. Schema for table auth_group</B +>Table 3-2. Schema for table auth_group</B ></P ><TABLE BORDER="1" @@ -524,9 +413,9 @@ ><DIV CLASS="TABLE" ><A -NAME="AEN511"><P +NAME="AEN531"><P ><B ->Table 3-4. Schema for table auth_perm</B +>Table 3-3. Schema for table auth_perm</B ></P ><TABLE BORDER="1" @@ -671,9 +560,9 @@ ><DIV CLASS="TABLE" ><A -NAME="AEN553"><P +NAME="AEN573"><P ><B ->Table 3-5. Schema for table auth_user</B +>Table 3-4. Schema for table auth_user</B ></P ><TABLE BORDER="1" @@ -921,9 +810,9 @@ ><DIV CLASS="TABLE" ><A -NAME="AEN623"><P +NAME="AEN643"><P ><B ->Table 3-6. Schema for table bug</B +>Table 3-5. Schema for table bug</B ></P ><TABLE BORDER="1" @@ -1306,9 +1195,9 @@ ><DIV CLASS="TABLE" ><A -NAME="AEN731"><P +NAME="AEN751"><P ><B ->Table 3-7. Schema for table bug_cc</B +>Table 3-6. Schema for table bug_cc</B ></P ><TABLE BORDER="1" @@ -1412,7 +1301,77 @@ ><DIV CLASS="TABLE" ><A -NAME="AEN761"><P +NAME="AEN781"><P +><B +>Table 3-7. Schema for table bug_dependency</B +></P +><TABLE +BORDER="1" +CLASS="CALSTABLE" +><THEAD +><TR +><TH +ALIGN="LEFT" +VALIGN="TOP" +>Field</TH +><TH +ALIGN="LEFT" +VALIGN="TOP" +>Type</TH +><TH +ALIGN="LEFT" +VALIGN="TOP" +>Key</TH +><TH +ALIGN="LEFT" +VALIGN="TOP" +>Description</TH +></TR +></THEAD +><TBODY +><TR +><TD +ALIGN="LEFT" +VALIGN="TOP" +>bug_id</TD +><TD +ALIGN="LEFT" +VALIGN="TOP" +>int(10) unsigned</TD +><TD +ALIGN="LEFT" +VALIGN="TOP" +>Primary</TD +><TD +ALIGN="LEFT" +VALIGN="TOP" +> </TD +></TR +><TR +><TD +ALIGN="LEFT" +VALIGN="TOP" +>depends_on</TD +><TD +ALIGN="LEFT" +VALIGN="TOP" +>int(10) unsigned</TD +><TD +ALIGN="LEFT" +VALIGN="TOP" +>Primary</TD +><TD +ALIGN="LEFT" +VALIGN="TOP" +> </TD +></TR +></TBODY +></TABLE +></DIV +><DIV +CLASS="TABLE" +><A +NAME="AEN801"><P ><B >Table 3-8. Schema for table bug_group</B ></P @@ -1456,7 +1415,7 @@ ><TD ALIGN="LEFT" VALIGN="TOP" ->Foreign</TD +> </TD ></TR ><TR ><TD @@ -1474,7 +1433,7 @@ ><TD ALIGN="LEFT" VALIGN="TOP" ->Foreign</TD +> </TD ></TR ></TBODY ></TABLE @@ -1484,9 +1443,97 @@ ><DIV CLASS="TABLE" ><A -NAME="AEN782"><P +NAME="AEN822"><P ><B ->Table 3-9. Schema for table bug_history</B +>Table 3-9. Schema for table bug_vote</B +></P +><TABLE +BORDER="1" +CLASS="CALSTABLE" +><THEAD +><TR +><TH +ALIGN="LEFT" +VALIGN="TOP" +>Field</TH +><TH +ALIGN="LEFT" +VALIGN="TOP" +>Type</TH +><TH +ALIGN="LEFT" +VALIGN="TOP" +>Key</TH +><TH +ALIGN="LEFT" +VALIGN="TOP" +>Description</TH +></TR +></THEAD +><TBODY +><TR +><TD +ALIGN="LEFT" +VALIGN="TOP" +>user_id</TD +><TD +ALIGN="LEFT" +VALIGN="TOP" +>int(10) unsigned</TD +><TD +ALIGN="LEFT" +VALIGN="TOP" +>Primary</TD +><TD +ALIGN="LEFT" +VALIGN="TOP" +> </TD +></TR +><TR +><TD +ALIGN="LEFT" +VALIGN="TOP" +>bug_id</TD +><TD +ALIGN="LEFT" +VALIGN="TOP" +>int(10) unsigned</TD +><TD +ALIGN="LEFT" +VALIGN="TOP" +>Primary</TD +><TD +ALIGN="LEFT" +VALIGN="TOP" +> </TD +></TR +><TR +><TD +ALIGN="LEFT" +VALIGN="TOP" +>created_date</TD +><TD +ALIGN="LEFT" +VALIGN="TOP" +>bigint(20) unsigned</TD +><TD +ALIGN="LEFT" +VALIGN="TOP" +> </TD +><TD +ALIGN="LEFT" +VALIGN="TOP" +> </TD +></TR +></TBODY +></TABLE +></DIV +><DIV +CLASS="TABLE" +><A +NAME="AEN847"><P +><B +>Table 3-10. Schema for table bug_history</B ></P ><TABLE BORDER="1" @@ -1626,9 +1673,9 @@ ><DIV CLASS="TABLE" ><A -NAME="AEN822"><P +NAME="AEN887"><P ><B ->Table 3-10. Schema for table comment</B +>Table 3-11. Schema for table comment</B ></P ><TABLE BORDER="1" @@ -1750,9 +1797,9 @@ ><DIV CLASS="TABLE" ><A -NAME="AEN857"><P +NAME="AEN922"><P ><B ->Table 3-11. Schema for table component</B +>Table 3-12. Schema for table component</B ></P ><TABLE BORDER="1" @@ -1967,9 +2014,9 @@ ><DIV CLASS="TABLE" ><A -NAME="AEN918"><P +NAME="AEN983"><P ><B ->Table 3-12. Schema for table configuration</B +>Table 3-13. Schema for table configuration</B ></P ><TABLE BORDER="1" @@ -2075,79 +2122,7 @@ ><DIV CLASS="TABLE" ><A -NAME="AEN949"><P -><B ->Table 3-13. Schema for table db_sequence</B -></P -><TABLE -BORDER="1" -CLASS="CALSTABLE" -><THEAD -><TR -><TH -ALIGN="LEFT" -VALIGN="TOP" ->Field</TH -><TH -ALIGN="LEFT" -VALIGN="TOP" ->Type</TH -><TH -ALIGN="LEFT" -VALIGN="TOP" ->Key</TH -><TH -ALIGN="LEFT" -VALIGN="TOP" ->Description</TH -></TR -></THEAD -><TBODY -><TR -><TD -ALIGN="LEFT" -VALIGN="TOP" ->seq_name</TD -><TD -ALIGN="LEFT" -VALIGN="TOP" ->varchar(127)</TD -><TD -ALIGN="LEFT" -VALIGN="TOP" ->Primary</TD -><TD -ALIGN="LEFT" -VALIGN="TOP" -> </TD -></TR -><TR -><TD -ALIGN="LEFT" -VALIGN="TOP" ->nextid</TD -><TD -ALIGN="LEFT" -VALIGN="TOP" ->int(10) unsigned</TD -><TD -ALIGN="LEFT" -VALIGN="TOP" -> </TD -><TD -ALIGN="LEFT" -VALIGN="TOP" -> </TD -></TR -></TBODY -></TABLE -></DIV -><P ->PHPlib uses this table in generating the incrementing primary key sequences for the other tables.</P -><DIV -CLASS="TABLE" -><A -NAME="AEN970"><P +NAME="AEN1014"><P ><B >Table 3-14. Schema for table group_perm</B ></P @@ -2217,7 +2192,7 @@ ><DIV CLASS="TABLE" ><A -NAME="AEN990"><P +NAME="AEN1034"><P ><B >Table 3-15. Schema for table os</B ></P @@ -2323,7 +2298,7 @@ ><DIV CLASS="TABLE" ><A -NAME="AEN1020"><P +NAME="AEN1064"><P ><B >Table 3-16. Schema for table project</B ></P @@ -2501,7 +2476,7 @@ ><DIV CLASS="TABLE" ><A -NAME="AEN1070"><P +NAME="AEN1114"><P ><B >Table 3-17. Schema for table project_group</B ></P @@ -2607,7 +2582,7 @@ ><DIV CLASS="TABLE" ><A -NAME="AEN1100"><P +NAME="AEN1144"><P ><B >Table 3-18. Schema for table resolution</B ></P @@ -2713,7 +2688,7 @@ ><DIV CLASS="TABLE" ><A -NAME="AEN1130"><P +NAME="AEN1174"><P ><B >Table 3-19. Schema for table saved_query</B ></P @@ -2824,7 +2799,7 @@ ><DIV CLASS="TABLE" ><A -NAME="AEN1162"><P +NAME="AEN1206"><P ><B >Table 3-20. Schema for table severity</B ></P @@ -2951,7 +2926,7 @@ ><DIV CLASS="TABLE" ><A -NAME="AEN1198"><P +NAME="AEN1242"><P ><B >Table 3-21. Schema for table status</B ></P @@ -3057,7 +3032,7 @@ ><DIV CLASS="TABLE" ><A -NAME="AEN1228"><P +NAME="AEN1272"><P ><B >Table 3-22. Schema for table user_group</B ></P @@ -3163,7 +3138,7 @@ ><DIV CLASS="TABLE" ><A -NAME="AEN1258"><P +NAME="AEN1302"><P ><B >Table 3-23. Schema for table user_perm</B ></P @@ -3233,9 +3208,79 @@ ><DIV CLASS="TABLE" ><A -NAME="AEN1278"><P +NAME="AEN1322"><P +><B +>Table 3-24. Schema for table user_pref</B +></P +><TABLE +BORDER="1" +CLASS="CALSTABLE" +><THEAD +><TR +><TH +ALIGN="LEFT" +VALIGN="TOP" +>Field</TH +><TH +ALIGN="LEFT" +VALIGN="TOP" +>Type</TH +><TH +ALIGN="LEFT" +VALIGN="TOP" +>Key</TH +><TH +ALIGN="LEFT" +VALIGN="TOP" +>Description</TH +></TR +></THEAD +><TBODY +><TR +><TD +ALIGN="LEFT" +VALIGN="TOP" +>user_id</TD +><TD +ALIGN="LEFT" +VALIGN="TOP" +>int(10) unsigned</TD +><TD +ALIGN="LEFT" +VALIGN="TOP" +>Primary</TD +><TD +ALIGN="LEFT" +VALIGN="TOP" +> </TD +></TR +><TR +><TD +ALIGN="LEFT" +VALIGN="TOP" +>email_notices</TD +><TD +ALIGN="LEFT" +VALIGN="TOP" +>tinyint(1)</TD +><TD +ALIGN="LEFT" +VALIGN="TOP" +> </TD +><TD +ALIGN="LEFT" +VALIGN="TOP" +>Whether the user wants to receive email notices from phpBugTracker. Values are 1 for yes (default) or 0 for no.</TD +></TR +></TBODY +></TABLE +></DIV +><DIV +CLASS="TABLE" +><A +NAME="AEN1342"><P ><B ->Table 3-24. Schema for table version</B +>Table 3-25. Schema for table version</B ></P ><TABLE BORDER="1" |