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

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

?>


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