| 1 | 1348 | Luisehahne | <?php
 | 
      
        | 2 |  |  | /**
 | 
      
        | 3 |  |  |  *
 | 
      
        | 4 |  |  |  * @category        admin
 | 
      
        | 5 |  |  |  * @package         settings
 | 
      
        | 6 |  |  |  * @author          WebsiteBaker Project
 | 
      
        | 7 |  |  |  * @copyright       2004-2009, Ryan Djurovich
 | 
      
        | 8 | 1349 | Luisehahne |  * @copyright       2009-2011, Website Baker Org. e.V.
 | 
      
        | 9 | 1348 | Luisehahne |  * @link			http://www.websitebaker2.org/
 | 
      
        | 10 |  |  |  * @license         http://www.gnu.org/licenses/gpl.html
 | 
      
        | 11 |  |  |  * @platform        WebsiteBaker 2.8.x
 | 
      
        | 12 | 1374 | Luisehahne |  * @requirements    PHP 5.2.2 and higher
 | 
      
        | 13 | 1348 | Luisehahne |  * @version         $Id$
 | 
      
        | 14 |  |  |  * @filesource		$HeadURL$
 | 
      
        | 15 |  |  |  * @lastmodified    $Date$
 | 
      
        | 16 |  |  |  *
 | 
      
        | 17 |  |  |  */
 | 
      
        | 18 |  |  | 
 | 
      
        | 19 |  |  | // prevent this file from being accessed directly in the browser (would set all entries in DB settings table to '')
 | 
      
        | 20 |  |  | if(!isset($_POST['default_language']) || $_POST['default_language'] == '') die(header('Location: index.php'));
 | 
      
        | 21 |  |  | 
 | 
      
        | 22 |  |  | // Find out if the user was view advanced options or not
 | 
      
        | 23 |  |  | $advanced = ($_POST['advanced'] == 'yes') ? '?advanced=yes' : '';
 | 
      
        | 24 |  |  | 
 | 
      
        | 25 |  |  | // Print admin header
 | 
      
        | 26 |  |  | require('../../config.php');
 | 
      
        | 27 |  |  | require_once(WB_PATH.'/framework/class.admin.php');
 | 
      
        | 28 |  |  | 
 | 
      
        | 29 | 1457 | Luisehahne | // suppress to print the header, so no new FTAN will be set
 | 
      
        | 30 | 1348 | Luisehahne | if($advanced == '')
 | 
      
        | 31 |  |  | {
 | 
      
        | 32 | 1457 | Luisehahne | 	$admin = new admin('Settings', 'settings_basic',false);
 | 
      
        | 33 | 1348 | Luisehahne | } else {
 | 
      
        | 34 | 1457 | Luisehahne | 	$admin = new admin('Settings', 'settings_advanced',false);
 | 
      
        | 35 | 1348 | Luisehahne | }
 | 
      
        | 36 |  |  | 
 | 
      
        | 37 | 1425 | Luisehahne | // Create a javascript back link
 | 
      
        | 38 |  |  | $js_back = ADMIN_URL.'/settings/index.php'.$advanced;
 | 
      
        | 39 | 1355 | FrankH | if( !$admin->checkFTAN() )
 | 
      
        | 40 |  |  | {
 | 
      
        | 41 | 1457 | Luisehahne | 	$admin->print_header();
 | 
      
        | 42 | 1425 | Luisehahne | 	$admin->print_error($MESSAGE['GENERIC_SECURITY_ACCESS'],$js_back );
 | 
      
        | 43 | 1355 | FrankH | }
 | 
      
        | 44 | 1457 | Luisehahne | // After check print the header
 | 
      
        | 45 |  |  | $admin->print_header();
 | 
      
        | 46 | 1355 | FrankH | 
 | 
      
        | 47 | 1348 | Luisehahne | // 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 |  |  |     {
 | 
      
        | 55 |  |  | 		$admin->print_error($MESSAGE['USERS']['INVALID_EMAIL'].
 | 
      
        | 56 |  |  | 			'<br /><strong>Email: '.htmlentities($_POST['server_email']).'</strong>', $js_back);
 | 
      
        | 57 |  |  | 	}
 | 
      
        | 58 |  |  | }
 | 
      
        | 59 |  |  | 
 | 
      
        | 60 |  |  | // Work-out file mode
 | 
      
        | 61 |  |  | if($advanced == '')
 | 
      
        | 62 |  |  | {
 | 
      
        | 63 |  |  | 	// Check if should be set to 777 or left alone
 | 
      
        | 64 |  |  | 	if(isset($_POST['world_writeable']) && $_POST['world_writeable'] == 'true')
 | 
      
        | 65 |  |  |     {
 | 
      
        | 66 |  |  | 		$file_mode = '0777';
 | 
      
        | 67 |  |  | 		$dir_mode = '0777';
 | 
      
        | 68 |  |  | 	} else {
 | 
      
        | 69 |  |  | 		$file_mode = STRING_FILE_MODE;
 | 
      
        | 70 |  |  | 		$dir_mode = STRING_DIR_MODE;
 | 
      
        | 71 |  |  | 	}
 | 
      
        | 72 |  |  | } else {
 | 
      
        | 73 |  |  | 	// Work-out the octal value for file mode
 | 
      
        | 74 |  |  | 	$u = 0;
 | 
      
        | 75 |  |  | 	if(isset($_POST['file_u_r']) && $_POST['file_u_r'] == 'true') {
 | 
      
        | 76 |  |  | 		$u = $u+4;
 | 
      
        | 77 |  |  | 	}
 | 
      
        | 78 |  |  | 	if(isset($_POST['file_u_w']) && $_POST['file_u_w'] == 'true') {
 | 
      
        | 79 |  |  | 		$u = $u+2;
 | 
      
        | 80 |  |  | 	}
 | 
      
        | 81 |  |  | 	if(isset($_POST['file_u_e']) && $_POST['file_u_e'] == 'true') {
 | 
      
        | 82 |  |  | 		$u = $u+1;
 | 
      
        | 83 |  |  | 	}
 | 
      
        | 84 |  |  | 	$g = 0;
 | 
      
        | 85 |  |  | 	if(isset($_POST['file_g_r']) && $_POST['file_g_r'] == 'true') {
 | 
      
        | 86 |  |  | 		$g = $g+4;
 | 
      
        | 87 |  |  | 	}
 | 
      
        | 88 |  |  | 	if(isset($_POST['file_g_w']) && $_POST['file_g_w'] == 'true') {
 | 
      
        | 89 |  |  | 		$g = $g+2;
 | 
      
        | 90 |  |  | 	}
 | 
      
        | 91 |  |  | 	if(isset($_POST['file_g_e']) && $_POST['file_g_e'] == 'true') {
 | 
      
        | 92 |  |  | 		$g = $g+1;
 | 
      
        | 93 |  |  | 	}
 | 
      
        | 94 |  |  | 	$o = 0;
 | 
      
        | 95 |  |  | 	if(isset($_POST['file_o_r']) && $_POST['file_o_r'] == 'true') {
 | 
      
        | 96 |  |  | 		$o = $o+4;
 | 
      
        | 97 |  |  | 	}
 | 
      
        | 98 |  |  | 	if(isset($_POST['file_o_w']) && $_POST['file_o_w'] == 'true') {
 | 
      
        | 99 |  |  | 		$o = $o+2;
 | 
      
        | 100 |  |  | 	}
 | 
      
        | 101 |  |  | 	if(isset($_POST['file_o_e']) && $_POST['file_o_e'] == 'true') {
 | 
      
        | 102 |  |  | 		$o = $o+1;
 | 
      
        | 103 |  |  | 	}
 | 
      
        | 104 |  |  | 	$file_mode = "0".$u.$g.$o;
 | 
      
        | 105 |  |  | 	// Work-out the octal value for dir mode
 | 
      
        | 106 |  |  | 	$u = 0;
 | 
      
        | 107 |  |  | 	if(isset($_POST['dir_u_r']) && $_POST['dir_u_r'] == 'true') {
 | 
      
        | 108 |  |  | 		$u = $u+4;
 | 
      
        | 109 |  |  | 	}
 | 
      
        | 110 |  |  | 	if(isset($_POST['dir_u_w']) && $_POST['dir_u_w'] == 'true') {
 | 
      
        | 111 |  |  | 		$u = $u+2;
 | 
      
        | 112 |  |  | 	}
 | 
      
        | 113 |  |  | 	if(isset($_POST['dir_u_e']) && $_POST['dir_u_e'] == 'true') {
 | 
      
        | 114 |  |  | 		$u = $u+1;
 | 
      
        | 115 |  |  | 	}
 | 
      
        | 116 |  |  | 	$g = 0;
 | 
      
        | 117 |  |  | 	if(isset($_POST['dir_g_r']) && $_POST['dir_g_r'] == 'true') {
 | 
      
        | 118 |  |  | 		$g = $g+4;
 | 
      
        | 119 |  |  | 	}
 | 
      
        | 120 |  |  | 	if(isset($_POST['dir_g_w']) && $_POST['dir_g_w'] == 'true') {
 | 
      
        | 121 |  |  | 		$g = $g+2;
 | 
      
        | 122 |  |  | 	}
 | 
      
        | 123 |  |  | 	if(isset($_POST['dir_g_e']) && $_POST['dir_g_e'] == 'true') {
 | 
      
        | 124 |  |  | 		$g = $g+1;
 | 
      
        | 125 |  |  | 	}
 | 
      
        | 126 |  |  | 	$o = 0;
 | 
      
        | 127 |  |  | 	if(isset($_POST['dir_o_r']) && $_POST['dir_o_r'] == 'true') {
 | 
      
        | 128 |  |  | 		$o = $o+4;
 | 
      
        | 129 |  |  | 	}
 | 
      
        | 130 |  |  | 	if(isset($_POST['dir_o_w']) && $_POST['dir_o_w'] == 'true') {
 | 
      
        | 131 |  |  | 		$o = $o+2;
 | 
      
        | 132 |  |  | 	}
 | 
      
        | 133 |  |  | 	if(isset($_POST['dir_o_e']) && $_POST['dir_o_e'] == 'true') {
 | 
      
        | 134 |  |  | 		$o = $o+1;
 | 
      
        | 135 |  |  | 	}
 | 
      
        | 136 |  |  | 	$dir_mode = "0".$u.$g.$o;
 | 
      
        | 137 |  |  | }
 | 
      
        | 138 |  |  | 
 | 
      
        | 139 | 1354 | Luisehahne | $allow_tags_in_fields = array('website_header', 'website_footer');
 | 
      
        | 140 |  |  | $allow_empty_values = array('website_header','website_footer','sec_anchor','pages_directory','page_spacer');
 | 
      
        | 141 |  |  | $disallow_in_fields = array('pages_directory', 'media_directory','wb_version');
 | 
      
        | 142 | 1348 | Luisehahne | // Create new database object
 | 
      
        | 143 |  |  | /*$database = new database(); */
 | 
      
        | 144 |  |  | 
 | 
      
        | 145 |  |  | // Query current settings in the db, then loop through them and update the db with the new value
 | 
      
        | 146 | 1354 | Luisehahne | $settings = array();
 | 
      
        | 147 |  |  | $old_settings = array();
 | 
      
        | 148 |  |  | // Query current settings in the db, then loop through them to get old values
 | 
      
        | 149 |  |  | $sql = 'SELECT `name`, `value` FROM `'.TABLE_PREFIX.'settings`';
 | 
      
        | 150 |  |  | $sql .= 'ORDER BY `name`';
 | 
      
        | 151 |  |  | 
 | 
      
        | 152 |  |  | $res_settings = $database->query($sql);
 | 
      
        | 153 | 1430 | Luisehahne | $passed = false;
 | 
      
        | 154 | 1354 | Luisehahne | while($setting = $res_settings->fetchRow())
 | 
      
        | 155 | 1348 | Luisehahne | {
 | 
      
        | 156 | 1354 | Luisehahne | 	$old_settings[$setting['name']] = $setting['value'];
 | 
      
        | 157 | 1348 | Luisehahne | 	$setting_name = $setting['name'];
 | 
      
        | 158 |  |  | 	$value = $admin->get_post($setting_name);
 | 
      
        | 159 | 1356 | Luisehahne | 	$value = isset($_POST[$setting_name]) ? $value : $old_settings[$setting_name] ;
 | 
      
        | 160 | 1354 | Luisehahne | 	switch ($setting_name) {
 | 
      
        | 161 |  |  | 		case 'default_timezone':
 | 
      
        | 162 |  |  | 			$value=$value*60*60;
 | 
      
        | 163 | 1430 | Luisehahne | 			$passed = true;
 | 
      
        | 164 | 1354 | Luisehahne | 			break;
 | 
      
        | 165 |  |  | 		case 'string_dir_mode':
 | 
      
        | 166 |  |  | 			$value=$dir_mode;
 | 
      
        | 167 | 1430 | Luisehahne | 			$passed = true;
 | 
      
        | 168 | 1354 | Luisehahne | 			break;
 | 
      
        | 169 |  |  | 		case 'string_file_mode':
 | 
      
        | 170 |  |  | 			$value=$file_mode;
 | 
      
        | 171 | 1430 | Luisehahne |  			$passed = true;
 | 
      
        | 172 |  |  | 		break;
 | 
      
        | 173 | 1354 | Luisehahne | 		case 'pages_directory':
 | 
      
        | 174 |  |  | 			break;
 | 
      
        | 175 |  |  | 		default :
 | 
      
        | 176 | 1430 | Luisehahne | 		    $passed = in_array($setting_name, $allow_empty_values);
 | 
      
        | 177 | 1354 | Luisehahne | 			break;
 | 
      
        | 178 |  |  | 	}
 | 
      
        | 179 |  |  |     if (!in_array($setting_name, $allow_tags_in_fields))
 | 
      
        | 180 | 1348 | Luisehahne |     {
 | 
      
        | 181 | 1354 | Luisehahne |         $value = strip_tags($value);
 | 
      
        | 182 |  |  |     }
 | 
      
        | 183 | 1348 | Luisehahne | 
 | 
      
        | 184 |  |  | 
 | 
      
        | 185 | 1356 | Luisehahne |     if ( !in_array($value, $disallow_in_fields) && (isset($_POST[$setting_name]) || $passed == true) )
 | 
      
        | 186 | 1354 | Luisehahne |     {
 | 
      
        | 187 |  |  |         $value = trim($admin->add_slashes($value));
 | 
      
        | 188 |  |  |         $sql = 'UPDATE `'.TABLE_PREFIX.'settings` ';
 | 
      
        | 189 |  |  |         $sql .= 'SET `value` = \''.$value.'\' ';
 | 
      
        | 190 |  |  |         $sql .= 'WHERE `name` <> \'wb_version\' ';
 | 
      
        | 191 |  |  |         $sql .= 'AND `name` = \''.$setting_name.'\' ';
 | 
      
        | 192 |  |  | 
 | 
      
        | 193 | 1356 | Luisehahne |         if (!$database->query($sql))
 | 
      
        | 194 | 1354 | Luisehahne |         {
 | 
      
        | 195 | 1356 | Luisehahne | 			if($database->is_error()) {
 | 
      
        | 196 | 1425 | Luisehahne | 				$admin->print_error($database->get_error, $js_back );
 | 
      
        | 197 | 1356 | Luisehahne | 			}
 | 
      
        | 198 | 1354 | Luisehahne |         }
 | 
      
        | 199 | 1348 | Luisehahne | 	}
 | 
      
        | 200 |  |  | }
 | 
      
        | 201 |  |  | 
 | 
      
        | 202 |  |  | // Query current search settings in the db, then loop through them and update the db with the new value
 | 
      
        | 203 |  |  | $sql  = 'SELECT `name`, `value` FROM `'.TABLE_PREFIX.'search` ';
 | 
      
        | 204 |  |  | $sql .= 'WHERE `extra` = ""';
 | 
      
        | 205 |  |  | $res_search = $database->query($sql);
 | 
      
        | 206 |  |  | 
 | 
      
        | 207 |  |  | if($database->is_error()) {
 | 
      
        | 208 | 1425 | Luisehahne | 	$admin->print_error($database->is_error(), $js_back );
 | 
      
        | 209 | 1348 | Luisehahne | }
 | 
      
        | 210 |  |  | 
 | 
      
        | 211 |  |  | while($search_setting = $res_search->fetchRow())
 | 
      
        | 212 |  |  | {
 | 
      
        | 213 |  |  | 	$old_value = $search_setting['value'];
 | 
      
        | 214 |  |  | 	$setting_name = $search_setting['name'];
 | 
      
        | 215 |  |  | 	$post_name = 'search_'.$search_setting['name'];
 | 
      
        | 216 |  |  | 
 | 
      
        | 217 |  |  |     // hold old value if post is empty
 | 
      
        | 218 |  |  |     // check search template
 | 
      
        | 219 |  |  |     $value = ( ($admin->get_post($post_name) == '') && ($setting_name != 'template') ) ? $old_value : $admin->get_post($post_name);
 | 
      
        | 220 |  |  |     // $value =  ( ($admin->get_post($post_name) == '') && ($setting_name == 'template') ) ? DEFAULT_TEMPLATE : $admin->get_post($post_name);
 | 
      
        | 221 |  |  |     if(isset($value))
 | 
      
        | 222 |  |  | 	{
 | 
      
        | 223 |  |  | 		$value = $admin->add_slashes($value);
 | 
      
        | 224 |  |  |         $sql  = 'UPDATE `'.TABLE_PREFIX.'search` ';
 | 
      
        | 225 |  |  |         $sql .= 'SET `value` = "'.$value.'" ';
 | 
      
        | 226 |  |  |         $sql .= 'WHERE `name` = "'.$setting_name.'" ';
 | 
      
        | 227 |  |  |         $sql .= 'AND `extra` = ""';
 | 
      
        | 228 |  |  | 		if($database->query($sql)) {
 | 
      
        | 229 |  |  | 		}
 | 
      
        | 230 |  |  | 		$sql_info = mysql_info($database->db_handle);
 | 
      
        | 231 |  |  |     }
 | 
      
        | 232 |  |  | }
 | 
      
        | 233 |  |  | 
 | 
      
        | 234 |  |  | // Check if there was an error updating the db
 | 
      
        | 235 |  |  | if($database->is_error()) {
 | 
      
        | 236 | 1425 | Luisehahne | 	$admin->print_error($database->get_error, $js_back );
 | 
      
        | 237 | 1348 | Luisehahne | } else {
 | 
      
        | 238 | 1425 | Luisehahne | 	$admin->print_success($MESSAGE['SETTINGS']['SAVED'], $js_back );
 | 
      
        | 239 | 1348 | Luisehahne | }
 | 
      
        | 240 |  |  | $admin->print_footer();
 | 
      
        | 241 |  |  | 
 | 
      
        | 242 | 1241 | Luisehahne | ?>
 |