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

[phpBT-dev] CVS: phpbt/inc functions.php,1.64,1.65

[Ulf E. <ulf...@us...>]

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

Modified Files:
	functions.php 
Log Message:
Reverting the SMTP_SENDER patch since this already exists in htmlMimeMail as return_path (which also works with 'mail')


Index: functions.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/inc/functions.php,v
retrieving revision 1.64
retrieving revision 1.65
diff -u -r1.64 -r1.65
--- functions.php	29 Aug 2005 19:14:13 -0000	1.64
+++ functions.php	8 Sep 2005 20:05:42 -0000	1.65
@@ -601,6 +601,7 @@
 	$mail = new htmlMimeMail();
 	$mail->setSubject($subject);
 	$mail->setFrom($from);
+	$mail->setReturnPath(RETURN_PATH);
 	$recipient[] = $to;
 
 	if (SEND_MIME_EMAIL) {
@@ -620,7 +621,7 @@
 	}
 
 	if (SMTP_EMAIL) {
-		$mail->setSMTPParams(SMTP_HOST, SMTP_PORT, SMTP_HELO, SMTP_AUTH, SMTP_AUTH_USER, SMTP_AUTH_PASS, SMTP_SENDER);
+		$mail->setSMTPParams(SMTP_HOST, SMTP_PORT, SMTP_HELO, SMTP_AUTH, SMTP_AUTH_USER, SMTP_AUTH_PASS);
 	}
 
 	$retval = $mail->send($recipient, SMTP_EMAIL ? 'smtp' : 'mail');

[phpBT-dev] CVS: phpbt/inc/htmlMimeMail htmlMimeMail.php,1.4,1.5 smtp.php,1.3,1.4

[Ulf E. <ulf...@us...>]

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

Modified Files:
	htmlMimeMail.php smtp.php 
Log Message:
Reverting the SMTP_SENDER patch since this already exists in htmlMimeMail as return_path (which also works with 'mail')


Index: htmlMimeMail.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/inc/htmlMimeMail/htmlMimeMail.php,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -r1.4 -r1.5
--- htmlMimeMail.php	22 Aug 2005 20:54:43 -0000	1.4
+++ htmlMimeMail.php	8 Sep 2005 20:05:42 -0000	1.5
@@ -142,7 +142,6 @@
 		$this->smtp_params['auth'] = false;
 		$this->smtp_params['user'] = '';
 		$this->smtp_params['pass'] = '';
-		$this->smtp_params['sender'] = null;
 
 		/**
         * Make sure the MIME version header is first.
@@ -189,7 +188,7 @@
 /**
 * Accessor to set the SMTP parameters
 */
-	function setSMTPParams($host = null, $port = null, $helo = null, $auth = null, $user = null, $pass = null, $sender = null)
+	function setSMTPParams($host = null, $port = null, $helo = null, $auth = null, $user = null, $pass = null)
 	{
 		if (!is_null($host)) $this->smtp_params['host'] = $host;
 		if (!is_null($port)) $this->smtp_params['port'] = $port;
@@ -197,7 +196,6 @@
 		if (!is_null($auth)) $this->smtp_params['auth'] = $auth;
 		if (!is_null($user)) $this->smtp_params['user'] = $user;
 		if (!is_null($pass)) $this->smtp_params['pass'] = $pass;
-		if (!is_null($sender)) $this->smtp_params['sender'] = $sender;
 	}
 
 /**

Index: smtp.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/inc/htmlMimeMail/smtp.php,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -r1.3 -r1.4
--- smtp.php	22 Aug 2005 20:54:43 -0000	1.3
+++ smtp.php	8 Sep 2005 20:05:42 -0000	1.4
@@ -26,7 +26,6 @@
 		var $auth;
 		var $user;
 		var $pass;
-		var $sender;
 
 		/**
         * Constructor function. Arguments:
@@ -58,7 +57,6 @@
 			$this->auth				= FALSE;
 			$this->user				= '';
 			$this->pass				= '';
-			$this->sender				= null;
 			$this->errors   		= array();
 
 			foreach($params as $key => $value){
@@ -129,10 +127,7 @@
 						return FALSE;
 				}
 
-				$envelope_sender = $this->from;
-				if (!is_null($this->sender))
-					$envelope_sender = $this->sender;
-				$this->mail($envelope_sender);
+				$this->mail($this->from);
 				if(is_array($this->recipients))
 					foreach($this->recipients as $value)
 						$this->rcpt($value);

[phpBT-dev] CVS: phpbt bug.php,1.144,1.145 config-dist.php,1.35,1.36

[Ulf E. <ulf...@us...>]

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

Modified Files:
	bug.php config-dist.php 
Log Message:
Reverting the SMTP_SENDER patch since this already exists in htmlMimeMail as return_path (which also works with 'mail')


Index: bug.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/bug.php,v
retrieving revision 1.144
retrieving revision 1.145
diff -u -r1.144 -r1.145
--- bug.php	27 Aug 2005 13:14:28 -0000	1.144
+++ bug.php	8 Sep 2005 20:05:41 -0000	1.145
@@ -318,11 +318,12 @@
 		$mail = new htmlMimeMail();
 		$mail->setText($t->fetch($template));
 		$mail->setFrom(ADMIN_EMAIL);
+		$mail->setReturnPath(RETURN_PATH);
 		$mail->setSubject("[Bug {$buginfo['bug_id']}] ".
 			($newbug ? 'New' : 'Changed').' - '.
 				stripslashes((!empty($cf['title']) ? $cf['title'] : $buginfo['title'])));
 		if (SMTP_EMAIL) {
-			$mail->setSMTPParams(SMTP_HOST, SMTP_PORT, SMTP_HELO, SMTP_AUTH, SMTP_AUTH_USER, SMTP_AUTH_PASS, SMTP_SENDER);
+			$mail->setSMTPParams(SMTP_HOST, SMTP_PORT, SMTP_HELO, SMTP_AUTH, SMTP_AUTH_USER, SMTP_AUTH_PASS);
 		}
 		$mail->send($maillist, SMTP_EMAIL ? 'smtp' : 'mail');
 	}

Index: config-dist.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/config-dist.php,v
retrieving revision 1.35
retrieving revision 1.36
diff -u -r1.35 -r1.36
--- config-dist.php	29 Aug 2005 19:09:39 -0000	1.35
+++ config-dist.php	8 Sep 2005 20:05:41 -0000	1.36
@@ -78,7 +78,6 @@
 define('SMTP_AUTH', false);
 define('SMTP_AUTH_USER', "");
 define('SMTP_AUTH_PASS', "");
-// define('SMTP_SENDER', SMTP_AUTH_USER."@".SMTP_HELO);
-define('SMTP_SENDER', null);
+define('RETURN_PATH', null);
 
 ?>

[phpBT-dev] Re: [Phpbt-users] Bug fixes or features?

[miah <mi...@ch...>]

Hi Long time User, Long time Lurker.

I realize manpower on this project is limited.  Personally, I'd like to
see Devel Snapshots, and bugs fixed in whatever is currently marked as
stable, unless its such a huge bug that it would take a tremendous
amount of manpower to fix or its already fixed in the dev branch.  Its
its something easily mergable to stable then push it back..  Some people
do use this software for production and wont run the devel versions, but
its good to have devel available for testing etc.

Thanks
-miah


On Thu, Sep 08, 2005 at 04:37:58PM +0200, Ulf Erikson wrote:
> [Cross-posting to both phpbt-dev and phpbt-users in order to reach you
> all]
> 
> Ulf Erikson [2005-08-30 09:25 +0200]:
> > > With all the patches flying in to HEAD (thanks!) should we go for a
> > > 1.1 release (which would include all the patches) rather than a 1.0.1
> > > (which would just include bug fixes)?
> > 
> > I would vote for the 1.0.1 update. You spent over a year to make sure
> > that the 1.0 release was stable. There have hardly been any complaints
> > on the release. Breaking that by adding half-tested features doesn't
> > sound wise.
> 
> Doesn't anyone else have some thoughts on this? 
> 
>  * Should we fix bugs in the 1.0 release and offer regular updates, or
>  should we spend all energy on developing a new version?
>  * Should the development version be offered as a downloadable snapshot
>  as soon as possible, or should we wait until it is safe and stable
>  enough for a release?
>  * Is the current development version safe and stable (and feature rich
>  and bug free) enough for a new release?
>  * What new features would you expect in a new release?
>  * What old bugs would you expect to be fixed in a new release?
> 
> If you have *any* interest in either bug-fix updates, development
> snapshots, or a new release Please let me know. I'm slowly starting to
> feel that I am talking to myself here... ;-(
> 
> -- 
> Ulf
> 
> 
> -------------------------------------------------------
> SF.Net email is Sponsored by the Better Software Conference & EXPO
> September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices
> Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA
> Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf
> _______________________________________________
> Phpbt-users mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpbt-users

[phpBT-dev] Bug fixes or features?

[Ulf E. <ulf...@fa...>]

[Cross-posting to both phpbt-dev and phpbt-users in order to reach you
all]

Ulf Erikson [2005-08-30 09:25 +0200]:
> > With all the patches flying in to HEAD (thanks!) should we go for a
> > 1.1 release (which would include all the patches) rather than a 1.0.1
> > (which would just include bug fixes)?
> 
> I would vote for the 1.0.1 update. You spent over a year to make sure
> that the 1.0 release was stable. There have hardly been any complaints
> on the release. Breaking that by adding half-tested features doesn't
> sound wise.

Doesn't anyone else have some thoughts on this? 

 * Should we fix bugs in the 1.0 release and offer regular updates, or
 should we spend all energy on developing a new version?
 * Should the development version be offered as a downloadable snapshot
 as soon as possible, or should we wait until it is safe and stable
 enough for a release?
 * Is the current development version safe and stable (and feature rich
 and bug free) enough for a new release?
 * What new features would you expect in a new release?
 * What old bugs would you expect to be fixed in a new release?

If you have *any* interest in either bug-fix updates, development
snapshots, or a new release Please let me know. I'm slowly starting to
feel that I am talking to myself here... ;-(

-- 
Ulf

[phpBT-dev] Session Id's and REQUEST_URI vs. SCRIPT_NAME

[Ulf E. <ulf...@fa...>]

Hoi,

Could someone please explain these two bugs for me? are they related?

[Bug #956457 ] popup*() forgets the session id's
http://sourceforge.net/tracker/index.php?func=detail&aid=956457&group_id=14939&atid=114939

[Bug #1069601 ] Major bug RC5
http://sourceforge.net/tracker/index.php?func=detail&aid=1069601&group_id=14939&atid=114939

Thanks
-- 
Ulf

[phpBT-dev] [Bug #1282025 ] v1.0rc6 Postgresql Statuses

[Ulf E. <ulf...@fa...>]

Benjamin,

Could you please check this bug report (with included fix)?

[Bug #1282025 ] v1.0rc6 Postgresql Statuses
http://sourceforge.net/tracker/index.php?func=detail&aid=1282025&group_id=14939&atid=114939

Is this a problem with Postgres only? Will the suggested fix help? Would 
it hurt to include the same changes for the other databases? (the more 
the queries look like each other the easier to maintain..)

/Ulf

[phpBT-dev] CVS: phpbt install.php,1.53,1.54

[Ulf E. <ulf...@us...>]

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

Modified Files:
	install.php 
Log Message:
Avoid "Undefined property: user_info"


Index: install.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/install.php,v
retrieving revision 1.53
retrieving revision 1.54
diff -u -r1.53 -r1.54
--- install.php	3 Sep 2005 16:41:48 -0000	1.53
+++ install.php	3 Sep 2005 16:53:05 -0000	1.54
@@ -186,8 +186,8 @@
 
 	// Simple error checking on returned DB object to check connection to db
 	if (DB::isError($db)) {
-		$error_message = $db->message;
-		$error_info = $db->user_info;
+		$error_message = isset($db->message) ? $db->message : '';
+		$error_info = isset($db->user_info) ? $db->user_info : '';
 		include('templates/default/install-dbfailure.html');
 		exit;
 	} else {

[phpBT-dev] CVS: phpbt/schemas mssql.in,1.3,1.4 mysql.in,1.51,1.52 mysqli.in,1.1,1.2 oci8.in,1.31,1.32 pgsql.in,1.50,1.51

[Ulf E. <ulf...@us...>]

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

Modified Files:
	mssql.in mysql.in mysqli.in oci8.in pgsql.in 
Log Message:
Make the group "User" less special (don't force everyone into it)


Index: mssql.in
===================================================================
RCS file: /cvsroot/phpbt/phpbt/schemas/mssql.in,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -r1.3 -r1.4
--- mssql.in	23 Aug 2005 21:12:38 -0000	1.3
+++ mssql.in	3 Sep 2005 16:41:48 -0000	1.4
@@ -442,6 +442,7 @@
 INSERT INTO TBL_CONFIGURATION VALUES ('EMAIL_IS_LOGIN','1','Whether to use email addresses as logins','bool');
 INSERT INTO TBL_CONFIGURATION VALUES ('STRICT_UPDATING', '0', 'Only the bug reporter, bug owner, managers, and admins can change a bug', 'bool');
 INSERT INTO TBL_CONFIGURATION VALUES ('NEW_ACCOUNTS_DISABLED', '0', 'Only admins can create new user accounts - newaccount.php is disabled', 'bool');
+INSERT INTO TBL_CONFIGURATION VALUES ('NEW_ACCOUNTS_GROUP', 'User', 'The group assigned to new user accounts', 'string');
 INSERT INTO TBL_CONFIGURATION VALUES ('RECALL_LOGIN', '0', 'Enable use of cookies to store username between logins', 'bool');
 INSERT INTO TBL_CONFIGURATION VALUES ('SHOW_PROJECT_SUMMARIES', '1', 'Itemize bug stats by project on the home page', 'bool');
 INSERT INTO TBL_CONFIGURATION VALUES ('FORCE_LOGIN', '0', 'Force users to login before being able to use the bug tracker', 'bool');
@@ -587,6 +588,7 @@
 # -- Sequences for the tables with no initial entries --
 #
 
+CREATE TABLE TBL_ATTACHMENT_seq ([id] [int] IDENTITY (1, 1) NOT NULL, [vapor] [int] NULL)
 CREATE TABLE TBL_BUG_seq ([id] [int] IDENTITY (1, 1) NOT NULL, [vapor] [int] NULL)
 CREATE TABLE TBL_COMMENT_seq ([id] [int] IDENTITY (1, 1) NOT NULL, [vapor] [int] NULL)
 CREATE TABLE TBL_COMPONENT_seq ([id] [int] IDENTITY (1, 1) NOT NULL, [vapor] [int] NULL)

Index: mysql.in
===================================================================
RCS file: /cvsroot/phpbt/phpbt/schemas/mysql.in,v
retrieving revision 1.51
retrieving revision 1.52
diff -u -r1.51 -r1.52
--- mysql.in	23 Aug 2005 21:12:38 -0000	1.51
+++ mysql.in	3 Sep 2005 16:41:48 -0000	1.52
@@ -452,6 +452,7 @@
 INSERT INTO TBL_CONFIGURATION VALUES ('EMAIL_IS_LOGIN','1','Whether to use email addresses as logins','bool');
 INSERT INTO TBL_CONFIGURATION VALUES ('STRICT_UPDATING', '0', 'Only the bug reporter, bug owner, managers, and admins can change a bug', 'bool');
 INSERT INTO TBL_CONFIGURATION VALUES ('NEW_ACCOUNTS_DISABLED', '0', 'Only admins can create new user accounts - newaccount.php is disabled', 'bool');
+INSERT INTO TBL_CONFIGURATION VALUES ('NEW_ACCOUNTS_GROUP', 'User', 'The group assigned to new user accounts', 'string');
 INSERT INTO TBL_CONFIGURATION VALUES ('RECALL_LOGIN', '0', 'Enable use of cookies to store username between logins', 'bool');
 INSERT INTO TBL_CONFIGURATION VALUES ('SHOW_PROJECT_SUMMARIES', '1', 'Itemize bug stats by project on the home page', 'bool');
 INSERT INTO TBL_CONFIGURATION VALUES ('FORCE_LOGIN', '0', 'Force users to login before being able to use the bug tracker', 'bool');
@@ -611,24 +612,28 @@
 # -- Sequences for the tables with no initial entries --
 #
 
+CREATE TABLE TBL_ATTACHMENT_seq (
+  id int unsigned auto_increment not null primary key);
+INSERT INTO TBL_ATTACHMENT_seq values(0);
+
 CREATE TABLE TBL_BUG_seq (
   id int unsigned auto_increment not null primary key);
-INSERT INTO TBL_BUG_seq values(1);
+INSERT INTO TBL_BUG_seq values(0);
 
 CREATE TABLE TBL_COMMENT_seq (
   id int unsigned auto_increment not null primary key);
-INSERT INTO TBL_COMMENT_seq values(1);
+INSERT INTO TBL_COMMENT_seq values(0);
 
 CREATE TABLE TBL_COMPONENT_seq (
   id int unsigned auto_increment not null primary key);
-INSERT INTO TBL_COMPONENT_seq values(1);
+INSERT INTO TBL_COMPONENT_seq values(0);
 
 CREATE TABLE TBL_PROJECT_seq (
   id int unsigned auto_increment not null primary key);
-INSERT INTO TBL_PROJECT_seq values(1);
+INSERT INTO TBL_PROJECT_seq values(0);
 
 CREATE TABLE TBL_VERSION_seq (
   id int unsigned auto_increment not null primary key);
-INSERT INTO TBL_VERSION_seq values(1);
+INSERT INTO TBL_VERSION_seq values(0);
 
 #--

Index: mysqli.in
===================================================================
RCS file: /cvsroot/phpbt/phpbt/schemas/mysqli.in,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- mysqli.in	30 May 2005 19:32:27 -0000	1.1
+++ mysqli.in	3 Sep 2005 16:41:48 -0000	1.2
@@ -3,6 +3,10 @@
 #
 # $Id$
 
+
+
+#--
+# TBL_ATTACHMENT
 CREATE TABLE TBL_ATTACHMENT (
   attachment_id int(10) unsigned NOT NULL default '0',
   bug_id int(10) unsigned NOT NULL default '0',
@@ -15,11 +19,13 @@
   PRIMARY KEY  (attachment_id)
 ) TYPE=MyISAM;
 
+
+#--
+# TBL_AUTH_GROUP
 CREATE TABLE TBL_AUTH_GROUP (
   group_id int(10) unsigned NOT NULL default '0',
   group_name varchar(80) NOT NULL default '',
   locked tinyint(1) unsigned NOT NULL default '0',
-  assignable tinyint(1) unsigned NOT NULL default '0',
   created_by int(10) unsigned NOT NULL default '0',
   created_date bigint(20) unsigned NOT NULL default '0',
   last_modified_by int(10) unsigned NOT NULL default '0',
@@ -27,6 +33,9 @@
   PRIMARY KEY  (group_id)
 ) TYPE=MyISAM;
 
+
+#--
+# TBL_AUTH_PERM
 CREATE TABLE TBL_AUTH_PERM (
   perm_id int(10) unsigned NOT NULL default '0',
   perm_name varchar(80) NOT NULL default '',
@@ -37,6 +46,9 @@
   PRIMARY KEY  (perm_id)
 ) TYPE=MyISAM;
 
+
+#--
+# TBL_AUTH_USER
 CREATE TABLE TBL_AUTH_USER (
   user_id int(10) unsigned NOT NULL default '0',
   login char(40) NOT NULL default '',
@@ -54,6 +66,17 @@
   UNIQUE KEY login (login)
 ) TYPE=MyISAM;
 
+
+#--
+# TBL_BOOKMARK
+CREATE TABLE TBL_BOOKMARK (
+  user_id int(10) unsigned NOT NULL default '0',
+  bug_id int(10) unsigned NOT NULL default '0'
+) TYPE=MyISAM;
+
+
+#--
+# TBL_BUG
 CREATE TABLE TBL_BUG (
   bug_id int(10) unsigned NOT NULL default '0',
   title varchar(100) NOT NULL default '',
@@ -81,6 +104,9 @@
   PRIMARY KEY (bug_id)
 ) TYPE=MyISAM;
 
+
+#--
+# TBL_BUG_CC
 CREATE TABLE TBL_BUG_CC (
   bug_id int(10) unsigned NOT NULL default '0',
   user_id int(10) unsigned NOT NULL default '0',
@@ -89,12 +115,18 @@
   PRIMARY KEY  (bug_id,user_id)
 ) TYPE=MyISAM;
 
+
+#--
+# TBL_BUG_DEPENDENCY
 CREATE TABLE TBL_BUG_DEPENDENCY (
   bug_id int(10) unsigned NOT NULL default '0',
   depends_on int(10) unsigned NOT NULL default '0',
   PRIMARY KEY  (bug_id,depends_on)
 ) TYPE=MyISAM;
 
+
+#--
+# TBL_BUG_GROUP
 CREATE TABLE TBL_BUG_GROUP (
   bug_id int(10) unsigned NOT NULL default '0',
   group_id int(10) unsigned NOT NULL default '0',
@@ -102,6 +134,9 @@
   KEY group_id (group_id)
 ) TYPE=MyISAM;
 
+
+#--
+# TBL_BUG_HISTORY
 CREATE TABLE TBL_BUG_HISTORY (
   bug_id int(10) unsigned NOT NULL default '0',
   changed_field varchar(30) NOT NULL default '',
@@ -111,6 +146,9 @@
   created_date bigint(20) unsigned NOT NULL default '0'
 ) TYPE=MyISAM;
 
+
+#--
+# TBL_BUG_VOTE
 CREATE TABLE TBL_BUG_VOTE (
   user_id int(10) unsigned NOT NULL default '0',
   bug_id int(10) unsigned NOT NULL default '0',
@@ -119,6 +157,9 @@
   KEY bug_id (bug_id)
 ) TYPE=MyISAM;
 
+
+#--
+# TBL_COMMENT
 CREATE TABLE TBL_COMMENT (
   comment_id int(10) unsigned NOT NULL default '0',
   bug_id int(10) unsigned NOT NULL default '0',
@@ -128,6 +169,9 @@
   PRIMARY KEY  (comment_id)
 ) TYPE=MyISAM;
 
+
+#--
+# TBL_COMPONENT
 CREATE TABLE TBL_COMPONENT (
   component_id int(10) unsigned NOT NULL default '0',
   project_id int(10) unsigned NOT NULL default '0',
@@ -135,6 +179,7 @@
   component_desc text NOT NULL,
   owner int(10) unsigned NOT NULL default '0',
   active tinyint(1) NOT NULL default '1',
+  sort_order tinyint(3) unsigned NOT NULL default '0',
   created_by int(10) unsigned NOT NULL default '0',
   created_date bigint(20) unsigned NOT NULL default '0',
   last_modified_by int(10) unsigned NOT NULL default '0',
@@ -142,6 +187,9 @@
   PRIMARY KEY  (component_id)
 ) TYPE=MyISAM;
 
+
+#--
+# TBL_CONFIGURATION
 CREATE TABLE TBL_CONFIGURATION (
   varname char(40) NOT NULL default '',
   varvalue char(255) NOT NULL default '',
@@ -150,6 +198,19 @@
   PRIMARY KEY  (varname)
 ) TYPE=MyISAM;
 
+
+#--
+# TBL_DATABASE
+CREATE TABLE TBL_DATABASE (
+  database_id tinyint(3) unsigned NOT NULL default '0',
+  database_name varchar(40) NOT NULL default '',
+  sort_order tinyint(3) unsigned NOT NULL default '0',
+  PRIMARY KEY (database_id)
+) TYPE=MyISAM;
+
+
+#--
+# TBL_GROUP_PERM
 CREATE TABLE TBL_GROUP_PERM (
   group_id int(10) unsigned NOT NULL default '0',
   perm_id int(10) unsigned NOT NULL default '0',
@@ -157,6 +218,9 @@
   KEY perm_id (perm_id)
 ) TYPE=MyISAM;
 
+
+#--
+# TBL_OS
 CREATE TABLE TBL_OS (
   os_id int(10) unsigned NOT NULL default '0',
   os_name char(30) NOT NULL default '',
@@ -165,6 +229,21 @@
   PRIMARY KEY  (os_id)
 ) TYPE=MyISAM;
 
+
+#--
+# TBL_PRIORITY
+CREATE TABLE TBL_PRIORITY (
+  priority_id int(10) unsigned NOT NULL default '0',
+  priority_name varchar(30) NOT NULL default '',
+  priority_desc text NOT NULL,
+  sort_order tinyint(3) unsigned NOT NULL default '0',
+  priority_color varchar(10) NOT NULL default '#FFFFFF',
+  PRIMARY KEY  (priority_id)
+) TYPE=MyISAM;
+
+
+#--
+# TBL_PROJECT
 CREATE TABLE TBL_PROJECT (
   project_id int(10) unsigned NOT NULL default '0',
   project_name varchar(30) NOT NULL default '',
@@ -177,6 +256,9 @@
   PRIMARY KEY  (project_id)
 ) TYPE=MyISAM;
 
+
+#--
+# TBL_PROJECT_GROUP
 CREATE TABLE TBL_PROJECT_GROUP (
   project_id int(10) unsigned NOT NULL default '0',
   group_id int(10) unsigned NOT NULL default '0',
@@ -186,11 +268,17 @@
   KEY group_id (group_id)
 ) TYPE=MyISAM;
 
+
+#--
+# TBL_PROJECT_PERM
 CREATE TABLE TBL_PROJECT_PERM (
   project_id int(11) NOT NULL default '0',
   user_id int(11) NOT NULL default '0'
 ) TYPE=MyISAM;
 
+
+#--
+# TBL_RESOLUTION
 CREATE TABLE TBL_RESOLUTION (
   resolution_id int(10) unsigned NOT NULL default '0',
   resolution_name varchar(30) NOT NULL default '',
@@ -199,6 +287,9 @@
   PRIMARY KEY  (resolution_id)
 ) TYPE=MyISAM;
 
+
+#--
+# TBL_SAVED_QUERY
 CREATE TABLE TBL_SAVED_QUERY (
   saved_query_id int(10) unsigned NOT NULL default '0',
   user_id int(10) unsigned NOT NULL default '0',
@@ -207,6 +298,9 @@
   PRIMARY KEY  (saved_query_id,user_id)
 ) TYPE=MyISAM;
 
+
+#--
+# TBL_SEVERITY
 CREATE TABLE TBL_SEVERITY (
   severity_id int(10) unsigned NOT NULL default '0',
   severity_name varchar(30) NOT NULL default '',
@@ -216,6 +310,19 @@
   PRIMARY KEY  (severity_id)
 ) TYPE=MyISAM;
 
+
+#--
+# TBL_SITE
+CREATE TABLE TBL_SITE (
+  site_id tinyint(3) unsigned NOT NULL default '0',
+  site_name varchar(50) NOT NULL default '',
+  sort_order tinyint(3) unsigned NOT NULL default '0',
+  PRIMARY KEY (site_id)
+) TYPE=MyISAM;
+
+
+#--
+# TBL_STATUS
 CREATE TABLE TBL_STATUS (
   status_id int(10) unsigned NOT NULL default '0',
   status_name varchar(30) NOT NULL default '',
@@ -225,6 +332,9 @@
   PRIMARY KEY  (status_id)
 ) TYPE=MyISAM;
 
+
+#--
+# TBL_USER_GROUP
 CREATE TABLE TBL_USER_GROUP (
   user_id int(10) unsigned NOT NULL default '0',
   group_id int(10) unsigned NOT NULL default '0',
@@ -234,6 +344,9 @@
   KEY group_id (group_id)
 ) TYPE=MyISAM;
 
+
+#--
+# TBL_USER_PERM
 CREATE TABLE TBL_USER_PERM (
   user_id int(10) unsigned NOT NULL default '0',
   perm_id int(10) unsigned NOT NULL default '0',
@@ -243,19 +356,26 @@
   KEY perm_id (perm_id)
 ) TYPE=MyISAM;
 
+
+#--
+# TBL_USER_PREF
 CREATE TABLE TBL_USER_PREF (
-    user_id int(11) NOT NULL default '0',
-    email_notices tinyint(1) NOT NULL default '1',
-    saved_queries tinyint(1) NOT NULL default '1',
-    def_results int(11) NOT NULL default '20',
-    PRIMARY KEY (user_id)
+  user_id int(11) NOT NULL default '0',
+  email_notices tinyint(1) NOT NULL default '1',
+  saved_queries tinyint(1) NOT NULL default '1',
+  def_results int(11) NOT NULL default '20',
+  PRIMARY KEY (user_id)
 ) TYPE=MyISAM;
 
+
+#--
+# TBL_VERSION
 CREATE TABLE TBL_VERSION (
   version_id int(10) unsigned NOT NULL default '0',
   project_id int(10) unsigned NOT NULL default '0',
   version_name char(30) NOT NULL default '',
   active tinyint(1) NOT NULL default '1',
+  sort_order tinyint(3) unsigned NOT NULL default '0',
   created_by int(10) unsigned NOT NULL default '0',
   created_date bigint(20) unsigned NOT NULL default '0',
   last_modified_by int(10) unsigned NOT NULL default '0',
@@ -263,54 +383,62 @@
   PRIMARY KEY  (version_id)
 ) TYPE=MyISAM;
 
-CREATE TABLE TBL_DATABASE (
-  database_id tinyint(3) unsigned NOT NULL default '0',
-  database_name varchar(40) NOT NULL default '',
-  sort_order tinyint(3) unsigned NOT NULL default '0',
-  PRIMARY KEY (database_id)
-) TYPE=MyISAM;
-
-CREATE TABLE TBL_SITE (
-  site_id tinyint(3) unsigned NOT NULL default '0',
-  site_name varchar(50) NOT NULL default '',
-  sort_order tinyint(3) unsigned NOT NULL default '0',
-  PRIMARY KEY (site_id)
-) TYPE=MyISAM;
 
 #
 # -- Insert initial data --
 #
 
+
 INSERT INTO TBL_AUTH_USER
 	(user_id, login, first_name, last_name, email, password)
-	values (1, 'OPTION_ADMIN_EMAIL', 'System', 'Admin', 'OPTION_ADMIN_EMAIL',
-		'OPTION_ADMIN_PASS');
-create table TBL_AUTH_USER_seq (id int unsigned auto_increment not null primary key);
-insert into TBL_AUTH_USER_seq values (1);
+	values (1, 'OPTION_ADMIN_EMAIL', 'System', 'Admin',
+		'OPTION_ADMIN_EMAIL', 'OPTION_ADMIN_PASS');
+
+CREATE TABLE TBL_AUTH_USER_seq (
+  id int unsigned auto_increment not null primary key);
+INSERT INTO TBL_AUTH_USER_seq values (1);
+
 
 # Start off with three user levels...
 INSERT INTO TBL_AUTH_GROUP (group_id, group_name, locked) VALUES (1, 'Admin', 1);
 INSERT INTO TBL_AUTH_GROUP (group_id, group_name, locked) VALUES (2, 'User', 1);
-INSERT INTO TBL_AUTH_GROUP (group_id, group_name, locked, assignable) VALUES (3, 'Developer', 1, 1);
-create table TBL_AUTH_GROUP_seq (id int unsigned auto_increment not null primary key);
-insert into TBL_AUTH_GROUP_seq values (3);
+INSERT INTO TBL_AUTH_GROUP (group_id, group_name, locked) VALUES (3, 'Developer', 1);
+
+CREATE TABLE TBL_AUTH_GROUP_seq (
+  id int unsigned auto_increment not null primary key);
+INSERT INTO TBL_AUTH_GROUP_seq values (3);
 
-# ... and only two permissions
+
+# ... and four 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');
 INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (3, 'EditAssignment');
+INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (4, 'Assignable');
+
 
-# Admins can do all the admin stuff and users can edit bugs
+# Admins can do all the admin stuff,
 INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (1, 1);
+
+# users can edit bugs, and
 INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (2, 2);
 
-# And user_id 1 is an admin and a user
+# developers are users who can own bugs
+INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (3, 2);
+INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (3, 4);
+
+
+# Insert user_id 1 into the admin group
 INSERT INTO TBL_USER_GROUP (user_id, group_id) VALUES (1, 1);
-INSERT INTO TBL_USER_GROUP (user_id, group_id) VALUES (1, 2);
+
 
 # Add user's prefs as default values for all users defined so far (only admin)
 INSERT INTO TBL_USER_PREF (user_id) SELECT USER_ID FROM TBL_AUTH_USER;
 
+
+#
+# -- Initialize the CONFIGURATION table --
+#
+
 INSERT INTO TBL_CONFIGURATION VALUES ('INSTALL_URL','OPTION_INSTALL_URL','The base URL of the phpBugTracker installation','string');
 INSERT INTO TBL_CONFIGURATION VALUES ('JPGRAPH_PATH','','If not in the include path.  This is the file path on the web server, not a URL.','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');
@@ -320,9 +448,11 @@
 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 ('USE_PRIORITY_COLOR','0','Should the query list use the priority colors as the row background color','bool');
 INSERT INTO TBL_CONFIGURATION VALUES ('EMAIL_IS_LOGIN','1','Whether to use email addresses as logins','bool');
 INSERT INTO TBL_CONFIGURATION VALUES ('STRICT_UPDATING', '0', 'Only the bug reporter, bug owner, managers, and admins can change a bug', 'bool');
 INSERT INTO TBL_CONFIGURATION VALUES ('NEW_ACCOUNTS_DISABLED', '0', 'Only admins can create new user accounts - newaccount.php is disabled', 'bool');
+INSERT INTO TBL_CONFIGURATION VALUES ('NEW_ACCOUNTS_GROUP', 'User', 'The group assigned to new user accounts', 'string');
 INSERT INTO TBL_CONFIGURATION VALUES ('RECALL_LOGIN', '0', 'Enable use of cookies to store username between logins', 'bool');
 INSERT INTO TBL_CONFIGURATION VALUES ('SHOW_PROJECT_SUMMARIES', '1', 'Itemize bug stats by project on the home page', 'bool');
 INSERT INTO TBL_CONFIGURATION VALUES ('FORCE_LOGIN', '0', 'Force users to login before being able to use the bug tracker', 'bool');
@@ -342,6 +472,11 @@
 INSERT INTO TBL_CONFIGURATION VALUES ('BUG_REOPENED','4','The status to assign a bug when it is reopened.','multi');
 INSERT INTO TBL_CONFIGURATION VALUES ('EMAIL_DISABLED', '0', 'Whether to disable all mail sent from the system', 'bool');
 
+
+#
+# -- Initialize the OS table --
+#
+
 INSERT INTO TBL_OS VALUES (1,'All',1,'');
 INSERT INTO TBL_OS VALUES (2,'Windows 3.1',2,'/Mozilla.*\\(Win16.*\\)/');
 INSERT INTO TBL_OS VALUES (3,'Windows 95',3,'/Mozilla.*\\(.*;.*; 32bit.*\\)/');
@@ -373,8 +508,15 @@
 INSERT INTO TBL_OS VALUES (29,'Solaris',29,'/Mozilla.*\\(.*;.*; SunOS 5.*\\)/');
 INSERT INTO TBL_OS VALUES (30,'SunOS',30,'/Mozilla.*\\(.*;.*; SunOS.*\\)/');
 INSERT INTO TBL_OS VALUES (31,'other',31,'');
-create table TBL_OS_seq (id int unsigned auto_increment not null primary key);
-insert into TBL_OS_seq values (31);
+
+CREATE TABLE TBL_OS_seq (
+  id int unsigned auto_increment not null primary key);
+INSERT INTO TBL_OS_seq values (31);
+
+
+#
+# -- Initialize the RESOLUTION table --
+#
 
 INSERT INTO TBL_RESOLUTION VALUES (1,'Fixed','Bug was eliminated',1);
 INSERT INTO TBL_RESOLUTION VALUES (2,'Not a bug','It''s not a bug -- it''s a feature!',2);
@@ -382,8 +524,15 @@
 INSERT INTO TBL_RESOLUTION VALUES (4,'Deferred','We''ll get around to it later',4);
 INSERT INTO TBL_RESOLUTION VALUES (5,'Works for me','Can''t replicate the bug',5);
 INSERT INTO TBL_RESOLUTION VALUES (6,'Duplicate','',6);
-create table TBL_RESOLUTION_seq (id int unsigned auto_increment not null primary key);
-insert into TBL_RESOLUTION_seq values (6);
+
+CREATE TABLE TBL_RESOLUTION_seq (
+  id int unsigned auto_increment not null primary key);
+INSERT INTO TBL_RESOLUTION_seq values (6);
+
+
+#
+# -- Initialize the SEVERITY table --
+#
 
 INSERT INTO TBL_SEVERITY VALUES (1,'Unassigned','Default bug creation',1,'#dadada');
 INSERT INTO TBL_SEVERITY VALUES (2,'Idea','Ideas for further development',2,'#dad0d0');
@@ -392,24 +541,60 @@
 INSERT INTO TBL_SEVERITY VALUES (5,'Content','Non-functional related bugs, such as text content',5,'#dababa');
 INSERT INTO TBL_SEVERITY VALUES (6,'Significant','A bug affecting the intended performance of the product',6,'#dab0b0');
 INSERT INTO TBL_SEVERITY VALUES (7,'Critical','A bug severe enough to prevent the release of the product',7,'#daaaaa');
-create table TBL_SEVERITY_seq (id int unsigned auto_increment not null primary key);
-insert into TBL_SEVERITY_seq values (7);
 
-INSERT INTO TBL_STATUS VALUES (1,'Unconfirmed','Reported but not confirmed',1, 1);
+CREATE TABLE TBL_SEVERITY_seq (
+  id int unsigned auto_increment not null primary key);
+INSERT INTO TBL_SEVERITY_seq values (7);
+
+
+#
+# -- Initialize the PRIORITY table --
+#
+
+INSERT INTO TBL_PRIORITY VALUES (1,'Low','Fix if possible',1,'#dadada');
+INSERT INTO TBL_PRIORITY VALUES (2,'Medium Low','Must fix before final',2,'#dad0d0');
+INSERT INTO TBL_PRIORITY VALUES (3,'Medium','Fix before next milestone (alpha, beta, etc.)',3,'#dac0c0');
+INSERT INTO TBL_PRIORITY VALUES (4,'Medium High','Fix as soon as possible',4,'#dab0b0');
+INSERT INTO TBL_PRIORITY VALUES (5,'High','Fix immediately',5,'#daaaaa');
+
+CREATE TABLE TBL_PRIORITY_seq (
+  id int unsigned auto_increment not null primary key);
+INSERT INTO TBL_PRIORITY_seq values (5);
+
+
+#
+# -- Initialize the STATUS table --
+#
+
+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 table TBL_STATUS_seq (id int unsigned auto_increment not null primary key);
-insert into TBL_STATUS_seq values (7);
+
+CREATE TABLE TBL_STATUS_seq (
+  id int unsigned auto_increment not null primary key);
+INSERT INTO TBL_STATUS_seq values (7);
+
+
+#
+# -- Initialize the DATABASE table --
+#
 
 INSERT INTO TBL_DATABASE VALUES (1,'Oracle 8.1.7',1);
 INSERT INTO TBL_DATABASE VALUES (2,'MySQL 3.23.49',2);
 INSERT INTO TBL_DATABASE VALUES (3,'PostgreSQL 7.1.3',3);
-create table TBL_DATABASE_seq (id int unsigned auto_increment not null primary key);
-insert into TBL_DATABASE_seq values (3);
+
+CREATE TABLE TBL_DATABASE_seq (
+  id int unsigned auto_increment not null primary key);
+INSERT INTO TBL_DATABASE_seq values (3);
+
+
+#
+# -- Initialize the SITE table --
+#
 
 # Examples only
 INSERT INTO TBL_SITE VALUES (0,'All',1);
@@ -417,17 +602,38 @@
 INSERT INTO TBL_SITE VALUES (2,'Production - location 2',3);
 INSERT INTO TBL_SITE VALUES (3,'Test site - location 1',4);
 INSERT INTO TBL_SITE VALUES (4,'Test site - location 2',5);
-create table TBL_SITE_seq (id int unsigned auto_increment not null primary key);
-insert into TBL_SITE_seq values (4);
 
-#-- Sequences for the tables with no initial entries
-create table TBL_BUG_seq (id int unsigned auto_increment not null primary key);
-insert into TBL_BUG_seq values(1);
-create table TBL_COMMENT_seq (id int unsigned auto_increment not null primary key);
-insert into TBL_COMMENT_seq values(1);
-create table TBL_COMPONENT_seq (id int unsigned auto_increment not null primary key);
-insert into TBL_COMPONENT_seq values(1);
-create table TBL_PROJECT_seq (id int unsigned auto_increment not null primary key);
-insert into TBL_PROJECT_seq values(1);
-create table TBL_VERSION_seq (id int unsigned auto_increment not null primary key);
-insert into TBL_VERSION_seq values(1);
+CREATE TABLE TBL_SITE_seq (
+  id int unsigned auto_increment not null primary key);
+INSERT INTO TBL_SITE_seq values (4);
+
+
+#
+# -- Sequences for the tables with no initial entries --
+#
+
+CREATE TABLE TBL_ATTACHMENT_seq (
+  id int unsigned auto_increment not null primary key);
+INSERT INTO TBL_ATTACHMENT_seq values(0);
+
+CREATE TABLE TBL_BUG_seq (
+  id int unsigned auto_increment not null primary key);
+INSERT INTO TBL_BUG_seq values(0);
+
+CREATE TABLE TBL_COMMENT_seq (
+  id int unsigned auto_increment not null primary key);
+INSERT INTO TBL_COMMENT_seq values(0);
+
+CREATE TABLE TBL_COMPONENT_seq (
+  id int unsigned auto_increment not null primary key);
+INSERT INTO TBL_COMPONENT_seq values(0);
+
+CREATE TABLE TBL_PROJECT_seq (
+  id int unsigned auto_increment not null primary key);
+INSERT INTO TBL_PROJECT_seq values(0);
+
+CREATE TABLE TBL_VERSION_seq (
+  id int unsigned auto_increment not null primary key);
+INSERT INTO TBL_VERSION_seq values(0);
+
+#--

Index: oci8.in
===================================================================
RCS file: /cvsroot/phpbt/phpbt/schemas/oci8.in,v
retrieving revision 1.31
retrieving revision 1.32
diff -u -r1.31 -r1.32
--- oci8.in	31 Aug 2005 20:12:38 -0000	1.31
+++ oci8.in	3 Sep 2005 16:41:48 -0000	1.32
@@ -453,6 +453,7 @@
 INSERT INTO TBL_CONFIGURATION VALUES ('EMAIL_IS_LOGIN','1','Whether to use email addresses as logins','bool');
 INSERT INTO TBL_CONFIGURATION VALUES ('STRICT_UPDATING', '0', 'Only the bug reporter, bug owner, managers, and admins can change a bug', 'bool');
 INSERT INTO TBL_CONFIGURATION VALUES ('NEW_ACCOUNTS_DISABLED', '0', 'Only admins can create new user accounts - newaccount.php is disabled', 'bool');
+INSERT INTO TBL_CONFIGURATION VALUES ('NEW_ACCOUNTS_GROUP', 'User', 'The group assigned to new user accounts', 'string');
 INSERT INTO TBL_CONFIGURATION VALUES ('RECALL_LOGIN', '0', 'Enable use of cookies to store username between logins', 'bool');
 INSERT INTO TBL_CONFIGURATION VALUES ('SHOW_PROJECT_SUMMARIES', '1', 'Itemize bug stats by project on the home page', 'bool');
 INSERT INTO TBL_CONFIGURATION VALUES ('FORCE_LOGIN', '0', 'Force users to login before being able to use the bug tracker', 'bool');
@@ -598,6 +599,7 @@
 # -- Sequences for the tables with no initial entries --
 #
 
+CREATE SEQUENCE TBL_ATTACHMENT_seq START WITH 1 NOCACHE;
 CREATE SEQUENCE TBL_BUG_seq START WITH 1 NOCACHE;
 CREATE SEQUENCE TBL_COMMENT_seq START WITH 1 NOCACHE;
 CREATE SEQUENCE TBL_COMPONENT_seq START WITH 1 NOCACHE;

Index: pgsql.in
===================================================================
RCS file: /cvsroot/phpbt/phpbt/schemas/pgsql.in,v
retrieving revision 1.50
retrieving revision 1.51
diff -u -r1.50 -r1.51
--- pgsql.in	23 Aug 2005 21:12:38 -0000	1.50
+++ pgsql.in	3 Sep 2005 16:41:48 -0000	1.51
@@ -441,6 +441,7 @@
 INSERT INTO TBL_CONFIGURATION VALUES ('EMAIL_IS_LOGIN','1','Whether to use email addresses as logins','bool');
 INSERT INTO TBL_CONFIGURATION VALUES ('STRICT_UPDATING', '0', 'Only the bug reporter, bug owner, managers, and admins can change a bug', 'bool');
 INSERT INTO TBL_CONFIGURATION VALUES ('NEW_ACCOUNTS_DISABLED', '0', 'Only admins can create new user accounts - newaccount.php is disabled', 'bool');
+INSERT INTO TBL_CONFIGURATION VALUES ('NEW_ACCOUNTS_GROUP', 'User', 'The group assigned to new user accounts', 'string');
 INSERT INTO TBL_CONFIGURATION VALUES ('RECALL_LOGIN', '0', 'Enable use of cookies to store username between logins', 'bool');
 INSERT INTO TBL_CONFIGURATION VALUES ('SHOW_PROJECT_SUMMARIES', '1', 'Itemize bug stats by project on the home page', 'bool');
 INSERT INTO TBL_CONFIGURATION VALUES ('FORCE_LOGIN', '0', 'Force users to login before being able to use the bug tracker', 'bool');
@@ -596,6 +597,7 @@
 # -- Sequences for the tables with no initial entries --
 #
 
+CREATE SEQUENCE TBL_ATTACHMENT_seq;
 CREATE SEQUENCE TBL_BUG_seq;
 CREATE SEQUENCE TBL_COMMENT_seq;
 CREATE SEQUENCE TBL_COMPONENT_seq;

[phpBT-dev] CVS: phpbt include.php,1.140,1.141 install.php,1.52,1.53 newaccount.php,1.34,1.35 upgrade.php,1.43,1.44

[Ulf E. <ulf...@us...>]

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

Modified Files:
	include.php install.php newaccount.php upgrade.php 
Log Message:
Make the group "User" less special (don't force everyone into it)


Index: include.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/include.php,v
retrieving revision 1.140
retrieving revision 1.141
diff -u -r1.140 -r1.141
--- include.php	29 Aug 2005 19:09:40 -0000	1.140
+++ include.php	3 Sep 2005 16:41:48 -0000	1.141
@@ -87,7 +87,7 @@
 }
 require_once ('inc/db/'.DB_TYPE.'.php');
 
-$me = $HTTP_SERVER_VARS['PHP_SELF'];
+$me = $_SERVER['PHP_SELF'];
 $selrange = 30;
 $now = time();
 

Index: install.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/install.php,v
retrieving revision 1.52
retrieving revision 1.53
diff -u -r1.52 -r1.53
--- install.php	29 Aug 2005 19:09:40 -0000	1.52
+++ install.php	3 Sep 2005 16:41:48 -0000	1.53
@@ -130,7 +130,7 @@
 		'/OPTION_ADMIN_PASS/' => $_POST['encrypt_pass'] ? md5($_POST['admin_pass']) : $_POST['admin_pass'],
 		'/OPTION_PHPBT_EMAIL/' => $_POST['phpbt_email'],
 		'/OPTION_ENCRYPT_PASS/' => $_POST['encrypt_pass'],
-		'/OPTION_INSTALL_URL/' => 'http://'.$HTTP_SERVER_VARS['SERVER_NAME'].dirname($HTTP_SERVER_VARS['SCRIPT_NAME']),
+		'/OPTION_INSTALL_URL/' => 'http://'.$_SERVER['SERVER_NAME'].dirname($_SERVER['SCRIPT_NAME']),
 		);
 }
 
@@ -296,11 +296,11 @@
 }
 
 function show_front($error = '') {
-	global $t, $_POST, $select, $HTTP_SERVER_VARS;
+	global $t, $_POST, $select;
 
 	extract($_POST);
 	$error = $error;
-	$default_email = 'phpbt@'.$HTTP_SERVER_VARS['SERVER_NAME'];
+	$default_email = 'phpbt@'.$_SERVER['SERVER_NAME'];
 	include('templates/default/install.html');
 }
 

Index: newaccount.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/newaccount.php,v
retrieving revision 1.34
retrieving revision 1.35
diff -u -r1.34 -r1.35
--- newaccount.php	22 Aug 2005 20:50:23 -0000	1.34
+++ newaccount.php	3 Sep 2005 16:41:48 -0000	1.35
@@ -58,7 +58,7 @@
 	}
 	$user_id = $db->nextId(TBL_AUTH_USER);
 	$db->query("insert into ".TBL_AUTH_USER." (user_id, login, first_name, last_name, email, password, active, created_date, last_modified_date) values (".join(', ', array($user_id, $db->quote(stripslashes($login)), $db->quote(stripslashes($firstname)), $db->quote(stripslashes($lastname)), $db->quote($_POST['email']), $mpassword, 1, $now, $now)).")");
-	$db->query("insert into ".TBL_USER_GROUP." (user_id, group_id, created_by, created_date) select $user_id, group_id, 0, $now from ".TBL_AUTH_GROUP." where group_name = 'User'"); 
+	$db->query("insert into ".TBL_USER_GROUP." (user_id, group_id, created_by, created_date) select $user_id, group_id, 0, $now from ".TBL_AUTH_GROUP." where group_name = ".NEW_ACCOUNTS_GROUP); 
 	$db->query("insert into ".TBL_USER_PREF." (user_id) values ($user_id)");
 	
 	qp_mail($_POST['email'], 

Index: upgrade.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/upgrade.php,v
retrieving revision 1.43
retrieving revision 1.44
diff -u -r1.43 -r1.44
--- upgrade.php	31 Aug 2005 20:11:06 -0000	1.43
+++ upgrade.php	3 Sep 2005 16:41:48 -0000	1.44
@@ -208,6 +208,7 @@
 			log_query("INSERT INTO ".TBL_PRIORITY." VALUES (3,'Medium','Fix before next milestone (alpha, beta, etc.)',3,'#dac0c0')");
 			log_query("INSERT INTO ".TBL_PRIORITY." VALUES (4,'Medium High','Fix as soon as possible',4,'#dab0b0')");
 			log_query("INSERT INTO ".TBL_PRIORITY." VALUES (5,'High','Fix immediately',5,'#daaaaa')");
+			log_query("INSERT INTO ".TBL_CONFIGURATION." VALUES ('NEW_ACCOUNTS_GROUP', 'User', 'The group assigned to new user accounts', 'string')");
 		}
 
 		/* update to current DB_VERSION */

[phpBT-dev] CVS: phpbt/admin user.php,1.52,1.53

[Ulf E. <ulf...@us...>]

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

Modified Files:
	user.php 
Log Message:
Make the group "User" less special (don't force everyone into it)


Index: user.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/admin/user.php,v
retrieving revision 1.52
retrieving revision 1.53
diff -u -r1.52 -r1.53
--- user.php	29 Aug 2005 19:14:13 -0000	1.52
+++ user.php	3 Sep 2005 16:41:48 -0000	1.53
@@ -65,9 +65,6 @@
 		}
 		// Add to prefs
 		$db->query("INSERT INTO ".TBL_USER_PREF." (user_id, email_notices) VALUES ($new_user_id, '{$_POST['fe_notice']}')");
-
-		// And add to the user group
-		$db->query("insert into ".TBL_USER_GROUP." (user_id, group_id, created_by, created_date) select $new_user_id, group_id, $u, $now from ".TBL_AUTH_GROUP." where group_name = 'User'");
 	} else {
 		if (ENCRYPT_PASS) {
 			$oldpass = $db->getOne("select password from ".TBL_AUTH_USER." where user_id = $userid");

[phpBT-dev] Demo

[Ulf E. <ulf...@fa...>]

Hoi,

The old (v0.9.0) demo at http://phpbt.sourceforge.net/demo/
doesn't work all that well since the files are mounted read-only
http://sourceforge.net/docman/display_doc.php?docid=4297&group_id=1#permissions
I've silenced some of the complaints, but don't have file permissions 
enough to change it all.

As an alternative I have now installed a development version from today at:
   http://phpbt.sourceforge.net/devel/
Sourceforge.net is an extremely slow server and often claim "file not 
found" for just about any file.. Usually a reload seems to help.

Two users: user and developer, with user and developer as passwords.

Please report all faults you see.
-- 
Ulf

[phpBT-dev] CVS: phpbt/inc auth.php,1.22,1.23

[Ulf E. <ulf...@us...>]

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

Modified Files:
	auth.php 
Log Message:
Permission fixes for project admins


Index: auth.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/inc/auth.php,v
retrieving revision 1.22
retrieving revision 1.23
diff -u -r1.22 -r1.23
--- auth.php	27 Aug 2005 13:14:28 -0000	1.22
+++ auth.php	2 Sep 2005 19:17:24 -0000	1.23
@@ -121,7 +121,7 @@
 		if ($this->have_perm_proj($project_id)) {
 			return true;
 		} else {
-			$this->perm_invalid($_SESSION['perms'], $p);
+			$this->perm_invalid($_SESSION['perms']);
 			exit();
 		}
 	}
@@ -182,7 +182,7 @@
 	}
 
 
-	function perm_invalid($actual_perms, $required_perms) {
+	function perm_invalid($actual_perms, $required_perms = 0) {
 		global $t;
 
 		$t->render('badperm.html', '');

[phpBT-dev] CVS: phpbt/admin project.php,1.49,1.50

[Ulf E. <ulf...@us...>]

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

Modified Files:
	project.php 
Log Message:
Permission fixes for project admins


Index: project.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/admin/project.php,v
retrieving revision 1.49
retrieving revision 1.50
diff -u -r1.49 -r1.50
--- project.php	27 Aug 2005 13:14:28 -0000	1.49
+++ project.php	2 Sep 2005 19:17:24 -0000	1.50
@@ -26,7 +26,7 @@
 define('TEMPLATE_PATH', 'admin');
 include 'include.php';
 
-function del_version($versionid, $projectid) {
+function del_version($versionid, $projectid = 0) {
 	global $db, $me, $perm;
 
 	$perm->check_proj($projectid);
@@ -37,7 +37,7 @@
 	header("Location: $me?op=edit&id=$projectid&");
 }
 
-function save_version($version_id = 0) {
+function save_version($version_id = 0, $projectid = 0) {
 	global $db, $me, $now, $u, $t, $perm;
 
 	$perm->check_proj($projectid);
@@ -81,7 +81,7 @@
 		!empty($_REQUEST['use_js']) ? 'wrap-popup.html' : 'wrap.html');
 }
 
-function del_component($componentid, $projectid) {
+function del_component($componentid, $projectid = 0) {
 	global $db, $me, $perm;
 
 	$perm->check_proj($projectid);
@@ -92,7 +92,7 @@
 	header("Location: $me?op=edit&id=$projectid&");
 }
 
-function save_component($component_id = 0) {
+function save_component($component_id = 0, $projectid = 0) {
 	global $db, $me, $u, $now, $t, $perm;
 
 	$perm->check_proj($projectid);
@@ -243,6 +243,8 @@
 function show_project($projectid = 0, $error = null) {
 	global $db, $me, $t, $QUERY, $perm;
 
+	$perm->check_proj($projectid);
+
 	if (is_array($error)) $t->assign($error);
 	else $t->assign('error', $error);
 	$t->assign('project_groups', 
@@ -319,8 +321,8 @@
 		case 'del_component' : del_component($_REQUEST['id'], $_REQUEST['project_id']); break;
 		case 'del_version' : del_version($_REQUEST['id'], $_REQUEST['project_id']); break;
 		case 'save_project' : save_project($_POST['id']); break;
-		case 'save_version' : save_version($_POST['version_id']); break;
-		case 'save_component' : save_component($_POST['component_id']); break;
+		case 'save_version' : save_version($_POST['version_id'], $_POST['project_id']); break;
+		case 'save_component' : save_component($_POST['component_id'], $_POST['project_id']); break;
 	}
 } else list_projects();
 

Re: [phpBT-dev] Recent commits

[Ulf E. <ulf...@fa...>]

* Ulf Erikson [2005-08-29 21:44]:
>>> This is just a minor warning or heads up if someone wish to play with 
>>> them: The update script is not ready yet not is support for Oracle or 
>>> Postgres. Hopefully this will be added "soon".
>>
>> I have updated inc/db/*.php and schemas/*.in. Things might work in 
>> Oracle and Postgres now. I have no way to test it myself.. Any 
>> volunteers? ;-)
> 
> Finally is upgrade.php also updated, but only for MySQL. Anyone willing 
> to help with the others? Anyone daring to test the new features?

I have just committed something that might work as an upgrade script 
also for Postgres and Oracle. I'm expecting more bug reports than what I 
have received until now ;-)

Re: [phpBT-dev] Recent commits

[Ulf E. <ulf...@fa...>]

* Benjamin Curtis [2005-08-30 00:07]:
> Yeah, I started to test some of the new features and got some  breakage 
> with mysqli and the bookmark queries.  I didn't have time to  really 
> look, but it seemed like mysqli.php was missing some queries.   Since 
> the queries should really be the same as in mysql.php, we  should 
> probably just load mysql.php even when mysqli is selected as  the 
> database type.

Yes, mysqli.php should be a copy of mysql.php (and mysqli.in a copy of 
mysql.in). Using the same file would save us from this kind of problems 
where I forget to update both. Current CVS should be fixed though.

[phpBT-dev] CVS: phpbt/schemas oci8.in,1.30,1.31

[Ulf E. <ulf...@us...>]

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

Modified Files:
	oci8.in 
Log Message:
Fix for copy&paste error in oci8.in


Index: oci8.in
===================================================================
RCS file: /cvsroot/phpbt/phpbt/schemas/oci8.in,v
retrieving revision 1.30
retrieving revision 1.31
diff -u -r1.30 -r1.31
--- oci8.in	23 Aug 2005 21:12:38 -0000	1.30
+++ oci8.in	31 Aug 2005 20:12:38 -0000	1.31
@@ -551,7 +551,7 @@
 INSERT INTO TBL_PRIORITY VALUES (4,'Medium High','Fix as soon as possible',4,'#dab0b0');
 INSERT INTO TBL_PRIORITY VALUES (5,'High','Fix immediately',5,'#daaaaa');
 
-CREATE SEQUENCE TBL_SEVERITY_seq START WITH 6 NOCACHE;
+CREATE SEQUENCE TBL_PRIORITY_seq START WITH 6 NOCACHE;
 
 
 #

[phpBT-dev] CVS: phpbt upgrade.php,1.42,1.43

[Ulf E. <ulf...@us...>]

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

Modified Files:
	upgrade.php 
Log Message:
Upgrade for Postgres and Oracle


Index: upgrade.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/upgrade.php,v
retrieving revision 1.42
retrieving revision 1.43
diff -u -r1.42 -r1.43
--- upgrade.php	29 Aug 2005 19:09:40 -0000	1.42
+++ upgrade.php	31 Aug 2005 20:11:06 -0000	1.43
@@ -121,6 +121,16 @@
 					log_query("ALTER TABLE ".TBL_STATUS." alter bug_open set NOT NULL");
 				}
 				if ($thisvers < 5) {
+					log_query("create table ".TBL_PRIORITY."( priority_id INT4  NOT NULL DEFAULT '0', priority_name varchar(30) NOT NULL DEFAULT '', priority_desc TEXT DEFAULT '' NOT NULL, sort_order INT2  NOT NULL DEFAULT '0', priority_color varchar(10) NOT NULL DEFAULT '#FFFFFF', PRIMARY KEY  (priority_id) )");
+					log_query("create table ".TBL_BOOKMARK."( user_id INT4  NOT NULL DEFAULT '0', bug_id INT4  NOT NULL DEFAULT '0' )");
+
+					log_query('ALTER TABLE '.TBL_COMPONENT.' ADD sort_order INT2');
+					log_query("ALTER TABLE ".TBL_COMPONENT." alter sort_order set DEFAULT 0");
+					log_query("ALTER TABLE ".TBL_COMPONENT." alter sort_order set NOT NULL");
+					log_query('ALTER TABLE '.TBL_VERSION.' ADD sort_order INT2');
+					log_query("ALTER TABLE ".TBL_VERSION." alter sort_order set DEFAULT 0");
+					log_query("ALTER TABLE ".TBL_VERSION." alter sort_order set NOT NULL");
+					log_query("CREATE SEQUENCE ".TBL_PRIORITY."_seq START 6");
 				}
 				break;
 			case 'mysqli' :
@@ -165,6 +175,11 @@
 					log_query("ALTER TABLE ".TBL_STATUS." ADD (bug_open number(1) default '1' NOT NULL)");
 				}
 				if ($thisvers < 5) {
+					log_query("create table ".TBL_PRIORITY." ( priority_id number(3)   default '0' NOT NULL, priority_name varchar2(30)  default '' NOT NULL, priority_desc varchar2(4000) NOT NULL, sort_order number(3)   default '0' NOT NULL, priority_color varchar2(10)  default '#FFFFFF' NOT NULL, PRIMARY KEY  (priority_id) )");
+					log_query("create table ".TBL_BOOKMARK." ( user_id number(10) default '0' NOT NULL, bug_id number(10) default '0' NOT NULL )");
+					log_query("ALTER TABLE ".TBL_COMPONENT." ADD ( sort_order number(3) default '0' NOT NULL )");
+					log_query("ALTER TABLE ".TBL_VERSION." ADD ( sort_order number(3) default '0' NOT NULL )");
+					log_query("CREATE SEQUENCE ".TBL_PRIORITY."_seq START WITH 6 NOCACHE");
 				}
 				break;
 		}

Re: [phpBT-dev] Patches for phpBT 1.0

[Ulf E. <ulf...@fa...>]

> With all the patches flying in to HEAD (thanks!) should we go for a
> 1.1 release (which would include all the patches) rather than a 1.0.1
> (which would just include bug fixes)?

I would vote for the 1.0.1 update. You spent over a year to make sure
that the 1.0 release was stable. There have hardly been any complaints
on the release. Breaking that by adding half-tested features doesn't
sound wise.

What do you think of announcing the update/release a bit wider next
time? :)

Why not asking at the localization mailing list and the web forum for
help with some more translations? Maybe ask earlier translators directly
whether they wish to help again. I have also thought of "converting"
translations from the old translation template to the new one and
include such as stubs. How does that sound?


I will try to come up with a TODO list for how I would like to bring
phpBT-devel into v1.1. Hope we can discuss it then: add or remove some
points, move them around and plan where to have releases of development
snapshots.

-- 
Ulf

Re: [phpBT-dev] Recent commits

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

Oh, and I will try to test on postgres as I get time.

On Aug 29, 2005, at 3:07 PM, Benjamin Curtis wrote:

> Yeah, I started to test some of the new features and got some  
> breakage with mysqli and the bookmark queries.  I didn't have time  
> to really look, but it seemed like mysqli.php was missing some  
> queries.  Since the queries should really be the same as in  
> mysql.php, we should probably just load mysql.php even when mysqli  
> is selected as the database type.
>
> On Aug 29, 2005, at 12:44 PM, Ulf Erikson wrote:
>
>
>> * Ulf Erikson [2005-08-23 23:42]:
>>
>>
>>>> This is just a minor warning or heads up if someone wish to play  
>>>> with them: The update script is not ready yet not is support for  
>>>> Oracle or Postgres. Hopefully this will be added "soon".
>>>>
>>>>
>>> I have updated inc/db/*.php and schemas/*.in. Things might work  
>>> in Oracle and Postgres now. I have no way to test it myself.. Any  
>>> volunteers? ;-)
>>>
>>>
>>
>> Finally is upgrade.php also updated, but only for MySQL. Anyone  
>> willing to help with the others? Anyone daring to test the new  
>> features?
>>
>> /Ulf
>>
>>
>> -------------------------------------------------------
>> SF.Net email is Sponsored by the Better Software Conference & EXPO
>> September 19-22, 2005 * San Francisco, CA * Development Lifecycle  
>> Practices
>> Agile & Plan-Driven Development * Managing Projects & Teams *  
>> Testing & QA
>> Security * Process Improvement & Measurement * http://www.sqe.com/ 
>> bsce5sf
>> _______________________________________________
>> phpbt-dev mailing list
>> php...@li...
>> https://lists.sourceforge.net/lists/listinfo/phpbt-dev
>>
>>
>
>
>
> -------------------------------------------------------
> SF.Net email is Sponsored by the Better Software Conference & EXPO
> September 19-22, 2005 * San Francisco, CA * Development Lifecycle  
> Practices
> Agile & Plan-Driven Development * Managing Projects & Teams *  
> Testing & QA
> Security * Process Improvement & Measurement * http://www.sqe.com/ 
> bsce5sf
> _______________________________________________
> phpbt-dev mailing list
> php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpbt-dev
>

Re: [phpBT-dev] Patches for phpBT 1.0

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

With all the patches flying in to HEAD (thanks!) should we go for a
1.1 release (which would include all the patches) rather than a 1.0.1
(which would just include bug fixes)?


On Aug 29, 2005, at 12:50 PM, Ulf Erikson wrote:

> * Ulf Erikson [2005-08-29 21:42]:
>
>> Could you please look at the attached patch for inclusion in the  
>> 1.0 branch?
>>
>
> Almost forgot.. when updating the various schemas I also found two  
> faults in the old Oracle support.
>
>  1) There are two syntax errors in inc/db/oci8.php
>  2) There is no EditAssignment permission in schemas/oci8.in
>
> /Ulf
> Index: schemas/oci8.in
> ===================================================================
> RCS file: /cvsroot/phpbt/phpbt/schemas/oci8.in,v
> retrieving revision 1.28
> diff -u -w -r1.28 oci8.in
> --- schemas/oci8.in    20 Jun 2005 01:05:29 -0000    1.28
> +++ schemas/oci8.in    29 Aug 2005 19:49:27 -0000
> @@ -297,6 +297,7 @@
>  -- ... 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');
> +INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (3,  
> 'EditAssignment');
>
>  -- Admins can do all the admin stuff and users can edit bugs
>  INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (1, 1);
> Index: inc/db/oci8.php
> ===================================================================
> RCS file: /cvsroot/phpbt/phpbt/inc/db/oci8.php,v
> retrieving revision 1.18
> diff -u -w -r1.18 oci8.php
> --- inc/db/oci8.php    30 May 2005 19:59:35 -0000    1.18
> +++ inc/db/oci8.php    29 Aug 2005 19:49:27 -0000
> @@ -115,11 +115,11 @@
>          'where p.project_id = pg.project_id(+) and active = 1 '.
>          'and (pg.project_id is null or pg.group_id in (%s)) '.
>          'group by p.project_id, p.project_name order by  
> project_name',
> -    'include-template-owner' => SELECT sum(decode( s.status_id in  
> (".OPEN_BUG_STATUSES.") , 1, 1, 0 )), ".
> +    'include-template-owner' => "SELECT sum(decode( s.status_id in  
> (".OPEN_BUG_STATUSES.") , 1, 1, 0 )), ".
>          "sum(decode( s.status_id not in (".OPEN_BUG_STATUSES.") ,  
> 1, 1, 0 )), ".
>          'from '.TBL_BUG.' b, '.TBL_STATUS.' s '.
>          'where  b.status_id = s.status_id (+) and b.assigned_to = % 
> s',
> -    'include-template-reporter' => SELECT sum(decode( s.status_id  
> in (".OPEN_BUG_STATUSES.") , 1, 1, 0 )) , ".
> +    'include-template-reporter' => "SELECT sum(decode( s.status_id  
> in (".OPEN_BUG_STATUSES.") , 1, 1, 0 )) , ".
>          "sum(decode( s.status_id not in (".OPEN_BUG_STATUSES.") ,  
> 1, 1, 0 )) ".
>          'from '.TBL_BUG.' b, ' . TBL_STATUS.' s '.
>          'where  b.status_id = s.status_id (+) and b.created_by = %s',
>

Re: [phpBT-dev] Recent commits

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

Yeah, I started to test some of the new features and got some  
breakage with mysqli and the bookmark queries.  I didn't have time to  
really look, but it seemed like mysqli.php was missing some queries.   
Since the queries should really be the same as in mysql.php, we  
should probably just load mysql.php even when mysqli is selected as  
the database type.

On Aug 29, 2005, at 12:44 PM, Ulf Erikson wrote:

> * Ulf Erikson [2005-08-23 23:42]:
>
>>> This is just a minor warning or heads up if someone wish to play  
>>> with them: The update script is not ready yet not is support for  
>>> Oracle or Postgres. Hopefully this will be added "soon".
>>>
>> I have updated inc/db/*.php and schemas/*.in. Things might work in  
>> Oracle and Postgres now. I have no way to test it myself.. Any  
>> volunteers? ;-)
>>
>
> Finally is upgrade.php also updated, but only for MySQL. Anyone  
> willing to help with the others? Anyone daring to test the new  
> features?
>
> /Ulf
>
>
> -------------------------------------------------------
> SF.Net email is Sponsored by the Better Software Conference & EXPO
> September 19-22, 2005 * San Francisco, CA * Development Lifecycle  
> Practices
> Agile & Plan-Driven Development * Managing Projects & Teams *  
> Testing & QA
> Security * Process Improvement & Measurement * http://www.sqe.com/ 
> bsce5sf
> _______________________________________________
> phpbt-dev mailing list
> php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpbt-dev
>

Re: [phpBT-dev] Patches for phpBT 1.0

[Ulf E. <ulf...@fa...>]

* Ulf Erikson [2005-08-29 21:42]:
> Could you please look at the attached patch for inclusion in the 1.0 
> branch?

Almost forgot.. when updating the various schemas I also found two 
faults in the old Oracle support.

  1) There are two syntax errors in inc/db/oci8.php
  2) There is no EditAssignment permission in schemas/oci8.in

/Ulf

Re: [phpBT-dev] Recent commits

[Ulf E. <ulf...@fa...>]

* Ulf Erikson [2005-08-23 23:42]:
>> This is just a minor warning or heads up if someone wish to play with 
>> them: The update script is not ready yet not is support for Oracle or 
>> Postgres. Hopefully this will be added "soon".
> 
> I have updated inc/db/*.php and schemas/*.in. Things might work in 
> Oracle and Postgres now. I have no way to test it myself.. Any 
> volunteers? ;-)

Finally is upgrade.php also updated, but only for MySQL. Anyone willing 
to help with the others? Anyone daring to test the new features?

/Ulf

[phpBT-dev] Patches for phpBT 1.0

[Ulf E. <ulf...@fa...>]

Benjamin,

Could you please look at the attached patch for inclusion in the 1.0 
branch? It fixes various permission related issues:

  * Bugs item #782962 - How to restrain task assignment only to users at 
admin group
  * Bugs item #1017788 - Managers Cannot Change Bug Details
  * Bugs item #1034495 - New user can set another reporter for bug
  * Bugs item #1060247 - Project Admin cannot change assignments

In v1.0 there are three user groups: Admin, User and Developer. There 
are also three permissions: Admin, EditBug and EditAssignment.

But the code checks for the permissions 'Administrator' and 'Manager' as 
well as the group 'Users'. The patch changes this to check for the 
'Admin' permission, whether the developer is a project admin, and 
whether the user is logged on. Other code changes include giving project 
admins a link to the admin pages and to only allow (project) admins to 
alter the reporter.

/Ulf