anmerkung: ergänzung idclient in _cat_tree

[emergence]

ich spiele mich gerade mit dem ergänzen dieser spalte in der db tabelle und bin auf ein paar unschönheiten getroffen, die diese ergänzung auslöst...

functions.con.php

function conFetchCategoryTree

Code: Alles auswählen

    $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 
                idclient = '".$client."'
            ORDER BY
                idtree";

ersetzen durch

Code: Alles auswählen

    $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."'
            ORDER BY
                A.idtree";

function conDeeperCategoriesArray

Code: Alles auswählen

    $sql = "SELECT
                *
            FROM
                ".$cfg["tab"]["cat_tree"]." AS A,
                ".$cfg["tab"]["cat"]." AS B
            WHERE
                A.idcat  = B.idcat AND
                idclient = '".$client."'
            ORDER BY
                idtree";

ersetzen durch

Code: Alles auswählen

    $sql = "SELECT
                *
            FROM
                ".$cfg["tab"]["cat_tree"]." AS A,
                ".$cfg["tab"]["cat"]." AS B
            WHERE
                A.idcat  = B.idcat AND
                B.idclient = '".$client."'
            ORDER BY
                A.idtree";

[emergence]

functions.str.php

function strDeeperCategoriesArray

Code: Alles auswählen

        $sql = "SELECT * FROM ".$cfg["tab"]["cat_tree"]." AS A, ".$cfg["tab"]["cat"]." AS B WHERE A.idcat=B.idcat AND idclient='$client' ORDER BY idtree";

ersetzen durch

Code: Alles auswählen

    $sql = "SELECT 
                * 
            FROM 
                ".$cfg["tab"]["cat_tree"]." AS A, 
                ".$cfg["tab"]["cat"]." AS B 
            WHERE 
                A.idcat  = B.idcat AND 
                B.idclient = '".$client."' 
            ORDER BY 
                A.idtree";

noch ne anmerkung
strDeeperCategoriesArray und conDeeperCategoriesArray
machen eigentlich exakt das selbe...

[emergence]

front_content.php

Code: Alles auswählen

				$sql = "SELECT
                            idart,
                            B.idcat
                        FROM
                            ".$cfg["tab"]["cat_art"]." AS A,
                            ".$cfg["tab"]["cat_tree"]." AS B,
                            ".$cfg["tab"]["cat"]." AS C
                        WHERE
                            A.idcat=B.idcat AND
                            B.idcat=C.idcat AND
                            is_start='1' AND
                            idclient='$client'
                        ORDER BY
                            idtree ASC";

ersetzen durch

Code: Alles auswählen

				$sql = "SELECT
                            idart,
                            B.idcat
                        FROM
                            ".$cfg["tab"]["cat_art"]." AS A,
                            ".$cfg["tab"]["cat_tree"]." AS B,
                            ".$cfg["tab"]["cat"]." AS C
                        WHERE
                            A.idcat=B.idcat AND
                            B.idcat=C.idcat AND
                            A.is_start='1' AND
                            C.idclient='$client'
                        ORDER BY
                            B.idtree ASC";

und

Code: Alles auswählen

				$sql = "SELECT
                            A.idart,
                            B.idcat
                        FROM
                            ".$cfg["tab"]["cat_art"]." AS A,
                            ".$cfg["tab"]["cat_tree"]." AS B,
                            ".$cfg["tab"]["cat"]." AS C,
							".$cfg["tab"]["cat_lang"]." AS D,
							".$cfg["tab"]["art_lang"]." AS E
                        WHERE
                            A.idcat=B.idcat AND
                            B.idcat=C.idcat AND
							D.startidartlang = E.idartlang AND
							D.idlang='$lang' AND
							E.idart=A.idart AND
							E.idlang='$lang' AND
                            idclient='$client'
                        ORDER BY
                            idtree ASC";

durch

Code: Alles auswählen

				$sql = "SELECT
                            A.idart,
                            B.idcat
                        FROM
                            ".$cfg["tab"]["cat_art"]." AS A,
                            ".$cfg["tab"]["cat_tree"]." AS B,
                            ".$cfg["tab"]["cat"]." AS C,
							".$cfg["tab"]["cat_lang"]." AS D,
							".$cfg["tab"]["art_lang"]." AS E
                        WHERE
                            A.idcat=B.idcat AND
                            B.idcat=C.idcat AND
							D.startidartlang = E.idartlang AND
							D.idlang='$lang' AND
							E.idart=A.idart AND
							E.idlang='$lang' AND
                            C.idclient='$client'
                        ORDER BY
                            B.idtree ASC";