X-Git-Url: https://git.pterodactylus.net/?p=fms.git;a=blobdiff_plain;f=admin%2Fintroduce.php;h=aafb20cc2656c36da1276dc7a899c33852d98902;hp=e3fbd8969c113027e5dee1594583287710489489;hb=868c533e84b3c81b6604b45b84efa32073aa20b4;hpb=6b896a9e1dc143bba86795be1e9336549db9b85f diff --git a/admin/introduce.php b/admin/introduce.php index e3fbd89..aafb20c 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, RequestIndex DESC;"); + $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->execute(); // only show latest captcha for each known identity