echo $building[$field[0]];
}
}
}
}
}
?>
</td>
<?php
}
?>
<td>
<?php
/* Check whether the building can be build or not */
$building['build'] = 0;
if ($user['level'] >= $building['lvl_needed'] && $user['wood'] >= calcBuildCosts($building)['wood'] && $user['iron'] >= calcBuildCosts($building)['iron'] && $user['clay'] >= calcBuildCosts($building)['clay'] && $user['max_villagers'] - $user['villagers_in_use'] >= calcBuildCosts($building)['villagers']) {
// All conditions seem right, so add the Build/Upgrade button!
// Check if building could be upgraded or not
$query = "SELECT * FROM `current_buildings` WHERE `user` = {$_SESSION['user_id']} AND `building` = {$building['ID']}";
$resultb = mysqli_query($connection, $query);
// Is building in current_building list/table?
if (mysqli_num_rows($resultb) > 0) {
// Yes, it could be upgraded
$resultb = mysqli_fetch_row($resultb);
// Save next level in the variable
$building['build'] = $resultb[3] + 1;
} else {
// No, it must be build first
// This variable contains 1 -> level of the new building
$building['build'] = 1;
}
<?php
require_once "reference/reference.php";
// Check if these form items were submitted (if not, they won't exist)
if ((isset($_POST['build']) || isset($_POST['upgrade'])) && isset($_POST['building_id'])) {
$building_id = $_POST['building_id'];
// Get building parameters
$query = "SELECT * FROM `buildings` WHERE `ID` = {$building_id}";
$result = mysqli_query(getConnection(), $query);
$building = mysqli_fetch_array($result);
// Calculate new resources
$newWoodAmount = $user['wood'] * 1 - calcBuildCosts($building)['wood'];
$newIronAmount = $user['iron'] * 1 - calcBuildCosts($building)['iron'];
$newClayAmount = $user['clay'] * 1 - calcBuildCosts($building)['clay'];
$newVillagersInUseAmount = $user['villagers_in_use'] * 1 + calcBuildCosts($building)['villagers'];
echo "wood: " . var_dump($newWoodAmount);
echo "iron: " . var_dump($newIronAmount);
echo "clay: " . var_dump($newIronAmount);
echo "villagers: " . var_dump($newVillagersInUseAmount);
// Save new values
$querywood = "UPDATE `users` SET `previous_wood` = {$newWoodAmount} WHERE `ID` = {$_SESSION['user_id']}";
$resultwood = mysqli_query(getConnection(), $querywood);
$queryiron = "UPDATE `users` SET `previous_iron` = {$newIronAmount} WHERE `ID` = {$_SESSION['user_id']}";
$resultiron = mysqli_query(getConnection(), $queryiron);
$queryclay = "UPDATE `users` SET `previous_clay` = {$newClayAmount} WHERE `ID` = {$_SESSION['user_id']}";
$resultclay = mysqli_query(getConnection(), $queryclay);
$queryvillagers = "UPDATE `users` SET `villagers` = {$newVillagersInUseAmount} WHERE `ID` = {$_SESSION['user_id']}";
$resultvillagers = mysqli_query(getConnection(), $queryvillagers);
if ($resultwood && $resultiron && $resultclay && $resultvillagers) {
$resultcosts = true;
} else {
