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
Chris@76:  */
Chris@76: 
Chris@76: if (!defined('SMF'))
Chris@76: 	die('Hacking attempt...');
Chris@76: 
Chris@76: /* /!!!
Chris@76: 
Chris@76: 	void ManageScheduledTasks()
Chris@76: 		// !!!
Chris@76: 
Chris@76: 	void ScheduledTasks()
Chris@76: 		// !!!
Chris@76: 
Chris@76: 	array list_getScheduledTasks()
Chris@76: 		// !!!
Chris@76: 
Chris@76: 	void EditTask()
Chris@76: 		// !!!
Chris@76: 
Chris@76: 	void TaskLog()
Chris@76: 		// !!!
Chris@76: 
Chris@76: 	array list_getTaskLogEntries()
Chris@76: 		// !!!
Chris@76: 
Chris@76: 	array list_getNumTaskLog()
Chris@76: 		// !!!
Chris@76: */
Chris@76: 
Chris@76: // !!!
Chris@76: function ManageScheduledTasks()
Chris@76: {
Chris@76: 	global $context, $txt, $modSettings;
Chris@76: 
Chris@76: 	isAllowedTo('admin_forum');
Chris@76: 
Chris@76: 	loadLanguage('ManageScheduledTasks');
Chris@76: 	loadTemplate('ManageScheduledTasks');
Chris@76: 
Chris@76: 	$subActions = array(
Chris@76: 		'taskedit' => 'EditTask',
Chris@76: 		'tasklog' => 'TaskLog',
Chris@76: 		'tasks' => 'ScheduledTasks',
Chris@76: 	);
Chris@76: 
Chris@76: 	// We need to find what's the action.
Chris@76: 	if (isset($_REQUEST['sa']) && isset($subActions[$_REQUEST['sa']]))
Chris@76: 		$context['sub_action'] = $_REQUEST['sa'];
Chris@76: 	else
Chris@76: 		$context['sub_action'] = 'tasks';
Chris@76: 
Chris@76: 	// Now for the lovely tabs. That we all love.
Chris@76: 	$context[$context['admin_menu_name']]['tab_data'] = array(
Chris@76: 		'title' => $txt['scheduled_tasks_title'],
Chris@76: 		'help' => '',
Chris@76: 		'description' => $txt['maintain_info'],
Chris@76: 		'tabs' => array(
Chris@76: 			'tasks' => array(
Chris@76: 				'description' => $txt['maintain_tasks_desc'],
Chris@76: 			),
Chris@76: 			'tasklog' => array(
Chris@76: 				'description' => $txt['scheduled_log_desc'],
Chris@76: 			),
Chris@76: 		),
Chris@76: 	);
Chris@76: 
Chris@76: 	// Call it.
Chris@76: 	$subActions[$context['sub_action']]();
Chris@76: }
Chris@76: 
Chris@76: // List all the scheduled task in place on the forum.
Chris@76: function ScheduledTasks()
Chris@76: {
Chris@76: 	global $context, $txt, $sourcedir, $smcFunc, $user_info, $modSettings, $scripturl;
Chris@76: 
Chris@76: 	// Mama, setup the template first - cause it's like the most important bit, like pickle in a sandwich.
Chris@76: 	// ... ironically I don't like pickle. </grudge>
Chris@76: 	$context['sub_template'] = 'view_scheduled_tasks';
Chris@76: 	$context['page_title'] = $txt['maintain_tasks'];
Chris@76: 
Chris@76: 	// Saving changes?
Chris@76: 	if (isset($_REQUEST['save']) && isset($_POST['enable_task']))
Chris@76: 	{
Chris@76: 		checkSession();
Chris@76: 
Chris@76: 		// We'll recalculate the dates at the end!
Chris@76: 		require_once($sourcedir . '/ScheduledTasks.php');
Chris@76: 
Chris@76: 		// Enable and disable as required.
Chris@76: 		$enablers = array(0);
Chris@76: 		foreach ($_POST['enable_task'] as $id => $enabled)
Chris@76: 			if ($enabled)
Chris@76: 				$enablers[] = (int) $id;
Chris@76: 
Chris@76: 		// Do the update!
Chris@76: 		$smcFunc['db_query']('', '
Chris@76: 			UPDATE {db_prefix}scheduled_tasks
Chris@76: 			SET disabled = CASE WHEN id_task IN ({array_int:id_task_enable}) THEN 0 ELSE 1 END',
Chris@76: 			array(
Chris@76: 				'id_task_enable' => $enablers,
Chris@76: 			)
Chris@76: 		);
Chris@76: 
Chris@76: 		// Pop along...
Chris@76: 		CalculateNextTrigger();
Chris@76: 	}
Chris@76: 
Chris@76: 	// Want to run any of the tasks?
Chris@76: 	if (isset($_REQUEST['run']) && isset($_POST['run_task']))
Chris@76: 	{
Chris@76: 		// Lets figure out which ones they want to run.
Chris@76: 		$tasks = array();
Chris@76: 		foreach ($_POST['run_task'] as $task => $dummy)
Chris@76: 			$tasks[] = (int) $task;
Chris@76: 
Chris@76: 		// Load up the tasks.
Chris@76: 		$request = $smcFunc['db_query']('', '
Chris@76: 			SELECT id_task, task
Chris@76: 			FROM {db_prefix}scheduled_tasks
Chris@76: 			WHERE id_task IN ({array_int:tasks})
Chris@76: 			LIMIT ' . count($tasks),
Chris@76: 			array(
Chris@76: 				'tasks' => $tasks,
Chris@76: 			)
Chris@76: 		);
Chris@76: 
Chris@76: 		// Lets get it on!
Chris@76: 		require_once($sourcedir . '/ScheduledTasks.php');
Chris@76: 		ignore_user_abort(true);
Chris@76: 		while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76: 		{
Chris@76: 			$start_time = microtime();
Chris@76: 			// The functions got to exist for us to use it.
Chris@76: 			if (!function_exists('scheduled_' . $row['task']))
Chris@76: 				continue;
Chris@76: 
Chris@76: 			// Try to stop a timeout, this would be bad...
Chris@76: 			@set_time_limit(300);
Chris@76: 			if (function_exists('apache_reset_timeout'))
Chris@76: 				@apache_reset_timeout();
Chris@76: 
Chris@76: 			// Do the task...
Chris@76: 			$completed = call_user_func('scheduled_' . $row['task']);
Chris@76: 
Chris@76: 			// Log that we did it ;)
Chris@76: 			if ($completed)
Chris@76: 			{
Chris@76: 				$total_time = round(array_sum(explode(' ', microtime())) - array_sum(explode(' ', $start_time)), 3);
Chris@76: 				$smcFunc['db_insert']('',
Chris@76: 					'{db_prefix}log_scheduled_tasks',
Chris@76: 					array('id_task' => 'int', 'time_run' => 'int', 'time_taken' => 'float'),
Chris@76: 					array($row['id_task'], time(), $total_time),
Chris@76: 					array('id_task')
Chris@76: 				);
Chris@76: 			}
Chris@76: 		}
Chris@76: 		$smcFunc['db_free_result']($request);
Chris@76: 		redirectexit('action=admin;area=scheduledtasks;done');
Chris@76: 	}
Chris@76: 
Chris@76: 	$listOptions = array(
Chris@76: 		'id' => 'scheduled_tasks',
Chris@76: 		'title' => $txt['maintain_tasks'],
Chris@76: 		'base_href' => $scripturl . '?action=admin;area=scheduledtasks',
Chris@76: 		'get_items' => array(
Chris@76: 			'function' => 'list_getScheduledTasks',
Chris@76: 		),
Chris@76: 		'columns' => array(
Chris@76: 			'name' => array(
Chris@76: 				'header' => array(
Chris@76: 					'value' => $txt['scheduled_tasks_name'],
Chris@76: 					'style' => 'width: 40%;',
Chris@76: 				),
Chris@76: 				'data' => array(
Chris@76: 					'sprintf' => array(
Chris@76: 						'format' => '
Chris@76: 							<a href="' . $scripturl . '?action=admin;area=scheduledtasks;sa=taskedit;tid=%1$d">%2$s</a><br /><span class="smalltext">%3$s</span>',
Chris@76: 						'params' => array(
Chris@76: 							'id' => false,
Chris@76: 							'name' => false,
Chris@76: 							'desc' => false,
Chris@76: 						),
Chris@76: 					),
Chris@76: 				),
Chris@76: 			),
Chris@76: 			'next_due' => array(
Chris@76: 				'header' => array(
Chris@76: 					'value' => $txt['scheduled_tasks_next_time'],
Chris@76: 				),
Chris@76: 				'data' => array(
Chris@76: 					'db' => 'next_time',
Chris@76: 					'class' => 'smalltext',
Chris@76: 				),
Chris@76: 			),
Chris@76: 			'regularity' => array(
Chris@76: 				'header' => array(
Chris@76: 					'value' => $txt['scheduled_tasks_regularity'],
Chris@76: 				),
Chris@76: 				'data' => array(
Chris@76: 					'db' => 'regularity',
Chris@76: 					'class' => 'smalltext',
Chris@76: 				),
Chris@76: 			),
Chris@76: 			'enabled' => array(
Chris@76: 				'header' => array(
Chris@76: 					'value' => $txt['scheduled_tasks_enabled'],
Chris@76: 					'style' => 'width: 6%;',
Chris@76: 				),
Chris@76: 				'data' => array(
Chris@76: 					'sprintf' => array(
Chris@76: 						'format' =>
Chris@76: 							'<input type="hidden" name="enable_task[%1$d]" id="task_%1$d" value="0" /><input type="checkbox" name="enable_task[%1$d]" id="task_check_%1$d" %2$s class="input_check" />',
Chris@76: 						'params' => array(
Chris@76: 							'id' => false,
Chris@76: 							'checked_state' => false,
Chris@76: 						),
Chris@76: 					),
Chris@76: 					'style' => 'text-align: center;',
Chris@76: 				),
Chris@76: 			),
Chris@76: 			'run_now' => array(
Chris@76: 				'header' => array(
Chris@76: 					'value' => $txt['scheduled_tasks_run_now'],
Chris@76: 					'style' => 'width: 12%;',
Chris@76: 				),
Chris@76: 				'data' => array(
Chris@76: 					'sprintf' => array(
Chris@76: 						'format' =>
Chris@76: 							'<input type="checkbox" name="run_task[%1$d]" id="run_task_%1$d" class="input_check" />',
Chris@76: 						'params' => array(
Chris@76: 							'id' => false,
Chris@76: 						),
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=scheduledtasks',
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="save" value="' . $txt['scheduled_tasks_save_changes'] . '" class="button_submit" />
Chris@76: 					<input type="submit" name="run" value="' . $txt['scheduled_tasks_run_now'] . '" class="button_submit" />',
Chris@76: 				'class' => 'floatright',
Chris@76: 				'style' => 'text-align: right;',
Chris@76: 			),
Chris@76: 			array(
Chris@76: 				'position' => 'after_title',
Chris@76: 				'value' => '
Chris@76: 					<span class="smalltext">' . $txt['scheduled_tasks_time_offset'] . '</span>',
Chris@76: 				'class' => 'windowbg2',
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'] = 'view_scheduled_tasks';
Chris@76: 
Chris@76: 	$context['tasks_were_run'] = isset($_GET['done']);
Chris@76: }
Chris@76: 
Chris@76: function list_getScheduledTasks($start, $items_per_page, $sort)
Chris@76: {
Chris@76: 	global $smcFunc, $txt, $scripturl;
Chris@76: 
Chris@76: 	$request = $smcFunc['db_query']('', '
Chris@76: 		SELECT id_task, next_time, time_offset, time_regularity, time_unit, disabled, task
Chris@76: 		FROM {db_prefix}scheduled_tasks',
Chris@76: 		array(
Chris@76: 		)
Chris@76: 	);
Chris@76: 	$known_tasks = array();
Chris@76: 	while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76: 	{
Chris@76: 		// Find the next for regularity - don't offset as it's always server time!
Chris@76: 		$offset = sprintf($txt['scheduled_task_reg_starting'], date('H:i', $row['time_offset']));
Chris@76: 		$repeating = sprintf($txt['scheduled_task_reg_repeating'], $row['time_regularity'], $txt['scheduled_task_reg_unit_' . $row['time_unit']]);
Chris@76: 
Chris@76: 		$known_tasks[] = array(
Chris@76: 			'id' => $row['id_task'],
Chris@76: 			'function' => $row['task'],
Chris@76: 			'name' => isset($txt['scheduled_task_' . $row['task']]) ? $txt['scheduled_task_' . $row['task']] : $row['task'],
Chris@76: 			'desc' => isset($txt['scheduled_task_desc_' . $row['task']]) ? $txt['scheduled_task_desc_' . $row['task']] : '',
Chris@76: 			'next_time' => $row['disabled'] ? $txt['scheduled_tasks_na'] : timeformat(($row['next_time'] == 0 ? time() : $row['next_time']), true, 'server'),
Chris@76: 			'disabled' => $row['disabled'],
Chris@76: 			'checked_state' => $row['disabled'] ? '' : 'checked="checked"',
Chris@76: 			'regularity' => $offset . ', ' . $repeating,
Chris@76: 		);
Chris@76: 	}
Chris@76: 	$smcFunc['db_free_result']($request);
Chris@76: 
Chris@76: 	return $known_tasks;
Chris@76: }
Chris@76: 
Chris@76: // Function for editing a task.
Chris@76: function EditTask()
Chris@76: {
Chris@76: 	global $context, $txt, $sourcedir, $smcFunc, $user_info, $modSettings;
Chris@76: 
Chris@76: 	// Just set up some lovely context stuff.
Chris@76: 	$context[$context['admin_menu_name']]['current_subsection'] = 'tasks';
Chris@76: 	$context['sub_template'] = 'edit_scheduled_tasks';
Chris@76: 	$context['page_title'] = $txt['scheduled_task_edit'];
Chris@76: 	$context['server_time'] = timeformat(time(), false, 'server');
Chris@76: 
Chris@76: 	// Cleaning...
Chris@76: 	if (!isset($_GET['tid']))
Chris@76: 		fatal_lang_error('no_access', false);
Chris@76: 	$_GET['tid'] = (int) $_GET['tid'];
Chris@76: 
Chris@76: 	// Saving?
Chris@76: 	if (isset($_GET['save']))
Chris@76: 	{
Chris@76: 		checkSession();
Chris@76: 
Chris@76: 		// We'll need this for calculating the next event.
Chris@76: 		require_once($sourcedir . '/ScheduledTasks.php');
Chris@76: 
Chris@76: 		// Do we have a valid offset?
Chris@76: 		preg_match('~(\d{1,2}):(\d{1,2})~', $_POST['offset'], $matches);
Chris@76: 
Chris@76: 		// If a half is empty then assume zero offset!
Chris@76: 		if (!isset($matches[2]) || $matches[2] > 59)
Chris@76: 			$matches[2] = 0;
Chris@76: 		if (!isset($matches[1]) || $matches[1] > 23)
Chris@76: 			$matches[1] = 0;
Chris@76: 
Chris@76: 		// Now the offset is easy; easy peasy - except we need to offset by a few hours...
Chris@76: 		$offset = $matches[1] * 3600 + $matches[2] * 60 - date('Z');
Chris@76: 
Chris@76: 		// The other time bits are simple!
Chris@76: 		$interval = max((int) $_POST['regularity'], 1);
Chris@76: 		$unit = in_array(substr($_POST['unit'], 0, 1), array('m', 'h', 'd', 'w')) ? substr($_POST['unit'], 0, 1) : 'd';
Chris@76: 
Chris@76: 		// Don't allow one minute intervals.
Chris@76: 		if ($interval == 1 && $unit == 'm')
Chris@76: 			$interval = 2;
Chris@76: 
Chris@76: 		// Is it disabled?
Chris@76: 		$disabled = !isset($_POST['enabled']) ? 1 : 0;
Chris@76: 
Chris@76: 		// Do the update!
Chris@76: 		$smcFunc['db_query']('', '
Chris@76: 			UPDATE {db_prefix}scheduled_tasks
Chris@76: 			SET disabled = {int:disabled}, time_offset = {int:time_offset}, time_unit = {string:time_unit},
Chris@76: 				time_regularity = {int:time_regularity}
Chris@76: 			WHERE id_task = {int:id_task}',
Chris@76: 			array(
Chris@76: 				'disabled' => $disabled,
Chris@76: 				'time_offset' => $offset,
Chris@76: 				'time_regularity' => $interval,
Chris@76: 				'id_task' => $_GET['tid'],
Chris@76: 				'time_unit' => $unit,
Chris@76: 			)
Chris@76: 		);
Chris@76: 
Chris@76: 		// Check the next event.
Chris@76: 		CalculateNextTrigger($_GET['tid'], true);
Chris@76: 
Chris@76: 		// Return to the main list.
Chris@76: 		redirectexit('action=admin;area=scheduledtasks');
Chris@76: 	}
Chris@76: 
Chris@76: 	// Load the task, understand? Que? Que?
Chris@76: 	$request = $smcFunc['db_query']('', '
Chris@76: 		SELECT id_task, next_time, time_offset, time_regularity, time_unit, disabled, task
Chris@76: 		FROM {db_prefix}scheduled_tasks
Chris@76: 		WHERE id_task = {int:id_task}',
Chris@76: 		array(
Chris@76: 			'id_task' => $_GET['tid'],
Chris@76: 		)
Chris@76: 	);
Chris@76: 
Chris@76: 	// Should never, ever, happen!
Chris@76: 	if ($smcFunc['db_num_rows']($request) == 0)
Chris@76: 		fatal_lang_error('no_access', false);
Chris@76: 
Chris@76: 	while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76: 	{
Chris@76: 		$context['task'] = array(
Chris@76: 			'id' => $row['id_task'],
Chris@76: 			'function' => $row['task'],
Chris@76: 			'name' => isset($txt['scheduled_task_' . $row['task']]) ? $txt['scheduled_task_' . $row['task']] : $row['task'],
Chris@76: 			'desc' => isset($txt['scheduled_task_desc_' . $row['task']]) ? $txt['scheduled_task_desc_' . $row['task']] : '',
Chris@76: 			'next_time' => $row['disabled'] ? $txt['scheduled_tasks_na'] : timeformat($row['next_time'] == 0 ? time() : $row['next_time'], true, 'server'),
Chris@76: 			'disabled' => $row['disabled'],
Chris@76: 			'offset' => $row['time_offset'],
Chris@76: 			'regularity' => $row['time_regularity'],
Chris@76: 			'offset_formatted' => date('H:i', $row['time_offset']),
Chris@76: 			'unit' => $row['time_unit'],
Chris@76: 		);
Chris@76: 	}
Chris@76: 	$smcFunc['db_free_result']($request);
Chris@76: }
Chris@76: 
Chris@76: // Show the log of all tasks that have taken place.
Chris@76: function TaskLog()
Chris@76: {
Chris@76: 	global $scripturl, $context, $txt, $smcFunc, $sourcedir;
Chris@76: 
Chris@76: 	// Lets load the language just incase we are outside the Scheduled area.
Chris@76: 	loadLanguage('ManageScheduledTasks');
Chris@76: 
Chris@76: 	// Empty the log?
Chris@76: 	if (!empty($_POST['removeAll']))
Chris@76: 	{
Chris@76: 		checkSession();
Chris@76: 
Chris@76: 		$smcFunc['db_query']('truncate_table', '
Chris@76: 			TRUNCATE {db_prefix}log_scheduled_tasks',
Chris@76: 			array(
Chris@76: 			)
Chris@76: 		);
Chris@76: 	}
Chris@76: 
Chris@76: 	// Setup the list.
Chris@76: 	$listOptions = array(
Chris@76: 		'id' => 'task_log',
Chris@76: 		'items_per_page' => 30,
Chris@76: 		'title' => $txt['scheduled_log'],
Chris@76: 		'no_items_label' => $txt['scheduled_log_empty'],
Chris@76: 		'base_href' => $context['admin_area'] == 'scheduledtasks' ? $scripturl . '?action=admin;area=scheduledtasks;sa=tasklog' : $scripturl . '?action=admin;area=logs;sa=tasklog',
Chris@76: 		'default_sort_col' => 'date',
Chris@76: 		'get_items' => array(
Chris@76: 			'function' => 'list_getTaskLogEntries',
Chris@76: 		),
Chris@76: 		'get_count' => array(
Chris@76: 			'function' => 'list_getNumTaskLogEntries',
Chris@76: 		),
Chris@76: 		'columns' => array(
Chris@76: 			'name' => array(
Chris@76: 				'header' => array(
Chris@76: 					'value' => $txt['scheduled_tasks_name'],
Chris@76: 				),
Chris@76: 				'data' => array(
Chris@76: 					'db' => 'name'
Chris@76: 				),
Chris@76: 			),
Chris@76: 			'date' => array(
Chris@76: 				'header' => array(
Chris@76: 					'value' => $txt['scheduled_log_time_run'],
Chris@76: 				),
Chris@76: 				'data' => array(
Chris@76: 					'function' => create_function('$rowData', '
Chris@76: 						return timeformat($rowData[\'time_run\'], true);
Chris@76: 					'),
Chris@76: 				),
Chris@76: 				'sort' => array(
Chris@76: 					'default' => 'lst.id_log DESC',
Chris@76: 					'reverse' => 'lst.id_log',
Chris@76: 				),
Chris@76: 			),
Chris@76: 			'time_taken' => array(
Chris@76: 				'header' => array(
Chris@76: 					'value' => $txt['scheduled_log_time_taken'],
Chris@76: 				),
Chris@76: 				'data' => array(
Chris@76: 					'sprintf' => array(
Chris@76: 						'format' => $txt['scheduled_log_time_taken_seconds'],
Chris@76: 						'params' => array(
Chris@76: 							'time_taken' => false,
Chris@76: 						),
Chris@76: 					),
Chris@76: 				),
Chris@76: 				'sort' => array(
Chris@76: 					'default' => 'lst.time_taken',
Chris@76: 					'reverse' => 'lst.time_taken DESC',
Chris@76: 				),
Chris@76: 			),
Chris@76: 		),
Chris@76: 		'form' => array(
Chris@76: 			'href' => $context['admin_area'] == 'scheduledtasks' ? $scripturl . '?action=admin;area=scheduledtasks;sa=tasklog' : $scripturl . '?action=admin;area=logs;sa=tasklog',
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="removeAll" value="' . $txt['scheduled_log_empty_log'] . '" class="button_submit" />',
Chris@76: 				'style' => 'text-align: right;',
Chris@76: 			),
Chris@76: 			array(
Chris@76: 				'position' => 'after_title',
Chris@76: 				'value' => $txt['scheduled_tasks_time_offset'],
Chris@76: 				'class' => 'smalltext',
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'] = 'task_log';
Chris@76: 
Chris@76: 	// Make it all look tify.
Chris@76: 	$context[$context['admin_menu_name']]['current_subsection'] = 'tasklog';
Chris@76: 	$context['page_title'] = $txt['scheduled_log'];
Chris@76: }
Chris@76: 
Chris@76: function list_getTaskLogEntries($start, $items_per_page, $sort)
Chris@76: {
Chris@76: 	global $smcFunc, $txt;
Chris@76: 
Chris@76: 	$request = $smcFunc['db_query']('', '
Chris@76: 		SELECT lst.id_log, lst.id_task, lst.time_run, lst.time_taken, st.task
Chris@76: 		FROM {db_prefix}log_scheduled_tasks AS lst
Chris@76: 			INNER JOIN {db_prefix}scheduled_tasks AS st ON (st.id_task = lst.id_task)
Chris@76: 		ORDER BY ' . $sort . '
Chris@76: 		LIMIT ' . $start . ', ' . $items_per_page,
Chris@76: 		array(
Chris@76: 		)
Chris@76: 	);
Chris@76: 	$log_entries = array();
Chris@76: 	while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76: 		$log_entries[] = array(
Chris@76: 			'id' => $row['id_log'],
Chris@76: 			'name' => isset($txt['scheduled_task_' . $row['task']]) ? $txt['scheduled_task_' . $row['task']] : $row['task'],
Chris@76: 			'time_run' => $row['time_run'],
Chris@76: 			'time_taken' => $row['time_taken'],
Chris@76: 		);
Chris@76: 	$smcFunc['db_free_result']($request);
Chris@76: 
Chris@76: 	return $log_entries;
Chris@76: }
Chris@76: 
Chris@76: function list_getNumTaskLogEntries()
Chris@76: {
Chris@76: 	global $smcFunc;
Chris@76: 
Chris@76: 	$request = $smcFunc['db_query']('', '
Chris@76: 		SELECT COUNT(*)
Chris@76: 		FROM {db_prefix}log_scheduled_tasks',
Chris@76: 		array(
Chris@76: 		)
Chris@76: 	);
Chris@76: 	list ($num_entries) = $smcFunc['db_fetch_row']($request);
Chris@76: 	$smcFunc['db_free_result']($request);
Chris@76: 
Chris@76: 	return $num_entries;
Chris@76: }
Chris@76: 
Chris@76: ?>