";
$not_read = " ";
if($collectionData['readable'] == 1){
$query_read = "SELECT * FROM main_collection_read WHERE main_collection_id = ". $collectionData['id'] . " AND main_contact_id = ".$GLOBALS['main_contact']['id'];
$result_read = @mysqli_query($GLOBALS['mysql_con'], $query_read);
if (@mysqli_num_rows($result_read) == 0) {
$not_read = " not_read";
}
}
// breadcrumb - DuP - 20190516
//Zuordnung der Name Collection in jeweiligen Collection Gruppe
$queryGroup = "SELECT * FROM `main_collection_group_link` WHERE `main_collection_id` = '" . $collectionData['id'] . "' and active=1";
$group_result = @mysqli_query($GLOBALS['mysql_con'], $queryGroup);
$group_row = @mysqli_fetch_array($group_result);
$group_output = $group_row['main_collection_setup_group_id'];
$query = "SELECT * FROM main_collection_setup_group WHERE id =\"" . $group_output . "\"";
$result = @mysqli_query($GLOBALS['mysql_con'], $query);
$row = @mysqli_fetch_array($result);
$output = $row['description'];
$showCollection = check_web_show($collectionData['id'], $GLOBALS['language']['id'], $collectionData['main_collection_setup_id'], $collectionData['collection_for']);
if($showCollection && $limitData > 0 ){
$limitData-- ;
echo "";
}
// Anmeldelink anzeigen
if (
$fullView === TRUE &&
$collections[$collection_id]['registration'] == 1 &&
(int)$collections[$collection_id]['registration_contactform_id'] > 0
) {
echo "
\n"; } } function get_inactive_components($page_id) { $default_inactive = array(); $query = "SELECT id FROM main_component WHERE (main_language_id = " . (int)$GLOBALS["language"]['id'] . " OR all_languages = 1) AND default_active = 0"; $result = @mysqli_query($GLOBALS['mysql_con'], $query); if (@mysqli_num_rows($result) > 0) { while ($row = @mysqli_fetch_array($result)) { $default_inactive[] = $row['id']; } } $component_ids = array(); $query = "SELECT main_component_id FROM main_page_component_include_link WHERE main_page_id = '" . (int)$page_id . "' AND active = 0"; $result = @mysqli_query($GLOBALS['mysql_con'], $query); if (@mysqli_num_rows($result) > 0) { while ($row = @mysqli_fetch_array($result)) { $component_ids[] = $row['main_component_id']; } } $allComponents = array_merge($component_ids, $default_inactive); return $allComponents; } function show_component_content($layout_area_id, &$IOCContainer = null, $layout_area_code) { require_once CMS_PATH . "common/classes/Siteparts.php"; $allSiteparts = \DynCom\mysyde\common\classes\Siteparts::get(); $page_id = (int)$GLOBALS["navigation"]['forward_page_id']; $component_ids = array(); $query = "SELECT id FROM main_component WHERE active = 1 AND (main_language_id = " . (int)$GLOBALS["language"]['id'] . " OR all_languages = 1) AND layout_area_id in (select id from main_layout_area where code = '" . $layout_area_code . "')"; $result = @mysqli_query($GLOBALS['mysql_con'], $query); if (@mysqli_num_rows($result) == 0) { return ""; } while ($row = @mysqli_fetch_array($result)) { $component_ids[] = $row['id']; } $active_components = array(); $query = "SELECT active, main_component_id FROM main_page_component_include_link WHERE main_page_id = '" . (int)$page_id . "' AND main_component_id IN (" . join(',', $component_ids) . ")"; $result = @mysqli_query($GLOBALS['mysql_con'], $query); if (@mysqli_num_rows($result) > 0) { while ($row = @mysqli_fetch_array($result)) { if ($row['active'] == 1) { $active_components[] = $row['main_component_id']; } } } // componenten filtern $final_components = array(); foreach ($component_ids as $componentId) { if (count($active_components) && in_array($componentId, $active_components)) { $final_components[] = $componentId; continue; } if (!is_array($GLOBALS["inactive_components"]) || !in_array($componentId, $GLOBALS["inactive_components"])) { $final_components[] = $componentId; continue; } } if (count($final_components) == 0) { return ""; } // componenten codes sammeln $componentCodes = array(); $query = "SELECT id, code FROM main_component WHERE id IN (" . join(',', $final_components) . ")"; $result = @mysqli_query($GLOBALS['mysql_con'], $query); while ($row = @mysqli_fetch_array($result)) { $componentCodes[$row['id']] = $row['code']; } $query = "SELECT * FROM main_component_link WHERE main_component_id IN (" . join(',', $final_components) . ") ORDER BY main_component_id ASC, sorting ASC"; $result = @mysqli_query($GLOBALS['mysql_con'], $query); if (@mysqli_num_rows($result) == 0) { return ""; } $currentComponent = NULL; $live_edit_class = ""; if ($GLOBALS["live_edit_mode"] === TRUE) { $live_edit_class = " live_edit_container live_edit_component"; } while ($sitepart = @mysqli_fetch_array($result)) { if ($currentComponent !== NULL && $currentComponent != $sitepart['main_component_id']) { echo "
";
}
if ($currentComponent === NULL || $currentComponent != $sitepart['main_component_id']) {
echo "";
//IC - TH - 20170517 +++
if ($GLOBALS["live_edit_mode"] === true) {
$translation = Registry::get("translation");
echo "
";
}
$queryField = '';
if($setupData['is_custom_collection']){
$queryField = "SELECT * FROM main_collection_setup_content WHERE main_collection_setup_id = " . $collection_setup['main_collection_setup_id'] . " AND main_collection_id = ".$collectionData['id']." ORDER BY sorting ASC";
$resultField = @mysqli_query($GLOBALS['mysql_con'], $queryField);
if (@mysqli_num_rows($resultField) < 1 ) {
continue;
}else{
$setup_fields = array();
while ($rowField = @mysqli_fetch_array($resultField)) {
$setup_fields[$rowField['id']] = $rowField;
}
}
}
$linkShow = FALSE;
if($coll_setup['collection_type'] == 4){
$translation = \DynCom\mysyde\common\classes\Registry::get("translation");
?>
'>
'.$output.'
';
}
foreach ($setup_fields as $fieldId => $fieldData) {
if($fullView && $fieldData['fieldtype'] == 'siteparts' && $fieldData['type_id'] == 16){
require_once(MODULE_PATH.'faq/show_collection_faq.inc.php');
// print_r(MODULE_PATH . $sitepartData['folder']) . DIRECTORY_SEPARATOR . $sitepartData['code'] . ".php"));
// echo '';
continue;
}
if($fullView && $fieldData['fieldtype'] == 'siteparts' && $fieldData['type_id'] == 22){
require_once(MODULE_PATH.'table/show_collection_table.inc.php');
// print_r(MODULE_PATH . $sitepartData['folder']) . DIRECTORY_SEPARATOR . $sitepartData['code'] . ".php"));
// echo '';
continue;
}
if (!isset($collection_lines[$collection_id])) {
continue;
}
if (!isset($collection_lines[$collection_id][$fieldId]) && $fieldData['fieldtype'] != 'collection_preview') {
continue;
}
if ($fullView === FALSE && $fieldData['is_teaser'] == 0) {
continue;
}
if ($linked == 1 && $fullView === FALSE) {
if ($collectionPreview === TRUE) {
// weiterleitung zu einer anderen seite
$query = "SELECT * FROM main_page_link WHERE main_collection_setup_id = '" . $collection_setup['main_collection_setup_id'] . "' AND main_collection_view_type = 0 LIMIT 1";
$result = mysqli_query($GLOBALS["mysql_con"], $query);
if (@mysqli_num_rows($result) == 1) {
$mainPageLink = @mysqli_fetch_array($result);
$query = "SELECT * FROM main_navigation WHERE forward_page_id = '" . $mainPageLink['main_page_id'] . "' LIMIT 1";
$result = mysqli_query($GLOBALS["mysql_con"], $query);
if (@mysqli_num_rows($result) == 1) {
$mainNavigation = @mysqli_fetch_array($result);
$collection_setup['main_collection_page_list_id'] = $mainNavigation["id"];
}
}
$fullviewLink = get_link_to_navigation($collection_setup['main_collection_page_list_id']) . get_collection_rewrite($collectionData['description'], $collection_id);
} else {
// gleiche seite nochmal laden
$fullviewLink = get_link_to_navigation($GLOBALS["navigation"]['id']) . get_collection_rewrite($collectionData['description'], $collection_id);
}
$createFullViewLink = '%s';
}
if($is_view){
$fullviewLink = get_link_to_navigation($collection_setup['main_collection_page_list_id']) . get_collection_rewrite($collectionData['description'], $collection_id);
}
$line = $collection_lines[$collection_id][$fieldId];
/** 20200825 - Wenn Description aktiv dann soll es als Titel angezeigt werden DuP **/
$description_title = '';
if (isset($fieldData['show_description_title']) && $fieldData['show_description_title'] == 1) {
$description_title = "" . $fieldData['fieldname'] . "";
}
if($coll_setup['desc_title'] == 1 && $linkShow == FALSE && $fullView == TRUE && $collectionSetup['code'] == 'news'){
echo ""; echo $collectionData['description']; echo '
'; $linkShow = TRUE; } if($coll_setup['desc_title'] == 1 && $linkShow == FALSE){ echo ""; echo $collectionData['description']; echo '
'; $linkShow = TRUE; } echo "";
switch ($fieldData['fieldtype']) {
case 'siteparts':
if ($linked == 1 && $fullView === FALSE) {
echo '';
}
show_sitepart_content($line['main_sitepart_id'], $line['main_sitepart_header_id']);
if ($linked == 1 && $fullView === FALSE) {
echo '';
}
break;
case 'standard':
default:
if ($fieldData['type_id'] == 4) { // link
$target = '';
if($line['main_sitepart_header_id'] == 1){
$target = 'target="_blank"';
}
echo $description_title . "" . $line['linkText'] . "";
break;
}
/** 20200812 Link entfernen vom Content DuP */
// if ($fieldData['type_id'] == 5) { // bild
// if ($line['data'] != "" && file_exists(ROOT_PATH . PATH_ORIGINAL_FRONTEND_COLLECTION . $line['data'])) {
// echo sprintf($createFullViewLink, "![](\"")
");
// }
// break;
// }
if ($fieldData['type_id'] == 5) { // bild
if ($line['data'] != "" && file_exists(ROOT_PATH . "userdata/" . $line['data'])) {
echo sprintf("![.$line['data'].](\"/userdata/")
");
}
break;
}
if ($fieldData['type_id'] == 6) { // Dropdown
//Get Dropdown Values
$setup_content = $setup_fields[$line['main_collection_setup_content_id']]['option_string'];
//Als Array umwandeln und Json wieder anzeigen
$options = explode(";", $setup_content);
$option_value = unserialize($line['data']);
// print value
echo $description_title . $options[$option_value];
break;
}
if ($fieldData['type_id'] == 3) { // Datum
$date = new DateTime($line['data']);
echo $date->format("d.m.Y");
break;
}
if ($fieldData['type_id'] == 8) { // Icon Dropdown
require(MODULE_PATH . "collection/collection_config.inc.php");
echo "
".$collection_icon_images[$fieldData['code']][$line['data']]["image"]."
";
break;
}
if ($fieldData['type_id'] == 9) { // Icon Dropdown
// Überprüfe, ob `line['data']` nicht leer ist
if (!empty($line['data'])) {
// Teile die `line['data']` in ein Array auf, falls mehrere IDs vorhanden sind
$dataIds = explode(',', $line['data']); // Angenommen, IDs sind durch Kommas getrennt
echo "";
foreach ($dataIds as $dataId) {
// Bereinige den Wert von `dataId` für die sichere Verwendung in der SQL-Abfrage
$dataId = mysqli_real_escape_string($GLOBALS['mysql_con'], trim($dataId));
// SQL-Abfrage, um den Datensatz mit der angegebenen ID abzurufen
$query = "SELECT id, name FROM main_contact WHERE id = '$dataId'";
$result = @mysqli_query($GLOBALS['mysql_con'], $query);
// Überprüfe, ob ein Ergebnis gefunden wurde
if ($result && mysqli_num_rows($result) > 0) {
$row = mysqli_fetch_array($result);
// Generiere den Link mit dem Namen
$name = htmlspecialchars($row['name']); // Sicher für HTML
echo '' . $name . '';
}
}
echo "
";
}
}
if ($fieldData['type_id'] == 666) { // connected_form
show_sitepart_content(3, $line['data']);
break;
}
if($fieldData['type_id'] == '8888' ){
$queryPrev = "SELECT * FROM main_collection_setup_preview WHERE field_id = ".$fieldData['id'];
$resultPrev = @mysqli_query($GLOBALS['mysql_con'], $queryPrev);
if (@mysqli_num_rows($resultPrev) > 0) {
while ($rowPrev = @mysqli_fetch_array($resultPrev)) {
$limit = $rowPrev['main_collection_items'];
$setupContent = [
'main_collection_id' => $collectionData['id'],
'main_collection_setup_id' => $rowPrev['main_collection_setup_id_selected'],
'main_collection_page_list_id' => $rowPrev['main_collection_page_list_id'],
'is_view' => 1,
'field_id' => $rowPrev['field_id'],
'main_collection_items' => $limit,
'main_collection_view_type' => $rowPrev['main_collection_view_type']
];
show_collection_setup_content($setupContent, 'main_collection_preview_group_link');
}
}
// echo '';
break;
}
if($fieldData['type_id'] == '8889'){
$queryLinked = "SELECT * FROM main_collection_contact_linked WHERE main_collection_id = ".$collectionData['id']." AND field_id = ".$fieldData['id'];
$resultLinked = @mysqli_query($GLOBALS['mysql_con'], $queryLinked);
if (@mysqli_num_rows($resultLinked) > 0) {
show_sitepart_content(3, $fieldData['option_string'], NULL, $IOCContainer, $fieldData['id']);
?>
";
}
if($fullView === TRUE){
$query_certificate = "SELECT * FROM main_certificate WHERE main_collection_id = ".$collection_id;
$result_certificate = @mysqli_query($GLOBALS['mysql_con'], $query_certificate);
$row_certificate = @mysqli_fetch_array($result_certificate);
if(isset($_GET['check_certificate']) && $_GET['check_certificate']){
$certificate_id = $_GET['check_certificate'];
$current_date = new DateTime();
$query = "SELECT * FROM certificate_contact_submit WHERE certificate_id = ".$certificate_id." AND main_contact_id = ".$GLOBALS['main_contact']['id'];
$result = @mysqli_query($GLOBALS['mysql_con'], $query);
$row = @mysqli_fetch_array($result);
if (@mysqli_num_rows($result) > 0) {
$query2 = "UPDATE certificate_contact_submit SET correct = 1, issue_date = '".$current_date->format('Y-m-d H:i:s')."' WHERE id = ".$row['id'];
}else{
$query2 = "INSERT INTO certificate_contact_submit (certificate_id, main_contact_id, issue_date, correct)
VALUES (
'".$certificate_id."',
'".$GLOBALS['main_contact']['id']."',
'".$current_date->format('Y-m-d H:i:s')."',
'1'
)";
}
$result2 = @mysqli_query($GLOBALS['mysql_con'], $query2);
?>
= 1 && $row_submit['correct'] == 1){
load_certificate_submit_mask($row_submit);
}else{
echo "";
echo "
";
}
}
}
if ($linked == 1 && $fullView === FALSE) {
echo "";
}
}
echo "";
echo "
";
echo "";
echo "
";
echo "Beitrag zertifizieren";
echo "Beitragszertifizierung
"; echo "Ich bestätige, dass ich den Inhalt dieses Beitrages gelesen und verstanden habe.
";
echo "\n"; } } function get_inactive_components($page_id) { $default_inactive = array(); $query = "SELECT id FROM main_component WHERE (main_language_id = " . (int)$GLOBALS["language"]['id'] . " OR all_languages = 1) AND default_active = 0"; $result = @mysqli_query($GLOBALS['mysql_con'], $query); if (@mysqli_num_rows($result) > 0) { while ($row = @mysqli_fetch_array($result)) { $default_inactive[] = $row['id']; } } $component_ids = array(); $query = "SELECT main_component_id FROM main_page_component_include_link WHERE main_page_id = '" . (int)$page_id . "' AND active = 0"; $result = @mysqli_query($GLOBALS['mysql_con'], $query); if (@mysqli_num_rows($result) > 0) { while ($row = @mysqli_fetch_array($result)) { $component_ids[] = $row['main_component_id']; } } $allComponents = array_merge($component_ids, $default_inactive); return $allComponents; } function show_component_content($layout_area_id, &$IOCContainer = null, $layout_area_code) { require_once CMS_PATH . "common/classes/Siteparts.php"; $allSiteparts = \DynCom\mysyde\common\classes\Siteparts::get(); $page_id = (int)$GLOBALS["navigation"]['forward_page_id']; $component_ids = array(); $query = "SELECT id FROM main_component WHERE active = 1 AND (main_language_id = " . (int)$GLOBALS["language"]['id'] . " OR all_languages = 1) AND layout_area_id in (select id from main_layout_area where code = '" . $layout_area_code . "')"; $result = @mysqli_query($GLOBALS['mysql_con'], $query); if (@mysqli_num_rows($result) == 0) { return ""; } while ($row = @mysqli_fetch_array($result)) { $component_ids[] = $row['id']; } $active_components = array(); $query = "SELECT active, main_component_id FROM main_page_component_include_link WHERE main_page_id = '" . (int)$page_id . "' AND main_component_id IN (" . join(',', $component_ids) . ")"; $result = @mysqli_query($GLOBALS['mysql_con'], $query); if (@mysqli_num_rows($result) > 0) { while ($row = @mysqli_fetch_array($result)) { if ($row['active'] == 1) { $active_components[] = $row['main_component_id']; } } } // componenten filtern $final_components = array(); foreach ($component_ids as $componentId) { if (count($active_components) && in_array($componentId, $active_components)) { $final_components[] = $componentId; continue; } if (!is_array($GLOBALS["inactive_components"]) || !in_array($componentId, $GLOBALS["inactive_components"])) { $final_components[] = $componentId; continue; } } if (count($final_components) == 0) { return ""; } // componenten codes sammeln $componentCodes = array(); $query = "SELECT id, code FROM main_component WHERE id IN (" . join(',', $final_components) . ")"; $result = @mysqli_query($GLOBALS['mysql_con'], $query); while ($row = @mysqli_fetch_array($result)) { $componentCodes[$row['id']] = $row['code']; } $query = "SELECT * FROM main_component_link WHERE main_component_id IN (" . join(',', $final_components) . ") ORDER BY main_component_id ASC, sorting ASC"; $result = @mysqli_query($GLOBALS['mysql_con'], $query); if (@mysqli_num_rows($result) == 0) { return ""; } $currentComponent = NULL; $live_edit_class = ""; if ($GLOBALS["live_edit_mode"] === TRUE) { $live_edit_class = " live_edit_container live_edit_component"; } while ($sitepart = @mysqli_fetch_array($result)) { if ($currentComponent !== NULL && $currentComponent != $sitepart['main_component_id']) { echo "
";
if ($GLOBALS["live_edit_mode"] === TRUE) {
$translation = \DynCom\mysyde\common\classes\Registry::get("translation");
echo "
";
}
}
if ((int)$sitepart['main_sitepart_id'] > 0) {
// anzeige eines siteparts im baustein
$sitepartData = $allSiteparts[$sitepart['main_sitepart_id']];
require_once(realpath(MODULE_PATH . $sitepartData['folder']) . DIRECTORY_SEPARATOR . $sitepartData['code'] . ".php");
$function = $sitepartData['code'] . "_show";
$reflection = new ReflectionFunction($function);
$noOfParams = $reflection->getNumberOfParameters();
if ($noOfParams > 1) {
$function($sitepart['main_sitepart_header_id'], $IOCContainer);
} else {
$function($sitepart['main_sitepart_header_id']);
}
} elseif ((int)$sitepart['main_collection_list'] == 2) {
// anzeige einer kollektionsvorschau im baustein
show_collection_setup_content($sitepart, "main_component_collection_group_link");
}
$currentComponent = $sitepart['main_component_id'];
}
echo "
";
}
function create_includes($main_layout_id, $page_id, $type)
{
$query = "
SELECT id, path, default_active, type
FROM main_layout_inclusions
WHERE main_layout_id = '" . $main_layout_id . "' AND type = '" . $type . "'
ORDER BY sorting ASC";
$result = @mysqli_query($GLOBALS['mysql_con'], $query);
$layout_inclusions = array();
while ($row = @mysqli_fetch_assoc($result)) {
$layout_inclusions[$row['id']] = $row;
}
if (count($layout_inclusions) == 0) {
return;
}
$includes_link_ids = array();
$query = "SELECT * FROM main_page_layout_inclusion_link WHERE main_page_id = '" . $page_id . "'";
$result = @mysqli_query($GLOBALS['mysql_con'], $query);
while ($row = @mysqli_fetch_assoc($result)) {
$includes_link_ids[$row['main_layout_includes_id']] = $row;
}
$time = 0;
foreach ($layout_inclusions as $inclusion_id => $inclusion_row) {
$include = FALSE;
if (
!isset($includes_link_ids[$inclusion_id]) &&
$inclusion_row['default_active'] == 1
) {
$include = TRUE;
} elseif (isset($includes_link_ids[$inclusion_id]) && $includes_link_ids[$inclusion_id]['active'] == 1) {
$include = TRUE;
}
if ($include === FALSE) {
continue;
}
if (!file_exists(rtrim($_SERVER["DOCUMENT_ROOT"], '/') . $inclusion_row["path"])) {
continue;
}
$filetime = filemtime(rtrim($_SERVER["DOCUMENT_ROOT"], '/') . $inclusion_row["path"]);
if ($time < $filetime) {
$time = $filetime;
}
switch ($inclusion_row['type']) {
case 'js':
echo "\n";
break;
case 'css':
echo "\n";
break;
}
}
//if ($inclusion_row['type'] == 'css') {
// echo '\n';
//}
// IF (@mysqli_num_rows($result) > 0) {
// WHILE ($layout_inclusions = @mysqli_fetch_assoc($result)) {
// $query2 = "SELECT active FROM main_page_layout_inclusion_link WHERE
// main_layout_inclusions_id = " . $layout_inclusions["id"] . " AND
// main_page_id = " . $page_id;
//
// $result2 = @mysqli_query($GLOBALS['mysql_con'],$query2);
// IF (@mysqli_num_rows($result2) == 0 && $layout_inclusions["default_active"] == 1) {
// SWITCH ($type) {
// CASE 'js': echo "\n"; break;
// CASE 'css': echo "\n"; break;
// }
// } ELSE {
// IF (@mysqli_result($result2,0) == 1) {
// SWITCH ($type) {
// CASE 'js': echo "\n"; break;
// CASE 'css': echo "\n"; break;
// }
// }
// }
// }
// }
}
function create_live_edit_includes()
{
if (isset($GLOBALS["admin_user_frontend"]) && $GLOBALS["admin_user_frontend"] !== FALSE && $GLOBALS["insert_live_edit_js"] === TRUE) {
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
// live edit modus setzen
$GLOBALS["live_edit_mode"] = TRUE;
// nur einmal einfuegen
$GLOBALS["insert_live_edit_js"] = FALSE;
// translation nochmal initalisieren
// auch wenn das backend offen ist, im iframe sind wir im frontend
\DynCom\mysyde\common\classes\Registry::set('translation', new \DynCom\mysyde\common\classes\Translate($GLOBALS["admin_user_frontend"]['main_language']));
}
}
function get_layout_classes($_layout_id)
{
$classes = array();
$query = "SELECT * FROM main_layout_class WHERE main_layout_id = '" . $_layout_id . "'";
$result = @mysqli_query($GLOBALS['mysql_con'], $query);
while ($row = @mysqli_fetch_assoc($result)) {
$classes[$row['id']] = $row;
}
return $classes;
}
//IC - TH - 20170517 ---
//function get_collection_sql_in_groups($collection_setup, $table) {
function get_collection_sql_in_groups($collection_setup, $table, $group_filter_id = 0)
{
//IC - TH - 20170517 +++
// Pruefen ob es gruppen gibt und ob kollektion in der gruppe ist
$query = "SELECT id FROM main_collection_setup_group WHERE main_collection_setup_id = '" . $collection_setup['main_collection_setup_id'] . "'";
$result = @mysqli_query($GLOBALS['mysql_con'], $query);
$countGroups = @mysqli_num_rows($result);
if ($countGroups == 0) {
return ""; //--> Keine gruppen angelegt, keine weitere pruefung
}
$link_row = "main_page_link_id";
if ($table == "main_component_collection_group_link") {
$link_row = "main_component_link_id";
}
$query = "SELECT main_collection_setup_group_id FROM " . $table . " WHERE " . $link_row . " = " . $collection_setup['id'];
//IC - TH - 20170517 ---
if ($group_filter_id != 0)
$query .= " and main_collection_setup_group_id = \"" . $group_filter_id . "\"";
//IC - TH - 20170517 +++
$result = @mysqli_query($GLOBALS['mysql_con'], $query);
$collection_setup_groups = array();
while ($row = @mysqli_fetch_array($result)) {
$collection_setup_groups[] = $row['main_collection_setup_group_id'];
}
if (count($collection_setup_groups) == 0) {
return ""; //--> Keine gruppen beim inhalt angecheckt
}
$query = "SELECT main_collection_id FROM main_collection_group_link WHERE main_collection_setup_group_id IN (" . join(",", $collection_setup_groups) . ") AND active = 1";
$result = @mysqli_query($GLOBALS['mysql_con'], $query);
$collection_ids = array();
while ($row = @mysqli_fetch_array($result)) {
$collection_ids[] = $row['main_collection_id'];
}
if (count($collection_ids) == 0) {
return " and main_collection.id IN(-1) "; //--> Keine kollektion zur definierten gruppe zugeordnet
}
return " and main_collection.id IN(" . join(",", $collection_ids) . ") ";
}
function finalize_meta_tags()
{
if (strpos($GLOBALS['site_title'], " | ") === FALSE) {
$GLOBALS['site_title'] .= ' | ';
}
$GLOBALS['site_title'] .= $GLOBALS['language']["site_title_name"];
$GLOBALS['meta_description'] .= substr(strip_tags($GLOBALS["language"]["meta_description"]), 0, 200);
$GLOBALS['meta_keywords'] .= $GLOBALS["language"]["meta_keywords"];
}
function get_globals_and_sid_as_div()
{
$json_imagecfg = base64_encode(serialize($GLOBALS["shop_setup"]["image_config"]));
$div = <<