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-08-20 23:16:53
|
Update of /cvsroot/phpbt/phpbt
In directory usw-pr-cvs1:/tmp/cvs-serv19463
Modified Files:
include.php query.php user.php
Log Message:
Getting closer on theuser bug list column preferences
Index: include.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/include.php,v
retrieving revision 1.32
retrieving revision 1.33
diff -u -r1.32 -r1.33
--- include.php 2001/08/18 20:11:52 1.32
+++ include.php 2001/08/20 23:16:50 1.33
@@ -91,6 +91,40 @@
15 => 'Administrator'
);
+$all_db_fields = array(
+ 'bug_id' => 'ID',
+ 'title' => 'Title',
+ 'description' => 'Description',
+ 'url' => 'URL',
+ 'severity_name' => 'Severity',
+ 'priority' => 'Priority',
+ 'status_name' => 'Status',
+ 'resolution_name' => 'Resolution',
+ 'assigned_to' => 'Assigned To',
+ 'reporter' => 'Reporter',
+ 'owner' => 'Owner',
+ 'created_date' => 'Created',
+ 'last_modified_by' => 'Last Modified',
+ 'last_modified_date' => 'Last Modified By',
+ 'project_name' => 'Project',
+ 'version_name' => 'Version',
+ 'component_name' => 'Component',
+ 'os_name' => 'OS',
+ 'browser_string' => 'Browser',
+ 'close_date' => 'Closed'
+ );
+
+$default_db_fields = array(
+ 'bug_id' => 'ID',
+ 'title' => 'Title',
+ 'reporter' => 'Reporter',
+ 'owner' => 'Owner',
+ 'severity_name' => 'Severity',
+ 'priority' => 'Priority',
+ 'status_name' => 'Status',
+ 'resolution_name' => 'Resolution'
+ );
+
class sqlclass extends CT_Sql {
var $database_class = 'dbclass';
var $database_table = 'active_sessions';
Index: query.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/query.php,v
retrieving revision 1.19
retrieving revision 1.20
diff -u -r1.19 -r1.20
--- query.php 2001/08/20 22:30:39 1.19
+++ query.php 2001/08/20 23:16:50 1.20
@@ -23,39 +23,6 @@
include 'include.php';
-$dbfields = array(
- 'bug_id' => 'ID',
- 'title' => 'Title',
- 'description' => 'Description',
- 'url' => 'URL',
- 'severity_name' => 'Severity',
- 'priority' => 'Priority',
- 'status_name' => 'Status',
- 'resolution_name' => 'Resolution',
- 'assigned_to' => 'Assigned To',
- 'reporter' => 'Reporter',
- 'owner' => 'Owner',
- 'created_date' => 'Created',
- 'last_modified_by' => 'Last Modified',
- 'last_modified_date' => 'Last Modified By',
- 'project_name' => 'Project',
- 'version_name' => 'Version',
- 'component_name' => 'Component',
- 'os_name' => 'OS',
- 'browser_string' => 'Browser',
- 'close_date' => 'Closed'
- );
-$mydbfields = array(
- 'bug_id' => 'ID',
- 'title' => 'Title',
- 'reporter' => 'Reporter',
- 'owner' => 'Owner',
- 'severity_name' => 'Severity',
- 'priority' => 'Priority',
- 'status_name' => 'Status',
- 'resolution_name' => 'Resolution'
- );
-
function delete_saved_query($queryid) {
global $q, $u, $me;
@@ -191,7 +158,7 @@
function list_items($assignedto = 0, $reportedby = 0, $open = 0) {
global $querystring, $me, $q, $t, $selrange, $order, $sort, $query,
- $page, $op, $select, $TITLE, $STRING, $savedqueryname, $u, $mydbfields;
+ $page, $op, $select, $TITLE, $STRING, $savedqueryname, $u, $default_db_fields;
$t->set_file('content','buglist.html');
$t->set_block('content','row','rows');
@@ -247,7 +214,7 @@
}
// Header row
- foreach ($mydbfields as $field => $title) {
+ foreach ($default_db_fields as $field => $title) {
$t->set_var(array(
'coldata' => "<a href='{{$field}url}'>$title</a>",
'td-extra' => "class=\"header-col\" bgcolor=\"{{$field}color}\""
@@ -262,7 +229,7 @@
while ($row = $q->grab()) {
$bgcolor = USE_SEVERITY_COLOR ? $row['severity_color'] :
((++$i % 2 == 0) ? '#dddddd' : '#ffffff');
- foreach ($mydbfields as $field => $title) {
+ foreach ($default_db_fields as $field => $title) {
switch ($field) {
case 'url' :
$coldata = "<a href='{$row[$field]}'>{$row[$field]}</a>";
@@ -303,7 +270,7 @@
$t->parse('rows','row',true);
$t->set_var('cols', '');
}
- $t->set_var('numcols', count($mydbfields));
+ $t->set_var('numcols', count($default_db_fields));
}
$t->set_file('wrap','wrap.html');
Index: user.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/user.php,v
retrieving revision 1.9
retrieving revision 1.10
diff -u -r1.9 -r1.10
--- user.php 2001/08/20 22:56:30 1.9
+++ user.php 2001/08/20 23:16:50 1.10
@@ -53,15 +53,27 @@
}
function show_preferences_form($error = '') {
- global $t, $pass1, $pass2;
+ global $t, $pass1, $pass2, $all_db_fields, $default_db_fields, $auth;
$t->set_file('content', 'user.html');
+ $t->set_block('content', 'column_list_row', 'list_rows');
+
$t->set_var(array(
'error' => $error ? $error.'<br><br>' : '',
'pass1' => $pass1,
'pass2' => $pass2
));
-
+
+ $my_fields = $auth->auth['db_fields'] ? $auth->auth['db_fields'] :
+ $default_db_fields;
+ foreach ($all_db_fields as $field => $title) {
+ $t->set_var(array(
+ 'column_name' => $field,
+ 'column_title' => $title,
+ 'checked' => $my_fields[$field] ? 'checked' : ''
+ ));
+ $t->parse('list_rows', 'column_list_row', true);
+ }
}
$t->set_file('wrap', 'wrap.html');
@@ -71,6 +83,7 @@
case 'changepassword' : change_password($_gv['pass1'], $_gv['pass2']); break;
case 'changecolumnlist' : change_bug_list_columns($_gv['column_list']); break;
default : show_preferences_form();
+}
else show_preferences_form();
$t->pparse('main', array('content', 'wrap', 'main'));
|
|
From: Benjamin C. <bc...@us...> - 2001-08-20 23:16:53
|
Update of /cvsroot/phpbt/phpbt/templates/default
In directory usw-pr-cvs1:/tmp/cvs-serv19463/templates/default
Modified Files:
user.html
Log Message:
Getting closer on theuser bug list column preferences
Index: user.html
===================================================================
RCS file: /cvsroot/phpbt/phpbt/templates/default/user.html,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- user.html 2001/08/20 22:55:46 1.1
+++ user.html 2001/08/20 23:16:50 1.2
@@ -28,3 +28,28 @@
</tr>
</table>
</form>
+<form action="{me}" method="post">
+<input type="hidden" name="do" value="changecolumnlist">
+ <table border="0" cellpadding="0" cellspacing="0" width="600">
+ <tr>
+ <td width="600"><b>Bug List Columns</b></td>
+ </tr>
+ <tr>
+ <td width="600">Choose the fields you want to see in the bug list</td>
+ </tr>
+ <!-- BEGIN column_list_row -->
+ <tr>
+ <td>
+ <input type="checkbox" name="column_list[]" value="{column_name}" {checked}>
+ {column_title}
+ </td>
+ </tr>
+ <!-- END column_list_row -->
+ <tr>
+ <td>
+ <input type="reset">
+ <input type="submit" value="Submit">
+ </td>
+ </tr>
+ </table>
+</form>
|
|
From: Benjamin C. <bc...@us...> - 2001-08-20 22:56:35
|
Update of /cvsroot/phpbt/phpbt
In directory usw-pr-cvs1:/tmp/cvs-serv15399
Modified Files:
user.php
Log Message:
Starting to add the bug list column preferences
Index: user.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/user.php,v
retrieving revision 1.8
retrieving revision 1.9
diff -u -r1.8 -r1.9
--- user.php 2001/08/17 02:41:16 1.8
+++ user.php 2001/08/20 22:56:30 1.9
@@ -23,6 +23,14 @@
include 'include.php';
+function change_bug_list_columns($column_list) {
+ global $q, $u, $t;
+
+ $column_list = serialize($column_list);
+ $q->query("update user set bug_list_fields = '$column_list' where user_id = $u");
+ $t->set_file('content', 'columnlistchanged.html');
+}
+
function change_password($pass1, $pass2) {
global $t, $q, $u, $STRING;
@@ -44,22 +52,26 @@
$t->set_file('content', 'passwordchanged.html');
}
-function show_password_form($error = '') {
+function show_preferences_form($error = '') {
global $t, $pass1, $pass2;
- $t->set_file('content', 'passwordform.html');
+ $t->set_file('content', 'user.html');
$t->set_var(array(
'error' => $error ? $error.'<br><br>' : '',
'pass1' => $pass1,
'pass2' => $pass2
));
+
}
$t->set_file('wrap', 'wrap.html');
$perm->check('User');
-if ($do) change_password($pass1, $pass2);
-else show_password_form();
+if ($do) switch ($op) {
+ case 'changepassword' : change_password($_gv['pass1'], $_gv['pass2']); break;
+ case 'changecolumnlist' : change_bug_list_columns($_gv['column_list']); break;
+ default : show_preferences_form();
+else show_preferences_form();
$t->pparse('main', array('content', 'wrap', 'main'));
|
|
From: Benjamin C. <bc...@us...> - 2001-08-20 22:55:50
|
Update of /cvsroot/phpbt/phpbt/templates/default
In directory usw-pr-cvs1:/tmp/cvs-serv15260
Added Files:
user.html
Removed Files:
passwordform.html
Log Message:
A little more generic user prefs page
--- NEW FILE: user.html ---
<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>
</form>
--- passwordform.html DELETED ---
|
|
From: Benjamin C. <bc...@us...> - 2001-08-20 22:33:32
|
Update of /cvsroot/phpbt/phpbt In directory usw-pr-cvs1:/tmp/cvs-serv9969 Modified Files: dbchanges.sql Log Message: Added a field to the user table for storing the columns to show in the bug list Index: dbchanges.sql =================================================================== RCS file: /cvsroot/phpbt/phpbt/dbchanges.sql,v retrieving revision 1.6 retrieving revision 1.7 diff -u -r1.6 -r1.7 --- dbchanges.sql 2001/08/19 03:30:56 1.6 +++ dbchanges.sql 2001/08/20 22:33:28 1.7 @@ -143,13 +143,14 @@ `email` char(60) NOT NULL default '', `password` char(40) NOT NULL default '', `user_level` 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`) ); -insert into user select UserID, FirstName, LastName, Email, Password, UserLevel, 0, CreatedDate, 0, CreatedDate from User; +insert into user select UserID, FirstName, LastName, Email, Password, UserLevel, '', 0, CreatedDate, 0, CreatedDate from User; CREATE TABLE `version` ( `version_id` int(10) unsigned NOT NULL default '0', |
|
From: Benjamin C. <bc...@us...> - 2001-08-20 22:30:43
|
Update of /cvsroot/phpbt/phpbt/templates/default
In directory usw-pr-cvs1:/tmp/cvs-serv9472/templates/default
Modified Files:
buglist.html
Log Message:
Play nice with Netscape 4.x
Index: buglist.html
===================================================================
RCS file: /cvsroot/phpbt/phpbt/templates/default/buglist.html,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -r1.3 -r1.4
--- buglist.html 2001/08/19 03:35:07 1.3
+++ buglist.html 2001/08/20 22:30:39 1.4
@@ -7,7 +7,7 @@
<!-- BEGIN row -->
<tr {tr-extra}>
<!-- BEGIN col -->
- <td class="{colclass}" bgcolor="{bgcolor}">
+ <td {td-extra}>
{coldata}
</td>
<!-- END col -->
|
|
From: Benjamin C. <bc...@us...> - 2001-08-20 22:30:43
|
Update of /cvsroot/phpbt/phpbt
In directory usw-pr-cvs1:/tmp/cvs-serv9472
Modified Files:
query.php
Log Message:
Play nice with Netscape 4.x
Index: query.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/query.php,v
retrieving revision 1.18
retrieving revision 1.19
diff -u -r1.18 -r1.19
--- query.php 2001/08/19 03:35:07 1.18
+++ query.php 2001/08/20 22:30:39 1.19
@@ -250,8 +250,7 @@
foreach ($mydbfields as $field => $title) {
$t->set_var(array(
'coldata' => "<a href='{{$field}url}'>$title</a>",
- 'colclass' => 'header-col',
- 'bgcolor' => "{{$field}color}"
+ 'td-extra' => "class=\"header-col\" bgcolor=\"{{$field}color}\""
));
$t->parse('cols', 'col', true);
}
@@ -267,37 +266,36 @@
switch ($field) {
case 'url' :
$coldata = "<a href='{$row[$field]}'>{$row[$field]}</a>";
- $colclass = '';
+ $td_extra = '';
break;
case 'created_date' :
case 'last_modified_date' :
case 'close_date' :
$coldata = date(DATEFORMAT, $row[$field]);
- $colclass = 'center-col';
+ $td_extra = 'class="center-col"';
break;
case 'bug_id' :
case 'title' :
$coldata = "<a href='bug.php?op=show&bugid={$row['bug_id']}'>{$row[$field]}</a>";
- $colclass = '';
+ $td_extra = '';
break;
case 'reporter' :
case 'owner' :
$coldata = maskemail($row[$field]);
- $colclass = 'center-col';
+ $td_extra = 'class="center-col"';
break;
case 'priority' :
$coldata = $select['priority'][$row[$field]];
- $colclass = 'center-col';
+ $td_extra = 'class="center-col"';
break;
default :
$coldata = $row[$field];
- $colclass = 'center-col';
+ $td_extra = 'class="center-col"';
break;
}
$t->set_var(array(
'coldata' => " $coldata ",
- 'colclass' => $colclass,
- 'bgcolor' => ''
+ 'td-extra' => $td_extra
));
$t->parse('cols', 'col', true);
}
|
|
From: Benjamin C. <bc...@us...> - 2001-08-19 03:35:09
|
Update of /cvsroot/phpbt/phpbt/templates/default
In directory usw-pr-cvs1:/tmp/cvs-serv4343/templates/default
Modified Files:
buglist.html
Log Message:
Added dynamic columns for bug list -- now just need to make it user-configurable
Index: buglist.html
===================================================================
RCS file: /cvsroot/phpbt/phpbt/templates/default/buglist.html,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -r1.2 -r1.3
--- buglist.html 2001/08/18 21:59:02 1.2
+++ buglist.html 2001/08/19 03:35:07 1.3
@@ -1,37 +1,20 @@
-<!--
-<form method="post" action="{me}?op=add">
-Submit a bug for <select name="project">{project}</select>.
-<input type="submit" name="Submit">
-</form>
--->
+<style>
+.header-col { font-weight: bold; text-align: center; }
+.center-col { text-align: center; }
+</style>
<h2>Bug List</h2>
<table cellpadding="2">
- <tr>
- <th bgcolor="{bugidcolor}"><a href="{bugidurl}">ID</th>
- <th bgcolor="{titlecolor}"><a href="{titleurl}">Title</a></th>
- <th bgcolor="{createdbycolor}"><a href="{createdbyurl}">Reporter</a></th>
- <th bgcolor="{ownercolor}"><a href="{ownerurl}">Assigned To</a></th>
- <th bgcolor="{severitycolor}"><a href="{severityurl}">Severity</a></th>
- <th bgcolor="{prioritycolor}"><a href="{priorityurl}">Priority</a></th>
- <th bgcolor="{createddatecolor}"><a href="{createddateurl}">Date Created</a></th>
- <th bgcolor="{statuscolor}"><a href="{statusurl}">Status</a></th>
- <th bgcolor="{resolutioncolor}"><a href="{resolutionurl}">Resolution</a></th>
- </tr>
<!-- BEGIN row -->
- <tr bgcolor="{bgcolor}" onClick="document.location.href='bug.php?op=show&bugid={bugid}'" onMouseOver="this.style.backgroundColor='#eeeeee'" onMouseOut="this.style.backgroundColor='{bgcolor}'" >
- <td><a href="bug.php?op=show&bugid={bugid}">{bugid}</a></td>
- <td><a href="bug.php?op=show&bugid={bugid}">{title}</a></td>
- <td align="center">{reporter}</td>
- <td align="center"> {owner}</td>
- <td align="center">{severity}</td>
- <td align="center">{priority}</td>
- <td align="center">{createddate}</td>
- <td align="center">{status}</td>
- <td align="center"> {resolution}</td>
+ <tr {tr-extra}>
+ <!-- BEGIN col -->
+ <td class="{colclass}" bgcolor="{bgcolor}">
+ {coldata}
+ </td>
+ <!-- END col -->
</tr>
<!-- END row -->
<tr>
- <td colspan="9" align="center">
+ <td colspan="{numcols}" align="center">
<br>
{first} - {last} of {total}<br>[ {pages} ]<!-- <a href="bugs.php?page=all">Show all</a>-->
<br>
|
|
From: Benjamin C. <bc...@us...> - 2001-08-19 03:35:09
|
Update of /cvsroot/phpbt/phpbt
In directory usw-pr-cvs1:/tmp/cvs-serv4343
Modified Files:
query.php
Log Message:
Added dynamic columns for bug list -- now just need to make it user-configurable
Index: query.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/query.php,v
retrieving revision 1.17
retrieving revision 1.18
diff -u -r1.17 -r1.18
--- query.php 2001/08/18 20:11:52 1.17
+++ query.php 2001/08/19 03:35:07 1.18
@@ -23,6 +23,39 @@
include 'include.php';
+$dbfields = array(
+ 'bug_id' => 'ID',
+ 'title' => 'Title',
+ 'description' => 'Description',
+ 'url' => 'URL',
+ 'severity_name' => 'Severity',
+ 'priority' => 'Priority',
+ 'status_name' => 'Status',
+ 'resolution_name' => 'Resolution',
+ 'assigned_to' => 'Assigned To',
+ 'reporter' => 'Reporter',
+ 'owner' => 'Owner',
+ 'created_date' => 'Created',
+ 'last_modified_by' => 'Last Modified',
+ 'last_modified_date' => 'Last Modified By',
+ 'project_name' => 'Project',
+ 'version_name' => 'Version',
+ 'component_name' => 'Component',
+ 'os_name' => 'OS',
+ 'browser_string' => 'Browser',
+ 'close_date' => 'Closed'
+ );
+$mydbfields = array(
+ 'bug_id' => 'ID',
+ 'title' => 'Title',
+ 'reporter' => 'Reporter',
+ 'owner' => 'Owner',
+ 'severity_name' => 'Severity',
+ 'priority' => 'Priority',
+ 'status_name' => 'Status',
+ 'resolution_name' => 'Resolution'
+ );
+
function delete_saved_query($queryid) {
global $q, $u, $me;
@@ -103,7 +136,7 @@
if ($assignedto || $reportedby) {
$q->query("select status_id from status where status_name ".($open ? '' : 'not ')."in ('Unconfirmed', 'New', 'Assigned', 'Reopened')");
while ($statusid = $q->grab_field()) $status[] = $statusid;
- $query[] = 'status_id in ('.delimit_list(',',$status).')';
+ $query[] = 'bug.status_id in ('.delimit_list(',',$status).')';
if ($assignedto) {
$query[] = "assigned_to = {$auth->auth['uid']}";
} else {
@@ -114,7 +147,7 @@
if ($status) $flags[] = 'bug.status_id in ('.delimit_list(',',$status).')';
if ($resolution) $flags[] = 'bug.resolution_id in ('.delimit_list(',',$resolution).')';
if ($os) $flags[] = 'bug.os_id in ('.delimit_list(',',$os).')';
- if ($priority) $flags[] = 'bug.priority_id in ('.delimit_list(',',$priority).')';
+ if ($priority) $flags[] = 'bug.priority in ('.delimit_list(',',$priority).')';
if ($severity) $flags[] = 'bug.severity_id in ('.delimit_list(',',$severity).')';
if ($flags) $query[] = '('.delimit_list(' or ',$flags).')';
@@ -158,10 +191,11 @@
function list_items($assignedto = 0, $reportedby = 0, $open = 0) {
global $querystring, $me, $q, $t, $selrange, $order, $sort, $query,
- $page, $op, $select, $TITLE, $STRING, $savedqueryname, $u;
+ $page, $op, $select, $TITLE, $STRING, $savedqueryname, $u, $mydbfields;
$t->set_file('content','buglist.html');
$t->set_block('content','row','rows');
+ $t->set_block('row','col','cols');
// Save the query if requested
if ($savedqueryname) {
@@ -183,54 +217,95 @@
'project' => build_select('project'),
'TITLE' => $TITLE['buglist']));
- $q->query("select bug_id, title, reporter.email as reporter, owner.email as owner, severity_name as severity, bug.created_date, status_name as status, priority_id, version_name as version, component_name as component, resolution_name as resolution, severity_color from bug left join resolution using (resolution_id), severity, status, version, component left join user owner on bug.assigned_to = owner.user_id left join user reporter on bug.created_by = reporter.user_id where bug.severity_id = severity.severity_id and bug.status_id = status.status_id and bug.version_id = version.version_id and bug.component_id = component.component_id ". ($querystring != '' ? "and $querystring " : ''). "order by $order $sort limit $llimit, $selrange");
+ $q->query("select bug.*, reporter.email as reporter, owner.email as owner, severity_name, status_name, version_name, component_name, resolution_name, severity_color from bug left join resolution using (resolution_id), severity, status, version, component left join user owner on bug.assigned_to = owner.user_id left join user reporter on bug.created_by = reporter.user_id where bug.severity_id = severity.severity_id and bug.status_id = status.status_id and bug.version_id = version.version_id and bug.component_id = component.component_id ". ($querystring != '' ? "and $querystring " : ''). "order by $order $sort limit $llimit, $selrange");
$headers = array(
- 'bugid' => 'bug_id',
+ 'bug_id' => 'bug_id',
'title' => 'title',
'description' => 'description',
'url' => 'url',
- 'severity' => 'severity.sort_order',
- 'priority' => 'bug.priority_id',
- 'status' => 'status.sort_order',
+ 'severity_name' => 'severity.sort_order',
+ 'priority' => 'bug.priority',
+ 'status_name' => 'status.sort_order',
'owner' => 'owner',
- 'createdby' => 'reporter',
- 'createddate' => 'created_date',
- 'project' => 'project_id',
- 'component' => 'component',
- 'os' => 'os_id',
- 'browserstring' => 'browser_string',
- 'resolution' => 'resolution');
+ 'reporter' => 'reporter',
+ 'created_date' => 'created_date',
+ 'project_name' => 'project_id',
+ 'component_name' => 'component_name',
+ 'os_name' => 'os_id',
+ 'browser_string' => 'browser_string',
+ 'resolution_name' => 'resolution.sort_order',
+ 'close_date' => 'close_date');
sorting_headers($me, $headers, $order, $sort, "page=$page");
if (!$q->num_rows()) {
- $t->set_var('rows',"<tr><td>{$STRING['nobugs']}</td></tr>");
+ $t->set_var(array(
+ 'rows' => "<tr><td>{$STRING['nobugs']}</td></tr>",
+ 'numcols' => "1"));
return;
}
-
- while ($row = $q->grab()) {
+
+ // Header row
+ foreach ($mydbfields as $field => $title) {
$t->set_var(array(
- 'bgcolor' => USE_SEVERITY_COLOR ? $row['severity_color'] :
- ((++$i % 2 == 0) ? '#dddddd' : '#ffffff'),
- 'bugid' => $row['bug_id'],
- 'title' => $row['title'],
- 'description' => $row['description'],
- 'url' => $row['url'],
- 'severity' => $row['severity'],
- 'priority' => $select['priority'][$row['priority_id']],
- 'status' => $row['status'],
- 'assignedto' => $row['assigned_to'],
- 'reporter' => maskemail($row['reporter']),
- 'owner' => maskemail($row['owner']),
- 'createddate' => date(DATEFORMAT,$row['created_date']),
- 'project' => $row['project_id'],
- 'component' => $row['component'],
- 'os' => $row['os_id'],
- 'browserstring' => $row['browser_string'],
- 'resolution' => $row['resolution']));
+ 'coldata' => "<a href='{{$field}url}'>$title</a>",
+ 'colclass' => 'header-col',
+ 'bgcolor' => "{{$field}color}"
+ ));
+ $t->parse('cols', 'col', true);
+ }
+ $t->set_var('tr-extra', '');
+ $t->parse('rows', 'row', true);
+ $t->set_var('cols', '');
+
+ // Data rows
+ while ($row = $q->grab()) {
+ $bgcolor = USE_SEVERITY_COLOR ? $row['severity_color'] :
+ ((++$i % 2 == 0) ? '#dddddd' : '#ffffff');
+ foreach ($mydbfields as $field => $title) {
+ switch ($field) {
+ case 'url' :
+ $coldata = "<a href='{$row[$field]}'>{$row[$field]}</a>";
+ $colclass = '';
+ break;
+ case 'created_date' :
+ case 'last_modified_date' :
+ case 'close_date' :
+ $coldata = date(DATEFORMAT, $row[$field]);
+ $colclass = 'center-col';
+ break;
+ case 'bug_id' :
+ case 'title' :
+ $coldata = "<a href='bug.php?op=show&bugid={$row['bug_id']}'>{$row[$field]}</a>";
+ $colclass = '';
+ break;
+ case 'reporter' :
+ case 'owner' :
+ $coldata = maskemail($row[$field]);
+ $colclass = 'center-col';
+ break;
+ case 'priority' :
+ $coldata = $select['priority'][$row[$field]];
+ $colclass = 'center-col';
+ break;
+ default :
+ $coldata = $row[$field];
+ $colclass = 'center-col';
+ break;
+ }
+ $t->set_var(array(
+ 'coldata' => " $coldata ",
+ 'colclass' => $colclass,
+ 'bgcolor' => ''
+ ));
+ $t->parse('cols', 'col', true);
+ }
+ $t->set_var('tr-extra', "bgcolor='$bgcolor' onClick=\"document.location.href='bug.php?op=show&bugid={$row['bug_id']}'\" onMouseOver=\"this.style.backgroundColor='#eeeeee'\" onMouseOut=\"this.style.backgroundColor='$bgcolor'\"");
$t->parse('rows','row',true);
+ $t->set_var('cols', '');
}
+ $t->set_var('numcols', count($mydbfields));
}
$t->set_file('wrap','wrap.html');
|
|
From: Benjamin C. <bc...@us...> - 2001-08-19 03:31:00
|
Update of /cvsroot/phpbt/phpbt In directory usw-pr-cvs1:/tmp/cvs-serv3763 Modified Files: dbchanges.sql Log Message: Added some default severity colors and reverted a case of db conversion zealousness Index: dbchanges.sql =================================================================== RCS file: /cvsroot/phpbt/phpbt/dbchanges.sql,v retrieving revision 1.5 retrieving revision 1.6 diff -u -r1.5 -r1.6 --- dbchanges.sql 2001/08/18 03:20:40 1.5 +++ dbchanges.sql 2001/08/19 03:30:56 1.6 @@ -17,7 +17,7 @@ `bug_desc` text NOT NULL, `bug_url` varchar(255) NOT NULL default '', `severity_id` tinyint(3) unsigned NOT NULL default '0', - `priority_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', @@ -119,6 +119,13 @@ 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'; CREATE TABLE `status` ( `status_id` int(10) unsigned NOT NULL default '0', |
|
From: Benjamin C. <bc...@us...> - 2001-08-19 03:28:35
|
Update of /cvsroot/phpbt/phpbt
In directory usw-pr-cvs1:/tmp/cvs-serv3389
Modified Files:
bug.php
Log Message:
Fixing some of the recent breakings -- work in progress
Index: bug.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/bug.php,v
retrieving revision 1.27
retrieving revision 1.28
diff -u -r1.27 -r1.28
--- bug.php 2001/08/18 14:14:37 1.27
+++ bug.php 2001/08/19 03:28:31 1.28
@@ -103,13 +103,13 @@
// If there are new comments grab the comments immediately before the latest
if ($comments) {
- $q->query("select u.email, c.text, c.created_date from comment c, user u where bug_id = {$buginfo['bug_id']} and c.created_by = u.user_id order by created_date desc limit 2");
+ $q->query("select u.email, c.comment_text, c.created_date from comment c, user u where bug_id = {$buginfo['bug_id']} and c.created_by = u.user_id order by created_date desc limit 2");
$row = $q->grab();
$t->set_var(array(
'newpostedby' => $row['email'],
'newpostedon' => date(TIMEFORMAT, $row['created_date']).' on '.
date(DATEFORMAT, $row['created_date']),
- 'newcomments' => textwrap('+ '.stripslashes($row['text']),72,"\n+ ")
+ 'newcomments' => textwrap('+ '.stripslashes($row['comment_text']),72,"\n+ ")
));
// If this comment is the first additional comment after the creation of the
// bug then we need to grab the bug's description as the previous comment
@@ -126,7 +126,7 @@
'oldpostedby' => $row['email'],
'oldpostedon' => date(TIMEFORMAT,$row['created_date']).' on '.
date(DATEFORMAT,$row['created_date']),
- 'oldcomments' => textwrap(stripslashes($row['text']),72)
+ 'oldcomments' => textwrap(stripslashes($row['comment_text']),72)
));
}
$t->parse('cblock', 'commentblock', true);
@@ -146,8 +146,8 @@
$t->set_var(array(
'bugid' => $buginfo['bug_id'],
'url' => INSTALLURL."/bug.php?op=show&bugid={$buginfo['bug_id']}",
- 'Priority' => $select['priority_id'][($cf['priority_id'] ? $cf['priority_id'] : $buginfo['priority_id'])],
- 'PriorityStat' => $cf['priority_id'] ? '!' : ' ',
+ 'Priority' => $select['priority'][($cf['priority'] ? $cf['priority'] : $buginfo['priority'])],
+ 'PriorityStat' => $cf['priority'] ? '!' : ' ',
'Reporter' => $reporter,
'ReporterStat' => $reporterstat,
'AssignedTo' => $assignedto,
@@ -220,8 +220,8 @@
show_bug($bugid,array('status' => $STRING['nobug']));
return;
}
- $q->query("insert into comment (comment_id, bug_id, text, created_by, created_date) values (".$q->nextid('comment').", $dupenum, 'Bug #$bugid is a duplicate of this bug', $u, $now)");
- $q->query("insert into comment (comment_id, bug_id, text, created_by, created_date) values (".$q->nextid('comment').", $bugid, 'This bug is a duplicate of bug #$dupenum', $u, $now)");
+ $q->query("insert into comment (comment_id, bug_id, comment_text, created_by, created_date) values (".$q->nextid('comment').", $dupenum, 'Bug #$bugid is a duplicate of this bug', $u, $now)");
+ $q->query("insert into comment (comment_id, bug_id, comment_text, created_by, created_date) values (".$q->nextid('comment').", $bugid, 'This bug is a duplicate of bug #$dupenum', $u, $now)");
$statusfield = 'Duplicate';
$bugresolution = $q->grab_field("select resolution_id from resolution where resolution_name = 'Duplicate'");
$statusfield = 'Resolved';
@@ -249,10 +249,10 @@
if ($comments) {
$comments = htmlspecialchars($comments);
- $q->query("insert into comment (comment_id, bug_id, text, created_by, created_date) values (".$q->nextid('comment').", $bugid, '$comments', $u, $now)");
+ $q->query("insert into comment (comment_id, bug_id, comment_text, created_by, created_date) values (".$q->nextid('comment').", $bugid, '$comments', $u, $now)");
}
- $q->query("update bug set title = '$title', url = '$url', severity_id = $severity, priority_id = $priority, ".($status ? "status_id = $status, " : ''). ($changeresolution ? "resolution_id = $bugresolution, " : ''). ($assignedto ? "assigned_to = $assignedto, " : '')." project_id = $project, version_id = $version, component_id = $component, os_id = $os, last_modified_by = $u, last_modified_date = $now where bug_id = $bugid");
+ $q->query("update bug set title = '$title', url = '$url', severity_id = $severity, priority = $priority, ".($status ? "status_id = $status, " : ''). ($changeresolution ? "resolution_id = $bugresolution, " : ''). ($assignedto ? "assigned_to = $assignedto, " : '')." project_id = $project, version_id = $version, component_id = $component, os_id = $os, last_modified_by = $u, last_modified_date = $now where bug_id = $bugid");
if ($changedfields or $comments) {
do_changedfields($u, $buginfo, $changedfields, $comments);
@@ -277,9 +277,9 @@
$time = time();
if (!$bugid) {
$status = $q->grab_field("select status_id from status where status_name = 'Unconfirmed'");
- $q->query("insert into bug (bug_id, title, description, url, severity_id, priority_id, status_id, created_by, created_date, last_modified_by, last_modified_date, project_id, version_id, component_id, os_id, browser_string) values (".$q->nextid('bug').", '$title', '$description', '$url', $severity, $priority, $status, $u, $time, $u, $time, $project, $version, $component, '$os', '{$GLOBALS['HTTP_USER_AGENT']}')");
+ $q->query("insert into bug (bug_id, title, description, url, severity_id, priority, status_id, created_by, created_date, last_modified_by, last_modified_date, project_id, version_id, component_id, os_id, browser_string) values (".$q->nextid('bug').", '$title', '$description', '$url', $severity, $priority, $status, $u, $time, $u, $time, $project, $version, $component, '$os', '{$GLOBALS['HTTP_USER_AGENT']}')");
} else {
- $q->query("update bug set title = '$title', description = '$description', url = '$url', severity_id = '$severity', priority_id = '$priority', status_id = $status, assigned_to = '$assignedto', project_id = $project, version_id = $version, component_id = $component, os_id = '$os', browser_string = '{$GLOBALS['HTTP_USER_AGENT']}' last_modified_by = $u, last_modified_date = $time where bug_id = '$bugid'");
+ $q->query("update bug set title = '$title', description = '$description', url = '$url', severity_id = '$severity', priority = '$priority', status_id = $status, assigned_to = '$assignedto', project_id = $project, version_id = $version, component_id = $component, os_id = '$os', browser_string = '{$GLOBALS['HTTP_USER_AGENT']}' last_modified_by = $u, last_modified_date = $time where bug_id = '$bugid'");
}
if ($another) header("Location: $me?op=add&project=$project");
else header("Location: query.php");
@@ -303,7 +303,7 @@
'url' => $row['URL'],
'urllabel' => $row['url'] ? "<a href='{$row['url']}'>URL</a>" : 'URL',
'severity' => build_select('severity',$row['severity_id']),
- 'priority' => build_select('priority',$row['priority_id']),
+ 'priority' => build_select('priority',$row['priority']),
'status' => build_select('status',$row['status_id']),
'resolution' => build_select('resolution',$row['resolution_id']),
'assignedto' => $row['assigned_to'],
@@ -344,7 +344,7 @@
function show_bug($bugid = 0, $error = '') {
global $q, $me, $t, $project, $STRING, $u, $perm;
- if (!ereg('^[0-9]+$',$bugid) or !$row = $q->grab("select bug_id, title, reporter.email as reporter, owner.email as owner, b.project_id, b.version_id, b.severity_id, b.created_date, b.last_modified_date, status_name as status, b.priority_id, b.description, resolution_name as resolution, url, b.component_id, b.os_id from bug b, severity sv, status st left join user owner on b.assigned_to = owner.user_id left join user reporter on b.created_by = reporter.user_id, resolution r where b.resolution_id = r.resolution_id where bug_id = '$bugid' and b.severity_id = sv.severity_id and b.status_id = st.status_id")) {
+ if (!ereg('^[0-9]+$',$bugid) or !$row = $q->grab("select bug_id, title, reporter.email as reporter, owner.email as owner, b.project_id, b.version_id, b.severity_id, b.created_date, b.last_modified_date, status_name as status, b.priority, b.description, resolution_name as resolution, url, b.component_id, b.os_id from bug b left join resolution r using(resolution_id), severity sv, status st left join user owner on b.assigned_to = owner.user_id left join user reporter on b.created_by = reporter.user_id where bug_id = '$bugid' and b.severity_id = sv.severity_id and b.status_id = st.status_id")) {
show_text($STRING['bugbadnum'],true);
return;
}
@@ -366,7 +366,7 @@
'url' => $row['url'],
'urllabel' => $row['url'] ? "<a href='{$row['url']}'>URL</a>" : 'URL',
'severity' => build_select('severity',$row['severity_id']),
- 'priority' => build_select('priority',$row['priority_id']),
+ 'priority' => build_select('priority',$row['priority']),
'status' => $row['status_id'],
'resolution' => $row['resolution_id'],
'owner' => maskemail($row['owner']),
@@ -443,7 +443,7 @@
}
}
- $q->query("select text, comment.created_date, email from comment, user where bug_id = $bugid and created_by = user_id order by comment.created_date");
+ $q->query("select comment_text, comment.created_date, email from comment, user where bug_id = $bugid and comment.created_by = user_id order by comment.created_date");
if (!$q->num_rows()) {
$t->set_var('rows','');
} else {
@@ -451,7 +451,7 @@
$t->set_var(array(
'bgcolor' => (++$i % 2 == 0) ? '#dddddd' : '#ffffff',
'rdescription' => eregi_replace('(bug)[[:space:]]*(#?)([0-9]+)',
- "\\1 <a href='$me?op=show&bugid=\\3'>\\2\\3</a>",nl2br($row['text'])),
+ "\\1 <a href='$me?op=show&bugid=\\3'>\\2\\3</a>",nl2br($row['comment_text'])),
'rreporter' => maskemail($row['email']),
'rcreateddate' => date(TIMEFORMAT,$row['created_date']).' on '.
date(DATEFORMAT,$row['created_date'])
|
|
From: Benjamin C. <bc...@us...> - 2001-08-18 21:59:05
|
Update of /cvsroot/phpbt/phpbt/templates/default
In directory usw-pr-cvs1:/tmp/cvs-serv24222/templates/default
Modified Files:
buglist.html
Log Message:
javascript fun
Index: buglist.html
===================================================================
RCS file: /cvsroot/phpbt/phpbt/templates/default/buglist.html,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- buglist.html 2001/08/01 13:55:56 1.1
+++ buglist.html 2001/08/18 21:59:02 1.2
@@ -18,7 +18,7 @@
<th bgcolor="{resolutioncolor}"><a href="{resolutionurl}">Resolution</a></th>
</tr>
<!-- BEGIN row -->
- <tr bgcolor="{bgcolor}">
+ <tr bgcolor="{bgcolor}" onClick="document.location.href='bug.php?op=show&bugid={bugid}'" onMouseOver="this.style.backgroundColor='#eeeeee'" onMouseOut="this.style.backgroundColor='{bgcolor}'" >
<td><a href="bug.php?op=show&bugid={bugid}">{bugid}</a></td>
<td><a href="bug.php?op=show&bugid={bugid}">{title}</a></td>
<td align="center">{reporter}</td>
|
|
From: Benjamin C. <bc...@us...> - 2001-08-18 20:12:42
|
Update of /cvsroot/phpbt/phpbt/admin
In directory usw-pr-cvs1:/tmp/cvs-serv5261/admin
Modified Files:
severity.php
Log Message:
A little bit of clean-up
Index: severity.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/admin/severity.php,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- severity.php 2001/08/17 14:54:16 1.1
+++ severity.php 2001/08/18 20:12:39 1.2
@@ -1,6 +1,6 @@
<?php
-// status.php - Interface to the Status table
+// severity.php - Interface to the severity table
// ------------------------------------------------------------------------
// Copyright (c) 2001 The phpBugTracker Group
// ------------------------------------------------------------------------
@@ -24,7 +24,7 @@
include '../include.php';
function do_form($severityid = 0) {
- global $q, $me, $fname, $fdescription, $fsortorder,$fcolor, $STRING;
+ global $q, $me, $fname, $fdescription, $fsortorder, $fcolor, $STRING;
// Validation
if (!$fname = trim($fname))
@@ -34,9 +34,9 @@
if ($error) { list_items($severityid, $error); return; }
if (!$severityid) {
- $q->query("insert into severity (severity_id, severity_name, severity_desc, sort_order, severity_color) values (".$q->nextid('severity').", '$fname', '$fdescription', '$fsortorder','$fcolor')");
+ $q->query("insert into severity (severity_id, severity_name, severity_desc, sort_order, severity_color) values (".$q->nextid('severity').", '$fname', '$fdescription', '$fsortorder', '$fcolor')");
} else {
- $q->query("update severity set severity_name = '$fname', severity_desc = '$fdescription', sort_order = '$fsortorder', severity_color = '$fcolor' where severity_id = '$severityid'");
+ $q->query("update severity set severity_name = '$fname', severity_desc = '$fdescription', sort_order = '$fsortorder', severity_color = '$fcolor' where severity_id = '$severityid'");
}
header("Location: $me?");
}
@@ -66,7 +66,7 @@
}
-function list_items($statusid = 0, $error = '') {
+function list_items($severityid = 0, $error = '') {
global $q, $t, $selrange, $order, $sort, $STRING, $TITLE;
$t->set_file('content','severitylist.html');
@@ -87,7 +87,7 @@
$q->query("select * from severity order by $order $sort limit $llimit, $selrange");
if (!$q->num_rows()) {
- $t->set_var('rows',"<tr><td>{$STRING['nostatuses']}</td></tr>");
+ $t->set_var('rows',"<tr><td>{$STRING['noseverities']}</td></tr>");
return;
}
@@ -102,16 +102,15 @@
while ($row = $q->grab()) {
$t->set_var(array(
- 'bgcolor' => (++$i % 2 == 0) ? '#dddddd' : '#ffffff',
+ 'bgcolor' => $row['severity_color'],
'severityid' => $row['severity_id'],
'name' => $row['severity_name'],
'description' => $row['severity_desc'],
- 'sortorder' => $row['sort_order'],
- 'color' => $row['severity_color']));
+ 'sortorder' => $row['sort_order']));
$t->parse('rows','row',true);
}
- show_form($statusid, $error);
+ show_form($severityid, $error);
$t->set_var('TITLE',$TITLE['severity']);
}
@@ -130,4 +129,4 @@
page_close();
-?>
\ No newline at end of file
+?>
|
|
From: Benjamin C. <bc...@us...> - 2001-08-18 20:12:25
|
Update of /cvsroot/phpbt/phpbt/admin/templates/default
In directory usw-pr-cvs1:/tmp/cvs-serv5221/admin/templates/default
Added Files:
severitylist.html
Log Message:
--- NEW FILE: severitylist.html ---
<br>
<table border="0" width="640">
<tr>
<td valign="top">
<b> Status List</b>
<hr size="1">
<table border="0">
<tr bgcolor="#eeeeee">
<th><a href="{nameurl}">Name</a></th>
<th><a href="{descriptionurl}">Description</a></th>
<th><a href="{sortorderurl}">Sort Order</a></th>
</tr>
<!-- BEGIN row -->
<tr bgcolor="{bgcolor}">
<td><a href="{me}?op=edit&id={severityid}">{name}</a></td>
<td> {description}</td>
<td align="center">{sortorder}</td>
</tr>
<!-- END row -->
</table>
</td>
<td valign="top">
<div align="right"><b>{action} severity </b></div>
<hr size="1">
<form action="{me}" method="post">
<input type="hidden" name="id" value="{fseverityid}">
<table border='0'>
<tr>
<td colspan="2" align="center" valign="top">
<font color="#ff0000">{error}</font>
</td>
</tr>
<tr>
<td align="right" valign="top">Name:</td>
<td><input type="text" size="20" maxlength="40" name="fname" value="{fname}"></td>
</tr>
<tr>
<td align="right" valign="top">Description:</td>
<td><textarea name="fdescription" cols=20 rows=5 wrap=virtual>{fdescription}</textarea></td>
</tr>
<tr>
<td align="right" valign="top">Sort Order:</td>
<td><input type="text" size="3" maxlength="3" name="fsortorder" value="{fsortorder}"></td>
</tr>
<tr>
<td align="right" valign="top">Row Color:</td>
<td><input type="text" size="11" maxlength="10" name="fcolor" value="{fcolor}"></td>
</tr>
</table>
<div align="right">
<input type='submit' name='submit' value='Submit'>
</div>
</form>
</td>
</table>
|
|
From: Benjamin C. <bc...@us...> - 2001-08-18 20:11:56
|
Update of /cvsroot/phpbt/phpbt
In directory usw-pr-cvs1:/tmp/cvs-serv5130
Modified Files:
include.php query.php
Log Message:
Changes needed for coloring rows in the query output by severity
Index: include.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/include.php,v
retrieving revision 1.31
retrieving revision 1.32
diff -u -r1.31 -r1.32
--- include.php 2001/08/18 14:14:58 1.31
+++ include.php 2001/08/18 20:11:52 1.32
@@ -35,6 +35,8 @@
define ('JPGRAPH_PATH', '/home/bcurtis/public_html/jp/'); // If it's not in the include path
define ('MASK_EMAIL', 1); // Should email addresses be plainly visible?
define ('HIDE_EMAIL', 1); // Should email addresses be hidden for those not logged in?
+// Should the query list use the severity colors as the row background color (like SourceForge)
+define ('USE_SEVERITY_COLOR', 1);
// Sub-dir of the INSTALLPATH - Needs to be writeable by the web process
define ('ATTACHMENT_PATH', 'attachments');
// Maximum size (in bytes) of an attachment
Index: query.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/query.php,v
retrieving revision 1.16
retrieving revision 1.17
diff -u -r1.16 -r1.17
--- query.php 2001/08/17 04:06:06 1.16
+++ query.php 2001/08/18 20:11:52 1.17
@@ -183,7 +183,7 @@
'project' => build_select('project'),
'TITLE' => $TITLE['buglist']));
- $q->query("select bug_id, title, reporter.email as reporter, owner.email as owner, severity_name as severity, bug.created_date, status_name as status, priority_id, version_name as version, component_name as component, resolution_name as resolution from bug, resolution, severity, status, version, component left join user owner on bug.assigned_to = owner.user_id left join user reporter on bug.created_by = reporter.user_id where bug.resolution_id = resolution.resolution_id and bug.severity_id = severity.severity_id and bug.status_id = status.status_id and bug.version_id = version.version_id and bug.component_id = component.component_id ". ($querystring != '' ? "and $querystring " : ''). "order by $order $sort limit $llimit, $selrange");
+ $q->query("select bug_id, title, reporter.email as reporter, owner.email as owner, severity_name as severity, bug.created_date, status_name as status, priority_id, version_name as version, component_name as component, resolution_name as resolution, severity_color from bug left join resolution using (resolution_id), severity, status, version, component left join user owner on bug.assigned_to = owner.user_id left join user reporter on bug.created_by = reporter.user_id where bug.severity_id = severity.severity_id and bug.status_id = status.status_id and bug.version_id = version.version_id and bug.component_id = component.component_id ". ($querystring != '' ? "and $querystring " : ''). "order by $order $sort limit $llimit, $selrange");
$headers = array(
'bugid' => 'bug_id',
@@ -211,7 +211,8 @@
while ($row = $q->grab()) {
$t->set_var(array(
- 'bgcolor' => (++$i % 2 == 0) ? '#dddddd' : '#ffffff',
+ 'bgcolor' => USE_SEVERITY_COLOR ? $row['severity_color'] :
+ ((++$i % 2 == 0) ? '#dddddd' : '#ffffff'),
'bugid' => $row['bug_id'],
'title' => $row['title'],
'description' => $row['description'],
|
|
From: Benjamin C. <bc...@us...> - 2001-08-18 15:04:12
|
Update of /cvsroot/phpbt/phpbt/languages In directory usw-pr-cvs1:/tmp/cvs-serv18089 Modified Files: de.php en.php pt-br.php se.php Log Message: Added title Severity Index: de.php =================================================================== RCS file: /cvsroot/phpbt/phpbt/languages/de.php,v retrieving revision 1.2 retrieving revision 1.3 diff -u -r1.2 -r1.3 --- de.php 2001/08/18 14:58:08 1.2 +++ de.php 2001/08/18 15:04:10 1.3 @@ -85,6 +85,7 @@ 'os' => 'Betriebssysteme', 'resolution' => 'Auflösungen', 'status' => 'Stati', + 'severity' => 'Severity', 'user' => 'Benutzer', 'home' => 'Home', 'reporting' => 'Bericht' Index: en.php =================================================================== RCS file: /cvsroot/phpbt/phpbt/languages/en.php,v retrieving revision 1.2 retrieving revision 1.3 diff -u -r1.2 -r1.3 --- en.php 2001/08/18 14:58:08 1.2 +++ en.php 2001/08/18 15:04:10 1.3 @@ -79,6 +79,7 @@ 'os' => 'Operating Systems', 'resolution' => 'Resolutions', 'status' => 'Statuses', + 'severity' => 'Severity', 'user' => 'Users', 'home' => 'Home', 'reporting' => 'Reporting' Index: pt-br.php =================================================================== RCS file: /cvsroot/phpbt/phpbt/languages/pt-br.php,v retrieving revision 1.2 retrieving revision 1.3 diff -u -r1.2 -r1.3 --- pt-br.php 2001/08/18 14:58:08 1.2 +++ pt-br.php 2001/08/18 15:04:10 1.3 @@ -80,6 +80,7 @@ 'os' => 'Sistemas Operacionais', 'resolution' => 'Normas', 'status' => 'Status', + 'severity' => 'Severity', 'user' => 'Usuários', 'home' => 'Home', 'reporting' => 'Relatórios' Index: se.php =================================================================== RCS file: /cvsroot/phpbt/phpbt/languages/se.php,v retrieving revision 1.2 retrieving revision 1.3 diff -u -r1.2 -r1.3 --- se.php 2001/08/18 14:58:08 1.2 +++ se.php 2001/08/18 15:04:10 1.3 @@ -80,6 +80,7 @@ 'os' => 'Operativsystem', 'resolution' => 'Uppföljning', 'status' => 'Status', + 'severity' => 'Severity', 'user' => 'Användare', 'home' => 'Hem', 'reporting' => 'Rapportering' |
|
From: Benjamin C. <bc...@us...> - 2001-08-18 14:58:11
|
Update of /cvsroot/phpbt/phpbt/languages In directory usw-pr-cvs1:/tmp/cvs-serv16787 Modified Files: de.php en.php pt-br.php se.php Log Message: Fixed a typo and added line for severities not being found Index: de.php =================================================================== RCS file: /cvsroot/phpbt/phpbt/languages/de.php,v retrieving revision 1.1 retrieving revision 1.2 diff -u -r1.1 -r1.2 --- de.php 2001/08/18 14:09:29 1.1 +++ de.php 2001/08/18 14:58:08 1.2 @@ -1,92 +1,93 @@ -<?php - -// strings-de.php - Deutsche Strings und Titel -// Translation by Stefan Plank -// ------------------------------------------------------------------------ -// Copyright (c) 2001 The phpBugTracker Group -// ------------------------------------------------------------------------ -// Diese Datei ist Teil des phpBugTracker -// -// phpBugTracker ist freie Software; Sie koennen sie weiterverteilen -// und/oder veraendern unter den Bedingungen der GNU General Public License, -// publiziert durch die Free Software Foundation; entweder nach Version 2 -// der Lizenz, oder (ihrer Wahl nach) irgendeiner spaeterern Version. -// -// phpBugTracker wird in der Hoffnung verteilt, dasz es nuetzlich ist, aber -// OHNE JEDE GARANTIE; selbst ohne die eingeschloszene Garantie der -// VERMARKTBARKEIT [MERCHANTIBILITY] oder EIGNUNG FUER -// EINEN PARTIKULAEREN GEBRAUCH. Sie koennen mehr Details in der -// GNU General Public License nachlesen. -// -// Sie sollten mit dem phpBugTracker eine Kopie der -// GNU General Public License bekommen haben; wenn nicht, schreiben Sie der -// Free Software Foundation, Inc., 59 Temple Place - Suite 330, Boston, -// MA 02111-1307, USA. -// ------------------------------------------------------------------------- - - - - -$STRING = array( - 'nouser' => 'Dieser Benutzer extistiert nicht', - 'dupeofself' => 'Ein Bug kann kein Duplikat von sich selbst sein', - 'nobug' => 'Dieser Bug existiert nicht', - 'givesummary' => 'Bitte geben Sie einen Bericht ein', - 'givedesc' => 'Bitte geben Sie eine Beschreibung ein', - 'noprojects' => 'Keine Projekte gefunden', - 'totalbugs' => 'Total Bugs', - 'giveemail' => 'Bitte geben Sie eine gültige E-mail Adresse ein.', - 'loginused' => 'Dieser Benutzername ist schon in Gebrauch', - 'newacctsubject' => 'phpBugTracker Login', - 'newacctmessage' => "Ihr phpBugTracker Passwort ist %s", - 'nobugs' => 'Kein Bug gefunden', - 'givename' => 'Bitte geben Sie einen Namen ein', - 'edit' => 'Bearbeiten', - 'addnew' => 'Neuen hinzufügen', - 'nooses' => 'Keine Betriebsysteme gefunden', - 'giveinitversion' => 'Bitte geben Sie eine Initialversion für das Projekt an', - 'giveversion' => 'Bitte geben Sie eine Version ein', - 'noversions' => 'Keine Version gefunden', - 'nocomponents' => 'Keine Komponenten gefunden', - 'nostatses' => 'Keine Stati gefunden', - 'givepassword' => 'Bitte geben Sie ein Passwort ein!', - 'nousers' => 'Keinen Benutzer gefunden', - 'bugbadperm' => 'Sie können diesen Bug nicht ändern', - 'bugbadnum' => 'Dieser Bug existiert nicht', - 'datecollision' => 'Jemand hat diesen Bug behoben seit Sie ihn gesehen haben. Die Buginformation wurde mit den letzten Änderunen erneut geladen.', - 'passwordmatch' => 'Dieses Passwörter stimmen nicht -- Bitte probieren Sie noch einmal', - 'nobughistory' => 'Es gibt keine History für diesen Bug', - 'logintomodify' => 'Sie müssen eingeloggt sein, um diesen Bug zu ändern.', - 'dupe_attachment' => 'Dieser Anhang existiert bereits für den Bug.', - 'give_attachment' => 'Bitte geben Sie eine Datei für den Upload an.', - 'no_attachment_save_path' => 'Konnte den Pfad zum Speichern nicht finden!', - 'attachment_path_not_writeable' => 'Konnte keine Datei im Speicherpfad erstellen', - 'attachment_move_error' => 'Es gab einen Fehler beim Bewegen der upzuloadenen Datei', - 'bad_attachment' => 'Dieser Dateianhang existiert nicht', - 'attachment_too_large' => 'Die angegebene Datei ist größer als '.number_format(ATTACHMENT_MAX_SIZE).' bytes', - 'bad_permission' => 'Sie haben nicht die erforderlichen Rechte für diese Funktion' - ); - -// Page titles -$TITLE = array( - 'enterbug' => 'Geben Sie einen Fehler ein', - 'editbug' => 'Fehler Bearbeiten', - 'newaccount' => 'Neuen Account anlegen', - 'bugquery' => 'Fehlersuche Bug Query', - 'buglist' => 'Fehlerliste', - 'addcomponent' => 'Komponente hinzufügen', - 'editcomponent' => 'Komponente bearbeiten', - 'addproject' => 'Projekt hinzufügen', - 'editproject' => 'Projekt bearbeiten', - 'addversion' => 'Version hinzufügen', - 'editversion' => 'Version bearbeiten', - 'project' => 'Projekte', - 'os' => 'Betriebssysteme', - 'resolution' => 'Auflösungen', - 'status' => 'Stati', - 'user' => 'Benutzer', - 'home' => 'Home', - 'reporting' => 'Bericht' - ); - -?> \ No newline at end of file +<?php + +// strings-de.php - Deutsche Strings und Titel +// Translation by Stefan Plank +// ------------------------------------------------------------------------ +// Copyright (c) 2001 The phpBugTracker Group +// ------------------------------------------------------------------------ +// Diese Datei ist Teil des phpBugTracker +// +// phpBugTracker ist freie Software; Sie koennen sie weiterverteilen +// und/oder veraendern unter den Bedingungen der GNU General Public License, +// publiziert durch die Free Software Foundation; entweder nach Version 2 +// der Lizenz, oder (ihrer Wahl nach) irgendeiner spaeterern Version. +// +// phpBugTracker wird in der Hoffnung verteilt, dasz es nuetzlich ist, aber +// OHNE JEDE GARANTIE; selbst ohne die eingeschloszene Garantie der +// VERMARKTBARKEIT [MERCHANTIBILITY] oder EIGNUNG FUER +// EINEN PARTIKULAEREN GEBRAUCH. Sie koennen mehr Details in der +// GNU General Public License nachlesen. +// +// Sie sollten mit dem phpBugTracker eine Kopie der +// GNU General Public License bekommen haben; wenn nicht, schreiben Sie der +// Free Software Foundation, Inc., 59 Temple Place - Suite 330, Boston, +// MA 02111-1307, USA. +// ------------------------------------------------------------------------- + + + + +$STRING = array( + 'nouser' => 'Dieser Benutzer extistiert nicht', + 'dupeofself' => 'Ein Bug kann kein Duplikat von sich selbst sein', + 'nobug' => 'Dieser Bug existiert nicht', + 'givesummary' => 'Bitte geben Sie einen Bericht ein', + 'givedesc' => 'Bitte geben Sie eine Beschreibung ein', + 'noprojects' => 'Keine Projekte gefunden', + 'totalbugs' => 'Total Bugs', + 'giveemail' => 'Bitte geben Sie eine gültige E-mail Adresse ein.', + 'loginused' => 'Dieser Benutzername ist schon in Gebrauch', + 'newacctsubject' => 'phpBugTracker Login', + 'newacctmessage' => "Ihr phpBugTracker Passwort ist %s", + 'nobugs' => 'Kein Bug gefunden', + 'givename' => 'Bitte geben Sie einen Namen ein', + 'edit' => 'Bearbeiten', + 'addnew' => 'Neuen hinzufügen', + 'nooses' => 'Keine Betriebsysteme gefunden', + 'giveinitversion' => 'Bitte geben Sie eine Initialversion für das Projekt an', + 'giveversion' => 'Bitte geben Sie eine Version ein', + 'noversions' => 'Keine Version gefunden', + 'nocomponents' => 'Keine Komponenten gefunden', + 'nostatuses' => 'Keine Stati gefunden', + 'noseverities' => 'No severities found', + 'givepassword' => 'Bitte geben Sie ein Passwort ein!', + 'nousers' => 'Keinen Benutzer gefunden', + 'bugbadperm' => 'Sie können diesen Bug nicht ändern', + 'bugbadnum' => 'Dieser Bug existiert nicht', + 'datecollision' => 'Jemand hat diesen Bug behoben seit Sie ihn gesehen haben. Die Buginformation wurde mit den letzten Änderunen erneut geladen.', + 'passwordmatch' => 'Dieses Passwörter stimmen nicht -- Bitte probieren Sie noch einmal', + 'nobughistory' => 'Es gibt keine History für diesen Bug', + 'logintomodify' => 'Sie müssen eingeloggt sein, um diesen Bug zu ändern.', + 'dupe_attachment' => 'Dieser Anhang existiert bereits für den Bug.', + 'give_attachment' => 'Bitte geben Sie eine Datei für den Upload an.', + 'no_attachment_save_path' => 'Konnte den Pfad zum Speichern nicht finden!', + 'attachment_path_not_writeable' => 'Konnte keine Datei im Speicherpfad erstellen', + 'attachment_move_error' => 'Es gab einen Fehler beim Bewegen der upzuloadenen Datei', + 'bad_attachment' => 'Dieser Dateianhang existiert nicht', + 'attachment_too_large' => 'Die angegebene Datei ist größer als '.number_format(ATTACHMENT_MAX_SIZE).' bytes', + 'bad_permission' => 'Sie haben nicht die erforderlichen Rechte für diese Funktion' + ); + +// Page titles +$TITLE = array( + 'enterbug' => 'Geben Sie einen Fehler ein', + 'editbug' => 'Fehler Bearbeiten', + 'newaccount' => 'Neuen Account anlegen', + 'bugquery' => 'Fehlersuche Bug Query', + 'buglist' => 'Fehlerliste', + 'addcomponent' => 'Komponente hinzufügen', + 'editcomponent' => 'Komponente bearbeiten', + 'addproject' => 'Projekt hinzufügen', + 'editproject' => 'Projekt bearbeiten', + 'addversion' => 'Version hinzufügen', + 'editversion' => 'Version bearbeiten', + 'project' => 'Projekte', + 'os' => 'Betriebssysteme', + 'resolution' => 'Auflösungen', + 'status' => 'Stati', + 'user' => 'Benutzer', + 'home' => 'Home', + 'reporting' => 'Bericht' + ); + +?> Index: en.php =================================================================== RCS file: /cvsroot/phpbt/phpbt/languages/en.php,v retrieving revision 1.1 retrieving revision 1.2 diff -u -r1.1 -r1.2 --- en.php 2001/08/18 14:09:29 1.1 +++ en.php 2001/08/18 14:58:08 1.2 @@ -42,7 +42,8 @@ 'giveversion' => 'Please enter a version', 'noversions' => 'No versions found', 'nocomponents' => 'No components found', - 'nostatses' => 'No statuses found', + 'nostatuses' => 'No statuses found', + 'noseverities' => 'No severities found', 'givepassword' => 'Please enter a password', 'nousers' => 'No users found', 'bugbadperm' => 'You cannot change this bug', Index: pt-br.php =================================================================== RCS file: /cvsroot/phpbt/phpbt/languages/pt-br.php,v retrieving revision 1.1 retrieving revision 1.2 diff -u -r1.1 -r1.2 --- pt-br.php 2001/08/18 14:09:29 1.1 +++ pt-br.php 2001/08/18 14:58:08 1.2 @@ -1,87 +1,88 @@ -<?php - -// strings-br.php - Brazilian Portuguese strings and titles -// Translation by Alexandre Ponso -// ------------------------------------------------------------------------ -// 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. -// ------------------------------------------------------------------------ - -$STRING = array( - 'nouser' => 'Este usuário não existe', - 'dupeofself' => 'Um bug não pode ser duplicata de si mesmo', - 'nobug' => 'Este bug não existe', - 'givesummary' => 'Por favor, digite um resumo', - 'givedesc' => 'Por favor, digite uma descrição', - 'noprojects' => 'Nenhum projeto encontrado', - 'totalbugs' => 'Total de Bugs', - 'giveemail' => 'Por favor, digite um endereço de email válido', - 'loginused' => 'Este login já está sendo usado', - 'newacctsubject' => 'phpBugTracker Login', - 'newacctmessage' => "Sua senha phpBugTracker é %s", - 'nobugs' => 'Nenhum bug encontrado', - 'givename' => 'Por favor, digite um nome', - 'edit' => 'Editar', - 'addnew' => 'Adicionar novo', - 'nooses' => 'Nenhum OS encontrado', - 'giveinitversion' => 'Por favor, digite uma versão inicial para o projeto', - 'giveversion' => 'Por favor, digite uma versão', - 'noversions' => 'Nenhuma versão encontrada', - 'nocomponents' => 'Nenhum componente encontrado', - 'nostatses' => 'Nenhum status encontrado', - 'givepassword' => 'Por favor, digite uma senha', - 'nousers' => 'Nenhum usuário encontrado', - 'bugbadperm' => 'Você não pode alterar este bug', - 'bugbadnum' => 'Este bug não existe', - 'datecollision' => 'Alguém já alterou este bug desde que você o viu. A informação sobre o bug foi atualizada com as últimas alterações.', - 'passwordmatch' => 'As senhas não conferem -- por favor, tente novamente', - 'nobughistory' => 'Não há historico para este bug', - 'logintomodify' => 'Você deve estar autenticado para alterar este bug', - 'dupe_attachment' => 'Este anexo já existe para esse bug', - 'give_attachment' => 'Por favor, escolha um arquivo para upload', - 'no_attachment_save_path' => 'Não há diretório de destino!', - 'attachment_path_not_writeable' => 'Não foi possível criar um arquivo no diretório de destino', - 'attachment_move_error' => 'Ocorreu um erro ao mover o arquivo transmitido', - 'bad_attachment' => 'Este anexo não existe', - 'attachment_too_large' => 'O arquivo escolhido é maior que '.number_format(ATTACHMENT_MAX_SIZE).' bytes', - 'bad_permission' => 'Você não tem as permissões necessárias para essa função' - ); - -// Page titles -$TITLE = array( - 'enterbug' => 'Adicionar um Bug', - 'editbug' => 'Editar Bug', - 'newaccount' => 'Criar uma nova conta', - 'bugquery' => 'Pesquisar Bug', - 'buglist' => 'Listar Bug', - 'addcomponent' => 'Adicionar Componente', - 'editcomponent' => 'Editar Componente', - 'addproject' => 'Adicionar Projeto', - 'editproject' => 'Editar Projeto', - 'addversion' => 'Adicionar Versão', - 'editversion' => 'Editar Versão', - 'project' => 'Projeto', - 'os' => 'Sistemas Operacionais', - 'resolution' => 'Normas', - 'status' => 'Status', - 'user' => 'Usuários', - 'home' => 'Home', - 'reporting' => 'Relatórios' - ); - -?> +<?php + +// strings-br.php - Brazilian Portuguese strings and titles +// Translation by Alexandre Ponso +// ------------------------------------------------------------------------ +// 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. +// ------------------------------------------------------------------------ + +$STRING = array( + 'nouser' => 'Este usuário não existe', + 'dupeofself' => 'Um bug não pode ser duplicata de si mesmo', + 'nobug' => 'Este bug não existe', + 'givesummary' => 'Por favor, digite um resumo', + 'givedesc' => 'Por favor, digite uma descrição', + 'noprojects' => 'Nenhum projeto encontrado', + 'totalbugs' => 'Total de Bugs', + 'giveemail' => 'Por favor, digite um endereço de email válido', + 'loginused' => 'Este login já está sendo usado', + 'newacctsubject' => 'phpBugTracker Login', + 'newacctmessage' => "Sua senha phpBugTracker é %s", + 'nobugs' => 'Nenhum bug encontrado', + 'givename' => 'Por favor, digite um nome', + 'edit' => 'Editar', + 'addnew' => 'Adicionar novo', + 'nooses' => 'Nenhum OS encontrado', + 'giveinitversion' => 'Por favor, digite uma versão inicial para o projeto', + 'giveversion' => 'Por favor, digite uma versão', + 'noversions' => 'Nenhuma versão encontrada', + 'nocomponents' => 'Nenhum componente encontrado', + 'nostatuses' => 'Nenhum status encontrado', + 'noseverities' => 'No severities found', + 'givepassword' => 'Por favor, digite uma senha', + 'nousers' => 'Nenhum usuário encontrado', + 'bugbadperm' => 'Você não pode alterar este bug', + 'bugbadnum' => 'Este bug não existe', + 'datecollision' => 'Alguém já alterou este bug desde que você o viu. A informação sobre o bug foi atualizada com as últimas alterações.', + 'passwordmatch' => 'As senhas não conferem -- por favor, tente novamente', + 'nobughistory' => 'Não há historico para este bug', + 'logintomodify' => 'Você deve estar autenticado para alterar este bug', + 'dupe_attachment' => 'Este anexo já existe para esse bug', + 'give_attachment' => 'Por favor, escolha um arquivo para upload', + 'no_attachment_save_path' => 'Não há diretório de destino!', + 'attachment_path_not_writeable' => 'Não foi possível criar um arquivo no diretório de destino', + 'attachment_move_error' => 'Ocorreu um erro ao mover o arquivo transmitido', + 'bad_attachment' => 'Este anexo não existe', + 'attachment_too_large' => 'O arquivo escolhido é maior que '.number_format(ATTACHMENT_MAX_SIZE).' bytes', + 'bad_permission' => 'Você não tem as permissões necessárias para essa função' + ); + +// Page titles +$TITLE = array( + 'enterbug' => 'Adicionar um Bug', + 'editbug' => 'Editar Bug', + 'newaccount' => 'Criar uma nova conta', + 'bugquery' => 'Pesquisar Bug', + 'buglist' => 'Listar Bug', + 'addcomponent' => 'Adicionar Componente', + 'editcomponent' => 'Editar Componente', + 'addproject' => 'Adicionar Projeto', + 'editproject' => 'Editar Projeto', + 'addversion' => 'Adicionar Versão', + 'editversion' => 'Editar Versão', + 'project' => 'Projeto', + 'os' => 'Sistemas Operacionais', + 'resolution' => 'Normas', + 'status' => 'Status', + 'user' => 'Usuários', + 'home' => 'Home', + 'reporting' => 'Relatórios' + ); + +?> Index: se.php =================================================================== RCS file: /cvsroot/phpbt/phpbt/languages/se.php,v retrieving revision 1.1 retrieving revision 1.2 diff -u -r1.1 -r1.2 --- se.php 2001/08/18 14:06:49 1.1 +++ se.php 2001/08/18 14:58:08 1.2 @@ -43,7 +43,8 @@ 'giveversion' => 'Skriv in ett versions-ID', 'noversions' => 'Inga versioner funna', 'nocomponents' => 'Inga komponenter funna', - 'nostatses' => 'Ingen status hittades', + 'nostatuses' => 'Ingen status hittades', + 'noseverities' => 'No severities found', 'givepassword' => 'Var god skriv in ditt lösenord', 'nousers' => 'Inga användare hittades', 'bugbadperm' => 'Du kan inte ändra på den här buggen', |
|
From: Benjamin C. <bc...@us...> - 2001-08-18 14:15:01
|
Update of /cvsroot/phpbt/phpbt
In directory usw-pr-cvs1:/tmp/cvs-serv8815
Modified Files:
include.php
Log Message:
Moving the strings files down to the languages directory
Index: include.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/include.php,v
retrieving revision 1.30
retrieving revision 1.31
diff -u -r1.30 -r1.31
--- include.php 2001/08/17 04:06:06 1.30
+++ include.php 2001/08/18 14:14:58 1.31
@@ -50,7 +50,7 @@
require PHPLIBPATH.'template.inc';
// Localization - include the file with the desired language
-include INSTALLPATH.'/strings-en.php';
+include INSTALLPATH.'/languages/en.php';
// Edit this class with your database information
class dbclass extends DB_Sql {
|
|
From: Benjamin C. <bc...@us...> - 2001-08-18 14:14:40
|
Update of /cvsroot/phpbt/phpbt
In directory usw-pr-cvs1:/tmp/cvs-serv8758
Modified Files:
bug.php
Log Message:
DB conversion
Index: bug.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/bug.php,v
retrieving revision 1.26
retrieving revision 1.27
diff -u -r1.26 -r1.27
--- bug.php 2001/08/11 17:28:43 1.26
+++ bug.php 2001/08/18 14:14:37 1.27
@@ -33,7 +33,7 @@
return;
}
- $q->query("select bh.*, Email from BugHistory bh left join User on CreatedBy = UserID where BugID = $bugid");
+ $q->query("select bh.*, email from bug_history bh left join user on created_by = user_id where bug_id = $bugid");
if (!$q->num_rows()) {
show_text($STRING['nobughistory']);
return;
@@ -45,11 +45,11 @@
while ($row = $q->grab()) {
$t->set_var(array(
'bgcolor' => (++$i % 2 == 0) ? '#dddddd' : '#ffffff',
- 'field' => stripslashes($row['ChangedField']),
- 'oldvalue' => stripslashes($row['OldValue']),
- 'newvalue' => stripslashes($row['NewValue']),
- 'createdby' => stripslashes(maskemail($row['Email'])),
- 'date' => date(DATEFORMAT.' '.TIMEFORMAT, $row['CreatedDate'])
+ 'field' => stripslashes($row['changed_field']),
+ 'oldvalue' => stripslashes($row['old_value']),
+ 'newvalue' => stripslashes($row['new_value']),
+ 'createdby' => stripslashes(maskemail($row['email'])),
+ 'date' => date(DATEFORMAT.' '.TIMEFORMAT, $row['created_date'])
));
$t->parse('rows', 'row', true);
}
@@ -62,9 +62,9 @@
$t->set_file('emailout','bugemail.txt');
$t->set_block('emailout','commentblock', 'cblock');
- foreach(array('Title','URL') as $field) {
+ foreach(array('title','url') as $field) {
if (isset($cf[$field])) {
- $q->query("insert into BugHistory (BugID, ChangedField, OldValue, NewValue, CreatedBy, CreatedDate) values ({$buginfo['BugID']}, '$field', '$buginfo[$field]', '$cf[$field]', $u, $now)");
+ $q->query("insert into bug_history (bug_id, changed_field, old_value, new_value, created_by, created_date) values ({$buginfo['bug_id']}, '$field', '$buginfo[$field]', '$cf[$field]', $u, $now)");
$t->set_var(array(
$field => $cf[$field],
$field.'Stat' => '!'
@@ -77,12 +77,12 @@
}
}
- foreach(array('Project','Component','Status','Resolution','Severity','OS',
- 'Version') as $field) {
- $oldvalue = $q->grab_field("select Name from $field where ${field}ID = $buginfo[$field]");
+ foreach(array('project','component','status','resolution','severity','os',
+ 'version') as $field) {
+ $oldvalue = $q->grab_field("select ${field}_name from $field where ${field}_id = $buginfo[$field]");
if ($cf[$field]) {
- $newvalue = $q->grab_field("select Name from $field where ${field}ID = $cf[$field]");
- $q->query("insert into BugHistory (BugID, ChangedField, OldValue, NewValue, CreatedBy, CreatedDate) values ({$buginfo['BugID']}, '$field', '$oldvalue', '$newvalue', $u, $now)");
+ $newvalue = $q->grab_field("select ${field}_name from $field where ${field}_id = $cf[$field]");
+ $q->query("insert into bug_history (bug_id, changed_field, old_value, new_value, created_by, created_date) values ({$buginfo['bug_id']}, '$field', '$oldvalue', '$newvalue', $u, $now)");
$t->set_var(array(
$field => stripslashes($newvalue),
$field.'Stat' => '!'
@@ -96,26 +96,25 @@
}
// Reporter never changes;
- $reporter = $q->grab_field("select Email from User where UserID =
- {$buginfo['CreatedBy']}");
+ $reporter = $q->grab_field("select email from user where user_id = {$buginfo['created_by']}");
$reporterstat = ' ';
- $assignedto = $q->grab_field("select Email from User where UserID = ". ($cf['AssignedTo'] ? $cf['AssignedTo'] : $buginfo['AssignedTo']));
- $assignedtostat = $cf['AssignedTo'] ? '!' : ' ';
+ $assignedto = $q->grab_field("select email from user where user_id = ". ($cf['assigned_to'] ? $cf['assigned_to'] : $buginfo['assigned_to']));
+ $assignedtostat = $cf['assigned_to'] ? '!' : ' ';
// If there are new comments grab the comments immediately before the latest
if ($comments) {
- $q->query("select u.Email, c.Text, c.CreatedDate from Comment c, User u where BugID = {$buginfo['BugID']} and c.CreatedBy = u.UserID order by CreatedDate desc limit 2");
+ $q->query("select u.email, c.text, c.created_date from comment c, user u where bug_id = {$buginfo['bug_id']} and c.created_by = u.user_id order by created_date desc limit 2");
$row = $q->grab();
$t->set_var(array(
- 'newpostedby' => $row['Email'],
- 'newpostedon' => date(TIMEFORMAT, $row['CreatedDate']).' on '.
- date(DATEFORMAT, $row['CreatedDate']),
- 'newcomments' => textwrap('+ '.stripslashes($row['Text']),72,"\n+ ")
+ 'newpostedby' => $row['email'],
+ 'newpostedon' => date(TIMEFORMAT, $row['created_date']).' on '.
+ date(DATEFORMAT, $row['created_date']),
+ 'newcomments' => textwrap('+ '.stripslashes($row['text']),72,"\n+ ")
));
// If this comment is the first additional comment after the creation of the
// bug then we need to grab the bug's description as the previous comment
if ($q->num_rows() < 2) {
- list($by, $on, $comments) = $q->grab("select u.Email, b.CreatedDate, b.Description from Bug b, User u where b.CreatedBy = u.UserID and BugID = {$buginfo['BugID']}");
+ list($by, $on, $comments) = $q->grab("select u.email, b.created_date, b.description from bug b, user u where b.created_by = u.user_id and bug_id = {$buginfo['bug_id']}");
$t->set_var(array(
'oldpostedby' => $by,
'oldpostedon' => date(TIMEFORMAT,$on).' on '.date(DATEFORMAT,$on),
@@ -124,10 +123,10 @@
} else {
$row = $q->grab();
$t->set_var(array(
- 'oldpostedby' => $row['Email'],
- 'oldpostedon' => date(TIMEFORMAT,$row['CreatedDate']).' on '.
- date(DATEFORMAT,$row['CreatedDate']),
- 'oldcomments' => textwrap(stripslashes($row['Text']),72)
+ 'oldpostedby' => $row['email'],
+ 'oldpostedon' => date(TIMEFORMAT,$row['created_date']).' on '.
+ date(DATEFORMAT,$row['created_date']),
+ 'oldcomments' => textwrap(stripslashes($row['text']),72)
));
}
$t->parse('cblock', 'commentblock', true);
@@ -137,18 +136,18 @@
// Don't email the person who just made the changes (later, make this
// behavior toggable by the user)
- if ($userid != $buginfo['CreatedBy'])
+ if ($userid != $buginfo['created_by'])
$maillist[] = $reporter;
- if ($userid != ($cf['AssignedTo'] ? $cf['AssignedTo'] : $buginfo['AssignedTo']))
+ if ($userid != ($cf['assigned_to'] ? $cf['assigned_to'] : $buginfo['assigned_to']))
$maillist[] = $assignedto;
// Later add a watcher (such as QA person) check here
$toemail = delimit_list(', ',$maillist);
$t->set_var(array(
- 'bugid' => $buginfo['BugID'],
- 'url' => INSTALLURL."/bug.php?op=show&bugid={$buginfo['BugID']}",
- 'Priority' => $select['priority'][($cf['Priority'] ? $cf['Priority'] : $buginfo['Priority'])],
- 'PriorityStat' => $cf['Priority'] ? '!' : ' ',
+ 'bugid' => $buginfo['bug_id'],
+ 'url' => INSTALLURL."/bug.php?op=show&bugid={$buginfo['bug_id']}",
+ 'Priority' => $select['priority_id'][($cf['priority_id'] ? $cf['priority_id'] : $buginfo['priority_id'])],
+ 'PriorityStat' => $cf['priority_id'] ? '!' : ' ',
'Reporter' => $reporter,
'ReporterStat' => $reporterstat,
'AssignedTo' => $assignedto,
@@ -156,8 +155,8 @@
'Comments' => textwrap($oldcomments,72,"\n ")."\n\n+".
textwrap($comments,72,"\n+ ")."\n"
));
- mail($toemail,"[Bug {$buginfo['BugID']}] Changed - ".
- ($cf['Title'] ? $cf['Title'] : $buginfo['Title']), $t->parse('main','emailout'),
+ mail($toemail,"[Bug {$buginfo['bug_id']}] Changed - ".
+ ($cf['title'] ? $cf['title'] : $buginfo['title']), $t->parse('main','emailout'),
sprintf("From: %s\nReply-To: %s\nErrors-To: %s", ADMINEMAIL, ADMINEMAIL,
ADMINEMAIL));
}
@@ -166,7 +165,7 @@
global $q, $t, $u, $STRING, $perm, $now;
// Pull bug from database to determine changed fields and for user validation
- $buginfo = $q->grab("select * from Bug where BugID = $bugid");
+ $buginfo = $q->grab("select * from bug where bug_id = $bugid");
if ($pv = $GLOBALS['HTTP_POST_VARS']) {
while (list($k,$v) = each($GLOBALS['HTTP_POST_VARS'])) {
@@ -180,19 +179,19 @@
}
}
- if (!($u == $buginfo['AssignedTo'] or $u == $buginfo['CreatedBy'] or
+ if (!($u == $buginfo['assigned_to'] or $u == $buginfo['created_by'] or
$perm->have_perm('Manager'))) {
show_bug($bugid,array('status' => $STRING['bugbadperm']));
return;
}
if ($outcome == 'reassign' and
- (!$assignedto = $q->grab_field("select UserID from User where Email = '$reassignto'"))) {
+ (!$assignedto = $q->grab_field("select user_id from user where email = '$reassignto'"))) {
show_bug($bugid,array('status' => $STRING['nouser']));
return;
}
- if ($lastmodifieddate != $buginfo['LastModifiedDate']) {
+ if ($lastmodifieddate != $buginfo['last_modified_date']) {
show_bug($bugid, array('status' => $STRING['datecollision']));
return;
}
@@ -201,30 +200,30 @@
case 'unchanged' : break;
case 'assign' : $assignedto = $u; $statusfield = 'Assigned'; break;
case 'reassign' :
- if (!$assignedto = $q->grab_field("select UserID from User where Email = '$reassignto'")) {
+ if (!$assignedto = $q->grab_field("select user_id from user where email = '$reassignto'")) {
show_bug($bugid,array('status' => $STRING['nouser']));
return;
} else {
$statusfield = 'Assigned';
- $changedfields['AssignedTo'] = $assignedto;
+ $changedfields['assigned_to'] = $assignedto;
break;
}
case 'reassigntocomponent' :
- $assignedto = $q->grab_field("select Owner from Component where ComponentID = $component");
+ $assignedto = $q->grab_field("select owner from component where component_id = $component");
$statusfield = 'Assigned'; break;
case 'dupe' :
$changeresolution = true;
if ($dupenum == $bugid) {
show_bug($bugid,array('status' => $STRING['dupeofself']));
return;
- } elseif (!$q->grab_field("select BugID from Bug where BugID = $dupenum")) {
+ } elseif (!$q->grab_field("select bug_id from bug where bug_id = $dupenum")) {
show_bug($bugid,array('status' => $STRING['nobug']));
return;
}
- $q->query("insert into Comment (CommentID, BugID, Text, CreatedBy, CreatedDate) values (".$q->nextid('Comment').", $dupenum, 'Bug #$bugid is a duplicate of this bug', $u, $now)");
- $q->query("insert into Comment (CommentID, BugID, Text, CreatedBy, CreatedDate) values (".$q->nextid('Comment').", $bugid, 'This bug is a duplicate of bug #$dupenum', $u, $now)");
+ $q->query("insert into comment (comment_id, bug_id, text, created_by, created_date) values (".$q->nextid('comment').", $dupenum, 'Bug #$bugid is a duplicate of this bug', $u, $now)");
+ $q->query("insert into comment (comment_id, bug_id, text, created_by, created_date) values (".$q->nextid('comment').", $bugid, 'This bug is a duplicate of bug #$dupenum', $u, $now)");
$statusfield = 'Duplicate';
- $bugresolution = $q->grab_field("select ResolutionID from Resolution where Name = 'Duplicate'");
+ $bugresolution = $q->grab_field("select resolution_id from resolution where resolution_name = 'Duplicate'");
$statusfield = 'Resolved';
break;
case 'resolve' :
@@ -244,16 +243,16 @@
break;
}
if ($statusfield) {
- $status = $q->grab_field("select StatusID from Status where Name = '$statusfield'");
- $changedfields['Status'] = $status;
+ $status = $q->grab_field("select status_id from status where status_name = '$statusfield'");
+ $changedfields['status'] = $status;
}
if ($comments) {
$comments = htmlspecialchars($comments);
- $q->query("insert into Comment (CommentID, BugID, Text, CreatedBy, CreatedDate) values (".$q->nextid('Comment').", $bugid, '$comments', $u, $now)");
+ $q->query("insert into comment (comment_id, bug_id, text, created_by, created_date) values (".$q->nextid('comment').", $bugid, '$comments', $u, $now)");
}
- $q->query("update Bug set Title = '$Title', URL = '$URL', Severity = $Severity, Priority = $Priority, ".($status ? "Status = $status, " : ''). ($changeresolution ? "Resolution = $bugresolution, " : ''). ($assignedto ? "AssignedTo = $assignedto, " : '')." Project = $Project, Version = $Version, Component = $Component, OS = $OS, LastModifiedBy = $u, LastModifiedDate = $now where BugID = $bugid");
+ $q->query("update bug set title = '$title', url = '$url', severity_id = $severity, priority_id = $priority, ".($status ? "status_id = $status, " : ''). ($changeresolution ? "resolution_id = $bugresolution, " : ''). ($assignedto ? "assigned_to = $assignedto, " : '')." project_id = $project, version_id = $version, component_id = $component, os_id = $os, last_modified_by = $u, last_modified_date = $now where bug_id = $bugid");
if ($changedfields or $comments) {
do_changedfields($u, $buginfo, $changedfields, $comments);
@@ -277,10 +276,10 @@
if ($url == 'http://') $url = '';
$time = time();
if (!$bugid) {
- $status = $q->grab_field("select StatusID from Status where Name = 'Unconfirmed'");
- $q->query("insert into Bug (BugID, Title, Description, URL, Severity, Priority, Status, CreatedBy, CreatedDate, LastModifiedBy, LastModifiedDate, Project, Version, Component, OS, BrowserString) values (".$q->nextid('Bug').", '$title', '$description', '$url', $severity, $priority, $status, $u, $time, $u, $time, $project, $version, $component, '$os', '{$GLOBALS['HTTP_USER_AGENT']}')");
+ $status = $q->grab_field("select status_id from status where status_name = 'Unconfirmed'");
+ $q->query("insert into bug (bug_id, title, description, url, severity_id, priority_id, status_id, created_by, created_date, last_modified_by, last_modified_date, project_id, version_id, component_id, os_id, browser_string) values (".$q->nextid('bug').", '$title', '$description', '$url', $severity, $priority, $status, $u, $time, $u, $time, $project, $version, $component, '$os', '{$GLOBALS['HTTP_USER_AGENT']}')");
} else {
- $q->query("update Bug set Title = '$title', Description = '$description', URL = '$url', Severity = '$severity', Priority = '$priority', Status = $status, AssignedTo = '$assignedto', Project = $project, Version = $version, Component = $component, OS = '$os', BrowserString = '{$GLOBALS['HTTP_USER_AGENT']}' LastModifiedBy = $u, LastModifiedDate = $time where BugID = '$bugid'");
+ $q->query("update bug set title = '$title', description = '$description', url = '$url', severity_id = '$severity', priority_id = '$priority', status_id = $status, assigned_to = '$assignedto', project_id = $project, version_id = $version, component_id = $component, os_id = '$os', browser_string = '{$GLOBALS['HTTP_USER_AGENT']}' last_modified_by = $u, last_modified_date = $time where bug_id = '$bugid'");
}
if ($another) header("Location: $me?op=add&project=$project");
else header("Location: query.php");
@@ -293,30 +292,30 @@
while (list($k,$v) = each($GLOBALS['HTTP_POST_VARS'])) $$k = $v;
$t->set_file('content','bugform.html');
- $projectname = $q->grab_field("select Name from Project where ProjectID = $project");
+ $projectname = $q->grab_field("select project_name from project where project_id = $project");
if ($bugid && !$error) {
- $row = $q->grab("select * from Bug where BugID = '$bugid'");
+ $row = $q->grab("select * from bug where bug_id = '$bugid'");
$t->set_var(array(
'bugid' => $bugid,
'TITLE' => $TITLE['editbug'],
- 'title' => stripslashes($row['Title']),
- 'description' => stripslashes($row['Description']),
+ 'title' => stripslashes($row['title']),
+ 'description' => stripslashes($row['description']),
'url' => $row['URL'],
- 'urllabel' => $row['URL'] ? "<a href='{$row['URL']}'>URL</a>" : 'URL',
- 'severity' => build_select('Severity',$row['Severity']),
- 'priority' => build_select('priority',$row['Priority']),
- 'status' => build_select('Status',$row['Status']),
- 'resolution' => build_select('Resolution',$row['Resolution']),
- 'assignedto' => $row['AssignedTo'],
- 'createdby' => $row['CreatedBy'],
- 'createddate' => date(DATEFORMAT,$row['CreatedDate']),
- 'lastmodifieddate' => $row['LastModifiedDate'],
- 'project' => $row['Project'],
+ 'urllabel' => $row['url'] ? "<a href='{$row['url']}'>URL</a>" : 'URL',
+ 'severity' => build_select('severity',$row['severity_id']),
+ 'priority' => build_select('priority',$row['priority_id']),
+ 'status' => build_select('status',$row['status_id']),
+ 'resolution' => build_select('resolution',$row['resolution_id']),
+ 'assignedto' => $row['assigned_to'],
+ 'createdby' => $row['created_by'],
+ 'createddate' => date(DATEFORMAT,$row['created_date']),
+ 'lastmodifieddate' => $row['last_modified_date'],
+ 'project' => $row['project_id'],
'projectname' => $projectname,
- 'version' => build_select('Version',$row['Version'],$row['Project']),
- 'component' => build_select('Component',$row['Component'],$row['Project']),
- 'os' => build_select('OS',$row['OS']),
- 'browserstring' => $row['BrowserString']));
+ 'version' => build_select('version',$row['version_id'],$row['project_id']),
+ 'component' => build_select('component',$row['component_id'],$row['project_id']),
+ 'os' => build_select('os',$row['os_id']),
+ 'browserstring' => $row['browser_string']));
} else {
$t->set_var(array(
'TITLE' => $TITLE['enterbug'],
@@ -326,26 +325,26 @@
'description' => stripslashes($description),
'url' => $url ? $url : 'http://',
'urllabel' => $url ? "<a href='$url'>URL</a>" : 'URL',
- 'severity' => build_select('Severity',$severity),
+ 'severity' => build_select('severity',$severity),
'priority' => build_select('priority',$priority),
- 'status' => build_select('Status',$status),
- 'resolution' => build_select('Resolution',$resolution),
+ 'status' => build_select('status',$status),
+ 'resolution' => build_select('resolution',$resolution),
'assignedto' => $assignedto,
'createdby' => $createdby,
'createddate' => $createddate,
'lastmodifieddate' => $lastmodifieddate,
'project' => $project,
'projectname' => $projectname,
- 'version' => build_select('Version',$version,$project),
- 'component' => build_select('Component',$component,$project),
- 'os' => build_select('OS',$os)));
+ 'version' => build_select('version',$version,$project),
+ 'component' => build_select('component',$component,$project),
+ 'os' => build_select('os',$os)));
}
}
function show_bug($bugid = 0, $error = '') {
global $q, $me, $t, $project, $STRING, $u, $perm;
- if (!ereg('^[0-9]+$',$bugid) or !$row = $q->grab("select BugID, Title, Reporter.Email as Reporter, Owner.Email as Owner, Project, Version, Severity, Bug.CreatedDate, Bug.LastModifiedDate, Status.Name as Status, Priority, Bug.Description, Resolution.Name as Resolution, URL, Component, OS from Bug, Severity, Status left join User Owner on Bug.AssignedTo = Owner.UserID left join User Reporter on Bug.CreatedBy = Reporter.UserID left join Resolution on Resolution = ResolutionID where BugID = '$bugid' and Severity = SeverityID and Status = StatusID")) {
+ if (!ereg('^[0-9]+$',$bugid) or !$row = $q->grab("select bug_id, title, reporter.email as reporter, owner.email as owner, b.project_id, b.version_id, b.severity_id, b.created_date, b.last_modified_date, status_name as status, b.priority_id, b.description, resolution_name as resolution, url, b.component_id, b.os_id from bug b, severity sv, status st left join user owner on b.assigned_to = owner.user_id left join user reporter on b.created_by = reporter.user_id, resolution r where b.resolution_id = r.resolution_id where bug_id = '$bugid' and b.severity_id = sv.severity_id and b.status_id = st.status_id")) {
show_text($STRING['bugbadnum'],true);
return;
}
@@ -362,26 +361,26 @@
'statuserr' => $error['status'] ? $error['status'].'<br><br>' : '',
'bugid' => $bugid,
'TITLE' => "{$TITLE['editbug']} #$bugid",
- 'title' => stripslashes($row['Title']),
- 'description' => nl2br(stripslashes($row['Description'])),
- 'url' => $row['URL'],
- 'urllabel' => $row['URL'] ? "<a href='{$row['URL']}'>URL</a>" : 'URL',
- 'severity' => build_select('Severity',$row['Severity']),
- 'priority' => build_select('priority',$row['Priority']),
- 'status' => $row['Status'],
- 'resolution' => $row['Resolution'],
- 'owner' => maskemail($row['Owner']),
- 'reporter' => maskemail($row['Reporter']),
- 'createddate' => date(DATEFORMAT,$row['CreatedDate']),
- 'createdtime' => date(TIMEFORMAT,$row['CreatedDate']),
- 'lastmodifieddate' => $row['LastModifiedDate'],
- 'project' => build_select('Project',$row['Project']),
- 'projectid' => $row['Project'],
- 'version' => build_select('Version',$row['Version'],$row['Project']),
- 'component' => build_select('Component',$row['Component'],$row['Project']),
- 'os' => build_select('OS',$row['OS']),
- 'browserstring' => $row['BrowserString'],
- 'bugresolution' => build_select('Resolution'),
+ 'title' => stripslashes($row['title']),
+ 'description' => nl2br(stripslashes($row['description'])),
+ 'url' => $row['url'],
+ 'urllabel' => $row['url'] ? "<a href='{$row['url']}'>URL</a>" : 'URL',
+ 'severity' => build_select('severity',$row['severity_id']),
+ 'priority' => build_select('priority',$row['priority_id']),
+ 'status' => $row['status_id'],
+ 'resolution' => $row['resolution_id'],
+ 'owner' => maskemail($row['owner']),
+ 'reporter' => maskemail($row['reporter']),
+ 'createddate' => date(DATEFORMAT,$row['created_date']),
+ 'createdtime' => date(TIMEFORMAT,$row['created_date']),
+ 'lastmodifieddate' => $row['last_modified_date'],
+ 'project' => build_select('project',$row['project_id']),
+ 'projectid' => $row['project_id'],
+ 'version' => build_select('version',$row['version_id'],$row['project_id']),
+ 'component' => build_select('component',$row['component_id'],$row['project_id']),
+ 'os' => build_select('os',$row['os_id']),
+ 'browserstring' => $row['browser_string'],
+ 'bugresolution' => build_select('resolution_id'),
'submit' => $u == 'nobody' ? $STRING['logintomodify'] :
'<input type="submit" value="Submit">'
));
@@ -410,29 +409,29 @@
}
// Show the attachments
- $q->query("select * from Attachment where BugID = $bugid");
+ $q->query("select * from attachment where bug_id = $bugid");
if (!$q->num_rows()) {
$t->set_var('attrows', '<tr><td colspan="5" align="center">No attachments</td></tr>');
} else {
while ($att = $q->grab()) {
- if (is_readable(INSTALLPATH.'/'.ATTACHMENT_PATH."/{$row['Project']}/$bugid-{$att['FileName']}")) {
- $action = "<a href='attachment.php?attachid={$att['AttachmentID']}'>View</a>";
+ if (is_readable(INSTALLPATH.'/'.ATTACHMENT_PATH."/{$row['project_id']}/$bugid-{$att['file_name']}")) {
+ $action = "<a href='attachment.php?attachid={$att['attachment_id']}'>View</a>";
if ($perm->have_perm('Administrator')) {
- $action .= " | <a href='attachment.php?del={$att['AttachmentID']}' onClick=\"return confirm('Are you sure you want to delete this attachment?');\">Delete</a>";
+ $action .= " | <a href='attachment.php?del={$att['attachment_id']}' onClick=\"return confirm('Are you sure you want to delete this attachment?');\">Delete</a>";
}
if ($att['FileSize'] > 1024) {
- $attsize = number_format((round($att['FileSize']) / 1024 * 100) / 100).'k';
+ $attsize = number_format((round($att['file_size']) / 1024 * 100) / 100).'k';
} else {
- $attsize = number_format($att['FileSize']).'b';
+ $attsize = number_format($att['file_size']).'b';
}
$t->set_var(array(
'bgcolor' => (++$j % 2 == 0) ? '#dddddd' : '#ffffff',
- 'attid' => $att['AttachmentID'],
- 'attname' => stripslashes($att['FileName']),
- 'attdesc' => stripslashes($att['Description']),
+ 'attid' => $att['attachment_id'],
+ 'attname' => stripslashes($att['file_name']),
+ 'attdesc' => stripslashes($att['description']),
'attsize' => $attsize,
- 'atttype' => $att['MimeType'],
- 'attdate' => date(DATEFORMAT, $att['CreatedDate']),
+ 'atttype' => $att['mime_type'],
+ 'attdate' => date(DATEFORMAT, $att['created_date']),
'attaction' => $action
));
$t->parse('attrows', 'attrow', true);
@@ -444,7 +443,7 @@
}
}
- $q->query("select Text, Comment.CreatedDate, Email from Comment, User where BugID = $bugid and CreatedBy = UserID order by CreatedDate");
+ $q->query("select text, comment.created_date, email from comment, user where bug_id = $bugid and created_by = user_id order by comment.created_date");
if (!$q->num_rows()) {
$t->set_var('rows','');
} else {
@@ -452,10 +451,10 @@
$t->set_var(array(
'bgcolor' => (++$i % 2 == 0) ? '#dddddd' : '#ffffff',
'rdescription' => eregi_replace('(bug)[[:space:]]*(#?)([0-9]+)',
- "\\1 <a href='$me?op=show&bugid=\\3'>\\2\\3</a>",nl2br($row['Text'])),
- 'rreporter' => maskemail($row['Email']),
- 'rcreateddate' => date(TIMEFORMAT,$row['CreatedDate']).' on '.
- date(DATEFORMAT,$row['CreatedDate'])
+ "\\1 <a href='$me?op=show&bugid=\\3'>\\2\\3</a>",nl2br($row['text'])),
+ 'rreporter' => maskemail($row['email']),
+ 'rcreateddate' => date(TIMEFORMAT,$row['created_date']).' on '.
+ date(DATEFORMAT,$row['created_date'])
));
$t->parse('rows','row',true);
}
@@ -465,7 +464,7 @@
function show_projects() {
global $me, $q, $t, $project, $STRING;
- $q->query("select * from Project where Active order by Name");
+ $q->query("select * from project where active order by project_name");
switch ($q->num_rows()) {
case 0 :
$t->set_var('rows',$STRING['noprojects']);
@@ -481,10 +480,10 @@
while ($row = $q->grab()) {
$t->set_var(array(
- 'id' => $row['ProjectID'],
- 'name' => $row['Name'],
- 'description' => $row['Description'],
- 'date' => date(DATEFORMAT,$row['CreatedDate'])
+ 'id' => $row['project_id'],
+ 'name' => $row['name'],
+ 'description' => $row['description'],
+ 'date' => date(DATEFORMAT,$row['created_date'])
));
$t->parse('rows','row',true);
}
|
|
From: Benjamin C. <bc...@us...> - 2001-08-18 14:09:33
|
Update of /cvsroot/phpbt/phpbt/languages In directory usw-pr-cvs1:/tmp/cvs-serv7935/languages Added Files: de.php en.php pt-br.php Log Message: Moving the strings files down to the languages directory --- NEW FILE: de.php --- <?php // strings-de.php - Deutsche Strings und Titel // Translation by Stefan Plank // ------------------------------------------------------------------------ // Copyright (c) 2001 The phpBugTracker Group // ------------------------------------------------------------------------ // Diese Datei ist Teil des phpBugTracker // // phpBugTracker ist freie Software; Sie koennen sie weiterverteilen // und/oder veraendern unter den Bedingungen der GNU General Public License, // publiziert durch die Free Software Foundation; entweder nach Version 2 // der Lizenz, oder (ihrer Wahl nach) irgendeiner spaeterern Version. // // phpBugTracker wird in der Hoffnung verteilt, dasz es nuetzlich ist, aber // OHNE JEDE GARANTIE; selbst ohne die eingeschloszene Garantie der // VERMARKTBARKEIT [MERCHANTIBILITY] oder EIGNUNG FUER // EINEN PARTIKULAEREN GEBRAUCH. Sie koennen mehr Details in der // GNU General Public License nachlesen. // // Sie sollten mit dem phpBugTracker eine Kopie der // GNU General Public License bekommen haben; wenn nicht, schreiben Sie der // Free Software Foundation, Inc., 59 Temple Place - Suite 330, Boston, // MA 02111-1307, USA. // ------------------------------------------------------------------------- $STRING = array( 'nouser' => 'Dieser Benutzer extistiert nicht', 'dupeofself' => 'Ein Bug kann kein Duplikat von sich selbst sein', 'nobug' => 'Dieser Bug existiert nicht', 'givesummary' => 'Bitte geben Sie einen Bericht ein', 'givedesc' => 'Bitte geben Sie eine Beschreibung ein', 'noprojects' => 'Keine Projekte gefunden', 'totalbugs' => 'Total Bugs', 'giveemail' => 'Bitte geben Sie eine gültige E-mail Adresse ein.', 'loginused' => 'Dieser Benutzername ist schon in Gebrauch', 'newacctsubject' => 'phpBugTracker Login', 'newacctmessage' => "Ihr phpBugTracker Passwort ist %s", 'nobugs' => 'Kein Bug gefunden', 'givename' => 'Bitte geben Sie einen Namen ein', 'edit' => 'Bearbeiten', 'addnew' => 'Neuen hinzufügen', 'nooses' => 'Keine Betriebsysteme gefunden', 'giveinitversion' => 'Bitte geben Sie eine Initialversion für das Projekt an', 'giveversion' => 'Bitte geben Sie eine Version ein', 'noversions' => 'Keine Version gefunden', 'nocomponents' => 'Keine Komponenten gefunden', 'nostatses' => 'Keine Stati gefunden', 'givepassword' => 'Bitte geben Sie ein Passwort ein!', 'nousers' => 'Keinen Benutzer gefunden', 'bugbadperm' => 'Sie können diesen Bug nicht ändern', 'bugbadnum' => 'Dieser Bug existiert nicht', 'datecollision' => 'Jemand hat diesen Bug behoben seit Sie ihn gesehen haben. Die Buginformation wurde mit den letzten Änderunen erneut geladen.', 'passwordmatch' => 'Dieses Passwörter stimmen nicht -- Bitte probieren Sie noch einmal', 'nobughistory' => 'Es gibt keine History für diesen Bug', 'logintomodify' => 'Sie müssen eingeloggt sein, um diesen Bug zu ändern.', 'dupe_attachment' => 'Dieser Anhang existiert bereits für den Bug.', 'give_attachment' => 'Bitte geben Sie eine Datei für den Upload an.', 'no_attachment_save_path' => 'Konnte den Pfad zum Speichern nicht finden!', 'attachment_path_not_writeable' => 'Konnte keine Datei im Speicherpfad erstellen', 'attachment_move_error' => 'Es gab einen Fehler beim Bewegen der upzuloadenen Datei', 'bad_attachment' => 'Dieser Dateianhang existiert nicht', 'attachment_too_large' => 'Die angegebene Datei ist größer als '.number_format(ATTACHMENT_MAX_SIZE).' bytes', 'bad_permission' => 'Sie haben nicht die erforderlichen Rechte für diese Funktion' ); // Page titles $TITLE = array( 'enterbug' => 'Geben Sie einen Fehler ein', 'editbug' => 'Fehler Bearbeiten', 'newaccount' => 'Neuen Account anlegen', 'bugquery' => 'Fehlersuche Bug Query', 'buglist' => 'Fehlerliste', 'addcomponent' => 'Komponente hinzufügen', 'editcomponent' => 'Komponente bearbeiten', 'addproject' => 'Projekt hinzufügen', 'editproject' => 'Projekt bearbeiten', 'addversion' => 'Version hinzufügen', 'editversion' => 'Version bearbeiten', 'project' => 'Projekte', 'os' => 'Betriebssysteme', 'resolution' => 'Auflösungen', 'status' => 'Stati', 'user' => 'Benutzer', 'home' => 'Home', 'reporting' => 'Bericht' ); ?> --- NEW FILE: en.php --- <?php // strings-en.php - English 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. // ------------------------------------------------------------------------ $STRING = array( 'nouser' => 'That user does not exist', 'dupeofself' => 'A bug can\'t be a duplicate of itself', 'nobug' => 'That bug does not exist', 'givesummary' => 'Please enter a summary', 'givedesc' => 'Please enter a description', 'noprojects' => 'No projects found', 'totalbugs' => 'Total Bugs', 'giveemail' => 'Please enter a valid email address', 'loginused' => 'That login has already been used', 'newacctsubject' => 'phpBugTracker Login', 'newacctmessage' => "Your phpBugTracker password is %s", 'nobugs' => 'No bugs found', 'givename' => 'Please enter a name', 'edit' => 'Edit', 'addnew' => 'Add new', 'nooses' => 'No OSes found', 'giveinitversion' => 'Please enter an initial version for the project', 'giveversion' => 'Please enter a version', 'noversions' => 'No versions found', 'nocomponents' => 'No components found', 'nostatses' => 'No statuses found', 'givepassword' => 'Please enter a password', 'nousers' => 'No users found', 'bugbadperm' => 'You cannot change this bug', 'bugbadnum' => 'That bug does not exist', 'datecollision' => 'Someone has updated this bug since you viewed it. The bug info has been reloaded with the latest changes.', 'passwordmatch' => 'Those passwords don\'t match -- please try again', 'nobughistory' => 'There is no history for that bug', 'logintomodify' => 'You must be logged in to modify this bug', 'dupe_attachment' => 'That attachment already exists for this bug', 'give_attachment' => 'Please specify a file to upload', 'no_attachment_save_path' => 'Couldn\'t find where to save the file!', 'attachment_path_not_writeable' => 'Couldn\'t create a file in the save path', 'attachment_move_error' => 'There was an error moving the uploaded file', 'bad_attachment' => 'That attachment does not exist', 'attachment_too_large' => 'The file you specified is larger than '.number_format(ATTACHMENT_MAX_SIZE).' bytes', 'bad_permission' => 'You do not have the permissions required for that function' ); // Page titles $TITLE = array( 'enterbug' => 'Enter a Bug', 'editbug' => 'Edit Bug', 'newaccount' => 'Create a new account', 'bugquery' => 'Bug Query', 'buglist' => 'Bug List', 'addcomponent' => 'Add Component', 'editcomponent' => 'Edit Component', 'addproject' => 'Add Project', 'editproject' => 'Edit Project', 'addversion' => 'Add Version', 'editversion' => 'Edit Version', 'project' => 'Projects', 'os' => 'Operating Systems', 'resolution' => 'Resolutions', 'status' => 'Statuses', 'user' => 'Users', 'home' => 'Home', 'reporting' => 'Reporting' ); ?> --- NEW FILE: pt-br.php --- <?php // strings-br.php - Brazilian Portuguese strings and titles // Translation by Alexandre Ponso // ------------------------------------------------------------------------ // 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. // ------------------------------------------------------------------------ $STRING = array( 'nouser' => 'Este usuário não existe', 'dupeofself' => 'Um bug não pode ser duplicata de si mesmo', 'nobug' => 'Este bug não existe', 'givesummary' => 'Por favor, digite um resumo', 'givedesc' => 'Por favor, digite uma descrição', 'noprojects' => 'Nenhum projeto encontrado', 'totalbugs' => 'Total de Bugs', 'giveemail' => 'Por favor, digite um endereço de email válido', 'loginused' => 'Este login já está sendo usado', 'newacctsubject' => 'phpBugTracker Login', 'newacctmessage' => "Sua senha phpBugTracker é %s", 'nobugs' => 'Nenhum bug encontrado', 'givename' => 'Por favor, digite um nome', 'edit' => 'Editar', 'addnew' => 'Adicionar novo', 'nooses' => 'Nenhum OS encontrado', 'giveinitversion' => 'Por favor, digite uma versão inicial para o projeto', 'giveversion' => 'Por favor, digite uma versão', 'noversions' => 'Nenhuma versão encontrada', 'nocomponents' => 'Nenhum componente encontrado', 'nostatses' => 'Nenhum status encontrado', 'givepassword' => 'Por favor, digite uma senha', 'nousers' => 'Nenhum usuário encontrado', 'bugbadperm' => 'Você não pode alterar este bug', 'bugbadnum' => 'Este bug não existe', 'datecollision' => 'Alguém já alterou este bug desde que você o viu. A informação sobre o bug foi atualizada com as últimas alterações.', 'passwordmatch' => 'As senhas não conferem -- por favor, tente novamente', 'nobughistory' => 'Não há historico para este bug', 'logintomodify' => 'Você deve estar autenticado para alterar este bug', 'dupe_attachment' => 'Este anexo já existe para esse bug', 'give_attachment' => 'Por favor, escolha um arquivo para upload', 'no_attachment_save_path' => 'Não há diretório de destino!', 'attachment_path_not_writeable' => 'Não foi possível criar um arquivo no diretório de destino', 'attachment_move_error' => 'Ocorreu um erro ao mover o arquivo transmitido', 'bad_attachment' => 'Este anexo não existe', 'attachment_too_large' => 'O arquivo escolhido é maior que '.number_format(ATTACHMENT_MAX_SIZE).' bytes', 'bad_permission' => 'Você não tem as permissões necessárias para essa função' ); // Page titles $TITLE = array( 'enterbug' => 'Adicionar um Bug', 'editbug' => 'Editar Bug', 'newaccount' => 'Criar uma nova conta', 'bugquery' => 'Pesquisar Bug', 'buglist' => 'Listar Bug', 'addcomponent' => 'Adicionar Componente', 'editcomponent' => 'Editar Componente', 'addproject' => 'Adicionar Projeto', 'editproject' => 'Editar Projeto', 'addversion' => 'Adicionar Versão', 'editversion' => 'Editar Versão', 'project' => 'Projeto', 'os' => 'Sistemas Operacionais', 'resolution' => 'Normas', 'status' => 'Status', 'user' => 'Usuários', 'home' => 'Home', 'reporting' => 'Relatórios' ); ?> |
|
From: Benjamin C. <bc...@us...> - 2001-08-18 14:09:33
|
Update of /cvsroot/phpbt/phpbt In directory usw-pr-cvs1:/tmp/cvs-serv7935 Removed Files: strings-de.php strings-en.php strings-pt-br.php Log Message: Moving the strings files down to the languages directory --- strings-de.php DELETED --- --- strings-en.php DELETED --- --- strings-pt-br.php DELETED --- |
|
From: Benjamin C. <bc...@us...> - 2001-08-18 14:06:52
|
Update of /cvsroot/phpbt/phpbt/languages In directory usw-pr-cvs1:/tmp/cvs-serv7475/languages Added Files: se.php Log Message: Swedish translation by Patrik Grip-Jansson --- NEW FILE: se.php --- <?php // strings-se.php - Swedish strings and titles // Translation by Patrik Grip-Jansson // ------------------------------------------------------------------------ // 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. // ------------------------------------------------------------------------ $STRING = array( 'nouser' => 'Användaren finns ej', 'dupeofself' => 'Ett fel kan inte vara en kopia av sig själv', 'nobug' => 'Den buggen finns ej', 'givesummary' => 'Skriv in en sammanfattning', 'givedesc' => 'Skriv in en beskrivning', 'noprojects' => 'Hittade inga projekt', 'totalbugs' => 'Totalt antal buggar', 'giveemail' => 'Skriv in en giltig e-postadress', 'loginused' => 'Användarnamnet är redan taget', 'newacctsubject' => 'phpBugTracker inloggning', 'newacctmessage' => "Ditt lösenord i phpBugTracker är %s", 'nobugs' => 'Inga buggar hittades', 'givename' => 'Ditt namn', 'edit' => 'Redigera', 'addnew' => 'Lägg till ny', 'nooses' => 'Inga OS hittades', 'giveinitversion' => 'Skriv in ett första versions-ID för projektet', 'giveversion' => 'Skriv in ett versions-ID', 'noversions' => 'Inga versioner funna', 'nocomponents' => 'Inga komponenter funna', 'nostatses' => 'Ingen status hittades', 'givepassword' => 'Var god skriv in ditt lösenord', 'nousers' => 'Inga användare hittades', 'bugbadperm' => 'Du kan inte ändra på den här buggen', 'bugbadnum' => 'Den buggen existerar inte', 'datecollision' => 'Någon har uppdaterat den buggen sen du tittade på den. Bugginformationen har laddats om med de senaste ändringarna', 'passwordmatch' => 'Lösenorden är inte lika -- var god försök igen', 'nobughistory' => 'Det finns ingen historik för den buggen', 'logintomodify' => 'Du måste vara inloggad för att redigera buggen', 'dupe_attachment' => 'Den bilagan finns redan med i buggen', 'give_attachment' => 'Ange vilken fil du vill skicka in', 'no_attachment_save_path' => 'Kunde inte hitta någon plats att lagra filen på', 'attachment_path_not_writeable' => 'Kunde inte spara filen i den angivna sökvägen för sparningar', 'attachment_move_error' => 'Ett fel uppstod när den inskickade filen skulle flyttas', 'bad_attachment' => 'Bilagan existerar inte', 'attachment_too_large' => 'Filen du angav är större än '.number_format(ATTACHMENT_MAX_SIZE).' bytes', 'bad_permission' => 'Du har inte den behövliga behörigheten för att använda den funktionen' ); // Page titles $TITLE = array( 'enterbug' => 'Rapportera bugg', 'editbug' => 'Redigera bugg', 'newaccount' => 'Skapa nytt konto', 'bugquery' => 'Buggsökning', 'buglist' => 'Bugglista', 'addcomponent' => 'Lägg till komponent', 'editcomponent' => 'Redigera komponent', 'addproject' => 'Lägg till projekt', 'editproject' => 'Redigera projekt', 'addversion' => 'Lägg till version', 'editversion' => 'Redigera version', 'project' => 'Projekt', 'os' => 'Operativsystem', 'resolution' => 'Uppföljning', 'status' => 'Status', 'user' => 'Användare', 'home' => 'Hem', 'reporting' => 'Rapportering' ); ?> |
|
From: Benjamin C. <bc...@us...> - 2001-08-18 14:06:17
|
Update of /cvsroot/phpbt/phpbt/languages In directory usw-pr-cvs1:/tmp/cvs-serv7390/languages Log Message: Directory /cvsroot/phpbt/phpbt/languages added to the repository |
|
From: Benjamin C. <bc...@us...> - 2001-08-18 03:20:42
|
Update of /cvsroot/phpbt/phpbt In directory usw-pr-cvs1:/tmp/cvs-serv5849 Modified Files: dbchanges.sql Log Message: Lengthen the bug title field and add a close_date field to the bug table Index: dbchanges.sql =================================================================== RCS file: /cvsroot/phpbt/phpbt/dbchanges.sql,v retrieving revision 1.4 retrieving revision 1.5 diff -u -r1.4 -r1.5 --- dbchanges.sql 2001/08/17 19:30:07 1.4 +++ dbchanges.sql 2001/08/18 03:20:40 1.5 @@ -13,7 +13,7 @@ CREATE TABLE `bug` ( `bug_id` int(10) unsigned NOT NULL default '0', - `bug_title` varchar(30) NOT NULL default '', + `bug_title` varchar(100) NOT NULL default '', `bug_desc` text NOT NULL, `bug_url` varchar(255) NOT NULL default '', `severity_id` tinyint(3) unsigned NOT NULL default '0', @@ -30,9 +30,10 @@ `component_id` int(10) unsigned NOT NULL default '0', `op_sys_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 * from Bug; +insert into bug select *, 0 from Bug; CREATE TABLE `bug_history` ( `bug_id` int(10) unsigned NOT NULL default '0', |
|
From: Benjamin C. <bc...@us...> - 2001-08-18 03:13:20
|
Update of /cvsroot/phpbt/phpbt
In directory usw-pr-cvs1:/tmp/cvs-serv4871
Modified Files:
newaccount.php
Log Message:
DB conversion
Index: newaccount.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/newaccount.php,v
retrieving revision 1.10
retrieving revision 1.11
diff -u -r1.10 -r1.11
--- newaccount.php 2001/08/17 01:43:17 1.10
+++ newaccount.php 2001/08/18 03:13:17 1.11
@@ -42,7 +42,7 @@
} else {
$mpassword = $password;
}
- $q->query("insert into user (user_id, first_name, last_name, email, password, user_level, created_date, last_modified_date) values (".$q->nextid('User').", '$firstname', '$lastname', '$email', '$mpassword', 1, $now, $now)");
+ $q->query("insert into user (user_id, first_name, last_name, email, password, user_level, created_date, last_modified_date) values (".$q->nextid('user').", '$firstname', '$lastname', '$email', '$mpassword', 1, $now, $now)");
mail($email, $STRING['newacctsubject'], sprintf($STRING['newacctmessage'],
$password), 'From: '.ADMINEMAIL);
$t->set_file('content','newaccountsuccess.html');
|
2 messages has been excluded from this view by a project administrator.
