| 1 | <?php
 | 
  
    | 2 | /**
 | 
  
    | 3 |  *
 | 
  
    | 4 |  * @category        admin
 | 
  
    | 5 |  * @package         settings
 | 
  
    | 6 |  * @author          WebsiteBaker Project
 | 
  
    | 7 |  * @copyright       2009-2012, WebsiteBaker Org. e.V.
 | 
  
    | 8 |  * @link			http://www.websitebaker2.org/
 | 
  
    | 9 |  * @license         http://www.gnu.org/licenses/gpl.html
 | 
  
    | 10 |  * @platform        WebsiteBaker 2.8.x
 | 
  
    | 11 |  * @requirements    PHP 5.2.2 and higher
 | 
  
    | 12 |  * @version         $Id: save.php 1777 2012-10-01 16:16:26Z Luisehahne $
 | 
  
    | 13 |  * @filesource		$HeadURL: svn://isteam.dynxs.de/wb-archiv/branches/2.8.x/wb/admin/settings/save.php $
 | 
  
    | 14 |  * @lastmodified    $Date: 2012-10-01 18:16:26 +0200 (Mon, 01 Oct 2012) $
 | 
  
    | 15 |  *
 | 
  
    | 16 |  */
 | 
  
    | 17 | 
 | 
  
    | 18 | // prevent this file from being accessed directly in the browser (would set all entries in DB settings table to '')
 | 
  
    | 19 | if(!isset($_POST['default_language']) || $_POST['default_language'] == '') die(header('Location: index.php'));
 | 
  
    | 20 | 
 | 
  
    | 21 | // Find out if the user was view advanced options or not
 | 
  
    | 22 | $advanced = ($_POST['advanced'] == 'yes') ? '?advanced=yes' : '';
 | 
  
    | 23 | 
 | 
  
    | 24 | // Print admin header
 | 
  
    | 25 | require('../../config.php');
 | 
  
    | 26 | require_once(WB_PATH.'/framework/class.admin.php');
 | 
  
    | 27 | require_once(WB_PATH.'/framework/functions.php');
 | 
  
    | 28 | 
 | 
  
    | 29 | // suppress to print the header, so no new FTAN will be set
 | 
  
    | 30 | if($advanced == '')
 | 
  
    | 31 | {
 | 
  
    | 32 | 	$admin = new admin('Settings', 'settings_basic',false);
 | 
  
    | 33 | } else {
 | 
  
    | 34 | 	$admin = new admin('Settings', 'settings_advanced',false);
 | 
  
    | 35 | }
 | 
  
    | 36 | 
 | 
  
    | 37 | // Create a javascript back link
 | 
  
    | 38 | $js_back = ADMIN_URL.'/settings/index.php'.$advanced;
 | 
  
    | 39 | if( !$admin->checkFTAN() )
 | 
  
    | 40 | {
 | 
  
    | 41 | 	$admin->print_header();
 | 
  
    | 42 | 	$admin->print_error($MESSAGE['GENERIC_SECURITY_ACCESS'],$js_back );
 | 
  
    | 43 | }
 | 
  
    | 44 | // After check print the header
 | 
  
    | 45 | $admin->print_header();
 | 
  
    | 46 | 
 | 
  
    | 47 | // Ensure that the specified default email is formally valid
 | 
  
    | 48 | if(isset($_POST['server_email']))
 | 
  
    | 49 | {
 | 
  
    | 50 | 	$_POST['server_email'] = strip_tags($_POST['server_email']);
 | 
  
    | 51 | //    // $pattern = '/^[-a-z0-9~!$%^&*_=+}{\'?]+(\.[-a-z0-9~!$%^&*_=+}{\'?]+)*@([a-z0-9]([-a-z0-9_]?[a-z0-9])*(\.[-a-z0-9_]+)*\.(aero|arpa|biz|com|coop|edu|gov|info|int|mil|museum|name|net|org|pro|travel|mobi|[a-z]{2})|([1]?\d{1,2}|2[0-4]{1}\d{1}|25[0-5]{1})(\.([1]?\d{1,2}|2[0-4]{1}\d{1}|25[0-5]{1})){3})(:[0-9]{1,5})?\r/im';
 | 
  
    | 52 | //    $pattern = '/^[_a-zA-Z0-9-]+(\.[_a-zA-Z0-9-]+)*@[a-zA-Z0-9-]+(\.[a-zA-Z0-9-]+)*\.(([0-9]{1,3})|([a-zA-Z]{2,6}))$/';
 | 
  
    | 53 | //    if(false == preg_match($pattern, $_POST['server_email']))
 | 
  
    | 54 | 	if(!$admin->validate_email($_POST['server_email']))
 | 
  
    | 55 |     {
 | 
  
    | 56 | 		$admin->print_error($MESSAGE['USERS_INVALID_EMAIL'].
 | 
  
    | 57 | 			'<br /><strong>Email: '.htmlentities($_POST['server_email']).'</strong>', $js_back);
 | 
  
    | 58 | 	}
 | 
  
    | 59 | }
 | 
  
    | 60 | 
 | 
  
    | 61 | if($admin->StripCodeFromText($admin->get_post('wbmailer_routine'))=='smtp') {
 | 
  
    | 62 | 
 | 
  
    | 63 | 	$checkSmtpHost = (($admin->StripCodeFromText($admin->get_post('wbmailer_smtp_host'))=='') ? false : true);
 | 
  
    | 64 | //	$checkSmtpHost = (isset($_POST['wbmailer_smtp_host']) && ($_POST['wbmailer_smtp_host']=='') ? false : true);
 | 
  
    | 65 | 	$checkSmtpUser = (($admin->StripCodeFromText($admin->get_post('wbmailer_smtp_username'))=='') ? false : true);
 | 
  
    | 66 | //	$checkSmtpUser = (isset($_POST['wbmailer_smtp_username']) && ($_POST['wbmailer_smtp_username']=='') ? false : true);
 | 
  
    | 67 | 	$checkSmtpPassword = (($admin->StripCodeFromText($admin->get_post('wbmailer_smtp_password'))=='') ? false : true);
 | 
  
    | 68 | //	$checkSmtpPassword = (isset($_POST['wbmailer_smtp_password']) && ($_POST['wbmailer_smtp_password']=='') ? false : true);
 | 
  
    | 69 | 
 | 
  
    | 70 | 	if(!$checkSmtpHost || !$checkSmtpUser || !$checkSmtpPassword) {
 | 
  
    | 71 | 		$admin->print_error($TEXT['REQUIRED'].' '.$TEXT['WBMAILER_SMTP_AUTH'].
 | 
  
    | 72 | 			'<br /><strong>'.$MESSAGE['GENERIC_FILL_IN_ALL'].'</strong>', $js_back);
 | 
  
    | 73 | 	}
 | 
  
    | 74 | 
 | 
  
    | 75 | }
 | 
  
    | 76 | 
 | 
  
    | 77 | // Work-out file mode
 | 
  
    | 78 | if($advanced == '')
 | 
  
    | 79 | {
 | 
  
    | 80 | 	$file_mode = STRING_FILE_MODE;
 | 
  
    | 81 | 	$dir_mode = STRING_DIR_MODE;
 | 
  
    | 82 | 	// Check if should be set to 777 or left alone
 | 
  
    | 83 | //	if(isset($_POST['world_writeable']) && $_POST['world_writeable'] == 'true')
 | 
  
    | 84 | //    {
 | 
  
    | 85 | //		$file_mode = '0777';
 | 
  
    | 86 | //		$dir_mode = '0777';
 | 
  
    | 87 | //	} else {
 | 
  
    | 88 | //		$file_mode = STRING_FILE_MODE;
 | 
  
    | 89 | //		$dir_mode = STRING_DIR_MODE;
 | 
  
    | 90 | //	}
 | 
  
    | 91 | } else {
 | 
  
    | 92 | 	$file_mode = STRING_FILE_MODE;
 | 
  
    | 93 | 	$dir_mode = STRING_DIR_MODE;
 | 
  
    | 94 | 	if($admin->get_user_id()=='1')
 | 
  
    | 95 | 	{
 | 
  
    | 96 | 		// Work-out the octal value for file mode
 | 
  
    | 97 | 		$u = 0;
 | 
  
    | 98 | 		if(isset($_POST['file_u_r']) && $_POST['file_u_r'] == 'true') {
 | 
  
    | 99 | 			$u = $u+4;
 | 
  
    | 100 | 		}
 | 
  
    | 101 | 		if(isset($_POST['file_u_w']) && $_POST['file_u_w'] == 'true') {
 | 
  
    | 102 | 			$u = $u+2;
 | 
  
    | 103 | 		}
 | 
  
    | 104 | 		if(isset($_POST['file_u_e']) && $_POST['file_u_e'] == 'true') {
 | 
  
    | 105 | 			$u = $u+1;
 | 
  
    | 106 | 		}
 | 
  
    | 107 | 		$g = 0;
 | 
  
    | 108 | 		if(isset($_POST['file_g_r']) && $_POST['file_g_r'] == 'true') {
 | 
  
    | 109 | 			$g = $g+4;
 | 
  
    | 110 | 		}
 | 
  
    | 111 | 		if(isset($_POST['file_g_w']) && $_POST['file_g_w'] == 'true') {
 | 
  
    | 112 | 			$g = $g+2;
 | 
  
    | 113 | 		}
 | 
  
    | 114 | 		if(isset($_POST['file_g_e']) && $_POST['file_g_e'] == 'true') {
 | 
  
    | 115 | 			$g = $g+1;
 | 
  
    | 116 | 		}
 | 
  
    | 117 | 		$o = 0;
 | 
  
    | 118 | 		if(isset($_POST['file_o_r']) && $_POST['file_o_r'] == 'true') {
 | 
  
    | 119 | 			$o = $o+4;
 | 
  
    | 120 | 		}
 | 
  
    | 121 | 		if(isset($_POST['file_o_w']) && $_POST['file_o_w'] == 'true') {
 | 
  
    | 122 | 			$o = $o+2;
 | 
  
    | 123 | 		}
 | 
  
    | 124 | 		if(isset($_POST['file_o_e']) && $_POST['file_o_e'] == 'true') {
 | 
  
    | 125 | 			$o = $o+1;
 | 
  
    | 126 | 		}
 | 
  
    | 127 | 		$file_mode = "0".$u.$g.$o;
 | 
  
    | 128 | 		// Work-out the octal value for dir mode
 | 
  
    | 129 | 		$u = 0;
 | 
  
    | 130 | 		if(isset($_POST['dir_u_r']) && $_POST['dir_u_r'] == 'true') {
 | 
  
    | 131 | 			$u = $u+4;
 | 
  
    | 132 | 		}
 | 
  
    | 133 | 		if(isset($_POST['dir_u_w']) && $_POST['dir_u_w'] == 'true') {
 | 
  
    | 134 | 			$u = $u+2;
 | 
  
    | 135 | 		}
 | 
  
    | 136 | 		if(isset($_POST['dir_u_e']) && $_POST['dir_u_e'] == 'true') {
 | 
  
    | 137 | 			$u = $u+1;
 | 
  
    | 138 | 		}
 | 
  
    | 139 | 		$g = 0;
 | 
  
    | 140 | 		if(isset($_POST['dir_g_r']) && $_POST['dir_g_r'] == 'true') {
 | 
  
    | 141 | 			$g = $g+4;
 | 
  
    | 142 | 		}
 | 
  
    | 143 | 		if(isset($_POST['dir_g_w']) && $_POST['dir_g_w'] == 'true') {
 | 
  
    | 144 | 			$g = $g+2;
 | 
  
    | 145 | 		}
 | 
  
    | 146 | 		if(isset($_POST['dir_g_e']) && $_POST['dir_g_e'] == 'true') {
 | 
  
    | 147 | 			$g = $g+1;
 | 
  
    | 148 | 		}
 | 
  
    | 149 | 		$o = 0;
 | 
  
    | 150 | 		if(isset($_POST['dir_o_r']) && $_POST['dir_o_r'] == 'true') {
 | 
  
    | 151 | 			$o = $o+4;
 | 
  
    | 152 | 		}
 | 
  
    | 153 | 		if(isset($_POST['dir_o_w']) && $_POST['dir_o_w'] == 'true') {
 | 
  
    | 154 | 			$o = $o+2;
 | 
  
    | 155 | 		}
 | 
  
    | 156 | 		if(isset($_POST['dir_o_e']) && $_POST['dir_o_e'] == 'true') {
 | 
  
    | 157 | 			$o = $o+1;
 | 
  
    | 158 | 		}
 | 
  
    | 159 | 		$dir_mode = "0".$u.$g.$o;
 | 
  
    | 160 | 	}
 | 
  
    | 161 | }
 | 
  
    | 162 | 
 | 
  
    | 163 | $allow_tags_in_fields = array(
 | 
  
    | 164 |     'website_header',
 | 
  
    | 165 |     'website_footer',
 | 
  
    | 166 |     'website_signature'
 | 
  
    | 167 |     );
 | 
  
    | 168 | $allow_empty_values = array(
 | 
  
    | 169 |     'website_header',
 | 
  
    | 170 |     'website_footer',
 | 
  
    | 171 |     'website_signature',
 | 
  
    | 172 |     'wysiwyg_style',
 | 
  
    | 173 |     'pages_directory',
 | 
  
    | 174 |     'page_icon_dir',
 | 
  
    | 175 |     'rename_files_on_upload',
 | 
  
    | 176 |     'page_spacer',
 | 
  
    | 177 |     'website_signature',
 | 
  
    | 178 |     'page_icon_dir',
 | 
  
    | 179 |     'modules_upgrade_list'
 | 
  
    | 180 |     );
 | 
  
    | 181 | $disallow_in_fields = array(
 | 
  
    | 182 |     'pages_directory',
 | 
  
    | 183 |     'media_directory',
 | 
  
    | 184 |     'wb_version'
 | 
  
    | 185 |     );
 | 
  
    | 186 | $StripCodeFromInput = array(
 | 
  
    | 187 |     'website_title',
 | 
  
    | 188 |     'website_description',
 | 
  
    | 189 |     'website_keywords',
 | 
  
    | 190 |     'wysiwyg_style',
 | 
  
    | 191 |     'search_module_order',
 | 
  
    | 192 |     'search_max_excerpt',
 | 
  
    | 193 |     'search_time_limit',
 | 
  
    | 194 |     'pages_directory',
 | 
  
    | 195 |     'page_icon_dir',
 | 
  
    | 196 |     'media_directory',
 | 
  
    | 197 |     'page_extension',
 | 
  
    | 198 |     'rename_files_on_upload',
 | 
  
    | 199 |     'page_spacer',
 | 
  
    | 200 |     'page_icon_dir',
 | 
  
    | 201 |     'modules_upgrade_list'
 | 
  
    | 202 |     );
 | 
  
    | 203 | 
 | 
  
    | 204 | $bRebuildAccessFiles = ( (isset( $_POST['rebuild_access_files']) && ( $_POST['rebuild_access_files'] == true )) ? true : false ) ;
 | 
  
    | 205 | 
 | 
  
    | 206 | // Query current settings in the db, then loop through them and update the db with the new value
 | 
  
    | 207 | $settings = array();
 | 
  
    | 208 | $old_settings = array();
 | 
  
    | 209 | // Query current settings in the db, then loop through them to get old values
 | 
  
    | 210 | $sql = 'SELECT `name`, `value` FROM `'.TABLE_PREFIX.'settings`';
 | 
  
    | 211 | $sql .= 'ORDER BY `name`';
 | 
  
    | 212 | 
 | 
  
    | 213 | if($res_settings = $database->query($sql)) {
 | 
  
    | 214 | 	$passed = false;
 | 
  
    | 215 | 	while($setting = $res_settings->fetchRow())
 | 
  
    | 216 | 	{
 | 
  
    | 217 | 		$setting_name = $setting['name'];
 | 
  
    | 218 | 		$old_settings[$setting_name] = $setting['value'];
 | 
  
    | 219 | 		$value = $admin->get_post($setting_name);
 | 
  
    | 220 | 		$value = isset($_POST[$setting_name]) ? $value : $old_settings[$setting_name] ;
 | 
  
    | 221 | 		switch ($setting_name) {
 | 
  
    | 222 | 			case 'default_timezone':
 | 
  
    | 223 | 				$value=$value*60*60;
 | 
  
    | 224 | 				$passed = true;
 | 
  
    | 225 | 				break;
 | 
  
    | 226 | 			case 'string_dir_mode':
 | 
  
    | 227 | 				$value=$dir_mode;
 | 
  
    | 228 | 				$passed = true;
 | 
  
    | 229 | 				break;
 | 
  
    | 230 | 			case 'string_file_mode':
 | 
  
    | 231 | 				$value=$file_mode;
 | 
  
    | 232 | 	 			$passed = true;
 | 
  
    | 233 |     			break;
 | 
  
    | 234 | 			case 'sec_anchor':
 | 
  
    | 235 |                 $value = $admin->StripCodeFromText($value);
 | 
  
    | 236 | 				$value=(($value=='') ? 'section_' : $value);
 | 
  
    | 237 | 	 			$passed = true;
 | 
  
    | 238 | 				break;
 | 
  
    | 239 | 			case 'pages_directory':
 | 
  
    | 240 |                 $value = $admin->StripCodeFromText($value);
 | 
  
    | 241 |                 $bNewPageFile = ( ( $value!= $old_settings['pages_directory'] ) ? true :  false );
 | 
  
    | 242 | 	 			$passed = $bNewPageFile;
 | 
  
    | 243 |                 $sGetId = '&id='.$bNewPageFile;
 | 
  
    | 244 | //                if(!is_dir(WB_PATH.$value) && is_writable(WB_PATH)) {
 | 
  
    | 245 | //                    $passed = make_dir(WB_PATH.$value);
 | 
  
    | 246 | //                }
 | 
  
    | 247 |                 $value  = (($passed == true) ? $value : $old_settings['pages_directory']);
 | 
  
    | 248 |                 $sPageDirectory = $value;
 | 
  
    | 249 | 				break;
 | 
  
    | 250 | 			case 'wbmailer_smtp_auth':
 | 
  
    | 251 | 				// $value = isset($_POST[$setting_name]) ? $_POST[$setting_name] : '' ;
 | 
  
    | 252 | 				$value = true ;
 | 
  
    | 253 | 	 			$passed = true;
 | 
  
    | 254 | 				break;
 | 
  
    | 255 | 			default :
 | 
  
    | 256 |                 $passed = in_array($setting_name, $allow_empty_values);
 | 
  
    | 257 |                 if(in_array($setting_name, $StripCodeFromInput) ) {
 | 
  
    | 258 |                     $value = $admin->StripCodeFromText($value);
 | 
  
    | 259 |                 }
 | 
  
    | 260 | 				break;
 | 
  
    | 261 | 		}
 | 
  
    | 262 | 
 | 
  
    | 263 | 	    if (!in_array($setting_name, $allow_tags_in_fields))
 | 
  
    | 264 | 	    {
 | 
  
    | 265 | 	        $value = strip_tags($value);
 | 
  
    | 266 | 	    }
 | 
  
    | 267 | 
 | 
  
    | 268 | 	    if ( !in_array($value, $disallow_in_fields) && (isset($_POST[$setting_name]) || $passed == true) )
 | 
  
    | 269 | 	    {
 | 
  
    | 270 | 	        $value = trim($admin->add_slashes($value));
 | 
  
    | 271 | 	        $sql = 'UPDATE `'.TABLE_PREFIX.'settings` ';
 | 
  
    | 272 | 	        $sql .= 'SET `value` = \''.($value).'\' '; // mysql_escape_string
 | 
  
    | 273 | 	        $sql .= 'WHERE `name` != \'wb_version\' ';
 | 
  
    | 274 | 	        $sql .= 'AND `name` = \''.$setting_name.'\' ';
 | 
  
    | 275 | 	        if (!$database->query($sql))
 | 
  
    | 276 | 	        {
 | 
  
    | 277 | 				if($database->is_error()) {
 | 
  
    | 278 | 					$admin->print_error($database->get_error, $js_back );
 | 
  
    | 279 | 				}
 | 
  
    | 280 | 	        }
 | 
  
    | 281 | 		}
 | 
  
    | 282 | 	}
 | 
  
    | 283 | 
 | 
  
    | 284 |     if(($bRebuildAccessFiles==true) && ($_POST['modules_upgrade_list']!='') && ($sPageDirectory==$old_settings['pages_directory']) ) {
 | 
  
    | 285 |         rebuild_all_accessfiles();
 | 
  
    | 286 |         $aModuleList = ( explode(',', $_POST['modules_upgrade_list']));
 | 
  
    | 287 |         upgrade_modules($aModuleList);
 | 
  
    | 288 |     }
 | 
  
    | 289 | 
 | 
  
    | 290 | }
 | 
  
    | 291 | $StripCodeFromISearch = array(
 | 
  
    | 292 |     'search_module_order',
 | 
  
    | 293 |     'search_max_excerpt',
 | 
  
    | 294 |     'search_time_limit',
 | 
  
    | 295 |     );
 | 
  
    | 296 | 
 | 
  
    | 297 | // Query current search settings in the db, then loop through them and update the db with the new value
 | 
  
    | 298 | $sql  = 'SELECT `name`, `value` FROM `'.TABLE_PREFIX.'search` ';
 | 
  
    | 299 | $sql .= 'WHERE `extra` = ""';
 | 
  
    | 300 | $res_search = $database->query($sql);
 | 
  
    | 301 | 
 | 
  
    | 302 | if($database->is_error()) {
 | 
  
    | 303 | 	$admin->print_error($database->is_error(), $js_back );
 | 
  
    | 304 | }
 | 
  
    | 305 | 
 | 
  
    | 306 | while($search_setting = $res_search->fetchRow())
 | 
  
    | 307 | {
 | 
  
    | 308 | 	$old_value = $search_setting['value'];
 | 
  
    | 309 | 	$setting_name = $search_setting['name'];
 | 
  
    | 310 | 	$post_name = 'search_'.$setting_name;
 | 
  
    | 311 | 
 | 
  
    | 312 |     // hold old value if post is empty
 | 
  
    | 313 |     // check search template
 | 
  
    | 314 |     $value = ($admin->get_post($post_name));
 | 
  
    | 315 |     if(in_array($post_name, $StripCodeFromISearch) ) {
 | 
  
    | 316 |         $value = $admin->StripCodeFromText($value);
 | 
  
    | 317 |     }
 | 
  
    | 318 |     $value = ( ($value == '') && ($setting_name != 'template') ) ? $old_value : $value;
 | 
  
    | 319 |     // $value =  ( ($admin->get_post($post_name) == '') && ($setting_name == 'template') ) ? DEFAULT_TEMPLATE : $admin->get_post($post_name);
 | 
  
    | 320 |     if(isset($value))
 | 
  
    | 321 | 	{
 | 
  
    | 322 | 		$value = $admin->add_slashes($value);
 | 
  
    | 323 |         $sql  = 'UPDATE `'.TABLE_PREFIX.'search` ';
 | 
  
    | 324 |         $sql .= 'SET `value` = "'.$value.'" ';
 | 
  
    | 325 |         $sql .= 'WHERE `name` = "'.$setting_name.'" ';
 | 
  
    | 326 |         $sql .= 'AND `extra` = ""';
 | 
  
    | 327 | 		if($database->query($sql)) {
 | 
  
    | 328 | 		}
 | 
  
    | 329 | 		$sql_info = mysql_info($database->db_handle);
 | 
  
    | 330 |     }
 | 
  
    | 331 | }
 | 
  
    | 332 | 
 | 
  
    | 333 | // Check if there was an error updating the db
 | 
  
    | 334 | if($database->is_error()) {
 | 
  
    | 335 | 	$admin->print_error($database->get_error, $js_back );
 | 
  
    | 336 | } else {
 | 
  
    | 337 | 	$admin->print_success($MESSAGE['SETTINGS_SAVED'], $js_back );
 | 
  
    | 338 | }
 | 
  
    | 339 | $admin->print_footer();
 |