cvs: phpweb / mod_bugs.php

From: 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 = "&nbsp;&nbsp;&nbsp;&nbsp;"; + + 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("<", "&lt;", $sdesc); + $html_sdesc = ereg_replace(">", "&gt;", $html_sdesc); + $report .= $html_sdesc."\n\n"; + $ascii_report = indent($report.$ldesc,""); + $html_desc = ereg_replace("<", "&lt;", $ldesc); + $html_desc = ereg_replace(">", "&gt;", $html_desc); + $report .= $html_desc."\n"; + + $html_report = ereg_replace("<", "&lt;", $report); + $html_report = ereg_replace(">", "&gt;", $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("<","&lt;",$data); + $data = ereg_replace(">","&gt;",$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("<","&lt;",$row[3]); + $sd = ereg_replace(">","&gt;",$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) +); +*/ +?>

« previous php.mirrors (#1997) next »