File:  [mozdev] / cdn / www / bug.html
Revision 1.3: download - view: text, annotated - select for diffs - revision graph
Fri Feb 28 14:44:08 2003 UTC (16 years, 3 months ago) by cdn
Branches: MAIN
CVS tags: HEAD
bugzilla fun

    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 
    9: 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 
   10: bugs</A> 
   11: <LI>See all <A 
   12: 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 
   13: bugs</A></LI>
   14: <li>Search by Bug Number<br><br>
   15: <FORM action=http://mozdev.org/bugs/show_bug.cgi method=get><INPUT type=submit value=Find> <INPUT size=6 
   16: name=id></FORM>
   17: </li>
   18: </ul><?php $doNotCapitalise = 1; ?>
   19: 
   20: <?php
   21: 
   22: // $Id: bug.html,v 1.3 2003/02/28 14:44:08 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         = 10;
   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:                       ORDER BY $id 
   42:                       DESC LIMIT $amount
   43:                     ";
   44: 
   45:   $my_result      = mysql_query($query, $connect);
   46: 
   47:   $e              = mysql_error();
   48:   if($e)
   49:     print  "ERROR:latest_bugs: $e"; 
   50: 
   51:   $row            = mysql_num_rows($my_result);
   52: 
   53:   if ( $doNotCapitalise )
   54:     $product = $project;
   55:   
   56:   print "<h4>Latest bugs filed for $product</h4>\n\n";
   57:   
   58:   print "<table cellspacing=\"2\" cellpadding=\"2\" border=0>\n";
   59:   
   60:   print "<thead>\n<tr>\n";
   61:   print '<th bgcolor="#990000"><font color="#ffffff">Bug #</font></th>';
   62:   print '<th bgcolor="#FF9900">Component</th>' . "\n\n";
   63:   print '<th bgcolor="#FF9900">Description</th>' . "\n\n";
   64:   print "</tr>\n</thead>\n";
   65: 
   66:   print "<tbody>\n";
   67:   for($i=0; $i<$row; $i++) {
   68:     $printstrike = false;
   69:     print "<tr>\n<td>\n";
   70:     $bug_id =  mysql_result($my_result, $i, $id);
   71:     $strike =  mysql_result($my_result, $i, $res);
   72:     if ($strike == "FIXED" || $strike == "INVALID" || $strike=="DUPLICATE")
   73:       $printstrike = true;
   74:     if ($printstrike)
   75:       print "<strike>";
   76:     print "<a href=\"$bug_url$bug_id\">";
   77:     print $bug_id;
   78:     print "</a>";
   79:     if ($printstrike)
   80:       print "</strike>";
   81:     print "\n</td>\n<td>\n";
   82:     print htmlspecialchars (  mysql_result($my_result, $i, $component),ENT_QUOTES);
   83:     print "\n</td>\n<td>\n";
   84:     print htmlspecialchars (  mysql_result($my_result, $i, $desc),ENT_QUOTES);
   85:     print "</td>\n</tr>\n";
   86:   }
   87:   print "</tbody>\n";
   88:   print "</table>\n\n";
   89: 
   90: ?>

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