GA4

[clinton/MarylandElectronicPetitionSignature.git] / presign.php

diff --git a/presign.php b/presign.php
index 286d4a7..5237e89 100644 (file)
--- a/presign.php
+++ b/presign.php
@@ -22,8 +22,10 @@ $signed_name_as             = $petition->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'])){
@@ -33,8 +35,8 @@ if (empty($_COOKIE['start_time'])){
   $now  = time();
   $time_on_site = $now - $_COOKIE['start_time']; 
 }
-$petition->query("insert into signatures (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 ('$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));
+$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;