File:  [mozdev] / cdn / www / bug.html
Revision 1.20: download - view: text, annotated - select for diffs - revision graph
Sun Mar 2 18:03:11 2003 UTC (16 years, 2 months ago) by cdn
Branches: MAIN
CVS tags: HEAD
component specific sql

    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>
    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>
   10: <li>Search by Bug Number<br><br>
   11: <form action="http://mozdev.org/bugs/show_bug.cgi" method="get"><input type="submit" value="Find">
   12: <input size="6" name="id"></form>
   13: </li>
   14: </ul><?php $doNotCapitalise = 01; $project='mozdev'; $project = 'optimoz'; 
   15: 
   16: $bug_component = array('gesture', 'radial');
   17: 
   18: ?>
   19: 
   20: <?php
   21: 
   22: // $Id: bug.html,v 1.20 2003/03/02 18:03:11 cdn Exp $
   23: 
   24:   require(PHP_INC.CONNECT);
   25: 
   26:   $id             = "bug_id";
   27:   $desc           = "short_desc";
   28:   $res            = "resolution";
   29:   $table          = "bugs";
   30:   $target         = "product";
   31:   $amount         = 60;
   32:   $bug_url        = "http://mozdev.org/bugs/show_bug.cgi?id=";
   33: 
   34:   $component      = 'component';      
   35:   
   36:   $product        = ucwords($project);
   37: 
   38:   $query          = " SELECT $id, $desc, $component, $res
   39:                       FROM $table
   40:                       WHERE $target='$product'
   41:                       AND $component LIKE '%" . $bug_component[1] . "%'
   42:                       ORDER BY $id DESC
   43:                       LIMIT $amount
   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: 
   54:   if ( $doNotCapitalise )
   55:     $product = $project;
   56:   
   57:   print '<h4 id="BZ-h4">Latest bugs filed for ' . $product . "</h4>\n\n";
   58: 
   59:   print '<h4 class="BZ-component-h4">' . mysql_result($my_result, 0, $component) . "</h4>\n";
   60: 
   61:   print '<table class="BZ-table" cellspacing="2" cellpadding="2" border="0">' . "\n";
   62: 
   63:   print "<thead>\n<tr>\n";
   64:   print '<th class="BZ-th-bug">Bug #</th>';
   65: //  print '<th bgcolor="#FF9900">Component</th>' . "\n\n";
   66:   print '<th class="BZ-th-desc">Description</th>' . "\n\n";
   67:   print "</tr>\n</thead>\n";
   68: 
   69:   print "<tbody>\n";
   70:   for($i=0; $i<$row; $i++) {
   71:     $printstrike = false;
   72:     print "<tr>\n<td>\n";
   73:     $bug_id =  mysql_result($my_result, $i, $id);
   74:     $strike =  mysql_result($my_result, $i, $res);
   75:     if ($strike == "FIXED" || $strike == "INVALID" || $strike=="DUPLICATE")
   76:       $printstrike = true;
   77:     if ($printstrike)
   78:       print "<strike>";
   79:     print "<a href=\"$bug_url$bug_id\">";
   80:     print $bug_id;
   81:     print "</a>";
   82:     if ($printstrike)
   83:       print "</strike>";
   84:     print "\n</td>\n<td>\n";
   85: //    print htmlspecialchars (  mysql_result($my_result, $i, $component),ENT_QUOTES);
   86: //    print mysql_result($my_result, $i, $component);
   87: //    print "\n</td>\n<td>\n";
   88:     print htmlspecialchars (  mysql_result($my_result, $i, $desc),ENT_QUOTES);
   89:     print "</td>\n</tr>\n";
   90:   }
   91:   print "</tbody>\n";
   92:   print "</table>\n";
   93: 
   94: ?>

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