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 (14 years, 6 months ago) by cdn
Branches: MAIN
CVS tags: HEAD
deboog

<h4 class="contentTitle">Project Owners &nbsp;&nbsp; <img src="http://www.mozdev.org/sharedimages/boxes.gif" alt=""></h4>
<h5><?php echo '$Revision: 1.20 $'; ?></h5>
<!-- MAIN CONTENT -->

<p>For anything relating to a particular project, please contact the different projects owners
directly or send a message to that project's <a href="http://www.mozdev.org/mailing-lists.html">mailing
list</a>.  To contact all project owners as a group, please use the
<a href="http://www.mozdev.org/owners/list.html">project owners mailing list</a>.
</p>

<?php

// $Id: kontact.html,v 1.20 2003/03/27 13:44:32 cdn Exp $

  require(PHP_INC.CONNECT);

//  $project = 'flibble';

  $query = "select project, prefCap from domain_projects order by project";

  $my_result      = mysql_query($query, $connect);

  $e              = mysql_error();
  if($e)
    print  "ERROR:latest_bugs: $e";

  $row            = mysql_num_rows($my_result);

  echo "<table id=\"contact\">\n";
  echo "<tr>\n";
  echo "<th>Project</th><th>Contact(s)</th>\n";
  echo "</tr>\n\n";

  $i = 0;

//  for($i=0; $i<$row; $i++) {

  while ( $sql_result = mysql_fetch_array($my_result) ) {

//$i = 18;

  $project = $sql_result['project'];
  $_PrOjEcT = $sql_result['prefCap'];

  if ( empty($_PrOjEcT) )
    $_PrOjEcT = $project;

  $quid = "SELECT u.name as name, u.email as email, u.loginID as id
             FROM project_privs as p, User as u, PermissionExtent as pe
              WHERE p.project='$project'
               AND p.commit_priv='Y'
                AND u.loginID=p.username
                 AND pe.userID=u.userID
                  AND permissionID=154 AND extent LIKE '$project%'";

  $s_quid = mysql_query($quid, $connect);

  $e  = mysql_error();
  if($e)
    print "ERROR2:project_members: $e";

  $row2 = mysql_num_rows($s_quid);

     $k = $i % 2;


 if ( $row2 > 0) {

  for($j=0; $j<$row2; $j++) {
   $name =  mysql_result($s_quid, $j, 'name');
   $email =  mysql_result($s_quid, $j, 'email');

   if ($_project == $project)
     unset($_PrOjEcT);

   echo "<tr class=" . '"';
   echo 'contact-row' . $k;
   echo '"';
   echo ">\n";
   echo '<td';

   if ($_project == $project)
     echo ' class="as-above"';

   echo '>';
   echo "<!-- $i -->";

   if ( isset($_PrOjEcT) ) {
    echo '<a href="http://';
    echo $project;
    echo '.';
    echo HOST;
    echo '/">';
    echo $_PrOjEcT . '</a>';
   }
   else {
     echo '&nbsp;';
   }

   echo '</td><td>';
   echo '<a href="mailto:';
   echo b2antispambot($email);
   echo '">';
   echo $name;
   echo "</a></td>\n</tr>\n";

   $_project = $project;

  }
 }
 else {
   if ($_project == $project)
     unset($_PrOjEcT);

   echo "<tr class=" . '"';
   echo 'contact-row' . $k;
   echo '"';
   echo ">\n";
   echo '<td';

   if ($_project == $project)
     echo ' class="as-above"';

   echo '>';
   echo "<!-- $i -->";

   if ( isset($_PrOjEcT) ) {
    echo '<a href="http://';
    echo $project;
    echo '.';
    echo HOST;
    echo '/">';
    echo $_PrOjEcT . '</a>';
   }
   else {
     echo '&nbsp;';
   }

   echo '</td><td>';
   echo "<strong>No Contact(s)</strong></td>\n</tr>\n";

   $_project = $project;
 }

  unset($_project);

   ++$i;

  }

  echo "</table>\n"

?>

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