<?PHP
include "./inc/config.inc.php";
include "./inc/systemeinstellungen.php";
include "./inc/de.php";
include "./system/funktionen.php";
$startzeit = getmicrotime();
db();
$rubrik= $_GET['rubrik'];
$cs= false;
$rubrik_name_sql= mysql_query("SELECT name, besch
FROM ".$dbtable00."
WHERE nummer='".NoI("$rubrik")."' ");
while($ROW=mysql_fetch_assoc($rubrik_name_sql))
{
$cs= true;
$rubriknamen = $ROW['name'];
$beschreibung= $ROW['besch'];
if ($beschreibung =="")
{
$besch="<br><br>";
}
else
{
$besch= '<P class="einsa"><br>'.$beschreibung.'<br><br></P>';
}
$besch2= strip_tags($besch);
$topic= 'Rubrik: ';
$seitentitel= PROJEKT_TITEL1.' - '.PROJEKT_TITEL2.' - '.$topic.$rubriknamen;
}
if($rubrik=="" || $cs== false)
{
}
$eintragzahl= 0;
$mitmachzahl= 0;
// Einträge zählen --------------------------------------
$eintrag_anzahl_sql= mysql_query("SELECT COUNT(*) as 'anzahl'
FROM ".$dbtable02."
WHERE rubrik='".NoI("$rubrik")."'
AND code='1' ");
$eintragzahl = mysql_result($eintrag_anzahl_sql,0,'anzahl');
// Kategorien zählen --------------------------------------
$kategorie_anzahl_sql= mysql_query("SELECT COUNT(*) as 'anzahl'
FROM ".$dbtable01."
WHERE rubrik='".NoI("$rubrik")."' ");
$kategoriezahl = mysql_result($kategorie_anzahl_sql,0,'anzahl');
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=ISO-8859-1">
<TITLE><?PHP echo $seitentitel ?></TITLE>
<link rel="stylesheet" type="text/css" href="./system/<?PHP echo $design_typ ?>">
<?PHP include "./inc/meta.php"; ?>
<meta name="description" content="Wählen Sie eine Kategorie aus der Rubrik: <?PHP echo $rubrik ?>...">
<script
language="JavaScript">
<!--
button1= new Image();
button1.src = "button_home.gif"
button2= new Image();
button2.src = "button_home2.gif"
//-->
</script>
</HEAD>
<BODY BACKGROUND="./gfx/back.gif" TOPMARGIN=0 LEFTMARGIN=0 MARGINWIDTH=0 MARGINHEIGHT=0>
<CENTER>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=980 CLASS="back_x">
<TR VALIGN=TOP ALIGN=LEFT>
<TD HEIGHT=749 WIDTH=980>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=980>
<?PHP
$headerinfo= 'Sie befinden sich hier --> Rubrik: '.$rubriknamen;
include "./inc/header.php";
?>
<TR VALIGN=TOP ALIGN=LEFT>
<TD HEIGHT=253 COLSPAN=2 WIDTH=190>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=190 HEIGHT=253>
<TR ALIGN=LEFT VALIGN=TOP>
<TD>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=190>
<TR VALIGN=TOP ALIGN=LEFT>
<TD HEIGHT=2></TD>
</TR>
<TR VALIGN=TOP ALIGN=LEFT>
<TD WIDTH=190>
<P ALIGN=LEFT class="datum">
<?PHP echo $seitendatum ?></P>
</TD>
</TR>
<TR VALIGN=TOP ALIGN=LEFT>
<TD HEIGHT=4></TD>
</TR>
<TR VALIGN=TOP ALIGN=LEFT>
<TD HEIGHT=216 WIDTH=190>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=190 HEIGHT=216 class="menu_links">
<TR ALIGN=LEFT VALIGN=TOP>
<TD>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=190>
<TR VALIGN=TOP ALIGN=LEFT>
<TD HEIGHT=22 COLSPAN=3 WIDTH=190>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=190 HEIGHT=22 class="menu_links_top">
<TR ALIGN=LEFT VALIGN=TOP>
<TD>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=188>
<TR VALIGN=TOP ALIGN=LEFT>
<TD WIDTH=4 HEIGHT=2><IMG SRC="./gfx/cpl.gif" WIDTH=4 HEIGHT=1 BORDER=0></TD>
<TD WIDTH=184><IMG SRC="./gfx/cpl.gif" WIDTH=184 HEIGHT=1 BORDER=0></TD>
</TR>
<TR VALIGN=TOP ALIGN=LEFT>
<TD></TD>
<TD WIDTH=184>
<P ALIGN=CENTER class="menuber"><?PHP echo $menuli_name ?></P>
</TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
</TD>
</TR>
<TR VALIGN=TOP ALIGN=LEFT>
<TD WIDTH=9 HEIGHT=9><IMG SRC="./gfx/cpl.gif" WIDTH=9 HEIGHT=1 BORDER=0></TD>
<TD WIDTH=173><IMG SRC="./gfx/cpl.gif" WIDTH=173 HEIGHT=1 BORDER=0></TD>
<TD WIDTH=8><IMG SRC="./gfx/cpl.gif" WIDTH=8 HEIGHT=1 BORDER=0></TD>
</TR>
<TR VALIGN=TOP ALIGN=LEFT>
<TD></TD>
<TD WIDTH=173>
<P>
<?PHP include "./inc/menulinks.php"; ?>
</TD>
</TR>
<TR VALIGN=TOP ALIGN=LEFT>
<TD HEIGHT=16 WIDTH=190>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=190 HEIGHT=16>
<TR ALIGN=LEFT VALIGN=TOP>
<TD> </TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
</TD>
<TD COLSPAN=3 WIDTH=596>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=596 HEIGHT=453>
<TR ALIGN=LEFT VALIGN=TOP>
<TD>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=584>
<TR VALIGN=TOP ALIGN=LEFT>
<TD WIDTH=11 HEIGHT=9><IMG SRC="./gfx/cpl.gif" WIDTH=11 HEIGHT=1 BORDER=0></TD>
<TD></TD>
</TR>
<TR VALIGN=TOP ALIGN=LEFT>
<TD HEIGHT=30></TD>
<TD WIDTH=573>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=573 HEIGHT=35>
<TR ALIGN=LEFT VALIGN=TOP>
<TD>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=572>
<TR VALIGN=TOP ALIGN=LEFT>
<TD class="einsa">
<P>
<br>Einträge: <b><?PHP echo $eintragzahl ?></b> | sämtliche Einträge <IMG HEIGHT=11 WIDTH=6 SRC="./gfx/buttcenter.gif" VSPACE=0 HSPACE=0 ALIGN="bottom" BORDER=0 ALT=""><a href="linkliste.php<?PHP echo "?rubrik=$rubrik" ?>" target="_top" class="menu2"> auflisten</a> | nur neue Einträge <IMG HEIGHT=11 WIDTH=6 SRC="./gfx/buttcenter.gif" VSPACE=0 HSPACE=0 ALIGN="bottom" BORDER=0 ALT=""><a href="linklisteneu.php<?PHP echo "?rubrik=$rubrik" ?>" target="_top" class="menu2"> auflisten</a>
</P>
</TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
</TD>
</TR>
<TR VALIGN=TOP ALIGN=LEFT>
<TD HEIGHT=10></TD>
<TD WIDTH=573>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=573 HEIGHT=10 class="kategorien1">
<TR ALIGN=LEFT VALIGN=TOP>
<TD>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=573>
<TR VALIGN=TOP ALIGN=LEFT>
<TD WIDTH=1><IMG SRC="./gfx/cpl.gif" WIDTH=1 HEIGHT=1 BORDER=0></TD>
<TD WIDTH=8><IMG SRC="./gfx/cpl.gif" WIDTH=8 HEIGHT=1 BORDER=0></TD>
<TD WIDTH=554>
<P> <?PHP echo $besch ?>
<!-- Index_start -->
<?PHP
$pos_count = 0;
$rub_count = 0;
$kategorie_name_sql= mysql_query("SELECT nummer, name
FROM ".$dbtable01."
WHERE rubrik='".NoI("$rubrik")."'
ORDER BY name ASC ");
while($ROW=mysql_fetch_assoc($kategorie_name_sql))
{
$mitmachzahl++;
$nummer= $ROW['nummer'];
$kategorie = $ROW['nummer'];
$rubrikname = $ROW['name'];
// Einträge der Rubrik zählen ------------------------------
$eintraege_anzahl_sql= mysql_query("SELECT COUNT(*) as 'anzahl'
FROM ".$dbtable02."
WHERE unterrubrik='".$nummer."'
AND rubrik='".NoI("$rubrik")."'
AND code='1' ");
$ezahl = mysql_result($eintraege_anzahl_sql,0,'anzahl');
if ($ezahl > 0)
{
$ordner= '<IMG HEIGHT=16 WIDTH=18 SRC="./gfx/red.gif" VSPACE=0 HSPACE=0 ALIGN="top" BORDER=0 ALT="">';
$datas= date("d.m.Y");
// Neue Einträge vorhanden? --------------------------------------
$eintrag_neu_sql= mysql_query("SELECT COUNT(*) as 'anzahl'
FROM ".$dbtable02."
WHERE datum='".$datas."'
AND unterrubrik='".$nummer."'
AND code='1' ");
$datazahl = mysql_result($eintrag_neu_sql,0,'anzahl');
if ($datazahl > 0)
{
$ordner= '<IMG HEIGHT=16 WIDTH=18 SRC="./gfx/reda_112.gif" VSPACE=0 HSPACE=0 ALIGN="top" BORDER=0 ALT="">';
}
}
else
{
$ordner= '<IMG HEIGHT=16 WIDTH=18 SRC="./gfx/reda_111.gif" VSPACE=0 HSPACE=0 ALIGN="top" BORDER=0 ALT="">';
}
$pos_count ++;
$rub_count ++;
if ($pos_count==1)
{
echo '<div align="center">
<table width="100%">
<tr>
<td width="48%" valign="TOP"><br><a href="kategorien.php?rubrik='.$rubrik.'&kategorie='.$kategorie.'" target="_top" class="content">'.$ordner.' '.$rubrikname.'</a><span class="vier"><br> Einträge: <span class="alert">'.$ezahl.'</span><br>
</td>
<td width="2%" valign="TOP">
</td>';
}
elseif ($pos_count==2)
{
echo '<td width="48%" valign="TOP"><br><a href="kategorien.php?rubrik='.$rubrik.'&kategorie='.$kategorie.'" target="_top" class="content">'.$ordner.' '.$rubrikname.'</a><span class="vier"><br> Einträge: <span class="alert">'.$ezahl.'</span><br>
</td>
<td width="2%" valign="TOP">
</td>
</tr>
</table>
</div>';
}
if ($pos_count==2)
{
$pos_count=0;
}
if ($rub_count == $kategoriezahl && $pos_count == 1)
{
echo '<td width="48%" valign="TOP" class="content"><br><br><br>
</td>
<td width="2%" valign="TOP">
</td>
</tr>
</table>
</div>';
}
}
if($mitmachzahl== 0)
{
echo '<br><br><center><IMG SRC="./gfx/nokategorie.gif"</center><br><br><br><br><br><br><br><br><br><br><br>';
}
?>
<!-- Index_ende -->
<br><br><br><br><center><a href="javascript:history.back()" class="backsite">Zurück</a><br><br><br></center>
</P>
</TD>
<TD WIDTH=9><IMG SRC="./gfx/cpl.gif" WIDTH=9 HEIGHT=1 BORDER=0></TD>
<TD WIDTH=1><IMG SRC="./gfx/cpl.gif" WIDTH=1 HEIGHT=1 BORDER=0></TD>
</TR>
<TR VALIGN=TOP ALIGN=LEFT>
<TD COLSPAN=5 HEIGHT=15></TD>
</TR>
<TR VALIGN=TOP ALIGN=LEFT>
<TD HEIGHT=41 COLSPAN=4 WIDTH=572>
<?PHP
if($goo_ads_center =="ja")
{ ?>
<center><script type="text/javascript">
<!--
<?PHP echo $goo_adcode_center ?>
//-->
</script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script></center><br>
<?PHP
} ?>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=572 HEIGHT=41 class="kategorien2">
<TR ALIGN=LEFT VALIGN=TOP>
<TD>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=563>
<TR VALIGN=TOP ALIGN=LEFT>
<TD WIDTH=20 HEIGHT=15><IMG SRC="./gfx/cpl.gif" WIDTH=20 HEIGHT=1 BORDER=0></TD>
<TD WIDTH=543 HEIGHT=15><IMG SRC="./gfx/cpl.gif" WIDTH=543 HEIGHT=1 BORDER=0></TD>
</TR>
<TR VALIGN=TOP ALIGN=LEFT>
<TD></TD>
<TD WIDTH=543>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=543 HEIGHT=10>
<TR VALIGN=TOP ALIGN=CENTER>
<P>
<td width="3%">
<td class="smallgrey" width="35%"><IMG HEIGHT=16 WIDTH=18 SRC="./gfx/reda_111.gif" ALIGN="top" BORDER=0 ALT=""> Keine Einträge vorhanden
</td>
<td class="smallgrey" width="35%"><IMG HEIGHT=16 WIDTH=18 SRC="./gfx/red.gif" ALIGN="top" BORDER=0 ALT=""> Einträge vorhanden
</td>
<td class="smallgrey" width="24%"><IMG HEIGHT=16 WIDTH=18 SRC="./gfx/reda_112.gif" ALIGN="top" BORDER=0 ALT=""> Heute neu
</td>
<td width="3%">
</td>
</P>
</TR>
</table>
</TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
</TD>
<TD></TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
</TD>
<TD COLSPAN=3 WIDTH=190>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=190 HEIGHT=453>
<TR ALIGN=LEFT VALIGN=TOP>
<TD>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=190>
<TR VALIGN=TOP ALIGN=LEFT>
<TD HEIGHT=21></TD>
</TR>
<TR VALIGN=TOP ALIGN=LEFT>
<TD HEIGHT=400 WIDTH=190>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=190 HEIGHT=400 class="menu_rechts">
<TR ALIGN=LEFT VALIGN=TOP>
<TD>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=190>
<TR VALIGN=TOP ALIGN=LEFT>
<TD HEIGHT=22 COLSPAN=3 WIDTH=190>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=190 HEIGHT=22>
<TR ALIGN=LEFT VALIGN=TOP>
<TD>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=190>
<TR VALIGN=TOP ALIGN=LEFT>
<TD HEIGHT=22 WIDTH=190>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=190 HEIGHT=22 class="menu_rechts_top">
<TR ALIGN=LEFT VALIGN=TOP>
<TD>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=188>
<TR VALIGN=TOP ALIGN=LEFT>
<TD WIDTH=4 HEIGHT=2><IMG SRC="./gfx/cpl.gif" WIDTH=4 HEIGHT=1 BORDER=0 ALT=""></TD>
<TD WIDTH=184><IMG SRC="./gfx/cpl.gif" WIDTH=184 HEIGHT=1 BORDER=0 ALT=""></TD>
</TR>
<TR VALIGN=TOP ALIGN=LEFT>
<TD></TD>
<TD WIDTH=184>
<P ALIGN=CENTER class="menuber"><?PHP echo $menure_name ?></P>
</TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
</TD>
</TR>
<TR VALIGN=TOP ALIGN=LEFT>
<TD WIDTH=9 HEIGHT=9><IMG SRC="./gfx/cpl.gif" WIDTH=9 HEIGHT=1 BORDER=0 ALT=""></TD>
<TD WIDTH=175><IMG SRC="./gfx/cpl.gif" WIDTH=175 HEIGHT=1 BORDER=0 ALT=""></TD>
<TD WIDTH=6><IMG SRC="./gfx/cpl.gif" WIDTH=6 HEIGHT=1 BORDER=0 ALT=""></TD>
</TR>
<TR VALIGN=TOP ALIGN=LEFT>
<TD></TD>
<TD WIDTH=175>
<P>
<?PHP include "./inc/menurechts.php"; ?>
</P>
</TD>
<TD></TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
</TD>
</TR>
<TR VALIGN=TOP ALIGN=LEFT>
<TD HEIGHT=16></TD>
</TR>
<TR VALIGN=TOP ALIGN=LEFT>
<TD HEIGHT=16 WIDTH=190>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=190 HEIGHT=16>
<TR ALIGN=LEFT VALIGN=TOP>
<TD> </TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
</TD>
</TR>
<?PHP
include "./inc/footer.php";
db_();
?>
</TABLE>
</TD>
</TR>
</TABLE>
</CENTER>
</BODY>
</HTML>