prepare("SELECT LocalIdentityID, Name 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 FROM tblIntroductionPuzzleRequests WHERE UUID NOT IN (SELECT UUID FROM tblIdentityIntroductionInserts) AND Day>='".gmdate('Y-m-d',strtotime('-1 day'))."' AND Found='true';"); $st->execute(); while($record=$st->fetch()) { print ""; print ""; print ""; print ""; print "
"; } ?>