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; }