CONTENIDO Forum

Code: Alles auswählen

if ($public == 1 AND $visible == 1 AND  $online == 1) { 

Code: Alles auswählen

if ($visible == 1 AND  $online == 1) {

Code: Alles auswählen

<?php 
/*********************************************** 
* Article Include Output for Printing 
* 
* Author      :     Willi Man 
* Copyright   :     Contenido - four for business 
* Created     :     18-12-2003 
* Modified    :     02-01-2004 
* Modified    :     05-08-2005, Andreas Lindner 
* Modified    :     20-11-2006, schlaucher 
************************************************/ 

#Get current settings 
//$cms_idcat = "CMS_VALUE[1]"; 
//$cms_idcatart = "CMS_VALUE[2]"; 

$bDebug = false; 
if ($bDebug) echo "<pre> cat $cms_idcat catart $cms_idcatart</pre>"; 

if ((strlen($cms_idcat) > 0 AND $cms_idcat != '0') AND (strlen($cms_idcatart) > 0 AND $cms_idcatart != '0')) { 
   if (strlen($cms_idcatart) > 0 AND $cms_idcatart > 0) {       
      #Get idart from database 
      $sql = "SELECT idcat, idart 
            FROM ".$cfg["tab"]["cat_art"]." 
            WHERE idcatart='".$cms_idcatart."'"; 
      if ($bDebug) {echo "<pre>";print_r($sql);echo "</pre>";} 
       $db->query($sql); 
       $db->next_record(); 

       $cms_catid = $db->f("idcat"); 
       $cms_artid = $db->f("idart"); 
        
         $db->free();       
   } 
    
   if ($cms_idcatart == 0) { 
      $cms_catid = $cms_idcat; 
             
      $sql = "SELECT A.idart, B.lastmodified 
            FROM ".$cfg["tab"]["cat_art"]." AS A, ".$cfg["tab"]["art_lang"]." AS B 
            WHERE 
               A.idart = B.idart AND 
               B.online = 1 AND 
               A.idcat = '".$cms_idcat."' 
               ORDER BY B.lastmodified DESC"; 
                
      if ($bDebug) {echo "<pre>";print_r($sql);echo "</pre>";} 
       $db->query($sql); 
        
       if ($db->next_record()) { 
          $cms_artid = $db->f("idart"); 
          $lastmod = $db->f('lastmodified'); 
       } 
        
         $db->free(); 
          
      $sql = "SELECT idcatart 
            FROM ".$cfg["tab"]["cat_art"]." 
            WHERE 
               idart = '".$cms_artid."' AND 
               idcat = '".$cms_catid."' "; 
                
      if ($bDebug) {echo "<pre>";print_r($sql);echo "</pre>";} 
       $db->query($sql); 
        
       if ($db->next_record()) { 
          $cms_idcatart = $db->f("idcatart"); 
       } 
        
         $db->free();          
   }    
    
    #Check if category is online or protected 
    $sql = "SELECT public, visible FROM ".$cfg["tab"]["cat_lang"]." WHERE idcat='".$cms_catid."' AND idlang='".$lang."'"; 
   if ($bDebug) {echo "<pre>";print_r($sql);echo "</pre>";} 
    $db->query($sql); 
    $db->next_record(); 

    $public = $db->f("public"); 
    $visible = $db->f("visible"); 
        
    $db->free(); 

    #Check if article is online 
    $sql = "SELECT online FROM ".$cfg["tab"]["art_lang"]." WHERE idart='".$cms_artid."' AND idlang='".$lang."'"; 
   if ($bDebug) {echo "<pre>";print_r($sql);echo "</pre>";} 
    $db->query($sql); 
    $db->next_record(); 

    $online = $db->f("online"); 
        
    $db->free(); 

    #If the article is online and the according category is not protected and visible, include the article 

    if ($public == 1 AND $visible == 1 AND  $online == 1) { 
      #Check if code creation is necessary 
       $sql = "SELECT 
                createcode 
            FROM 
                ".$cfg["tab"]["cat_art"]." 
            WHERE 
                idcat = '".$cms_catid."' AND 
                idart = '".$cms_artid."'"; 
      if ($bDebug) {echo "<pre>";print_r($sql);echo "</pre>";} 
      $db->query($sql); 
      if ($db->next_record()) { 
         $createcode = $db->f("createcode"); 
      } else { 
         $createcode = 1; 
      } 
    
      $db->free(); 
       
      #Create code if necessary 
      if ($createcode == 1) { 
         cInclude('includes', 'functions.con.php'); 
         cInclude('includes', 'functions.tpl.php'); 
         cInclude('includes', 'functions.mod.php'); 
          
           conGenerateCode($cms_catid, $cms_artid, $lang, $client); 
      } 
       
      #Get code from database and execute it 
      $sql = "SELECT code FROM ".$cfg["tab"]["code"]." WHERE idcatart = '".$cms_idcatart."' AND idlang = '".$lang."'"; 
      if ($bDebug) {echo "<pre>";print_r($sql);echo "</pre>";} 

      $db->query($sql); 
      if ($db->next_record()) { 
         $code = stripslashes($db->f("code")); 
          
         $db->free(); 
          
         ob_start(); 
       
         eval("?> 
".$code." 
<?php 
"); 
    
         $code = ob_get_contents(); 
    
         #Clean buffer 
         ob_end_clean(); 
         $code2 = "";

         do {
             $startpos = strpos($code, "<!--start:content-->"); 
             $endpos = strpos($code, "<!--end:content-->"); 
             $difflen = $endpos - $startpos; 
             $code2 .= substr($code, $startpos, $difflen);   
             $code = substr($code, $endpos+20);              
         }
         while($startpos > 0);

            echo '<div id="print_button"><button class="button_print" onclick="self.print();">Drucken</button>&nbsp;&nbsp;&nbsp;&nbsp;<button class="button_print" onclick="self.close();">Schließen</button></div><hr>'; 
         echo $code2; 
      } else { 
         echo "<!-- ERROR in module Article Include<pre>no code created for article to include!<br>idcat $cms_catid, idart $cms_artid, idlang $lang, idclient $client</pre>-->"; 
      } 
    } 
} 

?>