/** * 查看帖子 * @param: NULL * @return: NULL * @access: public */ public function run() { //取得帖子的id $topic_id = $this->getParameterFromGET('id'); $topic_id = (int) $topic_id; if (!$topic_id || $topic_id < 1) { $this->AlertAndBack(VT_TOPIC_ID_IS_NOT_VALID); return; } //验证帖子的id是否存在 if (!TopicUtil::isExists($this->db, $topic_id)) { $this->AlertAndBack(VT_TOPIC_ID_IS_NOT_EXISTS); return; } //查询帖子的版块id $layout_id = TopicUtil::getLayoutId($this->db, $topic_id); //验证论坛的版块 if (!LayoutUtil::isExists($this->db, $layout_id)) { $this->AlertAndBack(VT_LAYOUT_IS_NOT_EXISTS); return; } //得出论坛版块的状态 $layout_status = LayoutUtil::getLayoutStatus($this->db, $layout_id); //状态为0则为全部开放 //状态为1则为需要验证 //状态为2则为关闭 //如果为2 if ($layout_status == 2) { $this->AlertAndBack(VT_LAYOUT_IS_CLOSED); return; } else { if ($layout_status == 1) { if (!$_SESSION['user']['name']) { $this->AlertAndBack(VT_LAYOUT_NEED_AUTHOR); return; } } } //取得帖子的状态 $topic_status = TopicUtil::getTopicStatus($this->db, $topic_id); /** * 为0, 则开放 * 为1, 则需要认证 * 为2,则关闭 */ if ($topic_status == 1) { if (!$_SESSION['user']['name']) { $this->AlertAndBack(VT_TOPIC_NEED_AUTHOR); return; } } //增加帖子的浏览次数 TopicUtil::updateViewNumber($this->db, $topic_id); //取得Smarty的对象 $smarty = $this->getSmarty(); //先删除已经不存在的用户 LayoutUtil::delNotExistsUser($this->db); //取得站点的公告,并显示在页面上 $is_have_post = false; $post_str = ''; if (PostUtil::haveNotExpirePost($this->getDB())) { $is_have_post = true; $post_array = PostUtil::getPost($this->getDB(), 3); foreach ($post_array as $post_rows) { $post_str .= '<a href=\'index.php?module=post&action=view&id=' . $post_rows['id'] . '\' title=\'' . $post_rows['title'] . '\'>' . utf8_substr($post_rows['title'], 0, 35) . '</a>' . ' '; } } $smarty->assign('have_system_post', $is_have_post); $smarty->assign('post_str', $post_str); //求帖子的访问的导航菜单 $nav_array = LayoutUtil::getParentLayoutInfo($this->db, $layout_id); //导航栏 $smarty->assign('nav_array', $nav_array); //求帖子的标题 $title = TopicUtil::getTitle($this->db, $topic_id); $smarty->assign('topic_title', $title); $smarty->assign('clone_title', ' -> ' . $title); //取得页面 $page = $this->getParameterFromGET('page'); if (!$page || $page <= 0) { $page = 1; } //求总的页面 $total_page = TopicUtil::getTotalPage($this->db, $topic_id, $this->pre_page); if ($page > $total_page && $total_page > 0) { $page = $total_page; } //帖子的id和版块的id $smarty->assign('topic_id', $topic_id); $smarty->assign('bbs_id', $layout_id); //页面 $smarty->assign('now_page', $page); $smarty->assign('total_page', $total_page); $begin_page = 1; $end_page = $total_page; if ($page <= 10 && $total_page >= 10) { $end_page = 10; } else { if ($page > 10) { if ($page % 10 == 0) { //向前翻 $end_page = $page; $begin_page = $end_page - 9; } else { if ($page % 10 == 1) { //向后翻 //确定开始的页数 $begin_page = $page; if ($begin_page > $total_page) { $begin_page = $page - 9; } if ($begin_page + 9 > $total_page) { $end_page = $total_page; } else { $end_page = $begin_page + 9; } } else { $num = $page % 10; $pre_num = floor($page / 10); $begin_page = $pre_num * 10 + 1; $end_page = $begin_page + 9; } } } } if ($end_page > $total_page) { $end_page = $total_page; } $nav_page_array = array(); for ($i = $begin_page; $i <= $end_page; $i++) { array_push($nav_page_array, $i); } //帖子导航栏 $smarty->assign('nav_page', $nav_page_array); $offset_page = ($page - 1) * $this->pre_page; $topic_array = TopicUtil::getTopicInfo($this->db, $topic_id, $this->pre_page, $offset_page); $smarty->assign('topic', $topic_array); //取得当前用户的身份 $user_name = $_SESSION['user']['name']; $user_id = UserUtil::getUserId($this->db, $user_name); if (strlen($user_name)) { //验证用户的身份 $sql = 'select group_dep from base_user_info where lower(user_name) =?'; $sth = $this->db->prepare($sql); $res = $this->db->Execute($sth, array(strtolower($user_name))); $rows = $res->FetchRow(); $user_group = $rows['group_dep']; if ($user_group == 1 || $user_group == 2) { $smarty->assign('can_be_close', 1); } else { if ($user_group == 3) { $layout_id = TopicUtil::getLayoutId($this->db, $topic_id); $sql = 'select count(*) as num from bbs_layout_manager where user_id=? and ' . ' layout_id=?'; $sth = $this->db->prepare($sql); $res = $this->db->Execute($sth, array($user_id, $layout_id)); $rows = $res->FetchRow(); if (!$rows['num']) { $smarty->assign('can_be_close', 0); } else { $smarty->assign('can_be_close', 1); } } } } else { $smarty->assign('can_be_close', 0); } //加密一个返回的url $backurl = 'index.php?module=bbs&action=viewtopic&id=' . $topic_id . '&page=' . $page; $backurl = base64_encode($backurl); $smarty->assign('backurl', $backurl); $smarty->display('viewtopic.tmpl'); }
/** * 保存新回复 * @param: NULL * @return: NULL * @access: public */ public function run() { //取得主题的id $topic_id = $this->getParameterFromPOST('id'); //验证帖子的是否存在 if (!TopicUtil::isExists($this->db, $topic_id)) { $this->AlertAndBack(TOPIC_IS_NOT_EXISTS); return; } //验证帖子的状态 $status = TopicUtil::getTopicStatus($this->db, $topic_id); //注意状态为3,则为帖子被锁定,不能回复了。 if ($status == 2) { $this->AlertAndBack(TOPIC_HAD_BE_CLOSED); return; } else { if ($status == 3) { $this->AlertAndBack(TOPIC_HAD_BE_LOCK); return; } } //取得版块的id $bbs_id = TopicUtil::getLayoutId($this->db, $topic_id); if (!$bbs_id) { $this->forward('index.php'); } //验证论坛是否存在 if (!LayoutUtil::isExists($this->db, $bbs_id)) { //论坛不存在,则转向首页 $this->forward('index.php'); } //更新用户在本版的信息 LayoutUtil::updateOnlineUser($this->db, $bbs_id); $bbs_status = LayoutUtil::getLayoutStatus($this->db, $bbs_id); if ($bbs_status == 1 && !isset($_SESSION['user'])) { $this->AlertAndForward(SNT_NEED_LOGIN, 'index.php?module=user&action=showlogin'); return; } else { if ($bbs_status == 2) { $this->AlertAndForward(SNT_LAYOUT_WAS_CLOSED, 'index.php'); return; } else { if ($bbs_status == 3) { //等于三不允许发帖 $this->AlertAndBack(SNT_NOW_ALLOW_NEW_TOPIC); return; } else { if (LayoutUtil::isClosedByParent($this->db, $bbs_id)) { $this->AlertAndForward(SNT_LAYOUT_WAS_CLOSED, 'index.php'); return; } } } } //取得各种参数 //帖子的表情 $express = $this->getParameterFromPost('express'); //上传的帖子标题 $title = $this->getParameterFromPost('title'); //上传的内容 $content = $this->getParameterFromPost('content'); //记录在Session里 $_SESSION['temp_title'] = $title; $_SESSION['temp_content'] = $content; $_SESSION['temp_express'] = $express; //看文件是否有文件上传 if ($_FILES['attach']['tmp_name']) { //用户有上传文件 if ($_FILES['attach']['type'] != 'image/gif' && $_FILES['attach']['type'] != 'image/jpeg' && $_FILES['attach']['type'] != 'image/jpg' && $_FILES['attach']['type'] != 'image/pjpeg' && $_FILES['attach']['type'] != 'image/png') { $this->AlertandBack(ST_PHONE_FILE_LIMIT); } //判断上传的文件大小是否合乎要求 if ($_FILES['attach']['size'] > 1048576) { $this->AlertAndBack(ST_PHONE_FILE_SIZE_LIMIT); return; } } //回复标题可以为空 //如果标题为空,则自动生成一个标题 if (!$title || strlen($title) <= 0) { $sql = 'select title from bbs_subject where id=?'; $sth = $this->db->Prepare($sql); $res = $this->db->Execute($sth, array($topic_id)); $rows = $res->FetchRow(); $title = "Re:" . $rows['title']; } /* if ( strlen($title) > 143 ) { $this->AlertAndBack(ST_TITLE_TOO_LONG); return; }*/ if (!$content || strlen($content) <= 0) { $this->AlertAndBack(ST_CONTENT_IS_EMPTY); return; } //插入新回复 $ip_temp = getIp(); $ip = $ip_temp['ip']; $user_name = $_SESSION['user']['name']; $now = time(); $sql = 'insert into bbs_reply ( layout_id, title, author, content, post_ip, ' . 'post_date, express, subject_id ) values (?, ?, ?, ?, ?, ?, ?, ?) '; $sth = $this->{'db'}->Prepare($sql); $this->{'db'}->Execute($sth, array($bbs_id, $title, $user_name, $content, $ip, $now, $express, $topic_id)); if ($this->{'db'}->ErrorNo()) { $this->AlertAndBack($this->{'db'}->ErrorMsg()); return; } //得到最后的id $insert_id = $this->{'db'}->Insert_id(); if ($_FILES['attach']['tmp_name']) { //取得文件的大小 list($image_width, $image_height, $image_type, $image_attr) = getimagesize($_FILES['attach']['tmp_name']); //判断文件的类型 switch ($image_type) { case 1: $image_left_type = '.gif'; break; case 2: $image_left_type = '.jpg'; break; case 3: $image_left_type = '.png'; break; } //存储的文件名 $file_name = ROOT_PATH . 'upload/attach/reply/' . $insert_id . $image_left_type; if (!move_uploaded_file($_FILES['attach']['tmp_name'], $file_name)) { $sql = 'delete from bbs_reply where id=?'; $sth = $this->{'db'}->Prepare($sql); $this->{'db'}->Execute($sth, array($insert_id)); $this->AlertAndBack(ST_UPLOAD_ERROR); return; } else { $sql = 'insert into bbs_reply_attach (reply_id, file_type) ' . ' values (?, ?)'; $sth = $this->{'db'}->Prepare($sql); $this->{'db'}->Execute($sth, array($insert_id, $image_left_type)); } } unset($_SESSION['temp_title']); unset($_SESSION['temp_content']); unset($_SESSION['temp_express']); //发送短信,通知各个用户有回复了你的帖子 //发送邮件,通知各个用户有回复了你的帖子 $mail_user = array(); $message_user = array(); $sql = 'select a.author, b.user_email, b.id from bbs_subject a join ' . ' base_user_info b on a.author = b.user_name ' . ' join user_setting c on b.id=c.user_id where a.id=? and c.user_whether_receive_email=1'; $sth = $this->db->Prepare($sql); $res = $this->db->Execute($sth, array($topic_id)); $rows = $res->FetchRow(); if ($rows['id']) { $mail_user[] = $rows['user_email']; } $sql = 'select distinct a.author, b.user_email, b.id from bbs_reply a join base_user_info b ' . ' on a.author = b.user_name join user_setting c on b.id=c.user_id ' . ' where a.subject_id=? and c.user_whether_receive_email=1'; $sth = $this->db->Prepare($sql); $res = $this->db->Execute($sth, array($topic_id)); while ($rows = $res->FetchRow()) { if ($rows['id']) { $mail_user[] = $rows['user_email']; } } $mail_user = array_unique($mail_user); //计算发送短信的用户数组 $sql = 'select a.author, b.id from bbs_subject a join ' . ' base_user_info b on a.author = b.user_name ' . ' join user_setting c on b.id=c.user_id where a.id=? and c.receive_system_message=1'; $sth = $this->db->Prepare($sql); $res = $this->db->Execute($sth, array($topic_id)); $rows = $res->FetchRow(); if ($rows['id']) { $message_user[] = $rows['id']; } $sql = 'select distinct a.author, b.id from bbs_reply a join base_user_info b ' . ' on a.author = b.user_name join user_setting c on b.id=c.user_id ' . ' where a.subject_id=? and c.receive_system_message=1'; $sth = $this->db->Prepare($sql); $res = $this->db->Execute($sth, array($topic_id)); while ($rows = $res->FetchRow()) { if ($rows['id']) { $message_user[] = $rows['id']; } } $message_user = array_unique($message_user); //开始发送邮件 $to_address = implode(',', $mail_user); $mail_content = ST_MAIL_CONTENT . "\n\n"; $mail_content .= ROOT_URL . 'index.php?module=bbs&action=viewtopic&id=' . $topic_id . "\n\n"; $headers = "To:" . $to_address . "\r\n"; $headers .= "From:" . WEBSITE_EMAIL . "\r\n"; //发送邮件: @mail($to_address, ST_MAIL_SUBJECT, $mail_content, $headers); //发送短消息 //发件人 $sender = '0'; $message_content = ST_MESSAGE_CONTENT . "\n"; $now = getNoFormateCurrentDate(); $message_content .= "[url=" . 'index.php?module=bbs&action=viewtopic&id=' . $topic_id . "][color=red]" . ST_CLICK_HERE . "[/color]" . "[/url]"; $sql = 'insert into message_inbox ( user_id, send_user_id, title, receive_time, content ) ' . ' values ( ?, ?, ?, ?, ?) '; $sth = $this->db->Prepare($sql); foreach ($message_user as $user) { $this->db->Execute($sth, array($user, $sender, ST_MAIL_SUBJECT, $now, $message_content)); } $now = time(); //更新主题的最后更新时间 $update_sql = 'update bbs_subject set last_access_date=?,reply_number=reply_number+1 where id=?'; $sth = $this->db->Prepare($update_sql); $this->db->Execute($sth, array($now, $topic_id)); //求这个回帖的位置所在的位置 $sort_number = TopicUtil::getSortNumber($this->db, $topic_id, $insert_id); $page = ceil($sort_number / $this->pre_page); //这里还有很多的工作需要做 $this->TipsAndForward(ST_SAVE_REPLY_SUCCESS, 'index.php?module=bbs&action=viewtopic&id=' . $topic_id . '&page=' . $page . '#topic' . $sort_number); }
/** * 运行本类 * @param: NULL * @return: NULL * @access: public */ public function run() { /*{{{*/ $smarty = $this->getSmarty(); $smarty->assign('clone_title', CREATE_NEW_REPLY); //取得主题的id $topic_id = $this->getParameterFromGET('id'); //验证帖子的是否存在 if (!TopicUtil::isExists($this->db, $topic_id)) { $this->AlertAndBack(TOPIC_IS_NOT_EXISTS); return; } //验证帖子的状态 $status = TopicUtil::getTopicStatus($this->db, $topic_id); //注意状态为3,则为帖子被锁定,不能回复了。 if ($status == 2) { $this->AlertAndBack(TOPIC_HAD_BE_CLOSED); return; } else { if ($status == 3) { $this->AlertAndBack(TOPIC_HAD_BE_LOCK); return; } } //取得该帖子所在的版块 $layout_id = TopicUtil::getLayoutId($this->db, $topic_id); if (!LayoutUtil::isExists($this->db, $layout_id)) { //论坛不存在,则转向首页 $this->forward('index.php'); } //更新用户在本版的信息 LayoutUtil::updateOnlineUser($this->db, $layout_id); $bbs_status = LayoutUtil::getLayoutStatus($this->db, $layout_id); if ($bbs_status == 1 && !isset($_SESSION['user'])) { $this->AlertAndForward(SRY_NEED_LOGIN, 'index.php?module=user&action=showlogin'); return; } else { if ($bbs_status == 2) { $this->AlertAndForward(SRY_LAYOUT_WAS_CLOSED, 'index.php'); return; } else { if ($bbs_status == 3) { //等于三不允许发帖 $this->AlertAndBack(SRY_NOW_ALLOW_NEW_TOPIC); return; } else { if (LayoutUtil::isClosedByParent($this->db, $bbs_id)) { $this->AlertAndForward(SRY_LAYOUT_WAS_CLOSED, 'index.php'); return; } } } } //返回论坛上面的导行栏。 $nav_array = LayoutUtil::getParentLayoutInfo($this->db, $layout_id); //导航栏 $smarty->assign('nav_array', $nav_array); //先删除已经不存在的用户 LayoutUtil::delNotExistsUser($this->db); //从Session里读出数据 $temp_title = $_SESSION['temp_title']; if (strlen($temp_title) <= 0) { $smarty->assign('temp_title', $temp_title); } //看看是否是引用 $quote = $this->getParameterFromGET('quote'); $reply_id = $this->getParameterFromGET('replyid'); $temp_content = $_SESSION['temp_content']; $fck = new FCKeditor("content"); $fck->BasePath = FCKEDITOR_BASEPATH; if ($temp_content) { if (get_magic_quotes_gpc()) { $fck->Value = stripslashes($temp_content); } else { $fck->Value = $temp_content; } } else { if ($quote == 1) { if ($reply_id == 0) { $sql = 'select content from bbs_subject where id=?'; $sth = $this->db->Prepare($sql); $res = $this->db->Execute($sth, array($topic_id)); $rows = $res->FetchRow(); if (get_magic_quotes_gpc()) { $temp_content1 = stripslashes($rows['content']); } else { $temp_content1 = $rows['content']; } $fck->Value = '[quote]' . $temp_content1 . '[/quote]'; } else { $sql = 'select content from bbs_reply where id=?'; $sth = $this->db->Prepare($sql); $res = $this->db->Execute($sth, array($reply_id)); $rows = $res->FetchRow(); if (get_magic_quotes_gpc()) { $temp_content1 = stripslashes($rows['content']); } else { $temp_content1 = $rows['content']; } $fck->Value = '[quote]' . $temp_content1 . '[/quote]'; } } } $smarty->assign('fck', $fck); $temp_express = $_SESSION['temp_express']; $smarty->assign('temp_express', $temp_express); $smarty->assign('is_new_topic', 0); $smarty->assign('is_new_reply', 1); $smarty->assign('bbsid', $topic_id); $smarty->display('topic.tmpl'); }