PasteBin

<?php
// SETTINGS
	// Simple Desk Tables.
	$sd_tables = array('tickets', 'ticket_replies', 'log_action', 'log_read', 'attachments');
 
	// SMF Tables we need to clean up after.
	$smf_tables = array('log_mark_read', 'log_notify', 'log_actions', 'log_activity', );
 
	// My settings brings all the coders to the yard...
	$reset_settings = array(
		'shd_staff_badge' => 'nobadge',
		'shd_display_avatar' => 0,
		'shd_disable_action_log' => 0,
		'shd_ticketnav_style' => 'sd',
		'shd_allow_ticket_bbc' => 1,
		'shd_allow_ticket_smileys' => 1,
		'shd_enabled_bbc' => 1,
		'shd_helpdesk_only' => 0,
		'shd_attachments_mode' => 'ticket',
		'shd_disable_pm' => 0,
		'shd_disable_mlist' => 0,
		'shd_bbc' => implode(',', $bbc_tags),
		'shd_staff_ticket_self' => 1,
		'shd_privacy_display' => 'smart',
		'settings_updated' => time(),
	);
 
	// The default topic title.
	$topic = 'Welcome to the SimpleDesk Demo';
 
	// The default topic body.
	$message = 'Welcome to the SimpleDesk Demo.[br]
We have provided this demo forum as a means to allow you to demo our software.[br]
[br]
SimpleDesk Administrator login: Admin / admin[br]
SimpleDesk Staff user login: Staff / staff[br]
SimpleDesk Regular user login: User / user[br]';
 
// Join us, SMF.
require_once('SSI.php');
 
// Clean the tables.
foreach ($sd_tables as $table)
	$smcFunc['db_query']('', 'TRUNCATE {db_prefix}helpdesk_{raw:table}', array('table' => $table));
 
// Collect bbc.
$bbc_tags = array();
foreach (parse_bbc(false) AS $tag)
	$bbc_tags[] = $tag['tag'];
 
// Update the Settings table.
updateSettings($reset_settings);
 
// Clean the SMF topics and messages, leaving only default.  This is done because posts are allowed for move to topic/ticket feature
$smcFunc['db_query']('', 'DELETE FROM {db_prefix}topics WHERE id_topic > 1', array());
$smcFunc['db_query']('', 'DELETE FROM {db_prefix}messages WHERE id_msg > 1', array());
 
// Reset the auto-increment count.
$smcFunc['db_query']('', 'ALTER TABLE {db_prefix}topics AUTO_INCREMENT = 1', array());
$smcFunc['db_query']('', 'ALTER TABLE {db_prefix}messages AUTO_INCREMENT = 1', array());
 
// Clean any SMF logs such as read log pretaining to topics and messages caused by SD actions.
foreach ($smf_tables as $table)
	$smcFunc['db_query']('', 'TRUNCATE {db_prefix}{raw:table}', array('table' => $table));
 
// Do the actual change to message table.
$smcFunc['db_query']('', '
	UPDATE {db_prefix}messages
		SET
			subject = {string:topic},
			body = {string:message},
			id_msg_modified = 1,
			poster_name = {string:name},
			poster_email = {string:email},
			poster_ip = {string:ip},
			smileys_enabled = 1,
			modified_time = 0,
			modified_name = {string:empty},
			icon = {string:xx},
			approved = 1,
			id_member = 0,
			poster_time = {int:time}
	WHERE id_msg = 1',
		array(
			'topic' => $topic,
			'message' => $message,
			'name' => 'SimpleDesk Team',
			'email' => 'void@simpledesk.net',
			'ip' => '127.0.0.1',
			'empty' => '',
			'xx' => 'xx',
			'time' => (int) strtotime('Janurary 1st, 2010'),
		)
	);
 
// Now topics table.
$smcFunc['db_query']('', '
	UPDATE {db_prefix}topics
		SET
			is_sticky = 0,
			id_first_msg = 1,
			id_last_msg = 1,
			id_member_started = 0,
			id_member_updated = 0,
			id_poll = 0,
			id_previous_board = 0,
			id_previous_topic = 0,
			num_replies = 0,
			num_views = 0,
			locked = 0,
			unapproved_posts = 0,
			approved = 1
	WHERE id_topic = 1', array());
 
// TODO: Fail checks, email webmaster@simpledesk.net on errors and return false for error handler to show a message (Need to setup that email address first [HA!])
 
// For now this just redirects.
redirectexit();
 
return true; exit;
?>