5) { $where = sprintf("WHERE id = %s AND email LIKE %s", GetSQLValueString($colname_contact, "int"), GetSQLValueString($login_email."%", "text")); switch ($_GET["action"]) { case "confirm": $updatesql = "UPDATE people SET query=0, notes=CONCAT(IFNULL(notes,''),',Reconfirmed ".date("Y.m.d")."') $where ;"; $action_msg = "Thanks for confirming your email address and that you want to keep receiving news from us. You don't need to do anything else."; break; case "stop-monthly": $updatesql = "UPDATE people SET monthly=0 $where"; break; case "start-monthly": $updatesql = "UPDATE people SET monthly=1 $where"; start_receiving($colname_contact,$_GET["e"],"monthly"); break; case "stop-fortnight": $updatesql = "UPDATE people SET fortnight=0 $where"; break; case "start-fortnight": $updatesql = "UPDATE people SET fortnight=1 $where"; start_receiving($colname_contact,$_GET["e"],"fortnightly"); break; case "stop-weekly": $updatesql = "UPDATE people SET weekly=0 $where"; break; case "start-weekly": $updatesql = "UPDATE people SET weekly=1 $where"; start_receiving($colname_contact,$_GET["e"],"weekly"); break; case "change_email": $updatesql = sprintf("UPDATE people SET email=%s WHERE id = %s AND email = %s", GetSQLValueString($login_email, "text"), GetSQLValueString($_GET['id'], "int"), GetSQLValueString(urldecode($_GET['old_email']), "text")); $action_msg = "Updated your email address to ".$_GET['e']; if (isset($_COOKIE["rowbory_comms_id"])) { setcookie ( "rowbory_comms_id", ($login_id*7)-3, time()+(60*60*24*30*6) ); setcookie ( "rowbory_comms_email", $login_email , time()+(60*60*24*30*6) ); } break; case "remove": $updatesql = "UPDATE people SET monthly=0, weekly=0, fortnight=0, notes='remove' $where"; remove_person($colname_contact,$_GET['e']); $action_msg = "All your subscriptions have been cancelled and your details will be removed within a few hours unless you get in touch to say otherwise."; break; } echo ""; $result = mysqli_query($contact_local,$updatesql) or die(mysqli_error($contact_local)); //header("Location: ".$_SERVER['PHP_SELF']."?".str_replace("action=","oldaction=",$_SERVER['QUERY_STRING'])); } else if (isset($_GET["confirm"])&&strlen($login_email)>5) { $where = sprintf("WHERE id = %s AND email LIKE %s", GetSQLValueString($colname_contact, "int"), GetSQLValueString($login_email."%", "text")); $updatesql = "UPDATE people SET query=0, notes=CONCAT(IFNULL(notes,''),';Reconfirmed ".date("Y.m.d")."') $where ;"; $action_msg = "Thanks for confirming your email address and that you want to keep receiving news from us. You don't need to do anything else."; $result = mysqli_query($contact_local,$updatesql) or die(mysqli_error($contact_local)); } // ------------------------------------------------------------------------ // ------------- NOW LOAD THE (possibly personalised) PAGE include("view_functions.php"); // check for login from cookies if (($login_email=="" || $login_id=="") && isset($_COOKIE["rowbory_comms_id"])) { $encoded_id = $_COOKIE["rowbory_comms_id"]; $encoded_email = $_COOKIE["rowbory_comms_email"]; $login_email = $encoded_email; $login_id = ($encoded_id + 3) / 7; } if (strlen($login_email)<5) { $login_email = "HACK ATTEMPT?"; } $where = sprintf("WHERE id = %s AND email LIKE %s", GetSQLValueString($login_id, "int"), GetSQLValueString($login_email."%", "text")); $query_contact = "SELECT * FROM people $where"; if (isset($_GET["debug"])) { echo ""; } $contact = mysqli_query($contact_local,$query_contact) or die(mysqli_error($contact_local)); $row_contact = mysql_fetch_assoc($contact); $totalRows_contact = mysql_num_rows($contact); $loggedIn = ($totalRows_contact>0); if ($loggedIn) { $name = $row_contact["name"]; $email = $row_contact["email"]; $m = $row_contact["monthly"]; $f = $row_contact["fortnight"]; $w = $row_contact["weekly"]; $id = $row_contact["id"]; if (isset($_GET["rememberme"])) { if ($_GET["rememberme"]==1) { // set cookie setcookie ( "rowbory_comms_id", ($id*7)-3, time()+(60*60*24*30*6) ); setcookie ( "rowbory_comms_email", $email , time()+(60*60*24*30*6) ); } else if ($_GET["rememberme"]==0) { // clear cookie setcookie ( "rowbory_comms_id", "" , time()+1 ); setcookie ( "rowbory_comms_email", "" , time()+1 ); header("Location: index.php"); } } } //echo ""; ?> " /> ".$action_msg."
"; } ?>Hello .
(If you bookmark this page it will remember who you are when you return.)
Your email address as we have it, is . (Change email address. • Remove my details.)
This computer is set to remember your identity, so you can return without using the special personal link emailed to you as a supporter. If you're sharing it with others, you might want to " style="font-weight: bold">tell rowbory.co.uk to forget me so you have to log in with your special email link to get your personal information.
Are you the only person using this computer? You might want to " style="font-weight: bold">tell rowbory.co.uk to remember me so you don't need to log in again.
We're not able to do everything on our own, and we depend on others' support in many ways. Especially while we're away from the UK, to help our friends and supporters keep up to date, and as food for prayer, we try to produce 3 types of news (take the timings as an ideal we never live up to):
|
>
|
|
>
|
|
>
|
If you are not receiving any of these publications, use the contact page to send us a message asking to find out more.
If you have started receiving emails from us, and want to change your details, or to unsubscribe, click on your personal link at the end of the email to change your options. Or get in touch with us directly.