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));
 }
Esempio n. 4
0
 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;
 }