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

        if (! $id) {
            $sql = "INSERT INTO places (who, city, country) VALUES ($who, '$city', '$country')";
            if (! ($result = pg_exec($db, $sql))) {
                echo "Problem with query", pg_ErrorMessage($db), "<BR>";
                return FALSE;
            }
            $oid = pg_getlastoid($result);
        } else {
            $sql = "UPDATE people SET city = '$city', country = '$country' WHERE id = '$id'";
            if (! ($result = pg_exec($db, $sql))) {
                echo "Problem with query", pg_ErrorMessage($db), "<BR>";
                return FALSE;
            }

            $sql = "SELECT oid FROM people WHERE id = '$id'";
            if (! ($result = pg_exec($db, $sql))) {
                echo "Problem with query", pg_ErrorMessage($db), "<BR>";
                return FALSE;
            }
            if (pg_NumRows($result) == 1) {
                $row = pg_Fetch_Array($result, 0);
                $oid = $row["oid"];
            } else {
               echo "Cannot find OID for ID."
               return FALSE;
            }

        }

        if ($begin_year == "always") {
            $begin = "";
        } else {
            $begin = sprint("%4d-%2d-%2d", $begin_year, $begin_month, $begin_day);
        }

        if ($begin) {
            $sql = "UPDATE people SET begin = '$begin' WHERE oid = '$oid'";
        } else {
            $sql = "UPDATE people SET begin = NULL WHERE oid = '$oid'";
        }
        if (! ($result = pg_exec($db, $sql))) {
            echo "Problem with query", pg_ErrorMessage($db), "<BR>";
            return FALSE;
        }

        if ($end_year == "always") {
            $end = "";
        } else {
            $end = sprint("%4d-%2d-%2d", $end_year, $end_month, $end_day);
        }

        if ($end) {
            $sql = "UPDATE people SET finish = '$end' WHERE oid = '$oid'";
        } else {
            $sql = "UPDATE people SET finish = NULL WHERE oid = '$oid'";
        }
        if (! ($result = pg_exec($db, $sql))) {
            echo "Problem with query", pg_ErrorMessage($db), "<BR>";
            return FALSE;
        }

        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	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	tbm	1.22	if (! $id) {
44			$sql = "INSERT INTO places (who, city, country) VALUES ($who, '$city', '$country')";
45			if (! ($result = pg_exec($db, $sql))) {
46			echo "Problem with query", pg_ErrorMessage($db), "<BR>";
47			return FALSE;
48			}
49	tbm	1.23	$oid = pg_getlastoid($result);
50			} else {
51			$sql = "UPDATE people SET city = '$city', country = '$country' WHERE id = '$id'";
52			if (! ($result = pg_exec($db, $sql))) {
53			echo "Problem with query", pg_ErrorMessage($db), "<BR>";
54			return FALSE;
55			}
56
57			$sql = "SELECT oid FROM people WHERE id = '$id'";
58			if (! ($result = pg_exec($db, $sql))) {
59			echo "Problem with query", pg_ErrorMessage($db), "<BR>";
60			return FALSE;
61			}
62			if (pg_NumRows($result) == 1) {
63			$row = pg_Fetch_Array($result, 0);
64			$oid = $row["oid"];
65			} else {
66			echo "Cannot find OID for ID."
67			return FALSE;
68			}
69
70			}
71
72			if ($begin_year == "always") {
73			$begin = "";
74			} else {
75			$begin = sprint("%4d-%2d-%2d", $begin_year, $begin_month, $begin_day);
76	tbm	1.22	}
77
78	tbm	1.23	if ($begin) {
79			$sql = "UPDATE people SET begin = '$begin' WHERE oid = '$oid'";
80			} else {
81			$sql = "UPDATE people SET begin = NULL WHERE oid = '$oid'";
82			}
83			if (! ($result = pg_exec($db, $sql))) {
84			echo "Problem with query", pg_ErrorMessage($db), "<BR>";
85			return FALSE;
86			}
87
88			if ($end_year == "always") {
89			$end = "";
90			} else {
91			$end = sprint("%4d-%2d-%2d", $end_year, $end_month, $end_day);
92			}
93
94			if ($end) {
95			$sql = "UPDATE people SET finish = '$end' WHERE oid = '$oid'";
96			} else {
97			$sql = "UPDATE people SET finish = NULL WHERE oid = '$oid'";
98			}
99			if (! ($result = pg_exec($db, $sql))) {
100			echo "Problem with query", pg_ErrorMessage($db), "<BR>";
101			return FALSE;
102			}
103	tbm	1.1
104	tbm	1.17	return TRUE;
105			}
106	tbm	1.1
107
108	tbm	1.17	# user wants to fill out the form
109	tbm	1.1
110			# modify an entry (if $id exists), or add a new one)
111			if ($id) {
112			$sql = "SELECT begin, finish, city, country FROM places WHERE id = '$id'";
113			if (! ($result = pg_exec($db, $sql))) {
114			echo "Problem with query", pg_ErrorMessage($db), "<BR>";
115			return FALSE;
116			}
117
118			if (pg_NumRows($result) != 1) {
119			echo "Not enough or too many results. That should not happen.";
120			return FALSE;
121			}
122
123			$row = pg_Fetch_Array($result, 0);
124			$begin = $row["begin"];
125			$finish = $row["finish"];
126			$city = $row["city"];
127			$country = $row["country"];
128			} else {
129	tbm	1.2	$begin = $finish = "";
130			$city = $country = "";
131	tbm	1.1	}
132	tbm	1.2
133	tbm	1.1	?>
134	tbm	1.2
135			<div align="center">
136			<TABLE summary="">
137	tbm	1.18	<FORM method="post" action="gpgplace.php">
138	tbm	1.4
139
140			<?
141
142	tbm	1.12	function print_date($title, $name, $date) {
143
144	tbm	1.14	$parsed_date = split("-", $date);
145			$year = $parsed_date[0];
146			$month = $parsed_date[1];
147			$day = $parsed_date[2];
148	tbm	1.12
149	tbm	1.13	echo "<TR><TD>$title</TD><TD><SELECT name = \"";
150	tbm	1.12	echo $name;
151			echo "_year\">";
152
153			$years = array("2001", "2002", "2003", "always");
154			foreach ($years as $i) {
155			echo "<OPTION";
156			if ($year == $i \|\| (!year && $i == "always")) {
157			echo " SELECTED";
158			}
159			echo ">$i\n";
160	tbm	1.4	}
161
162	tbm	1.12	echo "</SELECT></TD>";
163			echo "<TD><SELECT name = \"";
164			echo $name;
165			echo "_month\">";
166
167			$months = array("January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December");
168			$counter = 1;
169			foreach ($months as $i) {
170			echo "<OPTION value=$counter";
171			if ($month == $counter) {
172			echo " SELECTED";
173			}
174			echo ">$i\n";
175			$counter = $counter + 1;
176	tbm	1.4	}
177
178	tbm	1.12	echo "</SELECT></TD>";
179	tbm	1.15	echo "<TD><SELECT name = \"";
180	tbm	1.12	echo $name;
181			echo "_day\">";
182
183			for ($i = 1; $i < 32; $i++) {
184			echo "<OPTION";
185			if ($day == $i) {
186			echo " SELECTED";
187			}
188	tbm	1.15	echo ">$i";
189	tbm	1.12	}
190			echo "</SELECT></TD>";
191			echo "</TR>";
192			echo "\n";
193	tbm	1.16	}
194	tbm	1.6	?>
195	tbm	1.7
196	tbm	1.9	<?
197	tbm	1.12
198			print_date("Begin", "begin", $begin);
199			print_date("End", "end", $finish);
200	tbm	1.19
201			if ($id) {
202	tbm	1.21	echo "<input type=\"hidden\" name=\"id\" value=\"$id\">";
203	tbm	1.19	}
204	tbm	1.12
205	tbm	1.9	?>
206
207	tbm	1.4
208	tbm	1.3	<TR><TD><B>City</B></TD><TD><INPUT name = "city" type = "text" value="<? echo $city ?>"></TD></TR>
209			<TR><TD><B>Country</B></TD><TD><INPUT name = "country" type = "text" value="<? echo $country ?>"></TD></TR>
210	tbm	1.17	<TR><TD> </TD><TD><INPUT type="submit" value="Submit"></TD></TR>
211	tbm	1.2	</FORM>
212			</TD>
213			</TR>
214			</TABLE>
215	tbm	1.1