View file farm/farm/dining.php

<?
include_once '../sys/inc/start.php';
include_once '../sys/inc/compress.php';
include_once '../sys/inc/sess.php';
include_once '../sys/inc/home.php';
include_once '../sys/inc/settings.php';
include_once '../sys/inc/db_connect.php';
include_once '../sys/inc/ipua.php';
include_once '../sys/inc/fnc.php';
include_once '../sys/inc/user.php';
only_reg();
$set['title']='Весёлая ферма :: Столовая';
include_once '../sys/inc/thead.php';
title();
aut();

$int=intval($_GET['id']);

$fuser=mysql_fetch_array(mysql_query("SELECT * FROM `farm_user` WHERE `uid` = '".$user['id']."' LIMIT 1"));

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");
add_farm_event('Вы всё съели. Добавлено '.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"));

add_farm_event('Вы успешно съели '.$semen['name'].'. Получено '.intval($_SESSION['xp']).' здоровья');

}

aut();

include 'inc/str.php';

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 "<div class='rowdown'><center><img src='/farm/bush/".$post['semen'].".png' alt=''></center><br/> <b>".$semen['name']."</b><br/>";
echo "&raquo; Количество урожая: <b>".$post['kol']."</b> <br/>";
echo "&raquo; Здоровья за единицу: <b>".$semen['xp']."</b> <br/>";

echo "&raquo; Всего здоровья: <b>".$xp."</b></div>";

echo "<form method='post' action='?id=".$int."&amp;eat'>\n";
echo "<input type='submit' name='save' value='Есть' />\n";
echo "</form>\n";

echo "<div class='rowup'>";
echo "<img src='/img/back.png' alt='' class='rpg' /> <a href='/farm/dining'>Столовая</a>";
echo "</div>";

}
else
{

farm_event();

$k_post=mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_ambar` WHERE `id_user` = '".$user['id']."'"),0);
$k_page=k_page($k_post,$set['p_str']);
$page=page($k_page);
$start=$set['p_str']*$page-$set['p_str'];


if ($k_post==0)
{
echo "<div class='err'>В амбаре товаров нет</div>";
}

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='rowdown'>";
echo "<img src='/img/add.png' alt='' class='rpg' /> <a href='/farm/dining?eat_all'>Съесть всё. Добавит ".intval($_SESSION['sum'])." здоровья</a></div>";
}


$res = mysql_query("SELECT * FROM `farm_ambar` WHERE `id_user` = '".$user['id']."' LIMIT $start, $set[p_str];"); 

while ($post = mysql_fetch_array($res)){
if ($num==1)
{
echo "<div class='rowdown'>";
$num=0;
}
else
{
echo "<div class='rowup'>";
$num=1;
}

$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']."&amp;eat'>Есть</a>)</div>";
}


if ($k_page>1)str('?',$k_page,$page); // Вывод страниц
}
echo "<div class='rowdown'>";
echo "<img src='/farm/img/garden.png' /> <a href='/farm/garden/'>Назад</a><br/>";
echo "</div>";

include_once '../sys/inc/tfoot.php';
?>