Файл: vkolhoze.com/inc/warehouse.php
Строк: 339
<?
require_header ('Рынок');
echo "<div class='content'>";
echo "<div class='block'>";
if(isset($_GET['box']) && intval($_GET['box'])!=NULL && mysql_result(mysql_query("SELECT COUNT(*) FROM `kolhoz_box` WHERE `id` = '".intval($_GET['box'])."' AND `id_user` = '$ku[id]' and `key` = '0'"),0)!=0)
{
$id = intval($_GET['box']);
$po="".mt_rand(10,100)."000000";
$boxo=1;
mysql_query("UPDATE `kolhoz_user` SET `rating` = '".($ku['rating']+$po)."' WHERE `id` = '$ku[id]'");
if($ku['level']>=40){
$rm=mt_rand(0,20); //Гвозди
if($rm==1 || $rm==5 || $rm==15){
$pm="".mt_rand(1,2)."";
$pm=intval($pm);
$boxm=1;
mysql_query("UPDATE `kolhoz_user` SET `nail` = '".($ku['nail']+$pm)."' WHERE `id` = '$ku[id]'");
}
$rb=mt_rand(0,20); //Доски
if($rb==1 || $rb==5 || $rb==15){
$pb="".mt_rand(1,2)."";
$rb=intval($rb);
$boxb=1;
mysql_query("UPDATE `kolhoz_user` SET `board` = '".($ku['board']+$rb)."' WHERE `id` = '$ku[id]'");
}
}
$rn=mt_rand(0,50); //рубины
if($rn==10 || $rn==20 || $rn==30){
$pr="".mt_rand(1,25)."";
$pr=intval($pr);
$boxr=1;
mysql_query("UPDATE `kolhoz_user` SET `rubies` = '".($ku['rubies']+$pr)."' WHERE `id` = '$ku[id]'");
}
$rc=mt_rand(1,20); //коллекция
if($rc==1){
$array = array("butterfly","coin","herbal","wrapper","car","necke","fan", "stamp", "perfume");
$id = mt_rand(0,6);
$sim = mt_rand(1,10);
mysql_query("UPDATE `kolhoz_collections` SET `".$array[$id]."".$sim."` = '1' WHERE `id_user` = '$ku[id]'");
$boxc=1;
}
echo "<div class='feedback'><div>";
echo 'В сундуке Вы нашли: </ br>';
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($ku['level']>=40){
if(isset($boxm))echo "<li><span><img width='16' height='16' src='images/icons/nail.png' alt='*'> <span class=''>$pm</span></li>";
if(isset($boxb))echo "<li><span><img width='16' height='16' src='images/icons/board.png' alt='*'> <span class=''>$pb</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>";
if(mysql_result(mysql_query("SELECT COUNT(*) FROM `kolhoz_box` WHERE `id_user` = '$ku[id]' and `key` = '1'"),0)!=0){
$q=mysql_query("SELECT * FROM `kolhoz_box` WHERE `id_user` = '$ku[id]' and `key` = '1' LIMIT 1");
while($post=mysql_fetch_array($q)){
mysql_query("DELETE FROM `kolhoz_box` WHERE `id` = '$post[id]'");
mysql_query("DELETE FROM `kolhoz_box` WHERE `id` = '$id'");
mysql_query("DELETE FROM `kolhoz_box` WHERE `id` = '$id'");
}
}else{
if($ku['rubies']>=25)
{
mysql_query("UPDATE `kolhoz_user` SET `rubies` = '".($ku['rubies']-25)."' WHERE `id` = '$ku[id]'");
mysql_query("DELETE FROM `kolhoz_box` WHERE `id` = '$id'");
mysql_query("DELETE FROM `kolhoz_box` WHERE `id` = '$id'");
}
else
{
$rm=$cena-$ku['rubies'];
$_SESSION['no_rubies']=$rm;
}
}
}
if(isset($_GET['sell_all']) && mysql_result(mysql_query("SELECT COUNT(*) FROM `kolhoz_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 `kolhoz_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 `kolhoz_$base` WHERE `id` = '$post[id_plant]'"));
if($post['tachka']==0)mysql_query("DELETE FROM `kolhoz_warehouse` WHERE `id` = '$post[id]'"); else mysql_query("UPDATE `kolhoz_warehouse` SET `count`='0' WHERE `id` = '$post[id]'");
$m=floor(($plant['money']/$plant['count'])*$post['count']);
$cm=$cm+$m;
}
mysql_query("UPDATE `kolhoz_user` SET `money` = '".($ku['money']+$cm)."' WHERE `id` = '$ku[id]'");
mysql_query("UPDATE `kolhoz_user` SET `umoney` = '$cm' WHERE `id` = '$ku[id]'");
if(isset($mc) && $mc['nalog']>0)
{
$nmoney=floor(($cm/100)*$mc['nalog']);
mysql_query("UPDATE `kolhoz_user` SET `money` = '".($ku['money']+$cm-$nmoney)."' WHERE `id` = '$ku[id]'");
mysql_query("UPDATE `kolhoz_collective_user` SET `money` = '".($mcu['money']+$nmoney)."' WHERE `id_user` = '$ku[id]'");
mysql_query("UPDATE `kolhoz_collective` SET `money` = '".($mc['money']+$nmoney)."' WHERE `id` = '$mc[id]'");
}
header("Location:/warehouse/".passgen());
exit;
}
if(isset($_GET['sell']) && intval($_GET['sell'])!=NULL && mysql_result(mysql_query("SELECT COUNT(*) FROM `kolhoz_warehouse` WHERE `id_user` = '$ku[id]' AND `id` = '".intval($_GET['sell'])."'"), 0)!==0)
{
$pw=mysql_fetch_array(mysql_query("SELECT * FROM `kolhoz_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 `kolhoz_$base` WHERE `id` = '$pw[id_plant]'"));
if($plant['count']==0){$plant['count']=1;}
$m=floor(($plant['money']/$plant['count'])*$pw['count']);
mysql_query("UPDATE `kolhoz_user` SET `money` = '".($ku['money']+$m)."' WHERE `id` = '$ku[id]'");
if($pw['tachka']==0)mysql_query("DELETE FROM `kolhoz_warehouse` WHERE `id` = '$pw[id]'"); else mysql_query("UPDATE `kolhoz_warehouse` SET `count`='0' WHERE `id` = '$pw[id]'");
mysql_query("UPDATE `kolhoz_user` SET `umoney` = '$m' WHERE `id` = '$ku[id]'");
if(isset($mc) && $mc['nalog']>0)
{
$nmoney=floor(($m/100)*$mc['nalog']);
mysql_query("UPDATE `kolhoz_user` SET `money` = '".($ku['money']+$m-$nmoney)."' WHERE `id` = '$ku[id]'");
mysql_query("UPDATE `kolhoz_collective_user` SET `money` = '".($mcu['money']+$nmoney)."' WHERE `id_user` = '$ku[id]'");
mysql_query("UPDATE `kolhoz_collective` SET `money` = '".($mc['money']+$nmoney)."' WHERE `id` = '$mc[id]'");
}
header("Location:/warehouse/".passgen());
exit;
}
if(isset($_GET['tachka']) && intval($_GET['tachka'])!=NULL && mysql_result(mysql_query("SELECT COUNT(*) FROM `kolhoz_warehouse` WHERE `id_user` = '$ku[id]' AND `id` = '".intval($_GET['tachka'])."' AND `count`>'0'"), 0)!==0)
{
$pw=mysql_fetch_array(mysql_query("SELECT * FROM `kolhoz_warehouse` WHERE `id_user` = '$ku[id]' AND `id` = '".intval($_GET['tachka'])."'"));
if($pw['count']>=100)$count=100; else $count=$pw['count'];
mysql_query("UPDATE `kolhoz_warehouse` SET `count` = '".($pw['count']-$count)."',`tachka` = '".($pw['tachka']+$count)."' WHERE `id` = '".intval($_GET['tachka'])."'");
header("Location:/warehouse/".passgen());
exit;
}
if(isset($_GET['tachka_out']) && intval($_GET['tachka_out'])!=NULL && mysql_result(mysql_query("SELECT COUNT(*) FROM `kolhoz_warehouse` WHERE `id_user` = '$ku[id]' AND `id` = '".intval($_GET['tachka_out'])."' AND `tachka`>'0'"), 0)!==0)
{
$pw=mysql_fetch_array(mysql_query("SELECT * FROM `kolhoz_warehouse` WHERE `id_user` = '$ku[id]' AND `id` = '".intval($_GET['tachka_out'])."'"));
if($pw['tachka']>=100)$count=100; else $count=$pw['tachka'];
mysql_query("UPDATE `kolhoz_warehouse` SET `count` = '".($pw['count']+$count)."',`tachka` = '".($pw['tachka']-$count)."' WHERE `id` = '".intval($_GET['tachka_out'])."'");
header("Location:/warehouse/".passgen());
exit;
}
if(isset($_GET['tachka_out_all']) && intval($_GET['tachka_out_all'])!=NULL && mysql_result(mysql_query("SELECT COUNT(*) FROM `kolhoz_warehouse` WHERE `id_user` = '$ku[id]' AND `id` = '".intval($_GET['tachka_out_all'])."' AND `tachka`>'0'"), 0)!==0)
{
$pw=mysql_fetch_array(mysql_query("SELECT * FROM `kolhoz_warehouse` WHERE `id_user` = '$ku[id]' AND `id` = '".intval($_GET['tachka_out_all'])."'"));
$count=$pw['tachka'];
mysql_query("UPDATE `kolhoz_warehouse` SET `count` = '".($pw['count']+$count)."',`tachka` = '".($pw['tachka']-$count)."' WHERE `id` = '".intval($_GET['tachka_out_all'])."'");
header("Location:/warehouse/".passgen());
exit;
}
if(isset($_GET['sell_all_market']) && mysql_result(mysql_query("SELECT COUNT(*) FROM `kolhoz_market` WHERE `id_user` = '$ku[id]'"),0)!=0)
{
$q=mysql_query("SELECT * FROM `kolhoz_market` WHERE `id_user` = '$ku[id]'");
$cm=0;
while($post=mysql_fetch_array($q))
{
$plant2=mysql_fetch_array(mysql_query("SELECT * FROM `kolhoz_plant2` WHERE `id` = '$post[id_plant2]'"));
$m=floor(($plant2['rubies']/$plant2['count'])*$post['count']);
$cm=$cm+$m;
}
mysql_query("UPDATE `kolhoz_user` SET `rubies` = '".($ku['rubies']+$cm)."' WHERE `id` = '$ku[id]'");
mysql_query("DELETE FROM `kolhoz_market` WHERE `id_user` = '$ku[id]'");
mysql_query("UPDATE `kolhoz_user` SET `umoney2` = '$cm' WHERE `id` = '$ku[id]'");
/*Налог временно убран
if(isset($mc) && $mc['nalog2']>0)
{
$nrubies=floor(($cm/100)*$mc['nalog2']);
mysql_query("UPDATE `kolhoz_user` SET `rubies` = '".($ku['rubies']+$cm-$nrubies)."' WHERE `id` = '$ku[id]'");
mysql_query("UPDATE `kolhoz_collective_user` SET `money` = '".($mcu['money']+$nmoney)."' WHERE `id_user` = '$ku[id]'");
mysql_query("UPDATE `kolhoz_collective` SET `rubies` = '".($mc['rubies']+$nrubies)."' WHERE `id` = '$mc[id]'");
}*/
header("Location:/warehouse/".passgen());
exit;
}
if(isset($_GET['sell_market']) && intval($_GET['sell_market'])!=NULL && mysql_result(mysql_query("SELECT COUNT(*) FROM `kolhoz_market` WHERE `id_user` = '$ku[id]' AND `id` = '".intval($_GET['sell_market'])."'"),0)!=0)
{
$pw=mysql_fetch_array(mysql_query("SELECT * FROM `kolhoz_market` WHERE `id_user` = '$ku[id]' AND `id` = '".intval($_GET['sell_market'])."'"),0);
$plant2=mysql_fetch_array(mysql_query("SELECT * FROM `kolhoz_plant2` WHERE `id` = '$pw[id_plant2]'"));
$m=floor(($plant2['rubies']/$plant2['count'])*$pw['count']);
mysql_query("UPDATE `kolhoz_user` SET `rubies` = '".($ku['rubies']+$m)."' WHERE `id` = '$ku[id]'");
mysql_query("DELETE FROM `kolhoz_market` WHERE `id` = '$pw[id]'");
mysql_query("UPDATE `kolhoz_user` SET `umoney2` = '$m' WHERE `id` = '$ku[id]'");
/*if(isset($mc) && $mc['nalog2']>0)
{
$nrubies=floor(($m/100)*$mc['nalog2']);
mysql_query("UPDATE `kolhoz_user` SET `rubies` = '".($ku['rubies']+$m-$nrubies)."' WHERE `id` = '$ku[id]'");
mysql_query("UPDATE `kolhoz_collective_user` SET `money` = '".($mcu['money']+$nmoney)."' WHERE `id_user` = '$ku[id]'");
mysql_query("UPDATE `kolhoz_collective` SET `rubies` = '".($mc['rubies']+$nrubies)."' WHERE `id` = '$mc[id]'");
}
*/
header("Location:/warehouse/".passgen());
exit;
}
$q=mysql_query("SELECT * FROM `kolhoz_warehouse` WHERE `id_user` = '$ku[id]' AND `tachka` > '0' AND `fish` = '0'");
if(mysql_num_rows($q)>0){echo '<div><h3>Тачка</h3><ul class="ptm">';
while($post=mysql_fetch_array($q))
{
$plant=mysql_fetch_array(mysql_query("SELECT * FROM `kolhoz_plant` WHERE `id` = '$post[id_plant]'"));
echo "<li><div><span class='title'>".hsc($plant['name'])."</span><img width='16' height='16' src='images/icons/tomato.png' alt='o'>Выложить из тачки</a>".($post['tachka']>1000?", <a class='knopka1' href='/warehouse/tachka_out_all-$post[id]'>Выложить все</a>":null)."
</div></li>";
}
echo "</ul></div>";
}
echo "<div><h3>Овощи</h3>";
echo "<ul class='ptm'>";
$q=mysql_query("SELECT * FROM `kolhoz_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 `kolhoz_plant` WHERE `id` = '$post[id_plant]'"));
$plz=mysql_fetch_array(mysql_query("SELECT * FROM `kolhoz_plant` WHERE `id` = '$plant[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'>".($plant['id_collective']>0?"".hsc($plz['name'])." ".hsc($plant['name'])."":"".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>".numbers($m)."</span>
</div></li>";
$cm=$cm+$m;
}
if(mysql_result(mysql_query("SELECT COUNT(*) FROM `kolhoz_warehouse` WHERE `id_user` = '$ku[id]' AND `fish`='0' AND `count`>'0'"),0)>1)echo "<li><a class='loc' href='/warehouse/sell_all'><img alt='*' width='16' height='16' src='images/icons/money.png'> Продать всё за <img width='16' height='16' src='images/icons/money.png' alt='*'><span>$cm</span></a></li>";
echo "</ul></div>";
echo "<div><h3>Ископаемые</h3>";
echo "<ul class='ptm'>";
$q=mysql_query("SELECT * FROM `kolhoz_warehouse` WHERE `id_user` = '$ku[id]' AND `arena` = '0' AND `fish` = '1'");
if(mysql_num_rows($q)==0){echo "<li>На рынке нет ископаемых для продажи</li>";}else{
$cm=0;
while($post=mysql_fetch_array($q))
{
$plant=mysql_fetch_array(mysql_query("SELECT * FROM `kolhoz_fish` WHERE `id` = '$post[id_plant]'"));
$m=floor(($plant['money']/$plant['count'])*$post['count']);
echo "<li><div><span class='title'>".hsc($plant['name'])."</span> (<span>$post[count]</span> кг): <a class='loc' href='/warehouse/fish/sell-$post[id]'><img width='16' height='16' src='images/icons/tomato.png' alt='o'>Продать за <img width='16' height='16' src='images/icons/money.png' alt='o'><span>$m</span>
</div></a></li>";
$cm=$cm+$m;
}
if(mysql_result(mysql_query("SELECT COUNT(*) FROM `kolhoz_warehouse` WHERE `id_user` = '$ku[id]' AND `fish`='1' AND `count`>'0'"),0)>1)echo "<li><img alt='*' width='16' height='16' src='images/icons/money.png'> <a href='/warehouse/sell_all/fish'>Продать всё</a> за <img width='16' height='16' src='images/icons/money.png' alt='o'><span>$cm</span></li>";
echo "</ul></div>";
}
if($ku['level']>=20){
echo "<div><h3>Консервация</h3>";
echo "<ul class='ptm'>";
$q=mysql_query("SELECT * FROM `kolhoz_market` WHERE `id_user` = '$ku[id]' AND `arena` = '0'");
if(mysql_num_rows($q)==0)echo "<li>Для продажи ничего нет</li>";
$cm=0;
while($post=mysql_fetch_array($q))
{
$plant2=mysql_fetch_array(mysql_query("SELECT * FROM `kolhoz_plant2` WHERE `id` = '$post[id_plant2]'"));
$m=floor(($plant2['rubies']/$plant2['count'])*$post['count']);
echo "<li><div><span class='title'>".hsc($plant2['name'])."</span> (<span>$post[count]</span>): <a class='loc' href='/warehouse/sell_market-$post[id]'><img width='16' height='16' src='images/icons/recipes.png' alt='o'> продать : <img width='16' height='16' src='images/icons/ruby.png' alt='o'><span>$m</span>
</div></a></li>";
$cm=$cm+$m;
}
if(mysql_result(mysql_query("SELECT COUNT(*) FROM `kolhoz_market` WHERE `id_user` = '$ku[id]'"),0)>1)echo "<li><img alt='*' width='16' height='16' src='images/icons/ruby.png'> <a href='/warehouse/sell_all_market'>Продать оптом</a> за <img width='16' height='16' src='images/icons/ruby.png' alt='o'><span>$cm</span></li>";
echo "</ul></div>";
}
echo "<div><h3>Сундуки</h3>";
echo "<ul class='ptm'>";
$q=mysql_query("SELECT * FROM `kolhoz_box` WHERE `id_user` = '$ku[id]'");
$key=mysql_result(mysql_query("SELECT COUNT(*) FROM `kolhoz_box` WHERE `id_user` = '$ku[id]' and `key` = '1'"),0);
if(mysql_num_rows($q)==0)echo "<li>У вас нет сундуков</li>";
while($post=mysql_fetch_array($q))
{
if($post['time']>$time)echo "<li>".($post['key']==0?"<img width='16' height='16' alt='o' src='/images/collections/chest.png'/><span class='title'> Сундук</span>":"<img width='16' height='16' alt='o' src='/images/collections/key.png'/><span class='title'> Ключ</span>")." (исчезнет через ".time_left($post['time']-$time)."): ".($post['key']==0?"".($key == 0?"<a href='?warehouse&box=$post[id]'>Купить ключ и открыть</a> за 25 <img width='16' height='16' src='images/icons/ruby.png' alt='o'>":"<a href='?warehouse&box=$post[id]'> Открыть</a>")."":"")." </li>";
}
echo "</ul></div>";
echo "<div class='pt'><a class='loc' href='/buy_plant'><img width='16' height='16' src='images/icons/tomato.png' alt='*'> Купить овощи</a></div></div>";
include_once 'inc/foot.php';
?>