| 1 | 4 | ryan | <?php
 | 
      
        | 2 |  |  | 
 | 
      
        | 3 | 36 | stefan | // $Id$
 | 
      
        | 4 | 4 | ryan | 
 | 
      
        | 5 |  |  | /*
 | 
      
        | 6 |  |  | 
 | 
      
        | 7 |  |  |  Website Baker Project <http://www.websitebaker.org/>
 | 
      
        | 8 | 519 | Ruebenwurz |  Copyright (C) 2004-2008, Ryan Djurovich
 | 
      
        | 9 | 4 | ryan | 
 | 
      
        | 10 |  |  |  Website Baker is free software; you can redistribute it and/or modify
 | 
      
        | 11 |  |  |  it under the terms of the GNU General Public License as published by
 | 
      
        | 12 |  |  |  the Free Software Foundation; either version 2 of the License, or
 | 
      
        | 13 |  |  |  (at your option) any later version.
 | 
      
        | 14 |  |  | 
 | 
      
        | 15 |  |  |  Website Baker is distributed in the hope that it will be useful,
 | 
      
        | 16 |  |  |  but WITHOUT ANY WARRANTY; without even the implied warranty of
 | 
      
        | 17 |  |  |  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 | 
      
        | 18 |  |  |  GNU General Public License for more details.
 | 
      
        | 19 |  |  | 
 | 
      
        | 20 |  |  |  You should have received a copy of the GNU General Public License
 | 
      
        | 21 |  |  |  along with Website Baker; if not, write to the Free Software
 | 
      
        | 22 |  |  |  Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
 | 
      
        | 23 |  |  | 
 | 
      
        | 24 |  |  | */
 | 
      
        | 25 |  |  | 
 | 
      
        | 26 | 545 | thorn | // Must include code to stop this file being accessed directly
 | 
      
        | 27 | 543 | thorn | if(defined('WB_PATH') == false) { exit("Cannot access this file directly"); }
 | 
      
        | 28 | 4 | ryan | 
 | 
      
        | 29 | 543 | thorn | // get target page_id
 | 
      
        | 30 |  |  | $table = TABLE_PREFIX.'mod_menu_link';
 | 
      
        | 31 |  |  | $sql_result = $database->query("SELECT * FROM $table WHERE section_id = '$section_id'");
 | 
      
        | 32 |  |  | $sql_row = $sql_result->fetchRow();
 | 
      
        | 33 |  |  | $target_page_id = $sql_row['target_page_id'];
 | 
      
        | 34 | 565 | thorn | $anchor = $sql_row['anchor'];
 | 
      
        | 35 |  |  | $sel = ' selected';
 | 
      
        | 36 | 4 | ryan | 
 | 
      
        | 37 | 543 | thorn | // Get list of all visible page-links, except menu_links and actual page
 | 
      
        | 38 | 565 | thorn | $links = array();
 | 
      
        | 39 | 543 | thorn | $table_p = TABLE_PREFIX."pages";
 | 
      
        | 40 |  |  | $table_s = TABLE_PREFIX."sections";
 | 
      
        | 41 | 565 | thorn | if($query_page = $database->query("SELECT DISTINCT p.* FROM $table_p AS p INNER JOIN $table_s AS s ON p.page_id=s.page_id WHERE s.module != 'menu_link' AND p.page_id != '$page_id' AND parent = '0' ORDER BY position")) {
 | 
      
        | 42 | 543 | thorn | 	while($page = $query_page->fetchRow()) {
 | 
      
        | 43 |  |  | 		if($admin->page_is_visible($page)) {
 | 
      
        | 44 |  |  | 			$links[$page['page_id']]='/'.$page['menu_title'];
 | 
      
        | 45 | 565 | thorn | 			if($query_subpage = $database->query("SELECT DISTINCT p.* FROM $table_p AS p INNER JOIN $table_s AS s ON p.page_id=s.page_id WHERE s.module != 'menu_link' AND p.page_id != '$page_id' AND root_parent = '{$page['page_id']}' ORDER BY level")) {
 | 
      
        | 46 | 543 | thorn | 				while($sub = $query_subpage->fetchRow()) {
 | 
      
        | 47 |  |  | 					if($admin->page_is_visible($sub)) {
 | 
      
        | 48 | 545 | thorn | 						$parent_link = (array_key_exists($sub['parent'],$links))?$links[$sub['parent']]:"";
 | 
      
        | 49 |  |  | 						$links[$sub['page_id']]=$parent_link.'/'.$sub['menu_title'];
 | 
      
        | 50 | 543 | thorn | 					}
 | 
      
        | 51 |  |  | 				}
 | 
      
        | 52 |  |  | 			}
 | 
      
        | 53 |  |  | 		}
 | 
      
        | 54 |  |  | 	}
 | 
      
        | 55 | 4 | ryan | }
 | 
      
        | 56 | 565 | thorn | // Get list of targets (id=... or <a name ...>) from pages in $links
 | 
      
        | 57 |  |  | $targets = array();
 | 
      
        | 58 |  |  | $table_mw = TABLE_PREFIX."mod_wysiwyg";
 | 
      
        | 59 |  |  | $table_s = TABLE_PREFIX."sections";
 | 
      
        | 60 |  |  | foreach($links as $pid=>$l) {
 | 
      
        | 61 |  |  | 	if($query_section = $database->query("SELECT section_id, module FROM $table_s WHERE page_id = '$pid' ORDER BY position")) {
 | 
      
        | 62 |  |  | 		while($section = $query_section->fetchRow()) {
 | 
      
        | 63 |  |  | 			$targets[$pid][] = "wb_section_{$section['section_id']}";
 | 
      
        | 64 |  |  | 			if($section['module'] == 'wysiwyg') {
 | 
      
        | 65 |  |  | 				if($query_page = $database->query("SELECT content FROM $table_mw WHERE section_id = '{$section['section_id']}' LIMIT 1")) {
 | 
      
        | 66 |  |  | 					$page = $query_page->fetchRow();
 | 
      
        | 67 |  |  | 					if(preg_match_all('/<(?:[^>]+id|\s*a[^>]+name)\s*=\s*"(.*)"/iuU',$page['content'], $match)) {
 | 
      
        | 68 |  |  | 						foreach($match[1] AS $t) {
 | 
      
        | 69 |  |  | 							$targets[$pid][] = $t;
 | 
      
        | 70 |  |  | 						}
 | 
      
        | 71 |  |  | 					}
 | 
      
        | 72 |  |  | 				}
 | 
      
        | 73 |  |  | 			}
 | 
      
        | 74 |  |  | 		}
 | 
      
        | 75 |  |  | 	}
 | 
      
        | 76 |  |  | }
 | 
      
        | 77 |  |  | // get target-window for actual page
 | 
      
        | 78 | 543 | thorn | $table = TABLE_PREFIX."pages";
 | 
      
        | 79 |  |  | $query_page = $database->query("SELECT target FROM $table WHERE page_id = '$page_id'");
 | 
      
        | 80 |  |  | $page = $query_page->fetchRow();
 | 
      
        | 81 |  |  | $target = $page['target'];
 | 
      
        | 82 | 4 | ryan | 
 | 
      
        | 83 | 565 | thorn | 
 | 
      
        | 84 |  |  | // script for target-select-box
 | 
      
        | 85 | 543 | thorn | ?>
 | 
      
        | 86 | 565 | thorn | <script type="text/javascript">
 | 
      
        | 87 |  |  | 	function populate()
 | 
      
        | 88 |  |  | 	{
 | 
      
        | 89 |  |  | 		o=document.getElementById('page_link');
 | 
      
        | 90 |  |  | 		d=document.getElementById('page_target');
 | 
      
        | 91 |  |  | 		if(!d){return;}
 | 
      
        | 92 |  |  | 		var mitems=new Array();
 | 
      
        | 93 |  |  | 		mitems['0']=[' ','0'];
 | 
      
        | 94 |  |  | 		<?php
 | 
      
        | 95 |  |  | 		foreach($links AS $pid=>$link) {
 | 
      
        | 96 |  |  | 			$str="mitems['$pid']=[";
 | 
      
        | 97 |  |  | 			$str.="' ',";
 | 
      
        | 98 |  |  | 			$str.="'0',";
 | 
      
        | 99 |  |  | 			if(is_array($targets) && is_array($targets[$pid])) {
 | 
      
        | 100 |  |  | 				foreach($targets[$pid] AS $value) {
 | 
      
        | 101 |  |  | 					$str.="'#$value',";
 | 
      
        | 102 |  |  | 					$str.="'$value',";
 | 
      
        | 103 |  |  | 				}
 | 
      
        | 104 |  |  | 				$str=rtrim($str, ',');
 | 
      
        | 105 |  |  | 				$str.="];\n";
 | 
      
        | 106 |  |  | 			}
 | 
      
        | 107 |  |  | 			echo $str;
 | 
      
        | 108 |  |  | 		}
 | 
      
        | 109 |  |  | 		?>
 | 
      
        | 110 |  |  | 		d.options.length=0;
 | 
      
        | 111 |  |  | 		cur=mitems[o.options[o.selectedIndex].value];
 | 
      
        | 112 |  |  | 		if(!cur){return;}
 | 
      
        | 113 |  |  | 		d.options.length=cur.length/2;
 | 
      
        | 114 |  |  | 		j=0;
 | 
      
        | 115 |  |  | 		for(var i=0;i<cur.length;i=i+2)
 | 
      
        | 116 |  |  | 		{
 | 
      
        | 117 |  |  | 			d.options[j].text=cur[i];
 | 
      
        | 118 |  |  | 			d.options[j++].value=cur[i+1];
 | 
      
        | 119 |  |  | 		}
 | 
      
        | 120 |  |  | 	}
 | 
      
        | 121 |  |  | </script>
 | 
      
        | 122 |  |  | 
 | 
      
        | 123 | 543 | thorn | <form action="<?php echo WB_URL ?>/modules/menu_link/save.php" method="post">
 | 
      
        | 124 |  |  | <input type="hidden" name="page_id" value="<?php echo $page_id ?>" />
 | 
      
        | 125 |  |  | <input type="hidden" name="section_id" value="<?php echo $section_id ?>" />
 | 
      
        | 126 |  |  | <table cellpadding="0" cellspacing="0" border="0" width="100%">
 | 
      
        | 127 |  |  | <tr>
 | 
      
        | 128 |  |  | 	<td>
 | 
      
        | 129 |  |  | 		<?php echo $TEXT['LINK'].':' ?>
 | 
      
        | 130 |  |  | 	</td>
 | 
      
        | 131 |  |  | 	<td>
 | 
      
        | 132 | 565 | thorn | 		<select name="page_link" id="page_link" onchange="populate()" style="width: 100%;">
 | 
      
        | 133 |  |  | 			<option value="0"<?php echo $target_page_id=='0'?$sel:''?>><?php echo $TEXT['PLEASE_SELECT']; ?></option>
 | 
      
        | 134 |  |  | 			<?php foreach($links AS $pid=>$link) {
 | 
      
        | 135 |  |  | 				echo "<option value=\"$pid\" ".($target_page_id==$pid?$sel:'').">$link</option>";
 | 
      
        | 136 |  |  | 			} ?>
 | 
      
        | 137 |  |  | 		</select>
 | 
      
        | 138 | 543 | thorn | 	</td>
 | 
      
        | 139 |  |  | </tr>
 | 
      
        | 140 |  |  | <tr>
 | 
      
        | 141 |  |  | 	<td>
 | 
      
        | 142 | 565 | thorn | 		<?php echo $TEXT['ANCHOR'].':' ?>
 | 
      
        | 143 |  |  | 	</td>
 | 
      
        | 144 |  |  | 	<td>
 | 
      
        | 145 |  |  | 		<select name="page_target" id="page_target" onfocus="populate()" style="width: 100%;">
 | 
      
        | 146 |  |  | 			<option value="<?php echo $anchor ?>" selected><?php echo $anchor=='0'?' ':'#'.$anchor ?></option>
 | 
      
        | 147 |  |  | 		</select>
 | 
      
        | 148 |  |  | 	</td>
 | 
      
        | 149 |  |  | </tr>
 | 
      
        | 150 |  |  | <tr>
 | 
      
        | 151 |  |  | 	<td>
 | 
      
        | 152 | 543 | thorn | 		<?php echo $TEXT['TARGET'].':' ?>
 | 
      
        | 153 |  |  | 	</td>
 | 
      
        | 154 |  |  | 	<td>
 | 
      
        | 155 | 565 | thorn | 		<select name="target" style="width: 100%" />
 | 
      
        | 156 | 543 | thorn | 			<option value="_blank"<?php if($target=='_blank') echo ' selected'; ?>><?php echo $TEXT['NEW_WINDOW'] ?></option>
 | 
      
        | 157 |  |  | 			<option value="_self"<?php if($target=='_self') echo ' selected'; ?>><?php echo $TEXT['SAME_WINDOW'] ?></option>
 | 
      
        | 158 |  |  | 			<option value="_top"<?php if($target=='_top') echo ' selected'; ?>><?php echo $TEXT['TOP_FRAME'] ?></option>
 | 
      
        | 159 |  |  | 		</select>
 | 
      
        | 160 |  |  | 	</td>
 | 
      
        | 161 |  |  | </tr>
 | 
      
        | 162 |  |  | </table>
 | 
      
        | 163 |  |  | 
 | 
      
        | 164 |  |  | <br />
 | 
      
        | 165 |  |  | 
 | 
      
        | 166 |  |  | <table cellpadding="0" cellspacing="0" border="0" width="100%">
 | 
      
        | 167 |  |  | <tr>
 | 
      
        | 168 |  |  | 	<td align="left">
 | 
      
        | 169 |  |  | 		<input type="submit" value="<?php echo $TEXT['SAVE'] ?>" style="width: 100px; margin-top: 5px;" />
 | 
      
        | 170 |  |  | 	</td>
 | 
      
        | 171 |  |  | 	<td align="right">
 | 
      
        | 172 |  |  | 		</form>
 | 
      
        | 173 |  |  | 		<input type="button" value="<?php echo $TEXT['CANCEL'] ?>" onclick="javascript: window.location = 'index.php';" style="width: 100px; margin-top: 5px;" />
 | 
      
        | 174 |  |  | 	</td>
 | 
      
        | 175 |  |  | </tr>
 | 
      
        | 176 |  |  | </table>
 | 
      
        | 177 |  |  | 
 | 
      
        | 178 |  |  | </form>
 |