Файл: vfermu.ru/sys/other/warehouse.php
Строк: 458
<?php
error_reporting(E_ALL);
ini_set('display_errors',false);
$ot_money=$system['sun_money_ot'];
$do_money=$system['sun_money_do'];
$ot_opyt=$system['sun_opyt_ot'];
$do_opyt=$system['sun_opyt_do'];
$ot_ruby=$system['sun_ruby_ot'];
$do_ruby=$system['sun_ruby_do'];
echo "<title>Амбар</title>";
echo "<div class='block'>";
$collections=mysql_fetch_array(mysql_query("SELECT * FROM `farm_collections` WHERE `id_user` = '$ku[id]'"));
if(isset($_GET['box']) && intval($_GET['box'])!=NULL && mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_box` WHERE `id` = '".intval($_GET['box'])."' AND `id_user` = '$ku[id]' and `key` = '0'"),0)!=0)
{
$id = intval($_GET['box']);
$keys = mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_box` WHERE `id_user` = '$ku[id]' AND `key` = '1' AND `time`>='$time'"),0);
$arend_key=mysql_fetch_array(mysql_query("SELECT * FROM `farm_box` WHERE `id_user` = '$ku[id]' AND `key` = '1' AND `time`>='$time'"),0);
$arend_box=mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_box` WHERE `id` = '".intval($_GET['box'])."' AND `id_user` = '$ku[id]' and `key` = '0' AND `time`>='$time'"));
if($keys>0){
mysql_query("DELETE FROM `farm_box` WHERE `id` = '$id'");
mysql_query("DELETE FROM `farm_box` WHERE `id_user` = '$ku[id]' AND `key` = '1' LIMIT 1");
$ot_opyt=$system['sun_opyt_ot'];
$do_opyt=$system['sun_opyt_do'];
$po="".mt_rand($ot_opyt,$do_opyt)."";
$boxo=1;
mysql_query("UPDATE `farm_user` SET `rating` = '".($ku['rating']+$po)."' WHERE `id` = '$ku[id]'");
$ot_money=$system['sun_money_ot'];
$do_money=$system['sun_money_do'];
$rm=mt_rand(0,20); //монеты
if($rm==1 || $rm==5 || $rm==15){
$pm="".mt_rand($ot_money,$do_money)."";
$pm=intval($pm);
$boxm=1;
mysql_query("UPDATE `farm_user` SET `money` = '".($ku['money']+$pm)."' WHERE `id` = '$ku[id]'");
}
$ot_ruby=$system['sun_ruby_ot'];
$do_ruby=$system['sun_ruby_do'];
$rn=mt_rand(0,50); //алмазы
if($rn==10 || $rn==20 || $rn==30){
$pr="".mt_rand($do_money,$do_ruby)."";
$pr=intval($pr);
$boxr=1;
mysql_query("UPDATE `farm_user` SET `rubies` = '".($ku['rubies']+$pr)."' WHERE `id` = '$ku[id]'");
}
$rc=mt_rand(1,100); //коллекция
if($rc<=$collections['chanse']){
$array = array("butterfly","coin","herbal","wrapper","car","necke","fan");
$id = mt_rand(0,6);
echo '</br>';
$sim = mt_rand(1,10);
mysql_query("UPDATE `farm_collections` SET `".$array[$id]."".$sim."` = '1' WHERE `id_user` = '$ku[id]'");
mysql_query("UPDATE `farm_user` SET `s_col` = `s_col` + '1' WHERE `id` = '$ku[id]' ");
$boxc=1;
}
$sdsdsd=rand(1,30);
$pun=rand(0,4);
if($pun==2)
{
$kusok=mysql_fetch_array(mysql_query("SELECT * FROM `farm_house_user` WHERE `id_user` = '$ku[id]'"));
if($ku['id']<=$kusok)
{
$koka="".mysql_result(mysql_query("SELECT sum(dopoln) FROM `farm_house_user` WHERE `id_user` = '$ku[id]'"),0)."";
}
else
{
$koka="0";
}
if($ku['limit_house']!=$koka)
{
$kosmosd=2; //монеты
if($kosmosd==2)
{
$ecepolika=1;
mysql_query("INSERT INTO `farm_house_user` SET `id_user` = '$ku[id]',`idhouse` = '$sdsdsd'");
}
}
}
echo "<div class='feedback'><div>";
echo 'В сундуке Лови: </br>';
if(isset($ecepolika))
{
$plantt=mysql_fetch_array(mysql_query("SELECT * FROM `farm_house` WHERE `id` = '$sdsdsd'"));
echo '
<span>
<span class="title">'.$plantt['name'].'</span>
<span class="nobr title"></span><br/>
<span class="nobr"><img src="/images/icons/beauty.png" width="16" height="16" alt="красота" title="красота"/><span>'.$plantt['beauty'].'</span></span>
<span class="nobr"><img src="/images/icons/conv.png" width="16" height="16" alt="удобство" title="удобство"/><span>'.$plantt['conv'].'</span></span>
<span class="nobr"><img src="/images/icons/status.png" width="16" height="16" alt="статусность" title="статусность"/><span>'.$plantt['status'].'</span></span>
</span>';
}
if(isset($boxo))echo "<li><span><img width='16' height='16' src='/images/icons/experience.png' alt='*'> Опыт +<span class=''>$po</span></li>";
if(isset($boxr))echo "<li><span><img width='16' height='16' src='/images/icons/ruby.png' alt='*'> Алмазы +<span class=''>$pr</span></li>";
if(isset($boxm))echo "<li><span><img width='16' height='16' src='/images/icons/money.png' alt='*'> Монеты +<span class=''>$pm</span></li>";
if(isset($boxc))echo "<li><img width='48' height='48' src='/images/collections/all/".$array[$id]."".$sim.".jpg'> <span class='epic'> Коллекционная вещь</span></li>";
echo "</div>n</div>";
}
else{echo"Нет ключей";}
}
if(isset($_GET['box_buy']) && intval($_GET['box_buy'])!=NULL && mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_box` WHERE `id` = '".intval($_GET['box_buy'])."' AND `id_user` = '$ku[id]' and `key` = '0'"),0)!=0)
{
$id = intval($_GET['box_buy']);
$keys = mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_key` WHERE `id_user` = '$ku[id]' AND `key` = '0' AND `time`>='$time'"),0);
$arend_key=mysql_fetch_array(mysql_query("SELECT * FROM `farm_key` WHERE `id_user` = '$ku[id]' AND `key` = '0' AND `time`>='$time'"));
$arend_box=mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_box` WHERE `id` = '".intval($_GET['box_buy'])."' AND `id_user` = '$ku[id]' AND `key` = '0' AND `time`>='$time'"));
if($ku['rubies']>=25){
mysql_query("UPDATE `farm_user` SET `rubies` = '".($ku['rubies']-25)."' WHERE `id` = '$ku[id]'");
mysql_query("UPDATE `farm_box` SET `key` = '1' WHERE `id` = '$id'");
$po="".mt_rand($ot_opyt,$do_opyt)."";
$boxo=1;
mysql_query("UPDATE `farm_user` SET `rating` = '".($ku['rating']+$po)."' WHERE `id` = '$ku[id]'");
$rm=mt_rand(0,20); //монеты
if($rm==1 || $rm==5 || $rm==15){
$pm="".mt_rand($ot_money,$do_money)."";
$pm=intval($pm);
$boxm=1;
mysql_query("UPDATE `farm_user` SET `money` = '".($ku['money']+$pm)."' WHERE `id` = '$ku[id]'");
}
$rn=mt_rand(0,50); //алмазы
if($rn==10 || $rn==20 || $rn==30){
$pr="".mt_rand($do_money,$do_ruby)."";
$pr=intval($pr);
$boxr=1;
mysql_query("UPDATE `farm_user` SET `rubies` = '".($ku['rubies']+$pr)."' WHERE `id` = '$ku[id]'");
}
$rc=mt_rand(1,100); //коллекция
if($rc<=$collections['chanse']){
$array = array("butterfly","coin","herbal","wrapper","car","necke","fan");
$id = mt_rand(0,6);
echo '</br>';
$sim = mt_rand(1,10);
mysql_query("UPDATE `farm_collections` SET `".$array[$id]."".$sim."` = '1' WHERE `id_user` = '$ku[id]'");
mysql_query("UPDATE `farm_user` SET `s_col` = `s_col` + '1' WHERE `id` = '$ku[id]' ");
$boxc=1;
$sdsdsd=rand(1,30);
$pun=rand(0,4);
if($pun==2)
{
$kusok=mysql_fetch_array(mysql_query("SELECT * FROM `farm_house_user` WHERE `id_user` = '$ku[id]'"));
if($ku['id']<=$kusok)
{
$koka="".mysql_result(mysql_query("SELECT sum(dopoln) FROM `farm_house_user` WHERE `id_user` = '$ku[id]'"),0)."";
}
else
{
$koka="0";
}
if($ku['limit_house']!=$koka)
{
$kosmosd=2; //монеты
if($kosmosd==2)
{
$ecepolika=1;
mysql_query("INSERT INTO `farm_house_user` SET `id_user` = '$ku[id]',`idhouse` = '$sdsdsd'");
}
}
}
}
echo "<div class='feedback'><div>";
echo 'В сундуке Лови: </br>';
if(isset($ecepolika))
{
$plantt=mysql_fetch_array(mysql_query("SELECT * FROM `farm_house` WHERE `id` = '$sdsdsd'"));
echo '
<span>
<span class="title">'.$plantt['name'].'</span>
<span class="nobr title"></span><br/>
<span class="nobr"><img src="/images/icons/beauty.png" width="16" height="16" alt="красота" title="красота"/><span>'.$plantt['beauty'].'</span></span>
<span class="nobr"><img src="/images/icons/conv.png" width="16" height="16" alt="удобство" title="удобство"/><span>'.$plantt['conv'].'</span></span>
<span class="nobr"><img src="/images/icons/status.png" width="16" height="16" alt="статусность" title="статусность"/><span>'.$plantt['status'].'</span></span>
</span>';
}
if(isset($boxo))echo "<li><span><img width='16' height='16' src='/images/icons/experience.png' alt='*'> Опыт +<span class=''>$po</span></li>";
if(isset($boxr))echo "<li><span><img width='16' height='16' src='/images/icons/ruby.png' alt='*'> Алмазы +<span class=''>$pr</span></li>";
if(isset($boxm))echo "<li><span><img width='16' height='16' src='/images/icons/money.png' alt='*'> Монеты +<span class=''>$pm</span></li>";
if(isset($boxc))echo "<li><img width='48' height='48' src='/images/collections/all/".$array[$id]."".$sim.".jpg'> <span class='epic'> Коллекционная вещь</span></li>";
echo "</div>n</div>";
$q2=mysql_query("SELECT * FROM `farm_key` WHERE `id_user` = '$ku[id]' and `key` = '1' LIMIT 1");
while($posts=mysql_fetch_array($q2)){
mysql_query("DELETE FROM `farm_key` WHERE `id` = '$posts[id]'");}
$q=mysql_query("SELECT * FROM `farm_box` WHERE `id_user` = '$ku[id]' and `key` = '1' LIMIT 1");
while($post=mysql_fetch_array($q)){
mysql_query("DELETE FROM `farm_box` WHERE `id` = '$post[id]'");}
}else{
$rm=25-$ku['rubies'];
$_SESSION['no_rubies']=$rm;
}
}
//////////////
if(isset($_GET['act']))
{
echo "<font color='green'>Здесь отображаются растения, которые вы хотите продать</font>";
echo "<li><font color=yellow'>Ваша машина для перевозов :</font></li>";
$act=mysql_query("SELECT * FROM `farm_warehouse_car` WHERE `id` = '$ku[warehouse_act]'");
while($post=mysql_fetch_array($act))
{
echo "<li><font color='#F7FE2E'>Модель: $post[name]</font></li>";
echo "<li><img src='images/avto/$post[id].png'></li>";
echo "<li><font color='#F7FE2E'>Время одной продажи составляет: ".time_left($post['time'])."</font></li>";
}
echo "<font color='green'>список растений, которые движутся в направлении рынка</font>";
$k_post = mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_warehouse_act` WHERE `id_user`='$ku[id]'"),0);
if ($k_post==0)
{
echo "<li>Список пуст...</li>";
}
$k_page=k_page($k_post,$set['p_str']);
$page=page($k_page);
$start=$set['p_str']*$page-$set['p_str'];
$act=mysql_query("SELECT * FROM `farm_warehouse_act` WHERE `id_user` = '$ku[id]'");
while($post=mysql_fetch_array($act))
{
$numma=$numma+1;
echo "<li>$numma. <img width='16' height='16' src='images/icons/tomato.png' alt='o'><span class='title'>$post[name]</span> (<span>$post[count]</span>):будет продано за ".time_left($post['time']-$time).", цена <img width='16' height='16' src='images/icons/money.png' alt='o'><span>$post[cena]</span></li>";
}
echo "<img width='16' height='16' src='images/icons/new/warehouse.png' alt='o'> <a href='/warehouse/'>В амбар
</a>";
echo "</div>";
include "sys/other/foot.php";
}
if($ku['photo_open']==1)
{
echo "<img src='/images/barn.png' alt='city'>";
}
echo '<div class="pt">';
echo "<span><span class='nobr'><img width='16' height='16' src='http://township.mobi/Content/Img/Tools/dynamit.png' alt='o'/> <span class='title'>".(strkol($ku['dinamit']))."</span></span></span> ";
echo "<span><span class='nobr'><img width='16' height='16' src='http://township.mobi/Content/Img/Tools/woodpanel.png' alt='o'/> <span class='title'>".(strkol($ku['klenta']))."</span></span></span>";
echo "<span><span class='nobr'> <img width='16' height='16' src='http://township.mobi/Content/Img/Tools/wood.png' alt='o'/> <span class='title'>".(strkol($ku['doskii']))."</span></span></span>";
echo "<span><span class='nobr'> <img width='16' height='16' src='/images/dekor/84884.png' alt='o'/> <span class='title'>".(strkol($ku['pergament']))."</span></span></span>";
echo "<span><span class='nobr'> <img width='16' height='16' src='/images/dekor/4435.png' alt='o'/> <span class='title'>".(strkol($ku['edaa']))."</span></span></span>";
echo '<div class="pt">';
echo "<img src='/images/icons/tick.png'> <a href='/warehouse/act'>Активные заявки<a>";
echo "<h3>Овощи</h3>";
/////
if(isset($_GET['sell_speci']) && intval($_GET['sell_speci'])!=NULL && mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_my_speci` WHERE `id_user` = '$ku[id]' AND `id` = '".intval($_GET['sell_speci'])."'"), 0)!==0)
{
$pw=mysql_fetch_array(mysql_query("SELECT * FROM `farm_my_speci` WHERE `id_user` = '$ku[id]' AND `id` = '".intval($_GET['sell_speci'])."'"));
$plant=mysql_fetch_array(mysql_query("SELECT * FROM `farm_speci` WHERE `id` = '$pw[id_spec]'"));
if($plant['count']==0){$plant['count']=1;}
if($plant['money']>0){$m=floor(($plant['money']/100)*$pw['count']);}else{$m=0;}
if($plant['rubies']>0){$r=floor(($plant['rubies']/100)*$pw['count']);}else{$r=0;}
$ku['rubies']=plus_rubies($r);
$ku['money']=plus_money($m);
mysql_query("DELETE FROM `farm_my_speci` WHERE `id` = '$pw[id]'");
$_SESSION['money']="$m";
$_SESSION['rubies']="$r";
header("Location:/warehouse/".passgen());
exit;}
//////////////////////////////////
if(isset($_GET['sell_all']) && mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_warehouse` WHERE `id_user` = '$ku[id]'"),0)!=0)
{
if(isset($_GET['fish'])){$fish=1;$base="fish";}else{$fish=0;$base="plant";}
$q=mysql_query("SELECT * FROM `farm_warehouse` WHERE `id_user` = '$ku[id]' AND `fish`='$fish'");
$cm=0;
while($post=mysql_fetch_array($q))
{
$plant=mysql_fetch_array(mysql_query("SELECT * FROM `farm_$base` WHERE `id` = '$post[id_plant]'"));
$m=floor(($plant['money']/$plant['count'])*$post['count']);
$ploj=mysql_fetch_array(mysql_query("SELECT * FROM `farm_warehouse_car` WHERE `id` = '$ku[warehouse_act]'"));
if($post['count']>0 && $post['specia']==0)mysql_query("INSERT INTO `farm_warehouse_act` SET `id_user` = '$ku[id]',`time`='".($ploj[time]+$time)."',`count`='$post[count]',`cena`='".($m)."',`name`='$plant[name]'");
if($post['tachka']==0 && $post['specia']==0)mysql_query("DELETE FROM `farm_warehouse` WHERE `id` = '$post[id]'"); else mysql_query("UPDATE `farm_warehouse` SET `count`='0' WHERE `id` = '$post[id]'");
$cm=$cm+$m;
}
}
///////////////////////////////////
if(isset($_GET['sell']) && intval($_GET['sell'])!=NULL && mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_warehouse` WHERE `id_user` = '$ku[id]' AND `id` = '".intval($_GET['sell'])."'"), 0)!==0)
{
$pw=mysql_fetch_array(mysql_query("SELECT * FROM `farm_warehouse` WHERE `id_user` = '$ku[id]' AND `id` = '".intval($_GET['sell'])."'"));
if(isset($_GET['fish'])){$fish=1;$base="fish";}else{$fish=0;$base="plant";}
$plant=mysql_fetch_array(mysql_query("SELECT * FROM `farm_$base` WHERE `id` = '$pw[id_plant]'"));
if($plant['count']==0){$plant['count']=1;}
$m=($plant['money']/$plant['count'])*$pw['count'];
if($pw['tachka']==0 && $pw['specia']==0)mysql_query("DELETE FROM `farm_warehouse` WHERE `id` = '$pw[id]'"); else mysql_query("UPDATE `farm_warehouse` SET `count`='0' WHERE `id` = '$pw[id]'");
$ploj=mysql_fetch_array(mysql_query("SELECT * FROM `farm_warehouse_car` WHERE `id` = '$ku[warehouse_act]'"));
mysql_query("INSERT INTO `farm_warehouse_act` SET `id_user` = '$ku[id]',`time`='".($ploj[time]+$time)."',`count`='$pw[count]',`cena`='".($m)."',`name`='$plant[name]'");
header("Location:/warehouse/act".passgen());
exit;
}
echo "<ul class='ptm'>";
$q=mysql_query("SELECT * FROM `farm_warehouse` WHERE `id_user` = '$ku[id]' AND `count` > '0' AND `fish` = '0'");
if(mysql_num_rows($q)==0)echo "<li>В амбаре нету овощей</li>";
$cm=0;
while($post=mysql_fetch_array($q))
{
$plant=mysql_fetch_array(mysql_query("SELECT * FROM `farm_plant` WHERE `id` = '$post[id_plant]'"));
$m=floor(($plant['money']/$plant['count'])*$post['count']);
echo "<li><div><img width='16' height='16' src='images/icons/tomato.png' alt='o'> <span class='title'>".hsc($plant['name'])."</span> (<span>$post[count]</span>):<a href='/warehouse/sell-$post[id]'>Продать</a> за <img width='16' height='16' src='images/icons/money.png' alt='o'> <span>$m</span>
</div></li>";
$cm=$cm+$m;
}
if(mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_warehouse` WHERE `id_user` = '$ku[id]' AND `fish`='0' AND `count`>'0'"),0)>1)echo "<li><img alt='*' width='16' height='16' src='images/icons/money.png'> <a href='/warehouse/sell_all'>Продать всё</a> за <img width='16' height='16' src='images/icons/money.png' alt='*'><span>$cm</span></li>";
echo "<div><h3>Добавки</h3>";
echo "<ul class='ptm'>";
$q=mysql_query("SELECT * FROM `farm_my_speci` WHERE `id_user` = '$ku[id]' AND `count` > '0'");
if(mysql_num_rows($q)==0)echo "<li>В амбаре нет Специй</li>";
$cm=0;
while($post=mysql_fetch_array($q))
{
$speci=mysql_fetch_array(mysql_query("SELECT * FROM `farm_speci` WHERE `id` = '$post[id_spec]'"));
$m=floor(($speci['money']/100)*$post['count']);
$r=floor(($speci['rubies']/100)*$post['count']);
echo "<li><div><img width='16' height='16' src='images/icons/addition.png' alt='o'><span class='title'> ".hsc($speci['name'])."</span> (<span>$post[count]</span>): <a href='/warehouse/sell_speci-$post[id]'>Продать</a> за ".($speci['money']>0?"<img width='16' height='16' src='images/icons/money.png' alt='o'> <span>".numbers($m)."</span>":"<img width='16' height='16' src='images/icons/ruby.png' alt='o'> <span>".numbers($r)."</span>")."</div></li>";
}
if($ku['level']>=15)
{
$keyz = mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_box` WHERE `id_user` = '$ku[id]' AND `key` = '1' AND `time`>='$time'"),0);
echo "<h3>Сундуки</h3>";
echo "<ul class='ptm'>";
$q=mysql_query("SELECT * FROM `farm_box` WHERE `id_user` = '$ku[id]' AND `time`>='$time' AND `key` = '0'");
if(mysql_num_rows($q)==0)echo "<li>У вас нет сундуков</li>";
while($post=mysql_fetch_array($q)){
echo "<li><img width='16' height='16' alt='o' src='/images/collections/chest.png'/><span class='title'> Сундук</span> (исчезнет через ".time_left($post['time']-$time)."): ".($keyz==0?"<a href='/?warehouse&box_buy=$post[id]'>Купить ключ и открыть</a> за 25 <img width='16' height='16' src='images/icons/ruby.png' alt='o'>":"<a href='/?warehouse&box=$post[id]'> Открыть</a>")." </li>";}
$q=mysql_query("SELECT * FROM `farm_box` WHERE `id_user` = '$ku[id]' AND `time`>='$time' AND `key` = '1'");
while($post=mysql_fetch_array($q)){
echo "<li><img width='16' height='16' alt='o' src='/images/collections/key.png'/><span class='title'> Ключ</span> (исчезнет через ".time_left($post['time']-$time).")</li>";}
echo "</ul>";
}
if($ku['ramka_open']==0)
{
echo "</ul></div>";
}
echo "<div class='pt'><img width='16' height='16' src='/images/dekor/4435.png' alt='*'> <a href='/?buildingMaterials'>Купить еду</a></div>";
echo "<img width='16' height='16' src='images/icons/tomato.png' alt='*'> <a href='/buy_plant'>Купить овощи</a></div>";
echo '<div>
<img width="16" height="16" src="/images/icons/addition.png" alt="*"/> <a href="/buy_speci">Купить специи</a>
</div>';
if($ku['ramka_open']==1)
{
echo "</ul></div>";
echo "</div>";
}
if($ku['ramka_open']==0)
{
echo "</ul></div>";
}
include "sys/other/foot.php";
?>