session_begin();
$auth->acl($user->data);
$user->setup();
// End session management
if (!$config['allow_drafts'])
{
message_die(GENERAL_MESSAGE, $lang['Not_Auth_View']);
}
$mode = request_var('mode', '', true);
$mode = check_var_value($mode, array('loadr', 'loadn', 'loadp', 'delete'), '');
if (!empty($_POST['kill_drafts']))
{
$mode = 'delete';
}
$start = request_var('start', 0);
$start = ($start < 0) ? 0 : $start;
if (!$user->data['session_logged_in'])
{
$redirect = (isset($start)) ? ('&start=' . $start) : '';
redirect(append_sid(CMS_PAGE_LOGIN . '?redirect=drafts.' . PHP_EXT . $redirect, true));
}
$draft_id = request_var('d', 0);
$draft_id = ($draft_id < 0) ? 0 : $draft_id;
if (($draft_id > 0) || !empty($_POST['kill_drafts']))
{
if ($mode == 'loadr')
{
redirect(append_sid(CMS_PAGE_POSTING . '?d=' . $draft_id . '&mode=reply' . '&draft_mode=draft_load', true));
}
elseif ($mode == 'loadn')
{
redirect(append_sid(CMS_PAGE_POSTING . '?d=' . $draft_id . '&mode=newtopic' . '&draft_mode=draft_load', true));
}
elseif ($mode == 'loadp')
{
redirect(append_sid(CMS_PAGE_PRIVMSG . '?d=' . $draft_id . '&mode=post' . '&draft_mode=draft_load', true));
}
elseif ($mode == 'delete')
{
if(!isset($_POST['confirm']))
{
$nav_server_url = create_server_url();
$breadcrumbs['address'] = $lang['Nav_Separator'] . '' . $lang['Profile'] . '' . $lang['Nav_Separator'] . '' . $lang['Drafts'] . '';
$ref_url = explode('/', $_SERVER['HTTP_REFERER']);
$s_hidden_fields = '';
if (is_array($_POST['drafts_list']))
{
for ($i = 0; $i < sizeof($_POST['drafts_list']); $i++)
{
$s_hidden_fields .= '';
}
$s_hidden_fields .= '';
}
$s_hidden_fields .= '';
$s_hidden_fields .= '';
$s_hidden_fields .= '';
$template->assign_vars(array(
'MESSAGE_TITLE' => $lang['Confirm'],
'MESSAGE_TEXT' => $lang['Drafts_Delete_Question'],
'L_YES' => $lang['Yes'],
'L_NO' => $lang['No'],
'S_CONFIRM_ACTION' => append_sid('drafts.' . PHP_EXT),
'S_HIDDEN_FIELDS' => $s_hidden_fields
)
);
full_page_generation('confirm_body.tpl', $lang['Drafts'], '', '');
}
else
{
if (is_array($_POST['drafts_list']))
{
$draft_ids = implode(',', $_POST['drafts_list']);
$sql_del = "DELETE FROM " . DRAFTS_TABLE . " WHERE draft_id IN (" . $draft_ids . ")";
$result_del = $db->sql_query($sql_del);
}
else
{
$sql_del = "DELETE FROM " . DRAFTS_TABLE . " WHERE draft_id = '" . $draft_id . "'";
$result_del = $db->sql_query($sql_del);
}
}
}
}
// Generate the page
$nav_server_url = create_server_url();
$breadcrumbs['address'] = $lang['Nav_Separator'] . '' . $lang['Profile'] . '' . $lang['Nav_Separator'] . '' . $lang['Drafts'] . '';
$breadcrumbs['bottom_right_links'] = '' . $lang['Mark_all'] . ' • ' . $lang['Unmark_all'] . '';
include_once(IP_ROOT_PATH . 'includes/users_zebra_block.' . PHP_EXT);
$template->assign_vars(array(
'S_FORM_ACTION' => append_sid('drafts.' . PHP_EXT),
'L_NO_DRAFTS' => $lang['Drafts_No_Drafts'],
'L_DRAFTS_CATEGORY' => $lang['Category'],
'L_DRAFTS_TYPE' => $lang['Drafts_Type'],
'L_DRAFTS_SUBJECT' => $lang['Drafts_Subject'],
'L_DRAFTS_ACTION' => $lang['Drafts_Action'],
'L_DRAFTS_DELETE_SEL' => $lang['Drafts_Delete_Sel'],
'L_DRAFTS_LOAD' => $lang['Drafts_Load'],
'L_DRAFTS_DELETE' => $lang['Delete'],
'L_CHECK_ALL' => $lang['Check_All'],
'L_UNCHECK_ALL' => $lang['UnCheck_All'],
)
);
$sql = "SELECT COUNT(*) as drafts_count FROM " . DRAFTS_TABLE . " d WHERE d.user_id = " . $user->data['user_id'];
$result = $db->sql_query($sql);
$row = $db->sql_fetchrow($result);
$drafts_count = ($row['drafts_count']) ? $row['drafts_count'] : 0;
$db->sql_freeresult($result);
$no_drafts = ($drafts_count == 0) ? true : false;
//die(($no_drafts == false) ? 'FALSE' : 'TRUE');
if ($no_drafts == false)
{
$sql = "SELECT d.*
FROM " . DRAFTS_TABLE . " d
WHERE d.user_id = '" . $user->data['user_id'] . "'
ORDER BY d.save_time DESC
LIMIT $start, " . $config['topics_per_page'];
$result = $db->sql_query($sql);
$draft_row = $db->sql_fetchrowset($result);
$db->sql_freeresult($result);
for ($i = 0; $i < sizeof($draft_row); $i++)
{
if ($i == 0)
{
$template->assign_block_vars('switch_drafts', array());
}
$draft_row[$i]['draft_cat'] = '';
$draft_row[$i]['draft_title'] = '';
$draft_load = '';
$draft_type = '';
$draft_cat_link = '';
$draft_title_link = '';
if ($draft_row[$i]['topic_id'] != 0)
{
$sql_d = "SELECT t.*, f.*
FROM " . TOPICS_TABLE . " t,
" . FORUMS_TABLE . " f
WHERE t.topic_id = '" . $draft_row[$i]['topic_id'] . "'
AND f.forum_id = t.forum_id
LIMIT 1";
$result_d = $db->sql_query($sql_d);
$draft_row_data = $db->sql_fetchrow($result_d);
$db->sql_freeresult($result_d);
$draft_image = '';
$draft_type = $lang['Drafts_NM'];
$draft_load = 'loadr';
$draft_cat_link = append_sid(IP_ROOT_PATH . CMS_PAGE_VIEWFORUM . '?' . POST_FORUM_URL . '=' . $draft_row_data['forum_id']);
$draft_title_link = append_sid(IP_ROOT_PATH . CMS_PAGE_VIEWTOPIC . '?' . POST_TOPIC_URL . '=' . $draft_row[$i]['topic_id']);
$draft_row[$i]['draft_cat'] = '' . $draft_row_data['forum_name'] . '';
$draft_row[$i]['draft_title'] = '' . $draft_row_data['topic_title'] . '';
}
elseif ($draft_row[$i]['forum_id'] != 0)
{
$sql_d = "SELECT f.*
FROM " . FORUMS_TABLE . " f
WHERE f.forum_id = '" . $draft_row[$i]['forum_id'] . "'
LIMIT 1";
$result_d = $db->sql_query($sql_d);
$draft_row_data = $db->sql_fetchrow($result_d);
$db->sql_freeresult($result_d);
$draft_image = '';
$draft_type = $lang['Drafts_NT'];
$draft_load = 'loadn';
$draft_cat_link = append_sid(IP_ROOT_PATH . CMS_PAGE_VIEWFORUM . '?' . POST_FORUM_URL . '=' . $draft_row_data['forum_id']);
$draft_title_link = append_sid(IP_ROOT_PATH . 'drafts.' . PHP_EXT . '?mode=' . $draft_load . '&d=' . $draft_row[$i]['draft_id']);
$draft_row[$i]['draft_cat'] = '' . $draft_row_data['forum_name'] . '';
$draft_row[$i]['draft_title'] = '' . $draft_row[$i]['draft_subject'] . '';
}
else
{
$draft_image = '';
$draft_type = $lang['Drafts_NPM'];
$draft_load = 'loadp';
$draft_cat_link = append_sid(IP_ROOT_PATH . CMS_PAGE_PRIVMSG);
$draft_title_link = append_sid(IP_ROOT_PATH . 'drafts.' . PHP_EXT . '?mode=' . $draft_load . '&d=' . $draft_row[$i]['draft_id']);
$draft_row[$i]['draft_cat'] = '' . $lang['Drafts_NPM'] . '';
$draft_row[$i]['draft_title'] = '' . $draft_row[$i]['draft_subject'] . '';
}
$row_class = (!($i % 2)) ? $theme['td_class1'] : $theme['td_class2'];
$template->assign_block_vars('draft_row', array(
'ROW_CLASS' => $row_class,
'S_DRAFT_ID' => $draft_row[$i]['draft_id'],
'DRAFT_IMG' => $draft_image,
'DRAFT_TYPE' => $draft_type,
'DRAFT_CAT_LINK' => $draft_cat_link,
'DRAFT_CAT' => $draft_row[$i]['draft_cat'],
'DRAFT_TITLE_LINK' => $draft_title_link,
'DRAFT_TITLE' => $draft_row[$i]['draft_title'],
'DRAFT_TIME' => create_date_ip($config['default_dateformat'], $draft_row[$i]['save_time'], $config['board_timezone']),
'U_DRAFT_LOAD' => append_sid(IP_ROOT_PATH . 'drafts.' . PHP_EXT . '?mode=' . $draft_load . '&d=' . $draft_row[$i]['draft_id']),
'U_DRAFT_DELETE' => append_sid(IP_ROOT_PATH . 'drafts.' . PHP_EXT . '?mode=delete&d=' . $draft_row[$i]['draft_id']),
)
);
}
$pagination = generate_pagination('drafts.' . PHP_EXT . '?mode=list', $drafts_count, $config['topics_per_page'], $start);
$template->assign_vars(array(
'PAGINATION' => $pagination,
'PAGE_NUMBER' => sprintf($lang['Page_of'], (floor($start / $config['topics_per_page']) + 1), ceil($drafts_count / $config['topics_per_page'])),
'L_GOTO_PAGE' => $lang['Goto_page']
)
);
}
else
{
$template->assign_block_vars('switch_no_drafts', array());
}
full_page_generation('drafts_body.tpl', $lang['Drafts'], '', '');
?>