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


    # user pressed submit

    if ($city || $country) {
        $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"];

        echo "$city, $country";
        echo "<P>";
        echo "$begin_year, $begin_month, $begin_day";
        echo "<P>";
        echo "$end_year, $end_month, $end_day";
        echo "<P>";
        echo "$id";
        echo "<P>";

        return TRUE;
    }


    # user wants to fill out the form

    # 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 = "";
    }

?>

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


<?

function print_date($title, $name, $date) {

    $parsed_date = split("-", $date);
    $year = $parsed_date[0];
    $month = $parsed_date[1];
    $day = $parsed_date[2];

    echo "<TR><TD>$title</TD><TD><SELECT name = \"";
    echo $name;
    echo "_year\">";

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

    echo "</SELECT></TD>";
    echo "<TD><SELECT name = \"";
    echo $name;
    echo "_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;
    }

    echo "</SELECT></TD>";
    echo "<TD><SELECT name = \"";
    echo $name;
    echo "_day\">";

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

<?

    print_date("Begin", "begin", $begin);
    print_date("End", "end", $finish);

    if ($id) {
        echo "<input type=hidden name=id value=\"$id\">"
    }

?>


<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>
<TR><TD> </TD><TD><INPUT type="submit" value="Submit"></TD></TR>
</FORM>
</TD>
</TR>
</TABLE>

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	<?
15	return FALSE;
16	} else {
17	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
28	# user pressed submit
29
30	if ($city \|\| $country) {
31	$sql = "SELECT id FROM people WHERE email = '$s_username'";
32	if (! ($result = pg_exec($db, $sql))) {
33	echo "Problem with query", pg_ErrorMessage($db), "<BR>";
34	return FALSE;
35	}
36	if (pg_NumRows($result) != 1) {
37	echo "That e-mail address is wicked.";
38	return FALSE;
39	}
40	$row = pg_Fetch_Array($result, 0);
41	$who = $row["id"];
42
43	echo "$city, $country";
44	echo "<P>";
45	echo "$begin_year, $begin_month, $begin_day";
46	echo "<P>";
47	echo "$end_year, $end_month, $end_day";
48	echo "<P>";
49	echo "$id";
50	echo "<P>";
51
52	return TRUE;
53	}
54
55
56	# user wants to fill out the form
57
58	# modify an entry (if $id exists), or add a new one)
59	if ($id) {
60	$sql = "SELECT begin, finish, city, country FROM places WHERE id = '$id'";
61	if (! ($result = pg_exec($db, $sql))) {
62	echo "Problem with query", pg_ErrorMessage($db), "<BR>";
63	return FALSE;
64	}
65
66	if (pg_NumRows($result) != 1) {
67	echo "Not enough or too many results. That should not happen.";
68	return FALSE;
69	}
70
71	$row = pg_Fetch_Array($result, 0);
72	$begin = $row["begin"];
73	$finish = $row["finish"];
74	$city = $row["city"];
75	$country = $row["country"];
76	} else {
77	$begin = $finish = "";
78	$city = $country = "";
79	}
80
81	?>
82
83	<div align="center">
84	<TABLE summary="">
85	<FORM method="post" action="gpgplace.php">
86
87
88	<?
89
90	function print_date($title, $name, $date) {
91
92	$parsed_date = split("-", $date);
93	$year = $parsed_date[0];
94	$month = $parsed_date[1];
95	$day = $parsed_date[2];
96
97	echo "<TR><TD>$title</TD><TD><SELECT name = \"";
98	echo $name;
99	echo "_year\">";
100
101	$years = array("2001", "2002", "2003", "always");
102	foreach ($years as $i) {
103	echo "<OPTION";
104	if ($year == $i \|\| (!year && $i == "always")) {
105	echo " SELECTED";
106	}
107	echo ">$i\n";
108	}
109
110	echo "</SELECT></TD>";
111	echo "<TD><SELECT name = \"";
112	echo $name;
113	echo "_month\">";
114
115	$months = array("January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December");
116	$counter = 1;
117	foreach ($months as $i) {
118	echo "<OPTION value=$counter";
119	if ($month == $counter) {
120	echo " SELECTED";
121	}
122	echo ">$i\n";
123	$counter = $counter + 1;
124	}
125
126	echo "</SELECT></TD>";
127	echo "<TD><SELECT name = \"";
128	echo $name;
129	echo "_day\">";
130
131	for ($i = 1; $i < 32; $i++) {
132	echo "<OPTION";
133	if ($day == $i) {
134	echo " SELECTED";
135	}
136	echo ">$i";
137	}
138	echo "</SELECT></TD>";
139	echo "</TR>";
140	echo "\n";
141	}
142	?>
143
144	<?
145
146	print_date("Begin", "begin", $begin);
147	print_date("End", "end", $finish);
148
149	if ($id) {
150	echo "<input type=hidden name=id value=\"$id\">"
151	}
152
153	?>
154
155
156	<TR><TD><B>City</B></TD><TD><INPUT name = "city" type = "text" value="<? echo $city ?>"></TD></TR>
157	<TR><TD><B>Country</B></TD><TD><INPUT name = "country" type = "text" value="<? echo $country ?>"></TD></TR>
158	<TR><TD> </TD><TD><INPUT type="submit" value="Submit"></TD></TR>
159	</FORM>
160	</TD>
161	</TR>
162	</TABLE>
163