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; }