Файл: vfermu.ru/sys/sellar/seat_change_recept_all.php
Строк: 188
<?
if(isset($_GET['select']) && intval($_GET['select'])!=NULL && mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_my_recept` WHERE `id` = '".intval($_GET['select'])."' AND `id_user` = '".($ku['id'])."'"),0)!=0){
$re=mysql_fetch_array(mysql_query("SELECT * FROM `farm_my_recept` WHERE `id_user` = '$ku[id]' AND `id` = '".intval($_GET['select'])."'"));
$recept=mysql_fetch_array(mysql_query("SELECT * FROM `farm_recept` WHERE `id` = '".($re['id_rec'])."'"));
$ranp1 =rand($recept['pc1_min'],$recept['pc1_max']);
$ranp2 =rand($recept['pc2_min'],$recept['pc2_max']);
$ranp3 =rand($recept['pc3_min'],$recept['pc3_max']);
$ranp4 =rand($recept['pc4_min'],$recept['pc4_max']);
$ranp5 =rand($recept['pc5_min'],$recept['pc5_max']);
$rans1 =rand($recept['sc1_min'],$recept['sc1_max']);
$rans2 =rand($recept['sc2_min'],$recept['sc2_max']);
$rans3 =rand($recept['sc3_min'],$recept['sc3_max']);
$rans4 =rand($recept['sc4_min'],$recept['sc4_max']);
$rans5 =rand($recept['sc5_min'],$recept['sc5_max']);
$rant =rand($recept['time_min'],$recept['time_max']);
mysql_query("UPDATE `farm_sellar_tmp` SET `p1` = '0',`pc1` = '0',`p2` = '0',`pc2` = '0',`p3` = '0',`pc3` = '0',`p4` = '0',`pc4` = '0',`p5` = '0',`pc5` = '0',`s1` = '0',`sc1` = '0',`s2` = '0',`sc2` = '0',`s3` = '0',`sc3` = '0',`s4` = '0',`sc4` = '0',`s5` = '0',`sc5` = '0',`time` = '0' WHERE `id_user` = '$ku[id]' LIMIT 1");
if($recept['p1']>0){
mysql_query("UPDATE `farm_sellar_tmp` SET `p1` = '".($recept['p1'])."',`pc1` = '".($ranp1)."' WHERE `id_user` = '$ku[id]' LIMIT 1");}
if($recept['p2']>0){
mysql_query("UPDATE `farm_sellar_tmp` SET `p2` = '".($recept['p2'])."',`pc2` = '".($ranp2)."' WHERE `id_user` = '$ku[id]' LIMIT 1");}
if($recept['p3']>0){
mysql_query("UPDATE `farm_sellar_tmp` SET `p3` = '".($recept['p3'])."',`pc3` = '".($ranp3)."' WHERE `id_user` = '$ku[id]' LIMIT 1");}
if($recept['p4']>0){
mysql_query("UPDATE `farm_sellar_tmp` SET `p4` = '".($recept['p4'])."',`pc4` = '".($ranp4)."' WHERE `id_user` = '$ku[id]' LIMIT 1");}
if($recept['p5']>0){
mysql_query("UPDATE `farm_sellar_tmp` SET `p5` = '".($recept['p5'])."',`pc5` = '".($ranp5)."' WHERE `id_user` = '$ku[id]' LIMIT 1");}
if($recept['s1']>0){
mysql_query("UPDATE `farm_sellar_tmp` SET `s1` = '".($recept['s1'])."',`sc1` = '".($rans1)."' WHERE `id_user` = '$ku[id]' LIMIT 1");}
if($recept['s2']>0){
mysql_query("UPDATE `farm_sellar_tmp` SET `s2` = '".($recept['s2'])."',`sc2` = '".($rans2)."' WHERE `id_user` = '$ku[id]' LIMIT 1");}
if($recept['s3']>0){
mysql_query("UPDATE `farm_sellar_tmp` SET `s3` = '".($recept['s3'])."',`sc3` = '".($rans3)."' WHERE `id_user` = '$ku[id]' LIMIT 1");}
if($recept['s4']>0){
mysql_query("UPDATE `farm_sellar_tmp` SET `s4` = '".($recept['s4'])."',`sc4` = '".($rans4)."' WHERE `id_user` = '$ku[id]' LIMIT 1");}
if($recept['s5']>0){
mysql_query("UPDATE `farm_sellar_tmp` SET `s5` = '".($recept['s5'])."',`sc5` = '".($rans5)."' WHERE `id_user` = '$ku[id]' LIMIT 1");}
mysql_query("UPDATE `farm_sellar_tmp` SET `time` = '".($rant)."' WHERE `id_user` = '".($ku['id'])."' LIMIT 1");
header("Location:/?mysellar&seat_all");exit;}
echo"<div class='event'><h1><a href='/?mysellar&seat_all'>Состав рецепта</a> / Книга рецептов</h1></div>";
echo "<div class='content'>";
echo "<div class='block'>";
echo "<ul class='ptm'>";
$k_post = mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_my_recept` WHERE `id_user` = '".($ku['id'])."'"),0);
if ($k_post==0){echo "пустo...";}
$k_page=k_page($k_post,3);
$page=page($k_page);
$start=3*$page-3;
if ($k_page>1)str("/?mysellar&seat_all&change_recept&",$k_page,$page); // Вывод страниц
$q=mysql_query("SELECT * FROM `farm_my_recept` WHERE `id_user` = '".($ku['id'])."' LIMIT $start,3");
if(mysql_num_rows($q)==0)echo "<li>Нет рецептов</li>";
while($post=mysql_fetch_array($q)){
$recept=mysql_fetch_array(mysql_query("SELECT * FROM `farm_recept` WHERE `id` = '".($post['id_rec'])."'"));
$r1=mysql_fetch_array(mysql_query("SELECT * FROM `farm_plant` WHERE `id` = '".($recept['p1'])."'"));
$r2=mysql_fetch_array(mysql_query("SELECT * FROM `farm_plant` WHERE `id` = '".($recept['p2'])."'"));
$r3=mysql_fetch_array(mysql_query("SELECT * FROM `farm_plant` WHERE `id` = '".($recept['p3'])."'"));
$r4=mysql_fetch_array(mysql_query("SELECT * FROM `farm_plant` WHERE `id` = '".($recept['p4'])."'"));
$r5=mysql_fetch_array(mysql_query("SELECT * FROM `farm_plant` WHERE `id` = '".($recept['p5'])."'"));
$u1=mysql_fetch_array(mysql_query("SELECT * FROM `farm_speci` WHERE `id` = '".($recept['s1'])."'"));
$u2=mysql_fetch_array(mysql_query("SELECT * FROM `farm_speci` WHERE `id` = '".($recept['s2'])."'"));
$u3=mysql_fetch_array(mysql_query("SELECT * FROM `farm_speci` WHERE `id` = '".($recept['s3'])."'"));
$u4=mysql_fetch_array(mysql_query("SELECT * FROM `farm_speci` WHERE `id` = '".($recept['s4'])."'"));
$u5=mysql_fetch_array(mysql_query("SELECT * FROM `farm_speci` WHERE `id` = '".($recept['s5'])."'"));
echo'<div>';
echo"<h3><a href='/?mysellar&seat_all&change_recept&select=$post[id]'><span>".hsc($recept['name'])."</span></a></h3>";
echo'<div><ul>';
if($recept['p1']>0){
echo"<li><img width='16' height='16' src='/images/icons/tomato.png' alt='o'> <span>".($r1['name'])."</span>: <span class='title'>".($recept['pc1_min'])."</span> - <span class='title'>".($recept['pc1_max'])."</span></li>";}
if($recept['p2']>0){
echo"<li><img width='16' height='16' src='/images/icons/tomato.png' alt='o'> <span>".($r2['name'])."</span>: <span class='title'>".($recept['pc2_min'])."</span> - <span class='title'>".($recept['pc2_max'])."</span></li>";}
if($recept['p3']>0){
echo"<li><img width='16' height='16' src='/images/icons/tomato.png' alt='o'> <span>".($r3['name'])."</span>: <span class='title'>".($recept['pc3_min'])."</span> - <span class='title'>".($recept['pc3_max'])."</span></li>";}
if($recept['p4']>0){
echo"<li><img width='16' height='16' src='/images/icons/tomato.png' alt='o'> <span>".($r4['name'])."</span>: <span class='title'>".($recept['pc4_min'])."</span> - <span class='title'>".($recept['pc4_max'])."</span></li>";}
if($recept['p5']>0){
echo"<li><img width='16' height='16' src='/images/icons/tomato.png' alt='o'> <span>".($r5['name'])."</span>: <span class='title'>".($recept['pc5_min'])."</span> - <span class='title'>".($recept['pc5_max'])."</span></li>";}
if($recept['s1']>0){
echo"<li><img width='16' height='16' src='/images/icons/addition.png' alt='o'> <span>".($u1['name'])."</span>: <span class='title'>".($recept['sc1_min'])."</span> - <span class='title'>".($recept['sc1_max'])."</span></li>";}
if($recept['s2']>0){
echo"<li><img width='16' height='16' src='/images/icons/addition.png' alt='o'> <span>".($u2['name'])."</span>: <span class='title'>".($recept['sc2_min'])."</span> - <span class='title'>".($recept['sc2_max'])."</span></li>";}
if($recept['s3']>0){
echo"<li><img width='16' height='16' src='/images/icons/addition.png' alt='o'> <span>".($u3['name'])."</span>: <span class='title'>".($recept['sc3_min'])."</span> - <span class='title'>".($recept['sc3_max'])."</span></li>";}
if($recept['s4']>0){
echo"<li><img width='16' height='16' src='/images/icons/addition.png' alt='o'> <span>".($u4['name'])."</span>: <span class='title'>".($recept['sc4_min'])."</span> - <span class='title'>".($recept['sc4_max'])."</span></li>";}
if($recept['s5']>0){
echo"<li><img width='16' height='16' src='/images/icons/addition.png' alt='o'> <span>".($u5['name'])."</span>: <span class='title'>".($recept['sc5_min'])."</span> - <span class='title'>".($recept['sc5_max'])."</span></li>";}
echo'</ul>';
echo"<div><img width='16' height='16' src='/images/icons/clock.png' alt='o'> Время <span class='title'>".time_rec($recept['time_min'])."</span> - <span class='title'>".time_rec($recept['time_max'])."</span></div>";
//echo"<div style='padding-bottom:8px;'><img width='16' height='16' src='/images/icons/last_recipes.png' alt='o'>Кулинарное мастерство: <span class='title'>".($post['master'])."</span><span class='minor'>(<span>Идеальный</span>)</span></div>";
echo"</div></div>";
}
if ($k_page>1)str("/?mysellar&seat_all&change_recept&",$k_page,$page); // Вывод страниц
echo "</ul></div>";
include_once 'sys/other/foot.php';
?>