} 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 . '",';