public function show($condition, $orderby, $offset, $count)
{
if (!$offset && !$count) {
$limit = '';
} else {
$limit = " limit {$offset}, {$count}";
}
$sql = 'SELECT * FROM ' . DB_PREFIX . 'joint WHERE 1 ' . $condition . $orderby . $limit;
$query = $this->db->query($sql);
$res = array();
$member_ids = array();
while ($row = $this->db->fetch_array($query)) {
$member_ids[] = $row['member_id'];
$res[] = $row;
}
if (!empty($member_ids)) {
$member_ids = implode(',', $member_ids);
//新旧会员处理
if (defined('SEEKHELP_NEW_MEMBER') && SEEKHELP_NEW_MEMBER) {
if ($this->settings['App_members']) {
$userInfor = array();
$temp_members = $this->members->get_newUserInfo_by_ids($member_ids);
if ($temp_members && !empty($temp_members) && is_array($temp_members)) {
foreach ($temp_members as $val) {
$userInfor[$val['member_id']] = $val;
}
}
//hg_pre($members);exit();
}
} else {
$userInfor = $this->get_userinfo_by_id($member_ids);
}
}
if (!empty($res)) {
foreach ($res as $key => $val) {
//新旧会员处理
if (defined('SEEKHELP_NEW_MEMBER') && SEEKHELP_NEW_MEMBER) {
if ($userInfor[$val['member_id']]['member_name']) {
$res[$key]['member_name'] = IS_HIDE_MOBILE ? hg_hide_mobile($userInfor[$val['member_id']]['member_name']) : $userInfor[$val['member_id']]['member_name'];
}
if ($userInfor[$val['member_id']]['avatar']['host']) {
$res[$key]['member_avatar'] = array('host' => $userInfor[$val['member_id']]['avatar']['host'], 'dir' => $userInfor[$val['member_id']]['avatar']['dir'], 'filepath' => $userInfor[$val['member_id']]['avatar']['filepath'], 'filename' => $userInfor[$val['member_id']]['avatar']['filename']);
}
} else {
if ($userInfor[$val['member_id']]['nick_name']) {
$res[$key]['member_name'] = IS_HIDE_MOBILE ? hg_hide_mobile($userInfor[$val['member_id']]['nick_name']) : $userInfor[$val['member_id']]['nick_name'];
}
if ($userInfor[$val['member_id']]['host']) {
$res[$key]['member_avatar'] = array('host' => $userInfor[$val['member_id']]['host'], 'dir' => $userInfor[$val['member_id']]['dir'], 'filepath' => $userInfor[$val['member_id']]['filepath'], 'filename' => $userInfor[$val['member_id']]['filename']);
}
}
}
}
return $res;
}
public function show($condition = '', $orderby = '', $limit = '')
{
$sql = "SELECT * FROM " . DB_PREFIX . "timeline WHERE 1 " . $condition . $orderby . $limit;
$q = $this->db->query($sql);
$info = array();
while ($r = $this->db->fetch_array($q)) {
//此处根据情况做一些格式化的处理,如：date('Y-m-d',TIMENOW);
$member_ids[] = $r['user_id'];
$info[] = $r;
}
if (!empty($member_ids)) {
$member_ids = implode(',', $member_ids);
//新旧会员处理
if (defined('SEEKHELP_NEW_MEMBER') && SEEKHELP_NEW_MEMBER) {
if ($this->settings['App_members']) {
$userInfor = array();
$temp_members = $this->members->get_newUserInfo_by_ids($member_ids);
if ($temp_members && !empty($temp_members) && is_array($temp_members)) {
foreach ($temp_members as $val) {
$userInfor[$val['member_id']] = $val;
}
}
//hg_pre($members);exit();
}
} else {
$userInfor = $this->get_userinfo_by_id($member_ids);
}
}
if (!empty($info)) {
foreach ($info as $key => $val) {
if ($userInfor[$val['user_id']]['member_name']) {
$info[$key]['member_name'] = IS_HIDE_MOBILE ? hg_hide_mobile($userInfor[$val['user_id']]['nick_name']) : $userInfor[$val['user_id']]['nick_name'];
}
if ($userInfor[$val['user_id']]['avatar']['host']) {
$info[$key]['member_avatar'] = array('host' => $userInfor[$val['user_id']]['avatar']['host'], 'dir' => $userInfor[$val['user_id']]['avatar']['dir'], 'filepath' => $userInfor[$val['user_id']]['avatar']['filepath'], 'filename' => $userInfor[$val['user_id']]['avatar']['filename']);
}
}
}
return $info;
}
public function detail()
{
$is_private = false;
//是否允许显示隐私信息
if ($this->input['member_id']) {
$field = 'm.member_id,m.guid,m.member_name,m.signature,m.type,m.type_name,m.gid,m.gradeid,m.groupexpiry,m.avatar,m.credits,m.status,m.isVerify,m.appid,m.appname,m.create_time,m.update_time,m.last_login_time,m.final_login_time,mb.nick_name,g.name as groupname,g.starnum,g.usernamecolor,g.icon as groupicon';
$condition = " AND m.member_id = " . intval($this->input['member_id']);
} else {
if ($this->input['guid']) {
$field = 'm.member_id,m.guid,m.member_name,m.signature,m.type,m.type_name,m.gid,m.gradeid,m.groupexpiry,m.avatar,m.credits,m.status,m.isVerify,m.appid,m.appname,m.create_time,m.update_time,mb.nick_name,g.name as groupname,g.starnum,g.usernamecolor,g.icon as groupicon';
$condition = " AND m.guid = '" . trim($this->input['guid']) . "'";
} else {
if ($this->user['user_id']) {
$field = 'm.*,g.name as groupname,g.starnum,g.usernamecolor,g.icon as groupicon';
$is_private = true;
//是否只可以取隐私数据
$condition = " AND m.member_id = " . intval($this->user['user_id']);
} else {
$this->errorOutput(NO_MEMBER_ID);
}
}
}
//会员信息
$leftjoin = '';
if (!$is_private) {
$leftjoin = ' LEFT JOIN ' . DB_PREFIX . 'member_bind as mb ON mb.member_id = m.member_id';
}
$leftjoin .= ' LEFT JOIN ' . DB_PREFIX . 'group as g ON m.gid=g.id';
$member = $this->mMember->get_member_info($condition, $field, $leftjoin);
$member = $member[0];
if (empty($member)) {
$this->errorOutput(NO_MEMBER);
}
$member_id = $member['member_id'];
// 积分信息
$credits = $this->Members->membercredit($member_id, $is_on = 1, true, true);
$member['credit'] = $credits[$member_id];
$this->Members->setMemberId($member_id);
$gradeInfo = $this->Members->getMemberGrade(array($member['gradeid']), $member['credit']);
if (is_array($gradeInfo)) {
$member = array_merge($member, $gradeInfo);
}
if (empty($member['groupname'])) {
$group_info = $this->Members->updategroup($member_id, 0);
if ($group_info && is_array($group_info)) {
foreach ($group_info as $key => $val) {
$member[$key] = $val;
}
}
}
//获取勋章信息
$member_medal = $this->Members->get_member_medal(array($member_id), $field = 'member_id,medalid,expiration', 2);
$medal_info = $this->Members->get_medal(array_keys($member_medal), 'id,name,image,brief');
$member = $this->Members->make_medal(array($member_id => $member), $medal_info, $member_medal, false);
//绑定信息
//星星图标数据开始
$staricon = $this->Members->staricon();
$member['showstar'] = $this->Members->showstar($member['starnum'], $staricon);
unset($member['starnum']);
//星星图标数据结束
//获取用户签到信息
include CUR_CONF_PATH . 'lib/member_sign.class.php';
$Osign = new sign();
$member['isSign'] = $Osign->getIsSign($member_id);
//获取用户签到信息结束
if ($is_private) {
$condition = " AND mb.member_id = " . $member_id;
$bind = $this->mMember->get_bind_info($condition);
$blacklist = $this->Members->blacklist($member_id);
$purview = $this->Members->showpurview($member['gid']);
$is_exist_password = trim($member['password']) ? 1 : 0;
unset($member['password'], $member['salt']);
}
$extension = array();
if ($member_id) {
//扩展信息
$condition = " AND member_id = " . $member_id;
$member_info = $this->mMemberInfo->show($condition);
//可以根据分类id和分类字段分别查询，同时传值只有一个有效，分类id具有更高优先级
$condition = '';
//根据分类id查询
if (isset($this->input['extension_sort_id']) && !empty($this->input['extension_sort_id'])) {
$condition = " AND field.extension_sort_id IN (" . trim($this->input['extension_sort_id']) . ")";
}
//根据分类字段查询
if (empty($condition)) {
if (isset($this->input['extension_sort']) && !empty($this->input['extension_sort'])) {
$extension_sort = trim($this->input['extension_sort']);
$condition = " AND sort.extension_sort IN ('" . $extension_sort . "')";
}
}
if (intval($this->input['app_id'])) {
$extension = $this->mMemberInfo->extendDataProcessByApp($member_info, 1, $this->input['app_id']);
} else {
$extension = $this->mMemberInfo->extendDataProcess($member_info, 1, $condition);
}
}
$return = $member;
if ($is_private) {
$return['bind'] = $bind;
}
if ($is_private) {
//是否绑定手机
if ($bind) {
$this->mMember->ExportbindData($bind, $return);
}
if (!$return['nick_name']) {
$return['nick_name'] = $return['member_name'];
}
$return['nick_name'] = hg_hide_mobile($return['nick_name']);
$return['mobile'] = $member['mobile'] ? $member['mobile'] : $return['mobile'];
$return['email'] = $member['email'] ? $member['email'] : $return['email'];
$return['is_exist_password'] = $is_exist_password;
$return['blacklist'] = $blacklist[$member['member_id']];
$return['purview'] = $purview[$member['gid']] ? $purview[$member['gid']] : array();
$return['isComplete'] = isUserComplete($member['type']);
$return['profilePercent'] = $this->mMember->profilePercentComplete($return);
}
//
if ($this->input['version'] == CLIENT_VERSION) {
$return = array('nick_name' => $return['member_name'], 'member_id' => $return['member_id'], 'avatar' => $return['avatar'] ? $return['avatar'] : array('host' => "", 'dir' => "", 'filepath' => "", 'filename' => ""));
if ($is_private) {
$return['token'] = $this->input['access_token'];
$return['email'] = $return['email'];
$return['is_exist_password'] = $is_exist_password;
$return['is_exist_email'] = $return['email'] ? 1 : 0;
$return['mobile'] = $return['mobile'];
}
}
$return['extension'] = $extension ? $extension : array();
//查询好友关系
if ($this->input['member_id']) {
$friend_ship = $this->getFriendship($member_id);
$return['friendship'] = $friend_ship;
}
//
$this->addItem($return);
$this->output();
}
/**
* comment详情
*/
public function comment_detail($id)
{
$info = array();
$member_ids = array();
$sql = 'SELECT * FROM ' . DB_PREFIX . 'comment WHERE 1 AND id IN(' . $id . ')';
$query = $this->db->query($sql);
while ($row = $this->db->fetch_array($query)) {
$member_ids[] = $row['member_id'];
$row['content'] = seekhelp_clean_value(stripcslashes(urldecode($row['content'])));
$info[] = $row;
}
if (!empty($member_ids)) {
$member_ids = implode(',', $member_ids);
//新旧会员处理
if (defined('SEEKHELP_NEW_MEMBER') && SEEKHELP_NEW_MEMBER) {
if ($this->settings['App_members']) {
$userInfor = array();
$temp_members = $this->members->get_newUserInfo_by_ids($member_ids);
if ($temp_members && !empty($temp_members) && is_array($temp_members)) {
foreach ($temp_members as $val) {
$userInfor[$val['member_id']] = $val;
}
}
//hg_pre($members);exit();
}
} else {
$userInfor = $this->get_userinfo_by_id($member_ids);
}
}
if (!empty($info)) {
foreach ($info as $key => $val) {
//新旧会员处理
if (defined('SEEKHELP_NEW_MEMBER') && SEEKHELP_NEW_MEMBER) {
if ($userInfor[$val['member_id']]['member_name']) {
$info[$key]['member_name'] = IS_HIDE_MOBILE ? hg_hide_mobile($userInfor[$val['member_id']]['nick_name']) : $userInfor[$val['member_id']]['nick_name'];
}
if ($userInfor[$val['member_id']]['avatar']['host']) {
$info[$key]['member_avatar'] = array('host' => $userInfor[$val['member_id']]['avatar']['host'], 'dir' => $userInfor[$val['member_id']]['avatar']['dir'], 'filepath' => $userInfor[$val['member_id']]['avatar']['filepath'], 'filename' => $userInfor[$val['member_id']]['avatar']['filename']);
$info[$key]['member_level'] = intval($userInfor[$val['member_id']]['digital']);
}
} else {
if ($userInfor[$val['member_id']]['nick_name']) {
$info[$key]['member_name'] = IS_HIDE_MOBILE ? hg_hide_mobile($userInfor[$val['member_id']]['nick_name']) : $userInfor[$val['member_id']]['nick_name'];
}
if ($userInfor[$val['member_id']]['host']) {
$info[$key]['member_avatar'] = array('host' => $userInfor[$val['member_id']]['host'], 'dir' => $userInfor[$val['member_id']]['dir'], 'filepath' => $userInfor[$val['member_id']]['filepath'], 'filename' => $userInfor[$val['member_id']]['filename']);
}
}
}
}
return $info;
}
/**
* 创建评论
* cid
* @see outerUpdateBase::create()
*/
public function create()
{
if ($this->input['app_id']) {
//检查社区黑名单
$blackInfo = $this->blacklist->check_blackByappId($this->input['app_id']);
if ($blackInfo && $blackInfo['deadline'] == -1) {
$this->errorOutput(SEEKHELP_IS_BLACK);
}
}
$data = array('cid' => intval($this->input['cid']), 'member_id' => intval($this->user['user_id']), 'comment_type' => trim($this->input['comment_type']), 'comment_fid' => intval($this->input['comment_fid']), 'location' => trim($this->input['location']), 'status' => 0, 'content' => $this->input['content'], 'create_time' => TIMENOW, 'ip' => $this->user['ip']);
//comment_type默认值 此处兼容老社区
if (!$this->input['comment_type']) {
$data['comment_type'] = 'main';
}
if (defined('SEEKHELP_COMMENT_STATUS') && SEEKHELP_COMMENT_STATUS) {
$data['status'] = 1;
}
if ($this->input['app_id'] && $data['comment_type'] == 'main') {
$app_id = $this->input['app_id'];
$appconfig = $this->appconfig->detail($app_id);
if ($appconfig['comment_audit'] == 0) {
$data['status'] = 1;
} else {
$data['status'] = 0;
}
}
if (!$data['cid'] || !$data['member_id'] || !$data['content']) {
$this->errorOutput(NOID);
}
// if(!$data['comment_type'])
// {
// $this->errorOutput(NO_COMMENT_TYPE);
// }
//会员黑名单验证
include_once ROOT_PATH . 'lib/class/members.class.php';
$obj = new members();
$res = $obj->check_blacklist($data['member_id']);
if ($res[$data['member_id']]['isblack']) {
//$this->addItem_withkey('error', "您的评论被屏蔽，请联系管理员！");
//$this->addItem_withkey('msg', "您的评论被屏蔽，请联系管理员！");
//$this->output();
$this->errorOutput(IS_BLACK_MEMBER);
}
$sql = "SELECT * FROM " . DB_PREFIX . "seekhelp WHERE id = " . $data['cid'];
$seekhelp = $this->db->query_first($sql);
$sort_id = $seekhelp['sort_id'];
$data['sort_id'] = $sort_id;
//屏蔽字验证
if ($this->settings['App_banword']) {
require_once ROOT_PATH . 'lib/class/banword.class.php';
$this->banword = new banword();
$str = $data['content'];
$banword = $this->banword->exists($str);
if ($banword && is_array($banword)) {
$banword_content = '';
foreach ($banword as $key => $val) {
$banword_content .= $val['banname'] . ',';
}
$data['banword'] = $banword_content ? rtrim($banword_content, ',') : '';
$data['status'] = 0;
}
}
$data['content'] = urlencode($data['content']);
$ret = $this->comment->create($data);
if ($ret) {
if ($data['status']) {
if ($data['comment_type'] == 'vice') {
$sql = "SELECT * FROM " . DB_PREFIX . "comment WHERE id = " . $data['comment_fid'];
$comment = $this->db->query_first($sql);
$this->SetCommentNum($data['comment_type'], $ret);
$this->SetTimeline($ret['id'], $comment, 'comment');
$this->SetMemberInfo($comment);
} else {
$this->SetCommentNum($data['comment_type'], $ret);
$this->SetTimeline($ret['id'], $seekhelp, 'seekhelp');
$this->SetMemberInfo($seekhelp);
}
//更新会员统计
if ($data['comment_type'] == 'main') {
$this->updateMemberCount($data['member_id'], 'create');
}
}
}
if ($this->settings['App_members']) {
$memberInfo = $this->members->get_newUserInfo_by_ids($data['member_id']);
}
$ret['member_avatar'] = $memberInfo[0]['avatar'];
$ret['member_name'] = IS_HIDE_MOBILE ? hg_hide_mobile($memberInfo[0]['nick_name']) : $memberInfo[0]['nick_name'];
$ret['content'] = seekhelp_clean_value(stripcslashes(urldecode($ret['content'])));
$this->addItem($ret);
$this->output();
}
/**
* 获取会话里的用户
*
* @param string or array $session_id 会话id 可以是数组或逗号隔开的字符串
* @return array 返回按会话分组的 用户数组
*/
function session_users($session_id)
{
if (!is_array($session_id)) {
$session_id = explode(',', $session_id);
}
$session_id = implode("','", $session_id);
if (!$session_id) {
return false;
}
$sql = 'SELECT * FROM ' . DB_PREFIX . 'session_user
WHERE 1 AND session_id IN(\'' . $session_id . '\') ORDER BY id ASC';
$q = $this->db->query($sql);
$ret = array();
while ($row = $this->db->fetch_array($q)) {
$row['uname'] = hg_hide_mobile($row['uname']);
$row['uavatar'] = $row['uavatar'] ? unserialize($row['uavatar']) : array();
$ret[$row['session_id']][] = $row;
}
return $ret;
}
public function detail($id, $member_id = 0)
{
$sql = 'SELECT sh.*, c.content,
a.name AS account_name, a.avatar AS account_avatar,
s.name AS sort_name,
r.content AS reply, r.create_time AS reply_time, r.user_id AS reply_user_id
FROM ' . DB_PREFIX . 'seekhelp sh
LEFT JOIN ' . DB_PREFIX . 'content c ON sh.id = c.id
LEFT JOIN ' . DB_PREFIX . 'account a ON sh.account_id = a.id
LEFT JOIN ' . DB_PREFIX . 'sort s ON sh.sort_id = s.id
LEFT JOIN ' . DB_PREFIX . 'reply r ON sh.reply_id = r.id
WHERE sh.id = ' . $id;
$ret = $this->db->query_first($sql);
if (!$ret) {
$sql = 'SELECT * FROM ' . DB_PREFIX . 'content WHERE id=' . $id . '';
$ret = $this->db->query_first($sql);
}
$ret['format_create_time'] = date('Y-m-d', $ret['create_time']);
$ret['account_avatar'] = $ret['account_avatar'] ? unserialize($ret['account_avatar']) : '';
$ret['title'] = stripcslashes($ret['title']);
$ret['content'] = seekhelp_clean_value(stripcslashes(urldecode($ret['content'])));
$ret['banword'] = $ret['banword'] ? unserialize($ret['banword']) : '';
//初始化变量
$ret['is_joint'] = 0;
$ret['is_attention'] = 0;
$ret['comment_num'] = 0;
$ret['attention_num'] = 0;
$ret['joint_num'] = 0;
$ret['pic'] = '';
$ret['video'] = '';
$ret['vodeo_audio'] = '';
$ret['member_name'] = '';
$ret['member_avatar'] = '';
$ret['reply_user_name'] = '';
$ret['reply_avatar'] = '';
$ret['reply_pass_time'] = '';
$ret['reply_pic'] = '';
$ret['reply_video'] = '';
$ret['reply_video_audio'] = '';
$ret['recommend_answer'] = '';
$ret['recommend_user_id'] = '';
$ret['recommend_user_name'] = '';
$ret['recommend_avatar'] = '';
$ret['recommend_time'] = '';
$ret['recommend_pass_time'] = '';
$comment_num = $this->comment_num($id);
$attention_num = $this->attention_num($id);
$joint_num = $this->joint_num($id);
$ret['comment_num'] = $comment_num[$id] ? $comment_num[$id] : 0;
$ret['attention_num'] = $attention_num[$id] ? $attention_num[$id] : 0;
$ret['joint_num'] = $joint_num[$id] ? $joint_num[$id] : 0;
//取系统用户
if ($ret['reply_user_id'] && $this->settings['App_auth']) {
$curl = new curl($this->settings['App_auth']['host'], $this->settings['App_auth']['dir']);
$curl->setSubmitType('post');
$curl->setReturnFormat('json');
$curl->initPostData();
$curl->addRequestData('a', 'getMemberById');
$curl->addRequestData('id', $ret['reply_user_id']);
$userInfor = $curl->request('member.php');
//print_r($userInfor);exit();
$userInfor = $userInfor[0][0];
if ($userInfor) {
$ret['reply_user_name'] = IS_HIDE_MOBILE ? hg_hide_mobile($userInfor['user_name']) : $userInfor['user_name'];
$ret['reply_avatar'] = $userInfor['avatar'];
}
}
if ($ret['is_reply']) {
$ret['comment_num'] += 1;
//如果有金牌回复,则评论数+1
if ($ret['reply']) {
$ret['reply_pass_time'] = TIMENOW - $ret['reply_time'];
}
}
//联名、关注状态判断
if ($member_id) {
$is_joint = $this->check_is_joint($member_id, $id);
$is_attention = $this->check_is_attention($member_id, $id);
$ret['is_joint'] = $is_joint ? 1 : 0;
$ret['is_attention'] = $is_attention ? 1 : 0;
}
//用户信息处理
$memberIds = array();
$memberIds[] = $ret['member_id'];
if ($ret['is_recommend'] && $ret['comment_id']) {
$sql = 'SELECT * FROM ' . DB_PREFIX . 'comment
WHERE id = ' . $ret['comment_id'] . ' AND status = 1 AND is_recommend = 1';
$commentInfor = $this->db->query_first($sql);
if ($commentInfor) {
$ret['recommend_answer'] = $commentInfor['content'];
$ret['recommend_user_id'] = $commentInfor['member_id'];
$ret['recommend_time'] = $commentInfor['create_time'];
$ret['recommend_pass_time'] = TIMENOW - $commentInfor['create_time'];
$memberIds[] = $commentInfor['member_id'];
}
}
//新旧会员处理
if (defined('SEEKHELP_NEW_MEMBER') && SEEKHELP_NEW_MEMBER) {
if ($this->settings['App_members'] && !empty($memberIds)) {
$memberIds = implode(',', $memberIds);
$member = array();
$temp_members = $this->members->get_newUserInfo_by_ids($memberIds);
if ($temp_members && !empty($temp_members) && is_array($temp_members)) {
foreach ($temp_members as $val) {
$member[$val['member_id']] = $val;
}
}
}
if ($member && $ret['member_id']) {
$ret['member_name'] = IS_HIDE_MOBILE ? hg_hide_mobile($member[$ret['member_id']]['nick_name']) : $member[$ret['member_id']]['nick_name'];
$ret['member_avatar'] = array('host' => $member[$ret['member_id']]['avatar']['host'], 'dir' => $member[$ret['member_id']]['avatar']['dir'], 'filepath' => $member[$ret['member_id']]['avatar']['filepath'], 'filename' => $member[$ret['member_id']]['avatar']['filename']);
}
if ($member && $ret['recommend_user_id']) {
$ret['recommend_user_name'] = IS_HIDE_MOBILE ? hg_hide_mobile($member[$ret['recommend_user_id']]['member_name']) : $member[$ret['recommend_user_id']]['member_name'];
$ret['recommend_avatar'] = array('host' => $member[$ret['recommend_user_id']]['avatar']['host'], 'dir' => $member[$ret['recommend_user_id']]['avatar']['dir'], 'filepath' => $member[$ret['recommend_user_id']]['avatar']['filepath'], 'filename' => $member[$ret['recommend_user_id']]['avatar']['filename']);
}
} else {
if ($this->settings['App_member'] && !empty($memberIds)) {
$memberIds = implode(',', $memberIds);
$member = $this->member->getMemberByIds($memberIds);
$member = $member[0];
}
if ($member && $ret['member_id']) {
$ret['member_name'] = IS_HIDE_MOBILE ? hg_hide_mobile($member[$ret['member_id']]['nick_name']) : $member[$ret['member_id']]['nick_name'];
$ret['member_avatar'] = array('host' => $member[$ret['member_id']]['host'], 'dir' => $member[$ret['member_id']]['dir'], 'filepath' => $member[$ret['member_id']]['filepath'], 'filename' => $member[$ret['member_id']]['filename']);
}
if ($member && $ret['recommend_user_id']) {
$ret['recommend_user_name'] = IS_HIDE_MOBILE ? hg_hide_mobile($member[$ret['recommend_user_id']]['nick_name']) : $member[$ret['recommend_user_id']]['nick_name'];
$ret['recommend_avatar'] = array('host' => $member[$ret['recommend_user_id']]['host'], 'dir' => $member[$ret['recommend_user_id']]['dir'], 'filepath' => $member[$ret['recommend_user_id']]['filepath'], 'filename' => $member[$ret['recommend_user_id']]['filename']);
}
}
//获取素材
/*
if ($ret['reply_id'])
{
$sql = 'SELECT * FROM '.DB_PREFIX.'materials WHERE cid = '.$id.' OR rid = '.$ret['reply_id'];
}
else
{
$sql = 'SELECT * FROM '.DB_PREFIX.'materials WHERE cid = '.$id;
}
*/
//排除异常数据
$sql = 'DELETE FROM ' . DB_PREFIX . 'materials WHERE flag = 1';
$this->db->query($sql);
$sql = 'SELECT * FROM ' . DB_PREFIX . 'materials WHERE cid = ' . $id . ' ORDER BY id DESC';
$query = $this->db->query($sql);
$content_materials = array();
$reply_materials = array();
$vodIds = array();
$id_original_id = array();
while ($row = $this->db->fetch_array($query)) {
if ($row['mark'] == 'video') {
$vodIds[] = $row['original_id'];
$id_original_id[$row['original_id']] = $row['id'];
}
if ($row['cid'] == $id && !$row['rid']) {
if ($row['mark'] == 'img') {
$content_materials['pic'][] = array('id' => $row['id'], 'host' => $row['host'], 'dir' => $row['dir'], 'filepath' => $row['filepath'], 'filename' => $row['filename'], 'imgwidth' => $row['imgwidth'], 'imgheight' => $row['imgheight']);
}
if ($row['mark'] == 'video') {
$content_materials['vodid'][] = $row['original_id'];
}
}
if ($ret['reply_id'] && $row['rid'] == $ret['reply_id']) {
if ($row['mark'] == 'img') {
$reply_materials['pic'][] = array('id' => $row['id'], 'host' => $row['host'], 'dir' => $row['dir'], 'filepath' => $row['filepath'], 'filename' => $row['filename'], 'imgwidth' => $row['imgwidth'], 'imgheight' => $row['imgheight']);
}
if ($row['mark'] == 'video') {
$reply_materials['vodid'][] = $row['original_id'];
}
}
}
if (!empty($content_materials['pic'])) {
$ret['pic'] = $content_materials['pic'];
}
if (!empty($reply_materials['pic'])) {
$ret['reply_pic'] = $reply_materials['pic'];
}
if (!empty($vodIds)) {
$vod_ids = implode(',', $vodIds);
$vodInfor = $this->livmedia->get_video($vod_ids);
if ($vodInfor) {
if (!empty($content_materials['vodid']) && is_array($content_materials['vodid'])) {
foreach ($content_materials['vodid'] as $vodid) {
if ($vodInfor[$vodid]['is_audio'] == 0) {
$vodInfor[$vodid]['id'] = $id_original_id[$vodid];
$ret['video'][] = $vodInfor[$vodid];
}
if ($vodInfor[$vodid]['is_audio']) {
$vodInfor[$vodid]['id'] = $id_original_id[$vodid];
$ret['vodeo_audio'][] = $vodInfor[$vodid];
}
}
}
if (!empty($reply_materials['vodid']) && is_array($reply_materials['vodid'])) {
foreach ($reply_materials['vodid'] as $vodid) {
if ($vodInfor[$vodid]['is_audio'] == 0) {
$vodInfor[$vodid]['id'] = $id_original_id[$vodid];
$ret['reply_video'][] = $vodInfor[$vodid];
}
if ($vodInfor[$vodid]['is_audio']) {
$vodInfor[$vodid]['id'] = $id_original_id[$vodid];
$ret['reply_video_audio'][] = $vodInfor[$vodid];
}
}
}
}
}
//输出常量
$ret['show_other_data'] = false;
if (defined('SHOW_OTHER_DATA')) {
$ret['show_other_data'] = SHOW_OTHER_DATA;
}
return $ret;
}
/**
*
* 获取找回密码邮箱验证码接口...
*/
public function getResetPasswordlinkMail()
{
$memberId = 0;
$link_url = $this->input['link_url'];
$identifierUserSystem = new identifierUserSystem();
$identifier = $identifierUserSystem->setIdentifier((int) $this->input['identifier'])->checkIdentifier();
//多用户系统
if ($memberName = trimall($this->input['member_name'])) {
$this->email = $memberName;
$nick_name = '用户';
if (hg_check_email_format($memberName)) {
$condition = " AND platform_id='" . $memberName . "' AND mb.type='email' AND mb.identifier=" . $identifier . "";
$leftjoin = " LEFT JOIN " . DB_PREFIX . "member_bind as mb ON m.member_id=mb.member_id ";
$memberInfo = $this->Members->get_member_info($condition, $field = ' mb.* ', $leftjoin, '', false);
$nick_name = $memberInfo['nick_name'];
}
$this->type = 'resetpassword';
$this->appuniqueid = 'resetpassword_link';
$this->tspace = array(hg_verify_mobile($memberName) ? hg_hide_mobile($memberName) : $memberName);
$this->verify_email();
$this->_expire_time = $this->settings['email_token_limit']['time_limit'] ? TIMENOW + $this->settings['email_token_limit']['time_limit'] : TIMENOW + 1000;
$condition = " AND email='" . $memberName . "' AND status=0";
$email_token_info = $this->email_token->show($condition, ' ORDER BY id DESC ', 'limit 1');
if (!$email_token_info) {
$this->token = $this->makeToken(16);
} else {
$this->token = $email_token_info[0]['token'];
//如果该验证码已经过期就重新生成验证码
if ($email_token_info[0]['expire_time'] < TIMENOW) {
$this->token = $this->makeToken(16);
} else {
//如果没有过期，过期时间还是原来的
$this->_expire_time = $email_token_info[0]['expire_time'];
}
}
$url = $link_url . '&email=' . $memberName . '&token=' . $this->token;
$this->bspace = array($memberName, $nick_name, $url);
$sendInfo = $this->generate_link_email();
if ($sendInfo) {
$output = array('email' => $sendInfo['email']);
$this->addItem($output);
}
$this->output();
} else {
$this->errorOutput(NO_MEMBER_NAME);
}
}
