123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250 |
- <?php
- /**
- * [Discuz!] (C)2001-2099 Comsenz Inc.
- * This is NOT a freeware, use is subject to license terms
- *
- * $Id: table_home_feed.php 28335 2012-02-28 04:37:47Z zhangguosheng $
- */
- if(!defined('IN_DISCUZ')) {
- exit('Access Denied');
- }
- class table_home_feed extends discuz_table
- {
- public function __construct() {
- $this->_table = 'home_feed';
- $this->_pk = 'feedid';
- parent::__construct();
- }
- public function optimize_table() {
- return DB::query("OPTIMIZE TABLE %t", array($this->_table), true);
- }
- public function fetch($id, $idtype = '', $uid = '', $feedid = '') {
- $wherearr = array();
- if($feedid) {
- $wherearr[] = DB::field('feedid', $feedid);
- }
- if($id) {
- $wherearr[] = DB::field('id', $id);
- $wherearr[] = DB::field('idtype', $idtype);
- }
- if($uid) {
- $wherearr[] = DB::field('uid', $uid);
- }
- $wheresql = !empty($wherearr) && is_array($wherearr) ? ' WHERE '.implode(' AND ', $wherearr) : '';
- if(empty($wheresql)) {
- return null;
- }
- return DB::fetch_first('SELECT * FROM '.DB::table($this->_table).' '.$wheresql);
- }
- public function fetch_all_by_uid_dateline($uids, $findex = true, $start = 0, $limit = 5) {
- if(!($uids = dintval($uids, true))) {
- return null;
- }
- return DB::fetch_all('SELECT * FROM %t '.(($findex) ? 'USE INDEX(dateline)' : '').' WHERE uid IN (%n) ORDER BY dateline desc %i', array($this->_table, $uids, DB::limit($start, $limit)));
- }
- public function fetch_all_by_hot($hotstarttime) {
- return DB::fetch_all('SELECT * FROM %t USE INDEX(hot) WHERE dateline>=%d ORDER BY hot DESC LIMIT 0,10', array($this->_table, $hotstarttime));
- }
- public function update($id, $data, $idtype = '', $uid = '', $feedid = '') {
- $condition = array();
- if($feedid) {
- $condition[] = DB::field('feedid', $feedid);
- }
- if($id) {
- $condition[] = DB::field('id', $id);
- $condition[] = DB::field('idtype', $idtype);
- }
- if($uid) {
- $condition[] = DB::field('uid', $uid);
- }
- if(empty($data) || !is_array($data) || !count($condition)) {
- return null;
- }
- DB::update($this->_table, $data, implode(' AND ', $condition));
- }
- public function update_hot_by_id($id, $idtype, $uid, $inchot) {
- DB::query('UPDATE %t SET hot = hot+\'%d\' WHERE id = %d AND idtype = %s AND uid = %d', array($this->_table, $inchot, $id, $idtype, $uid));
- }
- public function update_hot_by_feedid($feedid, $inchot) {
- DB::query('UPDATE %t SET hot = hot+\'%d\' WHERE feedid = %d', array($this->_table, $inchot, $feedid));
- }
- public function delete_by_dateline($dateline, $hot = 0) {
- if(!is_numeric($dateline) || !is_numeric($hot)) {
- return false;
- }
- $condition = array();
- $condition[] = DB::field('dateline', $dateline, '<');
- $condition[] = DB::field('hot', $hot);
- DB::delete($this->_table, implode(' AND ', $condition));
- }
- public function delete_by_id_idtype($ids, $idtype) {
- if(!$ids || !$idtype) {
- return null;
- }
- $condition = array();
- $condition[] = DB::field('id', $ids);
- $condition[] = DB::field('idtype', $idtype);
- DB::delete($this->_table, implode(' AND ', $condition));
- }
- public function delete_by_uid_idtype($uid, $idtype) {
- if(!$uid || !$idtype) {
- return null;
- }
- $condition = array();
- $condition[] = DB::field('uid', $uid);
- $condition[] = DB::field('idtype', $idtype);
- DB::delete($this->_table, implode(' AND ', $condition));
- }
- public function delete_by_icon($icon) {
- if(!$icon) {
- return null;
- }
- DB::delete($this->_table, DB::field('icon', $icon));
- }
- public function delete($feedid, $uid = '') {
- $condition = array();
- if($feedid) {
- $condition[] = DB::field('feedid', $feedid);
- }
- if($uid) {
- $condition[] = DB::field('uid', $uid);
- }
- if(!count($condition)) {
- return null;
- }
- DB::delete($this->_table, implode(' AND ', $condition));
- }
- public function delete_by_uid($uids) {
- if(!$uids) {
- return null;
- }
- DB::delete($this->_table, DB::field('uid', $uids).' OR ('.DB::field('id', $uids).' AND idtype=\'uid\')');
- }
- public function fetch_uid_by_username($users) {
- if(!$users) {
- return null;
- }
- return DB::fetch_all('SELECT uid FROM %t WHERE username IN (%n)', array($this->_table, $users), 'uid');
- }
- public function fetch_icon_by_icon($icon) {
- return DB::fetch_first('SELECT icon FROM %t WHERE icon=%s', array($this->_table, $icon));
- }
- public function fetch_feedid_by_hashdata($uid, $hash_data) {
- return DB::fetch_first('SELECT feedid FROM %t WHERE uid=%d AND hash_data=%s LIMIT 0,1', array($this->_table, $uid, $hash_data));
- }
- public function fetch_feedid_by_feedid($feedid) {
- if(!$feedid) {
- return null;
- }
- return DB::fetch_all('SELECT feedid FROM %t WHERE feedid IN (%n)', array($this->_table, $feedid), 'feedid');
- }
- public function fetch_uid_by_uid($uid) {
- if(!$uid) {
- return null;
- }
- return DB::fetch_all('SELECT uid FROM %t WHERE uid IN (%n)', array($this->_table, $uid), 'uid');
- }
- public function fetch_all_by_search($fetchtype, $uids, $icon, $starttime, $endtime, $feedids, $hot1, $hot2, $start = 0, $limit = 0, $findex = '', $appid = '') {
- $parameter = array($this->_table);
- $wherearr = array();
- if(is_array($uids) && count($uids)) {
- $parameter[] = $uids;
- $wherearr[] = 'uid IN(%n)';
- }
- if($appid) {
- $parameter[] = $appid;
- $wherearr[] = 'appid=%d';
- }
- if($icon) {
- $parameter[] = $icon;
- $wherearr[] = 'icon=%s';
- }
- if($starttime) {
- $parameter[] = is_numeric($starttime) ? $starttime : strtotime($starttime);
- $wherearr[] = 'dateline>%d';
- }
- if($endtime) {
- $parameter[] = is_numeric($endtime) ? $endtime : strtotime($endtime);
- $wherearr[] = 'dateline<%d';
- }
- if(is_array($feedids) && count($feedids)) {
- $parameter[] = $feedids;
- $wherearr[] = 'feedid IN(%n)';
- }
- if($hot1) {
- $parameter[] = $hot1;
- $wherearr[] = 'hot>=%d';
- }
- if($hot2) {
- $parameter[] = $hot2;
- $wherearr[] = 'hot<=%d';
- }
- if($fetchtype == 3) {
- $selectfield = "count(*)";
- } elseif ($fetchtype == 2) {
- $selectfield = "feedid";
- } else {
- $selectfield = "*";
- $parameter[] = DB::limit($start, $limit);
- $ordersql = ' ORDER BY dateline DESC %i';
- }
- if($findex) {
- $findex = 'USE INDEX(dateline)';
- }
- $wheresql = !empty($wherearr) && is_array($wherearr) ? ' WHERE '.implode(' AND ', $wherearr) : '';
- if($fetchtype == 3) {
- return DB::result_first("SELECT $selectfield FROM %t $wheresql", $parameter);
- } else {
- return DB::fetch_all("SELECT $selectfield FROM %t {$findex} $wheresql $ordersql", $parameter);
- }
- }
- }
- ?>
|