echo $tbl_lesson_doc->doc_id->CurrentValue; ?> "<?php echo $wrkonchange; ?> > <?php $sSqlWrk = "SELECT `doc_id`, `doc_name` FROM `tbl_doc`"; $sWhereWrk = "`doc_name` LIKE '{query_value}%'"; if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $sSqlWrk .= " LIMIT " . EW_AUTO_SUGGEST_MAX_ENTRIES; ?> <input type="hidden" name="q_x_doc_id" id="q_x_doc_id" value="s=<?php echo TEAencrypt($sSqlWrk); ?> &fn=<?php echo urlencode($tbl_lesson_doc->doc_id->LookupFn); ?> "> <script type="text/javascript"> var oas = new ew_AutoSuggest("x_doc_id", ftbl_lesson_docadd, false, EW_AUTO_SUGGEST_MAX_ENTRIES); oas.formatResult = function(ar) { var dv = ar[1]; for (var i = 2; i <= 4; i++) dv += (ar[i]) ? ew_ValueSeparator(i - 1, "x_doc_id") + ar[i] : ""; return dv; } oas.ac.typeAhead = false; ftbl_lesson_docadd.AutoSuggests["x_doc_id"] = oas;
<input type="text" name="sv_x_PromoCodeID" id="sv_x_PromoCodeID" value="<?php echo $GiftCertificates->PromoCodeID->EditValue; ?> " size="30"<?php echo $GiftCertificates->PromoCodeID->EditAttributes(); ?> > <span id="em_x_PromoCodeID" class="ewMessage" style="display: none"><img src="images/alert-small.gif" alt="Value does not exist" width="16" height="16" border="0"></span> <div id="sc_x_PromoCodeID"></div> </div> <input type="hidden" name="x_PromoCodeID" id="x_PromoCodeID" value="<?php echo $GiftCertificates->PromoCodeID->CurrentValue; ?> "> <?php $sSqlWrk = "SELECT `PromoCodeID`, `PromoCodeName` FROM `PromoCodes` WHERE (`PromoCodeName` LIKE '{query_value}%')"; $sSqlWrk = TEAencrypt($sSqlWrk, EW_RANDOM_KEY); ?> <input type="hidden" name="s_x_PromoCodeID" id="s_x_PromoCodeID" value="<?php echo $sSqlWrk; ?> "> <script type="text/javascript"> <!-- var oas_x_PromoCodeID = new ew_AutoSuggest("sv_x_PromoCodeID", "sc_x_PromoCodeID", "s_x_PromoCodeID", "em_x_PromoCodeID", "x_PromoCodeID", "", false); oas_x_PromoCodeID.formatResult = function(ar) { var df1 = ar[1]; return df1; }; oas_x_PromoCodeID.ac.typeAhead = false; //-->
function Page_Main() { global $Security, $Language, $UserProfile, $gsFormError; $sPassword = ""; $sLastUrl = $Security->LastUrl(); // Get last URL if ($sLastUrl == "") { $sLastUrl = "index.php"; } if (IsLoggingIn()) { $this->Username = @$_SESSION[EW_SESSION_USER_PROFILE_USER_NAME]; $sPassword = @$_SESSION[EW_SESSION_USER_PROFILE_PASSWORD]; $this->LoginType = @$_SESSION[EW_SESSION_USER_PROFILE_LOGIN_TYPE]; $bValidPwd = $Security->ValidateUser($this->Username, $sPassword, FALSE); if ($bValidPwd) { $_SESSION[EW_SESSION_USER_PROFILE_USER_NAME] = ""; $_SESSION[EW_SESSION_USER_PROFILE_PASSWORD] = ""; $_SESSION[EW_SESSION_USER_PROFILE_LOGIN_TYPE] = ""; } } else { if (!$Security->IsLoggedIn()) { $Security->AutoLogin(); } $this->Username = ""; // Initialize if (@$_POST["username"] != "") { // Setup variables $this->Username = ew_RemoveXSS(ew_StripSlashes(@$_POST["username"])); $sPassword = ew_RemoveXSS(ew_StripSlashes(@$_POST["password"])); $this->LoginType = strtolower(ew_RemoveXSS(@$_POST["type"])); } if ($this->Username != "") { $bValidate = $this->ValidateForm($this->Username, $sPassword); if (!$bValidate) { $this->setFailureMessage($gsFormError); } $_SESSION[EW_SESSION_USER_PROFILE_USER_NAME] = $this->Username; // Save login user name $_SESSION[EW_SESSION_USER_PROFILE_LOGIN_TYPE] = $this->LoginType; // Save login type } else { if ($Security->IsLoggedIn()) { if ($this->getFailureMessage() == "") { $this->Page_Terminate($sLastUrl); } // Return to last accessed page } $bValidate = FALSE; // Restore settings if (@$_COOKIE[EW_PROJECT_NAME]['Checksum'] == strval(crc32(md5(EW_RANDOM_KEY)))) { $this->Username = TEAdecrypt(@$_COOKIE[EW_PROJECT_NAME]['Username'], EW_RANDOM_KEY); } if (@$_COOKIE[EW_PROJECT_NAME]['AutoLogin'] == "autologin") { $this->LoginType = "a"; } elseif (@$_COOKIE[EW_PROJECT_NAME]['AutoLogin'] == "rememberusername") { $this->LoginType = "u"; } else { $this->LoginType = ""; } } $bValidPwd = FALSE; if ($bValidate) { // Call Logging In event $bValidate = $this->User_LoggingIn($this->Username, $sPassword); if ($bValidate) { $bValidPwd = $Security->ValidateUser($this->Username, $sPassword, FALSE); // Manual login if (!$bValidPwd) { if ($this->getFailureMessage() == "") { $this->setFailureMessage($Language->Phrase("InvalidUidPwd")); } // Invalid user id/password } } else { if ($this->getFailureMessage() == "") { $this->setFailureMessage($Language->Phrase("LoginCancelled")); } // Login cancelled } } } if ($bValidPwd) { // Write cookies if ($this->LoginType == "a") { // Auto login setcookie(EW_PROJECT_NAME . '[AutoLogin]', "autologin", EW_COOKIE_EXPIRY_TIME); // Set autologin cookie setcookie(EW_PROJECT_NAME . '[Username]', TEAencrypt($this->Username, EW_RANDOM_KEY), EW_COOKIE_EXPIRY_TIME); // Set user name cookie setcookie(EW_PROJECT_NAME . '[Password]', TEAencrypt($sPassword, EW_RANDOM_KEY), EW_COOKIE_EXPIRY_TIME); // Set password cookie setcookie(EW_PROJECT_NAME . '[Checksum]', crc32(md5(EW_RANDOM_KEY)), EW_COOKIE_EXPIRY_TIME); } elseif ($this->LoginType == "u") { // Remember user name setcookie(EW_PROJECT_NAME . '[AutoLogin]', "rememberusername", EW_COOKIE_EXPIRY_TIME); // Set remember user name cookie setcookie(EW_PROJECT_NAME . '[Username]', TEAencrypt($this->Username, EW_RANDOM_KEY), EW_COOKIE_EXPIRY_TIME); // Set user name cookie setcookie(EW_PROJECT_NAME . '[Checksum]', crc32(md5(EW_RANDOM_KEY)), EW_COOKIE_EXPIRY_TIME); } else { setcookie(EW_PROJECT_NAME . '[AutoLogin]', "", EW_COOKIE_EXPIRY_TIME); // Clear auto login cookie } // Call loggedin event $this->User_LoggedIn($this->Username); $this->Page_Terminate($sLastUrl); // Return to last accessed URL } elseif ($this->Username != "" && $sPassword != "") { // Call user login error event $this->User_LoginError($this->Username, $sPassword); } }
function ewrpt_AddEmailLog($sender, $recipient, $subject, $message) { $_SESSION[EWRPT_EXPORT_EMAIL_COUNTER]++; // Save to email log if (EWRPT_EMAIL_WRITE_LOG) { $dt = date("Y-m-d H:i:s"); $ip = ewrpt_ServerVar("REMOTE_ADDR"); $senderwrk = ewrpt_TruncateText($sender); $recipientwrk = ewrpt_TruncateText($recipient); $subjectwrk = ewrpt_TruncateText($subject); $messagewrk = ewrpt_TruncateText($message); // Save to database if (EWRPT_EMAIL_WRITE_LOG_TO_DATABASE) { global $conn; $sEmailSql = "INSERT INTO " . ewrpt_QuotedName(EWRPT_EMAIL_LOG_TABLE_NAME) . " (" . ewrpt_QuotedName(EWRPT_EMAIL_LOG_FIELD_NAME_DATETIME) . ", " . ewrpt_QuotedName(EWRPT_EMAIL_LOG_FIELD_NAME_IP) . ", " . ewrpt_QuotedName(EWRPT_EMAIL_LOG_FIELD_NAME_SENDER) . ", " . ewrpt_QuotedName(EWRPT_EMAIL_LOG_FIELD_NAME_RECIPIENT) . ", " . ewrpt_QuotedName(EWRPT_EMAIL_LOG_FIELD_NAME_SUBJECT) . ", " . ewrpt_QuotedName(EWRPT_EMAIL_LOG_FIELD_NAME_MESSAGE) . ") VALUES (" . ewrpt_QuotedValue($dt, EWRPT_DATATYPE_DATE) . ", " . ewrpt_QuotedValue($ip, EWRPT_DATATYPE_STRING) . ", " . ewrpt_QuotedValue($senderwrk, EWRPT_DATATYPE_STRING) . ", " . ewrpt_QuotedValue($recipientwrk, EWRPT_DATATYPE_STRING) . ", " . ewrpt_QuotedValue($subjectwrk, EWRPT_DATATYPE_STRING) . ", " . ewrpt_QuotedValue($messagewrk, EWRPT_DATATYPE_STRING) . ")"; $conn->Execute($sEmailSql); // Save to log file } else { $pfx = "email"; $sTab = "\t"; $sHeader = "date/time" . $sTab . "ip" . $sTab . "sender" . $sTab . "recipient" . $sTab . "subject" . $sTab . "message"; $sMsg = $dt . $sTab . $ip . $sTab . $senderwrk . $sTab . $recipientwrk . $sTab . $subjectwrk . $sTab . $messagewrk; $sFolder = EWRPT_UPLOAD_DEST_PATH; $randomkey = TEAencrypt(date("Ymd"), EWRPT_RANDOM_KEY); $sFn = $pfx . "_" . date("Ymd") . "_" . $randomkey . ".txt"; $filename = ewrpt_UploadPathEx(TRUE, $sFolder) . $sFn; if (file_exists($filename)) { $fileHandler = fopen($filename, "a+b"); } else { $fileHandler = fopen($filename, "a+b"); fwrite($fileHandler, $sHeader . "\r\n"); } fwrite($fileHandler, $sMsg . "\r\n"); fclose($fileHandler); } } }
function ew_CreateQuery($id, $sql) { echo ew_HtmlElement("div", array("id" => $id, "class" => "ewDisplayNone"), TEAencrypt($sql)); }
function Page_Main() { global $Security, $gsFormError; $sLastUrl = $Security->LastUrl(); // Get Last Url if ($sLastUrl == "") { $sLastUrl = "index.php"; } if (!$Security->IsLoggedIn()) { $Security->AutoLogin(); } if (@$_POST["username"] != "") { // Setup variables $this->sUsername = ew_StripSlashes(@$_POST["username"]); $sPassword = ew_StripSlashes(@$_POST["password"]); $this->sLoginType = strtolower(@$_POST["rememberme"]); $bValidate = $this->ValidateForm($this->sUsername, $sPassword); if (!$bValidate) { $this->setMessage($gsFormError); } } else { if ($Security->IsLoggedIn()) { if ($this->getMessage() == "") { $this->Page_Terminate($sLastUrl); } // Return to last accessed page } $bValidate = FALSE; // Restore settings $this->sUsername = @$_COOKIE[EW_PROJECT_NAME]['UserName']; if (@$_COOKIE[EW_PROJECT_NAME]['AutoLogin'] == "autologin") { $this->sLoginType = "a"; } elseif (@$_COOKIE[EW_PROJECT_NAME]['AutoLogin'] == "rememberusername") { $this->sLoginType = "u"; } else { $this->sLoginType = ""; } } if ($bValidate) { $bValidPwd = FALSE; // Call loggin in event $bValidate = $this->User_LoggingIn($this->sUsername, $sPassword); if ($bValidate) { $bValidPwd = $Security->ValidateUser($this->sUsername, $sPassword); if (!$bValidPwd) { $this->setMessage("Incorrect user ID or password"); } // Invalid User ID/password } else { if ($this->getMessage() == "") { $this->setMessage("Login cancelled"); } // Login cancelled } if ($bValidPwd) { // Write cookies $expirytime = time() + 365 * 24 * 60 * 60; // Change cookie expiry time here if ($this->sLoginType == "a") { // Auto login setcookie(EW_PROJECT_NAME . '[AutoLogin]', "autologin", $expirytime); // Set up autologin cookies setcookie(EW_PROJECT_NAME . '[UserName]', $this->sUsername, $expirytime); // Set up user name cookies setcookie(EW_PROJECT_NAME . '[Password]', TEAencrypt($sPassword, EW_RANDOM_KEY), $expirytime); // Set up password cookies } elseif ($this->sLoginType == "u") { // Remember user name setcookie(EW_PROJECT_NAME . '[AutoLogin]', "rememberusername", $expirytime); // Set up remember user name cookies setcookie(EW_PROJECT_NAME . '[UserName]', $this->sUsername, $expirytime); // Set up user name cookies } else { setcookie(EW_PROJECT_NAME . '[AutoLogin]', "", $expirytime); // Clear autologin cookies } // Call loggedin event $this->User_LoggedIn($this->sUsername); $this->Page_Terminate($sLastUrl); // Return to last accessed URL } else { // Call user login error event $this->User_LoginError($this->sUsername, $sPassword); } } }
$_SESSION[EW_SESSION_MESSAGE] = "Login cancelled"; } // Login cancelled } //$_SESSION[EW_SESSION_SYS_ADMIN] = '5'; if ($bValidPwd) { // Write cookies $expirytime = time() + 24 * 60 * 60; // Change cookie expiry time here if ($sLoginType == "a") { // Auto login setcookie(EW_PROJECT_NAME . '[AutoLogin]', "autologin", $expirytime); // Set up autologin cookies setcookie(EW_PROJECT_NAME . '[UserName]', $sUsername, $expirytime); // Set up user name cookies setcookie(EW_PROJECT_NAME . '[Password]', TEAencrypt($sPassword, EW_RANDOM_KEY), $expirytime); // Set up password cookies } elseif ($sLoginType == "u") { // Remember user name setcookie(EW_PROJECT_NAME . '[AutoLogin]', "rememberusername", $expirytime); // Set up remember user name cookies setcookie(EW_PROJECT_NAME . '[UserName]', $sUsername, $expirytime); // Set up user name cookies } else { setcookie(EW_PROJECT_NAME . '[AutoLogin]', "", $expirytime); // Clear autologin cookies } // Call loggedin event User_LoggedIn($sUsername); Page_Terminate('index.php'); // Return to last accessed url