Esempi in PHP per CLOUDWIND_SECURITY_SERVICE::sqlEscape

Esempio n. 1

File: platform_settingdb.class.php Progetto: sherlockhouse/aliyun

 function replace($id, $setting)
 {
     if (!$id) {
         return false;
     }
     return $this->_db->query("REPLACE INTO " . $this->_tableName . "(id,setting) VALUES (" . CLOUDWIND_SECURITY_SERVICE::sqlEscape($id) . "," . CLOUDWIND_SECURITY_SERVICE::sqlEscape($setting) . ")");
 }

Esempio n. 2

File: defend_postverifydb.class.php Progetto: sherlockhouse/aliyun

 function replace($type, $tid, $pid)
 {
     if (!$tid || !$type) {
         return false;
     }
     return $this->_db->query("REPLACE INTO " . $this->_tableName . "(id,type,tid,pid,modified_time) VALUES (null," . CLOUDWIND_SECURITY_SERVICE::sqlEscape($type) . "," . intval($tid) . "," . intval($pid) . "," . CloudWind_getConfig('g_timestamp') . ")");
 }

Esempio n. 3

File: platform_logsettingdb.class.php Progetto: jechiy/PHPWind

 function replace($id, $vector, $cipher, $hash)
 {
     if (!$id || !$vector || !$cipher || !$hash) {
         return false;
     }
     return $this->_db->query("REPLACE INTO " . $this->_tableName . "(id,vector,cipher,field1,field2,field3,field4) VALUES (" . CLOUDWIND_SECURITY_SERVICE::sqlEscape($id) . "," . CLOUDWIND_SECURITY_SERVICE::sqlEscape($vector) . "," . CLOUDWIND_SECURITY_SERVICE::sqlEscape($cipher) . "," . CLOUDWIND_SECURITY_SERVICE::sqlEscape($hash) . ",'',0,0)");
 }

Esempio n. 4

File: search_threadsdb.class.php Progetto: sherlockhouse/aliyun

 function setThreadCheckedByTid($tid)
 {
     $tid = intval($tid);
     if ($tid < 1) {
         return false;
     }
     $this->_db->update("UPDATE " . $this->_tableName . " SET ifcheck = 1 WHERE tid = " . CLOUDWIND_SECURITY_SERVICE::sqlEscape($tid));
     return $this->_db->affected_rows();
 }

Esempio n. 5

File: search_postsdb.class.php Progetto: sherlockhouse/aliyun

 function setPostCheckedByPid($pid, $table)
 {
     $pid = intval($pid);
     if (!$this->_checkTable($table) || $pid < 1) {
         return false;
     }
     $this->_db->update("UPDATE " . CLOUDWIND_SECURITY_SERVICE::sqlMetadata($table) . " SET ifshield = 0 WHERE pid = " . CLOUDWIND_SECURITY_SERVICE::sqlEscape($pid));
     return $this->_db->affected_rows();
 }

Esempio n. 6

File: core.security.class.php Progetto: sherlockhouse/aliyun

 function sqlSingle($array, $strip = true)
 {
     if (!CLOUDWIND_SECURITY_SERVICE::isArray($array)) {
         return '';
     }
     $array = CLOUDWIND_SECURITY_SERVICE::sqlEscape($array, $strip, true);
     $str = '';
     foreach ($array as $key => $val) {
         $str .= ($str ? ', ' : ' ') . CLOUDWIND_SECURITY_SERVICE::sqlMetadata($key) . '=' . $val;
     }
     return $str;
 }

Esempio n. 7

File: defend.generaloperate.class.php Progetto: sherlockhouse/aliyun

 function _postReply($id, $postAudit, $expand)
 {
     if (!isset($expand['tid']) || $expand['tid'] < 1) {
         return false;
     }
     $postVerifyService = $this->getPostVerifyService();
     $postVerifyService->insertPostVerify(2, $expand['tid'], $id);
     $postTable = GetPtable('N', $expand['tid']);
     return $GLOBALS['db']->query("UPDATE " . CLOUDWIND_SECURITY_SERVICE::sqlMetadata($postTable) . " SET ifshield=1 WHERE pid=" . CLOUDWIND_SECURITY_SERVICE::sqlEscape($id));
 }

Esempio n. 8

File: search_logsdb.class.php Progetto: jechiy/PHPWind

 function countLogsByTypeAndTime($tableName, $starttime, $endtime)
 {
     if (!in_array($tableName, $this->_logTableNames)) {
         return false;
     }
     $result = $this->_db->get_one("SELECT count(*) as count FROM " . CLOUDWIND_SECURITY_SERVICE::sqlMetadata($tableName) . " WHERE modified_time >= " . CLOUDWIND_SECURITY_SERVICE::sqlEscape($starttime) . " AND modified_time <= " . CLOUDWIND_SECURITY_SERVICE::sqlEscape($endtime));
     return $result && $result['count'] > 0 ? $result['count'] : 0;
 }

Esempio n. 9

File: dao_basedb.class.php Progetto: sherlockhouse/aliyun

 function _addSlashes($var)
 {
     return CLOUDWIND_SECURITY_SERVICE::sqlEscape($var);
 }