PHP RunnerCipherer::DecryptField方法代码示例

 function suggestValue($value, $searchFor, &$response, &$row)
 {
     if (!GetGlobalData("handleSearchSuggestInLookup", true)) {
         parent::suggestValue($value, $searchFor, $response, $row);
         return;
     }
     global $conn;
     $lookupSQL = buildLookupSQL($this->lookupPageType, $this->field, $this->pageObject->tName, "", $value, false, true, false, true, true, true);
     $this->fillLookupFieldsIndexes();
     $rs_lookup = db_query($lookupSQL, $conn);
     if ($data = db_fetch_numarray($rs_lookup)) {
         if ($this->isDisplayFieldEncrypted) {
             $lookup_value = $this->ciphererDisplay->DecryptField($this->lookupType == LT_QUERY ? $this->displayFieldName : $this->field, $data[$this->displayFieldIndex]);
         } else {
             $lookup_value = $data[$this->displayFieldIndex];
         }
         parent::suggestValue($lookup_value, $searchFor, $response, $row);
     }
 }

 /**
  * Fill the response array with the suggest values
  *
  * @param String value	
  *		Note: value is preceeded with "_" 
  * @param String searchFor
  * @param &Array response
  * @param &Array row
  */
 function suggestValue($value, $searchFor, &$response, &$row)
 {
     if (!GetGlobalData("handleSearchSuggestInLookup", true) || $this->lookupType == LT_LISTOFVALUES || $this->isSearchByDispalyedFieldAllowed()) {
         parent::suggestValue($value, $searchFor, $response, $row);
         return;
     }
     // "_" is added to convert number type to string in lookupsuggest.php ($value)
     $lookupSQL = $this->getLookupSQL("", substr($value, 1), false, true, false, true, true);
     $this->fillLookupFieldsIndexes();
     $qResult = $this->lookupConnection->query($lookupSQL);
     if ($data = $qResult->fetchNumeric()) {
         // "_" is added to convert number type to string
         if ($this->isDisplayFieldEncrypted) {
             $displayFieldName = $this->lookupType == LT_QUERY ? $this->displayFieldName : $this->field;
             $lookup_value = $this->ciphererDisplay->DecryptField($displayFieldName, "_" . $data[$this->displayFieldIndex]);
         } else {
             $lookup_value = "_" . $data[$this->displayFieldIndex];
         }
         parent::suggestValue($lookup_value, $searchFor, $response, $row);
     }
 }

        $strSQL = $gQuery->gSQLWhere_having_fromQuery("", $where, $having);
        $strSQL = "SELECT DISTINCT st." . $_connection->addFieldWrappers($f) . " from (" . $strSQL . ") st";
    } else {
        $strSQL = SQLQuery::gSQLWhere_having($sqlHead, $fromClause, $gQuery->WhereToSql(), $gQuery->GroupByToSql(), $gQuery->Having()->toSql($gQuery), $where, $having);
    }
    if ($_connection->dbType == nDATABASE_MySQL || $_connection->dbType == nDATABASE_PostgreSQL) {
        $strSQL .= " LIMIT " . $numberOfSuggests;
    } elseif ($_connection->dbType == nDATABASE_MSSQLServer || $_connection->dbType == nDATABASE_Access) {
        $strSQL = "select top " . $numberOfSuggests . " * from (" . $strSQL . ") st";
    } elseif ($_connection->dbType == nDATABASE_Oracle) {
        $strSQL = AddRowNumber($strSQL, $numberOfSuggests);
    }
    $qResult = $_connection->query($strSQL);
    // fill $response array with the field's suggest value
    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

 } else {
     $strUsername = make_db_value("username", $username);
 }
 $sql = "select " . $pageObject->getFieldSQLDecrypt("password") . " from " . $pageObject->connection->addTableWrappers("ConsolidatedStockEnquiry_users") . " where " . $pageObject->getFieldSQLDecrypt("username") . "=" . $strUsername;
 $qResult = $pageObject->connection->query($sql);
 $verified = false;
 if (!$qResult) {
     echo "Invalid validation code.";
     return;
 }
 $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"));

            }
        }
    }
    if (strlen(GetLWWhere($f, $pageType, $strTableName))) {
        $hasWhere = true;
    }
    break;
}
$lookupIndexes = GetLookupFieldsIndexes($gSettings, $lookupField);
$linkFieldIndex = $lookupIndexes["linkFieldIndex"];
$displayFieldIndex = $lookupIndexes["displayFieldIndex"];
$rs = db_query($LookupSQL, $conn);
while ($data = db_fetch_numarray($rs)) {
    if ($LookupType == LT_QUERY && $gSettings->isLookupUnique($f)) {
        if (!isset($uniqueArray)) {
            $uniqueArray = array();
        }
        if (in_array($data[$displayFieldIndex], $uniqueArray)) {
            continue;
        }
        $uniqueArray[] = $data[$displayFieldIndex];
    }
    $data[$linkFieldIndex] = $cipherer->DecryptField($f, $data[$linkFieldIndex]);
    if ($LookupType == LT_QUERY) {
        $data[$displayFieldIndex] = $cipherer->DecryptField($displayFieldName, $data[$displayFieldIndex]);
    }
    $response[] = $data[$linkFieldIndex];
    $response[] = $data[$displayFieldIndex];
}
$respObj = array('success' => true, 'data' => array_slice($response, 0, 40));
echo "<textarea>" . htmlspecialchars(my_json_encode($respObj)) . "</textarea>";