page load

Danny620 · August 12, 2009

i am programming a game and what it does is if someone clicks upgrade it gets there current level then the time it will require to upgrade and adds it to the time now. see that all works fine but when i click upgrade it submints all the times and stuff but i must press it again to get anthor message saying building in progress. and also when i revisit the page after when it should be complete i just get building in progress but it should realy have refreshed the code and show a new message it only shows the message after i press a blank buttion to refresh the code. how can i get it to keep checking everytime the page is acessed via web bar or refresh buttion.

heres all my code

<?php require('mysqli_connect.php'); 
  require('buildinginprogress.php');
  require('buildtime.php');
?>
<?php
echo "<pre>";
echo "POST:";
print_r($_POST);
echo "</pre>";
?>
<body>
<form id="form1" name="form1" method="post" action="">
<table width="681" border="1">
    <tr>
      <td width="96"><div align="center">Building</div></td>
      <td width="56"><div align="center">Level</div></td>
      <td width="80"><div align="center">Time</div></td>
      <td width="107"><div align="center">Cost</div></td>
      <td width="308"><div align="center">Upgrade</div></td>
    </tr>
    <tr>
      <td><div align="center">HQ</div></td>
      <td><div align="center"></div></td>
      <td><div align="center"></div></td>
      <td><div align="center"></div></td>
      <td><label>
        <div align="left">
          <input type="radio" name="radio" id="hq" value="hq" />
          hq </div>
        </label></td>
    </tr>
    <tr>
      <td><div align="center">WAREFARE</div></td>
      <td><div align="center"></div></td>
      <td><div align="center"></div></td>
      <td><div align="center"></div></td>
      <td><label>
      
        <div align="left">
          <input type="radio" name="radio" id="warfare" value="warfare" />      
        warfare</div>
      </label></td>
    </tr>
    <tr>
      <td><div align="center">TG</div></td>
      <td><div align="center"></div></td>
      <td><div align="center"></div></td>
      <td><div align="center"></div></td>
      <td><label>
        
        <div align="left">
          <input type="radio" name="radio" id="testing ground" value="testing ground" />
          testing ground</div>
      </label></td>
    </tr>
    <tr>
      <td><div align="center"></div></td>
      <td><div align="center"></div></td>
      <td><div align="center"></div></td>
      <td><div align="center"></div></td>
      <td><div align="left"></div></td>
    </tr>
    <tr>
      <td><div align="center"></div></td>
      <td><div align="center"></div></td>
      <td><div align="center"></div></td>
      <td><div align="center"></div></td>
      <td><div align="left"></div></td>
    </tr>
    <tr>
      <td><div align="center"></div></td>
      <td><div align="center"></div></td>
      <td><div align="center"></div></td>
      <td><div align="center"></div></td>
      <td><div align="left">
        <label></label>
        <label>
        <input type="submit" name="upgrade" id="upgrade" value="upgrade">
        </label>
        <label>        </label>
      </div></td>
    </tr>
  </table>
</form>
</body>
</html>

<?php 
$userid = 1;
//Check to see if any buildings are in progress
$q = "SELECT progress, complete, building FROM `construction` WHERE user_id = $userid & progress = 1";		
$r = mysqli_query ($dbc, $q) or trigger_error("Query: $q\n<br />MySQL Error: " . mysqli_error($dbc));
$progress = mysqli_fetch_array ($r, MYSQLI_ASSOC);
$check = $progress['complete']; 
$buildinpro = $progress['building'];
//Settings
$buildingpro = '0';

if($progress['progress'] == 1){
$date = date("Y-m-d H:i:s");
echo "yes building in progress";
if($date >= $check){

$q = "SELECT level FROM `buildings` WHERE user_id = $userid & building = '$buildinpro'";		
$r = mysqli_query ($dbc, $q) or trigger_error("Query: $q\n<br />MySQL Error: " . mysqli_error($dbc));
$buildlevel = mysqli_fetch_array ($r, MYSQLI_ASSOC);
$levelupgrade = $buildlevel['level'];

$q = "UPDATE construction SET progress = 0 WHERE user_id = $userid & progress = 1 LIMIT 1";
		$r = @mysqli_query ($dbc, $q);

	$upgraded = ++$levelupgrade;

//	$addpoints = $pointsnow + $points;

		$q = "UPDATE buildings SET level = '$upgraded', points = '$addpoints' WHERE user_id = $userid & building = '$buildinpro' 		LIMIT 1";
		$r = @mysqli_query ($dbc, $q);

}else{

$msg = 1;

}
}else{
echo "no in progress";
}
?>

<?php
//settings

// Query the database:
	$q = "SELECT level, points FROM `buildings` WHERE user_id = $userid & building = 'hq'";		
	$r = mysqli_query ($dbc, $q) or trigger_error("Query: $q\n<br />MySQL Error: " . mysqli_error($dbc));
 $nowhqlevel = mysqli_fetch_array ($r, MYSQLI_ASSOC);
//End of Hq level

$hqlevel = $nowhqlevel['level']; echo '<br />' . $hqlevel;
$pointsnow = $nowhqlevel['points']; echo '<br />' . $pointsnow;

//Get HQ Buildtime.

// Query the database:
	$q = "SELECT time, points FROM `hq` WHERE level = $hqlevel";		
	$r = mysqli_query ($dbc, $q) or trigger_error("Query: $q\n<br />MySQL Error: " . mysqli_error($dbc));
 $nowbuildtime = mysqli_fetch_array ($r, MYSQLI_ASSOC);
//End HQ Buildtime.
$points = $nowbuildtime['points']; echo '<br />' . $points;
   $buildtime = $nowbuildtime['time']; echo '<br />' . $buildtime;
   $builddate = date("Y-m-d H:i:s", time() + (60 * $buildtime)); echo '<br />' . $builddate;

//testing
require('recheck.php');

//Upgrade to the next level.
if(isset($_POST['radio'])){

if($passed){
$newre = $item - $costitem;
$newrex = $item_x - $costitem_x;
$newrey = $item_y - $costitem_y;
echo $newre; echo $newrex; echo $newrey;
// Query the database:
$q = "UPDATE construction SET complete = '$builddate', progress = 1 WHERE user_id = $userid LIMIT 1";
		$r = @mysqli_query ($dbc, $q);
} else {
echo "buidling no allowed";
}
}
   
?>

Sign In

page load

Recommended Posts

Danny620

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information