query("SELECT * FROM `$table` WHERE `section_id` = '$section_id'"); $sql_row = $sql_result->fetchRow( MYSQLI_ASSOC ); $target_page_id = $sql_row['target_page_id']; $r_type = $sql_row['redirect_type']; $extern = $sql_row['extern']; $anchor = $sql_row['anchor']; $sel = ' selected="selected"'; // Get list of all visible pages and build a page-tree // this function will fetch the page_tree, recursive if(!function_exists('menulink_make_tree')) { function menulink_make_tree($parent, $link_pid, $tree) { global $database, $admin, $menulink_titles; $table_p = TABLE_PREFIX."pages"; // get list of page-trails, recursive if($query_page = $database->query("SELECT * FROM `$table_p` WHERE `parent`=$parent ORDER BY `position`")) { while($page = $query_page->fetchRow(MYSQLI_ASSOC)) { if($admin->page_is_visible($page) ) { $pids = explode(',', $page['page_trail']); $entry = ''; foreach($pids as $pid) $entry .= $menulink_titles[$pid].' / '; $tree[$page['page_id']] = rtrim($entry, '/ '); $tree = menulink_make_tree($page['page_id'], $link_pid, $tree); } } } return($tree); } } // get list of all page_ids and page_titles global $menulink_titles; $menulink_titles = array(); $table_p = TABLE_PREFIX."pages"; if($query_page = $database->query("SELECT `page_id`,`menu_title` FROM `$table_p`")) { while($page = $query_page->fetchRow(MYSQLI_ASSOC)) $menulink_titles[$page['page_id']] = $page['menu_title']; } // now get the tree $links = array(); $links = menulink_make_tree(0, $page_id, $links); // Get list of targets (id=... or ) from pages in $links $targets = array(); $table_mw = TABLE_PREFIX."mod_wysiwyg"; $table_s = TABLE_PREFIX."sections"; foreach($links as $pid=>$l) { if($query_section = $database->query("SELECT `section_id`, `module` FROM `$table_s` WHERE `page_id` = '$pid' ORDER BY position")) { while($aMenuLink = $query_section->fetchRow(MYSQLI_ASSOC)) { // get section-anchor if(defined('SEC_ANCHOR') && SEC_ANCHOR!='') { $targets[$pid][] = SEC_ANCHOR.$aMenuLink['section_id']; } else { $targets[$pid] = array(); } if($aMenuLink['module'] == 'wysiwyg') { if($query_page = $database->query("SELECT `content` FROM $table_mw WHERE `section_id` = '{$aMenuLink['section_id']}' ")) { $page = $query_page->fetchRow(MYSQLI_ASSOC); if(preg_match_all('/<(?:a[^>]+name|[^>]+id)\s*=\s*"([^"]+)"/i',$page['content'], $match)) { foreach($match[1] AS $t) { $targets[$pid][$t] = $t; } } } } } } } // get target-window for actual page $table = TABLE_PREFIX."pages"; $query_page = $database->query("SELECT target FROM $table WHERE page_id = '$page_id'"); $page = $query_page->fetchRow(); $target = $page['target']; // script for target-select-box ?>

getFTAN(); ?>

	> > $link) { if ($pid == $page_id) // Display current page with selection disabled echo "$link *\n"; else echo "$link\n"; } ?>   />
	> > >
	>301 >302