| 
      1
     | 
    
      <?php
 
     | 
  
  
    | 
      2
     | 
    
      
 
     | 
  
  
    | 
      3
     | 
    
      // $Id: modify.php 565 2008-01-19 15:07:26Z thorn $
 
     | 
  
  
    | 
      4
     | 
    
      
 
     | 
  
  
    | 
      5
     | 
    
      /*
 
     | 
  
  
    | 
      6
     | 
    
      
 
     | 
  
  
    | 
      7
     | 
    
       Website Baker Project <http://www.websitebaker.org/>
 
     | 
  
  
    | 
      8
     | 
    
       Copyright (C) 2004-2008, Ryan Djurovich
 
     | 
  
  
    | 
      9
     | 
    
      
 
     | 
  
  
    | 
      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
     | 
    
      // Must include code to stop this file being accessed directly
 
     | 
  
  
    | 
      27
     | 
    
      if(defined('WB_PATH') == false) { exit("Cannot access this file directly"); }
     | 
  
  
    | 
      28
     | 
    
      
 
     | 
  
  
    | 
      29
     | 
    
      // 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
     | 
    
      $anchor = $sql_row['anchor'];
 
     | 
  
  
    | 
      35
     | 
    
      $sel = ' selected';
 
     | 
  
  
    | 
      36
     | 
    
      
 
     | 
  
  
    | 
      37
     | 
    
      // Get list of all visible page-links, except menu_links and actual page
 
     | 
  
  
    | 
      38
     | 
    
      $links = array();
 
     | 
  
  
    | 
      39
     | 
    
      $table_p = TABLE_PREFIX."pages";
 
     | 
  
  
    | 
      40
     | 
    
      $table_s = TABLE_PREFIX."sections";
 
     | 
  
  
    | 
      41
     | 
    
      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
     | 
    
      	while($page = $query_page->fetchRow()) {
     | 
  
  
    | 
      43
     | 
    
      		if($admin->page_is_visible($page)) {
     | 
  
  
    | 
      44
     | 
    
      			$links[$page['page_id']]='/'.$page['menu_title'];
 
     | 
  
  
    | 
      45
     | 
    
      			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
     | 
    
      				while($sub = $query_subpage->fetchRow()) {
     | 
  
  
    | 
      47
     | 
    
      					if($admin->page_is_visible($sub)) {
     | 
  
  
    | 
      48
     | 
    
      						$parent_link = (array_key_exists($sub['parent'],$links))?$links[$sub['parent']]:"";
 
     | 
  
  
    | 
      49
     | 
    
      						$links[$sub['page_id']]=$parent_link.'/'.$sub['menu_title'];
 
     | 
  
  
    | 
      50
     | 
    
      					}
 
     | 
  
  
    | 
      51
     | 
    
      				}
 
     | 
  
  
    | 
      52
     | 
    
      			}
 
     | 
  
  
    | 
      53
     | 
    
      		}
 
     | 
  
  
    | 
      54
     | 
    
      	}
 
     | 
  
  
    | 
      55
     | 
    
      }
 
     | 
  
  
    | 
      56
     | 
    
      // 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
     | 
    
      $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
     | 
    
      
 
     | 
  
  
    | 
      83
     | 
    
      
 
     | 
  
  
    | 
      84
     | 
    
      // script for target-select-box
 
     | 
  
  
    | 
      85
     | 
    
      ?>
 
     | 
  
  
    | 
      86
     | 
    
      <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
     | 
    
      <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
     | 
    
      		<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
     | 
    
      	</td>
 
     | 
  
  
    | 
      139
     | 
    
      </tr>
 
     | 
  
  
    | 
      140
     | 
    
      <tr>
 
     | 
  
  
    | 
      141
     | 
    
      	<td>
 
     | 
  
  
    | 
      142
     | 
    
      		<?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
     | 
    
      		<?php echo $TEXT['TARGET'].':' ?>
 
     | 
  
  
    | 
      153
     | 
    
      	</td>
 
     | 
  
  
    | 
      154
     | 
    
      	<td>
 
     | 
  
  
    | 
      155
     | 
    
      		<select name="target" style="width: 100%" />
 
     | 
  
  
    | 
      156
     | 
    
      			<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>
 
     | 
  
  
    | 
      179
     | 
    
      
 
     |