Update enter_information.php

[clinton/MarylandElectronicPetitionSignature.git] / presign.php

diff --git a/presign.php b/presign.php
index b66f1c0..450d8f9 100644 (file)
--- a/presign.php
+++ b/presign.php
@@ -24,6 +24,7 @@ $signed_name_as_circulator  = $petition->real_escape_string($_POST['signed_name_
 $contact_phone              = $petition->real_escape_string($_COOKIE['pPHONE']);
 $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 +34,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 (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 ('$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;
 
@@ -52,6 +53,10 @@ setcookie("last", $last);
 setcookie("invite_used", $_COOKIE['invite']);
 setcookie("invite", ""); // clear invite
 
+
+
+
+
 $q="SELECT ip_address, petition_id,VTRID, COUNT(*) as count FROM signatures where signature_status = 'verified' group by ip_address, petition_id, VTRID";
 $r = $petition->query($q);
 while($d = mysqli_fetch_array($r)){
@@ -60,6 +65,15 @@ while($d = mysqli_fetch_array($r)){
     slack_general_admin($msg,'md-petition-signed');
   }
 }
+
+$q = "select exit_page from petitions where petition_id = '$petition_id'";
+$r = $petition->query($q);
+$d = mysqli_fetch_array($r,MYSQLI_ASSOC);
+if ($d['exit_page'] != ''){
+    header('Location: '.$d['exit_page']);  
+    die();
+}
+
 header('Location: sign.php?s='.$last);
 
 ?>