Chris@76: <?php
Chris@76: 
Chris@76: /**
Chris@76:  * Simple Machines Forum (SMF)
Chris@76:  *
Chris@76:  * @package SMF
Chris@76:  * @author Simple Machines http://www.simplemachines.org
Chris@76:  * @copyright 2011 Simple Machines
Chris@76:  * @license http://www.simplemachines.org/about/smf/license.php BSD
Chris@76:  *
Chris@76:  * @version 2.0.3
Chris@76:  */
Chris@76: 
Chris@76: if (!defined('SMF'))
Chris@76: 	die('Hacking attempt...');
Chris@76: 
Chris@76: /*	This file contains all the screens that control settings for topics and
Chris@76: 	posts.
Chris@76: 
Chris@76: 	void ManagePaidSubscriptions()
Chris@76: 		- the main entrance point for the 'Paid Subscription' screen.
Chris@76: 		- accessed from ?action=admin;area=paidsubscribe.
Chris@76: 		- calls the right function based on the given sub-action.
Chris@76: 		- defaults to sub-action 'view'.
Chris@76: 		- requires admin_forum permission for admin based actions.
Chris@76: 
Chris@76: 	void ModifySubscriptionSettings()
Chris@76: 		- set any setting related to paid subscriptions.
Chris@76: 		- requires the moderate_forum permission
Chris@76: 		- accessed from ?action=admin;area=paidsubscribe;sa=settings.
Chris@76: 
Chris@76: 	void ViewSubscriptions()
Chris@76: 		- view a list of all the current subscriptions
Chris@76: 		- requires the admin_forum permission
Chris@76: 		- accessed from ?action=admin;area=paidsubscribe;sa=view.
Chris@76: 
Chris@76: 	void ModifySubscription()
Chris@76: 		- edit a subscription.
Chris@76: 		- accessed from ?action=admin;area=paidsubscribe;sa=modify.
Chris@76: 
Chris@76: 	void ViewSubscribedUsers()
Chris@76: 		- view a list of all the users who currently have a subscription.
Chris@76: 		- requires the admin_forum permission.
Chris@76: 		- subscription ID is required, in the form of $_GET['sid'].
Chris@76: 		- accessed from ?action=admin;area=paidsubscribe;sa=viewsub.
Chris@76: 
Chris@76: 	int list_getSubscribedUserCount()
Chris@76: 		// !!
Chris@76: 
Chris@76: 	array list_getSubscribedUsers()
Chris@76: 		// !!
Chris@76: 
Chris@76: 	void ModifyUserSubscription()
Chris@76: 		- edit a users subscription.
Chris@76: 		- accessed from ?action=admin;area=paidsubscribe;sa=modifyuser.
Chris@76: 
Chris@76: 	void reapplySubscriptions(array users)
Chris@76: 		- reapplies all subscription rules for each of the users.
Chris@76: 
Chris@76: 	void addSubscription(int id_subscribe, int id_member)
Chris@76: 		- add/extend a subscription for a member.
Chris@76: 
Chris@76: 	void removeSubscription(int id_subscribe, int id_member)
Chris@76: 		- remove a subscription from a user.
Chris@76: 
Chris@76: 	array loadPaymentGateways()
Chris@76: 		- checks the Sources directory for any files fitting the format of a payment gateway.
Chris@76: 		- loads each file to check it's valid.
Chris@76: 		- includes each file and returns the function name and whether it should work with this version of SMF.
Chris@76: */
Chris@76: 
Chris@76: function ManagePaidSubscriptions()
Chris@76: {
Chris@76: 	global $context, $txt, $scripturl, $sourcedir, $smcFunc, $modSettings;
Chris@76: 
Chris@76: 	// Load the required language and template.
Chris@76: 	loadLanguage('ManagePaid');
Chris@76: 	loadTemplate('ManagePaid');
Chris@76: 
Chris@76: 	$subActions = array(
Chris@76: 		'modify' => array('ModifySubscription', 'admin_forum'),
Chris@76: 		'modifyuser' => array('ModifyUserSubscription', 'admin_forum'),
Chris@76: 		'settings' => array('ModifySubscriptionSettings', 'admin_forum'),
Chris@76: 		'view' => array('ViewSubscriptions', 'admin_forum'),
Chris@76: 		'viewsub' => array('ViewSubscribedUsers', 'admin_forum'),
Chris@76: 	);
Chris@76: 
Chris@76: 	// Default the sub-action to 'view subscriptions', but only if they have already set things up..
Chris@76: 	$_REQUEST['sa'] = isset($_REQUEST['sa']) && isset($subActions[$_REQUEST['sa']]) ? $_REQUEST['sa'] : (!empty($modSettings['paid_currency_symbol']) ? 'view' : 'settings');
Chris@76: 
Chris@76: 	// Make sure you can do this.
Chris@76: 	isAllowedTo($subActions[$_REQUEST['sa']][1]);
Chris@76: 
Chris@76: 	$context['page_title'] = $txt['paid_subscriptions'];
Chris@76: 
Chris@76: 	// Tabs for browsing the different subscription functions.
Chris@76: 	$context[$context['admin_menu_name']]['tab_data'] = array(
Chris@76: 		'title' => $txt['paid_subscriptions'],
Chris@76: 		'help' => '',
Chris@76: 		'description' => $txt['paid_subscriptions_desc'],
Chris@76: 		'tabs' => array(
Chris@76: 			'view' => array(
Chris@76: 				'description' => $txt['paid_subs_view_desc'],
Chris@76: 			),
Chris@76: 			'settings' => array(
Chris@76: 				'description' => $txt['paid_subs_settings_desc'],
Chris@76: 			),
Chris@76: 		),
Chris@76: 	);
Chris@76: 
Chris@76: 	// Call the right function for this sub-acton.
Chris@76: 	$subActions[$_REQUEST['sa']][0]();
Chris@76: }
Chris@76: 
Chris@76: // Modify which payment methods are to be used.
Chris@76: function ModifySubscriptionSettings($return_config = false)
Chris@76: {
Chris@76: 	global $context, $txt, $modSettings, $sourcedir, $smcFunc, $scripturl;
Chris@76: 
Chris@76: 	// If the currency is set to something different then we need to set it to other for this to work and set it back shortly.
Chris@76: 	$modSettings['paid_currency'] = !empty($modSettings['paid_currency_code']) ? $modSettings['paid_currency_code'] : '';
Chris@76: 	if (!empty($modSettings['paid_currency_code']) && !in_array($modSettings['paid_currency_code'], array('usd', 'eur', 'gbp')))
Chris@76: 		$modSettings['paid_currency'] = 'other';
Chris@76: 
Chris@76: 	// These are all the default settings.
Chris@76: 	$config_vars = array(
Chris@76: 			array('select', 'paid_email', array(0 => $txt['paid_email_no'], 1 => $txt['paid_email_error'], 2 => $txt['paid_email_all']), 'subtext' => $txt['paid_email_desc']),
Chris@76: 			array('text', 'paid_email_to', 'subtext' => $txt['paid_email_to_desc'], 'size' => 60),
Chris@76: 		'',
Chris@76: 			'dummy_currency' => array('select', 'paid_currency', array('usd' => $txt['usd'], 'eur' => $txt['eur'], 'gbp' => $txt['gbp'], 'other' => $txt['other']), 'javascript' => 'onchange="toggleOther();"'),
Chris@76: 			array('text', 'paid_currency_code', 'subtext' => $txt['paid_currency_code_desc'], 'size' => 5, 'force_div_id' => 'custom_currency_code_div'),
Chris@76: 			array('text', 'paid_currency_symbol', 'subtext' => $txt['paid_currency_symbol_desc'], 'size' => 8, 'force_div_id' => 'custom_currency_symbol_div'),
Chris@76: 			array('check', 'paidsubs_test', 'subtext' => $txt['paidsubs_test_desc'], 'onclick' => 'return document.getElementById(\'paidsubs_test\').checked ? confirm(\'' . $txt['paidsubs_test_confirm'] . '\') : true;'),
Chris@76: 	);
Chris@76: 
Chris@76: 	// Now load all the other gateway settings.
Chris@76: 	$gateways = loadPaymentGateways();
Chris@76: 	foreach ($gateways as $gateway)
Chris@76: 	{
Chris@76: 		$gatewayClass = new $gateway['display_class']();
Chris@76: 		$setting_data = $gatewayClass->getGatewaySettings();
Chris@76: 		if (!empty($setting_data))
Chris@76: 		{
Chris@76: 			$config_vars[] = array('title', $gatewayClass->title, 'text_label' => (isset($txt['paidsubs_gateway_title_' . $gatewayClass->title]) ? $txt['paidsubs_gateway_title_' . $gatewayClass->title] : $gatewayClass->title));
Chris@76: 			$config_vars = array_merge($config_vars, $setting_data);
Chris@76: 		}
Chris@76: 	}
Chris@76: 
Chris@76: 	// Just searching?
Chris@76: 	if ($return_config)
Chris@76: 		return $config_vars;
Chris@76: 
Chris@76: 	// Get the settings template fired up.
Chris@76: 	require_once($sourcedir . '/ManageServer.php');
Chris@76: 
Chris@76: 	// Some important context stuff
Chris@76: 	$context['page_title'] = $txt['settings'];
Chris@76: 	$context['sub_template'] = 'show_settings';
Chris@76: 	$context['settings_message'] = '<span class="smalltext">' . $txt['paid_note'] . '</span>';
Chris@76: 	$context[$context['admin_menu_name']]['current_subsection'] = 'settings';
Chris@76: 
Chris@76: 	// Get the final touches in place.
Chris@76: 	$context['post_url'] = $scripturl . '?action=admin;area=paidsubscribe;save;sa=settings';
Chris@76: 	$context['settings_title'] = $txt['settings'];
Chris@76: 
Chris@76: 	// We want javascript for our currency options.
Chris@76: 	$context['settings_insert_below'] = '
Chris@76: 		<script type="text/javascript"><!-- // --><![CDATA[
Chris@76: 			function toggleOther()
Chris@76: 			{
Chris@76: 				var otherOn = document.getElementById("paid_currency").value == \'other\';
Chris@76: 				var currencydd = document.getElementById("custom_currency_code_div_dd");
Chris@76: 
Chris@76: 				if (otherOn)
Chris@76: 				{
Chris@76: 					document.getElementById("custom_currency_code_div").style.display = "";
Chris@76: 					document.getElementById("custom_currency_symbol_div").style.display = "";
Chris@76: 
Chris@76: 					if (currencydd)
Chris@76: 					{
Chris@76: 						document.getElementById("custom_currency_code_div_dd").style.display = "";
Chris@76: 						document.getElementById("custom_currency_symbol_div_dd").style.display = "";
Chris@76: 					}
Chris@76: 				}
Chris@76: 				else
Chris@76: 				{
Chris@76: 					document.getElementById("custom_currency_code_div").style.display = "none";
Chris@76: 					document.getElementById("custom_currency_symbol_div").style.display = "none";
Chris@76: 
Chris@76: 					if (currencydd)
Chris@76: 					{
Chris@76: 						document.getElementById("custom_currency_symbol_div_dd").style.display = "none";
Chris@76: 						document.getElementById("custom_currency_code_div_dd").style.display = "none";
Chris@76: 					}
Chris@76: 				}
Chris@76: 			}
Chris@76: 			toggleOther();
Chris@76: 		// ]]></script>';
Chris@76: 
Chris@76: 	// Saving the settings?
Chris@76: 	if (isset($_GET['save']))
Chris@76: 	{
Chris@76: 		checkSession();
Chris@76: 
Chris@76: 		// Sort out the currency stuff.
Chris@76: 		if ($_POST['paid_currency'] != 'other')
Chris@76: 		{
Chris@76: 			$_POST['paid_currency_code'] = $_POST['paid_currency'];
Chris@76: 			$_POST['paid_currency_symbol'] = $txt[$_POST['paid_currency'] . '_symbol'];
Chris@76: 		}
Chris@76: 		unset($config_vars['dummy_currency']);
Chris@76: 
Chris@76: 		saveDBSettings($config_vars);
Chris@76: 
Chris@76: 		redirectexit('action=admin;area=paidsubscribe;sa=settings');
Chris@76: 	}
Chris@76: 
Chris@76: 	// Prepare the settings...
Chris@76: 	prepareDBSettingContext($config_vars);
Chris@76: }
Chris@76: 
Chris@76: // Are we looking at viewing the subscriptions?
Chris@76: function ViewSubscriptions()
Chris@76: {
Chris@76: 	global $context, $txt, $modSettings, $smcFunc, $sourcedir, $scripturl;
Chris@76: 
Chris@76: 	// Not made the settings yet?
Chris@76: 	if (empty($modSettings['paid_currency_symbol']))
Chris@76: 		fatal_lang_error('paid_not_set_currency', false, $scripturl . '?action=admin;area=paidsubscribe;sa=settings');
Chris@76: 
Chris@76: 	// Some basic stuff.
Chris@76: 	$context['page_title'] = $txt['paid_subs_view'];
Chris@76: 	loadSubscriptions();
Chris@76: 
Chris@76: 	$listOptions = array(
Chris@76: 		'id' => 'subscription_list',
Chris@76: 		'items_per_page' => 20,
Chris@76: 		'base_href' => $scripturl . '?action=admin;area=paidsubscribe;sa=view',
Chris@76: 		'get_items' => array(
Chris@76: 			'function' => create_function('', '
Chris@76: 				global $context;
Chris@76: 				return $context[\'subscriptions\'];
Chris@76: 			'),
Chris@76: 		),
Chris@76: 		'get_count' => array(
Chris@76: 			'function' => create_function('', '
Chris@76: 				global $context;
Chris@76: 				return count($context[\'subscriptions\']);
Chris@76: 			'),
Chris@76: 		),
Chris@76: 		'no_items_label' => $txt['paid_none_yet'],
Chris@76: 		'columns' => array(
Chris@76: 			'name' => array(
Chris@76: 				'header' => array(
Chris@76: 					'value' => $txt['paid_name'],
Chris@76: 					'style' => 'text-align: left; width: 35%;',
Chris@76: 				),
Chris@76: 				'data' => array(
Chris@76: 					'function' => create_function('$rowData', '
Chris@76: 						global $scripturl;
Chris@76: 
Chris@76: 						return sprintf(\'<a href="%1$s?action=admin;area=paidsubscribe;sa=viewsub;sid=%2$s">%3$s</a>\', $scripturl, $rowData[\'id\'], $rowData[\'name\']);
Chris@76: 					'),
Chris@76: 				),
Chris@76: 			),
Chris@76: 			'cost' => array(
Chris@76: 				'header' => array(
Chris@76: 					'value' => $txt['paid_cost'],
Chris@76: 					'style' => 'text-align: left;',
Chris@76: 				),
Chris@76: 				'data' => array(
Chris@76: 					'function' => create_function('$rowData', '
Chris@76: 						global $context, $txt;
Chris@76: 
Chris@76: 						return $rowData[\'flexible\'] ? \'<em>\' . $txt[\'flexible\'] . \'</em>\' : $rowData[\'cost\'] . \' / \' . $rowData[\'length\'];
Chris@76: 					'),
Chris@76: 				),
Chris@76: 			),
Chris@76: 			'pending' => array(
Chris@76: 				'header' => array(
Chris@76: 					'value' => $txt['paid_pending'],
Chris@76: 					'style' => 'width: 18%;',
Chris@76: 				),
Chris@76: 				'data' => array(
Chris@76: 					'db_htmlsafe' => 'pending',
Chris@76: 					'style' => 'text-align: center;',
Chris@76: 				),
Chris@76: 			),
Chris@76: 			'finished' => array(
Chris@76: 				'header' => array(
Chris@76: 					'value' => $txt['paid_finished'],
Chris@76: 				),
Chris@76: 				'data' => array(
Chris@76: 					'db_htmlsafe' => 'finished',
Chris@76: 					'style' => 'text-align: center;',
Chris@76: 				),
Chris@76: 			),
Chris@76: 			'total' => array(
Chris@76: 				'header' => array(
Chris@76: 					'value' => $txt['paid_active'],
Chris@76: 				),
Chris@76: 				'data' => array(
Chris@76: 					'db_htmlsafe' => 'total',
Chris@76: 					'style' => 'text-align: center;',
Chris@76: 				),
Chris@76: 			),
Chris@76: 			'is_active' => array(
Chris@76: 				'header' => array(
Chris@76: 					'value' => $txt['paid_is_active'],
Chris@76: 				),
Chris@76: 				'data' => array(
Chris@76: 					'function' => create_function('$rowData', '
Chris@76: 						global $context, $txt;
Chris@76: 
Chris@76: 						return \'<span style="color: \' . ($rowData[\'active\'] ? \'green\' : \'red\') . \'">\' . ($rowData[\'active\'] ? $txt[\'yes\'] : $txt[\'no\']) . \'</span>\';
Chris@76: 					'),
Chris@76: 					'style' => 'text-align: center;',
Chris@76: 				),
Chris@76: 			),
Chris@76: 			'modify' => array(
Chris@76: 				'data' => array(
Chris@76: 					'function' => create_function('$rowData', '
Chris@76: 						global $context, $txt, $scripturl;
Chris@76: 
Chris@76: 						return \'<a href="\' . $scripturl . \'?action=admin;area=paidsubscribe;sa=modify;sid=\' . $rowData[\'id\'] . \'">\' . $txt[\'modify\'] . \'</a>\';
Chris@76: 					'),
Chris@76: 					'style' => 'text-align: center;',
Chris@76: 				),
Chris@76: 			),
Chris@76: 			'delete' => array(
Chris@76: 				'data' => array(
Chris@76: 					'function' => create_function('$rowData', '
Chris@76: 						global $context, $txt, $scripturl;
Chris@76: 
Chris@76: 						return \'<a href="\' . $scripturl . \'?action=admin;area=paidsubscribe;sa=modify;delete;sid=\' . $rowData[\'id\'] . \'">\' . $txt[\'delete\'] . \'</a>\';
Chris@76: 					'),
Chris@76: 					'style' => 'text-align: center;',
Chris@76: 				),
Chris@76: 			),
Chris@76: 		),
Chris@76: 		'form' => array(
Chris@76: 			'href' => $scripturl . '?action=admin;area=paidsubscribe;sa=modify',
Chris@76: 		),
Chris@76: 		'additional_rows' => array(
Chris@76: 			array(
Chris@76: 				'position' => 'below_table_data',
Chris@76: 				'value' => '
Chris@76: 					<input type="submit" name="add" value="' . $txt['paid_add_subscription'] . '" class="button_submit" />
Chris@76: 				',
Chris@76: 				'style' => 'text-align: right;',
Chris@76: 			),
Chris@76: 		),
Chris@76: 	);
Chris@76: 
Chris@76: 	require_once($sourcedir . '/Subs-List.php');
Chris@76: 	createList($listOptions);
Chris@76: 
Chris@76: 	$context['sub_template'] = 'show_list';
Chris@76: 	$context['default_list'] = 'subscription_list';
Chris@76: }
Chris@76: 
Chris@76: // Adding, editing and deleting subscriptions.
Chris@76: function ModifySubscription()
Chris@76: {
Chris@76: 	global $context, $txt, $modSettings, $smcFunc;
Chris@76: 
Chris@76: 	$context['sub_id'] = isset($_REQUEST['sid']) ? (int) $_REQUEST['sid'] : 0;
Chris@76: 	$context['action_type'] = $context['sub_id'] ? (isset($_REQUEST['delete']) ? 'delete' : 'edit') : 'add';
Chris@76: 
Chris@76: 	// Setup the template.
Chris@76: 	$context['sub_template'] = $context['action_type'] == 'delete' ? 'delete_subscription' : 'modify_subscription';
Chris@76: 	$context['page_title'] = $txt['paid_' . $context['action_type'] . '_subscription'];
Chris@76: 
Chris@76: 	// Delete it?
Chris@76: 	if (isset($_POST['delete_confirm']) && isset($_REQUEST['delete']))
Chris@76: 	{
Chris@76: 		checkSession();
Chris@76: 
Chris@76: 		$smcFunc['db_query']('delete_subscription', '
Chris@76: 			DELETE FROM {db_prefix}subscriptions
Chris@76: 			WHERE id_subscribe = {int:current_subscription}',
Chris@76: 			array(
Chris@76: 				'current_subscription' => $context['sub_id'],
Chris@76: 			)
Chris@76: 		);
Chris@76: 
Chris@76: 		redirectexit('action=admin;area=paidsubscribe;view');
Chris@76: 	}
Chris@76: 
Chris@76: 	// Saving?
Chris@76: 	if (isset($_POST['save']))
Chris@76: 	{
Chris@76: 		checkSession();
Chris@76: 
Chris@76: 		// Some cleaning...
Chris@76: 		$isActive = isset($_POST['active']) ? 1 : 0;
Chris@76: 		$isRepeatable = isset($_POST['repeatable']) ? 1 : 0;
Chris@76: 		$allowpartial = isset($_POST['allow_partial']) ? 1 : 0;
Chris@76: 		$reminder = isset($_POST['reminder']) ? (int) $_POST['reminder'] : 0;
Chris@76: 		$emailComplete = strlen($_POST['emailcomplete']) > 10 ? trim($_POST['emailcomplete']) : '';
Chris@76: 
Chris@76: 		// Is this a fixed one?
Chris@76: 		if ($_POST['duration_type'] == 'fixed')
Chris@76: 		{
Chris@76: 			// Clean the span.
Chris@76: 			$span = $_POST['span_value'] . $_POST['span_unit'];
Chris@76: 
Chris@76: 			// Sort out the cost.
Chris@76: 			$cost = array('fixed' => sprintf('%01.2f', strtr($_POST['cost'], ',', '.')));
Chris@76: 
Chris@76: 			// There needs to be something.
Chris@76: 			if (empty($_POST['span_value']) || empty($_POST['cost']))
Chris@76: 				fatal_lang_error('paid_no_cost_value');
Chris@76: 		}
Chris@76: 		// Flexible is harder but more fun ;)
Chris@76: 		else
Chris@76: 		{
Chris@76: 			$span = 'F';
Chris@76: 
Chris@76: 			$cost = array(
Chris@76: 				'day' => sprintf('%01.2f', strtr($_POST['cost_day'], ',', '.')),
Chris@76: 				'week' => sprintf('%01.2f', strtr($_POST['cost_week'], ',', '.')),
Chris@76: 				'month' => sprintf('%01.2f', strtr($_POST['cost_month'], ',', '.')),
Chris@76: 				'year' => sprintf('%01.2f', strtr($_POST['cost_year'], ',', '.')),
Chris@76: 			);
Chris@76: 
Chris@76: 			if (empty($_POST['cost_day']) && empty($_POST['cost_week']) && empty($_POST['cost_month']) && empty($_POST['cost_year']))
Chris@76: 				fatal_lang_error('paid_all_freq_blank');
Chris@76: 		}
Chris@76: 		$cost = serialize($cost);
Chris@76: 
Chris@76: 		// Yep, time to do additional groups.
Chris@76: 		$addgroups = array();
Chris@76: 		if (!empty($_POST['addgroup']))
Chris@76: 			foreach ($_POST['addgroup'] as $id => $dummy)
Chris@76: 				$addgroups[] = (int) $id;
Chris@76: 		$addgroups = implode(',', $addgroups);
Chris@76: 
Chris@76: 		// Is it new?!
Chris@76: 		if ($context['action_type'] == 'add')
Chris@76: 		{
Chris@76: 			$smcFunc['db_insert']('',
Chris@76: 				'{db_prefix}subscriptions',
Chris@76: 				array(
Chris@76: 					'name' => 'string-60', 'description' => 'string-255', 'active' => 'int', 'length' => 'string-4', 'cost' => 'string',
Chris@76: 					'id_group' => 'int', 'add_groups' => 'string-40', 'repeatable' => 'int', 'allow_partial' => 'int', 'email_complete' => 'string',
Chris@76: 					'reminder' => 'int',
Chris@76: 				),
Chris@76: 				array(
Chris@76: 					$_POST['name'], $_POST['desc'], $isActive, $span, $cost,
Chris@76: 					$_POST['prim_group'], $addgroups, $isRepeatable, $allowpartial, $emailComplete,
Chris@76: 					$reminder,
Chris@76: 				),
Chris@76: 				array('id_subscribe')
Chris@76: 			);
Chris@76: 		}
Chris@76: 		// Otherwise must be editing.
Chris@76: 		else
Chris@76: 		{
Chris@76: 			// Don't do groups if there are active members
Chris@76: 			$request = $smcFunc['db_query']('', '
Chris@76: 				SELECT COUNT(*)
Chris@76: 				FROM {db_prefix}log_subscribed
Chris@76: 				WHERE id_subscribe = {int:current_subscription}
Chris@76: 					AND status = {int:is_active}',
Chris@76: 				array(
Chris@76: 					'current_subscription' => $context['sub_id'],
Chris@76: 					'is_active' => 1,
Chris@76: 				)
Chris@76: 			);
Chris@76: 			list ($disableGroups) = $smcFunc['db_fetch_row']($request);
Chris@76: 			$smcFunc['db_free_result']($request);
Chris@76: 
Chris@76: 			$smcFunc['db_query']('substring', '
Chris@76: 				UPDATE {db_prefix}subscriptions
Chris@76: 					SET name = SUBSTRING({string:name}, 1, 60), description = SUBSTRING({string:description}, 1, 255), active = {int:is_active},
Chris@76: 					length = SUBSTRING({string:length}, 1, 4), cost = {string:cost}' . ($disableGroups ? '' : ', id_group = {int:id_group},
Chris@76: 					add_groups = {string:additional_groups}') . ', repeatable = {int:repeatable}, allow_partial = {int:allow_partial},
Chris@76: 					email_complete = {string:email_complete}, reminder = {int:reminder}
Chris@76: 				WHERE id_subscribe = {int:current_subscription}',
Chris@76: 				array(
Chris@76: 					'is_active' => $isActive,
Chris@76: 					'id_group' => !empty($_POST['prim_group']) ? $_POST['prim_group'] : 0,
Chris@76: 					'repeatable' => $isRepeatable,
Chris@76: 					'allow_partial' => $allowpartial,
Chris@76: 					'reminder' => $reminder,
Chris@76: 					'current_subscription' => $context['sub_id'],
Chris@76: 					'name' => $_POST['name'],
Chris@76: 					'description' => $_POST['desc'],
Chris@76: 					'length' => $span,
Chris@76: 					'cost' => $cost,
Chris@76: 					'additional_groups' => !empty($addgroups) ? $addgroups : '',
Chris@76: 					'email_complete' => $emailComplete,
Chris@76: 				)
Chris@76: 			);
Chris@76: 		}
Chris@76: 
Chris@76: 		redirectexit('action=admin;area=paidsubscribe;view');
Chris@76: 	}
Chris@76: 
Chris@76: 	// Defaults.
Chris@76: 	if ($context['action_type'] == 'add')
Chris@76: 	{
Chris@76: 		$context['sub'] = array(
Chris@76: 			'name' => '',
Chris@76: 			'desc' => '',
Chris@76: 			'cost' => array(
Chris@76: 				'fixed' => 0,
Chris@76: 			),
Chris@76: 			'span' => array(
Chris@76: 				'value' => '',
Chris@76: 				'unit' => 'D',
Chris@76: 			),
Chris@76: 			'prim_group' => 0,
Chris@76: 			'add_groups' => array(),
Chris@76: 			'active' => 1,
Chris@76: 			'repeatable' => 1,
Chris@76: 			'allow_partial' => 0,
Chris@76: 			'duration' => 'fixed',
Chris@76: 			'email_complete' => '',
Chris@76: 			'reminder' => 0,
Chris@76: 		);
Chris@76: 	}
Chris@76: 	// Otherwise load up all the details.
Chris@76: 	else
Chris@76: 	{
Chris@76: 		$request = $smcFunc['db_query']('', '
Chris@76: 			SELECT name, description, cost, length, id_group, add_groups, active, repeatable, allow_partial, email_complete, reminder
Chris@76: 			FROM {db_prefix}subscriptions
Chris@76: 			WHERE id_subscribe = {int:current_subscription}
Chris@76: 			LIMIT 1',
Chris@76: 			array(
Chris@76: 				'current_subscription' => $context['sub_id'],
Chris@76: 			)
Chris@76: 		);
Chris@76: 		while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76: 		{
Chris@76: 			// Sort the date.
Chris@76: 			preg_match('~(\d*)(\w)~', $row['length'], $match);
Chris@76: 			if (isset($match[2]))
Chris@76: 			{
Chris@76: 				$span_value = $match[1];
Chris@76: 				$span_unit = $match[2];
Chris@76: 			}
Chris@76: 			else
Chris@76: 			{
Chris@76: 				$span_value = 0;
Chris@76: 				$span_unit = 'D';
Chris@76: 			}
Chris@76: 
Chris@76: 			// Is this a flexible one?
Chris@76: 			if ($row['length'] == 'F')
Chris@76: 				$isFlexible = true;
Chris@76: 			else
Chris@76: 				$isFlexible = false;
Chris@76: 
Chris@76: 			$context['sub'] = array(
Chris@76: 				'name' => $row['name'],
Chris@76: 				'desc' => $row['description'],
Chris@76: 				'cost' => @unserialize($row['cost']),
Chris@76: 				'span' => array(
Chris@76: 					'value' => $span_value,
Chris@76: 					'unit' => $span_unit,
Chris@76: 				),
Chris@76: 				'prim_group' => $row['id_group'],
Chris@76: 				'add_groups' => explode(',', $row['add_groups']),
Chris@76: 				'active' => $row['active'],
Chris@76: 				'repeatable' => $row['repeatable'],
Chris@76: 				'allow_partial' => $row['allow_partial'],
Chris@76: 				'duration' => $isFlexible ? 'flexible' : 'fixed',
Chris@76: 				'email_complete' => htmlspecialchars($row['email_complete']),
Chris@76: 				'reminder' => $row['reminder'],
Chris@76: 			);
Chris@76: 		}
Chris@76: 		$smcFunc['db_free_result']($request);
Chris@76: 
Chris@76: 		// Does this have members who are active?
Chris@76: 		$request = $smcFunc['db_query']('', '
Chris@76: 			SELECT COUNT(*)
Chris@76: 			FROM {db_prefix}log_subscribed
Chris@76: 			WHERE id_subscribe = {int:current_subscription}
Chris@76: 				AND status = {int:is_active}',
Chris@76: 			array(
Chris@76: 				'current_subscription' => $context['sub_id'],
Chris@76: 				'is_active' => 1,
Chris@76: 			)
Chris@76: 		);
Chris@76: 		list ($context['disable_groups']) = $smcFunc['db_fetch_row']($request);
Chris@76: 		$smcFunc['db_free_result']($request);
Chris@76: 	}
Chris@76: 
Chris@76: 	// Load up all the groups.
Chris@76: 	$request = $smcFunc['db_query']('', '
Chris@76: 		SELECT id_group, group_name
Chris@76: 		FROM {db_prefix}membergroups
Chris@76: 		WHERE id_group != {int:moderator_group}
Chris@76: 			AND min_posts = {int:min_posts}',
Chris@76: 		array(
Chris@76: 			'moderator_group' => 3,
Chris@76: 			'min_posts' => -1,
Chris@76: 		)
Chris@76: 	);
Chris@76: 	$context['groups'] = array();
Chris@76: 	while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76: 		$context['groups'][$row['id_group']] = $row['group_name'];
Chris@76: 	$smcFunc['db_free_result']($request);
Chris@76: }
Chris@76: 
Chris@76: // View all the users subscribed to a particular subscription!
Chris@76: function ViewSubscribedUsers()
Chris@76: {
Chris@76: 	global $context, $txt, $modSettings, $scripturl, $options, $smcFunc, $sourcedir;
Chris@76: 
Chris@76: 	// Setup the template.
Chris@76: 	$context['page_title'] = $txt['viewing_users_subscribed'];
Chris@76: 
Chris@76: 	// ID of the subscription.
Chris@76: 	$context['sub_id'] = (int) $_REQUEST['sid'];
Chris@76: 
Chris@76: 	// Load the subscription information.
Chris@76: 	$request = $smcFunc['db_query']('', '
Chris@76: 		SELECT id_subscribe, name, description, cost, length, id_group, add_groups, active
Chris@76: 		FROM {db_prefix}subscriptions
Chris@76: 		WHERE id_subscribe = {int:current_subscription}',
Chris@76: 		array(
Chris@76: 			'current_subscription' => $context['sub_id'],
Chris@76: 		)
Chris@76: 	);
Chris@76: 	// Something wrong?
Chris@76: 	if ($smcFunc['db_num_rows']($request) == 0)
Chris@76: 		fatal_lang_error('no_access', false);
Chris@76: 	// Do the subscription context.
Chris@76: 	$row = $smcFunc['db_fetch_assoc']($request);
Chris@76: 	$context['subscription'] = array(
Chris@76: 		'id' => $row['id_subscribe'],
Chris@76: 		'name' => $row['name'],
Chris@76: 		'desc' => $row['description'],
Chris@76: 		'active' => $row['active'],
Chris@76: 	);
Chris@76: 	$smcFunc['db_free_result']($request);
Chris@76: 
Chris@76: 	// Are we searching for people?
Chris@76: 	$search_string = isset($_POST['ssearch']) && !empty($_POST['sub_search']) ? ' AND IFNULL(mem.real_name, {string:guest}) LIKE {string:search}' : '';
Chris@76: 	$search_vars = empty($_POST['sub_search']) ? array() : array('search' => '%' . $_POST['sub_search'] . '%', 'guest' => $txt['guest']);
Chris@76: 
Chris@76: 	$listOptions = array(
Chris@76: 		'id' => 'subscribed_users_list',
Chris@76: 		'items_per_page' => 20,
Chris@76: 		'base_href' => $scripturl . '?action=admin;area=paidsubscribe;sa=viewsub;sid=' . $context['sub_id'],
Chris@76: 		'default_sort_col' => 'name',
Chris@76: 		'get_items' => array(
Chris@76: 			'function' => 'list_getSubscribedUsers',
Chris@76: 			'params' => array(
Chris@76: 				$context['sub_id'],
Chris@76: 				$search_string,
Chris@76: 				$search_vars,
Chris@76: 			),
Chris@76: 		),
Chris@76: 		'get_count' => array(
Chris@76: 			'function' => 'list_getSubscribedUserCount',
Chris@76: 			'params' => array(
Chris@76: 				$context['sub_id'],
Chris@76: 				$search_string,
Chris@76: 				$search_vars,
Chris@76: 			),
Chris@76: 		),
Chris@76: 		'no_items_label' => $txt['no_subscribers'],
Chris@76: 		'columns' => array(
Chris@76: 			'name' => array(
Chris@76: 				'header' => array(
Chris@76: 					'value' => $txt['who_member'],
Chris@76: 					'style' => 'text-align: left; width: 20%;',
Chris@76: 				),
Chris@76: 				'data' => array(
Chris@76: 					'function' => create_function('$rowData', '
Chris@76: 						global $context, $txt, $scripturl;
Chris@76: 
Chris@76: 						return $rowData[\'id_member\'] == 0 ? $txt[\'guest\'] : \'<a href="\' . $scripturl . \'?action=profile;u=\' . $rowData[\'id_member\'] . \'">\' . $rowData[\'name\'] . \'</a>\';
Chris@76: 					'),
Chris@76: 				),
Chris@76: 				'sort' => array(
Chris@76: 					'default' => 'name',
Chris@76: 					'reverse' => 'name DESC',
Chris@76: 				),
Chris@76: 			),
Chris@76: 			'status' => array(
Chris@76: 				'header' => array(
Chris@76: 					'value' => $txt['paid_status'],
Chris@76: 					'style' => 'text-align: left; width: 10%;',
Chris@76: 				),
Chris@76: 				'data' => array(
Chris@76: 					'db_htmlsafe' => 'status_text',
Chris@76: 				),
Chris@76: 				'sort' => array(
Chris@76: 					'default' => 'status',
Chris@76: 					'reverse' => 'status DESC',
Chris@76: 				),
Chris@76: 			),
Chris@76: 			'payments_pending' => array(
Chris@76: 				'header' => array(
Chris@76: 					'value' => $txt['paid_payments_pending'],
Chris@76: 					'style' => 'text-align: left; width: 10%;',
Chris@76: 				),
Chris@76: 				'data' => array(
Chris@76: 					'db_htmlsafe' => 'pending',
Chris@76: 				),
Chris@76: 				'sort' => array(
Chris@76: 					'default' => 'payments_pending',
Chris@76: 					'reverse' => 'payments_pending DESC',
Chris@76: 				),
Chris@76: 			),
Chris@76: 			'start_time' => array(
Chris@76: 				'header' => array(
Chris@76: 					'value' => $txt['start_date'],
Chris@76: 					'style' => 'text-align: left; width: 20%;',
Chris@76: 				),
Chris@76: 				'data' => array(
Chris@76: 					'db_htmlsafe' => 'start_date',
Chris@76: 					'class' => 'smalltext',
Chris@76: 				),
Chris@76: 				'sort' => array(
Chris@76: 					'default' => 'start_time',
Chris@76: 					'reverse' => 'start_time DESC',
Chris@76: 				),
Chris@76: 			),
Chris@76: 			'end_time' => array(
Chris@76: 				'header' => array(
Chris@76: 					'value' => $txt['end_date'],
Chris@76: 					'style' => 'text-align: left; width: 20%;',
Chris@76: 				),
Chris@76: 				'data' => array(
Chris@76: 					'db_htmlsafe' => 'end_date',
Chris@76: 					'class' => 'smalltext',
Chris@76: 				),
Chris@76: 				'sort' => array(
Chris@76: 					'default' => 'end_time',
Chris@76: 					'reverse' => 'end_time DESC',
Chris@76: 				),
Chris@76: 			),
Chris@76: 			'modify' => array(
Chris@76: 				'header' => array(
Chris@76: 					'style' => 'width: 10%;',
Chris@76: 				),
Chris@76: 				'data' => array(
Chris@76: 					'function' => create_function('$rowData', '
Chris@76: 						global $context, $txt, $scripturl;
Chris@76: 
Chris@76: 						return \'<a href="\' . $scripturl . \'?action=admin;area=paidsubscribe;sa=modifyuser;lid=\' . $rowData[\'id\'] . \'">\' . $txt[\'modify\'] . \'</a>\';
Chris@76: 					'),
Chris@76: 					'style' => 'text-align: center;',
Chris@76: 				),
Chris@76: 			),
Chris@76: 			'delete' => array(
Chris@76: 				'header' => array(
Chris@76: 					'style' => 'width: 4%;',
Chris@76: 				),
Chris@76: 				'data' => array(
Chris@76: 					'function' => create_function('$rowData', '
Chris@76: 						global $context, $txt, $scripturl;
Chris@76: 
Chris@76: 						return \'<input type="checkbox" name="delsub[\' . $rowData[\'id\'] . \']" class="input_check" />\';
Chris@76: 					'),
Chris@76: 					'style' => 'text-align: center;',
Chris@76: 				),
Chris@76: 			),
Chris@76: 		),
Chris@76: 		'form' => array(
Chris@76: 			'href' => $scripturl . '?action=admin;area=paidsubscribe;sa=modifyuser;sid=' . $context['sub_id'],
Chris@76: 		),
Chris@76: 		'additional_rows' => array(
Chris@76: 			array(
Chris@76: 				'position' => 'below_table_data',
Chris@76: 				'value' => '
Chris@76: 					<div class="floatleft">
Chris@76: 						<input type="submit" name="add" value="' . $txt['add_subscriber'] . '" class="button_submit" />
Chris@76: 					</div>
Chris@76: 					<div class="floatright">
Chris@76: 						<input type="submit" name="finished" value="' . $txt['complete_selected'] . '" onclick="return confirm(\'' . $txt['complete_are_sure'] . '\');" class="button_submit" />
Chris@76: 						<input type="submit" name="delete" value="' . $txt['delete_selected'] . '" onclick="return confirm(\'' . $txt['delete_are_sure'] . '\');" class="button_submit" />
Chris@76: 					</div>
Chris@76: 				',
Chris@76: 			),
Chris@76: 			array(
Chris@76: 				'position' => 'top_of_list',
Chris@76: 				'value' => '
Chris@76: 					<div class="title_bar">
Chris@76: 						<h3 class="titlebg">' . sprintf($txt['view_users_subscribed'], $row['name']) . '</h3>
Chris@76: 					</div>
Chris@76: 					<div class="floatright">
Chris@76: 						<input type="text" name="sub_search" value="" class="input_text" />
Chris@76: 						<input type="submit" name="ssearch" value="' . $txt['search_sub'] . '" class="button_submit" />
Chris@76: 					</div>
Chris@76: 				',
Chris@76: 			),
Chris@76: 		),
Chris@76: 	);
Chris@76: 
Chris@76: 	require_once($sourcedir . '/Subs-List.php');
Chris@76: 	createList($listOptions);
Chris@76: 
Chris@76: 	$context['sub_template'] = 'show_list';
Chris@76: 	$context['default_list'] = 'subscribed_users_list';
Chris@76: }
Chris@76: 
Chris@76: // Returns how many people are subscribed to a paid subscription.
Chris@76: function list_getSubscribedUserCount($id_sub, $search_string, $search_vars = array())
Chris@76: {
Chris@76: 	global $smcFunc;
Chris@76: 
Chris@76: 	// Get the total amount of users.
Chris@76: 	$request = $smcFunc['db_query']('', '
Chris@76: 		SELECT COUNT(*) AS total_subs
Chris@76: 		FROM {db_prefix}log_subscribed AS ls
Chris@76: 			LEFT JOIN {db_prefix}members AS mem ON (mem.id_member = ls.id_member)
Chris@76: 		WHERE ls.id_subscribe = {int:current_subscription} ' . $search_string . '
Chris@76: 			AND (ls.end_time != {int:no_end_time} OR ls.payments_pending != {int:no_pending_payments})',
Chris@76: 		array_merge($search_vars, array(
Chris@76: 			'current_subscription' => $id_sub,
Chris@76: 			'no_end_time' => 0,
Chris@76: 			'no_pending_payments' => 0,
Chris@76: 		))
Chris@76: 	);
Chris@76: 	list ($memberCount) = $smcFunc['db_fetch_row']($request);
Chris@76: 	$smcFunc['db_free_result']($request);
Chris@76: 
Chris@76: 	return $memberCount;
Chris@76: }
Chris@76: 
Chris@76: function list_getSubscribedUsers($start, $items_per_page, $sort, $id_sub, $search_string, $search_vars = array())
Chris@76: {
Chris@76: 	global $smcFunc, $txt;
Chris@76: 
Chris@76: 	$request = $smcFunc['db_query']('', '
Chris@76: 		SELECT ls.id_sublog, IFNULL(mem.id_member, 0) AS id_member, IFNULL(mem.real_name, {string:guest}) AS name, ls.start_time, ls.end_time,
Chris@76: 			ls.status, ls.payments_pending
Chris@76: 		FROM {db_prefix}log_subscribed AS ls
Chris@76: 			LEFT JOIN {db_prefix}members AS mem ON (mem.id_member = ls.id_member)
Chris@76: 		WHERE ls.id_subscribe = {int:current_subscription} ' . $search_string . '
Chris@76: 			AND (ls.end_time != {int:no_end_time} OR ls.payments_pending != {int:no_payments_pending})
Chris@76: 		ORDER BY ' . $sort . '
Chris@76: 		LIMIT ' . $start . ', ' . $items_per_page,
Chris@76: 		array_merge($search_vars, array(
Chris@76: 			'current_subscription' => $id_sub,
Chris@76: 			'no_end_time' => 0,
Chris@76: 			'no_payments_pending' => 0,
Chris@76: 			'guest' => $txt['guest'],
Chris@76: 		))
Chris@76: 	);
Chris@76: 	$subscribers = array();
Chris@76: 	while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76: 		$subscribers[] = array(
Chris@76: 			'id' => $row['id_sublog'],
Chris@76: 			'id_member' => $row['id_member'],
Chris@76: 			'name' => $row['name'],
Chris@76: 			'start_date' => timeformat($row['start_time'], false),
Chris@76: 			'end_date' => $row['end_time'] == 0 ? 'N/A' : timeformat($row['end_time'], false),
Chris@76: 			'pending' => $row['payments_pending'],
Chris@76: 			'status' => $row['status'],
Chris@76: 			'status_text' => $row['status'] == 0 ? ($row['payments_pending'] == 0 ? $txt['paid_finished'] : $txt['paid_pending']) : $txt['paid_active'],
Chris@76: 		);
Chris@76: 	$smcFunc['db_free_result']($request);
Chris@76: 
Chris@76: 	return $subscribers;
Chris@76: }
Chris@76: 
Chris@76: // Edit or add a user subscription.
Chris@76: function ModifyUserSubscription()
Chris@76: {
Chris@76: 	global $context, $txt, $modSettings, $smcFunc;
Chris@76: 
Chris@76: 	loadSubscriptions();
Chris@76: 
Chris@76: 	$context['log_id'] = isset($_REQUEST['lid']) ? (int) $_REQUEST['lid'] : 0;
Chris@76: 	$context['sub_id'] = isset($_REQUEST['sid']) ? (int) $_REQUEST['sid'] : 0;
Chris@76: 	$context['action_type'] = $context['log_id'] ? 'edit' : 'add';
Chris@76: 
Chris@76: 	// Setup the template.
Chris@76: 	$context['sub_template'] = 'modify_user_subscription';
Chris@76: 	$context['page_title'] = $txt[$context['action_type'] . '_subscriber'];
Chris@76: 
Chris@76: 	// If we haven't been passed the subscription ID get it.
Chris@76: 	if ($context['log_id'] && !$context['sub_id'])
Chris@76: 	{
Chris@76: 		$request = $smcFunc['db_query']('', '
Chris@76: 			SELECT id_subscribe
Chris@76: 			FROM {db_prefix}log_subscribed
Chris@76: 			WHERE id_sublog = {int:current_log_item}',
Chris@76: 			array(
Chris@76: 				'current_log_item' => $context['log_id'],
Chris@76: 			)
Chris@76: 		);
Chris@76: 		if ($smcFunc['db_num_rows']($request) == 0)
Chris@76: 			fatal_lang_error('no_access', false);
Chris@76: 		list ($context['sub_id']) = $smcFunc['db_fetch_row']($request);
Chris@76: 		$smcFunc['db_free_result']($request);
Chris@76: 	}
Chris@76: 
Chris@76: 	if (!isset($context['subscriptions'][$context['sub_id']]))
Chris@76: 		fatal_lang_error('no_access', false);
Chris@76: 	$context['current_subscription'] = $context['subscriptions'][$context['sub_id']];
Chris@76: 
Chris@76: 	// Searching?
Chris@76: 	if (isset($_POST['ssearch']))
Chris@76: 	{
Chris@76: 		return ViewSubscribedUsers();
Chris@76: 	}
Chris@76: 	// Saving?
Chris@76: 	elseif (isset($_REQUEST['save_sub']))
Chris@76: 	{
Chris@76: 		checkSession();
Chris@76: 
Chris@76: 		// Work out the dates...
Chris@76: 		$starttime = mktime($_POST['hour'], $_POST['minute'], 0, $_POST['month'], $_POST['day'], $_POST['year']);
Chris@76: 		$endtime = mktime($_POST['hourend'], $_POST['minuteend'], 0, $_POST['monthend'], $_POST['dayend'], $_POST['yearend']);
Chris@76: 
Chris@76: 		// Status.
Chris@76: 		$status = $_POST['status'];
Chris@76: 
Chris@76: 		// New one?
Chris@76: 		if (empty($context['log_id']))
Chris@76: 		{
Chris@76: 			// Find the user...
Chris@76: 			$request = $smcFunc['db_query']('', '
Chris@76: 				SELECT id_member, id_group
Chris@76: 				FROM {db_prefix}members
Chris@76: 				WHERE real_name = {string:name}
Chris@76: 				LIMIT 1',
Chris@76: 				array(
Chris@76: 					'name' => $_POST['name'],
Chris@76: 				)
Chris@76: 			);
Chris@76: 			if ($smcFunc['db_num_rows']($request) == 0)
Chris@76: 				fatal_lang_error('error_member_not_found');
Chris@76: 
Chris@76: 			list ($id_member, $id_group) = $smcFunc['db_fetch_row']($request);
Chris@76: 			$smcFunc['db_free_result']($request);
Chris@76: 
Chris@76: 			// Ensure the member doesn't already have a subscription!
Chris@76: 			$request = $smcFunc['db_query']('', '
Chris@76: 				SELECT id_subscribe
Chris@76: 				FROM {db_prefix}log_subscribed
Chris@76: 				WHERE id_subscribe = {int:current_subscription}
Chris@76: 					AND id_member = {int:current_member}',
Chris@76: 				array(
Chris@76: 					'current_subscription' => $context['sub_id'],
Chris@76: 					'current_member' => $id_member,
Chris@76: 				)
Chris@76: 			);
Chris@76: 			if ($smcFunc['db_num_rows']($request) != 0)
Chris@76: 				fatal_lang_error('member_already_subscribed');
Chris@76: 			$smcFunc['db_free_result']($request);
Chris@76: 
Chris@76: 			// Actually put the subscription in place.
Chris@76: 			if ($status == 1)
Chris@76: 				addSubscription($context['sub_id'], $id_member, 0, $starttime, $endtime);
Chris@76: 			else
Chris@76: 			{
Chris@76: 				$smcFunc['db_insert']('',
Chris@76: 					'{db_prefix}log_subscribed',
Chris@76: 					array(
Chris@76: 						'id_subscribe' => 'int', 'id_member' => 'int', 'old_id_group' => 'int', 'start_time' => 'int',
Chris@76: 						'end_time' => 'int', 'status' => 'int',
Chris@76: 					),
Chris@76: 					array(
Chris@76: 						$context['sub_id'], $id_member, $id_group, $starttime,
Chris@76: 						$endtime, $status,
Chris@76: 					),
Chris@76: 					array('id_sublog')
Chris@76: 				);
Chris@76: 			}
Chris@76: 		}
Chris@76: 		// Updating.
Chris@76: 		else
Chris@76: 		{
Chris@76: 			$request = $smcFunc['db_query']('', '
Chris@76: 				SELECT id_member, status
Chris@76: 				FROM {db_prefix}log_subscribed
Chris@76: 				WHERE id_sublog = {int:current_log_item}',
Chris@76: 				array(
Chris@76: 					'current_log_item' => $context['log_id'],
Chris@76: 				)
Chris@76: 			);
Chris@76: 			if ($smcFunc['db_num_rows']($request) == 0)
Chris@76: 				fatal_lang_error('no_access', false);
Chris@76: 
Chris@76: 			list ($id_member, $old_status) = $smcFunc['db_fetch_row']($request);
Chris@76: 			$smcFunc['db_free_result']($request);
Chris@76: 
Chris@76: 			// Pick the right permission stuff depending on what the status is changing from/to.
Chris@76: 			if ($old_status == 1 && $status != 1)
Chris@76: 				removeSubscription($context['sub_id'], $id_member);
Chris@76: 			elseif ($status == 1 && $old_status != 1)
Chris@76: 			{
Chris@76: 				addSubscription($context['sub_id'], $id_member, 0, $starttime, $endtime);
Chris@76: 			}
Chris@76: 			else
Chris@76: 			{
Chris@76: 				$smcFunc['db_query']('', '
Chris@76: 					UPDATE {db_prefix}log_subscribed
Chris@76: 					SET start_time = {int:start_time}, end_time = {int:end_time}, status = {int:status}
Chris@76: 					WHERE id_sublog = {int:current_log_item}',
Chris@76: 					array(
Chris@76: 						'start_time' => $starttime,
Chris@76: 						'end_time' => $endtime,
Chris@76: 						'status' => $status,
Chris@76: 						'current_log_item' => $context['log_id'],
Chris@76: 					)
Chris@76: 				);
Chris@76: 			}
Chris@76: 		}
Chris@76: 
Chris@76: 		// Done - redirect...
Chris@76: 		redirectexit('action=admin;area=paidsubscribe;sa=viewsub;sid=' . $context['sub_id']);
Chris@76: 	}
Chris@76: 	// Deleting?
Chris@76: 	elseif (isset($_REQUEST['delete']) || isset($_REQUEST['finished']))
Chris@76: 	{
Chris@76: 		checkSession();
Chris@76: 
Chris@76: 		// Do the actual deletes!
Chris@76: 		if (!empty($_REQUEST['delsub']))
Chris@76: 		{
Chris@76: 			$toDelete = array();
Chris@76: 			foreach ($_REQUEST['delsub'] as $id => $dummy)
Chris@76: 				$toDelete[] = (int) $id;
Chris@76: 
Chris@76: 			$request = $smcFunc['db_query']('', '
Chris@76: 				SELECT id_subscribe, id_member
Chris@76: 				FROM {db_prefix}log_subscribed
Chris@76: 				WHERE id_sublog IN ({array_int:subscription_list})',
Chris@76: 				array(
Chris@76: 					'subscription_list' => $toDelete,
Chris@76: 				)
Chris@76: 			);
Chris@76: 			while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76: 				removeSubscription($row['id_subscribe'], $row['id_member'], isset($_REQUEST['delete']));
Chris@76: 			$smcFunc['db_free_result']($request);
Chris@76: 		}
Chris@76: 		redirectexit('action=admin;area=paidsubscribe;sa=viewsub;sid=' . $context['sub_id']);
Chris@76: 	}
Chris@76: 
Chris@76: 	// Default attributes.
Chris@76: 	if ($context['action_type'] == 'add')
Chris@76: 	{
Chris@76: 		$context['sub'] = array(
Chris@76: 			'id' => 0,
Chris@76: 			'start' => array(
Chris@76: 				'year' => (int) strftime('%Y', time()),
Chris@76: 				'month' => (int) strftime('%m', time()),
Chris@76: 				'day' => (int) strftime('%d', time()),
Chris@76: 				'hour' => (int) strftime('%H', time()),
Chris@76: 				'min' => (int) strftime('%M', time()) < 10 ? '0' . (int) strftime('%M', time()) : (int) strftime('%M', time()),
Chris@76: 				'last_day' => 0,
Chris@76: 			),
Chris@76: 			'end' => array(
Chris@76: 				'year' => (int) strftime('%Y', time()),
Chris@76: 				'month' => (int) strftime('%m', time()),
Chris@76: 				'day' => (int) strftime('%d', time()),
Chris@76: 				'hour' => (int) strftime('%H', time()),
Chris@76: 				'min' => (int) strftime('%M', time()) < 10 ? '0' . (int) strftime('%M', time()) : (int) strftime('%M', time()),
Chris@76: 				'last_day' => 0,
Chris@76: 			),
Chris@76: 			'status' => 1,
Chris@76: 		);
Chris@76: 		$context['sub']['start']['last_day'] = (int) strftime('%d', mktime(0, 0, 0, $context['sub']['start']['month'] == 12 ? 1 : $context['sub']['start']['month'] + 1, 0, $context['sub']['start']['month'] == 12 ? $context['sub']['start']['year'] + 1 : $context['sub']['start']['year']));
Chris@76: 		$context['sub']['end']['last_day'] = (int) strftime('%d', mktime(0, 0, 0, $context['sub']['end']['month'] == 12 ? 1 : $context['sub']['end']['month'] + 1, 0, $context['sub']['end']['month'] == 12 ? $context['sub']['end']['year'] + 1 : $context['sub']['end']['year']));
Chris@76: 
Chris@76: 		if (isset($_GET['uid']))
Chris@76: 		{
Chris@76: 			$request = $smcFunc['db_query']('', '
Chris@76: 				SELECT real_name
Chris@76: 				FROM {db_prefix}members
Chris@76: 				WHERE id_member = {int:current_member}',
Chris@76: 				array(
Chris@76: 					'current_member' => (int) $_GET['uid'],
Chris@76: 				)
Chris@76: 			);
Chris@76: 			list ($context['sub']['username']) = $smcFunc['db_fetch_row']($request);
Chris@76: 			$smcFunc['db_free_result']($request);
Chris@76: 		}
Chris@76: 		else
Chris@76: 			$context['sub']['username'] = '';
Chris@76: 	}
Chris@76: 	// Otherwise load the existing info.
Chris@76: 	else
Chris@76: 	{
Chris@76: 		$request = $smcFunc['db_query']('', '
Chris@76: 			SELECT ls.id_sublog, ls.id_subscribe, ls.id_member, start_time, end_time, status, payments_pending, pending_details,
Chris@76: 				IFNULL(mem.real_name, {string:blank_string}) AS username
Chris@76: 			FROM {db_prefix}log_subscribed AS ls
Chris@76: 				LEFT JOIN {db_prefix}members AS mem ON (mem.id_member = ls.id_member)
Chris@76: 			WHERE ls.id_sublog = {int:current_subscription_item}
Chris@76: 			LIMIT 1',
Chris@76: 			array(
Chris@76: 				'current_subscription_item' => $context['log_id'],
Chris@76: 				'blank_string' => '',
Chris@76: 			)
Chris@76: 		);
Chris@76: 		if ($smcFunc['db_num_rows']($request) == 0)
Chris@76: 			fatal_lang_error('no_access', false);
Chris@76: 		$row = $smcFunc['db_fetch_assoc']($request);
Chris@76: 		$smcFunc['db_free_result']($request);
Chris@76: 
Chris@76: 		// Any pending payments?
Chris@76: 		$context['pending_payments'] = array();
Chris@76: 		if (!empty($row['pending_details']))
Chris@76: 		{
Chris@76: 			$pending_details = @unserialize($row['pending_details']);
Chris@76: 			foreach ($pending_details as $id => $pending)
Chris@76: 			{
Chris@76: 				// Only this type need be displayed.
Chris@76: 				if ($pending[3] == 'payback')
Chris@76: 				{
Chris@76: 					// Work out what the options were.
Chris@76: 					$costs = @unserialize($context['current_subscription']['real_cost']);
Chris@76: 
Chris@76: 					if ($context['current_subscription']['real_length'] == 'F')
Chris@76: 					{
Chris@76: 						foreach ($costs as $duration => $cost)
Chris@76: 						{
Chris@76: 							if ($cost != 0 && $cost == $pending[1] && $duration == $pending[2])
Chris@76: 								$context['pending_payments'][$id] = array(
Chris@76: 									'desc' => sprintf($modSettings['paid_currency_symbol'], $cost . '/' . $txt[$duration]),
Chris@76: 								);
Chris@76: 						}
Chris@76: 					}
Chris@76: 					elseif ($costs['fixed'] == $pending[1])
Chris@76: 					{
Chris@76: 						$context['pending_payments'][$id] = array(
Chris@76: 							'desc' => sprintf($modSettings['paid_currency_symbol'], $costs['fixed']),
Chris@76: 						);
Chris@76: 					}
Chris@76: 				}
Chris@76: 			}
Chris@76: 
Chris@76: 			// Check if we are adding/removing any.
Chris@76: 			if (isset($_GET['pending']))
Chris@76: 			{
Chris@76: 				foreach ($pending_details as $id => $pending)
Chris@76: 				{
Chris@76: 					// Found the one to action?
Chris@76: 					if ($_GET['pending'] == $id && $pending[3] == 'payback' && isset($context['pending_payments'][$id]))
Chris@76: 					{
Chris@76: 						// Flexible?
Chris@76: 						if (isset($_GET['accept']))
Chris@76: 							addSubscription($context['current_subscription']['id'], $row['id_member'], $context['current_subscription']['real_length'] == 'F' ? strtoupper(substr($pending[2], 0, 1)) : 0);
Chris@76: 						unset($pending_details[$id]);
Chris@76: 
Chris@76: 						$new_details = serialize($pending_details);
Chris@76: 
Chris@76: 						// Update the entry.
Chris@76: 						$smcFunc['db_query']('', '
Chris@76: 							UPDATE {db_prefix}log_subscribed
Chris@76: 							SET payments_pending = payments_pending - 1, pending_details = {string:pending_details}
Chris@76: 							WHERE id_sublog = {int:current_subscription_item}',
Chris@76: 							array(
Chris@76: 								'current_subscription_item' => $context['log_id'],
Chris@76: 								'pending_details' => $new_details,
Chris@76: 							)
Chris@76: 						);
Chris@76: 
Chris@76: 						// Reload
Chris@76: 						redirectexit('action=admin;area=paidsubscribe;sa=modifyuser;lid=' . $context['log_id']);
Chris@76: 					}
Chris@76: 				}
Chris@76: 			}
Chris@76: 		}
Chris@76: 
Chris@76: 		$context['sub_id'] = $row['id_subscribe'];
Chris@76: 		$context['sub'] = array(
Chris@76: 			'id' => 0,
Chris@76: 			'start' => array(
Chris@76: 				'year' => (int) strftime('%Y', $row['start_time']),
Chris@76: 				'month' => (int) strftime('%m', $row['start_time']),
Chris@76: 				'day' => (int) strftime('%d', $row['start_time']),
Chris@76: 				'hour' => (int) strftime('%H', $row['start_time']),
Chris@76: 				'min' => (int) strftime('%M', $row['start_time']) < 10 ? '0' . (int) strftime('%M', $row['start_time']) : (int) strftime('%M', $row['start_time']),
Chris@76: 				'last_day' => 0,
Chris@76: 			),
Chris@76: 			'end' => array(
Chris@76: 				'year' => (int) strftime('%Y', $row['end_time']),
Chris@76: 				'month' => (int) strftime('%m', $row['end_time']),
Chris@76: 				'day' => (int) strftime('%d', $row['end_time']),
Chris@76: 				'hour' => (int) strftime('%H', $row['end_time']),
Chris@76: 				'min' => (int) strftime('%M', $row['end_time']) < 10 ? '0' . (int) strftime('%M', $row['end_time']) : (int) strftime('%M', $row['end_time']),
Chris@76: 				'last_day' => 0,
Chris@76: 			),
Chris@76: 			'status' => $row['status'],
Chris@76: 			'username' => $row['username'],
Chris@76: 		);
Chris@76: 		$context['sub']['start']['last_day'] = (int) strftime('%d', mktime(0, 0, 0, $context['sub']['start']['month'] == 12 ? 1 : $context['sub']['start']['month'] + 1, 0, $context['sub']['start']['month'] == 12 ? $context['sub']['start']['year'] + 1 : $context['sub']['start']['year']));
Chris@76: 		$context['sub']['end']['last_day'] = (int) strftime('%d', mktime(0, 0, 0, $context['sub']['end']['month'] == 12 ? 1 : $context['sub']['end']['month'] + 1, 0, $context['sub']['end']['month'] == 12 ? $context['sub']['end']['year'] + 1 : $context['sub']['end']['year']));
Chris@76: 	}
Chris@76: }
Chris@76: 
Chris@76: // Re-apply subscription rules.
Chris@76: function reapplySubscriptions($users)
Chris@76: {
Chris@76: 	global $smcFunc;
Chris@76: 
Chris@76: 	// Make it an array.
Chris@76: 	if (!is_array($users))
Chris@76: 		$users = array($users);
Chris@76: 
Chris@76: 	// Get all the members current groups.
Chris@76: 	$groups = array();
Chris@76: 	$request = $smcFunc['db_query']('', '
Chris@76: 		SELECT id_member, id_group, additional_groups
Chris@76: 		FROM {db_prefix}members
Chris@76: 		WHERE id_member IN ({array_int:user_list})',
Chris@76: 		array(
Chris@76: 			'user_list' => $users,
Chris@76: 		)
Chris@76: 	);
Chris@76: 	while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76: 	{
Chris@76: 		$groups[$row['id_member']] = array(
Chris@76: 			'primary' => $row['id_group'],
Chris@76: 			'additional' => explode(',', $row['additional_groups']),
Chris@76: 		);
Chris@76: 	}
Chris@76: 	$smcFunc['db_free_result']($request);
Chris@76: 
Chris@76: 	$request = $smcFunc['db_query']('', '
Chris@76: 		SELECT ls.id_member, ls.old_id_group, s.id_group, s.add_groups
Chris@76: 		FROM {db_prefix}log_subscribed AS ls
Chris@76: 			INNER JOIN {db_prefix}subscriptions AS s ON (s.id_subscribe = ls.id_subscribe)
Chris@76: 		WHERE ls.id_member IN ({array_int:user_list})
Chris@76: 			AND ls.end_time > {int:current_time}',
Chris@76: 		array(
Chris@76: 			'user_list' => $users,
Chris@76: 			'current_time' => time(),
Chris@76: 		)
Chris@76: 	);
Chris@76: 	while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76: 	{
Chris@76: 		// Specific primary group?
Chris@76: 		if ($row['id_group'] != 0)
Chris@76: 		{
Chris@76: 			// If this is changing - add the old one to the additional groups so it's not lost.
Chris@76: 			if ($row['id_group'] != $groups[$row['id_member']]['primary'])
Chris@76: 				$groups[$row['id_member']]['additional'][] = $groups[$row['id_member']]['primary'];
Chris@76: 			$groups[$row['id_member']]['primary'] = $row['id_group'];
Chris@76: 		}
Chris@76: 
Chris@76: 		// Additional groups.
Chris@76: 		if (!empty($row['add_groups']))
Chris@76: 			$groups[$row['id_member']]['additional'] = array_merge($groups[$row['id_member']]['additional'], explode(',', $row['add_groups']));
Chris@76: 	}
Chris@76: 	$smcFunc['db_free_result']($request);
Chris@76: 
Chris@76: 	// Update all the members.
Chris@76: 	foreach ($groups as $id => $group)
Chris@76: 	{
Chris@76: 		$group['additional'] = array_unique($group['additional']);
Chris@76: 		foreach ($group['additional'] as $key => $value)
Chris@76: 			if (empty($value))
Chris@76: 				unset($group['additional'][$key]);
Chris@76: 		$addgroups = implode(',', $group['additional']);
Chris@76: 
Chris@76: 		$smcFunc['db_query']('', '
Chris@76: 			UPDATE {db_prefix}members
Chris@76: 			SET id_group = {int:primary_group}, additional_groups = {string:additional_groups}
Chris@76: 			WHERE id_member = {int:current_member}
Chris@76: 			LIMIT 1',
Chris@76: 			array(
Chris@76: 				'primary_group' => $group['primary'],
Chris@76: 				'current_member' => $id,
Chris@76: 				'additional_groups' => $addgroups,
Chris@76: 			)
Chris@76: 		);
Chris@76: 	}
Chris@76: }
Chris@76: 
Chris@76: // Add or extend a subscription of a user.
Chris@76: function addSubscription($id_subscribe, $id_member, $renewal = 0, $forceStartTime = 0, $forceEndTime = 0)
Chris@76: {
Chris@76: 	global $context, $smcFunc;
Chris@76: 
Chris@76: 	// Take the easy way out...
Chris@76: 	loadSubscriptions();
Chris@76: 
Chris@76: 	// Exists, yes?
Chris@76: 	if (!isset($context['subscriptions'][$id_subscribe]))
Chris@76: 		return;
Chris@76: 
Chris@76: 	$curSub = $context['subscriptions'][$id_subscribe];
Chris@76: 
Chris@76: 	// Grab the duration.
Chris@76: 	$duration = $curSub['num_length'];
Chris@76: 
Chris@76: 	// If this is a renewal change the duration to be correct.
Chris@76: 	if (!empty($renewal))
Chris@76: 	{
Chris@76: 		switch ($renewal)
Chris@76: 		{
Chris@76: 			case 'D':
Chris@76: 				$duration = 86400;
Chris@76: 				break;
Chris@76: 			case 'W':
Chris@76: 				$duration = 604800;
Chris@76: 				break;
Chris@76: 			case 'M':
Chris@76: 				$duration = 2629743;
Chris@76: 				break;
Chris@76: 			case 'Y':
Chris@76: 				$duration = 31556926;
Chris@76: 				break;
Chris@76: 			default:
Chris@76: 				break;
Chris@76: 		}
Chris@76: 	}
Chris@76: 
Chris@76: 	// Firstly, see whether it exists, and is active. If so then this is meerly an extension.
Chris@76: 	$request = $smcFunc['db_query']('', '
Chris@76: 		SELECT id_sublog, end_time, start_time
Chris@76: 		FROM {db_prefix}log_subscribed
Chris@76: 		WHERE id_subscribe = {int:current_subscription}
Chris@76: 			AND id_member = {int:current_member}
Chris@76: 			AND status = {int:is_active}',
Chris@76: 		array(
Chris@76: 			'current_subscription' => $id_subscribe,
Chris@76: 			'current_member' => $id_member,
Chris@76: 			'is_active' => 1,
Chris@76: 		)
Chris@76: 	);
Chris@76: 	if ($smcFunc['db_num_rows']($request) != 0)
Chris@76: 	{
Chris@76: 		list ($id_sublog, $endtime, $starttime) = $smcFunc['db_fetch_row']($request);
Chris@76: 
Chris@76: 		// If this has already expired but is active, extension means the period from now.
Chris@76: 		if ($endtime < time())
Chris@76: 			$endtime = time();
Chris@76: 		if ($starttime == 0)
Chris@76: 			$starttime = time();
Chris@76: 
Chris@76: 		// Work out the new expiry date.
Chris@76: 		$endtime += $duration;
Chris@76: 
Chris@76: 		if ($forceEndTime != 0)
Chris@76: 			$endtime = $forceEndTime;
Chris@76: 
Chris@76: 		// As everything else should be good, just update!
Chris@76: 		$smcFunc['db_query']('', '
Chris@76: 			UPDATE {db_prefix}log_subscribed
Chris@76: 			SET end_time = {int:end_time}, start_time = {int:start_time}
Chris@76: 			WHERE id_sublog = {int:current_subscription_item}',
Chris@76: 			array(
Chris@76: 				'end_time' => $endtime,
Chris@76: 				'start_time' => $starttime,
Chris@76: 				'current_subscription_item' => $id_sublog,
Chris@76: 			)
Chris@76: 		);
Chris@76: 
Chris@76: 		return;
Chris@76: 	}
Chris@76: 	$smcFunc['db_free_result']($request);
Chris@76: 
Chris@76: 	// If we're here, that means we don't have an active subscription - that means we need to do some work!
Chris@76: 	$request = $smcFunc['db_query']('', '
Chris@76: 		SELECT m.id_group, m.additional_groups
Chris@76: 		FROM {db_prefix}members AS m
Chris@76: 		WHERE m.id_member = {int:current_member}',
Chris@76: 		array(
Chris@76: 			'current_member' => $id_member,
Chris@76: 		)
Chris@76: 	);
Chris@76: 	// Just in case the member doesn't exist.
Chris@76: 	if ($smcFunc['db_num_rows']($request) == 0)
Chris@76: 		return;
Chris@76: 
Chris@76: 	list ($old_id_group, $additional_groups) = $smcFunc['db_fetch_row']($request);
Chris@76: 	$smcFunc['db_free_result']($request);
Chris@76: 
Chris@76: 	// Prepare additional groups.
Chris@76: 	$newAddGroups = explode(',', $curSub['add_groups']);
Chris@76: 	$curAddGroups = explode(',', $additional_groups);
Chris@76: 
Chris@76: 	$newAddGroups = array_merge($newAddGroups, $curAddGroups);
Chris@76: 
Chris@76: 	// Simple, simple, simple - hopefully... id_group first.
Chris@76: 	if ($curSub['prim_group'] != 0)
Chris@76: 	{
Chris@76: 		$id_group = $curSub['prim_group'];
Chris@76: 
Chris@76: 		// Ensure their old privileges are maintained.
Chris@76: 		if ($old_id_group != 0)
Chris@76: 			$newAddGroups[] = $old_id_group;
Chris@76: 	}
Chris@76: 	else
Chris@76: 		$id_group = $old_id_group;
Chris@76: 
Chris@76: 	// Yep, make sure it's unique, and no empties.
Chris@76: 	foreach ($newAddGroups as $k => $v)
Chris@76: 		if (empty($v))
Chris@76: 			unset($newAddGroups[$k]);
Chris@76: 	$newAddGroups = array_unique($newAddGroups);
Chris@76: 	$newAddGroups = implode(',', $newAddGroups);
Chris@76: 
Chris@76: 	// Store the new settings.
Chris@76: 	$smcFunc['db_query']('', '
Chris@76: 		UPDATE {db_prefix}members
Chris@76: 		SET id_group = {int:primary_group}, additional_groups = {string:additional_groups}
Chris@76: 		WHERE id_member = {int:current_member}',
Chris@76: 		array(
Chris@76: 			'primary_group' => $id_group,
Chris@76: 			'current_member' => $id_member,
Chris@76: 			'additional_groups' => $newAddGroups,
Chris@76: 		)
Chris@76: 	);
Chris@76: 
Chris@76: 	// Now log the subscription - maybe we have a dorment subscription we can restore?
Chris@76: 	$request = $smcFunc['db_query']('', '
Chris@76: 		SELECT id_sublog, end_time, start_time
Chris@76: 		FROM {db_prefix}log_subscribed
Chris@76: 		WHERE id_subscribe = {int:current_subscription}
Chris@76: 			AND id_member = {int:current_member}',
Chris@76: 		array(
Chris@76: 			'current_subscription' => $id_subscribe,
Chris@76: 			'current_member' => $id_member,
Chris@76: 		)
Chris@76: 	);
Chris@76: 	//!!! Don't really need to do this twice...
Chris@76: 	if ($smcFunc['db_num_rows']($request) != 0)
Chris@76: 	{
Chris@76: 		list ($id_sublog, $endtime, $starttime) = $smcFunc['db_fetch_row']($request);
Chris@76: 
Chris@76: 		// If this has already expired but is active, extension means the period from now.
Chris@76: 		if ($endtime < time())
Chris@76: 			$endtime = time();
Chris@76: 		if ($starttime == 0)
Chris@76: 			$starttime = time();
Chris@76: 
Chris@76: 		// Work out the new expiry date.
Chris@76: 		$endtime += $duration;
Chris@76: 
Chris@76: 		if ($forceEndTime != 0)
Chris@76: 			$endtime = $forceEndTime;
Chris@76: 
Chris@76: 		// As everything else should be good, just update!
Chris@76: 		$smcFunc['db_query']('', '
Chris@76: 			UPDATE {db_prefix}log_subscribed
Chris@76: 			SET start_time = {int:start_time}, end_time = {int:end_time}, old_id_group = {int:old_id_group}, status = {int:is_active},
Chris@76: 				reminder_sent = {int:no_reminder_sent}
Chris@76: 			WHERE id_sublog = {int:current_subscription_item}',
Chris@76: 			array(
Chris@76: 				'start_time' => $starttime,
Chris@76: 				'end_time' => $endtime,
Chris@76: 				'old_id_group' => $old_id_group,
Chris@76: 				'is_active' => 1,
Chris@76: 				'no_reminder_sent' => 0,
Chris@76: 				'current_subscription_item' => $id_sublog,
Chris@76: 			)
Chris@76: 		);
Chris@76: 
Chris@76: 		return;
Chris@76: 	}
Chris@76: 	$smcFunc['db_free_result']($request);
Chris@76: 
Chris@76: 	// Otherwise a very simple insert.
Chris@76: 	$endtime = time() + $duration;
Chris@76: 	if ($forceEndTime != 0)
Chris@76: 		$endtime = $forceEndTime;
Chris@76: 
Chris@76: 	if ($forceStartTime == 0)
Chris@76: 		$starttime = time();
Chris@76: 	else
Chris@76: 		$starttime = $forceStartTime;
Chris@76: 
Chris@76: 	$smcFunc['db_insert']('',
Chris@76: 		'{db_prefix}log_subscribed',
Chris@76: 		array(
Chris@76: 			'id_subscribe' => 'int', 'id_member' => 'int', 'old_id_group' => 'int', 'start_time' => 'int',
Chris@76: 			'end_time' => 'int', 'status' => 'int', 'pending_details' => 'string',
Chris@76: 		),
Chris@76: 		array(
Chris@76: 			$id_subscribe, $id_member, $old_id_group, $starttime,
Chris@76: 			$endtime, 1, '',
Chris@76: 		),
Chris@76: 		array('id_sublog')
Chris@76: 	);
Chris@76: }
Chris@76: 
Chris@76: // Removes a subscription from a user, as in removes the groups.
Chris@76: function removeSubscription($id_subscribe, $id_member, $delete = false)
Chris@76: {
Chris@76: 	global $context, $smcFunc;
Chris@76: 
Chris@76: 	loadSubscriptions();
Chris@76: 
Chris@76: 	// Load the user core bits.
Chris@76: 	$request = $smcFunc['db_query']('', '
Chris@76: 		SELECT m.id_group, m.additional_groups
Chris@76: 		FROM {db_prefix}members AS m
Chris@76: 		WHERE m.id_member = {int:current_member}',
Chris@76: 		array(
Chris@76: 			'current_member' => $id_member,
Chris@76: 		)
Chris@76: 	);
Chris@76: 
Chris@76: 	// Just in case of errors.
Chris@76: 	if ($smcFunc['db_num_rows']($request) == 0)
Chris@76: 	{
Chris@76: 		$smcFunc['db_query']('', '
Chris@76: 			DELETE FROM {db_prefix}log_subscribed
Chris@76: 			WHERE id_member = {int:current_member}',
Chris@76: 			array(
Chris@76: 				'current_member' => $id_member,
Chris@76: 			)
Chris@76: 		);
Chris@76: 		return;
Chris@76: 	}
Chris@76: 	list ($id_group, $additional_groups) = $smcFunc['db_fetch_row']($request);
Chris@76: 	$smcFunc['db_free_result']($request);
Chris@76: 
Chris@76: 	// Get all of the subscriptions for this user that are active - it will be necessary!
Chris@76: 	$request = $smcFunc['db_query']('', '
Chris@76: 		SELECT id_subscribe, old_id_group
Chris@76: 		FROM {db_prefix}log_subscribed
Chris@76: 		WHERE id_member = {int:current_member}
Chris@76: 			AND status = {int:is_active}',
Chris@76: 		array(
Chris@76: 			'current_member' => $id_member,
Chris@76: 			'is_active' => 1,
Chris@76: 		)
Chris@76: 	);
Chris@76: 
Chris@76: 	// These variables will be handy, honest ;)
Chris@76: 	$removals = array();
Chris@76: 	$allowed = array();
Chris@76: 	$old_id_group = 0;
Chris@76: 	$new_id_group = -1;
Chris@76: 	while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76: 	{
Chris@76: 		if (!isset($context['subscriptions'][$row['id_subscribe']]))
Chris@76: 			continue;
Chris@76: 
Chris@76: 		// The one we're removing?
Chris@76: 		if ($row['id_subscribe'] == $id_subscribe)
Chris@76: 		{
Chris@76: 			$removals = explode(',', $context['subscriptions'][$row['id_subscribe']]['add_groups']);
Chris@76: 			if ($context['subscriptions'][$row['id_subscribe']]['prim_group'] != 0)
Chris@76: 				$removals[] = $context['subscriptions'][$row['id_subscribe']]['prim_group'];
Chris@76: 			$old_id_group = $row['old_id_group'];
Chris@76: 		}
Chris@76: 		// Otherwise things we allow.
Chris@76: 		else
Chris@76: 		{
Chris@76: 			$allowed = array_merge($allowed, explode(',', $context['subscriptions'][$row['id_subscribe']]['add_groups']));
Chris@76: 			if ($context['subscriptions'][$row['id_subscribe']]['prim_group'] != 0)
Chris@76: 			{
Chris@76: 				$allowed[] = $context['subscriptions'][$row['id_subscribe']]['prim_group'];
Chris@76: 				$new_id_group = $context['subscriptions'][$row['id_subscribe']]['prim_group'];
Chris@76: 			}
Chris@76: 		}
Chris@76: 	}
Chris@76: 	$smcFunc['db_free_result']($request);
Chris@76: 
Chris@76: 	// Now, for everything we are removing check they defintely are not allowed it.
Chris@76: 	$existingGroups = explode(',', $additional_groups);
Chris@76: 	foreach ($existingGroups as $key => $group)
Chris@76: 		if (empty($group) || (in_array($group, $removals) && !in_array($group, $allowed)))
Chris@76: 			unset($existingGroups[$key]);
Chris@76: 
Chris@76: 	// Finally, do something with the current primary group.
Chris@76: 	if (in_array($id_group, $removals))
Chris@76: 	{
Chris@76: 		// If this primary group is actually allowed keep it.
Chris@76: 		if (in_array($id_group, $allowed))
Chris@76: 			$existingGroups[] = $id_group;
Chris@76: 
Chris@76: 		// Either way, change the id_group back.
Chris@76: 		if ($new_id_group < 1)
Chris@76: 		{
Chris@76: 			// If we revert to the old id-group we need to ensure it wasn't from a subscription.
Chris@76: 			foreach ($context['subscriptions'] as $id => $group)
Chris@76: 				// It was? Make them a regular member then!
Chris@76: 				if ($group['prim_group'] == $old_id_group)
Chris@76: 					$old_id_group = 0;
Chris@76: 
Chris@76: 			$id_group = $old_id_group;
Chris@76: 		}
Chris@76: 		else
Chris@76: 			$id_group = $new_id_group;
Chris@76: 	}
Chris@76: 
Chris@76: 	// Crazy stuff, we seem to have our groups fixed, just make them unique
Chris@76: 	$existingGroups = array_unique($existingGroups);
Chris@76: 	$existingGroups = implode(',', $existingGroups);
Chris@76: 
Chris@76: 	// Update the member
Chris@76: 	$smcFunc['db_query']('', '
Chris@76: 		UPDATE {db_prefix}members
Chris@76: 		SET id_group = {int:primary_group}, additional_groups = {string:existing_groups}
Chris@76: 		WHERE id_member = {int:current_member}',
Chris@76: 		array(
Chris@76: 			'primary_group' => $id_group,
Chris@76: 			'current_member' => $id_member,
Chris@76: 			'existing_groups' => $existingGroups,
Chris@76: 		)
Chris@76: 	);
Chris@76: 
Chris@76: 	// Disable the subscription.
Chris@76: 	if (!$delete)
Chris@76: 		$smcFunc['db_query']('', '
Chris@76: 			UPDATE {db_prefix}log_subscribed
Chris@76: 			SET status = {int:not_active}
Chris@76: 			WHERE id_member = {int:current_member}
Chris@76: 				AND id_subscribe = {int:current_subscription}',
Chris@76: 			array(
Chris@76: 				'not_active' => 0,
Chris@76: 				'current_member' => $id_member,
Chris@76: 				'current_subscription' => $id_subscribe,
Chris@76: 			)
Chris@76: 		);
Chris@76: 	// Otherwise delete it!
Chris@76: 	else
Chris@76: 		$smcFunc['db_query']('', '
Chris@76: 			DELETE FROM {db_prefix}log_subscribed
Chris@76: 			WHERE id_member = {int:current_member}
Chris@76: 				AND id_subscribe = {int:current_subscription}',
Chris@76: 			array(
Chris@76: 				'current_member' => $id_member,
Chris@76: 				'current_subscription' => $id_subscribe,
Chris@76: 			)
Chris@76: 		);
Chris@76: }
Chris@76: 
Chris@76: // This just kind of caches all the subscription data.
Chris@76: function loadSubscriptions()
Chris@76: {
Chris@76: 	global $context, $txt, $modSettings, $smcFunc;
Chris@76: 
Chris@76: 	if (!empty($context['subscriptions']))
Chris@76: 		return;
Chris@76: 
Chris@76: 	// Make sure this is loaded, just in case.
Chris@76: 	loadLanguage('ManagePaid');
Chris@76: 
Chris@76: 	$request = $smcFunc['db_query']('', '
Chris@76: 		SELECT id_subscribe, name, description, cost, length, id_group, add_groups, active, repeatable
Chris@76: 		FROM {db_prefix}subscriptions',
Chris@76: 		array(
Chris@76: 		)
Chris@76: 	);
Chris@76: 	$context['subscriptions'] = array();
Chris@76: 	while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76: 	{
Chris@76: 		// Pick a cost.
Chris@76: 		$costs = @unserialize($row['cost']);
Chris@76: 
Chris@76: 		if ($row['length'] != 'F' && !empty($modSettings['paid_currency_symbol']) && !empty($costs['fixed']))
Chris@76: 			$cost = sprintf($modSettings['paid_currency_symbol'], $costs['fixed']);
Chris@76: 		else
Chris@76: 			$cost = '???';
Chris@76: 
Chris@76: 		// Do the span.
Chris@76: 		preg_match('~(\d*)(\w)~', $row['length'], $match);
Chris@76: 		if (isset($match[2]))
Chris@76: 		{
Chris@76: 			$num_length = $match[1];
Chris@76: 			$length = $match[1] . ' ';
Chris@76: 			switch ($match[2])
Chris@76: 			{
Chris@76: 				case 'D':
Chris@76: 					$length .= $txt['paid_mod_span_days'];
Chris@76: 					$num_length *= 86400;
Chris@76: 					break;
Chris@76: 				case 'W':
Chris@76: 					$length .= $txt['paid_mod_span_weeks'];
Chris@76: 					$num_length *= 604800;
Chris@76: 					break;
Chris@76: 				case 'M':
Chris@76: 					$length .= $txt['paid_mod_span_months'];
Chris@76: 					$num_length *= 2629743;
Chris@76: 					break;
Chris@76: 				case 'Y':
Chris@76: 					$length .= $txt['paid_mod_span_years'];
Chris@76: 					$num_length *= 31556926;
Chris@76: 					break;
Chris@76: 			}
Chris@76: 		}
Chris@76: 		else
Chris@76: 			$length = '??';
Chris@76: 
Chris@76: 		$context['subscriptions'][$row['id_subscribe']] = array(
Chris@76: 			'id' => $row['id_subscribe'],
Chris@76: 			'name' => $row['name'],
Chris@76: 			'desc' => $row['description'],
Chris@76: 			'cost' => $cost,
Chris@76: 			'real_cost' => $row['cost'],
Chris@76: 			'length' => $length,
Chris@76: 			'num_length' => $num_length,
Chris@76: 			'real_length' => $row['length'],
Chris@76: 			'pending' => 0,
Chris@76: 			'finished' => 0,
Chris@76: 			'total' => 0,
Chris@76: 			'active' => $row['active'],
Chris@76: 			'prim_group' => $row['id_group'],
Chris@76: 			'add_groups' => $row['add_groups'],
Chris@76: 			'flexible' => $row['length'] == 'F' ? true : false,
Chris@76: 			'repeatable' => $row['repeatable'],
Chris@76: 		);
Chris@76: 	}
Chris@76: 	$smcFunc['db_free_result']($request);
Chris@76: 
Chris@76: 	// Do the counts.
Chris@76: 	$request = $smcFunc['db_query']('', '
Chris@76: 		SELECT COUNT(id_sublog) AS member_count, id_subscribe, status
Chris@76: 		FROM {db_prefix}log_subscribed
Chris@76: 		GROUP BY id_subscribe, status',
Chris@76: 		array(
Chris@76: 		)
Chris@76: 	);
Chris@76: 	while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76: 	{
Chris@76: 		$ind = $row['status'] == 0 ? 'finished' : 'total';
Chris@76: 
Chris@76: 		if (isset($context['subscriptions'][$row['id_subscribe']]))
Chris@76: 			$context['subscriptions'][$row['id_subscribe']][$ind] = $row['member_count'];
Chris@76: 	}
Chris@76: 	$smcFunc['db_free_result']($request);
Chris@76: 
Chris@76: 	// How many payments are we waiting on?
Chris@76: 	$request = $smcFunc['db_query']('', '
Chris@76: 		SELECT SUM(payments_pending) AS total_pending, id_subscribe
Chris@76: 		FROM {db_prefix}log_subscribed
Chris@76: 		GROUP BY id_subscribe',
Chris@76: 		array(
Chris@76: 		)
Chris@76: 	);
Chris@76: 	while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76: 	{
Chris@76: 		if (isset($context['subscriptions'][$row['id_subscribe']]))
Chris@76: 			$context['subscriptions'][$row['id_subscribe']]['pending'] = $row['total_pending'];
Chris@76: 	}
Chris@76: 	$smcFunc['db_free_result']($request);
Chris@76: }
Chris@76: 
Chris@76: // Load all the payment gateways.
Chris@76: function loadPaymentGateways()
Chris@76: {
Chris@76: 	global $sourcedir;
Chris@76: 
Chris@76: 	$gateways = array();
Chris@76: 	if ($dh = opendir($sourcedir))
Chris@76: 	{
Chris@76: 		while (($file = readdir($dh)) !== false)
Chris@76: 		{
Chris@76: 			if (is_file($sourcedir .'/'. $file) && preg_match('~^Subscriptions-([A-Za-z\d]+)\.php$~', $file, $matches))
Chris@76: 			{
Chris@76: 				// Check this is definitely a valid gateway!
Chris@76: 				$fp = fopen($sourcedir . '/' . $file, 'rb');
Chris@76: 				$header = fread($fp, 4096);
Chris@76: 				fclose($fp);
Chris@76: 
Chris@76: 				if (strpos($header, '// SMF Payment Gateway: ' . strtolower($matches[1])) !== false)
Chris@76: 				{
Chris@76: 					loadClassFile($file);
Chris@76: 
Chris@76: 					$gateways[] = array(
Chris@76: 						'filename' => $file,
Chris@76: 						'code' => strtolower($matches[1]),
Chris@76: 						// Don't need anything snazier than this yet.
Chris@76: 						'valid_version' => class_exists(strtolower($matches[1]) . '_payment') && class_exists(strtolower($matches[1]) . '_display'),
Chris@76: 						'payment_class' => strtolower($matches[1]) . '_payment',
Chris@76: 						'display_class' => strtolower($matches[1]) . '_display',
Chris@76: 					);
Chris@76: 				}
Chris@76: 			}
Chris@76: 		}
Chris@76: 	}
Chris@76: 	closedir($dh);
Chris@76: 
Chris@76: 	return $gateways;
Chris@76: }
Chris@76: 
Chris@76: ?>