$schema_data['phpbb_notifications'] = array(

'COLUMNS' => array(

),

'PRIMARY_KEY' => 'notification_id',

'KEYS' => array(

$options = array_merge(array(

'notification_id' => false,

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

'order_dir' => 'DESC',

'limit' => 0,

'start' => 0,

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

SET unread = 0

(($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) : '') .

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

}

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

SET unread = 0

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

(($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) : '');

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

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

SET unread = 0

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

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

}

public function prune_notifications($timestamp)

{

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

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

}

{

return 'approve_post';

}

/**

* Language key used to output the text

*

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

return $data;

}

{

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

return $data;

}

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

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

'unread' => true,

'data' => array(),

// Unset data unique to each row

unset(

$data['notification_id'],

$data['unread'],

$data['user_id']

'FORMATTED_TITLE' => $this->get_title(),

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

'UNREAD' => $this->unread,

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

return $data;

}

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

return $data;

}

$this->set_data('forum_name', $post['forum_name']);

// Topics can be "read" before they are public (while awaiting approval).

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

{

$this->unread = false;

}

{

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

return $data;

}

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

return $data;

}

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

return $data;

}

$this->set_data('forum_name', $post['forum_name']);

// Topics can be "read" before they are public (while awaiting approval).

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

{

$this->unread = false;

}

{

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

return $data;

}

),

NOTIFICATIONS_TABLE => array(

'COLUMNS' => array(

),

'PRIMARY_KEY' => 'notification_id',

'KEYS' => array(

item_parent_id INTEGER DEFAULT 0 NOT NULL,

user_id INTEGER DEFAULT 0 NOT NULL,

unread INTEGER DEFAULT 1 NOT NULL,

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

);;

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

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

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

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

) ON [PRIMARY]

GO

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

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

unread tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,

data blob NOT NULL,

PRIMARY KEY (notification_id),

KEY item_ident (item_type, item_id),

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

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

unread tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,

data text NOT NULL,

PRIMARY KEY (notification_id),

KEY item_ident (item_type, item_id),

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

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

unread number(1) DEFAULT '1' NOT NULL,

data clob DEFAULT '' ,

CONSTRAINT pk_phpbb_notifications PRIMARY KEY (notification_id)

)

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

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

unread INT2 DEFAULT '1' NOT NULL CHECK (unread >= 0),

data varchar(4000) DEFAULT '' NOT NULL,

PRIMARY KEY (notification_id)

);

item_parent_id INTEGER UNSIGNED NOT NULL DEFAULT '0',

user_id INTEGER UNSIGNED NOT NULL DEFAULT '0',

unread INTEGER UNSIGNED NOT NULL DEFAULT '1',

data text(65535) NOT NULL DEFAULT ''

);

'item_parent_id' => 1,

'user_id' => 0,

'unread' => 1,

'data' => array(),

),

2 => array(

'item_parent_id' => 2,

'user_id' => 0,

'unread' => 1,

'data' => array(),

),

3 => array(

'item_parent_id' => 2,

'user_id' => 0,

'unread' => 1,

'data' => array(),

),

4 => array(

'item_parent_id' => 2,

'user_id' => 0,

'unread' => 1,

'data' => array(

'poster_id' => 2,

'topic_title' => 'test-title',

'item_parent_id' => 2,

'user_id' => 0,

'unread' => 1,

'data' => array(

'poster_id' => 2,

'topic_title' => 'test-title',

'item_parent_id' => 2,

'user_id' => 0,

'unread' => 1,

'data' => array(),

),

2 => array(

'item_parent_id' => 2,

'user_id' => 0,

'unread' => 1,

'data' => array(),

),

3 => array(

'item_parent_id' => 2,

'user_id' => 0,

'unread' => 1,

'data' => array(),

),

4 => array(

'item_parent_id' => 2,

'user_id' => 0,

'unread' => 1,

'data' => array(

'poster_id' => 2,

'topic_title' => 'test-title',

'item_parent_id' => 2,

'user_id' => 0,

'unread' => 1,

'data' => array(

'poster_id' => 2,

'topic_title' => 'test-title2',