CONTENIDO Forum

Code: Alles auswählen

/**
* mr_get_idart()
*
* get article id
*
* get recent article from websafe name tree
*
* @modified: 2005-09-11
* @param	string	Websafe name
* @param	integer	category id
* @return 	integer	recent article id
*/
function mr_get_idart ( $str_artname = "", $int_id = 0, $int_lang_id = 0 ) {
	global $cfg;
	
	$int_idart = false;
	
	$db = new DB_Contenido;

    
    
	$str_where = "";
    // only article name were given
    if ($int_id == 0) {
        // get all basic category ids with parentid=0
        $sql = "SELECT idcat FROM " . $cfg["tab"]["cat"] . " WHERE parentid = '0'";
        $db->query ( $sql );
        
        $arr_idcats = array();
        $arr_where = array();
        
        while ($db->next_record()) {
            $arr_idcats[] = "idcat = '" . $db->f("idcat") . "'";
        }
        $str_where = " AND ( " . join(" OR ", $arr_idcats) . ")";
    } else {
        $str_where = " AND ca.idcat = '$int_id'";
    }
    
	$sql = "SELECT al.idart 
			FROM " . $cfg["tab"]["art_lang"] . " al 
			LEFT JOIN " . $cfg["tab"]["cat_art"] . " ca 
			ON al.idart = ca.idart 
			WHERE al.urlname = '$str_artname'" . $str_where;
            
	$db->query($sql);
	$db->next_record();
	
	if ($db->f('idart') > 0) {
		$int_idart = $db->f('idart');
	}
	
	return $int_idart;
}