header('Location:index.php?page=' . $include);
exit;
}
$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);
$skipFields = array();
$encryptedFields = array();
$sql = "SELECT formFields.id as fieldID, labelText, pages_name, pages.label as pageLabel, CONCAT(pages_name,'_',fieldName) as finalFieldName, \n fieldName, formFields.type, pages.id as pageID, dl_name 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 = "'Signed',";
$selectFields = array();
$cbFields = array();
foreach ($result->rows as $row) {
if ($include === 'dlsite' && !$trial->parseBranches($row->pageID, $headRecord->getID())) {
$skipFields[] = $row->fieldID;
continue;
}
if ($headRecord->isFieldEncrypted($row->pages_name, $row->fieldName)) {
$encryptedFields[] = $row->fieldID;
if (!$encrypted && $row->fieldName !== 'age') {
$skipFields[] = $row->fieldID;
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);
public function addFlagInput($post)
{
$data = $this->record->getData($this->getPage());
$flag = new Flag();
$flag->link_id = $this->record->getID();
$flag->pages_name = $this->getPage();
foreach ($post as $key => $value) {
$page = substr($key, 0, strpos($key, "-"));
// Split out class and name from input field
$fieldName = substr($key, strpos($key, "-") + 1);
if ($page == 'flag') {
$flag->set($fieldName, $value);
}
}
if ($flag->isComplete()) {
$data->delete($flag->getFieldName());
$flag->saveToDB();
$flag->getFromDB();
$flag->flag_id = $flag->getID();
} else {
$flag = null;
}
return $flag;
}
