private function _post_recommend($limit) { $db_prefix = C('DB_PREFIX'); $sql = "SELECT a.* FROM `{$db_prefix}weiba_post` a, `{$db_prefix}weiba` b WHERE a.weiba_id=b.weiba_id AND ( b.`is_del` = 0 ) AND ( a.`recommend` = 1 ) AND ( a.`is_del` = 0 ) ORDER BY a.recommend_time desc LIMIT " . $limit; $post_recommend = D('weiba_post')->query($sql); $weiba_ids = getSubByKey($post_recommend, 'weiba_id'); $nameArr = $this->_getWeibaName($weiba_ids); foreach ($post_recommend as $k => $v) { $post_recommend[$k]['weiba'] = $nameArr[$v['weiba_id']]; $post_recommend[$k]['user'] = model('User')->getUserInfo($v['post_uid']); $post_recommend[$k]['replyuser'] = model('User')->getUserInfo($v['last_reply_uid']); $images = matchImages($v['content']); $images[0] && ($post_recommend[$k]['image'] = array_slice($images, 0, 5)); /* 解析emoji */ $post_recommend[$k]['title'] = formatEmoji(false, $v['title']); $post_recommend[$k]['content'] = formatEmoji(false, $v['content']); } // dump($post_recommend);exit; $this->assign('post_recommend', $post_recommend); }