| 18 |
<? |
<? |
| 19 |
if (($db = open_db())) { |
if (($db = open_db())) { |
| 20 |
|
|
| 21 |
$sql = "SELECT id, forename, surname, email, offer, last_update FROM people2 WHERE email = '$s_username'"; |
$sql = "SELECT id, forename, surname, email, offer, last_update FROM people WHERE email = '$s_username'"; |
| 22 |
if (! ($result = pg_exec($db, $sql))) { |
if (! ($result = pg_exec($db, $sql))) { |
| 23 |
echo "Problem with query", pg_ErrorMessage($db), "<BR>"; |
echo "Problem with query", pg_ErrorMessage($db), "<BR>"; |
| 24 |
return FALSE; |
return FALSE; |
| 45 |
} else { |
} else { |
| 46 |
if ($passwd1 != "") { |
if ($passwd1 != "") { |
| 47 |
$passwd = passwd_crypt($passwd1); |
$passwd = passwd_crypt($passwd1); |
| 48 |
$sql = "UPDATE people2 SET forename = '$forename', surname = '$surname', email = '$email' , passwd = '$passwd', offer = '$offer', last_update = 'now' WHERE id=$id"; |
$sql = "UPDATE people SET forename = '$forename', surname = '$surname', email = '$email' , passwd = '$passwd', offer = '$offer', last_update = 'now' WHERE id=$id"; |
| 49 |
} else { |
} else { |
| 50 |
$sql = "UPDATE people2 SET forename = '$forename', surname = '$surname', email = '$email' , offer = '$offer', last_update = 'now' WHERE id=$id"; |
$sql = "UPDATE people SET forename = '$forename', surname = '$surname', email = '$email' , offer = '$offer', last_update = 'now' WHERE id=$id"; |
| 51 |
}; |
}; |
| 52 |
|
|
| 53 |
if (! ($result = pg_exec($db, $sql))) { |
if (! ($result = pg_exec($db, $sql))) { |