'item_id' => array('UINT', 0),

'item_parent_id' => array('UINT', 0),

'user_id' => array('UINT', 0),

'notification_time' => array('TIMESTAMP', 1),

'data' => array('TEXT_UNI', ''),

),

'PRIMARY_KEY' => 'notification_id',

'KEYS' => array(

'item_ident' => array('INDEX', array('item_type', 'item_id')),

),

);

$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.unread = 1

AND nt.notification_type = n.item_type

AND nt.notification_type_enabled = 1';

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

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

$sql = 'SELECT n.*

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

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

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

AND nt.notification_type = n.item_type

AND nt.notification_type_enabled = 1

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

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

WHERE notification_time <= " . $time .

(($item_type !== false) ? ' AND ' . (is_array($item_type) ? $this->db->sql_in_set('item_type', $item_type) : " item_type = '" . $this->db->sql_escape($item_type) . "'") : '') .

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

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

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

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

AND notification_time <= " . $time .

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

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

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

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

WHERE notification_time <= " . $time . '

AND ' . ((is_array($notification_id)) ? $this->db->sql_in_set('notification_id', $notification_id) : 'notification_id = ' . (int) $notification_id);

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

'item_type' => $this->get_type(),

'item_parent_id' => static::get_item_parent_id($type_data),

'data' => array(),

), $this->data);

unset(

$data['notification_time'], // Also unsetting time, since it always tries to change the time to current (if you actually need to change the time, over-ride this function)

$data['notification_id'],

$data['user_id']

);

'URL' => $this->get_url(),

'TIME' => $this->user->format_date($this->notification_time),

);

}

*/

protected function mark($unread = true, $return = false)

{

$where = array(

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

}

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

WHERE ' . $where;

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

}

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

WHERE n.item_type = '" . $this->get_type() . "'

AND n.item_parent_id = " . (int) self::get_item_parent_id($post) . '

AND nt.notification_type = n.item_type

AND nt.notification_type_enabled = 1';

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

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

WHERE n.item_type = '" . $this->get_type() . "'

AND n.item_parent_id = " . (int) self::get_item_parent_id($post) . '

AND nt.notification_type = n.item_type

AND nt.notification_type_enabled = 1';

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

// Make sure that if the user has read the topic, it's marked as read in the notification

if (isset($pre_create_data[$this->user_id]) && $pre_create_data[$this->user_id] >= $this->notification_time)

{

}

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

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

WHERE n.item_type = '" . $this->get_type() . "'

AND n.item_parent_id = " . (int) self::get_item_parent_id($post) . '

AND nt.notification_type = n.item_type

AND nt.notification_type_enabled = 1';

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

// Make sure that if the user has read the topic, it's marked as read in the notification

if (isset($pre_create_data[$this->user_id]) && $pre_create_data[$this->user_id] >= $this->notification_time)

{

}

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

'item_id' => array('UINT', 0),

'item_parent_id' => array('UINT', 0),

'user_id' => array('UINT', 0),

'is_enabled' => array('BOOL', 1),

'notification_time' => array('TIMESTAMP', 1),

'data' => array('TEXT_UNI', ''),

'PRIMARY_KEY' => 'notification_id',

'KEYS' => array(

'item_ident' => array('INDEX', array('item_type', 'item_id')),

),

),

USER_NOTIFICATIONS_TABLE => array(

item_id INTEGER DEFAULT 0 NOT NULL,

item_parent_id INTEGER DEFAULT 0 NOT NULL,

user_id INTEGER DEFAULT 0 NOT NULL,

notification_time INTEGER DEFAULT 1 NOT NULL,

data BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL

);;

ALTER TABLE phpbb_notifications ADD PRIMARY KEY (notification_id);;

CREATE INDEX phpbb_notifications_item_ident ON phpbb_notifications(item_type, item_id);;

CREATE GENERATOR phpbb_notifications_gen;;

SET GENERATOR phpbb_notifications_gen TO 0;;

[item_id] [int] DEFAULT (0) NOT NULL ,

[item_parent_id] [int] DEFAULT (0) NOT NULL ,

[user_id] [int] DEFAULT (0) NOT NULL ,

[notification_time] [int] DEFAULT (1) NOT NULL ,

[data] [varchar] (4000) DEFAULT ('') NOT NULL

) ON [PRIMARY]

CREATE INDEX [item_ident] ON [phpbb_notifications]([item_type], [item_id]) ON [PRIMARY]

GO

GO

item_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

item_parent_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

notification_time int(11) UNSIGNED DEFAULT '1' NOT NULL,

data blob NOT NULL,

PRIMARY KEY (notification_id),

KEY item_ident (item_type, item_id),

);

item_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

item_parent_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

notification_time int(11) UNSIGNED DEFAULT '1' NOT NULL,

data text NOT NULL,

PRIMARY KEY (notification_id),

KEY item_ident (item_type, item_id),

) CHARACTER SET `utf8` COLLATE `utf8_bin`;

item_id number(8) DEFAULT '0' NOT NULL,

item_parent_id number(8) DEFAULT '0' NOT NULL,

user_id number(8) DEFAULT '0' NOT NULL,

notification_time number(11) DEFAULT '1' NOT NULL,

data clob DEFAULT '' ,

CONSTRAINT pk_phpbb_notifications PRIMARY KEY (notification_id)

CREATE INDEX phpbb_notifications_item_ident ON phpbb_notifications (item_type, item_id)

/

/

CREATE SEQUENCE phpbb_notifications_seq

item_id INT4 DEFAULT '0' NOT NULL CHECK (item_id >= 0),

item_parent_id INT4 DEFAULT '0' NOT NULL CHECK (item_parent_id >= 0),

user_id INT4 DEFAULT '0' NOT NULL CHECK (user_id >= 0),

notification_time INT4 DEFAULT '1' NOT NULL CHECK (notification_time >= 0),

data varchar(4000) DEFAULT '' NOT NULL,

PRIMARY KEY (notification_id)

);

CREATE INDEX phpbb_notifications_item_ident ON phpbb_notifications (item_type, item_id);

/*

Table: 'phpbb_poll_options'

item_id INTEGER UNSIGNED NOT NULL DEFAULT '0',

item_parent_id INTEGER UNSIGNED NOT NULL DEFAULT '0',

user_id INTEGER UNSIGNED NOT NULL DEFAULT '0',

notification_time INTEGER UNSIGNED NOT NULL DEFAULT '1',

data text(65535) NOT NULL DEFAULT ''

);

CREATE INDEX phpbb_notifications_item_ident ON phpbb_notifications (item_type, item_id);

# Table: 'phpbb_poll_options'

CREATE TABLE phpbb_poll_options (

'item_id' => 1,

'item_parent_id' => 1,

'user_id' => 0,

'notification_time' => 1349413321,

'data' => array(),

),

'item_id' => 2,

'item_parent_id' => 2,

'user_id' => 0,

'notification_time' => 1349413322,

'data' => array(),

),

'item_id' => 3,

'item_parent_id' => 2,

'user_id' => 0,

'notification_time' => 1349413323,

'data' => array(),

),

'item_id' => 4,

'item_parent_id' => 2,

'user_id' => 0,

'notification_time' => 1349413324,

'data' => array(

'poster_id' => 2,

'item_id' => 5,

'item_parent_id' => 2,

'user_id' => 0,

'notification_time' => 1349413325,

'data' => array(

'poster_id' => 2,

'item_id' => 1,

'item_parent_id' => 2,

'user_id' => 0,

'notification_time' => 1349413321,

'data' => array(),

),

'item_id' => 2,

'item_parent_id' => 2,

'user_id' => 0,

'notification_time' => 1349413322,

'data' => array(),

),

'item_id' => 3,

'item_parent_id' => 2,

'user_id' => 0,

'notification_time' => 1234,

'data' => array(),

),

'item_id' => 4,

'item_parent_id' => 2,

'user_id' => 0,

'notification_time' => 1349413324,

'data' => array(

'poster_id' => 2,

'item_id' => 5,

'item_parent_id' => 2,

'user_id' => 0,

'notification_time' => 1349413325,

'data' => array(

'poster_id' => 2,