www.gusucode.com > 时尚简洁扁平化社区论坛网站源码程序 > 时尚简洁扁平化社区论坛/整站安装/web/source/plugin/k_misign/table/table_plugin_k_misign_lastrule.php

    <?php

if(!defined('IN_DISCUZ')) {
	exit('Access Denied');
}

class table_plugin_k_misign_lastrule extends discuz_table{
	public function __construct() {

		$this->_table = 'plugin_k_misign_lastrule';
		$this->_pk    = 'ruleid';

		parent::__construct();
	}
	
	public function fetch_all_cp($start, $limit) {
		return DB::fetch_all('SELECT * FROM %t ORDER BY lastday ASC LIMIT %d, %d', array($this->table, $start, $limit), $this->_pk);
	}
	
	public function fetch_all($start, $limit) {
		return DB::fetch_all('SELECT * FROM %t WHERE status=1 ORDER BY lastday ASC LIMIT %d, %d', array($this->table, $start, $limit), 'lastday');
	}
	
	public function fetch_by_ruleid($ruleid) {
		return DB::fetch_first('SELECT * FROM %t WHERE ruleid=%d', array($this->table, $ruleid));
	}

	public function fetch_by_lastday($lastday) {
		return DB::fetch_first('SELECT * FROM %t WHERE lastday=%d', array($this->table, $lastday));
	}
}

//WWW.lbw3.com
?>