Annotation of cdn/www/bug.html, revision 1.19

1.1       cdn         1: <h5 class="page-header">Bugs</h5>
                      2: 
                      3: <ul>
                      4: <li>Enter a 
                      5: <a href="http://www.mozdev.org/bugs/enter_bug.cgi?product=cdn">new bug</a>
                      6:  for cdn
                      7: </li>
1.6       cdn         8: <li>View <a href="http://mozdev.org/bugs/buglist.cgi?email1=&amp;emailtype1=substring&amp;emailassigned_to1=1&amp;email2=&amp;emailtype2=substring&amp;emailreporter2=1&amp;bugidtype=include&amp;bug_id=&amp;changedin=&amp;votes=&amp;chfieldfrom=&amp;chfieldto=Now&amp;chfieldvalue=&amp;product=cdn&amp;short_desc=&amp;short_desc_type=allwordssubstr&amp;long_desc=&amp;long_desc_type=allwordssubstr&amp;bug_file_loc=&amp;bug_file_loc_type=allwordssubstr&amp;field0-0-0=noop&amp;type0-0-0=noop&amp;value0-0-0=&amp;cmdtype=doit&amp;order=Bug+Number">all bugs</a> 
                      9: <li>See all <a href="http://mozdev.org/bugs/buglist.cgi?bug_status=UNCONFIRMED&amp;bug_status=NEW&amp;bug_status=ASSIGNED&amp;bug_status=REOPENED&amp;email1=&amp;emailtype1=substring&amp;emailassigned_to1=1&amp;email2=&amp;emailtype2=substring&amp;emailreporter2=1&amp;bugidtype=include&amp;bug_id=&amp;changedin=&amp;votes=&amp;chfieldfrom=&amp;chfieldto=Now&amp;chfieldvalue=&amp;product=cdn&amp;short_desc=&amp;short_desc_type=allwordssubstr&amp;long_desc=&amp;long_desc_type=allwordssubstr&amp;bug_file_loc=&amp;bug_file_loc_type=allwordssubstr&amp;field0-0-0=noop&amp;type0-0-0=noop&amp;value0-0-0=&amp;cmdtype=doit&amp;order=Bug+Number">open bugs</a></li>
1.1       cdn        10: <li>Search by Bug Number<br><br>
1.6       cdn        11: <form action="http://mozdev.org/bugs/show_bug.cgi" method="get"><input type="submit" value="Find">
                     12: <input size="6" name="id"></form>
1.1       cdn        13: </li>
1.18      cdn        14: </ul><?php $doNotCapitalise = 01; $project='mozdev'; $project = 'optimoz'; 
                     15: 
                     16: $bug_component = array('gestures', 'radial');
                     17: 
                     18: ?>
1.1       cdn        19: 
                     20: <?php
                     21: 
1.18      cdn        22: // $Id: bug.html,v 1.17 2003/03/02 15:03:55 cdn Exp $
1.1       cdn        23: 
                     24:   require(PHP_INC.CONNECT);
                     25: 
                     26:   $id             = "bug_id";
                     27:   $desc           = "short_desc";
                     28:   $res            = "resolution";
                     29:   $table          = "bugs";
                     30:   $target         = "product";
1.12      cdn        31:   $amount         = 60;
1.1       cdn        32:   $bug_url        = "http://mozdev.org/bugs/show_bug.cgi?id=";
                     33: 
1.2       cdn        34:   $component      = 'component';      
                     35:   
1.1       cdn        36:   $product        = ucwords($project);
                     37: 
1.6       cdn        38:   $query          = " SELECT $id, $desc, $component, $res
1.1       cdn        39:                       FROM $table
1.6       cdn        40:                       WHERE $target='$product'
1.19    ! cdn        41:                       AND $component LIKE '%" . $bug_component[1] . "%'
1.16      cdn        42:                       ORDER BY $id DESC
1.6       cdn        43:                       LIMIT $amount
1.1       cdn        44:                     ";
                     45: 
                     46:   $my_result      = mysql_query($query, $connect);
                     47: 
                     48:   $e              = mysql_error();
                     49:   if($e)
                     50:     print  "ERROR:latest_bugs: $e"; 
                     51: 
                     52:   $row            = mysql_num_rows($my_result);
                     53: 
1.2       cdn        54:   if ( $doNotCapitalise )
                     55:     $product = $project;
                     56:   
1.9       cdn        57:   print '<h4 id="BZ-h4">Latest bugs filed for ' . $product . "</h4>\n\n";
1.6       cdn        58: 
                     59:   print '<table cellspacing="2" cellpadding="2" border=0>' . "\n";
                     60: 
1.1       cdn        61:   print "<thead>\n<tr>\n";
1.3       cdn        62:   print '<th bgcolor="#990000"><font color="#ffffff">Bug #</font></th>';
                     63:   print '<th bgcolor="#FF9900">Component</th>' . "\n\n";
1.2       cdn        64:   print '<th bgcolor="#FF9900">Description</th>' . "\n\n";
1.1       cdn        65:   print "</tr>\n</thead>\n";
1.2       cdn        66: 
1.1       cdn        67:   print "<tbody>\n";
                     68:   for($i=0; $i<$row; $i++) {
                     69:     $printstrike = false;
                     70:     print "<tr>\n<td>\n";
                     71:     $bug_id =  mysql_result($my_result, $i, $id);
                     72:     $strike =  mysql_result($my_result, $i, $res);
                     73:     if ($strike == "FIXED" || $strike == "INVALID" || $strike=="DUPLICATE")
                     74:       $printstrike = true;
                     75:     if ($printstrike)
                     76:       print "<strike>";
                     77:     print "<a href=\"$bug_url$bug_id\">";
                     78:     print $bug_id;
                     79:     print "</a>";
                     80:     if ($printstrike)
                     81:       print "</strike>";
1.3       cdn        82:     print "\n</td>\n<td>\n";
1.5       cdn        83: //    print htmlspecialchars (  mysql_result($my_result, $i, $component),ENT_QUOTES);
                     84:     print mysql_result($my_result, $i, $component);
1.1       cdn        85:     print "\n</td>\n<td>\n";
                     86:     print htmlspecialchars (  mysql_result($my_result, $i, $desc),ENT_QUOTES);
                     87:     print "</td>\n</tr>\n";
                     88:   }
                     89:   print "</tbody>\n";
                     90:   print "</table>\n\n";
                     91: 
1.7       cdn        92: ?>

FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>