assign("page", $page , true); $smarty->assign("language", $language, true); $smarty->assign("plan_list", $plan_list, true); $smarty->assign("model_list", $model_list, true); // ------------------------------------------------- // Alle Article auslesen !!!!!! // ------------------------------------------------- $qry = "SELECT fw_cms_text.article_id as article_id, fw_cms_content.id, fw_cms_content.create_date, fw_cms_text.headertext as title FROM fw_cms_text INNER JOIN fw_cms_content ON (fw_cms_text.article_id = fw_cms_content.id) WHERE fw_cms_content.reftype = 'ARTICLE' AND fw_cms_text.`language` = '$language' ORDER BY fw_cms_content.create_date DESC"; $articles = array(); $res = $mysqli->query($qry); while($row = $res->fetch_assoc()) { $urltext = urlencode($row['title']); $urltext = str_replace("%", '', $urltext); $row['urltext'] = $urltext; $articles[] = $row; } $smarty->assign('articles', $articles, true); // ------------------------------------------------- // Alle Bausätze auslesen !!!!!! // ------------------------------------------------- $qry = "SELECT fw_cms_text.article_id as article_id, fw_cms_content.id, fw_cms_content.create_date, fw_cms_text.headertext as title FROM fw_cms_text INNER JOIN fw_cms_content ON (fw_cms_text.article_id = fw_cms_content.id) WHERE fw_cms_content.reftype = 'BAUSATZ' AND fw_cms_text.`language` = '$language' ORDER BY fw_cms_content.create_date DESC"; $kits = array(); $res = $mysqli->query($qry); while($row = $res->fetch_assoc()) { $urltext = urlencode($row['title']); $urltext = str_replace("%", '', $urltext); $row['urltext'] = $urltext; $kits[] = $row; } $smarty->assign('kits', $kits, true); // ------------------------------------------------- // Alle Pläne auslesen !!!!!! // ------------------------------------------------- $qry = "SELECT fw_cms_text.article_id as article_id, fw_cms_content.id, fw_cms_content.create_date, fw_cms_text.headertext as title FROM fw_cms_text INNER JOIN fw_cms_content ON (fw_cms_text.article_id = fw_cms_content.id) WHERE fw_cms_content.reftype = 'PLAN' AND fw_cms_text.`language` = '$language' ORDER BY fw_cms_content.create_date DESC"; $plans = array(); $res = $mysqli->query($qry); while($row = $res->fetch_assoc()) { $urltext = urlencode($row['title']); $urltext = str_replace("%", '', $urltext); $row['urltext'] = $urltext; $plans[] = $row; } $smarty->assign('plans', $plans, true); // ------------------------------------------------- // Alle GALLERY auslesen !!!!!! // ------------------------------------------------- $qry = "SELECT fw_cms_text.article_id as article_id, fw_cms_content.id, fw_cms_content.create_date, fw_cms_text.headertext as title FROM fw_cms_text INNER JOIN fw_cms_content ON (fw_cms_text.article_id = fw_cms_content.id) WHERE fw_cms_content.reftype = 'GALLERY' AND fw_cms_text.`language` = '$language' ORDER BY fw_cms_content.create_date DESC"; $gallery = array(); $res = $mysqli->query($qry); while($row = $res->fetch_assoc()) { $urltext = urlencode($row['title']); $urltext = str_replace("%", '', $urltext); $row['urltext'] = $urltext; $gallery[] = $row; } $smarty->assign('gallery', $gallery, true); $message = isset($_REQUEST['src']) ? "Uuups! File Not Found" : "Sitemap"; $smarty->assign('headertext', $message, true); $smarty->assign('rand', $rand, true); $smarty->assign('language', $language, true); $smarty->display('sitemap.tpl'); ?>