Update abuse.php
authorPatrick McGuire <insidenothing@gmail.com>
Tue, 9 Jun 2020 11:42:51 +0000 (07:42 -0400)
committerGitHub <noreply@github.com>
Tue, 9 Jun 2020 11:42:51 +0000 (07:42 -0400)
admin/abuse.php

index 73cfdee..b0ba0b3 100644 (file)
@@ -183,7 +183,33 @@ while($d = mysqli_fetch_array($r)){
   </td>
 
 
-</tr></table>
+</tr>
+<tr>
+<td valign="top">
+<h2>latest</h2>
+<div>last 0-10</div><ol>
+<?PHP
+$q="SELECT * FROM signatures order by id desc limit 0, 10";
+$r = $petition->query($q);
+while($d = mysqli_fetch_array($r)){ 
+    echo "<li>$d[date_time_signed] <a href='?ip_address=$d[ip_address]'>$d[ip_address]</a> <a target='_Blank' href='https://ipinfo.io/$d[ip_address]'>IP INFO</a> <a href='?VTRID=$d[VTRID]'>$d[VTRID]</a> ".id2petition($d['petition_id'])." $d[signed_name_as]</li>"; 
+}
+?></ol>
+  </td>
+<td valign="top">
+<h2>latest</h2>
+<div>last 10-20</div><ol>
+<?PHP
+$q="SELECT * FROM signatures order by id desc limit 10, 10";
+$r = $petition->query($q);
+while($d = mysqli_fetch_array($r)){ 
+    echo "<li>$d[date_time_signed] <a href='?ip_address=$d[ip_address]'>$d[ip_address]</a> <a target='_Blank' href='https://ipinfo.io/$d[ip_address]'>IP INFO</a> <a href='?VTRID=$d[VTRID]'>$d[VTRID]</a> ".id2petition($d['petition_id'])." $d[signed_name_as]</li>"; 
+}
+?></ol>
+  </td>
+
+  </tr>
+</table>
 
 
 <?PHP