User errorFor 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; ?>