-* @version $Id$

-* @license http://opensource.org/licenses/gpl-license.php GNU Public License

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

- $template->assign_var('PAGINATION',

- generate_pagination(append_sid("{$phpbb_root_path}posting.$phpEx", 'mode=smilies&f=' . $forum_id),

- $smiley_count, $config['smilies_per_page'], $start, true)

- );

- $topic_condition = 'AND t.topic_id = p.topic_id AND t.topic_approved = 1';

- AND p.post_approved = 1";

- AND p.post_approved = 1

- 'S_CHECKED' => ($cur_topic_type == $topic_value['const'] || ($forum_id == 0 && $topic_value['const'] == POST_GLOBAL)) ? ' checked="checked"' : '',

- if (!$local)

- {

- $filedata['post_attach'] = ($upload->is_valid($form_name)) ? true : false;

- }

- else

- {

- $filedata['post_attach'] = true;

- }

- $cat_id = (isset($extensions[$file->get('extension')]['display_cat'])) ? $extensions[$file->get('extension')]['display_cat'] : ATTACHMENT_CATEGORY_NONE;

-

- // Do we have to create a thumbnail?

- $filedata['thumbnail'] = ($cat_id == ATTACHMENT_CATEGORY_IMAGE && $config['img_create_thumbnail']) ? 1 : 0;

-

- // Check Image Size, if it is an image

- if (!$auth->acl_get('a_') && !$auth->acl_get('m_', $forum_id) && $cat_id == ATTACHMENT_CATEGORY_IMAGE)

- {

- $file->upload->set_allowed_dimensions(0, 0, $config['img_max_width'], $config['img_max_height']);

- }

- // Admins and mods are allowed to exceed the allowed filesize

- // Are we uploading an image *and* this image being within the image category? Only then perform additional image checks.

- $no_image = ($cat_id == ATTACHMENT_CATEGORY_IMAGE) ? false : true;

- $file->move_file($config['upload_path'], false, $no_image);

- if ($cat_id == ATTACHMENT_CATEGORY_IMAGE && !$file->is_image())

- // We do not use the constants here, because some were not available in PHP 4.3.x

- case 1:

- case 2:

- case 9:

- case 10:

- case 11:

- case 12:

- case 3:

- case 15:

- global $template, $config, $phpbb_root_path, $phpEx, $user, $auth;

- global $config, $phpbb_root_path, $phpEx;

- " . ((!$auth->acl_get('m_approve', $forum_id)) ? 'AND p.post_approved = 1' : '') . '

- $sql = $db->sql_build_query('SELECT', array(

- 'ON' => 'z.user_id = ' . $user->data['user_id'] . ' AND z.zebra_id = p.poster_id'

- )

- AND u.user_id = p.poster_id'

- ));

- $row =& $rowset[$post_list[$i]];

- $message = censor_text($row['post_text']);

- $decoded_message = $message;

- if ($row['bbcode_bitfield'])

- {

- $bbcode->bbcode_second_pass($message, $row['bbcode_uid'], $row['bbcode_bitfield']);

- }

-

- $message = bbcode_nl2br($message);

- $message = smiley_text($message, !$row['enable_smilies']);

-/**

-* User Notification

-*/

-function user_notification($mode, $subject, $topic_title, $forum_name, $forum_id, $topic_id, $post_id, $author_name = '')

-{

- global $db, $user, $config, $phpbb_root_path, $phpEx, $auth;

-

- $topic_notification = ($mode == 'reply' || $mode == 'quote') ? true : false;

- $forum_notification = ($mode == 'post') ? true : false;

-

- if (!$topic_notification && !$forum_notification)

- {

- trigger_error('NO_MODE');

- }

-

- if (($topic_notification && !$config['allow_topic_notify']) || ($forum_notification && !$config['allow_forum_notify']))

- {

- return;

- }

-

- $topic_title = ($topic_notification) ? $topic_title : $subject;

- $topic_title = censor_text($topic_title);

-

- // Exclude guests, current user and banned users from notifications

- if (!function_exists('phpbb_get_banned_user_ids'))

- {

- include($phpbb_root_path . 'includes/functions_user.' . $phpEx);

- }

- $sql_ignore_users = phpbb_get_banned_user_ids();

- $sql_ignore_users[ANONYMOUS] = ANONYMOUS;

- $sql_ignore_users[$user->data['user_id']] = $user->data['user_id'];

-

- $notify_rows = array();

-

- // -- get forum_userids || topic_userids

- $sql = 'SELECT u.user_id, u.username, u.user_email, u.user_lang, u.user_notify_type, u.user_jabber

- FROM ' . (($topic_notification) ? TOPICS_WATCH_TABLE : FORUMS_WATCH_TABLE) . ' w, ' . USERS_TABLE . ' u

- WHERE w.' . (($topic_notification) ? 'topic_id' : 'forum_id') . ' = ' . (($topic_notification) ? $topic_id : $forum_id) . '

- AND ' . $db->sql_in_set('w.user_id', $sql_ignore_users, true) . '

- AND w.notify_status = ' . NOTIFY_YES . '

- AND u.user_type IN (' . USER_NORMAL . ', ' . USER_FOUNDER . ')

- AND u.user_id = w.user_id';

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

-

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

- {

- $notify_user_id = (int) $row['user_id'];

- $notify_rows[$notify_user_id] = array(

- 'user_id' => $notify_user_id,

- 'username' => $row['username'],

- 'user_email' => $row['user_email'],

- 'user_jabber' => $row['user_jabber'],

- 'user_lang' => $row['user_lang'],

- 'notify_type' => ($topic_notification) ? 'topic' : 'forum',

- 'template' => ($topic_notification) ? 'topic_notify' : 'newtopic_notify',

- 'method' => $row['user_notify_type'],

- 'allowed' => false

- );

-

- // Add users who have been already notified to ignore list

- $sql_ignore_users[$notify_user_id] = $notify_user_id;

- }

- $db->sql_freeresult($result);

-

- // forum notification is sent to those not already receiving topic notifications

- if ($topic_notification)

- {

- $sql = 'SELECT u.user_id, u.username, u.user_email, u.user_lang, u.user_notify_type, u.user_jabber

- FROM ' . FORUMS_WATCH_TABLE . ' fw, ' . USERS_TABLE . " u

- WHERE fw.forum_id = $forum_id

- AND " . $db->sql_in_set('fw.user_id', $sql_ignore_users, true) . '

- AND fw.notify_status = ' . NOTIFY_YES . '

- AND u.user_type IN (' . USER_NORMAL . ', ' . USER_FOUNDER . ')

- AND u.user_id = fw.user_id';

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

-

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

- {

- $notify_user_id = (int) $row['user_id'];

- $notify_rows[$notify_user_id] = array(

- 'user_id' => $notify_user_id,

- 'username' => $row['username'],

- 'user_email' => $row['user_email'],

- 'user_jabber' => $row['user_jabber'],

- 'user_lang' => $row['user_lang'],

- 'notify_type' => 'forum',

- 'template' => 'forum_notify',

- 'method' => $row['user_notify_type'],

- 'allowed' => false

- );

- }

- $db->sql_freeresult($result);

- }

-

- if (!sizeof($notify_rows))

- {

- return;

- }

-

- // Make sure users are allowed to read the forum

- foreach ($auth->acl_get_list(array_keys($notify_rows), 'f_read', $forum_id) as $forum_id => $forum_ary)

- {

- foreach ($forum_ary as $auth_option => $user_ary)

- {

- foreach ($user_ary as $user_id)

- {

- $notify_rows[$user_id]['allowed'] = true;

- }

- }

- }

-

- // Now, we have to do a little step before really sending, we need to distinguish our users a little bit. ;)

- $msg_users = $delete_ids = $update_notification = array();

- foreach ($notify_rows as $user_id => $row)

- {

- if (!$row['allowed'] || !trim($row['user_email']))

- {

- $delete_ids[$row['notify_type']][] = $row['user_id'];

- }

- else

- {

- $msg_users[] = $row;

- $update_notification[$row['notify_type']][] = $row['user_id'];

-

- /*

- * We also update the forums watch table for this user when we are

- * sending out a topic notification to prevent sending out another

- * notification in case this user is also subscribed to the forum

- * this topic was posted in.

- * Since an UPDATE query is used, this has no effect on users only

- * subscribed to the topic (i.e. no row is created) and should not

- * be a performance issue.

- */

- if ($row['notify_type'] === 'topic')

- {

- $update_notification['forum'][] = $row['user_id'];

- }

- }

- }

- unset($notify_rows);

-

- // Now, we are able to really send out notifications

- if (sizeof($msg_users))

- {

- include_once($phpbb_root_path . 'includes/functions_messenger.' . $phpEx);

- $messenger = new messenger();

-

- $msg_list_ary = array();

- foreach ($msg_users as $row)

- {

- $pos = (!isset($msg_list_ary[$row['template']])) ? 0 : sizeof($msg_list_ary[$row['template']]);

-

- $msg_list_ary[$row['template']][$pos]['method'] = $row['method'];

- $msg_list_ary[$row['template']][$pos]['email'] = $row['user_email'];

- $msg_list_ary[$row['template']][$pos]['jabber'] = $row['user_jabber'];

- $msg_list_ary[$row['template']][$pos]['name'] = $row['username'];

- $msg_list_ary[$row['template']][$pos]['lang'] = $row['user_lang'];

- $msg_list_ary[$row['template']][$pos]['user_id']= $row['user_id'];

- }

- unset($msg_users);

-

- foreach ($msg_list_ary as $email_template => $email_list)

- {

- foreach ($email_list as $addr)

- {

- $messenger->template($email_template, $addr['lang']);

-

- $messenger->to($addr['email'], $addr['name']);

- $messenger->im($addr['jabber'], $addr['name']);

-

- $messenger->assign_vars(array(

- 'USERNAME' => htmlspecialchars_decode($addr['name']),

- 'TOPIC_TITLE' => htmlspecialchars_decode($topic_title),

- 'FORUM_NAME' => htmlspecialchars_decode($forum_name),

- 'AUTHOR_NAME' => htmlspecialchars_decode($author_name),

-

- 'U_FORUM' => generate_board_url() . "/viewforum.$phpEx?f=$forum_id",

- 'U_TOPIC' => generate_board_url() . "/viewtopic.$phpEx?f=$forum_id&t=$topic_id",

- 'U_NEWEST_POST' => generate_board_url() . "/viewtopic.$phpEx?f=$forum_id&t=$topic_id&p=$post_id&e=$post_id",

- 'U_STOP_WATCHING_TOPIC' => generate_board_url() . "/viewtopic.$phpEx?uid={$addr['user_id']}&f=$forum_id&t=$topic_id&unwatch=topic",

- 'U_STOP_WATCHING_FORUM' => generate_board_url() . "/viewforum.$phpEx?uid={$addr['user_id']}&f=$forum_id&unwatch=forum",

- ));

-

- $messenger->send($addr['method']);

- }

- }

- unset($msg_list_ary);

-

- $messenger->save_queue();

- }

-

- // Handle the DB updates

- $db->sql_transaction('begin');

-

- if (!empty($update_notification['topic']))

- {

- $sql = 'UPDATE ' . TOPICS_WATCH_TABLE . '

- SET notify_status = ' . NOTIFY_NO . "

- WHERE topic_id = $topic_id

- AND " . $db->sql_in_set('user_id', $update_notification['topic']);

- $db->sql_query($sql);

- }

-

- if (!empty($update_notification['forum']))

- {

- $sql = 'UPDATE ' . FORUMS_WATCH_TABLE . '

- SET notify_status = ' . NOTIFY_NO . "

- WHERE forum_id = $forum_id

- AND " . $db->sql_in_set('user_id', $update_notification['forum']);

- $db->sql_query($sql);

- }

-

- // Now delete the user_ids not authorised to receive notifications on this topic/forum

- if (!empty($delete_ids['topic']))

- {

- $sql = 'DELETE FROM ' . TOPICS_WATCH_TABLE . "

- WHERE topic_id = $topic_id

- AND " . $db->sql_in_set('user_id', $delete_ids['topic']);

- $db->sql_query($sql);

- }

-

- if (!empty($delete_ids['forum']))

- {

- $sql = 'DELETE FROM ' . FORUMS_WATCH_TABLE . "

- WHERE forum_id = $forum_id

- AND " . $db->sql_in_set('user_id', $delete_ids['forum']);

- $db->sql_query($sql);

- }

-

- $db->sql_transaction('commit');

-}

-

-function delete_post($forum_id, $topic_id, $post_id, &$data)

- global $db, $user, $auth;

- if (($data['topic_first_post_id'] === $data['topic_last_post_id']) && $data['topic_replies_real'] == 0)

- if (!delete_posts('post_id', array($post_id), false, false))

- // Try to delete topic, we may had an previous error causing inconsistency

- if ($post_mode == 'delete_topic')

- delete_topics('topic_id', array($topic_id), false);

- trigger_error('ALREADY_DELETED');

- $sql_data[FORUMS_TABLE] = '';

- $db->sql_query('UPDATE ' . FORUMS_TABLE . ' SET forum_topics_real = forum_topics_real - ' . $topic_count . ', forum_topics = forum_topics - ' . $topic_count . ' WHERE forum_id = ' . $updated_forum);

- delete_topics('topic_id', array($topic_id), false);

-

- if ($data['topic_type'] != POST_GLOBAL)

- $sql_data[FORUMS_TABLE] .= 'forum_topics_real = forum_topics_real - 1';

- $sql_data[FORUMS_TABLE] .= ($data['topic_approved']) ? ', forum_posts = forum_posts - 1, forum_topics = forum_topics - 1' : '';

-

- $update_sql = update_post_information('forum', $forum_id, true);

- if (sizeof($update_sql))

- $sql_data[FORUMS_TABLE] .= ($sql_data[FORUMS_TABLE]) ? ', ' : '';

- $sql_data[FORUMS_TABLE] .= implode(', ', $update_sql[$forum_id]);

- ORDER BY p.post_time ASC";

- if ($data['topic_type'] != POST_GLOBAL)

- $sql_data[FORUMS_TABLE] = ($data['post_approved']) ? 'forum_posts = forum_posts - 1' : '';

- $sql_data[TOPICS_TABLE] = 'topic_poster = ' . intval($row['poster_id']) . ', topic_first_post_id = ' . intval($row['post_id']) . ", topic_first_poster_colour = '" . $db->sql_escape($row['user_colour']) . "', topic_first_poster_name = '" . (($row['poster_id'] == ANONYMOUS) ? $db->sql_escape($row['post_username']) : $db->sql_escape($row['username'])) . "', topic_time = " . (int) $row['post_time'];

-

- // Decrementing topic_replies here is fine because this case only happens if there is more than one post within the topic - basically removing one "reply"

- $sql_data[TOPICS_TABLE] .= ', topic_replies_real = topic_replies_real - 1' . (($data['post_approved']) ? ', topic_replies = topic_replies - 1' : '');

-

- if ($data['topic_type'] != POST_GLOBAL)

- {

- $sql_data[FORUMS_TABLE] = ($data['post_approved']) ? 'forum_posts = forum_posts - 1' : '';

- }

-

- $update_sql = update_post_information('forum', $forum_id, true);

- if (sizeof($update_sql))

- $sql_data[FORUMS_TABLE] .= ($sql_data[FORUMS_TABLE]) ? ', ' : '';

- $sql_data[FORUMS_TABLE] .= implode(', ', $update_sql[$forum_id]);

- }

- $sql_data[TOPICS_TABLE] = 'topic_bumped = 0, topic_bumper = 0, topic_replies_real = topic_replies_real - 1' . (($data['post_approved']) ? ', topic_replies = topic_replies - 1' : '');

- $update_sql = update_post_information('topic', $topic_id, true);

- if (sizeof($update_sql))

- {

- $sql_data[TOPICS_TABLE] .= ', ' . implode(', ', $update_sql[$topic_id]);

- $next_post_id = (int) str_replace('topic_last_post_id = ', '', $update_sql[$topic_id][0]);

- else

- WHERE topic_id = $topic_id " .

- ((!$auth->acl_get('m_approve', $forum_id)) ? 'AND post_approved = 1' : '');

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

-

- $next_post_id = (int) $row['last_post_id'];

- WHERE topic_id = $topic_id " .

- ((!$auth->acl_get('m_approve', $forum_id)) ? 'AND post_approved = 1' : '') . '

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

-

- if ($data['topic_type'] != POST_GLOBAL)

- {

- $sql_data[FORUMS_TABLE] = ($data['post_approved']) ? 'forum_posts = forum_posts - 1' : '';

- }

-

- $sql_data[TOPICS_TABLE] = 'topic_replies_real = topic_replies_real - 1' . (($data['post_approved']) ? ', topic_replies = topic_replies - 1' : '');

- $next_post_id = (int) $row['post_id'];

- $sql_data[TOPICS_TABLE] .= ', topic_attachment = 0';

-// $sql_data[USERS_TABLE] = ($data['post_postcount']) ? 'user_posts = user_posts - 1' : '';

-

- USERS_TABLE => 'user_id = ' . $data['poster_id']

- global $db, $auth, $user, $config, $phpEx, $template, $phpbb_root_path;

- $post_mode = ($data['topic_replies_real'] == 0) ? 'edit_topic' : (($data['topic_first_post_id'] == $data['post_id']) ? 'edit_first_post' : (($data['topic_last_post_id'] == $data['post_id']) ? 'edit_last_post' : 'edit'));

- $subject = truncate_string($subject);

- $data['topic_title'] = truncate_string($data['topic_title']);

- if ($mode == 'edit' && (!isset($data['post_approved']) || !isset($data['topic_approved']) || $data['post_approved'] === false || $data['topic_approved'] === false))

- $sql = 'SELECT p.post_approved, t.topic_type, t.topic_replies, t.topic_replies_real, t.topic_approved

- $data['topic_approved'] = $topic_row['topic_approved'];

- $data['post_approved'] = $topic_row['post_approved'];

- // This variable indicates if the user is able to post or put into the queue - it is used later for all code decisions regarding approval

- // The variable name should be $post_approved, because it indicates if the post is approved or not

- $post_approval = 1;

- $post_approval = 0;

- // Mods are able to force approved/unapproved posts. True means the post is approved, false the post is unapproved

- $post_approval = ($data['force_approved_state']) ? 1 : 0;

- 'forum_id' => ($topic_type == POST_GLOBAL) ? 0 : $data['forum_id'],

- 'post_approved' => $post_approval,

- 'forum_id' => ($topic_type == POST_GLOBAL) ? 0 : $data['forum_id'],

- 'post_approved' => (!$post_approval) ? 0 : $data['post_approved'],

-

- $post_approved = $sql_data[POSTS_TABLE]['sql']['post_approved'];

- 'forum_id' => ($topic_type == POST_GLOBAL) ? 0 : $data['forum_id'],

- 'topic_approved' => $post_approval,

- $sql_data[USERS_TABLE]['stat'][] = "user_lastpost_time = $current_time" . (($auth->acl_get('f_postcount', $data['forum_id']) && $post_approval) ? ', user_posts = user_posts + 1' : '');

- if ($topic_type != POST_GLOBAL)

- if ($post_approval)

- {

- $sql_data[FORUMS_TABLE]['stat'][] = 'forum_posts = forum_posts + 1';

- }

- $sql_data[FORUMS_TABLE]['stat'][] = 'forum_topics_real = forum_topics_real + 1' . (($post_approval) ? ', forum_topics = forum_topics + 1' : '');

- topic_replies_real = topic_replies_real + 1,

- (($post_approval) ? ', topic_replies = topic_replies + 1' : '') .

- $sql_data[USERS_TABLE]['stat'][] = "user_lastpost_time = $current_time" . (($auth->acl_get('f_postcount', $data['forum_id']) && $post_approval) ? ', user_posts = user_posts + 1' : '');

- if ($post_approval && $topic_type != POST_GLOBAL)

- $sql_data[FORUMS_TABLE]['stat'][] = 'forum_posts = forum_posts + 1';

- 'forum_id' => ($topic_type == POST_GLOBAL) ? 0 : $data['forum_id'],

- 'topic_approved' => (!$post_approval) ? 0 : $data['topic_approved'],

- // Correctly set back the topic replies and forum posts... only if the topic was approved before and now gets disapproved

- if (!$post_approval && $data['topic_approved'])

- {

- // Do we need to grab some topic informations?

- if (!sizeof($topic_row))

- {

- $sql = 'SELECT topic_type, topic_replies, topic_replies_real, topic_approved

- FROM ' . TOPICS_TABLE . '

- WHERE topic_id = ' . $data['topic_id'];

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

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

- $db->sql_freeresult($result);

- }

-

- // If this is the only post remaining we do not need to decrement topic_replies.

- // Also do not decrement if first post - then the topic_replies will not be adjusted if approving the topic again.

-

- // If this is an edited topic or the first post the topic gets completely disapproved later on...

- $sql_data[FORUMS_TABLE]['stat'][] = 'forum_topics = forum_topics - 1';

- $sql_data[FORUMS_TABLE]['stat'][] = 'forum_posts = forum_posts - ' . ($topic_row['topic_replies'] + 1);

-

- set_config_count('num_topics', -1, true);

- set_config_count('num_posts', ($topic_row['topic_replies'] + 1) * (-1), true);

-

- // Only decrement this post, since this is the one non-approved now

- if ($auth->acl_get('f_postcount', $data['forum_id']))

- {

- $sql_data[USERS_TABLE]['stat'][] = 'user_posts = user_posts - 1';

- }

- }

-

- break;

-

- case 'edit':

- case 'edit_last_post':

-

- // Correctly set back the topic replies and forum posts... but only if the post was approved before.

- if (!$post_approval && $data['post_approved'])

- {

- $sql_data[TOPICS_TABLE]['stat'][] = 'topic_replies = topic_replies - 1, topic_last_view_time = ' . $current_time;

- $sql_data[FORUMS_TABLE]['stat'][] = 'forum_posts = forum_posts - 1';

-

- set_config_count('num_posts', -1, true);

-

- if ($auth->acl_get('f_postcount', $data['forum_id']))

- {

- $sql_data[USERS_TABLE]['stat'][] = 'user_posts = user_posts - 1';

- }

- }

-

- 'topic_id' => $data['topic_id'])

- );

- if ($post_mode == 'post')

- 'topic_first_post_id' => $data['post_id'],

- 'topic_last_poster_id' => (int) $user->data['user_id'],

- 'topic_last_poster_name' => (!$user->data['is_registered'] && $username) ? $username : (($user->data['user_id'] != ANONYMOUS) ? $user->data['username'] : ''),

- unset($sql_data[POSTS_TABLE]['sql']);

- }

-

- $make_global = false;

-

- // Are we globalising or unglobalising?

- if ($post_mode == 'edit_first_post' || $post_mode == 'edit_topic')

- {

- if (!sizeof($topic_row))

- $sql = 'SELECT topic_type, topic_replies, topic_replies_real, topic_approved, topic_last_post_id

- FROM ' . TOPICS_TABLE . '

- WHERE topic_id = ' . $data['topic_id'];

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

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

- $db->sql_freeresult($result);

- // globalise/unglobalise?

- if (($topic_row['topic_type'] != POST_GLOBAL && $topic_type == POST_GLOBAL) || ($topic_row['topic_type'] == POST_GLOBAL && $topic_type != POST_GLOBAL))

- if (!empty($sql_data[FORUMS_TABLE]['stat']) && implode('', $sql_data[FORUMS_TABLE]['stat']))

- $db->sql_query('UPDATE ' . FORUMS_TABLE . ' SET ' . implode(', ', $sql_data[FORUMS_TABLE]['stat']) . ' WHERE forum_id = ' . $data['forum_id']);

- $make_global = true;

- $sql_data[FORUMS_TABLE]['stat'] = array();

- }

-

- // globalise

- if ($topic_row['topic_type'] != POST_GLOBAL && $topic_type == POST_GLOBAL)

- {

- // Decrement topic/post count

- $sql_data[FORUMS_TABLE]['stat'][] = 'forum_posts = forum_posts - ' . ($topic_row['topic_replies_real'] + 1);

- $sql_data[FORUMS_TABLE]['stat'][] = 'forum_topics_real = forum_topics_real - 1' . (($topic_row['topic_approved']) ? ', forum_topics = forum_topics - 1' : '');

-

- // Update forum_ids for all posts

- $sql = 'UPDATE ' . POSTS_TABLE . '

- SET forum_id = 0

- WHERE topic_id = ' . $data['topic_id'];

- $db->sql_query($sql);

- // unglobalise

- else if ($topic_row['topic_type'] == POST_GLOBAL && $topic_type != POST_GLOBAL)

- {

- // Increment topic/post count

- $sql_data[FORUMS_TABLE]['stat'][] = 'forum_posts = forum_posts + ' . ($topic_row['topic_replies_real'] + 1);

- $sql_data[FORUMS_TABLE]['stat'][] = 'forum_topics_real = forum_topics_real + 1' . (($topic_row['topic_approved']) ? ', forum_topics = forum_topics + 1' : '');

- // Update forum_ids for all posts

- $sql = 'UPDATE ' . POSTS_TABLE . '

- SET forum_id = ' . $data['forum_id'] . '

- WHERE topic_id = ' . $data['topic_id'];

- $db->sql_query($sql);

- }

- // we need to update the last forum information

- // only applicable if the topic is not global and it is approved

- // we also check to make sure we are not dealing with globaling the latest topic (pretty rare but still needs to be checked)

- if ($topic_type != POST_GLOBAL && !$make_global && ($post_approved || !$data['post_approved']))

- {

- // the last post makes us update the forum table. This can happen if...

- // We make a new topic

- // We reply to a topic

- // We edit the last post in a topic and this post is the latest in the forum (maybe)

- // We edit the only post in the topic

- // We edit the first post in the topic and all the other posts are not approved

- if (($post_mode == 'post' || $post_mode == 'reply') && $post_approved)

- {

- $sql_data[FORUMS_TABLE]['stat'][] = 'forum_last_post_id = ' . $data['post_id'];

- $sql_data[FORUMS_TABLE]['stat'][] = "forum_last_post_subject = '" . $db->sql_escape($subject) . "'";

- $sql_data[FORUMS_TABLE]['stat'][] = 'forum_last_post_time = ' . $current_time;

- $sql_data[FORUMS_TABLE]['stat'][] = 'forum_last_poster_id = ' . (int) $user->data['user_id'];

- $sql_data[FORUMS_TABLE]['stat'][] = "forum_last_poster_name = '" . $db->sql_escape((!$user->data['is_registered'] && $username) ? $username : (($user->data['user_id'] != ANONYMOUS) ? $user->data['username'] : '')) . "'";

- $sql_data[FORUMS_TABLE]['stat'][] = "forum_last_poster_colour = '" . $db->sql_escape($user->data['user_colour']) . "'";

- }

- else if ($post_mode == 'edit_last_post' || $post_mode == 'edit_topic' || ($post_mode == 'edit_first_post' && !$data['topic_replies']))

- {

- // this does not _necessarily_ mean that we must update the info again,

- // it just means that we might have to

- $sql = 'SELECT forum_last_post_id, forum_last_post_subject

- FROM ' . FORUMS_TABLE . '

- WHERE forum_id = ' . (int) $data['forum_id'];

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

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

- $db->sql_freeresult($result);

-

- // this post is the latest post in the forum, better update

- if ($row['forum_last_post_id'] == $data['post_id'])

- {

- // If post approved and subject changed, or poster is anonymous, we need to update the forum_last* rows

- if ($post_approved && ($row['forum_last_post_subject'] !== $subject || $data['poster_id'] == ANONYMOUS))

- {

- // the post's subject changed

- if ($row['forum_last_post_subject'] !== $subject)

- {

- $sql_data[FORUMS_TABLE]['stat'][] = 'forum_last_post_subject = \'' . $db->sql_escape($subject) . '\'';

- }

-

- // Update the user name if poster is anonymous... just in case an admin changed it

- if ($data['poster_id'] == ANONYMOUS)

- {

- $sql_data[FORUMS_TABLE]['stat'][] = "forum_last_poster_name = '" . $db->sql_escape($username) . "'";

- }

- }

- else if ($data['post_approved'] !== $post_approved)

- {

- // we need a fresh change of socks, everything has become invalidated

- $sql = 'SELECT MAX(topic_last_post_id) as last_post_id

- FROM ' . TOPICS_TABLE . '

- WHERE forum_id = ' . (int) $data['forum_id'] . '

- AND topic_approved = 1';

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

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

- $db->sql_freeresult($result);

-

- // any posts left in this forum?

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

- {

- $sql = 'SELECT p.post_id, p.post_subject, p.post_time, p.poster_id, p.post_username, u.user_id, u.username, u.user_colour

- FROM ' . POSTS_TABLE . ' p, ' . USERS_TABLE . ' u

- WHERE p.poster_id = u.user_id

- AND p.post_id = ' . (int) $row['last_post_id'];

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

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

- $db->sql_freeresult($result);

-

- // salvation, a post is found! jam it into the forums table

- $sql_data[FORUMS_TABLE]['stat'][] = 'forum_last_post_id = ' . (int) $row['post_id'];

- $sql_data[FORUMS_TABLE]['stat'][] = "forum_last_post_subject = '" . $db->sql_escape($row['post_subject']) . "'";

- $sql_data[FORUMS_TABLE]['stat'][] = 'forum_last_post_time = ' . (int) $row['post_time'];

- $sql_data[FORUMS_TABLE]['stat'][] = 'forum_last_poster_id = ' . (int) $row['poster_id'];

- $sql_data[FORUMS_TABLE]['stat'][] = "forum_last_poster_name = '" . $db->sql_escape(($row['poster_id'] == ANONYMOUS) ? $row['post_username'] : $row['username']) . "'";

- $sql_data[FORUMS_TABLE]['stat'][] = "forum_last_poster_colour = '" . $db->sql_escape($row['user_colour']) . "'";

- }

- else

- {

- // just our luck, the last topic in the forum has just been turned unapproved...

- $sql_data[FORUMS_TABLE]['stat'][] = 'forum_last_post_id = 0';

- $sql_data[FORUMS_TABLE]['stat'][] = "forum_last_post_subject = ''";

- $sql_data[FORUMS_TABLE]['stat'][] = 'forum_last_post_time = 0';

- $sql_data[FORUMS_TABLE]['stat'][] = 'forum_last_poster_id = 0';

- $sql_data[FORUMS_TABLE]['stat'][] = "forum_last_poster_name = ''";

- $sql_data[FORUMS_TABLE]['stat'][] = "forum_last_poster_colour = ''";

- }

- }

- }

- }

- }

- else if ($make_global)

- // somebody decided to be a party pooper, we must recalculate the whole shebang (maybe)

- $sql = 'SELECT forum_last_post_id

- FROM ' . FORUMS_TABLE . '

- WHERE forum_id = ' . (int) $data['forum_id'];

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

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

- $db->sql_freeresult($result);

-

- // we made a topic global, go get new data

- if ($topic_row['topic_type'] != POST_GLOBAL && $topic_type == POST_GLOBAL && $forum_row['forum_last_post_id'] == $topic_row['topic_last_post_id'])

- {

- // we need a fresh change of socks, everything has become invalidated

- $sql = 'SELECT MAX(topic_last_post_id) as last_post_id

- FROM ' . TOPICS_TABLE . '

- WHERE forum_id = ' . (int) $data['forum_id'] . '

- AND topic_approved = 1';

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

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

- $db->sql_freeresult($result);

- // any posts left in this forum?

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

- {

- $sql = 'SELECT p.post_id, p.post_subject, p.post_time, p.poster_id, p.post_username, u.user_id, u.username, u.user_colour

- FROM ' . POSTS_TABLE . ' p, ' . USERS_TABLE . ' u

- WHERE p.poster_id = u.user_id

- AND p.post_id = ' . (int) $row['last_post_id'];

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

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

- $db->sql_freeresult($result);

-

- // salvation, a post is found! jam it into the forums table

- $sql_data[FORUMS_TABLE]['stat'][] = 'forum_last_post_id = ' . (int) $row['post_id'];

- $sql_data[FORUMS_TABLE]['stat'][] = "forum_last_post_subject = '" . $db->sql_escape($row['post_subject']) . "'";

- $sql_data[FORUMS_TABLE]['stat'][] = 'forum_last_post_time = ' . (int) $row['post_time'];

- $sql_data[FORUMS_TABLE]['stat'][] = 'forum_last_poster_id = ' . (int) $row['poster_id'];

- $sql_data[FORUMS_TABLE]['stat'][] = "forum_last_poster_name = '" . $db->sql_escape(($row['poster_id'] == ANONYMOUS) ? $row['post_username'] : $row['username']) . "'";

- $sql_data[FORUMS_TABLE]['stat'][] = "forum_last_poster_colour = '" . $db->sql_escape($row['user_colour']) . "'";

- }

- else

- {

- // just our luck, the last topic in the forum has just been globalized...

- $sql_data[FORUMS_TABLE]['stat'][] = 'forum_last_post_id = 0';

- $sql_data[FORUMS_TABLE]['stat'][] = "forum_last_post_subject = ''";

- $sql_data[FORUMS_TABLE]['stat'][] = 'forum_last_post_time = 0';

- $sql_data[FORUMS_TABLE]['stat'][] = 'forum_last_poster_id = 0';

- $sql_data[FORUMS_TABLE]['stat'][] = "forum_last_poster_name = ''";

- $sql_data[FORUMS_TABLE]['stat'][] = "forum_last_poster_colour = ''";

- }

- }

- else if ($topic_row['topic_type'] == POST_GLOBAL && $topic_type != POST_GLOBAL && $forum_row['forum_last_post_id'] < $topic_row['topic_last_post_id'])

- {

- // this post has a higher id, it is newer

- $sql = 'SELECT p.post_id, p.post_subject, p.post_time, p.poster_id, p.post_username, u.user_id, u.username, u.user_colour

- FROM ' . POSTS_TABLE . ' p, ' . USERS_TABLE . ' u

- WHERE p.poster_id = u.user_id

- AND p.post_id = ' . (int) $topic_row['topic_last_post_id'];

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

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

- $db->sql_freeresult($result);

-

- // salvation, a post is found! jam it into the forums table

- $sql_data[FORUMS_TABLE]['stat'][] = 'forum_last_post_id = ' . (int) $row['post_id'];

- $sql_data[FORUMS_TABLE]['stat'][] = "forum_last_post_subject = '" . $db->sql_escape($row['post_subject']) . "'";

- $sql_data[FORUMS_TABLE]['stat'][] = 'forum_last_post_time = ' . (int) $row['post_time'];

- $sql_data[FORUMS_TABLE]['stat'][] = 'forum_last_poster_id = ' . (int) $row['poster_id'];

- $sql_data[FORUMS_TABLE]['stat'][] = "forum_last_poster_name = '" . $db->sql_escape(($row['poster_id'] == ANONYMOUS) ? $row['post_username'] : $row['username']) . "'";

- $sql_data[FORUMS_TABLE]['stat'][] = "forum_last_poster_colour = '" . $db->sql_escape($row['user_colour']) . "'";

- }

-

- // topic sync time!

- // simply, we update if it is a reply or the last post is edited

- if ($post_approved)

- // reply requires the whole thing

- if ($post_mode == 'reply')

- {

- $sql_data[TOPICS_TABLE]['stat'][] = 'topic_last_post_id = ' . (int) $data['post_id'];

- $sql_data[TOPICS_TABLE]['stat'][] = 'topic_last_poster_id = ' . (int) $user->data['user_id'];

- $sql_data[TOPICS_TABLE]['stat'][] = "topic_last_poster_name = '" . $db->sql_escape((!$user->data['is_registered'] && $username) ? $username : (($user->data['user_id'] != ANONYMOUS) ? $user->data['username'] : '')) . "'";

- $sql_data[TOPICS_TABLE]['stat'][] = "topic_last_poster_colour = '" . (($user->data['user_id'] != ANONYMOUS) ? $db->sql_escape($user->data['user_colour']) : '') . "'";

- $sql_data[TOPICS_TABLE]['stat'][] = "topic_last_post_subject = '" . $db->sql_escape($subject) . "'";

- $sql_data[TOPICS_TABLE]['stat'][] = 'topic_last_post_time = ' . (int) $current_time;

- }

- else if ($post_mode == 'edit_last_post' || $post_mode == 'edit_topic' || ($post_mode == 'edit_first_post' && !$data['topic_replies']))

- }

- }

- else if (!$data['post_approved'] && ($post_mode == 'edit_last_post' || $post_mode == 'edit_topic' || ($post_mode == 'edit_first_post' && !$data['topic_replies'])))

- {

- // like having the rug pulled from under us

- $sql = 'SELECT MAX(post_id) as last_post_id

- FROM ' . POSTS_TABLE . '

- WHERE topic_id = ' . (int) $data['topic_id'] . '

- AND post_approved = 1';

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

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

- $db->sql_freeresult($result);

-

- // any posts left in this forum?

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

- {

- $sql = 'SELECT p.post_id, p.post_subject, p.post_time, p.poster_id, p.post_username, u.user_id, u.username, u.user_colour

- FROM ' . POSTS_TABLE . ' p, ' . USERS_TABLE . ' u

- WHERE p.poster_id = u.user_id

- AND p.post_id = ' . (int) $row['last_post_id'];

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

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

- $db->sql_freeresult($result);

- // salvation, a post is found! jam it into the topics table

- $sql_data[TOPICS_TABLE]['stat'][] = 'topic_last_post_id = ' . (int) $row['post_id'];

- $sql_data[TOPICS_TABLE]['stat'][] = "topic_last_post_subject = '" . $db->sql_escape($row['post_subject']) . "'";

- $sql_data[TOPICS_TABLE]['stat'][] = 'topic_last_post_time = ' . (int) $row['post_time'];

- $sql_data[TOPICS_TABLE]['stat'][] = 'topic_last_poster_id = ' . (int) $row['poster_id'];

- $sql_data[TOPICS_TABLE]['stat'][] = "topic_last_poster_name = '" . $db->sql_escape(($row['poster_id'] == ANONYMOUS) ? $row['post_username'] : $row['username']) . "'";

- $sql_data[TOPICS_TABLE]['stat'][] = "topic_last_poster_colour = '" . $db->sql_escape($row['user_colour']) . "'";

- }

- }

- // Update total post count, do not consider moderated posts/topics

- if ($post_approval)

- {

- if ($post_mode == 'post')

- {

- set_config_count('num_topics', 1, true);

- set_config_count('num_posts', 1, true);

- }

- if ($post_mode == 'reply')

- {

- set_config_count('num_posts', 1, true);

- $where_sql = array(POSTS_TABLE => 'post_id = ' . $data['post_id'], TOPICS_TABLE => 'topic_id = ' . $data['topic_id'], FORUMS_TABLE => 'forum_id = ' . $data['forum_id'], USERS_TABLE => 'user_id = ' . $poster_id);

- if ($make_global)

- $search_type = basename($config['search_type']);

-

- if (!file_exists($phpbb_root_path . 'includes/search/' . $search_type . '.' . $phpEx))

- {

- trigger_error('NO_SUCH_SEARCH_MODULE');

- }

- include("{$phpbb_root_path}includes/search/$search_type.$phpEx");

- $search = new $search_type($error);

- $search->index($mode, $data['post_id'], $data['message'], $subject, $poster_id, ($topic_type == POST_GLOBAL) ? 0 : $data['forum_id']);

- markread('topic', (($topic_type == POST_GLOBAL) ? 0 : $data['forum_id']), $data['topic_id'], time());

- AND forum_id = ' . (($topic_type == POST_GLOBAL) ? 0 : $data['forum_id']);

- if ($topic_type == POST_GLOBAL)

- {

- $sql = 'SELECT MAX(topic_last_post_time) as forum_last_post_time

- FROM ' . TOPICS_TABLE . '

- WHERE forum_id = 0';

- }

- else

- {

- $sql = 'SELECT forum_last_post_time

- FROM ' . FORUMS_TABLE . '

- WHERE forum_id = ' . $data['forum_id'];

- }

- update_forum_tracking_info((($topic_type == POST_GLOBAL) ? 0 : $data['forum_id']), $forum_last_post_time, $f_mark_time, false);

- if (($mode == 'reply' || $mode == 'quote' || $mode == 'post') && $post_approval)

- // If a username was supplied or the poster is a guest, we will use the supplied username.

- // Doing it this way we can use "...post by guest-username..." in notifications when

- // "guest-username" is supplied or ommit the username if it is not.

- $username = ($username !== '' || !$user->data['is_registered']) ? $username : $user->data['username'];

- user_notification($mode, $subject, $data['topic_title'], $data['forum_name'], $data['forum_id'], $data['topic_id'], $data['post_id'], $username);

- if ($post_approval)

-

-?> \ No newline at end of file