X-Git-Url: https://git.pterodactylus.net/?a=blobdiff_plain;f=admin%2Fintroduce.php;h=216809d113b10ac9fec79b41e2a039b813f1b6cc;hb=5f8a87e41beeda971d6a47a6c6b0555da00af978;hp=b13a05e65dd4c55b9aeb37d837911ee134797795;hpb=c7fcb4c4bc5012a584add81a9509fc1f84c3c688;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 "
Type answers for a few puzzles and submit
";
- $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