/**
* 获取评论信息
*/
function show()
{
$this->input['count'] = $this->input['count'] ? $this->input['count'] : 10;
$this->input['offset'] = $this->input['offset'] ? $this->input['offset'] : 0;
$sql = 'select * from ' . DB_PREFIX . 'status_comments where 1 ' . $this->get_condition() . ' order by comment_time desc limit ' . $this->input['offset'] . ',' . $this->input['count'];
//hg_pre($sql);
$comment_all_data = $this->db->query($sql);
$member_ids = array();
$status_ids = array();
while ($result = $this->db->fetch_array($comment_all_data)) {
$result['comment_time'] = date('Y-m-d H:i', $result['comment_time']);
//审核状态
$result['state'] = $result['flag'];
$result['flag'] = $result['flag'] ? '通过' : '待审';
$member_ids[] = $result['member_id'];
$status_ids[] = $result['status_id'];
$result['content'] = hg_verify($result['content']);
$comments[] = $result;
}
//获取评论相对应的用户信息
$userinfo = $this->get_user_info($member_ids);
//hg_pre($status_ids);
//获取评论相对应的点滴信息
$statusinfo = $this->get_status_info($status_ids);
//评论 用户 点滴信息的合并
foreach ($comments as $k => $v) {
$v['user'] = $userinfo[$v['member_id']];
$v['status'] = $statusinfo[$v['status_id']];
$this->addItem($v);
$a[] = $v;
}
//hg_pre($a);
$this->output();
}
public function send_msg()
{
$sid = $this->input['sid'];
$content = $this->input['content'];
//解析表情$text = hg_verify($value['text']);
$content = hg_verify($content);
$to_name = $this->input['to_name'];
$users = $this->mUser->getUserByName($to_name);
$pid = intval($this->input['pid']);
$id = array();
if ($users) {
foreach ($users as $key => $user) {
$id[$user['id']] = $user['id'];
}
array_filter($id);
$ids = implode(',', array_keys($id));
$msg = $this->mMessages->send_message($sid, $ids, $content, $pid);
//print_r($msg);
$msg = $msg[0];
echo json_encode($msg);
} else {
echo '您选择的用户不存在';
}
}
/**
* 获取单条数据
*/
public function detail()
{
$this->input['id'] = urldecode($this->input['id']);
if (!$this->input['id']) {
$condition = ' ORDER BY id DESC LIMIT 1';
} else {
$condition = ' WHERE id in(' . $this->input['id'] . ')';
}
$sql = "SELECT * FROM " . DB_PREFIX . "comments " . $condition;
$r = $this->db->query_first($sql);
$uid = $r['user_id'] . ',' . $r['reply_user_id'];
$userinfo = $this->mVideo->getUserById($uid);
$this->setXmlNode('comment', 'info');
if (is_array($r) && $r) {
if ($this->settings['rewrite']) {
$r['user_link'] = SNS_UCENTER . "user-" . $r['user_id'] . ".html";
if ($r['reply_user_id']) {
$r['reply_user_link'] = SNS_UCENTER . "user-" . $r['reply_user_id'] . ".html";
}
$r['pagelink'] = SNS_VIDEO . "video-" . $r['cid'] . ".html";
} else {
$r['user_link'] = SNS_UCENTER . "user.php?user_id=" . $r['user_id'];
if ($r['reply_user_id']) {
$r['reply_user_link'] = SNS_UCENTER . "user.php?user_id=" . $r['reply_user_id'];
}
$r['pagelink'] = SNS_VIDEO . "video_play.php?id=" . $r['cid'];
}
$r['create_time'] = date('Y-m-d H:i:s', $r['create_time']);
$r['user'] = $userinfo[$r['user_id']];
$r['content'] = hg_verify($r['content']);
$r['reply_user'] = $userinfo[$r['reply_user_id']];
$this->addItem($r);
$this->output();
} else {
$this->errorOutput('评论不存在');
}
}
public function pub_to_group($status_id = "", $group_ids = "")
{
$group_ids = $this->input['group_ids'] ? $this->input['group_ids'] : $group_ids;
$status_id = $this->input['status_id'] ? $this->input['status_id'] : $status_id;
$status_info = $this->status->show(intval($status_id));
$status_info = $status_info[0];
$ip = $status_info['ip'];
$content = hg_verify($status_info['text']);
if (!empty($status_info['medias'])) {
$mediaInfo = $status_info['medias'];
foreach ($status_info['medias'] as $key => $mediaInfo) {
$type = $mediaInfo['type'];
$content .= $media_str = $type > 0 ? strstr($mediaInfo['link'], '.swf') ? ' [flash]' . $mediaInfo['link'] . '[/flash] <br />' : ' [real]' . $mediaInfo['link'] . '[/real] <br />' : ' [img]' . $mediaInfo['larger'] . '[/img] <br />';
}
}
$spe_char = array('#', '@');
$spe_replace = array('', '');
$text = str_replace($spe_char, $spe_replace, $status_info['text']);
$title = mb_substr(hg_move_face($text), 0, 30, 'utf-8');
$groupids = explode(',', $group_ids);
$tmp = array();
foreach ($groupids as $key => $idd) {
if ($idd) {
$tmp[$idd] = $idd;
}
}
include_once ROOT_PATH . 'lib/class/groups.class.php';
$groups = new Group();
foreach ($tmp as $gid) {
$rr = $groups->add_new_thread($gid, $title, $content, $ip);
}
if (empty($rr)) {
//echo json_encode('false');
} else {
//echo json_encode('true');
}
}
<p class="subject">
<?php
echo $text_show . "<br/>";
?>
</p>
<?php
include hg_load_template('statusline_content');
?>
<div class="speak">
<div class="hidden" id="t_<?php
echo $value['id'];
?>
"><?php
echo hg_verify($title);
?>
</div>
<div class="hidden" id="f_<?php
echo $value['id'];
?>
"><?php
echo $forward_show;
?>
</div>
<span id = "<?php
echo "fa" . $value['id'];
?>
" style="position:relative;">
<?php
if ($is_my_page) {
$len = strlen('#' . $keywords . '#');
if (substr(trim($value['text']), $len - 1, 1) == '#') {
$value['text'] = substr(trim($value['text']), $len);
}
$text = hg_verify($value['text']);
$text_show = '：' . ($value['text'] ? $value['text'] : $this->lang['forward_null']);
if ($value['reply_status_id']) {
$forward_show = '//@' . $value['user']['username'] . ' ' . $text_show;
$title = $this->lang['forward_one'] . $value['retweeted_status']['text'];
$status_id = $value['reply_user_id'];
} else {
$forward_show = '';
$title = $this->lang['forward_one'] . $value['text'];
$status_id = $value['member_id'];
}
$text_show = hg_match_red(hg_verify($text_show), $keywords);
$transmit_info = $value['retweeted_status'];
?>
<li>
<span class="zhibo_huifu"><a href="javascript:void(0);" onclick="disreplyStatus(<?php
echo $value['id'];
?>
, '<?php
echo $value['user']['username'];
?>
');return false;">回复</a></span>
<a href="<?php
echo $user_url;
?>
" class="zhibo_name" target="_blank"><?php
echo $value['user']['username'];
<ul class="mblog">
<?php
foreach ($statusline as $key => $value) {
$user_url = hg_build_link('user.php', array('user_id' => $value['member_id']));
$text = hg_verify($value['text']);
$text_show = $value['text'] ? $value['text'] : $this->lang['forward_null'];
if ($value['reply_status_id']) {
$forward_show = '//@' . $value['user']['username'] . ' ' . $text_show;
$title = $this->lang['forward_one'] . $value['retweeted_status']['text'];
$status_id = $value['reply_user_id'];
} else {
$forward_show = '';
$title = $this->lang['forward_one'] . $value['text'];
$status_id = $value['member_id'];
}
$text_show = hg_verify($text_show);
$transmit_info = $value['retweeted_status'];
?>
<li class="my-blog" id="mid_<?php
echo $value['id'];
?>
" onmouseover="report_show(<?php
echo $value['id'];
?>
,<?php
echo $value['user']['id'];
?>
);" onmouseout="report_hide(<?php
echo $value['id'];
?>
,<?php
echo hg_build_link(SNS_UCENTER . 'user.php', array('user_id' => $value['user']['id']));
?>
"><img src="{$value['user']['middle_avatar']}"/></a></div>
<div class="comment-bar">
<a class="bar-left" target="_blank" href="<?php
echo hg_build_link(SNS_UCENTER . 'user.php', array('user_id' => $value['user']['id']));
?>
">{$value['user']['username']}</a>
<div style="display:none;" id="cons_{$value['id']}_{$value['user']['id']}"><?php
echo hg_show_face($value['content']);
?>
</div>
<div style="display:none;" id="ava_{$value['id']}_{$value['user']['id']}">{$value['user']['middle_avatar']}</div>
<div style="display:none;" id="user_{$value['id']}_{$value['user']['id']}">{$value['user']['username']}</div>
<div style="display:none;" id="cons_{$value['id']}_{$value['user']['id']}"><?php
echo hg_verify($value['content']);
?>
</div>
{if $_INPUT['id']}
{code}
$type = 5;/*视频*/
$url = SNS_VIDEO.'video_play.php?id='.$cid.'#c'.$value['id'];
{/code}
{/if}
{if $_INPUT['sta_id']}
{code}
$type = 11;/*频道*/
$url = SNS_VIDEO.'station_play.php?sta_id='.$cid.'#c'.$value['id'];
{/code}
{/if}
<div style="display:none;" id="url_{$value['id']}_{$value['user']['id']}">{$url}</div>
</div>
{/if}
{if $transmit_info['text']||!empty($transmit_info['medias'])}
<div class="comment clear">
<div class="top"></div>
<div class="middle clear">
<p class="subject"><?php
echo hg_verify("@" . $transmit_info['user']['username'] . ":" . $transmit_info['text']);
?>
<br/>
</p>
<!-- <p class="subject"><?php
echo hg_verify("@" . $transmit_info['user']['username'] . ":" . $transmit_info['text']) . "<br/>";
?>
</p >-->
{if is_array($transmit_info['medias'])}
<input id="rot_{code} echo $transmit_info['id'] + $value['id'];{/code}" type="hidden" value="0"/>
<div id="prev_{code} echo $transmit_info['id'] + $value['id'];{/code}" style="display:{code} echo $show = $is_details ? 'none' : 'inline-block'{/code}">
{foreach $transmit_info['medias'] as $mk => $mv}
{code}
$var = array(
"url" => "",
"imgname" => "",
"ori" => "",
"video_url" => "",
">
<img class="pic" src="<?php
echo $value['user']['middle_avatar'];
?>
">
</a>
<div class="ping_list_right">
<p class="title_name"><a href="<?php
echo hg_build_link(SNS_UCENTER . 'user.php', array('user_id' => $value['user']['id']));
?>
"><?php
echo $value['user']['username'];
?>
</a><span>：<?php
echo hg_verify($value['text']);
?>
</span> <span class="ping_date">(<?php
echo hg_get_date($value['create_at']);
?>
)</span></p>
<p class="huifu"><span class="huifu_span" id="speak_<?php
echo $value['id'];
?>
_<?php
echo $tag;
?>
"><?php
if ($this->user['id']) {
?>
<a onclick="report_play(<?php
</div>
<a href="<?php
echo hg_build_link(SNS_UCENTER . 'user.php', array('user_id' => $v['id']));
?>
"><img src="<?php
echo $v['middle_avatar'];
?>
" title="<?php
echo $v['username'];
?>
" /></a>
<div style="margin:5px;" >
<?php
echo hg_verify($v['text']);
?>
</div>
</li>
<?php
}
?>
</ul>
<div style="clear:both;"></div>
<?php
echo $showpages;
?>
</div>
<?php
public function del_comment()
{
$cid = intval($this->input['cid']);
$result = $this->mComment->del_comment($cid);
foreach ($result as $key => $value) {
if ($key == "content") {
$value = hg_verify($value);
}
}
$result = json_encode($result);
print_r($result);
}
/**
获取微博
*/
public function status($condition, $orderby = 's.create_at DESC', $offset = 0, $count = 20)
{
$offset = intval($offset);
$count = intval($count);
$offset = $offset ? $offset : 0;
$count = $count ? $count : 20;
if (!$orderby) {
$orderby = 's.create_at DESC';
}
$sql = 'SELECT *, (transmit_count + reply_count) AS transmit_count FROM ' . DB_PREFIX . 'status s
LEFT JOIN ' . DB_PREFIX . 'status_extra se
ON s.id=se.status_id
WHERE 1 ' . $condition . '
ORDER BY ' . $orderby . '
LIMIT ' . $offset . ',' . $count;
$q = $this->db->query($sql);
$status_info = array();
$trans_status = array();
$member_ids = array();
$status_ids = array();
while ($r = $this->db->fetch_array($q)) {
$r['create_at'] = date('Y-m-d H:i:s', $r['create_at']);
if ($r['status'] == 0) {
$r['audit'] = 1;
$r['status_show'] = '通过';
} else {
$r['audit'] = 0;
$r['status_show'] = '不通过';
}
if ($this->settings['rewrite']) {
$r['status_link'] = SNS_MBLOG . "status-" . $r['id'] . ".html";
} else {
$r['status_link'] = SNS_MBLOG . 'show.php?id=' . $r['id'];
}
$r['text'] = hg_verify($r['text']);
$status_info[$r['id']] = $r;
$member_ids[] = $r['member_id'];
$status_ids[] = $r['id'];
if ($r['reply_status_id']) {
$status_ids[] = $r['reply_status_id'];
$trans_status[$r['id']] = $r['reply_status_id'];
$member_ids[] = $r['reply_user_id'];
}
}
//获取转发信息
if ($trans_status) {
$sql = 'SELECT * FROM ' . DB_PREFIX . 'status s
LEFT JOIN ' . DB_PREFIX . 'status_extra se
ON s.id=se.status_id
WHERE id IN ( ' . implode(',', $trans_status) . ' )';
$q = $this->db->query($sql);
$trans_status = array();
while ($r = $this->db->fetch_array($q)) {
$r['create_at'] = date('Y-m-d H:i:s', $r['create_at']);
if ($this->settings['rewrite']) {
$r['status_link'] = SNS_MBLOG . "status-" . $r['id'] . ".html";
} else {
$r['status_link'] = SNS_MBLOG . 'show.php?id=' . $r['id'];
}
$r['text'] = hg_verify($r['text']);
if ($r['status'] == 0) {
$r['audit'] = 1;
$r['status_show'] = '通过';
} else {
$r['audit'] = 0;
$r['status_show'] = '不通过';
}
$trans_status[$r['id']] = $r;
}
}
//获取媒体信息
if ($status_ids) {
$condition = ' AND status_id IN (' . implode(',', $status_ids) . ')';
$medias = $this->media->media($condition);
}
//获取用户信息
if ($member_ids) {
$userinfo = $this->mUser->getUserById(implode(',', array_unique($member_ids)));
$members = array();
if ($userinfo) {
foreach ($userinfo as $user) {
$members[$user['id']] = $user;
}
}
}
//合并微博信息
if ($status_info) {
foreach ($status_info as $k => $v) {
$status_info[$k]['user'] = $members[$v['member_id']];
//合并用户
if ($v['reply_status_id']) {
if ($trans_status[$v['reply_status_id']]) {
$trans = $trans_status[$v['reply_status_id']];
} else {
$trans = array('id' => 0, 'text' => '该信息已删除');
}
$trans['user'] = $members[$v['reply_user_id']];
//合并转发用户
$trans['medias'] = $medias[$v['reply_status_id']];
//合并转发媒体信息
$status_info[$k]['trans'] = $trans;
//合并转发
}
$status_info[$k]['medias'] = $medias[$k];
//合并媒体信息
}
}
return $status_info;
}
);"><?php
echo $this->lang['report'];
?>
</a></strong><?php
}
?>
<div style="display:none;" id="cons_<?php
echo $statusline['id'];
?>
_<?php
echo $statusline['user']['id'];
?>
">
<?php
echo hg_verify($statusline['text']);
?>
<?php
include hg_load_template("statusline_content");
?>
</div>
<div style="display:none;" id="ava_<?php
echo $statusline['id'];
?>
_<?php
echo $statusline['user']['id'];
?>
"><?php
echo $statusline['user']['small_avatar'];
?>
</div>
public function show()
{
$channel_id = $this->input['channel_id'];
if (!$channel_id) {
$this->errorOutput('未传入频道ID');
}
//$cond = ' AND status=1';
$sql = "select * from " . DB_PREFIX . "channel where id=" . $channel_id . $cond;
$channel_info = $this->db->query_first($sql);
if (!$channel_info) {
$this->errorOutput('指定频道不存在或被关闭');
}
$source = array('0' => '网站', '1' => 'Iphone客户端', '2' => 'android客户端');
$sql = "SELECT * FROM " . DB_PREFIX . "topic WHERE " . TIMENOW . " > start_time AND " . TIMENOW . " < end_time AND channel_id=" . $channel_id;
$f = $this->db->query_first($sql);
if (!empty($f)) {
$channel_topic = $f['name'];
} else {
$sql = "SELECT id,theme,start_time FROM " . DB_PREFIX . 'program WHERE channel_id =' . $channel_id . ' ';
$sql .= ' AND start_time + toff >= ' . TIMENOW . ' ORDER BY start_time ASC LIMIT 1';
$program = $this->db->query_first($sql);
$channel_topic = $program['theme'] ? $program['theme'] : $channel_info['name'];
}
$comments = array();
$return = array();
$return['show_topic'] = '关于#' . $channel_topic . '#的讨论';
$return['channel_topic'] = $channel_topic;
$count = intval($this->input['count']);
$count = $count ? $count : 20;
$page = intval($this->input['offset']) / $count;
$this->curl->setSubmitType('post');
$this->curl->setReturnFormat('json');
$this->curl->initPostData();
$this->curl->addRequestData('q', $channel_topic);
$this->curl->addRequestData('page', $page);
$this->curl->addRequestData('order_type', 0);
$this->curl->addRequestData('newest_id', 0);
$this->curl->addRequestData('count', $count);
$comments = $this->curl->request('search.php');
$deal_comments = array();
unset($comments[0]);
$len = strlen('#' . $channel_topic . '#');
if ($comments) {
foreach ($comments as $value) {
if (substr(trim($value['text']), $len - 1, 1) == '#') {
$value['text'] = substr(trim($value['text']), $len);
}
$text = hg_verify($value['text']);
$text_show = '：' . ($value['text'] ? $value['text'] : $this->lang['forward_null']);
if ($value['reply_status_id']) {
$forward_show = '//@' . $value['user']['username'] . ' ' . $text_show;
$title = $this->lang['forward_one'] . $value['retweeted_status']['text'];
} else {
$forward_show = '';
$title = $this->lang['forward_one'] . $value['text'];
}
if ($value['source']) {
$value['source_text'] = '通过' . $source[$value['source']];
} else {
$value['source_text'] = '';
}
$comment = array('id' => $value['id'], 'content' => $title, 'source' => $value['source'], 'author' => $value['user']['username'], 'pubdate' => date('m月d日 H:i', $value['create_at']), 'source_text' => '通过' . $value['source']);
$deal_comments[] = $comment;
}
}
$return['comments'] = $deal_comments;
$this->addItem($return);
$this->output();
}
