X-Git-Url: http://git.hcoop.net/clinton/MarylandElectronicPetitionSignature.git/blobdiff_plain/d3ffa763e7554bc4463d97c19c2b1f18be419d85..d46a6dd3be64893e950dc5486a5d7525904bb2af:/sign.php

diff --git a/sign.php b/sign.php
index 5baca92..818963f 100644
--- a/sign.php
+++ b/sign.php
@@ -1,6 +1,6 @@
 <?PHP 
 include_once('/var/www/secure.php'); 
-//include_once('../slack.php');
+include_once('slack.php');
 $petition_id = $_COOKIE['pID'];
 $VTRID = $_COOKIE['pVTRID'];
 if (!empty($_SERVER['HTTP_CLIENT_IP'])) {
@@ -17,35 +17,18 @@ $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']);
 
-$petition->query("insert into signatures (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 ('$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));
-/*slack_general_admin("$signed_name_as Petition $petition_id",'md-petition-signed');
-if($petition_id == '' || $petition_id == '0'){
- echo "<h1>AN ERROR HAS OCCURED - PLEASE TRY AGAIN <a href='reset.php'>HERE</a></h1>";   
- die();  // do not clear invite!!! 
+if (isset($_GET['s'])){
+    $last = $_GET['s'];
+}elseif($_COOKIE['last']){
+    $last = $_COOKIE['last']; // fall back on cookie
 }else{
-    
+    slack_general_admin("last petition cookie or get missing - directing to share",'md-petition-signed');
+    header('Location: share.php');  
 }
-*/
 
-$last = $petition->insert_id;
-setcookie("invite_used", $_COOKIE['invite']);
-setcookie("invite", ""); // clear invite
-//header('Location: eligible.php');
 include_once('header.php'); 
-
-
-
-
-$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)){
-  if ($d['count'] > 1){
-    $msg = "*ALERT* https://www.md-petition.com/admin/abuse.php?ip_address=$d[ip_address] https://www.md-petition.com/admin/abuse.php?VTRID=$d[VTRID] $d[petition_id] $d[count]"; 
-    slack_general_admin($msg,'md-petition-signed');
-  }
-}
-
-
+$php_session_id = session_id();
+$petition->query("update presign set presign_status = 'SIGNED' where php_session_id = '$php_session_id' and presign_status = 'NEW' ");
 $qX = "select * from website_text where id = '9'";
 $rX = $petition->query($qX);
 $dX = mysqli_fetch_array($rX);