langid' LIMIT 1"); if (mysqli_num_rows($_sprache2Q)>0) { $_sprache2=mysqli_fetch_object($_sprache2Q); } else { $_sprache2=mysqli_fetch_object(mysqli_query($thisDB, "SELECT * FROM www_sprachen_statics ORDER BY (SELECT reihenfolge FROM www_sprachen WHERE www_sprachen_statics.langid=www_sprachen.langid LIMIT 1) asc LIMIT 1")); } $_sprache3Q=mysqli_query($thisDB, "SELECT * FROM www_sprachen_statics2 WHERE langid='$_sprache->langid' LIMIT 1"); if (mysqli_num_rows($_sprache3Q)>0) { $_sprache3=mysqli_fetch_object($_sprache3Q); } else { $_sprache3=mysqli_fetch_object(mysqli_query($thisDB, "SELECT * FROM www_sprachen_statics2 ORDER BY (SELECT reihenfolge FROM www_sprachen WHERE www_sprachen_statics2.langid=www_sprachen.langid LIMIT 1) asc LIMIT 1")); } function mysql4datum($datum) { global $_sprache3; return substr($datum, 8,2).'.'.substr($datum, 5,2).'.'.substr($datum, 0,4).' '.$_sprache3->field282.' '.substr($datum, 11,2).':'.substr($datum, 14,2); } $ispopup=true; if ($_data->page=='setcard') { if ($_subpage=='drucken') { if (strlen($_engelid)==6) { $engelQ=mysqli_query($thisDB, "SELECT *, (SELECT wert FROM laender_sprachen WHERE laender_sprachen.wert=engel.besuchsland AND laender_sprachen.langid='$_sprache->langid' LIMIT 1) as besuchslandtitel, (SELECT titel FROM bundeslaender WHERE bundeslaender.wert=engel.besuchsbundesland LIMIT 1) as besuchsbundeslandtitel, (SELECT titel FROM orte WHERE orte.wert=engel.besuchsort LIMIT 1) as besuchsorttitel, (SELECT titel FROM ortsteile WHERE ortsteile.wert=engel.besuchsortsteil LIMIT 1) as besuchsortsteiltitel, (SELECT titel FROM strassen WHERE strassen.wert=engel.besuchsstrasse LIMIT 1) as besuchsstrassetitel, (SELECT titel FROM haeuser WHERE haeuser.wert=engel.besuchshausnummer LIMIT 1) as besuchshausnummertitel FROM engel WHERE status>0 AND anzeige>0 AND engelid='$_engelid' LIMIT 1"); if (mysqli_num_rows($engelQ)>0) { $tmplangid=$_COOKIE["langid"]; $sprachenQ=mysqli_query($thisDB, "SELECT * FROM www_sprachen WHERE status=1 AND langid='$tmplangid' LIMIT 1"); if (mysqli_num_rows($sprachenQ)>0) { $sprache=mysqli_fetch_object($sprachenQ); $langid=$tmplangid; setcookie('langid', $_data->langid); } else { $sprachenQ=mysqli_query($thisDB, "SELECT * FROM www_sprachen WHERE status=1 ORDER BY reihenfolge asc LIMIT 1"); if (mysqli_num_rows($sprachenQ)>0) { $sprache=mysqli_fetch_object($sprachenQ); $langid=$sprache->langid; setcookie('langid', $_data->langid); } else { $err=10001; } } $engel=mysqli_fetch_object($engelQ); $engeltexteQ=mysqli_query($thisDB, "SELECT * FROM engel_texte WHERE engelid='$engel->engelid' AND langid='$sprache->langid' LIMIT 1"); if (mysqli_num_rows($engeltexteQ)>0) { $engeltexte=mysqli_fetch_object($engeltexteQ); } else { $engeltexte=$sprache; } echo ''; echo ''; echo ''; echo ''; echo 'Modelle Auskunft - '.$engel->nickname; if (strlen($engeltexte->slogan)>0) {echo ' - '.$engeltexte->slogan;} echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo '
'; $bilderQ=mysqli_query($thisDB, "SELECT * FROM engel_bilder WHERE engelid='$_engelid' AND status>0 AND preis=0 AND anzeigeorte LIKE '_1%' $queryadd ORDER BY reihenfolge asc, titel asc, id asc LIMIT 1"); if (mysqli_num_rows($bilderQ)>0) { $bild=mysqli_fetch_object($bilderQ); echo '
'; echo ''; echo '
'; } if ($engel->islocation==1) { echo '
'; echo ''.$engel->nickname; if (strlen($engeltexte->slogan)>0) {echo ' - '.$engeltexte->slogan;} echo '

'; $result=''; include ('subpages/setcard_uebersicht.subpage.php'); echo $result.'
'; // echo 'Ausstattung
'; $result=''; include ('subpages/setcard_ausstattung.subpage.php'); echo $result; echo '

'; } else { echo '
'; echo ''.$engel->nickname; if (strlen($engeltexte->slogan)>0) {echo ' - '.$engeltexte->slogan;} echo '

'; // echo 'Übersicht
'; $result=''; include ('subpages/setcard_uebersicht.subpage.php'); echo $result.'
'; // echo 'Persönliches
'; $result=''; include ('subpages/setcard_persoenliches.subpage.php'); echo $result; echo '
'; echo '

'; echo '
'; // echo 'Service
'; $result=''; include ('subpages/setcard_service.subpage.php'); echo $result.'

'; echo '
'; echo '
'; } echo ''.$_sprache2->field90.'
'; echo $_sprache2->field94.': '; if (substr($engel->freietage, 0, 1)==1) {echo $_sprache2->field93;} elseif (substr($engel->anfragetage, 0, 1)==1) {echo $_sprache2->field101;} elseif ($engel->montagvon==$engel->montagbis) {echo $_sprache2->field92;} else {echo substr($engel->montagvon, 0, 5).'-'.substr($engel->montagbis, 0, 5).' '.$_sprache2->field102;} echo ' -- '.$_sprache2->field95.': '; if (substr($engel->freietage, 1, 1)==1) {echo $_sprache2->field93;} elseif (substr($engel->anfragetage, 1, 1)==1) {echo $_sprache2->field101;} elseif ($engel->dienstagvon==$engel->dienstagbis) {echo $_sprache2->field92;} else {echo substr($engel->dienstagvon, 0, 5).'-'.substr($engel->dienstagbis, 0, 5).' '.$_sprache2->field102;} echo ' -- '.$_sprache2->field96.': '; if (substr($engel->freietage, 2, 1)==1) {echo $_sprache2->field93;} elseif (substr($engel->anfragetage, 2, 1)==1) {echo $_sprache2->field101;} elseif ($engel->mittwochvon==$engel->mittwochbis) {echo $_sprache2->field92;} else {echo substr($engel->mittwochvon, 0, 5).'-'.substr($engel->mittwochbis, 0, 5).' '.$_sprache2->field102;} echo ' -- '.$_sprache2->field97.': '; if (substr($engel->freietage, 3, 1)==1) {echo $_sprache2->field93;} elseif (substr($engel->anfragetage, 3, 1)==1) {echo $_sprache2->field101;} elseif ($engel->donnerstagvon==$engel->donnerstagbis) {echo $_sprache2->field92;} else {echo substr($engel->donnerstagvon, 0, 5).'-'.substr($engel->donnerstagbis, 0, 5).' '.$_sprache2->field102;} echo ' -- '.$_sprache2->field98.': '; if (substr($engel->freietage, 4, 1)==1) {echo $_sprache2->field93;} elseif (substr($engel->anfragetage, 4, 1)==1) {echo $_sprache2->field101;} elseif ($engel->freitagvon==$engel->freitagbis) {echo $_sprache2->field92;} else {echo substr($engel->freitagvon, 0, 5).'-'.substr($engel->freitagbis, 0, 5).' '.$_sprache2->field102;} echo ' -- '.$_sprache2->field99.': '; if (substr($engel->freietage, 5, 1)==1) {echo $_sprache2->field93;} elseif (substr($engel->anfragetage, 5, 1)==1) {echo $_sprache2->field101;} elseif ($engel->samstagvon==$engel->samstagbis) {echo $_sprache2->field92;} else {echo substr($engel->samstagvon, 0, 5).'-'.substr($engel->samstagbis, 0, 5).' '.$_sprache2->field102;} echo ' -- '.$_sprache2->field100.': '; if (substr($engel->freietage, 6, 1)==1) {echo $_sprache2->field93;} elseif (substr($engel->anfragetage, 6, 1)==1) {echo $_sprache2->field101;} elseif ($engel->sonntagvon==$engel->sonntagbis) {echo $_sprache2->field92;} else {echo substr($engel->sonntagvon, 0, 5).'-'.substr($engel->sonntagbis, 0, 5).' '.$_sprache2->field102;} echo '
 '; echo '
'; // $newsQ=mysqli_query($thisDB, "SELECT * FROM engel_news WHERE engelid='$engel->engelid' AND lokalstatus=1 ORDER BY eingetragen desc"); // if (mysqli_num_rows($newsQ)>0) { // echo '
'; // echo ''.$_sprache2->field103.'
'; // while ($news=mysqli_fetch_object($newsQ)) { // echo '
'; // echo '
'.mysql4datum($news->eingetragen).'
'; // echo '
'.$news->titel.'
'.$news->nachricht.'
'; // echo '
'; // } // echo '

'; // } echo '
'; echo ''.$_sprache2->field91.' '.$engel->nickname.':
'; echo 'http://www.modell-auskunft.de/?data[enter]=1&data[page]=setcard&data[engelid]='.$engel->engelid; echo '
'; echo ''; echo ''; } } } elseif ($_subpage=='videos') { $videoQ=mysqli_query($thisDB, "SELECT * FROM engel_videos WHERE status>0 AND videoid='$_data->videoid' LIMIT 1"); if ((strlen($_data->videoid)==6)&&(mysqli_num_rows($videoQ)>0)) { $video=mysqli_fetch_object($videoQ); $engel=mysqli_fetch_object(mysqli_query($thisDB, "SELECT * FROM engel WHERE engelid='$video->engelid' LIMIT 1")); if (($video->preis==0)||((strlen($_user->memberid)==6)&&(mysqli_num_rows(mysqli_query($thisDB, "SELECT * FROM engel_videos_verkaeufe WHERE kundenid='$_user->memberid' AND videoid='$_data->videoid' LIMIT 1"))>0))) { if ($video->filetype==0) { require_once('inc/flvinfo2.inc.php'); $flvinfo=new FLVInfo2(); $info=$flvinfo->getInfo('videos/engel/'.$engel->engelid.'_'.$video->videoid.'.flv',true,true); if ($info->video->width>0) { $breite=$info->video->width; $hoehe=$info->video->height; } else { $breite=450; $hoehe=380; } echo ''; echo ''; echo ''; echo ''; echo 'Modelle Auskunft - '.$engel->nickname; if (strlen($engeltexte->slogan)>0) {echo ' - '.$engeltexte->slogan;} echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; $hierflash=explode($_sprache2->field133, 'xSPLITx', 2); echo '
'.$hierflash[0].' '.$hierflash[1].'
'; echo ''; echo ''; echo ''; } elseif ($video->filetype==1) { echo ''; echo ''; echo ''; echo ''; echo 'Modelle Auskunft - '.$engel->nickname; if (strlen($engeltexte->slogan)>0) {echo ' - '.$engeltexte->slogan;} echo ''; echo ''; echo ''; echo ''; echo '
'; echo ''; echo ''; echo ''; echo ''; echo ''; } } } } } ?>