Miscellany

<?php 
#   Copyright by: Manuel Staechele
#   Support: www.ilch.de


defined ('main') or die ( 'no direct access' );



$title = $allgAr['title'].' :: Referenzen';
$hmenu = 'Referenzen';
$design = new design ( $title , $hmenu );



function referenzen_find_kat ($kat) {
    
		$katpfad = 'include/images/referenzen/';
		$katjpg = $katpfad.$kat.'.jpg';
		$katgif = $katpfad.$kat.'.gif';
		$katpng = $katpfad.$kat.'.png';
		
		if ( file_exists( $katjpg ) ) {
		  $pfadzumBild = $katjpg;
		} elseif ( file_exists ( $katgif ) ) {
		  $pfadzumBild = $katgif;
		} elseif ( file_exists ( $katpng ) ) {
		  $pfadzumBild = $katpng;
		}
		
		if ( !empty( $pfadzumBild ) ) {
			$kategorie = '<img style="" src="'.$pfadzumBild.'" alt="'.$kat.'">';
		} else {
		  $kategorie = '<b>'.$kat.'</b><br /><br />';
		}
		
		return ( $kategorie );
}



if ( !is_numeric($menu->get(1)) )  {
  if($menu->get(1) == 'rss' || $menu->get(1) == 'atom')
  {
      #ob_clean();
      $feed_type = $menu->get(1);
      
    $abf = "SELECT MAX(referenzen_time) AS last_update FROM prefix_referenzen";
    $erg = db_query($abf);
    $row = db_fetch_assoc($erg);
    $last_update = str_replace(' ', 'T', $row['last_update']) . 'Z';
    
    $abf = "SELECT
      a.referenzen_title as title,
      a.referenzen_id as id,";
    $abf .= ($feed_type == 'atom') ? 'a.referenzen_time as datum,' : "DATE_FORMAT(a.referenzen_time,'%a, %e %b %y %H:%i:%s') as datum,"; 
    $abf .=  
     "a.referenzen_kat as kate,
      a.referenzen_text as text,
     a.referenzen_designer as designer,
    a.referenzen_slicer as slicer,
    a.referenzen_anpasser as anpasser,
    a.referenzen_code as code,
    a.referenzen_preis as preis,
    a.referenzen_anmerkung as anmerkung,
    a.referenzen_vprogramme as vprogramme,
    a.referenzen_zeit as zeit,
    a.referenzen_release as release,
    a.referenzen_name as name,
    a.referenzen_nname as nname,
    a.referenzen_email as email,
    a.referenzen_icq as icq,
    a.referenzen_hp as hp,
      b.name as username
    FROM prefix_referenzen as a
    LEFT JOIN prefix_user as b ON a.user_id = b.id
    WHERE a.referenzen_recht = 0
    ORDER BY referenzen_time ASC LIMIT 15";
    $erg = db_query($abf);
    $tpl = new tpl( 'referenzen_'.$menu->get(1).'.htm' );
    
    header('Content-type: application/' . $menu->get(1)  . '+xml');

    $tpl->set_ar_out(array('FEEDTITLE' => $allgAr['title'],
                           'UPDATED' => $last_update), 0);
    while ($row = db_fetch_assoc($erg))
    {
      if($feed_type == 'atom')
      {
          $row['datum'] = str_replace(' ', 'T', $row['datum']) . 'Z';
      }
      
      $a = explode('[PREVIEWENDE]', $row['text']);
      $tpl->set_ar_out(array('TITLE' => $row['title'],
                             'TXT' => bbcode($a[0]),
                             'LINK' => 'http://' . $_SERVER['HTTP_HOST'] . dirname($_SERVER['PHP_SELF']). '/index.php?referenzen-' . $row['id'],
                             'AUTHOR' => $row['username'],
                             'DATE' => $row['datum']
                             ), 1);
    }
    $tpl->out(2);
    exit;
  }
  else
  {
    $design->header();
    $limit = $allgAr['Nlimit'];
    $page = ( $menu->getA(1) == 'p' ? $menu->getE(1) : 1 );
    $MPL = db_make_sites ($page , "WHERE referenzen_recht >= ".$_SESSION['authright'] , $limit , '?referenzen' , 'referenzen' );
    $anfang = ($page - 1) * $limit;
    
    $tpl = new tpl ( 'referenzen.htm' );
    
    $abf = "SELECT
      a.referenzen_title as title,
      a.referenzen_id as id,
      DATE_FORMAT(a.referenzen_time,'%d. %m. %Y') as datum,
      DATE_FORMAT(a.referenzen_time,'%W') as dayofweek,
      a.referenzen_kat as kate,
      a.referenzen_text as text,
    a.referenzen_designer as designer,
    a.referenzen_slicer as slicer,
    a.referenzen_anpasser as anpasser,
    a.referenzen_code as code,
    a.referenzen_preis as preis,
    a.referenzen_anmerkung as anmerkung,
    a.referenzen_vprogramme as vprogramme,
    a.referenzen_zeit as zeit,
    a.referenzen_release as release,
    a.referenzen_name as name,
    a.referenzen_nname as nname,
    a.referenzen_email as email,
    a.referenzen_icq as icq,
    a.referenzen_hp as hp,
      b.name as username
    FROM prefix_referenzen as a
    LEFT JOIN prefix_user as b ON a.user_id = b.id
    WHERE ".$_SESSION['authright']." <= a.referenzen_recht
       OR a.referenzen_recht = 0
    ORDER BY referenzen_time DESC 
    LIMIT ".$anfang.",".$limit;
    #echo '<pre>'.$abf.'</pre>';
    
    $erg = db_query($abf);
    while ($row = db_fetch_assoc($erg)) {
      
      $k0m  = db_query("SELECT COUNT(ID) FROM `prefix_koms` WHERE uid = ".$row['id']." AND cat = 'referenzen'");
      $row['kom']  = db_result($k0m,0);
      
      $row['kate'] = referenzen_find_kat($row['kate']);
      $row['datum'] = $lang[$row['dayofweek']].' '.$row['datum'];
      if ( strpos ( $row['text'] , '[PREVIEWENDE]' ) !== FALSE ) {
        $a = explode('[PREVIEWENDE]' , $row['text']);
        $row['text'] = $a[0];
      }
      $row['text'] = bbcode($row['text']);
      $tpl->set_ar_out($row,0);
    }
    $tpl->set_out('SITELINK', $MPL,1);
    unset($tpl);
  }

  
  
} else {
 
 $design->header();
 $nid = escape($menu->get(1), 'integer');
 $row = db_fetch_object(db_query("SELECT * FROM `prefix_referenzen` WHERE referenzen_id = '".$nid."'"));

  if ( has_right(array($row->referenzen_recht)) ) {
    $komsOK = true;
	  if ( $allgAr['Ngkoms'] == 0 ) {
      if ( loggedin() ) {
        $komsOK = true;
  		} else {
	  	  $komsOK = false;
		  }
    }
	  if ( $allgAr['Nukoms'] == 0 ) {
	    $komsOK = false;
	  }

    # kommentar add
  	if ( (loggedin() OR chk_antispam ('referenzenkom')) AND $komsOK AND !empty($_POST['name']) AND !empty($_POST['txt']) ) {
      $_POST['txt'] = escape($_POST['txt'],'string');
		  $_POST['name'] = escape($_POST['name'],'string');
      db_query("INSERT INTO `prefix_koms` VALUES ('',".$nid.",'referenzen','".$_POST['name']."','".$_POST['txt']."')");
	  } 
	  # kommentar add
		
    # kommentar loeschen
    if ($menu->getA(2) == 'd' AND is_numeric($menu->getE(2)) AND has_right(-7, 'referenzen')) {
      $kommentar_id = escape($menu->getE(2),'integer');
      db_query("DELETE FROM prefix_koms WHERE uid = ".$nid." AND cat = 'referenzen' AND id = ".$kommentar_id);
    }
    # kommentar loeschen
    $kategorie = referenzen_find_kat($row->referenzen_kat);
		
		$textToShow = bbcode($row->referenzen_text);
		$textToShow = str_replace('[PREVIEWENDE]','',$textToShow);
		if ( !empty($such) ) {
		  $textToShow = markword($textToShow,$such);
		}
		
		$tpl = new tpl ( 'referenzen.htm' );
		$ar = array (
      'TEXT'  => $textToShow,
			'KATE'  => $kategorie,
      'NID' => $nid,
      'uname' => $_SESSION['authname'],
			'ANTISPAM' => (loggedin()?'':get_antispam ('referenzenkom', 0)),
			'NAME'  => $row->referenzen_title
		);
		$tpl->set_ar_out($ar, 2 );
		
		if ($komsOK) {
		  $tpl->set_ar_out ( array ( 'NAME' => $row->referenzen_title , 'NID' => $nid ), 3 );
		}
    $erg1 = db_query("SELECT text, name, id FROM `prefix_koms` WHERE uid = ".$nid." AND cat = 'referenzen' ORDER BY id DESC");
		$ergAnz1 = db_num_rows($erg1);
		if ( $ergAnz1 == 0 ) {
		  echo '<b>'.$lang['nocomments'].'</b>';
		} else {
		  $zahl = $ergAnz1;
		  while ($row1 = db_fetch_assoc($erg1)) {
        $row1['text'] = bbcode(trim($row1['text']));
        if (has_right(-7, 'referenzen')) {
          $row1['text'] .= '<a href="?referenzen-'.$nid.'-d'.$row1['id'].'"><img src="include/images/icons/del.gif" alt="l&ouml;schen" border="0" title="l&ouml;schen" /></a>';
        }
        $tpl->set_ar_out( array('NAME' => $row1['name'], 'TEXT' => $row1['text'], 'ZAHL' => $zahl ) , 4 );
        $zahl--;
		  }
    }
	}
  $tpl->out(5);
}

$design->footer();

?>