Sitemap für Contenido 4.4.4

nomore · Beitrag von **nomore** » Fr 21. Mai 2004, 23:09

Hallo erstmal.

Ich habe ein riesen problem mit dem Sitemap Modul. Ich bekomme es einfach nicht gebacken, das das Ding läuft. Wenn ich das Modul eingebunden habe und es anschließen über meine Seite aufrufen will, sehe ich nur einen weißen Bildschirm. Das Logfile im Adminbereich sieht dann so aus:

[21-May-2004 23:57:38] Invalid SQL: SELECT level FROM WHERE idcat=1<br><br>
[21-May-2004 23:57:38] next_record called with no query pending.

Hat eventuell jemand einen Tipp für mich?

Darth-Vader · Beitrag von **Darth-Vader** » Sa 22. Mai 2004, 00:48

und wenn du das modul drausen hast, funktioniert die seite also wird angezeigt ohne fehler?

zeig ma den code, den du da hast...

nomore · Beitrag von **nomore** » Sa 22. Mai 2004, 10:13

Sorry ich habe mich etwas falsch ausgedrückt. Die Seite wird schon angezeigt, aber der Container in dem die Sitemap angezeigt werden soll bleibt leer. Hier der code der Sitemap:

Eingabe:

/***********************************************
* CONTENIDO MODUL - INPUT
*
* Modulname : Sitemap
* Author(s) : Jan Lengowski, Jose Rodriguez
* Copyright : Contenido - four for business, Jose Rodriguez
* Created : 15-08-2002
* Modified : 14-01-2003 by nik wyss
* Modified : 29-12-2003 by Sascha Benkart.
* - Adapt to Contenido V4.4
************************************************/
// selected category
$selected = "CMS_VALUE[0]";

echo "<table cellspacing=\"0\" cellpadding=\"10\" border=\"0\">\n".
" <tr valign=\"top\">\n".
" <td>Kategorie wählen:</td>\n".
" <td>\n".
" <select name=\"CMS_VAR[0]\">\n".
" <option value='0'>---Alle---</option>\n";

// fetch all categorys
$query = "SELECT A.idcat, A.level, C.name 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 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>\n".
" </td>\n".
" </tr>\n".
" <tr>\n".
" <td>Anzahl Ebene:</td>\n".
" <td>\n".
" <input type=\"text\" name=\"CMS_VAR[1]\" value=\"CMS_VALUE[1]\">\n".
" </td>\n".
" </tr>\n".
" </table>\n";

Ausgabe:

<?php
/***********************************************
* CONTENIDO MODUL - OUTPUT
*
* Modulname : Sitemap
* Author(s) : Nik Wyss
* Copyright : None
* Created : 14-01-2003
* Modified : 14-01-2003
* Modified : 29-12-2003 by Sascha Benkart.
* - Adapt to Contenido V4.4
* - Output only shows visible items
************************************************/

$amountLevel = "CMS_VALUE[1]";
$newcat = "CMS_VALUE[0]";
$color = array("#aaaaff", "#bbbbff","#ccccff","#ddddff");

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 = "<table border=0 cellspacing=1 cellpadding=0 border=0>";
while ($db->next_record())
{
$lvl = $db->f("level");
if ($lvl==1)
{
$result.="<tr><td> </td></tr>";
}
$colorID=$lvl-$startLevel;
if ($colorID > count($color)-1)
{
$colorID=count($color)-1;
}
$result .= "<tr><td width='120px' bgcolor='".$color[$colorID].
"' valign=top><a href='content.php?idcat=".$db->f("idcat").
"&lang=$lang&client=$client' class='lmLink'>".
$db->f("name")."</a></td><td>".sitemap($db->f("idcat")).
"</td></tr>";
}
$result.= "</table>";
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);
?>

Übrigens, ein Lob an dich! Deine Sitemap ist der absolute Hammer!!!

Beitrag von **emergence** » Sa 22. Mai 2004, 10:25

im output findet sich

Code: Alles auswählen

$sql = "SELECT level FROM $cfgTab_cat_tree WHERE idcat=$newcat";

ersetzen durch

Code: Alles auswählen

$sql = "SELECT level FROM ".$cfg["tab"]["cat_tree"]." WHERE idcat=$newcat";

nomore · Beitrag von **nomore** » Sa 22. Mai 2004, 10:37

Hab ich gemacht, aber es erscheint trotzdem keine Sitemap.

Dafür sieht mein logfile jetzt so aus.

[22-May-2004 11:42:19] Invalid SQL: SELECT level FROM con_cat_tree WHERE idcat=<br><br>
[22-May-2004 11:42:19] next_record called with no query pending.
[22-May-2004 11:42:19] Invalid SQL: SELECT * FROM con_cat_tree AS A, con_cat AS B, con_cat_lang AS C WHERE A.idcat=B.idcat AND B.idcat=C.idcat AND C.idlang='1' AND B.idclient='1' AND B.parentid = AND level <= -1 AND C.visible=1 ORDER by A.idtree<br><br>
[22-May-2004 11:42:19] next_record called with no query pending.
[22-May-2004 11:42:22] Invalid SQL: SELECT level FROM con_cat_tree WHERE idcat=<br><br>
[22-May-2004 11:42:22] next_record called with no query pending.
[22-May-2004 11:42:22] Invalid SQL: SELECT * FROM con_cat_tree AS A, con_cat AS B, con_cat_lang AS C WHERE A.idcat=B.idcat AND B.idcat=C.idcat AND C.idlang='1' AND B.idclient='1' AND B.parentid = AND level <= -1 AND C.visible=1 ORDER by A.idtree<br><br>
[22-May-2004 11:42:22] next_record called with no query pending.
[22-May-2004 11:42:30] Invalid SQL: SELECT level FROM con_cat_tree WHERE idcat=<br><br>
[22-May-2004 11:42:30] next_record called with no query pending.
[22-May-2004 11:42:30] Invalid SQL: SELECT * FROM con_cat_tree AS A, con_cat AS B, con_cat_lang AS C WHERE A.idcat=B.idcat AND B.idcat=C.idcat AND C.idlang='1' AND B.idclient='1' AND B.parentid = AND level <= -1 AND C.visible=1 ORDER by A.idtree<br><br>
[22-May-2004 11:42:30] next_record called with no query pending.
[22-May-2004 11:42:38] Invalid SQL: SELECT level FROM con_cat_tree WHERE idcat=<br><br>
[22-May-2004 11:42:38] next_record called with no query pending.
[22-May-2004 11:42:38] Invalid SQL: SELECT * FROM con_cat_tree AS A, con_cat AS B, con_cat_lang AS C WHERE A.idcat=B.idcat AND B.idcat=C.idcat AND C.idlang='1' AND B.idclient='1' AND B.parentid = AND level <= -1 AND C.visible=1 ORDER by A.idtree<br><br>
[22-May-2004 11:42:38] next_record called with no query pending.
[22-May-2004 11:43:39] Invalid SQL: SELECT level FROM con_cat_tree WHERE idcat=<br><br>
[22-May-2004 11:43:39] next_record called with no query pending.
[22-May-2004 11:43:39] Invalid SQL: SELECT * FROM con_cat_tree AS A, con_cat AS B, con_cat_lang AS C WHERE A.idcat=B.idcat AND B.idcat=C.idcat AND C.idlang='1' AND B.idclient='1' AND B.parentid = AND level <= -1 AND C.visible=1 ORDER by A.idtree<br><br>
[22-May-2004 11:43:39] next_record called with no query pending.
[22-May-2004 11:43:40] Invalid SQL: SELECT level FROM con_cat_tree WHERE idcat=<br><br>
[22-May-2004 11:43:40] next_record called with no query pending.
[22-May-2004 11:43:40] Invalid SQL: SELECT * FROM con_cat_tree AS A, con_cat AS B, con_cat_lang AS C WHERE A.idcat=B.idcat AND B.idcat=C.idcat AND C.idlang='1' AND B.idclient='1' AND B.parentid = AND level <= -1 AND C.visible=1 ORDER by A.idtree<br><br>
[22-May-2004 11:43:40] next_record called with no query pending.

nomore · Beitrag von **nomore** » Mo 24. Mai 2004, 20:39

Hat sich erledigt, hab den Fehler gefunden!