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...> - 2002-03-26 18:44:36
|
Update of /cvsroot/phpbt/phpbt
In directory usw-pr-cvs1:/tmp/cvs-serv12851
Modified Files:
index.php
Log Message:
Added detailed project stats. Note that these stats can get very long, thus the configuration option to turn them off. Not tested yet on postgres
Index: index.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/index.php,v
retrieving revision 1.22
retrieving revision 1.23
diff -u -r1.22 -r1.23
--- index.php 26 Mar 2002 17:41:53 -0000 1.22
+++ index.php 26 Mar 2002 18:44:32 -0000 1.23
@@ -120,6 +120,63 @@
$t->parse('sblock', 'statsblock', true);
}
+// Project summaries
+$t->set_block('content', 'projectsummaryblock', 'projblock');
+$t->set_block('projectsummaryblock', 'projectrow', 'prows');
+$t->set_block('projectrow', 'col', 'cols');
+if (SHOW_PROJECT_SUMMARIES) {
+ $querystring = 'select project_name as "Project", sum(case when resolution_id = 0 then 1 else 0 end) as "Open"';
+ $resfields = array('Project','Open');
+
+ // Grab the resolutions from the database
+ $rs = $db->query("select resolution_name, ".
+ db_concat("', sum(case when resolution_id = '", 'resolution_id',
+ "' then 1 else 0 end) as \"'", 'resolution_name' ,"'\"'").
+ " from ".TBL_RESOLUTION);
+ while (list($fieldname, $countquery) = $rs->fetchRow(DB_FETCHMODE_ORDERED)) {
+ $resfields[] = $fieldname;
+ $querystring .= $countquery;
+ }
+ $resfields[] = 'Total';
+
+ $rs = $db->query("$querystring, count(bug_id) as \"Total\" from ".TBL_BUG.
+ " b left join ".TBL_PROJECT." p using (project_id)".
+ " where b.project_id not in ($restricted_projects) group by b.project_id".
+ " order by project_name");
+ if (!$rs->numRows()) {
+ $t->set_var('projblock', '');
+ } else {
+ foreach ($resfields as $col) {
+ $t->set_var('coldata', stripslashes($col));
+ $t->set_var('colclass', 'header-col');
+ $t->parse('cols', 'col', true);
+ }
+ $t->set_var('bgcolor', '#eeeeee');
+ $t->parse('prows', 'projectrow', true);
+ $t->set_var('cols', '');
+ $i = 0;
+ while ($rs->fetchInto($row)) {
+ foreach ($resfields as $col) {
+ $t->set_var(array(
+ 'coldata' => stripslashes($row[$col]),
+ 'colclass' => $col == 'Project' ? '' : 'center-col'
+ ));
+ $t->parse('cols', 'col', true);
+ }
+ $t->set_var('trclass', $i % 2 ? 'alt' : '');
+ $i++;
+ $t->parse('prows', 'projectrow', true);
+ $t->set_var('cols', '');
+ //for header default
+ $t->set_var('trclass','alt');
+ }
+ $t->parse('projblock', 'projectsummaryblock', true);
+ $rs->free();
+ }
+} else {
+ $t->set_var('projblock', '');
+}
+
// Show the recently added and closed bugs
$rs = $db->limitQuery("select bug_id, title, project_name from ".TBL_BUG.
' b, '.TBL_PROJECT." p where b.project_id not in ($restricted_projects)".
@@ -136,6 +193,7 @@
$t->parse('recentrows', 'recentrow', true);
}
}
+$rs->free();
$rs = $db->limitQuery('select b.bug_id, title, project_name from '.TBL_BUG.' b, '.
TBL_BUG_HISTORY.' h, '.TBL_PROJECT.' p'.
" where b.project_id not in ($restricted_projects) and b.bug_id = h.bug_id".
@@ -153,6 +211,7 @@
$t->parse('closerows', 'closerow', true);
}
}
+$rs->free();
$t->pparse('main',array('content','wrap','main'));
|
|
From: Benjamin C. <bc...@us...> - 2002-03-26 18:43:31
|
Update of /cvsroot/phpbt/phpbt/schemas
In directory usw-pr-cvs1:/tmp/cvs-serv12588/schemas
Modified Files:
mysql.in oci8.in pgsql.in
Log Message:
Added configuration option for whether to show detailed project stats on the home page
Index: mysql.in
===================================================================
RCS file: /cvsroot/phpbt/phpbt/schemas/mysql.in,v
retrieving revision 1.19
retrieving revision 1.20
diff -u -r1.19 -r1.20
--- mysql.in 21 Mar 2002 13:44:54 -0000 1.19
+++ mysql.in 26 Mar 2002 18:43:25 -0000 1.20
@@ -293,6 +293,7 @@
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 ('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 ('PROMOTE_VOTES', 5, 'The number of votes required to promote a bug from Unconfirmed to New (Set to 0 to disable promotions by voting)', 'string');
INSERT INTO TBL_CONFIGURATION VALUES ('MAX_USER_VOTES', 5, 'The maximum number of votes a user can cast across all bugs (Set to 0 to have no limit)', 'string');
INSERT INTO TBL_CONFIGURATION VALUES ('ATTACHMENT_PATH','attachments','Sub-dir of the INSTALLPATH - Needs to be writeable by the web process','string');
Index: oci8.in
===================================================================
RCS file: /cvsroot/phpbt/phpbt/schemas/oci8.in,v
retrieving revision 1.5
retrieving revision 1.6
diff -u -r1.5 -r1.6
--- oci8.in 21 Mar 2002 13:44:54 -0000 1.5
+++ oci8.in 26 Mar 2002 18:43:25 -0000 1.6
@@ -292,6 +292,7 @@
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 ('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 ('PROMOTE_VOTES', 5, 'The number of votes required to promote a bug from Unconfirmed to New (Set to 0 to disable promotions by voting)', 'string');
INSERT INTO TBL_CONFIGURATION VALUES ('MAX_USER_VOTES', 5, 'The maximum number of votes a user can cast across all bugs (Set to 0 to have no limit)', 'string');
INSERT INTO TBL_CONFIGURATION VALUES ('ATTACHMENT_PATH','attachments','Sub-dir of the INSTALLPATH - Needs to be writeable by the web process','string');
Index: pgsql.in
===================================================================
RCS file: /cvsroot/phpbt/phpbt/schemas/pgsql.in,v
retrieving revision 1.21
retrieving revision 1.22
diff -u -r1.21 -r1.22
--- pgsql.in 21 Mar 2002 13:44:54 -0000 1.21
+++ pgsql.in 26 Mar 2002 18:43:25 -0000 1.22
@@ -289,6 +289,7 @@
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 ('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 ('PROMOTE_VOTES', 5, 'The number of votes required to promote a bug from Unconfirmed to New (Set to 0 to disable promotions by voting)', 'string');
INSERT INTO TBL_CONFIGURATION VALUES ('MAX_USER_VOTES', 5, 'The maximum number of votes a user can cast across all bugs (Set to 0 to have no limit)', 'string');
INSERT INTO TBL_CONFIGURATION VALUES ('ATTACHMENT_PATH','attachments','Sub-dir of the INSTALLPATH - Needs to be writeable by the web process','string');
|
|
From: Benjamin C. <bc...@us...> - 2002-03-26 18:43:29
|
Update of /cvsroot/phpbt/phpbt
In directory usw-pr-cvs1:/tmp/cvs-serv12588
Modified Files:
upgrade.php
Log Message:
Added configuration option for whether to show detailed project stats on the home page
Index: upgrade.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/upgrade.php,v
retrieving revision 1.15
retrieving revision 1.16
diff -u -r1.15 -r1.16
--- upgrade.php 21 Mar 2002 13:44:54 -0000 1.15
+++ upgrade.php 26 Mar 2002 18:43:25 -0000 1.16
@@ -56,6 +56,7 @@
}
}
$db->query("INSERT INTO ".TBL_CONFIGURATION." VALUES ('RECALL_LOGIN','0','Enable use of cookies to store username between logins','bool')");
+ $db->query("INSERT INTO ".TBL_CONFIGURATION." VALUES ('SHOW_PROJECT_SUMMARIES', '1', 'Itemize bug stats by project on the home page', 'bool')");
}
include 'templates/default/upgrade-finished.html';
}
|
|
From: Benjamin C. <bc...@us...> - 2002-03-26 18:41:30
|
Update of /cvsroot/phpbt/phpbt
In directory usw-pr-cvs1:/tmp/cvs-serv12117
Modified Files:
css.php
Log Message:
Moved style stuff from report.html to css.php
Index: css.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/css.php,v
retrieving revision 1.6
retrieving revision 1.7
diff -u -r1.6 -r1.7
--- css.php 6 Mar 2002 00:04:09 -0000 1.6
+++ css.php 26 Mar 2002 18:41:20 -0000 1.7
@@ -272,3 +272,6 @@
padding: 5px;
text-align: center;
}
+
+.header-col { font-weight: bold; }
+.center-col { text-align: center; }
|
|
From: Benjamin C. <bc...@us...> - 2002-03-26 18:41:29
|
Update of /cvsroot/phpbt/phpbt/templates/default
In directory usw-pr-cvs1:/tmp/cvs-serv12117/templates/default
Modified Files:
report.html
Log Message:
Moved style stuff from report.html to css.php
Index: report.html
===================================================================
RCS file: /cvsroot/phpbt/phpbt/templates/default/report.html,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -r1.4 -r1.5
--- report.html 16 Jan 2002 11:12:16 -0000 1.4
+++ report.html 26 Mar 2002 18:41:20 -0000 1.5
@@ -1,8 +1,3 @@
-<style>
-.header-col { font-weight: bold; }
-.center-col { text-align: center; }
-</style>
-
<form action="{me}">
Bug statistics for
<select name="projectid" onChange="document.location.href='{me}?projectid='+this.options[this.selectedIndex].value">
|
|
From: Benjamin C. <bc...@us...> - 2002-03-26 18:40:31
|
Update of /cvsroot/phpbt/phpbt/inc
In directory usw-pr-cvs1:/tmp/cvs-serv11830/inc
Modified Files:
functions.php
Log Message:
Add a default error handler for the database object
Index: functions.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/inc/functions.php,v
retrieving revision 1.11
retrieving revision 1.12
diff -u -r1.11 -r1.12
--- functions.php 20 Mar 2002 23:56:22 -0000 1.11
+++ functions.php 26 Mar 2002 18:40:27 -0000 1.12
@@ -383,4 +383,9 @@
echo '</pre>';
}
+// Handle a database error
+function handle_db_error(&$obj) {
+ die($obj->message.'<br>'.$obj->userinfo);
+}
+
?>
|
|
From: Benjamin C. <bc...@us...> - 2002-03-26 18:40:30
|
Update of /cvsroot/phpbt/phpbt
In directory usw-pr-cvs1:/tmp/cvs-serv11830
Modified Files:
include.php
Log Message:
Add a default error handler for the database object
Index: include.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/include.php,v
retrieving revision 1.101
retrieving revision 1.102
diff -u -r1.101 -r1.102
--- include.php 20 Mar 2002 20:03:17 -0000 1.101
+++ include.php 26 Mar 2002 18:40:27 -0000 1.102
@@ -51,7 +51,7 @@
$db = DB::Connect($dsn);
$db->setOption('optimize', 'portability');
$db->setFetchMode(DB_FETCHMODE_ASSOC);
-
+$db->setErrorHandling(PEAR_ERROR_CALLBACK, "handle_db_error");
// Set up the configuration variables
$rs = $db->query('select varname, varvalue from '.TBL_CONFIGURATION);
|
|
From: Benjamin C. <bc...@us...> - 2002-03-26 17:57:30
|
Update of /cvsroot/phpbt/phpbt
In directory usw-pr-cvs1:/tmp/cvs-serv29011
Modified Files:
index.php
Log Message:
Added project info to recent bug lists
Index: index.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/index.php,v
retrieving revision 1.21
retrieving revision 1.22
diff -u -r1.21 -r1.22
--- index.php 26 Mar 2002 17:12:29 -0000 1.21
+++ index.php 26 Mar 2002 17:41:53 -0000 1.22
@@ -121,31 +121,34 @@
}
// Show the recently added and closed bugs
-$rs = $db->limitQuery("select bug_id, title from ".TBL_BUG.
- " where project_id not in ($restricted_projects)".
- ' order by created_date desc', 0, 5);
+$rs = $db->limitQuery("select bug_id, title, project_name from ".TBL_BUG.
+ ' b, '.TBL_PROJECT." p where b.project_id not in ($restricted_projects)".
+ ' and b.project_id = p.project_id order by b.created_date desc', 0, 5);
if (DB::isError($rs) or !$rs->numRows()) {
$t->set_var('recentrows', $STRING['nobugs']);
} else {
- while (list($bugid, $title) = $rs->fetchRow(DB_FETCHMODE_ORDERED)) {
+ while (extract($rs->fetchRow())) {
$t->set_var(array(
'title' => stripslashes($title),
- 'bugid' => $bugid
+ 'bugid' => $bugid,
+ 'project' => stripslashes($project_name)
));
$t->parse('recentrows', 'recentrow', true);
}
}
-$rs = $db->limitQuery('select b.bug_id, title from '.TBL_BUG.' b, '.TBL_BUG_HISTORY.
- " h where project_id not in ($restricted_projects) and b.bug_id = h.bug_id".
+$rs = $db->limitQuery('select b.bug_id, title, project_name from '.TBL_BUG.' b, '.
+ TBL_BUG_HISTORY.' h, '.TBL_PROJECT.' p'.
+ " where b.project_id not in ($restricted_projects) and b.bug_id = h.bug_id".
" and changed_field = 'status' and new_value = 'Closed'".
- ' order by h.created_date desc', 0, 5);
+ ' and b.project_id = p.project_id order by h.created_date desc', 0, 5);
if (DB::isError($rs) or !$rs->numRows()) {
$t->set_var('closerows', $STRING['nobugs']);
} else {
- while (list($bugid, $title) = $rs->fetchRow(DB_FETCHMODE_ORDERED)) {
+ while (extract($rs->fetchRow())) {
$t->set_var(array(
'title' => stripslashes($title),
- 'bugid' => $bugid
+ 'bugid' => $bugid,
+ 'project' => stripslashes($project_name)
));
$t->parse('closerows', 'closerow', true);
}
|
|
From: Benjamin C. <bc...@us...> - 2002-03-26 17:57:30
|
Update of /cvsroot/phpbt/phpbt/templates/default
In directory usw-pr-cvs1:/tmp/cvs-serv29011/templates/default
Modified Files:
index.html
Log Message:
Added project info to recent bug lists
Index: index.html
===================================================================
RCS file: /cvsroot/phpbt/phpbt/templates/default/index.html,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -r1.4 -r1.5
--- index.html 2 Mar 2002 18:48:30 -0000 1.4
+++ index.html 26 Mar 2002 17:41:53 -0000 1.5
@@ -4,14 +4,14 @@
<b>Five most recently submitted bugs:</b>
<br>
<!-- BEGIN recentrow -->
- <a href="bug.php?op=show&bugid={bugid}">{title}</a><br>
+ <a href="bug.php?op=show&bugid={bugid}">{title}</a> (<i>{project}</i>)<br>
<!-- END recentrow -->
<br>
<br>
<b>Five most recently closed bugs:</b>
<br>
<!-- BEGIN closerow -->
- <a href="bug.php?op=show&bugid={bugid}">{title}</a><br>
+ <a href="bug.php?op=show&bugid={bugid}">{title}</a> (<i>{project}</i>)<br>
<!-- END closerow -->
</td>
<td valign="top">
|
|
From: Benjamin C. <bc...@us...> - 2002-03-26 17:30:24
|
Update of /cvsroot/phpbt/phpbt In directory usw-pr-cvs1:/tmp/cvs-serv25663 Modified Files: install.php Log Message: Forgotten tables Index: install.php =================================================================== RCS file: /cvsroot/phpbt/phpbt/install.php,v retrieving revision 1.16 retrieving revision 1.17 diff -u -r1.16 -r1.17 --- install.php 20 Mar 2002 15:09:18 -0000 1.16 +++ install.php 26 Mar 2002 17:30:20 -0000 1.17 @@ -44,6 +44,7 @@ '/TBL_AUTH_PERM/' => $_pv['tbl_prefix'].'auth_perm', '/TBL_AUTH_USER/' => $_pv['tbl_prefix'].'auth_user', '/TBL_BUG_CC/' => $_pv['tbl_prefix'].'bug_cc', + '/TBL_BUG_DEPENDENCY/' => $_pv['tbl_prefix'].'bug_dependency', '/TBL_BUG_GROUP/' => $_pv['tbl_prefix'].'bug_group', '/TBL_BUG_HISTORY/' => $_pv['tbl_prefix'].'bug_history', '/TBL_BUG_VOTE/' => $_pv['tbl_prefix'].'bug_vote', @@ -61,6 +62,7 @@ '/TBL_STATUS/' => $_pv['tbl_prefix'].'status', '/TBL_USER_GROUP/' => $_pv['tbl_prefix'].'user_group', '/TBL_USER_PERM/' => $_pv['tbl_prefix'].'user_perm', + '/TBL_USER_PREF/' => $_pv['tbl_prefix'].'user_pref', '/TBL_VERSION/' => $_pv['tbl_prefix'].'version', '/TBL_PROJECT_GROUP/' => $_pv['tbl_prefix'].'project_group', '/OPTION_ADMIN_EMAIL/' => $_pv['admin_login'], |
|
From: Benjamin C. <bc...@us...> - 2002-03-26 17:28:02
|
Update of /cvsroot/phpbt/phpbt/docs/sgml In directory usw-pr-cvs1:/tmp/cvs-serv25025/docs/sgml Modified Files: bugsearch.sgml Log Message: Typo Index: bugsearch.sgml =================================================================== RCS file: /cvsroot/phpbt/phpbt/docs/sgml/bugsearch.sgml,v retrieving revision 1.1 retrieving revision 1.2 diff -u -r1.1 -r1.2 --- bugsearch.sgml 17 Oct 2001 04:02:28 -0000 1.1 +++ bugsearch.sgml 26 Mar 2002 17:27:59 -0000 1.2 @@ -25,7 +25,7 @@ </mediaobject> </screenshot> -<para>The five select boxes at the top allow you to choose bugs with specific characteristics, such as the priority, or those that have reached certain stages in the testing process, such as those that have been fixed. Multiple items can be chosen from each select box, and all options are combined for the filter. For example, if you selected <guilabel>New</guilabel> and <guilabel>Unconfirmed</guilabel>from the <guilabel>Status</guilabel> box and <guilabel>Feature Request</guilabel> from the <guilabel>Severity box</guilabel>, submitting the form would return a list of all the bugs that were designated feature requests and that haven't been handled yet. </para> +<para>The five select boxes at the top allow you to choose bugs with specific characteristics, such as the priority, or those that have reached certain stages in the testing process, such as those that have been fixed. Multiple items can be chosen from each select box, and all options are combined for the filter. For example, if you selected <guilabel>New</guilabel> and <guilabel>Unconfirmed</guilabel> from the <guilabel>Status</guilabel> box and <guilabel>Feature Request</guilabel> from the <guilabel>Severity box</guilabel>, submitting the form would return a list of all the bugs that were designated feature requests and that haven't been handled yet. </para> <para>The middle set of boxes allow you to get more detailed in your search, whether you want to search for bugs assigned to an individual or search for a certain snippet of text in a bug description. The three select boxes immediately following allow you to restrict your search to bugs filed against a certain project, or even against a specific version or component of a project. The last two select boxes determine how the bug list will be sorted.</para> <para>A set of search parameters can be saved and given a name to make it easier to repeat a query in the future. Clicking on a named saved query will take you to the list of bugs that meet the search criteria, and deleting one will remove the link from the list.</para> <para>Finally, at the bottom of every page you will notice four numbers that are linked. These will run a query of open and closed bugs assigned to you, and open and closed bugs reported by you respectively. These links allow you to quickly list which bugs are on your hit list, for example, and to see at a glance the status of bugs assigned to or reported by you.</para> |
|
From: Benjamin C. <bc...@us...> - 2002-03-26 17:27:51
|
Update of /cvsroot/phpbt/phpbt
In directory usw-pr-cvs1:/tmp/cvs-serv24995
Modified Files:
bug.php
Log Message:
Cleanup in bug mails sent
Index: bug.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/bug.php,v
retrieving revision 1.88
retrieving revision 1.89
diff -u -r1.88 -r1.89
--- bug.php 26 Mar 2002 17:21:19 -0000 1.88
+++ bug.php 26 Mar 2002 17:27:48 -0000 1.89
@@ -170,12 +170,12 @@
.addslashes($buginfo[$field])."', '".addslashes($cf[$field])
."', $u, $now)");
$t->set_var(array(
- $field => $cf[$field],
+ $field => stripslashes($cf[$field]),
$field.'_stat' => '!'
));
} else {
$t->set_var(array(
- $field => $buginfo[$field],
+ $field => stripslashes($buginfo[$field]),
$field.'_stat' => ' '
));
}
|
|
From: Benjamin C. <bc...@us...> - 2002-03-26 17:21:22
|
Update of /cvsroot/phpbt/phpbt
In directory usw-pr-cvs1:/tmp/cvs-serv23124
Modified Files:
bug.php
Log Message:
Handle html chars
Index: bug.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/bug.php,v
retrieving revision 1.87
retrieving revision 1.88
diff -u -r1.87 -r1.88
--- bug.php 21 Mar 2002 13:44:54 -0000 1.87
+++ bug.php 26 Mar 2002 17:21:19 -0000 1.88
@@ -554,8 +554,8 @@
$t->set_var(array(
'bugid' => $bugid,
'TITLE' => $TITLE['editbug'],
- 'title' => stripslashes($row['title']),
- 'description' => stripslashes($row['description']),
+ 'title' => htmlentities(stripslashes($row['title'])),
+ 'description' => htmlentities(stripslashes($row['description'])),
'url' => $row['url'],
'urllabel' => $row['url'] ? "<a href='{$row['url']}'>URL</a>" : 'URL',
'severity' => build_select('severity',$row['severity_id']),
@@ -577,8 +577,9 @@
'TITLE' => $TITLE['enterbug'],
'error' => $error,
'bugid' => $bugid,
- 'title' => isset($title) ? stripslashes($title) : '',
- 'description' => isset($description) ? stripslashes($description) : '',
+ 'title' => isset($title) ? htmlentities(stripslashes($title)) : '',
+ 'description' => isset($description) ?
+ htmlentities(stripslashes($description)) : '',
'url' => isset($url) ? $url : 'http://',
'urllabel' => isset($url) ? "<a href='$url'>URL</a>" : 'URL',
'severity' => build_select('severity',(isset($severity) ? $severity : 0)),
@@ -754,8 +755,8 @@
'vote_error' => isset($error['vote']) ? "<div class=\"error\">{$error['vote']}</div>" : '',
'bugid' => $bugid,
'TITLE' => "{$TITLE['editbug']} #$bugid",
- 'title' => stripslashes($row['title']),
- 'description' => nl2br(stripslashes($row['description'])),
+ 'title' => htmlentities(stripslashes($row['title'])),
+ 'description' => nl2br(htmlentities(stripslashes($row['description']))),
'url' => $row['url'],
'urllabel' => $row['url'] ? "<a href='{$row['url']}'>URL</a>" : 'URL',
'severity' => build_select('severity',$row['severity_id']),
|
|
From: Benjamin C. <bc...@us...> - 2002-03-26 17:12:34
|
Update of /cvsroot/phpbt/phpbt/languages In directory usw-pr-cvs1:/tmp/cvs-serv19966/languages Modified Files: cz.php de.php en.php es.php fr.php gb2312.php it.php no.php pt-br.php ru_koi8-r.php ru_windows-1251.php se.php Log Message: Added permission check and warning concerning the jpgraph images subdirectory Index: cz.php =================================================================== RCS file: /cvsroot/phpbt/phpbt/languages/cz.php,v retrieving revision 1.2 retrieving revision 1.3 diff -u -r1.2 -r1.3 --- cz.php 18 Mar 2002 17:42:23 -0000 1.2 +++ cz.php 26 Mar 2002 17:12:29 -0000 1.3 @@ -73,7 +73,8 @@ 0 => 'Vichni uivatelé', 1 => 'Aktivní uivatelé', 2 => 'Neaktivní uivatelé'), - 'dupe_dependency' => 'That bug dependency has already been added' + 'dupe_dependency' => 'That bug dependency has already been added', + 'image_path_not_writeable' => 'The subdirectory "jpgimages" is not writeable by the web process, so the summary image can not be rendered' ); // Page titles Index: de.php =================================================================== RCS file: /cvsroot/phpbt/phpbt/languages/de.php,v retrieving revision 1.12 retrieving revision 1.13 diff -u -r1.12 -r1.13 --- de.php 18 Mar 2002 17:42:24 -0000 1.12 +++ de.php 26 Mar 2002 17:12:29 -0000 1.13 @@ -76,7 +76,8 @@ 0 => 'All users', 1 => 'Active users', 2 => 'Inactive users'), - 'dupe_dependency' => 'That bug dependency has already been added' + 'dupe_dependency' => 'That bug dependency has already been added', + 'image_path_not_writeable' => 'The subdirectory "jpgimages" is not writeable by the web process, so the summary image can not be rendered' ); // Page titles Index: en.php =================================================================== RCS file: /cvsroot/phpbt/phpbt/languages/en.php,v retrieving revision 1.12 retrieving revision 1.13 diff -u -r1.12 -r1.13 --- en.php 18 Mar 2002 17:42:24 -0000 1.12 +++ en.php 26 Mar 2002 17:12:29 -0000 1.13 @@ -73,7 +73,8 @@ 0 => 'All users', 1 => 'Active users', 2 => 'Inactive users'), - 'dupe_dependency' => 'That bug dependency has already been added' + 'dupe_dependency' => 'That bug dependency has already been added', + 'image_path_not_writeable' => 'The subdirectory "jpgimages" is not writeable by the web process, so the summary image can not be rendered' ); // Page titles Index: es.php =================================================================== RCS file: /cvsroot/phpbt/phpbt/languages/es.php,v retrieving revision 1.5 retrieving revision 1.6 diff -u -r1.5 -r1.6 --- es.php 18 Mar 2002 17:42:24 -0000 1.5 +++ es.php 26 Mar 2002 17:12:29 -0000 1.6 @@ -73,7 +73,8 @@ 0 => 'All users', 1 => 'Active users', 2 => 'Inactive users'), - 'dupe_dependency' => 'That bug dependency has already been added' + 'dupe_dependency' => 'That bug dependency has already been added', + 'image_path_not_writeable' => 'The subdirectory "jpgimages" is not writeable by the web process, so the summary image can not be rendered' ); // Page titles Index: fr.php =================================================================== RCS file: /cvsroot/phpbt/phpbt/languages/fr.php,v retrieving revision 1.9 retrieving revision 1.10 diff -u -r1.9 -r1.10 --- fr.php 18 Mar 2002 17:42:24 -0000 1.9 +++ fr.php 26 Mar 2002 17:12:29 -0000 1.10 @@ -74,7 +74,8 @@ 0 => 'All users', 1 => 'Active users', 2 => 'Inactive users'), - 'dupe_dependency' => 'That bug dependency has already been added' + 'dupe_dependency' => 'That bug dependency has already been added', + 'image_path_not_writeable' => 'The subdirectory "jpgimages" is not writeable by the web process, so the summary image can not be rendered' ); // Page titles Index: gb2312.php =================================================================== RCS file: /cvsroot/phpbt/phpbt/languages/gb2312.php,v retrieving revision 1.8 retrieving revision 1.9 diff -u -r1.8 -r1.9 --- gb2312.php 18 Mar 2002 17:42:25 -0000 1.8 +++ gb2312.php 26 Mar 2002 17:12:29 -0000 1.9 @@ -76,7 +76,8 @@ 0 => 'All users', 1 => 'Active users', 2 => 'Inactive users'), - 'dupe_dependency' => 'That bug dependency has already been added' + 'dupe_dependency' => 'That bug dependency has already been added', + 'image_path_not_writeable' => 'The subdirectory "jpgimages" is not writeable by the web process, so the summary image can not be rendered' ); // Page titles Index: it.php =================================================================== RCS file: /cvsroot/phpbt/phpbt/languages/it.php,v retrieving revision 1.1 retrieving revision 1.2 diff -u -r1.1 -r1.2 --- it.php 22 Mar 2002 03:14:24 -0000 1.1 +++ it.php 26 Mar 2002 17:12:29 -0000 1.2 @@ -73,7 +73,8 @@ 0 => 'Tutti gli utenti', 1 => 'Utenti attivi', 2 => 'Utenti Inattivi'), - 'dupe_dependency' => 'La dipendenza per il bug e\' gia\' stata aggiunta' + 'dupe_dependency' => 'La dipendenza per il bug e\' gia\' stata aggiunta', + 'image_path_not_writeable' => 'The subdirectory "jpgimages" is not writeable by the web process, so the summary image can not be rendered' ); // Page titles Index: no.php =================================================================== RCS file: /cvsroot/phpbt/phpbt/languages/no.php,v retrieving revision 1.11 retrieving revision 1.12 diff -u -r1.11 -r1.12 --- no.php 18 Mar 2002 17:42:25 -0000 1.11 +++ no.php 26 Mar 2002 17:12:29 -0000 1.12 @@ -74,7 +74,8 @@ 0 => 'All users', 1 => 'Active users', 2 => 'Inactive users'), - 'dupe_dependency' => 'That bug dependency has already been added' + 'dupe_dependency' => 'That bug dependency has already been added', + 'image_path_not_writeable' => 'The subdirectory "jpgimages" is not writeable by the web process, so the summary image can not be rendered' ); // Page titles Index: pt-br.php =================================================================== RCS file: /cvsroot/phpbt/phpbt/languages/pt-br.php,v retrieving revision 1.13 retrieving revision 1.14 diff -u -r1.13 -r1.14 --- pt-br.php 18 Mar 2002 17:42:25 -0000 1.13 +++ pt-br.php 26 Mar 2002 17:12:29 -0000 1.14 @@ -74,7 +74,8 @@ 0 => 'All users', 1 => 'Active users', 2 => 'Inactive users'), - 'dupe_dependency' => 'That bug dependency has already been added' + 'dupe_dependency' => 'That bug dependency has already been added', + 'image_path_not_writeable' => 'The subdirectory "jpgimages" is not writeable by the web process, so the summary image can not be rendered' ); // Page titles Index: ru_koi8-r.php =================================================================== RCS file: /cvsroot/phpbt/phpbt/languages/ru_koi8-r.php,v retrieving revision 1.10 retrieving revision 1.11 diff -u -r1.10 -r1.11 --- ru_koi8-r.php 18 Mar 2002 17:42:25 -0000 1.10 +++ ru_koi8-r.php 26 Mar 2002 17:12:29 -0000 1.11 @@ -73,7 +73,8 @@ 0 => 'All users', 1 => 'Active users', 2 => 'Inactive users'), - 'dupe_dependency' => 'That bug dependency has already been added' + 'dupe_dependency' => 'That bug dependency has already been added', + 'image_path_not_writeable' => 'The subdirectory "jpgimages" is not writeable by the web process, so the summary image can not be rendered' ); // Page titles Index: ru_windows-1251.php =================================================================== RCS file: /cvsroot/phpbt/phpbt/languages/ru_windows-1251.php,v retrieving revision 1.10 retrieving revision 1.11 diff -u -r1.10 -r1.11 --- ru_windows-1251.php 18 Mar 2002 17:42:25 -0000 1.10 +++ ru_windows-1251.php 26 Mar 2002 17:12:29 -0000 1.11 @@ -73,7 +73,8 @@ 0 => 'All users', 1 => 'Active users', 2 => 'Inactive users'), - 'dupe_dependency' => 'That bug dependency has already been added' + 'dupe_dependency' => 'That bug dependency has already been added', + 'image_path_not_writeable' => 'The subdirectory "jpgimages" is not writeable by the web process, so the summary image can not be rendered' ); // Page titles Index: se.php =================================================================== RCS file: /cvsroot/phpbt/phpbt/languages/se.php,v retrieving revision 1.13 retrieving revision 1.14 diff -u -r1.13 -r1.14 --- se.php 18 Mar 2002 17:42:25 -0000 1.13 +++ se.php 26 Mar 2002 17:12:29 -0000 1.14 @@ -74,7 +74,8 @@ 0 => 'Alla användare', 1 => 'Aktiva användare', 2 => 'Inaktiva användare'), - 'dupe_dependency' => 'That bug dependency has already been added' + 'dupe_dependency' => 'That bug dependency has already been added', + 'image_path_not_writeable' => 'The subdirectory "jpgimages" is not writeable by the web process, so the summary image can not be rendered' ); // Page titles |
|
From: Benjamin C. <bc...@us...> - 2002-03-26 17:12:33
|
Update of /cvsroot/phpbt/phpbt
In directory usw-pr-cvs1:/tmp/cvs-serv19966
Modified Files:
index.php
Log Message:
Added permission check and warning concerning the jpgraph images subdirectory
Index: index.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/index.php,v
retrieving revision 1.20
retrieving revision 1.21
diff -u -r1.20 -r1.21
--- index.php 20 Mar 2002 15:14:48 -0000 1.20
+++ index.php 26 Mar 2002 17:12:29 -0000 1.21
@@ -94,7 +94,11 @@
// Show the overall bug stats
if (USE_JPGRAPH) {
- $t->set_var('sblock', build_image($restricted_projects));
+ if (!is_writeable('jpgimages')) {
+ $t->set_var('sblock', $STRING['image_path_not_writeable']);
+ } else {
+ $t->set_var('sblock', build_image($restricted_projects));
+ }
} else {
$stats = grab_data($restricted_projects);
$total = 0;
|
|
From: Benjamin C. <bc...@us...> - 2002-03-22 03:14:28
|
Update of /cvsroot/phpbt/phpbt/languages In directory usw-pr-cvs1:/tmp/cvs-serv18345/languages Added Files: it.php Log Message: Italian translation provided by Gaetano Giunta --- NEW FILE: it.php --- <?php // it.php - Italian 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: it.php,v 1.1 2002/03/22 03:14:24 bcurtis Exp $ $STRING = array( 'lang_charset' => 'us-ascii', 'nouser' => 'L\'utente non esiste', 'dupeofself' => 'Un bug non puo\' essere un duplicato di se stesso', 'nobug' => 'Il bug non esiste', 'givesummary' => 'Inserire un sommario', 'givedesc' => 'Inserire una descrizione', 'noprojects' => 'Nessun progetto trovato', 'totalbugs' => 'Bug totali', 'giveemail' => 'Inserire un indirizzo valido di posta elettronica', 'givelogin' => 'Inserire un login', 'loginused' => 'Il login e\' gia\' in uso', 'newacctsubject' => 'phpBugTracker Login', 'newacctmessage' => "La vostra password di phpBugTracker e\' %s", 'nobugs' => 'Nessun bug trovato', 'givename' => 'Inserire un nome', 'edit' => 'Modificare', 'addnew' => 'Aggiungere', 'nooses' => 'Nessun S.O. trovato', 'giveinitversion' => 'Inserire una versione iniziale per il progetto', 'giveversion' => 'Inserire una versione', 'noversions' => 'Nessuna versione trovata', 'nocomponents' => 'Nessun componente trovato', 'nostatuses' => 'Nessuno stato trovato', 'noseverities' => 'Nessuna severita\' trovata', 'givepassword' => 'Inserire una password', 'nousers' => 'Nessun utente trovato', 'bugbadperm' => 'Non potete cambiare questo bug', 'bugbadnum' => 'Il bug non esiste', 'datecollision' => 'Il bug e\' stato modificato il bug dopo che l\'avete visualizzato. L\'informazione sul bug e\' stata ricaricata con le ultime modifiche.', 'passwordmatch' => 'Le password non corrispondono -- Riprovare', 'nobughistory' => 'Non c\'e\' nessuna storia per il bug', 'logintomodify' => 'Bisogna aver fatto il login per modificare questo bug', 'dupe_attachment' => 'L\'attachment esiste gia\' per questo bug', 'give_attachment' => 'Specificare un file da caricare', 'no_attachment_save_path' => 'Manca il path in cui salvare il file!', 'attachment_path_not_writeable' => 'Non si puo\' creare un file nel path di salvataggio', 'attachment_move_error' => 'Si e\' verificato un errore spostando il file caricato', 'bad_attachment' => 'L\' attachment non esiste', 'attachment_too_large' => 'La dimensione del file specificato e\' maggiore di '.number_format(ATTACHMENT_MAX_SIZE).' byte', 'bad_permission' => 'Mancano i permessi richiesti per questa funzione', 'project_only_all_groups' => 'Non si possono scegliere gruppi specifici quando l\'opzione "Tutti i gruppi" e\' selezionata', 'previous_bug' => 'Precedente', 'next_bug' => 'Successivo', 'already_voted' => 'Avete gia\' votato per questo bug', 'too_many_votes' => 'Avete raggiunto il numero massimo di voti per utente', 'no_votes' => 'Non ci sono voti per questo bug', 'user_filter' => array( 0 => 'Tutti gli utenti', 1 => 'Utenti attivi', 2 => 'Utenti Inattivi'), 'dupe_dependency' => 'La dipendenza per il bug e\' gia\' stata aggiunta' ); // Page titles $TITLE = array( 'enterbug' => 'Inserisci Bug', 'editbug' => 'Modifica Bug', 'newaccount' => 'Crea nuovo account', 'bugquery' => 'Interrogazione Bug', 'buglist' => 'Lista dei Bug', 'addcomponent' => 'Aggiungi Componente', 'editcomponent' => 'Modifica Componente', 'addproject' => 'Aggiungi Progetto', 'editproject' => 'Modifica progetto', 'addversion' => 'Aggiungi Versione', 'editversion' => 'Modifica Versione', 'project' => 'Progetti', 'os' => 'Sistemi Operativi', 'resolution' => 'Risoluzioni', 'status' => 'Stati', 'severity' => 'Severita\'', 'user' => 'Utenti', 'home' => 'Home', 'reporting' => 'Reporting', 'group' => 'Gruppi' ); ?> |
|
From: Ben C. <php...@be...> - 2002-03-22 00:26:23
|
On Fri, Mar 22, 2002 at 03:53:05PM -0600, Cameron Moore wrote: > Hello, > I started testing out phpbt this week with the purpose of using it to > track bugs/tasks in the web development department where I work. I > tried out a couple other packages like phpbt and found them overly > complex (in setup and use) or just generally lacking in too many areas. > Phpbt appears to be a simple, yet powerful solution. I tried looking > back through some of the CVS commit messages in the list archives but > got tired of SF's interface. Is this list archived anywhere else? No, the list is not archived elsewhere, but I understand your frustration with the SF interface. If you are looking for just an overview of recent changes, the CHANGELOG is generally kept up-to-date with work completed in CVS. > > Anyway, I wanted to ask what plans you have for the near future. I'm an > unashamed Perl hacker, but I don't have any major qualls with hacking on > PHP. I'd like to lend a hand once I get my head our the way things are > done inside phpbt. Sadly, I don't have good plans for the immediate future. Since this is the second time someone has asked in as many weeks, I suppose I should really get to it, shouldn't I? :) One of the things that has been floating around in my mind, though, is that the documentation is in need of updating. Of course, that usually is the last thing anybody wants to do. Two things I can think of, though, that need attention are reporting and db portability in the query (e.g., case-sensitive issues). > > Here's my current list of phpbt issues: > > - HTML chars are not handled correctly when used in the bug summary > - Need directory/permission checks in index.php:build_image(); took me > a while to figure out phpbt kept dying every time I turned on jpgraph; > turns out I didn't have a jpgimages/ directory. > - Main page needs the option of showing the project next to the latest > items (probably in a <table/>) Yeah, I knew I should have added this to the summary in the first place. :) > - Would like the ability to colorize by Priority (known issue) > - Would like a 'show all unassigned bugs' query (known issue) > - Would like a 'site name' option in the Configuration section and > replace 'phpBugTracker' with that value That's a good one > - Default theme is a little crude in places Indeed -- I'm not the best designer, by any means. Actually, I'm surprised how long those templates I originally just threw together have lasted. > > I'm still waiting to get the go-ahead from the head web guy whether he > likes phpbt or not, but I'm expecting him to okay it. Once it's okayed > (and I get authentication working correctly with the CVS version), I > hope to help fix some of the issues listed above. Your help is certainly welcome and appreciated. At the least, thanks for outlining the issues you currently have. Feel free to let me know how I can help you. |
|
From: Cameron M. <li...@un...> - 2002-03-21 21:53:09
|
Hello, I started testing out phpbt this week with the purpose of using it to track bugs/tasks in the web development department where I work. I tried out a couple other packages like phpbt and found them overly complex (in setup and use) or just generally lacking in too many areas. Phpbt appears to be a simple, yet powerful solution. I tried looking back through some of the CVS commit messages in the list archives but got tired of SF's interface. Is this list archived anywhere else? Anyway, I wanted to ask what plans you have for the near future. I'm an unashamed Perl hacker, but I don't have any major qualls with hacking on PHP. I'd like to lend a hand once I get my head our the way things are done inside phpbt. Here's my current list of phpbt issues: - HTML chars are not handled correctly when used in the bug summary - Need directory/permission checks in index.php:build_image(); took me a while to figure out phpbt kept dying every time I turned on jpgraph; turns out I didn't have a jpgimages/ directory. - Main page needs the option of showing the project next to the latest items (probably in a <table/>) - Would like the ability to colorize by Priority (known issue) - Would like a 'show all unassigned bugs' query (known issue) - Would like a 'site name' option in the Configuration section and replace 'phpBugTracker' with that value - Default theme is a little crude in places I'm still waiting to get the go-ahead from the head web guy whether he likes phpbt or not, but I'm expecting him to okay it. Once it's okayed (and I get authentication working correctly with the CVS version), I hope to help fix some of the issues listed above. -- Cameron Moore [ Can you buy an entire chess set in a pawn shop? ] |
|
From: Benjamin C. <bc...@us...> - 2002-03-21 13:44:58
|
Update of /cvsroot/phpbt/phpbt
In directory usw-pr-cvs1:/tmp/cvs-serv21944
Modified Files:
bug.php config-dist.php config.php upgrade.php user.php
Log Message:
The first user preference: Whether to receive email notifications of bug changes
Index: bug.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/bug.php,v
retrieving revision 1.86
retrieving revision 1.87
diff -u -r1.86 -r1.87
--- bug.php 20 Mar 2002 15:59:24 -0000 1.86
+++ bug.php 21 Mar 2002 13:44:54 -0000 1.87
@@ -216,11 +216,13 @@
// Reporter never changes;
$reporter = $db->getOne('select email from '.TBL_AUTH_USER
- ." where user_id = {$buginfo['created_by']}");
+ ." u, ".TBL_USER_PREF." p where u.user_id = {$buginfo['created_by']} ".
+ "and u.user_id = p.user_id and email_notices = 1");
$reporterstat = ' ';
- $assignedto = $db->getOne('select email from '.TBL_AUTH_USER
- .' where user_id = '
- .(!empty($cf['assigned_to']) ? $cf['assigned_to'] : $buginfo['assigned_to']));
+ $assignedto = $db->getOne('select email from '.TBL_AUTH_USER." u, ".
+ TBL_USER_PREF.' p where u.user_id = '
+ .(!empty($cf['assigned_to']) ? $cf['assigned_to'] : $buginfo['assigned_to']).
+ " and u.user_id = p.user_id and email_notices = 1");
$assignedtostat = !empty($cf['assigned_to']) ? '!' : ' ';
// If there are new comments grab the comments immediately before the latest
@@ -262,39 +264,45 @@
$t->set_var('cblock', '');
}
+ $maillist = array();
// Don't email the person who just made the changes (later, make this
// behavior toggable by the user)
- if ($userid != $buginfo['created_by'])
+ if ($userid != $buginfo['created_by'] and !empty($reporter))
$maillist[] = $reporter;
- if ($userid != (!empty($cf['assigned_to']) ? $cf['assigned_to'] : $buginfo['assigned_to']))
+ if ($userid != (!empty($cf['assigned_to']) ? $cf['assigned_to'] : $buginfo['assigned_to'])
+ and !empty($assignedto))
$maillist[] = $assignedto;
// Collect the CCs
if ($ccs = $db->getCol('select email from '.TBL_BUG_CC.' left join '.
- TBL_AUTH_USER." using(user_id) where bug_id = {$buginfo['bug_id']}")) {
+ TBL_AUTH_USER." u using(user_id), ".TBL_USER_PREF." p ".
+ "where bug_id = {$buginfo['bug_id']} and u.user_id = p.user_id ".
+ "and email_notices = 1")) {
array_push($maillist, $ccs);
}
// Later add a watcher (such as QA person) check here
- $toemail = delimit_list(', ',$maillist);
+ if (count($maillist)) {
+ if ($toemail = delimit_list(', ',$maillist)) {
- $t->set_var(array(
- 'bugid' => $buginfo['bug_id'],
- 'bugurl' => INSTALL_URL."/bug.php?op=show&bugid={$buginfo['bug_id']}",
- 'priority' => $select['priority'][(!empty($cf['priority']) ? $cf['priority'] : $buginfo['priority'])],
- 'priority_stat' => !empty($cf['priority']) ? '!' : ' ',
- 'reporter' => $reporter,
- 'reporter_stat' => $reporterstat,
- 'assignedto' => $assignedto,
- 'assignedto_stat' => $assignedtostat
- ));
- if ($toemail) {
- mail($toemail,"[Bug {$buginfo['bug_id']}] ".($newbug ? 'New' : 'Changed').
- ' - '.(!empty($cf['title']) ? $cf['title'] : $buginfo['title']),
- $t->parse('main','emailout'),
- sprintf("From: %s\nReply-To: %s\nErrors-To: %s\nContent-Type: text/plain; charset=%s\nContent-Transfer-Encoding: 8bit\n", ADMIN_EMAIL, ADMIN_EMAIL,
- ADMIN_EMAIL, $STRING['lang_charset']));
- }
+ $t->set_var(array(
+ 'bugid' => $buginfo['bug_id'],
+ 'bugurl' => INSTALL_URL."/bug.php?op=show&bugid={$buginfo['bug_id']}",
+ 'priority' => $select['priority'][(!empty($cf['priority']) ? $cf['priority'] : $buginfo['priority'])],
+ 'priority_stat' => !empty($cf['priority']) ? '!' : ' ',
+ 'reporter' => $reporter,
+ 'reporter_stat' => $reporterstat,
+ 'assignedto' => $assignedto,
+ 'assignedto_stat' => $assignedtostat
+ ));
+
+ mail($toemail,"[Bug {$buginfo['bug_id']}] ".($newbug ? 'New' : 'Changed').
+ ' - '.(!empty($cf['title']) ? $cf['title'] : $buginfo['title']),
+ $t->parse('main','emailout'),
+ sprintf("From: %s\nReply-To: %s\nErrors-To: %s\nContent-Type: text/plain; charset=%s\nContent-Transfer-Encoding: 8bit\n", ADMIN_EMAIL, ADMIN_EMAIL,
+ ADMIN_EMAIL, $STRING['lang_charset']));
+ }
+ }
}
function update_bug($bugid = 0) {
@@ -692,8 +700,8 @@
"and {$_sv['queryinfo']['query']} and bug_id <> $bugid
order by {$_sv['queryinfo']['order']} {$_sv['queryinfo']['sort']}, bug_id asc", $offset, $limit);
- $firstid = $db->getOne();
- $secondid = $db->getOne();
+ list($firstid, $chunks) = $rs->fetchRow(DB_FETCHMODE_ORDERED);
+ list($secondid, $chunks) = $rs->fetchRow(DB_FETCHMODE_ORDERED);
if ($pos) {
if ($firstid) {
Index: config-dist.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/config-dist.php,v
retrieving revision 1.9
retrieving revision 1.10
diff -u -r1.9 -r1.10
--- config-dist.php 18 Mar 2002 18:01:53 -0000 1.9
+++ config-dist.php 21 Mar 2002 13:44:54 -0000 1.10
@@ -56,6 +56,7 @@
define ('TBL_STATUS', TBL_PREFIX.'status');
define ('TBL_USER_GROUP', TBL_PREFIX.'user_group');
define ('TBL_USER_PERM', TBL_PREFIX.'user_perm');
+define ('TBL_USER_PREF', TBL_PREFIX.'user_pref');
define ('TBL_VERSION', TBL_PREFIX.'version');
define ('TBL_PROJECT_GROUP', TBL_PREFIX.'project_group');
Index: config.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/config.php,v
retrieving revision 1.25
retrieving revision 1.26
diff -u -r1.25 -r1.26
--- config.php 18 Mar 2002 18:00:38 -0000 1.25
+++ config.php 21 Mar 2002 13:44:54 -0000 1.26
@@ -58,6 +58,7 @@
define ('TBL_STATUS', TBL_PREFIX.'status');
define ('TBL_USER_GROUP', TBL_PREFIX.'user_group');
define ('TBL_USER_PERM', TBL_PREFIX.'user_perm');
+define ('TBL_USER_PREF', TBL_PREFIX.'user_pref');
define ('TBL_VERSION', TBL_PREFIX.'version');
define ('TBL_PROJECT_GROUP', TBL_PREFIX.'project_group');
Index: upgrade.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/upgrade.php,v
retrieving revision 1.14
retrieving revision 1.15
diff -u -r1.14 -r1.15
--- upgrade.php 20 Mar 2002 20:10:09 -0000 1.14
+++ upgrade.php 21 Mar 2002 13:44:54 -0000 1.15
@@ -38,11 +38,17 @@
}
$rs = $db->query("select * from ".TBL_DB_SEQUENCE);
if (DB_TYPE == 'pgsql') {
+ // Set up the user prefs table
+ $db->query("CREATE TABLE ".TBL_USER_PREF." ( user_id INT4 NOT NULL DEFAULT '0', email_notices INT2 NOT NULL DEFAULT '1', PRIMARY KEY (user_id) )");
+ $db->query("insert into ".TBL_USER_PREF." (user_id) select user_id from ".TBL_AUTH_USER);
// Move the sequences
while ($rs->fetchInto($row)) {
$db->query("create sequence {$row['seq_name']}_seq start {$row['nextid']}");
}
} else {
+ // Set up the user prefs table
+ $db->query("CREATE TABLE ".TBL_USER_PREF." ( user_id int(11) NOT NULL default '0', email_notices tinyint(1) NOT NULL default '1', PRIMARY KEY (user_id) )");
+ $db->query("insert into ".TBL_USER_PREF." (user_id) select user_id from ".TBL_AUTH_USER);
// Move the sequences
while ($rs->fetchInto($row)) {
$db->query("create table {$row['seq_name']}_seq (id int unsigned auto_increment not null primary key)");
Index: user.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/user.php,v
retrieving revision 1.21
retrieving revision 1.22
diff -u -r1.21 -r1.22
--- user.php 20 Mar 2002 20:04:04 -0000 1.21
+++ user.php 21 Mar 2002 13:44:54 -0000 1.22
@@ -62,11 +62,36 @@
$t->set_file('content', 'passwordchanged.html');
}
+// Save changes to a user's preferences
+function change_preferences($prefs) {
+ global $db, $u, $t;
+
+ $updates = array();
+
+ $old_prefs = $db->getRow("select * from ".TBL_USER_PREF." where user_id = $u");
+ array_shift($old_prefs); // Drop the user_id field
+ $updates = array();
+ foreach ($old_prefs as $pref => $val) {
+ if (in_array($pref, $prefs) and !$val) {
+ $updates[] = "set $pref = 1";
+ } elseif (!in_array($pref, $prefs) and $val) {
+ $updates[] = "set $pref = 0";
+ }
+ }
+ if (count($updates)) {
+ $db->query("update ".TBL_USER_PREF.' '.@join(', ', $updates).
+ " where user_id = $u");
+ }
+ $t->set_file('content', 'preferenceschanged.html');
+}
+
+
function show_preferences_form($error = '') {
global $t, $pass1, $pass2, $all_db_fields, $default_db_fields, $_sv, $db, $u;
$t->set_file('content', 'user.html');
$t->set_block('content', 'column_list_row', 'list_rows');
+ $t->set_block('content', 'pref_row', 'pref_rows');
$t->set_block('content', 'votesblock', 'votesb');
$t->set_block('votesblock', 'vote_row', 'vote_rows');
@@ -107,6 +132,22 @@
}
$t->parse('votesb', 'votesblock', true);
}
+
+ // Display current preference settings
+ $pref_labels = array(
+ 'email_notices' => 'Receive notifications of bug changes via email'
+ );
+ $prefs = $db->getRow("select * from ".TBL_USER_PREF." where user_id = $u");
+ array_shift($prefs);
+
+ foreach ($prefs as $pref => $val) {
+ $t->set_var(array(
+ 'pref_label' => $pref_labels[$pref],
+ 'pref' => $pref,
+ 'checked' => $val ? 'checked' : ''
+ ));
+ $t->parse('pref_rows', 'pref_row', true);
+ }
}
$t->set_file('wrap', 'wrap.html');
@@ -118,6 +159,7 @@
elseif (isset($_pv['do'])) switch ($_pv['do']) {
case 'changepassword' : change_password($_pv['pass1'], $_pv['pass2']); break;
case 'changecolumnlist' : change_bug_list_columns($_pv['column_list']); break;
+ case 'changeprefs' : change_preferences(isset($_pv['preferences']) ? $_pv['preferences'] : array()); break;
default : show_preferences_form();
}
else show_preferences_form();
|
|
From: Benjamin C. <bc...@us...> - 2002-03-21 13:44:57
|
Update of /cvsroot/phpbt/phpbt/templates/default
In directory usw-pr-cvs1:/tmp/cvs-serv21944/templates/default
Modified Files:
passwordchanged.html user.html
Added Files:
preferenceschanged.html
Log Message:
The first user preference: Whether to receive email notifications of bug changes
--- NEW FILE: preferenceschanged.html ---
<div align="center">
<br>
<br>
Your preferences have been changed successfully
<br>
<br>
Return to the <a href="user.php">Personal Page</a> or <a href="index.php">phpBugTracker Home</a>.
</div>
Index: passwordchanged.html
===================================================================
RCS file: /cvsroot/phpbt/phpbt/templates/default/passwordchanged.html,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- passwordchanged.html 1 Aug 2001 13:55:56 -0000 1.1
+++ passwordchanged.html 21 Mar 2002 13:44:54 -0000 1.2
@@ -1,4 +1,8 @@
-Your password has been changed successfully
-<br>
-<br>
-<a href="index.php">Return to phpBugTracker home</a>
+<div align="center">
+ <br>
+ <br>
+ Your password has been changed successfully
+ <br>
+ <br>
+ Return to the <a href="user.php">Personal Page</a> or <a href="index.php">phpBugTracker Home</a>.
+</div>
Index: user.html
===================================================================
RCS file: /cvsroot/phpbt/phpbt/templates/default/user.html,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -r1.3 -r1.4
--- user.html 28 Feb 2002 18:23:31 -0000 1.3
+++ user.html 21 Mar 2002 13:44:54 -0000 1.4
@@ -1,36 +1,67 @@
-<form action="{me}" method="post">
-<input type="hidden" name="do" value="changepassword">
- <table border="0" cellpadding="0" cellspacing="0" width="600">
- <tr>
- <td colspan="2" width="600"><b>Change Password</b></td>
- </tr>
- <tr>
- <td colspan="2" width="600">
- <font color="#ff0000">{error}</font>
- </td>
- </tr>
- <tr>
- <td colspan="2" width="600">Please enter your new password twice below</td>
- </tr>
- <tr>
- <td>Password: </td>
- <td><input type="password" name="pass1" value="{pass1}"></td>
- </tr>
- <tr>
- <td>Verify: </td>
- <td><input type="password" name="pass2" value="{pass2}"></td>
- </tr>
- <tr>
- <td colspan="2">
- <input type="reset">
- <input type="submit" value="Submit">
- </td>
- </tr>
- </table>
+<table border="0" cellpadding="0" cellspacing="0" width="600">
+ <td width="300" valign="top">
+ <form action="{me}" method="post">
+ <input type="hidden" name="do" value="changepassword">
+ <table border="0" cellpadding="0" cellspacing="0" width="300">
+ <tr>
+ <td colspan="2" width="300"><b>Change Password</b></td>
+ </tr>
+ <tr>
+ <td colspan="2" width="300" class="error">{error}</td>
+ </tr>
+ <tr>
+ <td colspan="2" width="300">Please enter your new password twice below</td>
+ </tr>
+ <tr>
+ <td>Password: </td>
+ <td><input type="password" name="pass1" value="{pass1}"></td>
+ </tr>
+ <tr>
+ <td>Verify: </td>
+ <td><input type="password" name="pass2" value="{pass2}"></td>
+ </tr>
+ <tr>
+ <td colspan="2" align="center">
+ <br>
+ <input type="reset">
+ <input type="submit" value="Submit">
+ </td>
+ </tr>
+ </table>
+ </form>
+ </td>
+ <td width="300" valign="top">
+ <form action="{me}" method="post">
+ <input type="hidden" name="do" value="changeprefs">
+ <table border="0" cellpadding="0" cellspacing="0" width="300">
+ <tr>
+ <td colspan="2" width="300"><b>Change Preferences</b></td>
+ </tr>
+ <tr>
+ <td colspan="2" width="300" class="error"></td>
+ </tr>
+ <!-- BEGIN pref_row -->
+ <tr>
+ <td>{pref_label}: </td>
+ <td><input type="checkbox" name="preferences[]" value="{pref}" {checked}></td>
+ </tr>
+ <!-- END pref_row -->
+ <tr>
+ <td colspan="2" align="center">
+ <br>
+ <input type="reset">
+ <input type="submit" value="Submit">
+ </td>
+ </tr>
+ </table>
+ </form>
+ </td>
+</table>
</form>
+<br>
<form action="{me}" method="post">
<input type="hidden" name="do" value="changecolumnlist">
- <table border="0" cellpadding="0" cellspacing="0" width="600">
+ <table border="0" cellpadding="0" cellspacing="0" width="300">
<td width="300">
<table border="0" cellpadding="0" cellspacing="0" width="300">
<tr>
@@ -48,7 +79,8 @@
</tr>
<!-- END column_list_row -->
<tr>
- <td>
+ <td align="center">
+ <br>
<input type="reset">
<input type="submit" value="Submit">
</td>
|
|
From: Benjamin C. <bc...@us...> - 2002-03-21 13:44:57
|
Update of /cvsroot/phpbt/phpbt/schemas In directory usw-pr-cvs1:/tmp/cvs-serv21944/schemas Modified Files: mysql.in oci8.in pgsql.in Log Message: The first user preference: Whether to receive email notifications of bug changes Index: mysql.in =================================================================== RCS file: /cvsroot/phpbt/phpbt/schemas/mysql.in,v retrieving revision 1.18 retrieving revision 1.19 diff -u -r1.18 -r1.19 --- mysql.in 20 Mar 2002 20:10:09 -0000 1.18 +++ mysql.in 21 Mar 2002 13:44:54 -0000 1.19 @@ -232,6 +232,12 @@ KEY perm_id (perm_id) ) TYPE=MyISAM; +CREATE TABLE TBL_USER_PREF ( + user_id int(11) NOT NULL default '0', + email_notices tinyint(1) NOT NULL default '1', + PRIMARY KEY (user_id) +) TYPE=MyISAM; + CREATE TABLE TBL_VERSION ( version_id int(10) unsigned NOT NULL default '0', project_id int(10) unsigned NOT NULL default '0', Index: oci8.in =================================================================== RCS file: /cvsroot/phpbt/phpbt/schemas/oci8.in,v retrieving revision 1.4 retrieving revision 1.5 diff -u -r1.4 -r1.5 --- oci8.in 20 Mar 2002 20:10:09 -0000 1.4 +++ oci8.in 21 Mar 2002 13:44:54 -0000 1.5 @@ -237,6 +237,12 @@ ) ; CREATE INDEX PERMUSERIDX ON TBL_USER_PERM ( perm_id ); +CREATE TABLE TBL_USER_PREF ( + user_id number(10) default '0' NOT NULL, + email_notices number(1) default '1' NOT NULL, + PRIMARY KEY (user_id) +) ; + CREATE TABLE TBL_VERSION ( version_id number(10) default '0' NOT NULL, project_id number(10) default '0' NOT NULL, Index: pgsql.in =================================================================== RCS file: /cvsroot/phpbt/phpbt/schemas/pgsql.in,v retrieving revision 1.20 retrieving revision 1.21 diff -u -r1.20 -r1.21 --- pgsql.in 20 Mar 2002 20:10:09 -0000 1.20 +++ pgsql.in 21 Mar 2002 13:44:54 -0000 1.21 @@ -230,6 +230,12 @@ PRIMARY KEY (user_id,perm_id) ); +CREATE TABLE TBL_USER_PREF ( + user_id INT4 NOT NULL DEFAULT '0', + email_notices INT2 NOT NULL DEFAULT '1', + PRIMARY KEY (user_id) +); + CREATE TABLE TBL_VERSION ( version_id INT4 NOT NULL DEFAULT '0', project_id INT4 NOT NULL DEFAULT '0', |
|
From: Benjamin C. <bc...@us...> - 2002-03-20 23:56:25
|
Update of /cvsroot/phpbt/phpbt/inc
In directory usw-pr-cvs1:/tmp/cvs-serv27272/inc
Modified Files:
functions.php
Log Message:
Reworking authentication
Index: functions.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/inc/functions.php,v
retrieving revision 1.10
retrieving revision 1.11
diff -u -r1.10 -r1.11
--- functions.php 20 Mar 2002 20:00:14 -0000 1.10
+++ functions.php 20 Mar 2002 23:56:22 -0000 1.11
@@ -43,7 +43,7 @@
///
/// Build a select box with the item matching $value selected
function build_select($box, $value = '', $project = 0) {
- global $db, $select, $perm, $auth, $STRING, $restricted_projects;
+ global $db, $select, $perm, $STRING, $restricted_projects;
//create hash to map tablenames
$cfgDatabase = array(
@@ -300,9 +300,9 @@
///
/// If the constant is set do a little email masking to make harvesting a little harder
function maskemail($email) {
- global $auth;
+ global $_sv;
- if (HIDE_EMAIL && empty($auth->auth['uid'])) {
+ if (HIDE_EMAIL && empty($_sv['uid'])) {
return '******';
} elseif (MASK_EMAIL) {
return str_replace('@', ' at ', str_replace('.', ' dot ', $email));
@@ -314,7 +314,7 @@
///
/// Build the javascript for the dynamic project -> component -> version select boxes
function build_project_js() {
- global $db, $u, $perm, $auth;
+ global $db, $u, $perm, $_sv;
$js = '';
@@ -326,7 +326,7 @@
$rs = $db->query('select p.project_id, project_name from '.TBL_PROJECT.
' p left join '.TBL_PROJECT_GROUP.' pg using(project_id)
where active = 1 and (pg.project_id is null or pg.group_id in ('.
- delimit_list(',', $auth->auth['group_ids']).')) group by
+ delimit_list(',', $_sv['group_ids']).')) group by
p.project_id, p.project_name order by project_name');
}
while (list($pid, $pname) = $rs->fetchRow(DB_FETCHMODE_ORDERED)) {
|
|
From: Ben C. <php...@be...> - 2002-03-20 20:13:41
|
Well, this change clobbered being able to have register_globals = off.
So, I've reworked the authentication stuff to push values directly into
the session array, rather then as an array that's a member of the auth
class. Bang away on it... this functionality should be well tested. :)
On Tue, Feb 26, 2002 at 06:51:44AM -0800, Ben Curtis wrote:
> Yup, feel free to make changes. I'll try to look at it today myself.
> It's benn an experience trying to convert that PHPlib stuff to work
> without register_globals. :)
>
> On Tue, Feb 26, 2002 at 10:10:55AM +0100, Patrick Mairif wrote:
> > this
> > $a =& $HTTP_SESSION_VARS['auth'];
> > $this->auth =& $a->auth;
> > solves the problem for me, but this solution depends on the name of
> > the instance of the class. it must be "auth".
> >
> > I would prefer a solution in which the object is stored and restored
> > where it's declared, outside of the class.
> >
> > sth. like
> > $auth = new uauth; //declaration of the object
> > session_start();
> > session_register("auth"); //restoring the object from the session
> >
> > I didn't had the time this morning to check where it has to be
> > changed, but I would do it this evening or so with your ok, Ben.
> >
> > _______________________________________________
> > phpbt-dev mailing list
> > php...@li...
> > https://lists.sourceforge.net/lists/listinfo/phpbt-dev
>
> _______________________________________________
> phpbt-dev mailing list
> php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpbt-dev
|
|
From: Benjamin C. <bc...@us...> - 2002-03-20 20:10:16
|
Update of /cvsroot/phpbt/phpbt/schemas
In directory usw-pr-cvs1:/tmp/cvs-serv14227/schemas
Modified Files:
mysql.in oci8.in pgsql.in
Log Message:
Added "Remember me" functionality
Index: mysql.in
===================================================================
RCS file: /cvsroot/phpbt/phpbt/schemas/mysql.in,v
retrieving revision 1.17
retrieving revision 1.18
diff -u -r1.17 -r1.18
--- mysql.in 18 Mar 2002 17:47:07 -0000 1.17
+++ mysql.in 20 Mar 2002 20:10:09 -0000 1.18
@@ -286,6 +286,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 ('RECALL_LOGIN', '0', 'Enable use of cookies to store username between logins', 'bool');
INSERT INTO TBL_CONFIGURATION VALUES ('PROMOTE_VOTES', 5, 'The number of votes required to promote a bug from Unconfirmed to New (Set to 0 to disable promotions by voting)', 'string');
INSERT INTO TBL_CONFIGURATION VALUES ('MAX_USER_VOTES', 5, 'The maximum number of votes a user can cast across all bugs (Set to 0 to have no limit)', 'string');
INSERT INTO TBL_CONFIGURATION VALUES ('ATTACHMENT_PATH','attachments','Sub-dir of the INSTALLPATH - Needs to be writeable by the web process','string');
Index: oci8.in
===================================================================
RCS file: /cvsroot/phpbt/phpbt/schemas/oci8.in,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -r1.3 -r1.4
--- oci8.in 18 Mar 2002 17:47:07 -0000 1.3
+++ oci8.in 20 Mar 2002 20:10:09 -0000 1.4
@@ -285,6 +285,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 ('RECALL_LOGIN', '0', 'Enable use of cookies to store username between logins', 'bool');
INSERT INTO TBL_CONFIGURATION VALUES ('PROMOTE_VOTES', 5, 'The number of votes required to promote a bug from Unconfirmed to New (Set to 0 to disable promotions by voting)', 'string');
INSERT INTO TBL_CONFIGURATION VALUES ('MAX_USER_VOTES', 5, 'The maximum number of votes a user can cast across all bugs (Set to 0 to have no limit)', 'string');
INSERT INTO TBL_CONFIGURATION VALUES ('ATTACHMENT_PATH','attachments','Sub-dir of the INSTALLPATH - Needs to be writeable by the web process','string');
Index: pgsql.in
===================================================================
RCS file: /cvsroot/phpbt/phpbt/schemas/pgsql.in,v
retrieving revision 1.19
retrieving revision 1.20
diff -u -r1.19 -r1.20
--- pgsql.in 18 Mar 2002 17:47:07 -0000 1.19
+++ pgsql.in 20 Mar 2002 20:10:09 -0000 1.20
@@ -282,6 +282,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 ('RECALL_LOGIN', '0', 'Enable use of cookies to store username between logins', 'bool');
INSERT INTO TBL_CONFIGURATION VALUES ('PROMOTE_VOTES', 5, 'The number of votes required to promote a bug from Unconfirmed to New (Set to 0 to disable promotions by voting)', 'string');
INSERT INTO TBL_CONFIGURATION VALUES ('MAX_USER_VOTES', 5, 'The maximum number of votes a user can cast across all bugs (Set to 0 to have no limit)', 'string');
INSERT INTO TBL_CONFIGURATION VALUES ('ATTACHMENT_PATH','attachments','Sub-dir of the INSTALLPATH - Needs to be writeable by the web process','string');
|
|
From: Benjamin C. <bc...@us...> - 2002-03-20 20:10:15
|
Update of /cvsroot/phpbt/phpbt
In directory usw-pr-cvs1:/tmp/cvs-serv14227
Modified Files:
upgrade.php
Log Message:
Added "Remember me" functionality
Index: upgrade.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/upgrade.php,v
retrieving revision 1.13
retrieving revision 1.14
diff -u -r1.13 -r1.14
--- upgrade.php 18 Mar 2002 17:52:56 -0000 1.13
+++ upgrade.php 20 Mar 2002 20:10:09 -0000 1.14
@@ -49,6 +49,7 @@
$db->query("insert into {$row['seq_name']}_seq values ({$row['nextid']})");
}
}
+ $db->query("INSERT INTO ".TBL_CONFIGURATION." VALUES ('RECALL_LOGIN','0','Enable use of cookies to store username between logins','bool')");
}
include 'templates/default/upgrade-finished.html';
}
|
2 messages has been excluded from this view by a project administrator.
