elseif ($action == 'user_card')
{
if($_POST['bind'])
{
$card_no =trim($_POST['card_no']);
$card_pass =trim($_POST['card_pass']);
if(empty($card_no))
{
show_message("卡号为空");
}
$sql = "select * from " . $ecs->table('user_card') . " where card_no='$card_no' ";
$card_info = $db->getRow($sql);
if($card_info)
{
$user_card_num = $db->getOne("select count(*) from " . $ecs->table('user_card') . " where card_no='$card_no' and user_id='$_SESSION[user_id]' " );
if($user_card_num>=1)
{
show_message("您已绑定过一个会员止，由于一个会员最多绑定一个会员卡，无法绑定其它卡");
}
if($card_info['user_id'] ==$_SESSION['user_id'])
{
show_message("您已绑定了此卡");
}
if(!$card_info['is_show'])
{
show_message("此卡已被禁用");
}
elseif($card_info['user_id'] >0)
{
show_message("此卡已被其它会员绑定");
}
elseif($card_info['card_pass'] ==$card_pass['card_pass'])
{
show_message("卡密错误！");
}
else
{
$db->query("update " . $ecs->table('user_card') . " set user_id='$_SESSION[user_id]', bind_time ='". gmtime() ."', card_status=1 where card_no='$card_no' limit 1 ");
$arr['user_money'] = floatval($card_info['user_money']);
$arr['pay_points'] = $card_info['pay_points'];
$arr['rank_points'] = $card_info['rank_points'];
if($card_info['card_level'])
{
$card_rank = $db->getOne(" select rank_id from " . $ecs->table('user_rank') . " where rank_name='$card_info[card_level]' ");
if($card_rank) $arr['user_rank'] = $card_rank;
$sql = 'UPDATE ' . $ecs->table('users') . " SET `user_rank`='$card_rank' WHERE `user_id`='" . $_SESSION['user_id'] . "'";
$db->query($sql);
}
log_account_change($_SESSION['user_id'], $arr['user_money'], 0, $arr['rank_points'], $arr['pay_points'], '绑定会卡'.$card_no.'充值等级积分:'.$arr['rank_points'].',消费积分'.$arr['pay_points']);
$sql = 'UPDATE ' . $ecs->table('user_card') . " SET `user_money`='0', `pay_points`='0', `rank_points`='0' WHERE `card_no`='" . $card_no . "'";
$db->query($sql);
show_message("绑定成功", '用户信息', 'user.php?act=user_card', 'info');
}
}
else
{
show_message("卡号不存在", '重新绑定', 'user.php?act=user_card', 'info');
}
exit;
}
{
if($_POST['bind'])
{
$card_no =trim($_POST['card_no']);
$card_pass =trim($_POST['card_pass']);
if(empty($card_no))
{
show_message("卡号为空");
}
$sql = "select * from " . $ecs->table('user_card') . " where card_no='$card_no' ";
$card_info = $db->getRow($sql);
if($card_info)
{
$user_card_num = $db->getOne("select count(*) from " . $ecs->table('user_card') . " where card_no='$card_no' and user_id='$_SESSION[user_id]' " );
if($user_card_num>=1)
{
show_message("您已绑定过一个会员止，由于一个会员最多绑定一个会员卡，无法绑定其它卡");
}
if($card_info['user_id'] ==$_SESSION['user_id'])
{
show_message("您已绑定了此卡");
}
if(!$card_info['is_show'])
{
show_message("此卡已被禁用");
}
elseif($card_info['user_id'] >0)
{
show_message("此卡已被其它会员绑定");
}
elseif($card_info['card_pass'] ==$card_pass['card_pass'])
{
show_message("卡密错误！");
}
else
{
$db->query("update " . $ecs->table('user_card') . " set user_id='$_SESSION[user_id]', bind_time ='". gmtime() ."', card_status=1 where card_no='$card_no' limit 1 ");
$arr['user_money'] = floatval($card_info['user_money']);
$arr['pay_points'] = $card_info['pay_points'];
$arr['rank_points'] = $card_info['rank_points'];
if($card_info['card_level'])
{
$card_rank = $db->getOne(" select rank_id from " . $ecs->table('user_rank') . " where rank_name='$card_info[card_level]' ");
if($card_rank) $arr['user_rank'] = $card_rank;
$sql = 'UPDATE ' . $ecs->table('users') . " SET `user_rank`='$card_rank' WHERE `user_id`='" . $_SESSION['user_id'] . "'";
$db->query($sql);
}
log_account_change($_SESSION['user_id'], $arr['user_money'], 0, $arr['rank_points'], $arr['pay_points'], '绑定会卡'.$card_no.'充值等级积分:'.$arr['rank_points'].',消费积分'.$arr['pay_points']);
$sql = 'UPDATE ' . $ecs->table('user_card') . " SET `user_money`='0', `pay_points`='0', `rank_points`='0' WHERE `card_no`='" . $card_no . "'";
$db->query($sql);
show_message("绑定成功", '用户信息', 'user.php?act=user_card', 'info');
}
}
else
{
show_message("卡号不存在", '重新绑定', 'user.php?act=user_card', 'info');
}
exit;
}
