function feedback() { header("Content-type: application/xml"); $pattern = '/^xe360/i'; $content = trim(EClassApi::getParam('content')); $comment_id = (int) Url::get('comment_id', 0); $sender_user_name = trim(EClassApi::getParam('user_name')); $sender_email = trim(EClassApi::getParam('sender_email')); $subItemId = (int) Url::get('sub_item_id', 0); $comment_row = array(); // if(isset($_COOKIE['setTimeOutComment'])){ // if(time()-$_COOKIE['setTimeOutComment']<=30){// 30 giay // echo "<comments><content>time_out</content></comments>"; // exit(); // } // } // else{ // EClassApi::my_setcookie("setTimeOutComment", time(), 30 + TIME_NOW); // 30 giay // } if (preg_match($pattern, $sender_user_name) || preg_match($pattern, $sender_email) || preg_match($pattern, $content)) { echo "<comments><content>bad_word</content></comments>"; exit; } if (User::is_login() && User::is_block()) { echo "<comments><content>no_perm</content></comments>"; exit; } if ($comment_id) { $comment_row = DB::select('comment', "id={$comment_id}"); if (!$comment_row) { echo "<comments><content>no_perm</content></comments>"; exit; } if (User::is_login() && $comment_row['sender_user_id'] == User::id()) { //Không được trả lời cho chính mình! echo "<comments><content>no_perm</content></comments>"; exit; } if (!($item = Item::get_item($comment_row['item_id']))) { echo "<comments><content>no_perm</content></comments>"; exit; } } else { $item_id = (int) Url::get('item_id', 0); if (!$item_id || !($item = Item::get_item($item_id))) { echo "<comments><content>no_perm</content></comments>"; exit; } } $item_memcache = $item; if (EClassApi::isBlackList(User::id(), $item['user_id'])) { echo "<comments><content>blacklist</content></comments>"; exit; } if (!User::is_login() && EClassApi::checkBadWord($sender_user_name)) { echo "<comments><content>bad_word</content></comments>"; exit; } if ($item["state"] == 1 && !User::have_permit(ADMIN_ITEM)) { echo "<comments><content>no_perm</content></comments>"; exit; } $username = strtolower($sender_user_name); if (!User::is_login() && (strlen($username) < 3 || strlen($sender_email) < 3 || $username == 'admin' || $username == 'administrator' || $username == 'moderator' || $username == 'enbac')) { echo "<comments><content>bad_word</content></comments>"; exit; } if (EClassApi::checkBadWord($content)) { echo "<comments><content>bad_word</content></comments>"; exit; } /*if(!User::is_login()){ $captcha = EClassApi::getParam('captcha'); if(!isset($_SESSION["enbac_validate"]) || $captcha=='' || $captcha != $_SESSION["enbac_validate"]){ echo "<comments><content>false_captcha</content></comments>"; exit(); } }*/ $content = preg_replace("/\n/", "<br />", $content); $content = str_replace('<br /><br />', ' ', $content); $receiver_user_id = 0; $receiver_username = ''; if ($comment_id) { if ($comment_row['parent_id']) { $receiver_user_id = $comment_row['sender_user_id']; $receiver_username = $comment_row['sender_user_name']; if ($receiver_user_id) { $content = '@<a href="' . WEB_DIR . $receiver_username . '" class="fast_reply_link" title="' . $receiver_username . '">' . $receiver_username . '</a>: ' . $content; } else { $content = '<font color="#999">@<span style="text-decoration:underline">' . $receiver_username . '</span> </font>: ' . $content; } $parent_id = $comment_row['parent_id']; } else { $parent_id = $comment_row['id']; } } else { $parent_id = 0; } $user_item = User::getUser($item['user_id']); if ($user_item) { $user_type = 0; if (User::is_login()) { $sender_user_name = User::user_name(); $user_id = User::id(); $user_send = User::getUser($user_id); if (!$user_send['avatar_url']) { /*gen 1 cai avatar cho nguoiwf dungf nayf*/ // EClassApi::genAvatar('40',md5($sender_user_name)); } /* #note-comment 11.02 by ngannv Nên bỏ cái query này đi rà xoát lại cơ chế liên quan đến trường user_type trong bảng comment */ $sql = "SELECT sms_total FROM sms_user_active WHERE user_id = {$user_id}"; $user_active = DB::fetch($sql); if ($user_active) { $sms_total = $user_active['sms_total']; if ($sms_total >= 3) { $user_type = 2; } else { $user_type = 1; } } else { $user_type = 1; } } else { // set guest cookie $week = 60 * 60 * 24 * 365 + TIME_NOW; EClassApi::my_setcookie("guest_name", $sender_user_name, $week); EClassApi::my_setcookie("guest_email", $sender_email, $week); /*Tạo một avatar cho khách*/ //EClassApi::genAvatar('40',md5($sender_user_name)); } $up_up_count = ''; if ($content != '') { $comment = array('content' => $content, 'item_id' => $item['id'], 'time' => TIME_NOW, 'order_time' => TIME_NOW, 'post_ip' => EClassApi::ip(), 'parent_id' => $parent_id, 'receiver_user_id' => $item['user_id'], 'receiver_user_name' => $item['user_name'], 'display' => 1, 'sub_item_id' => $subItemId, 'user_type' => $user_type); if (User::id()) { if ($item['user_id'] == User::id()) { //Chuyển trạng thái đã trả lời khi comment chính topic của mình! $comment['status'] = 1; } $comment['sender_user_id'] = User::id(); $comment['sender_user_name'] = User::user_name(); } else { $comment['sender_user_id'] = 0; $comment['sender_user_name'] = $sender_user_name; $comment['sender_email'] = $sender_email; } if ($comment_row && $comment_row['sender_user_id'] && $comment_row['sender_user_id'] != $item['user_id']) { $comment['replied_user_id'] = $comment_row['sender_user_id']; $comment['replied_user_name'] = $comment_row['sender_user_name']; } elseif ($comment_row && $comment_row['sender_user_id'] == $item['user_id']) { $comment['replied_status'] = 1; } $id = DB::insert('comment', $comment); if ($id) { /* if(!User::id()){ EClassApi::reload_captcha(); }*/ /*Cập nhật tăng thêm số lượt comment trong bảng item_sub*/ if ($subItemId > 0) { $updItemSubTbl = "UPDATE item_sub SET comment_count=comment_count+1 WHERE id={$subItemId} LIMIT 1"; DB::query($updItemSubTbl); } if ($parent_id) { $re = DB::query("SELECT id FROM comment WHERE item_id = {$item['id']} AND parent_id = {$parent_id} AND display = 1 ORDER BY id DESC LIMIT 3,1"); if ($re) { if ($row = mysql_fetch_assoc($re)) { if ($row) { DB::query("UPDATE comment SET display = 0 WHERE parent_id = {$parent_id} AND display = 1 AND id<={$row['id']}"); } } } if ($comment_id == $parent_id) { if (User::is_login() && $item['user_id'] == User::id()) { DB::query("UPDATE comment SET have_child = have_child + 1, order_time = " . time() . ", status=1 WHERE id = {$parent_id}"); } else { DB::query("UPDATE comment SET have_child = have_child + 1, order_time = " . time() . " WHERE id = {$parent_id}"); } } else { DB::query("UPDATE comment SET have_child = have_child + 1, order_time = " . time() . " WHERE id = {$parent_id}"); if (User::is_login() && $item['user_id'] == User::id()) { DB::query("UPDATE comment SET status=1 WHERE id = {$comment_id}"); //Cập nhật đã đọc - trả lời cho feed DB::query("UPDATE feed SET status = 1 WHERE ref_id = {$comment_id} AND type=1"); } } if (User::is_login()) { //Nếu là thành viên //Cập nhật lại replied_status nếu chưa được check! if ($item['user_id'] != User::id() && $comment_row['replied_user_id'] == User::id() && $comment_row['replied_status'] == 0) { DB::query("UPDATE comment SET replied_status=1 WHERE id = {$comment_id}"); //Cập nhật đã đọc - trả lời cho feed DB::query("UPDATE feed SET status = 1 WHERE ref_id = {$comment_id} AND type=2"); //Cập nhật comment mới cho chính mình DB::query('UPDATE account SET total_new_comment = total_new_comment - 1 WHERE id=' . User::id() . ' AND total_new_comment>0'); User::getUser(User::id(), 0, 1); } if ($item['user_id'] != User::id()) { //Nếu ko fải giao dịch của mình //Cập nhật comment mới cho chủ topic DB::query('UPDATE account SET total_new_comment = total_new_comment + 1 WHERE id=' . $item['user_id']); User::getUser($item['user_id'], 0, 1); } elseif ($comment_row && $comment_row['status'] == 0) { //Cập nhật comment mới cho chính mình DB::query('UPDATE account SET total_new_comment = total_new_comment - 1 WHERE id=' . User::id() . ' AND total_new_comment>0'); User::getUser(User::id(), 0, 1); } //Cập nhật comment mới cho người có comment được trả lời if ($comment_row['sender_user_id'] && $comment_row['sender_user_id'] != $item['user_id'] && $comment_row['sender_user_id'] != User::id() && $comment_row['sender_user_id'] != $item['user_id']) { //Nếu trả lời comment cho 1 người nào đó ko fải chủ topic DB::query('UPDATE account SET total_new_comment = total_new_comment + 1 WHERE id=' . $comment_row['sender_user_id']); User::getUser($comment_row['sender_user_id'], 0, 1); } } else { //Nếu là khách vãng lai //Cập nhật comment mới cho chủ topic DB::query('UPDATE account SET total_new_comment = total_new_comment + 1 WHERE id=' . $item['user_id']); User::getUser($item['user_id'], 0, 1); //Cập nhật comment mới cho người có comment được trả lời if ($comment_row['sender_user_id'] && $comment_row['sender_user_id'] != $item['user_id'] && $comment_row['sender_user_id'] != $item['user_id']) { //Nếu trả lời comment cho 1 người nào đó ko fải chủ topic DB::query('UPDATE account SET total_new_comment = total_new_comment + 1 WHERE id=' . $comment_row['sender_user_id']); User::getUser($comment_row['sender_user_id'], 0, 1); } } } EClassApi::update_cache_comment($item['id']); } $total_feedback = DB::count('comment', "item_id={$item['id']} AND sub_item_id=0"); /*vãi #note-comment 01 by ngannv*/ $up_up_count = '<up_count>'; $up_up_count .= $user_item['up_item']; if (!$subItemId) { DB::update_id('item', array('reply_count' => $total_feedback), $item['id']); } if (MEMCACHE_ON) { $item_memcache['reply_count'] = $total_feedback; eb_memcache::do_put("item:{$item['id']}", $item_memcache); } $up_up_count .= '</up_count>'; //Cập nhật cron job if ($user_item && $user_item['email'] && $user_item['email_alert'] && $user_item['id'] != User::id()) { if (User::id()) { $sender_email = ''; } $link = WEB_ROOT . ECRewrite::formatUrl('?page=item_detail&id=' . $item['id'] . '&ebname=' . EClassApi::safe_title($item['name'])); $title = "<a href='{$link}' target='_blank' style='text-decoration:none;color:#003399;'><font color='#003399'>{$item['name']}</font></a>"; EClassApi::addCronJob('item_comment', EClassApi::parseBBCode($content, true), $user_item['id'], User::id() ? User::user_name() : $sender_user_name, $sender_email, $item['id'], $title, $link); } } else { $id = 0; } $time = date('H:i - d/m'); $xml = "<comments><content><![CDATA[" . EClassApi::parseBBCode($content) . "]]></content><post_time>" . date('H:i') . "</post_time>"; /* * longnt * thêm trả lại id comment mới insert */ $xml .= "<insert_id>{$id}</insert_id>"; $action = 'item_comment'; if (User::id() != $item['user_id']) { require_once ROOT_PATH . 'includes/enbac/comment.php'; Comment::addNewComment($item['user_id']); } $xml .= $up_up_count . "<id>" . $id % 3 . "</id></comments>"; //del cache html if ($subItemId) { $caheFile = 'fb_' . $subItemId; if (MEMCACHE_ON) { eb_memcache::do_put('update_comment_sub_' . $item['id'] . '_' . $subItemId, 1); /*ngannv #update_comment_sub tìm thêm trong ajax_item_detai.ajax*/ } } else { $caheFile = 'fb_' . $item['id']; } StaticCache::delCache($caheFile); echo $xml; System::halt(); } }
function user_comment_reply() { $c_user_id = (int) Url::get('c_user_id', 0); $content = trim(EClassApi::getParam('content')); $json = ""; if (!User::is_login()) { $json = '({"msg":"no_login"})'; echo $json; exit; } if (User::is_block()) { $json = '({"msg":"no_perm"})'; echo $json; exit; } if ($c_user_id) { $comment_user = DB::select('comment_user', "id={$c_user_id}"); if ($comment_user && $comment_user['receiver_user_id'] == User::id() && $comment_user['sender_user_id'] != User::id()) { if ($content) { $json = '({"msg":"success"'; if (EClassApi::checkBadWord($content)) { $json = '({"msg":"bad_word"})'; echo $json; exit; } $user = User::getUser($comment_user['sender_user_id']); if ($user) { $id = DB::insert('comment_user', array('content' => $content, 'time' => TIME_NOW, 'post_ip' => EClassApi::ip(), 'sender_user_id' => User::id(), 'sender_user_name' => User::user_name(), 'receiver_user_id' => $user['id'], 'receiver_user_name' => $user['user_name'], 'is_read' => 0, 'status' => 0)); if ($id) { DB::query('UPDATE account set total_comment_user=total_comment_user+1 WHERE id=' . $user['id']); // so luu but User::getUser($user['id'], 0, 1); if ($user['email'] && $user['email_alert'] && $user['id'] != User::id()) { $link = WEB_ROOT . '?page=shop&user_name=' . $user['user_name'] . '&mode=comment'; $link = ECRewrite::formatUrl($link); EClassApi::addCronJob('user_comment', EClassApi::parseBBCode($content, true), $user['id'], User::user_name(), '', 0, '', $link); } } } if ($comment_user['status'] == 0) { DB::query("UPDATE comment_user SET status=1, is_read=1 WHERE id={$c_user_id}"); //Cập nhật đã đọc - trả lời cho feed DB::query("UPDATE feed SET status = 1 WHERE ref_id = {$c_user_id} AND type=1"); } $json .= "})"; echo $json; exit; } elseif (Url::get('act') == 'reply' && $content == '') { $json = '({"msg":"short_content"})'; echo $json; exit; } } } $json = "({'msg':'no_perm'})"; echo $json; exit; }