<?

  session_start();

  $die_text = "<h1>User error</h1>For generate this PDF document use link from buy-auto.eu website.";
  //$ad = 142;
  if(empty($ad))   die("1".$die_text);
  if(empty($_SESSION['lang'])) die("2".$die_text);

  if(file_exists("languages/".$_SESSION['lang']."/index_".$_SESSION['lang'].".php"))
     require("languages/".$_SESSION['lang']."/index_".$_SESSION['lang'].".php");
  else
     die("3".$die_text);

  require('pdf/fpdf.php');
  require("funkce/user.php");

  $DBHost="c172um.forpsi.com";
  $DBUser="buy_autoeu";
  $DBPass="bEFrk346";
  $konto=@mysql_connect("$DBHost","$DBUser","$DBPass");
  if(!$konto):
    die("4".$die_text);
  else:
    MySQL_Select_DB("buy_autoeu");
  endif;


  $ad = (int) $ad;

  $sql = "SELECT *
          FROM `inzeraty_vypis`, `inzeraty_vybava`
          WHERE 1
                AND (`aktivni` = 1)
                AND (inzeraty_vybava.id = inzeraty_vypis.id)
                AND (inzeraty_vypis.id = $ad)";

  $v = MySQL_Fetch_Array(MySQL_Query($sql));

  if(!$v): die("5".$die_text);

  elseif($v["aktivni"] == 0): die("6".$die_text);

  else:

  /// --- VŠECHNO OK, DATA NAČTENA Z DB --

  $pdf=new FPDF('P','mm','A4');
  $pdf->AddPage();
  $pdf->Image('images/biglogo.png',10,10, 60,9, "PNG","http://www.buy-auto.eu/");

  $pdf->SetFont('Arial','IB',22);
  $pdf->SetTextColor(200,4,28);

  $pdf->Cell(10,50,SubStr($v["vypis"],0,35));


  $pdf->SetTextColor(0,0,0);
  $pdf->SetFont('Arial','',10);

  $pdf->Write(5,"\n\n\n\n\n\n\n");

  // cena

  $pdf->SetFont('Arial','B',10);
  $pdf->Write(5,"$text_ad_pu_8: ");
  $pdf->SetFont('Arial','',10);
  $pdf->Write(5,Number_Format($v["cena"], 0, "", ".")." EUR\n");

  // cena pro export

  if($v["cena_export"]):

  $pdf->SetFont('Arial','B',10);
  $pdf->Write(5,"$text_ad_pu_106: ");
  $pdf->SetFont('Arial','',10);
  $pdf->Write(5,Number_Format($v["cena_export"], 0, "", ".")." EUR\n");

  endif;

  // kategorie

  $pdf->SetFont('Arial','B',10);
  $pdf->Write(5,"$text_ad_pu_1: ");

            switch($v["kategorie"]):

                    case 1:
                         $kat = $text_ad_pu_2;
                         break;
                    case 2:
                         $kat = $text_ad_pu_3;
                         break;
                    case 3:
                         $kat = $text_ad_pu_4;
                         break;
                    case 4:
                         $kat = $text_ad_pu_5;
                         break;

            endswitch;

  $pdf->SetFont('Arial','',10);
  $pdf->Write(5,"$kat \n");

  // země prodeje

  $pdf->SetFont('Arial','B',10);
  $pdf->Write(5,"$text_ad_pu_65a: ");
  $pdf->SetFont('Arial','',10);
  $pdf->Write(5,$v["zeme"]. "\n");

  // karoserie

              switch($v["karoserie"]):

                    case 1:
                         $kar = $text_ad_pu_22;
                         break;
                    case 2:
                         $kar = $text_ad_pu_23;
                         break;
                    case 3:
                         $kar = $text_ad_pu_24;
                         break;
                    case 4:
                         $kar = $text_ad_pu_25;
                         break;
                    case 5:
                         $kar = $text_ad_pu_26;
                         break;
                    case 6:
                         $kar = $text_ad_pu_27;
                         break;
                    case 7:
                         $kar = $text_ad_pu_28;
                         break;
                    case 8:
                         $kar = $text_ad_pu_29;
                         break;
                    case 9:
                         $kar = $text_ad_pu_30;
                         break;
              endswitch;

  $pdf->SetFont('Arial','B',10);
  $pdf->Write(5,"$text_ad_pu_21: ");
  $pdf->SetFont('Arial','',10);
  $pdf->Write(5,$kar. "\n");


  // barva

  if($v["barva_2"]):

              switch($v["barva_2"]):

                      case 1:
                           $bar1 = $text_ad_pu_51;
                           break;
                      case 2:
                           $bar1 = $text_ad_pu_52;
                           break;
                      case 3:
                           $bar1 = $text_ad_pu_53;
                           break;
                      case 4:
                           $bar1 = $text_ad_pu_54;
                           break;
                      case 5:
                           $bar1 = $text_ad_pu_55;
                           break;
                      case 6:
                           $bar1 = $text_ad_pu_56;
                           break;
                      case 7:
                           $bar1 = $text_ad_pu_57;
                           break;
                      case 8:
                           $bar1 = $text_ad_pu_58;
                           break;
                      case 9:
                           $bar1 = $text_ad_pu_59;
                           break;
                      case 10:
                           $bar1 = $text_ad_pu_60;
                           break;
                      case 11:
                           $bar1 = $text_ad_pu_61;
                           break;
                      case 12:
                           $bar1 = $text_ad_pu_62;
                           break;
                      case 13:
                           $bar1 = $text_ad_pu_63;
                           break;
                      case 14:
                           $bar1 = $text_ad_pu_64;
                           break;
              endswitch;

              switch($v["barva_1"]):

                      case 1:
                           $bar2 = $text_ad_pu_47;
                           break;
                      case 2:
                           $bar2 = $text_ad_pu_48;
                           break;
                      case 3:
                           $bar2 = $text_ad_pu_49;
                           break;
                      case 4:
                           $bar2 = $text_ad_pu_50;
                           break;

              endswitch;


  $pdf->SetFont('Arial','B',10);
  $pdf->Write(5,"$text_ad_pu_46: ");
  $pdf->SetFont('Arial','',10);
  $pdf->Write(5,$bar1." ".$bar2."\n");

  endif;

  // rok

  $pdf->SetFont('Arial','B',10);
  $pdf->Write(5,"$text_ad_pu_12: ");
  $pdf->SetFont('Arial','',10);
  $pdf->Write(5,$v["rok"]."\n");

  // do provozu

  if($v["doprovozu"]):

  $pdf->SetFont('Arial','B',10);
  $pdf->Write(5,"$text_ad_pu_33: ");
  $pdf->SetFont('Arial','',10);
  if($v["doprovozu_m"]) $pdf->Write(5,$v["doprovozu_m"]."/");
  $pdf->Write(5,$v["doprovozu"]."\n");

  endif;

  // najeto

  if($v["najeto_unit"] == 1)
      $mil = Number_Format($v["najeto_km"], 0, "", ".")." km";
  else
      $mil = Number_Format($v["najeto_mi"], 0, "", ".")." mi";

  $pdf->SetFont('Arial','B',10);
  $pdf->Write(5,"$text_ad_pu_9: ");
  $pdf->SetFont('Arial','',10);
  $pdf->Write(5,$mil."\n");

  // stav

  if($v["stav"]):


                  switch($v["stav"]):

                      case 1:
                           $stav = $text_ad_pu_35;
                           break;
                      case 2:
                           $stav = $text_ad_pu_36;
                           break;
                      case 3:
                           $stav = $text_ad_pu_37;
                           break;
                      case 4:
                           $stav = $text_ad_pu_38;
                           break;
                      case 5:
                           $stav = $text_ad_pu_39;
                           break;
                      case 6:
                           $stav = $text_ad_pu_40;
                           break;

                  endswitch;

  $pdf->SetFont('Arial','B',10);
  $pdf->Write(5,"$text_ad_pu_34: ");
  $pdf->SetFont('Arial','',10);
  $pdf->Write(5,$stav."\n");

  endif;

  // palivo


              switch($v["palivo"]):
                    case 1:
                         $pal = $text_ad_pu_14;
                         break;
                    case 2:
                         $pal = $text_ad_pu_15;
                         break;
                    case 3:
                         $pal = $text_ad_pu_16;
                         break;
                    case 4:
                         $pal = $text_ad_pu_17;
                         break;
              endswitch;

  $pdf->SetFont('Arial','B',10);
  $pdf->Write(5,"$text_ad_pu_13: ");
  $pdf->SetFont('Arial','',10);
  $pdf->Write(5,$pal."\n");

  // objem

  if($v["objem"]):

  $pdf->SetFont('Arial','B',10);
  $pdf->Write(5,"$text_ad_pu_42: ");
  $pdf->SetFont('Arial','',10);
  $pdf->Write(5,Number_Format($v["objem"], 0, "", ".")." ccm \n");

  endif;

  // vykon

  if($v["vykon_kw"]):

  $pdf->SetFont('Arial','B',10);
  $pdf->Write(5,"$text_ad_pu_208: ");
  $pdf->SetFont('Arial','',10);
  $pdf->Write(5,Number_Format($v["vykon_kw"], 0, "", ".")." kW (".Number_Format($v["vykon_ps"], 0, "", ".")." hp)  \n");

  endif;

  // válce

  if($v["valce"]):

  $pdf->SetFont('Arial','B',10);
  $pdf->Write(5,"$text_ad_pu_43: ");
  $pdf->SetFont('Arial','',10);
  $pdf->Write(5,"V".$v["valce"]."  \n");

  endif;

  // prevodovka

  switch($v["prevodovka"]):

                    case 1:
                         $ger = $text_ad_pu_19;
                         break;
                    case 2:
                         $ger = $text_ad_pu_20;
                         break;

  endswitch;

  $pdf->SetFont('Arial','B',10);
  $pdf->Write(5,"$text_ad_pu_18: ");
  $pdf->SetFont('Arial','',10);
  $pdf->Write(5,$ger);
  if($v["prevody"]) $pdf->Write(5," ".$v["prevody"]."°");
  $pdf->Write(5,"\n");

  // původ

  if($v["puvod"]):

  $pdf->SetFont('Arial','B',10);
  $pdf->Write(5,"$text_ad_pu_65: ");
  $pdf->SetFont('Arial','',10);
  $pdf->Write(5,$v["puvod"]." \n");

  endif;

  // dveře

  if($v["dvere"]):

  $pdf->SetFont('Arial','B',10);
  $pdf->Write(5,"$text_ad_pu_44: ");
  $pdf->SetFont('Arial','',10);
  $pdf->Write(5,$v["dvere"]." \n");

  endif;

  // sezeni

  if($v["sezeni"]):

  $pdf->SetFont('Arial','B',10);
  $pdf->Write(5,"$text_ad_pu_45: ");
  $pdf->SetFont('Arial','',10);
  $pdf->Write(5,$v["sezeni"]."\n");

  endif;

  // původ

  if($v["zaruka"]):

  $pdf->SetFont('Arial','B',10);
  $pdf->Write(5,"$text_ad_pu_105: ");
  $pdf->SetFont('Arial','',10);
  $pdf->Write(5,$v["zaruka"]." ".$text_ad_pu_105c."\n");

  endif;

  // výbava
  $pdf->SetFont('Arial','B',10);
  $pdf->Write(5,"$text_ad_lista_3: ");
  $pdf->SetFont('Arial','',10);

              if($v["b1"]) { $pdf->Write(5,$text_ad_pu_115.", "); ++$vyb; }
              if($v["b2"]) { $pdf->Write(5,$text_ad_pu_116.", "); ++$vyb; }
              if($v["b3"]) { $pdf->Write(5,$text_ad_pu_117.", "); ++$vyb; }
              if($v["b4"]) { $pdf->Write(5,$text_ad_pu_118.", "); ++$vyb; }
              if($v["b5"]) { $pdf->Write(5,$text_ad_pu_119.", "); ++$vyb; }
              if($v["b6"]) { $pdf->Write(5,$text_ad_pu_120.", "); ++$vyb; }
              if($v["b7"]) { $pdf->Write(5,$text_ad_pu_121.", "); ++$vyb; }
              if($v["b8"]) { $pdf->Write(5,$text_ad_pu_122.", "); ++$vyb; }
              if($v["b9"]) { $pdf->Write(5,$text_ad_pu_123.", "); ++$vyb; }
              if($v["b10"]) { $pdf->Write(5,$text_ad_pu_124.", "); ++$vyb; }
              if($v["b11"]) { $pdf->Write(5,$text_ad_pu_125.", "); ++$vyb; }
              if($v["b12"]) { $pdf->Write(5,$text_ad_pu_126.", "); ++$vyb; }
              if($v["b13"]) { $pdf->Write(5,$text_ad_pu_127.", "); ++$vyb; }
              if($v["b14"]) { $pdf->Write(5,$text_ad_pu_128.", "); ++$vyb; }
              if($v["b15"]) { $pdf->Write(5,$text_ad_pu_129.", "); ++$vyb; }
              if($v["b16"]) { $pdf->Write(5,$text_ad_pu_130.", "); ++$vyb; }
              if($v["b17"]) { $pdf->Write(5,$text_ad_pu_131.", "); ++$vyb; }
              if($v["b18"]) { $pdf->Write(5,$text_ad_pu_132.", "); ++$vyb; }
              if($v["b19"]) { $pdf->Write(5,$text_ad_pu_133.", "); ++$vyb; }

              if($v["a1"]) { $pdf->Write(5,$text_ad_pu_135.", "); ++$vyb; }
              if($v["a2"]) { $pdf->Write(5,$text_ad_pu_136.", "); ++$vyb; }
              if($v["a3"]) { $pdf->Write(5,$text_ad_pu_137.", "); ++$vyb; }
              if($v["a4"]) { $pdf->Write(5,$text_ad_pu_138.", "); ++$vyb; }
              if($v["a5"]) { $pdf->Write(5,$text_ad_pu_139.", "); ++$vyb; }
              if($v["a6"]) { $pdf->Write(5,$text_ad_pu_140.", "); ++$vyb; }
              if($v["a7"]) { $pdf->Write(5,$text_ad_pu_141.", "); ++$vyb; }
              if($v["a8"]) { $pdf->Write(5,$text_ad_pu_142.", "); ++$vyb; }
              if($v["a9"]) { $pdf->Write(5,$text_ad_pu_143.", "); ++$vyb; }
              if($v["a10"]) { $pdf->Write(5,$text_ad_pu_144.", "); ++$vyb; }

              if($v["z1"]) { $pdf->Write(5,$text_ad_pu_146.", "); ++$vyb; }
              if($v["z2"]) { $pdf->Write(5,$text_ad_pu_147.", "); ++$vyb; }
              if($v["z3"]) { $pdf->Write(5,$text_ad_pu_148.", "); ++$vyb; }
              if($v["z4"]) { $pdf->Write(5,$text_ad_pu_149.", "); ++$vyb; }
              if($v["z5"]) { $pdf->Write(5,$text_ad_pu_150.", "); ++$vyb; }
              if($v["z6"]) { $pdf->Write(5,$text_ad_pu_151.", "); ++$vyb; }
              if($v["z7"]) { $pdf->Write(5,$text_ad_pu_152.", "); ++$vyb; }
              if($v["z8"]) { $pdf->Write(5,$text_ad_pu_153.", "); ++$vyb; }

              if($v["v1"]) { $pdf->Write(5,$text_ad_pu_155.", "); ++$vyb; }
              if($v["v2"]) { $pdf->Write(5,$text_ad_pu_156.", "); ++$vyb; }
              if($v["v3"]) { $pdf->Write(5,$text_ad_pu_157.", "); ++$vyb; }
              if($v["v4"]) { $pdf->Write(5,$text_ad_pu_158.", "); ++$vyb; }
              if($v["v5"]) { $pdf->Write(5,$text_ad_pu_159.", "); ++$vyb; }
              if($v["v6"]) { $pdf->Write(5,$text_ad_pu_160.", "); ++$vyb; }
              if($v["v7"]) { $pdf->Write(5,$text_ad_pu_161.", "); ++$vyb; }
              if($v["v8"]) { $pdf->Write(5,$text_ad_pu_162.", "); ++$vyb; }
              if($v["v9"]) { $pdf->Write(5,$text_ad_pu_163.", "); ++$vyb; }
              if($v["v10"]) { $pdf->Write(5,$text_ad_pu_164.", "); ++$vyb; }
              if($v["v11"]) { $pdf->Write(5,$text_ad_pu_165.", "); ++$vyb; }
              if($v["v12"]) { $pdf->Write(5,$text_ad_pu_166.", "); ++$vyb; }
              if($v["v13"]) { $pdf->Write(5,$text_ad_pu_167.", "); ++$vyb; }
              if($v["v14"]) { $pdf->Write(5,$text_ad_pu_168.", "); ++$vyb; }

              if($v["i1"]) { $pdf->Write(5,$text_ad_pu_170.", "); ++$vyb; }
              if($v["i2"]) { $pdf->Write(5,$text_ad_pu_171.", "); ++$vyb; }
              if($v["i3"]) { $pdf->Write(5,$text_ad_pu_172.", "); ++$vyb; }
              if($v["i4"]) { $pdf->Write(5,$text_ad_pu_173.", "); ++$vyb; }
              if($v["i5"]) { $pdf->Write(5,$text_ad_pu_174.", "); ++$vyb; }
              if($v["i6"]) { $pdf->Write(5,$text_ad_pu_175.", "); ++$vyb; }
              if($v["i7"]) { $pdf->Write(5,$text_ad_pu_176.", "); ++$vyb; }
              if($v["i8"]) { $pdf->Write(5,$text_ad_pu_177.", "); ++$vyb; }
              if($v["i9"]) { $pdf->Write(5,$text_ad_pu_178.", "); ++$vyb; }
              if($v["i10"]) { $pdf->Write(5,$text_ad_pu_179.", "); ++$vyb; }
              if($v["i11"]) { $pdf->Write(5,$text_ad_pu_180.", "); ++$vyb; }
              if($v["i12"]) { $pdf->Write(5,$text_ad_pu_181.", "); ++$vyb; }
              if($v["i13"]) { $pdf->Write(5,$text_ad_pu_182.", "); ++$vyb; }
              if($v["i14"]) { $pdf->Write(5,$text_ad_pu_183.", "); ++$vyb; }
              if($v["i15"]) { $pdf->Write(5,$text_ad_pu_184.", "); ++$vyb; }

              if($v["j1"]) { $pdf->Write(5,$text_ad_pu_186.", "); ++$vyb; }
              if($v["j2"]) { $pdf->Write(5,$text_ad_pu_187.", "); ++$vyb; }
              if($v["j3"]) { $pdf->Write(5,$text_ad_pu_188.", "); ++$vyb; }
              if($v["j4"]) { $pdf->Write(5,$text_ad_pu_189.", "); ++$vyb; }
              if($v["j5"]) { $pdf->Write(5,$text_ad_pu_190.", "); ++$vyb; }
              if($v["j6"]) { $pdf->Write(5,$text_ad_pu_191.", "); ++$vyb; }
              if($v["j7"]) { $pdf->Write(5,$text_ad_pu_192.", "); ++$vyb; }
              if($v["j8"]) { $pdf->Write(5,$text_ad_pu_193.", "); ++$vyb; }
              if($v["j9"]) { $pdf->Write(5,$text_ad_pu_194.", "); ++$vyb; }
              if($v["j10"]) { $pdf->Write(5,$text_ad_pu_195.", "); ++$vyb; }
              if($v["j11"]) { $pdf->Write(5,$text_ad_pu_196.", "); ++$vyb; }

              if($v["o1"]) { $pdf->Write(5,$text_ad_pu_198.", "); ++$vyb; }
              if($v["o2"]) { $pdf->Write(5,$text_ad_pu_199.", "); ++$vyb; }
              if($v["o3"]) { $pdf->Write(5,$text_ad_pu_200.", "); ++$vyb; }
              if($v["o4"]) { $pdf->Write(5,$text_ad_pu_201.", "); ++$vyb; }
              if($v["o5"]) { $pdf->Write(5,$text_ad_pu_202.", "); ++$vyb; }
              if($v["o6"]) { $pdf->Write(5,$text_ad_pu_203.", "); ++$vyb; }
              if($v["o7"]) { $pdf->Write(5,$text_ad_pu_204.", "); ++$vyb; }
              if($v["o8"]) { $pdf->Write(5,$text_ad_pu_205.", "); ++$vyb; }
              if($v["o9"]) { $pdf->Write(5,$text_ad_pu_206.", "); ++$vyb; }
              if($v["o10"]) { $pdf->Write(5,$text_ad_pu_209.", "); ++$vyb; }
              if($v["o11"]) { $pdf->Write(5,$text_ad_pu_210.", "); ++$vyb; }


              if($vyb)
                  $pdf->Write(5,"\n");
              else
                  $pdf->Write(5,$pdf_t1."\n");

              // financování

              if( $v["f_hotovost"]
                  or $v["f_prevod"]
                  or $v["f_karta"]
                  or $v["f_uver"]
                  or $v["f_leasing"]
                  or $v["f_operleasing"]
                  or $v["f_protiucet"]
                  or $v["f_dph"]):


                     $pdf->SetFont('Arial','B',10);
                     $pdf->Write(5,"$text_ad_pu_107: ");
                     $pdf->SetFont('Arial','',10);


                  if($v["f_hotovost"]) $pdf->Write(5,$text_ad_pu_108.", ");
                  if($v["f_prevod"]) $pdf->Write(5,$text_ad_pu_109.", ");
                  if($v["f_karta"]) $pdf->Write(5,$text_ad_pu_109b.", ");
                  if($v["f_uver"]) $pdf->Write(5,$text_ad_pu_110.", ");
                  if($v["f_leasing"]) $pdf->Write(5,$text_ad_pu_111.", ");
                  if($v["f_operleasing"]) $pdf->Write(5,$text_ad_pu_112.", ");
                  if($v["f_protiucet"]) $pdf->Write(5,$text_ad_pu_113.", ");
                  if($v["f_dph"]) $pdf->Write(5,$text_ad_pu_113a);

                  $pdf->Write(5,"\n\n");

              else: $pdf->Write(5,"\n");

              endif;

              $pocetobr = pocetobrazku($v["id"]);
              if($pocetobr):

                 $updir = (string) ((int) ($id/1000));

                 $pdf->Image('photos/'.$updir.'/'.$v["id"].'/1-1.jpg',130,45, 0,48, "JPG");


              endif;


  $pdf->SetFont('Arial','B',10);
  $pdf->Write(5,"$pdf_t2: ");
  $pdf->SetFont('Arial','',10);
  $pdf->Write(5,"http://www.buy-auto.eu/index.php?page=advertiser&user=".$v["uzivatel"]."\n","http://www.buy-auto.eu/index.php?page=advertiser&user=".$v["uzivatel"]);

  $pdf->SetFont('Arial','B',10);
  $pdf->Write(5,"$pdf_t3: ");
  $pdf->SetFont('Arial','',10);
  $pdf->Write(5,"http://www.buy-auto.eu/index.php?page=ad_detail&ad=".$v["id"]."\n","http://www.buy-auto.eu/index.php?page=ad_detail&ad=".$v["id"]);

  $pdf->SetFont('Arial','B',10);
  $pdf->Write(5,"$pdf_t4: ");
  $pdf->SetFont('Arial','',10);
  $pdf->Write(5,date("m.d.y G:i:s T")."\n\n");

  $pdf->SetFont('Arial','I',5);
  $pdf->Write(5,"Copyright © 2006-".date("y")." Buy-auto.eu");

  $pdf->Output();

  endif;

?>