<?php

/**

*

* This file is part of the phpBB Forum Software package.

*

* @copyright (c) phpBB Limited <https://www.phpbb.com>

* @license GNU General Public License, version 2 (GPL-2.0)

*

* For full copyright and license information, please see

* the docs/CREDITS.txt file.

*

*/

/**

* @ignore

*/

if (!defined('IN_PHPBB'))

{

exit;

}

/**

* Fill smiley templates (or just the variables) with smilies, either in a window or inline

*/

function generate_smilies($mode, $forum_id)

{

global $db, $user, $config, $template, $phpbb_dispatcher, $request;

global $phpEx, $phpbb_root_path, $phpbb_container, $phpbb_path_helper;

/* @var $pagination \phpbb\pagination */

$pagination = $phpbb_container->get('pagination');

$base_url = append_sid("{$phpbb_root_path}posting.$phpEx", 'mode=smilies&amp;f=' . $forum_id);

$start = $request->variable('start', 0);

if ($mode == 'window')

{

if ($forum_id)

{

$sql = 'SELECT forum_style

FROM ' . FORUMS_TABLE . "

WHERE forum_id = $forum_id";

$result = $db->sql_query_limit($sql, 1);

$row = $db->sql_fetchrow($result);

$db->sql_freeresult($result);

$user->setup('posting', (int) $row['forum_style']);

}

else

{

$user->setup('posting');

}

page_header($user->lang['SMILIES']);

$sql_ary = [

'SELECT' => 'COUNT(s.smiley_id) AS item_count',

'FROM' => [

SMILIES_TABLE => 's',

],

'GROUP_BY' => 's.smiley_url',

];

/**

* Modify SQL query that fetches the total number of smilies in window mode

*

* @event core.generate_smilies_count_sql_before

* @var int forum_id Forum where smilies are generated

* @var array sql_ary Array with the SQL query

* @var string base_url URL for the "More smilies" link and its pagination

* @since 3.2.9-RC1

* @changed 3.2.10-RC1 Added base_url

*/

$vars = [

'forum_id',

'sql_ary',

'base_url',

];

extract($phpbb_dispatcher->trigger_event('core.generate_smilies_count_sql_before', compact($vars)));

$sql = $db->sql_build_query('SELECT', $sql_ary);

$result = $db->sql_query($sql, 3600);

$smiley_count = 0;

while ($row = $db->sql_fetchrow($result))

{

++$smiley_count;

}

$db->sql_freeresult($result);

$template->set_filenames(array(

'body' => 'posting_smilies.html')

);

$start = $pagination->validate_start($start, $config['smilies_per_page'], $smiley_count);

$pagination->generate_template_pagination($base_url, 'pagination', 'start', $smiley_count, $config['smilies_per_page'], $start);

}

$display_link = false;

if ($mode == 'inline')

{

$sql = 'SELECT smiley_id

FROM ' . SMILIES_TABLE . '

WHERE display_on_posting = 0';

$result = $db->sql_query_limit($sql, 1, 0, 3600);

if ($row = $db->sql_fetchrow($result))

{

$display_link = true;

}

$db->sql_freeresult($result);

}

if ($mode == 'window')

{

$sql_ary = [

'SELECT' => 's.smiley_url, MIN(s.emotion) AS emotion, MIN(s.code) AS code, s.smiley_width, s.smiley_height, MIN(s.smiley_order) AS min_smiley_order',

'FROM' => [

SMILIES_TABLE => 's',

],

'GROUP_BY' => 's.smiley_url, s.smiley_width, s.smiley_height',

'ORDER_BY' => $db->sql_quote('min_smiley_order'),

];

}

else

{

$sql_ary = [

'SELECT' => 's.*',

'FROM' => [

SMILIES_TABLE => 's',

],

'WHERE' => 's.display_on_posting = 1',

'ORDER_BY' => 's.smiley_order',

];

}

/**

* Modify the SQL query that fetches the smilies

*

* @event core.generate_smilies_modify_sql

* @var string mode Smiley mode, either window or inline

* @var int forum_id Forum where smilies are generated, or 0 if composing a private message

* @var array sql_ary Array with SQL query data

* @since 3.2.10-RC1

* @since 3.3.1-RC1

*/

$vars = [

'mode',

'forum_id',

'sql_ary',

];

extract($phpbb_dispatcher->trigger_event('core.generate_smilies_modify_sql', compact($vars)));

$sql = $db->sql_build_query('SELECT', $sql_ary);

if ($mode == 'window')

{

$result = $db->sql_query_limit($sql, $config['smilies_per_page'], $start, 3600);

}

else

{

$result = $db->sql_query($sql, 3600);

}

$smilies = array();

while ($row = $db->sql_fetchrow($result))

{

if (empty($smilies[$row['smiley_url']]))

{

$smilies[$row['smiley_url']] = $row;

}

}

$db->sql_freeresult($result);

/**

* Modify smilies before they are assigned to the template

*

* @event core.generate_smilies_modify_rowset

* @var string mode Smiley mode, either window or inline

* @var int forum_id Forum where smilies are generated, or 0 if composing a private message

* @var array smilies Smiley rows fetched from the database

* @since 3.2.9-RC1

*/

$vars = [

'mode',

'forum_id',

'smilies',

];

extract($phpbb_dispatcher->trigger_event('core.generate_smilies_modify_rowset', compact($vars)));

if (count($smilies))

{

$root_path = $phpbb_path_helper->get_web_root_path();

foreach ($smilies as $row)

{

/**

* Modify smiley root path before populating smiley list

*

* @event core.generate_smilies_before

* @var string root_path root_path for smilies

* @since 3.1.11-RC1

*/

$vars = array('root_path');

extract($phpbb_dispatcher->trigger_event('core.generate_smilies_before', compact($vars)));

$template->assign_block_vars('smiley', array(

'SMILEY_CODE' => $row['code'],

'A_SMILEY_CODE' => addslashes($row['code']),

'SMILEY_IMG' => $root_path . $config['smilies_path'] . '/' . $row['smiley_url'],

'SMILEY_WIDTH' => $row['smiley_width'],

'SMILEY_HEIGHT' => $row['smiley_height'],

'SMILEY_DESC' => $row['emotion'])

);

}

}

/**

* This event is called after the smilies are populated

*

* @event core.generate_smilies_after

* @var string mode Mode of the smilies: window|inline

* @var int forum_id The forum ID we are currently in

* @var bool display_link Shall we display the "more smilies" link?

* @var string base_url URL for the "More smilies" link and its pagination

* @since 3.1.0-a1

* @changed 3.2.10-RC1 Added base_url

*/

$vars = [

'mode',

'forum_id',

'display_link',

'base_url',

];

extract($phpbb_dispatcher->trigger_event('core.generate_smilies_after', compact($vars)));

if ($mode == 'inline' && $display_link)

{

$template->assign_vars(array(

'S_SHOW_SMILEY_LINK' => true,

'U_MORE_SMILIES' => $base_url,

));

}

if ($mode == 'window')

{

page_footer();

}

}

/**

* Update last post information

* Should be used instead of sync() if only the last post information are out of sync... faster

*

* @param string $type Can be forum|topic

* @param mixed $ids topic/forum ids

* @param bool $return_update_sql true: SQL query shall be returned, false: execute SQL

* @return array|null SQL query, null otherwise

*/

function update_post_information($type, $ids, $return_update_sql = false)

{

global $db, $phpbb_dispatcher;

if (empty($ids))

{

return;

}

if (!is_array($ids))

{

$ids = array($ids);

}

$update_sql = $empty_forums = $not_empty_forums = array();

if ($type != 'topic')

{

$topic_join = ', ' . TOPICS_TABLE . ' t';

$topic_condition = 'AND t.topic_id = p.topic_id AND t.topic_visibility = ' . ITEM_APPROVED;

}

else

{

$topic_join = '';

$topic_condition = '';

}

if (count($ids) == 1)

{

$sql = 'SELECT p.post_id as last_post_id

FROM ' . POSTS_TABLE . " p $topic_join

WHERE " . $db->sql_in_set('p.' . $type . '_id', $ids) . "

$topic_condition

AND p.post_visibility = " . ITEM_APPROVED . "

ORDER BY p.post_id DESC";

$result = $db->sql_query_limit($sql, 1);

}

else

{

$sql = 'SELECT p.' . $type . '_id, MAX(p.post_id) as last_post_id

FROM ' . POSTS_TABLE . " p $topic_join

WHERE " . $db->sql_in_set('p.' . $type . '_id', $ids) . "

$topic_condition

AND p.post_visibility = " . ITEM_APPROVED . "

GROUP BY p.{$type}_id";

$result = $db->sql_query($sql);

}

$last_post_ids = array();

while ($row = $db->sql_fetchrow($result))

{

if (count($ids) == 1)

{

$row[$type . '_id'] = $ids[0];

}

if ($type == 'forum')

{

$not_empty_forums[] = $row['forum_id'];

if (empty($row['last_post_id']))

{

$empty_forums[] = $row['forum_id'];

}

}

$last_post_ids[] = $row['last_post_id'];

}

$db->sql_freeresult($result);

if ($type == 'forum')

{

$empty_forums = array_merge($empty_forums, array_diff($ids, $not_empty_forums));

foreach ($empty_forums as $forum_id)

{

$update_sql[$forum_id][] = 'forum_last_post_id = 0';

$update_sql[$forum_id][] = "forum_last_post_subject = ''";

$update_sql[$forum_id][] = 'forum_last_post_time = 0';

$update_sql[$forum_id][] = 'forum_last_poster_id = 0';

$update_sql[$forum_id][] = "forum_last_poster_name = ''";

$update_sql[$forum_id][] = "forum_last_poster_colour = ''";

}

}

if (count($last_post_ids))

{

$sql_ary = array(

'SELECT' => 'p.' . $type . '_id, p.post_id, p.post_subject, p.post_time, p.poster_id, p.post_username, u.user_id, u.username, u.user_colour',

'FROM' => array(

POSTS_TABLE => 'p',

USERS_TABLE => 'u',

),

'WHERE' => $db->sql_in_set('p.post_id', $last_post_ids) . '

AND p.poster_id = u.user_id',

);

/**

* Event to modify the SQL array to get the post and user data from all last posts

*

* @event core.update_post_info_modify_posts_sql

* @var string type The table being updated (forum or topic)

* @var array sql_ary SQL array to get some of the last posts' data

* @since 3.3.5-RC1

*/

$vars = [

'type',

'sql_ary',

];

extract($phpbb_dispatcher->trigger_event('core.update_post_info_modify_posts_sql', compact($vars)));

$result = $db->sql_query($db->sql_build_query('SELECT', $sql_ary));

$rowset = array();

while ($row = $db->sql_fetchrow($result))

{

$rowset[] = $row;

$update_sql[$row["{$type}_id"]][] = $type . '_last_post_id = ' . (int) $row['post_id'];

$update_sql[$row["{$type}_id"]][] = "{$type}_last_post_subject = '" . $db->sql_escape($row['post_subject']) . "'";

$update_sql[$row["{$type}_id"]][] = $type . '_last_post_time = ' . (int) $row['post_time'];

$update_sql[$row["{$type}_id"]][] = $type . '_last_poster_id = ' . (int) $row['poster_id'];

$update_sql[$row["{$type}_id"]][] = "{$type}_last_poster_colour = '" . $db->sql_escape($row['user_colour']) . "'";

$update_sql[$row["{$type}_id"]][] = "{$type}_last_poster_name = '" . (($row['poster_id'] == ANONYMOUS) ? $db->sql_escape($row['post_username']) : $db->sql_escape($row['username'])) . "'";

}

$db->sql_freeresult($result);

/**

* Event to modify the update_sql array to add new update data for forum or topic last posts

*

* @event core.update_post_info_modify_sql

* @var string type The table being updated (forum or topic)

* @var array rowset Array with the posts data

* @var array update_sql Array with SQL data to update the forums or topics table with

* @since 3.3.5-RC1

*/

$vars = [

'type',

'rowset',

'update_sql',

];

extract($phpbb_dispatcher->trigger_event('core.update_post_info_modify_sql', compact($vars)));

unset($rowset);

}

unset($empty_forums, $ids, $last_post_ids);

if ($return_update_sql || !count($update_sql))

{

return $update_sql;

}

$table = ($type == 'forum') ? FORUMS_TABLE : TOPICS_TABLE;

foreach ($update_sql as $update_id => $update_sql_ary)

{

$sql = "UPDATE $table

SET " . implode(', ', $update_sql_ary) . "

WHERE {$type}_id = $update_id";

$db->sql_query($sql);

}

return null;

}

/**

* Generate Topic Icons for display

*/

function posting_gen_topic_icons($mode, $icon_id)

{

global $phpbb_root_path, $phpbb_path_helper, $config, $template, $cache;

// Grab icons

$icons = $cache->obtain_icons();

if (!$icon_id)

{

$template->assign_var('S_NO_ICON_CHECKED', ' checked="checked"');

}

if (count($icons))

{

$root_path = $phpbb_path_helper->get_web_root_path();

foreach ($icons as $id => $data)

{

if ($data['display'])

{

$template->assign_block_vars('topic_icon', array(

'ICON_ID' => $id,

'ICON_IMG' => $root_path . $config['icons_path'] . '/' . $data['img'],

'ICON_WIDTH' => $data['width'],

'ICON_HEIGHT' => $data['height'],

'ICON_ALT' => $data['alt'],

'S_CHECKED' => ($id == $icon_id) ? true : false,

'S_ICON_CHECKED' => ($id == $icon_id) ? ' checked="checked"' : '')

);

}

}

return true;

}

return false;

}

/**

* Build topic types able to be selected

*/

function posting_gen_topic_types($forum_id, $cur_topic_type = POST_NORMAL)

{

global $auth, $user, $template;

$toggle = false;

$topic_types = array(

'sticky' => array('const' => POST_STICKY, 'lang' => 'POST_STICKY'),

'announce' => array('const' => POST_ANNOUNCE, 'lang' => 'POST_ANNOUNCEMENT'),

'announce_global' => array('const' => POST_GLOBAL, 'lang' => 'POST_GLOBAL')

);

$topic_type_array = array();

foreach ($topic_types as $auth_key => $topic_value)

{

if ($auth->acl_get('f_' . $auth_key, $forum_id))

{

$toggle = true;

$topic_type_array[] = array(

'VALUE' => $topic_value['const'],

'S_CHECKED' => ($cur_topic_type == $topic_value['const']) ? ' checked="checked"' : '',

'L_TOPIC_TYPE' => $user->lang[$topic_value['lang']]

);

}

}

if ($toggle)

{

$topic_type_array = array_merge(array(0 => array(

'VALUE' => POST_NORMAL,

'S_CHECKED' => ($cur_topic_type == POST_NORMAL) ? ' checked="checked"' : '',

'L_TOPIC_TYPE' => $user->lang['POST_NORMAL'])),

$topic_type_array

);

foreach ($topic_type_array as $array)

{

$template->assign_block_vars('topic_type', $array);

}

$template->assign_vars(array(

'S_TOPIC_TYPE_STICKY' => ($auth->acl_get('f_sticky', $forum_id)),

'S_TOPIC_TYPE_ANNOUNCE' => ($auth->acl_gets('f_announce', 'f_announce_global', $forum_id)),

));

}

return $toggle;

}

//

// Attachment related functions

//

/**

* Calculate the needed size for Thumbnail

*/

function get_img_size_format($width, $height)

{

global $config;

// Maximum Width the Image can take

$max_width = ($config['img_max_thumb_width']) ? $config['img_max_thumb_width'] : 400;

if ($width > $height)

{

return array(

round($width * ($max_width / $width)),

round($height * ($max_width / $width))

);

}

else

{

return array(

round($width * ($max_width / $height)),

round($height * ($max_width / $height))

);

}

}

/**

* Return supported image types

*/

function get_supported_image_types($type = false)

{

if (@extension_loaded('gd'))

{

$format = imagetypes();

$new_type = 0;

if ($type !== false)

{

// Type is one of the IMAGETYPE constants - it is fetched from getimagesize()

switch ($type)

{

// GIF

case IMAGETYPE_GIF:

$new_type = ($format & IMG_GIF) ? IMG_GIF : false;

break;

// JPG, JPC, JP2

case IMAGETYPE_JPEG:

case IMAGETYPE_JPC:

case IMAGETYPE_JPEG2000:

case IMAGETYPE_JP2:

case IMAGETYPE_JPX:

case IMAGETYPE_JB2:

$new_type = ($format & IMG_JPG) ? IMG_JPG : false;

break;

// PNG

case IMAGETYPE_PNG:

$new_type = ($format & IMG_PNG) ? IMG_PNG : false;

break;

// WBMP

case IMAGETYPE_WBMP:

$new_type = ($format & IMG_WBMP) ? IMG_WBMP : false;

break;

// WEBP

case IMAGETYPE_WEBP:

$new_type = ($format & IMG_WEBP) ? IMG_WEBP : false;

break;

}

}

else

{

$new_type = [];

$go_through_types = [IMG_GIF, IMG_JPG, IMG_PNG, IMG_WBMP, IMG_WEBP];

foreach ($go_through_types as $check_type)

{

if ($format & $check_type)

{

$new_type[] = $check_type;

}

}

}

return [

'gd' => ($new_type) ? true : false,

'format' => $new_type,

'version' => (function_exists('imagecreatetruecolor')) ? 2 : 1

];

}

return ['gd' => false];

}

/**

* Create Thumbnail

*/

function create_thumbnail($source, $destination, $mimetype)

{

global $config, $phpbb_filesystem, $phpbb_dispatcher;

$min_filesize = (int) $config['img_min_thumb_filesize'];

$img_filesize = (file_exists($source)) ? @filesize($source) : false;

if (!$img_filesize || $img_filesize <= $min_filesize)

{

return false;

}

$dimension = @getimagesize($source);

if ($dimension === false)

{

return false;

}

list($width, $height, $type, ) = $dimension;

if (empty($width) || empty($height))

{

return false;

}

list($new_width, $new_height) = get_img_size_format($width, $height);

// Do not create a thumbnail if the resulting width/height is bigger than the original one

if ($new_width >= $width && $new_height >= $height)

{

return false;

}

$thumbnail_created = false;

/**

* Create thumbnail event to replace GD thumbnail creation with for example ImageMagick

*

* @event core.thumbnail_create_before

* @var string source Image source path

* @var string destination Thumbnail destination path

* @var string mimetype Image mime type

* @var float new_width Calculated thumbnail width

* @var float new_height Calculated thumbnail height

* @var bool thumbnail_created Set to true to skip default GD thumbnail creation

* @since 3.2.4

*/

$vars = array(

'source',

'destination',

'mimetype',

'new_width',

'new_height',

'thumbnail_created',

);

extract($phpbb_dispatcher->trigger_event('core.thumbnail_create_before', compact($vars)));

if (!$thumbnail_created)

{

$type = get_supported_image_types($type);

if ($type['gd'])

{

// If the type is not supported, we are not able to create a thumbnail

if ($type['format'] === false)

{

return false;

}

switch ($type['format'])

{

case IMG_GIF:

$image = @imagecreatefromgif($source);

break;

case IMG_JPG:

@ini_set('gd.jpeg_ignore_warning', 1);

$image = @imagecreatefromjpeg($source);

break;

case IMG_PNG:

$image = @imagecreatefrompng($source);

break;

case IMG_WBMP:

$image = @imagecreatefromwbmp($source);

break;

case IMG_WEBP:

$image = @imagecreatefromwebp($source);

break;

}

if (empty($image))

{

return false;

}

if ($type['version'] == 1)

{

$new_image = imagecreate($new_width, $new_height);

if ($new_image === false)

{

return false;

}

imagecopyresized($new_image, $image, 0, 0, 0, 0, $new_width, $new_height, $width, $height);

}

else

{

$new_image = imagecreatetruecolor($new_width, $new_height);

if ($new_image === false)

{

return false;

}

// Preserve alpha transparency (png for example)

@imagealphablending($new_image, false);

@imagesavealpha($new_image, true);

imagecopyresampled($new_image, $image, 0, 0, 0, 0, $new_width, $new_height, $width, $height);

}

switch ($type['format'])

{

case IMG_GIF:

imagegif($new_image, $destination);

break;

case IMG_JPG:

imagejpeg($new_image, $destination, 90);

break;

case IMG_PNG:

imagepng($new_image, $destination);

break;

case IMG_WBMP:

imagewbmp($new_image, $destination);

break;

case IMG_WEBP:

imagewebp($new_image, $destination);

break;

}

}

else

{

return false;

}

}

if (!file_exists($destination))

{

return false;

}

try

{

$phpbb_filesystem->phpbb_chmod($destination, \phpbb\filesystem\filesystem_interface::CHMOD_READ | \phpbb\filesystem\filesystem_interface::CHMOD_WRITE);

}

catch (\phpbb\filesystem\exception\filesystem_exception $e)

{

// Do nothing

}

return true;

}

/**

* Assign Inline attachments (build option fields)

*/

function posting_gen_inline_attachments(&$attachment_data)

{

global $template;

if (count($attachment_data))

{

$s_inline_attachment_options = '';

foreach ($attachment_data as $i => $attachment)

{

$s_inline_attachment_options .= '<option value="' . $i . '">' . utf8_basename($attachment['real_filename']) . '</option>';

}

$template->assign_var('S_INLINE_ATTACHMENT_OPTIONS', $s_inline_attachment_options);

return true;

}

return false;

}

/**

* Generate inline attachment entry

*

* @param array $attachment_data The attachment data

* @param string $filename_data The filename data (filecomment)

* @param bool $show_attach_box Whether to show the attach box

* @param mixed $forum_id The forum id to check or false if private message

* @return int

*/

function posting_gen_attachment_entry($attachment_data, &$filename_data, $show_attach_box = true, $forum_id = false)

{

global $template, $cache, $config, $user, $phpbb_dispatcher, $phpbb_container;

$allowed_attachments = array_keys($cache->obtain_attach_extensions($forum_id)['_allowed_']);

// Some default template variables

$default_vars = [

'S_SHOW_ATTACH_BOX' => $show_attach_box,

'S_HAS_ATTACHMENTS' => count($attachment_data),

'FILESIZE' => $config['max_filesize'],

'FILE_COMMENT' => (isset($filename_data['filecomment'])) ? $filename_data['filecomment'] : '',

'MAX_ATTACHMENT_FILESIZE' => $config['max_filesize'] > 0 ? $user->lang('MAX_ATTACHMENT_FILESIZE', get_formatted_filesize($config['max_filesize'])) : '',

'ALLOWED_ATTACHMENTS' => !empty($allowed_attachments) ? '.' . implode(',.', $allowed_attachments) : '',

];

/**

* Modify default attachments template vars

*

* @event core.modify_default_attachments_template_vars

* @var array allowed_attachments Array containing allowed attachments data

* @var array default_vars Array containing default attachments template vars

* @since 3.3.6-RC1

*/

$vars = ['allowed_attachments', 'default_vars'];

extract($phpbb_dispatcher->trigger_event('core.modify_default_attachments_template_vars', compact($vars)));

$template->assign_vars($default_vars);

if (count($attachment_data))

{

// We display the posted attachments within the desired order.

($config['display_order']) ? krsort($attachment_data) : ksort($attachment_data);

$attachrow_template_vars = [];

foreach ($attachment_data as $count => $attach_row)

{

$hidden = '';

$attach_row['real_filename'] = utf8_basename($attach_row['real_filename']);

foreach ($attach_row as $key => $value)

{

$hidden .= '<input type="hidden" name="attachment_data[' . $count . '][' . $key . ']" value="' . $value . '" />';

}

$download_link = $phpbb_container->get('controller.helper')

->route(

'phpbb_storage_attachment',

[

'id' => (int) $attach_row['attach_id'],

'filename' => $attach_row['real_filename'],

]

);

$attachrow_template_vars[(int) $attach_row['attach_id']] = array(

'FILENAME' => utf8_basename($attach_row['real_filename']),

'A_FILENAME' => addslashes(utf8_basename($attach_row['real_filename'])),

'FILE_COMMENT' => $attach_row['attach_comment'],

'ATTACH_ID' => $attach_row['attach_id'],

'S_IS_ORPHAN' => $attach_row['is_orphan'],

'ASSOC_INDEX' => $count,

'FILESIZE' => get_formatted_filesize($attach_row['filesize']),

'U_VIEW_ATTACHMENT' => $download_link,

'S_HIDDEN' => $hidden,

);

}

/**

* Modify inline attachments template vars

*

* @event core.modify_inline_attachments_template_vars

* @var array attachment_data Array containing attachments data

* @var array attachrow_template_vars Array containing attachments template vars

* @since 3.2.2-RC1

*/

$vars = array('attachment_data', 'attachrow_template_vars');

extract($phpbb_dispatcher->trigger_event('core.modify_inline_attachments_template_vars', compact($vars)));

$template->assign_block_vars_array('attach_row', $attachrow_template_vars);

}

return count($attachment_data);

}

//

// General Post functions

//

/**

* Load Drafts

*/

function load_drafts($topic_id = 0, $forum_id = 0, $id = 0, $pm_action = '', $msg_id = 0)

{

global $user, $db, $template, $auth;

global $phpbb_root_path, $phpbb_dispatcher, $phpEx;

$topic_ids = $draft_rows = array();

// Load those drafts not connected to forums/topics

// If forum_id == 0 AND topic_id == 0 then this is a PM draft

if (!$topic_id && !$forum_id)

{

$sql_and = ' AND d.forum_id = 0 AND d.topic_id = 0';

}

else

{

$sql_and = '';

$sql_and .= ($forum_id) ? ' AND d.forum_id = ' . (int) $forum_id : '';

$sql_and .= ($topic_id) ? ' AND d.topic_id = ' . (int) $topic_id : '';

}

$sql = 'SELECT d.*, f.forum_id, f.forum_name

FROM ' . DRAFTS_TABLE . ' d

LEFT JOIN ' . FORUMS_TABLE . ' f ON (f.forum_id = d.forum_id)

WHERE d.user_id = ' . $user->data['user_id'] . "

$sql_and

ORDER BY d.save_time DESC";

$result = $db->sql_query($sql);

while ($row = $db->sql_fetchrow($result))

{

if ($row['topic_id'])

{

$topic_ids[] = (int) $row['topic_id'];

}

$draft_rows[] = $row;

}

$db->sql_freeresult($result);

if (!count($draft_rows))

{

return;

}

$topic_rows = array();

if (count($topic_ids))

{

$sql = 'SELECT topic_id, forum_id, topic_title, topic_poster

FROM ' . TOPICS_TABLE . '

WHERE ' . $db->sql_in_set('topic_id', array_unique($topic_ids));

$result = $db->sql_query($sql);

while ($row = $db->sql_fetchrow($result))

{

$topic_rows[$row['topic_id']] = $row;

}

$db->sql_freeresult($result);

}

/**

* Drafts found and their topics

* Edit $draft_rows in order to add or remove drafts loaded

*

* @event core.load_drafts_draft_list_result

* @var array draft_rows The drafts query result. Includes its forum id and everything about the draft

* @var array topic_ids The list of topics got from the topics table

* @var array topic_rows The topics that draft_rows references

* @since 3.1.0-RC3

*/

$vars = array('draft_rows', 'topic_ids', 'topic_rows');

extract($phpbb_dispatcher->trigger_event('core.load_drafts_draft_list_result', compact($vars)));

unset($topic_ids);

$template->assign_var('S_SHOW_DRAFTS', true);

foreach ($draft_rows as $draft)

{

$link_topic = $link_forum = $link_pm = false;

$view_url = $title = '';

if (isset($topic_rows[$draft['topic_id']])

&& (

($topic_rows[$draft['topic_id']]['forum_id'] && $auth->acl_get('f_read', $topic_rows[$draft['topic_id']]['forum_id']))

||

(!$topic_rows[$draft['topic_id']]['forum_id'] && $auth->acl_getf_global('f_read'))