?? action_basket.php
字號:
<?php
//error_reporting(0);
include_once('../include/global.php');
?>
<?php
if (isset($_POST['account']) && isset($_POST['pasword']) && isset($_POST['usersn'])) {
$au = new DB($db_host, $db_user, $db_pwd, $AU_db, $pconnect);
$itemdb = new DB($db_host, $db_user, $db_pwd, $AUitem_db, $pconnect);
unset($db_host, $db_user, $db_pwd, $AU_db, $AUlogin_db, $AUitem_db, $pconnect);
$account = $_POST['account'];
$pasword = $_POST['pasword'];
$usersn = $_POST['usersn'];
if (!(ValidData($account) && ValidData($pasword))) {
ErrorPurchase("Tên đăng nhập hoặc mật khẩu không đúng !");
} else {
$query ="
SELECT UserSN, UserID, passwd
FROM audition.users
WHERE UserID = '$account'
";
$check = $itemdb->query($query);
$count = $itemdb->num_rows($check);
if ($count != 1) {
ErrorPurchase("Lỗi, xin liên hệ admin");
} else {
$result = $itemdb->fetch_array($check);
if ($account != $result['UserID'] || $pasword != $result['passwd'] || $usersn != $result['UserSN']) {
ErrorPurchase("Sai mật khẩu");
} else {
$query ="
SELECT UserSN, Cash
FROM itemdb.usercash
WHERE UserSN = '$usersn'
";
$check = $itemdb->query($query);
$result = $itemdb->fetch_array($check);
$Cash1 = $result['Cash'];
$query ="
SELECT SUM(al.Cash) Cash
FROM basket uwc
LEFT JOIN avatarlist al
ON al.ItemID = uwc.ItemID
WHERE uwc.UserSN = '$usersn'
GROUP BY uwc.UserSN
ORDER BY basketID
";
$check = $itemdb->query($query);
$result = $itemdb->fetch_array($check);
$Cash2 = $result['Cash'];
if ($Cash1 < $Cash2) {
ErrorPurchase("Không đủ Vcoin. Lượng Vcoin cần thiết là: $Cash2");
}
//
else {
$query ="
SELECT UserSN, Den
FROM itemdb.userden
WHERE UserSN = '$usersn'
";
$check = $itemdb->query($query);
$result = $itemdb->fetch_array($check);
$Den1 = $result['Den'];
$query ="
SELECT SUM(al.Den) Den
FROM basket uwc
LEFT JOIN avatarlist al
ON al.ItemID = uwc.ItemID
WHERE uwc.UserSN = '$usersn'
GROUP BY uwc.UserSN
ORDER BY basketID
";
$check = $itemdb->query($query);
$result = $itemdb->fetch_array($check);
//
$Den2 = $result['Den'];
//
if ($Den1 < $Den2) {
ErrorPurchase("Không đủ Den. Lượng Den cần thiết là: $Den2");
}
//
else {
$Cash = $Cash1 - $Cash2;
$Den = $Den1 - $Den2;
$date = date('Y-m-d H:i:s');
$query ="
SELECT UserSN, UserNick
FROM audition.userinfo
WHERE UserSN = '$usersn'
";
$check = $au->query($query);
$result = $au->fetch_array($check);
//
//
$usernicklist=$result['UserNick'];
$query ="
SELECT uwc.ItemID, al.ItemName , al.Den , al.Cash
FROM basket uwc
LEFT JOIN avatarlist al
ON al.ItemID = uwc.ItemID
WHERE uwc.UserSN = '$usersn'
ORDER BY uwc.BasketID
";
$check = $itemdb->query($query);
$count = $itemdb->num_rows($check);
$index = 0;
while($result = $itemdb->fetch_array($check))
{
$index += 1;
}
while($index > 0)
{
$query ="
SELECT uwc.ItemID, al.ItemName , al.Den , al.Cash
FROM basket uwc
LEFT JOIN avatarlist al
ON al.ItemID = uwc.ItemID
WHERE uwc.UserSN = '$usersn'
ORDER BY uwc.BasketID
";
$check = $itemdb->query($query);
$result = $itemdb->fetch_array($check);
$ItemID = $result['ItemID'];
$query ="
SELECT al.ItemID, uwc.UserSN
FROM basket uwc
LEFT JOIN avatarlist al
ON al.ItemID = uwc.ItemID
WHERE uwc.UserSN = '$usersn'
ORDER BY uwc.BasketID
";
$check = $itemdb->query($query);
$result = $itemdb->fetch_array($check);
//
$query ="
SELECT ItemID, Part
FROM avatarlist
WHERE ItemID = '$ItemID'
";
$check = $itemdb->query($query);
$result = $itemdb->fetch_array($check);
//
if($result['Part']=='f'){
$insertlist = 'avatar_inventory_face';
}
else{}
if($result['Part']=='h'){
$insertlist = 'avatar_inventory_hair';
}
else{}
if($result['Part']=='j'){
$insertlist = 'avatar_inventory_jacket';
}
else{}
if($result['Part']=='p'){
$insertlist = 'avatar_inventory_pants';
}
else{}
if($result['Part']=='s'){
$insertlist = 'avatar_inventory_shoes';
}
else{}
if($result['Part']=='e'){
$insertlist = 'avatar_inventory_items';
}
else{}
if($result['Part']=='h,j,p,s'){
$insertlist = 'avatar_inventory_sets';
}
else{}
if($result['Part']=='h,j'){
$insertlist = 'avatar_inventory_sets';
}
else{}
if($result['Part']=='h,j,p'){
$insertlist = 'avatar_inventory_sets';
}
else{}
if($result['Part']=='j,p'){
$insertlist = 'avatar_inventory_sets';
}
else{}
if($result['Part']=='j,p,s'){
$insertlist = 'avatar_inventory_sets';
}
else{}
if($result['Part']=='p,s'){
$insertlist = 'avatar_inventory_sets';
}
else{}
if($result['Part']=='s,p,j,f,h'){
$insertlist = 'avatar_inventory_pet';
}
else{}
$query ="
INSERT INTO `".$insertlist."`
( `usersn`, `buynick`, `itemid`, `DuplicationCount`, `expiredtype`, `expireddate`)
VALUES ( '".$usersn."', '".$usernicklist."', '".$ItemID."', '0', '1', '2090-01-01 00:00:00')
";
$index = $index -1;
$result = $itemdb->query($query);
$query ="
DELETE
FROM basket
WHERE ItemID = '$ItemID'
";
$result = $itemdb->query($query);
}
$query ="
DELETE
FROM basket
WHERE UserSN = '$usersn'
";
$result = $itemdb->query($query);
$query ="
UPDATE usercash ui
SET ui.cash = '$Cash'
WHERE UserSN = '$usersn'
";
$result = $itemdb->query($query);
$query ="
UPDATE userden ui
SET ui.den = '$Den'
WHERE UserSN = '$usersn'
";
$result = $itemdb->query($query);
$query ="
UPDATE audition.userinfo ui
SET ui.cash = '$Cash'
WHERE UserSN = '$usersn'
";
$result = $au->query($query);
$query ="
UPDATE audition.userinfo ui
SET ui.Money = '$Den'
WHERE UserSN = '$usersn'
";
$result = $au->query($query);
$query ="
SELECT UserSN, UserID, UserNick, Money, Cash
FROM audition.userinfo
WHERE UserSN = '$usersn'
";
$check = $au->query($query);
$result = $au->fetch_array($check);
echo '<div><table border="1" cellspacing="0" cellpadding="1">';
echo '<tr align="center"><td colspan="4"><b>Thông tin nhân vật</b></td></tr>';
echo '<tr align="center"><td><b>Tên nhân vật</b></td><td width="310px" colspan="3"><b>'.$result['UserNick'].'</b></td></tr>';
echo '<tr align="center"><td><b>DEN</b></td><td width="310px" colspan="3"><b>'.$result['Money'].'</b></td></tr>';
echo '<tr align="center"><td><b>Vcoin</b></td><td width="310px" colspan="3"><b>'.$result['Cash'].'</b></td></tr>';
echo '<tr align="center"><td colspan="4"><b>Cám ơn bạn đã ủng hộ cửa hàng chúng tôi</b></td></tr>';
echo '<tr align="center"><td colspan="4"><B>(Đã mua đồ)<B></td></tr>';
echo '<tr align="center"><td colspan="4"><B>(Đã mua đồ)<B></td></tr>';
echo '<tr align="center"><td colspan="4"><B>(Đã mua đồ)<B></td></tr>';
echo '<tr align="center"><td colspan="4"><B>(Đã mua đồ)<B></td></tr>';
echo '<tr align="center"><td colspan="4"><B>(Đã mua đồ)<B></td></tr>';
echo '<tr align="center"><td colspan="4"><B>(Đã mua đồ)<B></td></tr>';
echo '<tr align="center"><td colspan="4"><a href="#" onclick="javascript:window.close()">Thoát nick và đóng Wed</a></td></tr>';
echo '</table></div>';
}
}
}
}
}}
?>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -