{

global $db, $config, $user, $template, $phpEx;

$sql = 'SELECT *

FROM phpbb_forum_access

WHERE forum_id = ' . $forum_data['forum_id'] . '

switch ($errno)

{

case E_WARNING:

case E_NOTICE:

if (defined('DEBUG_EXTRA'))

{

}

break;

{

case 'forum':

$sql_select_add = ', f.forum_parents';

$sql_table_add = ', ' . FORUMS_TABLE . ' f';

$sql_update_table = FORUMS_TABLE;

break;

case 'topic':

$sql_select_add = '';

$sql_table_add = '';

$sql_update_table = TOPICS_TABLE;

break;

default:

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

$db->sql_freeresult($result);

$update_sql = array(

);

$db->sql_query($sql);

}

}

// Fulltext parse

{

$result = $search->add($mode, $post_data['post_id'], $message, $subject);

}

// Sync forums, topics and users ...

if ($mode != 'edit')

{

$forum_topics_sql = ($mode == 'post') ? ', forum_topics = forum_topics + 1, forum_topics_real = forum_topics_real + 1' : '';

$forum_sql = array(

'forum_last_post_id' => $post_data['post_id'],

'forum_last_poster_name'=> ($user->data['user_id'] == ANONYMOUS) ? stripslashes($username) : $user->data['username'],

);

$db->sql_query($sql);

// Update topic: first/last post info, replies

}

$topic_replies_sql = ($mode == 'reply' || $mode == 'quote') ? ', topic_replies = topic_replies + 1, topic_replies_real = topic_replies_real + 1' : '';

$db->sql_query($sql);

// Update user post count ... if appropriate

}

// Topic Notification

{

$sql = "INSERT INTO " . TOPICS_WATCH_TABLE . " (user_id, topic_id)

VALUES (" . $user->data['user_id'] . ", " . $post_data['topic_id'] . ")";

$db->sql_query($sql);

}

{

$sql = "DELETE FROM " . TOPICS_WATCH_TABLE . "

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

$db->sql_transaction('commit');

// Send Notifications

{

user_notification($mode, stripslashes($post_data['subject']), $post_data['forum_id'], $post_data['topic_id'], $post_data['post_id']);

}

$message = ($auth->acl_get('f_moderate', $post_data['forum_id']) && !$auth->acl_get('f_ignorequeue', $post_data['forum_id'])) ? 'POST_STORED_MOD' : 'POST_STORED';

$message = $user->lang[$message] . '<br /><br />' . sprintf($user->lang['VIEW_MESSAGE'], '<a href="viewtopic.' . $phpEx . $SID .'&p=' . $post_data['post_id'] . '#' . $post_data['post_id'] . '">', '</a>') . '<br /><br />' . sprintf($user->lang['RETURN_FORUM'], '<a href="viewforum.' . $phpEx . $SID .'&amp;f=' . $post_data['forum_id'] . '">', '</a>');

}

// Smiley check

{

$sql = "SELECT code

FROM " . SMILIES_TABLE;

$str_to = array('&#91;', '&#93;', '&#46;');

$out .= "[code=$stx:" . $this->bbcode_uid . ']' . str_replace($str_from, $str_to, $code) . '[/code:' . $this->bbcode_uid . ']';

default:

$str_from = array('<', '>', '[', ']', '.');

$out .= $tag . ']';

$tok = '[';

}

{

// sub-list, add a closing tag

array_push($close_tags, (($m[1]) ? '/list:o:' . $this->bbcode_uid : '/list:u:' . $this->bbcode_uid));

$words = array();

if ($mode == 'edit')

{

FROM " . SEARCH_WORD_TABLE . " w, " . SEARCH_MATCH_TABLE . " m

WHERE m.post_id = " . intval($post_id) . "

AND w.word_id = m.word_id";

INSERT INTO phpbb_config (config_name, config_value) VALUES ('pm_max_msgs','50');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('edit_time','0');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_email_sig','Thanks, The Management');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_delivery','0');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_host','');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_port','25');

Subject: {SITENAME} - Email a friend

Charset: iso-8859-1

{TOPIC_NAME}

'ALL_TOPICS' => 'All Topics',

'MARK_TOPICS_READ' => 'Mark all topics read',

'TOPICS_MARKED' => 'The topics for this forum have now been marked read',

'SEND_EMAIL' => 'Send Email',

'NO_EMAIL' => 'You are not permitted to send email to this user.',

'CC_EMAIL' => 'Send a copy of this email to yourself',

'EMAIL_SENT' => 'The email has been sent.',

'EMAIL_BODY_EXPLAIN' => 'This message will be sent as plain text, do not include any HTML or BBCode. The return address for this message will be set to your email address.',

'FLOOD_EMAIL_LIMIT' => 'You cannot send another email at this time. Please try again later.',

'EMPTY_SUBJECT_EMAIL' => 'You must specify a subject for the email.',

'EMPTY_MESSAGE_EMAIL' => 'You must enter a message to be emailed.',

'NO_VIEW_USERS' => 'You are not authorised to view the member list or profiles.',

'VIEWING_PROFILE' => 'Profile view',

// Grab data

$mode = (isset($_REQUEST['mode'])) ? htmlspecialchars($_REQUEST['mode']) : '';

$user_id = (isset($_GET['u'])) ? intval($_GET['u']) : ANONYMOUS;

switch ($mode)

$page_title = $user->lang['SEND_EMAIL'];

$template_html = 'memberlist_email.html';

{

trigger_error($user->lang['NO_EMAIL']);

}

{

trigger_error($user->lang['NO_EMAIL']);

}

trigger_error($lang['FLOOD_EMAIL_LIMIT']);

}

{

{

}

{

}

{

}

else

{

}

{

$sql = "UPDATE " . USERS_TABLE . "

SET user_emailtime = " . time() . "

include($phpbb_root_path . 'includes/emailer.'.$phpEx);

$emailer = new emailer();

$emailer->subject($subject);

$emailer->replyto($user->data['user_email']);

if (!empty($_POST['cc_email']))

{

$emailer->cc($user->data['user_email'], $user->data['username']);

}

$emailer->headers('X-AntiAbuse: User_id - ' . $user->data['user_id']);

$emailer->headers('X-AntiAbuse: Username - ' . $user->data['username']);

$emailer->headers('X-AntiAbuse: User IP - ' . $user->ip);

'SITENAME' => $config['sitename'],

'BOARD_EMAIL' => $config['board_contact'],

'FROM_USERNAME' => $user->data['username'],

);

$emailer->send();

$emailer->reset();

}

}

$template->assign_vars(array(

);

break;

WHERE t.topic_id = " . $topic_id . "

AND f.forum_id = t.forum_id";

break;

case 'quote':

AND t.topic_id = p.topic_id

AND u.user_id = p.poster_id

AND f.forum_id = t.forum_id";

break;

case 'topicreview':

include($phpbb_root_path . 'includes/functions_admin.' . $phpEx);

$topic_sql = array();

$topic_update_sql = 'topic_replies = topic_replies - 1, topic_replies_real = topic_replies_real - 1';

// User tries to delete the post twice ? Exit... we do not want the topics table screwed up.

$forum_update_sql .= 'forum_topics = forum_topics - 1, forum_topics_real = forum_topics_real - 1';

}

// Sync last post informations

$db->sql_transaction();

update_last_post_information('topic', $topic_id);

}

update_last_post_information('forum', $forum_id);

$db->sql_transaction('commit');

if ($post_data['topic_first_post_id'] == $post_data['topic_last_post_id'])

{

$message = $user->lang['DELETED'];

}

else

{

}

trigger_error($message);

}

else

$topic_cur_post_id = (isset($_POST['topic_cur_post_id'])) ? intval($_POST['topic_cur_post_id']) : false;

$subject = (!empty($_POST['subject'])) ? trim(htmlspecialchars(strip_tags($_POST['subject']))) : '';

{

$subject = phpbb_strtolower($subject);

}

$enable_smilies = ($config['allow_smilies'] && empty($_POST['disable_smilies']) && $auth->acl_get('f_smilies', $forum_id)) ? TRUE : FALSE;

$enable_sig = ($config['allow_sig'] && !empty($_POST['attach_sig']) && $auth->acl_get('f_sigs', $forum_id)) ? TRUE : FALSE;

*/

$enable_urls = (isset($_POST['disable_magic_url'])) ? 0 : 1;

$notify = (!empty($_POST['notify'])) ? true : false;

$topic_lock = (isset($_POST['lock_topic'])) ? true : false;

WHERE topic_id = ' . $topic_id;

$db->sql_query($sql);

}

else

{

$auth_option = '';

switch ($topic_type)

{

break;

case POST_ANNOUNCE:

$auth_option = 'announce';

$template->assign_vars(array(

'S_HAS_POLL_OPTIONS' => (sizeof($poll_options)) ? true : false,

);

foreach ($poll_options as $option)

</tr>

<!-- IF ERROR_MESSAGE neq '' -->

<tr>

</tr>

<!-- ENDIF -->

<tr>

</tr>

<tr>

</tr>

<tr>

<td class="row1" valign="top"><b class="gen">{L_MESSAGE_BODY}</b><br /><span class="gensmall">{L_EMAIL_BODY_EXPLAIN}</span></td>

</tr>

<tr>

<td class="row1" valign="top"><span class="gen"><b>{L_OPTIONS}</b></span></td>

'U_VIEW_OLDER_TOPIC' => $view_prev_topic_url,

'U_VIEW_NEWER_TOPIC' => $view_next_topic_url,

'U_PRINT_TOPIC' => "viewtopic.$phpEx$SID&amp;f=$forum_id&amp;t=$topic_id&amp;$u_sort_param&amp;view=print",

'U_POST_NEW_TOPIC' => $new_topic_url,

'U_POST_REPLY_TOPIC' => $reply_topic_url)

}

}

{

$user_cache[$poster_id]['email_img'] = '<a href="' . $email_url . '">' . $user->img('btn_email', $user->lang['SEND_EMAIL']) . '</a>';

$user_cache[$poster_id]['email'] = '<a href="' . $email_url . '">' . $user->lang['SEND_EMAIL'] . '</a>';

}