Hallo
Habe folgendes Problem.
Ich habe das aktuelle Contenido 4.4.4 auf meine Webserver installiert.
Soweit hat auch alles geklappt. Das einloggen in das Admin Menü klappt auch ohne Probleme.
Die Testseite ist ja schon vorinstalliert unf funktioniert.
Doch bei mir gibts ein Problem. Die Seite wird zwar angezeigt aber das Menü und die Links gehen nicht.
Wenn ich auf die Menülinks klicke wird die Seite neu geladen, aber es wird immer nur die index Seite angezeigt.
Ich kann ohne weiters einzelne Seite bearbeiten, aber wenn ich mir dann im cms Verzeichnis die Seiten anschauen will, werden Sie nicht angezeigt sondern immer nur die Startseite.
Ich vermute das es irgendwas mit der Datenbank zu tun hat oder so.
Wäre toll wenn mir jemand helfen könnte wie ich das Problem beheben kann.
Hier die Daten meines Servers und die error log Nachrichten:
Serverbetriebssystem Apache/2.0.49 (Linux/SuSE)
MySQL Serverversion 4.0.18
Installierte PHP-Version 4.3.4
safe_mode Aktiviert
magic_quotes_gpc Aktiviert
magic_quotes_runtime Deaktiviert
gpc_order GPC
memory_limit 8M
max_execution_time 30
Deaktivierte Funktionen nothing disabled
Gettext extension loaded
sql.safe_mode Deaktiviert
error log:
-----------------------
[16-Nov-2004 18:26:40] Invalid SQL: lock tables con_sequence write<br><br>
[16-Nov-2004 18:26:40] lock() failed.
[16-Nov-2004 18:26:40] cannot lock con_sequence - has it been created?
[16-Nov-2004 18:26:40] Invalid SQL: INSERT INTO con_keywords (keyword,auto,idlang, idkeyword) VALUES ('web','&9=8',1,0)<br><br>
[16-Nov-2004 18:26:40] Invalid SQL: lock tables con_sequence write<br><br>
[16-Nov-2004 18:26:40] lock() failed.
[16-Nov-2004 18:26:40] cannot lock con_sequence - has it been created?
[16-Nov-2004 18:26:40] Invalid SQL: INSERT INTO con_keywords (keyword,auto,idlang, idkeyword) VALUES ('server','&9=8',1,0)<br><br>
[16-Nov-2004 18:26:40] Invalid SQL: lock tables con_sequence write<br><br>
[16-Nov-2004 18:26:40] lock() failed.
[16-Nov-2004 18:26:40] cannot lock con_sequence - has it been created?
[16-Nov-2004 18:26:40] Invalid SQL: INSERT INTO con_keywords (keyword,auto,idlang, idkeyword) VALUES ('kunden','&9=8',1,0)<br><br>
[16-Nov-2004 18:26:40] Invalid SQL: lock tables con_sequence write<br><br>
[16-Nov-2004 18:26:40] lock() failed.
[16-Nov-2004 18:26:40] cannot lock con_sequence - has it been created?
[16-Nov-2004 18:26:40] Invalid SQL: INSERT INTO con_keywords (keyword,auto,idlang, idkeyword) VALUES ('http','&9=8',1,0)<br><br>
[16-Nov-2004 18:26:40] Invalid SQL: lock tables con_sequence write<br><br>
[16-Nov-2004 18:26:40] lock() failed.
[16-Nov-2004 18:26:40] cannot lock con_sequence - has it been created?
[16-Nov-2004 18:26:40] Invalid SQL: INSERT INTO con_keywords (keyword,auto,idlang, idkeyword) VALUES ('de','&9=8',1,0)<br><br>
[16-Nov-2004 18:26:40] Invalid SQL: lock tables con_sequence write<br><br>
[16-Nov-2004 18:26:40] lock() failed.
[16-Nov-2004 18:26:40] cannot lock con_sequence - has it been created?
[16-Nov-2004 18:26:40] Invalid SQL: INSERT INTO con_keywords (keyword,auto,idlang, idkeyword) VALUES ('cms','&9=8',1,0)<br><br>
[16-Nov-2004 18:26:40] Invalid SQL: lock tables con_sequence write<br><br>
[16-Nov-2004 18:26:40] lock() failed.
[16-Nov-2004 18:26:40] cannot lock con_sequence - has it been created?
[16-Nov-2004 18:26:40] Invalid SQL: INSERT INTO con_keywords (keyword,auto,idlang, idkeyword) VALUES ('alturo','&9=8',1,0)<br><br>
[16-Nov-2004 18:26:40] Invalid SQL: lock tables con_sequence write<br><br>
[16-Nov-2004 18:26:40] lock() failed.
[16-Nov-2004 18:26:40] cannot lock con_sequence - has it been created?
[16-Nov-2004 18:26:40] Invalid SQL: INSERT INTO con_keywords (keyword,auto,idlang, idkeyword) VALUES ('upload','&9=4',1,0)<br><br>
[16-Nov-2004 18:26:40] Invalid SQL: lock tables con_sequence write<br><br>
[16-Nov-2004 18:26:40] lock() failed.
[16-Nov-2004 18:26:40] cannot lock con_sequence - has it been created?
[16-Nov-2004 18:26:40] Invalid SQL: INSERT INTO con_keywords (keyword,auto,idlang, idkeyword) VALUES ('logos','&9=3',1,0)<br><br>
[16-Nov-2004 18:26:40] Invalid SQL: lock tables con_sequence write<br><br>
[16-Nov-2004 18:26:40] lock() failed.
[16-Nov-2004 18:26:40] cannot lock con_sequence - has it been created?
[16-Nov-2004 18:26:40] Invalid SQL: INSERT INTO con_keywords (keyword,auto,idlang, idkeyword) VALUES ('logo','&9=3',1,0)<br><br>
[16-Nov-2004 18:26:40] Invalid SQL: lock tables con_sequence write<br><br>
[16-Nov-2004 18:26:40] lock() failed.
[16-Nov-2004 18:26:40] cannot lock con_sequence - has it been created?
[16-Nov-2004 18:26:40] Invalid SQL: INSERT INTO con_keywords (keyword,auto,idlang, idkeyword) VALUES ('jpg','&9=2',1,0)<br><br>
[16-Nov-2004 18:26:40] Invalid SQL: lock tables con_sequence write<br><br>
[16-Nov-2004 18:26:40] lock() failed.
[16-Nov-2004 18:26:40] cannot lock con_sequence - has it been created?
[16-Nov-2004 18:26:40] Invalid SQL: INSERT INTO con_keywords (keyword,auto,idlang, idkeyword) VALUES ('contenido','&9=1',1,0)<br><br>
[16-Nov-2004 18:26:40] Invalid SQL: lock tables con_sequence write<br><br>
[16-Nov-2004 18:26:40] lock() failed.
[16-Nov-2004 18:26:40] cannot lock con_sequence - has it been created?
[16-Nov-2004 18:26:40] Invalid SQL: INSERT INTO con_keywords (keyword,auto,idlang, idkeyword) VALUES ('itprof','&9=1',1,0)<br><br>
[16-Nov-2004 18:26:40] Invalid SQL: lock tables con_sequence write<br><br>
[16-Nov-2004 18:26:40] lock() failed.
[16-Nov-2004 18:26:40] cannot lock con_sequence - has it been created?
[16-Nov-2004 18:26:40] Invalid SQL: INSERT INTO con_keywords (keyword,auto,idlang, idkeyword) VALUES ('gif','&9=2',1,0)<br><br>
[16-Nov-2004 18:26:40] Invalid SQL: lock tables con_sequence write<br><br>
[16-Nov-2004 18:26:40] lock() failed.
[16-Nov-2004 18:26:40] cannot lock con_sequence - has it been created?
[16-Nov-2004 18:26:40] Invalid SQL: INSERT INTO con_keywords (keyword,auto,idlang, idkeyword) VALUES ('bilder','&9=1',1,0)<br><br>
[16-Nov-2004 18:26:40] Invalid SQL: lock tables con_sequence write<br><br>
[16-Nov-2004 18:26:40] lock() failed.
[16-Nov-2004 18:26:40] cannot lock con_sequence - has it been created?
[16-Nov-2004 18:26:40] Invalid SQL: INSERT INTO con_keywords (keyword,auto,idlang, idkeyword) VALUES ('banner','&9=1',1,0)<br><br>
[16-Nov-2004 18:26:40] Invalid SQL: lock tables con_sequence write<br><br>
[16-Nov-2004 18:26:40] lock() failed.
[16-Nov-2004 18:26:40] cannot lock con_sequence - has it been created?
[16-Nov-2004 18:26:40] Invalid SQL: INSERT INTO con_keywords (keyword,auto,idlang, idkeyword) VALUES ('fb','&9=1',1,0)<br><br>
[16-Nov-2004 18:26:40] Invalid SQL: lock tables con_sequence write<br><br>
[16-Nov-2004 18:26:40] lock() failed.
[16-Nov-2004 18:26:40] cannot lock con_sequence - has it been created?
[16-Nov-2004 18:26:40] Invalid SQL: INSERT INTO con_keywords (keyword,auto,idlang, idkeyword) VALUES ('startartikel','&9=1',1,0)<br><br>
[16-Nov-2004 18:26:40] Invalid SQL: lock tables con_sequence write<br><br>
[16-Nov-2004 18:26:40] lock() failed.
[16-Nov-2004 18:26:40] cannot lock con_sequence - has it been created?
[16-Nov-2004 18:26:40] Invalid SQL: INSERT INTO con_keywords (keyword,auto,idlang, idkeyword) VALUES ('punkt','&9=1',1,0)<br><br>
[16-Nov-2004 18:26:40] Invalid SQL: lock tables con_sequence write<br><br>
[16-Nov-2004 18:26:40] lock() failed.
[16-Nov-2004 18:26:40] cannot lock con_sequence - has it been created?
[16-Nov-2004 18:26:40] Invalid SQL: INSERT INTO con_code (idcode, idcatart, code, idlang, idclient) VALUES ('0', '21', '<!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://web0.xxxxxxxx.alturo-server.de/k ... o_logo.jpg\" != \"\") {
$img = \'<img src=\"http://web0.xxxxxxx.alturo-server.de/ku ... o_logo.jpg\" border=\"0\">\';
if (\"http://web0.xxxxxxxxx.alturo-server.de/kunden/cms/\" != \"http://\") {
$img = sprintf(\'<a href=\"%s\" target=\"%s\">%s</a>\',\"http://web0.xxxxxxxx.alturo-server.de/kunden/cms/\", \"\", $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://web0.xxxxxxx.alturo-server.de/ku ... f_logo.gif\" != \"\") {
$img = \'<img src=\"http://web0.xxxxxxxx.alturo-server.de/k ... f_logo.gif\" border=\"0\">\';
if (\"http://web0.xxxxxxxx.alturo-server.de/kunden/cms/\" != \"http://\") {
$img = sprintf(\'<a href=\"%s\" target=\"%s\">%s</a>\',\"http://web0.xxxxxxx.alturo-server.de/kunden/cms/\", \"\", $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-->
FC<?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 1\"; ?>
</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://web0.xxxxxxxx.alturo-server.de/k ... banner.jpg\" != \"\") {
$img = \'<img src=\"http://web0.xxxxxxx.alturo-server.de/ku ... banner.jpg\" border=\"0\">\';
if (\"http://web0.xxxxxxxx.alturo-server.de/kunden/cms/\" != \"http://\") {
$img = sprintf(\'<a href=\"%s\" target=\"%s\">%s</a>\',\"http://web0.xxxxxxx.alturo-server.de/kunden/cms/\", \"\", $img);
}
echo $img;
}
echo \"<br>\";
echo \"\";
echo \"<br>\";
echo \"\";
echo \"<br>\";
?>
</td>
</tr>
<tr>
<td><?php
if (\"http://web0.xxxxxxxx.alturo-server.de/k ... b_logo.gif\" != \"\") {
$img = \'<img src=\"http://web0.xxxxxxxx.alturo-server.de/k ... b_logo.gif\" border=\"0\">\';
if (\"http://web0.xxxxxxxxx.alturo-server.de/kunden/cms/\" != \"http://\") {
$img = sprintf(\'<a href=\"%s\" target=\"%s\">%s</a>\',\"http://web0.xxxxxxxx.alturo-server.de/kunden/cms/\", \"\", $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>
[16-Nov-2004 18:26:40] Invalid SQL: lock tables con_sequence write<br><br>
[16-Nov-2004 18:26:40] lock() failed.
[16-Nov-2004 18:26:40] cannot lock con_sequence - has it been created?
[16-Nov-2004 18:26:40] Invalid SQL: INSERT INTO con_stat (visited, idcatart, idlang, idstat, idclient) VALUES ('1', '21', '1', '0', '1')<br><br>
[16-Nov-2004 18:26:40] PHP Warning: Unexpected character in input: '\' (ASCII=92) state=1 in /home/htdocs/web0/html/kunden/cms/front_content.php(563) : eval()'d code on line 21
[16-Nov-2004 18:26:40] PHP Parse error: parse error, expecting `T_STRING' or `T_VARIABLE' or `T_NUM_STRING' in /home/htdocs/web0/html/kunden/cms/front_content.php(563) : eval()'d code on line 51
