ok i am very very new but my problem is this my code executes with no errors, however nothings happens my database remains unchanged. I’m sure this is something simple like flow control yet I do not understand php flow control yet so any help at all would be appreciated. I will post my working script as well as my non working script so you can see where I was and where I am trying to go.
Working script:
[php]<?php
include “connect.php”;
session_start();
if (isset($_SESSION[‘player’]))
{
$player=$_SESSION[‘player’];
$userstats1=“SELECT * from liberty_users where username=’$player’”;
$userstats2=mysql_query($userstats1) or die(“Could not get user stats”);
$userstats=mysql_fetch_array($userstats2);
$numturns=$userstats[numturns];
$job_id=$userstats[job];
$jobstats1=“SELECT * from jobs where id=(’$job_id’)”;
// $jobstats1=“SELECT * from jobs where id=1”;
$jobstats2=mysql_query($jobstats1) or die(“Dead on job stats”);
$jobstats=mysql_fetch_array($jobstats2);
// print “
Sorry, $player you do not have a job click here to find one.
”;// }
if ($job_id<=0)
{
print “
Sorry, $player you do not have a job click here to find one.
”;exit;
}
if ($numturns<=149)
{
print “
Sorry, $player you do not have enough turns to work! You need at least 150 turns to work.
”;
print “
[Home][Work]
”;//$URL=“index.php”;
//header (“Location: $URL”);
}
else if ($numturns>=150)
{
$wages=$jobstats[salary];
$skillup=$jobstats[skill_up];
//debug
print "$job_id<br>";
print "<h1><center>Welcome! $player you have $userstats[numturns] turns left.</center></h1>";
print "<h2><center>[<a href='index.php'>Home</a>][<a href='work.php'>Work</a>]<br/></center></h2>";
print "<p><center>You are currently employied by $jobstats[company] <br></center></p>";
print "<p><left>Company description:<br>$jobstats[desc]<br></p>";
print "<p><left><table border=1><tr><td>Work Skill</td><td>Wages</td><td>Skill up</td><td>Gold</tr><tr><td>$userstats[work_skill]</td><td>$wages</td><td>$jobstats[skill_up]</td><td>$userstats[gold]</td><br></p></table>";
// print "<p><left><table><tr></tr><tr><td>
//$query1 = mysql_query("UPDATE liberty_users SET numturns = (numturns - '150') SET gold=(gold+$wages) SET work_skill=(work_skill+$skill_up)") WHERE id=$userstats[id]") or die(mysql_error());
$updateplayerstats="Update liberty_users set numturns=numturns-'150', gold=gold+'$wages', work_skill=work_skill+'$skillup' where username='$player'";
mysql_query($updateplayerstats) or die("Could not update player stats");
//$sql="INSERT INTO liberty_users (numturns) values (numturns-150)";
//$result = mysql_query($sql) or die ("it just died");
// $updaterefresh="update liberty_users set numturns=numturns-150 where ID='$playerstats[ID]'";
// mysql_query($updaterefresh) or die("It just died");
// $getturns="Update liberty_users set numturns=numturns-150";
// $numturns=mysql_query($userstats[numturns] or die("Could not get turns");
}
}
{
//print "<h1><center>Welcome! $player you have $userstats[numturns] turns left</center></h1>";
//print "<h2><center>[<a href='index.php'>Home</a>][<a href='work.php'>Work</a>]</center></h2>";
}
?>[/php]
Non working script: <please help me fix it :(>
[php]<?php
include “connect.php”;
session_start();
if (isset($_SESSION[‘player’]))
{
$player=$_SESSION[‘player’];
$userstats1=“SELECT * from liberty_users where username=’$player’”;
$userstats2=mysql_query($userstats1) or die(“Could not get user stats”);
$userstats=mysql_fetch_array($userstats2);
$numturns=$userstats[numturns];
$job_id=$userstats[job];
$jobstats1=“SELECT * from jobs where id=(’$job_id’)”;
$jobstats2=mysql_query($jobstats1) or die(“Dead on job stats”);
$jobstats=mysql_fetch_array($jobstats2);
$wages=$jobstats[salary];
$skillup=$jobstats[skill_up];
$randomevents=rand(0,30);
$multiplier=($wages*$hours);
$skillmultiplier=($skillup*$hours);
$selectrandomevent=rand(1,6);
$randomeventbonus1=5;
$randomeventbonus2=5;
$randomeventbonus3=4;
$randomeventbonus4=3;
$randomeventbonus5=3;
$randomeventbonus6=10;
if ($job_id<=0)
{
print "<h1><center>Sorry, $player you do not have a job click <a href='classifieds.php'>here</a> to find one.</center></h1>";
exit;
}
print "<h1><center>Welcome! $player you have $userstats[numturns] turns left.</center></h1>";
print "<h2><center>[<a href='index.php'>Home</a>][<a href='work.php'>Work</a>]<br/></center></h2>";
print "<p><center>You are currently employied by $jobstats[company] <br></center></p>";
print "<p><left>Company description:<br>$jobstats[desc]<br></p>";
print "<p><left><table border=1><tr><td>Work Skill</td><td>Wages</td><td>Skill up</td><td>Gold</tr><tr><td>$userstats[work_skill]</td>
<td>$wages</td><td>$jobstats[skill_up]</td><td>$userstats[gold]</td><center></p></table>";
// print "How many hours do you wish to work? ";
?>
| How many hours do you wish to work? | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 |
Welcome! $player you have $userstats[numturns] turns left.
"; // print "[Home][Work]
";
// print "You are currently employied by $jobstats[company]
Company description:
$jobstats[desc]
| Work Skill | Wages | Skill up | Gold |
| $userstats[work_skill] | $wages | $jobstats[skill_up] | $userstats[gold] |
| //$query1 = mysql_query("UPDATE liberty_users SET numturns = (numturns - '150') SET gold=(gold+$wages) SET work_skill=(work_skill+$skill_up)") WHERE id=$userstats[id]") or die(mysql_error()); //$sql="INSERT INTO liberty_users (numturns) values (numturns-150)"; //$result = mysql_query($sql) or die ("it just died"); // $updaterefresh="update liberty_users set numturns=numturns-150 where ID='$playerstats[ID]'"; // mysql_query($updaterefresh) or die("It just died"); // $getturns="Update liberty_users set numturns=numturns-150"; // $numturns=mysql_query($userstats[numturns] or die("Could not get turns"); } { // code to be executed; } // moving to function if (isset($_POST['submit'])) { $hours=($_POST['hours']); work(); } } ?>[/php] |