Файл: vfermu.ru/sys/sellar/list_recept.php
Строк: 137
<?
if(isset($_GET['mysellar']) && isset($_GET['list_recept']))
{
echo "<title>Книга рецептов</title>";
$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,4);
$page=page($k_page);
$start=4*$page-4;
echo"<div class='event'><h1><a href='/?mysellar'>Погреб</a> / Книга рецептов</h1></div>";
echo "<div class='content'>";
echo "<div class='block'>";
echo "<ul class='ptm'>";
if ($k_page>1)str("/?mysellar&list_recept&",$k_page,$page); // Вывод страниц
$q=mysql_query("SELECT * FROM `farm_my_recept` WHERE `id_user` = '$ku[id]' LIMIT $start,4");
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><span>".hsc($recept['name'])."</span></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&list_recept&",$k_page,$page); // Вывод страниц
echo "</ul></div>";
include_once 'sys/other/foot.php';
}
?>