ecshop高级别看低级别价格

//*****查找设定的用户会员等级最大积分

function get_fine_user_rank($user_points,$max_points_level){

       $sql = "sel ect ur.rank_id, ur.rank_name, ur.min_points, ur.max_points from ".$GLOBALS['ecs']->table('user_rank')." as ur where ur.min_points <= '$user_points' and ur.max_points >= '$user_points'";

       $res = $GLOBALS['db']->getAll($sql);

       foreach($res as $row){

              $arr['rank_id'] = $row['rank_id'];

              $arr['rank_name'] = $row['rank_name'];

              $arr['max_points'] = $row['max_points'];

              if($row['max_points'] >= $max_points_level){

                     $arr['max_points_level'] = 1;

              }else{

                     $arr['max_points_level'] = 0;

              }

       }

       return $arr;

}

//*****查找会员用户积分

function get_fine_user_points($user_id){

       $sql = "sel ect u.rank_points from ".$GLOBALS['ecs']->table('users')."  as u where u.user_id = '$user_id'";

       $res = $GLOBALS['db']->getOne($sql);

       return $res;

}

function get_user_rank_prices($goods_id, $shop_price)

{

    $sql = "SELECT rank_id,max_points, INULLmp.user_price, r.discount * $shop_price / 100) AS price, r.rank_name, r.discount " .

            'FROM ' . $GLOBALS['ecs']->table('user_rank') . ' AS r ' .

            'LEFT JOIN ' . $GLOBALS['ecs']->table('member_price') . " AS mp ".

                "ON mp.goods_id = '$goods_id' AND mp.user_rank = r.rank_id " .

            "WHERE r.show_price = 1 OR r.rank_id = '$_SESSION[user_rank]'";

    $res = $GLOBALS['db']->getAll($sql);

       $user_points = get_fine_user_points($_SESSION['user_id']); //

    $arr = array();

    foreach($res as $row)

    {

        $arr[$row['rank_id']]['rank_name'] = htmlspecialchars($row['rank_name']);

              $arr[$row['rank_id']]['max_points'] = $row['max_points'];

              $user_rank = get_fine_user_rank($user_points,$row['max_points']);                

              $arr[$row['rank_id']]['user_rank_maxPoints'] = $user_rank['max_points_level'];    //

        $arr[$row['rank_id']]['price']     = price_format($row['price']);

    }

    return $arr;

}

              if(empty($_SESSION['user_id'])){

                     $userId = 0;

              }else{

                     $userId = 1;

              }

              $smarty->assign('userId',          $userId);   //判断会员是否登录

<!-- {foreach from=$rank_prices item=rank_price key=key} 会员等级对应的价格-->

       {if $rank_price.user_rank_maxPoints eq 1}<strong>{$rank_price.rank_name}：</strong><font class="shop" id="ECS_RANKPRICE_{$key}">{$rank_price.price}</font><br />{/if}

       <!--{/foreach}-->

       {if $userId eq 0}<strong class="shop">登陆才能看到会员优惠价格</strong>{/if}