phpbt-dev — Developer's mailing list and cvs commits

Re: [phpBT-dev] Assigned To list

[<php...@be...>]

It would be great to have a feature where by project you could select
the users to be included in the "assigned to" list.  I'd be happy to
accept a patch for that. :)  Alternatively, you can file a feature
request at the sourceforge site.

Phpbt is still under development, though my time commitment to it for
the last few months has been almost non-existent.  The roadmap is indeed
out of date, but I am actually still planning on making a 1.0 release
within the decade. :)

On Wed, Mar 17, 2004 at 01:15:18PM -0500, Cliff Brake wrote:
> I am using phpbt 0.9.1 with great success -- thanks for a wonderful product.
> 
> In the past, I have been using it in a single customer/project senario, but 
> would now like to expand to using one install for multiple 
> customers/projects.  This seems to work well as I can use groups to give 
> users access to only the project they need.  However, when I click on the 
> "Assigned To:" field when editting a bug, all developers are listed even if 
> they don't have access to the project.  Is there a fix for this?  If not I 
> will probably look into making the change and will summit it back if this is 
> the desired bahavior.
> 
> Has anyone used phpbugtracker in a multiple customer senario where you don't 
> want one customer to see another's project/developers?
> 
> Also, is phpbt still under development?  The roadmap seems a little out of 
> date.
> 
> Thanks,
> Cliff
> 
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by: IBM Linux Tutorials
> Free Linux tutorial presented by Daniel Robbins, President and CEO of
> GenToo technologies. Learn everything from fundamentals to system
> administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
> _______________________________________________
> phpbt-dev mailing list
> php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpbt-dev

[phpBT-dev] CVS: phpbt/inc functions.php,1.45,1.46

[Ken T. <ke...@us...>]

Update of /cvsroot/phpbt/phpbt/inc
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv29302/phpbt/inc

Modified Files:
	functions.php 
Log Message:
mail() headers need to be \r\n, not just \n.


Index: functions.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/inc/functions.php,v
retrieving revision 1.45
retrieving revision 1.46
diff -u -r1.45 -r1.46
--- functions.php	12 Oct 2003 21:32:07 -0000	1.45
+++ functions.php	18 Mar 2004 22:48:32 -0000	1.46
@@ -553,9 +553,9 @@
         // There have to be no newline at the end of $headers
     }
 	if (false/*HTML_EMAIL*/) {
-		$headers .= "Content-Type: text/html; charset=\"".$STRING['lang_charset']."\"\nContent-Transfer-Encoding: ";
+		$headers .= "Content-Type: text/html; charset=\"".$STRING['lang_charset']."\"\r\nContent-Transfer-Encoding: ";
 	} else {
-		$headers .= "Content-Type: text/plain; charset=\"".$STRING['lang_charset']."\"\nContent-Transfer-Encoding: ";
+		$headers .= "Content-Type: text/plain; charset=\"".$STRING['lang_charset']."\"\r\nContent-Transfer-Encoding: ";
 	}
 
     // If configured to send MIME encoded emails

RE: [phpBT-dev] Assigned To list

[Jaanus K. <jaa...@ee...>]

> I am using phpbt 0.9.1 with great success -- thanks for a
> wonderful product.

same here - almost :)

> Has anyone used phpbugtracker in a multiple customer senario
> where you don't
> want one customer to see another's project/developers?

I have a similar requirement - I am using phpbt for development as well as
customer support tracking tool, and what I have in mind is that the content
of "Assigned to" field should be customizable across projects and
components. I.e. in project component admin there should be a field
specifying that "in case of this component, I only want people belonging to
this and that group to be visible in the Assigned to field". Currently it is
hardcoded so that all people with group "Developer" are listed.

> Also, is phpbt still under development?  The roadmap seems a
> little out of
> date.

Not sure about this - some cvs changes pop up now and then, but people like
you and me have a lot more ideas that should be included, so why not step
in.


rgds,
jaanus

[phpBT-dev] Assigned To list

[Cliff B. <cb...@ac...>]

I am using phpbt 0.9.1 with great success -- thanks for a wonderful product.

In the past, I have been using it in a single customer/project senario, but 
would now like to expand to using one install for multiple 
customers/projects.  This seems to work well as I can use groups to give 
users access to only the project they need.  However, when I click on the 
"Assigned To:" field when editting a bug, all developers are listed even if 
they don't have access to the project.  Is there a fix for this?  If not I 
will probably look into making the change and will summit it back if this is 
the desired bahavior.

Has anyone used phpbugtracker in a multiple customer senario where you don't 
want one customer to see another's project/developers?

Also, is phpbt still under development?  The roadmap seems a little out of 
date.

Thanks,
Cliff

[phpBT-dev] CVS: phpbt/templates/default queryform.html,1.20.4.1,1.20.4.2

[Benjamin C. <bc...@us...>]

Update of /cvsroot/phpbt/phpbt/templates/default
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv25195/templates/default

Modified Files:
      Tag: htmltemplates
	queryform.html 
Log Message:
Added date search functionality

Index: queryform.html
===================================================================
RCS file: /cvsroot/phpbt/phpbt/templates/default/queryform.html,v
retrieving revision 1.20.4.1
retrieving revision 1.20.4.2
diff -u -r1.20.4.1 -r1.20.4.2
--- queryform.html	30 Aug 2003 22:00:34 -0000	1.20.4.1
+++ queryform.html	29 Feb 2004 02:17:27 -0000	1.20.4.2
@@ -155,6 +155,15 @@
 		    <option value="rlike"><?php echo translate("regexp"); ?></option>
 		    <option value="not rlike"><?php echo translate("not regexp"); ?></option>
 	    </select></td>
+	</tr><tr>
+	<td align="right">
+		<?php echo translate("Created Date Range"); ?>:
+	</td>
+	<td colspan="2">
+		<input type="text" name="start_date" size="11"> 
+		<?php echo translate("to"); ?> 
+		<input type="text" name="end_date" size="11">
+	</td>
 	</tr>
     </table>
     <hr align="left" width="100%">

[phpBT-dev] CVS: phpbt query.php,1.98.2.2,1.98.2.3

[Benjamin C. <bc...@us...>]

Update of /cvsroot/phpbt/phpbt
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv25195

Modified Files:
      Tag: htmltemplates
	query.php 
Log Message:
Added date search functionality

Index: query.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/query.php,v
retrieving revision 1.98.2.2
retrieving revision 1.98.2.3
diff -u -r1.98.2.2 -r1.98.2.3
--- query.php	16 Sep 2003 11:39:33 -0000	1.98.2.2
+++ query.php	29 Feb 2004 02:17:26 -0000	1.98.2.3
@@ -109,6 +109,12 @@
 		if (!empty($flags)) {
 			$query[] = '('.@join(' and ',$flags).')';
 		}
+		if (!empty($start_date)) {
+			$query[] = 'b.created_date > '.strtotime($start_date);
+		}
+		if (!empty($end_date)) {
+			$query[] = 'b.created_date < '.strtotime($end_date);
+		}
 
 		// Email field(s)
 		if (!empty($email1)) {

[phpBT-dev] CVS: phpbt/templates/default queryform.html,1.20,1.20.2.1

[Benjamin C. <bc...@us...>]

Update of /cvsroot/phpbt/phpbt/templates/default
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv24410/templates/default

Modified Files:
      Tag: phpbt-1_0
	queryform.html 
Log Message:
Added date search functionality

Index: queryform.html
===================================================================
RCS file: /cvsroot/phpbt/phpbt/templates/default/queryform.html,v
retrieving revision 1.20
retrieving revision 1.20.2.1
diff -u -r1.20 -r1.20.2.1
--- queryform.html	11 Jun 2003 12:09:20 -0000	1.20
+++ queryform.html	29 Feb 2004 02:12:21 -0000	1.20.2.1
@@ -138,6 +138,15 @@
 		    <option value="rlike">{$STRING.QUERY.MatchingAs_Regexp}</option>
 		    <option value="not rlike">{$STRING.QUERY.MatchingAs_NotRegexp}</option>
 	    </select></td>
+	</tr><tr>
+	<td align="right">
+		Created Date Range:
+	</td>
+	<td colspan="2">
+		<input type="text" name="start_date" size="11"> 
+		to 
+		<input type="text" name="end_date" size="11">
+	</td>
 	</tr>
     </table>
     <hr align="left" width="100%">

[phpBT-dev] CVS: phpbt query.php,1.96.2.2,1.96.2.3

[Benjamin C. <bc...@us...>]

Update of /cvsroot/phpbt/phpbt
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv24410

Modified Files:
      Tag: phpbt-1_0
	query.php 
Log Message:
Added date search functionality

Index: query.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/query.php,v
retrieving revision 1.96.2.2
retrieving revision 1.96.2.3
diff -u -r1.96.2.2 -r1.96.2.3
--- query.php	25 Jul 2003 02:50:07 -0000	1.96.2.2
+++ query.php	29 Feb 2004 02:12:21 -0000	1.96.2.3
@@ -109,6 +109,12 @@
 		}
 		if (!empty($flags)) {
 			$query[] = '('.@join(' and ',$flags).')';
+		}		
+		if (!empty($start_date)) {
+			$query[] = 'b.created_date > '.strtotime($start_date);
+		}
+		if (!empty($end_date)) {
+			$query[] = 'b.created_date < '.strtotime($end_date);
 		}
 
 		// Email field(s)

[phpBT-dev] CVS: phpbt/inc/db mysql.php,1.18,1.18.2.1 oci8.php,1.15.4.1,1.15.4.2 pgsql.php,1.24,1.24.4.1

[Benjamin C. <bc...@us...>]

Update of /cvsroot/phpbt/phpbt/inc/db
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv11190/inc/db

Modified Files:
      Tag: htmltemplates
	mysql.php oci8.php pgsql.php 
Log Message:
Sort the history by created_date

Index: mysql.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/inc/db/mysql.php,v
retrieving revision 1.18
retrieving revision 1.18.2.1
diff -u -r1.18 -r1.18.2.1
--- mysql.php	24 Jul 2003 04:47:13 -0000	1.18
+++ mysql.php	25 Feb 2004 12:47:48 -0000	1.18.2.1
@@ -50,7 +50,7 @@
 	'bug-history' => 'select bh.*, login '.
 		'from '.TBL_BUG_HISTORY.' bh '.
 		'left join '. TBL_AUTH_USER.' on bh.created_by = user_id '.
-		'where bug_id = %s',
+		'where bug_id = %s order by bh.created_date',
 	'bug-cc-list' => 'select email '.
 		'from '.TBL_BUG_CC.' left join '. TBL_AUTH_USER.' u using(user_id), '.
 		TBL_USER_PREF.' p '.

Index: oci8.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/inc/db/oci8.php,v
retrieving revision 1.15.4.1
retrieving revision 1.15.4.2
diff -u -r1.15.4.1 -r1.15.4.2
--- oci8.php	25 Feb 2004 12:42:11 -0000	1.15.4.1
+++ oci8.php	25 Feb 2004 12:47:48 -0000	1.15.4.2
@@ -54,7 +54,7 @@
 		'and group_name <> \'User\'',
 	'bug-history' => 'select bh.*, login '.
 		'from '.TBL_BUG_HISTORY.' bh, '.TBL_AUTH_USER .
-		' where user_id = bh.created_by(+) and bug_id = %s',
+		' where user_id = bh.created_by(+) and bug_id = %s order by bh.created_date',
 	'bug-cc-list' => 'select email '.
 		'from '.TBL_BUG_CC.' bc, ' . TBL_AUTH_USER.' u, ' . TBL_USER_PREF.' p '.
 		'where u.user_id = bc.user_id(+) and u.user_id = p.user_id '.

Index: pgsql.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/inc/db/pgsql.php,v
retrieving revision 1.24
retrieving revision 1.24.4.1
diff -u -r1.24 -r1.24.4.1
--- pgsql.php	21 Jun 2003 13:36:30 -0000	1.24
+++ pgsql.php	25 Feb 2004 12:47:48 -0000	1.24.4.1
@@ -51,7 +51,7 @@
 	'bug-history' => 'select bh.*, login '.
 		'from '.TBL_BUG_HISTORY.' bh '.
 		'left join '. TBL_AUTH_USER.' on bh.created_by = user_id '.
-		'where bug_id = %s',
+		'where bug_id = %s order by bh.created_date',
 	'bug-cc-list' => 'select email '.
 		'from '.TBL_BUG_CC.' left join '. TBL_AUTH_USER.' u using(user_id), '.
 		TBL_USER_PREF.' p '.

[phpBT-dev] CVS: phpbt/inc/db mysql.php,1.17.2.1,1.17.2.2 oci8.php,1.15.2.1,1.15.2.2 pgsql.php,1.24,1.24.2.1

[Benjamin C. <bc...@us...>]

Update of /cvsroot/phpbt/phpbt/inc/db
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv11146/inc/db

Modified Files:
      Tag: phpbt-1_0
	mysql.php oci8.php pgsql.php 
Log Message:
Sort the history by created_date

Index: mysql.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/inc/db/mysql.php,v
retrieving revision 1.17.2.1
retrieving revision 1.17.2.2
diff -u -r1.17.2.1 -r1.17.2.2
--- mysql.php	25 Jul 2003 02:50:08 -0000	1.17.2.1
+++ mysql.php	25 Feb 2004 12:47:29 -0000	1.17.2.2
@@ -50,7 +50,7 @@
 	'bug-history' => 'select bh.*, login '.
 		'from '.TBL_BUG_HISTORY.' bh '.
 		'left join '. TBL_AUTH_USER.' on bh.created_by = user_id '.
-		'where bug_id = %s',
+		'where bug_id = %s order by bh.created_date',
 	'bug-cc-list' => 'select email '.
 		'from '.TBL_BUG_CC.' left join '. TBL_AUTH_USER.' u using(user_id), '.
 		TBL_USER_PREF.' p '.

Index: oci8.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/inc/db/oci8.php,v
retrieving revision 1.15.2.1
retrieving revision 1.15.2.2
diff -u -r1.15.2.1 -r1.15.2.2
--- oci8.php	25 Feb 2004 12:42:30 -0000	1.15.2.1
+++ oci8.php	25 Feb 2004 12:47:30 -0000	1.15.2.2
@@ -54,7 +54,7 @@
 		'and group_name <> \'User\'',
 	'bug-history' => 'select bh.*, login '.
 		'from '.TBL_BUG_HISTORY.' bh, '.TBL_AUTH_USER .
-		' where user_id = bh.created_by(+) and bug_id = %s',
+		' where user_id = bh.created_by(+) and bug_id = %s order by bh.created_date',
 	'bug-cc-list' => 'select email '.
 		'from '.TBL_BUG_CC.' bc, ' . TBL_AUTH_USER.' u, ' . TBL_USER_PREF.' p '.
 		'where u.user_id = bc.user_id(+) and u.user_id = p.user_id '.

Index: pgsql.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/inc/db/pgsql.php,v
retrieving revision 1.24
retrieving revision 1.24.2.1
diff -u -r1.24 -r1.24.2.1
--- pgsql.php	21 Jun 2003 13:36:30 -0000	1.24
+++ pgsql.php	25 Feb 2004 12:47:30 -0000	1.24.2.1
@@ -51,7 +51,7 @@
 	'bug-history' => 'select bh.*, login '.
 		'from '.TBL_BUG_HISTORY.' bh '.
 		'left join '. TBL_AUTH_USER.' on bh.created_by = user_id '.
-		'where bug_id = %s',
+		'where bug_id = %s order by bh.created_date',
 	'bug-cc-list' => 'select email '.
 		'from '.TBL_BUG_CC.' left join '. TBL_AUTH_USER.' u using(user_id), '.
 		TBL_USER_PREF.' p '.

[phpBT-dev] CVS: phpbt/inc/db oci8.php,1.15,1.15.2.1

[Benjamin C. <bc...@us...>]

Update of /cvsroot/phpbt/phpbt/inc/db
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv10411/inc/db

Modified Files:
      Tag: phpbt-1_0
	oci8.php 
Log Message:
Fixed a query

Index: oci8.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/inc/db/oci8.php,v
retrieving revision 1.15
retrieving revision 1.15.2.1
diff -u -r1.15 -r1.15.2.1
--- oci8.php	21 Jun 2003 13:36:30 -0000	1.15
+++ oci8.php	25 Feb 2004 12:42:30 -0000	1.15.2.1
@@ -39,7 +39,7 @@
 		'group by d.database_id, database_name, sort_order '.
 		'order by %s %s',
 	'admin-list-sites' => 'select s.site_id, site_name, sort_order, '.
-		'count(bug_id) as bug_count from '.TBL_SITE. ' s, '.TBL_BUG.
+		'count(bug_id) as bug_count from '.TBL_SITE. ' s, '.TBL_BUG.' b '.
 		'where s.site_id = b.site_id(+) group by s.site_id, site_name, '.
 		'sort_order order by %s %s',
 	'admin-list-statuses' => 'select s.status_id, status_name, status_desc, '.

[phpBT-dev] CVS: phpbt/inc/db oci8.php,1.15,1.15.4.1

[Benjamin C. <bc...@us...>]

Update of /cvsroot/phpbt/phpbt/inc/db
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv10363/inc/db

Modified Files:
      Tag: htmltemplates
	oci8.php 
Log Message:
Fixed a query

Index: oci8.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/inc/db/oci8.php,v
retrieving revision 1.15
retrieving revision 1.15.4.1
diff -u -r1.15 -r1.15.4.1
--- oci8.php	21 Jun 2003 13:36:30 -0000	1.15
+++ oci8.php	25 Feb 2004 12:42:11 -0000	1.15.4.1
@@ -39,7 +39,7 @@
 		'group by d.database_id, database_name, sort_order '.
 		'order by %s %s',
 	'admin-list-sites' => 'select s.site_id, site_name, sort_order, '.
-		'count(bug_id) as bug_count from '.TBL_SITE. ' s, '.TBL_BUG.
+		'count(bug_id) as bug_count from '.TBL_SITE. ' s, '.TBL_BUG.' b '.
 		'where s.site_id = b.site_id(+) group by s.site_id, site_name, '.
 		'sort_order order by %s %s',
 	'admin-list-statuses' => 'select s.status_id, status_name, status_desc, '.

[phpBT-dev] CVS: phpbt/templates/default bugdisplay.html,1.45.4.3,1.45.4.4

[Benjamin C. <bc...@us...>]

Update of /cvsroot/phpbt/phpbt/templates/default
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv9838

Modified Files:
      Tag: htmltemplates
	bugdisplay.html 
Log Message:
Show the error messages near the top of the page

Index: bugdisplay.html
===================================================================
RCS file: /cvsroot/phpbt/phpbt/templates/default/bugdisplay.html,v
retrieving revision 1.45.4.3
retrieving revision 1.45.4.4
diff -u -r1.45.4.3 -r1.45.4.4
--- bugdisplay.html	1 Sep 2003 13:48:18 -0000	1.45.4.3
+++ bugdisplay.html	25 Feb 2004 12:39:11 -0000	1.45.4.4
@@ -77,6 +77,8 @@
 	</tr>
     <?php if (!empty($error['status'])) echo "<tr><td class=\"error\">{$error['status']}</td></tr>"; ?>
     </table>
+	<?php if (!empty($error['add_dep'])) echo "<div class=\"error\">{$error['add_dep']}</div>"; ?>
+	<?php if (!empty($error['vote'])) echo "<div class=\"error\">{$error['vote']}</div>" ?>
     <table border="0" width="100%" cellspacing="0" cellpadding="2">
 	<tr>
 	    <td><?php echo translate("Reporter"); ?>:</td>

[phpBT-dev] CVS: phpbt/templates/default bugdisplay.html,1.45,1.45.2.1

[Benjamin C. <bc...@us...>]

Update of /cvsroot/phpbt/phpbt/templates/default
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv9215/templates/default

Modified Files:
      Tag: phpbt-1_0
	bugdisplay.html 
Log Message:
Show the error messages near the top of the page

Index: bugdisplay.html
===================================================================
RCS file: /cvsroot/phpbt/phpbt/templates/default/bugdisplay.html,v
retrieving revision 1.45
retrieving revision 1.45.2.1
diff -u -r1.45 -r1.45.2.1
--- bugdisplay.html	9 Apr 2003 21:52:32 -0000	1.45
+++ bugdisplay.html	25 Feb 2004 12:35:52 -0000	1.45.2.1
@@ -85,6 +85,9 @@
 	<tr><td class="error">{$error.status}</td></tr>
 {/if}
     </table>
+	{if !empty($error.vote)}<div class="error">{$error.vote}</div>{/if}
+	{if !empty($error.add_dep)}<div class="error">{$error.add_dep}</div>{/if}
+
     <table border="0" width="100%" cellspacing="0" cellpadding="2">
 	<tr>
 	    <td>{$STRING.BUGDISPLAY.reporter}:</td>

[phpBT-dev] bug on oci8.php + solution

[Rieder, T. <tho...@su...>]

Bug on oci8.php	
simple sql error.


replace line 41 to 44 with this
solution:
        'admin-list-sites' => 'select s.site_id, site_name, sort_order, '.
                'count(bug_id) as bug_count from '.TBL_SITE. ' s,
'.TBL_BUG.' b '.
                'where s.site_id = b.site_id(+) group by s.site_id,
site_name, '.
                'sort_order order by %s %s',

[phpBT-dev] CVS: phpbt/schemas pgsql.in,1.43.4.1,1.43.4.2

[Benjamin C. <bc...@us...>]

Update of /cvsroot/phpbt/phpbt/schemas
In directory sc8-pr-cvs1:/tmp/cvs-serv6164/schemas

Modified Files:
      Tag: htmltemplates
	pgsql.in 
Log Message:
Synching with mysql schema

Index: pgsql.in
===================================================================
RCS file: /cvsroot/phpbt/phpbt/schemas/pgsql.in,v
retrieving revision 1.43.4.1
retrieving revision 1.43.4.2
diff -u -r1.43.4.1 -r1.43.4.2
--- pgsql.in	30 Aug 2003 22:08:35 -0000	1.43.4.1
+++ pgsql.in	1 Dec 2003 14:11:59 -0000	1.43.4.2
@@ -23,7 +23,8 @@
   group_id INT4  NOT NULL DEFAULT '0',
   group_name varchar(80) NOT NULL DEFAULT '',
   locked INT2 NOT NULL DEFAULT 0,
-	created_by INT4  NOT NULL DEFAULT '0',
+  assignable INT2 NOT NULL DEFAULT 0,
+  created_by INT4  NOT NULL DEFAULT '0',
   created_date INT8  NOT NULL DEFAULT '0',
   last_modified_by INT4  NOT NULL DEFAULT '0',
   last_modified_date INT8  NOT NULL DEFAULT '0',
@@ -220,6 +221,7 @@
   status_name varchar(30) NOT NULL DEFAULT '',
   status_desc TEXT DEFAULT '' NOT NULL,
   sort_order INT2  NOT NULL DEFAULT '0',
+  bug_open INT2  NOT NULL DEFAULT '0',
   PRIMARY KEY  (status_id)
 );
 
@@ -334,7 +336,6 @@
 INSERT INTO TBL_CONFIGURATION VALUES ('BUG_PROMOTED','2','The status to assign a bug when it is promoted (if enabled).','multi');
 INSERT INTO TBL_CONFIGURATION VALUES ('BUG_ASSIGNED','3','The status to assign a bug when it is assigned.','multi');
 INSERT INTO TBL_CONFIGURATION VALUES ('BUG_REOPENED','4','The status to assign a bug when it is reopened.','multi');
-INSERT INTO TBL_CONFIGURATION VALUES ('BUG_CLOSED','7','The status to assign a bug when it is closed.','multi');
 INSERT INTO TBL_CONFIGURATION VALUES ('EMAIL_DISABLED', '0', 'Whether to disable all mail sent from the system', 'bool');
 
 INSERT INTO TBL_OS VALUES (1,'All',1,'');
@@ -387,13 +388,13 @@
 INSERT INTO TBL_SEVERITY VALUES (7,'Critical','A bug severe enough to prevent the release of the product',7,'#daaaaa');
 CREATE SEQUENCE TBL_SEVERITY_seq START 8;
 
-INSERT INTO TBL_STATUS VALUES (1,'Unconfirmed','Reported but not confirmed',1);
-INSERT INTO TBL_STATUS VALUES (2,'New','A new bug',2);
-INSERT INTO TBL_STATUS VALUES (3,'Assigned','Assigned to a developer',3);
-INSERT INTO TBL_STATUS VALUES (4,'Reopened','Closed but opened again for further inspection',4);
-INSERT INTO TBL_STATUS VALUES (5,'Resolved','Set by engineer with a resolution',5);
-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 TBL_STATUS VALUES (1,'Unconfirmed','Reported but not confirmed',1,1);
+INSERT INTO TBL_STATUS VALUES (2,'New','A new bug',2,1);
+INSERT INTO TBL_STATUS VALUES (3,'Assigned','Assigned to a developer',3,1);
+INSERT INTO TBL_STATUS VALUES (4,'Reopened','Closed but opened again for further inspection',4,1);
+INSERT INTO TBL_STATUS VALUES (5,'Resolved','Set by engineer with a resolution',5,0);
+INSERT INTO TBL_STATUS VALUES (6,'Verified','The resolution is confirmed by the reporter',6,0);
+INSERT INTO TBL_STATUS VALUES (7,'Closed','The bug is officially squashed (QA)',7,0);
 CREATE SEQUENCE TBL_STATUS_seq START 8;
 
 INSERT INTO TBL_DATABASE VALUES (1,'Oracle 8.1.7',1);

[phpBT-dev] Help on installation

[Paul N. <bri...@ya...>]

I am trying to run the installation/creation of database tables of BugTracker with Oracle 8.1.6 and, whenever I fill the fields ( Host, Database Name, User and Password ) with real values, I got the message  DB Error : no such database Array.
 
I have already created ODBC connections.
 
Does anyone know how to solve this problem ?
 
I am using Windows 2000 Server with Apache and PHP.
 
Thanks !!!


---------------------------------
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard

[phpBT-dev] CVS: phpbt report.php,1.26.6.1,1.26.6.2

[Benjamin C. <bc...@us...>]

Update of /cvsroot/phpbt/phpbt
In directory sc8-pr-cvs1:/tmp/cvs-serv23846

Modified Files:
      Tag: htmltemplates
	report.php 
Log Message:
updates

Index: report.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/report.php,v
retrieving revision 1.26.6.1
retrieving revision 1.26.6.2
diff -u -r1.26.6.1 -r1.26.6.2
--- report.php	30 Aug 2003 22:07:12 -0000	1.26.6.1
+++ report.php	17 Nov 2003 12:44:59 -0000	1.26.6.2
@@ -2,7 +2,7 @@
 
 // report.php - Generate reports on various bug activities
 // ------------------------------------------------------------------------
-// Copyright (c) 2001, 2002 The phpBugTracker Group
+// Copyright (c) 2001 - 2003 The phpBugTracker Group
 // ------------------------------------------------------------------------
 // This file is part of phpBugTracker
 //
@@ -29,7 +29,7 @@
 	
 	// Start off our query
 	$querystring = $QUERY['report-resbyeng-1'];
-	$resfields = array('Assigned To','Open');
+	$resfields = array(translate("Assigned To"), translate("Open"));
 
 	// Grab the resolutions from the database
 	$rs = $db->query($QUERY['report-resbyeng-2'].
@@ -40,7 +40,7 @@
 		$resfields[] = $fieldname;
 		$querystring .= $countquery;
 	}
-	$resfields[] = 'Total';
+	$resfields[] = translate("Total");
 	
 	if ($projectid && is_numeric($projectid)) {
 		$projectquery = $QUERY['join-where']." project_id = $projectid";
@@ -63,17 +63,17 @@
 }
 
 function new_bugs_by_date($date_range) {
-	global $db, $t, $now, $_gv;
+	global $db, $t, $now;
 	
-	include ("jpgraph.php");
-	include ("jpgraph_bar.php");
+	include_once("jpgraph.php");
+	include_once("jpgraph_bar.php");
 	
 	$colors = array('red', 'cadetblue', 'gold', 'darkmagenta');
 	
 	$graph = new Graph(450,300);
 	$graph->SetShadow();
 	$graph->SetScale("textlin");
-	$graph->title->Set("Bug Counts by Date");
+	$graph->title->Set(translate("Bug Counts by Date"));
 	$graph->title->SetFont(FF_FONT1,FS_BOLD);
 	$graph->img->SetMargin(40,140,40,80);
 	if ($date_range > 30) {
@@ -118,9 +118,9 @@
 	$graph->Add($p1);
 	
 	// Resolutions
-	if (isset($_gv['resolutions'])) {
+	if (isset($_GET['resolutions'])) {
 		$color = 0;
-		foreach ($_gv['resolutions'] as $resolution) {
+		foreach ($_GET['resolutions'] as $resolution) {
 			$stats = array(
 				'dates' => array(), 
 				'labels' => array(), 
@@ -154,12 +154,12 @@
 	$graph->Stroke();
 }
 
-$projectid = isset($_gv['projectid']) ? $_gv['projectid'] : 0;
+$projectid = isset($_GET['projectid']) ? $_GET['projectid'] : 0;
 
-if (isset($_gv['op'])) {
-	switch ($_gv['op']) {
+if (isset($_GET['op'])) {
+	switch ($_GET['op']) {
 		case 'bugsbydate' : 
-			new_bugs_by_date(isset($_gv['date_range']) ? $_gv['date_range'] : 7);
+			new_bugs_by_date(isset($_GET['date_range']) ? $_GET['date_range'] : 7);
 			break;
 	}
 } else {

[phpBT-dev] CVS: phpbt/styles default.css,1.4.4.2,1.4.4.3 print.css,1.1.6.1,1.1.6.2

[Benjamin C. <bc...@us...>]

Update of /cvsroot/phpbt/phpbt/styles
In directory sc8-pr-cvs1:/tmp/cvs-serv23566/styles

Modified Files:
      Tag: htmltemplates
	default.css print.css 
Log Message:
tweaks

Index: default.css
===================================================================
RCS file: /cvsroot/phpbt/phpbt/styles/default.css,v
retrieving revision 1.4.4.2
retrieving revision 1.4.4.3
diff -u -r1.4.4.2 -r1.4.4.3
--- default.css	1 Sep 2003 13:48:18 -0000	1.4.4.2
+++ default.css	17 Nov 2003 12:43:32 -0000	1.4.4.3
@@ -3,6 +3,7 @@
 	font-size: 12px; 
 	color: #000000;
 	background: #ffffff;
+	margin: 0px;
 	}
 
 a:link      { text-decoration: none; color: #006699; }
@@ -60,22 +61,6 @@
 	font-size: 12px;
 	}
 	
-.navfont { 
-	font-family: "Verdana","Arial","Helvetica","MS Sans Serif","Sans-Serif";
-	font-size: 10px; 
-	}
-
-.login-box {
-	vertical-align: text-bottom; 
-	font-size: 10px; 
-	}
-
-input[type="text"].login-box { 
-	padding-top: 0.1em; 
-	padding-left: 0.2em; 
-	padding-right: 0.2em; 
-	}
-
 .banner { 
 	text-align: center; 
 	font-weight: bold;
@@ -97,11 +82,6 @@
 	padding-bottom: 0.1em;
 	}
 
-a.sidenavlink {
-	color: #000000;
-	text-decoration: none;
-	}
-	
 .nav {
 	vertical-align: middle;
 	background: #9999ff;
@@ -111,44 +91,6 @@
 	font-weight: bold;
 	}
 
-.navtitlebar {
-	background: #99f;
-	}
-
-.navborder {
-	background: #000;
-	}
-	
-.navbotspacer {
-	background: #fff;
-	}
-
-.navinput {
-	vertical-align: middle;
-	background: #ffffff;
-	color: #00000;
-	font-family: "Arial", sans-serif;
-	font-size: 12px;
-	}
-	
-.sidenav {
-	vertical-align: top;
-	background: #9999ff;
-	color: #ffffff;
-	font-family: "Verdana", "Tahoma", "Helvetica", sans-serif;
-	font-size: 14px;
-	font-weight: bold;
-	}
-	
-.bottomnav {
-	vertical-align: middle;
-	background: #ffffcc;
-	color: #000000;
-	font-family: "Arial", sans-serif;
-	font-size: 10px;
-	font-weight: bold;
-	}
-	
 .bottomnavinput {
 	vertical-align: middle;
 	color: #00000;
@@ -156,51 +98,6 @@
 	font-size: 10px;
 	}
 	
-.topnavbox {
-	vertical-align: middle;
-	background: #9999ff;
-	color: #ffffff;
-	font-family: "Arial", sans-serif;
-	font-size: 14px;
-	font-weight: bold;
-	border-width: 1px 0px 1px 0px;
-	border-color: #ffffff;
-	border-style: solid;
-	padding: 5px;
-	cursor: pointer;
-	cursor: hand;
-	}
-	
-.navbox {
-	vertical-align: middle;
-	background: #9999ff;
-	color: #ffffff;
-	font-family: "Arial", sans-serif;
-	font-size: 14px;
-	font-weight: bold;
-	border-width: 0px 0px 1px 0px;
-	border-color: #ffffff;
-	border-style: solid;
-	padding: 5px;
-	cursor: pointer;
-	cursor: hand;
-	}
-	
-.navboxselected {
-	vertical-align: middle;
-	background: #ffffcc;
-	color: #ffffff;
-	font-family: "Arial", sans-serif;
-	font-size: 14px;
-	font-weight: bold;
-	border-width: 0px 0px 1px 0px;
-	border-color: #ffffff;
-	border-style: solid;
-	padding: 5px;
-	cursor: pointer;
-	cursor: hand;
-	}
-	
 .maincontent {
 	vertical-align: top;
 	background: #ffffff;
@@ -224,17 +121,6 @@
 .header-col { font-weight: bold; }
 .center-col { text-align: center; }
 
-a.navlink, a.navlink:link, a.navlink:visited, a.navlink:active {
-	color: #FFFFFF;
-	text-decoration: none;
-	font-family: Arial, Helvetica, sans-serif;
-	font-weight: bold;
-	}
-
-a.navlink:hover {
-	text-decoration: underline;
-}
-
 .bordertable {
 	width: 90%;
 }
@@ -255,3 +141,59 @@
 a.closed_bug_number { 
 	text-decoration: line-through;
 }
+
+.header_image {
+	height: 55px;
+}
+
+.header_search {
+	position: absolute;
+	top: 10px;
+	right: 0px;
+	height: 40px;
+}
+
+#tabnav {
+	height: 22px;
+	margin: 0;
+	padding-left: 6px;
+}
+
+#tabnav li {
+	margin: 0; 
+	padding: 0;
+	display: inline;
+	list-style-type: none;
+}
+	
+#tabnav a:link, #tabnav a:visited {
+	float: left;
+	font-size: 12px;
+	line-height: 14px;
+	font-weight: bold;
+	padding: 2px 5px 2px 0px;
+	margin-right: 4px;
+	/* border-left: 1px solid #000; */
+	text-decoration: none;
+	color: #fff;
+}
+	
+#tabnav a:hover {
+	text-decoration: underline;
+}
+
+.personalarea {
+	/* position: absolute;
+	top: 77px; */
+	width: 100%;
+	/* height: 50px; */
+	background: #ffc;
+	color: #000000;
+	font-size: 10px;
+	font-weight: bold;
+	border-top: 1px solid #000;
+	border-bottom: 1px solid #000;
+}
+	
+
+

Index: print.css
===================================================================
RCS file: /cvsroot/phpbt/phpbt/styles/print.css,v
retrieving revision 1.1.6.1
retrieving revision 1.1.6.2
diff -u -r1.1.6.1 -r1.1.6.2
--- print.css	1 Sep 2003 13:48:18 -0000	1.1.6.1
+++ print.css	17 Nov 2003 12:43:32 -0000	1.1.6.2
@@ -59,23 +59,6 @@
 	font-size: 12px;
 	}
 
-.navfont {
-  font-family: "Verdana","Arial","Helvetica","MS Sans Serif","Sans-Serif";
-  font-size: 10px;
-	}
-
-.login-box {
-	vertical-align: text-bottom;
-	font-size: 10px;
-	display: none;
-	}
-
-input[type="text"].login-box {
-	padding-top: 0.1em;
-	padding-left: 0.2em;
-	padding-right: 0.2em;
-	}
-
 .banner {
 	text-align: center;
 	font-weight: bold;
@@ -97,11 +80,6 @@
 	padding-bottom: 0.1em;
 	}
 
-a.sidenavlink {
-	color: #000000;
-	text-decoration: none;
-	}
-
 .nav {
 	vertical-align: middle;
 	background: #9999ff;
@@ -112,84 +90,11 @@
 	display: none;
 	}
 
-.navinput {
-	vertical-align: middle;
-	background: #ffffff;
-	color: #00000;
-	font-family: "Arial", sans-serif;
-	font-size: 12px;
-	}
-
-.sidenav {
-	vertical-align: top;
-	background: #9999ff;
-	color: #ffffff;
-	font-family: "Verdana", "Tahoma", "Helvetica", sans-serif;
-	font-size: 14px;
-	font-weight: bold;
-	}
-
-.bottomnav {
-	vertical-align: middle;
-	background: #ffffcc;
-	color: #000000;
-	font-family: "Arial", sans-serif;
-	font-size: 10px;
-	font-weight: bold;
-	}
-
 .bottomnavinput {
 	vertical-align: middle;
 	color: #00000;
 	font-family: "Arial", sans-serif;
 	font-size: 10px;
-	}
-
-.topnavbox {
-	vertical-align: middle;
-	background: #9999ff;
-	color: #ffffff;
-	font-family: "Arial", sans-serif;
-	font-size: 14px;
-	font-weight: bold;
-	border-width: 1px 0px 1px 0px;
-	border-color: #ffffff;
-	border-style: solid;
-	padding: 5px;
-	cursor: pointer;
-	cursor: hand;
-	display: none;
-	}
-
-.navbox {
-	vertical-align: middle;
-	background: #9999ff;
-	color: #ffffff;
-	font-family: "Arial", sans-serif;
-	font-size: 14px;
-	font-weight: bold;
-	border-width: 0px 0px 1px 0px;
-	border-color: #ffffff;
-	border-style: solid;
-	padding: 5px;
-	cursor: pointer;
-	cursor: hand;
-	display: none;
-	}
-
-.navboxselected {
-	vertical-align: middle;
-	background: #ffffcc;
-	color: #ffffff;
-	font-family: "Arial", sans-serif;
-	font-size: 14px;
-	font-weight: bold;
-	border-width: 0px 0px 1px 0px;
-	border-color: #ffffff;
-	border-style: solid;
-	padding: 5px;
-	cursor: pointer;
-	cursor: hand;
 	}
 
 .maincontent {

[phpBT-dev] CVS: phpbt/inc auth.php,1.18.4.1,1.18.4.2

[Benjamin C. <bc...@us...>]

Update of /cvsroot/phpbt/phpbt/inc
In directory sc8-pr-cvs1:/tmp/cvs-serv23486/inc

Modified Files:
      Tag: htmltemplates
	auth.php 
Log Message:
template tweak

Index: auth.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/inc/auth.php,v
retrieving revision 1.18.4.1
retrieving revision 1.18.4.2
diff -u -r1.18.4.1 -r1.18.4.2
--- auth.php	5 Sep 2003 11:59:52 -0000	1.18.4.1
+++ auth.php	17 Nov 2003 12:43:04 -0000	1.18.4.2
@@ -170,7 +170,7 @@
 	function perm_invalid($actual_perms, $required_perms) {
 		global $t;
 
-		$t->wrap('badperm.html');
+		$t->render('badperm.html', '');
 	}
 
 	function check_group($group) {

[phpBT-dev] CVS: phpbt/templates/default wrap.html,1.28.4.1,1.28.4.2

[Benjamin C. <bc...@us...>]

Update of /cvsroot/phpbt/phpbt/templates/default
In directory sc8-pr-cvs1:/tmp/cvs-serv23368/templates/default

Modified Files:
      Tag: htmltemplates
	wrap.html 
Log Message:
css rework

Index: wrap.html
===================================================================
RCS file: /cvsroot/phpbt/phpbt/templates/default/wrap.html,v
retrieving revision 1.28.4.1
retrieving revision 1.28.4.2
diff -u -r1.28.4.1 -r1.28.4.2
--- wrap.html	30 Aug 2003 22:00:34 -0000	1.28.4.1
+++ wrap.html	17 Nov 2003 12:42:03 -0000	1.28.4.2
@@ -7,90 +7,60 @@
     <META http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET ?>">
 </head>
 <body topmargin="0" leftmargin="0" marginheight="0" marginwidth="0">
-<table width="100%" border="0" cellspacing="0" cellpadding="0" class="nav">
-  <tr>
-	<td class="nav" valign="middle"><img name="title" src="<?php echo $template_path ?>/images/title.gif" width="500" height="50" border="0" alt="" hspace="0" vspace="0"></td>
-	<td align="right" valign="middle" class="nav">
-		<form action="bug.php">
-		<input type="hidden" name="op" value="show">
-		<?php echo translate("Find Bug") ?>
-		<input name="bugid" type="text" id="bugid" size="4">
-		&nbsp;
-		</form>
-	</td>
-  </tr>
-  <tr>
-	  <td class="navtitlebar" height="4" colspan="2"><img src="<?php echo $template_path ?>/images/spacer.gif" height="1" width="1"></td>
-  </tr>
-  <tr>
-	  <td class="navtitlebar" colspan="2">
-	  <table border="0" cellspacing="0" cellpadding="4">
-			<tr>
-			  <td><a href="index.php" class="navlink"><?php echo translate("Home"); ?></a></td>
-			  <td>|</td>
-			  <td><a href="bug.php?op=add" class="navlink"><?php echo translate("Add a new bug"); ?></a></td>
-			  <td>|</td>
-			  <td><a href="query.php?op=query" class="navlink"><?php echo translate("Query Bugs"); ?></a></td>
-			  <td>|</td>
-			  <td><a href="report.php" class="navlink"><?php echo translate("View Reports"); ?></a></td>
-				<?php if (!NEW_ACCOUNTS_DISABLED && empty($_SESSION['uid'])) { ?>
-			  <td>|</td>
-			  <td><a href="newaccount.php" class="navlink"><?php echo translate("Create a New Account"); ?></a></td>
-				<?php } ?>
-			  <td>|</td>
-			  <td><a href="docs/html/userguide.html" class="navlink"><?php echo translate("Read Documentation"); ?></a></td>
-				<?php if (isset($perm) && $perm->have_perm('Administrator')) { ?>
-			  <td>|</td>
-			  <td><a href="admin/project.php" class="navlink"><?php echo translate("Administration Tools"); ?></a></td>
-				<?php } ?>
-			</tr>
-		</table>
-	</td>
-  </tr>
-  <tr>
-	  <td class="navtitlebar" height="4" colspan="2"><img src="<?php echo $template_path ?>/images/spacer.gif" height="1" width="1"></td>
-  </tr>
-  <tr>
-	  <td class="navborder" height="1" colspan="2"><img src="<?php echo $template_path ?>/images/spacer.gif" height="1" width="1"></td>
-  </tr>
-  <?php if (basename($_SERVER['SCRIPT_NAME']) != 'newaccount.php') { ?>
-	<tr>
-	    <td colspan="2" height="20" class="bottomnav">
-		<form method="post" action="<?php echo $_SERVER['SCRIPT_NAME'].($_SERVER['REQUEST_STRING'] ? '?'.$_SERVER['REQUEST_STRING'] : '') ?>">
-		&nbsp;
-		<?php if (!$_SESSION['uid']) { ?>
-			<?php if (EMAIL_IS_LOGIN) $loginlabel = translate("Email");
-				else $loginlabel = translate("Login");
-			?>
-			<?php echo $loginerror ?>
-			<?php echo $loginlabel ?>: <input type="text" name="username" class="bottomnavinput" value="<?php echo $_COOKIE['phpbt_user'] ?>">
-			<?php echo translate("Password") ?>: <input type="password" name="password" class="bottomnavinput">
-			<input type="hidden" name="dologin" value="1">
-			<input type="submit" value="<?php echo translate("Login"); ?>" class="bottomnavinput">
-			<input type="submit" name="sendpass" value="<?php echo translate("Email Password"); ?>" class="bottomnavinput" title="<?php echo translate("Forgot your password?  Have it sent to you") ?>">
-			<?php if (RECALL_LOGIN) { ?>
-				<input type="checkbox" name="savecookie" value="1" <?php if (!empty($_COOKIE['phpbt_user'])) echo 'checked' ?> class="bottomnavinput" title="<?php printf(translate('Remember %s for next time'), $loginlabel) ?>"> <?php echo translate("Remember me"); ?>
-			<?php } ?>
-		<?php } else { ?>
-			<?php echo translate("Bugs assigned to me"); ?>: <a href="query.php?op=mybugs&assignedto=1&open=1" title="Open"><?php echo $owner_open ?></a> / <a href="query.php?op=mybugs&assignedto=1&open=0" title="Closed"><?php echo $owner_closed ?></a>
-			| <?php echo translate("Bugs reported by me"); ?>: <a href="query.php?op=mybugs&reportedby=1&open=1" title="Open"><?php echo $reporter_open ?></a> / <a href="query.php?op=mybugs&reportedby=1&open=0" title="Closed"><?php echo $reporter_closed ?></a>
-			| <a href="user.php"><?php echo translate("Personal Page"); ?></a>
-			| <a href="logout.php"><?php echo printf(translate('Logout %s'), $_SESSION['uname']); ?></a>
-		<?php } ?>
-		&nbsp;
-		</form>
-	    </td>
-	</tr>
-  <tr>
-	  <td class="navborder" height="1" colspan="2"><img src="<?php echo $template_path ?>/images/spacer.gif" height="1" width="1"></td>
-  </tr>
-  <?php } ?>
-  <tr>
-	  <td class="navbotspacer" height="20" colspan="2"><img src="<?php echo $template_path ?>/images/spacer.gif" height="1" width="1"></td>
-  </tr>
-</table>
+<div class="nav">
+    <div class="header_image">
+        <img name="title" src="<?php echo $template_path ?>/images/title.gif" width="500" height="50" border="0" alt="" hspace="0" vspace="0">
+    </div>
+    <div class="header_search">
+        <form action="bug.php">
+            <input type="hidden" name="op" value="show">
+            <?php echo translate("Find Bug") ?>
+            <input name="bugid" type="text" id="bugid" size="4">
+            &nbsp;
+        </form>
+    </div>
+    <ul id="tabnav">
+        <li><a href="index.php" style="border: none;"><?php echo translate("Home"); ?></a></li>
+        <li><a href="bug.php?op=add"><?php echo translate("Add a new bug"); ?></a></li>
+        <li><a href="query.php?op=query"><?php echo translate("Query Bugs"); ?></a></li>
+        <li><a href="report.php"><?php echo translate("View Reports"); ?></a></li>
+        <?php if (!NEW_ACCOUNTS_DISABLED && empty($_SESSION['uid'])) { ?><li><a href="newaccount.php"><?php echo translate("Create a New Account"); ?></a></li><?php } ?>
+        <li><a href="docs/html/userguide.html"><?php echo translate("Read Documentation"); ?></a></li>
+        <?php if (isset($perm) && $perm->have_perm('Administrator')) { ?><li><a href="admin/project.php"><?php echo translate("Administration Tools"); ?></a></li><?php } ?>
+    </ul>
+</div>
+
+<?php if (basename($_SERVER['SCRIPT_NAME']) != 'newaccount.php') { ?>
+<div class="personalarea">
+<form method="post" action="<?php echo $_SERVER['SCRIPT_NAME'].($_SERVER['REQUEST_STRING'] ? '?'.$_SERVER['REQUEST_STRING'] : '') ?>">
+&nbsp;
+<?php if (!$_SESSION['uid']) { ?>
+    <?php if (EMAIL_IS_LOGIN) $loginlabel = translate("Email");
+        else $loginlabel = translate("Login");
+    ?>
+    <?php echo $loginerror ?>
+    <?php echo $loginlabel ?>: <input type="text" name="username" class="bottomnavinput" value="<?php echo $_COOKIE['phpbt_user'] ?>">
+    <?php echo translate("Password") ?>: <input type="password" name="password" class="bottomnavinput">
+    <input type="hidden" name="dologin" value="1">
+    <input type="submit" value="<?php echo translate("Login"); ?>" class="bottomnavinput">
+    <input type="submit" name="sendpass" value="<?php echo translate("Email Password"); ?>" class="bottomnavinput" title="<?php echo translate("Forgot your password?  Have it sent to you") ?>">
+    <?php if (RECALL_LOGIN) { ?>
+        <input type="checkbox" name="savecookie" value="1" <?php if (!empty($_COOKIE['phpbt_user'])) echo 'checked' ?> class="bottomnavinput" title="<?php printf(translate('Remember %s for next time'), $loginlabel) ?>"> <?php echo translate("Remember me"); ?>
+    <?php } ?>
+<?php } else { ?>
+    <?php echo translate("Bugs assigned to me"); ?>: <a href="query.php?op=mybugs&assignedto=1&open=1" title="Open"><?php echo $owner_open ?></a> / <a href="query.php?op=mybugs&assignedto=1&open=0" title="Closed"><?php echo $owner_closed ?></a>
+    | <?php echo translate("Bugs reported by me"); ?>: <a href="query.php?op=mybugs&reportedby=1&open=1" title="Open"><?php echo $reporter_open ?></a> / <a href="query.php?op=mybugs&reportedby=1&open=0" title="Closed"><?php echo $reporter_closed ?></a>
+    | <a href="user.php"><?php echo translate("Personal Page"); ?></a>
+    | <a href="logout.php"><?php echo printf(translate('Logout %s'), $_SESSION['uname']); ?></a>
+<?php } ?>
+&nbsp;
+</form>
+</div>
+<?php } ?>
+
 <div style="padding: 0px 5px;">
-<?php include($content_template) ?>
+    <?php include($content_template) ?>
 </div>
+
 </body>
 </html>

[phpBT-dev] CVS: phpbt/templates/default/admin wrap.html,1.23.4.1,1.23.4.2

[Benjamin C. <bc...@us...>]

Update of /cvsroot/phpbt/phpbt/templates/default/admin
In directory sc8-pr-cvs1:/tmp/cvs-serv23278/templates/default/admin

Modified Files:
      Tag: htmltemplates
	wrap.html 
Log Message:
css rework

Index: wrap.html
===================================================================
RCS file: /cvsroot/phpbt/phpbt/templates/default/admin/wrap.html,v
retrieving revision 1.23.4.1
retrieving revision 1.23.4.2
diff -u -r1.23.4.1 -r1.23.4.2
--- wrap.html	30 Aug 2003 21:59:37 -0000	1.23.4.1
+++ wrap.html	17 Nov 2003 12:41:16 -0000	1.23.4.2
@@ -7,92 +7,39 @@
     <META http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">
 </head>
 <body topmargin="0" leftmargin="0" marginheight="0" marginwidth="0">
-<table width="100%" border="0" cellspacing="0" cellpadding="0">
-  <tr>
-	<td class="nav" valign="middle"><img name="title" src="<?php echo $template_path; ?>/../images/title.gif" width="500" height="50" border="0" alt="" hspace="0" vspace="0"></td>
-	<td align="right" valign="middle" class="nav">
-		<form action="../bug.php">
-		<input type="hidden" name="op" value="show">
-		<?php echo translate("Find Bug"); ?>
-		<input name="bugid" type="text" id="bugid" size="4">
-		&nbsp;
-		</form>
-	</td>
-  </tr>
-  <tr>
-	  <td class="navtitlebar" height="4" colspan="2"><img src="<?php echo $template_path; ?>/../images/spacer.gif" height="1" width="1"></td>
-  </tr>
-  <tr>
-	  <td class="navtitlebar" colspan="2">
-	  <table border="0" cellspacing="0" cellpadding="4">
-			<tr>
-			  <td><a href="configure.php" class="navlink"><?php echo translate("Configuration"); ?></a></td>
-			  <td>|</td>
-			  <td><a href="project.php" class="navlink"><?php echo translate("Projects"); ?></a></td>
-			  <td>|</td>
-			  <td><a href="user.php" class="navlink"><?php echo translate("Users"); ?></a></td>
-			  <td>|</td>
-			  <td><a href="group.php" class="navlink"><?php echo translate("Groups"); ?></a></td>
-			  <td>|</td>
-			  <td><a href="status.php" class="navlink"><?php echo translate("Statuses"); ?></a></td>
-			  <td>|</td>
-			  <td><a href="resolution.php" class="navlink"><?php echo translate("Resolutions"); ?></a></td>
-			</tr><tr>
-			  <td><a href="severity.php" class="navlink"><?php echo translate("Severities"); ?></a></td>
-			  <td>|</td>
-			  <td><a href="os.php" class="navlink"><?php echo translate("Operating Systems"); ?></a></td>
-			  <td>|</td>
-			  <td><a href="database.php" class="navlink"><?php echo translate("Databases"); ?></a></td>
-			  <td>|</td>
-			  <td><a href="site.php" class="navlink"><?php echo translate("Sites"); ?></a></td>
-			  <td>|</td>
-			  <td><a href="../docs/html/userguide.html" class="navlink"><?php echo translate("Documentation"); ?></a></td>
-			  <td>|</td>
-			  <td><a href="../index.php" class="navlink"><?php echo translate("User Tools"); ?></a></td>
-			</tr>
-		</table>
-	</td>
-  </tr>
-  <tr>
-	  <td class="navtitlebar" height="4" colspan="2"><img src="<?php echo $template_path; ?>/../images/spacer.gif" height="1" width="1"></td>
-  </tr>
-  <tr>
-	  <td class="navborder" height="1" colspan="2"><img src="<?php echo $template_path; ?>/../images/spacer.gif" height="1" width="1"></td>
-  </tr>
-	<tr>
-	    <td colspan="2" height="20" class="bottomnav">
-		<form method="post" action="<?php echo $_SERVER['PHP_SELF'].(!empty($_SERVER['QUERY_STRING']) ? $_SERVER['QUERY_STRING'] : ''); ?>">
-		&nbsp;
-<?php if (empty($_SESSION['uid'])) { ?>
-		<?php echo $loginerror; ?>
-		<?php echo EMAIL_IS_LOGIN ? translate("Email") : translate("Login"); ?>: 
-        <input type="text" name="username" class="bottomnavinput" value="<?php echo $_COOKIES['phpbt_user']; ?>">
-		<?php echo translate("Password"); ?>: <input type="password" name="password" class="bottomnavinput">
-		<input type="hidden" name="dologin" value="1">
-		<input type="submit" value="Login" class="bottomnavinput">
-		<input type="submit" name="sendpass" value="<?php echo translate("Email my password"); ?>" class="bottomnavinput" title="<?php echo translate("Forgot your password?  Have it sent to you"); ?>">
-    <?php if (RECALL_LOGIN) { ?>
-		<input type="checkbox" name="savecookie" value="1" <?php if (!empty($_COOKIES['phpbt_user'])) echo 'checked'; ?> class="bottomnavinput"> <?php echo translate("Remember me"); ?>
-    <?php } ?>
-<?php } else { ?>
-		<?php echo translate("Bugs assigned to me"); ?>: <a href="../query.php?op=mybugs&assignedto=1&open=1" title="<?php echo translate("Open"); ?>"><?php echo $owner_open; ?></a> / <a href="../query.php?op=mybugs&assignedto=1&open=0" title="<?php echo translate("Closed"); ?>"><?php echo $owner_closed; ?></a>
-		| <?php echo translate("Bugs reported by me"); ?>: <a href="../query.php?op=mybugs&reportedby=1&open=1" title="<?php echo translate("Open"); ?>"><?php echo $reporter_open; ?></a> / <a href="../query.php?op=mybugs&reportedby=1&open=0" title="<?php echo translate("Closed"); ?>"><?php echo $reporter_closed; ?></a>
-		| <a href="../user.php"><?php echo translate("Personal Page"); ?></a>
-		| <a href="../logout.php"><?php printf(translate('Logout %s'), $_SESSION['uname']); ?></a>
-<?php } ?>
-		&nbsp;
-		</form>
-	    </td>
-	</tr>
-  <tr>
-	  <td class="navborder" height="1" colspan="2"><img src="<?php echo $template_path; ?>/../images/spacer.gif" height="1" width="1"></td>
-  </tr>
-  <tr>
-	  <td class="navbotspacer" height="20" colspan="2"><img src="<?php echo $template_path; ?>/../images/spacer.gif" height="1" width="1"></td>
-  </tr>
-</table>
+<div class="nav">
+    <div class="header_image">
+        <img name="title" src="<?php echo $template_path ?>/../images/title.gif" width="500" height="50" border="0" alt="" hspace="0" vspace="0">
+    </div>
+    <div class="header_search">
+        <form action="bug.php">
+            <input type="hidden" name="op" value="show">
+            <?php echo translate("Find Bug") ?>
+            <input name="bugid" type="text" id="bugid" size="4">
+            &nbsp;
+        </form>
+    </div>
+    <ul id="tabnav">
+        <li><a href="configure.php" class="navlink"><?php echo translate("Configuration"); ?></a></li>
+        <li><a href="project.php" class="navlink"><?php echo translate("Projects"); ?></a></li>
+        <li><a href="user.php" class="navlink"><?php echo translate("Users"); ?></a></li>
+        <li><a href="group.php" class="navlink"><?php echo translate("Groups"); ?></a></li>
+        <li><a href="../docs/html/userguide.html" class="navlink"><?php echo translate("Documentation"); ?></a></li>
+        <li><a href="../index.php" class="navlink"><?php echo translate("User Tools"); ?></a></li>
+    </ul>
+    <ul id="tabnav">
+        <li><a href="status.php" class="navlink"><?php echo translate("Statuses"); ?></a></li>
+        <li><a href="resolution.php" class="navlink"><?php echo translate("Resolutions"); ?></a></li>
+        <li><a href="severity.php" class="navlink"><?php echo translate("Severities"); ?></a></li>
+        <li><a href="os.php" class="navlink"><?php echo translate("Operating Systems"); ?></a></li>
+        <li><a href="database.php" class="navlink"><?php echo translate("Databases"); ?></a></li>
+        <li><a href="site.php" class="navlink"><?php echo translate("Sites"); ?></a></li>
+    </ul>
+</div>
 
-<?php include($content_template); ?>
+<div style="padding: 0px 5px;">
+    <?php include($content_template); ?>
+</div>
 
 </body>
 </html>

[phpBT-dev] CVS: phpbt/templates/default/admin projectlist.html,1.8.4.1,1.8.4.2

[Benjamin C. <bc...@us...>]

Update of /cvsroot/phpbt/phpbt/templates/default/admin
In directory sc8-pr-cvs1:/tmp/cvs-serv23139/templates/default/admin

Modified Files:
      Tag: htmltemplates
	projectlist.html 
Log Message:
Tweak the page for non-admin view

Index: projectlist.html
===================================================================
RCS file: /cvsroot/phpbt/phpbt/templates/default/admin/projectlist.html,v
retrieving revision 1.8.4.1
retrieving revision 1.8.4.2
diff -u -r1.8.4.1 -r1.8.4.2
--- projectlist.html	30 Aug 2003 21:59:37 -0000	1.8.4.1
+++ projectlist.html	17 Nov 2003 12:40:40 -0000	1.8.4.2
@@ -1,7 +1,10 @@
 <table border="0" width="100%">
   <tr>
     <td valign="top">
-      <b>&nbsp;<?php echo $page_title; ?></b> - <a href="<?php echo $_SERVER['SCRIPT_NAME']; ?>?op=add"><?php echo translate("Add new project"); ?></a>
+      <b>&nbsp;<?php echo $page_title; ?></b>
+	  <?php if (isset($perm) and $perm->have_perm('Administrator')) 
+	  	echo " - <a href=\"{$_SERVER['SCRIPT_NAME']}?op=add\">".translate("Add new project")."</a>";
+	  ?>
       <hr size="1">
 			<table class="bordertable" align="center">
 				<tr>
@@ -12,7 +15,7 @@
 				<?php for ($i = 0, $count = count($projects); $i < $count; $i++) { ?>
 					<tr>
 						<td>
-                            <?php if ($perm->have_perm('Administrator') or $perm->have_perm_proj($projects[$i]['project_id'])) { ?>
+                            <?php if (isset($perm) and ($perm->have_perm('Administrator') or $perm->have_perm_proj($projects[$i]['project_id']))) { ?>
                                 <a href="<?php echo $_SERVER['SCRIPT_NAME']; ?>?op=edit&id=<?php echo $projects[$i]['project_id']; ?>"><?php echo stripslashes($projects[$i]['project_name']); ?></a>
                             <?php } else { echo stripslashes($projects[$i]['project_name']); } ?>
                         </td>

[phpBT-dev] CVS: phpbt/inc functions.php,1.42.2.1,1.42.2.2

[Ken T. <ke...@us...>]

Update of /cvsroot/phpbt/phpbt/inc
In directory sc8-pr-cvs1:/tmp/cvs-serv1438/inc

Modified Files:
      Tag: phpbt-1_0
	functions.php 
Log Message:
yes, closed-bugs FINALLY works!


Index: functions.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/inc/functions.php,v
retrieving revision 1.42.2.1
retrieving revision 1.42.2.2
diff -u -r1.42.2.1 -r1.42.2.2
--- functions.php	25 Jul 2003 02:50:08 -0000	1.42.2.1
+++ functions.php	12 Oct 2003 21:33:06 -0000	1.42.2.2
@@ -581,7 +581,7 @@
 		$closed_statuses[] = (int)$row['status_id'];
 	}
 	
-	return '('.$column.' = '.(count($closed_statuses ? join(' OR '.$column.' = ', $closed_statuses) : '1')).')';
+	return '('.$column.' = '.(count($closed_statuses) ? join(' OR '.$column.' = ', $closed_statuses) : '0').')';
 }
 
 // Check whether or not a status-id means BUG_CLOSED

[phpBT-dev] CVS: phpbt/inc functions.php,1.44,1.45

[Ken T. <ke...@us...>]

Update of /cvsroot/phpbt/phpbt/inc
In directory sc8-pr-cvs1:/tmp/cvs-serv1241/inc

Modified Files:
	functions.php 
Log Message:
closed-bugs FINALLY works!


Index: functions.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/inc/functions.php,v
retrieving revision 1.44
retrieving revision 1.45
diff -u -r1.44 -r1.45
--- functions.php	24 Jul 2003 04:57:00 -0000	1.44
+++ functions.php	12 Oct 2003 21:32:07 -0000	1.45
@@ -581,7 +581,7 @@
 		$closed_statuses[] = (int)$row['status_id'];
 	}
 	
-	return '('.$column.' = '.(count($closed_statuses ? join(' OR '.$column.' = ', $closed_statuses) : '1')).')';
+	return '('.$column.' = '.(count($closed_statuses) ? join(' OR '.$column.' = ', $closed_statuses) : '0').')';
 }
 
 // Check whether or not a status-id means BUG_CLOSED