CONTENIDO Forum

Code: Alles auswählen

          $sql = "SELECT ".$cfg["tab"]["content"].".*,".$cfg["tab"]["art_lang"].".summary  
                  FROM ".$cfg["tab"]["content"]." 
                  left join ".$cfg["tab"]["art_lang"]." 
                  on ".$cfg["tab"]["content"].".idartlang=".$cfg["tab"]["art_lang"].".idartlang   
                  WHERE ".$cfg["tab"]["content"].".idartlang = '$value' 
                  AND ".$cfg["tab"]["content"].".idtype = '1' 
                  AND ".$cfg["tab"]["content"].".typeid = '1'";

Code: Alles auswählen

<?
/***********************************************
* CONTENIDO MODUL - OUTPUT
*
* Erweiterte Artikel liste
*
* Liste von Artikeln mit mehreren Daten basierend 
* auf 4fb referenz modul
*
* Author      :     Evert Smit
* Copyright   :     4fB
* Created     :     13-07-2003
* Modified    :     16-08-2002
************************************************/

// second db class instance
$db2 = new DB_Contenido;

// selected category
$selcat = "CMS_VALUE[0]";

 if($selcat!="0" && $selcat!=""){

// select all articles in category widthout start article
$query = "SELECT ARTLANG.idart, ARTLANG.idartlang FROM ".$cfg["tab"]["cat_art"]." AS CATART, ".
          $cfg["tab"]["art_lang"]." AS ARTLANG ".
         "WHERE CATART.idcat = '$selcat' AND ARTLANG.idart = CATART.idart AND ARTLANG.idlang = '$lang' AND ".
         "ARTLANG.online = '1' ORDER BY CATART.idart DESC";

// execute query
$db->query($query);

unset($articleID);
unset($linkID);

// get id's of sub articles
while ($db->next_record()) {
  $articleID[] = $db->f("idartlang");
  $linkID[] = $db->f("idart");
} // end while

// loop through subarticles

echo '
<table width="70%" border="0" cellspacing="0" cellpadding="0">
<tr><td class=titel>CMS_VALUE[2]</td></tr><TR><TD><UL>
';

if (is_array($articleID)) {

    foreach ($articleID as $key => $value) {

          // select all CMS variables of the article
          $sql = "SELECT ".$cfg["tab"]["content"].".*,".$cfg["tab"]["art_lang"].".summary  
                  FROM ".$cfg["tab"]["content"]." 
                  left join ".$cfg["tab"]["art_lang"]." 
                  on ".$cfg["tab"]["content"].".idartlang=".$cfg["tab"]["art_lang"].".idartlang   
                  WHERE ".$cfg["tab"]["content"].".idartlang = '$value' 
                  AND ".$cfg["tab"]["content"].".idtype = '1' 
                  AND ".$cfg["tab"]["content"].".typeid = '1'";

          $db->query($sql);
          $db->next_record();

          // select and resolve image path
          $imagesql="select value from ".$cfg["tab"]["content"]." where idartlang='$value' and idtype='4' and typeid='1'";
          $db2->query($imagesql);
          $db2->next_record();
          $image_id= $db2->f("value");
          // get image name and path

          $imagesql="select * from ".$cfg["tab"]["upl"]." where idupl='$image_id'";
          $db2->query($imagesql);
          $db2->next_record();
          $webdir='upload/';
          $thumbdir='thumbnails/';
          $filedir='/home/www/contenido/motosommer/';
          $imagelocation=$filedir.$webdir.$db2->f('dirname').$db2->f('filename');
          $thumblocation=$filedir.$webdir.$thumbdir.$db2->f('filename');
          if (!file_exists($thumblocation)){
          	// create thunbnail
		        $fileinformation=getimagesize($imagelocation);
				$imagewidth	=	$fileinformation[0];
				$imageheight	=	$fileinformation[1];
				$imagetype=$db2->f('filetype');
				$imageattributes =	$fileinformation[3];
				//$newfile= $last_id."-image.".$imagetype;
				$target=$thumblocation;
				
				if ( !(copy($imagelocation,$target)))
				{
					echo "Could not copy file to destintaion., Command returned Error Message. Please check your log files. ".$imagelocation." ".$target;
					die;
				}
				
				//create thumbnails 80xrelational height
				// Determine what filetype and set pointer to source image
				switch ($imagetype)
				{
					case "gif":
						$original_image=imagecreatefromgif($target);
						break;
					case "png":
						$original_image=imagecreatefrompng($target);
						break;
					case "jpg":
						$original_image=imagecreatefromjpeg($target);
						break;
				}
				
				if (!$original_image){
					echo 'Error getting image from '.$target.'.';
				}	
				//echo $target;
				// set image width and height of thunbnail and put pointer for filesytsem
				$thumbfile= $db2->f('filename');
				$target_thumb=$thumblocation;
				$t_width=80;
				// calculating height to maintain ratio
				$t_height=(80/$imagewidth)*$imageheight;
				// remove digits to get solid number
				list ($t_height,$notimportand)=explode('.',$t_height);
				// create blank image
				$thumb_image=imagecreate($t_width,$t_height);
				
				// resize image based on height and width
				imagecopyresized($thumb_image,$original_image,0,0,0,0,$t_width,$t_height,$imagewidth,$imageheight);
				// store image on file system
				// requires different functionf for either gif or jpeg
				switch ($imagetype)
				{
					case "gif":
						imagegif($thumb_image,$target_thumb);
						break;
					case "png":
						imagepng($thumb_image,$target_thumb);
						break;
					default:
						imagejpeg($thumb_image,$target_thumb,75);
						break;
				}
				imagedestroy($thumb_image);
				imagedestroy($original_image);
          }
          $image=$webdir.$thumbdir.$db2->f('filename');
			
          $head = $db->f("value");
          $summary= $db->f("summary");

          if ( strlen($head) > CMS_VALUE[3]) {
            $head = substr($head, 0, CMS_VALUE[3]);
            $head .= '..';
          }

          // link
          $link = $sess->url("front_content.php?client=$client&lang=$lang&idcat=$selcat&idart=$linkID[$key]&m=$m&s=$s");
          //echo '<tr><td><A HREF="'.$link.'">'.$db->f("value").'</a></td></tr>';
          echo '<LI><A HREF="'.$link.'">'.$head.'</a><BR>'.$summary.'<img src="'.$image.'">';

    } // end while
echo '</TD></TR>';


          unset($head);
        unset($summary);
        
    } // end foreach
    
} // end if (is_array)

echo '</table><br>';

?>