X-Git-Url: https://git.pterodactylus.net/?a=blobdiff_plain;f=admin%2Fintroduce.php;h=216809d113b10ac9fec79b41e2a039b813f1b6cc;hb=d8ccfe2b3944adf07d35534459cdda19d15217c8;hp=b13a05e65dd4c55b9aeb37d837911ee134797795;hpb=964f55fd550fc711c0320ce6a24ad713040695d0;p=fms.git

diff --git a/admin/introduce.php b/admin/introduce.php
index b13a05e..216809d 100644
--- a/admin/introduce.php
+++ b/admin/introduce.php
@@ -53,7 +53,7 @@ function content()
 	print "<br>Type answers for a few puzzles and submit<br>";
 	
 	
-	$st=$db->prepare("SELECT UUID,Day,IdentityID FROM tblIntroductionPuzzleRequests WHERE UUID NOT IN (SELECT UUID FROM tblIdentityIntroductionInserts) AND Day>='".gmdate('Y-m-d',strtotime('-1 day'))."' AND Found='true' ORDER BY IdentityID, Day DESC, RequestIndex DESC;");
+	$st=$db->prepare("SELECT UUID,Day,IdentityID FROM tblIntroductionPuzzleRequests WHERE UUID NOT IN (SELECT UUID FROM tblIdentityIntroductionInserts) AND UUID NOT IN (SELECT UUID FROM tblIntroductionPuzzleInserts) AND Day>='".gmdate('Y-m-d',strtotime('-1 day'))."' AND Found='true' ORDER BY IdentityID, Day DESC, RequestIndex DESC;");
 	$st->execute();
 	
 	// only show latest captcha for each known identity