Endlich habe auch ich mal ein Problem mit Contenido. Ich benutze die Version 4.4.4.
Nachdem der Server meines Providers komplett gehackt und alle Daten gelöscht wurden muß ich jetzt nochmal von vorne anfangen. Aber egal.
Also ich habe eine Neuinstallation gemacht... Nun kann ich nur noch die Startseite des Frontend sehen, versuche ich zum Beispiel den Kontakt zu öffnen bekomme ich nur noch eine weiße Seite und habe dann so einige Einträge in der Errorlog.
Ich hänge jetzt mal die Einstellungen und den Inhalt der Log-Datei an:
Einstellungen:
Code: Alles auswählen
Variable Lokaler Wert
Contenido-Version 4.4.4
Contenido-Pfad /home/htdocs/web5/html/foliendesign/contenido/
Contenido-HTML-Pfad ../contenido/
Contenido HTML-Pfad http://www.azibi.de/foliendesign/contenido/
Frontend-Pfad /home/htdocs/web5/html/foliendesign
Contenido PHPLib-Pfad /home/htdocs/web5/html/foliendesign/conlib/
Contenido WYSIWYG-Pfad /home/htdocs/web5/html/foliendesign/contenido/external/wysiwyg/spaw/
Contenido WYSIWYG HTML-Pfad http://www.azibi.de/foliendesign/contenido/external/wysiwyg/spaw/
Hostname www.azibi.de
Browser-Pfad http://www.azibi.de/foliendesign/contenido/
Mandanteninformationen Anzahl der Mandanten:1
Mandanten-Einstellungen Werte
Foliendesign
Sprache(n) deutsch
HTM-Pfad http://www.azibi.de/foliendesign/cms/
frontend-Pfad /home/htdocs/web5/html/foliendesign/cms/
Anzahl der Benutzer 2
Anzahl der Artikel 15
Serverbetriebssystem Apache/2.0.48 (Linux/SuSE)
MySQL Serverversion 4.0.15
Installierte PHP-Version 4.3.3
safe_mode Aktiviert
magic_quotes_gpc Aktiviert
magic_quotes_runtime Deaktiviert
gpc_order GPC
memory_limit 60M
max_execution_time 30
Deaktivierte Funktionen nothing disabled
Gettext extension loaded
sql.safe_mode Deaktiviert
GD-Bibliothek Einstellungen Werte
GD Support enabled
GD Version bundled (2.0.15 compatible)
FreeType Support enabled
FreeType Linkage with freetype
T1Lib Support enabled
GIF Read Support enabled
JPG Support enabled
PNG Support enabled
WBMP Support enabled
XBM Support enabled
include_path .:/usr/share/php
Code: Alles auswählen
[07-Jun-2004 12:47:28] Invalid SQL: lock tables cms_sequence write<br><br>
[07-Jun-2004 12:47:28] lock() failed.
[07-Jun-2004 12:47:28] cannot lock cms_sequence - has it been created?
[07-Jun-2004 12:47:28] Invalid SQL: INSERT INTO cms_stat (visited, idcatart, idlang, idstat, idclient) VALUES ('1', '32', '1', '0', '1')<br><br>
[07-Jun-2004 12:47:31] Invalid SQL: lock tables cms_sequence write<br><br>
[07-Jun-2004 12:47:31] lock() failed.
[07-Jun-2004 12:47:31] cannot lock cms_sequence - has it been created?
[07-Jun-2004 12:47:31] Invalid SQL: INSERT INTO cms_keywords (keyword,auto,idlang, idkeyword) VALUES ('startartikel','&15=1',1,0)<br><br>
[07-Jun-2004 12:47:31] Invalid SQL: lock tables cms_sequence write<br><br>
[07-Jun-2004 12:47:31] lock() failed.
[07-Jun-2004 12:47:31] cannot lock cms_sequence - has it been created?
[07-Jun-2004 12:47:31] Invalid SQL: INSERT INTO cms_keywords (keyword,auto,idlang, idkeyword) VALUES ('punkt','&15=1',1,0)<br><br>
[07-Jun-2004 12:47:31] Invalid SQL: lock tables cms_sequence write<br><br>
[07-Jun-2004 12:47:31] lock() failed.
[07-Jun-2004 12:47:31] cannot lock cms_sequence - has it been created?
[07-Jun-2004 12:47:31] Invalid SQL: INSERT INTO cms_keywords (keyword,auto,idlang, idkeyword) VALUES ('www','&15=8',1,0)<br><br>
[07-Jun-2004 12:47:31] Invalid SQL: lock tables cms_sequence write<br><br>
[07-Jun-2004 12:47:31] lock() failed.
[07-Jun-2004 12:47:31] cannot lock cms_sequence - has it been created?
[07-Jun-2004 12:47:31] Invalid SQL: INSERT INTO cms_keywords (keyword,auto,idlang, idkeyword) VALUES ('upload','&15=4',1,0)<br><br>
[07-Jun-2004 12:47:31] Invalid SQL: lock tables cms_sequence write<br><br>
[07-Jun-2004 12:47:31] lock() failed.
[07-Jun-2004 12:47:31] cannot lock cms_sequence - has it been created?
[07-Jun-2004 12:47:31] Invalid SQL: INSERT INTO cms_keywords (keyword,auto,idlang, idkeyword) VALUES ('logos','&15=3',1,0)<br><br>
[07-Jun-2004 12:47:31] Invalid SQL: lock tables cms_sequence write<br><br>
[07-Jun-2004 12:47:31] lock() failed.
[07-Jun-2004 12:47:31] cannot lock cms_sequence - has it been created?
[07-Jun-2004 12:47:31] Invalid SQL: INSERT INTO cms_keywords (keyword,auto,idlang, idkeyword) VALUES ('logo','&15=3',1,0)<br><br>
[07-Jun-2004 12:47:31] Invalid SQL: lock tables cms_sequence write<br><br>
[07-Jun-2004 12:47:31] lock() failed.
[07-Jun-2004 12:47:31] cannot lock cms_sequence - has it been created?
[07-Jun-2004 12:47:31] Invalid SQL: INSERT INTO cms_keywords (keyword,auto,idlang, idkeyword) VALUES ('jpg','&15=2',1,0)<br><br>
[07-Jun-2004 12:47:31] Invalid SQL: lock tables cms_sequence write<br><br>
[07-Jun-2004 12:47:31] lock() failed.
[07-Jun-2004 12:47:31] cannot lock cms_sequence - has it been created?
[07-Jun-2004 12:47:31] Invalid SQL: INSERT INTO cms_keywords (keyword,auto,idlang, idkeyword) VALUES ('http','&15=8',1,0)<br><br>
[07-Jun-2004 12:47:31] Invalid SQL: lock tables cms_sequence write<br><br>
[07-Jun-2004 12:47:31] lock() failed.
[07-Jun-2004 12:47:31] cannot lock cms_sequence - has it been created?
[07-Jun-2004 12:47:31] Invalid SQL: INSERT INTO cms_keywords (keyword,auto,idlang, idkeyword) VALUES ('foliendesign','&15=8',1,0)<br><br>
[07-Jun-2004 12:47:31] Invalid SQL: lock tables cms_sequence write<br><br>
[07-Jun-2004 12:47:31] lock() failed.
[07-Jun-2004 12:47:31] cannot lock cms_sequence - has it been created?
[07-Jun-2004 12:47:31] Invalid SQL: INSERT INTO cms_keywords (keyword,auto,idlang, idkeyword) VALUES ('de','&15=8',1,0)<br><br>
[07-Jun-2004 12:47:31] Invalid SQL: lock tables cms_sequence write<br><br>
[07-Jun-2004 12:47:31] lock() failed.
[07-Jun-2004 12:47:31] cannot lock cms_sequence - has it been created?
[07-Jun-2004 12:47:31] Invalid SQL: INSERT INTO cms_keywords (keyword,auto,idlang, idkeyword) VALUES ('contenido','&15=1',1,0)<br><br>
[07-Jun-2004 12:47:31] Invalid SQL: lock tables cms_sequence write<br><br>
[07-Jun-2004 12:47:31] lock() failed.
[07-Jun-2004 12:47:31] cannot lock cms_sequence - has it been created?
[07-Jun-2004 12:47:31] Invalid SQL: INSERT INTO cms_keywords (keyword,auto,idlang, idkeyword) VALUES ('cms','&15=8',1,0)<br><br>
[07-Jun-2004 12:47:31] Invalid SQL: lock tables cms_sequence write<br><br>
[07-Jun-2004 12:47:31] lock() failed.
[07-Jun-2004 12:47:31] cannot lock cms_sequence - has it been created?
[07-Jun-2004 12:47:31] Invalid SQL: INSERT INTO cms_keywords (keyword,auto,idlang, idkeyword) VALUES ('azibi','&15=8',1,0)<br><br>
[07-Jun-2004 12:47:31] Invalid SQL: lock tables cms_sequence write<br><br>
[07-Jun-2004 12:47:31] lock() failed.
[07-Jun-2004 12:47:31] cannot lock cms_sequence - has it been created?
[07-Jun-2004 12:47:31] Invalid SQL: INSERT INTO cms_keywords (keyword,auto,idlang, idkeyword) VALUES ('itprof','&15=1',1,0)<br><br>
[07-Jun-2004 12:47:31] Invalid SQL: lock tables cms_sequence write<br><br>
[07-Jun-2004 12:47:31] lock() failed.
[07-Jun-2004 12:47:31] cannot lock cms_sequence - has it been created?
[07-Jun-2004 12:47:31] Invalid SQL: INSERT INTO cms_keywords (keyword,auto,idlang, idkeyword) VALUES ('gif','&15=2',1,0)<br><br>
[07-Jun-2004 12:47:31] Invalid SQL: lock tables cms_sequence write<br><br>
[07-Jun-2004 12:47:31] lock() failed.
[07-Jun-2004 12:47:31] cannot lock cms_sequence - has it been created?
[07-Jun-2004 12:47:31] Invalid SQL: INSERT INTO cms_keywords (keyword,auto,idlang, idkeyword) VALUES ('bilder','&15=1',1,0)<br><br>
[07-Jun-2004 12:47:31] Invalid SQL: lock tables cms_sequence write<br><br>
[07-Jun-2004 12:47:31] lock() failed.
[07-Jun-2004 12:47:31] cannot lock cms_sequence - has it been created?
[07-Jun-2004 12:47:31] Invalid SQL: INSERT INTO cms_keywords (keyword,auto,idlang, idkeyword) VALUES ('banner','&15=1',1,0)<br><br>
[07-Jun-2004 12:47:31] Invalid SQL: lock tables cms_sequence write<br><br>
[07-Jun-2004 12:47:31] lock() failed.
[07-Jun-2004 12:47:31] cannot lock cms_sequence - has it been created?
[07-Jun-2004 12:47:31] Invalid SQL: INSERT INTO cms_keywords (keyword,auto,idlang, idkeyword) VALUES ('fb','&15=1',1,0)<br><br>
[07-Jun-2004 12:47:31] Invalid SQL: lock tables cms_sequence write<br><br>
[07-Jun-2004 12:47:31] lock() failed.
[07-Jun-2004 12:47:31] cannot lock cms_sequence - has it been created?
[07-Jun-2004 12:47:31] Invalid SQL: INSERT INTO cms_keywords (keyword,auto,idlang, idkeyword) VALUES ('blank','&15=3',1,0)<br><br>
[07-Jun-2004 12:47:31] Invalid SQL: lock tables cms_sequence write<br><br>
[07-Jun-2004 12:47:31] lock() failed.
[07-Jun-2004 12:47:31] cannot lock cms_sequence - has it been created?
[07-Jun-2004 12:47:31] Invalid SQL: INSERT INTO cms_code (idcode, idcatart, code, idlang, idclient) VALUES ('0', '27', '<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.0 Transitional//EN\">
<html>
<head>
<title>Contenido</title>
<link rel=\"stylesheet\" type=\"text/css\" href=\"css/format.css\">
<meta name=\"generator\" content=\"CMS Contenido 4.4.4\">
<meta http-equiv=\"Content-Type\" content=\"text/html; charset=iso-8859-1\">
</head>
<body bgcolor=\"white\" style=\"margin:0px\">
<table width=\"100%\" height=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\">
<tr><td height=\"5\"></td></tr>
<tr><td align=\"center\">
<table width=\"800\" border=\"0\" height=\"100%\" cellspacing=\"0\" cellpadding=\"0\">
<tr>
<td width=\"200\" align=\"center\"><?php
if (\"http://www.azibi.de/foliendesign/cms/upload/logos/contenido_logo.jpg\" != \"\") {
$img = \'<img src=\"http://www.azibi.de/foliendesign/cms/upload/logos/contenido_logo.jpg\" border=\"0\">\';
if (\"http://www.azibi.de/foliendesign/cms/\" != \"http://\") {
$img = sprintf(\'<a href=\"%s\" target=\"%s\">%s</a>\',\"http://www.azibi.de/foliendesign/cms/\", \"_blank\", $img);
}
echo $img;
}
echo \"<br>\";
echo \"\";
echo \"<br>\";
echo \"\";
echo \"<br>\";
?>
</td>
<td align=\"center\" height=\"80\" with=\"400\">
<table width=\"400\" border=\"0\" height=\"80\" cellspacing=\"0\" cellpadding=\"0\" background=\"images/background.jpg\" style=\"border: 1px;border-color: #F7C473; border-style: dashed; background-color: #FCF2D5\">
<tr><td>
<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"400\" height=\"80\">
<tr><td> </td></tr><tr><td align=\"right\" valign=\"bottom\">
<!--hilfsnavi-->
<?php
include_once($cfg[\"path\"][\"contenido\"].$cfg[\"path\"][\"includes\"].\"functions.con.php\");
$catStart = \"2\";
if ($catStart != \"\") {
$catIds = conDeeperCategoriesArray($catStart);
echo \'<table cellpadding=\"0\" cellspacing=\"0\" border=\"0\"><tr>\';
echo \'<td><img src=\"images/wuerfel.gif\"></td>\';
if ( is_array($catIds) ) {
foreach($catIds as $key=>$val) {
// Ersten Eintrag ueberspringen, weil das der Menupunkt selbst ist
// und nicht angezeigt werden soll.
if ($key != 0) {
$sql = \"SELECT CAT.idcat AS idcat, name FROM \".
$cfg[\"tab\"][\"cat\"].\" AS CAT, \".
$cfg[\"tab\"][\"cat_lang\"].\" AS CATLANG
WHERE CAT.idcat = \".$val.\"
AND CAT.idcat = CATLANG.idcat
AND CATLANG.idlang = \'$lang\'
AND CATLANG.visible = \'1\'\";
$db->query($sql);
$db2 = new DB_Contenido;
while ( $db->next_record() ) {
$target = \"_self\";
/* Check for redirect and new window flag */
$sql = \"SELECT idart FROM \".$cfg[\"tab\"][\"cat_art\"].\" WHERE idcat=\'\". $db->f(\"idcat\").\"\' AND is_start = \'1\'\";
$db2->query($sql);
if ($db2->next_record())
{
$cidart = $db2->f(\"idart\");
$sql = \"SELECT external_redirect FROM \".$cfg[\"tab\"][\"art_lang\"].\" WHERE idart = \'$cidart\' AND idlang=\'$lang\'\";
$db2->query($sql);
if ($db2->next_record())
{
$target = ( $db2->f(\"external_redirect\") == 0 ) ? \'_self\' : \'_blank\';
}
}
echo \'<td height=\"21\" class=\".navigation\" style=\"border: 0px; border-top:1px; border-color: #F7C473; border-style: dashed; background-color: #FFFFFF; padding-left:7px; padding-right:7px;\">
<a class=\"klein\" target=\"\'.$target.\'\" href=\"front_content.php?idcat=\'.$db->f(\"idcat\").\'\">\'.$db->f(\"name\").\'</a></td>\';
} // end while
} // if
} // end foreach
} // end if (is_array)
echo \'</tr></table>\';
}
?>
<!--hilfsnavi ende-->
</td></tr>
</table>
</td></tr>
</table>
</td>
<td width=\"200\" align=\"center\"><?php
if (\"http://www.azibi.de/foliendesign/cms/upload/logos/itprof_logo.gif\" != \"\") {
$img = \'<img src=\"http://www.azibi.de/foliendesign/cms/upload/logos/itprof_logo.gif\" border=\"0\">\';
if (\"http://www.azibi.de/foliendesign/cms/\" != \"http://\") {
$img = sprintf(\'<a href=\"%s\" target=\"%s\">%s</a>\',\"http://www.azibi.de/foliendesign/cms/\", \"_blank\", $img);
}
echo $img;
}
echo \"<br>\";
echo \"\";
echo \"<br>\";
echo \"\";
echo \"<br>\";
?>
</td>
</tr>
<tr><td colspan=\"3\" height=\"5\"></td></tr>
<tr>
<td align=\"right\" valign=\"top\">
<!--navi-->
<?php
/***********************************************
* CONTENIDO MODUL - OUTPUT
*
* Modulname : Navigation 1.1
* Author : Jan Lengowski
* Copyright : Contenido - four for business
* Created : 15-05-2003
* Modified : 26-05-2003
************************************************/
if ( !is_object($db2) ) {
$db2 = new DB_Contenido;
}
/**
* Check if a category is child
* of another category
*
* @return boolean true/false
* @author Jan Lengowski <Jan.Lengowski@4fb.de>
* @copyright four for business AG 2003
*/
if (!function_exists(\"catIsChildOf\"))
{
function catIsChildOf($id, $idparent) {
global $cfg, $client, $lang;
$db = new DB_Contenido;
$parent = $id;
while ( $parent != 0 ) {
$sql = \"SELECT
a.parentid
FROM
\".$cfg[\"tab\"][\"cat\"].\" AS a,
\".$cfg[\"tab\"][\"cat_lang\"].\" AS b
WHERE
a.idclient = \'\".$client.\"\' AND
b.idlang = \'\".$lang.\"\' AND
a.idcat = b.idcat AND
a.idcat = \'\".$parent.\"\'\";
$db->query($sql);
$db->next_record();
$parent = $db->f(\"parentid\");
if ($parent == $idparent) {
return true;
}
}
return false;
}
}
if ( catIsChildOf($idcat, \"1\") ) {
$sel_idcat = $idcat;
} else {
$sel_idcat = \"1\";
}
/* Include Template Class */
include_once($cfg[\"path\"][\"contenido\"] . \'classes/class.template.php\');
/**
* Array storing alle the
* navigation data
*/
$navitems = array();
/* Template Instance */
$tpl = new Template;
/**
* Recursive function for creating
* the navigation array
* @param Int $idcat Category id
*/
function nav($idcat) {
global $navitems, $client, $lang, $cfg;
$db = new DB_Contenido;
$db2 = new DB_Contenido;
$sql = \"SELECT parentid FROM \".$cfg[\"tab\"][\"cat\"].\" WHERE idcat = \'$idcat\'\";
$db->query($sql);
$db->next_record();
$parentid = $db->f(\"parentid\");
if ( $parentid == 0 ) {
if ( $idcat != \"1\" ){
$navitems = array();
$sql = \"SELECT
A.idcat,
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
B.idclient = \'$client\' AND
C.idlang = \'$lang\' AND
C.visible = \'1\' AND
B.parentid = \'1\'
ORDER
BY A.idtree\";
$db->query($sql);
while ($db->next_record()) {
/* Check for external redirects... */
$sql = \"SELECT
a.external_redirect AS ext
FROM
\".$cfg[\"tab\"][\"art_lang\"].\" AS a,
\".$cfg[\"tab\"][\"cat_art\"].\" AS b,
\".$cfg[\"tab\"][\"cat\"].\" AS c
WHERE
b.idcat = \'\".$db->f(\"idcat\").\"\' AND
b.is_start = \'1\' AND
c.idclient = \'\".$client.\"\' AND
c.idcat = b.idcat AND
a.idart = b.idart AND
a.idlang = \'\".$lang.\"\'\";
$db2->query($sql);
$db2->next_record();
$target = ( $db2->f(\"ext\") == 0 ) ? \'_self\' : \'_blank\';
$navitems[$db->f(\"idcat\")] = array(\"idcat\" => $db->f(\"idcat\"),
\"name\" => $db->f(\"name\"),
\"target\" => $target);
}
}
return true;
}
$sql = \"SELECT
A.idcat,
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
B.idclient = \'$client\' AND
C.idlang = \'$lang\' AND
C.visible = \'1\' AND
B.parentid = \'$parentid\'
ORDER BY
A.idtree\";
$db->query($sql);
while ($db->next_record()) {
/* Check for external redirects... */
$sql = \"SELECT
a.external_redirect AS ext
FROM
\".$cfg[\"tab\"][\"art_lang\"].\" AS a,
\".$cfg[\"tab\"][\"cat_art\"].\" AS b,
\".$cfg[\"tab\"][\"cat\"].\" AS c
WHERE
b.idcat = \'\".$db->f(\"idcat\").\"\' AND
b.is_start = \'1\' AND
c.idclient = \'\".$client.\"\' AND
c.idcat = b.idcat AND
a.idart = b.idart AND
a.idlang = \'\".$lang.\"\'\";
$db2->query($sql);
$db2->next_record();
$target = ( $db2->f(\"ext\") == 0 ) ? \'_self\' : \'_blank\';
$tmp_nav[$db->f(\"idcat\")] = array(\"idcat\" => $db->f(\"idcat\"),
\"name\" => $db->f(\"name\"),
\"target\" => $target);
}
$tmp_nav[$idcat][\"sub\"] = $navitems;
$navitems = $tmp_nav;
/* Function call */
nav($parentid);
} // end function
$sql = \"SELECT
A.idcat,
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
B.idclient = \'$client\' AND
C.idlang = \'$lang\' AND
C.visible = \'1\' AND
B.parentid = \'$sel_idcat\'
ORDER BY
A.idtree\";
$db->query($sql);
while ( $db->next_record() ) {
/* Check for external redirects... */
$sql = \"SELECT
a.external_redirect AS ext
FROM
\".$cfg[\"tab\"][\"art_lang\"].\" AS a,
\".$cfg[\"tab\"][\"cat_art\"].\" AS b,
\".$cfg[\"tab\"][\"cat\"].\" AS c
WHERE
b.idcat = \'\".$db->f(\"idcat\").\"\' AND
b.is_start = \'1\' AND
c.idclient = \'\".$client.\"\' AND
c.idcat = b.idcat AND
a.idart = b.idart AND
a.idlang = \'\".$lang.\"\'\";
$db2->query($sql);
$db2->next_record();
$target = ( $db2->f(\"ext\") == 0 ) ? \'_self\' : \'_blank\';
$navitems[$db->f(\"idcat\")] = array(\"idcat\" => $db->f(\"idcat\"),
\"name\" => $db->f(\"name\"),
\"target\" => $target);
}
/* Create Navigation Array */
nav($sel_idcat);
/* Start Output buffer */
ob_start();
echo \'<table cellspacing=\"0\" cellpadding=\"0\" border=\"0\">\';
foreach ($navitems as $key => $data) {
/* 1. Navigations Ebene */
$tpl->reset();
$tpl->set(\'d\', \'NAME\', $data[\'name\']);
$tpl->set(\'d\', \'TARGET\', $data[\'target\']);
$tpl->set(\'d\', \'HREF\', $sess->url(\'front_content.php?idcat=\'.$data[\'idcat\']));
$tpl->next();
if ($idcat == $data[\'idcat\'] || is_array($data[\'sub\'])) {
$tpl->generate(\'templates/navfirst_on.html\');
} else {
$tpl->generate(\'templates/navfirst_off.html\');
}
if (is_array($data[\'sub\'])) {
foreach ($data[\'sub\'] as $key => $data) {
/* 2. Navigations Ebene */
$tpl->reset();
$tpl->set(\'d\', \'NAME\', $data[\'name\']);
$tpl->set(\'d\', \'TARGET\', $data[\'target\']);
$tpl->set(\'d\', \'HREF\', $sess->url(\'front_content.php?idcat=\'.$data[\'idcat\']));
$tpl->next();
if ($idcat == $data[\'idcat\'] || is_array($data[\'sub\'])) {
$tpl->generate(\'templates/navsecond_on.html\');
} else {
$tpl->generate(\'templates/navsecond_off.html\');
}
if (is_array($data[\'sub\'])) {
foreach ($data[\'sub\'] as $key => $data) {
/* 3. Navigations Ebene */
$tpl->reset();
$tpl->set(\'d\', \'NAME\', $data[\'name\']);
$tpl->set(\'d\', \'TARGET\', $data[\'target\']);
$tpl->set(\'d\', \'HREF\', $sess->url(\'front_content.php?idcat=\'.$data[\'idcat\']));
$tpl->next();
if ($idcat == $data[\'idcat\']) {
$tpl->generate(\'templates/navthird_on.html\');
} else {
$tpl->generate(\'templates/navthird_off.html\');
}
} // end foreach
} // end if
} // end foreach
} // end if
} // end foreach
echo \'</table>\';
/* Read out buffer */
$html = ob_get_contents();
/* Clean buffer */
ob_end_clean();
/* Output buffer-contents */
echo $html;
?>
<!--navi ende-->
</td>
<td valign=\"top\">
<!--inhalt-->
<table width=\"400\" height=\"50%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" style=\"border: 1px;border-color: #F7C473; border-style: dashed; background-color: #FCF2D5\">
<tr><td height=\"20\" colspan=\"2\"> </td></tr>
<tr><td rowspan=\"3\" width=\"25\"> </td>
<td valign=\"top\" height=\"30\" class=\"headline\"><?php echo \"Startartikel Punkt 2\"; ?>
</td></tr>
<tr><td valign=\"top\" height=\"30\" class=\"subheadline\"><?php echo \"\"; ?>
</td></tr>
<tr><td valign=\"top\" height=\"100%\" class=\"text\"><?php echo \"\"; ?>
</td></tr>
</table>
<!--inhalt ende-->
</td>
<td align=\"center\" valign=\"top\">
<table cellspacing=\"0\" cellpadding=\"0\" border=\"0\">
<tr>
<td><?php
/***********************************************
* CONTENIDO MODUL - OUTPUT
*
* REFERENZ MODUL / ARTIKELLISTE
*
* Artikelliste mit Img 1, Head 1, Head 2
*
* Erstellt eine Liste mit allen Artikel bis
* auf den Startartikel.
*
* Author : Jan Lengowski
* Copyright : four for business AG
* Created : 15-08-2002
* Modified : 16-08-2002
************************************************/
// second db class instance
$db2 = new DB_Contenido;
// selected category
$selcat = \"12\";
if($selcat!=\"0\" && $selcat!=\"\"){
// select all articles in category widthout start article
$query = \"SELECT ARTLANG.idart, ARTLANG.idartlang FROM \".$cfg[\"tab\"][\"cat_art\"].\" AS CATART, \".
$cfg[\"tab\"][\"art_lang\"].\" AS ARTLANG \".
\"WHERE CATART.idcat = \'$selcat\' AND ARTLANG.idart = CATART.idart AND ARTLANG.idlang = \'$lang\' AND \".
\"ARTLANG.online = \'1\' ORDER BY CATART.idart DESC\";
// execute query
$db->query($query);
unset($articleID);
unset($linkID);
// get id\'s of sub articles
while ($db->next_record()) {
$articleID[] = $db->f(\"idartlang\");
$linkID[] = $db->f(\"idart\");
} // end while
// loop through subarticles
echo \'
<table width=\"165\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">
<tr><td height=\"30\" colspan=\"2\" ></td></tr>
<tr><td height=\"21\" width=\"22\" style=\"border: 0px; border-top:1px; border-bottom:1px; border-color: #F7C473; border-style: solid; background-color: #FCF2D5\"><img src=\"images/wuerfel.gif\" width=\"22\" height=\"21\" border=\"0\"></td>
<td width=\"143\" style=\"border: 1px; border-left:0px; border-color: #F7C473; border-style: dashed; background-color: #FCF2D5; padding-left:10px\" class=\"punkte\">News</td></tr>
\';
if (is_array($articleID)) {
foreach ($articleID as $key => $value) {
// select all CMS variables of the article
$sql = \"SELECT * FROM \".$cfg[\"tab\"][\"content\"].\" WHERE idartlang = \'$value\' AND idtype = \'1\' AND typeid = \'1\'\";
$db->query($sql);
$db->next_record();
$head = $db->f(\"value\");
if ( strlen($head) > \"50\") {
$head = substr($head, 0, \"50\");
$head .= \'..\';
}
// link
$link = $sess->url(\"front_content.php?client=$client&lang=$lang&idcat=$selcat&idart=$linkID[$key]&m=$m&s=$s\");
echo \'<tr><td colspan=\"2\" class=\"text\" height=\"22\" style=\"border: 1px; border-top:0px; border-color: #F7C473; border-style: dashed; background-color: #FCF2D5; padding-left:10px\"><a href=\"\'.$link.\'\">\'.urldecode($db->f(\"value\")).\'</a></td></tr>\';
} // end while
unset($headline);
unset($text);
} // end foreach
} // end if (is_array)
echo \'</table><br>\';
?>
</td>
</tr>
<tr>
<td><?php
if (\"http://www.azibi.de/foliendesign/cms/upload/bilder/banner.jpg\" != \"\") {
$img = \'<img src=\"http://www.azibi.de/foliendesign/cms/upload/bilder/banner.jpg\" border=\"0\">\';
if (\"http://www.azibi.de/foliendesign/cms/\" != \"http://\") {
$img = sprintf(\'<a href=\"%s\" target=\"%s\">%s</a>\',\"http://www.azibi.de/foliendesign/cms/\", \"\", $img);
}
echo $img;
}
echo \"<br>\";
echo \"\";
echo \"<br>\";
echo \"\";
echo \"<br>\";
?>
</td>
</tr>
<tr>
<td><?php
if (\"http://www.azibi.de/foliendesign/cms/upload/logos/4fb_logo.gif\" != \"\") {
$img = \'<img src=\"http://www.azibi.de/foliendesign/cms/upload/logos/4fb_logo.gif\" border=\"0\">\';
if (\"http://www.azibi.de/foliendesign/cms/\" != \"http://\") {
$img = sprintf(\'<a href=\"%s\" target=\"%s\">%s</a>\',\"http://www.azibi.de/foliendesign/cms/\", \"_blank\", $img);
}
echo $img;
}
echo \"<br>\";
echo \"\";
echo \"<br>\";
echo \"\";
echo \"<br>\";
?>
</td>
</tr>
</table>
</td></tr></table>
</td></tr></table>
</body>
</html>', '1', '1')<br><br>
[07-Jun-2004 12:47:31] Invalid SQL: lock tables cms_sequence write<br><br>
[07-Jun-2004 12:47:31] lock() failed.
[07-Jun-2004 12:47:31] cannot lock cms_sequence - has it been created?
[07-Jun-2004 12:47:31] Invalid SQL: INSERT INTO cms_stat (visited, idcatart, idlang, idstat, idclient) VALUES ('1', '27', '1', '0', '1')<br><br>
Gruß Azibi