File:  [mozdev] / cdn / www / bug.html
Revision 1.1: download - view: text, annotated - select for diffs - revision graph
Fri Feb 28 14:31:21 2003 UTC (16 years, 5 months ago) by cdn
Branches: MAIN
CVS tags: HEAD
bugs.html (latest_bugs) - flexibility

    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>
   19: 
   20: <?php
   21: 
   22: // $Id: bug.html,v 1.1 2003/02/28 14:31:21 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:   $product        = ucwords($project);
   35: 
   36:   $query          = " SELECT $id, $desc, $res 
   37:                       FROM $table
   38:                       WHERE $target='$product' 
   39:                       ORDER BY $id 
   40:                       DESC LIMIT $amount
   41:                     ";
   42: 
   43:   $my_result      = mysql_query($query, $connect);
   44: 
   45:   $e              = mysql_error();
   46:   if($e)
   47:     print  "ERROR:latest_bugs: $e"; 
   48: 
   49:   $row            = mysql_num_rows($my_result);
   50: 
   51:   print "<h4>Latest bugs filed for $product</h4>\n\n";
   52:   print "<table cellspacing=\"2\" cellpadding=\"2\" border=0>\n";
   53:   print "<thead>\n<tr>\n";
   54:   print "<th bgcolor=\"#990000\"><font color=\"#ffffff\">Bug #</font></th>
   55:          <th  bgcolor=\"#FF9900\">Description</th>\n\n";
   56:   print "</tr>\n</thead>\n";
   57:   print "<tbody>\n";
   58:   for($i=0; $i<$row; $i++) {
   59:     $printstrike = false;
   60:     print "<tr>\n<td>\n";
   61:     $bug_id =  mysql_result($my_result, $i, $id);
   62:     $strike =  mysql_result($my_result, $i, $res);
   63:     if ($strike == "FIXED" || $strike == "INVALID" || $strike=="DUPLICATE")
   64:       $printstrike = true;
   65:     if ($printstrike)
   66:       print "<strike>";
   67:     print "<a href=\"$bug_url$bug_id\">";
   68:     print $bug_id;
   69:     print "</a>";
   70:     if ($printstrike)
   71:       print "</strike>";
   72:     print "\n</td>\n<td>\n";
   73:     print htmlspecialchars (  mysql_result($my_result, $i, $desc),ENT_QUOTES);
   74:     print "</td>\n</tr>\n";
   75:   }
   76:   print "</tbody>\n";
   77:   print "</table>\n\n";
   78: 
   79: ?>
   80: 

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