File:  [mozdev] / cdn / www / bug.html
Revision 1.21: download - view: text, annotated - select for diffs - revision graph
Sun Mar 2 18:49:09 2003 UTC (16 years, 3 months ago) by cdn
Branches: MAIN
CVS tags: HEAD
looped 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.21 2003/03/02 18:49:09 cdn Exp $
   23: 
   24:   require(PHP_INC.CONNECT);
   25: 
   26:   $product        = ucwords($project);
   27: 
   28:   if ( $doNotCapitalise )
   29:     $product = $project;
   30:   
   31:   print '<h4 id="BZ-h4">Latest bugs filed for ' . $product . "</h4>\n\n";
   32: 
   33:   $id             = "bug_id";
   34:   $desc           = "short_desc";
   35:   $res            = "resolution";
   36:   $table          = "bugs";
   37:   $target         = "product";
   38: 
   39:   if (!isset($amount))
   40:     $amount         = 10;
   41: 
   42:   $bug_url        = "http://" . HOST . "/bugs/show_bug.cgi?id=";
   43: 
   44:   $component      = 'component';
   45: 
   46:   if ( !isset($bug_component) )
   47:     $bug_component[0] = '';
   48:         
   49:  for ($j=0; $j < count($bug_component); ++$j)
   50:  {
   51:   $query          = " SELECT $id, $desc, $component, $res
   52:                       FROM $table
   53:                       WHERE $target='$product'
   54:                       AND $component LIKE '%" . $bug_component[$j] . "%'
   55:                       ORDER BY $id DESC
   56:                       LIMIT $amount
   57:                     ";
   58: 
   59:   $my_result      = mysql_query($query, $connect);
   60: 
   61:   $e              = mysql_error();
   62:   if($e)
   63:     print  "ERROR:latest_bugs: $e"; 
   64: 
   65:   $row            = mysql_num_rows($my_result);
   66: 
   67:   print '<h4 class="BZ-component-h4">' . mysql_result($my_result, 0, $component) . "</h4>\n";
   68: 
   69:   print '<table class="BZ-table" cellspacing="2" cellpadding="2" border="0">' . "\n";
   70: 
   71:   print "<thead>\n<tr>\n";
   72:   print '<th class="BZ-th-bug">Bug #</th>';
   73: //  print '<th bgcolor="#FF9900">Component</th>' . "\n\n";
   74:   print '<th class="BZ-th-desc">Description</th>' . "\n\n";
   75:   print "</tr>\n</thead>\n";
   76: 
   77:   print "<tbody>\n";
   78:   for($i=0; $i<$row; $i++) {
   79:     $printstrike = false;
   80:     print "<tr>\n<td>\n";
   81:     $bug_id =  mysql_result($my_result, $i, $id);
   82:     $strike =  mysql_result($my_result, $i, $res);
   83:     if ($strike == "FIXED" || $strike == "INVALID" || $strike=="DUPLICATE")
   84:       $printstrike = true;
   85:     if ($printstrike)
   86:       print "<strike>";
   87:     print "<a href=\"$bug_url$bug_id\">";
   88:     print $bug_id;
   89:     print "</a>";
   90:     if ($printstrike)
   91:       print "</strike>";
   92:     print "\n</td>\n<td>\n";
   93: //    print htmlspecialchars (  mysql_result($my_result, $i, $component),ENT_QUOTES);
   94: //    print mysql_result($my_result, $i, $component);
   95: //    print "\n</td>\n<td>\n";
   96:     print htmlspecialchars (  mysql_result($my_result, $i, $desc),ENT_QUOTES);
   97:     print "</td>\n</tr>\n";
   98:   }
   99:   print "</tbody>\n";
  100:   print "</table>\n";
  101:  }
  102: 
  103: ?>

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