habe einen neuen Testaccount, auf einem neuen Server.
Es lassen sich keine Unterkategorien anzeigen, und es erscheint folgende Meldung im Errorlog:
[/code][24-Apr-2004 10:37:34] Invalid SQL: lock tables con_sequence write<br><br>
[24-Apr-2004 10:37:34] lock() failed.
[24-Apr-2004 10:37:34] cannot lock con_sequence - has it been created?
[24-Apr-2004 10:37:34] Invalid SQL: INSERT INTO con_keywords (keyword,auto,idlang, idkeyword) VALUES ('startartikel','&15=1',1,0)<br><br>
[24-Apr-2004 10:37:34] Invalid SQL: lock tables con_sequence write<br><br>
[24-Apr-2004 10:37:34] lock() failed.
[24-Apr-2004 10:37:34] cannot lock con_sequence - has it been created?
[24-Apr-2004 10:37:34] Invalid SQL: INSERT INTO con_keywords (keyword,auto,idlang, idkeyword) VALUES ('punkt','&15=1',1,0)<br><br>
[24-Apr-2004 10:37:34] Invalid SQL: lock tables con_sequence write<br><br>
[24-Apr-2004 10:37:34] lock() failed.
[24-Apr-2004 10:37:34] cannot lock con_sequence - has it been created?
[24-Apr-2004 10:37:34] Invalid SQL: INSERT INTO con_keywords (keyword,auto,idlang, idkeyword) VALUES ('upload','&15=4',1,0)<br><br>
[24-Apr-2004 10:37:34] Invalid SQL: lock tables con_sequence write<br><br>
[24-Apr-2004 10:37:34] lock() failed.
[24-Apr-2004 10:37:34] cannot lock con_sequence - has it been created?
[24-Apr-2004 10:37:34] Invalid SQL: INSERT INTO con_keywords (keyword,auto,idlang, idkeyword) VALUES ('logos','&15=3',1,0)<br><br>
[24-Apr-2004 10:37:34] Invalid SQL: lock tables con_sequence write<br><br>
[24-Apr-2004 10:37:34] lock() failed.
[24-Apr-2004 10:37:34] cannot lock con_sequence - has it been created?
[24-Apr-2004 10:37:34] Invalid SQL: INSERT INTO con_keywords (keyword,auto,idlang, idkeyword) VALUES ('logo','&15=3',1,0)<br><br>
[24-Apr-2004 10:37:34] Invalid SQL: lock tables con_sequence write<br><br>
[24-Apr-2004 10:37:34] lock() failed.
[24-Apr-2004 10:37:34] cannot lock con_sequence - has it been created?
[24-Apr-2004 10:37:34] Invalid SQL: INSERT INTO con_keywords (keyword,auto,idlang, idkeyword) VALUES ('jpg','&15=2',1,0)<br><br>
[24-Apr-2004 10:37:34] Invalid SQL: lock tables con_sequence write<br><br>
[24-Apr-2004 10:37:34] lock() failed.
[24-Apr-2004 10:37:34] cannot lock con_sequence - has it been created?
[24-Apr-2004 10:37:34] Invalid SQL: INSERT INTO con_keywords (keyword,auto,idlang, idkeyword) VALUES ('http','&15=8',1,0)<br><br>
[24-Apr-2004 10:37:34] Invalid SQL: lock tables con_sequence write<br><br>
[24-Apr-2004 10:37:34] lock() failed.
[24-Apr-2004 10:37:34] cannot lock con_sequence - has it been created?
[24-Apr-2004 10:37:34] Invalid SQL: INSERT INTO con_keywords (keyword,auto,idlang, idkeyword) VALUES ('de','&15=8',1,0)<br><br>
[24-Apr-2004 10:37:34] Invalid SQL: lock tables con_sequence write<br><br>
[24-Apr-2004 10:37:34] lock() failed.
[24-Apr-2004 10:37:34] cannot lock con_sequence - has it been created?
[24-Apr-2004 10:37:34] Invalid SQL: INSERT INTO con_keywords (keyword,auto,idlang, idkeyword) VALUES ('contenido','&15=1',1,0)<br><br>
[24-Apr-2004 10:37:34] Invalid SQL: lock tables con_sequence write<br><br>
[24-Apr-2004 10:37:34] lock() failed.
[24-Apr-2004 10:37:34] cannot lock con_sequence - has it been created?
[24-Apr-2004 10:37:34] Invalid SQL: INSERT INTO con_keywords (keyword,auto,idlang, idkeyword) VALUES ('cms','&15=16',1,0)<br><br>
[24-Apr-2004 10:37:34] Invalid SQL: lock tables con_sequence write<br><br>
[24-Apr-2004 10:37:34] lock() failed.
[24-Apr-2004 10:37:34] cannot lock con_sequence - has it been created?
[24-Apr-2004 10:37:34] Invalid SQL: INSERT INTO con_keywords (keyword,auto,idlang, idkeyword) VALUES ('ambition','&15=8',1,0)<br><br>
[24-Apr-2004 10:37:34] Invalid SQL: lock tables con_sequence write<br><br>
[24-Apr-2004 10:37:34] lock() failed.
[24-Apr-2004 10:37:34] cannot lock con_sequence - has it been created?
[24-Apr-2004 10:37:34] Invalid SQL: INSERT INTO con_keywords (keyword,auto,idlang, idkeyword) VALUES ('ah','&15=8',1,0)<br><br>
[24-Apr-2004 10:37:34] Invalid SQL: lock tables con_sequence write<br><br>
[24-Apr-2004 10:37:34] lock() failed.
[24-Apr-2004 10:37:34] cannot lock con_sequence - has it been created?
[24-Apr-2004 10:37:34] Invalid SQL: INSERT INTO con_keywords (keyword,auto,idlang, idkeyword) VALUES ('itprof','&15=1',1,0)<br><br>
[24-Apr-2004 10:37:34] Invalid SQL: lock tables con_sequence write<br><br>
[24-Apr-2004 10:37:34] lock() failed.
[24-Apr-2004 10:37:34] cannot lock con_sequence - has it been created?
[24-Apr-2004 10:37:34] Invalid SQL: INSERT INTO con_keywords (keyword,auto,idlang, idkeyword) VALUES ('gif','&15=2',1,0)<br><br>
[24-Apr-2004 10:37:34] Invalid SQL: lock tables con_sequence write<br><br>
[24-Apr-2004 10:37:34] lock() failed.
[24-Apr-2004 10:37:34] cannot lock con_sequence - has it been created?
[24-Apr-2004 10:37:34] Invalid SQL: INSERT INTO con_keywords (keyword,auto,idlang, idkeyword) VALUES ('bilder','&15=1',1,0)<br><br>
[24-Apr-2004 10:37:34] Invalid SQL: lock tables con_sequence write<br><br>
[24-Apr-2004 10:37:34] lock() failed.
[24-Apr-2004 10:37:34] cannot lock con_sequence - has it been created?
[24-Apr-2004 10:37:34] Invalid SQL: INSERT INTO con_keywords (keyword,auto,idlang, idkeyword) VALUES ('banner','&15=1',1,0)<br><br>
[24-Apr-2004 10:37:34] Invalid SQL: lock tables con_sequence write<br><br>
[24-Apr-2004 10:37:34] lock() failed.
[24-Apr-2004 10:37:34] cannot lock con_sequence - has it been created?
[24-Apr-2004 10:37:34] Invalid SQL: INSERT INTO con_keywords (keyword,auto,idlang, idkeyword) VALUES ('fb','&15=1',1,0)<br><br>
[24-Apr-2004 10:37:34] Invalid SQL: lock tables con_sequence write<br><br>
[24-Apr-2004 10:37:34] lock() failed.
[24-Apr-2004 10:37:34] cannot lock con_sequence - has it been created?
[24-Apr-2004 10:37:34] Invalid SQL: INSERT INTO con_keywords (keyword,auto,idlang, idkeyword) VALUES ('blank','&15=3',1,0)<br><br>
[24-Apr-2004 10:37:34] Invalid SQL: lock tables con_sequence write<br><br>
[24-Apr-2004 10:37:34] lock() failed.
[24-Apr-2004 10:37:34] cannot lock con_sequence - has it been created?
[24-Apr-2004 10:37:34] Invalid SQL: INSERT INTO con_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://cms.2ah.ambition24.de/cms/upload ... o_logo.jpg\" != \"\") {
$img = \'<img src=\"http://cms.2ah.ambition24.de/cms/upload ... o_logo.jpg\" border=\"0\">\';
if (\"http://cms.2ah.ambition24.de/cms/\" != \"http://\") {
$img = sprintf(\'<a href=\"%s\" target=\"%s\">%s</a>\',\"http://cms.2ah.ambition24.de/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://cms.2ah.ambition24.de/cms/upload ... f_logo.gif\" != \"\") {
$img = \'<img src=\"http://cms.2ah.ambition24.de/cms/upload ... f_logo.gif\" border=\"0\">\';
if (\"http://cms.2ah.ambition24.de/cms/\" != \"http://\") {
$img = sprintf(\'<a href=\"%s\" target=\"%s\">%s</a>\',\"http://cms.2ah.ambition24.de/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://cms.2ah.ambition24.de/cms/upload ... banner.jpg\" != \"\") {
$img = \'<img src=\"http://cms.2ah.ambition24.de/cms/upload ... banner.jpg\" border=\"0\">\';
if (\"http://cms.2ah.ambition24.de/cms/\" != \"http://\") {
$img = sprintf(\'<a href=\"%s\" target=\"%s\">%s</a>\',\"http://cms.2ah.ambition24.de/cms/\", \"\", $img);
}
echo $img;
}
echo \"<br>\";
echo \"\";
echo \"<br>\";
echo \"\";
echo \"<br>\";
?>
</td>
</tr>
<tr>
<td><?php
if (\"http://cms.2ah.ambition24.de/cms/upload ... b_logo.gif\" != \"\") {
$img = \'<img src=\"http://cms.2ah.ambition24.de/cms/upload ... b_logo.gif\" border=\"0\">\';
if (\"http://cms.2ah.ambition24.de/cms/\" != \"http://\") {
$img = sprintf(\'<a href=\"%s\" target=\"%s\">%s</a>\',\"http://cms.2ah.ambition24.de/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>
[24-Apr-2004 10:37:34] Invalid SQL: lock tables con_sequence write<br><br>
[24-Apr-2004 10:37:34] lock() failed.
[24-Apr-2004 10:37:34] cannot lock con_sequence - has it been created?
[24-Apr-2004 10:37:34] Invalid SQL: INSERT INTO con_stat (visited, idcatart, idlang, idstat, idclient) VALUES ('1', '27', '1', '0', '1')<br><br>
[24-Apr-2004 10:37:34] PHP Warning: Unexpected character in input: '\' (ASCII=92) state=1 in /home/htdocs/web3/html/cms/front_content.php(563) : eval()'d code on line 21
[24-Apr-2004 10:37:34] PHP Parse error: parse error, expecting `T_STRING' or `T_VARIABLE' or `T_NUM_STRING' in /home/htdocs/web3/html/cms/front_content.php(563) : eval()'d code on line 51
[24-Apr-2004 10:37:35] Invalid SQL: lock tables con_sequence write<br><br>
[24-Apr-2004 10:37:35] lock() failed.
[24-Apr-2004 10:37:35] cannot lock con_sequence - has it been created?
[24-Apr-2004 10:37:35] Invalid SQL: INSERT INTO con_stat (visited, idcatart, idlang, idstat, idclient) VALUES ('1', '32', '1', '0', '1')<br><br>
