⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 action_basket.php

📁 source web for audition offline 3.26
💻 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&#234;n &#273;&#259;ng nh&#7853;p ho&#7863;c m&#7853;t kh&#7849;u kh&#244;ng &#273;&#250;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&#7895;i, xin li&#234;n h&#7879; admin");
		} else {
			$result = $itemdb->fetch_array($check);
			if ($account != $result['UserID'] || $pasword != $result['passwd'] || $usersn != $result['UserSN']) {
				ErrorPurchase("Sai m&#7853;t kh&#7849;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&#244;ng &#273;&#7911; Vcoin. L&#432;&#7907;ng Vcoin c&#7847;n thi&#7871;t l&#224;: $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&#244;ng &#273;&#7911; Den. L&#432;&#7907;ng Den c&#7847;n thi&#7871;t l&#224;: $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&#244;ng tin nh&#226;n v&#7853;t</b></td></tr>';
					echo '<tr align="center"><td><b>T&#234;n nh&#226;n v&#7853;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&#225;m &#417;n b&#7841;n &#273;&#227; &#7911;ng h&#7897; c&#7917;a h&#224;ng ch&#250;ng t&#244;i</b></td></tr>';
                                        echo '<tr align="center"><td colspan="4"><B>(&#272;&#227; mua &#273;&#7891;)<B></td></tr>';
                                        echo '<tr align="center"><td colspan="4"><B>(&#272;&#227; mua &#273;&#7891;)<B></td></tr>';
                                        echo '<tr align="center"><td colspan="4"><B>(&#272;&#227; mua &#273;&#7891;)<B></td></tr>';
                                        echo '<tr align="center"><td colspan="4"><B>(&#272;&#227; mua &#273;&#7891;)<B></td></tr>';
                                        echo '<tr align="center"><td colspan="4"><B>(&#272;&#227; mua &#273;&#7891;)<B></td></tr>';
                                        echo '<tr align="center"><td colspan="4"><B>(&#272;&#227; mua &#273;&#7891;)<B></td></tr>';
					
					
					echo '<tr align="center"><td colspan="4"><a href="#" onclick="javascript:window.close()">Tho&#225;t nick v&#224; &#273;&#243;ng Wed</a></td></tr>';
					echo '</table></div>';
				}
			}
		}
	}
}}
?>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -