CONTENIDO Forum

Code: Alles auswählen

<?php
# Initialization
$bDebug = false;

unset ($aData);
$aData = array();

unset ($aSettings);
$aSettings = array();
$aSettings["ArticleCount"]       = "CMS_VALUE[1]";
$aSettings["TeaserLength"]       = "CMS_VALUE[2]";
$aSettings["HeadlineIdentifier"] = "CMS_VALUE[5]";
$aSettings["TextIdentifier"]     = "CMS_VALUE[6]";
$aSettings["ImageIdentifier"]    = "CMS_VALUE[7]";
$aSettings["ImageWidth"]         = "CMS_VALUE[8]";
$aSettings["ImageHeight"]        = "CMS_VALUE[9]";
$aSettings["ImageFromContent"]   = "CMS_VALUE[10]";

# Checking values
if (!is_numeric($aSettings["ArticleCount"]) || $aSettings["ArticleCount"] <= 0) {
$aSettings["ArticleCount"] = 0;
}
if (!is_numeric($aSettings["TeaserLength"]) || $aSettings["TeaserLength"] <= 0) {
$aSettings["TeaserLength"] = 50;
}
if (!is_numeric($aSettings["ImageWidth"]) || $aSettings["ImageWidth"] <=0) {
$aSettings["ImageWidth"] = 0;
$aSettings["ImageHeight"] = 0;
}
if (!is_numeric($aSettings["ImageHeight"]) || $aSettings["ImageHeight"] <=0) {
$aSettings["ImageWidth"] = 0;
$aSettings["ImageHeight"] = 0;
}

if (!is_object($db2)) {
$db2 = new DB_Contenido;
}
if (!is_object($db3)) {
$db3 = new DB_Contenido;
}

if ($aSettings["ArticleCount"] > 0 && ($aSettings["HeadlineIdentifier"] != "" ||
$aSettings["TextIdentifier"] != "" || $aSettings["ImageIdentifier"] != "")) {
for ($i = 0; $i < $aSettings["ArticleCount"]; $i++) {
$lArtIdentifier = 21 + ($i * 2);
$aData["Item".($i + 1)] = array();

$aData["Item".($i + 1)]["IDCatArt"] = "CMS_VALUE[$lArtIdentifier]";
$aData["Item".($i + 1)]["Headline"] = "&nbsp;";
$aData["Item".($i + 1)]["Text"]     = "&nbsp;";
$aData["Item".($i + 1)]["Image"]    = array();
$aData["Item".($i + 1)]["Image"]["ServerPath"] = "";
$aData["Item".($i + 1)]["Image"]["WebPath"]    = "";

if ($aData["Item".($i + 1)]["IDCatArt"] != "") {
$sql =  "SELECT tblData.value AS value, tblData.idtype AS idtype, tblData.typeid AS typeid FROM ";
$sql .= $cfg["tab"]["cat_art"]." AS tblCatArt, ";
$sql .= $cfg["tab"]["art_lang"]." AS tblArtLang, ";
$sql .= $cfg["tab"]["content"]." AS tblData ";
$sql .= "WHERE tblData.idartlang = tblArtLang.idartlang AND ";
$sql .= "tblArtLang.idlang = '".$lang."' AND ";
$sql .= "tblArtLang.idart = tblCatArt.idart AND ";
$sql .= "tblCatArt.idcatart = '".$aData["Item".($i + 1)]["IDCatArt"]."' AND (";

$sql_items = "";
if ($aSettings["HeadlineIdentifier"] != "") {
$sql_items = "(".$aSettings["HeadlineIdentifier"].")";
}
if ($aSettings["TextIdentifier"] != "") {
if ($sql_items != "") {
$sql_items .= " OR (".$aSettings["TextIdentifier"].")";
} else {
$sql_items = "(".$aSettings["TextIdentifier"].")";
}
}
if ($aSettings["ImageIdentifier"] != "") {
if ($sql_items != "") {
$sql_items .= " OR (".$aSettings["ImageIdentifier"].")";
} else {
$sql_items = "(".$aSettings["ImageIdentifier"].")";
}
}

$sql .= $sql_items.")";   

if ($bDebug) {
echo "<pre>".$sql."</pre>", chr(10);
}

// execute query
$db2->query($sql);

while ($db2->next_record()) {
$sTypeIdentifier = "tblData.idtype = '".$db2->f('idtype')."' AND tblData.typeid = '".$db2->f('typeid')."'";

# Note: The TypeIdentifier for one item may be the same as for another item.
#       Therefore, we are storing the content everywhere as needed
if ($sTypeIdentifier == $aSettings["HeadlineIdentifier"]) {
$aData["Item".($i + 1)]["Headline"] = strip_tags(urldecode($db2->f('value')));
}
if ($sTypeIdentifier == $aSettings["TextIdentifier"]) {
$sTmpValue = strip_tags(urldecode($db2->f('value')));
if (strlen($sTmpValue) > $aSettings["TeaserLength"]) {
$sTmpValue = substr($sTmpValue, 0, $aSettings["TeaserLength"])."...";
}
$aData["Item".($i + 1)]["Text"] = $sTmpValue;
}
if ($sTypeIdentifier == $aSettings["ImageIdentifier"]) {
$sql = "";
if ($aSettings["ImageFromContent"] != "") {
$sTmpValue = urldecode($db2->f('value'));

$regEx = "/<img[^>]*?>.*?/i";
$match = array ();
preg_match($regEx, $sTmpValue, $match);

$regEx = "/(src)(=)(['\"]?)([^\"']*)(['\"]?)/i";
$img = array ();
preg_match($regEx, $match[0], $img);
$img_src = preg_split("/\//", $img[0]);

$img_name = $img_src[count($img_src) - 1];
$img_name = preg_replace("/\"/", "", $img_name);
# $img_split = preg_split("/\./", $img_name);
# $img_type = $img_split[count($img_split) - 1];
# $img_split2 = preg_split("/_/", $img_split[0]);

$name = $img_name;

#if (count($img_split2) > 1) {
#   $img_x = $img_split2[count($img_split2) - 1];
#   $img_y = $img_split2[count($img_split2) - 2];

#   if (is_numeric($img_x) AND is_numeric($img_y)) {
#      $suffix = "_".$img_x."_".$img_y.".".$img_type;
#      $name = preg_replace("/$suffix/", "", $img_name);
#      $name = $name.".[a-zA-Z]{3}";
#   }
#}

if (strlen($name) > 0) {
$sql =  "SELECT dirname, filename FROM ".$cfg["tab"]["upl"]." ";
$sql .= "WHERE filename REGEXP '$name'";
}
} else {
$sql =  "SELECT dirname, filename FROM ".$cfg["tab"]["upl"]." ";
$sql .= "WHERE idupl = '".$db2->f('value')."'";
}

if ($bDebug) {
echo "<pre>".$sql."</pre>";
}

if ($sql != "") {
// execute query
$db3->query($sql);

if ($db3->next_record()) {
$aData["Item".($i + 1)]["Image"]["ServerPath"] = $cfgClient[$client]["upl"]["path"].$db3->f('dirname').$db3->f('filename');
$aData["Item".($i + 1)]["Image"]["WebPath"] = $cfgClient[$client]["upl"]["htmlpath"].$db3->f('dirname').$db3->f('filename');
}
}
}
}
}
}
unset ($db2);
unset ($sql);
unset ($sql_items);
unset ($sIDCatArt);
unset ($sTmpValue);

for ($i = 0; $i < $aSettings["ArticleCount"]; $i++) {
if ($aData["Item".($i + 1)]["IDCatArt"] != "") {
$href = $sess->url("front_content.php?idcatart=".$aData["Item".($i + 1)]["IDCatArt"]);
echo '<div id="area'.($i + 1).'">', chr(10);
if ($aSettings["ImageWidth"] == 0 || $aSettings["ImageHeight"] == 0) {
$image = $aData["Item".($i + 1)]["Image"]["WebPath"];
} else {
if ($aData["Item".($i + 1)]["Image"]["ServerPath"] != "" && file_exists($aData["Item".($i + 1)]["Image"]["ServerPath"])) {
#Scale image
$image = capiImgScale($aData["Item".($i + 1)]["Image"]["ServerPath"], $aSettings["ImageWidth"], $aSettings["ImageHeight"], false, false, 10, false);
} else {
$image = $aData["Item".($i + 1)]["Image"]["WebPath"];
}
}

#Get dimensions of the image
echo '<table width="100%" border="0" cellspacing="0" cellpadding="0">';
echo '<tr valign="top">';
echo '<td width="150">';

list ($width, $height, $type, $attr) = getimagesize($image);

if ($image !== "") {
echo '   
<div id="image"><img src="'.$image.'" width="'.$width.'" height="'.$height.'" /></div>', chr(10);
}
echo '</td>';
echo '<td>';
echo '<div id="headline" class="small">'.$aData["Item".($i + 1)]["Headline"].'</div>', chr(10);
echo '<br>';
echo '<div id="text">'.$aData["Item".($i + 1)]["Text"].'<br /><br><a href="'.$href.'", target="{BLANC}"><img src="images/zum_shop.gif" border="0"/>'.mi18n("").'</a></div>', chr(10);
echo '</div>', chr(10);
echo '</td>';
echo '</tr>';
echo '</table>';
echo '<img src="images/line_liste.gif">';
echo '<br>';

}
}
}
?>