CONTENIDO Forum

Code: Alles auswählen

function _getArticlesByCatId($idcat)
    {
    	global $cfg;
		
    	if ($cfg["is_start_compatible"] == true)
    	{
            $sql = 'SELECT
                        a.idart,
                        c.is_start
                    FROM
                        '.$this->tab['art_lang'].' AS a,
                        '.$this->tab['art'].' AS b,
                        '.$this->tab['cat_art'].' AS c
                    WHERE
                        c.idcat = '.$idcat.' AND
                        b.idclient = '.$this->client.' AND
                        b.idart = c.idart AND
                        a.idart = b.idart AND
                        a.idlang = '.$this->lang.'';
    	} else {
    		
			$sArtSpecs = (count($this->artspecs) > 0) ? " a.artspec IN ('".implode("','", $this->artspecs)."') AND " : '';
    		
		    $sql = 'SELECT
                    a.idart,
					a.idartlang,
					c.is_start
                FROM
                    '.$this->tab['art_lang'].' AS a,
                    '.$this->tab['art'].' AS b,
                    '.$this->tab['cat_art'].' AS c
                WHERE
                    c.idcat = '.$idcat.' AND
                    b.idclient = '.$this->client.' AND
                    b.idart = c.idart AND
                    a.idart = b.idart AND
					'.$sArtSpecs.'
                    a.idlang = '.$this->lang.'';   		
    	}