webwml/newmaint/gpg.wml

<?
  include("gpgconfig.inc");
  include("common.inc");
  include("gpgcommon.inc");
?>
#use wml::gpgpage title="GPG Signing Coordination Page"
<?

    if (! ($db = open_db())) {
        echo "<P>Cannot open SQL database</P>";
        return FALSE;
    }

    function print_people($db, $sql) {
        if (! ($query = pg_exec($db, $sql))) {
            echo "Problem with query", pg_ErrorMessage($db), "<BR>";
            return FALSE;
        }
        $rows = pg_NumRows($query);
        for ($i = 0; $i < $rows; $i++) {
            $row = pg_Fetch_Array($query, $i);
            echo "<H2>";
            echo $row["forename"], " ", $row["surname"];
            echo " &lt;", $row["email"], "&gt;";
            echo "</H2>\n";

            print_all_places($row["id"], FALSE);

        }
    }
?>

<H1>People looking for GPG Signing</H1>
<?
    $sql = "SELECT id, forename, surname, email FROM people WHERE offer is FALSE ORDER BY surname";
    print_people($db, $sql);
?>

<HR>

<H1>People offering GPG Signing</H1>
<?
    $sql = "SELECT id, forename, surname, email FROM people WHERE offer is TRUE ORDER BY surname";
    print_people($db, $sql);
?>

<P>

1	tbm	1.1	<?
2			include("gpgconfig.inc");
3			include("common.inc");
4			include("gpgcommon.inc");
5			?>
6			#use wml::gpgpage title="GPG Signing Coordination Page"
7			<?
8
9	tbm	1.3	if (! ($db = open_db())) {
10			echo "<P>Cannot open SQL database</P>";
11			return FALSE;
12			}
13
14	tbm	1.1	function print_people($db, $sql) {
15			if (! ($query = pg_exec($db, $sql))) {
16			echo "Problem with query", pg_ErrorMessage($db), "<BR>";
17			return FALSE;
18			}
19			$rows = pg_NumRows($query);
20			for ($i = 0; $i < $rows; $i++) {
21			$row = pg_Fetch_Array($query, $i);
22			echo "<H2>";
23			echo $row["forename"], " ", $row["surname"];
24			echo " <", $row["email"], ">";
25			echo "</H2>\n";
26
27			print_all_places($row["id"], FALSE);
28
29			}
30	tbm	1.2	}
31	tbm	1.1	?>
32
33			<H1>People looking for GPG Signing</H1>
34			<?
35	tbm	1.9	$sql = "SELECT id, forename, surname, email FROM people WHERE offer is FALSE ORDER BY surname";
36	tbm	1.1	print_people($db, $sql);
37			?>
38	tbm	1.7
39			<HR>
40
41	tbm	1.1	<H1>People offering GPG Signing</H1>
42			<?
43	tbm	1.9	$sql = "SELECT id, forename, surname, email FROM people WHERE offer is TRUE ORDER BY surname";
44	tbm	1.1	print_people($db, $sql);
45			?>
46
47	tbm	1.5	<P>
48