Update printable_qr_code.php

[clinton/MarylandElectronicPetitionSignature.git] / sign.php

diff --git a/sign.php b/sign.php
dissimilarity index 69%
index bbf6280..818963f 100644 (file)
--- a/sign.php
+++ b/sign.php
@@ -1,20 +1,56 @@
-<?PHP 
-include_once('/var/www/secure.php'); 
-$petition_id = $_COOKIE['pID'];
-$VTRID = $_COOKIE['pVTRID'];
-if (!empty($_SERVER['HTTP_CLIENT_IP'])) {
-    $ip = $_SERVER['HTTP_CLIENT_IP'];
-} elseif (!empty($_SERVER['HTTP_X_FORWARDED_FOR'])) {
-    $ip = $_SERVER['HTTP_X_FORWARDED_FOR'];
-} else {
-    $ip = $_SERVER['REMOTE_ADDR'];
-}
-$signed_name_as             = $_POST['signed_name_as'];
-$date_of_birth              = $_COOKIE['pDOB'];
-$signed_name_as_circulator  = $_POST['signed_name_as_circulator'];
-$contact_phone              = $_COOKIE['pPHONE'];
-$signature_status           = $_COOKIE['signature_status'];
-$petition->query("insert into signatures (VTRID,ip_address,date_of_birth,date_time_signed,petition_id,signed_name_as,signed_name_as_circulator,contact_phone,signature_status) values ('$VTRID','$ip','$date_of_birth',NOW(),'$petition_id','$signed_name_as','$signed_name_as_circulator','$contact_phone','$signature_status')") or die(mysqli_error($petition));
-setcookie("invite_used", $_COOKIE['invite']);
-setcookie("invite", ""); // clear invite
-header('Location: eligible.php');
+<?PHP 
+include_once('/var/www/secure.php'); 
+include_once('slack.php');
+$petition_id = $_COOKIE['pID'];
+$VTRID = $_COOKIE['pVTRID'];
+if (!empty($_SERVER['HTTP_CLIENT_IP'])) {
+    $ip = $_SERVER['HTTP_CLIENT_IP'];
+} elseif (!empty($_SERVER['HTTP_X_FORWARDED_FOR'])) {
+    $ip = $_SERVER['HTTP_X_FORWARDED_FOR'];
+} else {
+    $ip = $_SERVER['REMOTE_ADDR'];
+}
+$signed_name_as             = $petition->real_escape_string($_POST['signed_name_as']);
+$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']);
+$signature_status           = $petition->real_escape_string($_COOKIE['signature_status']);
+$bot_check                  = $petition->real_escape_string($_SERVER['HTTP_USER_AGENT']);
+
+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');  
+}
+
+include_once('header.php'); 
+$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);
+?>
+<script>
+    document.title = "MEPS - Petition Signed";
+    alert("Petition Signed");
+</script>
+<div class='row'>
+ <div class='col-sm-10' style='text-align:center;'><h1><?PHP echo $dX['text_title'];?></h1></div>
+</div>
+<div class='row'>
+ <div class='col-sm-10' style='text-align:center;'><h2><?PHP echo $dX['text_block'];?></h2></div>
+</div>
+<div class='row'>
+ <div class='col-sm-10' style='text-align:center;'><br><button type="button" class="btn btn-success btn-lg btn-block" onclick="window.open('printer.php?id=<?PHP echo $last;?>')">View and/or Print</button></div>
+</div>
+<div class='row'>
+ <div class='col-sm-10' style='text-align:center;'><br><button type="button" class="btn btn-info btn-lg btn-block" onclick="window.location.href='eligible.php'">More Petitions</button></div>
+</div>
+<div class='row'>
+ <div class='col-sm-10' style='text-align:center;'><br><button type="button" class="btn btn-danger btn-lg btn-block" onclick="window.location.href='reset.php'">Reset / Restart</button></div>
+</div>
+<?PHP 
+include_once('footer.php');