ECSHOP中的会员中心2条修改方法(等级价格.vip)

return array('goods' => $row, 'filter' => $filter, 'page_count' => $filter['page_count'], 'record_count' => $filter['record_count']);

foreach($row as $key_tmp=>$goods_tmp)
{
$sql = "SELECT rank_id, IFNULL(mp.user_price, r.discount * $goods_tmp[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_tmp[goods_id]' AND mp.user_rank = r.rank_id " .
"WHERE r.show_price = 1 OR r.rank_id = '$_SESSION[user_rank]'";
$res_up = $GLOBALS['db']->query($sql);
while ($row_up = $GLOBALS['db']->fetchRow($res_up))
{
$row[$key_tmp]['user_price'][$row_up['rank_id']] = array(
'rank_name' => htmlspecialchars($row_up['rank_name']),
'price' => price_format($row_up['price']));
}
}

{if $goods.user_price}
{foreach from=$goods.user_price item=user_price }

{$user_price.rank_name}：{$user_price.price}
{/foreach}
{/if}

$update_data = array_merge($update_data, $other);

$update_data['user_rank']=2; //自动注册成“VIP会员”
$GLOBALS['db']->query("update ".$GLOBALS['ecs']->table('user_rank') . " set special_rank =1 where rank_id=2" );