www.gusucode.com > 时尚简洁扁平化社区论坛网站源码程序 > 时尚简洁扁平化社区论坛/整站安装/web/source/class/table/table_home_feed_app.php
<?php /** * [Discuz!] (C)2001-2099 Comsenz Inc. * This is NOT a freeware, use is subject to license terms * * $Id: table_home_feed_app.php 27903 2012-02-16 08:06:10Z zhengqingpeng $ */ if(!defined('IN_DISCUZ')) { exit('Access Denied'); } class table_home_feed_app extends discuz_table { public function __construct() { $this->_table = 'home_feed_app'; $this->_pk = 'feedid'; parent::__construct(); } public function fetch_all_by_uid_icon($uids = null, $icon = '', $start = 0, $limit = 0) { $parameter = array($this->_table); $wherearr = array(); if($uids !== null) { $uids = dintval($uids, true); $wherearr[] = is_array($uids) ? 'uid IN(%n)' : 'uid=%d'; $parameter[] = $uids; } if(!empty($icon)) { $wherearr[] = 'icon=%s'; $parameter[] = $icon; } $wheresql = !empty($wherearr) && is_array($wherearr) ? ' WHERE '.implode(' AND ', $wherearr) : ''; return DB::fetch_all("SELECT * FROM %t $wheresql ORDER BY dateline DESC ".DB::limit($start, $limit), $parameter, $this->_pk); } public function optimize_table() { return DB::query("OPTIMIZE TABLE %t", array($this->_table), true); } public function delete_by_dateline($dateline) { $dateline = dintval($dateline); if($dateline) { return DB::delete($this->_table, DB::field('dateline', $dateline, '<')); } return 0; } } ?>