Verschiedene Publikationen

Zur Kathedrale des Bistums Dresden-Meißen sind verschiedene Publikationen erhältlich. Wir stellen Ihnen hier eine Übersicht vor.

Zur Kathedrale des Bistums Dresden-Meißen sind verschiedene Publikationen erhältlich. Wir stellen Ihnen hier eine Übersicht vor.

s moduls $uploadpfad = "/upload/"; // relativ zum root-verzeichnis (mit slash am anfang und am ende) $thumbnailpfad = "/upload/auto_thumbnails/"; //relativ zum root-verzeichnis (mit slash am anfang und am ende) // konfiguration $categorie = "1822"; $angezeigte_anzahl = "10"; if ($angezeigte_anzahl == '') $angezeigte_anzahl = 10; $startartikel = "$C15"; if ($startartikel == '') $startartikel = false; $subheadline = "100"; if ($subheadline == '') $subheadline = 200; $navigationslink['previous'] = "zurück"; if ($navigationslink['previous'] == '') $navigationslink['previous'] = '[:: rückwärts ]'; $navigationslink['next'] = "weiter"; if ($navigationslink['next'] == '') $navigationslink['next'] = '[ vorwärts ::]'; $ebene = "0"; $bildbreite = "100"; $limit = (isset($_GET['displaylimit']) && $_GET['displaylimit'] > 0)?($_GET['displaylimit']):(0); $db = cRegistry::getDb(); $db2 = cRegistry::getDb(); // wenn startartikel true ist, werden die startartikel dargestellt, sonst nicht // $nurstartartikel = ($startartikel)?(''):('AND d.is_start = 0'); // alte fassung $nurstartartikel = ($startartikel)?(''):('AND d.idart != f.startidartlang'); // liest die anzahl betroffener artikel aus der datenbank switch ($ebene) { case -2: $sql_1 = " SELECT count(*) AS anzahl FROM ({$cfg['tab']['cat']} AS a, {$cfg['tab']['cat']} AS b, {$cfg['tab']['cat']} AS c) LEFT JOIN {$cfg['tab']['cat_art']} AS d ON c.idcat = d.idcat LEFT JOIN {$cfg['tab']['art_lang']} AS e ON d.idart = e.idart LEFT JOIN {$cfg['tab']['cat_lang']} AS f ON a.idcat = f.idcat WHERE ( ( c.parentid = b.idcat AND b.parentid = a.idcat ) OR ( c.idcat = b.idcat AND b.parentid = a.idcat ) OR ( c.idcat = b.idcat AND b.idcat = a.idcat ) ) AND a.idcat = $categorie AND e.online = 1 AND e.redirect = 0 AND e.external_redirect = 0 AND e.idlang = $lang $nurstartartikel "; $sql_2 = " SELECT c.idcat, d.idart, e.idartlang, e.artsort, e.published, e.created, DATE_FORMAT(e.created,'%d.%m.%y') AS erstellungsdatum FROM ({$cfg['tab']['cat']} AS a, {$cfg['tab']['cat']} AS b, {$cfg['tab']['cat']} AS c) LEFT JOIN {$cfg['tab']['cat_art']} AS d ON c.idcat = d.idcat LEFT JOIN {$cfg['tab']['art_lang']} AS e ON d.idart = e.idart LEFT JOIN {$cfg['tab']['cat_lang']} AS f ON a.idcat = f.idcat WHERE ( ( c.parentid = b.idcat AND b.parentid = a.idcat ) OR ( c.idcat = b.idcat AND b.parentid = a.idcat ) OR ( c.idcat = b.idcat AND b.idcat = a.idcat ) ) AND a.idcat = $categorie AND e.online = 1 AND e.redirect = 0 AND e.external_redirect = 0 AND e.idlang = $lang $nurstartartikel ORDER BY e.artsort ASC, e.created DESC LIMIT $limit, $angezeigte_anzahl "; break; case -1: $sql_1 = " SELECT count(*) AS anzahl FROM ({$cfg['tab']['cat']} AS a, {$cfg['tab']['cat']} AS b, {$cfg['tab']['cat']} AS c) LEFT JOIN {$cfg['tab']['cat_art']} AS d ON b.idcat = d.idcat LEFT JOIN {$cfg['tab']['art_lang']} AS e ON d.idart = e.idart LEFT JOIN {$cfg['tab']['cat_lang']} AS f ON a.idcat = f.idcat WHERE ( ( c.idcat = b.idcat AND b.parentid = a.idcat ) OR ( c.idcat = b.idcat AND b.idcat = a.idcat ) ) AND a.idcat = $categorie AND e.online = 1 AND e.redirect = 0 AND e.external_redirect = 0 AND e.idlang = $lang $nurstartartikel "; $sql_2 = " SELECT c.idcat, d.idart, e.idartlang, e.artsort, e.published, e.created, DATE_FORMAT(e.created,'%d.%m.%y') AS erstellungsdatum FROM ({$cfg['tab']['cat']} AS a, {$cfg['tab']['cat']} AS b, {$cfg['tab']['cat']} AS c) LEFT JOIN {$cfg['tab']['cat_art']} AS d ON c.idcat = d.idcat LEFT JOIN {$cfg['tab']['art_lang']} AS e ON d.idart = e.idart LEFT JOIN {$cfg['tab']['cat_lang']} AS f ON a.idcat = f.idcat WHERE ( ( c.idcat = b.idcat AND b.parentid = a.idcat ) OR ( c.idcat = b.idcat AND b.idcat = a.idcat ) ) AND a.idcat = $categorie AND e.online = 1 AND e.redirect = 0 AND e.external_redirect = 0 AND e.idlang = $lang $nurstartartikel ORDER BY e.artsort ASC, e.created DESC LIMIT $limit, $angezeigte_anzahl "; break; case 0: $sql_1 = " SELECT count(*) AS anzahl FROM ({$cfg['tab']['cat']} AS a, {$cfg['tab']['cat']} AS b, {$cfg['tab']['cat']} AS c) LEFT JOIN {$cfg['tab']['cat_art']} AS d ON c.idcat = d.idcat LEFT JOIN {$cfg['tab']['art_lang']} AS e ON d.idart = e.idart LEFT JOIN {$cfg['tab']['cat_lang']} AS f ON c.idcat = f.idcat WHERE ( ( c.idcat = b.idcat AND b.idcat = a.idcat ) ) AND a.idcat = $categorie AND e.online = 1 AND e.redirect = 0 AND e.external_redirect = 0 AND e.idlang = $lang $nurstartartikel "; $sql_2 = " SELECT c.idcat, d.idart, e.idartlang, e.artsort, e.created, DATE_FORMAT(e.created,'%d.%m.%y') AS erstellungsdatum FROM ({$cfg['tab']['cat']} AS a, {$cfg['tab']['cat']} AS b, {$cfg['tab']['cat']} AS c) LEFT JOIN {$cfg['tab']['cat_art']} AS d ON c.idcat = d.idcat LEFT JOIN {$cfg['tab']['art_lang']} AS e ON d.idart = e.idart LEFT JOIN {$cfg['tab']['cat_lang']} AS f ON c.idcat = f.idcat WHERE ( ( c.idcat = b.idcat AND b.idcat = a.idcat ) ) AND a.idcat = $categorie AND e.online = 1 AND e.idlang = $lang $nurstartartikel ORDER BY e.artsort ASC, e.created DESC LIMIT $limit, $angezeigte_anzahl "; break; } $db->query($sql_1); $db->next_record(); $anzahl_artikel = $db->f("anzahl"); $db->query($sql_2); echo "
\n"; while ($db->next_record()) { echo "
\n"; $sql = " SELECT a.value, a.typeid, b.type, c.filename, c.dirname FROM {$cfg['tab']['content']} AS a LEFT JOIN {$cfg['tab']['type']} AS b ON a.idtype = b.idtype LEFT JOIN {$cfg['tab']['upl']} AS c ON a.value = c.idupl WHERE a.idartlang = ".$db->f("idartlang")." AND ( b.type = 'CMS_HTMLHEAD' OR b.type = 'CMS_IMG' ) ORDER BY b.type, a.typeid ASC "; // print "

$sql

"; $db2->query($sql); $db2->next_record(); $link = $sess->url("/".$db->f("idcat")."&idart=".$db->f("idart")); $ueberschrift = "

".urldecode($db2->f("value"))."

\n"; $datum = "".$db->f("erstellungsdatum")."\n"; $weiter = "Meldung lesen\n"; $db2->next_record(); // die subheadline auf die gewünschte länge reduzieren (trennung nur // nach bzw. vor einem ganzen wort if (strlen($db2->f("value")) > $subheadline) { $newsubheadline = ''; $worte = explode (" ",strip_tags(urldecode($db2->f("value")))); $zulang = false; foreach ($worte as $wort) { if (strlen($newsubheadline." ".$wort) >= $subheadline) $zulang = true; $newsubheadline = (!$zulang)?($newsubheadline." ".$wort):($newsubheadline); } $newsubheadline .= "..."; } else { $newsubheadline = strip_tags(urldecode($db2->f("value"))); } $bild_vorhanden = false; while ($db2->next_record()) { if ($db2->f("type") == 'CMS_IMG' && $db2->f("typeid") == 1) { $bilddateiname = "{$thumbnailpfad}{$bildbreite}_".$db2->f("value").".jpg"; if (!file_exists($cfg['path']['frontend'].$bilddateiname)) { $src_image_size = getimagesize($cfg['path']['frontend'].$uploadpfad.$db2->f("dirname").$db2->f("filename")); $bildhoehe = round($src_image_size[1] * $bildbreite / $src_image_size[0]); if ($bildhoehe > $bildbreite) { $bildhoehe = $bildbreite; $bildbreite = round($src_image_size[0] * $bildhoehe / $src_image_size[1]); } $dst_im = imagecreatetruecolor($bildbreite,$bildhoehe); if ($src_image_size[2] == 1) { $src_im = imagecreatefromGIF($cfg['path']['frontend'].$uploadpfad.$db2->f("dirname").$db2->f("filename")); } elseif ($src_image_size[2] == 2) { $src_im = @ImageCreateFromJPEG($cfg['path']['frontend'].$uploadpfad.$db2->f("dirname").$db2->f("filename")); } else { $src_im = imagecreatefromgd($cfg['path']['frontend'].$uploadpfad.$db2->f("dirname").$db2->f("filename")); } imagecopyresampled ($dst_im,$src_im,0,0,0,0,$bildbreite,$bildhoehe,$src_image_size[0],$src_image_size[1]); imagejpeg ($dst_im,$cfg['path']['frontend'].$bilddateiname,100); } $bild_vorhanden = true; } } if ($bild_vorhanden) { $width = "100"; $width += 5; $bild = "
\n"; $unterzeile = "
$newsubheadline
\n"; } else { $bild = ""; $unterzeile = "
$newsubheadline
\n"; } $text = $bild; $text .= $ueberschrift; $text .= $unterzeile; // $text .= "

".$datum." - ".$weiter."

"; $text .= "
\n"; echo $text; } echo "
"; if ($limit > 0 || $anzahl_artikel > $limit + $angezeigte_anzahl) { echo ''; if ($limit > 0) { $displaylimit = ($limit - $angezeigte_anzahl >= 0)?($limit - $angezeigte_anzahl):(0); echo ""; } else { echo ''; } if ($anzahl_artikel > $limit + $angezeigte_anzahl) { $displaylimit = $limit + $angezeigte_anzahl; echo ""; } else { echo ''; } echo '
url("/?displaylimit=%24displaylimit")."\">{$navigationslink['previous']} url("/?displaylimit=%24displaylimit")."\">{$navigationslink['next']} 

'; } ?>


RSS-Feed | Newsletter | Sitemap | Impressum | Datenschutz