ModifyPolicySettings()

Complexity

Conditions	13
Paths	96

Size

Total Lines	201
Code Lines	95

Duplication

Lines	0
Ratio	0 %

Importance

Changes	6
Bugs	0	Features	0

<?php
function ModifyPolicySettings($return_config = false)
{
	global $txt, $scripturl, $context, $sourcedir, $modSettings, $smcFunc;
	
	// Needed for the WYSIWYG editor.
	require_once($sourcedir . '/Subs-Editor.php');
	$context['sub_template'] = 'edit_policy';
	$context['page_title'] = $txt['policy_management'];

	$config_vars = array(
		array('check', 'enable_policy_function'),
		array('text', 'policy_text'),
	);
	
	$currentVersion = !empty($modSettings['policy_version']) ? substr($modSettings['policy_version'], 11) : 0;

	// Now create the editor.
	$editorOptions = array(
		'id' => 'policy_text',
		'value' => !empty($modSettings['policy_text' . $currentVersion]) ? $modSettings['policy_text' . $currentVersion] : '',
		'height' => '250px',
		'width' => '100%',
		'labels' => array(
			'post_button' => $txt['policy_save'],
		),
		'preview_type' => 2,
		'required' => true,
	);
	create_control_richedit($editorOptions);
	// Store the ID for old compatibility.
	$context['post_box_name'] = $editorOptions['id'];
	
	call_integration_hook('integrate_policy_settings', array(&$config_vars));
	
	$request = $smcFunc['db_query']('', '
		SELECT count( case when th.value is null then 1 end) novalid,
			count( case when th.value is not null and th.value != {string:policy_version} then 1 end) outdated,
			count( case when th.value = {string:policy_version} then 1 end) fresh
		FROM {db_prefix}members mem
		LEFT JOIN {db_prefix}themes th ON (mem.id_member = th.id_member AND th.id_theme = 1 AND th.variable = {string:policy_approved})',
		array(
			'policy_version' => 'policy_text' . $currentVersion,
			'policy_approved' => 'policy_approved',
		)
	);
	
	list ($context['policy']['invalid'], $context['policy']['outdated'], $context['policy']['fresh']) = $smcFunc['db_fetch_row']($request);
	$smcFunc['db_free_result']($request);
	
	$request = $smcFunc['db_query']('', '
		SELECT a.variable, count(b.value) amount
		FROM {db_prefix}settings a
		LEFT JOIN {db_prefix}themes b ON (a.variable = b.value and b.variable = {string:policy_approved})
		WHERE a.variable like {string:avar}
		GROUP BY a.variable
		ORDER BY a.variable desc',
		array(
			'policy_approved' => 'policy_approved',
			'avar' => 'policy_text%',
		)
	);
	
	$context['poc']['policy_management'] = array();
	while ($row = $smcFunc['db_fetch_assoc']($request))
	{
		$context['poc']['policy_management'][] = array(
			'name' => $row['variable'],
			'amount' => $row['amount'],
			'new' => ($row['variable'] == 'policy_text' . $currentVersion ? true : false),
		);
	}
	$smcFunc['db_free_result']($request);
	if ($return_config)
		return $config_vars;

	// Saving?
	if (isset($_GET['save']))
	{
		checkSession();

		call_integration_hook('integrate_save_policy_settings');

		if (!empty($_REQUEST['enforce_new']))
		{
		$select = '
			UPDATE {db_prefix}themes
			SET value = {string:value}
			WHERE EXISTS (
				SELECT a.id_member
				FROM {db_prefix}themes a
				LEFT JOIN {db_prefix}themes b ON (a.id_member = b.id_member and b.variable = {string:bvar})
				WHERE a.variable = {string:avar} and a.value = {string:aval} 
					AND ( b.value != {string:bval}  or b.value is null)
					AND a.id_member = {db_prefix}themes.id_member
			)
			AND variable = {string:avar}';
			
			$smcFunc['db_query']('managePrivacyNew',
				$select,
				array(
					'value' => '0',
					'bvar' => 'policy_approved',
					'avar' => 'policy_isvalid',
					'aval' => '1',
					'bval' => 'policy_text' . $currentVersion,
				)
			);
		}
		elseif (!empty($_REQUEST['save_setting']))
		{
			unset($config_vars[1]);
			saveDBSettings($config_vars);
		}
		elseif (!empty($_REQUEST['save_new_policy']) || !empty($_REQUEST['update_policy']))
		{
			if (!empty($_REQUEST['save_new_policy']))
				$currentVersion++;
			
			$config_vars[] = array('text', 'policy_text'.$currentVersion);
			$_POST['policy_text'.$currentVersion] = $_REQUEST['policy_text'];
			$config_vars[] = array('text', 'policy_version');
			$_POST['policy_version'] = 'policy_text'.$currentVersion;
			unset($config_vars[1]);
			saveDBSettings($config_vars);
		}

		$_SESSION['adm-save'] = true;
		redirectexit('action=admin;area=featuresettings;sa=policy');
	}
	elseif (isset($_GET['manage']))
	{
		checkSession();
		
		call_integration_hook('integrate_manage_policy_settings');
		
		// set user with the policy invalid
		$select = '
			UPDATE {db_prefix}themes
			SET value = {string:value}
			WHERE EXISTS (
				SELECT a.id_member
				FROM {db_prefix}themes a
				LEFT JOIN {db_prefix}themes b ON (a.id_member = b.id_member and b.variable = {string:bvar})
				WHERE a.variable = {string:avar} and a.value = {string:aval} 
					AND b.value = {string:bval}
					AND a.id_member = {db_prefix}themes.id_member
			)
			AND variable = {string:avar}';

		$smcFunc['db_query']('managePrivacyInvalid',
				$select,
			array(
				'value' => '0',
				'bvar' => 'policy_approved',
				'avar' => 'policy_isvalid',
				'aval' => '1',
				'bval' => $_REQUEST['delete_policy'],
			)
		);
		
		// empty users
		$select = '
			UPDATE {db_prefix}themes
			SET value = {string:value}
			WHERE EXISTS (
				SELECT a.id_member
				FROM {db_prefix}themes a
				LEFT JOIN {db_prefix}themes b ON (a.id_member = b.id_member and b.variable = {string:bvar})
				WHERE a.variable = {string:avar} and a.value = {string:aval} 
					AND b.value = {string:bval}
					AND a.id_member = {db_prefix}themes.id_member
			)
			and variable = {string:bvar}';
		$smcFunc['db_query']('managePrivacyEmptyusers',
			$select,
			array(
				'value' => '',
				'bvar' => 'policy_approved',
				'avar' => 'policy_isvalid',
				'aval' => '0',
				'bval' => $_REQUEST['delete_policy'],
			)
		);
		
		$smcFunc['db_query']('','
			DELETE FROM {db_prefix}settings
			WHERE variable = {string:policy_text}',
			array(
				'policy_text' => $_REQUEST['delete_policy'],
			)
		);
		
		
		$_SESSION['adm-save'] = true;
		redirectexit('action=admin;area=featuresettings;sa=policy');
	}

	$context['post_url'] = $scripturl . '?action=admin;area=featuresettings;save;sa=policy';
	$context['settings_title'] = $txt['privacy'];

	prepareDBSettingContext($config_vars);
}
?>