wenn man in config_misc den output code auf true setzt, wird der ganze inhalt im kleinen fenster angezeigt, jedoch nicht auf der wirklichen seite.
con-code habe ich auch schon geleert.
jemand eine idee?
habe auch versucht die klammer zu setzen, hoffe habe dies richtig gemacht include.con_art_overview.php
Code: Alles auswählen
$sql = "SELECT
a.idart AS idart,
a.idlang AS idlang,
a.idartlang AS idartlang,
a.title AS title,
c.idcat AS idcat,
{ISSTART}
c.idcatart AS idcatart,
a.idtplcfg AS idtplcfg,
a.published AS published,
a.online AS online,
a.created AS created,
a.lastmodified AS lastmodified,
a.timemgmt AS timemgmt,
a.datestart AS datestart,
a.dateend AS dateend,
a.artsort AS artsort,
a.redirect AS redirect,
a.locked AS locked
FROM
(".$cfg["tab"]["art_lang"]." AS a,
".$cfg["tab"]["art"]." AS b,
".$cfg["tab"]["cat_art"]." AS c)
WHERE
(a.idlang = '".$lang."' {SYNCOPTIONS}) AND
a.idart = b.idart AND
b.idclient = '".$client."' AND
b.idart = c.idart AND
c.idcat = '".$idcat."'";
// Simple SQL statement to get the number of articles
$sql_count =
"SELECT
COUNT(*) AS article_count
FROM
(".$cfg["tab"]["art_lang"]." AS a,
".$cfg["tab"]["art"]." AS b,
".$cfg["tab"]["cat_art"]." AS c)
WHERE
(a.idlang = '".Contenido_Security::toInteger($lang)."' {SYNCOPTIONS}) AND
a.idart = b.idart AND
b.idclient = '".Contenido_Security::toInteger($client)."' AND
b.idart = c.idart AND
c.idcat = '".Contenido_Security::toInteger($idcat)."'";
if ($cfg["is_start_compatible"] == true)
{
$sql = str_replace("{ISSTART}", "c.is_start AS is_start,", $sql);
} else {
$sql = str_replace("{ISSTART}", "", $sql);
}
if ($syncoptions == -1)
{
$sql = str_replace("{SYNCOPTIONS}", "", $sql);
$sql_count = str_replace("{SYNCOPTIONS}", "", $sql_count);
} else {
$sql = str_replace("{SYNCOPTIONS}", "OR a.idlang = '".$syncoptions."'", $sql);
$sql_count = str_replace("{SYNCOPTIONS}", "OR a.idlang = '".$syncoptions."'", $sql_count);
und include.con_str_overview.php
Code: Alles auswählen
if ($syncoptions == -1)
{
if ($cfg["is_start_compatible"] == true)
{
$sql2 = "SELECT
c.is_start AS is_start,
a.online AS online,
a.idlang AS idlang
FROM
(".$cfg["tab"]["art_lang"]." AS a,
".$cfg["tab"]["art"]." AS b,
".$cfg["tab"]["cat_art"]." AS c)
WHERE
a.idlang = ".Contenido_Security::toInteger($lang)." AND
a.idart = b.idart AND
b.idclient = '".Contenido_Security::toInteger($client)."' AND
b.idart = c.idart AND
c.idcat = '".Contenido_Security::toInteger($idcat)."'";
} else {
$sql2 = "SELECT
a.online AS online,
a.idlang AS idlang,
a.idartlang AS idartlang
FROM
(".$cfg["tab"]["art_lang"]." AS a,
".$cfg["tab"]["art"]." AS b,
".$cfg["tab"]["cat_art"]." AS c)
WHERE
a.idlang = ".Contenido_Security::toInteger($lang)." AND
a.idart = b.idart AND
b.idclient = '".Contenido_Security::toInteger($client)."' AND
b.idart = c.idart AND
c.idcat = '".Contenido_Security::toInteger($idcat)."'";
}
} else {
if ($cfg["is_start_compatible"] == true)
{
$sql2 = "SELECT
c.is_start AS is_start,
a.online AS online,
a.idlang AS idlang
FROM
(".$cfg["tab"]["art_lang"]." AS a,
".$cfg["tab"]["art"]." AS b,
".$cfg["tab"]["cat_art"]." AS c)
WHERE
a.idart = b.idart AND
b.idclient = '".Contenido_Security::toInteger($client)."' AND
b.idart = c.idart AND
c.idcat = '".Contenido_Security::toInteger($idcat)."'";
} else {
$sql2 = "SELECT
a.idartlang AS idartlang,
a.online AS online,
a.idlang AS idlang
FROM
(".$cfg["tab"]["art_lang"]." AS a,
".$cfg["tab"]["art"]." AS b,
".$cfg["tab"]["cat_art"]." AS c)
WHERE
a.idart = b.idart AND
b.idclient = '".Contenido_Security::toInteger($client)."' AND
b.idart = c.idart AND
c.idcat = '".Contenido_Security::toInteger($idcat)."'";
}
}
$db2->query($sql2);