/** * 更新注册控制统计记录 * @param array $data * @return boolean */ public function update_regctrl($data) { if (empty($data)) { return false; } else { $this->db = K_Model::getInstanceDb(true); $log = $this->getRow(array('ip' => $data['ip']), array('count', 'lastregdate'), $this->member_control); if (empty($log)) { $id = $this->add($data, 'id', $this->member_control); return $id ? true : false; } else { $cur_time = time(); $regctrl = read_static_cache('website_config'); if ($cur_time - $data['lastregdate'] > $regctrl['regist_t'] * 3600) { //超过时间限制,更新时间、次数归1 $result = $this->update(array('ip' => $data['ip']), array('lastregdate' => $cur_time, 'count' => 1), $this->member_control); return $result ? true : false; } else { //没有超过次数限制 $result = $this->update(array('ip' => $data['ip']), array('lastregdate' => $cur_time, 'count' => $log['count'] + 1), $this->member_control); return $result ? true : false; } } } }
/** *获取一个公告 */ public function get_item($article_id) { $this->db = K_Model::getInstanceDb(false); $article_id = intval($article_id); if (!$article_id) { return false; } $where = array('id' => $article_id); return $this->getRow($where, array('*'), $this->model_name); }
/** * 获取订阅 * * @access public * @paras int $rid 节目ID * * @return array */ public function my($uid, $state = 0, $page = 1, $size = 6) { $this->db = K_Model::getInstanceDb(false); $where['uid'] = $uid; if ($state >= 0) { $where['state'] = $state; } if ($page <= 0) { $page = 1; } $offset = ($page - 1) * $size; $sql = "select p.rid, p.name, p.desc, p.pic_name, p.is_live, p.videos, m.uid, m.username, p.record_time from sk_programs as p" . " inner join sk_member as m on m.uid=p.uid" . " where p.visible=0 and p.status = 1 order by p.is_live desc, p.videos desc" . " limit {$offset}, {$size}"; $query = $this->db->query($sql); return $query->result_array(); }
public function get_html($fid) { $html = read_fragment_cache($fid); if (empty($html)) { $this->db = K_Model::getInstanceDb(false); $row = $this->getRow(array('fid' => $fid, 'status' => 1), array('data, temp')); if (!empty($row)) { $row['data'] = unserialize($row['data']); $row['data'] = json_decode($row['data'], true); $html = parse_frag_template($row['temp'], $row['data'], $this->img_path); write_fragment_cache($fid, $html); } } return $html; }
function __construct() { parent::__construct(); $this->db = K_Model::getInstanceDb(true); }
/** * 根据评论ID获取用户ID * * @access public * @param int $cid 评论ID * * @return int/bool 用户ID */ public function get_uid_by_cid($cid) { if ($cid > 0) { $this->db = K_Model::getInstanceDb(false); $where = array('c_id' => $cid); $row = $this->getRow($where); if ($row) { return $row['uid']; } else { return false; } } else { return false; } }
public function callback_update_videos($where, $set) { $this->db = K_Model::getInstanceDb(true); if (!empty($where) && !empty($set)) { $r = $this->getRow($where, array(), $this->model_video_name); if ($r) { return $this->update($where, $set, $this->model_video_name); } else { return false; } } else { return false; } }
/** * 更新关系表 * @param array $where * @param array $field * @return boolean */ public function update_relation($where, $field) { $this->db = K_Model::getInstanceDb(true); return $this->update($where, $field, $this->member_follow); }
/** * 获取金币列表 * * @access public * @param int $uid * 用户ID * @param int $method * 1:获取金币 2:使用金币 0:所以的 * @param int $page * 动作等级 * @param int $size * 页面大小 * @param int $is_count * 是否返回总数 * * @return array 返回金币记录 */ public function get_list_by_uid($uid, $method = 0, $page = 1, $size = 10, $is_count = FALSE) { $this->db = K_Model::getInstanceDb(true); $offset = ($page - 1) * $size; $limit = $size; $where = 'where cl.uid =' . $uid; if (in_array($method, array(0, 1, 2))) { if ($method > 0) { $where .= ' and cl.method = ' . $method; } } $sql = 'select cl.*, cc.name as act_name, cc.level as cat_level, cc.desc from ' . $this->model_name_log . ' as cl left join ' . $this->model_name_config . ' as cc on cl.act=cc.act ' . $where . ' order by cl.record_time desc limit ' . $offset . ', ' . $limit; $query = $this->db->query($sql); $result['list'] = $query->result_array(); if ($is_count) { $sql = 'select count(*) as c from ' . $this->model_name_log . ' as cl ' . $where; $query = $this->db->query($sql); $rec = $query->result_array(); if (isset($rec[0])) { $result['count'] = $rec[0]['c']; } else { $result['count'] = 0; } } return $result; }
/** * 获取关注某个人的记录 * @param array $where * @param array $field * @return array */ public function get_follow_by_uid($where, $field = array()) { $this->db = K_Model::getInstanceDb(false); $data = $this->slave->select($field)->get_where($this->member_follow, $where); return !empty($data) ? $data : array(); }
public function update_pushsatus_by_uid($uid) { $this->db = K_Model::getInstanceDb(true); $row = $this->getRow(array('uid' => $uid), '', $this->model_name_record); if (!empty($row)) { $last_mi_id = intval($row['last_mi_id']); $sql = 'update ' . $this->model_name_publish . ' set status = 0 where ex_id = ' . $uid . ' and type = 0 and mi_id < ' . $last_mi_id; return $this->db->query($sql); } }
/** * 更新订单记录 * @param string 订单号 * @param array 更新字段 * @return boolean */ public function update_order($order_id, $set) { $this->db = K_Model::getInstanceDb(true); $where = array('oid' => $order_id); return $this->update($where, $set, $this->model_name_log); }
/** * 获取社团参加的所有比赛的开始时间 * @param int $tid 社团tid * @return array */ public function get_game_starttime($tid) { $this->db = K_Model::getInstanceDb(true); $sql = "select b.starttime,b.endtime from {$this->sign} a left join {$this->game} b on a.gid=b.id where a.tid={$tid}"; $data = $this->db->query($sql)->result_array(); $this->db->query($sql)->free_result(); return $data; }
public function recommended($keys = "", $cate = "", $size = 10) { if (!empty($keys)) { } elseif (!empty($cate)) { } else { $this->db = K_Model::getInstanceDb(false); $sql = "select pv.rid, v.title as name, p.duration, v.pic_name, pv.views, m.uid, m.username, pv.record_time from sk_program_videos as pv" . " inner join sk_programs as p on p.rid=pv.rid" . " inner join sk_video as v on v.id=pv.vid" . " inner join sk_member as m on m.uid=v.uid" . " where v.status=3 order by rand()" . " limit 0, {$size}"; $query = $this->db->query($sql); return $query->result_array(); } }
/** * 获取充值记录 * * @access public * @param int $uid * 用户ID * @param int $page * 当前页 * @param int $size * 页面大小 * @param int $is_count * 是否返回总数 * * @return array 返回充值记录 */ public function get_inpour($uid, $page = 1, $size = 10, $is_count = FALSE) { $this->db = K_Model::getInstanceDb(true); $offset = ($page - 1) * $size; $limit = $size; $where = 'where r.uid =' . $uid; $sql = 'select r.* from ' . $this->model_recharge . ' as r ' . $where . ' order by r.dateline desc limit ' . $offset . ', ' . $limit; $query = $this->db->query($sql); $result['list'] = $query->result_array(); if ($is_count) { $sql = 'select count(*) as c from ' . $this->model_recharge . ' as r ' . $where; $query = $this->db->query($sql); $rec = $query->result_array(); if (isset($rec[0])) { $result['count'] = $rec[0]['c']; } else { $result['count'] = 0; } } return $result; }
/** * 获取推荐数量 * * @access public * @param string $position 推荐频道ID * * * @return boolean */ public function get_count($position) { if ($position > 0) { $this->db = K_Model::getInstanceDb(false); $where = array('position' => $position); return $this->getCount($where); } else { return 0; } }
/** * 获取道具明细列表 * * @access public * @param int $uid * 用户ID * @param string $mg_cate * 道具类型 * @param int $page * 分页 * @param int $size * 页面大小 * @param int $is_count * 是否返回总数 * * @return array 返回积分记录 */ public function get_list_by_uid($uid, $mg_cate, $page = 1, $size = 10, $is_count = FALSE) { $this->db = K_Model::getInstanceDb(false); $offset = ($page - 1) * $size; $limit = $size; $where = 'where ml.uid =' . $uid; if (!empty($mg_cate)) { $where = ' and m.mg_cate = \'' . $mg_cate . '\''; } $sql = 'select ml.*, m.name as ide_name, m.description from ' . $this->model_name_log . ' as ml left join ' . $this->model_name . ' as m on ml.identifier=m.identifier ' . $where . ' order by ml.dateline desc limit ' . $offset . ', ' . $limit; $query = $this->db->query($sql); $result['list'] = $query->result_array(); if ($is_count) { $sql = 'select count(*) as c from ' . $this->model_name_log . ' as ml left join ' . $this->model_name . ' as m on ml.identifier=m.identifier ' . $where; $query = $this->db->query($sql); $rec = $query->result_array(); if (isset($rec[0])) { $result['count'] = $rec[0]['c']; } else { $result['count'] = 0; } } return $result; }
/** * 获取回答 * * @access public * @param int $parent_qid 父ID * @param int $page 当前页数 * @param int $size 页面大小 * @param int $is_count 是否返回总数 * * @return array 返回列表 */ public function get_reply_by_qid($parent_qid = 0, $page = 1, $size = 10, $is_count = FALSE) { $this->db = K_Model::getInstanceDb(true); $offset = ($page - 1) * $size; $limit = $size; $where = ' where q.is_answer = 1 and q.parent_qid=' . $parent_qid; $sql = 'select q.qid, q.content, q.record_time, m.admin_name from ' . $this->model_name . ' as q ' . 'left join sk_manager as m on q.uid=m.id' . $where . ' order by q.record_time desc limit ' . $offset . ', ' . $limit; $query = $this->db->query($sql); $result['list'] = $query->result_array(); if ($is_count) { $sql = 'select count(*) as c from ' . $this->model_name . ' as q ' . $where; $query = $this->db->query($sql); $rec = $query->result_array(); if (isset($rec[0])) { $result['count'] = $rec[0]['c']; } else { $result['count'] = 0; } } return $result; }
/** * 获取节目信息 * * @access public * @paras int $rid 节目ID * * @return array */ public function getRow($id) { $this->db = K_Model::getInstanceDb(false); $where = array('id' => $id, 'status' => 1); return $this->getRow($where); }
public function get_range_by_lid($lid) { if ($lid > 0) { $this->db = K_Model::getInstanceDb(true); $where = array('lid' => $lid); return $this->getRow($where, array('level', 'min_credit', 'max_credit')); } else { return false; } }
/** * 获取房间信息 * * @access public * @paras int $rid 房间ID * * @return array */ public function get_my_rooms($uid, $skip_rid = 0, $size = 10) { $this->db = K_Model::getInstanceDb(false); if ($uid > 0) { $sql = "select * from " . $this->model_name . " where uid = {$uid} and rid > {$skip_rid} order by rid asc limit {$size}"; $query = $this->db->query($sql); return $query->result_array(); } else { return false; } }
/** * 第三方信息更新 * @param array $where * @param array $field * @return boolean */ public function update_oauth($where, $field) { $this->db = K_Model::getInstanceDb(true); return $this->update($where, $field, $this->oauth); }