<?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.
We have provided this demo forum as a means to allow you to demo our software.
SimpleDesk Administrator login: Admin / admin
SimpleDesk Staff user login: Staff / staff
SimpleDesk Regular user login: User / user
';
// 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;
?>