public function buildObjectHTML($CRLF, $TAB, $PREFIX) { $dq = '"'; $fieldName = $PREFIX . $this->objectProperty['sob_all_name']; // $fieldTitle = $this->objectProperty['sob_all_title']; $fieldTitle = "<div id='{$fieldName}" . "_title'>" . $this->objectProperty['sob_all_title'] . '</div>'; if (!$this->displayThisObject) { //--set it blank so no title will be displayed $fieldTitle = ''; } $fieldValue = htmlentities($this->objectValue); $type = $this->objectProperty['sob_all_type']; $id = uniqid('', true); $pValue = addEscapes($this->objectValue); $ses = $_GET['ses']; $s = "INSERT INTO zzsys_variable (zzsys_variable_id, sva_id, sva_expiry_date, sva_session_id, sva_name, sva_value, sys_added) "; $s = $s . "VALUES ('{$id}', '{$this->formsessionID}', '" . nuDateAddDays(Today(), 2) . "', '{$ses}', '{$fieldName}', '{$pValue}', '" . date('Y-m-d H:i:s') . "')"; if ($type != 'words') { nuRunQuery($s); } if ($type == 'button') { $htmlString = $this->buildHTMLForButton($CRLF, $TAB, $fieldName, $fieldTitle, $fieldValue, $PREFIX); } if ($type == 'display') { $htmlString = $this->buildHTMLForDisplay($CRLF, $TAB, $fieldName, $fieldTitle, $fieldValue); } if ($type == 'dropdown') { $htmlString = $this->buildHTMLForDropdown($CRLF, $TAB, $fieldName, $fieldTitle, $fieldValue, $PREFIX); } if ($type == 'graph') { $htmlString = $this->buildHTMLForGraph($CRLF, $TAB, $fieldName, $fieldTitle, $fieldValue); } if ($type == 'html') { $htmlString = $this->buildHTMLForHtml($CRLF, $TAB, $fieldName, $fieldTitle, $fieldValue); } if ($type == 'inarray') { $htmlString = $this->buildHTMLForInarray($CRLF, $TAB, $fieldName, $fieldTitle, $fieldValue, $PREFIX); } if ($type == 'listbox') { $htmlString = $this->buildHTMLForListbox($CRLF, $TAB, $fieldName, $fieldTitle, $fieldValue); } if ($type == 'lookup') { $htmlString = $this->buildHTMLForLookup($CRLF, $TAB, $fieldName, $fieldTitle, $fieldValue, $PREFIX); } if ($type == 'text') { $htmlString = $this->buildHTMLForText($CRLF, $TAB, $fieldName, $fieldTitle, $fieldValue, $PREFIX); } if ($type == 'textarea') { $htmlString = $this->buildHTMLForTextarea($CRLF, $TAB, $fieldName, $fieldTitle, $fieldValue, $PREFIX); } if ($type == 'words') { $htmlString = $this->buildHTMLForWords($CRLF, $TAB); } if ($type == 'subform') { $htmlString = $this->buildHTMLForSubform($CRLF, $TAB, $fieldName, $fieldTitle, $this->objectProperty['sob_subform_blank_rows'], $this->objectProperty['zzsys_object_id']); } nuRunQuery("DROP TABLE IF EXISTS `{$this->TT}`"); return $htmlString; }
function setnuVariable($pID, $pExpire, $pName, $pValue) { $id = uniqid('1'); $now = date('Y-m-d H:i:s'); $dq = '"'; $pValue = addEscapes($pValue); $ses = $_GET['ses']; nudebug("ses:{$ses}"); $s = "DELETE FROM zzsys_variable WHERE sva_id = '{$pID}' AND sva_name = '{$pName}'"; nuRunQuery($s); $s = "INSERT INTO zzsys_variable (zzsys_variable_id, sva_id, sva_session_id, sva_expiry_date, sva_name, sva_value, sys_added) "; $s = $s . "VALUES ('{$id}', '{$pID}', '{$ses}', '{$pExpire}', '{$pName}', '{$pValue}', '{$now}')"; nuRunQuery($s); }