membercomfun.php
1.62 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
<?php
//--------------- 會員相關處理函數 ---------------
//點卡沖值
function CardGetFen($username,$reusername,$card_no,$password){
global $empire,$dbtbpre;
$card_no=RepPostVar($card_no);
$password=RepPostVar($password);
$username=RepPostVar($username);
if(!trim($username)||!trim($card_no)||!trim($password))
{
printerror("EmptyGetCard","history.go(-1)",1);
}
if($username!=$reusername)
{
printerror("DifCardUsername","history.go(-1)",1);
}
$user=$empire->fetch1("select ".eReturnSelectMemberF('userid,userdate,username')." from ".eReturnMemberTable()." where ".egetmf('username')."='$username' limit 1");
if(!$user['userid'])
{
printerror("ExiestCardUsername","history.go(-1)",1);
}
$num=$empire->gettotal("select count(*) as total from {$dbtbpre}enewscard where card_no='".$card_no."' and password='".$password."' limit 1");
if(!$num)
{
printerror("CardPassError","history.go(-1)",1);
}
//是否過期
$buytime=date("Y-m-d H:i:s");
$r=$empire->fetch1("select cardfen,money,endtime,carddate,cdgroupid,cdzgroupid from {$dbtbpre}enewscard where card_no='$card_no' limit 1");
if($r[endtime]<>"0000-00-00")
{
$endtime=to_date($r[endtime]);
if($endtime<time())
{
printerror("CardOutDate","history.go(-1)",1);
}
}
//充值
eAddFenToUser($r[cardfen],$r[carddate],$r[cdgroupid],$r[cdzgroupid],$user);
$sql1=$empire->query("delete from {$dbtbpre}enewscard where card_no='$card_no'");//刪除卡號
//備份購買記錄
BakBuy($user['userid'],$username,$card_no,$r[cardfen],$r[money],$r[carddate],0);
printerror("CardGetFenSuccess","../member/card/",1);
}
?>