bezeichnung; $short_uri = str_replace(array('ä', 'Ä', 'ö', 'Ö', 'ü', 'Ü', 'ß'), array('ae', 'Ae', 'oe', 'Oe', 'ue', 'Ue', 'ss'), $short_uri); $short_uri = preg_replace("@[^0-9aA-zZ\-]@si", "-", $short_uri); $short_uri = preg_replace("@(-{2,})@si", "-", $short_uri); $sql = " INSERT INTO structure SET parent_id=".$parent_ids['oldid_'.$menu->parentid].", old_id=".$menu->rid.", active=1, short_uri='".$short_uri."', image='', name='".$menu->bezeichnung."' "; echo $sql."
"; $query = mysql_query($sql); $last_id = $parent_ids['oldid_'.$menu->rid] = mysql_insert_id($connection); $sql = " INSERT INTO `site_content` (`structure_id`, `type`, `position`, `activ`, `content`, `configuration`) VALUES (".$last_id.", 'textbox', 1, 0, '', NULL), (".$last_id.", 'slider', 2, 0, '', NULL), (".$last_id.", 'article_list', 3, 1, '0', NULL), (".$last_id.", 'banner', 4, 0, '0', NULL), (".$last_id.", 'manufacturers', 5, 0, '', NULL), (".$last_id.", 'substructure', 6, 0, '', NULL), (".$last_id.", 'popular', 0, 0, '', NULL) "; $query = mysql_query($sql); }