/** * 查询评论内容 * * @access public * @params integer $id * @params integer $type * @params integer $page * @return array */ function assign_comment($id, $type, $page = 1) { /* 取得评论列表 */ $count = $GLOBALS['db']->getOne('SELECT COUNT(*) FROM ' . $GLOBALS['ecs']->table('comment') . " WHERE id_value = '{$id}' AND comment_type = '{$type}' AND status = 1 AND parent_id = 0"); $size = !empty($GLOBALS['_CFG']['comments_number']) ? $GLOBALS['_CFG']['comments_number'] : 5; $page_count = $count > 0 ? intval(ceil($count / $size)) : 1; $sql = 'SELECT * FROM ' . $GLOBALS['ecs']->table('comment') . " WHERE id_value = '{$id}' AND comment_type = '{$type}' AND status = 1 AND parent_id = 0" . ' ORDER BY comment_id DESC'; $res = $GLOBALS['db']->selectLimit($sql, $size, ($page - 1) * $size); $arr = array(); $ids = ''; while ($row = $GLOBALS['db']->fetchRow($res)) { $ids .= $ids ? ",{$row['comment_id']}" : $row['comment_id']; $arr[$row['comment_id']]['id'] = $row['comment_id']; $arr[$row['comment_id']]['email'] = $row['email']; $arr[$row['comment_id']]['username'] = $row['user_name']; $arr[$row['comment_id']]['content'] = str_replace('\\r\\n', '<br />', htmlspecialchars($row['content'])); $arr[$row['comment_id']]['content'] = nl2br(str_replace('\\n', '<br />', $arr[$row['comment_id']]['content'])); $arr[$row['comment_id']]['rank'] = $row['comment_rank']; $arr[$row['comment_id']]['rank_w'] = $row['comment_rank'] * 20; $arr[$row['comment_id']]['add_time'] = local_date($GLOBALS['_CFG']['time_format'], $row['add_time']); } /* 取得已有回复的评论 */ if ($ids) { $sql = 'SELECT * FROM ' . $GLOBALS['ecs']->table('comment') . " WHERE parent_id IN( {$ids} )"; $res = $GLOBALS['db']->query($sql); while ($row = $GLOBALS['db']->fetch_array($res)) { $arr[$row['parent_id']]['re_content'] = nl2br(str_replace('\\n', '<br />', htmlspecialchars($row['content']))); $arr[$row['parent_id']]['re_add_time'] = local_date($GLOBALS['_CFG']['time_format'], $row['add_time']); $arr[$row['parent_id']]['re_email'] = $row['email']; $arr[$row['parent_id']]['re_username'] = $row['user_name']; } } /* 分页样式 */ //$pager['styleid'] = isset($GLOBALS['_CFG']['page_style'])? intval($GLOBALS['_CFG']['page_style']) : 0; $pager['page'] = $page; $pager['size'] = $size; $pager['record_count'] = $count; $pager['page_count'] = $page_count; $pager['page_first'] = "javascript:gotoPage(1,{$id},{$type})"; $pager['page_prev'] = $page > 1 ? "javascript:gotoPage(" . ($page - 1) . ",{$id},{$type})" : 'javascript:;'; $pager['page_next'] = $page < $page_count ? 'javascript:gotoPage(' . ($page + 1) . ",{$id},{$type})" : 'javascript:;'; $pager['page_last'] = $page < $page_count ? 'javascript:gotoPage(' . $page_count . ",{$id},{$type})" : 'javascript:;'; $comment_percent = comment_percent($id); //获取评分 $cmt = array('comments' => $arr, 'pager' => $pager, 'comment_percent' => $comment_percent); return $cmt; }
/*------------------------------------------------------ */ //-- PROCESSOR /*------------------------------------------------------ */ //$cache_id = $goods_id . '-' . $_SESSION['user_rank'].'-'.$_CFG['lang']; //$cache_id = sprintf('%X', crc32($cache_id)); if (!$smarty->is_cached('goods.dwt', $cache_id)) { $smarty->assign('image_width', $_CFG['image_width']); $smarty->assign('image_height', $_CFG['image_height']); $smarty->assign('helps', get_shop_help()); // 网店帮助 $smarty->assign('id', $goods_id); $smarty->assign('type', 0); $smarty->assign('cfg', $_CFG); $smarty->assign('promotion', get_promotion_info($goods_id)); //促销信息 $smarty->assign('comment_percent', comment_percent($goods_id)); //获取评分 $smarty->assign('promotion_info', get_promotion_info()); $goods = get_goods_info($goods_id); //获得商品的信息 $bidrecord = get_goods_bid($goods_id); //获得投标记录 //$repayrecord = get_goods_repay($goods_id); //获得还款记录 /* 获取所属大类的名称 */ /*$sql = 'select a.cat_name from'.$ecs->table("category").' as a,'.$ecs->table("category").' as b where a.cat_id = b.parent_id and b.cat_id='.$goods["cat_id"]; $goods_row = $db->getRow($sql); $goods_row_catname = $goods_row['cat_name'];*/ if ($goods === false) { /* 如果没有找到任何记录则跳回到首页 */ ecs_header("Location: ./\n"); exit;
/** * 调用评论信息 * * @access public * @return string */ function insert_comments($arr) { $need_cache = $GLOBALS['smarty']->caching; $need_compile = $GLOBALS['smarty']->force_compile; $GLOBALS['smarty']->caching = false; $GLOBALS['smarty']->force_compile = true; /* 验证码相关设置 */ if (intval($GLOBALS['_CFG']['captcha']) & CAPTCHA_COMMENT && gd_version() > 0) { $GLOBALS['smarty']->assign('enabled_captcha', 1); $GLOBALS['smarty']->assign('rand', mt_rand()); } $GLOBALS['smarty']->assign('username', stripslashes($_SESSION['user_name'])); $GLOBALS['smarty']->assign('email', $_SESSION['email']); $GLOBALS['smarty']->assign('comment_type', $arr['type']); $GLOBALS['smarty']->assign('id', $arr['id']); $cmt = assign_comment($arr['id'], $arr['type']); $GLOBALS['smarty']->assign('comments', $cmt['comments']); $GLOBALS['smarty']->assign('pager', $cmt['pager']); $comment_percent = comment_percent($arr['id']); $GLOBALS['smarty']->assign('comment_percent', $comment_percent); $val = $GLOBALS['smarty']->fetch('library/comments_list.lbi'); $GLOBALS['smarty']->caching = $need_cache; $GLOBALS['smarty']->force_compile = $need_compile; return $val; }