Файл: www/farm/dining.php
Строк: 66
<?php
include '../config.php';
div('Столовая');
$int=intval($_GET['id']);
$fuser=mysql_fetch_array(mysql_query("SELECT * FROM `farm_user` WHERE `uid` = '".$user['id']."' LIMIT 1"));
include 'inc/str.php';
if(isset($_GET['eat_all'])){
mysql_query("DELETE FROM `farm_ambar` WHERE `id_user`= '".$user['id']."'");
$sumd = intval($_SESSION['sum']);
mysql_query("UPDATE `farm_user` SET `xp` = '".($fuser['xp']+$sumd)."' WHERE `uid` = '".$user['id']."' LIMIT 1");
msg('Вы всё съели. Добавлено '.intval($_SESSION['sum']).' здоровья');
unset($_SESSION['sum']);
header("Location: /farm/dining");
exit;}
if(isset($_GET['eat_ok'])){
$semen=mysql_fetch_array(mysql_query("SELECT * FROM `farm_plant` WHERE `id` = '".intval($_SESSION['plid'])."' LIMIT 1"));
msg('Вы успешно съели '.$semen['name'].'. Получено '.intval($_SESSION['xp']).' здоровья');}
if(isset($_GET['id'])){
$check=mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_ambar` WHERE `id` = '".$int."'"), 0);
if($check==0){
header("Location: /farm/dining");
exit();}
$post=mysql_fetch_array(mysql_query("SELECT * FROM `farm_ambar` WHERE `id`= '".intval($_GET['id'])."' LIMIT 1"));
$semen=mysql_fetch_array(mysql_query("SELECT * FROM `farm_plant` WHERE `id` = '".$post['semen']."' LIMIT 1"));
unset($_SESSION['plid']);
$_SESSION['plid'] = $post['semen'];
$xp=$post['kol']*$semen['xp'];
unset($_SESSION['xp']);
$_SESSION['xp'] = $xp;
if(isset($_GET['eat'])){
$xp = intval($_SESSION['xp']);
mysql_query("UPDATE `farm_user` SET `xp` = '".($fuser['xp']+$xp)."' WHERE `uid` = '".$user['id']."' LIMIT 1");
mysql_query("DELETE FROM `farm_ambar` WHERE `id` = ".intval($_GET['id'])." ");
header('Location: /farm/dining?eat_ok');}
//farm_event();
echo '<center><img src="/farm/bush/'.$post['semen'].'.png"></center><br/> <b>'.$semen['name'].'</b><br/>';
echo 'Количество урожая: <b>'.$post['kol'].'</b> <br/>';
echo 'Здоровья за единицу: <b>'.$semen['xp'].'</b> <br/>';
echo 'Всего здоровья: <b>'.$xp.'</b>';
echo '<form action="?id='.$int.'&eat" method="POST">';
echo '<input type="submit" name="save" value="Есть"></form>';
}else{
//farm_event();
$k_post=mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_ambar` WHERE `id_user` = '".$user['id']."'"),0);
if($k_post==0){
echo 'В амбаре товаров нет';}
if($k_post!=0){
$rssum=mysql_query("SELECT * FROM `farm_ambar` WHERE `id_user` = '".$user['id']."'");
$_SESSION['sum']=0;
while($item=mysql_fetch_array($rssum)){
$plsum = mysql_fetch_array(mysql_query("SELECT * FROM `farm_plant` WHERE `id` = '".$item['semen']."' LIMIT 1"));
$plussum = $plsum['xp']*$item['kol'];
$_SESSION['sum'] = $plussum+$_SESSION['sum'];}
echo '<div class="msg1">';
echo '<img src="img/add.png"> <a href="/farm/dining?eat_all">Съесть всё. Добавит '.intval($_SESSION['sum']).' здоровья</a></div>';}
$res = mysql_query("SELECT * FROM `farm_ambar` WHERE `id_user` = '".$user['id']."'");
while($post = mysql_fetch_array($res)){
$n++;
if(is_integer($n/2)){
echo '<div class="msg2">';
}else{
echo '<div class="msg1">';}
$semen=mysql_fetch_array(mysql_query("SELECT * FROM `farm_plant` WHERE `id` = '".$post['semen']."' LIMIT 1"));
echo '<img src="/farm/bush/'.$post['semen'].'.png" height="20" width="20"><b></b> <a href="?id='.$post['id'].'">'.$semen['name'].'</a> ['.$post['kol'].'] ';
echo '(<a href="?id='.$post['id'].'&eat">Есть</a>)</div>';}}
echo '</div>';
include '../foot.php';
echo '</div>';
?>