Menu
▾
▴
phpbt-dev — Developer's mailing list and cvs commits
You can subscribe to this list here.
| 2001 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
(34) |
Aug
(215) |
Sep
(180) |
Oct
(135) |
Nov
(105) |
Dec
(81) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2002 |
Jan
(76) |
Feb
(22) |
Mar
(154) |
Apr
(149) |
May
(128) |
Jun
(94) |
Jul
(14) |
Aug
(24) |
Sep
(77) |
Oct
(52) |
Nov
(22) |
Dec
(6) |
| 2003 |
Jan
(4) |
Feb
(10) |
Mar
(6) |
Apr
(29) |
May
(10) |
Jun
(37) |
Jul
(39) |
Aug
(13) |
Sep
(23) |
Oct
(3) |
Nov
(7) |
Dec
(2) |
| 2004 |
Jan
|
Feb
(10) |
Mar
(4) |
Apr
|
May
(35) |
Jun
(4) |
Jul
(17) |
Aug
(6) |
Sep
(14) |
Oct
(18) |
Nov
(2) |
Dec
(14) |
| 2005 |
Jan
(9) |
Feb
(30) |
Mar
(6) |
Apr
|
May
(38) |
Jun
(23) |
Jul
(21) |
Aug
(76) |
Sep
(50) |
Oct
(51) |
Nov
(13) |
Dec
|
|
From: Benjamin C. <bc...@us...> - 2001-11-07 18:33:46
|
Update of /cvsroot/phpbt/phpbt/languages In directory usw-pr-cvs1:/tmp/cvs-serv25152/languages Added Files: gb2312.php Log Message: Chinese strings --- NEW FILE: gb2312.php --- <?php // gb2312.php - Chinese strings and titles // ------------------------------------------------------------------------ // Copyright (c) 2001 The phpBugTracker Group // ------------------------------------------------------------------------ // This file is part of phpBugTracker // // phpBugTracker is free software; you can redistribute it and/or modify // it under the terms of the GNU General Public License as published by // the Free Software Foundation; either version 2 of the License, or // (at your option) any later version. // // phpBugTracker is distributed in the hope that it will be useful, // but WITHOUT ANY WARRANTY; without even the implied warranty of // MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the // GNU General Public License for more details. // // You should have received a copy of the GNU General Public License // along with phpBugTracker; if not, write to the Free Software Foundation, // Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. // ------------------------------------------------------------------------ // $Id $ // ------------------------------------------------------------------------ // Translated by liaobin(lia...@37...) // ------------------------------------------------------------------------ $STRING = array( 'lang_charset' => 'gb2312', 'nouser' => 'Óû§²»´æÔÚ', 'dupeofself' => 'Ò»¸öBug²»ÄÜͬËü±¾ÉíÖظ´', 'nobug' => 'Õâ¸öBug²»´æÔÚ', 'givesummary' => 'Çë¸ø³ö¸ÅÊö', 'givedesc' => 'Çë¸ø³ö¾ßÌåÃèÊö', 'noprojects' => 'ûÓÐÕÒµ½ÏîÄ¿', 'totalbugs' => '¹²ÓÐBug', 'giveemail' => 'ÇëÊäÈëÒ»¸öÓÐЧµÄemailÃû', 'givelogin' => 'ÇëÊäÈëµÇ¼Óû§Ãû', 'loginused' => 'Õâ¸öµÇ¼Óû§ÃûÒѾ±»Ê¹ÓÃ', 'newacctsubject' => 'phpBugTracker µÇ¼', 'newacctmessage' => "ÄúµÄ phpBugTracker ÃÜÂëÊÇ %s", 'nobugs' => 'ûÓÐBugÕÒµ½', 'givename' => 'ÇëÊäÈëÐÕÃû', 'edit' => '±à¼', 'addnew' => 'Ìí¼Ó', 'nooses' => 'ûÓÐ OSes ÕÒµ½', 'giveinitversion' => 'ÇëÊäÈëÏîÄ¿µÄ³õʼ»¯°æ±¾ºÅ', 'giveversion' => 'ÇëÊäÈë°æ±¾ºÅ', 'noversions' => 'ûÓа汾ºÅ±»ÕÒµ½', 'nocomponents' => 'ûÓÐÏîÄ¿µ¥Ôª±»ÕÒµ½', 'nostatuses' => 'ûÓÐ״̬±»ÕÒµ½', 'noseverities' => 'ûÓÐÑÏÖس̶ȱ»ÕÒµ½', 'givepassword' => 'ÇëÊäÈëÒ»¸öÃÜÂë', 'nousers' => 'ûÓÐÓû§ÕÒµ½', 'bugbadperm' => 'Äú²»Äܸü¸ÄÕâ¸öBug', 'bugbadnum' => 'Õâ¸öBug²»´æÔÚ', 'datecollision' => 'ÔÚÄú¿´¹ýÕâ¸öbugÖ®ºó£¬ÓÐÈ˸üÐÂÁËÕâ¸öBug. Õâ¸ö bug µÄÐÅÏ¢ÒѾÔÚ×îºóÒ»´Î±ä¸üºóÖØÔØÁË.', 'passwordmatch' => 'ÃÜÂ벻ƥÅä -- ÇëÔÙÊÔÒ»±é', 'nobughistory' => 'Õâ¸öbugûÓÐÀúÊ·', 'logintomodify' => 'ÄúÐÞ¸ÄÕâ¸öbug±ØÐëÏȵǼ', 'dupe_attachment' => 'Õâ¸öbugµÄ¸½¼þÒѾ´æÔÚ', 'give_attachment' => 'Çë¸ø³öÐèÒªÉÏÔصÄÎļþÃû', 'no_attachment_save_path' => 'ûÓÐÕÒµ½¸½¼þÎļþµÄÉÏÔØ·¾¶!', 'attachment_path_not_writeable' => '¸½¼þÉÏÔØ·¾¶²»ÄÜд!', 'attachment_move_error' => 'Òƶ¯¸½¼þʱ³ö´í', 'bad_attachment' => '¸½¼þ²»´æÔÚ', 'attachment_too_large' => 'ÄúÉÏÔصĸ½¼þ´óÓÚ '.number_format(ATTACHMENT_MAX_SIZE).' ×Ö½Ú', 'bad_permission' => 'ÄúûÓÐʹÓÃÕâ¸ö¹¦ÄܵÄȨÏÞ' ); // Page titles $TITLE = array( 'enterbug' => 'ÊäÈëÒ»¸öbug', 'editbug' => '±à¼bug', 'newaccount' => '´´½¨ÐÂÓû§', 'bugquery' => '²éѯBug ', 'buglist' => 'Bug Áбí', 'addcomponent' => 'Ìí¼ÓÒ»¸öµ¥Ôª', 'editcomponent' => '±à¼Ò»¸öµ¥Ôª', 'addproject' => 'Ìí¼ÓÒ»¸öÏîÄ¿', 'editproject' => '±à¼Ò»¸öÏîÄ¿', 'addversion' => 'Ìí¼Ó°æ±¾ºÅ', 'editversion' => '±à¼°æ±¾ºÅ', 'project' => 'ÏîÄ¿', 'os' => '²Ù×÷ϵͳ', 'resolution' => '½â¾ö·½·¨', 'status' => '״̬', 'severity' => 'ÑÏÖس̶È', 'user' => 'Óû§', 'home' => 'Ö÷Ò³Ãæ', 'reporting' => '±¨±í' ); ?> |
|
From: Benjamin C. <bc...@us...> - 2001-11-07 18:06:21
|
Update of /cvsroot/phpbt/phpbt In directory usw-pr-cvs1:/tmp/cvs-serv18265 Modified Files: TODO Log Message: Bugzilla conversion script Index: TODO =================================================================== RCS file: /cvsroot/phpbt/phpbt/TODO,v retrieving revision 1.9 retrieving revision 1.10 diff -u -r1.9 -r1.10 --- TODO 2001/10/17 12:41:47 1.9 +++ TODO 2001/11/07 18:06:18 1.10 @@ -10,3 +10,4 @@ Misc: - Be able to color by priority instead of severity +- Conversion script from a bugzilla database |
|
From: Javier S. <js...@si...> - 2001-11-07 01:09:26
|
OK ben :-) Just want to answer you about AdoDB and Smarty, both seems to be very powerfull Libs ... and so populate. I never used any of their, but it will be a good think ... PHPlib would only be used for Sessions And perms so ? Have you ever used phpbt.dyndns.org for test purpose ? (i think i have gived to you acces login/pass , isn'it ?) There is 2 phpbts working on this host,whith last CVS snpashot, http://phpbt.dyndns.org/phpbt-my/ -> Mysql DB http://phpbt.dyndns.org/phpbt-pg/ -> postgres DB there some WebAdmin DB stuff on http://phpbt.dyndns.org/mysql/ http://phpbt.dyndns.org/pgsql/ I rember that phpbt.dyndns.org is hosted my little P166 whith a cable connection (380/64 Kbits), it's a test/dev server only. Here is versions numbers : Apache : Apache/1.3.19 (Unix) (Red-Hat/Linux) PHP : 4.0.6 Mysql : 3.23.36 PostgreSQL : 7.1.3 Kernel : 2.4.2 (RedHat 7.1 default) About Version 0.5.0 , i have found some bugs on Postgres, there is a Display Date problem on all Lists, format is bugged, but it works. JpGraph seems to have some problems whith image.php, it show only 3 bugs ... even if there is much more. Well this list is note exclusive, If anybody wants to found more ;-) Ben Curtis wrote: >I'm working towards getting 0.5.0 out the door by the end of this week, so if you have some extra time to hammer on it, I'd appreciate you finding everything I broke. :) > >_______________________________________________ >phpbt-dev mailing list >php...@li... >https://lists.sourceforge.net/lists/listinfo/phpbt-dev > |
|
From: Benjamin C. <bc...@us...> - 2001-11-06 16:42:08
|
Update of /cvsroot/phpbt/phpbt/schemas
In directory usw-pr-cvs1:/tmp/cvs-serv17786/schemas
Modified Files:
mysql.in
Log Message:
Added missing semi-colons
Index: mysql.in
===================================================================
RCS file: /cvsroot/phpbt/phpbt/schemas/mysql.in,v
retrieving revision 1.8
retrieving revision 1.9
diff -u -r1.8 -r1.9
--- mysql.in 2001/11/06 04:39:47 1.8
+++ mysql.in 2001/11/06 16:42:05 1.9
@@ -272,8 +272,8 @@
INSERT INTO TBL_CONFIGURATION VALUES ('HIDE_EMAIL','1','Should email addresses be hidden for those not logged in?','bool');
INSERT INTO TBL_CONFIGURATION VALUES ('USE_SEVERITY_COLOR','1','Should the query list use the severity colors as the row background color (like SourceForge)','bool');
INSERT INTO TBL_CONFIGURATION VALUES ('EMAIL_IS_LOGIN','1','Whether to use email addresses as logins','bool');
-INSERT INTO TBL_CONFIGURATION VALUES ('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 ('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 ('ATTACHMENT_PATH','attachments','Sub-dir of the INSTALLPATH - Needs to be writeable by the web process','string');
INSERT INTO TBL_CONFIGURATION VALUES ('THEME','default','Which set of templates to use','multi');
INSERT INTO TBL_CONFIGURATION VALUES ('ATTACHMENT_MAX_SIZE','2097152','Maximum size (in bytes) of an attachment. This will not override the settings in php.ini if php.ini has a lower limit.','string');
|
|
From: Michael B. <mb...@us...> - 2001-11-06 16:17:02
|
Update of /cvsroot/phpbt/phpbt/schemas
In directory usw-pr-cvs1:/tmp/cvs-serv3270/schemas
Modified Files:
pgsql.in
Log Message:
couple of missing semicolong prevented web-based install from working
Index: pgsql.in
===================================================================
RCS file: /cvsroot/phpbt/phpbt/schemas/pgsql.in,v
retrieving revision 1.10
retrieving revision 1.11
diff -u -r1.10 -r1.11
--- pgsql.in 2001/11/06 04:39:47 1.10
+++ pgsql.in 2001/11/06 16:16:59 1.11
@@ -265,23 +265,41 @@
INSERT INTO TBL_USER_GROUP (user_id, group_id) VALUES (1, 2);
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','string');
+
INSERT INTO TBL_CONFIGURATION VALUES ('CVS_WEB','http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/phpbt/phpbt/','Location of your cvs web interface (see format_comments() in bug.php)','string');
+
INSERT INTO TBL_CONFIGURATION VALUES ('ADMIN_EMAIL','OPTION_PHPBT_EMAIL','The email address used in correspondence from the bug tracker','string');
+
INSERT INTO TBL_CONFIGURATION VALUES ('ENCRYPT_PASS','OPTION_ENCRYPT_PASS','Whether to store passwords encrypted. <b>Warning:</b> Changing this after users have been created will result in their being unable to login.','bool');
+
INSERT INTO TBL_CONFIGURATION VALUES ('USE_JPGRAPH','','Whether to show some reports as images','bool');
+
INSERT INTO TBL_CONFIGURATION VALUES ('MASK_EMAIL','1','Should email addresses have . changed to \'dot\' and @ change to \'at\'?','bool');
+
INSERT INTO TBL_CONFIGURATION VALUES ('HIDE_EMAIL','1','Should email addresses be hidden for those not logged in?','bool');
+
INSERT INTO TBL_CONFIGURATION VALUES ('USE_SEVERITY_COLOR','1','Should the query list use the severity colors as the row background color (like SourceForge)','bool');
+
INSERT INTO TBL_CONFIGURATION VALUES ('EMAIL_IS_LOGIN','1','Whether to use email addresses as logins','bool');
-INSERT INTO TBL_CONFIGURATION VALUES ('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 ('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 ('ATTACHMENT_PATH','attachments','Sub-dir of the INSTALLPATH - Needs to be writeable by the web process','string');
+
INSERT INTO TBL_CONFIGURATION VALUES ('THEME','default','Which set of templates to use','multi');
+
INSERT INTO TBL_CONFIGURATION VALUES ('ATTACHMENT_MAX_SIZE','2097152','Maximum size (in bytes) of an attachment. This will not override the settings in php.ini if php.ini has a lower limit.','string');
+
INSERT INTO TBL_CONFIGURATION VALUES ('DATE_FORMAT','m-d-Y','See the <a href="http://www.php.net/date" target="_new">date page</a> in the PHP manual for more info','string');
+
INSERT INTO TBL_CONFIGURATION VALUES ('TIME_FORMAT','g:i A','See the <a href="http://www.php.net/date" target="_new">date page</a> in the PHP manual for more info','string');
+
INSERT INTO TBL_CONFIGURATION VALUES ('LANGUAGE','en','The language file to use for warning and error messages','multi');
+
INSERT INTO TBL_OS VALUES (1,'All',1,'');
INSERT INTO TBL_OS VALUES (2,'Windows 3.1',2,'/Mozilla.*\\(Win16.*\\)/');
|
|
From: Ben C. <php...@be...> - 2001-11-06 13:13:26
|
I'm working towards getting 0.5.0 out the door by the end of this week, so if you have some extra time to hammer on it, I'd appreciate you finding everything I broke. :) |
|
From: Benjamin C. <bc...@us...> - 2001-11-06 09:06:34
|
Update of /cvsroot/phpbt/phpbt/schemas In directory usw-pr-cvs1:/tmp/cvs-serv4424/schemas Modified Files: pgsql.in Log Message: Avoid space-padded strings Index: pgsql.in =================================================================== RCS file: /cvsroot/phpbt/phpbt/schemas/pgsql.in,v retrieving revision 1.8 retrieving revision 1.9 diff -u -r1.8 -r1.9 --- pgsql.in 2001/10/30 04:02:45 1.8 +++ pgsql.in 2001/11/06 04:04:02 1.9 @@ -21,10 +21,10 @@ CREATE TABLE TBL_ATTACHMENT ( attachment_id INT4 NOT NULL DEFAULT '0', bug_id INT4 NOT NULL DEFAULT '0', - file_name char(255) NOT NULL DEFAULT '', - description char(255) NOT NULL DEFAULT '', + file_name varchar(255) NOT NULL DEFAULT '', + description varchar(255) NOT NULL DEFAULT '', file_size INT8 NOT NULL DEFAULT '0', - mime_type char(30) NOT NULL DEFAULT '', + mime_type varchar(30) NOT NULL DEFAULT '', created_by INT4 NOT NULL DEFAULT '0', created_date INT8 NOT NULL DEFAULT '0', PRIMARY KEY (attachment_id) @@ -52,13 +52,13 @@ CREATE TABLE TBL_AUTH_USER ( user_id INT4 NOT NULL DEFAULT '0', - login char(40) NOT NULL DEFAULT '', - first_name char(40) NOT NULL DEFAULT '', - last_name char(40) NOT NULL DEFAULT '', - email char(60) NOT NULL DEFAULT '', - password char(40) NOT NULL DEFAULT '', + login varchar(40) NOT NULL DEFAULT '', + first_name varchar(40) NOT NULL DEFAULT '', + last_name varchar(40) NOT NULL DEFAULT '', + email varchar(60) NOT NULL DEFAULT '', + password varchar(40) NOT NULL DEFAULT '', active INT2 NOT NULL DEFAULT '1', - bug_list_fields char(255) NOT NULL DEFAULT '', + bug_list_fields varchar(255) NOT NULL DEFAULT '', created_by INT4 NOT NULL DEFAULT '0', created_date INT8 NOT NULL DEFAULT '0', last_modified_by INT4 NOT NULL DEFAULT '0', @@ -105,9 +105,9 @@ CREATE TABLE TBL_BUG_HISTORY ( bug_id INT4 NOT NULL DEFAULT '0', - changed_field char(20) NOT NULL DEFAULT '', - old_value char(255) NOT NULL DEFAULT '', - new_value char(255) NOT NULL DEFAULT '', + changed_field varchar(20) NOT NULL DEFAULT '', + old_value varchar(255) NOT NULL DEFAULT '', + new_value varchar(255) NOT NULL DEFAULT '', created_by INT4 NOT NULL DEFAULT '0', created_date INT8 NOT NULL DEFAULT '0' ); @@ -139,7 +139,7 @@ varname varchar(40) NOT NULL DEFAULT '', varvalue varchar(255) NOT NULL DEFAULT '', description varchar(255) NOT NULL DEFAULT '', - vartype char(20) NOT NULL DEFAULT '', + vartype varchar(20) NOT NULL DEFAULT '', PRIMARY KEY (varname) ); @@ -157,9 +157,9 @@ CREATE TABLE TBL_OS ( os_id INT4 NOT NULL DEFAULT '0', - os_name char(30) NOT NULL DEFAULT '', + os_name varchar(30) NOT NULL DEFAULT '', sort_order INT2 NOT NULL DEFAULT '0', - regex char(40) NOT NULL DEFAULT '', + regex varchar(40) NOT NULL DEFAULT '', PRIMARY KEY (os_id) ); @@ -228,7 +228,7 @@ CREATE TABLE TBL_VERSION ( version_id INT4 NOT NULL DEFAULT '0', project_id INT4 NOT NULL DEFAULT '0', - version_name char(10) NOT NULL DEFAULT '', + version_name varchar(10) NOT NULL DEFAULT '', active INT2 NOT NULL DEFAULT '1', created_by INT4 NOT NULL DEFAULT '0', created_date INT8 NOT NULL DEFAULT '0', |
|
From: Benjamin C. <bc...@us...> - 2001-11-06 09:06:23
|
Update of /cvsroot/phpbt/phpbt In directory usw-pr-cvs1:/tmp/cvs-serv4632 Removed Files: configure_db Log Message: Not needed with web installation --- configure_db DELETED --- |
|
From: Benjamin C. <bc...@us...> - 2001-11-06 09:04:12
|
Update of /cvsroot/phpbt/phpbt
In directory usw-pr-cvs1:/tmp/cvs-serv4107
Added Files:
upgrade.php
Log Message:
Files for upgrading from previous version
--- NEW FILE: upgrade.php ---
<?php
// upgrade.php -- Upgrade from the previous version
define ('NO_AUTH', 1);
include 'include.php';
function upgrade() {
global $q;
$upgraded = $q->grab_field("select count(*) from ". TBL_CONFIGURATION.
" where varname = 'STRICT_UPDATING'");
if (!$upgraded) {
// Move the support tables to use the table prefix
// (if the table prefix is non-empty)
if (strlen(TBL_PREFIX)) {
$q->Halt_On_Error = 'no'; // We're going to ignore errors
$db_sess_table = ereg_replace(TBL_PREFIX, '', TBL_ACTIVE_SESSIONS);
$db_seq_table = ereg_replace(TBL_PREFIX, '', TBL_DB_SEQUENCE);
$q->query("alter table $db_sess_table rename to ". TBL_ACTIVE_SESSIONS);
$q->query("alter table $db_seq_table rename to ". TBL_DB_SEQUENCE);
$q->Halt_On_Error = 'yes'; // Stop ignoring errors
}
// New configuration option
$q->query('insert into '. TBL_CONFIGURATION.
" (varname, varvalue, description, vartype) values ('STRICT_UPDATING', '0',
'Only the bug reporter, bug owner, managers, and admins can change a bug',
'bool')");
}
include 'templates/default/upgrade-finished.html';
}
if ($doit) {
upgrade();
} else {
include 'templates/default/upgrade.html';
}
?>
|
|
From: Benjamin C. <bc...@us...> - 2001-11-06 09:02:53
|
Update of /cvsroot/phpbt/phpbt/templates/default In directory usw-pr-cvs1:/tmp/cvs-serv4107/templates/default Added Files: upgrade-finished.html upgrade.html Log Message: Files for upgrading from previous version --- NEW FILE: upgrade-finished.html --- <html> <head> <title>Upgade phpBT</title> </head> <body> <div align="center"> <br> <br> Your database has been updated. <br> <br> <a href="index.php">phpBugTracker home</a> </div> </body> </html> --- NEW FILE: upgrade.html --- <html> <head> <title>Upgade phpBT</title> </head> <body> <div align="center"> <br> <br> This script will upgrade your database from version 0.4.0 to version 0.5.0 of phpBugTracker. <br> <br> <a href="<?php echo $HTTP_SERVER_VARS['PHP_SELF']; ?>?doit=1">Do it!</a> </div> </body> </html> |
|
From: Benjamin C. <bc...@us...> - 2001-11-06 08:40:23
|
Update of /cvsroot/phpbt/phpbt/schemas
In directory usw-pr-cvs1:/tmp/cvs-serv21077/schemas
Modified Files:
mysql.in pgsql.in
Log Message:
New config options
Index: mysql.in
===================================================================
RCS file: /cvsroot/phpbt/phpbt/schemas/mysql.in,v
retrieving revision 1.7
retrieving revision 1.8
diff -u -r1.7 -r1.8
--- mysql.in 2001/10/30 04:02:45 1.7
+++ mysql.in 2001/11/06 04:39:47 1.8
@@ -272,6 +272,8 @@
INSERT INTO TBL_CONFIGURATION VALUES ('HIDE_EMAIL','1','Should email addresses be hidden for those not logged in?','bool');
INSERT INTO TBL_CONFIGURATION VALUES ('USE_SEVERITY_COLOR','1','Should the query list use the severity colors as the row background color (like SourceForge)','bool');
INSERT INTO TBL_CONFIGURATION VALUES ('EMAIL_IS_LOGIN','1','Whether to use email addresses as logins','bool');
+INSERT INTO TBL_CONFIGURATION VALUES ('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 ('ATTACHMENT_PATH','attachments','Sub-dir of the INSTALLPATH - Needs to be writeable by the web process','string');
INSERT INTO TBL_CONFIGURATION VALUES ('THEME','default','Which set of templates to use','multi');
INSERT INTO TBL_CONFIGURATION VALUES ('ATTACHMENT_MAX_SIZE','2097152','Maximum size (in bytes) of an attachment. This will not override the settings in php.ini if php.ini has a lower limit.','string');
Index: pgsql.in
===================================================================
RCS file: /cvsroot/phpbt/phpbt/schemas/pgsql.in,v
retrieving revision 1.9
retrieving revision 1.10
diff -u -r1.9 -r1.10
--- pgsql.in 2001/11/06 04:04:02 1.9
+++ pgsql.in 2001/11/06 04:39:47 1.10
@@ -274,6 +274,8 @@
INSERT INTO TBL_CONFIGURATION VALUES ('HIDE_EMAIL','1','Should email addresses be hidden for those not logged in?','bool');
INSERT INTO TBL_CONFIGURATION VALUES ('USE_SEVERITY_COLOR','1','Should the query list use the severity colors as the row background color (like SourceForge)','bool');
INSERT INTO TBL_CONFIGURATION VALUES ('EMAIL_IS_LOGIN','1','Whether to use email addresses as logins','bool');
+INSERT INTO TBL_CONFIGURATION VALUES ('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 ('ATTACHMENT_PATH','attachments','Sub-dir of the INSTALLPATH - Needs to be writeable by the web process','string');
INSERT INTO TBL_CONFIGURATION VALUES ('THEME','default','Which set of templates to use','multi');
INSERT INTO TBL_CONFIGURATION VALUES ('ATTACHMENT_MAX_SIZE','2097152','Maximum size (in bytes) of an attachment. This will not override the settings in php.ini if php.ini has a lower limit.','string');
|
|
From: Benjamin C. <bc...@us...> - 2001-11-06 08:40:13
|
Update of /cvsroot/phpbt/phpbt/templates/default In directory usw-pr-cvs1:/tmp/cvs-serv21386/templates/default Added Files: newaccount-disabled.html Log Message: New option for disabling newaccount.php --- NEW FILE: newaccount-disabled.html --- <table width="640" border="0"> <tr> <td align="center"> Sorry, but the self-creation of new accounts has been disabled. Please contact the administrator to have an account created for you. </td> </tr> </table> |
|
From: Benjamin C. <bc...@us...> - 2001-11-06 08:40:13
|
Update of /cvsroot/phpbt/phpbt
In directory usw-pr-cvs1:/tmp/cvs-serv21386
Modified Files:
upgrade.php newaccount.php
Log Message:
New option for disabling newaccount.php
Index: upgrade.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/upgrade.php,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- upgrade.php 2001/11/06 04:03:28 1.1
+++ upgrade.php 2001/11/06 04:40:18 1.2
@@ -22,10 +22,15 @@
$q->Halt_On_Error = 'yes'; // Stop ignoring errors
}
- // New configuration option
+ // New configuration options
$q->query('insert into '. TBL_CONFIGURATION.
" (varname, varvalue, description, vartype) values ('STRICT_UPDATING', '0',
'Only the bug reporter, bug owner, managers, and admins can change a bug',
+ 'bool')");
+ $q->query('insert into '. TBL_CONFIGURATION.
+ " (varname, varvalue, description, vartype) values
+ ('NEW_ACCOUNTS_DISABLED', '0',
+ 'Only admins can create new user accounts - newaccount.php is disabled',
'bool')");
}
include 'templates/default/upgrade-finished.html';
Index: newaccount.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/newaccount.php,v
retrieving revision 1.19
retrieving revision 1.20
diff -u -r1.19 -r1.20
--- newaccount.php 2001/10/24 03:03:58 1.19
+++ newaccount.php 2001/11/06 04:40:18 1.20
@@ -27,6 +27,11 @@
function do_form() {
global $q, $t, $_pv, $STRING, $now, $u;
+ if (NEW_ACCOUNTS_DISABLED) {
+ $t->set_file('content', 'newaccount-disabled');
+ return;
+ }
+
if (!EMAIL_IS_LOGIN && !$_pv['login'] = trim($_pv['login']))
$error = $STRING['givelogin'];
elseif (!$_pv['email'] or !valid_email($_pv['email']))
@@ -63,6 +68,11 @@
function show_form($error = '') {
global $q, $t, $_pv;
+ if (NEW_ACCOUNTS_DISABLED) {
+ $t->set_file('content', 'newaccount-disabled.html');
+ return;
+ }
+
$t->set_file('content','newaccount.html');
$t->set_block('content', 'loginentryarea', 'loginarea');
$t->set_var(array(
|
|
From: Benjamin C. <bc...@us...> - 2001-11-06 08:39:58
|
Update of /cvsroot/phpbt/phpbt
In directory usw-pr-cvs1:/tmp/cvs-serv21846
Modified Files:
upgrade.php
Log Message:
Forgot the extra headers :)
Index: upgrade.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/upgrade.php,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -r1.2 -r1.3
--- upgrade.php 2001/11/06 04:40:18 1.2
+++ upgrade.php 2001/11/06 04:41:14 1.3
@@ -1,6 +1,26 @@
<?php
// upgrade.php -- Upgrade from the previous version
+// ------------------------------------------------------------------------
+// Copyright (c) 2001 The phpBugTracker Group
+// ------------------------------------------------------------------------
+// This file is part of phpBugTracker
+//
+// phpBugTracker is free software; you can redistribute it and/or modify
+// it under the terms of the GNU General Public License as published by
+// the Free Software Foundation; either version 2 of the License, or
+// (at your option) any later version.
+//
+// phpBugTracker is distributed in the hope that it will be useful,
+// but WITHOUT ANY WARRANTY; without even the implied warranty of
+// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+// GNU General Public License for more details.
+//
+// You should have received a copy of the GNU General Public License
+// along with phpBugTracker; if not, write to the Free Software Foundation,
+// Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
+// ------------------------------------------------------------------------
+// $Id$
define ('NO_AUTH', 1);
include 'include.php';
|
|
From: Benjamin C. <bc...@us...> - 2001-11-06 08:38:45
|
Update of /cvsroot/phpbt/phpbt In directory usw-pr-cvs1:/tmp/cvs-serv22590 Modified Files: CHANGELOG Log Message: Index: CHANGELOG =================================================================== RCS file: /cvsroot/phpbt/phpbt/CHANGELOG,v retrieving revision 1.24 retrieving revision 1.25 diff -u -r1.24 -r1.25 --- CHANGELOG 2001/11/03 19:24:07 1.24 +++ CHANGELOG 2001/11/06 04:42:43 1.25 @@ -4,6 +4,9 @@ : Added on option for choosing whether bugs can be changed only by the bug reporter, bug owner, managers, or admins. : Added a printable view for bugs +: Added an upgrade script to upgrade from the last major version +: Added an option to disable newaccount.php, thus preventing users from + creating accounts for themselves. -- 0.4.0 -- 18 Oct 2001 : Improved the CSS file to make choosing different color schemes easier. |
|
From: Benjamin C. <bc...@us...> - 2001-11-06 08:38:08
|
Update of /cvsroot/phpbt/phpbt In directory usw-pr-cvs1:/tmp/cvs-serv24306 Modified Files: CHANGELOG Log Message: A little clarification Index: CHANGELOG =================================================================== RCS file: /cvsroot/phpbt/phpbt/CHANGELOG,v retrieving revision 1.25 retrieving revision 1.26 diff -u -r1.25 -r1.26 --- CHANGELOG 2001/11/06 04:42:43 1.25 +++ CHANGELOG 2001/11/06 04:46:16 1.26 @@ -1,8 +1,8 @@ -- 0.5.0 -- : Fixed a bug with the bug history update. : Added web-based installation. -: Added on option for choosing whether bugs can be changed only by the bug - reporter, bug owner, managers, or admins. +: Added on option for choosing whether bugs can be changed by anyone or only by + the bug reporter, bug owner, managers, or admins. : Added a printable view for bugs : Added an upgrade script to upgrade from the last major version : Added an option to disable newaccount.php, thus preventing users from |
|
From: Benjamin C. <bc...@us...> - 2001-11-03 19:24:09
|
Update of /cvsroot/phpbt/phpbt/templates/default
In directory usw-pr-cvs1:/tmp/cvs-serv25896/templates/default
Modified Files:
bugdisplay.html
Added Files:
bugdisplay-printable.html
Log Message:
Added a printable view for bugs
--- NEW FILE: bugdisplay-printable.html ---
<table border='0' width="640">
<tr>
<td width="210" colspan="2">
Bug <b>#{bugid}</b>
</td>
<td width="210" colspan="2">
Reporter: <b>{reporter}</b>
</td>
<td width="210" colspan="2">
Created: <b>{createddate}</b>
</td>
</tr>
<tr>
<td>
Product:
</td>
<td>
{project}
</td>
<td>
Component:
</td>
<td>
{component}
</td>
<td>
Version:
</td>
<td>
{version}
</td>
</tr>
<tr>
<td>
Severity:
</td>
<td>
{severity}
</td>
<td>
Priority:
</td>
<td>
{priority}
</td>
<td>
OS:
</td>
<td>
{os}
</td>
</tr>
<tr>
<td colspan="6">
<hr size="1">
</td>
</tr>
</table>
<table border="0" cellpadding="2" cellspacing="0" width="640">
<tr>
<td>Assigned To:</td>
<td><b>{owner}</td>
<td colspan="2">
</td>
</tr>
<tr>
<td>Status:</td>
<td><b>{status}</b></td>
<td>Summary:</td>
<td>{title}</td>
</tr>
<tr>
<td>Resolution:</td>
<td><b>{resolution}</b></td>
<td>URL:</td>
<td>{url}</td>
</tr>
<tr>
<td colspan="4">
</td>
</tr>
</table>
<br>
<br>
<table border="0" cellpadding="2" cellspacing="0" width="640">
<tr>
<td>
Comments:
<hr size="1">
</td>
</tr>
<tr>
<td>
<div align="center">
<i>----- Posted by {reporter} at {createdtime} on {createddate} -----</i>
<br>
<br>
</div>
{description}
<br>
<br>
<br>
</td>
</tr>
<!-- BEGIN row -->
<tr>
<td>
<div align="center">
<i>----- Posted by {rreporter} at {rcreateddate} -----</i>
<br>
<br>
</div>
{rdescription}
<br>
<br>
<br>
</td>
</tr>
<!-- END row -->
</table>
<br>
<a href="{me}?op=show&bugid={bugid}">Back to bug #{bugid}</a>
<br>
<br>
Index: bugdisplay.html
===================================================================
RCS file: /cvsroot/phpbt/phpbt/templates/default/bugdisplay.html,v
retrieving revision 1.8
retrieving revision 1.9
diff -u -r1.8 -r1.9
--- bugdisplay.html 2001/10/17 12:59:56 1.8
+++ bugdisplay.html 2001/11/03 19:24:07 1.9
@@ -191,7 +191,10 @@
</tr>
</table>
</form>
-<a href="{me}?op=history&bugid={bugid}">View bug activity</a>
+
+<b><a href="{me}?op=history&bugid={bugid}">View bug activity</a></b> |
+<b><a href="{me}?op=print&&bugid={bugid}">Printable view</a></b>
+
<br>
<br>
<table border="0" cellpadding="2" cellspacing="0" width="640">
|
|
From: Benjamin C. <bc...@us...> - 2001-11-03 19:24:09
|
Update of /cvsroot/phpbt/phpbt
In directory usw-pr-cvs1:/tmp/cvs-serv25896
Modified Files:
CHANGELOG bug.php
Log Message:
Added a printable view for bugs
Index: CHANGELOG
===================================================================
RCS file: /cvsroot/phpbt/phpbt/CHANGELOG,v
retrieving revision 1.23
retrieving revision 1.24
diff -u -r1.23 -r1.24
--- CHANGELOG 2001/11/03 14:25:30 1.23
+++ CHANGELOG 2001/11/03 19:24:07 1.24
@@ -2,7 +2,8 @@
: Fixed a bug with the bug history update.
: Added web-based installation.
: Added on option for choosing whether bugs can be changed only by the bug
- reporter, bug owner, managers, or admins.
+ reporter, bug owner, managers, or admins.
+: Added a printable view for bugs
-- 0.4.0 -- 18 Oct 2001
: Improved the CSS file to make choosing different color schemes easier.
Index: bug.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/bug.php,v
retrieving revision 1.54
retrieving revision 1.55
diff -u -r1.54 -r1.55
--- bug.php 2001/11/03 14:58:04 1.54
+++ bug.php 2001/11/03 19:24:07 1.55
@@ -427,6 +427,74 @@
}
}
+function show_bug_printable($bugid) {
+ global $q, $t, $select;
+
+ if (!is_numeric($bugid) or
+ !$row = $q->grab('select b.*, reporter.login as reporter,
+ owner.login as owner, project_name, component_name, version_name,
+ severity_name, os_name, status_name, resolution_name
+ from '.TBL_BUG.' b
+ left join '.TBL_AUTH_USER.' owner on b.assigned_to = owner.user_id
+ left join '.TBL_AUTH_USER.' reporter on b.created_by = reporter.user_id
+ left join '.TBL_RESOLUTION.' r on b.resolution_id = r.resolution_id,'.
+ TBL_SEVERITY.' sv, '.TBL_STATUS.' st, '.TBL_OS.' os, '.
+ TBL_VERSION.' v, '.TBL_COMPONENT.' c, '.TBL_PROJECT." p
+ where bug_id = '$bugid' and b.severity_id = sv.severity_id
+ and b.os_id = os.os_id and b.version_id = v.version_id
+ and b.component_id = c.component_id and b.project_id = p.project_id
+ and b.status_id = st.status_id")) {
+ show_text($STRING['bugbadnum'],true);
+ exit;
+ }
+
+ $t->set_file('content', 'bugdisplay-printable.html');
+ $t->set_block('content','row','rows');
+ $t->set_var(array(
+ 'TITLE' => "{$TITLE['editbug']} #$bugid",
+ 'bugid' => $bugid,
+ 'title' => stripslashes($row['title']),
+ 'description' => nl2br(stripslashes($row['description'])),
+ 'url' => $row['url'] ? "<a href='{$row['url']}'>{$row['url']}</a>" : '',
+ 'severity' => $row['severity_name'],
+ 'priority' => $select['priority'][$row['priority']],
+ 'status' => $row['status_name'],
+ 'resolution' => $row['resolution_name'] ? $row['resolution_name'] : '',
+ 'owner' => maskemail($row['owner']),
+ 'reporter' => maskemail($row['reporter']),
+ 'createddate' => date(DATE_FORMAT,$row['created_date']),
+ 'createdtime' => date(TIME_FORMAT,$row['created_date']),
+ 'lastmodifieddate' => $row['last_modified_date'],
+ 'project' => $row['project_name'],
+ 'version' => $row['version_name'],
+ 'component' => $row['component_name'],
+ 'os' => $row['os_name'],
+ 'browserstring' => $row['browser_string'],
+ ));
+
+ // Show the comments
+ $q->query('select comment_text, c.created_date, login'
+ .' from '.TBL_COMMENT.' c, '.TBL_AUTH_USER
+ ." where bug_id = $bugid and c.created_by = user_id order by c.created_date");
+ if (!$q->num_rows()) {
+ $t->set_var('rows','');
+ } else {
+ while ($row = $q->grab()) {
+ $t->set_var(array(
+ 'bgcolor' => (++$i % 2 == 0) ? '#dddddd' : '#ffffff',
+ 'trclass' => $i % 2 ? '' : 'alt',
+ 'rdescription' => nl2br(format_comments(
+ htmlspecialchars($row['comment_text']))),
+ 'rreporter' => maskemail($row['login']),
+ 'rcreateddate' => date(TIME_FORMAT,$row['created_date']).' on '.
+ date(DATE_FORMAT,$row['created_date'])
+ ));
+ $t->parse('rows','row',true);
+ }
+ }
+}
+
+
function show_bug($bugid = 0, $error = '') {
global $q, $me, $t, $project, $STRING, $u, $perm;
@@ -610,6 +678,7 @@
case 'show' : show_bug($bugid); break;
case 'update' : update_bug($bugid); break;
case 'do' : do_form($bugid); break;
+ case 'print' : show_bug_printable($bugid); break;
}
} else header("Location: query.php");
|
|
From: Benjamin C. <bc...@us...> - 2001-11-03 17:17:43
|
Update of /cvsroot/phpbt/phpbt In directory usw-pr-cvs1:/tmp/cvs-serv24350 Modified Files: install.php Log Message: Add recognition to phpBB Index: install.php =================================================================== RCS file: /cvsroot/phpbt/phpbt/install.php,v retrieving revision 1.3 retrieving revision 1.4 diff -u -r1.3 -r1.4 --- install.php 2001/11/03 14:38:17 1.3 +++ install.php 2001/11/03 17:17:40 1.4 @@ -1,6 +1,7 @@ <?php // install.php -- Web-based installation script +// Thanks to the phpBB crew for an example on how this can be done. // ------------------------------------------------------------------------ // Copyright (c) 2001 The phpBugTracker Group // ------------------------------------------------------------------------ |
|
From: Benjamin C. <bc...@us...> - 2001-11-03 14:58:07
|
Update of /cvsroot/phpbt/phpbt
In directory usw-pr-cvs1:/tmp/cvs-serv29314
Modified Files:
bug.php
Log Message:
Rearrange the logic a bit
Index: bug.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/bug.php,v
retrieving revision 1.53
retrieving revision 1.54
diff -u -r1.53 -r1.54
--- bug.php 2001/11/03 14:25:30 1.53
+++ bug.php 2001/11/03 14:58:04 1.54
@@ -238,8 +238,8 @@
}
}
- if (!($u == $buginfo['assigned_to'] or $u == $buginfo['created_by'] or
- $perm->have_perm('Manager')) and STRICT_UPDATING) {
+ if (STRICT_UPDATING and !($u == $buginfo['assigned_to'] or
+ $u == $buginfo['created_by'] or $perm->have_perm('Manager'))) {
show_bug($bugid,array('status' => $STRING['bugbadperm']));
return;
}
|
|
From: Benjamin C. <bc...@us...> - 2001-11-03 14:57:09
|
Update of /cvsroot/phpbt/phpbt/docs/sgml In directory usw-pr-cvs1:/tmp/cvs-serv29171 Modified Files: configuration.sgml Log Message: New config variables Index: configuration.sgml =================================================================== RCS file: /cvsroot/phpbt/phpbt/docs/sgml/configuration.sgml,v retrieving revision 1.3 retrieving revision 1.4 diff -u -r1.3 -r1.4 --- configuration.sgml 2001/10/15 13:43:01 1.3 +++ configuration.sgml 2001/11/03 14:57:06 1.4 @@ -128,6 +128,18 @@ <para>The format for displaying the date, according to PHP's <ulink url="http://www.php.net/manual/function.date.php"><function>date()</function></ulink> function.</para> </listitem> </varlistentry> +<varlistentry> +<term>LANGUAGE</term> +<listitem> +<para>The language file (found in the <filename class="directory">languages</filename> sub-directory to use for error and warning messages.</para> +</listitem> +</varlistentry> +<varlistentry> +<term>STRICT_UPDATING</term> +<listitem> +<para>If set to true, the only people who can make changes to a bug are the reporter, the owner, and those with manager or admin permissions.</para> +</listitem> +</varlistentry> </variablelist> </sect1> |
|
From: Benjamin C. <bc...@us...> - 2001-11-03 14:38:20
|
Update of /cvsroot/phpbt/phpbt In directory usw-pr-cvs1:/tmp/cvs-serv26110 Modified Files: install.php Log Message: Make sure the admin login is a valid email address since we default to email and login being the same Index: install.php =================================================================== RCS file: /cvsroot/phpbt/phpbt/install.php,v retrieving revision 1.2 retrieving revision 1.3 diff -u -r1.2 -r1.3 --- install.php 2001/10/30 04:08:35 1.2 +++ install.php 2001/11/03 14:38:17 1.3 @@ -78,6 +78,13 @@ return $text; } +/// +/// Check the validity of an email address +/// (From zend.com user russIndr) +function valid_email($email) { + return eregi('^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,3})$', $email); +} + function grab_config_file() { global $t, $_pv; @@ -123,6 +130,8 @@ $error = 'Please enter the phpBT email address'; } elseif (!$_pv['admin_login'] = trim($_pv['admin_login'])) { $error = 'Please enter the admin login'; + } elseif (!valid_email($_pv['admin_login'])) { + $error = 'Please use a valid email address for the admin login'; } elseif (!$_pv['admin_pass'] = trim($_pv['admin_pass'])) { $error = 'Please enter the admin password'; } elseif (!$_pv['admin_pass2'] = trim($_pv['admin_pass2'])) { |
|
From: Benjamin C. <bc...@us...> - 2001-11-03 14:25:34
|
Update of /cvsroot/phpbt/phpbt
In directory usw-pr-cvs1:/tmp/cvs-serv23830
Modified Files:
CHANGELOG bug.php dbchanges.sql
Log Message:
Added on option for choosing whether bugs can be changed only by the bug reporter, bug owner, managers, or admins.
Index: CHANGELOG
===================================================================
RCS file: /cvsroot/phpbt/phpbt/CHANGELOG,v
retrieving revision 1.22
retrieving revision 1.23
diff -u -r1.22 -r1.23
--- CHANGELOG 2001/10/30 04:04:46 1.22
+++ CHANGELOG 2001/11/03 14:25:30 1.23
@@ -1,6 +1,8 @@
-- 0.5.0 --
: Fixed a bug with the bug history update.
: Added web-based installation.
+: Added on option for choosing whether bugs can be changed only by the bug
+ reporter, bug owner, managers, or admins.
-- 0.4.0 -- 18 Oct 2001
: Improved the CSS file to make choosing different color schemes easier.
Index: bug.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/bug.php,v
retrieving revision 1.52
retrieving revision 1.53
diff -u -r1.52 -r1.53
--- bug.php 2001/10/30 14:23:12 1.52
+++ bug.php 2001/11/03 14:25:30 1.53
@@ -239,7 +239,7 @@
}
if (!($u == $buginfo['assigned_to'] or $u == $buginfo['created_by'] or
- $perm->have_perm('Manager'))) {
+ $perm->have_perm('Manager')) and STRICT_UPDATING) {
show_bug($bugid,array('status' => $STRING['bugbadperm']));
return;
}
Index: dbchanges.sql
===================================================================
RCS file: /cvsroot/phpbt/phpbt/dbchanges.sql,v
retrieving revision 1.12
retrieving revision 1.13
diff -u -r1.12 -r1.13
--- dbchanges.sql 2001/09/04 03:46:14 1.12
+++ dbchanges.sql 2001/11/03 14:25:31 1.13
@@ -1,181 +1 @@
-drop table if exists attachment;
-CREATE TABLE attachment (
- attachment_id int(10) unsigned NOT NULL default '0',
- bug_id int(10) unsigned NOT NULL default '0',
- file_name char(255) NOT NULL default '',
- description char(255) NOT NULL default '',
- file_size bigint(20) unsigned NOT NULL default '0',
- mime_type char(30) NOT NULL default '',
- created_by int(10) unsigned NOT NULL default '0',
- created_date bigint(20) unsigned NOT NULL default '0',
- PRIMARY KEY (attachment_id)
-);
-insert into attachment select * from Attachment;
-
-drop table if exists bug;
-CREATE TABLE bug (
- bug_id int(10) unsigned NOT NULL default '0',
- title varchar(100) NOT NULL default '',
- description text NOT NULL,
- url varchar(255) NOT NULL default '',
- severity_id tinyint(3) unsigned NOT NULL default '0',
- priority tinyint(3) unsigned NOT NULL default '0',
- status_id tinyint(3) unsigned NOT NULL default '0',
- resolution_id tinyint(3) unsigned NOT NULL default '0',
- assigned_to int(10) 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',
- last_modified_date bigint(20) unsigned NOT NULL default '0',
- project_id int(10) unsigned NOT NULL default '0',
- version_id int(10) unsigned NOT NULL default '0',
- component_id int(10) unsigned NOT NULL default '0',
- os_id tinyint(3) unsigned NOT NULL default '0',
- browser_string varchar(255) NOT NULL default '',
- close_date bigint(20) unsigned NOT NULL default '0',
- PRIMARY KEY (bug_id)
-);
-insert into bug select *, 0 from Bug;
-
-drop table if exists bug_history;
-CREATE TABLE bug_history (
- bug_id int(10) unsigned NOT NULL default '0',
- changed_field char(20) NOT NULL default '',
- old_value char(255) NOT NULL default '',
- new_value char(255) NOT NULL default '',
- created_by int(10) unsigned NOT NULL default '0',
- created_date bigint(20) unsigned NOT NULL default '0'
-);
-insert into bug_history select * from BugHistory;
-
-drop table if exists comment;
-CREATE TABLE comment (
- comment_id int(10) unsigned NOT NULL default '0',
- bug_id int(10) unsigned NOT NULL default '0',
- comment_text text NOT NULL,
- created_by int(10) unsigned NOT NULL default '0',
- created_date bigint(20) unsigned NOT NULL default '0',
- PRIMARY KEY (comment_id)
-);
-insert into comment select * from Comment;
-
-drop table if exists component;
-CREATE TABLE component (
- component_id int(10) unsigned NOT NULL default '0',
- project_id int(10) unsigned NOT NULL default '0',
- component_name varchar(30) NOT NULL default '',
- component_desc text NOT NULL,
- owner int(10) unsigned NOT NULL default '0',
- active tinyint(1) NOT NULL default '1',
- 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',
- last_modified_date bigint(20) unsigned NOT NULL default '0',
- PRIMARY KEY (component_id)
-);
-insert into component select * from Component;
-
-drop table if exists os;
-CREATE TABLE os (
- os_id int(10) unsigned NOT NULL default '0',
- os_name char(30) NOT NULL default '',
- sort_order tinyint(3) unsigned NOT NULL default '0',
- regex char(40) NOT NULL default '',
- PRIMARY KEY (os_id)
-);
-insert into os select * from OS;
-
-drop table if exists project;
-CREATE TABLE project (
- project_id int(10) unsigned NOT NULL default '0',
- project_name varchar(30) NOT NULL default '',
- project_desc text NOT NULL,
- active tinyint(1) NOT NULL default '1',
- 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',
- last_modified_date bigint(20) unsigned NOT NULL default '0',
- PRIMARY KEY (project_id)
-);
-insert into project select *, CreatedBy, CreatedDate from Project;
-
-drop table if exists resolution;
-CREATE TABLE resolution (
- resolution_id int(10) unsigned NOT NULL default '0',
- resolution_name varchar(30) NOT NULL default '',
- resolution_desc text NOT NULL,
- sort_order tinyint(3) unsigned NOT NULL default '0',
- PRIMARY KEY (resolution_id)
-);
-insert into resolution select * from Resolution;
-
-drop table if exists saved_query;
-CREATE TABLE saved_query (
- saved_query_id int(10) unsigned NOT NULL auto_increment,
- user_id int(10) unsigned NOT NULL default '0',
- saved_query_name varchar(40) NOT NULL default '',
- saved_query_string text NOT NULL,
- PRIMARY KEY (saved_query_id,user_id)
-);
-insert into saved_query select * from SavedQuery;
-
-drop table if exists severity;
-CREATE TABLE severity (
- severity_id int(10) unsigned NOT NULL default '0',
- severity_name varchar(30) NOT NULL default '',
- severity_desc text NOT NULL,
- sort_order tinyint(3) unsigned NOT NULL default '0',
- severity_color varchar(10) NOT NULL default '#FFFFFF',
- PRIMARY KEY (severity_id)
-);
-insert into severity select *, null from Severity;
-update severity set severity_color = '#dadada' where severity_id = '1';
-update severity set severity_color = '#dad0d0' where severity_id = '2';
-update severity set severity_color = '#dacaca' where severity_id = '3';
-update severity set severity_color = '#dac0c0' where severity_id = '4';
-update severity set severity_color = '#dababa' where severity_id = '5';
-update severity set severity_color = '#dab0b0' where severity_id = '6';
-update severity set severity_color = '#daaaaa' where severity_id = '7';
-
-drop table if exists status;
-CREATE TABLE status (
- status_id int(10) unsigned NOT NULL default '0',
- status_name varchar(30) NOT NULL default '',
- status_desc text NOT NULL,
- sort_order tinyint(3) unsigned NOT NULL default '0',
- PRIMARY KEY (status_id)
-);
-insert into status select * from Status;
-
-drop table if exists auth_user;
-CREATE TABLE auth_user (
- user_id int(10) unsigned NOT NULL default '0',
- login char(40) NOT NULL default '',
- first_name char(40) NOT NULL default '',
- last_name char(40) NOT NULL default '',
- email char(60) NOT NULL default '',
- password char(40) NOT NULL default '',
- active tinyint(3) unsigned NOT NULL default '1',
- bug_list_fields char(255) NOT NULL default '',
- 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',
- last_modified_date bigint(20) unsigned NOT NULL default '0',
- PRIMARY KEY (user_id),
- UNIQUE login (login)
-);
-insert into auth_user select UserID, Email, FirstName, LastName, Email, Password, if (UserLevel > 0, 1, 0), '', 0, CreatedDate, 0, CreatedDate from User;
-
-drop table if exists version;
-CREATE TABLE version (
- version_id int(10) unsigned NOT NULL default '0',
- project_id int(10) unsigned NOT NULL default '0',
- version_name char(10) NOT NULL default '',
- active tinyint(1) NOT NULL default '1',
- 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',
- last_modified_date bigint(20) unsigned NOT NULL default '0',
- PRIMARY KEY (version_id)
-);
-insert into version select *, CreatedBy, CreatedDate from Version;
+insert into TBL_CONFIGURATION (varname, varvalue, description, vartype) values ('STRICT_UPDATING', '0', 'Only the bug reporter, bug owner, managers, and admins can change a bug', 'bool');
|
|
From: Benjamin C. <bc...@us...> - 2001-11-02 13:38:19
|
Update of /cvsroot/phpbt/phpbt
In directory usw-pr-cvs1:/tmp/cvs-serv10989
Modified Files:
include.php
Log Message:
Fixed problems with saving queries
Index: include.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/include.php,v
retrieving revision 1.71
retrieving revision 1.72
diff -u -r1.71 -r1.72
--- include.php 2001/11/02 04:21:41 1.71
+++ include.php 2001/11/02 13:38:16 1.72
@@ -74,7 +74,11 @@
global $auth;
if ($seq_name == TBL_SAVED_QUERY) {
- return $q->grab_field("select max(saved_query_id)+1 where user_id = ".$auth->auth['uid']);
+ if ($id = $this->grab_field("select max(saved_query_id)+1 from ".TBL_SAVED_QUERY." where user_id = ".$auth->auth['uid'])) {
+ return $id;
+ } else {
+ return 1;
+ }
} else {
return DB_Sql::nextid($seq_name);
}
|
|
From: Benjamin C. <bc...@us...> - 2001-11-02 04:22:15
|
Update of /cvsroot/phpbt/phpbt
In directory usw-pr-cvs1:/tmp/cvs-serv6560
Modified Files:
report.php
Log Message:
Make the queries more pg friendly
Index: report.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/report.php,v
retrieving revision 1.15
retrieving revision 1.16
diff -u -r1.15 -r1.16
--- report.php 2001/09/01 15:44:20 1.15
+++ report.php 2001/11/02 04:22:12 1.16
@@ -31,10 +31,11 @@
$t->set_var('reporttitle', 'Bug resolutions');
// Start off our query
- $querystring = 'select email as "Assigned To", sum(if(resolution_id = "0",1,0)) as "Open"';
+ $querystring = 'select email as "Assigned To", sum(case when resolution_id = 0 then 1 else 0 end) as "Open"';
$resfields = array('Assigned To','Open');
+
// Grab the resolutions from the database
- $q->query("select resolution_name, concat(', sum(if(resolution_id = \"',resolution_id,'\",1,0)) as \"',resolution_name,'\"') from ".TBL_RESOLUTION);
+ $q->query("select resolution_name, ".$q->concat("', sum(case when resolution_id = '", 'resolution_id', "' then 1 else 0 end) as \"'", 'resolution_name' ,"'\"'")." from ".TBL_RESOLUTION);
while (list($fieldname, $countquery) = $q->grab()) {
$resfields[] = $fieldname;
$querystring .= $countquery;
@@ -47,7 +48,7 @@
$projectquery = '';
}
- $q->query("$querystring, count(bug_id) as 'Total' from ".TBL_BUG." b left join ".TBL_AUTH_USER." u on assigned_to = user_id $projectquery group by assigned_to");
+ $q->query("$querystring, count(bug_id) as \"Total\" from ".TBL_BUG." b left join ".TBL_AUTH_USER." u on assigned_to = user_id $projectquery group by assigned_to, u.email");
if (!$q->num_rows()) {
$t->set_var('rows', 'No data to display');
} else {
|
2 messages has been excluded from this view by a project administrator.
