webwml/newmaint/gpgplace.wml

<?
  session_start();
  include("gpgconfig.inc");
  include("common.inc");
  include("gpgcommon.inc");

?>
#use wml::gpgpage title="GPG Signing Coordination - Your profile"
<?
  if (!session_is_registered("s_username")) {
?>
<STRONG>
You should not be here!</STRONG>
<?
   return FALSE;
 } else {
  session_register("s_username");
  }
?>

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

    $sql = "SELECT id FROM people WHERE email = '$s_username'";
    if (! ($result = pg_exec($db, $sql))) {
        echo "Problem with query", pg_ErrorMessage($db), "<BR>";
        return FALSE;
    }
    if (pg_NumRows($result) != 1) {
        echo "That e-mail address is wicked.";
        return FALSE;
    }
    $row = pg_Fetch_Array($result, 0);
    $who = $row["id"];


    # begin, finish

    # city, country


    # modify an entry (if $id exists), or add a new one)
    if ($id) {
        $sql = "SELECT begin, finish, city, country FROM places WHERE id = '$id'";
        if (! ($result = pg_exec($db, $sql))) {
            echo "Problem with query", pg_ErrorMessage($db), "<BR>";
            return FALSE;
        }

        if (pg_NumRows($result) != 1) {
            echo "Not enough or too many results.  That should not happen.";
            return FALSE;
        }

        $row = pg_Fetch_Array($result, 0);
        $begin = $row["begin"];
        $finish = $row["finish"];
        $city = $row["city"];
        $country = $row["country"];
    } else {
        $begin = $finish = "";
        $city = $country = "";
    }

    $year = $month = "";

?>

<div align="center">
<TABLE summary="">
<FORM method="post" action="gpgregister.php">


<TR><TD>Begin</TD><TD><SELECT name = "year">
<?

$years = array("2001", "2002", "2003", "always");
foreach ($years as $i) {
    echo "<OPTION";
    if ($year == $i || (!year && $i == "always")) {
        echo " SELECTED";
    }
    echo ">$i\n";
}
?>
</SELECT></TD>

<TD><SELECT name = "month">
<?
$months = array("January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December");
$counter = 1;
foreach ($months as $i) {
    echo "<OPTION value=$counter";
    if ($month == $counter) {
        echo " SELECTED";
    }
    echo ">$i\n";
    $counter = $counter + 1;

}
?>
</SELECT></TD>

<TD><SELECT name = "day">
<?
for ($i = 1; $i < 32; $i++) {
    echo "<OPTION";
    if ($day == $i) {
        echo " SELECTED";
    }
    echo ">$i\n";
}
?>

</SELECT></TD>
</TR>

<TR><TD><B>City</B></TD><TD><INPUT name = "city" type = "text" value="<? echo $city ?>"></TD></TR>
<TR><TD><B>Country</B></TD><TD><INPUT name = "country" type = "text" value="<? echo $country ?>"></TD></TR>
</FORM>
</TD>
</TR>
</TABLE>

1	tbm	1.1	<?
2			session_start();
3			include("gpgconfig.inc");
4			include("common.inc");
5			include("gpgcommon.inc");
6
7			?>
8			#use wml::gpgpage title="GPG Signing Coordination - Your profile"
9			<?
10			if (!session_is_registered("s_username")) {
11			?>
12			<STRONG>
13			You should not be here!</STRONG>
14	tbm	1.11	<?
15			return FALSE;
16			} else {
17	tbm	1.1	session_register("s_username");
18			}
19			?>
20
21			<?
22			if (! ($db = open_db())) {
23			echo "<P>Cannot open database.</P>";
24			return FALSE;
25			}
26
27			$sql = "SELECT id FROM people WHERE email = '$s_username'";
28			if (! ($result = pg_exec($db, $sql))) {
29			echo "Problem with query", pg_ErrorMessage($db), "<BR>";
30			return FALSE;
31			}
32			if (pg_NumRows($result) != 1) {
33			echo "That e-mail address is wicked.";
34			return FALSE;
35			}
36			$row = pg_Fetch_Array($result, 0);
37			$who = $row["id"];
38
39
40			# begin, finish
41
42			# city, country
43
44
45			# modify an entry (if $id exists), or add a new one)
46			if ($id) {
47			$sql = "SELECT begin, finish, city, country FROM places WHERE id = '$id'";
48			if (! ($result = pg_exec($db, $sql))) {
49			echo "Problem with query", pg_ErrorMessage($db), "<BR>";
50			return FALSE;
51			}
52
53			if (pg_NumRows($result) != 1) {
54			echo "Not enough or too many results. That should not happen.";
55			return FALSE;
56			}
57
58			$row = pg_Fetch_Array($result, 0);
59			$begin = $row["begin"];
60			$finish = $row["finish"];
61			$city = $row["city"];
62			$country = $row["country"];
63			} else {
64	tbm	1.2	$begin = $finish = "";
65			$city = $country = "";
66	tbm	1.1	}
67	tbm	1.2
68	tbm	1.4	$year = $month = "";
69
70	tbm	1.1	?>
71	tbm	1.2
72			<div align="center">
73			<TABLE summary="">
74			<FORM method="post" action="gpgregister.php">
75	tbm	1.4
76
77	tbm	1.7	<TR><TD>Begin</TD><TD><SELECT name = "year">
78	tbm	1.4	<?
79
80			$years = array("2001", "2002", "2003", "always");
81			foreach ($years as $i) {
82			echo "<OPTION";
83	tbm	1.5	if ($year == $i \|\| (!year && $i == "always")) {
84	tbm	1.4	echo " SELECTED";
85			}
86			echo ">$i\n";
87			}
88			?>
89	tbm	1.7	</SELECT></TD>
90	tbm	1.4
91	tbm	1.7	<TD><SELECT name = "month">
92	tbm	1.4	<?
93	tbm	1.6	$months = array("January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December");
94	tbm	1.4	$counter = 1;
95			foreach ($months as $i) {
96			echo "<OPTION value=$counter";
97			if ($month == $counter) {
98			echo " SELECTED";
99			}
100			echo ">$i\n";
101			$counter = $counter + 1;
102
103			}
104	tbm	1.6	?>
105	tbm	1.10	</SELECT></TD>
106	tbm	1.7
107	tbm	1.9	<TD><SELECT name = "day">
108			<?
109			for ($i = 1; $i < 32; $i++) {
110			echo "<OPTION";
111			if ($day == $i) {
112			echo " SELECTED";
113			}
114			echo ">$i\n";
115			}
116			?>
117
118	tbm	1.10	</SELECT></TD>
119	tbm	1.9	</TR>
120	tbm	1.4
121	tbm	1.3	<TR><TD><B>City</B></TD><TD><INPUT name = "city" type = "text" value="<? echo $city ?>"></TD></TR>
122			<TR><TD><B>Country</B></TD><TD><INPUT name = "country" type = "text" value="<? echo $country ?>"></TD></TR>
123	tbm	1.2	</FORM>
124			</TD>
125			</TR>
126			</TABLE>
127	tbm	1.1