From: Patrick McGuire <insidenothing@gmail.com>
Date: Sun, 14 Jun 2020 14:42:20 +0000 (-0400)
Subject: Update download.php
X-Git-Tag: v1.0.0~121
X-Git-Url: https://git.hcoop.net/clinton/MarylandElectronicPetitionSignature.git/commitdiff_plain/5b8ad2d1d420633e36328132afeb5f58d939235f

Update download.php
---

diff --git a/admin/download.php b/admin/download.php
index 9c4f393..8d434ec 100644
--- a/admin/download.php
+++ b/admin/download.php
@@ -6,9 +6,9 @@ function mysqli_field_name($result, $field_offset)
     return is_object($properties) ? $properties->name : null;
 }
 if ($_COOKIE['level'] == 'admin'){
-  $q = "SELECT date_time_signed, signed_name_as, printed_status FROM petitions where signature_status = 'verified' ORDER BY id";
+  $q = "SELECT date_time_signed, signed_name_as, petition_id FROM signatures where signature_status = 'verified' ORDER BY id";
 }else{
-  $q = "SELECT date_time_signed, signed_name_as, printed_status FROM petitions where petition_id = '$_COOKIE[petition_id]' and signature_status = 'verified' ORDER BY id";
+  $q = "SELECT date_time_signed, signed_name_as FROM signatures where petition_id = '$_COOKIE[petition_id]' and signature_status = 'verified' ORDER BY id";
 }
 
 $r = $petition->query($q);