<?
   // =-------------------------
   // Parametry posilane v URL zredukuju jen na ty nutne

   $parametry=(
            ($id!=""       ? "&id=$id":"").
            ($admin!=""    ? "&admin=$admin":"").
            ($Jmeno!=""    ? "&Jmeno=$Jmeno":"").
            ($PodnikID!="" ? "&PodnikID=$PodnikID":"").
            ($Mesto!=0     ? "&Mesto=$Mesto":"").
            ($TypSexu!=0   ? "&TypSexu=$TypSexu":"").
            ($Vlasy!=0     ? "&Vlasy=$Vlasy":"").
            ($Vyska!=0     ? "&Vyska=$Vyska":"").
            ($Vaha!=0      ? "&Vaha=$Vaha":"").
            ($Dostupnost!=0? "&Dostupnost=$Dostupnost":"").
            ($CenaOd!=0    ? "&CenaOd=$CenaOd":"").
            ($CenaDo!=0    ? "&CenaDo=$CenaDo":"").
            ($Vek!=0       ? "&Vek=$Vek":"").
            ($PrsaCislo!=0 ? "&PrsaCislo=$PrsaCislo":""));

   if ($ac=="") $ac="z";
   $parametry.="&ac=$ac";

   if ($rand==0)
   {
      mt_srand((float)microtime()*1000000);
      $rand=mt_rand(0,999999);
      Header("Location: $PHP_SELF?rand=$rand$parametry");
      exit;
   }

   include('dbconnect.php');
   include('adresare.php');

   function str0($r) { return ($r<=9 ? "0" : "").$r; }

   $table=($ac=="z"?"Zeny":($ac=="m"?"Muzi":"Podniky"));

   if ($zobr==0) $zobr="10";
   if ($num==0)  $num=1;

   $letos=date("Y");

// =-----------------------------
// Nejdriv vytvorim samotny dotaz

$expr="sin($table.id*$rand) AS rnd, $table.id, Jmeno, ($letos-RokNarozeni) as Vek, PrsaCislo,
       Vyska, Vaha, CenaOd, CenaDo, Rozmery, Navstev, NavstevCelkem,
       PracDobaPoPaOd, PracDobaPoPaDo, PracDobaSoOd, PracDobaSoDo, PracDobaNeOd, PracDobaNeDo, PodnikID,
       Vlasy.Barva, Mesta.Mesto, Text, Kontakt, (UNIX_TIMESTAMP(AdmZaplacenoKdy)>0) as Platila ";

// =-----------------------------
// Vyberu z tabulek

$from="$table
LEFT JOIN Mesta ON MestoID=Mesta.id
LEFT JOIN Mezitable_dost_$ac ON Mezitable_dost_$ac.idPerson=$table.id
LEFT JOIN TypyDostupnosti ON Mezitable_dost_$ac.idTyp=TypyDostupnosti.id
LEFT JOIN Mezitable_sex_$ac ON Mezitable_sex_$ac.idPerson=$table.id
LEFT JOIN TypySexu ON Mezitable_sex_$ac.idTyp=TypySexu.id

LEFT JOIN Vlasy ON VlasyID=Vlasy.id

";

// =----------------------------
// Setridim podle nahody

$order="ORDER BY Platila DESC, rnd";

// =----------------------------
// Podminka dle hledani

if ($Jmeno!="") $wher.=" AND Jmeno LIKE \"$Jmeno%\" ";
if ($PodnikID!="") $wher.=" AND PodnikID = \"$PodnikID\" ";
if ($id!="") $wher.=" AND $table".".id=\"$id\" ";
if ($Mesto!=0) $wher.=" AND MestoID=\"$Mesto\" ";
if ($Vek!=0) $wher.=" AND ($letos-RokNarozeni) BETWEEN "
          .($Vek==1?"18 AND 20":"").($Vek==2?"21 AND 25":"")
          .($Vek==3?"26 AND 30":"").($Vek==4?"31 AND 35":"")
          .($Vek==5?"36 AND 40":"").($Vek==6?"41 AND 45":"")
          .($Vek==7?"46 AND 200":"");
if($PrsaCislo!=0) $wher.=" AND PrsaCislo=\"$PrsaCislo\" ";
if($Vlasy!=0) $wher.=" AND VlasyID=\"$Vlasy\" ";
if ($Vyska!=0) $wher.=" AND Vyska BETWEEN "
          .($Vyska==1?"0 AND 150":"")  .($Vyska==2?"151 AND 160":"")
          .($Vyska==3?"161 AND 170":"").($Vyska==4?"171 AND 180":"")
          .($Vyska==5?"181 AND 190":"").($Vyska==6?"190 AND 1000":"");
if ($Vaha!=0) $wher.=" AND Vaha BETWEEN "
          .($Vaha==1?"0 AND 50":"") .($Vaha==2?"51 AND 60":"")
          .($Vaha==3?"61 AND 70":"").($Vaha==4?"71 AND 80":"")
          .($Vaha==5?"81 AND 90":"").($Vaha==6?"90 AND 1000":"");
if ($CenaOd!=0) $wher.=" AND CenaOd>=$CenaOd ";
if ($CenaDo!=0) $wher.=" AND CenaDo<=$CenaDo ";
if ($TypSexu!=0) $wher.=" AND Mezitable_sex_$ac.idTyp=\"$TypSexu\" ";
if ($Dostupnost!=0) $wher.=" AND Mezitable_dost_$ac.idTyp=\"$Dostupnost\" ";

// =---------------------------
// PracDoba - zobrazim Dostupna nebo Nedostupna

$dnes=date("w"); $dnesDen=($dnes==0?"Ne":($dnes==6?"So":"PoPa"));
$dnes=date("H:i:s");
$avail=", ((PracDoba".$dnesDen."Od < '$dnes' AND PracDoba".$dnesDen."Do > '$dnes' AND PracDoba".$dnesDen."Do>PracDoba".$dnesDen."Od)
        OR (PracDoba".$dnesDen."Od < '$dnes' AND PracDoba".$dnesDen."Do > '$dnes' AND PracDoba".$dnesDen."Do<PracDoba".$dnesDen."Od)) AS Otevreno ";

// =--------------------------
// Doupraveni podminky hledani

if ($admin=="yes") $schvalWhere=" 1=1 "; else $schvalWhere=" AdmSchvaleno=1 " ;
$wher.=" AND ".$schvalWhere;
if ($wher!="") $wher="WHERE ".substr($wher,4);

// =--------------------------
// Neznam-li pocet celkem, udelam select bez LIMIT

if (!isset($celkem))
{
  $result=mysql_query("SELECT COUNT(*) FROM $from $wher GROUP BY $table.id");
  if (!$result) die(mysql_error());
  $celkem=mysql_numrows($result);
}

$limit="LIMIT ".(($num-1)*$zobr).",$zobr";

// =--------------------------
// Tak, a tady uz normalni select

$result=mysql_query("SELECT $expr $avail FROM $from $wher GROUP BY $table.id $order $limit");
if (!$result) die(mysql_error());
if (mysql_numrows($result)<1) echo "<P ALIGN=\"center\">".$strNicNenalezeno."</P>";

// -----------------------------------
// ZDE ZACINA VYPIS do browseru

include('top_html.php');

// -----------------------------------
// Pokud neni nalezen zadny zaznam

if (mysql_numrows($result)==0)
{
  echo "<BR><BR><BR><P ALIGN=\"center\">$strNicNenalezeno</P><BR><BR><BR>";
  include('bot_html.php');
  exit;
}

echo "<DIV ALIGN=\"center\"><CENTER>
      <TABLE BORDER=\"0\" CELLSPACING=\"0\" CELLPADDING=\"0\">";

// -----------------------------------
// Pokud je nalezen jen jeden zaznam

if (mysql_numrows($result)==1)
{
   echo "<TR><TD COLSPAN=\"3\">";
   $navig=number2("$PHP_SELF?rand=$rand&num=$num&celkem=$celkem&zobr=$zobr$parametry",$celkem);
   echo $navig;
   echo "</TD></TR>";
   echo hr2Coll(3);
   echo "<TR><TD COLSPAN=\"3\">&nbsp;</TD></TR>";

   $row=mysql_fetch_array($result); $id=$row[id];

   // typ sexu
   $resultSex=mysql_query("SELECT Typ FROM Mezitable_sex_$ac LEFT JOIN TypySexu ON idTyp=id WHERE idPerson='$id'");
   if (!$resultSex) die(mysql_error());
   while ($rowSex=mysql_fetch_row($resultSex)) $SexText.=$rowSex[0].", ";
   $SexText=substr($SexText,0,-2);

   // typ dostupnosti
   $doss= $ac=="p"?"Podniku":"Dostupnosti";
   $resultDost=mysql_query("SELECT Typ FROM Mezitable_dost_$ac LEFT JOIN Typy$doss ON idTyp=id WHERE idPerson='$id'");
   if (!$resultDost) die(mysql_error());
   while ($rowDost=mysql_fetch_row($resultDost)) $DostText.=$rowDost[0].", ";
   $DostText=substr($DostText,0,-2);

   // podnik id
   if ($ac!="p")
   {
     $resultPodnik=mysql_query("SELECT Jmeno FROM Podniky WHERE id=\"".$row[PodnikID]."\"");
     if (!$resultPodnik) die(mysql_error());
     $PodnikText=@mysql_result($resultPodnik,0,Jmeno);
     if ($PodnikText!="") $PodnikText="<A HREF=\"$PHP_SELF?ac=p&id=".$row[PodnikID]."\">".$PodnikText."</A>";
   }

   echo "<TR><TD VALIGN=\"top\"><A HREF=\"ukazpics.php?id=$id&ac=$ac&num=1&name=$row[Jmeno]\"><IMG SRC=\"".$picadr.$ac."/".$id."/00.jpg\"></A>".
        "<BR CLEAR=\"all\"><BR><A TITLE=\"$strClickHereForMoreInfo\" HREF=\"#\" ONCLICK=\"ShowURL('legal.php');\"> ".($row[Platila]?"$strOvereno":"$strNeOvereno")."</A>".
        "</TD><TD>&nbsp;&nbsp;&nbsp;</TD><TD VALIGN=\"top\">

   <TABLE CELLSPACING=\"3\" CELLPADDING=\"0\">
   <TR><TD ALIGN=\"right\">$strID:</TD><TD><B>$row[id]</B></TD></TR>
   <TR><TD ALIGN=\"right\">$strJmeno:</TD><TD><B>$row[Jmeno]</B></TD></TR>
   ".($PodnikText!=""?"<TR><TD ALIGN=\"right\">$strPodnik:</TD><TD><B>$PodnikText</B></TD></TR>":"")."
   <TR><TD ALIGN=\"right\">$strMesto:</TD><TD><B>$row[Mesto]</B></TD></TR>
   <TR><TD ALIGN=\"right\">$strKontakt:</TD><TD><B>$row[Kontakt]</B></TD></TR>
   <TR><TD ALIGN=\"right\">&nbsp;</TD><TD>&nbsp;</TD></TR>
".($ac!="p"?("
   <TR><TD ALIGN=\"right\">$strVek:</TD><TD><B>$row[Vek]</B></TD></TR>
   <TR><TD ALIGN=\"right\">$strVlasy:</TD><TD><B>$row[Barva]</B></TD></TR>
   <TR><TD ALIGN=\"right\">$strVyska:</TD><TD><B>$row[Vyska]</B></TD></TR>
   <TR><TD ALIGN=\"right\">$strVaha:</TD><TD><B>$row[Vaha]</B></TD></TR>
"):"")."
".($ac=="z"?("
   <TR><TD ALIGN=\"right\">$strPrsaCislo:</TD><TD><B>$row[PrsaCislo]</B></TD></TR>
   ".($row[Rozmery]!=""?"<TR><TD ALIGN=\"right\">$strRozmery:</TD><TD><B>$row[Rozmery]</B></TD></TR>":""))
:"")."
   <TR><TD ALIGN=\"right\">Ceny:</TD><TD><B>od $row[CenaOd] do $row[CenaDo]</B></TD></TR>
   <TR><TD ALIGN=\"right\" VALIGN=\"top\">".($ac!="p"?$strDostupnost:$strTypPodniku).":</TD><TD><B>".wordwrap($DostText,20,"<BR>")."</B></TD></TR>
   <TR><TD ALIGN=\"right\" VALIGN=\"top\">$strTypSexu:</TD><TD><B>".wordwrap($SexText,20,"<BR>")."</B></TD></TR>
   <TR><TD>&nbsp;</TD><TD>&nbsp;</TD></TR>
   <TR><TD ALIGN=\"right\">$strPoPa:</TD><TD><B>".pracdoba($row[PracDobaPoPaOd],$row[PracDobaPoPaDo])."</B></TD></TR>
   <TR><TD ALIGN=\"right\">$strSo:</TD><TD><B>".pracdoba($row[PracDobaSoOd],$row[PracDobaSoDo])."</B></TD></TR>
   <TR><TD ALIGN=\"right\">$strNe:</TD><TD><B>".pracdoba($row[PracDobaNeOd],$row[PracDobaNeDo])."</B></TD></TR>
   </TABLE>

   <!-- 4 Navstev
        15 NavstevCelkem  -->

   </TD></TR><TR><TD COLSPAN=\"3\"><BR>".nl2br(wordwrap($row[Text],70))."<BR><BR></TD></TR>";

// =----------------------------
// a tady zobrazit nahledy

   echo "<TR><TD COLSPAN=\"3\" ALIGN=\"center\">";

   $count=0;
   $folder=$picadr.$ac."/".$id."/";
   $d=opendir($folder);
   while($file=readdir($d)) if (substr($file,0,1)=="n" && $file!="n01.jpg")
   {
     $count++;
     echo "<A HREF=\"ukazpics.php?num=".($count+1)."&ac=$ac&id=$id&name=$row[Jmeno]\"><IMG SRC=\"$folder"."$file\" VSPACE=\"5\" HSPACE=\"5\"></A>";
     if ( ($count % 5) == 0) echo "<BR>";
   }
   closedir($d);

   echo "</TD></TR>";

// =----------------------------
// a tady - pokud jde o podnik - se musi zobrazit PERSONAL

   $CisloPodniku=$row[id];
//   $rand=1;

   if ($ac=="p")
   {
     $result=mysql_query("SELECT sin(id*$rand) AS rnd, id FROM Zeny WHERE PodnikID=\"$CisloPodniku\" AND $schvalWhere ORDER BY rnd");
     if (!$result) Die(mysql_error());
     $celkem=mysql_numrows($result);

     $i=0;
     while ($row=mysql_fetch_array($result))
     { $i++;
       $zp.="<A HREF=\"find.php?rand=$rand&num=$i&zobr=1&celkem=$celkem&ac=z&PodnikID=$CisloPodniku\"><IMG SRC=\"$picadr/z/$row[id]/n01.jpg\" VSPACE=\"5\" HSPACE=\"5\"></A>";
       if ($i % 5 == 0) $zp.="<BR>";
     }

     if ($zp!="") echo "<TR><TD COLSPAN=\"3\" ALIGN=\"center\"><BR><BR>$strZenskyPersonal:<BR><BR>$zp</TD></TR>";

     $result=mysql_query("SELECT sin(id*$rand) AS rnd, id FROM Muzi WHERE PodnikID=\"$CisloPodniku\" AND $schvalWhere ORDER BY rnd");
     if (!$result) Die(mysql_error());
     $celkem=mysql_numrows($result);

     $i=0;
     while ($row=mysql_fetch_array($result))
     { $i++;
       $mp.="<A HREF=\"find.php?rand=$rand&num=$i&zobr=1&celkem=$celkem&ac=m&PodnikID=$CisloPodniku\"><IMG SRC=\"$picadr/m/$row[id]/n01.jpg\" VSPACE=\"5\" HSPACE=\"5\"></A>";
       if ($i % 5 == 0) $mp.="<BR>";
     }

     if ($mp!="") echo "<TR><TD COLSPAN=\"3\" ALIGN=\"center\"><BR><BR>$strMuzskyPersonal:<BR><BR>$mp</TD></TR>";
   }

   echo "<TR><TD COLSPAN=3><BR><BR>".wordwrap($strBonus,70,"<BR>")."</TD></TR>";
   echo hr2coll(3);

   echo "</TABLE></CENTER></DIV><BR><BR>";
   include('bot_html.php');
   flush();

   $result=mysql_query("UPDATE $table SET Navstev=Navstev+1");
   if (!$result) Die(mysql_error());

   exit;
}

// =-----------------------------------
// No a jestli se naslo vic nez jeden,
// tak to ukaze seznam.

$strop=$celkem/$zobr; if (floor($strop)!=$strop) $strop=floor($strop)+1;
$navig=numbers("$PHP_SELF?rand=$rand&num=$num&celkem=$celkem&zobr=$zobr$parametry",$strop);

echo "<TR><TD ALIGN=\"center\" COLSPAN=\"5\">$navig</TD></TR>";
echo hr2coll(5);

$count=0; // abych vedel na kolikate sem polozce, abych mohl cislovat

@mysql_data_seek($result,0);
while($row=mysql_fetch_array($result))
{
  $count ++;

  $aktual=(($num-1)*$zobr+$count);
  $odkaz="$PHP_SELF?rand=$rand&num=$aktual&zobr=1&celkem=$celkem".$parametry;
  $PracDoba="$strPracovniDoba:";
  if ($row[PracDobaPoPaOd]!="00:00" || $row[PracDobaPoPaDo]!="00:00") $PracDoba.=" $strPoPa: ".pracdoba($row[PracDobaPoPaOd],$row[PracDobaPoPaDo]);
  if ($row[PracDobaSoOd]!="00:00" || $row[PracDobaSoDo]!="00:00") $PracDoba.=" $strSo: ".pracdoba($row[PracDobaSoOd],$row[PracDobaSoDo]);
  if ($row[PracDobaNeOd]!="00:00" || $row[PracDobaNeDo]!="00:00") $PracDoba.=" $strNe: ".pracdoba($row[PracDobaNeOd],$row[PracDobaNeDo]);

  echo "<TR><TD VALIGN=\"top\" ALIGN=\"left\"><H2><BR>".$aktual.".</H2><BR><BR></TD>".
       "<TD ALIGN=\"center\"><A HREF=\"$odkaz\"><IMG SRC=\"$picadr".$ac."/".$row[id]."/n01.jpg\" BORDER=\"1\" HSPACE=\"20\" VSPACE=\"5\"></A></TD>".
       "<TD ALIGN=\"left\"><A HREF=\"$odkaz\"><B>$row[Jmeno]</B></A> ($row[id]), $strMesto: $row[Mesto]<BR>".
       "$strVek: $row[Vek] let, $strVyska: $row[Vyska] cm, $strVaha: $row[Vaha] kg<BR>".
       ($ac=="z"?"$strPrsaCislo: $row[PrsaCislo] $strRozmery: $row[Rozmery]<BR>":"").
       "$PracDoba <BR><A TITLE=\"$strClickHereForMoreInfo\" HREF=\"#\" ONCLICK=\"ShowURL('legal.php');\"> ".($row[Platila]?"$strOvereno":"$strNeOvereno")."</A>".
       "$strStrankuNavstivilo </TD>".
       "<TD>&nbsp;&nbsp;&nbsp;</TD>".
       "<TD ALIGN=\"left\" VALIGN=\"top\">&nbsp;<IMG SRC=\"$imgurl/".($row[Otevreno]==0?"d2.gif":"d1.gif")."\" BORDER=\"0\" ALT=\"".($row[Otevreno]==0?"$strZavreno":"$strOtevreno")."\"></TD></TR>";
  echo hrColl(5);
}

echo "<TR><TD ALIGN=\"center\" COLSPAN=\"5\">";
echo $navig;
echo "</TD></TR>";
echo hr2coll(5);
echo "<TR><TD COLSPAN=\"5\" ALIGN=\"center\">
<IMG SRC=\"$imgurl/d1.gif\" ALIGN=\"middle\"> = $strTedOtevreno
<IMG SRC=\"$imgurl/d2.gif\" ALIGN=\"middle\"> = $strTedZavreno
</TD></TR>";
echo "</TABLE></CENTER></DIV><BR>";

include('bot_html.php');

?>