} else {
$dataQuery = DB::query($sql);
$data = 'all';
}
$numRows = $dataQuery->getRows();
$sql = "INSERT INTO downloadLog ( user_id, ip, numRows, encrypted, data ) VALUES ( ?, ?, ?, ?, ? )";
$pA = array('isiis', $user->getID(), $_SERVER['REMOTE_ADDR'], $numRows, $encrypted, $data);
DB::query($sql, $pA);
$headRecord = new Record($dataQuery->rows[0]->id);
$sql = "SELECT formFields.id as fieldID, labelText, pages_name, pages.label as pageLabel, fieldName, \n formFields.type, pages.id as pageID FROM formFields \n LEFT JOIN pages ON pages.name = pages_name \n WHERE dataName = 'record' AND pages_name != 'adverseevent'\n AND ( formFields.type != 'break' AND formFields.type != 'heading' AND formFields.type != 'data' )\n ORDER BY pageOrder, pages_name, entryorder";
$result = DB::query($sql);
$output = "";
$selectFields = array();
$cbFields = array();
foreach ($result->rows as $row) {
if ($include === 'dlsite' && !$trial->parseBranches($row->pageID, $headRecord->getID())) {
continue;
}
if (!$encrypted && $row->fieldName !== 'age' && $headRecord->isFieldEncrypted($row->pages_name, $row->fieldName)) {
continue;
}
switch ($row->type) {
case 'checkbox':
$sql = "SELECT value FROM formVal\n WHERE operator = 'IN LIST' AND\n formFields_id = ?";
$pA = array('i', $row->fieldID);
$valueTable = DB::query($sql, $pA);
$sql = "SELECT id, name FROM {$valueTable->value}";
$checkboxes = DB::query($sql);
foreach ($checkboxes->rows as $cb) {
$cbFields[$row->pages_name][$row->fieldName][] = $cb->id;
$output .= '"' . $row->pages_name . '_' . $row->labelText . '_' . $cb->name . '",';
