Menu
▾
▴
phpbt-dev — Developer's mailing list and cvs commits
You can subscribe to this list here.
| 2001 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
(34) |
Aug
(215) |
Sep
(180) |
Oct
(135) |
Nov
(105) |
Dec
(81) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2002 |
Jan
(76) |
Feb
(22) |
Mar
(154) |
Apr
(149) |
May
(128) |
Jun
(94) |
Jul
(14) |
Aug
(24) |
Sep
(77) |
Oct
(52) |
Nov
(22) |
Dec
(6) |
| 2003 |
Jan
(4) |
Feb
(10) |
Mar
(6) |
Apr
(29) |
May
(10) |
Jun
(37) |
Jul
(39) |
Aug
(13) |
Sep
(23) |
Oct
(3) |
Nov
(7) |
Dec
(2) |
| 2004 |
Jan
|
Feb
(10) |
Mar
(4) |
Apr
|
May
(35) |
Jun
(4) |
Jul
(17) |
Aug
(6) |
Sep
(14) |
Oct
(18) |
Nov
(2) |
Dec
(14) |
| 2005 |
Jan
(9) |
Feb
(30) |
Mar
(6) |
Apr
|
May
(38) |
Jun
(23) |
Jul
(21) |
Aug
(76) |
Sep
(50) |
Oct
(51) |
Nov
(13) |
Dec
|
|
From: Benjamin C. <bc...@us...> - 2001-10-15 13:51:46
|
Update of /cvsroot/phpbt/phpbt In directory usw-pr-cvs1:/tmp/cvs-serv22471 Modified Files: logout.php Log Message: Fixed a bug with the change to THEME Index: logout.php =================================================================== RCS file: /cvsroot/phpbt/phpbt/logout.php,v retrieving revision 1.5 retrieving revision 1.6 diff -u -r1.5 -r1.6 --- logout.php 2001/08/09 12:54:47 1.5 +++ logout.php 2001/10/15 13:51:43 1.6 @@ -25,7 +25,7 @@ $auth->unauth(); -include 'templates/'.THEME.'logout.html'; +include 'templates/'.THEME.'/logout.html'; page_close(); |
|
From: Benjamin C. <bc...@us...> - 2001-10-15 13:43:04
|
Update of /cvsroot/phpbt/phpbt/docs/sgml In directory usw-pr-cvs1:/tmp/cvs-serv19826/sgml Modified Files: configuration.sgml Log Message: Changed configuration info Index: configuration.sgml =================================================================== RCS file: /cvsroot/phpbt/phpbt/docs/sgml/configuration.sgml,v retrieving revision 1.2 retrieving revision 1.3 diff -u -r1.2 -r1.3 --- configuration.sgml 2001/10/01 01:12:38 1.2 +++ configuration.sgml 2001/10/15 13:43:01 1.3 @@ -1,138 +1,136 @@ <!-- -*- sgml -*- --> <sect1 id="configuration"> - <title>Configuration Options</title> +<title>Configuration Options</title> - <abstract> - <para>The options listed in this section can be configured by the <filename>configure</filename> script and can be found in <filename>config.php</filename>.</para> - </abstract> +<abstract> +<para>Most of the options listed here can be configured via the Configuration page of the admin tools. The <varname>DB_</varname> and <varname>PHPLIB_PATH</varname> options can be found in <filename>config.php</filename>.</para> +</abstract> - <variablelist> - <varlistentry> - <term>INSTALLPATH</term> - <listitem> - <para>Location on disk of the &phpbt; installation.</para> - </listitem> - </varlistentry> - <varlistentry> - <term>INSTALLURL</term> - <listitem> - <para>URL that is the home of the installation.</para> - </listitem> - </varlistentry> - <varlistentry> - <term>CVS_WEB</term> - <listitem> - <para>Location of your cvs web interface (see <function>format_comments()</function> in <filename>bug.php</filename>). This is for links to files in CVS generated from the comments attached to bugs.</para> - </listitem> - </varlistentry> - <varlistentry> - <term>DB_TYPE</term> - <listitem> - <para>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 &phpbt;</para> - </listitem> - </varlistentry> - <varlistentry> - <term>DB_HOST</term> - <listitem> - <para>The hostname of the database server.</para> - </listitem> - </varlistentry> - <varlistentry> - <term>DB_DATABASE</term> - <listitem> - <para>The name of the database to be used.</para> - </listitem> - </varlistentry> - <varlistentry> - <term>DB_USER</term> - <listitem> - <para>Username to use for connecting to the database.</para> - </listitem> - </varlistentry> - <varlistentry> - <term>DB_PASSWORD</term> - <listitem> - <para>The password to use for connecting to the database.</para> - </listitem> - </varlistentry> - <varlistentry> - <term>ADMINEMAIL</term> - <listitem> - <para>The email address that will be used for all correspondence to and from the bug tracker.</para> - </listitem> - </varlistentry> - <varlistentry> - <term>ENCRYPTPASS</term> - <listitem> - <para>When true, passwords will be stored as an <function>md5()</function> hash in the database. When false, they will be stored as plaintext.</para> - <para>If this is set to true, a new password will be generated for users if they request their password to be emailed to them, as the encryption is not reversible.</para> - </listitem> - </varlistentry> - <varlistentry> - <term>THEME</term> - <listitem> - <para>The directory below the <filename>templates</filename> directory (both in the top directory and the <filename>admin</filename> directory) where the <acronym>HTML</acronym> template files are located. This makes it easy to wrap the bug tracker in a completely different look.</para> - </listitem> - </varlistentry> - <varlistentry> - <term>USE_JPGRAPH</term> - <listitem> - <para>Whether to use the <ulink url="http://www.aditus.nu/jpgraph/">JpGraph</ulink> graphing class for some reports.</para> - </listitem> - </varlistentry> - <varlistentry> - <term>MASK_EMAIL</term> - <listitem> - <para>If true, then email addresses will be shown as <computeroutput>example at example dot com</computeroutput>. Otherwise, email addresses will be shown as <computeroutput>ex...@ex...</computeroutput>.</para> - </listitem> - </varlistentry> - <varlistentry> - <term>HIDE_EMAIL</term> - <listitem> - <para>If true, email addresses will be shown as <computeroutput>******</computeroutput> to users who are not logged in (to help avoid spam bots on public bug trackers). If false, email addresses will be shown according the setting of <varname>MASK_EMAIL</varname>, above.</para> - </listitem> - </varlistentry> - <varlistentry> - <term>USE_SEVERITY_COLOR</term> - <listitem> - <para>Whether to color the rows of the bug list according to the severity of the bugs. The severity colors can be set via the admin interface. If this is false, the bugs will be listed with alternating background colors of white and gray.</para> - </listitem> - </varlistentry> - <varlistentry> - <term>EMAIL_IS_LOGIN</term> - <listitem> - <para>If true, then users login with their email address, and the email address is shown for fields such as Assigned To and Reported By. If false, the login is not tied to the user's email address.</para> - </listitem> - </varlistentry> - <varlistentry> - <term>ATTACHMENT_PATH</term> - <listitem> - <para>The subdirectory in which to store bug attachments. This directory needs to writeable by the web server.</para> - </listitem> - </varlistentry> - <varlistentry> - <term>ATTACHMENT_MAX_SIZE</term> - <listitem> - <para>Maximum size (in bytes) of an attachment. This will not override the settings in <filename>php.ini</filename> if <filename>php.ini</filename> has a lower limit.</para> - </listitem> - </varlistentry> - <varlistentry> - <term>DATEFORMAT</term> - <listitem> - <para>The format for displaying the date, according to PHP's <ulink url="http://www.php.net/manual/function.date.php"><function>date()</function></ulink> function.</para> - </listitem> - </varlistentry> - <varlistentry> - <term>TIMEFORMAT</term> - <listitem> - <para>The format for displaying the date, according to PHP's <ulink url="http://www.php.net/manual/function.date.php"><function>date()</function></ulink> function.</para> - </listitem> - </varlistentry> - </variablelist> +<variablelist> +<varlistentry> +<term>INSTALL_PATH</term> +<listitem> +<para>Location on disk of the &phpbt; installation. This variable is obtained by getting the working directory of the scripts.</para> +</listitem> +</varlistentry> +<varlistentry> +<term>INSTALL_URL</term> +<listitem> +<para>URL that is the home of the installation.</para> +</listitem> +</varlistentry> +<varlistentry> +<term>CVS_WEB</term> +<listitem> +<para>Location of your cvs web interface (see <function>format_comments()</function> in <filename>bug.php</filename>). This is for links to files in CVS generated from the comments attached to bugs.</para> +</listitem> +</varlistentry> +<varlistentry> +<term>DB_TYPE</term> +<listitem> +<para>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 &phpbt;</para> +</listitem> +</varlistentry> +<varlistentry> +<term>DB_HOST</term> +<listitem> +<para>The hostname of the database server.</para> +</listitem> +</varlistentry> +<varlistentry> +<term>DB_DATABASE</term> +<listitem> +<para>The name of the database to be used.</para> +</listitem> +</varlistentry> +<varlistentry> +<term>DB_USER</term> +<listitem> +<para>Username to use for connecting to the database.</para> +</listitem> +</varlistentry> +<varlistentry> +<term>DB_PASSWORD</term> +<listitem> +<para>The password to use for connecting to the database.</para> +</listitem> +</varlistentry> +<varlistentry> +<term>ADMIN_EMAIL</term> +<listitem> +<para>The email address that will be used for all correspondence to and from the bug tracker.</para> +</listitem> +</varlistentry> +<varlistentry> +<term>ENCRYPT_PASS</term> +<listitem> +<para>When true, passwords will be stored as an <function>md5()</function> hash in the database. When false, they will be stored as plaintext.</para> +<para>If this is set to true, a new password will be generated for users if they request their password to be emailed to them, as the encryption is not reversible.</para> +</listitem> +</varlistentry> +<varlistentry> +<term>THEME</term> +<listitem> +<para>The directory below the <filename>templates</filename> directory (both in the top directory and the <filename>admin</filename> directory) where the <acronym>HTML</acronym> template files are located. This makes it easy to wrap the bug tracker in a completely different look.</para> +</listitem> +</varlistentry> +<varlistentry> +<term>USE_JPGRAPH</term> +<listitem> +<para>Whether to use the <ulink url="http://www.aditus.nu/jpgraph/">JpGraph</ulink> graphing class for some reports.</para> +</listitem> +</varlistentry> +<varlistentry> +<term>MASK_EMAIL</term> +<listitem> +<para>If true, then email addresses will be shown as <computeroutput>example at example dot com</computeroutput>. Otherwise, email addresses will be shown as <computeroutput>ex...@ex...</computeroutput>.</para> +</listitem> +</varlistentry> +<varlistentry> +<term>HIDE_EMAIL</term> +<listitem> +<para>If true, email addresses will be shown as <computeroutput>******</computeroutput> to users who are not logged in (to help avoid spam bots on public bug trackers). If false, email addresses will be shown according the setting of <varname>MASK_EMAIL</varname>, above.</para> +</listitem> +</varlistentry> +<varlistentry> +<term>USE_SEVERITY_COLOR</term> +<listitem> +<para>Whether to color the rows of the bug list according to the severity of the bugs. The severity colors can be set via the admin interface. If this is false, the bugs will be listed with alternating background colors of white and gray.</para> +</listitem> +</varlistentry> +<varlistentry> +<term>EMAIL_IS_LOGIN</term> +<listitem> +<para>If true, then users login with their email address, and the email address is shown for fields such as Assigned To and Reported By. If false, the login is not tied to the user's email address.</para> +</listitem> +</varlistentry> +<varlistentry> +<term>ATTACHMENT_PATH</term> +<listitem> +<para>The subdirectory in which to store bug attachments. This directory needs to writeable by the web server.</para> +</listitem> +</varlistentry> +<varlistentry> +<term>ATTACHMENT_MAX_SIZE</term> +<listitem> +<para>Maximum size (in bytes) of an attachment. This will not override the settings in <filename>php.ini</filename> if <filename>php.ini</filename> has a lower limit.</para> +</listitem> +</varlistentry> +<varlistentry> +<term>DATE_FORMAT</term> +<listitem> +<para>The format for displaying the date, according to PHP's <ulink url="http://www.php.net/manual/function.date.php"><function>date()</function></ulink> function.</para> +</listitem> +</varlistentry> +<varlistentry> +<term>TIME_FORMAT</term> +<listitem> +<para>The format for displaying the date, according to PHP's <ulink url="http://www.php.net/manual/function.date.php"><function>date()</function></ulink> function.</para> +</listitem> +</varlistentry> +</variablelist> </sect1> <!-- Local Variables: --> -<!-- sgml-indent-step: 2 --> -<!-- sgml-indent-data: 2 --> <!-- sgml-parent-document: "phpbt.sgml" --> <!-- End: --> |
|
From: Benjamin C. <bc...@us...> - 2001-10-15 13:43:04
|
Update of /cvsroot/phpbt/phpbt/docs/html In directory usw-pr-cvs1:/tmp/cvs-serv19826/html Modified Files: configuration.html devguide.html devstandards.html index.html Log Message: Changed configuration info Index: configuration.html =================================================================== RCS file: /cvsroot/phpbt/phpbt/docs/html/configuration.html,v retrieving revision 1.6 retrieving revision 1.7 diff -u -r1.6 -r1.7 --- configuration.html 2001/10/14 03:25:23 1.6 +++ configuration.html 2001/10/15 13:43:01 1.7 @@ -87,10 +87,13 @@ NAME="AEN111" ></A ><P ->The options listed in this section can be configured by the <TT -CLASS="FILENAME" ->configure</TT -> script and can be found in <TT +>Most of the options listed here can be configured via the Configuration page of the admin tools. The <TT +CLASS="VARNAME" +>DB_</TT +> and <TT +CLASS="VARNAME" +>PHPLIB_PATH</TT +> options can be found in <TT CLASS="FILENAME" >config.php</TT >.</P @@ -100,13 +103,13 @@ CLASS="VARIABLELIST" ><DL ><DT ->INSTALLPATH</DT +>INSTALL_PATH</DT ><DD ><P ->Location on disk of the phpBugTracker installation.</P +>Location on disk of the phpBugTracker installation. This variable is obtained by getting the working directory of the scripts.</P ></DD ><DT ->INSTALLURL</DT +>INSTALL_URL</DT ><DD ><P >URL that is the home of the installation.</P @@ -154,13 +157,13 @@ >The password to use for connecting to the database.</P ></DD ><DT ->ADMINEMAIL</DT +>ADMIN_EMAIL</DT ><DD ><P >The email address that will be used for all correspondence to and from the bug tracker.</P ></DD ><DT ->ENCRYPTPASS</DT +>ENCRYPT_PASS</DT ><DD ><P >When true, passwords will be stored as an <TT @@ -250,7 +253,7 @@ > has a lower limit.</P ></DD ><DT ->DATEFORMAT</DT +>DATE_FORMAT</DT ><DD ><P >The format for displaying the date, according to PHP's <A @@ -263,7 +266,7 @@ > function.</P ></DD ><DT ->TIMEFORMAT</DT +>TIME_FORMAT</DT ><DD ><P >The format for displaying the date, according to PHP's <A Index: devguide.html =================================================================== RCS file: /cvsroot/phpbt/phpbt/docs/html/devguide.html,v retrieving revision 1.11 retrieving revision 1.12 diff -u -r1.11 -r1.12 --- devguide.html 2001/10/14 03:25:23 1.11 +++ devguide.html 2001/10/15 13:43:01 1.12 @@ -127,7 +127,7 @@ ><DIV CLASS="ABSTRACT" ><A -NAME="AEN216" +NAME="AEN217" ></A ><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 @@ -150,7 +150,7 @@ ><DIV CLASS="ABSTRACT" ><A -NAME="AEN221" +NAME="AEN222" ></A ><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 @@ -175,7 +175,7 @@ ><H3 CLASS="SECT3" ><A -NAME="AEN227" +NAME="AEN228" >3.1.1.1. Database Abstraction</A ></H3 ><P @@ -206,7 +206,7 @@ ><DIV CLASS="EXAMPLE" ><A -NAME="AEN238" +NAME="AEN239" ></A ><P ><B @@ -244,7 +244,7 @@ ><H3 CLASS="SECT3" ><A -NAME="AEN241" +NAME="AEN242" >3.1.1.2. Templates</A ></H3 ><P @@ -252,7 +252,7 @@ ><DIV CLASS="EXAMPLE" ><A -NAME="AEN244" +NAME="AEN245" ></A ><P ><B @@ -289,7 +289,7 @@ ><H3 CLASS="SECT3" ><A -NAME="AEN247" +NAME="AEN248" >3.1.1.3. Session and Authentication</A ></H3 ><P @@ -361,7 +361,7 @@ ><DIV CLASS="EXAMPLE" ><A -NAME="AEN272" +NAME="AEN273" ></A ><P ><B Index: devstandards.html =================================================================== RCS file: /cvsroot/phpbt/phpbt/docs/html/devstandards.html,v retrieving revision 1.12 retrieving revision 1.13 diff -u -r1.12 -r1.13 --- devstandards.html 2001/10/14 03:25:23 1.12 +++ devstandards.html 2001/10/15 13:43:01 1.13 @@ -77,7 +77,7 @@ ><DIV CLASS="ABSTRACT" ><A -NAME="AEN282" +NAME="AEN283" ></A ><P > This section details the coding and process standards to be Index: index.html =================================================================== RCS file: /cvsroot/phpbt/phpbt/docs/html/index.html,v retrieving revision 1.9 retrieving revision 1.10 diff -u -r1.9 -r1.10 --- index.html 2001/10/14 03:25:23 1.9 +++ index.html 2001/10/15 13:43:01 1.10 @@ -114,17 +114,17 @@ ></DT ><DT >3-1. <A -HREF="devguide.html#AEN238" +HREF="devguide.html#AEN239" >Using the database class</A ></DT ><DT >3-2. <A -HREF="devguide.html#AEN244" +HREF="devguide.html#AEN245" >Using the template class</A ></DT ><DT >3-3. <A -HREF="devguide.html#AEN272" +HREF="devguide.html#AEN273" >Permission and Group Checking</A ></DT ></DL |
|
From: Benjamin C. <bc...@us...> - 2001-10-15 13:41:31
|
Update of /cvsroot/phpbt/phpbt/docs/html/images/shots/user In directory usw-pr-cvs1:/tmp/cvs-serv19284/html/images/shots/user Modified Files: buglist.jpg buglist.png bugdetail.jpg bugdetail.png Log Message: Smaller shots Index: buglist.jpg =================================================================== RCS file: /cvsroot/phpbt/phpbt/docs/html/images/shots/user/buglist.jpg,v retrieving revision 1.1 retrieving revision 1.2 diff -u -r1.1 -r1.2 Binary files /tmp/cvswMmnwR and /tmp/cvsWImn5x differ Index: buglist.png =================================================================== RCS file: /cvsroot/phpbt/phpbt/docs/html/images/shots/user/buglist.png,v retrieving revision 1.1 retrieving revision 1.2 diff -u -r1.1 -r1.2 Binary files /tmp/cvsFhIdfS and /tmp/cvsmjOt8z differ Index: bugdetail.jpg =================================================================== RCS file: /cvsroot/phpbt/phpbt/docs/html/images/shots/user/bugdetail.jpg,v retrieving revision 1.1 retrieving revision 1.2 diff -u -r1.1 -r1.2 Binary files /tmp/cvsSDXAzT and /tmp/cvsWYcJtC differ Index: bugdetail.png =================================================================== RCS file: /cvsroot/phpbt/phpbt/docs/html/images/shots/user/bugdetail.png,v retrieving revision 1.1 retrieving revision 1.2 diff -u -r1.1 -r1.2 Binary files /tmp/cvs69H8tU and /tmp/cvsaCu4LE differ |
|
From: Benjamin C. <bc...@us...> - 2001-10-14 03:25:27
|
Update of /cvsroot/phpbt/phpbt/docs/sgml In directory usw-pr-cvs1:/tmp/cvs-serv31660/sgml Modified Files: installation.sgml Log Message: Updated the installation instructions Index: installation.sgml =================================================================== RCS file: /cvsroot/phpbt/phpbt/docs/sgml/installation.sgml,v retrieving revision 1.1 retrieving revision 1.2 diff -u -r1.1 -r1.2 --- installation.sgml 2001/09/29 04:02:38 1.1 +++ installation.sgml 2001/10/14 03:25:23 1.2 @@ -1,63 +1,47 @@ <!-- -*- sgml -*- --> <sect1 id="installation"> - <title>Installation Instructions</title> +<title>Installation Instructions</title> - <orderedlist> - <listitem> - <para>Install PHPlib (<ulink url="http://sourceforge.net/projects/phplib/">http://sourceforge.net/projects/phplib</ulink>) if it's not already installed. Note that with recent versions of PHP, PHPlib needs to be patched. Please do the following with the patch file, <filename>page.inc.patch</filename> in the distribution directory:</para> - <screen>cat page.inc.patch | patch -p0 -b /path/to/phplib/page.inc</screen> - <para>Make sure you replace <filename>/path/to/phplib</filename> with the actual path to the installation of PHPlib. On windows systems you can edit <filename>page.inc</filename> and change line 67 from <computeroutput>if (isset($user)) {</computeroutput> to <computeroutput>if (isset($user) && $user) {</computeroutput>.</para> - </listitem> - - <listitem> - <para>Copy the directory tree from the tarball to a location suitable for serving web pages.</para> - </listitem> - - <listitem> - <para>Run the <filename>configure</filename> script. This will change <filename>config.php</filename> (creating a backup) and will run <filename>configure_db</filename>, which will create <filename>createdb.sql</filename>. </para> - - <para><emphasis>-- or --</emphasis></para> - - <para>Configure manually: - <orderedlist> - <listitem> - <para>Edit the constants in <filename>config.php</filename>.</para> - </listitem> - <listitem> - <para>Run <filename>configure_db</filename> to get <filename>createdb.sql</filename>.</para> - </listitem> - </orderedlist> - </para> - </listitem> - - <listitem> - <para>If you want to use JpGraph (<ulink url="http://www.aditus.nu/jpgraph/">http://www.aditus.nu/jpgraph</ulink>) to display the bug summary info, you will also need to edit <filename>jpgraph.php</filename> from the JpGraph disribution.</para> - </listitem> - - <listitem> - <para>Edit <filename>createdb.sql</filename>, changing the admin info in the database insert. You can search on the text <computeroutput>ad...@ex...</computeroutput> (around line 240).</para> - </listitem> - - <listitem> - <para>Use <filename>createdb.sql</filename> to create your database. With MySQL it can be done as follows: - </para> - <screen>mysql -h <db host> -u <username> -p<yourpassword> < createdb.sql</screen> - </listitem> - - <listitem> - <para>Browse on over to the installation, choose Admin tools, login with the info you put in the database creation script, and create your first project.</para> - </listitem> - - <listitem> - <para>Start reporting bugs.</para> - </listitem> +<procedure> +<step> +<para>Install PHPlib (<ulink url="http://sourceforge.net/projects/phplib/">http://sourceforge.net/projects/phplib</ulink>) if it's not already installed. Note that with recent versions of PHP, PHPlib needs to be patched. Please do the following with the patch file, <filename>page.inc.patch</filename> in the distribution directory:</para> +<screen><command>cat</command> <filename>page.inc.patch</filename> | <command>patch</command> <option>-p0</option> <option>-b</option> <filename><replaceable>/path/to/phplib/page.inc</replaceable></filename></screen> +<para>Make sure you replace <filename>/path/to/phplib</filename> with the actual path to the installation of PHPlib. On windows systems you can edit <filename>page.inc</filename> and change line 67 from <computeroutput>if (isset($user)) {</computeroutput> to <computeroutput>if (isset($user) && $user) {</computeroutput>.</para> +<note> +<para>Optional: Install JpGraph (<ulink url="http://www.aditus.nu/jpgraph/">http://www.aditus.nu/jpgraph</ulink>) if you wish to use it for the summary bug display on the home page.</para> +</note> +</step> + +<step> +<para>Copy the directory tree from the tarball to a location suitable for serving web pages.</para> +</step> + +<step> +<para>Run <command>configure_db</command>, which will create <filename>createdb.sql</filename>. Use the <option>-h</option> option when running <command>configure_db</command> to see the options.</para> +</step> + +<step> +<para>Edit <filename>createdb.sql</filename>, changing the admin info in the database insert. You can search on the text <computeroutput>ad...@ex...</computeroutput> (around line 240). You can also edit the options being inserted into the configuration table or edit them later from the web interface.</para> +</step> + +<step> +<para>Use <filename>createdb.sql</filename> to create your database. With MySQL it can be done as follows: +</para> +<screen><command>mysql</command> <option>-h</option> <replaceable>db host</replaceable> <option>-u</option> <replaceable>username</replaceable> <option>-p</option><replaceable>yourpassword</replaceable> < <filename>createdb.sql</filename></screen> +</step> + +<step> +<para>Browse on over to the installation, choose Admin tools, login with the info you put in the database creation script, and create your first project.</para> +</step> + +<step> +<para>Start reporting bugs.</para> +</step> - </orderedlist> +</procedure> </sect1> <!-- Local Variables: --> -<!-- sgml-indent-step: 2 --> -<!-- sgml-indent-data: 2 --> <!-- sgml-parent-document: "phpbt.sgml" --> <!-- End: --> |
|
From: Benjamin C. <bc...@us...> - 2001-10-14 03:25:26
|
Update of /cvsroot/phpbt/phpbt/docs/html
In directory usw-pr-cvs1:/tmp/cvs-serv31660/html
Modified Files:
adminguide.html configuration.html devguide.html
devstandards.html index.html
Log Message:
Updated the installation instructions
Index: adminguide.html
===================================================================
RCS file: /cvsroot/phpbt/phpbt/docs/html/adminguide.html,v
retrieving revision 1.6
retrieving revision 1.7
diff -u -r1.6 -r1.7
--- adminguide.html 2001/10/08 01:59:15 1.6
+++ adminguide.html 2001/10/14 03:25:23 1.7
@@ -113,6 +113,8 @@
NAME="INSTALLATION"
>2.1. Installation Instructions</A
></H1
+><DIV
+CLASS="PROCEDURE"
><OL
TYPE="1"
><LI
@@ -128,12 +130,35 @@
><TABLE
BORDER="0"
BGCOLOR="#EEEEEE"
-WIDTH="90%"
+WIDTH="100%"
><TR
><TD
><PRE
CLASS="SCREEN"
->cat page.inc.patch | patch -p0 -b /path/to/phplib/page.inc</PRE
+><B
+CLASS="COMMAND"
+>cat</B
+> <TT
+CLASS="FILENAME"
+>page.inc.patch</TT
+> | <B
+CLASS="COMMAND"
+>patch</B
+> <TT
+CLASS="OPTION"
+>-p0</TT
+> <TT
+CLASS="OPTION"
+>-b</TT
+> <TT
+CLASS="FILENAME"
+><TT
+CLASS="REPLACEABLE"
+><I
+>/path/to/phplib/page.inc</I
+></TT
+></TT
+></PRE
></TD
></TR
></TABLE
@@ -151,6 +176,34 @@
CLASS="COMPUTEROUTPUT"
>if (isset($user) && $user) {</TT
>.</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
><LI
><P
@@ -158,89 +211,75 @@
></LI
><LI
><P
->Run the <TT
-CLASS="FILENAME"
->configure</TT
-> script. This will change <TT
-CLASS="FILENAME"
->config.php</TT
-> (creating a backup) and will run <TT
-CLASS="FILENAME"
->configure_db</TT
+>Run <B
+CLASS="COMMAND"
+>configure_db</B
>, which will create <TT
CLASS="FILENAME"
>createdb.sql</TT
->. </P
-><P
-><SPAN
-CLASS="emphasis"
-><I
-CLASS="EMPHASIS"
->-- or --</I
-></SPAN
-></P
-><P
->Configure manually:
- <OL
-TYPE="a"
-><LI
-><P
->Edit the constants in <TT
-CLASS="FILENAME"
->config.php</TT
->.</P
-></LI
-><LI
-><P
->Run <TT
-CLASS="FILENAME"
->configure_db</TT
-> to get <TT
-CLASS="FILENAME"
->createdb.sql</TT
->.</P
+>. Use the <TT
+CLASS="OPTION"
+>-h</TT
+> option when running <B
+CLASS="COMMAND"
+>configure_db</B
+> to see the options.</P
></LI
-></OL
->
- </P
-></LI
><LI
><P
->If you want to use JpGraph (<A
-HREF="http://www.aditus.nu/jpgraph/"
-TARGET="_top"
->http://www.aditus.nu/jpgraph</A
->) to display the bug summary info, you will also need to edit <TT
-CLASS="FILENAME"
->jpgraph.php</TT
-> from the JpGraph disribution.</P
-></LI
-><LI
-><P
>Edit <TT
CLASS="FILENAME"
>createdb.sql</TT
>, changing the admin info in the database insert. You can search on the text <TT
CLASS="COMPUTEROUTPUT"
>ad...@ex...</TT
-> (around line 240).</P
+> (around line 240). You can also edit the options being inserted into the configuration table or edit them later from the web interface.</P
></LI
><LI
><P
>Use <TT
CLASS="FILENAME"
>createdb.sql</TT
-> to create your database. With MySQL it can be done as follows:
- </P
+> to create your database. With MySQL it can be done as follows:</P
><TABLE
BORDER="0"
BGCOLOR="#EEEEEE"
-WIDTH="90%"
+WIDTH="100%"
><TR
><TD
><PRE
CLASS="SCREEN"
->mysql -h <db host> -u <username> -p<yourpassword> < createdb.sql</PRE
+><B
+CLASS="COMMAND"
+>mysql</B
+> <TT
+CLASS="OPTION"
+>-h</TT
+> <TT
+CLASS="REPLACEABLE"
+><I
+>db host</I
+></TT
+> <TT
+CLASS="OPTION"
+>-u</TT
+> <TT
+CLASS="REPLACEABLE"
+><I
+>username</I
+></TT
+> <TT
+CLASS="OPTION"
+>-p</TT
+><TT
+CLASS="REPLACEABLE"
+><I
+>yourpassword</I
+></TT
+> < <TT
+CLASS="FILENAME"
+>createdb.sql</TT
+></PRE
></TD
></TR
></TABLE
@@ -254,6 +293,7 @@
>Start reporting bugs.</P
></LI
></OL
+></DIV
></DIV
></DIV
><DIV
Index: configuration.html
===================================================================
RCS file: /cvsroot/phpbt/phpbt/docs/html/configuration.html,v
retrieving revision 1.5
retrieving revision 1.6
diff -u -r1.5 -r1.6
--- configuration.html 2001/10/08 01:59:15 1.5
+++ configuration.html 2001/10/14 03:25:23 1.6
@@ -84,7 +84,7 @@
><DIV
CLASS="ABSTRACT"
><A
-NAME="AEN108"
+NAME="AEN111"
></A
><P
>The options listed in this section can be configured by the <TT
Index: devguide.html
===================================================================
RCS file: /cvsroot/phpbt/phpbt/docs/html/devguide.html,v
retrieving revision 1.10
retrieving revision 1.11
diff -u -r1.10 -r1.11
--- devguide.html 2001/10/09 04:03:35 1.10
+++ devguide.html 2001/10/14 03:25:23 1.11
@@ -127,7 +127,7 @@
><DIV
CLASS="ABSTRACT"
><A
-NAME="AEN213"
+NAME="AEN216"
></A
><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
@@ -150,7 +150,7 @@
><DIV
CLASS="ABSTRACT"
><A
-NAME="AEN218"
+NAME="AEN221"
></A
><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
@@ -175,7 +175,7 @@
><H3
CLASS="SECT3"
><A
-NAME="AEN224"
+NAME="AEN227"
>3.1.1.1. Database Abstraction</A
></H3
><P
@@ -206,7 +206,7 @@
><DIV
CLASS="EXAMPLE"
><A
-NAME="AEN235"
+NAME="AEN238"
></A
><P
><B
@@ -244,7 +244,7 @@
><H3
CLASS="SECT3"
><A
-NAME="AEN238"
+NAME="AEN241"
>3.1.1.2. Templates</A
></H3
><P
@@ -252,7 +252,7 @@
><DIV
CLASS="EXAMPLE"
><A
-NAME="AEN241"
+NAME="AEN244"
></A
><P
><B
@@ -289,7 +289,7 @@
><H3
CLASS="SECT3"
><A
-NAME="AEN244"
+NAME="AEN247"
>3.1.1.3. Session and Authentication</A
></H3
><P
@@ -361,7 +361,7 @@
><DIV
CLASS="EXAMPLE"
><A
-NAME="AEN269"
+NAME="AEN272"
></A
><P
><B
Index: devstandards.html
===================================================================
RCS file: /cvsroot/phpbt/phpbt/docs/html/devstandards.html,v
retrieving revision 1.11
retrieving revision 1.12
diff -u -r1.11 -r1.12
--- devstandards.html 2001/10/09 04:03:35 1.11
+++ devstandards.html 2001/10/14 03:25:23 1.12
@@ -77,7 +77,7 @@
><DIV
CLASS="ABSTRACT"
><A
-NAME="AEN279"
+NAME="AEN282"
></A
><P
> This section details the coding and process standards to be
Index: index.html
===================================================================
RCS file: /cvsroot/phpbt/phpbt/docs/html/index.html,v
retrieving revision 1.8
retrieving revision 1.9
diff -u -r1.8 -r1.9
--- index.html 2001/10/09 04:03:35 1.8
+++ index.html 2001/10/14 03:25:23 1.9
@@ -114,17 +114,17 @@
></DT
><DT
>3-1. <A
-HREF="devguide.html#AEN235"
+HREF="devguide.html#AEN238"
>Using the database class</A
></DT
><DT
>3-2. <A
-HREF="devguide.html#AEN241"
+HREF="devguide.html#AEN244"
>Using the template class</A
></DT
><DT
>3-3. <A
-HREF="devguide.html#AEN269"
+HREF="devguide.html#AEN272"
>Permission and Group Checking</A
></DT
></DL
|
|
From: Benjamin C. <bc...@us...> - 2001-10-14 03:25:14
|
Update of /cvsroot/phpbt/phpbt
In directory usw-pr-cvs1:/tmp/cvs-serv31637
Modified Files:
INSTALL
Log Message:
Updated the installation instructions
Index: INSTALL
===================================================================
RCS file: /cvsroot/phpbt/phpbt/INSTALL,v
retrieving revision 1.9
retrieving revision 1.10
diff -u -r1.9 -r1.10
--- INSTALL 2001/09/28 13:25:40 1.9
+++ INSTALL 2001/10/14 03:25:11 1.10
@@ -10,29 +10,24 @@
from 'if (isset($user)) {' to 'if (isset($user) && $user) {' (without the
quotes).
+ Optional: Install JpGraph (http://www.aditus.nu/jpgraph/) if you wish to
+ use it.
+
2. Copy the directory tree from the tarball to a location suitable for serving
web pages.
-
-3. Run the configure script. This will change config.php (creating a backup)
- and run configure_db which creates createdb.sql.
-
- -- or --
-
-3. Configure manually.
- a. Edit the constants in config.php.
- b. Edit the variables in configure_db and run it to get createdb.sql.
-4. If you want to use jpgraph (http://www.aditus.nu/jpgraph/)
- to display the bug summary info, you will also need to edit
- jpgraph.php from the jpgraph disribution.
+3. Run configure_db, which creates createdb.sql. Use the -h option when running
+ configure_db to see the options. You can also edit the options being
+ inserted into the configuration table or edit them later from the web
+ interface.
-5. Edit createdb.sql, changing the admin info in the database insert. You can
+4. Edit createdb.sql, changing the admin info in the database insert. You can
search on the text ad...@ex... (around line 240).
-6. Use createdb.sql to create your database. With MySQL it can be done like
+5. Use createdb.sql to create your database. With MySQL it can be done like
mysql -h <db host> -u <username> -p<yourpassword> < createdb.sql
-7. Browse on over to the installation, choose Admin tools, login with the info
+6. Browse on over to the installation, choose Admin tools, login with the info
you put in the database creation script, and create your first project.
-8. Start reporting bugs
+7. Start reporting bugs
|
|
From: Benjamin C. <bc...@us...> - 2001-10-13 23:15:55
|
Update of /cvsroot/phpbt/phpbt
In directory usw-pr-cvs1:/tmp/cvs-serv13358
Modified Files:
include.php
Log Message:
Added an admin interface for the configuration options
Index: include.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/include.php,v
retrieving revision 1.62
retrieving revision 1.63
diff -u -r1.62 -r1.63
--- include.php 2001/10/12 13:43:29 1.62
+++ include.php 2001/10/13 23:15:52 1.63
@@ -373,6 +373,34 @@
}
$text .= '</option>';
break;
+ case 'LANGUAGE' :
+ $dir = opendir(INSTALL_PATH.'/'.INCLUDE_PATH.'languages');
+ while (false !== ($file = readdir($dir))) {
+ if ($file != '.' && $file != '..' && $file != 'CVS') {
+ $file = str_replace('.php', '', $file);
+ if ($file == $value) {
+ $sel = ' selected';
+ } else {
+ $sel = '';
+ }
+ $text .= "<option value=\"$file\"$sel>$file</option>";
+ }
+ }
+ break;
+ case 'THEME' :
+ $dir = opendir(INSTALL_PATH.'/'.INCLUDE_PATH.'templates');
+ while (false !== ($file = readdir($dir))) {
+ if ($file != '.' && $file != '..' && $file != 'CVS') {
+ $file = str_replace('.php', '', $file);
+ if ($file == $value) {
+ $sel = ' selected';
+ } else {
+ $sel = '';
+ }
+ $text .= "<option value=\"$file\"$sel>$file</option>";
+ }
+ }
+ break;
default :
$deadarray = $select[$box];
while(list($val,$item) = each($deadarray)) {
|
|
From: Benjamin C. <bc...@us...> - 2001-10-13 23:15:55
|
Update of /cvsroot/phpbt/phpbt/admin
In directory usw-pr-cvs1:/tmp/cvs-serv13358/admin
Added Files:
configure.php
Log Message:
Added an admin interface for the configuration options
--- NEW FILE: configure.php ---
<?php
// configure.php - Interface for configuration options
// ------------------------------------------------------------------------
// Copyright (c) 2001 The phpBugTracker Group
// ------------------------------------------------------------------------
// This file is part of phpBugTracker
//
// phpBugTracker is free software; you can redistribute it and/or modify
// it under the terms of the GNU General Public License as published by
// the Free Software Foundation; either version 2 of the License, or
// (at your option) any later version.
//
// phpBugTracker is distributed in the hope that it will be useful,
// but WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
// GNU General Public License for more details.
//
// You should have received a copy of the GNU General Public License
// along with phpBugTracker; if not, write to the Free Software Foundation,
// Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
// ------------------------------------------------------------------------
// $Id: configure.php,v 1.1 2001/10/13 23:15:52 bcurtis Exp $
define('INCLUDE_PATH', '../');
include INCLUDE_PATH.'include.php';
function save_options() {
global $q, $HTTP_POST_VARS;
foreach ($HTTP_POST_VARS as $k => $v) {
$q->query('update '.TBL_CONFIGURATION." set varvalue = '$v' where varname = '$k'");
}
}
function list_options() {
global $q, $t;
$t->set_file('content', 'configure.html');
$t->set_block('content', 'row', 'rows');
$t->set_block('row', 'inputblock', 'input');
$t->set_block('row', 'selectblock', 'select');
$t->set_block('row', 'radioblock', 'radio');
$q->query('select * from '.TBL_CONFIGURATION);
while ($row = $q->grab()) {
$t->set_var($row);
$t->set_var('trclass', ++$i % 2 ? '' : 'alt');
switch ($row['vartype']) {
case 'multi' :
$t->set_var(array(
'options' => build_select($row['varname'], $row['varvalue']),
'input' => '',
'radio' => ''
));
$t->parse('select', 'selectblock', true);
break;
case 'bool' :
$t->set_var(array(
'yes' => $row['varvalue'] ? ' checked' : '',
'no' => $row['varvalue'] ? '' : ' checked',
'input' => '',
'select' => ''
));
$t->parse('radio', 'radioblock', true);
break;
default :
$t->set_var(array(
'input_type' => 'text',
'checked' => '',
'select' => '',
'radio' => ''
));
$t->parse('input', 'inputblock', true);
break;
}
$t->parse('rows', 'row', true);
$t->set_var(array(
'input' => '',
'select' => '',
'radio' => ''
));
}
}
$t->set_file('wrap','wrap.html');
$perm->check('Admin');
if ($submit) {
save_options();
}
list_options();
$t->pparse('main',array('content','wrap','main'));
page_close();
?>
|
|
From: Benjamin C. <bc...@us...> - 2001-10-13 23:15:55
|
Update of /cvsroot/phpbt/phpbt/templates/default/admin
In directory usw-pr-cvs1:/tmp/cvs-serv13358/templates/default/admin
Modified Files:
wrap.html
Added Files:
configure.html
Log Message:
Added an admin interface for the configuration options
--- NEW FILE: configure.html ---
<br>
<form action="{me}" method="post">
<table border="0" width="640">
<tr>
<td valign="top">
<b> Configuration</b>
<hr size="1">
<table border="0">
<tr>
<th>Variable</th>
<th>Value</th>
<th>Information</th>
</tr>
<!-- BEGIN row -->
<tr class="{trclass}">
<td>{varname}</td>
<td>
<!-- BEGIN inputblock -->
<input type="{input_type}" name="{varname}" value="{varvalue}"{checked}>
<!-- END inputblock -->
<!-- BEGIN selectblock -->
<select name="varname">{options}</select>
<!-- END selectblock -->
<!-- BEGIN radioblock -->
<input type="radio" name="{varname}" value="1"{yes}> Yes
<input type="radio" name="{varname}" value="0"{no}> No
<!-- END radioblock -->
</td>
<td>{description}</td>
</tr>
<!-- END row -->
</table>
</td>
</tr>
<tr>
<td align="center">
<input type="reset" value="Reset Form">
<input type="submit" name="submit" value="Submit Changes">
</td>
</tr>
</table>
</form>
Index: wrap.html
===================================================================
RCS file: /cvsroot/phpbt/phpbt/templates/default/admin/wrap.html,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- wrap.html 2001/10/11 14:24:04 1.1
+++ wrap.html 2001/10/13 23:15:52 1.2
@@ -13,6 +13,7 @@
<td width="540">
<font class="navfont"><b>
[
+ <a href="configure.php">Configuration</a> |
<a href="project.php">Projects</a> |
<a href="user.php">Users</a> |
<a href="status.php">Statuses</a> |
|
|
From: Benjamin C. <bc...@us...> - 2001-10-13 23:15:25
|
Update of /cvsroot/phpbt/phpbt/schemas
In directory usw-pr-cvs1:/tmp/cvs-serv13255/schemas
Modified Files:
mysql.0.3.x-0.4.0.in mysql.in pgsql.0.3.x-0.4.0.in pgsql.in
Log Message:
Changed the theme configuration option to be multi-valued (select box) rather than free-form (text box) and added a warning to the encrypt_pass option
Index: mysql.0.3.x-0.4.0.in
===================================================================
RCS file: /cvsroot/phpbt/phpbt/schemas/mysql.0.3.x-0.4.0.in,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- mysql.0.3.x-0.4.0.in 2001/10/12 13:43:59 1.1
+++ mysql.0.3.x-0.4.0.in 2001/10/13 23:15:22 1.2
@@ -14,14 +14,14 @@
INSERT INTO TBL_CONFIGURATION VALUES ('JPGRAPH_PATH','','If not in the include path','string');
INSERT INTO TBL_CONFIGURATION VALUES ('CVS_WEB','http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/phpbt/phpbt/','Location of your cvs web interface (see format_comments() in bug.php)','string');
INSERT INTO TBL_CONFIGURATION VALUES ('ADMIN_EMAIL','ph...@be...','The email address used in correspondence from the bug tracker','string');
-INSERT INTO TBL_CONFIGURATION VALUES ('ENCRYPT_PASS','','Whether to store passwords encrypted','bool');
+INSERT INTO TBL_CONFIGURATION VALUES ('ENCRYPT_PASS','','Whether to store passwords encrypted. <b>Warning:</b> Changing this after users have been created will result in their being unable to login.','bool');
INSERT INTO TBL_CONFIGURATION VALUES ('USE_JPGRAPH','','Whether to show some reports as images','bool');
INSERT INTO TBL_CONFIGURATION VALUES ('MASK_EMAIL','1','Should email addresses have . changed to \'dot\' and @ change to \'at\'?','bool');
INSERT INTO TBL_CONFIGURATION VALUES ('HIDE_EMAIL','1','Should email addresses be hidden for those not logged in?','bool');
INSERT INTO TBL_CONFIGURATION VALUES ('USE_SEVERITY_COLOR','1','Should the query list use the severity colors as the row background color (like SourceForge)','bool');
INSERT INTO TBL_CONFIGURATION VALUES ('EMAIL_IS_LOGIN','1','Whether to use email addresses as logins','bool');
INSERT INTO TBL_CONFIGURATION VALUES ('ATTACHMENT_PATH','attachments','Sub-dir of the INSTALLPATH - Needs to be writeable by the web process','string');
-INSERT INTO TBL_CONFIGURATION VALUES ('THEME','default','Which set of templates to use','string');
+INSERT INTO TBL_CONFIGURATION VALUES ('THEME','default','Which set of templates to use','multi');
INSERT INTO TBL_CONFIGURATION VALUES ('ATTACHMENT_MAX_SIZE','2097152','Maximum size (in bytes) of an attachment. This will not override the settings in php.ini if php.ini has a lower limit.','string');
INSERT INTO TBL_CONFIGURATION VALUES ('DATE_FORMAT','m-d-Y','See the <a href="http://www.php.net/date" target="_new">date page</a> in the PHP manual for more info','string');
INSERT INTO TBL_CONFIGURATION VALUES ('TIME_FORMAT','g:i A','See the <a href="http://www.php.net/date" target="_new">date page</a> in the PHP manual for more info','string');
Index: mysql.in
===================================================================
RCS file: /cvsroot/phpbt/phpbt/schemas/mysql.in,v
retrieving revision 1.5
retrieving revision 1.6
diff -u -r1.5 -r1.6
--- mysql.in 2001/10/12 13:43:59 1.5
+++ mysql.in 2001/10/13 23:15:22 1.6
@@ -272,14 +272,14 @@
INSERT INTO TBL_CONFIGURATION VALUES ('JPGRAPH_PATH','','If not in the include path','string');
INSERT INTO TBL_CONFIGURATION VALUES ('CVS_WEB','http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/phpbt/phpbt/','Location of your cvs web interface (see format_comments() in bug.php)','string');
INSERT INTO TBL_CONFIGURATION VALUES ('ADMIN_EMAIL','ph...@be...','The email address used in correspondence from the bug tracker','string');
-INSERT INTO TBL_CONFIGURATION VALUES ('ENCRYPT_PASS','','Whether to store passwords encrypted','bool');
+INSERT INTO TBL_CONFIGURATION VALUES ('ENCRYPT_PASS','','Whether to store passwords encrypted. <b>Warning:</b> Changing this after users have been created will result in their being unable to login.','bool');
INSERT INTO TBL_CONFIGURATION VALUES ('USE_JPGRAPH','','Whether to show some reports as images','bool');
INSERT INTO TBL_CONFIGURATION VALUES ('MASK_EMAIL','1','Should email addresses have . changed to \'dot\' and @ change to \'at\'?','bool');
INSERT INTO TBL_CONFIGURATION VALUES ('HIDE_EMAIL','1','Should email addresses be hidden for those not logged in?','bool');
INSERT INTO TBL_CONFIGURATION VALUES ('USE_SEVERITY_COLOR','1','Should the query list use the severity colors as the row background color (like SourceForge)','bool');
INSERT INTO TBL_CONFIGURATION VALUES ('EMAIL_IS_LOGIN','1','Whether to use email addresses as logins','bool');
INSERT INTO TBL_CONFIGURATION VALUES ('ATTACHMENT_PATH','attachments','Sub-dir of the INSTALLPATH - Needs to be writeable by the web process','string');
-INSERT INTO TBL_CONFIGURATION VALUES ('THEME','default','Which set of templates to use','string');
+INSERT INTO TBL_CONFIGURATION VALUES ('THEME','default','Which set of templates to use','multi');
INSERT INTO TBL_CONFIGURATION VALUES ('ATTACHMENT_MAX_SIZE','2097152','Maximum size (in bytes) of an attachment. This will not override the settings in php.ini if php.ini has a lower limit.','string');
INSERT INTO TBL_CONFIGURATION VALUES ('DATE_FORMAT','m-d-Y','See the <a href="http://www.php.net/date" target="_new">date page</a> in the PHP manual for more info','string');
INSERT INTO TBL_CONFIGURATION VALUES ('TIME_FORMAT','g:i A','See the <a href="http://www.php.net/date" target="_new">date page</a> in the PHP manual for more info','string');
Index: pgsql.0.3.x-0.4.0.in
===================================================================
RCS file: /cvsroot/phpbt/phpbt/schemas/pgsql.0.3.x-0.4.0.in,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- pgsql.0.3.x-0.4.0.in 2001/10/12 13:43:59 1.1
+++ pgsql.0.3.x-0.4.0.in 2001/10/13 23:15:22 1.2
@@ -17,14 +17,14 @@
INSERT INTO TBL_CONFIGURATION VALUES ('JPGRAPH_PATH','','If not in the include path','string');
INSERT INTO TBL_CONFIGURATION VALUES ('CVS_WEB','http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/phpbt/phpbt/','Location of your cvs web interface (see format_comments() in bug.php)','string');
INSERT INTO TBL_CONFIGURATION VALUES ('ADMIN_EMAIL','ph...@be...','The email address used in correspondence from the bug tracker','string');
-INSERT INTO TBL_CONFIGURATION VALUES ('ENCRYPT_PASS','','Whether to store passwords encrypted','bool');
+INSERT INTO TBL_CONFIGURATION VALUES ('ENCRYPT_PASS','','Whether to store passwords encrypted. <b>Warning:</b> Changing this after users have been created will result in their being unable to login.','bool');
INSERT INTO TBL_CONFIGURATION VALUES ('USE_JPGRAPH','','Whether to show some reports as images','bool');
INSERT INTO TBL_CONFIGURATION VALUES ('MASK_EMAIL','1','Should email addresses have . changed to \'dot\' and @ change to \'at\'?','bool');
INSERT INTO TBL_CONFIGURATION VALUES ('HIDE_EMAIL','1','Should email addresses be hidden for those not logged in?','bool');
INSERT INTO TBL_CONFIGURATION VALUES ('USE_SEVERITY_COLOR','1','Should the query list use the severity colors as the row background color (like SourceForge)','bool');
INSERT INTO TBL_CONFIGURATION VALUES ('EMAIL_IS_LOGIN','1','Whether to use email addresses as logins','bool');
INSERT INTO TBL_CONFIGURATION VALUES ('ATTACHMENT_PATH','attachments','Sub-dir of the INSTALLPATH - Needs to be writeable by the web process','string');
-INSERT INTO TBL_CONFIGURATION VALUES ('THEME','default','Which set of templates to use','string');
+INSERT INTO TBL_CONFIGURATION VALUES ('THEME','default','Which set of templates to use','multi');
INSERT INTO TBL_CONFIGURATION VALUES ('ATTACHMENT_MAX_SIZE','2097152','Maximum size (in bytes) of an attachment. This will not override the settings in php.ini if php.ini has a lower limit.','string');
INSERT INTO TBL_CONFIGURATION VALUES ('DATE_FORMAT','m-d-Y','See the <a href="http://www.php.net/date" target="_new">date page</a> in the PHP manual for more info','string');
INSERT INTO TBL_CONFIGURATION VALUES ('TIME_FORMAT','g:i A','See the <a href="http://www.php.net/date" target="_new">date page</a> in the PHP manual for more info','string');
Index: pgsql.in
===================================================================
RCS file: /cvsroot/phpbt/phpbt/schemas/pgsql.in,v
retrieving revision 1.5
retrieving revision 1.6
diff -u -r1.5 -r1.6
--- pgsql.in 2001/10/12 13:43:59 1.5
+++ pgsql.in 2001/10/13 23:15:22 1.6
@@ -278,14 +278,14 @@
INSERT INTO TBL_CONFIGURATION VALUES ('JPGRAPH_PATH','','If not in the include path','string');
INSERT INTO TBL_CONFIGURATION VALUES ('CVS_WEB','http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/phpbt/phpbt/','Location of your cvs web interface (see format_comments() in bug.php)','string');
INSERT INTO TBL_CONFIGURATION VALUES ('ADMIN_EMAIL','ph...@be...','The email address used in correspondence from the bug tracker','string');
-INSERT INTO TBL_CONFIGURATION VALUES ('ENCRYPT_PASS','','Whether to store passwords encrypted','bool');
+INSERT INTO TBL_CONFIGURATION VALUES ('ENCRYPT_PASS','','Whether to store passwords encrypted. <b>Warning:</b> Changing this after users have been created will result in their being unable to login.','bool');
INSERT INTO TBL_CONFIGURATION VALUES ('USE_JPGRAPH','','Whether to show some reports as images','bool');
INSERT INTO TBL_CONFIGURATION VALUES ('MASK_EMAIL','1','Should email addresses have . changed to \'dot\' and @ change to \'at\'?','bool');
INSERT INTO TBL_CONFIGURATION VALUES ('HIDE_EMAIL','1','Should email addresses be hidden for those not logged in?','bool');
INSERT INTO TBL_CONFIGURATION VALUES ('USE_SEVERITY_COLOR','1','Should the query list use the severity colors as the row background color (like SourceForge)','bool');
INSERT INTO TBL_CONFIGURATION VALUES ('EMAIL_IS_LOGIN','1','Whether to use email addresses as logins','bool');
INSERT INTO TBL_CONFIGURATION VALUES ('ATTACHMENT_PATH','attachments','Sub-dir of the INSTALLPATH - Needs to be writeable by the web process','string');
-INSERT INTO TBL_CONFIGURATION VALUES ('THEME','default','Which set of templates to use','string');
+INSERT INTO TBL_CONFIGURATION VALUES ('THEME','default','Which set of templates to use','multi');
INSERT INTO TBL_CONFIGURATION VALUES ('ATTACHMENT_MAX_SIZE','2097152','Maximum size (in bytes) of an attachment. This will not override the settings in php.ini if php.ini has a lower limit.','string');
INSERT INTO TBL_CONFIGURATION VALUES ('DATE_FORMAT','m-d-Y','See the <a href="http://www.php.net/date" target="_new">date page</a> in the PHP manual for more info','string');
INSERT INTO TBL_CONFIGURATION VALUES ('TIME_FORMAT','g:i A','See the <a href="http://www.php.net/date" target="_new">date page</a> in the PHP manual for more info','string');
|
|
From: Benjamin C. <bc...@us...> - 2001-10-13 22:03:59
|
Update of /cvsroot/phpbt/phpbt/templates/default/admin In directory usw-pr-cvs1:/tmp/cvs-serv29994 Modified Files: userlist.html Log Message: Left out a </tr> Index: userlist.html =================================================================== RCS file: /cvsroot/phpbt/phpbt/templates/default/admin/userlist.html,v retrieving revision 1.1 retrieving revision 1.2 diff -u -r1.1 -r1.2 --- userlist.html 2001/10/11 14:24:04 1.1 +++ userlist.html 2001/10/13 22:03:56 1.2 @@ -81,4 +81,5 @@ </div> </form> </td> + </tr> </table> |
|
From: Benjamin C. <bc...@us...> - 2001-10-12 13:44:03
|
Update of /cvsroot/phpbt/phpbt
In directory usw-pr-cvs1:/tmp/cvs-serv4702
Modified Files:
configure_db
Log Message:
All new and improved update schema files!
Index: configure_db
===================================================================
RCS file: /cvsroot/phpbt/phpbt/configure_db,v
retrieving revision 1.7
retrieving revision 1.8
diff -u -r1.7 -r1.8
--- configure_db 2001/09/24 08:07:59 1.7
+++ configure_db 2001/10/12 13:43:59 1.8
@@ -6,11 +6,16 @@
#TBL_PREFIX="phpbt_"
TBL_PREFIX=''
DB_TYPE='mysql'
+VERSION='.0.3.x-0.4.0'
+UPGRADE=''
#------------------------------------------------------------------------------
help() {
echo "usage $0 -h|--help"
- echo " $0 [-t <db-type>] [-p <table-prefix>]"
+ echo " $0 [-t <db-type>] [-p <table-prefix>] [-u]"
+ echo ""
+ echo " -u: Used for upgrading from the previous major version (if applicable)"
+ echo ""
} #end help()
#------------------------------------------------------------------------------
@@ -27,6 +32,7 @@
s/TBL_BUG/${TBL_PREFIX}bug/g
s/TBL_COMMENT/${TBL_PREFIX}comment/g
s/TBL_COMPONENT/${TBL_PREFIX}component/g
+ s/TBL_CONFIGURATION/${TBL_PREFIX}configuration/g
s/TBL_PROJECT/${TBL_PREFIX}project/g
s/TBL_RESOLUTION/${TBL_PREFIX}resolution/g
s/TBL_SAVED_QUERY/${TBL_PREFIX}saved_query/g
@@ -48,6 +54,12 @@
#------------------------------------------------------------------------------
#parse commandline arguments
+
+if [ $# -eq 0 ];
+then
+ EXTRAHELP=" For help, run $0 -h"
+fi
+
while [ $# -gt 0 ]; do
case $1
in
@@ -69,6 +81,10 @@
fi
shift;;
+ '-u') #upgrading
+ UPGRADE=$VERSION
+ shift;;
+
'-h'|'--help')
help
exit 0;;
@@ -80,4 +96,6 @@
#------------------------------------------------------------------------------
#generate SQL file
-generate_sql schemas/$DB_TYPE.in createdb.sql
+generate_sql schemas/$DB_TYPE$UPGRADE.in createdb.sql
+echo $EXTRAHELP
+echo "Created $DB_TYPE schema file createdb.sql."
|
|
From: Benjamin C. <bc...@us...> - 2001-10-12 13:44:03
|
Update of /cvsroot/phpbt/phpbt/schemas
In directory usw-pr-cvs1:/tmp/cvs-serv4702/schemas
Modified Files:
mysql.in pgsql.in
Added Files:
mysql.0.2.x-0.3.0.in mysql.0.3.x-0.4.0.in pgsql.0.2.x-0.3.0.in
pgsql.0.3.x-0.4.0.in
Removed Files:
changes-0.4.0.sql
Log Message:
All new and improved update schema files!
--- NEW FILE: mysql.0.2.x-0.3.0.in ---
#
# -- Conversion from 0.2.x to 0.3.0 --
#
INSERT INTO TBL_ATTACHMENT SELECT * FROM Attachment;
INSERT INTO TBL_AUTH_USER SELECT UserID, Email, FirstName, LastName, Email, Password, if (UserLevel > 0, 1, 0), '', 0, CreatedDate, 0, CreatedDate FROM User;
INSERT INTO TBL_BUG SELECT *, 0 FROM Bug;
INSERT INTO TBL_BUG_HISTORY SELECT * FROM BugHistory;
INSERT INTO TBL_COMMENT SELECT * FROM Comment;
INSERT INTO TBL_COMPONENT SELECT * FROM Component;
INSERT INTO TBL_OS SELECT * FROM OS;
INSERT INTO TBL_PROJECT SELECT *, CreatedBy, CreatedDate FROM Project;
INSERT INTO TBL_RESOLUTION SELECT * FROM Resolution;
INSERT INTO TBL_SAVED_QUERY SELECT * FROM SavedQuery;
INSERT INTO TBL_SEVERITY SELECT *, '' FROM Severity;
UPDATE TBL_SEVERITY SET severity_color = '#dadada' WHERE severity_id = '1';
UPDATE TBL_SEVERITY SET severity_color = '#dad0d0' WHERE severity_id = '2';
UPDATE TBL_SEVERITY SET severity_color = '#dacaca' WHERE severity_id = '3';
UPDATE TBL_SEVERITY SET severity_color = '#dac0c0' WHERE severity_id = '4';
UPDATE TBL_SEVERITY SET severity_color = '#dababa' WHERE severity_id = '5';
UPDATE TBL_SEVERITY SET severity_color = '#dab0b0' WHERE severity_id = '6';
UPDATE TBL_SEVERITY SET severity_color = '#daaaaa' WHERE severity_id = '7';
INSERT INTO TBL_STATUS SELECT * FROM Status;
INSERT INTO TBL_VERSION SELECT *, CreatedBy, CreatedDate FROM Version;
# Start off with three user levels...
INSERT INTO TBL_AUTH_GROUP (group_id, group_name) VALUES (1, 'Admin');
INSERT INTO TBL_AUTH_GROUP (group_id, group_name) VALUES (2, 'User');
INSERT INTO TBL_AUTH_GROUP (group_id, group_name) VALUES (3, 'Developer');
# ... and only two permissions
INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (1, 'Admin');
INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (2, 'Editbug');
# Admins can do all the admin stuff and users can edit bugs
INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (1, 1);
INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (2, 2);
# Move users into the new tables
INSERT INTO TBL_USER_GROUP (user_id, group_id) SELECT UserID, group_id FROM User, TBL_AUTH_GROUP where UserLevel = 15 and group_name = 'Admin';
INSERT INTO TBL_USER_GROUP (user_id, group_id) SELECT UserID, group_id FROM User, TBL_AUTH_GROUP where UserLevel = 3 and group_name = 'Developer';
INSERT INTO TBL_USER_GROUP (user_id, group_id) SELECT UserID, 2 FROM User where UserLevel > 0;
--- NEW FILE: mysql.0.3.x-0.4.0.in ---
#
# -- Conversion from 0.3.x to 0.4.0 --
#
CREATE TABLE TBL_CONFIGURATION (
varname char(40) NOT NULL default '',
varvalue char(255) NOT NULL default '',
description char(255) NOT NULL default '',
vartype char(20) NOT NULL default '',
PRIMARY KEY (varname)
);
INSERT INTO TBL_CONFIGURATION VALUES ('INSTALL_URL','http://localhost/~bcurtis/phpbt','The base URL of the phpBugTracker installation','string');
INSERT INTO TBL_CONFIGURATION VALUES ('JPGRAPH_PATH','','If not in the include path','string');
INSERT INTO TBL_CONFIGURATION VALUES ('CVS_WEB','http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/phpbt/phpbt/','Location of your cvs web interface (see format_comments() in bug.php)','string');
INSERT INTO TBL_CONFIGURATION VALUES ('ADMIN_EMAIL','ph...@be...','The email address used in correspondence from the bug tracker','string');
INSERT INTO TBL_CONFIGURATION VALUES ('ENCRYPT_PASS','','Whether to store passwords encrypted','bool');
INSERT INTO TBL_CONFIGURATION VALUES ('USE_JPGRAPH','','Whether to show some reports as images','bool');
INSERT INTO TBL_CONFIGURATION VALUES ('MASK_EMAIL','1','Should email addresses have . changed to \'dot\' and @ change to \'at\'?','bool');
INSERT INTO TBL_CONFIGURATION VALUES ('HIDE_EMAIL','1','Should email addresses be hidden for those not logged in?','bool');
INSERT INTO TBL_CONFIGURATION VALUES ('USE_SEVERITY_COLOR','1','Should the query list use the severity colors as the row background color (like SourceForge)','bool');
INSERT INTO TBL_CONFIGURATION VALUES ('EMAIL_IS_LOGIN','1','Whether to use email addresses as logins','bool');
INSERT INTO TBL_CONFIGURATION VALUES ('ATTACHMENT_PATH','attachments','Sub-dir of the INSTALLPATH - Needs to be writeable by the web process','string');
INSERT INTO TBL_CONFIGURATION VALUES ('THEME','default','Which set of templates to use','string');
INSERT INTO TBL_CONFIGURATION VALUES ('ATTACHMENT_MAX_SIZE','2097152','Maximum size (in bytes) of an attachment. This will not override the settings in php.ini if php.ini has a lower limit.','string');
INSERT INTO TBL_CONFIGURATION VALUES ('DATE_FORMAT','m-d-Y','See the <a href="http://www.php.net/date" target="_new">date page</a> in the PHP manual for more info','string');
INSERT INTO TBL_CONFIGURATION VALUES ('TIME_FORMAT','g:i A','See the <a href="http://www.php.net/date" target="_new">date page</a> in the PHP manual for more info','string');
INSERT INTO TBL_CONFIGURATION VALUES ('LANGUAGE','en','The language file to use for warning and error messages','multi');
--- NEW FILE: pgsql.0.2.x-0.3.0.in ---
--
-- -- Conversion from 0.2.x to 0.3.0 --
--
INSERT INTO TBL_ATTACHMENT SELECT * FROM Attachment;
INSERT INTO TBL_AUTH_USER SELECT UserID, Email, FirstName, LastName, Email, Password, if (UserLevel > 0, 1, 0), '', 0, CreatedDate, 0, CreatedDate FROM User;
INSERT INTO TBL_BUG SELECT *, 0 FROM Bug;
INSERT INTO TBL_BUG_HISTORY SELECT * FROM BugHistory;
INSERT INTO TBL_COMMENT SELECT * FROM Comment;
INSERT INTO TBL_COMPONENT SELECT * FROM Component;
INSERT INTO TBL_OS SELECT * FROM OS;
INSERT INTO TBL_PROJECT SELECT *, CreatedBy, CreatedDate FROM Project;
INSERT INTO TBL_RESOLUTION SELECT * FROM Resolution;
INSERT INTO TBL_SAVED_QUERY SELECT * FROM SavedQuery;
INSERT INTO TBL_SEVERITY SELECT *, '' FROM Severity;
UPDATE TBL_SEVERITY SET severity_color = '#dadada' WHERE severity_id = '1';
UPDATE TBL_SEVERITY SET severity_color = '#dad0d0' WHERE severity_id = '2';
UPDATE TBL_SEVERITY SET severity_color = '#dacaca' WHERE severity_id = '3';
UPDATE TBL_SEVERITY SET severity_color = '#dac0c0' WHERE severity_id = '4';
UPDATE TBL_SEVERITY SET severity_color = '#dababa' WHERE severity_id = '5';
UPDATE TBL_SEVERITY SET severity_color = '#dab0b0' WHERE severity_id = '6';
UPDATE TBL_SEVERITY SET severity_color = '#daaaaa' WHERE severity_id = '7';
INSERT INTO TBL_STATUS SELECT * FROM Status;
INSERT INTO TBL_VERSION SELECT *, CreatedBy, CreatedDate FROM Version;
-- Start off with three user levels...
INSERT INTO TBL_AUTH_GROUP (group_id, group_name) VALUES (1, 'Admin');
INSERT INTO TBL_AUTH_GROUP (group_id, group_name) VALUES (2, 'User');
INSERT INTO TBL_AUTH_GROUP (group_id, group_name) VALUES (3, 'Developer');
-- ... and only two permissions
INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (1, 'Admin');
INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (2, 'Editbug');
-- Admins can do all the admin stuff and users can edit bugs
INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (1, 1);
INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (2, 2);
-- Move users into the new tables
INSERT INTO TBL_USER_GROUP (user_id, group_id) SELECT UserID, group_id FROM User, TBL_AUTH_GROUP where UserLevel = 15 and group_name = 'Admin';
INSERT INTO TBL_USER_GROUP (user_id, group_id) SELECT UserID, group_id FROM User, TBL_AUTH_GROUP where UserLevel = 3 and group_name = 'Developer';
INSERT INTO TBL_USER_GROUP (user_id, group_id) SELECT UserID, 2 FROM User where UserLevel > 0;
--- NEW FILE: pgsql.0.3.x-0.4.0.in ---
BEGIN;
--
-- -- Conversion from 0.3.x to 0.4.0 --
--
CREATE TABLE TBL_CONFIGURATION (
varname char(40) NOT NULL DEFAULT '',
varvalue char(255) NOT NULL DEFAULT '',
description char(255) NOT NULL DEFAULT '',
vartype char(20) NOT NULL DEFAULT '',
PRIMARY KEY (varname)
);
INSERT INTO TBL_CONFIGURATION VALUES ('INSTALL_URL','http://localhost/~bcurtis/phpbt','The base URL of the phpBugTracker installation','string');
INSERT INTO TBL_CONFIGURATION VALUES ('JPGRAPH_PATH','','If not in the include path','string');
INSERT INTO TBL_CONFIGURATION VALUES ('CVS_WEB','http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/phpbt/phpbt/','Location of your cvs web interface (see format_comments() in bug.php)','string');
INSERT INTO TBL_CONFIGURATION VALUES ('ADMIN_EMAIL','ph...@be...','The email address used in correspondence from the bug tracker','string');
INSERT INTO TBL_CONFIGURATION VALUES ('ENCRYPT_PASS','','Whether to store passwords encrypted','bool');
INSERT INTO TBL_CONFIGURATION VALUES ('USE_JPGRAPH','','Whether to show some reports as images','bool');
INSERT INTO TBL_CONFIGURATION VALUES ('MASK_EMAIL','1','Should email addresses have . changed to \'dot\' and @ change to \'at\'?','bool');
INSERT INTO TBL_CONFIGURATION VALUES ('HIDE_EMAIL','1','Should email addresses be hidden for those not logged in?','bool');
INSERT INTO TBL_CONFIGURATION VALUES ('USE_SEVERITY_COLOR','1','Should the query list use the severity colors as the row background color (like SourceForge)','bool');
INSERT INTO TBL_CONFIGURATION VALUES ('EMAIL_IS_LOGIN','1','Whether to use email addresses as logins','bool');
INSERT INTO TBL_CONFIGURATION VALUES ('ATTACHMENT_PATH','attachments','Sub-dir of the INSTALLPATH - Needs to be writeable by the web process','string');
INSERT INTO TBL_CONFIGURATION VALUES ('THEME','default','Which set of templates to use','string');
INSERT INTO TBL_CONFIGURATION VALUES ('ATTACHMENT_MAX_SIZE','2097152','Maximum size (in bytes) of an attachment. This will not override the settings in php.ini if php.ini has a lower limit.','string');
INSERT INTO TBL_CONFIGURATION VALUES ('DATE_FORMAT','m-d-Y','See the <a href="http://www.php.net/date" target="_new">date page</a> in the PHP manual for more info','string');
INSERT INTO TBL_CONFIGURATION VALUES ('TIME_FORMAT','g:i A','See the <a href="http://www.php.net/date" target="_new">date page</a> in the PHP manual for more info','string');
INSERT INTO TBL_CONFIGURATION VALUES ('LANGUAGE','en','The language file to use for warning and error messages','multi');
COMMIT;
Index: mysql.in
===================================================================
RCS file: /cvsroot/phpbt/phpbt/schemas/mysql.in,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -r1.4 -r1.5
--- mysql.in 2001/10/07 23:42:11 1.4
+++ mysql.in 2001/10/12 13:43:59 1.5
@@ -137,6 +137,14 @@
PRIMARY KEY (component_id)
) TYPE=MyISAM;
+CREATE TABLE TBL_CONFIGURATION (
+ varname char(40) NOT NULL default '',
+ varvalue char(255) NOT NULL default '',
+ description char(255) NOT NULL default '',
+ vartype char(20) NOT NULL default '',
+ PRIMARY KEY (varname)
+) TYPE=MyISAM;
+
CREATE TABLE db_sequence (
seq_name varchar(127) NOT NULL default '',
nextid int(10) unsigned NOT NULL default '0',
@@ -260,6 +268,22 @@
INSERT INTO TBL_USER_GROUP (user_id, group_id) VALUES (1, 1);
INSERT INTO TBL_USER_GROUP (user_id, group_id) VALUES (1, 2);
+INSERT INTO TBL_CONFIGURATION VALUES ('INSTALL_URL','http://localhost/~bcurtis/phpbt','The base URL of the phpBugTracker installation','string');
+INSERT INTO TBL_CONFIGURATION VALUES ('JPGRAPH_PATH','','If not in the include path','string');
+INSERT INTO TBL_CONFIGURATION VALUES ('CVS_WEB','http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/phpbt/phpbt/','Location of your cvs web interface (see format_comments() in bug.php)','string');
+INSERT INTO TBL_CONFIGURATION VALUES ('ADMIN_EMAIL','ph...@be...','The email address used in correspondence from the bug tracker','string');
+INSERT INTO TBL_CONFIGURATION VALUES ('ENCRYPT_PASS','','Whether to store passwords encrypted','bool');
+INSERT INTO TBL_CONFIGURATION VALUES ('USE_JPGRAPH','','Whether to show some reports as images','bool');
+INSERT INTO TBL_CONFIGURATION VALUES ('MASK_EMAIL','1','Should email addresses have . changed to \'dot\' and @ change to \'at\'?','bool');
+INSERT INTO TBL_CONFIGURATION VALUES ('HIDE_EMAIL','1','Should email addresses be hidden for those not logged in?','bool');
+INSERT INTO TBL_CONFIGURATION VALUES ('USE_SEVERITY_COLOR','1','Should the query list use the severity colors as the row background color (like SourceForge)','bool');
+INSERT INTO TBL_CONFIGURATION VALUES ('EMAIL_IS_LOGIN','1','Whether to use email addresses as logins','bool');
+INSERT INTO TBL_CONFIGURATION VALUES ('ATTACHMENT_PATH','attachments','Sub-dir of the INSTALLPATH - Needs to be writeable by the web process','string');
+INSERT INTO TBL_CONFIGURATION VALUES ('THEME','default','Which set of templates to use','string');
+INSERT INTO TBL_CONFIGURATION VALUES ('ATTACHMENT_MAX_SIZE','2097152','Maximum size (in bytes) of an attachment. This will not override the settings in php.ini if php.ini has a lower limit.','string');
+INSERT INTO TBL_CONFIGURATION VALUES ('DATE_FORMAT','m-d-Y','See the <a href="http://www.php.net/date" target="_new">date page</a> in the PHP manual for more info','string');
+INSERT INTO TBL_CONFIGURATION VALUES ('TIME_FORMAT','g:i A','See the <a href="http://www.php.net/date" target="_new">date page</a> in the PHP manual for more info','string');
+INSERT INTO TBL_CONFIGURATION VALUES ('LANGUAGE','en','The language file to use for warning and error messages','multi');
INSERT INTO TBL_OS VALUES (1,'All',1,'');
INSERT INTO TBL_OS VALUES (2,'Windows 3.1',2,'/Mozilla.*\\(Win16.*\\)/');
@@ -319,47 +343,4 @@
INSERT INTO TBL_STATUS VALUES (6,'Verified','The resolution is confirmed by the reporter',6);
INSERT INTO TBL_STATUS VALUES (7,'Closed','The bug is officially squashed (QA)',7);
INSERT INTO db_sequence values ('TBL_STATUS', 7);
-
-#
-# -- Conversion from 0.2.x to 0.3.0 --
-#
-
-#INSERT INTO TBL_ATTACHMENT SELECT * FROM Attachment;
-#INSERT INTO TBL_AUTH_USER SELECT UserID, Email, FirstName, LastName, Email, Password, if (UserLevel > 0, 1, 0), '', 0, CreatedDate, 0, CreatedDate FROM User;
-#INSERT INTO TBL_BUG SELECT *, 0 FROM Bug;
-#INSERT INTO TBL_BUG_HISTORY SELECT * FROM BugHistory;
-#INSERT INTO TBL_COMMENT SELECT * FROM Comment;
-#INSERT INTO TBL_COMPONENT SELECT * FROM Component;
-#INSERT INTO TBL_OS SELECT * FROM OS;
-#INSERT INTO TBL_PROJECT SELECT *, CreatedBy, CreatedDate FROM Project;
-#INSERT INTO TBL_RESOLUTION SELECT * FROM Resolution;
-#INSERT INTO TBL_SAVED_QUERY SELECT * FROM SavedQuery;
-#INSERT INTO TBL_SEVERITY SELECT *, '' FROM Severity;
-#UPDATE TBL_SEVERITY SET severity_color = '#dadada' WHERE severity_id = '1';
-#UPDATE TBL_SEVERITY SET severity_color = '#dad0d0' WHERE severity_id = '2';
-#UPDATE TBL_SEVERITY SET severity_color = '#dacaca' WHERE severity_id = '3';
-#UPDATE TBL_SEVERITY SET severity_color = '#dac0c0' WHERE severity_id = '4';
-#UPDATE TBL_SEVERITY SET severity_color = '#dababa' WHERE severity_id = '5';
-#UPDATE TBL_SEVERITY SET severity_color = '#dab0b0' WHERE severity_id = '6';
-#UPDATE TBL_SEVERITY SET severity_color = '#daaaaa' WHERE severity_id = '7';
-#INSERT INTO TBL_STATUS SELECT * FROM Status;
-#INSERT INTO TBL_VERSION SELECT *, CreatedBy, CreatedDate FROM Version;
-
-# Start off with three user levels...
-#INSERT INTO TBL_AUTH_GROUP (group_id, group_name) VALUES (1, 'Admin');
-#INSERT INTO TBL_AUTH_GROUP (group_id, group_name) VALUES (2, 'User');
-#INSERT INTO TBL_AUTH_GROUP (group_id, group_name) VALUES (3, 'Developer');
-
-# ... and only two permissions
-#INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (1, 'Admin');
-#INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (2, 'Editbug');
-
-# Admins can do all the admin stuff and users can edit bugs
-#INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (1, 1);
-#INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (2, 2);
-
-# Move users into the new tables
-#INSERT INTO TBL_USER_GROUP (user_id, group_id) SELECT UserID, group_id FROM User, TBL_AUTH_GROUP where UserLevel = 15 and group_name = 'Admin';
-#INSERT INTO TBL_USER_GROUP (user_id, group_id) SELECT UserID, group_id FROM User, TBL_AUTH_GROUP where UserLevel = 3 and group_name = 'Developer';
-#INSERT INTO TBL_USER_GROUP (user_id, group_id) SELECT UserID, 2 FROM User where UserLevel > 0;
Index: pgsql.in
===================================================================
RCS file: /cvsroot/phpbt/phpbt/schemas/pgsql.in,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -r1.4 -r1.5
--- pgsql.in 2001/10/07 23:42:11 1.4
+++ pgsql.in 2001/10/12 13:43:59 1.5
@@ -138,6 +138,14 @@
PRIMARY KEY (component_id)
);
+CREATE TABLE TBL_CONFIGURATION (
+ varname char(40) NOT NULL DEFAULT '',
+ varvalue char(255) NOT NULL DEFAULT '',
+ description char(255) NOT NULL DEFAULT '',
+ vartype char(20) NOT NULL DEFAULT '',
+ PRIMARY KEY (varname)
+);
+
CREATE TABLE db_sequence (
seq_name varchar(127) NOT NULL DEFAULT '',
nextid INT4 NOT NULL DEFAULT '0',
@@ -266,6 +274,22 @@
INSERT INTO TBL_USER_GROUP (user_id, group_id) VALUES (1, 1);
INSERT INTO TBL_USER_GROUP (user_id, group_id) VALUES (1, 2);
+INSERT INTO TBL_CONFIGURATION VALUES ('INSTALL_URL','http://localhost/~bcurtis/phpbt','The base URL of the phpBugTracker installation','string');
+INSERT INTO TBL_CONFIGURATION VALUES ('JPGRAPH_PATH','','If not in the include path','string');
+INSERT INTO TBL_CONFIGURATION VALUES ('CVS_WEB','http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/phpbt/phpbt/','Location of your cvs web interface (see format_comments() in bug.php)','string');
+INSERT INTO TBL_CONFIGURATION VALUES ('ADMIN_EMAIL','ph...@be...','The email address used in correspondence from the bug tracker','string');
+INSERT INTO TBL_CONFIGURATION VALUES ('ENCRYPT_PASS','','Whether to store passwords encrypted','bool');
+INSERT INTO TBL_CONFIGURATION VALUES ('USE_JPGRAPH','','Whether to show some reports as images','bool');
+INSERT INTO TBL_CONFIGURATION VALUES ('MASK_EMAIL','1','Should email addresses have . changed to \'dot\' and @ change to \'at\'?','bool');
+INSERT INTO TBL_CONFIGURATION VALUES ('HIDE_EMAIL','1','Should email addresses be hidden for those not logged in?','bool');
+INSERT INTO TBL_CONFIGURATION VALUES ('USE_SEVERITY_COLOR','1','Should the query list use the severity colors as the row background color (like SourceForge)','bool');
+INSERT INTO TBL_CONFIGURATION VALUES ('EMAIL_IS_LOGIN','1','Whether to use email addresses as logins','bool');
+INSERT INTO TBL_CONFIGURATION VALUES ('ATTACHMENT_PATH','attachments','Sub-dir of the INSTALLPATH - Needs to be writeable by the web process','string');
+INSERT INTO TBL_CONFIGURATION VALUES ('THEME','default','Which set of templates to use','string');
+INSERT INTO TBL_CONFIGURATION VALUES ('ATTACHMENT_MAX_SIZE','2097152','Maximum size (in bytes) of an attachment. This will not override the settings in php.ini if php.ini has a lower limit.','string');
+INSERT INTO TBL_CONFIGURATION VALUES ('DATE_FORMAT','m-d-Y','See the <a href="http://www.php.net/date" target="_new">date page</a> in the PHP manual for more info','string');
+INSERT INTO TBL_CONFIGURATION VALUES ('TIME_FORMAT','g:i A','See the <a href="http://www.php.net/date" target="_new">date page</a> in the PHP manual for more info','string');
+INSERT INTO TBL_CONFIGURATION VALUES ('LANGUAGE','en','The language file to use for warning and error messages','multi');
INSERT INTO TBL_OS VALUES (1,'All',1,'');
INSERT INTO TBL_OS VALUES (2,'Windows 3.1',2,'/Mozilla.*\\(Win16.*\\)/');
@@ -325,50 +349,6 @@
INSERT INTO TBL_STATUS VALUES (6,'Verified','The resolution is confirmed by the reporter',6);
INSERT INTO TBL_STATUS VALUES (7,'Closed','The bug is officially squashed (QA)',7);
INSERT INTO db_sequence values ('TBL_STATUS', 7);
-
---
--- -- Conversion from 0.2.x to 0.3.0 --
---
-
---INSERT INTO TBL_ATTACHMENT SELECT * FROM Attachment;
---INSERT INTO TBL_AUTH_USER SELECT UserID, Email, FirstName, LastName, Email, Password, if (UserLevel > 0, 1, 0), '', 0, CreatedDate, 0, CreatedDate FROM User;
---INSERT INTO TBL_BUG SELECT *, 0 FROM Bug;
---INSERT INTO TBL_BUG_HISTORY SELECT * FROM BugHistory;
---INSERT INTO TBL_COMMENT SELECT * FROM Comment;
---INSERT INTO TBL_COMPONENT SELECT * FROM Component;
---INSERT INTO TBL_OS SELECT * FROM OS;
---INSERT INTO TBL_PROJECT SELECT *, CreatedBy, CreatedDate FROM Project;
---INSERT INTO TBL_RESOLUTION SELECT * FROM Resolution;
---INSERT INTO TBL_SAVED_QUERY SELECT * FROM SavedQuery;
---INSERT INTO TBL_SEVERITY SELECT *, '' FROM Severity;
---UPDATE TBL_SEVERITY SET severity_color = '#dadada' WHERE severity_id = '1';
---UPDATE TBL_SEVERITY SET severity_color = '#dad0d0' WHERE severity_id = '2';
---UPDATE TBL_SEVERITY SET severity_color = '#dacaca' WHERE severity_id = '3';
---UPDATE TBL_SEVERITY SET severity_color = '#dac0c0' WHERE severity_id = '4';
---UPDATE TBL_SEVERITY SET severity_color = '#dababa' WHERE severity_id = '5';
---UPDATE TBL_SEVERITY SET severity_color = '#dab0b0' WHERE severity_id = '6';
---UPDATE TBL_SEVERITY SET severity_color = '#daaaaa' WHERE severity_id = '7';
---INSERT INTO TBL_STATUS SELECT * FROM Status;
---INSERT INTO TBL_VERSION SELECT *, CreatedBy, CreatedDate FROM Version;
-
--- Start off with three user levels...
---INSERT INTO TBL_AUTH_GROUP (group_id, group_name) VALUES (1, 'Admin');
---INSERT INTO TBL_AUTH_GROUP (group_id, group_name) VALUES (2, 'User');
---INSERT INTO TBL_AUTH_GROUP (group_id, group_name) VALUES (3, 'Developer');
-
--- ... and only two permissions
---INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (1, 'Admin');
---INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (2, 'Editbug');
-
--- Admins can do all the admin stuff and users can edit bugs
---INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (1, 1);
---INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (2, 2);
-
--- Move users into the new tables
---INSERT INTO TBL_USER_GROUP (user_id, group_id) SELECT UserID, group_id FROM User, TBL_AUTH_GROUP where UserLevel = 15 and group_name = 'Admin';
---INSERT INTO TBL_USER_GROUP (user_id, group_id) SELECT UserID, group_id FROM User, TBL_AUTH_GROUP where UserLevel = 3 and group_name = 'Developer';
---INSERT INTO TBL_USER_GROUP (user_id, group_id) SELECT UserID, 2 FROM User where UserLevel > 0;
-
--
--- changes-0.4.0.sql DELETED ---
|
|
From: Benjamin C. <bc...@us...> - 2001-10-12 13:43:33
|
Update of /cvsroot/phpbt/phpbt
In directory usw-pr-cvs1:/tmp/cvs-serv4552
Modified Files:
config.php include.php
Log Message:
Use table name constants for configuration table
Index: config.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/config.php,v
retrieving revision 1.13
retrieving revision 1.14
diff -u -r1.13 -r1.14
--- config.php 2001/10/12 04:19:31 1.13
+++ config.php 2001/10/12 13:43:29 1.14
@@ -44,6 +44,7 @@
define ('TBL_BUG_HISTORY', TBL_PREFIX.'bug_history');
define ('TBL_COMMENT', TBL_PREFIX.'comment');
define ('TBL_COMPONENT', TBL_PREFIX.'component');
+define ('TBL_CONFIGURATION', TBL_PREFIX.'configuration');
define ('TBL_GROUP_PERM', TBL_PREFIX.'group_perm');
define ('TBL_OS', TBL_PREFIX.'os');
define ('TBL_PROJECT', TBL_PREFIX.'project');
Index: include.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/include.php,v
retrieving revision 1.61
retrieving revision 1.62
diff -u -r1.61 -r1.62
--- include.php 2001/10/12 04:19:31 1.61
+++ include.php 2001/10/12 13:43:29 1.62
@@ -51,7 +51,7 @@
$q = new dbclass;
// Set up the configuration variables
-$q->query("select varname, varvalue from configuration");
+$q->query('select varname, varvalue from '.TBL_CONFIGURATION);
while (list($k, $v) = $q->grab()) {
define($k, $v);
}
|
|
From: Ben C. <php...@be...> - 2001-10-12 12:18:00
|
Because I was trying to get it done really quickly instead of correctly. :) I'll be changing it to match the rest of the DB creation stuff in the next few minutes. You'll notice I also left out the third column from the table. :)
On Fri, Oct 12, 2001 at 12:43:20PM +0200, Patrick Mairif wrote:
> On Thu, Oct 11, 2001 at 09:19:33PM -0700, Benjamin Curtis wrote:
> > --- NEW FILE: changes-0.4.0.sql ---
> > create table configuration (varname char(40) not null, varvalue char(255) not null, primary key (varname));
> > INSERT INTO configuration VALUES ('INSTALL_URL','http://localhost/~bcurtis/phpbt','');
>
> Why do you use a fixed tablename "configuration" instead a dynamic
> one?
>
> _______________________________________________
> phpbt-dev mailing list
> php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpbt-dev
|
|
From: Patrick M. <mai...@st...> - 2001-10-12 10:42:49
|
On Thu, Oct 11, 2001 at 09:19:33PM -0700, Benjamin Curtis wrote:
> --- NEW FILE: changes-0.4.0.sql ---
> create table configuration (varname char(40) not null, varvalue char(255) not null, primary key (varname));
> INSERT INTO configuration VALUES ('INSTALL_URL','http://localhost/~bcurtis/phpbt','');
Why do you use a fixed tablename "configuration" instead a dynamic
one?
|
|
From: Benjamin C. <bc...@us...> - 2001-10-12 04:19:34
|
Update of /cvsroot/phpbt/phpbt/admin
In directory usw-pr-cvs1:/tmp/cvs-serv4700/admin
Modified Files:
project.php user.php
Log Message:
* WARNING * This _will_ clobber your configuration settings, as most of the defines have moved to the new table, configuration. (Let me know if I broke anything) :)
Index: project.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/admin/project.php,v
retrieving revision 1.22
retrieving revision 1.23
diff -u -r1.22 -r1.23
--- project.php 2001/10/05 04:22:46 1.22
+++ project.php 2001/10/12 04:19:31 1.23
@@ -87,7 +87,7 @@
'trclass' => $i % 2 ? '' : 'alt',
'verid' => $row['version_id'],
'vername' => $row['version_name'],
- 'verdate' => date(DATEFORMAT,$row['created_date']),
+ 'verdate' => date(DATE_FORMAT,$row['created_date']),
'veractive' => $row['active'] ? 'Y' : 'N'
));
$t->parse('verrows','verrow',true);
@@ -170,9 +170,9 @@
'owner' => $row['Owner'],
'compactive' => $row['active'] ? 'Y' : 'N',
'createdby' => $row['created_by'],
- 'compdate' => date(DATEFORMAT,$row['created_date']),
+ 'compdate' => date(DATE_FORMAT,$row['created_date']),
'lastmodifiedby' => $row['last_modified_by'],
- 'lastmodifieddate' => date(DATEFORMAT,$row['last_modified_date'])
+ 'lastmodifieddate' => date(DATE_FORMAT,$row['last_modified_date'])
));
$t->parse('rows','row',true);
}
@@ -307,7 +307,7 @@
'description' => stripslashes($row['project_desc']),
'active' => $row['active'] ? 'Y' : 'N',
'createdby' => $row['created_by'],
- 'createddate' => date(DATEFORMAT,$row['created_date'])
+ 'createddate' => date(DATE_FORMAT,$row['created_date'])
));
$t->parse('rows','row',true);
}
Index: user.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/admin/user.php,v
retrieving revision 1.28
retrieving revision 1.29
diff -u -r1.28 -r1.29
--- user.php 2001/10/05 04:22:46 1.28
+++ user.php 2001/10/12 04:19:31 1.29
@@ -49,7 +49,7 @@
}
if (!$userid) {
- if (ENCRYPTPASS) $mpassword = md5($_pv['fpassword']);
+ if (ENCRYPT_PASS) $mpassword = md5($_pv['fpassword']);
else $mpassword = $_pv['fpassword'];
$new_user_id = $q->nextid(TBL_AUTH_USER);
$q->query('insert into '.TBL_AUTH_USER
@@ -64,7 +64,7 @@
values ('$new_user_id' ,'$group', $u, $now)");
}
} else {
- if (ENCRYPTPASS) {
+ if (ENCRYPT_PASS) {
$oldpass = $q->grab_field("select password from ".TBL_AUTH_USER
." where user_id = $userid");
if ($oldpass != $_pv['fpassword']) {
@@ -212,7 +212,7 @@
'name' => stripslashes($row['fullname']),
'email' => $row['email'],
'active' => $row['active'] ? 'Yes' : 'No',
- 'date' => date(DATEFORMAT, $row['created_date'])));
+ 'date' => date(DATE_FORMAT, $row['created_date'])));
$t->parse('rows','row',true);
}
|
|
From: Benjamin C. <bc...@us...> - 2001-10-12 04:19:34
|
Update of /cvsroot/phpbt/phpbt/schemas
In directory usw-pr-cvs1:/tmp/cvs-serv4700/schemas
Added Files:
changes-0.4.0.sql
Log Message:
* WARNING * This _will_ clobber your configuration settings, as most of the defines have moved to the new table, configuration. (Let me know if I broke anything) :)
--- NEW FILE: changes-0.4.0.sql ---
create table configuration (varname char(40) not null, varvalue char(255) not null, primary key (varname));
INSERT INTO configuration VALUES ('INSTALL_URL','http://localhost/~bcurtis/phpbt','');
INSERT INTO configuration VALUES ('JPGRAPH_PATH','','If not in the include path');
INSERT INTO configuration VALUES ('CVS_WEB','http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/phpbt/phpbt/','Location of your cvs web interface (see format_comments() in bug.php)');
INSERT INTO configuration VALUES ('ADMIN_EMAIL','ph...@be...','');
INSERT INTO configuration VALUES ('ENCRYPT_PASS','','Whether to store passwords encrypted');
INSERT INTO configuration VALUES ('USE_JPGRAPH','','Whether to show some reports as images');
INSERT INTO configuration VALUES ('MASK_EMAIL','1','Should email addresses have . changed to \'dot\' and @ change to \'at\'?');
INSERT INTO configuration VALUES ('HIDE_EMAIL','1','Should email addresses be hidden for those not logged in?');
INSERT INTO configuration VALUES ('USE_SEVERITY_COLOR','1','Should the query list use the severity colors as the row background color (like SourceForge)');
INSERT INTO configuration VALUES ('EMAIL_IS_LOGIN','1','Whether to use email addresses as logins');
INSERT INTO configuration VALUES ('ATTACHMENT_PATH','attachments','Sub-dir of the INSTALLPATH - Needs to be writeable by the web process');
INSERT INTO configuration VALUES ('THEME','default','Which set of templates to use');
INSERT INTO configuration VALUES ('ATTACHMENT_MAX_SIZE','2097152','Maximum size (in bytes) of an attachment. This will not override the settings in php.ini if php.ini has a lower limit.');
INSERT INTO configuration VALUES ('DATE_FORMAT','m-d-Y','');
INSERT INTO configuration VALUES ('TIME_FORMAT','g:i A','');
INSERT INTO configuration VALUES ('LANGUAGE','en','');
|
|
From: Benjamin C. <bc...@us...> - 2001-10-12 04:19:34
|
Update of /cvsroot/phpbt/phpbt
In directory usw-pr-cvs1:/tmp/cvs-serv4700
Modified Files:
attachment.php bug.php config.php include.php newaccount.php
query.php user.php
Log Message:
* WARNING * This _will_ clobber your configuration settings, as most of the defines have moved to the new table, configuration. (Let me know if I broke anything) :)
Index: attachment.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/attachment.php,v
retrieving revision 1.9
retrieving revision 1.10
diff -u -r1.9 -r1.10
--- attachment.php 2001/09/18 03:36:33 1.9
+++ attachment.php 2001/10/12 04:19:31 1.10
@@ -48,7 +48,7 @@
show_text($STRING['bad_attachment'], true);
return false;
}
- $filename = join('/',array(INSTALLPATH, ATTACHMENT_PATH,
+ $filename = join('/',array(INSTALL_PATH, ATTACHMENT_PATH,
$ainfo['project_id'], "{$ainfo['bug_id']}-{$ainfo['file_name']}"));
if (!is_readable($filename)) {
show_text($STRING['bad_attachment'], true);
@@ -89,7 +89,7 @@
}
}
- $filepath = INSTALLPATH.'/'.ATTACHMENT_PATH;
+ $filepath = INSTALL_PATH.'/'.ATTACHMENT_PATH;
$tmpfilename = $HTTP_POST_FILES['attachment']['tmp_name'];
$filename = "$bugid-{$HTTP_POST_FILES['attachment']['name']}";
Index: bug.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/bug.php,v
retrieving revision 1.48
retrieving revision 1.49
diff -u -r1.48 -r1.49
--- bug.php 2001/10/05 04:22:45 1.48
+++ bug.php 2001/10/12 04:19:31 1.49
@@ -71,7 +71,7 @@
'oldvalue' => stripslashes($row['old_value']),
'newvalue' => stripslashes($row['new_value']),
'createdby' => stripslashes(maskemail($row['login'])),
- 'date' => date(DATEFORMAT.' '.TIMEFORMAT, $row['created_date'])
+ 'date' => date(DATE_FORMAT.' '.TIME_FORMAT, $row['created_date'])
));
$t->parse('rows', 'row', true);
}
@@ -153,8 +153,8 @@
$row = $q->grab();
$t->set_var(array(
'newpostedby' => $row['login'],
- 'newpostedon' => date(TIMEFORMAT, $row['created_date']).' on '.
- date(DATEFORMAT, $row['created_date']),
+ 'newpostedon' => date(TIME_FORMAT, $row['created_date']).' on '.
+ date(DATE_FORMAT, $row['created_date']),
'newcomments' => textwrap('+ '.format_comments($row['comment_text']),72,"\n+ ")
));
// If this comment is the first additional comment after the creation of the
@@ -165,15 +165,15 @@
." where b.created_by = u.user_id and bug_id = {$buginfo['bug_id']}");
$t->set_var(array(
'oldpostedby' => $by,
- 'oldpostedon' => date(TIMEFORMAT,$on).' on '.date(DATEFORMAT,$on),
+ 'oldpostedon' => date(TIME_FORMAT,$on).' on '.date(DATE_FORMAT,$on),
'oldcomments' => textwrap(format_comments($comments),72)
));
} else {
$row = $q->grab();
$t->set_var(array(
'oldpostedby' => $row['login'],
- 'oldpostedon' => date(TIMEFORMAT,$row['created_date']).' on '.
- date(DATEFORMAT,$row['created_date']),
+ 'oldpostedon' => date(TIME_FORMAT,$row['created_date']).' on '.
+ date(DATE_FORMAT,$row['created_date']),
'oldcomments' => textwrap(format_comments($row['comment_text']),72)
));
}
@@ -201,7 +201,7 @@
$t->set_var(array(
'bugid' => $buginfo['bug_id'],
- 'bugurl' => INSTALLURL."/bug.php?op=show&bugid={$buginfo['bug_id']}",
+ 'bugurl' => INSTALL_URL."/bug.php?op=show&bugid={$buginfo['bug_id']}",
'priority' => $select['priority'][($cf['priority'] ? $cf['priority'] : $buginfo['priority'])],
'priority_stat' => $cf['priority'] ? '!' : ' ',
'reporter' => $reporter,
@@ -212,8 +212,8 @@
if ($toemail) {
mail($toemail,"[Bug {$buginfo['bug_id']}] Changed - ".
($cf['title'] ? $cf['title'] : $buginfo['title']), $t->parse('main','emailout'),
- sprintf("From: %s\nReply-To: %s\nErrors-To: %s\nContent-Type: text/plain; charset=%s\nContent-Transfer-Encoding: 8bit\n", ADMINEMAIL, ADMINEMAIL,
- ADMINEMAIL, $STRING['lang_charset']));
+ sprintf("From: %s\nReply-To: %s\nErrors-To: %s\nContent-Type: text/plain; charset=%s\nContent-Transfer-Encoding: 8bit\n", ADMIN_EMAIL, ADMIN_EMAIL,
+ ADMIN_EMAIL, $STRING['lang_charset']));
}
}
@@ -394,7 +394,7 @@
'resolution' => build_select('resolution',$row['resolution_id']),
'assignedto' => $row['assigned_to'],
'createdby' => $row['created_by'],
- 'createddate' => date(DATEFORMAT,$row['created_date']),
+ 'createddate' => date(DATE_FORMAT,$row['created_date']),
'lastmodifieddate' => $row['last_modified_date'],
'project' => $row['project_id'],
'projectname' => $projectname,
@@ -462,8 +462,8 @@
'resolution' => $row['resolution_name'] ? $row['resolution_name'] : '',
'owner' => maskemail($row['owner']),
'reporter' => maskemail($row['reporter']),
- 'createddate' => date(DATEFORMAT,$row['created_date']),
- 'createdtime' => date(TIMEFORMAT,$row['created_date']),
+ 'createddate' => date(DATE_FORMAT,$row['created_date']),
+ 'createdtime' => date(TIME_FORMAT,$row['created_date']),
'lastmodifieddate' => $row['last_modified_date'],
'project' => build_select('project',$row['project_id']),
'projectid' => $row['project_id'],
@@ -506,7 +506,7 @@
$t->set_var('attrows', '<tr><td colspan="5" align="center">No attachments</td></tr>');
} else {
while ($att = $q->grab()) {
- if (is_readable(INSTALLPATH.'/'.ATTACHMENT_PATH."/{$row['project_id']}/$bugid-{$att['file_name']}")) {
+ if (is_readable(INSTALL_PATH.'/'.ATTACHMENT_PATH."/{$row['project_id']}/$bugid-{$att['file_name']}")) {
$action = "<a href='attachment.php?attachid={$att['attachment_id']}'>View</a>";
if ($perm->have_perm('Administrator')) {
$action .= " | <a href='attachment.php?del={$att['attachment_id']}' onClick=\"return confirm('Are you sure you want to delete this attachment?');\">Delete</a>";
@@ -524,7 +524,7 @@
'attdesc' => stripslashes($att['description']),
'attsize' => $attsize,
'atttype' => $att['mime_type'],
- 'attdate' => date(DATEFORMAT, $att['created_date']),
+ 'attdate' => date(DATE_FORMAT, $att['created_date']),
'attaction' => $action
));
$t->parse('attrows', 'attrow', true);
@@ -550,8 +550,8 @@
'rdescription' => nl2br(format_comments(
htmlspecialchars($row['comment_text']))),
'rreporter' => maskemail($row['login']),
- 'rcreateddate' => date(TIMEFORMAT,$row['created_date']).' on '.
- date(DATEFORMAT,$row['created_date'])
+ 'rcreateddate' => date(TIME_FORMAT,$row['created_date']).' on '.
+ date(DATE_FORMAT,$row['created_date'])
));
$t->parse('rows','row',true);
}
@@ -583,7 +583,7 @@
'id' => $row['project_id'],
'name' => $row['project_name'],
'description' => $row['project_desc'],
- 'date' => date(DATEFORMAT,$row['created_date'])
+ 'date' => date(DATE_FORMAT,$row['created_date'])
));
$t->parse('rows','row',true);
}
Index: config.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/config.php,v
retrieving revision 1.12
retrieving revision 1.13
diff -u -r1.12 -r1.13
--- config.php 2001/09/29 14:50:26 1.12
+++ config.php 2001/10/12 04:19:31 1.13
@@ -22,41 +22,15 @@
// ------------------------------------------------------------------------
// $Id$
-define ('INSTALLPATH', '/home/bcurtis/public_html/phpbt');
-define ('INSTALLURL', 'http://localhost/~bcurtis/phpbt');
+define ('PHPLIB_PATH', ''); // If PHPlib is not in your include path
-define ('PHPLIBPATH', ''); // If not in the include path
-define ('JPGRAPH_PATH', ''); // If not in the include path
-
-// Location of your cvs web interface (see format_comments() in bug.php)
-define ('CVS_WEB', 'http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/phpbt/phpbt/');
-
// Database Config
-define ('DB_TYPE', 'mysql'); //using PHPlib file naming
+define ('DB_TYPE', 'mysql'); // using PHPlib file naming
define ('DB_HOST', 'localhost');
define ('DB_DATABASE', 'BugTracker');
define ('DB_USER', 'root');
define ('DB_PASSWORD', '');
-define ('ADMINEMAIL', 'ph...@be...');
-define ('ENCRYPTPASS', 0); // Whether to store passwords encrypted
-define ('THEME', 'default/'); // Which set of templates to use
-define ('USE_JPGRAPH', 0); // Whether to show images or not
-define ('MASK_EMAIL', 1); // Should email addresses be plainly visible?
-define ('HIDE_EMAIL', 1); // Should email addresses be hidden for those not logged in?
-// Should the query list use the severity colors as the row background color (like SourceForge)
-define ('USE_SEVERITY_COLOR', 1);
-define ('EMAIL_IS_LOGIN', 1); // Whether to use email addresses as logins
-
-// Sub-dir of the INSTALLPATH - Needs to be writeable by the web process
-define ('ATTACHMENT_PATH', 'attachments');
-// Maximum size (in bytes) of an attachment
-// This will not override the settings in php.ini if php.ini has a lower limit
-define ('ATTACHMENT_MAX_SIZE', 2097152);
-define ('ONEDAY', 86400);
-define ('DATEFORMAT', 'm-d-Y');
-define ('TIMEFORMAT', 'g:i A');
-
// Database Table Config
// you can change either the prefix of the table names or each table name individually
define ('TBL_PREFIX', ''); // the prefix for all tables, leave empty to use the old style
@@ -82,15 +56,14 @@
define ('TBL_VERSION', TBL_PREFIX.'version');
define ('TBL_PROJECT_GROUP', TBL_PREFIX.'project_group');
-require_once (PHPLIBPATH.'db_'.DB_TYPE.'.inc');
-require_once (PHPLIBPATH.'ct_sql.inc');
-require_once (PHPLIBPATH.'session.inc');
-require_once (PHPLIBPATH.'auth.inc');
-require_once (PHPLIBPATH.'perm.inc');
-require_once (PHPLIBPATH.'page.inc');
-require_once (PHPLIBPATH.'template.inc');
+define ('ONEDAY', 86400);
-// Localization - include the file with the desired language
-include INSTALLPATH.'/languages/en.php';
+require_once (PHPLIB_PATH.'db_'.DB_TYPE.'.inc');
+require_once (PHPLIB_PATH.'ct_sql.inc');
+require_once (PHPLIB_PATH.'session.inc');
+require_once (PHPLIB_PATH.'auth.inc');
+require_once (PHPLIB_PATH.'perm.inc');
+require_once (PHPLIB_PATH.'page.inc');
+require_once (PHPLIB_PATH.'template.inc');
?>
Index: include.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/include.php,v
retrieving revision 1.60
retrieving revision 1.61
diff -u -r1.60 -r1.61
--- include.php 2001/10/11 14:28:37 1.60
+++ include.php 2001/10/12 04:19:31 1.61
@@ -22,11 +22,11 @@
// ------------------------------------------------------------------------
// $Id$
-if (defined("INCLUDE_PATH")) {
- require INCLUDE_PATH."config.php";
-} else {
- require "config.php";
+define ('INSTALL_PATH', dirname($HTTP_SERVER_VARS['SCRIPT_FILENAME']));
+if (!defined('INCLUDE_PATH')) {
+ define('INCLUDE_PATH', '');
}
+require (INSTALL_PATH.'/'.INCLUDE_PATH.'config.php');
// Edit this class with your database information
class dbclass extends DB_Sql {
@@ -49,7 +49,16 @@
}
$q = new dbclass;
-$cssfile = 'global.css';
+
+// Set up the configuration variables
+$q->query("select varname, varvalue from configuration");
+while (list($k, $v) = $q->grab()) {
+ define($k, $v);
+}
+
+// Localization - include the file with the desired language
+include INSTALL_PATH.'/'.INCLUDE_PATH.'languages/'.LANGUAGE.'.php';
+
$me = $HTTP_SERVER_VARS['PHP_SELF'];
$me2 = $HTTP_SERVER_VARS['REQUEST_URI'];
$selrange = 30;
@@ -106,7 +115,7 @@
function auth_loginform() {
global $sess;
- include 'templates/'.THEME.'login.html';
+ include 'templates/'.THEME.'/login.html';
}
@@ -115,7 +124,7 @@
if (!$username) return 'nobody';
$this->auth['uname'] = $username;
- if (ENCRYPTPASS) {
+ if (ENCRYPT_PASS) {
$password = md5($password);
}
$u = $q->grab("select * from ".TBL_AUTH_USER." where login = '$username' and password = '$password' and active > 0");
@@ -245,10 +254,10 @@
}
}
-if (defined('INCLUDE_PATH')) {
- $t = new templateclass(INCLUDE_PATH.'templates/'.THEME.'admin', 'keep');
+if (INCLUDE_PATH == '../') {
+ $t = new templateclass(INCLUDE_PATH.'templates/'.THEME.'/admin', 'keep');
} else {
- $t = new templateclass('templates/'.THEME, 'keep');
+ $t = new templateclass('templates/'.THEME.'/', 'keep');
}
$t->set_var(array(
@@ -256,7 +265,6 @@
'me' => $me,
'me2' => $me2,
'error' => '',
- 'cssfile' => $cssfile,
'loginerror' => '',
'template_path' => INCLUDE_PATH.'templates/'.THEME));
@@ -512,13 +520,13 @@
'loginerror' => 'Invalid login<br>'
));
} else {
- if (ENCRYPTPASS) {
+ if (ENCRYPT_PASS) {
$password = genpassword(10);
$mpassword = md5($password);
$q->query("update ".TBL_AUTH_USER." set password = '$mpassword' where login = '$username'");
}
mail($email, $STRING['newacctsubject'], sprintf($STRING['newacctmessage'],
- $password), sprintf("From: %s\nContent-Type: text/plain; charset=%s\nContent-Transfer-Encoding: 8bit\n",ADMINEMAIL, $STRING['lang_charset']));
+ $password), sprintf("From: %s\nContent-Type: text/plain; charset=%s\nContent-Transfer-Encoding: 8bit\n",ADMIN_EMAIL, $STRING['lang_charset']));
$t->set_var(array(
'loginerrorcolor' => '#0000ff',
'loginerror' => 'Your password has been emailed to you<br>'
Index: newaccount.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/newaccount.php,v
retrieving revision 1.17
retrieving revision 1.18
diff -u -r1.17 -r1.18
--- newaccount.php 2001/10/02 23:19:42 1.17
+++ newaccount.php 2001/10/12 04:19:31 1.18
@@ -40,7 +40,7 @@
$firstname = htmlspecialchars($firstname);
$lastname = htmlspecialchars($lastname);
$password = genpassword(10);
- if (ENCRYPTPASS) {
+ if (ENCRYPT_PASS) {
$mpassword = md5($password);
} else {
$mpassword = $password;
@@ -52,7 +52,7 @@
$q->query("insert into ".TBL_USER_GROUP." (user_id, group_id)"
." select $user_id, group_id from ".TBL_AUTH_GROUP." where group_name = 'user'");
mail($email, $STRING['newacctsubject'], sprintf($STRING['newacctmessage'],
- $password), sprintf("From: %s\nContent-Type: text/plain; charset=%s\nContent-Transfer-Encoding: 8bit\n",ADMINEMAIL, $STRING['lang_charset']));
+ $password), sprintf("From: %s\nContent-Type: text/plain; charset=%s\nContent-Transfer-Encoding: 8bit\n",ADMIN_EMAIL, $STRING['lang_charset']));
$t->set_file('content','newaccountsuccess.html');
}
Index: query.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/query.php,v
retrieving revision 1.31
retrieving revision 1.32
diff -u -r1.31 -r1.32
--- query.php 2001/10/06 03:56:33 1.31
+++ query.php 2001/10/12 04:19:31 1.32
@@ -263,7 +263,7 @@
case 'created_date' :
case 'last_modified_date' :
case 'close_date' :
- $coldata = $row[$field] ? date(DATEFORMAT, $row[$field]) : ' ';
+ $coldata = $row[$field] ? date(DATE_FORMAT, $row[$field]) : ' ';
$td_extra = 'class="center"';
break;
case 'bug_id' :
Index: user.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/user.php,v
retrieving revision 1.15
retrieving revision 1.16
diff -u -r1.15 -r1.16
--- user.php 2001/09/18 03:36:33 1.15
+++ user.php 2001/10/12 04:19:31 1.16
@@ -44,7 +44,7 @@
return;
}
- if (ENCRYPTPASS) {
+ if (ENCRYPT_PASS) {
$mpassword = md5($pass1);
} else {
$mpassword = $pass1;
|
|
From: Benjamin C. <bc...@us...> - 2001-10-12 04:18:04
|
Update of /cvsroot/phpbt/phpbt In directory usw-pr-cvs1:/tmp/cvs-serv4202 Modified Files: CHANGELOG Log Message: Index: CHANGELOG =================================================================== RCS file: /cvsroot/phpbt/phpbt/CHANGELOG,v retrieving revision 1.18 retrieving revision 1.19 diff -u -r1.18 -r1.19 --- CHANGELOG 2001/10/03 03:29:33 1.18 +++ CHANGELOG 2001/10/12 04:18:01 1.19 @@ -1,3 +1,10 @@ +-- 0.4.0 -- Oct 2001 +: Fixed a bug with the Features section of the configure script. +: Improved the CSS file to make choosing different color schemes easier. +: Consolidated the two separate templates directories into one tree. +: Fixed a bug with the OS table creation. +: Moved configuration information to the database. + -- 0.3.3 -- 2 Oct 2001 : Added the ability to enter cvs:filename.ext or cvs:path/filename.ext:v.vv into the bug comments and have that linked to a CVS web interface. |
|
From: Ben C. <php...@be...> - 2001-10-11 14:46:58
|
For the Features sub menu I changed it from read choice <$tempfile to choice=`cat $tempfile` because read was only grabbing the first line and losing the rest of the options. Please let me know whether this works for you. On Tue, Sep 25, 2001 at 05:56:23PM +0200, Patrick Mairif wrote: > Hi, > > I think the problem is this line: > > choice=`<$tempfile` > > choice is then empty. > when I replace it with > > read choice <$tempfile > > it works better. > > patrick! > > -- > http://home.nikocity.de/mairif > http://caravan-network.de > ICQ# 96716515 > > _______________________________________________ > phpbt-dev mailing list > php...@li... > https://lists.sourceforge.net/lists/listinfo/phpbt-dev |
|
From: Benjamin C. <bc...@us...> - 2001-10-11 14:45:39
|
Update of /cvsroot/phpbt/phpbt
In directory usw-pr-cvs1:/tmp/cvs-serv7865
Modified Files:
configure
Log Message:
read doesn't grab all the values, thus the options are lost
Index: configure
===================================================================
RCS file: /cvsroot/phpbt/phpbt/configure,v
retrieving revision 1.14
retrieving revision 1.15
diff -u -r1.14 -r1.15
--- configure 2001/09/26 14:20:37 1.14
+++ configure 2001/10/11 14:45:36 1.15
@@ -182,7 +182,7 @@
retval=$?
- read choice <$tempfile
+ choice=`cat $tempfile`
if [ $retval -eq 0 ]; then
for selected in $choice
do
|
|
From: Benjamin C. <bc...@us...> - 2001-10-11 14:28:40
|
Update of /cvsroot/phpbt/phpbt
In directory usw-pr-cvs1:/tmp/cvs-serv1995
Modified Files:
include.php
Log Message:
Slight bug in the {template_path} token
Index: include.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/include.php,v
retrieving revision 1.59
retrieving revision 1.60
diff -u -r1.59 -r1.60
--- include.php 2001/10/11 14:24:03 1.59
+++ include.php 2001/10/11 14:28:37 1.60
@@ -258,7 +258,7 @@
'error' => '',
'cssfile' => $cssfile,
'loginerror' => '',
- 'template_path' => 'templates/'.THEME));
+ 'template_path' => INCLUDE_PATH.'templates/'.THEME));
// End classes -- Begin helper functions
|
|
From: Benjamin C. <bc...@us...> - 2001-10-11 14:24:08
|
Update of /cvsroot/phpbt/phpbt/templates/default/admin
In directory usw-pr-cvs1:/tmp/cvs-serv514/templates/default/admin
Added Files:
badperm.html login.html oslist.html project-add.html
project-edit.html projectlist.html resolutionlist.html
severitylist.html statuslist.html userlist.html wrap.html
Log Message:
Moved admin templates to a subdir of the templates dir. Changed wraps to use css.php instead of global.css
--- NEW FILE: badperm.html ---
<table border="0" width="640">
<tr>
<td align="center">
<font color="#ff0000">
You do not have the permissions required for that function
</font>
</td>
</tr>
</table>
--- NEW FILE: login.html ---
<?php
global $formvars;
if (!$formvars) {
$formvars = htmlentities(serialize($GLOBALS[HTTP_POST_VARS]));
}
?>
<html>
<head>
<title>phpBT Admin</title>
<!--<link rel="StyleSheet" href="/siteadmin.css" type="text/css">-->
<style>
td { font-family: "Verdana","Tahoma","Arial","Helvetica","Times";
color: rgb(0,0,0);
font-size: 9px; }
</style>
</head>
<body bgcolor="#ffffff" text="#000000" link="#004433" alink="#004433" vlink="#004433">
<center>
<br>
<br>
<br>
<div align='center'><b>Admin Login</b></div>
<br>
<form action='<?php print $GLOBALS[REQUEST_URI] ?>' method='post'>
<input type="hidden" name="formvars" value="<?php echo $formvars ?>">
<table border="0">
<?php global $username; if ( isset($username) ): ?>
<tr>
<td align='center'>
<font color=red>
<b>Invalid login and/or password</b>
</font>
</td>
</tr>
<?php endif ?>
<tr>
<td>Login:</td>
</tr>
<tr>
<td><input size="30" name='username' value='<?php if (isset($this->auth["uname"])) print $this->auth["uname"] ?>'></td>
</tr>
<tr>
<td>Password:</td>
</tr>
<tr>
<td><input size="30" type='password' name='password'></td>
</tr>
<tr>
<td align="right"><input type="submit" value="Go"></td>
</tr>
<tr>
<td><hr size="1" color="#000000" width="140"></td>
</tr>
</table>
</form>
</center>
</body>
<script language="JavaScript">
<!--
if (document.forms[0][0].value != '') {
document.forms[0][1].focus();
} else {
document.forms[0][0].focus();
}
// -->
</script>
</html>
--- NEW FILE: oslist.html ---
<br>
<table border="0" width="640">
<tr>
<td valign="top">
<b> OS List</b>
<hr size="1">
<table border="0">
<tr bgcolor="#eeeeee">
<th><a href="{nameurl}">Name</a></th>
<th><a href="{regexurl}">Regex</a></th>
<th><a href="{sortorderurl}">Sort Order</a></th>
</tr>
<!-- BEGIN row -->
<tr class="{trclass}">
<td><a href="{me}?op=edit&id={osid}">{name}</a></td>
<td> {regex}</td>
<td align="center">{sortorder}</td>
</tr>
<!-- END row -->
</table>
</td>
<td valign="top">
<div align="right"><b>{action} OS </b></div>
<hr size="1">
<form action="{me}" method="post">
<input type="hidden" name="id" value="{fosid}">
<table border='0'>
<tr>
<td colspan="2" align="center" valign="top">
<font color="#ff0000">{error}</font>
</td>
</tr>
<tr>
<td align="right" valign="top">Name:</td>
<td><input type="text" size="20" maxlength="40" name="fname" value="{fname}"></td>
</tr>
<tr>
<td align="right" valign="top">Regex:</td>
<td><input type="text" size="20" maxlength="40" name="fregex" value="{fregex}"></td>
</tr>
<tr>
<td align="right" valign="top">Sort Order:</td>
<td><input type="text" size="3" maxlength="3" name="fsortorder" value="{fsortorder}"></td>
</tr>
</table>
<div align="right">
<input type='submit' name='submit' value='Submit'>
</div>
</form>
</td>
</table>
--- NEW FILE: project-add.html ---
<form action="project.php" method="post">
<input type="hidden" name="id" value="{projectid}">
<input type="hidden" name="do" value="project">
<table border="0">
<tr>
<td valign="top" rowspan="2" width="320">
<table border="0">
<tr>
<td>
<b>Project Information</b>
<hr size="1">
<font color="#ff0000">{error}</font>
</td>
</tr>
<tr>
<td valign="top">
Name:
<br>
<input type="text" size="30" maxlength="30" name="name" value="{name}">
</td>
</tr>
<tr>
<td valign="top">
Description:
<br>
<textarea name="description" cols=40 rows=5 wrap=virtual>{description}</textarea>
</td>
</tr>
<tr>
<td valign="top">
Active:
<br>
<input type="checkbox" name="active" value="1" {active}>
</td>
</tr>
</table>
</td>
<td width="320">
<table border="0">
<tr>
<td>
<b>Version Information</b>
<hr size="1">
<font color="#ff0000">{vf_error}</font>
</td>
</tr>
<tr>
<td valign="top">
Initial Version:
<br>
<input type="text" size="30" maxlength="30" name="vf_version" value="{vf_version}">
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td>
<table border="0">
<tr>
<td>
<b>Component Information</b>
<hr size="1">
<font color="#ff0000">{cf_error}</font>
</td>
</tr>
<tr>
<td valign="top">
Initial Component Name:
<br>
<input type="text" size="30" maxlength="30" name="cf_name" value="{cf_name}">
</td>
</tr>
<tr>
<td valign="top">
Description:
<br>
<textarea name="cf_description" cols="30">{cf_description}</textarea>
</td>
</tr>
<tr>
<td valign="top">
Owner:
<br>
<select name="cf_owner"><option value="0">None</option>{cf_owner}</select>
</td>
</tr>
</table>
</td>
</tr>
</table>
<input type='submit' name='submit' value='Submit'>
</form>
--- NEW FILE: project-edit.html ---
<form action="project.php" method="post">
<input type="hidden" name="id" value="{projectid}">
<input type="hidden" name="do" value="project">
<table border='0'>
<tr>
<td colspan="2"><font color="#ff0000">{error}</td>
</tr>
<tr>
<td align="right" valign="top">Name:</td>
<td><input type="text" size="30" maxlength="30" name="name" value="{name}"></td>
</tr>
<tr>
<td align="right" valign="top">Description:</td>
<td><textarea name="description" cols=40 rows=5 wrap=virtual>{description}</textarea></td>
</tr>
<tr>
<td align="right" valign="top">Active:</td>
<td align="left" valign="top"><input type="checkbox" name="active" value="1" {active}></td>
</tr>
</table>
<input type='submit' name='submit' value='Submit'>
</form>
<br>
<table border="0">
<tr>
<td width="320" valign="top">
<b>{vf_action} Version</b>
<hr width="320" size="1" align="center">
<font color="#ff0000">{vf_error}</font>
<table border="0">
<form action="{me}" method="post">
<input type="hidden" name="do" value="version">
<input type="hidden" name="versionid" value="{versionid}">
<input type="hidden" name="projectid" value="{projectid}">
<tr>
<td width="200">Version:</td>
<td width="120">Active:</td>
</tr>
<tr>
<td><input type="text" name="vf_version" value="{vf_version}"></td>
<td><input type="checkbox" name="vf_active" value="1" {vf_active}></td>
</tr>
<tr>
<td colspan="2" align="right">
<input type="submit" value="{vf_action} Version">
</td>
</tr>
<tr>
</form>
</table>
</td>
<td width="320" valign="top">
<b>{cf_action} Component</b>
<hr width="320" size="1" align="center">
<font color="#ff0000">{cf_error}</font>
<table border="0">
<form action="{me}" method="post">
<input type="hidden" name="do" value="component">
<input type="hidden" name="componentid" value="{componentid}">
<input type="hidden" name="projectid" value="{projectid}">
<tr>
<td width="200">Name:</td>
<td width="120">Active:</td>
</tr>
<tr>
<td><input type="text" name="cf_name" value="{cf_name}"></td>
<td><input type="checkbox" name="cf_active" value="1" {cf_active}></td>
</tr>
<tr>
<td colspan="2">
Description:
<br>
<textarea name="cf_description" cols="40">{cf_description}</textarea>
</td>
</tr>
<tr>
<td colspan="2">
Owner:
<br>
<select name="cf_owner"><option value="0">None</option>{cf_owner}</select>
</td>
</tr>
<tr>
<td colspan="2" align="right">
<input type="submit" value="{cf_action} Component">
</td>
</tr>
<tr>
</form>
</table>
</td>
</tr>
<tr>
<td width="320" valign="top">
<br>
<b>Versions of {name}</b>
<hr width="320" size="1" align="center">
<table border="0">
<tr bgcolor="#eeeeee">
<th width="160">Version</th>
<th width="100">Created</th>
<th width="60">Active</th>
</tr>
<!-- BEGIN verrow -->
<tr class="{trclass}">
<td><a href="{me}?op=edit&id={projectid}&versionid={verid}">{vername}</a></td>
<td align="center">{verdate}</td>
<td align="center">{veractive}</td>
</tr>
<!-- END verrow -->
</table>
</td>
<td width="320" valign="top">
<br>
<b>Components of {name}</b>
<hr width="320" size="1" align="center">
<table border="0">
<tr bgcolor="#eeeeee">
<th width="160">Component</th>
<th width="100">Created</th>
<th width="60">Active</th>
</tr>
<!-- BEGIN row -->
<tr class="{trclass}">
<td><a href="{me}?op=edit&id={projectid}&componentid={compid}">{compname}</a></td>
<td align="center">{compdate}</td>
<td align="center">{compactive}</td>
</tr>
<!-- END row -->
</table>
</td>
</tr>
</table>
--- NEW FILE: projectlist.html ---
<a href="{me}?op=add">Add a new project</a>
<br>
<br>
<table border="0">
<tr bgcolor="#eeeeee">
<th><a href="{nameurl}">Project</a></th>
<th><a href="{createddateurl}">Created</a></th>
<th><a href="{activeurl}">Active</a></th>
</tr>
<!-- BEGIN row -->
<tr class='{trclass}'>
<td><a href="{me}?op=edit&id={projectid}">{name}</a></td>
<td align="center">{createddate}</td>
<td align="center">{active}</td>
</tr>
<!-- END row -->
</table>
--- NEW FILE: resolutionlist.html ---
<br>
<table border="0" width="640">
<tr>
<td valign="top">
<b> Resolution List</b>
<hr size="1">
<table border="0">
<tr bgcolor="#eeeeee">
<th><a href="{nameurl}">Name</a></th>
<th><a href="{descriptionurl}">Description</a></th>
<th><a href="{sortorderurl}">Sort Order</a></th>
</tr>
<!-- BEGIN row -->
<tr class="{trclass}">
<td><a href="{me}?op=edit&id={resolutionid}">{name}</a></td>
<td> {description}</td>
<td align="center">{sortorder}</td>
</tr>
<!-- END row -->
</table>
</td>
<td valign="top">
<div align="right"><b>{action} resolution </b></div>
<hr size="1">
<form action="{me}" method="post">
<input type="hidden" name="id" value="{fresolutionid}">
<table border='0'>
<tr>
<td colspan="2" align="center" valign="top">
<font color="#ff0000">{error}</font>
</td>
</tr>
<tr>
<td align="right" valign="top">Name:</td>
<td><input type="text" size="20" maxlength="40" name="fname" value="{fname}"></td>
</tr>
<tr>
<td align="right" valign="top">Description:</td>
<td><textarea name="fdescription" cols=20 rows=5 wrap=virtual>{fdescription}</textarea></td>
</tr>
<tr>
<td align="right" valign="top">Sort Order:</td>
<td><input type="text" size="3" maxlength="3" name="fsortorder" value="{fsortorder}"></td>
</tr>
</table>
<div align="right">
<input type='submit' name='submit' value='Submit'>
</div>
</form>
</td>
</table>
--- NEW FILE: severitylist.html ---
<br>
<table border="0" width="640">
<tr>
<td valign="top">
<b> Status List</b>
<hr size="1">
<table border="0">
<tr>
<th><a href="{nameurl}">Name</a></th>
<th><a href="{descriptionurl}">Description</a></th>
<th><a href="{sortorderurl}">Sort Order</a></th>
</tr>
<!-- BEGIN row -->
<tr class="{trclass}" bgcolor="{bgcolor}">
<td><a href="{me}?op=edit&id={severityid}">{name}</a></td>
<td> {description}</td>
<td align="center">{sortorder}</td>
</tr>
<!-- END row -->
</table>
</td>
<td valign="top">
<div align="right"><b>{action} severity </b></div>
<hr size="1">
<form action="{me}" method="post">
<input type="hidden" name="id" value="{fseverityid}">
<table border='0'>
<tr>
<td colspan="2" align="center" valign="top">
<font color="#ff0000">{error}</font>
</td>
</tr>
<tr>
<td align="right" valign="top">Name:</td>
<td><input type="text" size="20" maxlength="40" name="fname" value="{fname}"></td>
</tr>
<tr>
<td align="right" valign="top">Description:</td>
<td><textarea name="fdescription" cols=20 rows=5 wrap=virtual>{fdescription}</textarea></td>
</tr>
<tr>
<td align="right" valign="top">Sort Order:</td>
<td><input type="text" size="3" maxlength="3" name="fsortorder" value="{fsortorder}"></td>
</tr>
<tr>
<td align="right" valign="top">Row Color:</td>
<td><input type="text" size="11" maxlength="10" name="fcolor" value="{fcolor}"></td>
</tr>
</table>
<div align="right">
<input type='submit' name='submit' value='Submit'>
</div>
</form>
</td>
</table>
--- NEW FILE: statuslist.html ---
<br>
<table border="0" width="640">
<tr>
<td valign="top">
<b> Status List</b>
<hr size="1">
<table border="0">
<tr bgcolor="#eeeeee">
<th><a href="{nameurl}">Name</a></th>
<th><a href="{descriptionurl}">Description</a></th>
<th><a href="{sortorderurl}">Sort Order</a></th>
</tr>
<!-- BEGIN row -->
<tr class="{trclass}">
<td><a href="{me}?op=edit&id={statusid}">{name}</a></td>
<td> {description}</td>
<td align="center">{sortorder}</td>
</tr>
<!-- END row -->
</table>
</td>
<td valign="top">
<div align="right"><b>{action} status </b></div>
<hr size="1">
<form action="{me}" method="post">
<input type="hidden" name="id" value="{fstatusid}">
<table border='0'>
<tr>
<td colspan="2" align="center" valign="top">
<font color="#ff0000">{error}</font>
</td>
</tr>
<tr>
<td align="right" valign="top">Name:</td>
<td><input type="text" size="20" maxlength="40" name="fname" value="{fname}"></td>
</tr>
<tr>
<td align="right" valign="top">Description:</td>
<td><textarea name="fdescription" cols=20 rows=5 wrap=virtual>{fdescription}</textarea></td>
</tr>
<tr>
<td align="right" valign="top">Sort Order:</td>
<td><input type="text" size="3" maxlength="3" name="fsortorder" value="{fsortorder}"></td>
</tr>
</table>
<div align="right">
<input type='submit' name='submit' value='Submit'>
</div>
</form>
</td>
</table>
--- NEW FILE: userlist.html ---
<!--<a href="{me}?op=add">Add a new user</a>-->
<br>
<table border="0">
<tr>
<td valign="top">
<b> User List</b>
<hr size="1">
<table border="0">
<tr>
<th bgcolor="{logincolor}"><a href="{loginurl}">Login</a></th>
<th bgcolor="{namecolor}"><a href="{nameurl}">Name</a></th>
<th bgcolor="{datecolor}"><a href="{dateurl}">Created</a></th>
<th bgcolor="{activecolor}"><a href="{activeurl}">Active</a></th>
</tr>
<!-- BEGIN row -->
<tr class="{trclass}">
<td><a href="{me}?op=edit&id={userid}">{login}</a></td>
<td align="center">{name}</td>
<td align="center">{date}</td>
<td align="center">{active}</td>
</tr>
<!-- END row -->
<tr>
<td colspan="4" align="center">
<br>
{first} to {last} of {records}
<br>
{pages}
</td>
</tr>
</table>
</td>
<td valign="top">
<div align="right"><b>{action} user </b></div>
<hr size="1">
<form action="user.php" method="post">
<input type="hidden" name="id" value="{fuserid}">
<table border='0'>
<tr>
<td colspan="2" align="center" valign="top">
<font color="#ff0000">{error}</font>
</td>
</tr>
<!-- BEGIN loginentryarea -->
<tr>
<td align="right" valign="top">Login:</td>
<td><input type="text" size="20" maxlength="40" name="flogin" value="{flogin}"></td>
</tr>
<!-- END loginentryarea -->
<tr>
<td align="right" valign="top">Email:</td>
<td><input type="text" size="20" maxlength="40" name="femail" value="{femail}"></td>
</tr>
<tr>
<td align="right" valign="top">FirstName:</td>
<td><input type="text" size="20" maxlength="40" name="ffirstname" value="{ffirstname}"></td>
</tr>
<tr>
<td align="right" valign="top">LastName:</td>
<td><input type="text" size="20" maxlength="40" name="flastname" value="{flastname}"></td>
</tr>
<tr>
<td align="right" valign="top">Password:</td>
<td><input type="text" size="20" maxlength="40" name="fpassword" value="{fpassword}"></td>
</tr>
<tr>
<td align="right" valign="top">User Group:</td>
<td>
<select name="fusergroup[]" size="3" multiple>
{fusergroup}
</select>
</td>
</tr>
<tr>
<td align="right" valign="top">Active:</td>
<td><input type="checkbox" name="factive" value="1" {factive}></td>
</tr>
</table>
<div align="right">
<input type='submit' name='submit' value='Submit'>
</div>
</form>
</td>
</table>
--- NEW FILE: wrap.html ---
<html>
<head>
<META HTTP-EQUIV="Expires" CONTENT="-1">
<title>phpBugTracker Admin - {TITLE}</title>
<link rel="StyleSheet" href="../css.php" type="text/css">
</head>
<body bgcolor="#ffffff" link="#006699" vlink="#006699" alink="#006699">
<table border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="640" colspan="2"><hr size="1" width="640"></td>
</tr>
<tr>
<td width="540">
<font class="navfont"><b>
[
<a href="project.php">Projects</a> |
<a href="user.php">Users</a> |
<a href="status.php">Statuses</a> |
<a href="resolution.php">Resolutions</a> |
<a href="severity.php">Severity</a> |
<a href="os.php">OSes</a>
]
</b></font>
</td>
<td width="100" align="right">
<font class="navfont"><b>
[
<a href="../index.php">User Tools</a>
]
</font>
</td>
</tr>
<tr>
<td width="640" colspan="2"><hr size="1" width="640"></td>
</tr>
</table>
{content}
<table border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="640"><hr size="1" width="640"></td>
</tr>
<tr>
<!-- BEGIN loginblock -->
<td class="login-box">
<form method="post" action="{me2}">
<font color="{loginerrorcolor}"><b>{loginerror}<b></font>
Email: <input type="text" name="username" class="login-box">
Password: <input type="password" name="password" class="login-box">
<!--<input type="image" border="0" name="login" value="doit" src="go.gif" width="30" height="20" align="middle" class="login-button">-->
<input type="hidden" name="login" value="1">
<input type="submit" value="Login" class="login-box">
<input type="submit" name="sendpass" value="Email Password" class="login-box" title="Forgot your password? Have it sent to you">
</form>
</td>
<!-- END loginblock -->
<!-- BEGIN logoutblock -->
<td>
<font class="navfont"><b>
[ Bugs assigned to me: <a href="../query.php?op=mybugs&assignedto=1&open=1" title="Open">{owner_open}</a> / <a href="query.php?op=mybugs&assignedto=1&open=0" title="Closed">{owner_closed}</a>
| Bugs reported by me: <a href="../query.php?op=mybugs&reportedby=1&open=1" title="Open">{reporter_open}</a> / <a href="query.php?op=mybugs&reportedby=1&open=0" title="Closed">{reporter_closed}</a>
| <a href="../user.php">Personal Page</a>
| <a href="../logout.php">Logout {loggedinas}</a>
]
</b></font>
</td>
<!-- END logoutblock -->
</tr>
</table>
<!-- BEGIN adminnavblock -->
<!-- END adminnavblock -->
</body>
</html>
|
2 messages has been excluded from this view by a project administrator.
