-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathupdate_prize.php
69 lines (64 loc) · 2.68 KB
/
update_prize.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
<html>
<head><title>Asemble Base</title></head>
<body>
<?php
include('session.php');
#include ('sql_log.php');
#$con = new mysqli($servername, $username, $password, $dbname);
if ($con->connect_errno) {
echo "Failed to connect to MySQL: (" . $con->connect_errno . ") " . $con->connect_error;
}
echo $con->host_info . "\n";
echo "<br>";
$sql = "SELECT id, name_id, firepower, shield, hull, shield_rege, hull_rege, prize_metal, prize_fuel, prize_diamond, prize_cash FROM tzcrew.Ship ORDER BY prize_cash DESC, prize_metal , prize_fuel";
$result = $con->query($sql);
$row_cnt = $result->num_rows;
echo "Rows " . $row_cnt;
echo "<table border=1>";
if ($result->num_rows > 0) {
// output data of each row
echo "<tr><td>id: " . "</td><td>Name: " . "</td><td>Firepower: " . "</td><td>Shield: " . "</td>
<td>Hull: " . "</td><td>Shield Regeneration: " . "</td><td>Hull Regeneration: " . "</td>
<td>Prize metal : " . "</td><td>Prize fuel: " . "</td><td>Prize Diamond: " . "</td>
<td>Prize Cash: " . "</td></tr>";
while($row = $result->fetch_assoc()) {
echo "<tr><td>" . $row["id"]. "</td><td>" . $row["name_id"]. "</td><td>" . $row["firepower"].
"</td><td>" . $row["shield"]. "</td><td>" . $row["hull"]. "</td><td>" . $row["shield_rege"].
"</td><td>" . $row["hull_rege"]. "</td><td>" . $row["prize_metal"].
"</td><td>" . $row["prize_fuel"]."</td><td>" . $row["prize_diamond"].
"</td><td>" . $row["prize_cash"]. "</td></tr>";
//Make Variables from row data
$id=$row["id"];
$hull=$row["hull"];
$firepower=$row["firepower"];
$shield=$row["shield"];
$shield_rege=$row["shield_rege"];
$hull_rege=$row["hull_rege"];
$prize_diamond=$row["prize_diamond"];
$prize_cash=$row["prize_cash"];
$prize_fuel=$hull/2 *$hull_rege + $firepower + $shield * $shield_rege;
$prize_metal=$hull * $hull_rege + $firepower/2 + $shield/2 * $shield_rege;
$prize_diamond=($hull * $shield) * (($hull_rege +$shield_rege)/2) + $firepower;
$prize_cash=($hull * $hull_rege + $firepower + $shield * $shield_rege) * $prize_diamond;
/*
Print all stats and update them calc cost
echo "<br> prize_metal ", $prize_metal, " prize_fuel ", $prize_fuel," hull ", $hull," firepower ", $firepower," shield ", $shield ,
" id ", $id, "<br>";
*/
$sql2 = "UPDATE tzcrew.Ship SET prize_fuel='$prize_fuel' WHERE id=$id";
$sql3 = "UPDATE tzcrew.Ship SET prize_metal='$prize_metal' WHERE id=$id";
$sql4 = "UPDATE tzcrew.Ship SET prize_diamond='$prize_diamond' WHERE id=$id";
$sql5 = "UPDATE tzcrew.Ship SET prize_cash='$prize_cash' WHERE id=$id";
$con->query($sql2);
$con->query($sql3);
$con->query($sql4);
$con->query($sql5);
}
} else {
echo "Ship 0 results";
}
echo "</table><br>";
mysqli_close($con);
?>
</body>
</html>