cvs: phpweb / mod_bugs.php
| From: | Sterling Hughes | Date: | Wed, 06 Sep 2000 21:06:27 +0000 |
| Subject: | cvs: phpweb / mod_bugs.php | ||
| Groups: | php.mirrors | ||
| Request: | Send a blank email to php-mirrors+get-1997@lists.php.net to get a copy of this message | ||
sterling Wed Sep 6 14:06:27 2000 EDT
Modified files:
/phpweb mod_bugs.php
Log:
add test.
Index: phpweb/mod_bugs.php
diff -u /dev/null phpweb/mod_bugs.php:1.20
--- /dev/null Wed Sep 6 14:06:27 2000
+++ phpweb/mod_bugs.php Wed Sep 6 14:06:27 2000
@@ -0,0 +1,842 @@
+<?
+ if($save && $user && $pw) {
+ SetCookie("MAGIC_COOKIE",base64_encode("$user:$pw"),time()+3600*24*12,'/');
+ }
+
+/* See the end of the script for the table layout. */
+
+require("shared.inc");
+if (strstr($MYSITE,"bugs.php.net")) {
+ $dbhost="localhost";
+ $dbuser="nobody";
+ $dbpwd="";
+} else if (strstr($MYSITE,"il.php.net")) {
+ $dbhost="bugs.php.net";
+ $dbuser="bourbon";
+ $dbpwd="";
+} else if (strstr($MYSITE,"localhost")) {
+ $dbhost="localhost";
+ $dbuser="nobody";
+ $dbpwd="";
+} else {
+ Header("Location: http://bugs.php.net");
+ exit;
+}
+
+$DISABLE_KICKOUTS=1;
+commonHeader("Bug Reporting");
+echo "<font size=-1>\n";
+$destination = "php-dev@lists.php.net";
+#$destination = "zak@php.net";
+
+function indent($string, $prefix) {
+ $string = ereg_replace(13, "", $string); /* get rid of Ctrl-M */
+ return $prefix . ereg_replace("\n", "\n$prefix", $string) . "\n";
+}
+
+function wrap($text,$margin=72) {
+ $i=0;
+ $last_space=0;
+ $printfrom=0;
+ $len=strlen($text);
+ $line_len=0;
+ while($i<$len) {
+ if($text[$i]==chr(32) || $text[$i]==chr(7)) {
+ $last_space=$i;
+ $line_len++;
+ } else
+ if($text[$i]==chr(10) || $text[$i]==chr(13)) {
+ $line_len=0;
+ } else {
+ $line_len++;
+ }
+ if($line_len>$margin) {
+ if($last_space==0 || $last_space<$printfrom) {
+ echo substr($text,$printfrom,$margin);
+ echo "\n";
+ $printfrom+=$margin+1;
+ } else {
+ echo substr($text,$printfrom,$last_space-$printfrom);
+ echo "\n";
+ $printfrom=$last_space+1;
+ }
+ $line_len=0;
+ }
+ $i++;
+ }
+ echo substr($text,$printfrom);
+}
+
+function list_ids($current) {
+ global $dbhost,$dbuser,$dbpwd;
+ mysql_connect($dbhost,$dbuser,$dbpwd) or die("Unable to connect to SQL server.");
+ $result = mysql_db_query('php3', "select distinct dev_id from bugdb where dev_id
not like '%@%' and dev_id not like '%.%' and php_version like '4%'
order by dev_id");
+ if($current) echo "<option>$current\n";
+ echo "<option>Any\n";
+ while($row = mysql_fetch_row($result)) {
+ if($row[0]!=$current) echo "<option>".$row[0]."\n";
+ }
+}
+
+function show_state_options($state, $show_all, $user_mode=0) {
+ if ($state) { echo "<option>$state\n"; }
+ if($state!="Open") { echo "<option>Open\n"; }
+ if($state!="Closed") { echo "<option>Closed\n"; }
+ if($state!="Assigned" && $user_mode!=2) { echo
"<option>Assigned\n"; }
+ if($state!="Analyzed" && $user_mode!=2) { echo
"<option>Analyzed\n"; }
+ if($state!="Suspended" && $user_mode!=2) { echo
"<option>Suspended\n"; }
+ if($state!="Feedback") { echo "<option>Feedback\n"; }
+ if($state!="OldFeedback") { echo "<option>OldFeedback\n"; }
+ if($state!="Duplicate") { echo "<option>Duplicate\n"; }
+ if($state!="All" && $show_all) { echo "<option>All\n"; }
+}
+
+function show_menu($state)
+{
+ global $PHP_SELF, $bug_type, $by;
+
+ if(!isset($bug_type)) { $bug_type="Any"; }
+ echo "<form method=POST action=\"$PHP_SELF\">\n";
+ echo "<input type=hidden name=cmd value=\"Display Bugs\">\n";
+ echo "<table bgcolor=#aabbcc cellspacing=0><tr><td><input type=submit
value=\"Display\"></td><td><select
name=\"status\">\n";
+ show_state_options($state, 1);
+ echo "</select></td><td align=right>bugs of type:
</td><td>";
+ show_types($bug_type,1,"bug_type");
+
+ $fields = array( "id" => "Bug ID",
+ "bug_type" => "Bug Type",
+ "email" => "Email address",
+ "sdesc" => "Short Description",
+ "ldesc" => "Long Description",
+ "php_version" => "PHP Version",
+ "php_os" => "Platform",
+ "status" => "Status",
+ "comments" => "Comments",
+ "ts1" => "Opened",
+ "assign" => "Assigned To");
+
+ reset($fields);
+ echo "</td><td align=right>Last Comment By:</td><td> <select
name=\"by\">\n";
+ list_ids($by);
+ echo "</select></td></tr>\n";
+ echo "<tr><td colspan=3 align=right>Where the bug description
contains:</td>\n";
+ echo "<td colspan=3><input type=text
name=\"search_for\"></td></tr></form>\n";
+ echo "<tr><td colspan=3 align=right><form method=GET
action=\"$PHP_SELF\">\n";
+ echo "<input type='submit' value='Edit'> bug
number:</td><td colspan=2><input type='text'
name='id'></td>\n";
+ echo "<input type='hidden' name='edit'
value='1'>\n";
+ echo "</td><td><a
href=\"bugstats.php\">Statistics</a></td></tr></table>";
+ echo "<i>Feature/Change requests must be explicitly selected to be
shown</i></form>\n";
+}
+
+### show_types signifigantly modified by j.a.greant 00/09/05
+### show_types signifigantly modified by sterling hughes 00/09/06
+function show_types($first_item, $show_any, $var_name) {
+ $items = array('Any',
+ 'General Issues' =>
+ array('Feature/Change Request',
+ 'Documentation Problem',
+ 'Reproducible Crash',
+ 'Scripting Engine Problem',
+ 'Performance Problem'),
+ 'Installation and Configuration' =>
+ array('Compile Problem' =>
+ array('Compile Failure',
+ 'Compile Warning'),
+ 'Web Server Problem' =>
+ array('Apache Related',
+ 'IIS Related',
+ 'PWS Related',
+ 'Other web server'),
+ 'Configuration Issues' =>
+ array('Dynamic Loading Related',
+ 'PHP options and information functions')
+ ),
+ 'Function Specific' =>
+ array (
+ 'Calendar Functions' =>
+ array('Calendar Extension Related',
+ 'ICAP Related',
+ 'MCAL Related'),
+ 'Directory/Filesystem Functions' =>
+ array('Directory Related',
+ 'Filesystem Related'),
+ 'Directory Services Functions' =>
+ array('YP/NIS Related',
+ 'LDAP Related'),
+ 'Database Functions' =>
+ array('Adabas-D Related',
+ 'dBase Related',
+ 'DBM/DBA Related',
+ 'filePro Related',
+ 'Hyperwave Related',
+ 'Informix Related',
+ 'Interbase Related',
+ 'Sybase-ct (ctlib) functions',
+ 'Sybase (dblib) functions',
+ 'mSQL Related',
+ 'MSSQL Related',
+ 'MySQL Related',
+ 'ODBC Related',
+ 'Oracle Related',
+ 'PostgreSQL Related',
+ 'Solid Related'),
+ 'Data Exchange Functions' =>
+ array('WDDX Related',
+ 'YAZ Related'),
+ 'Extensibility Functions' =>
+ array('COM Related',
+ 'POSIX Related',
+ 'Program Execution Related',
+ 'Sephamore Related',
+ 'Sattelite CORBA Related',
+ 'Readline Related'),
+ 'E-commerce Functions' =>
+ array('Cybercash Related',
+ 'CCVS Related',
+ 'Versign Payflow Pro Related'),
+ 'Graphics Functions' =>
+ array('GD Related',
+ 'SWF Related'),
+ 'Languages/Translation Functions' =>
+ array('Aspell Related',
+ 'Gettext Related',
+ 'Pspell Related',
+ 'Recode Related'),
+ 'Mail Functions' =>
+ array('IMAP Related',
+ 'Mail Function Related',
+ 'Vmailmgr Related'),
+ 'Math Functions' =>
+ array('BC Math Related'),
+ 'Encryption Functions' =>
+ array('Crypt Related',
+ 'Mcrypt Related',
+ 'Mhash Related'),
+ 'Network Functions' =>
+ array('FTP Related',
+ 'HTTP Related',
+ 'SNMP Related',
+ 'Sockets Related'),
+ 'Output Control Functions',
+ 'PDF Functions' =>
+ array('ClibPDF Related',
+ 'FDF Related',
+ 'PDFLib Related'),
+ 'Data Structure Functions' =>
+ array('Array Related',
+ 'Class/Object Related',
+ 'String Related',
+ 'Variable Related'),
+ 'Regular Expression Functions' =>
+ array('PCRE Related',
+ 'Regexps Related'),
+ 'Session Functions',
+ 'XML Functions' =>
+ array('DOM XML Related',
+ 'Sablotron XSL Related',
+ 'XML Related'),
+ 'URL Functions' =>
+ array('CURL Related',
+ 'URL Related'),
+ 'Zlib Related',
+ 'Unknown/Other Function'
+ )
+ );
+
+ $selected[$first_item] = ' SELECTED';
+
+ echo "<select name=\"$var_name\">\n";
+ foreach ($items as $topic => $subtopics) {
+ if (!$show_any && $topic == 'Any') {
+ continue;
+ }
+
+ if (!is_array ($subtopics)) {
+ _types_display_entry($subtopics, $selected, 0);
+ continue;
+ }
+ _types_display_entry ($topic, $selected, 0);
+ _types_show_subtopics ($subtopics, $selected, 1);
+ }
+ echo "</select>";
+}
+
+function _types_display_entry ($text, $selected, $level)
+{
+ $indent = " ";
+
+ echo "<option value=\"$text\" $selected[$text]>";
+ for ($i = 0; $i < $level; $i++) {
+ print $indent;
+ }
+ echo "$text</option>";
+}
+
+function _types_show_subtopics ($subtopics, $selected, $level = 0)
+{
+ foreach ($subtopics as $heading => $subheadings) {
+ if (!is_array ($subheadings)) {
+ _types_display_entry ($subheadings, $selected, $level);
+ continue;
+ }
+
+ _types_display_entry ($heading, $selected, $level);
+ _types_show_subtopics ($subheadings, $selected, $level+1);
+ }
+}
+
+function find_password($user) {
+ $fp=@fopen("/repository/CVSROOT/passwd","r");
+ if (!$fp) {
+ return ("");
+ }
+ while(!feof($fp)) {
+ $line=fgets($fp,120);
+ list($luser,$passwd,$junk) = explode(":",$line);
+ if($user==$luser) {
+ fclose($fp);
+ return($passwd);
+ }
+ }
+ fclose($fp);
+ return("");
+}
+
+function addlinks($text) {
+ $text = htmlspecialchars($text);
+ $new_text = ereg_replace("(http:[^ \n\t]*)","<a
href=\"\\1\">\\1</a>",$text);
+ $new_text = ereg_replace("(ftp:[^ \n\t]*)","<a
href=\"\\1\">\\1</a>",$text);
+ $new_text = ereg_replace("[.,]-=-\"","\"",$new_text);
+ $new_text = ereg_replace("-=-\"","\"",$new_text);
+ return $new_text;
+}
+
+if (isset($cmd) && $cmd == "Send bug report") {
+ if(!ereg("@",$email)) {
+ echo "ERROR! Please provide a valid email address<P>\n";
+ commonFooter();
+ exit;
+ }
+
+ if($ebug_type=="--Please Select--") {
+ echo "ERROR! Please select an appropriate bug type<P>\n";
+ commonFooter();
+ exit;
+ }
+
+ if ($php_version=='earlier') {
+ echo "ERROR! Please select a valid PHP version. If your PHP version is too old, please
upgrade first and see if the problem has not already been fixed.";
+ commonFooter();
+ exit;
+ }
+
+ show_menu($status);
+ echo "<hr>\n";
+
+ mysql_connect($dbhost,$dbuser,$dbpwd) or die("Unable to connect to SQL server.");
+ mysql_select_db("php3");
+ $ts=date("Y-m-d H:i:s");
+ $ret = mysql_query("INSERT into bugdb values
(0,'$ebug_type','$email','$sdesc','$ldesc','$php_version','$php_os','Open','','$ts','$ts','','','$passwd')");
+ $cid = mysql_insert_id();
+
+ $report = "";
+ echo("<pre>\n");
+
+ $ldesc = stripslashes($ldesc);
+ $sdesc = stripslashes($sdesc);
+ $report .= "From: $email\n";
+ $report .= "Operating system: $php_os\n";
+ $report .= "PHP version: $php_version\n";
+ $report .= "PHP Bug Type: $ebug_type\n";
+ $report .= "Bug description: ";
+ $html_sdesc = ereg_replace("<", "<", $sdesc);
+ $html_sdesc = ereg_replace(">", ">", $html_sdesc);
+ $report .= $html_sdesc."\n\n";
+ $ascii_report = indent($report.$ldesc,"");
+ $html_desc = ereg_replace("<", "<", $ldesc);
+ $html_desc = ereg_replace(">", ">", $html_desc);
+ $report .= $html_desc."\n";
+
+ $html_report = ereg_replace("<", "<", $report);
+ $html_report = ereg_replace(">", ">", $html_report);
+
+ echo wrap($html_report);
+ echo("</pre>\n");
+
+ if (Mail($destination, "PHP 4.0 Bug #$cid: $sdesc", $ascii_report, "From:
$email")) {
+ echo "<p><h2>Mail sent to $destination...</h2>\n";
+ echo "Thank you for your help!<P>";
+ echo "<i>The password for this report is</i>:
<b>".htmlentities($passwd)."</b><br>";
+ echo "If the status of the bug report you submitted\n";
+ echo "changes, you will be notified. You may return here and check on the status\n";
+ echo "or update your report at any time. The URL for your bug report is: <a
href=\"http://bugs.php.net/?id=$cid\">";
+ echo "http://bugs.php.net/?id=$cid</a>\n";
+ } else {
+ echo("<p><h2>Mail not sent!</h2>\n");
+ echo("Please send this page in a mail to " .
+ "<a href=\"mailto:$email\">$email</a> manually.\n");
+ }
+
+} elseif(isset($cmd) && $cmd=="Display Bugs") {
+ show_menu($status);
+ echo "<hr>\n";
+
+ include("table_wrapper.inc");
+
+ function external_processing($fieldname,$tablename,$data,$row)
+ {
+ switch($fieldname) {
+ case "id":
+ print "<a href=\"bugs.php?id=$data\">$data</a>\n";
+ break;
+ case "Originator":
+ print "<a href=\"mailto:$data\">$data</a>\n";
+ break;
+ case "Mod":
+ print "<a href=\"bugs.php?id=${row[id]}&edit=1\"><img
src=\"gifs/circular_arrow.gif\" border=\"0\"></a>\n";
+ break;
+
+ case "Status":
+ if ($data == "Feedback") {
+ echo "Feedback<br>(".$row[unchanged_days]." days)";
+ break;
+ }
+ /* otherwise fall through */
+
+ default:
+ $data = ereg_replace("<","<",$data);
+ $data = ereg_replace(">",">",$data);
+ print $data;
+ break;
+ }
+ }
+ function row_coloring($row) {
+ if ($row["bug_type"]=="Feature/Change Request") {
+ return "#aaaaaa";
+ }
+ switch($row["Status"]) {
+ case "Open":
+ return "#ffbbaa";
+ break;
+ case "Closed":
+ return "#aaffbb";
+ break;
+ case "Suspended":
+ return "#ffccbb";
+ break;
+ case "Assigned":
+ return "#bbaaff";
+ break;
+ case "Feedback":
+ return "#bbeeff";
+ break;
+ case "Analyzed":
+ return "#99bbaa";
+ break;
+ case "Duplicate":
+ return "#bbbbbb";
+ break;
+ default:
+ return "#aaaaaa";
+ break;
+ }
+ }
+ $external_processing_function="external_processing";
+ $row_coloring_function="row_coloring";
+
+ mysql_connect($dbhost,$dbuser,$dbpwd) or die("Unable to connect to SQL server");
+ mysql_select_db("php3");
+
+ $tables[] = "bugdb";
+ $fields[] = "id";
+ $fields[] = "bug_type";
+ $fields[] = "status as Status";
+ $fields[] = "assign as Assigned";
+ $fields[] = "php_version as Version";
+# $fields[] = "php_os as OS";
+ $fields[] = "php_os as Platform";
+ $fields[] = "sdesc as Description";
+ $fields[] = "id as Mod";
+ $fields[] = "TO_DAYS(NOW())-TO_DAYS(ts2) as unchanged_days";
+ $conversion_table["id"] = "ID#";
+ $conversion_table["bug_type"] = "Bug Type";
+ $pass_on = ereg_replace("
","+","&cmd=Display+Bugs&status=$status&bug_type=$bug_type");
+ $default_header_color="aaaaaa";
+ $centering["id"] = $centering["Mod"] = "center";
+ $dont_link["Mod"]=1;
+ $dont_display["unchanged_days"] = 1;
+
+ if (!isset($order_by_clause)) {
+ $order_by_clause = "id";
+ }
+ if($status=="All" && $bug_type=="Any") {
+ $where_clause = "bug_type!='Feature/Change Request'";
+ /* nothing */
+ } elseif($status=="All" && $bug_type!="Any") {
+ $where_clause = "bug_type='$bug_type'";
+ } else {
+ if($bug_type=="Any") {
+ $where_clause = "bug_type!='Feature/Change Request'";
+ } else {
+ $where_clause = "bug_type='$bug_type'";
+ }
+
+ /* Treat assigned and analyzed bugs as open */
+
+ if($status=="Open") {
+ $where_clause .= " and (status='Open' or status='Assigned' or
status='Analyzed')";
+ } elseif($status=="OldFeedback") {
+ $where_clause .= " and status='Feedback' and
TO_DAYS(NOW())-TO_DAYS(ts2)>60";
+ } else {
+ $where_clause .= " and status='$status'";
+ }
+ }
+ if(strlen($search_for)) {
+ $where_clause .= " and (sdesc like '%$search_for%' or ldesc like
'%$search_for%' or comments like '%$search_for%')";
+ }
+ if (strlen($where_clause)) {
+ $where_clause .= " and";
+ }
+ $where_clause .= " php_version like '4%'";
+ if(strlen($by) and $by!='Any') $where_clause .= " and dev_id = '$by'
";
+ table_wrapper();
+ echo "<br><center><a href=\"$PHP_SELF\">Submit a Bug
Report</a></center>\n";
+} else if(!isset($cmd) && isset($id)) {
+
+ ### Change made by j.a.greant 00/09/03
+ function get_old_comments ($bug_id)
+ {
+ $divider =
'---------------------------------------------------------------------------';
+ $max_message_length = 10 * 1024;
+
+ #fetch comments
+ $result = mysql_query ("SELECT ts, email, comment from bugdb_comments where bug = $bug_id
order by ts desc");
+ while ($temp = mysql_fetch_row ($result)) # $result should always be valid, suppress error just
in case.
+ $comments[] = $temp;
+
+ if ($comments[0])
+ unset ($comments[0]); # Ditch the most recent comment
+
+ #fetch original bug description
+ $query = "SELECT ts1, email, ldesc from bugdb where id=$bug_id";
+ $result = mysql_query ($query);
+ $comments[] = mysql_fetch_row ($result);
+
+ foreach ($comments as $value)
+ {
+ $output .= "[$value[0]] $value[1]\n$value[2]\n\n$divider\n\n";
+ if (strlen ($output) > $max_message_length)
+ {
+ $output .= "The remainder of the comments for this report are over the " . round
($max_message_length/1024) . "k message limit. To view the remainder of the comments, please
review the bug report online.";
+ break;
+ }
+ }
+
+ if ($output)
+ return "\n\nPrevious Comments:\n\n" . $output;
+ }
+
+ show_menu($status);
+ echo "<hr>\n";
+
+ mysql_connect($dbhost,$dbuser,$dbpwd)
+ or die("Unable to connect to SQL server.");
+ mysql_select_db("php3");
+
+ /* HANDLE NORMAL DEVELOPER UPDATES */
+ if(isset($modify) && $modify=="Edit Bug") {
+ $ok=0;
+ if($user!="cvsread") {
+ $psw=find_password($user);
+ if(strlen($psw)>0) {
+ if(crypt($pw,substr($psw,0,2))==$psw) {
+ $ts=date("Y-m-d H:i:s");
+ mysql_query("UPDATE bugdb set status='$estatus',
bug_type='$ebug_type', assign='$eassign', comments='$comments',
ts2='$ts', dev_id='$user' where id=$id");
+ if (!empty($ncomment)) {
+ mysql_query("INSERT INTO bugdb_comments (bug, email, ts, comment) VALUES
($id,'".$user."@php.net','$ts','$ncomment')");
+ }
+ $ok=1;
+ }
+ }
+ }
+ if(!$ok) {
+ echo "<b>Sorry, incorrect user id/password pair.</b><br>\n";
+ Mail("rasmus@lerdorf.on.ca", "bugdb auth failure for $user/$pw",
"", "From: bugdb");
+ } else {
+ echo "<b>Database updated!</b><br>\n";
+
+ $text = "ID: $id\nUpdated by: $user\nReported By: $eemail\nStatus: $estatus\nBug Type:
$ebug_type\nAssigned To: $eassign\nComments:\n\n$ncomment" . get_old_comments ($id);
+ $text .= "\nFull Bug description available at: http://bugs.php.net/?id=$id\n";
+ $text = stripslashes($text);
+ $esdesc = stripslashes($esdesc);
+
+ /* mail bug originator */
+ Mail($eemail, "PHP 4.0 Bug #$id Updated: $esdesc", $text, "From: Bug Database
<$destination>");
+ Mail($destination, "PHP 4.0 Bug #$id Updated: $esdesc", $text, "From: Bug
Database <$destination>");
+ }
+ }
+
+ /* HANDLE USER UDPATES */
+ if(isset($modify) && $modify=="User Edit Bug") {
+ $ts=date("Y-m-d H:i:s");
+ $result = mysql_query("select status, bug_type, ldesc, php_version, php_os from bugdb where
id=$id and passwd='$pw'");
+ $ok=mysql_numrows($result);
+ if(!$ok) {
+ echo "<b>Sorry, incorrect password. The entry has not been
changed.</b><br>\n";
+ Mail("rasmus@lerdorf.on.ca", "bugdb auth failure for bug #$id - ($pw)",
"", "From: bugdb");
+ } else {
+ $row=mysql_fetch_row($result);
+
+ /* update bug record */
+ if($estatus=="Closed" and $row[0]!="Closed")
+ mysql_query("UPDATE bugdb set status='$estatus',
bug_type='$ebug_type', php_version='$ephp_version', php_os='$ephp_os',
ts2='$ts', dev_id='$eemail' where id=$id");
+ else
+ mysql_query("UPDATE bugdb set status='$estatus',
bug_type='$ebug_type', php_version='$ephp_version', php_os='$ephp_os',
ts2='$ts' where id=$id");
+
+ /* add comment */
+ if (!empty($ncomment)) {
+ mysql_query("INSERT INTO bugdb_comments (bug, email, ts, comment) VALUES
($id,'$eemail','$ts','$ncomment')");
+ }
+
+ echo "<b>Database updated!</b><br>\n";
+
+ $text = "ID: $id\nUser Update by: $eemail\n";
+ if($estatus!=$row[0]) $text .= "Old-Status: ".$row[0]."\n";
+ $text .= "Status: $estatus\n";
+ if($ebug_type != $row[1]) $text .= "Old-Bug Type: ".$row[1]."\n";
+ $text .= "Bug Type: $ebug_type\n";
+ $text .= "Description: $esdesc\n\n$ncomment";
+ $text .= get_old_comments ($id);
+ $text .= "\nFull Bug description available at: http://bugs.php.net/?id=$id\n";
+ $text = stripslashes($text);
+ $esdesc = stripslashes($esdesc);
+ Mail($eemail, "PHP 4.0 Bug #$id Updated: $esdesc", $text, "From: Bug Database
<$destination>");
+ Mail($destination, "PHP 4.0 Bug #$id Updated: $esdesc", $text, "From: Bug
Database <$destination>");
+ mysql_freeresult($result);
+ }
+ }
+
+ /* DISPLAY BUG */
+ $result = mysql_query("SELECT * from bugdb where id=$id");
+ if($result and mysql_numrows($result)>0) {
+ $row = mysql_fetch_row($result);
+ echo "<br><h1>Bug id #$id</h1>\n";
+ echo "<table>\n";
+ if(!isset($edit)) {
+ echo "<tr><th
align=right>Status:</th><td>".$row[7]."</td>";
+ echo "<td><a href=\"$PHP_SELF?id=$id&edit=2\"><font
size=-1><tt>Modify</tt></font></a></td>";
+ } else {
+ echo "<form method=POST action=\"http://bugs.php.net$PHP_SELF?id=$id\">\n";
+ if($edit==1)
+ echo "<input type=hidden name=modify value=\"Edit Bug\">\n";
+ else
+ echo "<input type=hidden name=modify value=\"User Edit Bug\">\n";
+ echo "<tr><th align=right>Status:</th><td><select
name=\"estatus\">\n";
+ show_state_options($row[7], 0, ($edit==2)?2:0);
+ echo "</select>\n";
+ if($edit==1)
+ {
+ echo "Assign to: <input type=text name=eassign
value=\"$row[12]\">\n";
+ echo "<input type=submit value=\"Commit Changes\">\n";
+ }
+ }
+ echo "</tr>\n";
+ echo "<tr><th align=right>From:</th><td><a href=\"mailto:".$row[2]."\">".$row[2]."</a>";
+ echo "<input type=hidden name=eemail
value=\"$row[2]\"></td></tr>\n";
+ echo "<tr><th
align=right>Date:</th><td>".$row[9]."</td></tr>\n";
+ if(!isset($edit)) {
+ echo "<tr><th
align=right>Type:</th><td>".$row[1]."</td></tr>\n";
+ } else {
+ echo "<tr><th align=right>Type:</th><td>\n";
+ show_types($row[1],0,"ebug_type");
+ echo "</td></tr>\n";
+ }
+ if($edit==2) {
+ echo "<tr><th align=right>OS:</th><td><input type=text size=20
name=ephp_os value=\"".$row[6]."\"></td></tr>\n";
+ } else {
+ echo "<tr><th
align=right>OS:</th><td>".$row[6]."</td></tr>\n";
+ }
+ if($edit==2 ||$edit == 1) {
+ echo "<tr><th align=right>PHP Version:</th><td><input type=text
size=20 name=ephp_version
value=\"".$row[5]."\"></td></tr>\n";
+ } else {
+ echo "<tr><th align=right>PHP
Version:</th><td>".$row[5]."</td></tr>\n";
+ }
+ echo "<tr><th align=right>Assigned
To:</th><td>".$row[12]."</td></tr>\n";
+ $sd = ereg_replace("<","<",$row[3]);
+ $sd = ereg_replace(">",">",$sd);
+ echo "<tr><th align=right>Short
Desc.:</th><td></b>$sd<input type=hidden name=esdesc value=\"",
htmlspecialchars($row[3]), "\"></td></tr>\n";
+ echo "</table>\n";
+
+ /* INSERT NEW COMMENT HERE */
+ if (isset($edit)) {
+ echo "<b>New Comment:</b><br>\n";
+ echo "<textarea cols=60 rows=15 name=\"ncomment\"
wrap=physical></textarea><br>\n";
+ if(isset($MAGIC_COOKIE)) list($user, $pw) = explode(":",
base64_decode($MAGIC_COOKIE));
+ if ($edit == 1) {
+ echo "CVS user id: <input type=text size=10 name=user
value=\"$user\">\n";
+ }
+ echo "Password: <input type=password size=10 name=pw
value=\"$pw\">\n";
+ echo "<input type=submit value=\"Commit Changes\"><br>\n";
+ if(!$user || !$pw) {
+ echo "Remember my login/password: <input type=checkbox name=save>\n";
+ }
+ echo "</form>\n";
+ }
+
+ echo "<hr>\n";
+
+ /* ORIGINAL REPORT */
+ echo "<b><i>[".$row[9]."]
".$row[2]."</i></b><br>\n";
+ $text = addlinks($row[4]);
+ echo "<blockquote><blockquote><pre>";
+ echo wrap($text,90);
+ echo "</pre></blockquote></blockquote>\n";
+
+ /* OLD-STYLE DEVELOPER COMMENT */
+ if(strlen($row[8])) {
+ echo "<b><i>[".$row[10]."]
".$row[11]."</i></b><br>\n";
+ $text=addlinks($row[8]);
+ echo "<blockquote><blockquote><pre>";
+ wrap($text,90);
+ echo "</pre></blockquote></blockquote>\n";
+ }
+
+ /* NEW-STYLE COMMENTS */
+ $query = "SELECT *,UNIX_TIMESTAMP(ts) AS my_when FROM bugdb_comments WHERE bug=$id ORDER BY
ts";
+ if ($comresult = mysql_query($query)) {
+ while ($com = mysql_fetch_array($comresult)) {
+ echo "<b><i>[".$com['ts']."]
".$com['email']."</i></b><br>\n";
+ $text = addlinks($com['comment']);
+ echo "<blockquote><blockquote><pre>";
+ wrap($text,90);
+ echo "</pre></blockquote></blockquote>\n";
+ }
+ mysql_freeresult($comresult);
+ }
+
+ } else {
+ echo "<br><h1>Sorry bug id #$id does not exist</h1>\n";
+ }
+ if ($result) {
+ mysql_freeresult($result);
+ }
+} else {
+ show_menu($status);
+?>
+Or use the form below to submit a new bug report.
+<hr>
+<form method=POST action="<? echo $PHP_SELF;?>">
+<input type=hidden name=cmd value="Send bug report">
+
+<p><strong>Please read the <a href="bugs-dos-and-donts.php">Dos &
Don'ts</a> before submitting a bug report!</strong</p>
+<p><strong>To report bugs in PHP 3.0, please go <a href="http://bugs.php.net/bugs-php3.php">here</a>.</strong></p>
+
+<table>
+ <tr>
+ <th align=right>Your email address:</th>
+ <td colspan="2">
+ <input type=text size=20 name="email" value="<?if(isset($email)) { echo
$email; }?>">
+ </td>
+ </tr><tr>
+ <th align=right>PHP version:</th>
+ <td>
+ <select name="php_version">
+ <option name="4.0.2">4.0.2
+ <option name="4.0.1pl2">4.0.1pl2
+ <option name="4.0.1">4.0.1
+ <option name="4.0.0">4.0.0
+ <option name="4.0CVS-<? print date("d/m/Y"); ?>">4.0 Latest CVS
(<? print date("d/m/Y"); ?>)
+ <option name="earlier">Earlier? Upgrade first!
+ </select>
+ </td>
+ </tr><tr>
+ <th align=right>Type of bug:</th>
+ <td colspan="2">
+ <?show_types("--Please Select--",0,"ebug_type")?>
+ </td>
+ </tr><tr>
+ <th align=right>Operating system:</th>
+ <td colspan="2">
+ <input type=text size=20 name="php_os" value="<?echo
isset($operating_system)?$operating_system:"";?>">
+ </td>
+ </tr><tr>
+ <th align=right>Bug description:</th>
+ <td colspan="2">
+ <input type=text size=40 maxlength=79 name="sdesc">
+ </td></tr>
+ </tr><tr>
+ <th align=right>Password:</th>
+ <td>
+ <input type=text size=20 maxlength=20 name="passwd"></td>
+ <td><font size="-2">
+You may enter any password here. This password allows you to come back and modify your
+submitted bug report at a later date.
+ </font>
+ </td></tr>
+</table>
+
+<table>
+<tr>
+<td valign="top">
+Please supply any information that may be helpful in fixing the bug:
+<ul>
+ <li>A short script that reproduces the problem
+ <li>The list of modules you compiled PHP with (your configure line)
+ <li>A copy of your php.ini file (if it might be relevant)
+ <li>Any other information unique or specific to your setup
+</ul>
+<center>
+<input type=submit value="Send bug report">
+</center>
+</td>
+<td>
+<textarea cols=60 rows=15 name="ldesc" wrap=physical></textarea>
+</td>
+</tr>
+</table>
+
+<p>
+
+</form>
+
+<? } ?>
+</font>
+<?
+commonFooter();
+?>
+<?
+/*
+# MySQL dump 4.0
+#
+# Host: localhost Database: php3
+#--------------------------------------------------------
+DROP table bugdb;
+
+CREATE TABLE bugdb (
+ id int(8) NOT NULL AUTO_INCREMENT,
+ bug_type char(32),
+ email varchar(40) NOT NULL,
+ sdesc varchar(80),
+ ldesc text,
+ php_version char(16),
+ php_os varchar(32),
+ status varchar(16),
+ comments text,# developer comment (deprecated)
+ ts1 datetime, # bug created date
+ ts2 datetime, # developer comment date (deprecated)
+ dev_id varchar(16),# developer who commented (deprecated)
+ assign varchar(16),
+ passwd varchar(20),# user password
+ PRIMARY KEY (id)
+);
+
+CREATE TABLE bugdb_comments (
+ id int(8) NOT NULL AUTO_INCREMENT,
+ bug int(8) NOT NULL,
+ email varchar(40) NOT NULL,
+ ts datetime NOT NULL,
+ comment text,
+ PRIMARY KEY (id)
+);
+*/
+?>