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

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.17    ! cdn        14: </ul><?php $doNotCapitalise = 01; $project='mozdev'; //$project = 'optimoz'; ?>
1.1       cdn        15: 
                     16: <?php
                     17: 
1.17    ! cdn        18: // $Id: bug.html,v 1.16 2003/03/02 14:59:42 cdn Exp $
1.1       cdn        19: 
                     20:   require(PHP_INC.CONNECT);
                     21: 
                     22:   $id             = "bug_id";
                     23:   $desc           = "short_desc";
                     24:   $res            = "resolution";
                     25:   $table          = "bugs";
                     26:   $target         = "product";
1.12      cdn        27:   $amount         = 60;
1.1       cdn        28:   $bug_url        = "http://mozdev.org/bugs/show_bug.cgi?id=";
                     29: 
1.2       cdn        30:   $component      = 'component';      
                     31:   
1.1       cdn        32:   $product        = ucwords($project);
                     33: 
1.6       cdn        34:   $query          = " SELECT $id, $desc, $component, $res
1.1       cdn        35:                       FROM $table
1.6       cdn        36:                       WHERE $target='$product'
1.16      cdn        37:                       ORDER BY $id DESC
1.6       cdn        38:                       LIMIT $amount
1.1       cdn        39:                     ";
                     40: 
                     41:   $my_result      = mysql_query($query, $connect);
                     42: 
                     43:   $e              = mysql_error();
                     44:   if($e)
                     45:     print  "ERROR:latest_bugs: $e"; 
                     46: 
                     47:   $row            = mysql_num_rows($my_result);
                     48: 
1.2       cdn        49:   if ( $doNotCapitalise )
                     50:     $product = $project;
                     51:   
1.9       cdn        52:   print '<h4 id="BZ-h4">Latest bugs filed for ' . $product . "</h4>\n\n";
1.6       cdn        53: 
                     54:   print '<table cellspacing="2" cellpadding="2" border=0>' . "\n";
                     55: 
1.1       cdn        56:   print "<thead>\n<tr>\n";
1.3       cdn        57:   print '<th bgcolor="#990000"><font color="#ffffff">Bug #</font></th>';
                     58:   print '<th bgcolor="#FF9900">Component</th>' . "\n\n";
1.2       cdn        59:   print '<th bgcolor="#FF9900">Description</th>' . "\n\n";
1.1       cdn        60:   print "</tr>\n</thead>\n";
1.2       cdn        61: 
1.1       cdn        62:   print "<tbody>\n";
                     63:   for($i=0; $i<$row; $i++) {
                     64:     $printstrike = false;
                     65:     print "<tr>\n<td>\n";
                     66:     $bug_id =  mysql_result($my_result, $i, $id);
                     67:     $strike =  mysql_result($my_result, $i, $res);
                     68:     if ($strike == "FIXED" || $strike == "INVALID" || $strike=="DUPLICATE")
                     69:       $printstrike = true;
                     70:     if ($printstrike)
                     71:       print "<strike>";
                     72:     print "<a href=\"$bug_url$bug_id\">";
                     73:     print $bug_id;
                     74:     print "</a>";
                     75:     if ($printstrike)
                     76:       print "</strike>";
1.3       cdn        77:     print "\n</td>\n<td>\n";
1.5       cdn        78: //    print htmlspecialchars (  mysql_result($my_result, $i, $component),ENT_QUOTES);
                     79:     print mysql_result($my_result, $i, $component);
1.1       cdn        80:     print "\n</td>\n<td>\n";
                     81:     print htmlspecialchars (  mysql_result($my_result, $i, $desc),ENT_QUOTES);
                     82:     print "</td>\n</tr>\n";
                     83:   }
                     84:   print "</tbody>\n";
                     85:   print "</table>\n\n";
                     86: 
1.7       cdn        87: ?>

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