X-Git-Url: http://git.hcoop.net/clinton/MarylandElectronicPetitionSignature.git/blobdiff_plain/30f1a182529fac2f06cca7073167fddc12bae2c0..12e4ddb81f7cb6f500ee0e6fbe0f6d46bdc7ecc4:/presign.php diff --git a/presign.php b/presign.php index f7885ec..5237e89 100644 --- a/presign.php +++ b/presign.php @@ -1,4 +1,5 @@ real_escape_string($_POST['signed_name_ $date_of_birth = $petition->real_escape_string($_COOKIE['pDOB']); $signed_name_as_circulator = $petition->real_escape_string($_POST['signed_name_as_circulator']); $contact_phone = $petition->real_escape_string($_COOKIE['pPHONE']); +$shared_email = $petition->real_escape_string($_COOKIE['email']); $signature_status = $petition->real_escape_string($_COOKIE['signature_status']); $bot_check = $petition->real_escape_string($_SERVER['HTTP_USER_AGENT']); +$VoterList_table = $petition->real_escape_string($_COOKIE['VoterList_table']); +$php_session_id = session_id(); global $time_on_site; if (empty($_COOKIE['start_time'])){ setcookie("start_time", time()); @@ -31,27 +35,46 @@ if (empty($_COOKIE['start_time'])){ $now = time(); $time_on_site = $now - $_COOKIE['start_time']; } -$petition->query("insert into signatures (bot_check,VTRID,ip_address,date_of_birth,date_time_signed,just_date,petition_id,signed_name_as,signed_name_as_circulator,contact_phone,signature_status) values ('$bot_check','$VTRID','$ip','$date_of_birth',NOW(),NOW(),'$petition_id','$signed_name_as','$signed_name_as_circulator','$contact_phone','$signature_status')") or die(mysqli_error($petition)); +$petition->query("insert into signatures (shared_email,VoterList_table,php_session_id,bot_check,VTRID,ip_address,date_of_birth,date_time_signed,just_date,petition_id,signed_name_as,signed_name_as_circulator,contact_phone,signature_status) +values ('$shared_email','$VoterList_table','$php_session_id','$bot_check','$VTRID','$ip','$date_of_birth',NOW(),NOW(),'$petition_id','$signed_name_as','$signed_name_as_circulator','$contact_phone','$signature_status')") or die(mysqli_error($petition)); + +$last = $petition->insert_id; + +$petition->query("update presign set presign_status = 'SIGNED' where php_session_id = '$php_session_id' and presign_status = 'NEW' "); if($petition_id == '' || $petition_id == '0'){ slack_general_admin("MISSING petition_id",'md-petition-signed'); echo "