File:  [mozdev] / cdn / www / kontact.html
Revision 1.20: download - view: text, annotated - select for diffs - revision graph
Thu Mar 27 13:44:32 2003 UTC (16 years, 1 month ago) by cdn
Branches: MAIN
CVS tags: HEAD
deboog

    1: <h4 class="contentTitle">Project Owners &nbsp;&nbsp; <img src="http://www.mozdev.org/sharedimages/boxes.gif" alt=""></h4>
    2: <h5><?php echo '$Revision: 1.20 $'; ?></h5>
    3: <!-- MAIN CONTENT -->
    4: 
    5: <p>For anything relating to a particular project, please contact the different projects owners
    6: directly or send a message to that project's <a href="http://www.mozdev.org/mailing-lists.html">mailing
    7: list</a>.  To contact all project owners as a group, please use the
    8: <a href="http://www.mozdev.org/owners/list.html">project owners mailing list</a>.
    9: </p>
   10: 
   11: <?php
   12: 
   13: // $Id: kontact.html,v 1.20 2003/03/27 13:44:32 cdn Exp $
   14: 
   15:   require(PHP_INC.CONNECT);
   16: 
   17: //  $project = 'flibble';
   18: 
   19:   $query = "select project, prefCap from domain_projects order by project";
   20: 
   21:   $my_result      = mysql_query($query, $connect);
   22: 
   23:   $e              = mysql_error();
   24:   if($e)
   25:     print  "ERROR:latest_bugs: $e";
   26: 
   27:   $row            = mysql_num_rows($my_result);
   28: 
   29:   echo "<table id=\"contact\">\n";
   30:   echo "<tr>\n";
   31:   echo "<th>Project</th><th>Contact(s)</th>\n";
   32:   echo "</tr>\n\n";
   33: 
   34:   $i = 0;
   35: 
   36: //  for($i=0; $i<$row; $i++) {
   37: 
   38:   while ( $sql_result = mysql_fetch_array($my_result) ) {
   39: 
   40: //$i = 18;
   41: 
   42:   $project = $sql_result['project'];
   43:   $_PrOjEcT = $sql_result['prefCap'];
   44: 
   45:   if ( empty($_PrOjEcT) )
   46:     $_PrOjEcT = $project;
   47: 
   48:   $quid = "SELECT u.name as name, u.email as email, u.loginID as id
   49:              FROM project_privs as p, User as u, PermissionExtent as pe
   50:               WHERE p.project='$project'
   51:                AND p.commit_priv='Y'
   52:                 AND u.loginID=p.username
   53:                  AND pe.userID=u.userID
   54:                   AND permissionID=154 AND extent LIKE '$project%'";
   55: 
   56:   $s_quid = mysql_query($quid, $connect);
   57: 
   58:   $e  = mysql_error();
   59:   if($e)
   60:     print "ERROR2:project_members: $e";
   61: 
   62:   $row2 = mysql_num_rows($s_quid);
   63: 
   64:      $k = $i % 2;
   65: 
   66: 
   67:  if ( $row2 > 0) {
   68: 
   69:   for($j=0; $j<$row2; $j++) {
   70:    $name =  mysql_result($s_quid, $j, 'name');
   71:    $email =  mysql_result($s_quid, $j, 'email');
   72: 
   73:    if ($_project == $project)
   74:      unset($_PrOjEcT);
   75: 
   76:    echo "<tr class=" . '"';
   77:    echo 'contact-row' . $k;
   78:    echo '"';
   79:    echo ">\n";
   80:    echo '<td';
   81: 
   82:    if ($_project == $project)
   83:      echo ' class="as-above"';
   84: 
   85:    echo '>';
   86:    echo "<!-- $i -->";
   87: 
   88:    if ( isset($_PrOjEcT) ) {
   89:     echo '<a href="http://';
   90:     echo $project;
   91:     echo '.';
   92:     echo HOST;
   93:     echo '/">';
   94:     echo $_PrOjEcT . '</a>';
   95:    }
   96:    else {
   97:      echo '&nbsp;';
   98:    }
   99: 
  100:    echo '</td><td>';
  101:    echo '<a href="mailto:';
  102:    echo b2antispambot($email);
  103:    echo '">';
  104:    echo $name;
  105:    echo "</a></td>\n</tr>\n";
  106: 
  107:    $_project = $project;
  108: 
  109:   }
  110:  }
  111:  else {
  112:    if ($_project == $project)
  113:      unset($_PrOjEcT);
  114: 
  115:    echo "<tr class=" . '"';
  116:    echo 'contact-row' . $k;
  117:    echo '"';
  118:    echo ">\n";
  119:    echo '<td';
  120: 
  121:    if ($_project == $project)
  122:      echo ' class="as-above"';
  123: 
  124:    echo '>';
  125:    echo "<!-- $i -->";
  126: 
  127:    if ( isset($_PrOjEcT) ) {
  128:     echo '<a href="http://';
  129:     echo $project;
  130:     echo '.';
  131:     echo HOST;
  132:     echo '/">';
  133:     echo $_PrOjEcT . '</a>';
  134:    }
  135:    else {
  136:      echo '&nbsp;';
  137:    }
  138: 
  139:    echo '</td><td>';
  140:    echo "<strong>No Contact(s)</strong></td>\n</tr>\n";
  141: 
  142:    $_project = $project;
  143:  }
  144: 
  145:   unset($_project);
  146: 
  147:    ++$i;
  148: 
  149:   }
  150: 
  151:   echo "</table>\n"
  152: 
  153: ?>

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