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

Re: [phpBT-dev] user_level

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

This is a result of the change to the new permission scheme.  user_level became active.

On Thu, Aug 30, 2001 at 09:55:51PM +0200, Patrick Mairif wrote:
> what happened to user_level in auth_user? it's accessed in admin/user.php!
> 
> 
> _______________________________________________
> phpbt-dev mailing list
> php...@li...
> http://lists.sourceforge.net/lists/listinfo/phpbt-dev

Re: [phpBT-dev] bug.os_id=bug.op_sys_id?

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

Actually the db schemas should be changed.  I just did that and committed to CVS.

On Thu, Aug 30, 2001 at 09:45:48PM +0200, Patrick Mairif wrote:
> in query.php3 is a field bug.os_id used, should this be bug.op_sys_id?
> 
> 
> _______________________________________________
> phpbt-dev mailing list
> php...@li...
> http://lists.sourceforge.net/lists/listinfo/phpbt-dev

[phpBT-dev] CVS: phpbt createdb_pg.sql,1.2,1.3 dbchanges.sql,1.10,1.11

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

Update of /cvsroot/phpbt/phpbt
In directory usw-pr-cvs1:/tmp/cvs-serv9073

Modified Files:
	createdb_pg.sql dbchanges.sql 
Log Message:
Changing op_sys_id to os_id

Index: createdb_pg.sql
===================================================================
RCS file: /cvsroot/phpbt/phpbt/createdb_pg.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -r1.2 -r1.3
--- createdb_pg.sql	2001/08/29 13:44:57	1.2
+++ createdb_pg.sql	2001/08/30 20:44:40	1.3
@@ -50,7 +50,7 @@
   "project_id" INT4  NOT NULL DEFAULT '0',
   "version_id" INT4  NOT NULL DEFAULT '0',
   "component_id" INT4  NOT NULL DEFAULT '0',
-  "op_sys_id" INT2  NOT NULL DEFAULT '0',
+  "os_id" INT2  NOT NULL DEFAULT '0',
   "browser_string" varchar(255) NOT NULL DEFAULT '',
   "close_date" INT8  NOT NULL DEFAULT '0',
   PRIMARY KEY  (bug_id)

Index: dbchanges.sql
===================================================================
RCS file: /cvsroot/phpbt/phpbt/dbchanges.sql,v
retrieving revision 1.10
retrieving revision 1.11
diff -u -r1.10 -r1.11
--- dbchanges.sql	2001/08/28 03:51:33	1.10
+++ dbchanges.sql	2001/08/30 20:44:40	1.11
@@ -28,7 +28,7 @@
   `project_id` int(10) unsigned NOT NULL default '0',
   `version_id` int(10) unsigned NOT NULL default '0',
   `component_id` int(10) unsigned NOT NULL default '0',
-  `op_sys_id` tinyint(3) unsigned NOT NULL default '0',
+  `os_id` tinyint(3) unsigned NOT NULL default '0',
   `browser_string` varchar(255) NOT NULL default '',
 	`close_date` bigint(20) unsigned NOT NULL default '0',
   PRIMARY KEY  (`bug_id`)

[phpBT-dev] user_level

[Patrick M. <mai...@st...>]

what happened to user_level in auth_user? it's accessed in admin/user.php!

[phpBT-dev] bug.os_id=bug.op_sys_id?

[Patrick M. <mai...@st...>]

in query.php3 is a field bug.os_id used, should this be bug.op_sys_id?

Re: [phpBT-dev] table user

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

Yup

On Thu, Aug 30, 2001 at 07:42:31PM +0200, Patrick Mairif wrote:
> I found in user.php, function list_items() a select on table user. can I
> assume this should be auth_user? 
> 
> 
> 
> _______________________________________________
> phpbt-dev mailing list
> php...@li...
> http://lists.sourceforge.net/lists/listinfo/phpbt-dev

[phpBT-dev] table user

[Patrick M. <mai...@st...>]

I found in user.php, function list_items() a select on table user. can I
assume this should be auth_user? 

Re: [phpBT-dev] db structure

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

Heh, sounds good -- let me know if you need anymore completely biased opionion. :)

On Thu, Aug 30, 2001 at 04:12:39PM +0200, Patrick Mairif wrote:
> I thought again about it and decided to use constants in general and
> create an array when needed. is this ok?
> 
> 
> _______________________________________________
> phpbt-dev mailing list
> php...@li...
> http://lists.sourceforge.net/lists/listinfo/phpbt-dev

Re: [phpBT-dev] db structure

[Patrick M. <mai...@st...>]

I thought again about it and decided to use constants in general and
create an array when needed. is this ok?

[phpBT-dev] CVS: phpbt/templates/default bugdisplay.html,1.4,1.5 bugemail.txt,1.1,1.2

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

Update of /cvsroot/phpbt/phpbt/templates/default
In directory usw-pr-cvs1:/tmp/cvs-serv27615/templates/default

Modified Files:
	bugdisplay.html bugemail.txt 
Log Message:
Changes to table and field names

Index: bugdisplay.html
===================================================================
RCS file: /cvsroot/phpbt/phpbt/templates/default/bugdisplay.html,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -r1.4 -r1.5
--- bugdisplay.html	2001/08/11 17:09:24	1.4
+++ bugdisplay.html	2001/08/30 13:49:08	1.5
@@ -1,8 +1,6 @@
-<form action="bug.php" method="post">
-<input type="hidden" name="bugid" value="{bugid}">
+<form action="bug.php?op=update&bugid={bugid}" method="post">
 <input type="hidden" name="projectid" value="{projectid}">
-<input type="hidden" name="lastmodifieddate" value="{lastmodifieddate}">
-<input type="hidden" name="op" value="update">
+<input type="hidden" name="last_modified_date" value="{lastmodifieddate}">
 <table border='0' width="640">
 	<tr>
 		<td width="210" colspan="2">
@@ -20,19 +18,19 @@
 			Product:
 		</td>
 		<td>
-			<select name="Project">{project}</select>
+			<select name="project_id">{project}</select>
 		</td>
 		<td>
 			Component: 
 		</td>
 		<td>
-			<select name="Component">{component}</select>
+			<select name="component_id">{component}</select>
 		</td>
 		<td>
 			Version: 
 		</td>
 		<td>
-			<select name="Version">{version}</select>
+			<select name="version_id">{version}</select>
 		</td>
 	</tr>
 	<tr>
@@ -40,19 +38,19 @@
 			Severity: 
 		</td>
 		<td>
-			<select name="Severity">{severity}</select>
+			<select name="severity_id">{severity}</select>
 		</td>
 		<td>
 			Priority: 
 		</td>
 		<td>
-			<select name="Priority">{priority}</select>
+			<select name="priority">{priority}</select>
 		</td>
 		<td>
 			OS: 
 		</td>
 		<td>
-			<select name="OS">{os}</select>
+			<select name="os_id">{os}</select>
 		</td>
 	</tr>
 	<tr>
@@ -73,13 +71,13 @@
   	<td>Status:</td>
   	<td><b>{status}</b></td>
   	<td>Summary:</td>
-  	<td><input type="text" size="30" maxlength="30" name="Title" value="{title}"></td>
+  	<td><input type="text" size="30" maxlength="30" name="title" value="{title}"></td>
 	</tr>
 	<tr>
   	<td>Resolution:</td>
   	<td><b>{resolution}</b></td>
   	<td>{urllabel}:</td>
-  	<td><input type="text" size="30" maxlength="255" name="URL" value="{url}"></td>
+  	<td><input type="text" size="30" maxlength="255" name="url" value="{url}"></td>
 	</tr>
 	<tr>
   	<td colspan="4">

Index: bugemail.txt
===================================================================
RCS file: /cvsroot/phpbt/phpbt/templates/default/bugemail.txt,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- bugemail.txt	2001/08/01 13:55:56	1.1
+++ bugemail.txt	2001/08/30 13:49:08	1.2
@@ -1,18 +1,18 @@
 ============================================================================
-         Bug #: {bugid} ({url})
-{ReporterStat}  Reported By: {Reporter}
+         Bug #: {bugid} ({bugurl})
+{reporter_stat}  Reported By: {reporter}
 ----------------------------------------------------------------------------
-{TitleStat}      Summary: {Title}
-{URLStat}          URL: {URL}
-{ProjectStat}      Product: {Project}
-{VersionStat}      Version: {Version}
-{ComponentStat}    Component: {Component}
-{StatusStat}       Status: {Status}
-{ResolutionStat}   Resolution: {Resolution}
-{SeverityStat}     Severity: {Severity}
-{OSStat}   OS/Version: {OS}
-{PriorityStat}     Priority: {Priority}
-{AssignedToStat}  Assigned To: {AssignedTo}
+{title_stat}      Summary: {title}
+{url_stat}          URL: {url}
+{project_id_stat}      Product: {project_id}
+{version_id_stat}      Version: {version_id}
+{component_id_stat}    Component: {component_id}
+{status_id_stat}       Status: {status_id}
+{resolution_id_stat}   Resolution: {resolution_id}
+{severity_id_stat}     Severity: {severity_id}
+{os_id_stat}   OS/Version: {os_id}
+{priority_stat}     Priority: {priority}
+{assignedto_stat}  Assigned To: {assignedto}
 ============================================================================
 <!-- BEGIN commentblock -->
                               COMMENTS                                   

[phpBT-dev] CVS: phpbt bug.php,1.32,1.33

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

Update of /cvsroot/phpbt/phpbt
In directory usw-pr-cvs1:/tmp/cvs-serv27615

Modified Files:
	bug.php 
Log Message:
Changes to table and field names

Index: bug.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/bug.php,v
retrieving revision 1.32
retrieving revision 1.33
diff -u -r1.32 -r1.33
--- bug.php	2001/08/29 13:56:56	1.32
+++ bug.php	2001/08/30 13:49:08	1.33
@@ -68,19 +68,19 @@
 			$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' => '!'
+				$field.'_stat' => '!'
 				));
 		} else {
 			$t->set_var(array(
 				$field => $buginfo[$field],
-				$field.'Stat' => ' '
+				$field.'_stat' => ' '
 				));
 		}
 	}
 	
 	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]");
+		$oldvalue = $q->grab_field("select ${field}_name from $field where ${field}_id = {$buginfo[$field.'_id']}");
 		if ($cf[$field]) {
 			$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)");
@@ -134,7 +134,7 @@
 	} else {
 		$t->set_var('cblock', '');
 	}
-		
+	
 	// Don't email the person who just made the changes (later, make this 
 	// behavior toggable by the user)
 	if ($userid != $buginfo['created_by']) 
@@ -146,15 +146,13 @@
 		
 	$t->set_var(array(
 		'bugid' => $buginfo['bug_id'],
-		'url' => INSTALLURL."/bug.php?op=show&bugid={$buginfo['bug_id']}",
-		'Priority' => $select['priority'][($cf['priority'] ? $cf['priority'] : $buginfo['priority'])],
-		'PriorityStat' => $cf['priority'] ? '!' : ' ',
-		'Reporter' => $reporter,
-		'ReporterStat' => $reporterstat,
-		'AssignedTo' => $assignedto,
-		'AssignedToStat' => $assignedtostat,
-		'Comments' => textwrap($oldcomments,72,"\n	")."\n\n+".
-			textwrap($comments,72,"\n+ ")."\n"
+		'bugurl' => INSTALLURL."/bug.php?op=show&bugid={$buginfo['bug_id']}",
+		'priority' => $select['priority'][($cf['priority'] ? $cf['priority'] : $buginfo['priority'])],
+		'priority_stat' => $cf['priority'] ? '!' : ' ',
+		'reporter' => $reporter,
+		'reporter_stat' => $reporterstat,
+		'assignedto' => $assignedto,
+		'assignedto_stat' => $assignedtostat
 		));
 	if ($toemail) {
 		mail($toemail,"[Bug {$buginfo['bug_id']}] Changed - ".
@@ -170,15 +168,15 @@
 	// Pull bug from database to determine changed fields and for user validation
 	$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'])) {
+	if (isset($GLOBALS['HTTP_POST_VARS'])) {
+		foreach ($GLOBALS['HTTP_POST_VARS'] as $k => $v) {
 			$$k = $v;
-			if ($k == 'URL') {
+			if ($k == 'url') {
 				if ($v == 'http://') $v = '';
 				elseif ($v and substr($v,0,7) != 'http://') $v = 'http://'.$v;
-				$URL = $v;
+				$url = $v;
 			}
-			if ($buginfo[$k] != $v) { $changedfields[$k] = $v; }
+			if (stripslashes($buginfo[$k]) != stripslashes($v)) { $changedfields[$k] = $v; }
 		}
 	}
 	
@@ -194,7 +192,7 @@
 		return;
 	}
 	
-	if ($lastmodifieddate != $buginfo['last_modified_date']) {
+	if ($last_modified_date != $buginfo['last_modified_date']) {
 		show_bug($bugid, array('status' => $STRING['datecollision']));
 		return;
 	}
@@ -255,7 +253,7 @@
 		$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 = $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_id, priority = $priority, ".($status ? "status_id = $status, " : ''). ($changeresolution ? "resolution_id = $bugresolution, " : ''). ($assignedto ? "assigned_to = $assignedto, " : '')." project_id = $project_id, version_id = $version_id, component_id = $component_id, os_id = $os_id, last_modified_by = $u, last_modified_date = $now where bug_id = $bugid");
 	
 	if ($changedfields or $comments) {
 		do_changedfields($u, $buginfo, $changedfields, $comments);

Re: [phpBT-dev] db structure

[Patrick M. <mai...@st...>]

I allready started a solution with an constant prefix and an array:
  define ('DB_PREFIX', 'phpbt_');
  $cfgDatabase['attachment'] = DB_PREFIX.'attachment');

the solution with only one prefix used everywhere would be another
possibility.

> Now as for the hash vs. constant decision, I really prefer constants for two
> reasons:
> 1. These values are constant, so by definition they should be constants. :)
> 2. If it's a variable you have to remember to global $TABLE almost
> everywhere in the code.  Since I almost always forget to global $STRING
> when I need to, this one is a big deal for me. :)

I made the same experience! now, there is everywhere a
'global $cfgDatabase'! :-)

> So, even though the query lines are going to get noticeably longer, I
> prefer to set up TABLE_PREFIX and xxx_TABLE constants (e.g,
> define(USER_TABLE, 'auth_user')) and then have queries like "select *
> from ". TABLE_PREFIX.USER_TABLE ." where user_id = blah".

I need a dynamic mapping from the old tablenames, which are part of
fieldnames, to the new tablenames. I need a construct like
$cfgDatabase[$field]. With constants I have to create this kind of array
from the constants!

Re: [phpBT-dev] db structure

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

Oh, I did leave out the alternative of having two sets of names... P_xxx_TABLE has the TABLE_PREFIX prepended and xxx_TABLE does not.  That would avoid TABLE_PREFIX. showing up everywhere in the code.

On Wed, Aug 29, 2001 at 10:36:50PM +0200, Javier Sixto wrote:
> Ben Curtis wrote:
> 
> >Argh, some of my own code foiling my plans... :)  For this case we really 
> >need to have the TABLE_PREFIX (if that's the constant) be separate from 
> >xxx_TABLE or $TABLE['xxx'] (depending on whether we use a constant or hash 
> >(if you think of them as roughly equivalent (which the developer purist in 
> >me doesn't, but I digress (ooh the parentheses nesting)))).  So that means 
> >that queries throughout the code will either look like "select * from ". 
> >PREFIX ."table where ..." or "select * from ". PREFIX.xxx_TABLE ." where 
> >..." or "select * from ". PREFIX.$TABLE['xxx'] ." where ...".  That way you 
> >have the PREFIXless table names for this array.
> >
> >Now as for the hash vs. constant decision, I really prefer constants for 
> >two reasons:
> >1. These values are constant, so by definition they should be constants. :)
> >
> ok :-) the global variable is not very intersting for constants :-P
> 
> >
> >2. If it's a variable you have to remember to global $TABLE almost 
> >everywhere in the code.  Since I almost always forget to global $STRING 
> >when I need to, this one is a big deal for me. :)
> >
> >So, even though the query lines are going to get noticeably longer, I 
> >prefer to set up TABLE_PREFIX and xxx_TABLE constants (e.g, 
> >define(USER_TABLE, 'auth_user')) and then have queries like "select * from 
> >". TABLE_PREFIX.USER_TABLE ." where user_id = blah".
> >
> I will follow you ;-)
> 
> >
> >Comments?  Revilings?  Letters to CAP_ABUSE@? :)
> >
> >On Wed, Aug 29, 2001 at 08:56:03PM +0200, Patrick Mairif wrote:
> >
> >>I found a construct in bug.php (line 81) in which the old tablenames are
> >>used to access table fields in a loop, so I need a way to dynamically map
> >>the old names to the new configured ones, a hash for instance. So I would
> >>prefer Javiers solution and use one global hash and one constant for the
> >>prefix. At this point I need it anyway.
> >>
> >>Other ideas?
> >>
> >
> >_______________________________________________
> >phpbt-dev mailing list
> >php...@li...
> >http://lists.sourceforge.net/lists/listinfo/phpbt-dev
> >
> 
> 
> 
> 
> _______________________________________________
> phpbt-dev mailing list
> php...@li...
> http://lists.sourceforge.net/lists/listinfo/phpbt-dev

Re: [phpBT-dev] db structure

[Javier S. <js...@si...>]

Ben Curtis wrote:

>Argh, some of my own code foiling my plans... :)  For this case we really need to have the TABLE_PREFIX (if that's the constant) be separate from xxx_TABLE or $TABLE['xxx'] (depending on whether we use a constant or hash (if you think of them as roughly equivalent (which the developer purist in me doesn't, but I digress (ooh the parentheses nesting)))).  So that means that queries throughout the code will either look like "select * from ". PREFIX ."table where ..." or "select * from ". PREFIX.xxx_TABLE ." where ..." or "select * from ". PREFIX.$TABLE['xxx'] ." where ...".  That way you have the PREFIXless table names for this array.
>
>Now as for the hash vs. constant decision, I really prefer constants for two reasons:
>1. These values are constant, so by definition they should be constants. :)
>
ok :-) the global variable is not very intersting for constants :-P

>
>2. If it's a variable you have to remember to global $TABLE almost everywhere in the code.  Since I almost always forget to global $STRING when I need to, this one is a big deal for me. :)
>
>So, even though the query lines are going to get noticeably longer, I prefer to set up TABLE_PREFIX and xxx_TABLE constants (e.g, define(USER_TABLE, 'auth_user')) and then have queries like "select * from ". TABLE_PREFIX.USER_TABLE ." where user_id = blah".
>
I will follow you ;-)

>
>Comments?  Revilings?  Letters to CAP_ABUSE@? :)
>
>On Wed, Aug 29, 2001 at 08:56:03PM +0200, Patrick Mairif wrote:
>
>>I found a construct in bug.php (line 81) in which the old tablenames are
>>used to access table fields in a loop, so I need a way to dynamically map
>>the old names to the new configured ones, a hash for instance. So I would
>>prefer Javiers solution and use one global hash and one constant for the
>>prefix. At this point I need it anyway.
>>
>>Other ideas?
>>
>
>_______________________________________________
>phpbt-dev mailing list
>php...@li...
>http://lists.sourceforge.net/lists/listinfo/phpbt-dev
>

[phpBT-dev] w00t!

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

Shameless celebration on my part:

phpBugTracker is #18 on SourceForge's most active this week. :)
https://sourceforge.net/top/mostactive.php?type=week

Thanks for making my day!

Re: [phpBT-dev] db structure

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

Argh, some of my own code foiling my plans... :)  For this case we really need to have the TABLE_PREFIX (if that's the constant) be separate from xxx_TABLE or $TABLE['xxx'] (depending on whether we use a constant or hash (if you think of them as roughly equivalent (which the developer purist in me doesn't, but I digress (ooh the parentheses nesting)))).  So that means that queries throughout the code will either look like "select * from ". PREFIX ."table where ..." or "select * from ". PREFIX.xxx_TABLE ." where ..." or "select * from ". PREFIX.$TABLE['xxx'] ." where ...".  That way you have the PREFIXless table names for this array.

Now as for the hash vs. constant decision, I really prefer constants for two reasons:
1. These values are constant, so by definition they should be constants. :)
2. If it's a variable you have to remember to global $TABLE almost everywhere in the code.  Since I almost always forget to global $STRING when I need to, this one is a big deal for me. :)

So, even though the query lines are going to get noticeably longer, I prefer to set up TABLE_PREFIX and xxx_TABLE constants (e.g, define(USER_TABLE, 'auth_user')) and then have queries like "select * from ". TABLE_PREFIX.USER_TABLE ." where user_id = blah".

Comments?  Revilings?  Letters to CAP_ABUSE@? :)

On Wed, Aug 29, 2001 at 08:56:03PM +0200, Patrick Mairif wrote:
> I found a construct in bug.php (line 81) in which the old tablenames are
> used to access table fields in a loop, so I need a way to dynamically map
> the old names to the new configured ones, a hash for instance. So I would
> prefer Javiers solution and use one global hash and one constant for the
> prefix. At this point I need it anyway.
> 
> Other ideas?

Re: [phpBT-dev] db structure

[Patrick M. <mai...@st...>]

I found a construct in bug.php (line 81) in which the old tablenames are
used to access table fields in a loop, so I need a way to dynamically map
the old names to the new configured ones, a hash for instance. So I would
prefer Javiers solution and use one global hash and one constant for the
prefix. At this point I need it anyway.

Other ideas?

Re: [phpBT-dev] db structure

[Javier S. <js...@si...>]

I think it's a good thing to have the abilty to tune each table name ;-)
Ben Curtis wrote:

>As promised, I've rolled it around in my head a bit, and I think I would like to have a constant for the prefix and a constant for each table name.  This would allow for a prefix or not, and would allow people who prefer StudlyCaps table names to have them.  And since we would be editing every query for the prefix constant anyway, we might as well use table name constants.
>
>Thoughts?
>
>On Tue, Aug 28, 2001 at 01:45:40PM -0700, Ben Curtis wrote:
>
>>On Tue, Aug 28, 2001 at 10:35:56PM +0200, Patrick Mairif wrote:
>>
>>>On Tue, 28 Aug 2001, Ben Curtis wrote:
>>>
>>>>What should happen is that a constant is added to config.php for the
>>>>table name prefix, like phpbt_.  Then constants need to be added for
>>>>each table name using the prefix constant.  Then all the queries need to
>>>>be changed to use the new constants -- instead of "select from auth_user
>>>>..." it would be "select from ".USER_TABLE." ...
>>>>
>>>Why not one constant for the prefix that is used in all queries?
>>>
>>That's an alternative... let me let it roll around in my head a bit
>>
>>>The other suggestion from Javier sounds good, too, but I think it is not
>>>necessary. I think an array is a bit overloaded, isn't it?
>>>
>>Hmm, I didn't see a suggestion from Javier -- either I missed it or he didn't send it to the list. :)
>>
>>>> If you'd like to do this I can add you to the project as a developer.
>>>>
>>>ok, I would do this, just add me!
>>>
>>You've been added
>>
>>>>It doesn't have to be right away, but it would also be nice to have this
>>>>prefix configurable via the configure script and have that script change
>>>>the db schema file accordingly.
>>>>
>>>gonna see, what I can do. :)
>>>
>>Cool!  And, welcome aboard!
>>
>>_______________________________________________
>>phpbt-dev mailing list
>>php...@li...
>>http://lists.sourceforge.net/lists/listinfo/phpbt-dev
>>
>
>_______________________________________________
>phpbt-dev mailing list
>php...@li...
>http://lists.sourceforge.net/lists/listinfo/phpbt-dev
>

Re: [phpBT-dev] db structure

[Patrick M. <mai...@st...>]

On Wed, 29 Aug 2001, Ben Curtis wrote:

> As promised, I've rolled it around in my head a bit, and I think I would like to have a constant for the prefix and a constant for each table name.  This would allow for a prefix or not, and would allow people who prefer StudlyCaps table names to have them.  And since we would be editing every query for the prefix constant anyway, we might as well use table name constants.
> 
> Thoughts?

I had the same thoughts yesterday, so I agree! :)

Re: [phpBT-dev] db structure

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

As promised, I've rolled it around in my head a bit, and I think I would like to have a constant for the prefix and a constant for each table name.  This would allow for a prefix or not, and would allow people who prefer StudlyCaps table names to have them.  And since we would be editing every query for the prefix constant anyway, we might as well use table name constants.

Thoughts?

On Tue, Aug 28, 2001 at 01:45:40PM -0700, Ben Curtis wrote:
> On Tue, Aug 28, 2001 at 10:35:56PM +0200, Patrick Mairif wrote:
> > On Tue, 28 Aug 2001, Ben Curtis wrote:
> > > What should happen is that a constant is added to config.php for the
> > > table name prefix, like phpbt_.  Then constants need to be added for
> > > each table name using the prefix constant.  Then all the queries need to
> > > be changed to use the new constants -- instead of "select from auth_user
> > > ..." it would be "select from ".USER_TABLE." ...
> > 
> > Why not one constant for the prefix that is used in all queries?
> 
> That's an alternative... let me let it roll around in my head a bit
> 
> > 
> > The other suggestion from Javier sounds good, too, but I think it is not
> > necessary. I think an array is a bit overloaded, isn't it?
> 
> Hmm, I didn't see a suggestion from Javier -- either I missed it or he didn't send it to the list. :)
> 
> > 
> > >  If you'd like to do this I can add you to the project as a developer.
> > 
> > ok, I would do this, just add me!
> 
> You've been added
> 
> > 
> > > It doesn't have to be right away, but it would also be nice to have this
> > > prefix configurable via the configure script and have that script change
> > > the db schema file accordingly.
> > 
> > gonna see, what I can do. :)
> > 
> 
> Cool!  And, welcome aboard!
> 
> _______________________________________________
> phpbt-dev mailing list
> php...@li...
> http://lists.sourceforge.net/lists/listinfo/phpbt-dev

[phpBT-dev] Mail to this list

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

You'll notice a lot of mail just showed up on this list. :)  I discovered there were a number of messages waiting approval to be sent because they were sent by non-subscribers.  I'm in the process of adding dupe email addresses (mbravo@users... and jsixto@...) with the no-mail option so that you can post from these accounts.  Let me know if you have any questions.

[phpBT-dev] CVS: phpbt bug.php,1.31,1.32

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

Update of /cvsroot/phpbt/phpbt
In directory usw-pr-cvs1:/tmp/cvs-serv10832

Modified Files:
	bug.php 
Log Message:
Only send the bug update email if there is someone to whom to send it

Index: bug.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/bug.php,v
retrieving revision 1.31
retrieving revision 1.32
diff -u -r1.31 -r1.32
--- bug.php	2001/08/29 08:05:39	1.31
+++ bug.php	2001/08/29 13:56:56	1.32
@@ -156,10 +156,12 @@
 		'Comments' => textwrap($oldcomments,72,"\n	")."\n\n+".
 			textwrap($comments,72,"\n+ ")."\n"
 		));
-	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\nContent-Type: text/plain; charset=%s\nContent-Transfer-Encoding: 8bit\n", ADMINEMAIL, ADMINEMAIL,
-			ADMINEMAIL, $STRING['lang_charset']));
+	if ($toemail) {
+		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\nContent-Type: text/plain; charset=%s\nContent-Transfer-Encoding: 8bit\n", ADMINEMAIL, ADMINEMAIL,
+				ADMINEMAIL, $STRING['lang_charset']));
+	}
 }
 
 function update_bug($bugid = 0) {

[phpBT-dev] CVS: phpbt createdb.sql,1.6,1.7 createdb_pg.sql,1.1,1.2

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

Update of /cvsroot/phpbt/phpbt
In directory usw-pr-cvs1:/tmp/cvs-serv6506

Modified Files:
	createdb.sql createdb_pg.sql 
Log Message:
Added OS X

Index: createdb.sql
===================================================================
RCS file: /cvsroot/phpbt/phpbt/createdb.sql,v
retrieving revision 1.6
retrieving revision 1.7
diff -u -r1.6 -r1.7
--- createdb.sql	2001/08/10 13:51:17	1.6
+++ createdb.sql	2001/08/29 13:44:57	1.7
@@ -127,24 +127,25 @@
 INSERT INTO OS VALUES (12,'Mac System 8.5',12,'/Mozilla.*\\(.*;.*; 68K.*\\)/');
 INSERT INTO OS VALUES (13,'Mac System 8.6',13,'/Mozilla.*\\(.*;.*; PPC.*\\)/');
 INSERT INTO OS VALUES (14,'Mac System 9.0',14,'');
-INSERT INTO OS VALUES (15,'Linux',15,'/Mozilla.*\\(.*;.*; Linux.*\\)/');
-INSERT INTO OS VALUES (16,'BSDI',16,'/Mozilla.*\\(.*;.*; BSD\\/OS.*\\)/');
-INSERT INTO OS VALUES (17,'FreeBSD',17,'/Mozilla.*\\(.*;.*; FreeBSD.*\\)/');
-INSERT INTO OS VALUES (18,'NetBSD',18,'');
-INSERT INTO OS VALUES (19,'OpenBSD',19,'');
-INSERT INTO OS VALUES (20,'AIX',20,'/Mozilla.*\\(.*;.*; AIX.*\\)/');
-INSERT INTO OS VALUES (21,'BeOS',21,'');
-INSERT INTO OS VALUES (22,'HP-UX',22,'/Mozilla.*\\(.*;.*; HP-UX.*\\)/');
-INSERT INTO OS VALUES (23,'IRIX',23,'/Mozilla.*\\(.*;.*; IRIX.*\\)/');
-INSERT INTO OS VALUES (24,'Neutrino',24,'');
-INSERT INTO OS VALUES (25,'OpenVMS',25,'');
-INSERT INTO OS VALUES (26,'OS/2',26,'');
-INSERT INTO OS VALUES (27,'OSF/1',27,'/Mozilla.*\\(.*;.*; OSF.*\\)/');
-INSERT INTO OS VALUES (28,'Solaris',28,'/Mozilla.*\\(.*;.*; SunOS 5.*\\)/');
-INSERT INTO OS VALUES (29,'SunOS',29,'/Mozilla.*\\(.*;.*; SunOS.*\\)/');
-INSERT INTO OS VALUES (30,'other',30,'');
+INSERT INTO OS VALUES (15,'Mac OS X',15,'');
+INSERT INTO OS VALUES (16,'Linux',16,'/Mozilla.*\\(.*;.*; Linux.*\\)/');
+INSERT INTO OS VALUES (17,'BSDI',17,'/Mozilla.*\\(.*;.*; BSD\\/OS.*\\)/');
+INSERT INTO OS VALUES (18,'FreeBSD',18,'/Mozilla.*\\(.*;.*; FreeBSD.*\\)/');
+INSERT INTO OS VALUES (19,'NetBSD',19,'');
+INSERT INTO OS VALUES (20,'OpenBSD',20,'');
+INSERT INTO OS VALUES (21,'AIX',21,'/Mozilla.*\\(.*;.*; AIX.*\\)/');
+INSERT INTO OS VALUES (22,'BeOS',22,'');
+INSERT INTO OS VALUES (23,'HP-UX',23,'/Mozilla.*\\(.*;.*; HP-UX.*\\)/');
+INSERT INTO OS VALUES (24,'IRIX',24,'/Mozilla.*\\(.*;.*; IRIX.*\\)/');
+INSERT INTO OS VALUES (25,'Neutrino',25,'');
+INSERT INTO OS VALUES (26,'OpenVMS',26,'');
+INSERT INTO OS VALUES (27,'OS/2',27,'');
+INSERT INTO OS VALUES (28,'OSF/1',28,'/Mozilla.*\\(.*;.*; OSF.*\\)/');
+INSERT INTO OS VALUES (29,'Solaris',29,'/Mozilla.*\\(.*;.*; SunOS 5.*\\)/');
+INSERT INTO OS VALUES (30,'SunOS',30,'/Mozilla.*\\(.*;.*; SunOS.*\\)/');
+INSERT INTO OS VALUES (31,'other',31,'');
 
-insert into db_sequence values ('OS', 30);
+insert into db_sequence values ('OS', 31);
 
 #
 # Table structure for table 'Project'

Index: createdb_pg.sql
===================================================================
RCS file: /cvsroot/phpbt/phpbt/createdb_pg.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- createdb_pg.sql	2001/08/23 10:14:19	1.1
+++ createdb_pg.sql	2001/08/29 13:44:57	1.2
@@ -156,22 +156,23 @@
 INSERT INTO "os" VALUES (12,'Mac System 8.5',12,'/Mozilla.*\\(.*;.*; 68K.*\\)/');
 INSERT INTO "os" VALUES (13,'Mac System 8.6',13,'/Mozilla.*\\(.*;.*; PPC.*\\)/');
 INSERT INTO "os" VALUES (14,'Mac System 9.0',14,'');
-INSERT INTO "os" VALUES (15,'Linux',15,'/Mozilla.*\\(.*;.*; Linux.*\\)/');
-INSERT INTO "os" VALUES (16,'BSDI',16,'/Mozilla.*\\(.*;.*; BSD\\/OS.*\\)/');
-INSERT INTO "os" VALUES (17,'FreeBSD',17,'/Mozilla.*\\(.*;.*; FreeBSD.*\\)/');
-INSERT INTO "os" VALUES (18,'NetBSD',18,'');
-INSERT INTO "os" VALUES (19,'OpenBSD',19,'');
-INSERT INTO "os" VALUES (20,'AIX',20,'/Mozilla.*\\(.*;.*; AIX.*\\)/');
-INSERT INTO "os" VALUES (21,'BeOS',21,'');
-INSERT INTO "os" VALUES (22,'HP-UX',22,'/Mozilla.*\\(.*;.*; HP-UX.*\\)/');
-INSERT INTO "os" VALUES (23,'IRIX',23,'/Mozilla.*\\(.*;.*; IRIX.*\\)/');
-INSERT INTO "os" VALUES (24,'Neutrino',24,'');
-INSERT INTO "os" VALUES (25,'OpenVMS',25,'');
-INSERT INTO "os" VALUES (26,'OS/2',26,'');
-INSERT INTO "os" VALUES (27,'OSF/1',27,'/Mozilla.*\\(.*;.*; OSF.*\\)/');
-INSERT INTO "os" VALUES (28,'Solaris',28,'/Mozilla.*\\(.*;.*; SunOS 5.*\\)/');
-INSERT INTO "os" VALUES (29,'SunOS',29,'/Mozilla.*\\(.*;.*; SunOS.*\\)/');
-INSERT INTO "os" VALUES (30,'other',30,'');
+INSERT INTO "os" VALUES (15,'Mac OS X',15,'');
+INSERT INTO "os" VALUES (16,'Linux',16,'/Mozilla.*\\(.*;.*; Linux.*\\)/');
+INSERT INTO "os" VALUES (17,'BSDI',17,'/Mozilla.*\\(.*;.*; BSD\\/OS.*\\)/');
+INSERT INTO "os" VALUES (18,'FreeBSD',18,'/Mozilla.*\\(.*;.*; FreeBSD.*\\)/');
+INSERT INTO "os" VALUES (19,'NetBSD',19,'');
+INSERT INTO "os" VALUES (20,'OpenBSD',20,'');
+INSERT INTO "os" VALUES (21,'AIX',21,'/Mozilla.*\\(.*;.*; AIX.*\\)/');
+INSERT INTO "os" VALUES (22,'BeOS',22,'');
+INSERT INTO "os" VALUES (23,'HP-UX',23,'/Mozilla.*\\(.*;.*; HP-UX.*\\)/');
+INSERT INTO "os" VALUES (24,'IRIX',24,'/Mozilla.*\\(.*;.*; IRIX.*\\)/');
+INSERT INTO "os" VALUES (25,'Neutrino',25,'');
+INSERT INTO "os" VALUES (26,'OpenVMS',26,'');
+INSERT INTO "os" VALUES (27,'OS/2',27,'');
+INSERT INTO "os" VALUES (28,'OSF/1',28,'/Mozilla.*\\(.*;.*; OSF.*\\)/');
+INSERT INTO "os" VALUES (29,'Solaris',29,'/Mozilla.*\\(.*;.*; SunOS 5.*\\)/');
+INSERT INTO "os" VALUES (30,'SunOS',30,'/Mozilla.*\\(.*;.*; SunOS.*\\)/');
+INSERT INTO "os" VALUES (31,'other',31,'');
 
 --
 -- Table structure for table 'project'
@@ -318,4 +319,4 @@
 
 CREATE INDEX changed_active_sessions_index ON "active_sessions" ("changed");
 
-COMMIT;
\ No newline at end of file
+COMMIT;

[phpBT-dev] CVS: phpbt/languages ru_koi8-r.php,NONE,1.1 ru_windows-1251.php,NONE,1.1 de.php,1.3,1.4 en.php,1.3,1.4 no.php,1.1,1.2 pt-br.php,1.3,1.4 se.php,1.3,1.4

[Michael B. <mb...@us...>]

Update of /cvsroot/phpbt/phpbt/languages
In directory usw-pr-cvs1:/tmp/cvs-serv11899/languages

Modified Files:
	de.php en.php no.php pt-br.php se.php 
Added Files:
	ru_koi8-r.php ru_windows-1251.php 
Log Message:
Two new Russian language files
Introduced a new value in $STRING - lang_charset, which specifies MIME charset 
for the language file, and modified all mail-sending statements to include 
appropriate mail headers. Charset is probably mandatory for language files
now.



--- NEW FILE: ru_koi8-r.php ---
<?php

// ru_koi8-r.php - Russian strings and titles, KOI8-R encoding
// ------------------------------------------------------------------------
// 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(
	'lang_charset' => 'koi8-r',
	'nouser' => 'ôÁËÏÇÏ ÐÏÌØÚÏ×ÁÔÅÌÑ ÎÅ ÓÕÝÅÓÔ×ÕÅÔ',
	'dupeofself' => 'ðÒÏÂÌÅÍÁ ÎÅ ÍÏÖÅÔ ÂÙÔØ ÄÕÂÌÉËÁÔÏÍ ÓÁÍÏÊ ÓÅÂÑ',
	'nobug' => 'ôÁËÏÊ ÐÒÏÂÌÅÍÙ ÎÅ ÓÕÝÅÓÔ×ÕÅÔ',
	'givesummary' => 'ðÏÖÁÌÕÊÓÔÁ, ÕËÁÖÉÔÅ ÓÕÔØ ÐÒÏÂÌÅÍÙ',
	'givedesc' => 'ðÏÖÁÌÕÊÓÔÁ, ××ÅÄÉÔÅ ÏÐÉÓÁÎÉÅ',
	'noprojects' => 'ðÒÏÅËÔÏ× ÎÅ ÎÁÊÄÅÎÏ',
	'totalbugs' => '÷ÓÅÇÏ ÐÒÏÂÌÅÍ',
	'giveemail' => 'ðÏÖÁÌÕÊÓÔÁ, ÕËÁÖÉÔÅ ÒÁÂÏÔÁÀÝÉÊ email-ÁÄÒÅÓ',
	'loginused' => 'ôÁËÏÊ ÌÏÇÉÎ ÕÖÅ ÚÁÎÑÔ',
	'newacctsubject' => 'phpBugTracker Login',
	'newacctmessage' => "÷ÁÛ ÐÁÒÏÌØ × phpBugTracker - %s",
	'nobugs' => 'ðÒÏÂÌÅÍ ÎÅ ÎÁÊÄÅÎÏ',
	'givename' => 'ðÏÖÁÌÕÊÓÔÁ, ÕËÁÖÉÔÅ ÉÍÑ',
	'edit' => 'ðÒÁ×ËÁ',
	'addnew' => 'äÏÂÁ×ÉÔØ',
	'nooses' => 'îÅ ÎÁÊÄÅÎÏ ïó',
	'giveinitversion' => 'ðÏÖÁÌÕÊÓÔÁ, ÕËÁÖÉÔÅ ÎÁÞÁÌØÎÕÀ ×ÅÒÓÉÀ ÄÌÑ ÄÁÎÎÏÇÏ ÐÒÏÅËÔÁ',
	'giveversion' => 'ðÏÖÁÌÕÊÓÔÁ, ÕËÁÖÉÔÅ ×ÅÒÓÉÀ',
	'noversions' => '÷ÅÒÓÉÊ ÎÅ ÎÁÊÄÅÎÏ',
	'nocomponents' => 'ëÏÍÐÏÎÅÎÔ ÎÅ ÎÁÊÄÅÎÏ',
	'nostatuses' => 'óÏÓÔÏÑÎÉÊ ÎÅ ÎÁÊÄÅÎÏ',
	'noseverities' => 'ïÐÉÓÁÎÉÊ ×ÁÖÎÏÓÔÉ ÎÅ ÎÁÊÄÅÎÏ',
	'givepassword' => 'ðÏÖÁÌÕÊÓÔÁ, ÕËÁÖÉÔÅ ÐÁÒÏÌØ',
	'nousers' => 'ðÏÌØÚÏ×ÁÔÅÌÅÊ ÎÅ ÎÁÊÄÅÎÏ',
	'bugbadperm' => '÷Ù ÎÅ ÍÏÖÅÔÅ ÉÚÍÅÎÉÔØ ÜÔÕ ÐÒÏÂÌÅÍÕ',
	'bugbadnum' => 'ôÁËÏÊ ÐÒÏÂÌÅÍÙ ÎÅ ÓÕÝÅÓÔ×ÕÅÔ',
	'datecollision' => 'ëÔÏ-ÔÏ ÏÂÎÏ×ÉÌ ÜÔÕ ÐÒÏÂÌÅÍÕ ÐÏËÁ ×Ù ÅÅ ÐÒÏÓÍÁÔÒÉ×ÁÌÉ. éÎÆÏÒÍÁÃÉÑ Ï ÐÒÏÂÌÅÍÅ ÐÅÒÅÚÁÇÒÕÖÅÎÁ, ×ËÌÀÞÁÑ ÐÏÓÌÅÄÎÉÅ ÉÚÍÅÎÅÎÉÑ.',
	'passwordmatch' => 'üÔÉ ÐÁÒÏÌÉ ÎÅ ÓÏ×ÐÁÄÁÀÔ -- ÐÏÖÁÌÕÊÓÔÁ, ÐÏÐÒÏÂÕÊÔÅ ÅÝÅ ÒÁÚ',
	'nobughistory' => 'äÌÑ ÜÔÏÊ ÐÒÏÂÌÅÍÙ ÉÓÔÏÒÉÉ ÎÅÔ',
	'logintomodify' => 'äÌÑ ÉÚÍÅÎÅÎÉÑ ÜÔÏÊ ÐÒÏÂÌÅÍÙ ×Ù ÄÏÌÖÎÙ ×ÏÊÔÉ × ÓÉÓÔÅÍÕ',
	'dupe_attachment' => 'ôÁËÏÅ ÐÒÉÌÏÖÅÎÉÅ ÕÖÅ ÓÕÝÅÓÔ×ÕÅÔ ÄÌÑ ÄÁÎÎÏÊ ÐÒÏÂÌÅÍÙ',
	'give_attachment' => 'ðÏÖÁÌÕÊÓÔÁ, ÕËÁÖÉÔÅ ÆÁÊÌ ÄÌÑ ÚÁÇÒÕÚËÉ',
	'no_attachment_save_path' => 'îÅ ÍÏÇÕ ÎÁÊÔÉ ÇÄÅ ÓÏÚÒÁÎÉÔØ ÆÁÊÌ!',
	'attachment_path_not_writeable' => 'îÅ ÍÏÇÕ ÓÏÚÄÁÔØ ÆÁÊÌ × ÕËÁÚÁÎÎÏÍ ÍÅÓÔÅ',
	'attachment_move_error' => 'ðÒÉ ÐÅÒÅÍÅÝÅÎÉÉ ÚÁÇÒÕÖÅÎÎÏÇÏ ÆÁÊÌÁ ÐÒÏÉÚÏÛÌÁ ÏÛÉÂËÁ',
	'bad_attachment' => 'ôÁËÏÇÏ ÐÒÉÌÏÖÅÎÉÑ ÎÅ ÓÕÝÅÓÔ×ÕÅÔ',
	'attachment_too_large' => 'õËÁÚÁÎÎÙÊ ÆÁÊÌ ÉÍÅÅÔ ÒÁÚÍÅÒ ÂÏÌØÛÅ ÞÅÍ '.number_format(ATTACHMENT_MAX_SIZE).' ÂÁÊÔ',
	'bad_permission' => 'õ ×ÁÓ ÎÅÔ ÐÏÌÎÏÍÏÞÉÊ, ÎÅÏÂÈÏÄÉÍÙÈ ÄÌÑÄÁÎÎÏÊ ÆÕÎËÃÉÉ'
	);
	
// Page titles
$TITLE = array(
	'enterbug' => '÷×ÏÄ ÐÒÏÂÌÅÍÙ',
	'editbug' => 'ðÒÁ×ËÁ ÐÒÏÂÌÅÍÙ',
	'newaccount' => 'óÏÚÄÁÎÉÅ ÎÏ×ÏÇÏ ×ÈÏÄÁ × ÓÉÓÔÅÍÕ',
	'bugquery' => 'úÁÐÒÏÓ ÐÒÏÂÌÅÍ',
	'buglist' => 'óÐÉÓÏË ÐÒÏÂÌÅÍ',
	'addcomponent' => 'äÏÂÁ×ÉÔØ ËÏÍÐÏÎÅÎÔ',
	'editcomponent' => 'ðÒÁ×ËÁ ËÏÍÐÏÎÅÎÔÁ',
	'addproject' => 'äÏÂÁ×ÉÔØ ÐÒÏÅËÔ',
	'editproject' => 'ðÒÁ×ËÁ ÐÒÏÅËÔÁ',
	'addversion' => 'äÏÂÁ×ÉÔØ ×ÅÒÓÉÀ',
	'editversion' => 'ðÒÁ×ËÁ ×ÅÒÓÉÉ',
	'project' => 'ðÒÏÅËÔÙ',
	'os' => 'ïÐÅÒÁÃÉÏÎÎÙÅ ÓÉÓÔÅÍÙ',
	'resolution' => 'òÅÚÏÌÀÃÉÉ',
	'status' => 'óÏÓÔÏÑÎÉÑ',
	'severity' => '÷ÁÖÎÏÓÔØ',
	'user' => 'ðÏÌØÚÏ×ÁÔÅÌÉ',
	'home' => 'çÌÁ×ÎÁÑ ÓÔÒÁÎÉÃÁ',
	'reporting' => 'ïÔÞÅÔÙ'
	);
	
?>

--- NEW FILE: ru_windows-1251.php ---
<?php

// ru_windows-1251.php - Russian strings and titles, windows-1251 encoding
// ------------------------------------------------------------------------
// 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(
	'lang_charset' => 'windows-1251',
	'nouser' => 'Òàêîãî ïîëüçîâàòåëÿ íå ñóùåñòâóåò',
	'dupeofself' => 'Ïðîáëåìà íå ìîæåò áûòü äóáëèêàòîì ñàìîé ñåáÿ',
	'nobug' => 'Òàêîé ïðîáëåìû íå ñóùåñòâóåò',
	'givesummary' => 'Ïîæàëóéñòà, óêàæèòå ñóòü ïðîáëåìû',
	'givedesc' => 'Ïîæàëóéñòà, ââåäèòå îïèñàíèå',
	'noprojects' => 'Ïðîåêòîâ íå íàéäåíî',
	'totalbugs' => 'Âñåãî ïðîáëåì',
	'giveemail' => 'Ïîæàëóéñòà, óêàæèòå ðàáîòàþùèé email-àäðåñ',
	'loginused' => 'Òàêîé ëîãèí óæå çàíÿò',
	'newacctsubject' => 'phpBugTracker Login',
	'newacctmessage' => "Âàø ïàðîëü â phpBugTracker - %s",
	'nobugs' => 'Ïðîáëåì íå íàéäåíî',
	'givename' => 'Ïîæàëóéñòà, óêàæèòå èìÿ',
	'edit' => 'Ïðàâêà',
	'addnew' => 'Äîáàâèòü',
	'nooses' => 'Íå íàéäåíî ÎÑ',
	'giveinitversion' => 'Ïîæàëóéñòà, óêàæèòå íà÷àëüíóþ âåðñèþ äëÿ äàííîãî ïðîåêòà',
	'giveversion' => 'Ïîæàëóéñòà, óêàæèòå âåðñèþ',
	'noversions' => 'Âåðñèé íå íàéäåíî',
	'nocomponents' => 'Êîìïîíåíò íå íàéäåíî',
	'nostatuses' => 'Ñîñòîÿíèé íå íàéäåíî',
	'noseverities' => 'Îïèñàíèé âàæíîñòè íå íàéäåíî',
	'givepassword' => 'Ïîæàëóéñòà, óêàæèòå ïàðîëü',
	'nousers' => 'Ïîëüçîâàòåëåé íå íàéäåíî',
	'bugbadperm' => 'Âû íå ìîæåòå èçìåíèòü ýòó ïðîáëåìó',
	'bugbadnum' => 'Òàêîé ïðîáëåìû íå ñóùåñòâóåò',
	'datecollision' => 'Êòî-òî îáíîâèë ýòó ïðîáëåìó ïîêà âû åå ïðîñìàòðèâàëè. Èíôîðìàöèÿ î ïðîáëåìå ïåðåçàãðóæåíà, âêëþ÷àÿ ïîñëåäíèå èçìåíåíèÿ.',
	'passwordmatch' => 'Ýòè ïàðîëè íå ñîâïàäàþò -- ïîæàëóéñòà, ïîïðîáóéòå åùå ðàç',
	'nobughistory' => 'Äëÿ ýòîé ïðîáëåìû èñòîðèè íåò',
	'logintomodify' => 'Äëÿ èçìåíåíèÿ ýòîé ïðîáëåìû âû äîëæíû âîéòè â ñèñòåìó',
	'dupe_attachment' => 'Òàêîå ïðèëîæåíèå óæå ñóùåñòâóåò äëÿ äàííîé ïðîáëåìû',
	'give_attachment' => 'Ïîæàëóéñòà, óêàæèòå ôàéë äëÿ çàãðóçêè',
	'no_attachment_save_path' => 'Íå ìîãó íàéòè ãäå ñîçðàíèòü ôàéë!',
	'attachment_path_not_writeable' => 'Íå ìîãó ñîçäàòü ôàéë â óêàçàííîì ìåñòå',
	'attachment_move_error' => 'Ïðè ïåðåìåùåíèè çàãðóæåííîãî ôàéëà ïðîèçîøëà îøèáêà',
	'bad_attachment' => 'Òàêîãî ïðèëîæåíèÿ íå ñóùåñòâóåò',
	'attachment_too_large' => 'Óêàçàííûé ôàéë èìååò ðàçìåð áîëüøå ÷åì '.number_format(ATTACHMENT_MAX_SIZE).' áàéò',
	'bad_permission' => 'Ó âàñ íåò ïîëíîìî÷èé, íåîáõîäèìûõ äëÿäàííîé ôóíêöèè'
	);
	
// Page titles
$TITLE = array(
	'enterbug' => 'Ââîä ïðîáëåìû',
	'editbug' => 'Ïðàâêà ïðîáëåìû',
	'newaccount' => 'Ñîçäàíèå íîâîãî âõîäà â ñèñòåìó',
	'bugquery' => 'Çàïðîñ ïðîáëåì',
	'buglist' => 'Ñïèñîê ïðîáëåì',
	'addcomponent' => 'Äîáàâèòü êîìïîíåíò',
	'editcomponent' => 'Ïðàâêà êîìïîíåíòà',
	'addproject' => 'Äîáàâèòü ïðîåêò',
	'editproject' => 'Ïðàâêà ïðîåêòà',
	'addversion' => 'Äîáàâèòü âåðñèþ',
	'editversion' => 'Ïðàâêà âåðñèè',
	'project' => 'Ïðîåêòû',
	'os' => 'Îïåðàöèîííûå ñèñòåìû',
	'resolution' => 'Ðåçîëþöèè',
	'status' => 'Ñîñòîÿíèÿ',
	'severity' => 'Âàæíîñòü',
	'user' => 'Ïîëüçîâàòåëè',
	'home' => 'Ãëàâíàÿ ñòðàíèöà',
	'reporting' => 'Îò÷åòû'
	);
	
?>

Index: de.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/languages/de.php,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -r1.3 -r1.4
--- de.php	2001/08/18 15:04:10	1.3
+++ de.php	2001/08/29 08:05:39	1.4
@@ -28,6 +28,7 @@
 
 
 $STRING = array(
+	'lang_charset' => 'iso8859-1',
 	'nouser' => 'Dieser Benutzer extistiert nicht',
 	'dupeofself' => 'Ein Bug kann kein Duplikat von sich selbst sein',
 	'nobug' => 'Dieser Bug existiert nicht',

Index: en.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/languages/en.php,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -r1.3 -r1.4
--- en.php	2001/08/18 15:04:10	1.3
+++ en.php	2001/08/29 08:05:39	1.4
@@ -22,6 +22,7 @@
 // ------------------------------------------------------------------------
 
 $STRING = array(
+	'lang_charset' => 'us-ascii',
 	'nouser' => 'That user does not exist',
 	'dupeofself' => 'A bug can\'t be a duplicate of itself',
 	'nobug' => 'That bug does not exist',

Index: no.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/languages/no.php,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- no.php	2001/08/29 03:45:23	1.1
+++ no.php	2001/08/29 08:05:39	1.2
@@ -23,6 +23,7 @@
 // ------------------------------------------------------------------------
 
 $STRING = array(
+	'lang_charset' => 'iso8859-1',
 	'nouser' => 'Denne brukeren eksisterer ikke',
 	'dupeofself' => 'En feil kan ikke være en kopi av seg selv',
 	'nobug' => 'Den feilen eksisterer ikke',

Index: pt-br.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/languages/pt-br.php,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -r1.3 -r1.4
--- pt-br.php	2001/08/18 15:04:10	1.3
+++ pt-br.php	2001/08/29 08:05:39	1.4
@@ -23,6 +23,7 @@
 // ------------------------------------------------------------------------
 
 $STRING = array(
+	'lang_charset' => 'iso8859-1',
 	'nouser' => 'Este usuário não existe',
 	'dupeofself' => 'Um bug não pode ser duplicata de si mesmo',
 	'nobug' => 'Este bug não existe',

Index: se.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/languages/se.php,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -r1.3 -r1.4
--- se.php	2001/08/18 15:04:10	1.3
+++ se.php	2001/08/29 08:05:39	1.4
@@ -23,6 +23,7 @@
 // ------------------------------------------------------------------------
 
 $STRING = array(
+	'lang_charset' => 'iso8859-1',
 	'nouser' => 'Användaren finns ej',
 	'dupeofself' => 'Ett fel kan inte vara en kopia av sig själv',
 	'nobug' => 'Den buggen finns ej',

[phpBT-dev] CVS: phpbt bug.php,1.30,1.31 include.php,1.43,1.44 newaccount.php,1.13,1.14

[Michael B. <mb...@us...>]

Update of /cvsroot/phpbt/phpbt
In directory usw-pr-cvs1:/tmp/cvs-serv11899

Modified Files:
	bug.php include.php newaccount.php 
Log Message:
Two new Russian language files
Introduced a new value in $STRING - lang_charset, which specifies MIME charset 
for the language file, and modified all mail-sending statements to include 
appropriate mail headers. Charset is probably mandatory for language files
now.



Index: bug.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/bug.php,v
retrieving revision 1.30
retrieving revision 1.31
diff -u -r1.30 -r1.31
--- bug.php	2001/08/25 18:39:11	1.30
+++ bug.php	2001/08/29 08:05:39	1.31
@@ -158,8 +158,8 @@
 		));
 	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));
+		sprintf("From: %s\nReply-To: %s\nErrors-To: %s\nContent-Type: text/plain; charset=%s\nContent-Transfer-Encoding: 8bit\n", ADMINEMAIL, ADMINEMAIL,
+			ADMINEMAIL, $STRING['lang_charset']));
 }
 
 function update_bug($bugid = 0) {

Index: include.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/include.php,v
retrieving revision 1.43
retrieving revision 1.44
diff -u -r1.43 -r1.44
--- include.php	2001/08/28 04:13:59	1.43
+++ include.php	2001/08/29 08:05:39	1.44
@@ -455,7 +455,7 @@
         $q->query("update auth_user set password = '$mpassword' where login = '$username'");
       }
       mail($email, $STRING['newacctsubject'], sprintf($STRING['newacctmessage'],
-        $password),  'From: '.ADMINEMAIL);
+        $password),  sprintf("From: %s\nContent-Type: text/plain; charset=%s\nContent-Transfer-Encoding: 8bit\n",ADMINEMAIL, $STRING['lang_charset']));
       $t->set_var(array(
         'loginerrorcolor' => '#0000ff',
         'loginerror' => 'Your password has been emailed to you<br>'

Index: newaccount.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/newaccount.php,v
retrieving revision 1.13
retrieving revision 1.14
diff -u -r1.13 -r1.14
--- newaccount.php	2001/08/28 04:15:15	1.13
+++ newaccount.php	2001/08/29 08:05:39	1.14
@@ -50,7 +50,7 @@
 	$q->query("insert into auth_user (user_id, login, first_name, last_name, email, password, active, created_date, last_modified_date) values ($user_id, '$login', '$firstname', '$lastname', '$email', '$mpassword', 1, $now, $now)");
 	$q->query("insert into user_group (user_id, group_id) select $user_id, group_id from auth_group where group_name = 'user'"); 
 	mail($email, $STRING['newacctsubject'], sprintf($STRING['newacctmessage'], 
-		$password),	'From: '.ADMINEMAIL);
+		$password),	sprintf("From: %s\nContent-Type: text/plain; charset=%s\nContent-Transfer-Encoding: 8bit\n",ADMINEMAIL, $STRING['lang_charset']));
 	$t->set_file('content','newaccountsuccess.html');
 }