//
// NW.Tech Web-Development by H. Duerkop ("NW.Tech") CONFIDENTIAL
// Unpublished Copyright (c) 2001-2021 [NW.Tech Web-Development by H. Duerkop], All Rights Reserved.
//
// NOTICE: All information contained herein is, and remains the property of NW.Tech. The intellectual and technical concepts contained
// herein are proprietary to NW.Tech and may be covered by U.S. and Foreign Patents, patents in process, and are protected by trade secret or copyright law.
// Dissemination of this information or reproduction of this material is strictly forbidden unless prior written permission is obtained
// from NW.Tech. Access to the source code contained herein is hereby forbidden to anyone except current NW.Tech employees, managers or contractors who have executed
// Confidentiality and Non-disclosure agreements explicitly covering such access.
//
// The copyright notice above does not evidence any actual or intended publication or disclosure of this source code, which includes
// information that is confidential and/or proprietary, and is a trade secret, of NW.Tech. ANY REPRODUCTION, MODIFICATION, DISTRIBUTION, PUBLIC PERFORMANCE,
// OR PUBLIC DISPLAY OF OR THROUGH USE OF THIS SOURCE CODE WITHOUT THE EXPRESS WRITTEN CONSENT OF NW.TECH IS STRICTLY PROHIBITED, AND IN VIOLATION OF APPLICABLE
// LAWS AND INTERNATIONAL TREATIES. THE RECEIPT OR POSSESSION OF THIS SOURCE CODE AND/OR RELATED INFORMATION DOES NOT CONVEY OR IMPLY ANY RIGHTS
// TO MODIFY, REPRODUCE, DISCLOSE OR DISTRIBUTE ITS CONTENTS, OR TO MANUFACTURE, USE, OR SELL ANYTHING THAT IT MAY DESCRIBE, IN WHOLE OR IN PART.
//
require ('inc/__sqlsafe.inc.php');
$_data=sqlsafe($_REQUEST['data']);
require ('inc/__db.inc.php');
require ('inc/__func.inc.php');
require ('inc/__login.inc.php');
include ('inc/_www_sprachen.inc.php');
include ('inc/_www_rubriken.inc.php');
require ('inc/_pages.inc.php');
$_sprache2Q=mysqli_query($thisDB, "SELECT * FROM www_sprachen_statics WHERE langid='$_sprache->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 '
';
$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 '
';
// $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 '