-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathbuy.php
82 lines (74 loc) · 3.28 KB
/
buy.php
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
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
<?php
#debug data of session data
include('session.php');
echo "fetch2 " . $fetch2['session'] . "<br>";
echo "session2 " . $session2 . "<br>" ;
echo "session3 " . $session3 . "<br>" ;
$diff=$session3-$fetch2['session'];
echo "Diffrence " . $diff . "<br>" ;
echo "query2 " . $query2 . "<br>";
?>
<html>
<head>
<title>Welcome to Buy Ships</title>
</head>
<body>
<h1>Welcome <?php echo $login_session; ?></h1>
<!-- Import Links -->
<h2><a href="welcome.php">Welcome link</a></h2>
<h2><a href="build.php">Build link</a></h2>
<h2><a href="logout.php">Sign Out</a></h2>
<?php
#list all resources
$resources = "SELECT metal, fuel, money , diamond FROM Base, Account
WHERE Account.name='$user_check' and Account.base=Base.base";
$resources2=$con->query($resources);
while($resources3 = $resources2->fetch_assoc()) {
echo "Your Current resources: Metal <B>" . $resources3["metal"] . "</B> Fuel <B>" . $resources3["fuel"] .
"</B> Diamond <B>" . $resources3["diamond"] . "</B> Money <B>" . $resources3["money"] . "</B><br>" ;
}
#close current connection
$resources2->close();
?>
<h2>Ships that you can buy</h2>
<?php
#list all ships that user can buy
$buy_avaible = "Select name_id, firepower, shield, hull, prize_metal, prize_fuel, prize_diamond,prize_cash, Base.fleet
from Ship, Base, Account
where Account.base=Base.base and Base.money>=Ship.prize_cash and Account.name='$user_check' && Base.base='$Base_data' && Base.fleet='$Fleet_data'";
#make query
$buy_avaible2=$con->query($buy_avaible);
#make check what fleet user have
#$buy_avaible_fleet = "select tzcrew.Accoount.name,Fleet.fleet FROM Account,Base,Fleet WHERE Account.name='$user_check' && Account.base=Base.base && Base.fleet=Fleet.fleet LIMIT 1;";
echo "<table border=1><tr><td>Avaible Ships: </td><td>Firepower</td><td>Shield</td><td>Hull</td>
<td>Metal</td><td>Fuel</td><td>Diamond</td><td>Prize</td>\t";
$i=0;
while($buy_avaible3 = $buy_avaible2->fetch_row()) {
echo "<tr><td>
<form action ='buy_update.php' method = 'POST'>"
. $buy_avaible3[0] . "</td><td>" . $buy_avaible3[1] . "</td><td>" . $buy_avaible3[2] . "</td><td>"
. $buy_avaible3[3] . "</td><td>" . $buy_avaible3[4] . "</td><td>" . $buy_avaible3[5] . "</td><td>"
. $buy_avaible3[6] . "</td><td>" . $buy_avaible3[7] . "</td><td>
<input type='hidden' name='ship_prize' value='$buy_avaible3[7]'>
<input type='hidden' name='ship_fleet' value='$buy_avaible3[8]'>
<input type='submit' name='buy_ship' value='$buy_avaible3[0]'></form></td></tr>";
$i++;
}
//if($_SERVER["REQUEST_METHOD"] == "POST") {
//$buy_avaible3sql=$i;
#Tarkita mihin fleet kuuluu login_user
//$query_buy= "INSERT INTO tzcrew.Fleet (`id`, `fleet`, `ship`, `damage`) VALUES ('', $fetch_buy, $buy_avaible3[0], '0') where Account.base=Base.base and Base.fleet=Fleet.fleet and Account.name='$user_check'";
//$query_buy= "INSERT INTO Fleet(fleet, ship, damage) VALUES ('fleet1', '$buy_avaible3sql', '0') ";
//$query_takecash=
#make query
//$result_buy=$con->query($query_buy);
//$fetch_buy = mysqli_fetch_assoc($result_buy);
//$name_buy = $fetch_buy["fleet"];
//echo "<font color=green> $result_buy " ,$result_buy , "</font><font color=red> $query_buy " , $query_buy , "</font><br>";
//}
echo "</tr></table>";
//close current connection
$buy_avaible2->close();
?>
</body>
</html>