www.gusucode.com > 教程素材资源下载论坛网站源码程序 > 教程素材资源下载论坛/整站源码/source/class/table/table_forum_filter_post.php
<?php if(!defined('IN_DISCUZ')) { exit('Access Denied'); } class table_forum_filter_post extends discuz_table { public function __construct() { $this->_table = 'forum_filter_post'; $this->_pk = ''; parent::__construct(); } public function fetch_all_by_tid_pids($tid, $pid) { return DB::fetch_all('SELECT * FROM %t WHERE tid=%d AND pid IN(%n)', array($this->_table, $tid, $pid), 'pid'); } public function fetch_all_by_tid_postlength_limit($tid, $limit = 10) { if($limit <= 0) { return array(); } return DB::fetch_all('SELECT * FROM %t WHERE tid=%d ORDER BY postlength DESC LIMIT %d', array($this->_table, $tid, $limit), 'pid'); } public function delete_by_tid_pid($tid, $pid) { if(empty($tid) || empty($pid)) { return false; } return DB::query('DELETE FROM %t WHERE tid=%d AND pid=%d', array($this->_table, $tid, $pid)); } public function delete_by_tid($tid) { if(empty($tid)) { return false; } return DB::query('DELETE FROM %t WHERE tid IN (%n)', array($this->_table, $tid)); } public function delete_by_pid($pids) { if(empty($pids)) { return false; } return DB::query('DELETE FROM %t WHERE '.DB::field('pid', $pids), array($this->_table)); } } ?>