/[webwml]/newmaint/whoisam.wml
ViewVC logotype

Diff of /newmaint/whoisam.wml

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 1.4 by tbm, Thu Mar 14 02:01:38 2002 UTC revision 1.5 by tbm, Thu Mar 14 02:14:00 2002 UTC
# Line 2  Line 2 
2    include("config.inc");    include("config.inc");
3    include("common.inc");    include("common.inc");
4    
5    function print_applicants($sql) {    function print_applicants($db, $sql) {
   if (! ($db = open_db())) {  
     return FALSE;  
   }  
6    if (! ($query = pg_exec($db, $sql))) {    if (! ($query = pg_exec($db, $sql))) {
7      echo "Problem with query", pg_ErrorMessage($db), "<BR>";      echo "Problem with query", pg_ErrorMessage($db), "<BR>";
8      pg_Close($db);      pg_Close($db);
# Line 16  Line 13 
13      $row = pg_Fetch_Array($query, $i);      $row = pg_Fetch_Array($query, $i);
14      echo $row["name"], "<BR>\n";      echo $row["name"], "<BR>\n";
15    }    }
   
   pg_Close($db);  
16    return TRUE;    return TRUE;
17  }?>  }?>
18  #use wml::nmpage title="Debian New Maintainer - Application Manager List"  #use wml::nmpage title="Debian New Maintainer - Application Manager List"
19    <?
20      if (! ($db = open_db())) {
21        echo "Cannot open database!";
22        return FALSE;
23      }
24    ?>
25  <H1>Debian New Maintainer - Application Manager List</H1><BR>  <H1>Debian New Maintainer - Application Manager List</H1><BR>
26  <P>Below is the list of Debian maintainers who are currently active as  <P>Below is the list of Debian maintainers who are currently active as
27  Application Managers:  Application Managers:
28  <BR>  <BR>
29  <? $sql = "SELECT * from manager WHERE is_active IS TRUE ORDER by name";  <? $sql = "SELECT * from manager WHERE is_active IS TRUE ORDER by name";
30     print_applicants($sql); ?>     print_applicants($db, $sql); ?>
31  <P>  <P>
32  <P>Below is the list of Debian maintainers who used to help as Application  <P>Below is the list of Debian maintainers who used to help as Application
33  Managers in the past:  Managers in the past:
34  <BR>  <BR>
35  <? $sql = "SELECT * from manager WHERE is_active IS FALSE ORDER by name";  <? $sql = "SELECT * from manager WHERE is_active IS FALSE ORDER by name";
36     print_applicants($sql); ?>     print_applicants($db, $sql); ?>
37    <?
38      pg_Close($db);
39    ?>
40    
Legend:
Removed from v.1.4  
changed lines
  Added in v.1.5
  ViewVC Help
Powered by ViewVC 1.1.5