prepare("SELECT LocalIdentityID, Name, PublicKey FROM tblLocalIdentity ORDER BY Name;"); $st->execute(); print ""; } function content() { global $dblocation; $db=new PDO('sqlite:'.$dblocation); if(isset($_REQUEST["formaction"]) && $_REQUEST["formaction"]=="announce" && $_REQUEST["localidentityid"]!="") { $st=$db->prepare("INSERT INTO tblIdentityIntroductionInserts(LocalIdentityID,Day,UUID,Solution) VALUES(?,?,?,?);"); for($i=0; $ibindParam(1,$_REQUEST["localidentityid"]); $st->bindParam(2,$_REQUEST["day"][$i]); $st->bindParam(3,$_REQUEST["uuid"][$i]); $st->bindParam(4,$_REQUEST["solution"][$i]); $st->execute(); } } } ?>

Announce Identity

Select Identity to announce 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->execute(); // only show latest captcha for each known identity $lastid=''; $shown=0; while(($record=$st->fetch()) && $shown<30) { if($lastid!=$record[2]) { $lastid=$record[2]; print ""; print ""; print ""; print ""; print "
"; $shown++; } } if($shown>0) { ?>