webwml/newmaint/gpg.wml

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

    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";

            echo "<LI>";
            print_all_places($row["id"], FALSE);
            echo "</LI>";

        }
    }
?>

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

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			function print_people($db, $sql) {
10			if (! ($query = pg_exec($db, $sql))) {
11			echo "Problem with query", pg_ErrorMessage($db), "<BR>";
12			return FALSE;
13			}
14			$rows = pg_NumRows($query);
15			for ($i = 0; $i < $rows; $i++) {
16			$row = pg_Fetch_Array($query, $i);
17			echo "<H2>";
18			echo $row["forename"], " ", $row["surname"];
19			echo " <", $row["email"], ">";
20			echo "</H2>\n";
21
22			echo "<LI>";
23			print_all_places($row["id"], FALSE);
24			echo "</LI>";
25
26			}
27	tbm	1.2	}
28	tbm	1.1	?>
29
30			<H1>People looking for GPG Signing</H1>
31			<?
32			$sql = "SELECT id, forename, surname, email FROM people WHERE offer is FALSE";
33			print_people($db, $sql);
34			?>
35			<H1>People offering GPG Signing</H1>
36			<?
37			$sql = "SELECT id, forename, surname, email FROM people WHERE offer is TRUE";
38			print_people($db, $sql);
39			?>
40