Файл: ubiznes.mobi/inc/location/shops/act.php
Строк: 310
<?
if(isset($_GET['new_shop'])){
if(isset($_GET['info']) && mysql_result(mysql_query("SELECT COUNT(*) FROM `shops` WHERE `id` = '".intval($_GET['info'])."'"),0)>0){
$info=mysql_fetch_assoc(mysql_query("SELECT * FROM `shops` WHERE `id` = '".intval($_GET['info'])."' LIMIT 1"));
$fact1=mysql_fetch_assoc(mysql_query("SELECT * FROM `factory` WHERE `id` = '$info[res_1]' LIMIT 1"));
$fact2=mysql_fetch_assoc(mysql_query("SELECT * FROM `factory` WHERE `id` = '$info[res_2]' LIMIT 1"));
echo'<div class="pan-4">
<font color="lime" size="4"> Информация о магазине </font> <hr>
Наименование магазина: <span class="small"> <img width="32" height="32" src="/inc/location/shops/images/'.$info['id'].'.png"> <font color="violet"> '.hsc($info['name']).' </font> </span> </br>
Наименование товара: <img width="32" height="32" src="/inc/location/shops/images/p'.$info['id'].'.png"> <font color="violet"> '.hsc($info['names']).' </font>
<hr>
Стоимость закупа 1-го товара: <img width="16" height="16" src="/images/icons/'.$info['res'].'.png"> <font color="yellow"> '.razd($info['price']).'</font> </br>
Стоимость продажи 1-го товара: <img width="16" height="16" src="/images/icons/'.$info['res'].'.png"> <font color="yellow"> '.razd($info['price_sell']).'</font> </br>
Кол-во опыта за продажу 1-го товара: <img width="16" height="16" src="/images/icons/exp.png"> <font color="yellow"> '.rating($info['exp']).'</font> </br>
Время продажи 1-го товара: <img width="16" height="16" src="/images/icons/time.png"> <font color="yellow"> '.time_left($info['time']).'</font>
<hr>
Постройка: </br>'.($fact1['id']>0?''.img_ic(16,16,'factory/tovar/'.$fact1['id']).' <font color="yellow"> '.$fact1['names'].' </font> (<font color="yellow">'.$info['count_1'].'</font>) </br>':null).' '.($fact2['id']>0?''.img_ic(16,16,'factory/tovar/'.$fact2['id']).' <font color="yellow"> '.$fact2['names'].'</font> (<font color="yellow">'.$info['count_2'].'</font>)':null).'<hr>
</div>';
back("/?shops&new_shop");
include_once'sys/foot.php';
}
if(isset($_GET['select']) && mysql_result(mysql_query("SELECT COUNT(*) FROM `shops` WHERE `id` = '".intval($_GET['select'])."'"),0)>0){
$select=mysql_fetch_assoc(mysql_query("SELECT * FROM `shops` WHERE `id` = '".intval($_GET['select'])."' LIMIT 1"));
if(isset($_GET['ok'])){
if(mysql_result(mysql_query("SELECT COUNT(*) FROM `shops_user` WHERE `id_user` = '$user[id]' AND `act` = '1'"),0)>0){
$err=1; err_game("Чтобы начать стройку нового магазина, закончите предыдушую стройку");
}elseif(mysql_result(mysql_query("SELECT COUNT(*) FROM `shops_user` WHERE `id_user` = '$user[id]'"),0)>=$max){
$err=1; err_game("Достигнуто максимальное кол-во магазинов");
}
if(empty($err)){
mysql_query("INSERT INTO `shops_user` SET `id_user` = '$user[id]', `act` = '1', `id_shops` = '$select[id]',`level` = '1', `count_max` = '$select[max]'");
heads("Cтройка магазина успешно начата","/?shops");
}
}
echo'<div class="pan-4"> Вы действительно хотите начать стройку магазина <font color="yellow"> '.hsc($select['name']).' </font>? </div>';
podtv("/?shops&new_shop&select=$select[id]&ok","/?shops&new_shop");
back("/?shops&new_shop");
include_once'sys/foot.php';
}
$k_post = mysql_result(mysql_query("SELECT COUNT(*) FROM `shops`"),0);
if ($k_post==0){echo "Список пуст...";}
$k_page=k_page($k_post,$set['p_str']);
$page=page($k_page);
$start=$set['p_str']*$page-$set['p_str'];
$q=mysql_query("SELECT * FROM `shops` ORDER BY `id` DESC LIMIT $start, $set[p_str]");
while($post=mysql_fetch_array($q)){
$fact1=mysql_fetch_assoc(mysql_query("SELECT * FROM `factory` WHERE `id` = '$post[res_1]' LIMIT 1"));
$fact2=mysql_fetch_assoc(mysql_query("SELECT * FROM `factory` WHERE `id` = '$post[res_2]' LIMIT 1"));
echo "<div class='pan-4 small'>
<img width='48' height='48' src='inc/location/shops/images/$post[id].png' alt='o' class='portrait'>
<div> <span> <a href='/?shops&new_shop&select=$post[id]'>".hsc($post['name'])."</a> </span> | <a href='/?shops&new_shop&info=$post[id]'>[Информация о магазине]</a> </br>
Товар: <img width='16' height='16' src='/inc/location/shops/images/p".$post['id'].".png'> <font color='violet'> ".hsc($post['names'])."</font> </br>
Постройка: ".($fact1['id']>0?''.img_ic(16,16,'factory/tovar/'.$fact1['id']).' <font color="yellow"> '.$fact1['names'].' </font> (<font color="yellow">'.$post['count_1'].'</font>) |':null)." ".($fact2['id']>0?''.img_ic(16,16,'factory/tovar/'.$fact2['id']).' <font color="yellow"> '.$fact2['names'].'</font>(<font color="yellow">'.$post['count_2'].'</font>)':null)."
</div>
<div style='clear:both'></div>
</div>";
}
back("/?shops");
include_once'sys/foot.php';
}
if(isset($_GET['act_warehouse']) && mysql_result(mysql_query("SELECT COUNT(*) FROM `shops_user` WHERE `id_user` = '$user[id]' AND `act` = '1' AND `id` = '".intval($_GET['act_warehouse'])."'"),0)>0 && isset($_GET['type'])){
$type=abs(intval($_GET['type'])); if($type!=1 && $type!=2){header("location:/?shops");exit;}
$us_shop=mysql_fetch_assoc(mysql_query("SELECT * FROM `shops_user` WHERE `id` = '".intval($_GET['act_warehouse'])."' LIMIT 1"));
$shops=mysql_fetch_assoc(mysql_query("SELECT * FROM `shops` WHERE `id` = '$us_shop[id_shops]' LIMIT 1"));
$fact1=mysql_fetch_assoc(mysql_query("SELECT * FROM `factory` WHERE `id` = '$shops[res_1]' LIMIT 1"));
$fact2=mysql_fetch_assoc(mysql_query("SELECT * FROM `factory` WHERE `id` = '$shops[res_2]' LIMIT 1"));
if($type==1)$fact=$fact1;else $fact=$fact2;
$max=(($us_shop['level']*$shops['count_'.$type])-$us_shop['res'.$type]);
if(isset($_GET['give']) && mysql_result(mysql_query("SELECT COUNT(*) FROM `factory_warehouse` WHERE `id_user` = '$user[id]' AND `id_factory` = '$fact[id]' AND `count` > '0' AND `id` = '".intval($_GET['give'])."'"),0)>0){
$sell=mysql_fetch_assoc(mysql_query("SELECT * FROM `factory_warehouse` WHERE `id` = '".intval($_GET['give'])."' LIMIT 1"));
$facts=mysql_fetch_assoc(mysql_query("SELECT * FROM `factory` WHERE `id` = '$sell[id_factory]' LIMIT 1"));
if(isset($_POST['sells'])){
$count=abs(intval($_POST['count']));if($count>$max)$count=$max;
if($count>$sell['count']){$err=1; err_game("У Вас нет такого кол-ва товара");}
if($count<=0){$err=1; err_game("Минимальное кол-во товара: <span class=''>1 шт.</span>");}
if(empty($err)){
mysql_query("UPDATE `shops_user` SET `res$type` = `res$type` + '$count' WHERE `id` = '$us_shop[id]'");
mysql_query("UPDATE `factory_warehouse` SET `count` = `count` - '$count' WHERE `id` = '$sell[id]'");
heads("Материал успешно сдан","/?shops");
}
}
echo'<div class="pan-4">
<h2> Информация </h2>
Материал: '.img_ic(16,16,'factory/tovar/'.$facts['id']).' <font color="yellow"> '.hsc($facts['names']).' </font> </br>
На складе: '.img_ic(16,16,'factory/tovar/'.$facts['id']).' <font color="yellow"> '.hsc($sell['count']).' </font> </br>
Нужно: '.img_ic(16,16,'factory/tovar/'.$facts['id']).' <font color="yellow"> '.$max.' </font> </div>
<div class="pan-4">
<form method="post">
Введите кол-во товара для cдачи: </br><input type="number" name="count" min="1" max="'.$max.'" value="'.(($us_shop['level']*$shops['count_'.$type])-$us_shop['res'.$type]).'"></br>
<input type="submit" name="sells" value="Продать"></form></div>';
back("/?shops");
include_once'sys/foot.php';
}
echo'<div class="pan-4">';
$k_post = mysql_result(mysql_query("SELECT COUNT(*) FROM `factory_warehouse` WHERE `id_user` = '$user[id]' AND `count` > '0' AND `id_factory` = '".$fact['id']."'"),0);
if ($k_post==0){echo "На складе нет такого товара";}
$k_page=k_page($k_post,$set['p_str']);
$page=page($k_page);
$start=$set['p_str']*$page-$set['p_str'];
$q=mysql_query("SELECT * FROM `factory_warehouse` WHERE `id_user` = '$user[id]' AND `count` > '0' AND `id_factory` = '".$fact['id']."' ORDER BY `id` ASC LIMIT $start, $set[p_str]");
while($post=mysql_fetch_array($q)){
$fact=mysql_fetch_assoc(mysql_query("SELECT * FROM `factory` WHERE `id` = '$post[id_factory]' LIMIT 1"));
echo'<div> <img width="22" height="22" src="/images/factory/tovar/'.$fact['id'].'.png"> <span class="epic">'.$fact['names'].'</span>: <span class="">'.razd($post['count']).'</span>
<div class="text-2"> <img width="16" height="16" src="http://nebo.mobi/images/icons/st_build.png"> <a href="/?shops&act_warehouse='.$us_shop['id'].'&type='.$type.'&give='.$post['id'].'"> Сдать рабочим </a> <img width="16" height="16" src="http://nebo.mobi/images/icons/st_build.png"></div>
</div>';
}
echo'</div>';
back("/?shops"); include_once'sys/foot.php';
}
if(isset($_GET['act']) && mysql_result(mysql_query("SELECT COUNT(*) FROM `shops_user` WHERE `id_user` = '$user[id]' AND `act` = '1' AND `id` = '".intval($_GET['act'])."'"),0)>0){
$us_shop=mysql_fetch_assoc(mysql_query("SELECT * FROM `shops_user` WHERE `id` = '".intval($_GET['act'])."' LIMIT 1"));
$shops=mysql_fetch_assoc(mysql_query("SELECT * FROM `shops` WHERE `id` = '$us_shop[id_shops]' LIMIT 1"));
if($us_shop['res1']>=($us_shop['level']*$shops['count_1']) && $us_shop['res2']>=($us_shop['level']*$shops['count_2'])){
mysql_query("UPDATE `shops_user` SET `res1` = '0', `res2` = '0', `act` = '0' WHERE `id` ='$us_shop[id]'");
heads("Cтройка успешно завершена","/?shops");
}else{
err_game("Нехватает материалов");
}
}
if(isset($_GET['moderate']) && mysql_result(mysql_query("SELECT COUNT(*) FROM `shops_user` WHERE `id_user` = '$user[id]' AND `act` = '0' AND `id` = '".intval($_GET['moderate'])."'"),0)>0){
$info=mysql_fetch_assoc(mysql_query("SELECT * FROM `shops_user` WHERE `id` = '".intval($_GET['moderate'])."' LIMIT 1"));
$shops=mysql_fetch_assoc(mysql_query("SELECT * FROM `shops` WHERE `id` = '$info[id_shops]' LIMIT 1"));
$fact1=mysql_fetch_assoc(mysql_query("SELECT * FROM `factory` WHERE `id` = '$shops[res_1]' LIMIT 1"));
$fact2=mysql_fetch_assoc(mysql_query("SELECT * FROM `factory` WHERE `id` = '$shops[res_2]' LIMIT 1"));
if(isset($_GET['upgr'])){
if(isset($_GET['ok'])){
mysql_query("UPDATE `shops_user` SET `act` = '1', `level` = `level` + '1', `count_max` = `count_max` + '5' WHERE `id` = '$info[id]'");
heads("Улучшение успешно начато","/?shops");
}
echo'<div class="pan-4"> Вы действительно хотите начать улучшение магазина? </br>
<font color="gray"> <span class="small"> Отменить это действие будет <font color="lime">невозможно</font></span> </font></div>';
podtv("/?shops&moderate=$info[id]&upgr&ok","/?shops&moderate=$info[id]");
back("/?shops&moderate=$info[id]");
include_once'sys/foot.php';
}
echo'<div class="pan-4">
<font color="lime" size="4"> Информация о магазине </font> <hr>
Наименование магазина: <span class="small"> <img width="32" height="32" src="/inc/location/shops/images/'.$shops['id'].'.png"> <font color="violet"> '.hsc($shops['name']).' </font> </span> </br>
Наименование товара: <img width="32" height="32" src="/inc/location/shops/images/p'.$shops['id'].'.png"> <font color="violet"> '.hsc($shops['names']).' </font>
Максимальное кол-во продаваемого товара: <font color="orange"> '.$info['count_max'].' </font></br>
<hr>
Стоимость улучшения: </br>
'.($fact1['id']>0?''.img_ic(16,16,'factory/tovar/'.$fact1['id']).' <font color="aqua"> '.$fact1['names'].' </font> (<font color="yellow">'.razd(($info['level']+1)*$shops['count_1']).'</font>) </br>':null).'
'.($fact2['id']>0?''.img_ic(16,16,'factory/tovar/'.$fact2['id']).' <font color="aqua"> '.$fact2['names'].'</font>(<font color="yellow">'.razd(($info['level']+1)*$shops['count_2']).'</font>)':null).'
<div class="text-2"> <a href=/?shops&moderate='.$info['id'].'&upgr> Начать улучшение </a> </div>
<font color="gray"> <span class="small"> Каждый уровень магазина дает <font color="lime">+5 товаров</font> для продажи </span> </font>
<hr></div>';
back("/?shops");
include_once'sys/foot.php';
}
if(isset($_GET['tovar']) && mysql_result(mysql_query("SELECT COUNT(*) FROM `shops_user` WHERE `id_user` = '$user[id]' AND `act` = '0' AND `id` = '".intval($_GET['tovar'])."'"),0)>0){
$info=mysql_fetch_assoc(mysql_query("SELECT * FROM `shops_user` WHERE `id` = '".intval($_GET['tovar'])."' LIMIT 1"));
$shops=mysql_fetch_assoc(mysql_query("SELECT * FROM `shops` WHERE `id` = '$info[id_shops]' LIMIT 1"));
echo'<div class="pan-4"><hr>
Магазин: <span class="small"> <img width="32" height="32" src="/inc/location/shops/images/'.$shops['id'].'.png"> <font color="violet"> '.hsc($shops['name']).' </font> </span> </br>
Товар: <img width="32" height="32" src="/inc/location/shops/images/p'.$shops['id'].'.png"> <font color="violet"> '.hsc($shops['names']).' </font>
<hr>
Выставлено товара: <font color="orange"> '.$info['count'].' </font></br>
Стоимость покупки одного товара: '.img_ic(16,16,'icons/'.$shops['res']).' <font color="orange"> '.$shops['price'].' </font></br>
Стоимость продажи одного товара: '.img_ic(16,16,'icons/'.$shops['res']).' <font color="orange"> '.$shops['price_sell'].' </font><hr>
</div>';
$max=$info['count_max']-$info['count'];
if(isset($_POST['ok'])){
$count=abs(intval($_POST['count']));
$price=$shops['price']*$count;
if($count>$max){$err=1;err_game("Вводимое кол-во превышает доступное");}
elseif($user[$shops['res']]<$price){$err=1; err_game("У Вас не хватает ".img_ic(16,16,'icons/'.$shops['res'])." <font color='lime'>".razd($price-$user[$shops['res']])."</font>");}
if(empty($err)){
mysql_query("UPDATE `user` SET `$shops[res]` = `$shops[res]` - '$price' WHERE `id` = '$user[id]'" );
mysql_query("UPDATE `shops_user` SET `count` = `count` + '$count'".($info['count']==0?",`last` = '$time',`times` = '0'":null)." WHERE `id` = '$info[id]'");
heads("Товар успешно выставлен","/?shops");
}
}
echo'<div class="pan-4">
Доступно к выставке: <font color="orange">'.($max).'
'.($max>0?'
<form method="post"> Введите кол-во товара:</br><input type="number" name="count"></br>
<input type="submit" name="ok" value="Выставить"></form>
':null).'
</div>';
back("/?shops");
include_once'sys/foot.php';
}