Hi ich bins nochmal. Also an
Code: Alles auswählen
$sql = "SELECT level FROM $cfgTab_cat_tree WHERE idcat=$newcat";
kannst net liegen da es in der Sitemap doch richig ist. Ich poste mal den code der Sitemap.
Hier der
INPUT
Code: Alles auswählen
// Variablendeklarationen
// Das Modul ist für eine ältere Contenido-VErsion - offensichtlich hießen Variablen damals anders...
$cfgTab_cat_tree = $cfg['tab']['cat_tree'];
$cfgTab_cat = $cfg['tab']['cat'];
$cfgTab_cat_lang = $cfg['tab']['cat_lang'];
// selected category
$selected = "CMS_VALUE[0]";
echo "<table cellspacing=\"0\" cellpadding=\"10\" border=\"0\">
<tr valign=\"top\">
<td>Kategorie wählen:</td>
<td>
<select name=\"CMS_VAR[0]\">
<option value='0'>---Alle---</option>
";
// fetch all categorys
$query = "SELECT A.idcat, A.level, C.name FROM $cfgTab_cat_tree AS A, ".
"$cfgTab_cat AS B, $cfgTab_cat_lang AS C WHERE A.idcat=B.idcat ".
"AND B.idcat=C.idcat AND C.idlang='$lang' AND B.idclient='$client' ".
"AND C.visible=1 ORDER BY A.idtree";
// execute query
$db->query($query);
// loop result and build the options
while ($db->next_record()) {
// indent spacer
$spaces = "";
// how many levels
$levels = $db->f("level");
for ($i = 0; $i > $levels; $i ++) {
// add 2 spaces for every level
$spaces = $spaces . " ";
} // end for
if ($selected == $db->f("idcat")) {
// selected category
echo "<option selected=\"selected\" value=\"". $db->f("idcat") ."\">". $spaces . $db->f("name") ."</option>
";
} else {
// category
echo "<option value=\"". $db->f("idcat") ."\">". $spaces . $db->f("name") ."</option>
";
} // end if
} // end while
echo " </select>
</td>
</tr>
<tr>
<td>Anzahl Ebene:</td>
<td>
<input type=\"text\" name=\"CMS_VAR[1]\" value=\"CMS_VALUE[1]\" size=\"20\"></td>
</tr>
</table>";
Und hier der
OUTPUT
Code: Alles auswählen
<style type="text/css">
a.lev1 {
border-color: #F7C473;
border-style: dashed;
background-image:url(a.gif);
background-repeat:no-repeat;
border-width: 0px;
color: #000099;
background-color: #FCF2D5;
display: block;
font-family: Arial,Verdana, Helvetica, sans-serif;
font-size: 9pt;
height: 17px;
margin-top: 0px;
margin-right: 10px;
padding-left: 26px;
padding-right: 0px;
text-align: left;
width: 100%;
}
a.lev1:link {
color: #000099;
text-decoration: none;
}
a.lev1:visited {
color: #000099;
font-size: 9pt;
text-decoration: none;
}
a.lev1:hover {
background-image:url(aa.gif);
background-repeat:no-repeat;
background-color: #B3B6FC;
color: #FFFFFF;
font-size: 9pt;
text-decoration: none;
}
a.lev1:active {
background-color: #1E4063;
color: #FFFFFF;
text-decoration: none;
}
a.lev2 {
border-color: #000000;
border-style: dotted;
border-width: 0px;
color: #000099;
background-image:url(b.gif);
background-repeat:no-repeat;
background-color: #FCF2D5;
display: block;
font-family: Arial,Verdana, Helvetica, sans-serif;
font-size: 9pt;
height: 17px;
margin-top: 0px;
margin-right: 10px;
padding-left: 36px;
padding-right: 0px;
text-align: left;
width: 100%;
}
a.lev2:link {
color: #000099;
text-decoration: none;
}
a.lev2:visited {
color: #000099;
font-size: 9pt;
text-decoration: none;
}
a.lev2:hover {
background-image:url(bb.gif);
background-repeat:no-repeat;
background-color: #B3B6FC;
color: #FFFFFF;
font-size: 9pt;
text-decoration: none;
}
a.lev2:active {
background-color: #1E4063;
color: #FFFFFF;
text-decoration: none;
}
a.lev3 {
border-color: #000000;
border-style: dotted;
border-width: 0px;
color: #000099;
background-image:url(c.gif);
background-repeat:no-repeat;
background-color: #FCF2D5;
display: block;
font-family: Arial,Verdana, Helvetica, sans-serif;
font-size: 9pt;
height: 17px;
margin-top: 0px;
margin-right: 10px;
padding-left: 46px;
padding-right: 0px;
text-align: left;
width: 100%;
}
a.lev3:link {
color: #000099;
text-decoration: none;
}
a.lev3:visited {
color: #000099;
font-size: 9pt;
text-decoration: none;
}
a.lev3:hover {
background-image:url(cc.gif);
background-repeat:no-repeat;
background-color: #B3B6FC;
color: #FFFFFF;
font-size: 9pt;
text-decoration: none;
}
a.lev3:active {
background-color: #1E4063;
color: #FFFFFF;
text-decoration: none;
}
a.lev4 {
border-color: #000000;
border-style: dotted;
border-width: 0px;
color: #000099;
background-image:url(d.gif);
background-repeat:no-repeat;
background-color: #FCF2D5;
display: block;
font-family: Arial,Verdana, Helvetica, sans-serif;
font-size: 9pt;
height: 17px;
margin-top: 0px;
margin-right: 10px;
padding-left: 53px;
padding-right: 0px;
text-align: left;
width: 100%;
}
a.lev4:link {
color: #000099;
text-decoration: none;
}
a.lev4:visited {
color: #000099;
font-size: 9pt;
text-decoration: none;
}
a.lev4:hover {
background-image:url(dd.gif);
background-repeat:no-repeat;
background-color: #B3B6FC;
color: #FFFFFF;
font-size: 9pt;
text-decoration: none;
}
a.lev4:active {
background-color: #1E4063;
color: #FFFFFF;
text-decoration: none;
}
a.lev5 {
border-color: #000000;
border-style: dotted;
border-width: 0px;
color: #000099;
background-image:url(d.gif);
background-repeat:no-repeat;
background-color: #FCF2D5;
display: block;
font-family: Arial,Verdana, Helvetica, sans-serif;
font-size: 9pt;
height: 17px;
margin-top: 0px;
margin-right: 10px;
padding-left: 53px;
padding-right: 0px;
text-align: left;
width: 100%;
}
a.lev5:link {
color: #000099;
text-decoration: none;
}
a.lev5:visited {
color: #000099;
font-size: 9pt;
text-decoration: none;
}
a.lev5:hover {
background-image:url(dd.gif);
background-repeat:no-repeat;
background-color: #B3B6FC;
color: #FFFFFF;
font-size: 9pt;
text-decoration: none;
}
a.lev5:active {
background-color: #1E4063;
color: #FFFFFF;
text-decoration: none;
}
a.lev6 {
border-color: #000000;
border-style: dotted;
border-width: 0px;
color: #000099;
background-image:url(d.gif);
background-repeat:no-repeat;
background-color: #FCF2D5;
display: block;
font-family: Arial,Verdana, Helvetica, sans-serif;
font-size: 9pt;
height: 17px;
margin-top: 0px;
margin-right: 10px;
padding-left: 53px;
padding-right: 0px;
text-align: left;
width: 100%;
}
a.lev6:link {
color: #000099;
text-decoration: none;
}
a.lev6:visited {
color: #000099;
font-size: 9pt;
text-decoration: none;
}
a.lev6:hover {
background-image:url(dd.gif);
background-repeat:no-repeat;
background-color: #B3B6FC;
color: #FFFFFF;
font-size: 9pt;
text-decoration: none;
}
a.lev6:active {
background-color: #1E4063;
color: #FFFFFF;
text-decoration: none;
}
a.lev7 {
border-color: #000000;
border-style: dotted;
border-width: 0px;
color: #000099;
background-image:url(d.gif);
background-repeat:no-repeat;
background-color: #FCF2D5;
display: block;
font-family: Arial,Verdana, Helvetica, sans-serif;
font-size: 9pt;
height: 17px;
margin-top: 0px;
margin-right: 10px;
padding-left: 53px;
padding-right: 0px;
text-align: left;
width: 100%;
}
a.lev7:link {
color: #000099;
text-decoration: none;
}
a.lev7:visited {
color: #000099;
font-size: 9pt;
text-decoration: none;
}
a.lev7:hover {
background-image:url(dd.gif);
background-repeat:no-repeat;
background-color: #B3B6FC;
color: #FFFFFF;
font-size: 9pt;
text-decoration: none;
}
a.lev7:active {
background-color: #1E4063;
color: #FFFFFF;
text-decoration: none;
}
a.lev8 {
border-color: #000000;
border-style: dotted;
border-width: 0px;
color: #000099;
background-image:url(d.gif);
background-repeat:no-repeat;
background-color: #FCF2D5;
display: block;
font-family: Arial,Verdana, Helvetica, sans-serif;
font-size: 9pt;
height: 17px;
margin-top: 0px;
margin-right: 10px;
padding-left: 53px;
padding-right: 0px;
text-align: left;
width: 100%;
}
a.lev8:link {
color: #000099;
text-decoration: none;
}
a.lev8:visited {
color: #000099;
font-size: 9pt;
text-decoration: none;
}
a.lev8:hover {
background-image:url(dd.gif);
background-repeat:no-repeat;
background-color: #B3B6FC;
color: #FFFFFF;
font-size: 9pt;
text-decoration: none;
}
a.lev8:active {
background-color: #1E4063;
color: #FFFFFF;
text-decoration: none;
}
a.lev9 {
border-color: #000000;
border-style: dotted;
border-width: 0px;
color: #000099;
background-image:url(d.gif);
background-repeat:no-repeat;
background-color: #FCF2D5;
display: block;
font-family: Arial,Verdana, Helvetica, sans-serif;
font-size: 9pt;
height: 17px;
margin-top: 0px;
margin-right: 10px;
padding-left: 53px;
padding-right: 0px;
text-align: left;
width: 100%;
}
a.lev9:link {
color: #000099;
text-decoration: none;
}
a.lev9:visited {
color: #000099;
font-size: 9pt;
text-decoration: none;
}
a.lev9:hover {
background-image:url(dd.gif);
background-repeat:no-repeat;
background-color: #B3B6FC;
color: #FFFFFF;
font-size: 9pt;
text-decoration: none;
}
a.lev9:active {
background-color: #1E4063;
color: #FFFFFF;
text-decoration: none;
}
a.lev10 {
border-color: #000000;
border-style: dotted;
border-width: 0px;
color: #000099;
background-image:url(d.gif);
background-repeat:no-repeat;
background-color: #FCF2D5;
display: block;
font-family: Arial,Verdana, Helvetica, sans-serif;
font-size: 9pt;
height: 17px;
margin-top: 0px;
margin-right: 10px;
padding-left: 53px;
padding-right: 0px;
text-align: left;
width: 100%;
}
a.lev10:link {
color: #000099;
text-decoration: none;
}
a.lev10:visited {
color: #000099;
font-size: 9pt;
text-decoration: none;
}
a.lev10:hover {
background-image:url(dd.gif);
background-repeat:no-repeat;
background-color: #B3B6FC;
color: #FFFFFF;
font-size: 9pt;
text-decoration: none;
}
a.lev10:active {
background-color: #1E4063;
color: #FFFFFF;
text-decoration: none;
}
</style>
<?php
/***********************************************
* CONTENIDO MODUL - OUTPUT
*
* Modulname : Sitemap v1.2
* Author(s) : Nik Wyss
* Copyright : None
* Created : 14-01-2003
* Modified : 14-01-2003
* Modified : 20-01-2004 by Peter Beauvain
* - Adapt to Contenido V4.4
* - Output only shows visible items
************************************************/
$amountLevel = "CMS_VALUE[1]";
$newcat = "CMS_VALUE[0]";
$color = array("lev1", "lev1","lev2","lev3","lev4","lev5","lev6","lev7","lev8","lev9","lev10");
function sitemap($newcat=0)
{
global $lang, $client, $amountLevel, $color, $startLevel, $cfg;
$db = new DB_Contenido;
$sql = "SELECT * FROM ".$cfg["tab"]["cat_tree"]." AS A, ".
$cfg["tab"]["cat"]." AS B, ".
$cfg["tab"]["cat_lang"]." AS C ".
"WHERE A.idcat=B.idcat AND B.idcat=C.idcat AND ".
"C.idlang='$lang' AND B.idclient='$client' AND ".
"B.parentid =$newcat AND level <= $amountLevel AND C.visible=1 ".
"ORDER by A.idtree";
$db->query($sql);
$result = "";
while ($db->next_record())
{
$lvl = $db->f("level");
if ($lvl==1)
{
$result.="";
}
$colorID=$lvl-$startLevel;
if ($colorID > count($color)-1)
{
$colorID=count($color)-1;
}
$result .= "<a width='130px' class='".$color[$colorID]."' style='display: block; ' href='front_content.php?idcat=".$db->f("idcat").
"&lang=$lang&client=$client' class='lmLink'>".
$db->f("name")."</a>".sitemap($db->f("idcat"))."";
}
$result.= "";
return($result);
}
$sql = "SELECT level FROM $cfgTab_cat_tree WHERE idcat=$newcat";
$db->query($sql);
$db->next_record();
$startLevel = $db->f("level");
$amountLevel += $startLevel;
if ($newcat==0){$amountLevel--;}
echo sitemap($newcat);
?>