Update abuse.php

diff --git a/admin/abuse.php b/admin/abuse.php
index 70e3c28..e6ea57b 100644 (file)
--- a/admin/abuse.php
+++ b/admin/abuse.php
@@ -89,7 +89,7 @@ if (isset($_GET['ip_address'])){
 <h2>IP Address List</h2>
 <div>Watch for duplicates.</div>
 <?PHP
-$q="SELECT ip_address, petition_id, COUNT(*) as count FROM signatures where signature_status = 'verified' group by ip_address";
+$q="SELECT ip_address, petition_id, COUNT(*) as count FROM signatures where signature_status = 'verified' group by ip_address, petition_id";
 $r = $petition->query($q);
 while($d = mysqli_fetch_array($r)){
   if ($d['count'] > 1){
@@ -101,7 +101,7 @@ while($d = mysqli_fetch_array($r)){
 <h2>VTRID List</h2>
 <div>Watch for duplicates.</div>
 <?PHP
-$q="SELECT VTRID, petition_id, COUNT(*) as count FROM signatures where signature_status = 'verified' group by VTRID";
+$q="SELECT VTRID, petition_id, COUNT(*) as count FROM signatures where signature_status = 'verified' group by VTRID, petition_id";
 $r = $petition->query($q);
 while($d = mysqli_fetch_array($r)){ 
   if ($d['count'] > 1){