<?
	require 'inc/functions.inc.php';
    	require 'libs/Smarty.class.php';

    $smarty = new Smarty;
    $connect = OpenDB();

    $category = $_REQUEST["category"];

//menupunkte selecten
$query = " SELECT * 
		FROM 
		    kategorie";
$result=mysql_query($query);

while($menu = mysql_fetch_array($result)){
$menue[] = $menu;

}
$smarty->assign("menue", $menue); 

//indexteaser selecten
$query = " SELECT *
		FROM 
		    category_verwaltung as cv, 
		    kategorie as k, 
		    pages as p
		WHERE 
		    cv.cat_id = k.id
		AND 
		    cv.page_id = p.id
		AND 
		    k.category = '$category'";
		    
$result=mysql_query($query);

while($daten = mysql_fetch_array($result)){
$teaser[] = $daten;
$smarty->assign("teaser", $teaser);
$id = $daten['id'];	
echo $id;

	$query_sum = " SELECT sum(review_score) / COUNT(review_score) AS gscore 
			    FROM 
			        reviews 
			    WHERE 
			        page_id = '$id'";
			  
	    $result2 = mysql_query($query_sum); 
	     $score=mysql_fetch_array($result2);
	     $scores = $score['gscore'];
	     $smarty->assign("scores", $scores);
	     echo $scores."
\n";
	     
				
        
}

 	
$smarty->fetch("index_teaser.tpl");
$smarty->assign("icons", $icons);
$smarty->assign("path", $img_url);	
$smarty->display("index.tpl");
?>

<TABLE width="99%" border=1 align="center" cellPadding=0 cellSpacing=0 bordercolor="#000000" class=red>
  <TBODY>
    <TR>
      <TD colspan="2">Kagetgorie :{$category} </TD>
    </TR>
  </TBODY>
</TABLE>
{foreach from=$teaser item="data"}
<TABLE width="99%" border=1 align="center" cellPadding=0 cellSpacing=0 bordercolor="#000000" class=red>
  <TBODY>
    <TR>
      <TD>Name : <span class="headline">{$data.pagename} </span></TD>
      <TD colspan="2" valign="top" class=menu></TD>
    </TR>
    <TR>
      <TD width="160">[img]{$path}{$data.pagescreen}[/img]</TD>
      <TD colspan="2" valign="top" class=menu><div align="justify" class="text">{$data.page_teaser}</div>
      </TD>
    </TR>
    <TR>
      <TD width="160" bgcolor="#CCCCCC" class="in3 Stil1"><div align="center"><font color="#FFFFFF">{$scores}</font></div></TD>
      <TD width="936" valign="top" bgcolor="#CCCCCC"><a href="anzeigen.php?category={$data.category}&article={$data.pagename}">Review
      zu {$data.pagename}lesen</a></TD>
      <TD width="142" valign="top" bgcolor="#CCCCCC"><div align="center"><font size="1" face="Verdana, Arial, Helvetica, sans-serif">{$data.Datum}</font></div></TD>
    </TR>
  </TBODY>
</TABLE>

{/foreach}