* do not publish! */ $GLOBALS['db'] = new PDO('pgsql:host=localhost;port=5432;dbname=flagbot;user=flagbot;password=flagbotpw'); $GLOBALS['db']->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $query = "SELECT count(*) as count , submitter, service, status FROM flags WHERE (received + INTERVAL '30 minute') > now() group by submitter, service, status order by count DESC"; if (isset($_REQUEST['all'])) $query = "SELECT count(*) as count , submitter, service, status FROM flags group by submitter, service, status order by count DESC"; ?>

Submission Board - Services/Exploits and their Flags

Flags Service + Exploit flags Alltime Service + Exploit flags Flag_IDs

Current Time:
NUM ROWS: query($query)->fetchAll()); ?>

query($query); while($row = $stmt->fetch(PDO::FETCH_ASSOC)) { ?>

count	service	submitter	status

Status: 0=submission pending; 1=submitted:OK; 2=submitted:Fail