| 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 |
$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 |
$begin = $finish = "";
|
| 65 |
$city = $country = "";
|
| 66 |
}
|
| 67 |
|
| 68 |
$year = $month = "";
|
| 69 |
|
| 70 |
?>
|
| 71 |
|
| 72 |
<div align="center">
|
| 73 |
<TABLE summary="">
|
| 74 |
<FORM method="post" action="gpgregister.php">
|
| 75 |
|
| 76 |
|
| 77 |
<TR><TD>Begin</TD><TD><SELECT name = "year">
|
| 78 |
<?
|
| 79 |
|
| 80 |
$years = array("2001", "2002", "2003", "always");
|
| 81 |
foreach ($years as $i) {
|
| 82 |
echo "<OPTION";
|
| 83 |
if ($year == $i || (!year && $i == "always")) {
|
| 84 |
echo " SELECTED";
|
| 85 |
}
|
| 86 |
echo ">$i\n";
|
| 87 |
}
|
| 88 |
?>
|
| 89 |
</SELECT></TD>
|
| 90 |
|
| 91 |
<TD><SELECT name = "month">
|
| 92 |
<?
|
| 93 |
$months = array("January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December");
|
| 94 |
$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 |
?>
|
| 105 |
</SELECT></TD>
|
| 106 |
|
| 107 |
<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 |
</SELECT></TD>
|
| 119 |
</TR>
|
| 120 |
|
| 121 |
<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 |
</FORM>
|
| 124 |
</TD>
|
| 125 |
</TR>
|
| 126 |
</TABLE>
|
| 127 |
|
Parent Directory
| 
Revision Log