$roles = array('offices' => array('athteam' => array('athteam'), 'damage' => array('damagecontrol'), 'historians' => array('historian'), 'imss' => array('headimssrep', 'imssrep'), 'librarians' => array('librarian'), 'socteam' => array('socteam')), 'people' => array('arc' => array('arcrep'), 'boc' => array('bocrep'), 'bookie' => array('bookie'), 'crc' => array('crcrep'), 'pope' => array('pope'), 'president' => array('president'), 'secretary' => array('secretary'), 'treasurer' => array('treasurer'), 'vp' => array('vicepresident')), 'support' => array('healthad' => array('healthad'), 'ra-prime' => array('ra'), 'ucc-prime' => array('coheaducc', 'ucc')));
$order = 'ORDER BY `class`, `name`';
$president = 'President <*****@*****.**>';
$secretary = 'Secretary <*****@*****.**>';
$pdo = new PDO('sqlite:../hovselist.db');
$year = date('Y') + (date('n') >= 7);
if (array_key_exists('action', $_POST)) {
header('HTTP/1.1 400 Bad Request');
header('Status: 400 Bad Request');
$content = '';
$format = "`name` || ' ''' || SUBSTR(`class`, 3) || ' <' || `email` || '>'";
$lists = array();
try {
switch ($_POST['action']) {
case 'delete':
$content = Mole::killMoleByUid($pdo, (int) $_POST['uid']);
break;
case 'gen_class':
$result = $pdo->prepare(<<<EOF
SELECT `class`,
\t{$format}
FROM `moles`
WHERE `alley` <> 'Social'
\tAND `class` <> ''
\tAND `class` >= {$year}
\tAND `position` <> 'RA'
{$order}
EOF
);
$result->execute();
$rows = $result->fetchAll(PDO::FETCH_COLUMN | PDO::FETCH_GROUP);
