function get_sub_info($id)
{
$sql = <<<EOD
SELECT email_id, email_address, email_status, email_created,
email_candles_zipcode, email_candles_city,
email_candles_geonameid,
email_candles_havdalah, email_optin_announce
FROM hebcal_shabbat_email
WHERE hebcal_shabbat_email.email_id = '{$id}'
EOD;
$mysqli = hebcal_open_mysqli_db();
$result = mysqli_query($mysqli, $sql) or die("Invalid query 1: " . mysqli_error($mysqli));
if (mysqli_num_rows($result) != 1) {
return array();
}
list($id, $address, $status, $created, $zip, $city, $geonameid, $havdalah, $optin_announce) = mysqli_fetch_row($result);
$val = array("id" => $id, "status" => $status, "em" => $address, "m" => $havdalah, "upd" => $optin_announce, "zip" => $zip, "city" => $city, "geonameid" => $geonameid, "t" => $created);
mysqli_free_result($result);
return $val;
}
function sql_unsub($em)
{
global $remoteAddr;
$sql = <<<EOD
UPDATE hebcal_shabbat_email
SET email_status='unsubscribed',email_ip='{$remoteAddr}'
WHERE email_address = '{$em}'
EOD;
$mysqli = hebcal_open_mysqli_db();
return mysqli_query($mysqli, $sql);
}
