当前位置：首页 → 问答吧 → ecshop前台显示用户等级的实现

ecshop前台显示用户等级的实现

时间：2007-07-13

来源：互联网

受 pandagao 关于烧包网会员等级显示启发今天实现了前台模板会员等级显示的修改

1.修改程序文件

a) /includes/lib_clips.php 文件中搜索如下代码大概在第526行

$sql = "SELECT pay_points, user_money, last_time FROM " .$GLOBALS['ecs']->table('users'). " WHERE user_id = '$user_id'";
$row = $GLOBALS['db']->getRow($sql);

将以上代码修改为

复制PHP内容到剪贴板

PHP代码:

$sql = "SELECT a.pay_points, a.rank_points, a.user_money, a.last_time, a.user_rank,b.prefix FROM " .$GLOBALS['ecs']->table('users'). " as a,ecs_user_getmethod as b WHERE a.method_id = b.method_id AND user_id = '$user_id'";
$row = $GLOBALS['db']->getRow($sql);

修改后在下面紧接着插入

复制PHP内容到剪贴板

PHP代码:

if($row['user_rank']=='0') {
  $sql2 = "SELECT b.rank_name as userrank FROM ". $GLOBALS['ecs']->table('users') ." as a,".$GLOBALS['ecs']->table('user_rank')." as b WHERE a.rank_points > b.min_points AND a.rank_points < b.max_points AND a.user_id = '$user_id'"; }
else {
  $user_rank = $row['user_rank'];
  $sql2 = "SELECT b.rank_name as userrank FROM ". $GLOBALS['ecs']->table('users') ." as a,".$GLOBALS['ecs']->table('user_rank')." as b WHERE a.user_rank = b.rank_id AND a.user_id = '$user_id'";
}
$row2 = $GLOBALS['db']->getRow($sql2);

然后在
$info = array();
$info['username'] = $_SESSION['user_name'];
$info['shop_name'] = $GLOBALS['_CFG']['shop_name'];
$info['integral'] = $row['pay_points'] . $GLOBALS['_CFG']['integral_name'];
下面插入

复制PHP内容到剪贴板