+ $enable_sig = ($config['allow_sig'] && $user->optionget('attachsig')) ? TRUE : FALSE;

+ $enable_smilies = ($config['allow_smilies'] && $user->optionget('allowsmile')) ? TRUE : FALSE;

+ $enable_bbcode = ($config['allow_bbcode'] && $user->optionget('allowbbcode')) ? TRUE : FALSE;

+ 'topic_title' => (empty($topic_title)) ? $subject : $topic_title,

+ 'forum_name' => $forum_name,

+$html_checked = (isset($enable_html)) ? !$enable_html : (($config['allow_html']) ? !$user->optionget('allowhtml') : 1);

+$bbcode_checked = (isset($enable_bbcode)) ? !$enable_bbcode : (($config['allow_bbcode']) ? !$user->optionget('allowbbcode') : 1);

+$smilies_checked = (isset($enable_smilies)) ? !$enable_smilies : (($config['allow_smilies']) ? !$user->optionget('allowsmile') : 1);

+$notify_checked = (isset($notify)) ? $notify : (($notify_set == -1) ? (($user->data['user_id'] != ANONYMOUS) ? $user->optionget('notify') : 0) : $notify_set);

+function user_notification($mode, $subject, $topic_title, $forum_name, $forum_id, $topic_id, $post_id)

+ global $db, $user, $censors, $config, $phpbb_root_path, $phpEx;

+ $forum_notification = ($mode == 'post') ? TRUE : FALSE;

+

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

+ {

+ trigger_error('WRONG_NOTIFICATION_MODE');

+ }

+ $topic_title = ($topic_notification) ? $tpüoc_title : $subject;

+ decode_text($topic_title);

+ $topic_title = (sizeof($censors['match'])) ? preg_replace($censors['match'], $censors['replace'], $topic_title) : $topic_title;

+

+ $db->sql_freeresult($result);

+ $notify_rows = array();

+ // -- get forum_userids || topic_userids

+ $sql = 'SELECT u.user_id, u.username, u.user_email, u.user_lang

+ 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 w.user_id NOT IN ($sql_ignore_users)

+ AND w.notify_status = 0

+ AND u.user_id = w.user_id";

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

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

+ $notify_rows[$row['user_id']] = array(

+ 'user_id' => $row['user_id'],

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

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

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

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

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

+ 'allowed' => false

+ );

+

+ // forum notification is sent to those not receiving post notification

+ if ($topic_notification)

+ if (sizeof($notify_rows))

+ $sql_ignore_users .= ', ' . implode(', ', array_keys($notify_rows));

+ $sql = 'SELECT u.user_id, u.username, u.user_email, u.user_lang

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

+ WHERE fw.forum_id = $forum_id

+ AND fw.user_id NOT IN ($sql_ignore_users)

+ AND fw.notify_status = 0

+ AND u.user_id = fw.user_id";

+ $notify_rows[$row['user_id']] = array(

+ 'user_id' => $row['user_id'],

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

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

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

+ 'notify_type' => 'forum',

+ 'template' => 'forum_notify',

+ 'allowed' => false

+ );

+

+ if (!sizeof($notify_rows))

+ // We have all users informations we want, now check if they are actually permitted to receive a notification

+ $sql = 'SELECT a.user_id

+ FROM ' . ACL_OPTIONS_TABLE . ' ao, ' . ACL_USERS_TABLE . ' a

+ WHERE a.user_id IN (' . implode(', ', array_keys($notify_rows)) . ")

+ AND ao.auth_option_id = a.auth_option_id

+ AND ao.auth_option = 'f_read'

+ AND a.forum_id = $forum_id";

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

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

+ $notify_rows[$row['user_id']]['allowed'] = true;

+ }

+ $db->sql_freeresult($result);

+ // Now grab group settings...

+ $sql = 'SELECT ug.user_id, MIN(a.auth_setting) as min_setting

+ FROM ' . USER_GROUP_TABLE . ' ug, ' . ACL_OPTIONS_TABLE . ' ao, ' . ACL_GROUPS_TABLE . ' a

+ WHERE ug.user_id IN (' . implode(', ', array_keys($notify_rows)) . ")

+ AND a.group_id = ug.group_id

+ AND ao.auth_option_id = a.auth_option_id

+ AND ao.auth_option = 'f_read'

+ AND a.forum_id = $forum_id

+ GROUP BY ug.user_id";

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

+

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

+ {

+ if ($row['min_setting'] == 1)

+ $notify_rows[$row['user_id']]['allowed'] = true;

+ $db->sql_freeresult($result);

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

+ $email_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

+ {

+ $email_users[] = $row;

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

+ unset($notify_rows);

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

+ 'U_NEWEST_POST' => generate_board_url() . '/viewtopic.'.$phpEx . '?t=' . $topic_id . '&p=' . $post_id . '#' . $post_id,

+ 'U_TOPIC' => generate_board_url() . '/viewtopic.'.$phpEx . '?t=' . $topic_id,

+ unset($email_list_ary);

+

+ // Now delete the user_ids not authorized to receive notifications on this topic/forum

+ if (sizeof($delete_ids['topic']))

+ $sql = "DELETE FROM " . TOPICS_WATCH_TABLE . "

+ AND user_id IN (" . implode(', ', $delete_ids['topic']) . ")";

+ if (sizeof($delete_ids['forum']))

+ $sql = "DELETE FROM " . FORUMS_WATCH_TABLE . "

+ AND user_id IN (" . implode(', ', $delete_ids['forum']) . ")";

+ // Now update the notification status

+ if (sizeof($update_notification['topic']))

+ $sql = "UPDATE " . TOPICS_WATCH_TABLE . "

+ SET notify_status = 1

+ AND user_id IN (" . implode(', ', $update_notification['topic']) . ")";

+ $db->sql_query($sql);

+ }

+

+ if (sizeof($update_notification['forum']))

+ {

+ $sql = "UPDATE " . FORUMS_WATCH_TABLE . "

+ SET notify_status = 1

+ WHERE forum_id = $forum_id

+ AND user_id IN (" . implode(', ', $update_notification['forum'] . ")";

+ 'U_QUOTE' => ($auth->acl_get('f_quote', $forum_id)) ? 'javascript:addquote(' . $row['post_id'] . ", '" . str_replace("'", "\\'", $poster) . "')" : '',

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

+ 'post_username' => ($username != '' && $data['poster_id'] == ANONYMOUS) ? stripslashes($username) : '',

+ 'topic_first_poster_name' => ($user->data['user_id'] == ANONYMOUS && !empty($username)) ? stripslashes($username) : $user->data['username'],

+ 'topic_first_poster_name' => stripslashes($username),

+ 'topic_first_poster_name' => stripslashes($username),

+ 'topic_last_poster_name' => ($user->data['user_id'] == ANONYMOUS && !empty($username)) ? stripslashes($username) : $user->data['username']

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