Файл: www/farm/ambar.php
Строк: 54
<?php
include '../config.php';
$int=intval($_GET['id']);
div('Склад');
include 'inc/str.php';
$fuser=mysql_fetch_array(mysql_query("SELECT * FROM `farm_user` WHERE `uid` = '".$user['id']."' LIMIT 1"));
if(isset($_GET['sell_all'])){
mysql_query("DELETE FROM `farm_ambar` WHERE `id_user`= '".$user['id']."'");
$sumd = intval($_SESSION['sum']);
mysql_query("UPDATE `farm_user` SET `gold` = '".($fuser['gold']+$sumd)."' WHERE `uid` = '".$user['id']."' LIMIT 1");
msg('Весь урожай продан за '.intval($_SESSION['sum']).' золота');
unset($_SESSION['sum']);
header("Location: /farm/ambar");
exit;}
if(isset($_GET['sell_ok'])){
$semen=mysql_fetch_array(mysql_query("select * from `farm_plant` WHERE `id` = '".intval($_SESSION['plid'])."' LIMIT 1"));
msg('Урожай растения '.$semen['name'].' продан. Получено '.intval($_SESSION['dohod']).' золота.');}
if(isset($_GET['id'])){
$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'];
$dohod=$post['kol']*$semen['dohod'];
unset($_SESSION['dohod']);
$_SESSION['dohod'] = $dohod;
if(isset($_GET['sell'])){
$dohod = intval($_SESSION['dohod']);
mysql_query("UPDATE `farm_user` SET `gold` = '".($fuser['gold']+$dohod)."' WHERE `uid` = '".$user['id']."' LIMIT 1");
mysql_query("DELETE FROM `farm_ambar` WHERE `id` = ".intval($_GET['id'])." ");
header('Location: /farm/ambar?sell_ok');}
//farm_event();
echo '<img src="/farm/bush/'.$post['semen'].'.png"><br/> <b>'.$semen['name'].'</b><br/>';
echo 'Количество урожая: <b>'.$post['kol'].'</b> <br/>';
echo 'Цена за единицу: <b>'.$semen['dohod'].'</b> <br/>';
echo 'Общий доход: <b>'.$dohod.'</b> <br/>';
echo '<form action="?id='.$int.'&sell" 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['dohod']*$item['kol'];
$_SESSION['sum'] = $plussum+$_SESSION['sum'];}
echo '<img src="img/add.png"> <a href="/farm/ambar?sell_all">Продать всё за '.intval($_SESSION['sum']).' золота</a>';}
$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'].'&sell">Продать</a>)</div>';}}
echo '</div>';
include '../foot.php';
echo '</div>';
?>