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) . ")"); }
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') . ")"); }
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)"); }
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(); }
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(); }
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; }
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)); }
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; }
function _addSlashes($var) { return CLOUDWIND_SECURITY_SERVICE::sqlEscape($var); }