-class exception extends \Exception

- public function __toString()

- {

- return $this->getMessage();

- }

- /** @var array */

- /** @var \phpbb\config\config */

- protected $config;

-

- protected $phpbb_root_path;

-

- /** @var string */

- protected $php_ext;

-

- /** @var string */

- protected $notifications_table;

-

- /** @var string */

- * @param \phpbb\config\config $config

- * @param string $phpbb_root_path

- * @param string $php_ext

- * @param string $notifications_table

- public function __construct($notification_types, $notification_methods, ContainerInterface $phpbb_container, \phpbb\user_loader $user_loader, \phpbb\config\config $config, \phpbb\event\dispatcher_interface $phpbb_dispatcher, \phpbb\db\driver\driver_interface $db, \phpbb\cache\service $cache, $user, $phpbb_root_path, $php_ext, $notification_types_table, $notifications_table, $user_notifications_table)

- $this->config = $config;

- $this->phpbb_root_path = $phpbb_root_path;

- $this->php_ext = $php_ext;

-

- $this->notifications_table = $notifications_table;

- * Load the user's notifications

- public function load_notifications(array $options = array())

- // Merge default options

- $options = array_merge(array(

- 'notification_id' => false,

- 'user_id' => $this->user->data['user_id'],

- 'order_by' => 'notification_time',

- 'order_dir' => 'DESC',

- 'limit' => 0,

- 'start' => 0,

- 'all_unread' => false,

- 'count_unread' => false,

- 'count_total' => false,

- ), $options);

-

- // If all_unread, count_unread must be true

- $options['count_unread'] = ($options['all_unread']) ? true : $options['count_unread'];

- // Anonymous users and bots never receive notifications

- if ($options['user_id'] == $this->user->data['user_id'] && ($this->user->data['user_id'] == ANONYMOUS || $this->user->data['user_type'] == USER_IGNORE))

- $notifications = $user_ids = array();

- $load_special = array();

- $total_count = $unread_count = 0;

- if ($options['count_unread'])

- // Get the total number of unread notifications

- $sql = 'SELECT COUNT(n.notification_id) AS unread_count

- FROM ' . $this->notifications_table . ' n, ' . $this->notification_types_table . ' nt

- WHERE n.user_id = ' . (int) $options['user_id'] . '

- AND n.notification_read = 0

- AND nt.notification_type_id = n.notification_type_id

- AND nt.notification_type_enabled = 1';

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

- $unread_count = (int) $this->db->sql_fetchfield('unread_count');

- $this->db->sql_freeresult($result);

-

- if ($options['count_total'])

- // Get the total number of notifications

- $sql = 'SELECT COUNT(n.notification_id) AS total_count

- FROM ' . $this->notifications_table . ' n, ' . $this->notification_types_table . ' nt

- WHERE n.user_id = ' . (int) $options['user_id'] . '

- AND nt.notification_type_id = n.notification_type_id

- AND nt.notification_type_enabled = 1';

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

- $total_count = (int) $this->db->sql_fetchfield('total_count');

- $this->db->sql_freeresult($result);

-

- if (!$options['count_total'] || $total_count)

- $rowset = array();

- $selected_unread_count = 0;

-

- // Get the main notifications

- $sql = 'SELECT n.*, nt.notification_type_name

- FROM ' . $this->notifications_table . ' n, ' . $this->notification_types_table . ' nt

- WHERE n.user_id = ' . (int) $options['user_id'] .

- (($options['notification_id']) ? ' AND ' . $this->db->sql_in_set('n.notification_id', $options['notification_id']) : '') . '

- AND nt.notification_type_id = n.notification_type_id

- AND nt.notification_type_enabled = 1

- ORDER BY n.' . $this->db->sql_escape($options['order_by']) . ' ' . $this->db->sql_escape($options['order_dir']);

- $result = $this->db->sql_query_limit($sql, $options['limit'], $options['start']);

-

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

- {

- $rowset[$row['notification_id']] = $row;

- $selected_unread_count += (int) !$row['notification_read'];

- }

- $this->db->sql_freeresult($result);

-

- // Get all unread notifications

- if ($selected_unread_count < $unread_count && $options['all_unread'] && !empty($rowset))

- {

- $sql = 'SELECT n.*, nt.notification_type_name

- FROM ' . $this->notifications_table . ' n, ' . $this->notification_types_table . ' nt

- WHERE n.user_id = ' . (int) $options['user_id'] . '

- AND n.notification_read = 0

- AND ' . $this->db->sql_in_set('n.notification_id', array_keys($rowset), true) . '

- AND nt.notification_type_id = n.notification_type_id

- AND nt.notification_type_enabled = 1

- ORDER BY n.' . $this->db->sql_escape($options['order_by']) . ' ' . $this->db->sql_escape($options['order_dir']);

- $result = $this->db->sql_query_limit($sql, $options['limit'], $options['start']);

-

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

- {

- $rowset[$row['notification_id']] = $row;

- }

- $this->db->sql_freeresult($result);

- }

-

- foreach ($rowset as $row)

- {

- $notification = $this->get_item_type_class($row['notification_type_name'], $row);

-

- // Array of user_ids to query all at once

- $user_ids = array_merge($user_ids, $notification->users_to_query());

-

- // Some notification types also require querying additional tables themselves

- if (!isset($load_special[$row['notification_type_name']]))

- {

- $load_special[$row['notification_type_name']] = array();

- }

- $load_special[$row['notification_type_name']] = array_merge($load_special[$row['notification_type_name']], $notification->get_load_special());

-

- $notifications[$row['notification_id']] = $notification;

- }

-

- $this->user_loader->load_users($user_ids);

-

- // Allow each type to load its own special items

- foreach ($load_special as $item_type => $data)

- {

- $item_class = $this->get_item_type_class($item_type);

-

- $item_class->load_special($data, $notifications);

- }

- return array(

- 'notifications' => $notifications,

- 'unread_count' => $unread_count,

- 'total_count' => $total_count,

- );

- * Mark notifications read

- *

- * @param bool|string|array $notification_type_name Type identifier or array of item types (only acceptable if the $data is identical for the specified types). False to mark read for all item types

- * @param bool|int|array $item_id Item id or array of item ids. False to mark read for all item ids

- * @param bool|int|array $user_id User id or array of user ids. False to mark read for all user ids

- * @param bool|int $time Time at which to mark all notifications prior to as read. False to mark all as read. (Default: False)

- */

- public function mark_notifications_read($notification_type_name, $item_id, $user_id, $time = false)

- $time = ($time !== false) ? $time : time();

-

- $sql = 'UPDATE ' . $this->notifications_table . "

- SET notification_read = 1

- WHERE notification_time <= " . (int) $time .

- (($notification_type_name !== false) ? ' AND ' . $this->db->sql_in_set('notification_type_id', $this->get_notification_type_ids($notification_type_name)) : '') .

- (($user_id !== false) ? ' AND ' . $this->db->sql_in_set('user_id', $user_id) : '') .

- (($item_id !== false) ? ' AND ' . $this->db->sql_in_set('item_id', $item_id) : '');

- $this->db->sql_query($sql);

- * Mark notifications read from a parent identifier

- public function mark_notifications_read_by_parent($notification_type_name, $item_parent_id, $user_id, $time = false)

- $time = ($time !== false) ? $time : time();

-

- $sql = 'UPDATE ' . $this->notifications_table . "

- SET notification_read = 1

- WHERE notification_time <= " . (int) $time .

- (($notification_type_name !== false) ? ' AND ' . $this->db->sql_in_set('notification_type_id', $this->get_notification_type_ids($notification_type_name)) : '') .

- (($item_parent_id !== false) ? ' AND ' . $this->db->sql_in_set('item_parent_id', $item_parent_id, false, true) : '') .

- (($user_id !== false) ? ' AND ' . $this->db->sql_in_set('user_id', $user_id) : '');

- $this->db->sql_query($sql);

- * Mark notifications read

- public function mark_notifications_read_by_id($notification_id, $time = false)

- $time = ($time !== false) ? $time : time();

- $sql = 'UPDATE ' . $this->notifications_table . "

- SET notification_read = 1

- WHERE notification_time <= " . (int) $time . '

- AND ' . $this->db->sql_in_set('notification_id', $notification_id);

- $this->db->sql_query($sql);

- $item_id = $this->get_item_type_class($notification_type_name)->get_item_id($data);

-

- $notification_objects = $notification_methods = array();

- $sql = 'SELECT n.user_id

- FROM ' . $this->notifications_table . ' n, ' . $this->notification_types_table . ' nt

- WHERE n.notification_type_id = ' . (int) $notification_type_id . '

- AND n.item_id = ' . (int) $item_id . '

- AND nt.notification_type_id = n.notification_type_id

- AND nt.notification_type_enabled = 1';

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

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

- unset($notify_users[$row['user_id']]);

- $this->db->sql_freeresult($result);

- if (!sizeof($notify_users))

- $insert_buffer = new \phpbb\db\sql_insert_buffer($this->db, $this->notifications_table);

-

- // Insert notification row using buffer.

- $insert_buffer->insert($notification->create_insert_array($data, $pre_create_data));

- if ($method) // blank means we just insert it as a notification, but do not notify them by any other means

- if (!isset($notification_methods[$method]))

- {

- $notification_methods[$method] = $this->get_method_class($method);

- }

-

- $notification_methods[$method]->add_to_queue($notification);

- $insert_buffer->flush();

-

- * Update a notification

- public function update_notifications($notification_type_name, $data)

- $notification = $this->get_item_type_class($notification_type_name);

- // Allow the notifications class to over-ride the update_notifications functionality

- if (method_exists($notification, 'update_notifications'))

- // Return False to over-ride the rest of the update

- if ($notification->update_notifications($data) === false)

- {

- return;

- }

- $notification_type_id = $this->get_notification_type_id($notification_type_name);

- $item_id = $notification->get_item_id($data);

- $update_array = $notification->create_update_array($data);

-

- $sql = 'UPDATE ' . $this->notifications_table . '

- SET ' . $this->db->sql_build_array('UPDATE', $update_array) . '

- WHERE notification_type_id = ' . (int) $notification_type_id . '

- AND item_id = ' . (int) $item_id;

- $this->db->sql_query($sql);

- public function delete_notifications($notification_type_name, $item_id, $parent_id = false)

- $this->delete_notifications($type, $item_id, $parent_id);

- $sql = 'DELETE FROM ' . $this->notifications_table . '

- WHERE notification_type_id = ' . (int) $notification_type_id . '

- AND ' . $this->db->sql_in_set('item_id', $item_id) .

- (($parent_id !== false) ? ' AND ' . $this->db->sql_in_set('item_parent_id', $parent_id) : '');

- $this->db->sql_query($sql);

- 'id' => $type->get_type(),

- 'lang' => 'NOTIFICATION_TYPE_' . strtoupper($type->get_type()),

- 'group' => 'NOTIFICATION_GROUP_MISCELLANEOUS',

- if ($method instanceof \phpbb\notification\method\method_interface && $method->is_available())

- $subscription_methods[$method_name] = array(

- 'id' => $method->get_type(),

- 'lang' => str_replace('.', '_', strtoupper($method->get_type())),

- );

- $user_id = ($user_id === false) ? $this->user->data['user_id'] : $user_id;

-

- if (empty($user_notifications[$id]))

- {

- // No rows at all, default to ''

- $subscriptions[$id] = array('');

- }

- else

-

- if (!isset($subscriptions[$id]))

- $subscriptions[$id] = array();

-

- $subscriptions[$id][] = $user_notification['method'];

- * @param string $method The method of the notification e.g. '', 'email', or 'jabber'

- public function add_subscription($item_type, $item_id = 0, $method = '', $user_id = false)

- if ($method !== '')

- // Make sure to subscribe them to the base subscription

- $this->add_subscription($item_type, $item_id, '', $user_id);

- * @param string $method The method of the notification e.g. '', 'email', or 'jabber'

- public function delete_subscription($item_type, $item_id = 0, $method = '', $user_id = false)

- $user_id = ($user_id === false) ? $this->user->data['user_id'] : $user_id;

-

- // If no method, make sure that no other notification methods for this item are selected before deleting

- if ($method === '')

- $sql = 'SELECT COUNT(*) as num_notifications

- FROM ' . $this->user_notifications_table . "

- WHERE item_type = '" . $this->db->sql_escape($item_type) . "'

- AND item_id = " . (int) $item_id . '

- AND user_id = ' .(int) $user_id . "

- AND method <> ''

- AND notify = 1";

- $this->db->sql_query($sql);

- $num_notifications = $this->db->sql_fetchfield('num_notifications');

- $this->db->sql_freeresult();

-

- if ($num_notifications)

- return;

- $sql = 'DELETE FROM ' . $this->notifications_table . '

- WHERE notification_type_id = ' . (int) $notification_type_id;

- $this->db->sql_query($sql);

-

- $sql = 'DELETE FROM ' . $this->notification_types_table . '

- WHERE notification_type_id = ' . (int) $notification_type_id;

- $this->db->sql_query($sql);

- $this->cache->destroy('notification_type_ids');

- $sql = 'DELETE FROM ' . $this->notifications_table . '

- WHERE notification_time < ' . (int) $timestamp .

- (($only_read) ? ' AND notification_read = 1' : '');

- $this->db->sql_query($sql);

- $this->config->set('read_notification_last_gc', time(), false);

- * Helper to get the notifications item type class and set it up

- */

- * Helper to get the notifications method class and set it up

- */

- * Helper to load objects (notification types/methods)

- */

- $notification_type_ids = $this->cache->get('notification_type_ids');

-

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

-

- if ($notification_type_ids === false)

- $notification_type_ids = array();

-

- $sql = 'SELECT notification_type_id, notification_type_name

- FROM ' . $this->notification_types_table;

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

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

- {

- $notification_type_ids[$row['notification_type_name']] = (int) $row['notification_type_id'];

- }

- $this->db->sql_freeresult($result);

-

- $this->cache->put('notification_type_ids', $notification_type_ids);

- $this->db->sql_transaction('rollback');

- throw new \phpbb\notification\exception($this->user->lang('NOTIFICATION_TYPE_NOT_EXIST', $notification_type_name));

- $this->cache->put('notification_type_ids', $notification_type_ids);

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

-

- /** @var \phpbb\user_loader */

- protected $user_loader;

-

- /** @var \phpbb\db\driver\driver_interface */

- protected $db;

-

- /** @var \phpbb\cache\driver\driver_interface */

- protected $cache;

-

- /** @var \phpbb\template\template */

- protected $template;

-

- /** @var \phpbb\extension\manager */

- protected $extension_manager;

-

- /** @var \phpbb\user */

- protected $user;

-

- /** @var \phpbb\auth\auth */

- protected $auth;

-

- /** @var \phpbb\config\config */

- protected $config;

-

- /** @var string */

- protected $phpbb_root_path;

-

- /** @var string */

- protected $php_ext;

-

- * Notification Method Base Constructor

- * @param \phpbb\user_loader $user_loader

- * @param \phpbb\db\driver\driver_interface $db

- * @param \phpbb\cache\driver\driver_interface $cache

- * @param \phpbb\user $user

- * @param \phpbb\auth\auth $auth

- * @param \phpbb\config\config $config

- * @param string $phpbb_root_path

- * @param string $php_ext

- * @return \phpbb\notification\method\base

- public function __construct(\phpbb\user_loader $user_loader, \phpbb\db\driver\driver_interface $db, \phpbb\cache\driver\driver_interface $cache, $user, \phpbb\auth\auth $auth, \phpbb\config\config $config, $phpbb_root_path, $php_ext)

- $this->user_loader = $user_loader;

- $this->db = $db;

- $this->cache = $cache;

- $this->user = $user;

- $this->auth = $auth;

- $this->config = $config;

- $this->phpbb_root_path = $phpbb_root_path;

- $this->php_ext = $php_ext;

- * Set notification manager (required)

- * @param \phpbb\notification\manager $notification_manager

- public function set_notification_manager(\phpbb\notification\manager $notification_manager)

- $this->notification_manager = $notification_manager;

- public function is_available()

- return $this->config['email_enable'] && $this->user->data['user_email'];

- public function is_available()

- return ($this->global_available() && $this->user->data['user_jabber']);

- return $this->notify_using_messenger(NOTIFY_IM, 'short/');

- $this->user_loader->load_users($user_ids);

- $board_url = generate_board_url();

- if ($user['user_type'] == USER_IGNORE || ($user['user_type'] == USER_INACTIVE && $user['user_inactive_reason'] == INACTIVE_MANUAL) || in_array($notification->user_id, $banned_users))

- public static $notification_option = array(

- public static function get_item_id($user)

- public static function get_item_parent_id($post)

- return $this->user->lang($this->language_key, $username);

- public function create_insert_array($user, $pre_create_data)

- return parent::create_insert_array($user, $pre_create_data);

- public static $notification_option = array(

- $users[$post['poster_id']] = array('');

- * Function for preparing the data for insertion in an SQL query

- * (The service handles insertion)

- *

- * @param array $post Data from submit_post

- * @param array $pre_create_data Data from pre_create_insert_array()

- *

- * @return array Array of data ready to be inserted into the database

- $data = parent::create_insert_array($post, $pre_create_data);

- $this->notification_time = $data['notification_time'] = time();

- public static $notification_option = array(

- $users[$post['poster_id']] = array('');

- * Function for preparing the data for insertion in an SQL query

- * (The service handles insertion)

- *

- * @param array $post Data from submit_post

- * @param array $pre_create_data Data from pre_create_insert_array()

- *

- * @return array Array of data ready to be inserted into the database

- $data = parent::create_insert_array($post, $pre_create_data);

- $this->notification_time = $data['notification_time'] = time();

- /** @var \phpbb\user_loader */

- protected $user_loader;

-

- /** @var \phpbb\cache\driver\driver_interface */

- protected $cache;

-

- /** @var \phpbb\template\template */

- protected $template;

- /** @var \phpbb\config\config */

- protected $config;

-

- protected $notification_types_table;

-

- /** @var string */

- protected $notifications_table;

-

- /** @var string */

- public static $notification_option = false;

- * Indentification data

- * Notification Type Base Constructor

- *

- * @param \phpbb\user_loader $user_loader

- * @param \phpbb\db\driver\driver_interface $db

- * @param \phpbb\cache\driver\driver_interface $cache

- * @param \phpbb\user $user

- * @param \phpbb\auth\auth $auth

- * @param \phpbb\config\config $config

- * @param string $phpbb_root_path

- * @param string $php_ext

- * @param string $notification_types_table

- * @param string $notifications_table

- * @param string $user_notifications_table

- * @return \phpbb\notification\type\base

- */

- public function __construct(\phpbb\user_loader $user_loader, \phpbb\db\driver\driver_interface $db, \phpbb\cache\driver\driver_interface $cache, $user, \phpbb\auth\auth $auth, \phpbb\config\config $config, $phpbb_root_path, $php_ext, $notification_types_table, $notifications_table, $user_notifications_table)

- $this->user_loader = $user_loader;

- $this->cache = $cache;

- $this->config = $config;

- $this->notification_types_table = $notification_types_table;

- $this->notifications_table = $notifications_table;

- * Function for preparing the data for insertion in an SQL query

- * (The service handles insertion)

- *

- * @param array $type_data Data unique to this notification type

- * @param array $pre_create_data Data from pre_create_insert_array()

- * @return array Array of data ready to be inserted into the database

- 'notification_data' => array(),

- $data = $this->create_insert_array($type_data);

- * Load the special items (fall back)

- */

- * Pre create insert array function (fall back)

- *

- * @return array

- */

- * Find the users who want to receive notifications (helper)

- *

- * @param array $user_ids User IDs to check if they want to receive notifications

- * (Bool False to check all users besides anonymous and bots (USER_IGNORE))

- *

- * @return array

- */

- $rowset = $resulting_user_ids = array();

- $resulting_user_ids[] = $row['user_id'];

-

- if (!$row['notify'] || (isset($options['ignore_users'][$row['user_id']]) && in_array($row['method'], $options['ignore_users'][$row['user_id']])))

- $rowset[$row['user_id']][] = $row['method'];

- if (!in_array($user_id, $resulting_user_ids) && !isset($options['ignore_users'][$user_id]))

- // No rows at all for this user, default to ''

- $rowset[$user_id] = array('');

- return $rowset;

- $where = array(

- 'notification_type_id = ' . (int) $this->notification_type_id,

- 'item_id = ' . (int) $this->item_id,

- 'user_id = ' . (int) $this->user_id,

- );

- $where = implode(' AND ', $where);

-

- $sql = 'UPDATE ' . $this->notifications_table . '

- SET notification_read = ' . (int) $this->notification_read . '

- WHERE ' . $where;

- $this->db->sql_query($sql);

- public static $notification_option = array(

- $update_notifications = array();

- $sql = 'SELECT n.*

- FROM ' . $this->notifications_table . ' n, ' . $this->notification_types_table . ' nt

- WHERE n.notification_type_id = ' . (int) $this->notification_type_id . '

- AND n.item_parent_id = ' . (int) static::get_item_parent_id($post) . '

- AND n.notification_read = 0

- AND nt.notification_type_id = n.notification_type_id

- AND nt.notification_type_enabled = 1';

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

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

- // Do not create a new notification

- unset($notify_users[$row['user_id']]);

- $notification = $this->notification_manager->get_item_type_class($this->get_type(), $row);

- $sql = 'UPDATE ' . $this->notifications_table . '

- SET ' . $this->db->sql_build_array('UPDATE', $update_responders) . '

- WHERE notification_id = ' . $row['notification_id'];

- $this->db->sql_query($sql);

- $this->db->sql_freeresult($result);

- public static $notification_option = array(

- return $this->user->lang($this->language_key);

- return $this->user->lang(

- return $this->user->lang(

- * Function for preparing the data for insertion in an SQL query

- * (The service handles insertion)

- *

- * @param array $post Data from submit_post

- * @param array $pre_create_data Data from pre_create_insert_array()

- *

- * @return array Array of data ready to be inserted into the database

- $data = parent::create_insert_array($post);

- $this->notification_time = $data['notification_time'] = time();

- public static $notification_option = array(

- return $this->user->lang($this->language_key);

- return $this->user->lang(

- return $this->user->lang(

- * Function for preparing the data for insertion in an SQL query

- * (The service handles insertion)

- *

- * @param array $post Data from submit_post

- * @param array $pre_create_data Data from pre_create_insert_array()

- *

- * @return array Array of data ready to be inserted into the database

- $data = parent::create_insert_array($post, $pre_create_data);

- $this->notification_time = $data['notification_time'] = time();

- public static $notification_option = array(

- public static function get_item_id($group)

- public static function get_item_parent_id($group)

- return $this->user->lang('NOTIFICATION_GROUP_REQUEST', $username, $this->get_data('group_name'));

- return parent::create_insert_array($group, $pre_create_data);

- public static function get_item_id($group)

- public static function get_item_parent_id($group)

- $users[$user_id] = array('');

- return $this->user->lang('NOTIFICATION_GROUP_REQUEST_APPROVED', $this->get_data('group_name'));

- return parent::create_insert_array($group, $pre_create_data);

- public static $notification_option = array(

- public static function get_item_id($pm)

- public static function get_item_parent_id($pm)

- if (!sizeof($pm['recipients']))

- return $this->user->lang('NOTIFICATION_PM', $username);

- return $this->user->lang(

- * Function for preparing the data for insertion in an SQL query

- * (The service handles insertion)

- *

- * @param array $pm Data from submit_post

- * @param array $pre_create_data Data from pre_create_insert_array()

- *

- * @return array Array of data ready to be inserted into the database

- return parent::create_insert_array($pm, $pre_create_data);

- public static $notification_option = array(

- public static function get_item_id($post)

- public static function get_item_parent_id($post)

- $update_notifications = array();

- $sql = 'SELECT n.*

- FROM ' . $this->notifications_table . ' n, ' . $this->notification_types_table . ' nt

- WHERE n.notification_type_id = ' . (int) $this->notification_type_id . '

- AND n.item_parent_id = ' . (int) static::get_item_parent_id($post) . '

- AND n.notification_read = 0

- AND nt.notification_type_id = n.notification_type_id

- AND nt.notification_type_enabled = 1';

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

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

- // Do not create a new notification

- unset($notify_users[$row['user_id']]);

- $notification = $this->notification_manager->get_item_type_class($this->get_type(), $row);

- $sql = 'UPDATE ' . $this->notifications_table . '

- SET ' . $this->db->sql_build_array('UPDATE', $update_responders) . '

- WHERE notification_id = ' . $row['notification_id'];

- $this->db->sql_query($sql);

- $this->db->sql_freeresult($result);

- $responders_cnt = sizeof($responders);

- $trimmed_responders_cnt = $responders_cnt - sizeof($responders);

- $usernames[] = $this->user->lang('NOTIFICATION_MANY_OTHERS');

- $usernames[] = $this->user->lang('NOTIFICATION_X_OTHERS', $trimmed_responders_cnt);

- return $this->user->lang(

- return $this->user->lang(

- if (sizeof($users) > 4)

- if (!sizeof($notify_users) || !$this->inherit_read_status)

- * Function for preparing the data for insertion in an SQL query

- * (The service handles insertion)

- *

- * @param array $post Data from submit_post

- * @param array $pre_create_data Data from pre_create_insert_array()

- *

- * @return array Array of data ready to be inserted into the database

- return parent::create_insert_array($post, $pre_create_data);

- if (sizeof($responders) > 25)

- return array('notification_data' => $serialized_data);

- public static $notification_option = array(

- * Function for preparing the data for insertion in an SQL query

- * (The service handles insertion)

- *

- * @param array $post Data from submit_post

- * @param array $pre_create_data Data from pre_create_insert_array()

- *

- * @return array Array of data ready to be inserted into the database

- $data = parent::create_insert_array($post, $pre_create_data);

- $this->notification_time = $data['notification_time'] = time();

- * regular expression to match to find usernames

- *

- * @var string

- */

- protected static $regular_expression_match = '#\[quote=&quot;(.+?)&quot;#';

-

- /**

- public static $notification_option = array(

- $usernames = false;

- preg_match_all(static::$regular_expression_match, $post['post_text'], $usernames);

- if (empty($usernames[1]))

- $usernames[1] = array_unique($usernames[1]);

- $usernames = array_map('utf8_clean_string', $usernames[1]);

- $old_notifications = array();

- $sql = 'SELECT n.user_id

- FROM ' . $this->notifications_table . ' n, ' . $this->notification_types_table . ' nt

- WHERE n.notification_type_id = ' . (int) $this->notification_type_id . '

- AND n.item_id = ' . static::get_item_id($post) . '

- AND nt.notification_type_id = n.notification_type_id

- AND nt.notification_type_enabled = 1';

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

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

- {

- $old_notifications[] = $row['user_id'];

- }

- $this->db->sql_freeresult($result);

- $remove_notifications = array_diff($old_notifications, array_keys($notifications));

- foreach (array_diff(array_keys($notifications), $old_notifications) as $user_id)

- $sql = 'DELETE FROM ' . $this->notifications_table . '

- WHERE notification_type_id = ' . (int) $this->notification_type_id . '

- AND item_id = ' . static::get_item_id($post) . '

- AND ' . $this->db->sql_in_set('user_id', $remove_notifications);

- $this->db->sql_query($sql);

- public static $notification_option = array(

- public static function get_item_parent_id($pm)

- $user_data = $this->user_loader->get_user($this->get_data('reporter_id'));

- 'AUTHOR_NAME' => htmlspecialchars_decode($user_data['username']),

- 'SUBJECT' => htmlspecialchars_decode(censor_text($this->get_data('message_subject'))),

- 'U_VIEW_REPORT' => generate_board_url() . "mcp.{$this->php_ext}?r={$this->item_parent_id}&amp;i=pm_reports&amp;mode=pm_report_details",

- $this->user->add_lang('mcp');

- return $this->user->lang(

- return $this->user->lang(

- return $this->user->lang(

- if (isset($this->user->lang[$this->get_data('reason_title')]))

- return $this->user->lang(

- $this->user->lang[$this->get_data('reason_title')]

- return $this->user->lang(

- return array($this->get_data('reporter_id'));

- }

- * Function for preparing the data for insertion in an SQL query

- * (The service handles insertion)

- *

- * @param array $post Data from submit_post

- * @param array $pre_create_data Data from pre_create_insert_array()

- *

- * @return array Array of data ready to be inserted into the database

- return parent::create_insert_array($post, $pre_create_data);

- return array($pm['reporter'] => array(''));

- return $this->user->lang(

- return $this->user->lang(

- * Function for preparing the data for insertion in an SQL query

- * (The service handles insertion)

- *

- * @param array $pm PM Data

- * @param array $pre_create_data Data from pre_create_insert_array()

- *

- * @return array Array of data ready to be inserted into the database

- $data = parent::create_insert_array($pm, $pre_create_data);

- $this->notification_time = $data['notification_time'] = time();

- public static $notification_option = array(

- $this->user->add_lang('mcp');

- return $this->user->lang(

- return $this->user->lang(

- return $this->user->lang(

- if (isset($this->user->lang[$this->get_data('reason_title')]))

- return $this->user->lang(

- $this->user->lang[$this->get_data('reason_title')]

- return $this->user->lang(

- * Function for preparing the data for insertion in an SQL query

- * (The service handles insertion)

- *

- * @param array $post Data from submit_post

- * @param array $pre_create_data Data from pre_create_insert_array()

- *

- * @return array Array of data ready to be inserted into the database

- return parent::create_insert_array($post, $pre_create_data);

- return array($post['reporter'] => array(''));

- return $this->user->lang(

- return $this->user->lang(

- * Function for preparing the data for insertion in an SQL query

- * (The service handles insertion)

- *

- * @param array $post Data from submit_post

- * @param array $pre_create_data Data from pre_create_insert_array()

- *

- * @return array Array of data ready to be inserted into the database

- $data = parent::create_insert_array($post, $pre_create_data);

- $this->notification_time = $data['notification_time'] = time();

- public static $notification_option = array(

- public static function get_item_id($post)

- public static function get_item_parent_id($post)

- return $this->user->lang(

- return $this->user->lang(

- return $this->user->lang(

- if (!sizeof($notify_users) || !$this->inherit_read_status)

- * Function for preparing the data for insertion in an SQL query

- * (The service handles insertion)

- *

- * @param array $post Data from submit_post

- * @param array $pre_create_data Data from pre_create_insert_array()

- *

- * @return array Array of data ready to be inserted into the database

- return parent::create_insert_array($post, $pre_create_data);

- public static $notification_option = array(

- * Function for preparing the data for insertion in an SQL query

- * (The service handles insertion)

- *

- * @param array $topic Data from submit_post

- * @param array $pre_create_data Data from pre_create_insert_array()

- *

- * @return array Array of data ready to be inserted into the database

- $data = parent::create_insert_array($topic, $pre_create_data);

- $this->notification_time = $data['notification_time'] = time();

- public static function get_item_id($type_data);

- public static function get_item_parent_id($type_data);

- * (The service handles insertion)

- public function create_insert_array($type_data, $pre_create_data);

- public function mark_read($return);

- public function mark_unread($return);