function searchAssign() { parent::searchAssign(); $searchGlobalParams = $this->searchClauseObj->getSearchGlobalParams(); $searchPanelAttrs = $this->searchClauseObj->getSrchPanelAttrs(); // show hide window $this->xt->assign("showHideSearchWin_attrs", ' title="Floating window"'); $searchOpt_mess = $searchPanelAttrs['srchOptShowStatus'] ? "Hide search options" : "Show search options"; $this->xt->assign("showHideSearchPanel_attrs", 'align="absmiddle" title="' . $searchOpt_mess . '" alt="' . $searchOpt_mess . '"'); $searchforAttrs = "name=\"ctlSearchFor" . $this->id . "\" id=\"ctlSearchFor" . $this->id . "\""; if ($this->isUseAjaxSuggest) { $searchforAttrs .= "autocomplete=off "; } $searchforAttrs .= ' placeholder="' . "search" . '"'; if ($this->searchClauseObj->isUsedSrch()) { $valSrchFor = $searchGlobalParams["simpleSrch"]; $searchforAttrs .= " value=\"" . runner_htmlspecialchars($valSrchFor) . "\""; } $this->xt->assignbyref("searchfor_attrs", $searchforAttrs); $this->xt->assign('searchPanelTopButtons', $this->isDisplaySearchPanel); if ($this->pSet->showSimpleSearchOptions()) { $simpleSearchTypeCombo = '<select id="simpleSrchTypeCombo' . $this->id . '" name="simpleSrchTypeCombo' . $this->id . '" size="1">'; $simpleSearchTypeCombo .= $this->searchControlBuilder->getSimpleSearchTypeCombo($searchGlobalParams["simpleSrchTypeComboOpt"], $searchGlobalParams["simpleSrchTypeComboNot"]); $simpleSearchTypeCombo .= "</select>"; $this->xt->assign('simpleSearchTypeCombo', $simpleSearchTypeCombo); $simpleSearchFieldCombo = '<select id="simpleSrchFieldsCombo' . $this->id . '" name="simpleSrchFieldsCombo' . $this->id . '" size="1">'; $simpleSearchFieldCombo .= $this->searchControlBuilder->simpleSearchFieldCombo($this->allSearchFields, $searchGlobalParams["simpleSrchFieldsComboOpt"]); $simpleSearchFieldCombo .= "</select>"; $this->xt->assign('simpleSearchFieldCombo', $simpleSearchFieldCombo); } }
function buildControl($value, $mode, $fieldNum, $validate, $additionalCtrlParams, $data) { parent::buildControl($value, $mode, $fieldNum, $validate, $additionalCtrlParams, $data); $inputType = $this->pageObject->pSetEdit->getHTML5InputType($this->field); $altAttr = ( $mode == MODE_INLINE_EDIT || $mode == MODE_INLINE_ADD ) && $this->is508 == true ? ' alt="' . $this->strLabel . '" ' : ''; //Alterado por Helbert em 04/06/2015 //Se o campo for de data, cria a class do input como datepiker if ($this->cfield == "value_DATA_VENCIMENTO_1" OR $this->cfield == "value_DATA_RECEBIMENTO_1" OR $this->cfield == "value_DATA_PAGAMENTO_1" OR $this->cfield == "value1_DATA_VENCIMENTO_1" OR $this->cfield == "value1_DATA_PAGAMENTO_1" OR $this->cfield == "value1_DATA_RECEBIMENTO_1" ) { $class = 'class="datepicker" readonly = "true"'; } echo '<input id="' . $this->cfield . '" ' . $this->inputStyle . $class . ' type="' . $inputType . '" ' . ($mode == MODE_SEARCH ? ' ' : '') . $altAttr . 'name="' . $this->cfield . '" ' . $this->pageObject->pSetEdit->getEditParams($this->field) . ' value="' . runner_htmlspecialchars($value) . '">'; $this->buildControlEnd($validate); }
function buildControl($value, $mode, $fieldNum, $validate, $additionalCtrlParams, $data) { if ($this->container->pageType == PAGE_LIST || $this->container->pageType == PAGE_SEARCH) { $value = prepare_for_db($this->field, $value, "time"); } parent::buildControl($value, $mode, $fieldNum, $validate, $additionalCtrlParams, $data); echo '<input id="' . $this->ctype . '" ' . $this->inputStyle . ' type="hidden" name="' . $this->ctype . '" value="time">'; $arr_number = parsenumbers((string) $value); if (count($arr_number) == 6) { $value = mysprintf("%d:%02d:%02d", array($arr_number[3], $arr_number[4], $arr_number[5])); } $timeAttrs = $this->pageObject->pSetEdit->getFormatTimeAttrs($this->field); if (count($timeAttrs)) { $input = '<input type="text" ' . $this->inputStyle . ' name="' . $this->cfield . '" ' . (($mode == MODE_INLINE_EDIT || $mode == MODE_INLINE_ADD) && $this->is508 == true ? 'alt="' . $this->strLabel . '" ' : '') . 'id="' . $this->cfield . '" ' . $this->pageObject->pSetEdit->getEditParams($this->field); if ($timeAttrs["useTimePicker"]) { $convention = $timeAttrs["hours"]; $loc = getLacaleAmPmForTimePicker($convention, true); $tpVal = getValForTimePicker($this->type, $value, $loc['locale']); echo $input . ' value="' . runner_htmlspecialchars($tpVal['val']) . '">'; echo ' '; echo '<a class="rnr-imgclock" data-icon="timepicker" title="Time" style="display:inline-block; margin:4px 0 0 6px; visibility: hidden;" id="trigger-test-' . $this->cfield . '" /></a>'; } else { echo $input . ' value="' . runner_htmlspecialchars($value) . '">'; } } $this->buildControlEnd($validate); }
public function getValueHighlighted($value, $highlightData) { $searchWordArr = array(); foreach ($highlightData['searchWords'] as $searchWord) { $word = preg_replace('/[\\.,]/', '', $searchWord); $wordArr = str_split($word); $word = implode("[^\\d]{0,2}", $wordArr); //add thousands and decimals separators to the pattern $word = runner_htmlspecialchars($word); if ($searchOpt == 'Starts with') { $word = "^" . $word; } $searchWordArr[] = $word; } $pattern = '/(' . implode('|', $searchWordArr) . ')/'; $searchOpt = $highlightData['searchOpt']; switch ($searchOpt) { case 'Equals': return $this->addHighlightingSpan($value); case 'Starts with': return preg_replace($pattern, $this->addHighlightingSpan('$1'), $value); case 'Contains': return preg_replace($pattern, $this->addHighlightingSpan('$1'), $value); default: return $value; } }
function buildControl($value, $mode, $fieldNum, $validate, $additionalCtrlParams, $data) { parent::buildControl($value, $mode, $fieldNum, $validate, $additionalCtrlParams, $data); $inputType = $this->pageObject->pSetEdit->getHTML5InputType($this->field); $altAttr = ($mode == MODE_INLINE_EDIT || $mode == MODE_INLINE_ADD) && $this->is508 == true ? ' alt="' . $this->strLabel . '" ' : ''; echo '<input id="' . $this->cfield . '" ' . $this->inputStyle . ' type="' . $inputType . '" ' . ($mode == MODE_SEARCH ? 'autocomplete="off" ' : '') . $altAttr . 'name="' . $this->cfield . '" ' . $this->pageObject->pSetEdit->getEditParams($this->field) . ' value="' . runner_htmlspecialchars($value) . '">'; $this->buildControlEnd($validate); }
public function showDBValue(&$data, $keylink) { $result = $this->getTextValue($data); if (!$this->container->forExport || $this->container->forExport && $this->container->forExport != "excel" && $this->container->forExport != "csv") { $result = runner_htmlspecialchars($result); } return $result; }
function buildControl($value, $mode, $fieldNum, $validate, $additionalCtrlParams, $data) { parent::buildControl($value, $mode, $fieldNum, $validate, $additionalCtrlParams, $data); if ($mode == MODE_EDIT || $mode == MODE_ADD || $mode == MODE_INLINE_EDIT || $mode == MODE_INLINE_ADD) { echo '<span id="readonly_' . $this->cfield . '" ' . $this->inputStyle . '>' . $this->pageObject->readOnlyFields[$this->field] . '</span>'; } echo '<input id="' . $this->cfield . '" type="Hidden" name="' . $this->cfield . '" value="' . runner_htmlspecialchars($value) . '">'; $this->buildControlEnd($validate); }
function searchAssign() { parent::searchAssign(); $searchforAttrs = 'placeholder="' . "buscar" . '"'; $searchGlobalParams = $this->searchClauseObj->getSearchGlobalParams(); if ($this->searchClauseObj->isUsedSrch()) { $valSrchFor = $searchGlobalParams["simpleSrch"]; $searchforAttrs .= " value=\"" . runner_htmlspecialchars($valSrchFor) . "\""; } $searchforAttrs .= " size=\"15\" name=\"ctlSearchFor" . $this->id . "\" id=\"ctlSearchFor" . $this->id . "\""; $this->xt->assign("searchfor_attrs", $searchforAttrs); }
public function showDBValue(&$data, $keylink) { $value = ""; $this->upload_handler->tkeys = $keylink; $filesArray = $this->getFilesArray($data[$this->field]); $showThumbnails = $this->container->pSet->showThumbnail($this->field); $isExport = $this->container->pageType == PAGE_EXPORT || $this->container->forExport != ''; if ($showThumbnails) { $zoomboxRand = rand(11111, 99999); } foreach ($filesArray as $file) { $userFile = $this->upload_handler->buildUserFile($file); if (!$isExport) { $value .= $value != "" ? "</br>" : ""; if ($showThumbnails && $userFile["thumbnail_url"] != "" && CheckImageExtension($file["name"])) { $value .= "<a target=_blank href=\"" . runner_htmlspecialchars($userFile["url"]) . "\" class='zoombox zgallery" . $zoomboxRand . "'><img border='0'"; if ($this->is508) { $value .= " alt=\"" . runner_htmlspecialchars($userFile["name"]) . "\""; } $value .= " src=\"" . runner_htmlspecialchars(GetRootPathForResources($userFile["thumbnail_url"])) . "\" /></a>"; } else { if ($this->container->pSet->showIcon($this->field)) { $value .= '<a href="' . runner_htmlspecialchars($userFile["url"]) . '"><img style="vertical-align: middle;" src="' . GetRootPathForResources('images/icons/' . $this->getFileIconByType($file["name"], $file["type"])) . '" /></a>'; } } } if ($this->container->pSet->showCustomExpr($this->field)) { $value .= fileCustomExpression($file, $data, $this->field, $this->container->pageType); } else { if ($isExport) { $value .= ($value != "" ? ", " : "") . $file["usrName"]; } else { if ($showThumbnails && $userFile["thumbnail_url"] != "" && CheckImageExtension($file["name"]) && $value != "") { $value .= "<br />"; } $label = runner_htmlspecialchars($file["usrName"] != "" ? $file["usrName"] : $file["name"]); if ($this->searchHighlight) { $label = $this->highlightSearchWord($label, true, ""); } $value .= '<a dir="LTR" href="' . runner_htmlspecialchars($userFile["url"]) . '">' . $label . '</a>'; } } if ($this->container->pSet->showFileSize($this->field)) { $fileSizeAndUnit = $this->getFileSizeAndUnits($file["size"]); $value .= " " . str_format_number(round($fileSizeAndUnit["size"], 2)) . " " . $this->sizeUnits[$fileSizeAndUnit["unitIndex"]]; } } return $value; }
public function showDBValue(&$data, $keylink) { $value = ""; if (@$data[$this->field] != NULL && $this->container->pageType != PAGE_PRINT) { $videoId = 'video_' . GoodFieldName(runner_htmlspecialchars($this->field)) . '_'; $videoId .= $this->getContainer()->id . "_"; if ($this->getContainer()->pageType != PAGE_ADD) { $videoId .= $this->getContainer()->recId; } else { $videoId .= postvalue("id"); } $type = 'video/mp4'; $fileName = 'file.mp4'; $fileNameF = $this->getContainer()->pSet->getFilenameField($this->field); if ($fileNameF) { $fileName = $data[$fileNameF]; if (!$fileName) { $fileName = 'file.mp4'; } else { $type = getContentTypeByExtension(substr($fileName, strrpos($fileName, '.'))); } } $href = GetTableLink("mfhandler", "", "filename=" . $fileName . "&table=" . rawurlencode($this->getContainer()->pSet->_table) . "&field=" . rawurlencode($this->field) . "&pageType=" . $this->getContainer()->pageType . $keylink); $vWidth = $this->getContainer()->pSet->getVideoWidth($this->field); $vHeight = $this->getContainer()->pSet->getVideoHeight($this->field); if ($vWidth == 0) { $vWidth = 300; } if ($vHeight == 0) { $vHeight = 200; } $value .= ' <div style="width:' . $vWidth . 'px; height:' . $vHeight . 'px;"> <video class="projekktor" width="' . $vWidth . '" height="' . $vHeight . '" id="' . $videoId . '" type="' . $type . '" src="' . $href . '" > </video></div>'; if ($this->pageObject != null) { $this->pageObject->controlsMap['video'][] = $videoId; } } else { $fileNameF = $this->getContainer()->pSet->getFilenameField($this->field); if ($fileNameF) { $fileName = $data[$fileNameF]; if (!$fileName) { $value = $fileName; } } } return $value; }
public function showDBValue(&$data, $keylink) { $value = ""; $fileName = $data[$this->field]; if (strlen($fileName)) { $fieldIsUrl = $this->container->pSet->isVideoUrlField($this->field); if (!$fieldIsUrl) { $this->upload_handler->tkeys = $keylink; $filesArray = $this->getFilesArray($fileName); } else { $filesArray = array($fileName); } $title = ""; $titleField = $this->container->pSet->getAudioTitleField($this->field); if ($titleField) { $title = runner_htmlspecialchars($data[$titleField]); } foreach ($filesArray as $file) { if ($this->container->pageType == PAGE_EXPORT || $this->container->pageType == PAGE_PRINT || $this->container->forExport != '') { if ($value != "") { $value .= ", "; } $value .= $fieldIsUrl ? $file : $file["usrName"]; continue; } // if file if (!$fieldIsUrl) { if (!file_exists(getabspath($file["name"]))) { continue; } } if ($fieldIsUrl) { $href = $file; } else { $userFile = $this->upload_handler->buildUserFile($file); $href = runner_htmlspecialchars($userFile["url"]); if (!$title || !$titleField) { $title = $userFile["name"]; } } $link = '<a title="' . $title . '" href="' . $href . '">' . $title . '</a>'; $value .= ($value == "" ? "" : "<br />") . '<audio controls preload="none" src="' . $href . '">' . $link . '</audio>'; } } return $value; }
public function showDBValue(&$data, $keylink) { $value = ""; $fileNameF = $this->container->pSet->getFilenameField($this->field); if ($fileNameF) { $fileName = $data[$fileNameF]; if (!$fileName) { $fileName = "file.bin"; } } else { $fileName = "file.bin"; } if (strlen($data[$this->field])) { $value = "<a href='" . GetTableLink("getfile", "", "table=" . GetTableURL($this->container->pSet->_table) . "&filename=" . rawurlencode($fileName) . "&field=" . rawurlencode($this->field) . $keylink) . "'>"; $value .= runner_htmlspecialchars($fileName); $value .= "</a>"; } return $value; }
public function showDBValue(&$data, $keylink) { $value = ""; $title = ""; $titleField = $this->container->pSet->getAudioTitleField($this->field); if ($titleField) { $title = runner_htmlspecialchars($data[$titleField]); } if (@$data[$this->field] != NULL && $this->container->pageType != PAGE_PRINT) { if (!$title) { $title = "Track.mp3"; } $href = GetTableLink('getfile', '', 'table=' . GetTableURL($this->container->pSet->_table) . '&field=' . rawurlencode($this->field) . $keylink . '&filename=' . $title); $link = '<a title="' . $title . '" href="' . $href . '">' . $title . '</a>'; $value = '<audio controls preload="none" src="' . $href . '">' . $link . '</audio>'; } else { $value = $title; } return $value; }
public function showDBValue(&$data, $keylink) { if (!$this->pageObject) { return runner_htmlspecialchars($data[$this->field]); } elseif ($this->pageObject->pageType == PAGE_EXPORT || $this->pageObject->pageType == PAGE_RPRINT && $this->container->forExport == "excel") { return runner_htmlspecialchars($data[$this->field]); } if ($this->pageObject->pageType != PAGE_LIST) { $mapData = $this->pageObject->addGoogleMapData($this->field, $data); } if ($this->pageObject->pageType != PAGE_PRINT && $this->pageObject->pageType != PAGE_RPRINT) { return '<div id="littleMap_' . GoodFieldName($this->field) . '_' . $this->pageObject->recId . '" style="width: ' . ($this->pageObject->googleMapCfg['fieldsAsMap'] == null ? "100" : $this->pageObject->googleMapCfg['fieldsAsMap'][$this->field]['width'] . 'px; height: ') . ($this->pageObject->googleMapCfg['fieldsAsMap'] == null ? "100" : $this->pageObject->googleMapCfg['fieldsAsMap'][$this->field]['height'] . 'px;" ') . 'class="littleMap"></div>'; } if ($mapData['markers'][0]['lat'] == "" && $mapData['markers'][0]['lng'] == "") { $location = $mapData['markers'][0]['address']; } else { $location = $mapData['markers'][0]['lat'] . ',' . $mapData['markers'][0]['lng']; } $src = 'http://maps.googleapis.com/maps/api/staticmap?center=' . $location . '&zoom=' . $mapData['zoom'] . '&size=' . ($this->pageObject->googleMapCfg['fieldsAsMap'] == null ? "100" : $this->pageObject->googleMapCfg['fieldsAsMap'][$this->field]['width']) . 'x' . ($this->pageObject->googleMapCfg['fieldsAsMap'] == null ? "100" : $this->pageObject->googleMapCfg['fieldsAsMap'][$this->field]['height']) . '&maptype=mobile&markers=' . $location . '&sensor=false'; return '<img border="0" alt="" src="' . $src . '">'; }
public function getValueHighlighted($value, $highlightData) { $searchWordArr = array(); foreach ($highlightData['searchWords'] as $searchWord) { $word = $searchWord; $wordArr = str_split($word); $word = implode("([\\-\\(]|\\) )?", $wordArr); $searchWordArr[] = '[(]?' . runner_htmlspecialchars($word); } $searchWord = implode('|', $searchWordArr); $searchOpt = $highlightData['searchOpt']; switch ($searchOpt) { case 'Equals': return $this->addHighlightingSpan($value); case 'Starts with': return preg_replace('/^(' . $searchWord . ')/', $this->addHighlightingSpan('$1'), $value); case 'Contains': return preg_replace('/(' . $searchWord . ')/', $this->addHighlightingSpan('$1'), $value); default: return $value; } }
$strLabel = GetFieldLabel("DashboardUsers", "email"); $message .= $strLabel . ": " . $values["email"] . "\r\n"; $strLabel = GetFieldLabel("DashboardUsers", "active"); $message .= $strLabel . ": " . $values["active"] . "\r\n"; $strLabel = GetFieldLabel("DashboardUsers", "fullname"); $message .= $strLabel . ": " . $values["fullname"] . "\r\n"; $strLabel = GetFieldLabel("DashboardUsers", "groupid"); $message .= $strLabel . ": " . $values["groupid"] . "\r\n"; $sentMailResults = runner_mail(array('to' => "*****@*****.**", 'subject' => "Notification on registering", 'body' => $message)); if (!count($sentMailResults) || $sentMailResults['mailed']) { // show Registartion successful message $pageObject->updatePageLayoutAndCSS('', 'success'); $pageObject->addCommonJs(); $pageObject->fillSetCntrlMaps(); $pageObject->addButtonHandlers(); $pageObject->body["begin"] .= $includes . "<form method=\"POST\" action=\"" . GetTableLink("login") . "\" name=\"loginform\">\n\t\t\t<input type=\"Hidden\" name=username value=\"" . runner_htmlspecialchars($strUsername) . "\">" . "<input type=\"Hidden\" name=password value=\"" . runner_htmlspecialchars($strPassword) . "\"></form>"; $pageObject->body["end"] .= "<script>"; $pageObject->body['end'] .= "window.controlsMap = " . my_json_encode($pageObject->controlsHTMLMap) . ";"; $pageObject->body['end'] .= "window.viewControlsMap = " . my_json_encode($pageObject->viewControlsHTMLMap) . ";"; $pageObject->body['end'] .= "window.settings = " . my_json_encode($pageObject->jsSettings) . ";</script>"; $pageObject->body['end'] .= "<script language=\"JavaScript\" src=\"" . GetRootPathForResources("include/runnerJS/RunnerAll.js") . "\"></script>\r\n"; $pageObject->body["end"] .= "<script>" . $pageObject->PrepareJS() . "</script>"; $xt->assign("registered_block", true); $xt->assign("body", $pageObject->body); $xt->assign("loginlink_attrs", "onclick=\"document.forms.loginform.submit();return false;\" id=\"ProceedToLogin\""); if (postvalue("onFly") == 1) { $pageObject->templatefile = GetTemplateName("", "register_success"); $xt->assign("id", $id); $xt->assign("footer", false); $xt->assign("header", false); $xt->assign("body", true);
while (($row = $qResult->fetchNumeric()) && count($response) < $numberOfSuggests) { $val = $cipherer->DecryptField($f, $row[0]); if (IsGuid($fType)) { $val = substr($val, 1, -1); } // "_" is added to conver number type to string $fieldControl->suggestValue("_" . $val, $searchFor, $response, $row); } } $_connection->close(); ksort($response, SORT_STRING); foreach ($response as $value => $realValue) { if (count($result) > $numberOfSuggests) { break; } $strValue = $value[0] == '_' ? substr($value, 1) : $value; // .net compatibility issue $strRealValue = $realValue[0] == '_' ? substr($realValue, 1) : $realValue; $pos = my_stripos($strValue, $searchFor, 0); if ($pos === FALSE) { $result[] = array("value" => runner_htmlspecialchars($strValue), "realValue" => $strRealValue); } else { $highlightedValue = runner_htmlspecialchars(substr($strValue, 0, $pos)) . "<b>" . runner_htmlspecialchars(substr($strValue, $pos, strlen($searchFor))) . "</b>" . runner_htmlspecialchars(substr($strValue, $pos + strlen($searchFor))); $result[] = array("value" => $highlightedValue, "realValue" => $strRealValue); } } $returnJSON = array(); $returnJSON['success'] = true; $returnJSON['result'] = $result; echo printJSON($returnJSON); exit;
function buildControl($value, $mode, $fieldNum, $validate, $additionalCtrlParams, $data) { parent::buildControl($value, $mode, $fieldNum, $validate, $additionalCtrlParams, $data); echo '<input id="' . $this->cfield . '" type="Hidden" name="' . $this->cfield . '" value="' . runner_htmlspecialchars($value) . '">'; $this->buildControlEnd($validate); }
foreach ( $arrPrivateCharts as $chart ) { if ( $chart["status"] == "public" ) { $private_charts .= '<div style="margin-bottom:5px;">'; $private_charts .= '<span class="ritem" id="' . $chart['name'] . '" title="'.runner_htmlspecialchars($chart['title']).'">'; $private_charts .= '<img src="images/unlock16.png" title="'."Public chart".'"/>'; $private_charts .= ( strlen( $chart['title'] ) > $cMaxTitleLength+5 ) ? substr( $chart['title'], 0, $cMaxTitleLength ) . "..." : $chart['title']; $private_charts .= '<a class="action view" type="chart" href="#">['."View".']</a>'; if(count($arr_tables_db) || count($arr_tables_project) || count($arr_tables_custom)) $private_charts .= '<a class="action edit" type="chart" href="#">['."Edit".']</a>'; $private_charts .= '<a class="action del" type="chart" href="#">['."Delete".']</a>'; $private_charts .= '</span>'; $private_charts .= '</div>'."\r\n"; } else { $private_charts .= '<div style="margin-bottom:5px;">'; $private_charts .= '<span class="ritem" id="' . $chart['name'] . '" title="'.runner_htmlspecialchars($chart['title']).'">'; $private_charts .= '<img src="images/lock16.png" title="'."Private chart".'"/>'; $private_charts .= ( strlen( $chart['title'] ) > $cMaxTitleLength+5 ) ? substr( $chart['title'], 0, $cMaxTitleLength ) . "..." : $chart['title']; $private_charts .= '<a class="action view" type="chart" href="#">['."View".']</a>'; if(count($arr_tables_db) || count($arr_tables_project) || count($arr_tables_custom)) $private_charts .= '<a class="action edit" type="chart" href="#">['."Edit".']</a>'; $private_charts .= '<a class="action del" type="chart" href="#">['."Delete".']</a>'; $private_charts .= '</span>'; $private_charts .= '</div>'."\r\n"; } } $xt->assign("css_height_report","height:100px;"); $xt->assign("css_height_chart","height:100px;"); if ((count($arrPrivateReports)>6 || count($arrSharedReports)>6) || (count($arrPrivateCharts)>6 || count ($arrSharedCharts)>6)) { $xt->assign("css_height_report","height:200px;");
function DisplayMasterTableInfoForPrint_GroupMaster($params) { global $cman; $detailtable = $params["detailtable"]; $keys = $params["keys"]; $xt = new Xtempl(); $tName = "GroupMaster"; $xt->eventsObject = getEventObject($tName); $cipherer = new RunnerCipherer($tName); $settings = new ProjectSettings($tName, PAGE_PRINT); $connection = $cman->byTable($tName); $masterQuery = $settings->getSQLQuery(); $viewControls = new ViewControlsContainer($settings, PAGE_PRINT); $where = ""; $keysAssoc = array(); $showKeys = ""; if ($detailtable == "BranchMaster") { $keysAssoc["Groupid"] = $keys[1 - 1]; $where .= RunnerPage::_getFieldSQLDecrypt("Groupid", $connection, $settings, $cipherer) . "=" . $cipherer->MakeDBValue("Groupid", $keys[1 - 1], "", true); $keyValue = $viewControls->showDBValue("Groupid", $keysAssoc); $showKeys .= " " . GetFieldLabel("GroupMaster", "Groupid") . ": " . $keyValue; $xt->assign('showKeys', $showKeys); } if ($detailtable == "CompanyMaster") { $keysAssoc["Groupid"] = $keys[1 - 1]; $where .= RunnerPage::_getFieldSQLDecrypt("Groupid", $connection, $settings, $cipherer) . "=" . $cipherer->MakeDBValue("Groupid", $keys[1 - 1], "", true); $keyValue = $viewControls->showDBValue("Groupid", $keysAssoc); $showKeys .= " " . GetFieldLabel("GroupMaster", "Groupid") . ": " . $keyValue; $xt->assign('showKeys', $showKeys); } if (!$where) { return; } $str = SecuritySQL("Export", $tName); if (strlen($str)) { $where .= " and " . $str; } $strWhere = whereAdd($masterQuery->m_where->toSql($masterQuery), $where); if (strlen($strWhere)) { $strWhere = " where " . $strWhere . " "; } $strSQL = $masterQuery->HeadToSql() . ' ' . $masterQuery->FromToSql() . $strWhere . $masterQuery->TailToSql(); LogInfo($strSQL); $data = $cipherer->DecryptFetchedArray($connection->query($strSQL)->fetchAssoc()); if (!$data) { return; } // reassign pagetitlelabel function adding extra params $xt->assign_function("pagetitlelabel", "xt_pagetitlelabel", array("record" => $data, "settings" => $settings)); $keylink = ""; $keylink .= "&key1=" . runner_htmlspecialchars(rawurlencode(@$data["Groupid"])); $xt->assign("Groupid_mastervalue", $viewControls->showDBValue("Groupid", $data, $keylink)); $format = $settings->getViewFormat("Groupid"); $class = " rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("Groupid"))) { $class = ' rnr-field-number'; } $xt->assign("Groupid_class", $class); // add class for field header as field value $xt->assign("GroupName_mastervalue", $viewControls->showDBValue("GroupName", $data, $keylink)); $format = $settings->getViewFormat("GroupName"); $class = " rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("GroupName"))) { $class = ' rnr-field-number'; } $xt->assign("GroupName_class", $class); // add class for field header as field value $xt->assign("GroupContactPerson_mastervalue", $viewControls->showDBValue("GroupContactPerson", $data, $keylink)); $format = $settings->getViewFormat("GroupContactPerson"); $class = " rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("GroupContactPerson"))) { $class = ' rnr-field-number'; } $xt->assign("GroupContactPerson_class", $class); // add class for field header as field value $xt->assign("GroupContactEmail_mastervalue", $viewControls->showDBValue("GroupContactEmail", $data, $keylink)); $format = $settings->getViewFormat("GroupContactEmail"); $class = " rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("GroupContactEmail"))) { $class = ' rnr-field-number'; } $xt->assign("GroupContactEmail_class", $class); // add class for field header as field value $xt->assign("GroupContactNumber_mastervalue", $viewControls->showDBValue("GroupContactNumber", $data, $keylink)); $format = $settings->getViewFormat("GroupContactNumber"); $class = " rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("GroupContactNumber"))) { $class = ' rnr-field-number'; } $xt->assign("GroupContactNumber_class", $class); // add class for field header as field value $xt->assign("GroupCloudFolder_mastervalue", $viewControls->showDBValue("GroupCloudFolder", $data, $keylink)); $format = $settings->getViewFormat("GroupCloudFolder"); $class = " rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("GroupCloudFolder"))) { $class = ' rnr-field-number'; } $xt->assign("GroupCloudFolder_class", $class); // add class for field header as field value $xt->assign("IsActive_mastervalue", $viewControls->showDBValue("IsActive", $data, $keylink)); $format = $settings->getViewFormat("IsActive"); $class = " rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("IsActive"))) { $class = ' rnr-field-number'; } $xt->assign("IsActive_class", $class); // add class for field header as field value $layout = GetPageLayout("GroupMaster", 'masterprint'); if ($layout) { $xt->assign("pageattrs", 'class="' . $layout->style . " page-" . $layout->name . '"'); } $xt->displayPartial(GetTemplateName("GroupMaster", "masterprint")); }
public function showDBValue($value, $keyLink) { $imageValue = ""; $this->initUploadHandler(); $this->upload_handler->tkeys = $keyLink; $filesArray = my_json_decode($value); if (!is_array($filesArray) || count($filesArray) == 0) { if ($value == "") { $filesArray = array(); } else { $uploadedFile = $this->upload_handler->get_file_object($value); if (is_null($uploadedFile)) { $filesArray = array(); } else { $filesArray = array($uploadedFile); } } } foreach ($filesArray as $imageFile) { $userFile = $this->upload_handler->buildUserFile($imageFile); if ($this->pageObject->pSetEdit->getViewFormat($this->field) == FORMAT_FILE) { $imageValue .= $imageValue != "" ? "</br>" : ""; $imageValue .= '<a href="' . runner_htmlspecialchars($userFile["url"]) . '">' . runner_htmlspecialchars($imageFile["usrName"] != "" ? $imageFile["usrName"] : $imageFile["name"]) . '</a>'; } else { if (CheckImageExtension($imageFile["name"])) { $imageValue .= $imageValue != "" ? "</br>" : ""; if ($this->pageObject->pSetEdit->showThumbnail($this->field)) { $thumbname = $userFile["thumbnail_url"]; $imageValue .= "<a target=_blank"; $imageValue .= " href=\"" . runner_htmlspecialchars($userFile["url"]) . "\" class='zoombox'>"; $imageValue .= "<img"; if ($thumbname == "" || $imageFile["name"] == $imageFile["thumbnail"]) { $imgWidth = $this->pageObject->pSetEdit->getImageWidth($this->field); $imageValue .= $imgWidth ? " width=" . $imgWidth : ""; $imgHeight = $this->pageObject->pSetEdit->getImageHeight($this->field); $imageValue .= $imgHeight ? " height=" . $imgHeight : ""; } $imageValue .= " border=0"; if ($this->is508) { $imageValue .= " alt=\"" . runner_htmlspecialchars($userFile["name"]) . "\""; } $imageValue .= " src=\"" . runner_htmlspecialchars($userFile["thumbnail_url"]) . "\"></a>"; } else { $imageValue .= "<img"; $imgWidth = $this->pageObject->pSetEdit->getImageWidth($this->field); $imageValue .= $imgWidth ? " width=" . $imgWidth : ""; $imgHeight = $this->pageObject->pSetEdit->getImageHeight($this->field); $imageValue .= $imgHeight ? " height=" . $imgHeight : ""; $imageValue .= " border=0"; if ($this->is508) { $imageValue .= " alt=\"" . runner_htmlspecialchars($userFile["name"]) . "\""; } $imageValue .= " src=\"" . runner_htmlspecialchars($userFile["url"]) . "\">"; } } } } return $imageValue; }
$tbl=$tbl_name["sqlname"]; $isStorProc=$tbl_name["isStorProc"]; } else { $tbl=$tbl_name; $isStorProc=false; } if(!$isStorProc) { $selected = ""; if ( !empty( $_SESSION['webreports']['tables'] ) ){ if ( in_array( $tbl, $_SESSION['webreports']['tables'] ) ) $selected = "selected"; } $tables .= '<option ' . $selected . ' value="' . runner_htmlspecialchars($tbl) . '">'.(!is_wr_project() ? $tbl : getCaptionTable($tbl)) . (is_wr_project() ? (getCaptionTable($tbl)!=$tbl ? " (".$tbl.")" : "" ) : "").'</option>'."\r\n"; } } if (@$_SESSION['webreports']['settings']['title'] != "") { $xt->assign("report_title",", "."Title".": ".@$_SESSION['webreports']['settings']['title']); } else { $xt->assign("report_title",""); } $xt->assign("tables", $tables); if(!count($arr_tables_db) && !count($arr_tables_project) || !count($arr_tables_custom) && !count($arr_tables_project) || !count($arr_tables_custom) && !count($arr_tables_db)) $xt->assign("radio_style","style='display:none';"); if(count($arr_tables_db)) $xt->assign("view_radio_db",true);
/** Private Array to XML. changes php arrays into xml text recursively. @param arg_arr_array the array to be changed into XML. @param arg_int_pad_number the number of pads of the current tag. @param arg_str_pad the indentation pad text. @return String xml text. @see array_to_xml(). @access Private. */ function prv_array_to_xml($arg_arr_array, $arg_int_pad_number = 0, $arg_str_pad = "") { $str_xml = ""; $keys = array_keys($arg_arr_array); for ($i = 0; $i < count($keys); $i++) { $k = $keys[$i]; $v = $arg_arr_array[$k]; $str_xml .= $this->pad($arg_int_pad_number, $arg_str_pad) . "<attr value=\"" . runner_htmlspecialchars($k) . "\">"; if (is_array($v)) { $str_xml .= $this->prv_array_to_xml($v, $arg_int_pad_number + 1, $arg_str_pad); } else { $str_xml .= $this->pad($arg_int_pad_number + 1, $arg_str_pad) . runner_htmlspecialchars($v); } $str_xml .= $this->pad($arg_int_pad_number, $arg_str_pad) . "</attr>\n"; } return $str_xml; }
$xt->assign("guestlink_block", isGuestLoginAvailable()); $_SESSION["MyURL"] = $myurl; if ($myurl && $_SESSION["MyUrlAccess"]) { $xt->assign("guestlink_attrs", "href=\"" . $myurl . "\""); } else { $xt->assign("guestlink_attrs", "href=\"" . GetTableLink("menu") . "\""); } if (postvalue("username")) { $xt->assign("username_attrs", ($is508 == true ? "id=\"username\" " : "") . "value=\"" . runner_htmlspecialchars($pUsername) . "\""); } else { $xt->assign("username_attrs", ($is508 == true ? "id=\"username\" " : "") . "value=\"" . runner_htmlspecialchars(refine(@$_COOKIE["username"])) . "\""); } if (postvalue("password")) { $xt->assign("password_attrs", ($is508 == true ? " id=\"password\"" : "") . " value=\"" . runner_htmlspecialchars($pPassword) . "\""); } else { $xt->assign("password_attrs", ($is508 == true ? " id=\"password\"" : "") . " value=\"" . runner_htmlspecialchars(refine(@$_COOKIE["password"])) . "\""); } if (@$_GET["message"] == "expired") { $message = "Your session has expired." . "Please login again."; } if (@$_GET["message"] == "invalidlogin") { $message = "Invalid Login"; } if ($message) { $xt->assign("message_block", true); $xt->assign("message", "<div class='message rnr-error'>" . $message . "</div>"); } $pageObject->body["begin"] .= GetBaseScriptsForPage(false); $pageObject->body["begin"] .= "<form method=\"post\" action='" . GetTableLink("login") . "' id=\"form1\" name=\"form1\">\n\t\t\t\t\t\t\t\t<input type=\"hidden\" name=\"btnSubmit\" value=\"Login\">"; $pageObject->body["end"] .= "</form>"; $pageObject->addCommonJs();
$strMessage = "User"." ".$strUsernameEmail." "."is not registered."; } } } $xt->assign("submit_attrs","onclick='document.forms.form1.submit();return false;'"); $xt->assign("username_email_label",true); $is508=isEnableSection508(); if($is508) { $xt->assign_section("username_email_label","<label for=\"username_email\">","</label>"); } $xt->assign("username_email_attrs",($is508==true ? "id=\"username_email\" " : "")."value=\"".runner_htmlspecialchars($strUsernameEmail)."\""); if(@$strMessage) { $xt->assign("message","<div class='message rnr-error'>".$strMessage."</div>"); $xt->assign("message_block",true); if($pageObject->isCaptchaOk==1) $_SESSION[$sessPrefix."_count_captcha"]=$_SESSION[$sessPrefix."_count_captcha"]+1; } $pageObject->body["begin"] .= GetBaseScriptsForPage(false); $pageObject->body["begin"] .="<script language = JavaScript> function OnKeyDown() { e = window.event;
function fillCheckAttr(&$record, $data, $keyblock) { $checkbox_attrs = "name=\"selection[]\" value=\"" . runner_htmlspecialchars(@$data[$this->linkField]) . "\" id=\"check" . $this->recId . "\""; $record["checkbox"] = array("begin" => "<input type='checkbox' " . $checkbox_attrs . ">", "data" => array()); }
$xt->assign("next_button", true); $nextlink .="editid1=".runner_htmlspecialchars(rawurlencode($next[1-1])); $xt->assign("nextbutton_attrs", "id=\"nextButton".$id."\""); } else if( count($prev) ) { $xt->assign("next_button", true); $xt->assign("nextbutton_class", "rnr-invisible-button"); } else $xt->assign("next_button", false); if(count($prev)) { $xt->assign("prev_button", true); $prevlink .="editid1=".runner_htmlspecialchars(rawurlencode($prev[1-1])); $xt->assign("prevbutton_attrs", "id=\"prevButton".$id."\""); } else if( count($next) ) { $xt->assign("prev_button", true); $xt->assign("prevbutton_class", "rnr-invisible-button"); } else $xt->assign("prev_button", false); //End show Next Prev button ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// if(!$inlineview) { $xt->assign("back_button",true);
} elseif (postvalue('cname')) { $contents_block["begin"].='action="'.GetTableLink("dchart").'?cname='.runner_htmlspecialchars(rawurlencode(postvalue("cname"))).'" '; } $contents_block["begin"] .= 'name="editform"><input type="hidden" id="a" name="a" value="advsearch">'; $contents_block["end"] = '</form>'; $xt->assignbyref("contents_block",$contents_block); $xt->assign("searchbutton_attrs", 'name="SearchButton" onclick="document.forms.editform.submit();"'); $xt->assign("resetbutton_attrs", 'onclick="return ResetControls();"'); $xt->assign("backbutton_attrs", "onclick=\"document.forms.editform.a.value='return'; document.forms.editform.submit();\""); $xt->assign("conditions_block",true); $xt->assign("search_button",true); $xt->assign("reset_button",true); $xt->assign("back_button",true); $xt->assign("wr_pagestylepath", $wr_pagestylepath); $xt->assign("dynamic", "true"); if (postvalue('rname')) { $xt->assign("rname", postvalue('rname')); } if (postvalue('cname')) { $xt->assign("cname", postvalue('cname')); } $templatefile = GetTemplateName("", "dsearch"); $xt->assign( "reportTitle", runner_htmlspecialchars( $xml_array['settings']['title'] ) ); $xt->display($templatefile); ?>
function DisplayMasterTableInfo_GE_ESTADO_CIVIL($params) { global $cman; $detailtable = $params["detailtable"]; $keys = $params["keys"]; $xt = new Xtempl(); $tName = "GE.ESTADO_CIVIL"; $settings = new ProjectSettings($tName, PAGE_LIST); $cipherer = new RunnerCipherer($tName); $connection = $cman->byTable($tName); $masterQuery = $settings->getSQLQuery(); $viewControls = new ViewControlsContainer($settings, PAGE_LIST); $where = ""; $keysAssoc = array(); $showKeys = ""; if ($detailtable == "GE.PERSONA_DISPONIBLE") { $keysAssoc["ESTADO_CIVIL_ID"] = $keys[1 - 1]; $where .= RunnerPage::_getFieldSQLDecrypt("ESTADO_CIVIL_ID", $connection, $settings, $cipherer) . "=" . $cipherer->MakeDBValue("ESTADO_CIVIL_ID", $keys[1 - 1], "", true); $keyValue = $viewControls->showDBValue("ESTADO_CIVIL_ID", $keysAssoc); $showKeys .= " " . GetFieldLabel("GE_ESTADO_CIVIL", "ESTADO_CIVIL_ID") . ": " . $keyValue; $xt->assign('showKeys', $showKeys); } if (!$where) { return; } $str = SecuritySQL("Search"); if (strlen($str)) { $where .= " and " . $str; } $strWhere = whereAdd($masterQuery->WhereToSql(), $where); if (strlen($strWhere)) { $strWhere = " where " . $strWhere . " "; } $strSQL = $masterQuery->HeadToSql() . ' ' . $masterQuery->FromToSql() . $strWhere . $masterQuery->TailToSql(); LogInfo($strSQL); $data = $cipherer->DecryptFetchedArray($connection->query($strSQL)->fetchAssoc()); if (!$data) { return; } // reassign pagetitlelabel function adding extra params $xt->assign_function("pagetitlelabel", "xt_pagetitlelabel", array("record" => $data, "settings" => $settings)); $keylink = ""; $keylink .= "&key1=" . runner_htmlspecialchars(rawurlencode(@$data["ESTADO_CIVIL_ID"])); $xt->assign("ESTADO_CIVIL_ID_mastervalue", $viewControls->showDBValue("ESTADO_CIVIL_ID", $data, $keylink)); $format = $settings->getViewFormat("ESTADO_CIVIL_ID"); $class = " rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("ESTADO_CIVIL_ID"))) { $class = ' rnr-field-number'; } $xt->assign("ESTADO_CIVIL_ID_class", $class); // add class for field header as field value $xt->assign("NOMBRE_mastervalue", $viewControls->showDBValue("NOMBRE", $data, $keylink)); $format = $settings->getViewFormat("NOMBRE"); $class = " rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("NOMBRE"))) { $class = ' rnr-field-number'; } $xt->assign("NOMBRE_class", $class); // add class for field header as field value $xt->assign("FEC_CREACION_mastervalue", $viewControls->showDBValue("FEC_CREACION", $data, $keylink)); $format = $settings->getViewFormat("FEC_CREACION"); $class = " rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("FEC_CREACION"))) { $class = ' rnr-field-number'; } $xt->assign("FEC_CREACION_class", $class); // add class for field header as field value $xt->assign("USUARIO_CREACION_mastervalue", $viewControls->showDBValue("USUARIO_CREACION", $data, $keylink)); $format = $settings->getViewFormat("USUARIO_CREACION"); $class = " rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("USUARIO_CREACION"))) { $class = ' rnr-field-number'; } $xt->assign("USUARIO_CREACION_class", $class); // add class for field header as field value $xt->assign("FEC_ULTIMA_MOD_mastervalue", $viewControls->showDBValue("FEC_ULTIMA_MOD", $data, $keylink)); $format = $settings->getViewFormat("FEC_ULTIMA_MOD"); $class = " rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("FEC_ULTIMA_MOD"))) { $class = ' rnr-field-number'; } $xt->assign("FEC_ULTIMA_MOD_class", $class); // add class for field header as field value $xt->assign("USUARIO_ULTIMA_MOD_mastervalue", $viewControls->showDBValue("USUARIO_ULTIMA_MOD", $data, $keylink)); $format = $settings->getViewFormat("USUARIO_ULTIMA_MOD"); $class = " rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("USUARIO_ULTIMA_MOD"))) { $class = ' rnr-field-number'; } $xt->assign("USUARIO_ULTIMA_MOD_class", $class); // add class for field header as field value $layout = GetPageLayout("GE_ESTADO_CIVIL", 'masterlist'); if ($layout) { $xt->assign("pageattrs", 'class="' . $layout->style . " page-" . $layout->name . '"'); } $xt->displayPartial(GetTemplateName("GE_ESTADO_CIVIL", "masterlist")); }
$data = $qResult->fetchNumeric(); if (!$data) { echo "Invalid validation code."; return; } $dbPassword = $regCipherer->DecryptField("password", $data[0]); $usercode = $username . md5($dbPassword); if ($code != md5($usercode)) { echo "Invalid validation code."; return; } $sql = "update " . $pageObject->connection->addTableWrappers("ConsolidatedStockEnquiry_users") . " set " . $pageObject->connection->addFieldWrappers("active1") . "=1 " . " where " . $pageObject->getFieldSQLDecrypt("username") . "=" . $strUsername; $pageObject->connection->exec($sql); $pageObject->updatePageLayoutAndCSS('', 'success'); $pageObject->body["begin"] .= "<form method=\"POST\" action=\"" . GetTableLink("login") . "\" name=\"loginform\">\n\t<input type=\"Hidden\" name=\"username\" value=\"" . runner_htmlspecialchars($username) . "\">"; $pageObject->body["begin"] .= "<input type=\"Hidden\" name=\"password\" value=\"" . runner_htmlspecialchars($data["password"]) . "\">"; $pageObject->body["begin"] .= "</form>"; $xt->assign("body", $pageObject->body); $xt->assign("registered_block", true); $xt->assign("loginlink_attrs", "onclick=\"document.forms.loginform.submit();return false;\" id=\"ProceedToLogin\""); return $pageObject->display(GetTemplateName("", "register_success")); // return $pageObject->display for .net compatibility } // proccess captcha if ($isUseCaptcha) { $pageObject->doCaptchaCode(); } if (!$pageObject->isCaptchaOk) { $allow_registration = false; } if (@$_POST["btnSubmit"] == "Register") {