Вчем проблема?
| Код |
<?php
$do = $_GET['do'];
mysql_connect("localhost", "root", "") or die(mysql_error());
mysql_select_db("game") or die(mysql_error());
$res = mysql_query("SELECT * FROM logsys WHERE username='$username' AND password='$password'");
if(mysql_num_rows($res) == 0)
{
die("<center><font face=\"Verdana\">We did not find your user details, please go <a href=\"/logsys/login.php\">back</a> and try again.");
}
if($do == "")
{
$villager1 = $r['farmers'];
$villager2 = $r['goldminers'];
$villager3 = $r['lumberjacks'];
$villager4 = $r['stoneminers'];
echo(' <form name=collect_form action=?do==collect method=post>
<h2>Send Worker to collect resources</h2>
<table><tr><td>
Farmers: </td><td><input type=text name=villager1 size=7 value=<?php echo $villager1 ?>>
</td></tr><tr><td>
Gold Miners: </td><td><input type=text name=villager2 size=7 value=<?php echo $villager2 ?>>
</td></tr><tr><td>
lumberjacks: </td><td><input type=text name=villager3 size=7 value=<?php echo $villager3 ?>>
</td></tr><tr><td>
Stone Miners: </td><td><input type=text name=villager4 size=7 value=<?php echo $villager4 ?>>
</td></tr></table><br> <br><center>
<input type=submit name=attack value=Start-Collecting! /></center>
</form>');
}
if($do == "collect")
{
session_start();
$username=$_SESSION['username'];
$password=$_SESSION['password'];
mysql_connect("localhost", "root", "") or die("There was an error connecting to the mysql server.");
mysql_select_db("game");
$res = mysql_query("SELECT * FROM logsys WHERE username='$username' AND password='$password'") or die(mysql_error());
if(mysql_num_rows($res) == 1)
{
while($r=mysql_fetch_assoc($res)){
$villager1_sent = $_POST['villager1'];
$villager2_sent = $_POST['villager2'];
$villager3_sent = $_POST['villager3'];
$villager4_sent = $_POST['villager4'];
$seccessful = TRUE;
$food_cqr = 0.10;
$money_cqr = 0.10;
$wood_cqr = 0.10;
$stone_cqr = 0.10;
}
if($villager1_sent < $villager1 || $villager2_sent > $villager2 || $villager3_sent > $unit3
|| $villager4_sent > $villager4){
echo "Sorry, you have tried to send more villagers than you have.";
}
else{
$new_villager1 = $villager1/.96;
$new_villager2 = $villager2/.96;
$new_villager3 = $villager3/.96;
$new_villager4 = $villager4/.96;
$new_food = $villagers1*$food_cqr;
$new_money = $villagers2*$money_cqr;
$new_wood = $villagers3*$wood_cqr;
$new_stone = $villagers4*$stone_cqr;
$food123=$new_food - $food;
$gold123=$new_money - $money;
$wood123=$new_wood - $wood;
$stone123=$new_stone - $stone;
$message="Your villagers collected some resources!";
echo $message;
}
mysql_query("UPDATE logsys SET `farmer`='new_villager1', `goldminer`='new_villager2', `lumberjacks`='new_villager3', `stoneminers`='new_villager4', `food`= '$new_food', `gold`='$new_money', `wood`='$new_wood', `stone`='$new_stone'
WHERE `username`='$username' AND `password`='$password'") or die(mysql_error());
}
}
?>
|
когда я запускаю код почему-то форма запускается, но когда вводишь количество в форму и нажимаешь на ок ...
страничка появлаеться бланком и никакого Updata ... в-чем причина до-меня не доходит ...
Заранее спасибо! |