]~', '', $_POST['icon']);
$draft['smileys_enabled'] = isset($_POST['ns']) ? (int) $_POST['ns'] : 0;
$draft['locked'] = isset($_POST['lock']) ? (int) $_POST['lock'] : 0;
$draft['sticky'] = isset($_POST['sticky']) && !empty($modSettings['enableStickyTopics']) ? (int) $_POST['sticky'] : 0;
$draft['subject'] = strtr($smcFunc['htmlspecialchars']($_POST['subject']), array("\r" => '', "\n" => '', "\t" => ''));
$draft['body'] = $smcFunc['htmlspecialchars']($_POST['message'], ENT_QUOTES);
// message and subject still need a bit more work
preparsecode($draft['body']);
if ($smcFunc['strlen']($draft['subject']) > 100)
$draft['subject'] = $smcFunc['substr']($draft['subject'], 0, 100);
// Modifying an existing draft, like hitting the save draft button or autosave enabled?
if (!empty($id_draft) && !empty($draft_info) && $draft_info['id_member'] == $user_info['id'])
{
$smcFunc['db_query']('', '
UPDATE {db_prefix}user_drafts
SET
id_topic = {int:id_topic},
id_board = {int:id_board},
poster_time = {int:poster_time},
subject = {string:subject},
smileys_enabled = {int:smileys_enabled},
body = {string:body},
icon = {string:icon},
locked = {int:locked},
is_sticky = {int:is_sticky}
WHERE id_draft = {int:id_draft}',
array (
'id_topic' => $topic_id,
'id_board' => $board,
'poster_time' => time(),
'subject' => $draft['subject'],
'smileys_enabled' => (int) $draft['smileys_enabled'],
'body' => $draft['body'],
'icon' => $draft['icon'],
'locked' => $draft['locked'],
'is_sticky' => $draft['sticky'],
'id_draft' => $id_draft,
)
);
// some items to return to the form
$context['draft_saved'] = true;
$context['id_draft'] = $id_draft;
// cleanup
unset($_POST['save_draft']);
}
// otherwise creating a new draft
else
{
$smcFunc['db_insert']('',
'{db_prefix}user_drafts',
array(
'id_topic' => 'int',
'id_board' => 'int',
'type' => 'int',
'poster_time' => 'int',
'id_member' => 'int',
'subject' => 'string-255',
'smileys_enabled' => 'int',
'body' => (!empty($modSettings['max_messageLength']) && $modSettings['max_messageLength'] > 65534 ? 'string-' . $modSettings['max_messageLength'] : 'string-65534'),
'icon' => 'string-16',
'locked' => 'int',
'is_sticky' => 'int'
),
array(
$topic_id,
$board,
0,
time(),
$user_info['id'],
$draft['subject'],
$draft['smileys_enabled'],
$draft['body'],
$draft['icon'],
$draft['locked'],
$draft['sticky']
),
array(
'id_draft'
)
);
// get the id of the new draft
$id_draft = $smcFunc['db_insert_id']('{db_prefix}user_drafts', 'id_draft');
// everything go as expected?
if (!empty($id_draft))
{
$context['draft_saved'] = true;
$context['id_draft'] = $id_draft;
}
else
$post_errors[] = 'draft_not_saved';
// cleanup
unset($_POST['save_draft']);
}
// if we were called from the autosave function, send something back
if (!empty($id_draft) && isset($_REQUEST['xml']) && (!in_array('session_timeout', $post_errors)))
{
$context['draft_saved_on'] = time();
XmlDraft($id_draft);
}
return true;
}
/**
* Saves a PM draft in the user_drafts table
* The core draft feature must be enabled, as well as the pm draft option
* Determines if this is a new or and update to an existing pm draft
*
* @global type $context
* @global type $user_info
* @global type $smcFunc
* @global type $modSettings
* @param string $post_errors
* @param type $recipientList
* @return boolean
*/
function SavePMDraft(&$post_errors, $recipientList)
{
global $context, $user_info, $smcFunc, $modSettings;
// PM survey says ... can you stay or must you go
if (empty($modSettings['drafts_enabled']) || empty($modSettings['drafts_pm_enabled']) || !allowedTo('pm_draft') || !isset($_POST['save_draft']))
return false;
// read in what you sent us
$id_pm_draft = (int) $_POST['id_pm_draft'];
$draft_info = ReadDraft($id_pm_draft, 1);
// 5 seconds is the same limit we have for posting
if (isset($_REQUEST['xml']) && !empty($draft_info['poster_time']) && time() < $draft_info['poster_time'] + 5)
{
$context['draft_saved_on'] = $draft_info['poster_time'];
// Send something back to the javascript caller
if (!empty($id_draft))
XmlDraft($id_draft);
return true;
}
// determine who this is being sent to
if (isset($_REQUEST['xml']))
{
$recipientList['to'] = isset($_POST['recipient_to']) ? explode(',', $_POST['recipient_to']) : array();
$recipientList['bcc'] = isset($_POST['recipient_bcc']) ? explode(',', $_POST['recipient_bcc']) : array();
}
elseif (!empty($draft_info['to_list']) && empty($recipientList))
$recipientList = unserialize($draft_info['to_list']);
// prepare the data we got from the form
$reply_id = empty($_POST['replied_to']) ? 0 : (int) $_POST['replied_to'];
$outbox = empty($_POST['outbox']) ? 0 : 1;
$draft['body'] = $smcFunc['htmlspecialchars']($_POST['message'], ENT_QUOTES);
$draft['subject'] = strtr($smcFunc['htmlspecialchars']($_POST['subject']), array("\r" => '', "\n" => '', "\t" => ''));
// message and subject always need a bit more work
preparsecode($draft['body']);
if ($smcFunc['strlen']($draft['subject']) > 100)
$draft['subject'] = $smcFunc['substr']($draft['subject'], 0, 100);
// Modifying an existing PM draft?
if (!empty($id_pm_draft) && !empty($draft_info) && $draft_info['id_member'] == $user_info['id'])
{
$smcFunc['db_query']('', '
UPDATE {db_prefix}user_drafts
SET id_reply = {int:id_reply},
type = {int:type},
poster_time = {int:poster_time},
subject = {string:subject},
body = {string:body},
to_list = {string:to_list},
outbox = {int:outbox}
WHERE id_draft = {int:id_pm_draft}
LIMIT 1',
array(
'id_reply' => $reply_id,
'type' => 1,
'poster_time' => time(),
'subject' => $draft['subject'],
'body' => $draft['body'],
'id_pm_draft' => $id_pm_draft,
'to_list' => serialize($recipientList),
'outbox' => $outbox,
)
);
// some items to return to the form
$context['draft_saved'] = true;
$context['id_pm_draft'] = $id_pm_draft;
}
// otherwise creating a new PM draft.
else
{
$smcFunc['db_insert']('',
'{db_prefix}user_drafts',
array(
'id_reply' => 'int',
'type' => 'int',
'poster_time' => 'int',
'id_member' => 'int',
'subject' => 'string-255',
'body' => 'string-65534',
'to_list' => 'string-255',
'outbox' => 'int',
),
array(
$reply_id,
1,
time(),
$user_info['id'],
$draft['subject'],
$draft['body'],
serialize($recipientList),
$outbox,
),
array(
'id_draft'
)
);
// get the new id
$id_pm_draft = $smcFunc['db_insert_id']('{db_prefix}user_drafts', 'id_draft');
// everything go as expected, if not toss back an error
if (!empty($id_pm_draft))
{
$context['draft_saved'] = true;
$context['id_pm_draft'] = $id_pm_draft;
}
else
$post_errors[] = 'draft_not_saved';
}
// if we were called from the autosave function, send something back
if (!empty($id_pm_draft) && isset($_REQUEST['xml']) && !in_array('session_timeout', $post_errors))
{
$context['draft_saved_on'] = time();
XmlDraft($id_pm_draft);
}
return;
}
/**
* Reads a draft in from the user_drafts table
* Only loads the draft of a given type 0 for post, 1 for pm draft
* validates that the draft is the users draft
* Optionally loads the draft in to context or superglobal for loading in to the form
*
* @param type $id_draft - draft to load
* @param type $type - type of draft
* @param type $check - validate the user
* @param type $load - load it for use in a form
* @return boolean
*/
function ReadDraft($id_draft, $type = 0, $check = true, $load = false)
{
global $context, $user_info, $smcFunc, $modSettings;
// like purell always clean to be sure
$id_draft = (int) $id_draft;
$type = (int) $type;
// nothing to read, nothing to do
if (empty($id_draft))
return false;
// load in this draft from the DB
$request = $smcFunc['db_query']('', '
SELECT *
FROM {db_prefix}user_drafts
WHERE id_draft = {int:id_draft}' . ($check ? '
AND id_member = {int:id_member}' : '') . '
AND type = {int:type}' . (!empty($modSettings['drafts_keep_days']) ? '
AND poster_time > {int:time}' : '') . '
LIMIT 1',
array(
'id_member' => $user_info['id'],
'id_draft' => $id_draft,
'type' => $type,
'time' => (!empty($modSettings['drafts_keep_days']) ? (time() - ($modSettings['drafts_keep_days'] * 86400)) : 0),
)
);
// no results?
if (!$smcFunc['db_num_rows']($request))
return false;
// load up the data
$draft_info = $smcFunc['db_fetch_assoc']($request);
$smcFunc['db_free_result']($request);
// Load it up for the templates as well
$recipients = array();
if (!empty($load))
{
if ($type === 0)
{
// a standard post draft?
$context['sticky'] = !empty($draft_info['is_sticky']) ? $draft_info['is_sticky'] : '';
$context['locked'] = !empty($draft_info['locked']) ? $draft_info['locked'] : '';
$context['use_smileys'] = !empty($draft_info['smileys_enabled']) ? true : false;
$context['icon'] = !empty($draft_info['icon']) ? $draft_info['icon'] : 'xx';
$context['message'] = !empty($draft_info['body']) ? str_replace('
', "\n", un_htmlspecialchars(stripslashes($draft_info['body']))) : '';
$context['subject'] = !empty($draft_info['subject']) ? stripslashes($draft_info['subject']) : '';
$context['board'] = !empty($draft_info['board_id']) ? $draft_info['id_board'] : '';
$context['id_draft'] = !empty($draft_info['id_draft']) ? $draft_info['id_draft'] : 0;
}
elseif ($type === 1)
{
// one of those pm drafts? then set it up like we have an error
$_REQUEST['outbox'] = !empty($draft_info['outbox']);
$_REQUEST['subject'] = !empty($draft_info['subject']) ? stripslashes($draft_info['subject']) : '';
$_REQUEST['message'] = !empty($draft_info['body']) ? str_replace('
', "\n", un_htmlspecialchars(stripslashes($draft_info['body']))) : '';
$_REQUEST['replied_to'] = !empty($draft_info['id_reply']) ? $draft_info['id_reply'] : 0;
$context['id_pm_draft'] = !empty($draft_info['id_draft']) ? $draft_info['id_draft'] : 0;
$recipients = unserialize($draft_info['to_list']);
// make sure we only have integers in this array
$recipients['to'] = array_map('intval', $recipients['to']);
$recipients['bcc'] = array_map('intval', $recipients['bcc']);
// pretend we messed up to populate the pm message form
messagePostError(array(), array(), $recipients);
return true;
}
}
return $draft_info;
}
/**
* Deletes one or many drafts from the DB
* Validates the drafts are from the user
* is supplied an array of drafts will attempt to remove all of them
*
* @param type $id_draft
* @param type $check
* @return boolean
*/
function DeleteDraft($id_draft, $check = true)
{
global $user_info, $smcFunc;
// Only a single draft.
if (is_numeric($id_draft))
$id_draft = array($id_draft);
// can't delete nothing
if (empty($id_draft) || ($check && empty($user_info['id'])))
return false;
$smcFunc['db_query']('', '
DELETE FROM {db_prefix}user_drafts
WHERE id_draft IN ({array_int:id_draft})' . ($check ? '
AND id_member = {int:id_member}' : ''),
array (
'id_draft' => $id_draft,
'id_member' => empty($user_info['id']) ? -1 : $user_info['id'],
)
);
}
/**
* Loads in a group of drafts for the user of a given type (0/posts, 1/pm's)
* loads a specific draft for forum use if selected.
* Used in the posting screens to allow draft selection
* WIll load a draft if selected is supplied via post
*
* @param type $member_id
* @param type $topic
* @param type $draft_type
* @return boolean
*/
function ShowDrafts($member_id, $topic = false, $draft_type = 0)
{
global $smcFunc, $scripturl, $context, $txt, $modSettings;
// Permissions
if (($draft_type === 0 && empty($context['drafts_save'])) || ($draft_type === 1 && empty($context['drafts_pm_save'])) || empty($member_id))
return false;
$context['drafts'] = array();
// has a specific draft has been selected? Load it up if there is not a message already in the editor
if (isset($_REQUEST['id_draft']) && empty($_POST['subject']) && empty($_POST['message']))
ReadDraft((int) $_REQUEST['id_draft'], $draft_type, true, true);
// load the drafts this user has available
$request = $smcFunc['db_query']('', '
SELECT *
FROM {db_prefix}user_drafts
WHERE id_member = {int:id_member}' . ((!empty($topic) && empty($draft_type)) ? '
AND id_topic = {int:id_topic}' : (!empty($topic) ? '
AND id_reply = {int:id_topic}' : '')) . '
AND type = {int:draft_type}' . (!empty($modSettings['drafts_keep_days']) ? '
AND poster_time > {int:time}' : '') . '
ORDER BY poster_time DESC',
array(
'id_member' => $member_id,
'id_topic' => (int) $topic,
'draft_type' => $draft_type,
'time' => (!empty($modSettings['drafts_keep_days']) ? (time() - ($modSettings['drafts_keep_days'] * 86400)) : 0),
)
);
// add them to the draft array for display
while ($row = $smcFunc['db_fetch_assoc']($request))
{
// Post drafts
if ($draft_type === 0)
$context['drafts'][] = array(
'subject' => censorText(shorten_subject(stripslashes($row['subject']), 24)),
'poster_time' => timeformat($row['poster_time']),
'link' => '' . $row['subject'] . '',
);
// PM drafts
elseif ($draft_type === 1)
$context['drafts'][] = array(
'subject' => censorText(shorten_subject(stripslashes($row['subject']), 24)),
'poster_time' => timeformat($row['poster_time']),
'link' => '' . (!empty($row['subject']) ? $row['subject'] : $txt['drafts_none']) . '',
);
}
$smcFunc['db_free_result']($request);
}
/**
* Returns an xml response to an autosave ajax request
* provides the id of the draft saved and the time it was saved
*
* @param type $id_draft
*/
function XmlDraft($id_draft)
{
global $txt, $context;
header('Content-Type: text/xml; charset=' . (empty($context['character_set']) ? 'ISO-8859-1' : $context['character_set']));
echo '
';
obExit(false);
}
/**
* Show all drafts of a given type by the current user
* Uses the showdraft template
* Allows for the deleting and loading/editing of drafts
*
* @param type $memID
* @param type $draft_type
*/
function showProfileDrafts($memID, $draft_type = 0)
{
global $txt, $scripturl, $modSettings, $context, $smcFunc;
// Some initial context.
$context['start'] = isset($_REQUEST['start']) ? (int) $_REQUEST['start'] : 0;
$context['current_member'] = $memID;
// If just deleting a draft, do it and then redirect back.
if (!empty($_REQUEST['delete']))
{
checkSession('get');
$id_delete = (int) $_REQUEST['delete'];
$smcFunc['db_query']('', '
DELETE FROM {db_prefix}user_drafts
WHERE id_draft = {int:id_draft}
AND id_member = {int:id_member}
AND type = {int:draft_type}
LIMIT 1',
array(
'id_draft' => $id_delete,
'id_member' => $memID,
'draft_type' => $draft_type,
)
);
redirectexit('action=profile;u=' . $memID . ';area=showdrafts;start=' . $context['start']);
}
// Default to 10.
if (empty($_REQUEST['viewscount']) || !is_numeric($_REQUEST['viewscount']))
$_REQUEST['viewscount'] = 10;
// Get the count of applicable drafts on the boards they can (still) see ...
// @todo .. should we just let them see their drafts even if they have lost board access ?
$request = $smcFunc['db_query']('', '
SELECT COUNT(id_draft)
FROM {db_prefix}user_drafts AS ud
INNER JOIN {db_prefix}boards AS b ON (b.id_board = ud.id_board AND {query_see_board})
WHERE id_member = {int:id_member}
AND type={int:draft_type}' . (!empty($modSettings['drafts_keep_days']) ? '
AND poster_time > {int:time}' : ''),
array(
'id_member' => $memID,
'draft_type' => $draft_type,
'time' => (!empty($modSettings['drafts_keep_days']) ? (time() - ($modSettings['drafts_keep_days'] * 86400)) : 0),
)
);
list ($msgCount) = $smcFunc['db_fetch_row']($request);
$smcFunc['db_free_result']($request);
$maxIndex = (int) $modSettings['defaultMaxMessages'];
// Make sure the starting place makes sense and construct our friend the page index.
$context['page_index'] = constructPageIndex($scripturl . '?action=profile;u=' . $memID . ';area=showdrafts', $context['start'], $msgCount, $maxIndex);
$context['current_page'] = $context['start'] / $maxIndex;
// Reverse the query if we're past 50% of the pages for better performance.
$start = $context['start'];
$reverse = $_REQUEST['start'] > $msgCount / 2;
if ($reverse)
{
$maxIndex = $msgCount < $context['start'] + $modSettings['defaultMaxMessages'] + 1 && $msgCount > $context['start'] ? $msgCount - $context['start'] : (int) $modSettings['defaultMaxMessages'];
$start = $msgCount < $context['start'] + $modSettings['defaultMaxMessages'] + 1 || $msgCount < $context['start'] + $modSettings['defaultMaxMessages'] ? 0 : $msgCount - $context['start'] - $modSettings['defaultMaxMessages'];
}
// Find this user's drafts for the boards they can access
// @todo ... do we want to do this? If they were able to create a draft, do we remove thier access to said draft if they loose
// access to the board or if the topic moves to a board they can not see?
$request = $smcFunc['db_query']('', '
SELECT
b.id_board, b.name AS bname,
ud.id_member, ud.id_draft, ud.body, ud.smileys_enabled, ud.subject, ud.poster_time, ud.icon, ud.id_topic, ud.locked, ud.is_sticky
FROM {db_prefix}user_drafts AS ud
INNER JOIN {db_prefix}boards AS b ON (b.id_board = ud.id_board AND {query_see_board})
WHERE ud.id_member = {int:current_member}
AND type = {int:draft_type}' . (!empty($modSettings['drafts_keep_days']) ? '
AND poster_time > {int:time}' : '') . '
ORDER BY ud.id_draft ' . ($reverse ? 'ASC' : 'DESC') . '
LIMIT ' . $start . ', ' . $maxIndex,
array(
'current_member' => $memID,
'draft_type' => $draft_type,
'time' => (!empty($modSettings['drafts_keep_days']) ? (time() - ($modSettings['drafts_keep_days'] * 86400)) : 0),
)
);
// Start counting at the number of the first message displayed.
$counter = $reverse ? $context['start'] + $maxIndex + 1 : $context['start'];
$context['posts'] = array();
while ($row = $smcFunc['db_fetch_assoc']($request))
{
// Censor....
if (empty($row['body']))
$row['body'] = '';
$row['subject'] = $smcFunc['htmltrim']($row['subject']);
if (empty($row['subject']))
$row['subject'] = $txt['no_subject'];
censorText($row['body']);
censorText($row['subject']);
// BBC-ilize the message.
$row['body'] = parse_bbc($row['body'], $row['smileys_enabled'], 'draft' . $row['id_draft']);
// And the array...
$context['drafts'][$counter += $reverse ? -1 : 1] = array(
'body' => $row['body'],
'counter' => $counter,
'alternate' => $counter % 2,
'board' => array(
'name' => $row['bname'],
'id' => $row['id_board']
),
'topic' => array(
'id' => $row['id_topic'],
'link' => empty($row['id']) ? $row['subject'] : '' . $row['subject'] . '',
),
'subject' => $row['subject'],
'time' => timeformat($row['poster_time']),
'timestamp' => forum_time(true, $row['poster_time']),
'icon' => $row['icon'],
'id_draft' => $row['id_draft'],
'locked' => $row['locked'],
'sticky' => $row['is_sticky'],
);
}
$smcFunc['db_free_result']($request);
// If the drafts were retrieved in reverse order, get them right again.
if ($reverse)
$context['drafts'] = array_reverse($context['drafts'], true);
// Menu tab
$context[$context['profile_menu_name']]['tab_data'] = array(
'title' => $txt['drafts_show'] . ' - ' . $context['member']['name'],
'icon' => 'message_sm.png'
);
$context['sub_template'] = 'showDrafts';
}
/**
* Show all PM drafts of the current user
* Uses the showpmdraft template
* Allows for the deleting and loading/editing of drafts
*
* @param type $memID
*/
function showPMDrafts($memID = -1)
{
global $txt, $user_info, $scripturl, $modSettings, $context, $smcFunc;
// init
$draft_type = 1;
// If just deleting a draft, do it and then redirect back.
if (!empty($_REQUEST['delete']))
{
checkSession('get');
$id_delete = (int) $_REQUEST['delete'];
$start = isset($_REQUEST['start']) ? (int) $_REQUEST['start'] : 0;
$smcFunc['db_query']('', '
DELETE FROM {db_prefix}user_drafts
WHERE id_draft = {int:id_draft}
AND id_member = {int:id_member}
AND type = {int:draft_type}
LIMIT 1',
array(
'id_draft' => $id_delete,
'id_member' => $memID,
'draft_type' => $draft_type,
)
);
// now redirect back to the list
redirectexit('action=pm;sa=showpmdrafts;start=' . $start);
}
// perhaps a draft was selected for editing? if so pass this off
if (!empty($_REQUEST['id_draft']) && !empty($context['drafts_pm_save']) && $memID == $user_info['id'])
{
checkSession('get');
$id_draft = (int) $_REQUEST['id_draft'];
redirectexit('action=pm;sa=send;id_draft=' . $id_draft);
}
// Default to 10.
if (empty($_REQUEST['viewscount']) || !is_numeric($_REQUEST['viewscount']))
$_REQUEST['viewscount'] = 10;
// Get the count of applicable drafts
$request = $smcFunc['db_query']('', '
SELECT COUNT(id_draft)
FROM {db_prefix}user_drafts
WHERE id_member = {int:id_member}
AND type={int:draft_type}' . (!empty($modSettings['drafts_keep_days']) ? '
AND poster_time > {int:time}' : ''),
array(
'id_member' => $memID,
'draft_type' => $draft_type,
'time' => (!empty($modSettings['drafts_keep_days']) ? (time() - ($modSettings['drafts_keep_days'] * 86400)) : 0),
)
);
list ($msgCount) = $smcFunc['db_fetch_row']($request);
$smcFunc['db_free_result']($request);
$maxIndex = (int) $modSettings['defaultMaxMessages'];
// Make sure the starting place makes sense and construct our friend the page index.
$context['page_index'] = constructPageIndex($scripturl . '?action=pm;sa=showpmdrafts', $context['start'], $msgCount, $maxIndex);
$context['current_page'] = $context['start'] / $maxIndex;
// Reverse the query if we're past 50% of the total for better performance.
$start = $context['start'];
$reverse = $_REQUEST['start'] > $msgCount / 2;
if ($reverse)
{
$maxIndex = $msgCount < $context['start'] + $modSettings['defaultMaxMessages'] + 1 && $msgCount > $context['start'] ? $msgCount - $context['start'] : (int) $modSettings['defaultMaxMessages'];
$start = $msgCount < $context['start'] + $modSettings['defaultMaxMessages'] + 1 || $msgCount < $context['start'] + $modSettings['defaultMaxMessages'] ? 0 : $msgCount - $context['start'] - $modSettings['defaultMaxMessages'];
}
// Load in this user's PM drafts
$request = $smcFunc['db_query']('', '
SELECT
ud.id_member, ud.id_draft, ud.body, ud.subject, ud.poster_time, ud.outbox, ud.id_reply, ud.to_list
FROM {db_prefix}user_drafts AS ud
WHERE ud.id_member = {int:current_member}
AND type = {int:draft_type}' . (!empty($modSettings['drafts_keep_days']) ? '
AND poster_time > {int:time}' : '') . '
ORDER BY ud.id_draft ' . ($reverse ? 'ASC' : 'DESC') . '
LIMIT ' . $start . ', ' . $maxIndex,
array(
'current_member' => $memID,
'draft_type' => $draft_type,
'time' => (!empty($modSettings['drafts_keep_days']) ? (time() - ($modSettings['drafts_keep_days'] * 86400)) : 0),
)
);
// Start counting at the number of the first message displayed.
$counter = $reverse ? $context['start'] + $maxIndex + 1 : $context['start'];
$context['posts'] = array();
while ($row = $smcFunc['db_fetch_assoc']($request))
{
// Censor....
if (empty($row['body']))
$row['body'] = '';
$row['subject'] = $smcFunc['htmltrim']($row['subject']);
if (empty($row['subject']))
$row['subject'] = $txt['no_subject'];
censorText($row['body']);
censorText($row['subject']);
// BBC-ilize the message.
$row['body'] = parse_bbc($row['body'], true, 'draft' . $row['id_draft']);
// Have they provide who this will go to?
$recipients = array(
'to' => array(),
'bcc' => array(),
);
$recipient_ids = (!empty($row['to_list'])) ? unserialize($row['to_list']) : array();
// @todo ... this is a bit ugly since it runs an extra query for every message, do we want this?
// at least its only for draft PM's and only the user can see them ... so not heavily used .. still
if (!empty($recipient_ids['to']) || !empty($recipient_ids['bcc']))
{
$recipient_ids['to'] = array_map('intval', $recipient_ids['to']);
$recipient_ids['bcc'] = array_map('intval', $recipient_ids['bcc']);
$allRecipients = array_merge($recipient_ids['to'], $recipient_ids['bcc']);
$request_2 = $smcFunc['db_query']('', '
SELECT id_member, real_name
FROM {db_prefix}members
WHERE id_member IN ({array_int:member_list})',
array(
'member_list' => $allRecipients,
)
);
while ($result = $smcFunc['db_fetch_assoc']($request_2))
{
$recipientType = in_array($result['id_member'], $recipient_ids['bcc']) ? 'bcc' : 'to';
$recipients[$recipientType][] = $result['real_name'];
}
$smcFunc['db_free_result']($request_2);
}
// Add the items to the array for template use
$context['drafts'][$counter += $reverse ? -1 : 1] = array(
'body' => $row['body'],
'counter' => $counter,
'alternate' => $counter % 2,
'subject' => $row['subject'],
'time' => timeformat($row['poster_time']),
'timestamp' => forum_time(true, $row['poster_time']),
'id_draft' => $row['id_draft'],
'recipients' => $recipients,
'age' => floor((time() - $row['poster_time']) / 86400),
'remaining' => (!empty($modSettings['drafts_keep_days']) ? floor($modSettings['drafts_keep_days'] - ((time() - $row['poster_time']) / 86400)) : 0),
);
}
$smcFunc['db_free_result']($request);
// if the drafts were retrieved in reverse order, then put them in the right order again.
if ($reverse)
$context['drafts'] = array_reverse($context['drafts'], true);
// off to the template we go
$context['page_title'] = $txt['drafts'];
$context['sub_template'] = 'showPMDrafts';
$context['linktree'][] = array(
'url' => $scripturl . '?action=pm;sa=showpmdrafts',
'name' => $txt['drafts'],
);
}
/**
* Modify any setting related to drafts.
* Requires the admin_forum permission.
* Accessed from ?action=admin;area=managedrafts
*
* @param bool $return_config = false
* @uses Admin template, edit_topic_settings sub-template.
*/
function ModifyDraftSettings($return_config = false)
{
global $context, $txt, $sourcedir, $scripturl;
isAllowedTo('admin_forum');
// Here are all the draft settings, a bit lite for now, but we can add more :P
$config_vars = array(
// Draft settings ...
array('check', 'drafts_post_enabled'),
array('check', 'drafts_pm_enabled'),
array('check', 'drafts_show_saved_enabled', 'subtext' => $txt['drafts_show_saved_enabled_subnote']),
array('int', 'drafts_keep_days', 'postinput' => $txt['days_word'], 'subtext' => $txt['drafts_keep_days_subnote']),
'',
array('check', 'drafts_autosave_enabled', 'subtext' => $txt['drafts_autosave_enabled_subnote']),
array('int', 'drafts_autosave_frequency', 'postinput' => $txt['manageposts_seconds'], 'subtext' => $txt['drafts_autosave_frequency_subnote']),
);
if ($return_config)
return $config_vars;
// Get the settings template ready.
require_once($sourcedir . '/ManageServer.php');
// Setup the template.
$context['page_title'] = $txt['managedrafts_settings'];
$context['sub_template'] = 'show_settings';
$context[$context['admin_menu_name']]['tab_data'] = array(
'title' => $txt['drafts'],
'help' => '',
'description' => $txt['managedrafts_settings_description'],
);
// Saving them ?
if (isset($_GET['save']))
{
checkSession();
// Protect them from themselves.
$_POST['drafts_autosave_frequency'] = $_POST['drafts_autosave_frequency'] < 30 ? 30 : $_POST['drafts_autosave_frequency'];
saveDBSettings($config_vars);
redirectexit('action=admin;area=managedrafts');
}
// some javascript to enable / disable the frequency input box
$context['settings_post_javascript'] = '
var autosave = document.getElementById(\'drafts_autosave_enabled\');
createEventListener(autosave)
autosave.addEventListener(\'change\', toggle);
toggle();
function toggle()
{
var select_elem = document.getElementById(\'drafts_autosave_frequency\');
select_elem.disabled = !autosave.checked;
}
';
// Final settings...
$context['post_url'] = $scripturl . '?action=admin;area=managedrafts;save';
$context['settings_title'] = $txt['managedrafts_settings'];
// Prepare the settings...
prepareDBSettingContext($config_vars);
}
?>