Code: Select all
<?php
if(isset($_POST['bus'])) {
$sql = "SELECT * from bususerbdlg";
$user_query = mysqli_query($db_conx, $sql);
$numrows = mysqli_num_rows($user_query);
if ($stats_gold < 1000) {
?><div id="error"><?php
echo "<span id='errormess'><big><left><font color='red'>You do not have enough Gold</center></span></big></font>"; ?>
</div>
<meta http-equiv="refresh" content="3;url=cabs.php">
<?php exit;
}
if ($stats_food < 300) {
?><div id="error"><?php
echo "<span id='errormess'><big><left><font color='red'>You do not have enough Food</center></span></big></font>"; ?>
</div>
<meta http-equiv="refresh" content="3;url=cabs.php">
<?php exit;
}
if ($stats_gold >= 1000 || $stats_food >= 300){
$gold1 = ($stats_gold - 1000);
$food1 = ($stats_food - 300);
$update_gold = "UPDATE stats SET gold='$gold1' AND food='$food1' WHERE $id = '$_SESSION[userid]";
$query = mysqli_query($db_conx, $update_gold);
$time = time();
$finish = time() + strtotime($row['times']) + (15 * 1);
$randid = rand(999,9999999);
$bdlgid = 1;
$sql = "UPDATE bususerbdlg SET times1='$currenttime'";
$query = mysqli_query($db_conx, $sql);
$sql = "INSERT INTO bususerbdlg (bdlgid, playerid, times1, finish, randid) VALUES ('$bdlgid','$_SESSION[userid]','$time', '$finish', '$randid')";
$query = mysqli_query($db_conx, $sql);
}}
?>
<?php
$sql = "SELECT * from bususerbdlg";
$user_query = mysqli_query($db_conx, $sql);
$numrows = mysqli_num_rows($user_query);
while ($row = mysqli_fetch_array($user_query, MYSQLI_ASSOC)) {
if ($row['times1'] >= $row['finish']) {
?> <?php
$bus="<img src='images/bus.png'>";
echo " $bus";
}else{
?> <?php
echo buildtimes($row['finish'] - $row['times1']);
}
}
/////////////////////////////////////////END OF PURCHASING A BUS/////////////////////////////////////////////////
