Attachment #1350 for bug #3922

(-)classes/core/PKPApplication.inc.php (+2 lines)

Lines 186-191	Link Here

186

			'CurrencyDAO' => 'currency.CurrencyDAO',

186

			'CurrencyDAO' => 'currency.CurrencyDAO',

187

			'HelpTocDAO' => 'help.HelpTocDAO',

187

			'HelpTocDAO' => 'help.HelpTocDAO',

188

			'HelpTopicDAO' => 'help.HelpTopicDAO',

188

			'HelpTopicDAO' => 'help.HelpTopicDAO',

189

			'NotificationDAO' => 'notification.NotificationDAO',

190

			'NotificationSettingsDAO' => 'notification.NotificationSettingsDAO',

189

			'ScheduledTaskDAO' => 'scheduledTask.ScheduledTaskDAO',

191

			'ScheduledTaskDAO' => 'scheduledTask.ScheduledTaskDAO',

190

			'SessionDAO' => 'session.SessionDAO',

192

			'SessionDAO' => 'session.SessionDAO',

191

			'SiteDAO' => 'site.SiteDAO',

193

			'SiteDAO' => 'site.SiteDAO',




<?php

/**
 * @file classes/notification/Notification.inc.php
 *
 * Copyright (c) 2003-2008 John Willinsky
 * Distributed under the GNU GPL v2. For full terms see the file docs/COPYING.
 *
 * @class Notification
 * @ingroup notification
 * @see NotificationDAO
 * @brief Class for Notification.
 */

// $Id: Notification.inc.php,v 1.10 2008/07/01 01:16:09 asmecher Exp $


/** Notification associative types. */
// Submission Events				0x10000000
define('NOTIFICATION_TYPE_ARTICLE_SUBMITTED', 		0x1000001);
define('NOTIFICATION_TYPE_METADATA_MODIFIED', 		0x1000002);
define('NOTIFICATION_TYPE_SUPP_FILE_ADDED', 			0x1000003);
define('NOTIFICATION_TYPE_SUPP_FILE_MODIFIED', 		0x1000004);
define('NOTIFICATION_TYPE_GALLEY_ADDED', 				0x1000005);
define('NOTIFICATION_TYPE_GALLEY_MODIFIED', 			0x1000006);
define('NOTIFICATION_TYPE_SUBMISSION_COMMENT', 		0x1000007);
define('NOTIFICATION_TYPE_LAYOUT_COMMENT', 			0x1000008);
define('NOTIFICATION_TYPE_COPYEDIT_COMMENT', 			0x1000009);
define('NOTIFICATION_TYPE_PROOFREAD_COMMENT', 		0x1000010);
define('NOTIFICATION_TYPE_REVIEWER_COMMENT', 			0x1000011);
define('NOTIFICATION_TYPE_REVIEWER_FORM_COMMENT', 	0x1000012);
define('NOTIFICATION_TYPE_EDITOR_DECISION_COMMENT', 	0x1000013);

// Other events
define('NOTIFICATION_TYPE_USER_COMMENT', 				0x2000002);
define('NOTIFICATION_TYPE_PUBLISHED_ISSUE', 			0x2000003);

import('notification.NotificationDAO');

class Notification extends DataObject {

	/**
	 * Constructor.
	 */
	function Notification() {
		parent::DataObject();
	}
	
	/**
	 * Create a new notification with the specified arguments and insert into DB
	 * This is a static method
	 * @param $userId int
	 * @param $contents string
	 * @param $param string
	 * @param $location string
	 * @param $isLocalized bool
	 * @param $assocType int
	 * @param $assocId int
	 * @return Notification object
	 */
	function createNotification($userId, $contents, $param, $location, $isLocalized, $assocType, $assocId) {
		$notification = new Notification();
		$context =& Request::getContext();
		$contextId = $context->getId();

		$notification->setUserId($userId);
		$notification->setContents($contents);
		$notification->setParam($param);
		$notification->setLocation($location);
		$notification->setIsLocalized($isLocalized);
		$notification->setAssocType($assocType);
		$notification->setContext($contextId);
		
		$notificationDao = &DAORegistry::getDAO('NotificationDAO');
		$notificationDao->insertNotification($notification);
		
		return $notification;
	}

	/**
	 * get notification id
	 * @return int
	 */
	function getNotificationId() {
		return $this->getData('notificationId');
	}

	/**
	 * set notification id
	 * @param $commentId int
	 */
	function setNotificationId($notificationId) {
		return $this->setData('notificationId', $notificationId);
	}
	
	/**
	 * get user id associated with this notification
	 * @return int
	 */
	function getUserId() {
		return $this->getData('userId');
	}
	
	/**
	 * set user id associated with this notification
	 * @param $userId int
	 */
	function setUserId($userId) {
		return $this->setData('userId', $userId);
	}
	
	/**
	 * get date notification was created
	 * @return date (YYYY-MM-DD HH:MM:SS)
	 */
	function getDateCreated() {
		return $this->getData('dateCreated');
	}
	
	/**
	 * set date notification was created
	 * @param $dateCreated date (YYYY-MM-DD HH:MM:SS)
	 */
	function setDateCreated($dateCreated) {
		return $this->setData('dateCreated', $dateCreated);
	}
	
	/**
	 * get date notification is read by user
	 * @return date (YYYY-MM-DD HH:MM:SS)
	 */
	function getDateRead() {
		return $this->getData('dateRead');
	}
	
	/**
	 * set date notification is read by user
	 * Also sets setisUnread() if $dateRead is null
	 * @param $dateRead date (YYYY-MM-DD HH:MM:SS)
	 */
	function setDateRead($dateRead) {
		if(!isset($dateRead)) {
			$this->setIsUnread(true);
			$notificationDao = &DAORegistry::getDAO('NotificationDAO');
			$notificationDao->setDateRead($this->getNotificationId());
		} else {
			$this->setIsUnread(false);
			return $this->setData('dateRead', $dateRead);	
		}
	}
	
	/**
	 * return true if reading for the first time
	 * @return bool
	 */
	function getIsUnread() {
		return $this->getData('isUnread');
	}
	
	/**
	 * set to true if notification has not been read
	 * @param $isUnread bool
	 */
	function setIsUnread($isUnread) {
		return $this->setData('isUnread', $isUnread);
	}
	
	/**
	 * get notification contents
	 * @return string
	 */
	function getContents() {
		return $this->getData('contents');
	}
	
	/**
	 * set notification contents
	 * @param $contents int
	 */
	function setContents($contents) {
		return $this->setData('contents', $contents);
	}
	
	/**
	 * get optional parameter (e.g. article title)
	 * @return string
	 */
	function getParam() {
		return $this->getData('param');
	}
	
	/**
	 * set optional parameter
	 * @param $param int
	 */
	function setParam($param) {
		return $this->setData('param', $param);
	}
	
	/**
	 * get URL that notification refers to
	 * @return int
	 */
	function getLocation() {
		return $this->getData('location');
	}
	
	/**
	 * set URL that notification refers to
	 * @param $location int
	 */
	function setLocation($location) {
		return $this->setData('location', $location);
	}
	
	/**
	 * return true if message is localized (i.e. a system message)
	 * @return int
	 */
	function getIsLocalized() {
		return $this->getData('isLocalized');
	}
	
	/**
	 * set to true if message is localized (i.e. is a system message)
	 * @param $isLocalized int
	 */
	function setIsLocalized($isLocalized) {
		return $this->setData('isLocalized', $isLocalized);
	}

	/**
	 * get notification type
	 * @return int
	 */
	function getAssocType() {
		return $this->getData('assocType');
	}

	/**
	 * set notification type
	 * @param $assocType int
	 */
	function setAssocType($assocType) {
		return $this->setData('assocType', $assocType);
	}
	
	/**
	 * get context id
	 * @return int
	 */
	function getContext() {
		return $this->getData('context');
	}
	/**
	 * set context id
	 * @param $context int
	 */
	function setContext($context) {
		return $this->setData('context', $context);
	}	
	
	/**
	 * return the path to the icon for this type
	 * @return string
	 */
	function getIconLocation() {
		$baseUrl = Request::getBaseUrl() . '/lib/pkp/templates/images/icons/';
		switch ($this->getAssocType()) {
			case NOTIFICATION_TYPE_ARTICLE_SUBMITTED:
			case NOTIFICATION_TYPE_GALLEY_ADDED:
			case NOTIFICATION_TYPE_SUPP_FILE_ADDED:
				return $baseUrl . 'page_new.png';
				break;
			case NOTIFICATION_TYPE_SUPP_FILE_MODIFIED:
			case NOTIFICATION_TYPE_SUPP_FILE_ADDED:
				return $baseUrl . 'page_attachment.png';
				break;
			
			case NOTIFICATION_TYPE_METADATA_MODIFIED:
			case NOTIFICATION_TYPE_GALLEY_MODIFIED:
				return $baseUrl . 'edit.png';
				break;
			case NOTIFICATION_TYPE_SUBMISSION_COMMENT:
			case NOTIFICATION_TYPE_LAYOUT_COMMENT:
			case NOTIFICATION_TYPE_COPYEDIT_COMMENT:
			case NOTIFICATION_TYPE_PROOFREAD_COMMENT:
			case NOTIFICATION_TYPE_REVIEWER_COMMENT:
			case NOTIFICATION_TYPE_REVIEWER_FORM_COMMENT:
			case NOTIFICATION_TYPE_EDITOR_DECISION_COMMENT:
			case NOTIFICATION_TYPE_USER_COMMENT:
				return $baseUrl . 'comment_new.png';
				break;
			case NOTIFICATION_TYPE_PUBLISHED_ISSUE:
				return $baseUrl . 'list_world.png';
				break;
			default:
				return $baseUrl . 'page_alert.png';
		}
		
		
	}

 }

?>




<?php

/**
 * @file classes/notification/NotificationDAO.inc.php
 *
 * Copyright (c) 2003-2008 John Willinsky
 * Distributed under the GNU GPL v2. For full terms see the file docs/COPYING.
 *
 * @class NotificationDAO
 * @ingroup notification
 * @see Notification
 *
 * @brief Operations for retrieving and modifying Notification objects.
 */

// $Id: NotificationDAO.inc.php,v 1.19 2008/11/05 00:46:39 mcrider Exp $

import('notification.Notification');

class NotificationDAO extends DAO {
	/**
	 * Constructor.
	 */
	function NotificationDAO() {
		parent::DAO();
	}
	
	/**
	 * Retrieve Notification by notification id
	 * @param $notificationId int
	 * @return Notification object
	 */
	function &getNotificationById($notificationId) {
		$result = &$this->retrieve(
			'SELECT * FROM notifications WHERE notification_id = ?', $notificationId
		);
	
		$notification = &$this->_returnNotificationFromRow($result->GetRowAssoc(false));
	
		$result->Close();
		unset($result);
	
		return $notification;
	}	
	
	/**
	 * Retrieve Notifications by user id
	 * @param $userId int
	 * @return Notification objects array
	 */
	function &getNotificationsByUserId($userId) {
		$application =& PKPApplication::getApplication();
		$productName = $application->getName();
		$context =& Request::getContext();
		$contextId = $context->getId();
		
		$notifications = array();
	
		$result = &$this->retrieve(
			'SELECT * FROM notifications WHERE user_id = ? AND product = ? AND context = ? ORDER BY date_created DESC',	
			array($userId, $productName, $contextId)
		);
	
		$returner = new DAOResultFactory($result, $this, '_returnNotificationFromRow');
		
		return $returner;
	}
	
	/**
	 * Retrieve Notifications by notification id
	 * @param $notificationId int
	 * @return boolean
	 */
	function setDateRead($notificationId) {
		$returner = $this->update(
			sprintf('UPDATE notifications
				SET date_read = %s
				WHERE notification_id = ?',
				$this->datetimeToDB(date('Y-m-d H:i:s'))),
			array(
				$notificationId
			)
		);

		return $returner;
	}
	
	/**
	 * Creates and returns an notification object from a row
	 * @param $row array
	 * @return Notification object
	 */
	function &_returnNotificationFromRow($row) {
		$notification = new Notification();
		$notification->setNotificationId($row['notification_id']);
		$notification->setUserId($row['user_id']);
		$notification->setDateCreated($row['date_created']);
		$notification->setDateRead($row['date_read']);
		$notification->setContents($row['contents']);
		$notification->setParam($row['param']);
		$notification->setLocation($row['location']);
		$notification->setIsLocalized($row['is_localized']);
		$notification->setContext($row['context']);
		$notification->setAssocType($row['assoc_type']);
		
		HookRegistry::call('NotificationDAO::_returnNotificationFromRow', array(&$notification, &$row));
	
		return $notification;
	}
	
	/**
	 * Inserts a new notification into notifications table
	 * @param Notification object
	 * @return int Notification Id 
	 */
	function insertNotification(&$notification) {
		$application =& PKPApplication::getApplication();
		$productName = $application->getName();
		
		if ($this->notificationAlreadyExists($notification)) {
			return 0;
		}
		
		$notificationSettingsDao = &DAORegistry::getDAO('NotificationSettingsDAO');
		$notificationSettings = $notificationSettingsDao->getNotificationSettings($notification->getUserId());
		$notificationEmailSettings = $notificationSettingsDao->getNotificationEmailSettings($notification->getUserId());
		
		if(in_array($notification->getAssocType(), $notificationEmailSettings)) {
			$this->sendNotificationEmail($notification);
		}
		
		if(!in_array($notification->getAssocType(), $notificationSettings)) {
			$this->update(
				sprintf('INSERT INTO notifications
					(user_id, date_created, contents, param, location, is_localized, context, product, assoc_type)
					VALUES
					(?, %s, ?, ?, ?, ?, ?, ?, ?)',
					$this->datetimeToDB(date('Y-m-d H:i:s'))),
				array(
					$notification->getUserId(),
					$notification->getContents(),
					$notification->getParam(),
					$notification->getLocation(),
					$notification->getIsLocalized(),
					$notification->getContext(),
					$productName,
					$notification->getAssocType(),
				)
			);
		
			$notification->setNotificationId($this->getInsertNotificationId());
			return $notification->getNotificationId();
		} else return 0;
	}
	
	/**
	 * Delete Notification by notification id
	 * @param $notificationId int
	 * @return boolean
	 */
	function deleteNotificationById($notificationId, $userId = null) {
		return $this->update('DELETE FROM notifications WHERE notification_id = ?' . (isset($userId) ? ' AND user_id = ?' : ''), 
			isset($userId) ? array($notificationId, $userId) : $notificationId
		);
	}	

	/**
	 * Check if the same notification was added in the last hour
	 * Will prevent multiple notifications to show up in a user's feed e.g.
	 * if a user edits a submission multiple times in a short time span
	 * @param notification object
	 * @return boolean
	 */
	function notificationAlreadyExists(&$notification) {
		$application =& PKPApplication::getApplication();
		$productName = $application->getName();
		$context =& Request::getContext();
		$contextId = $context->getId();
			
		$result = &$this->retrieve(
			'SELECT date_created FROM notifications WHERE user_id = ? AND contents = ? AND product = ? AND assoc_type = ? AND context = ?',
			array(
					$notification->getUserId(),
					$notification->getContents(),
					$productName,
					$notification->getAssocType(),
					$contextId
				)
		);
		
		$date = isset($result->fields[0]) ? $result->fields[0] : 0;
		
		if ($date == 0) {
			return false;
		} else {
			$timeDiff = strtotime($date) - time();
			if ($timeDiff < 3600) { // 1 hour (in seconds)
				return true;
			} else return false;
		}
	}

	/**
	 * Get the ID of the last inserted notification
	 * @return int
	 */
	function getInsertNotificationId() {
		return $this->getInsertId('notifications', 'notification_id');
	}
	
	/**
	 * Get the number of unread messages for a user
	 * @param $userId int
	 * @return int
	 */
	function getUnreadNotificationCount($userId) {
		$application =& PKPApplication::getApplication();
		$productName = $application->getName();
		$context =& Request::getContext();
		$contextId = $context->getId();
		
		$result = &$this->retrieve(
			'SELECT count(*) FROM notifications WHERE user_id = ? AND date_read IS NULL AND product = ? AND context = ?',
			array($userId, $productName, $contextId)
		);

		$returner = $result->fields[0];

		$result->Close();
		unset($result);

		return $returner;
	}
	
	/**
	 * Get the number of read messages for a user
	 * @param $userId int
	 * @return int
	 */
	function getReadNotificationCount($userId) {
		$application =& PKPApplication::getApplication();
		$productName = $application->getName();
		$context =& Request::getContext();
		$contextId = $context->getId();
		
		$result = &$this->retrieve(
			'SELECT count(*) FROM notifications WHERE user_id = ? AND date_read IS NOT NULL AND product = ? AND context = ?',
			array($userId, $productName, $contextId)
		);

		$returner = $result->fields[0];

		$result->Close();
		unset($result);

		return $returner;
	}

	/**
	 * Send an email to a user regarding the notification
	 * @param $notification object Notification
	 */
	function sendNotificationEmail($notification) {
		$userId = $notification->getUserId();
		$userDao = &DAORegistry::getDAO('UserDAO');
		$user = $userDao->getUser($userId);
		
		if ($notification->getIsLocalized()) {
			$params = array('param' => $notification->getParam());
			$notificationContents = Locale::translate($notification->getContents(), $params);
		} else {
			$notificationContents = $notification->getContents();
		}
		
		import('mail.MailTemplate');
		$site = &Request::getSite();
		$mail = new MailTemplate('NOTIFICATION');
		$mail->setFrom($site->getSiteContactEmail(), $site->getSiteContactName());
		$mail->assignParams(array(
			'notificationContents' => $notificationContents,
			'url' => $notification->getLocation(),
			'siteTitle' => $site->getSiteTitle()
		));
		$mail->addRecipient($user->getEmail(), $user->getFullName());
		$mail->send();
	}	
	
	/**
	 * Send an update to all users on the mailing list
	 * @param $notification object Notification
	 */
	function sendToMailingList($notification) {
		$notificationSettingsDao = &DAORegistry::getDAO('NotificationSettingsDAO');
		$guestList = $notificationSettingsDao->getGuestList();
		
		foreach ($guestList as $email) {
			if ($notification->getIsLocalized()) {
				$params = array('param' => $notification->getParam());
				$notificationContents = Locale::translate($notification->getContents(), $params);
			} else {
				$notificationContents = $notification->getContents();
			}
			
			import('mail.MailTemplate');
			$journal = Request::getJournal();
			$site = &Request::getSite();
			
			$mail = new MailTemplate('NOTIFICATION_MAILLIST');
			$mail->setFrom($site->getSiteContactEmail(), $site->getSiteContactName());
			$mail->assignParams(array(
				'notificationContents' => $notificationContents,
				'url' => $notification->getLocation(),
				'siteTitle' => $journal->getJournalTitle(),
				'unsubscribeLink' => Request::url(null, 'notification', 'unsubscribeMailList')
			));
			$mail->addRecipient($email);
			$mail->send();
		}
		
		
	}	
}

?>




<?php

/**
 * @file classes/notification/NotificationSettingsDAODAO.inc.php
 *
 * Copyright (c) 2003-2008 John Willinsky
 * Distributed under the GNU GPL v2. For full terms see the file docs/COPYING.
 *
 * @class NotificationSettingsDAO
 * @ingroup notification
 * @see Notification
 *
 * @brief Operations for retrieving and modifying user's notification settings.
 */

// $Id: NotificationSettingsDAO.inc.php,v 1.19 2008/11/05 00:46:39 mcrider Exp $

class NotificationSettingsDAO extends DAO {
	/**
	 * Constructor.
	 */
	function NotificationSettingsDAO() {
		parent::DAO();
	}
	
	/**
	 * Retrieve Notifications settings by user id
	 * Returns an array of notification types that the user
	 * does NOT want to be notified of
	 * @param $userId int
	 * @return array
	 */
	function &getNotificationSettings($userId) {
		$application =& PKPApplication::getApplication();
		$productName = $application->getName();
		$context =& Request::getContext();
		$contextId = $context->getId();
		
		$notificationSettings = array();
	
		$result = &$this->retrieve(
			'SELECT setting_value FROM notification_settings WHERE user_id = ? AND product = ? AND setting_name = ? AND context = ?',
				array($userId, $productName, 'notify', $contextId)
		);
	
		while (!$result->EOF) {
			$row = $result->GetRowAssoc(false);
			$notificationSettings[] = (int) $row['setting_value'];
			$result->moveNext();
		}

		$result->Close();
		unset($result);
		
		return $notificationSettings;
	}
	
	/**
	 * Retrieve Notifications email settings by user id
	 * Returns an array of notification types that the user
	 * DOES want to be emailed about
	 * @param $userId int
	 * @return array
	 */
	function &getNotificationEmailSettings($userId) {
		$application =& PKPApplication::getApplication();
		$productName = $application->getName();
		$context =& Request::getContext();
		$contextId = $context->getId();
		
		$emailSettings = array();
	
		$result = &$this->retrieve(
			'SELECT setting_value FROM notification_settings WHERE user_id = ? AND product = ? AND setting_name = ? AND context = ?',
				array($userId, $productName, 'email', $contextId)
		);
	
		while (!$result->EOF) {
			$row = $result->GetRowAssoc(false);
			$emailSettings[] = (int) $row['setting_value'];
			$result->moveNext();
		}

		$result->Close();
		unset($result);
		
		return $emailSettings;
	}
	
	/**
	 * Update a user's notification settings
	 * @param $notificationSettings array
	 * @param $userId int
	 */
	function updateNotificationSettings($notificationSettings, $userId) {
		$application =& PKPApplication::getApplication();
		$productName = $application->getName();
		$context =& Request::getContext();
		$contextId = $context->getId();		
		
		// Delete old settings first, then insert new settings
		$this->update('DELETE FROM notification_settings WHERE user_id = ? AND product = ? AND setting_name = ? AND context = ?',
			array($userId, $productName, 'notify', $contextId));
	
		for ($i=0; $i<count($notificationSettings); $i++) {
			$this->update(
				'INSERT INTO notification_settings
					(setting_name, setting_value, user_id, product, context)
					VALUES
					(?, ?, ?, ?, ?)',
				array(
					"notify",
					$notificationSettings[$i],
					$userId,
					$productName,
					$contextId
				)
			);
		}
	}
	
	/**
	 * Update a user's notification email settings
	 * @param $notificationEmailSettings array
	 * @param $userId int
	 */
	function updateNotificationEmailSettings($emailSettings, $userId) {
		$application =& PKPApplication::getApplication();
		$productName = $application->getName();
		$context =& Request::getContext();
		$contextId = $context->getId();
		
		// Delete old settings first, then insert new settings
		$this->update('DELETE FROM notification_settings WHERE user_id = ? AND product = ? AND setting_name = ? AND context = ?',
			array($userId, $productName, 'email', $contextId));
	
		for ($i=0; $i<count($emailSettings); $i++) {
			$this->update(
				'INSERT INTO notification_settings
					(setting_name, setting_value, user_id, product, context)
					VALUES
					(?, ?, ?, ?, ?)',
				array(
					"email",
					$emailSettings[$i],
					$userId,
					$productName,
					$contextId
				)
			);
		}
	}
	
	/**
	 * Gets a user id by an RSS token value
	 * @param $token int
	 * @return int
	 */
	function getUserIdByRSSToken($token) {
		$application =& PKPApplication::getApplication();
		$productName = $application->getName();
		$context =& Request::getContext();
		$contextId = $context->getId();
	
		$result = &$this->retrieve(
			'SELECT user_id FROM notification_settings WHERE setting_value = ? AND setting_name = ? AND product = ? AND context = ?',
				array($token, 'token', $productName, $contextId)
		);

		$row = $result->GetRowAssoc(false);
		$userId = $row['user_id'];

		$result->Close();
		unset($result);
		
		return $userId;
	}

	/**
	 * Gets an RSS token for a user id
	 * @param $userId int
	 * @return int
	 */
	function getRSSTokenByUserId($userId) {
		$application =& PKPApplication::getApplication();
		$productName = $application->getName();
		$context =& Request::getContext();
		$contextId = $context->getId();
	
		$result = &$this->retrieve(
			'SELECT setting_value FROM notification_settings WHERE user_id = ? AND setting_name = ? AND product = ? AND context = ?',
				array($userId, 'token', $productName, $contextId)
		);

		$row = $result->GetRowAssoc(false);
		$userId = $row['setting_value'];

		$result->Close();
		unset($result);
		
		return $userId;
	}

	/**
	 * Generates and inserts a new token for a user's RSS feed
	 * @param $userId int
	 * @return int
	 */
	function insertNewRSSToken($userId) {
		$application =& PKPApplication::getApplication();
		$productName = $application->getName();
		$context =& Request::getContext();
		$contextId = $context->getId();
		
		$token = uniqid(rand());
	
		$this->update(
			'INSERT INTO notification_settings
				(setting_name, setting_value, user_id, product, context)
				VALUES
				(?, ?, ?, ?, ?)',
			array(
				'token',
				$token,
				$userId,
				$productName,
				$contextId
			)
		);

		return $token;
	}
	
	/**
	 * Generates an access key for the guest user and adds them to the settings table
	 * @param $userId int
	 * @return int
	 */
	function subscribeGuest($email) {
		$application =& PKPApplication::getApplication();
		$productName = $application->getName();
		$context =& Request::getContext();
		$contextId = $context->getId();
		
		
		// Check that the email doesn't already exist
		$result = &$this->retrieve(
			'SELECT * FROM notification_settings WHERE setting_name = ? AND setting_value = ? AND product = ? AND context = ?',
			array(
				'guestList',
				$email,
				$productName,
				$contextId
			)
		);
		
		if ($result->RecordCount() != 0) {
			return false;
		} else {		
			$this->update(
				'INSERT INTO notification_settings
					(setting_name, setting_value, user_id, product, context)
					VALUES
					(?, ?, ?, ?, ?)',
				array(
					'guestList',
					$email,
					0,
					$productName,
					$contextId
				)
			);
		}	
		
		// Get assoc_id into notification_settings table, also used as user_id for access key
		$assocId = $this->getInsertNotificationSettingId();

		import('security.AccessKeyManager');
		$accessKeyManager = new AccessKeyManager();
		
		$password = $accessKeyManager->createKey('MailListContext', $assocId, $assocId, 10000);
		return $password;
	}
	
	
	
	/**
	 * Removes an email address and associated access key from email notifications
	 * @param $email string
	 * @param $password string
	 * @return boolean
	 */
	function unsubscribeGuest($email, $password) {
		$application =& PKPApplication::getApplication();
		$productName = $application->getName();
		$context =& Request::getContext();
		$contextId = $context->getId();
		
		$result = &$this->retrieve(
			'SELECT setting_id FROM notification_settings WHERE setting_name = ? AND product = ? AND context = ?',
			array(
				'guestList',
				$productName,
				$contextId
			)
		);

		$row = $result->GetRowAssoc(false);
		$userId = $row['setting_id'];

		$result->Close();
		unset($result);

		import('security.AccessKeyManager');
		$accessKeyManager = new AccessKeyManager();
		$accessKeyHash = AccessKeyManager::generateKeyHash($password);
		$accessKey = $accessKeyManager->validateKey('MailListContext', $userId, $accessKeyHash);

		if ($accessKey) {
			$this->update(
				'DELETE FROM notification_settings WHERE setting_name = ? AND setting_value = ? AND product = ? AND context = ?',
				array(
					'guestList',
					$email,
					$productName,
					$contextId
				)
			);
			$accessKeyDao =& DAORegistry::getDAO('AccessKeyDAO');
			$accessKeyDao->deleteAccessKey($accessKey);
			return true;
		} else return false;
		
		
	}

	/**
	 * Gets a list of email addresses of users subscribed to the mailing list
	 * @return array
	 */
	function getGuestList() {
		$application =& PKPApplication::getApplication();
		$productName = $application->getName();
		$context =& Request::getContext();
		$contextId = $context->getId();
		$guestList = array();
		
		$result = &$this->retrieve(
			'SELECT setting_value FROM notification_settings WHERE setting_name = ? AND product = ? AND context = ?',
			array(
				'guestList',
				$productName,
				$contextId
			)
		);

		while (!$result->EOF) {
			$row = $result->GetRowAssoc(false);
			$guestList[] = $row['setting_value'];
			$result->moveNext();
		}

		$result->Close();
		unset($result);
		
		return $guestList;
	}

	/**
	 * Generates and inserts a new password for a mailing list user
	 * @param $email string
	 * @return string
	 */
	function resetPassword($email) {
		$application =& PKPApplication::getApplication();
		$productName = $application->getName();
		$context =& Request::getContext();
		$contextId = $context->getId();
		
		$result = &$this->retrieve(
			'SELECT setting_id FROM notification_settings WHERE setting_name = ? AND setting_value = ? AND product = ? AND context = ?',
			array(
				'guestList',
				$email,
				$productName,
				$contextId
			)
		);

		$row = $result->GetRowAssoc(false);
		$settingId = $row['setting_id'];

		$result->Close();
		unset($result);

		$accessKeyDao =& DAORegistry::getDAO('AccessKeyDAO');
		$accessKey = $accessKeyDao->getAccessKeyByUserId('MailListContext', $settingId);

		if ($accessKey) {
			$key = Validation::generatePassword();
			$accessKey->setKeyHash(md5($key));
			
			$accessKeyDao =& DAORegistry::getDAO('AccessKeyDAO');
			$accessKeyDao->updateAccessKey($accessKey);
			return $key;
		} else return false;
	}
	
	
	
	
	
	
	
	
	
	
	
	

	/**
	 * Get the ID of the last inserted notification
	 * @return int
	 */
	function getInsertNotificationSettingId() {
		return $this->getInsertId('notification_settings', 'setting_id');
	}

}

?>




		unset($result);
		return $accessKey;
	}
	
	/**
	 * Retrieve a accessKey object user ID.
	 * @param $context string
	 * @param $userId int
	 * @return AccessKey
	 */
	function &getAccessKeyByUserId($context, $userId) {
		$result =& $this->retrieve(
			sprintf(
				'SELECT * FROM access_keys WHERE context = ? AND user_id = ? AND expiry_date > %s',
				$this->datetimeToDB(Core::getCurrentDate())
			),
			array($context, $userId)
		);

		$returner = null;
		if ($result->RecordCount() != 0) {
			$returner =& $this->_returnAccessKeyFromRow($result->GetRowAssoc(false));
		}
		$result->Close();
		unset($result);
		return $returner;
	}

	/**
	 * Retrieve a accessKey object by key.

	 */
	function updateAccessKey(&$accessKey) {
		return $this->update(
			sprintf('UPDATE access_keys
				SET
					key_hash = ?,
					expiry_date = %s,

(-)classes/template/PKPTemplateManager.inc.php (-2 / +2 lines)

Lines 415-423	Link Here

415

			if (isset($params['name'])) {

415

			if (isset($params['name'])) {

416

				// build image tag with standarized size of 16x16

416

				// build image tag with standarized size of 16x16

417

				$disabled = (isset($params['disabled']) && !empty($params['disabled']));

417

				$disabled = (isset($params['disabled']) && !empty($params['disabled']));

418

				if (!isset($params['path'])) $params['path'] = 'templates/images/icons/';

418

				if (!isset($params['path'])) $params['path'] = 'lib/pkp/templates/images/icons/';

419

				$iconHtml = '<img src="' . $smarty->get_template_vars('baseUrl') . '/' . $params['path'];

419

				$iconHtml = '<img src="' . $smarty->get_template_vars('baseUrl') . '/' . $params['path'];

420

				$iconHtml .= $params['name'] . ($disabled ? '_disabled' : '') . '.gif" width="16" height="14" alt="';

420

				$iconHtml .= $params['name'] . ($disabled ? '_disabled' : '') . '.png" width="16" height="14" alt="';

421

422

				// if alt parameter specified use it, otherwise use localization version

422

				// if alt parameter specified use it, otherwise use localization version

423

				if (isset($params['alt'])) {

423

				if (isset($params['alt'])) {




	<message key="navigation.stepNumber">Step {$step}</message>
	<message key="navigation.userHome">User Home</message>
	<message key="navigation.user">User</message>
	<message key="notification.allow">Allow these types of notifications to appear in my notification feed.</message>
	<message key="notification.email">Also send me an email for these types of notifications.</message>
	<message key="notification.location">Go To URL</message>
	<message key="notification.mailList">Notification mailing list</message>
	<message key="notification.mailListDescription">Enter your email address to receive immediate notifications of important new content added to the journal.</message>
	<message key="notification.mailList.privacyProtection">Privacy protection policy</message>
	<message key="notification.mailList.protectedContent"><![CDATA[<a href="{$subscribeUrl}">Subscribe</a> to protected content.]]></message>
	<message key="notification.mailList.submit"><![CDATA[Or <a href="{$submitUrl}">submit</a> an article?]]></message>
	<message key="notification.mailList.review"><![CDATA[Want to also <a href="{$reviewUrl}">review</a>?]]></message>
	<message key="notification.noneExist">You have no notifications at this time.</message>
	<message key="notification.notification">Notification</message>	
	<message key="notification.notifications">Notifications</message>	
	<message key="notification.notificationsDescription">You have {$unreadCount} unread notifications and {$readCount} read notifications.<![CDATA[  <a href="{$settingsUrl}">Click here</a> to change your notification settings.]]></message>
	<message key="notification.notificationsPublicDescription">This page shows important updates associated with this journal such as new issues or announcements.  You may subscribe to these notifications through RSS feeds (by clicking on the images to the right), or <![CDATA[  <a href="{$emailUrl}">through email.</a>]]></message>
	<message key="notification.settings">Notification Settings</message>
	<message key="notification.settingsDescription">Select the system events that you wish to be notified about.  Unchecking an item will prevent notifications of the event from showing up in your notification feed.</message>
	<message key="notification.subscribeError">Your email address is already subscribed to notifications.</message>
	<message key="notification.subscribeSuccess">Your email address has been successfully added to the mailing list.</message>
	<message key="notification.reminderError">There was an error sending your password, please ensure you've entered your email address correctly.</message>
	<message key="notification.reminderSent">Your new password has been sent to the email address provided.</message>
	<message key="notification.type.articleSubmitted">A new article, "{$param}", has been submitted.</message>
	<message key="notification.type.copyeditComment">A copyeditor has left a comment on "{$param}".</message>
	<message key="notification.type.editorDecisionComment">A comment has been left on the editor decision for "{$param}".</message>
	<message key="notification.type.galleyAdded">A galley has been added for "{$param}".</message>
	<message key="notification.type.galleyModified">An galley has been modified for "{$param}".</message>
	<message key="notification.type.issuePublished">An issue has been published.</message>
	<message key="notification.type.layoutComment">A comment has been left about "{$param}'s" layout.</message>
	<message key="notification.type.metadataModified">"{$param}'s" metadata has been modified.</message>
	<message key="notification.type.other">Other Events</message>
	<message key="notification.type.proofreadComment">A comment has been left by a proofreader on "{$param}".</message>
	<message key="notification.type.reviewerComment">A reviewer has commented on "{$param}".</message>
	<message key="notification.type.reviewerFormComment">A review form review has been submitted for "{$param}".</message>
	<message key="notification.type.submissionComment">An editor has made a comment on "{$param}".</message>
	<message key="notification.type.submissions">Submission Events</message>
	<message key="notification.type.suppFileAdded">A supplementary file has been added to "{$param}".</message>
	<message key="notification.type.suppFileModified">"{$param}'s" supplementary file(s) has been modified.</message>
	<message key="notification.type.userComment">A reader has made a comment on "{$param}"</message>
	<message key="notification.unsubscribeDescription">Enter your email address and password below to unsubscribe from email notifications.  If you do not remember your password, leave the password field blank and a new one will be emailed to you at the given email address.</message>	
	<message key="notification.unsubscribeError">There was an error unsubscribing you.  Please ensure your email address and password are correct.</message>
	<message key="notification.unsubscribeSuccess">You were successfully unsubscribed.</message>	
	<message key="search.abstract">Abstract</message>
	<message key="search.allFields">All</message>
	<message key="search.coverage">Coverage</message>




<?php

/**
 * @file NotificationHandler.inc.php
 *
 * Copyright (c) 2000-2008 John Willinsky
 * Distributed under the GNU GPL v2. For full terms see the file docs/COPYING.
 *
 * @class NotificationHandler
 * @ingroup pages_help
 *
 * @brief Handle requests for viewing notifications. 
 */

import('core.PKPHandler');
import('notification.Notification');

class NotificationHandler extends PKPHandler {

	/**
	 * Display help table of contents.
	 */
	function index() {
		parent::validate();
		parent::setupTemplate();
		$templateMgr =& TemplateManager::getManager();
		
		$user = Request::getUser();
		if(isset($user)) {
			$userId = $user->getUserId();
			$templateMgr->assign('isUserLoggedIn', true);
		} else {
			$userId = 0;
			$templateMgr->assign('emailUrl', Request::url(null, 'notification', 'subscribeMailList'));
			$templateMgr->assign('isUserLoggedIn', false);
		}

		$notificationDao = &DAORegistry::getDAO('NotificationDAO');
		$notifications = $notificationDao->getNotificationsByUserId($userId);
		
		$templateMgr->assign('notifications', $notifications);
		$templateMgr->assign('unread', $notificationDao->getUnreadNotificationCount($userId));
		$templateMgr->assign('read', $notificationDao->getReadNotificationCount($userId));
		$templateMgr->assign('url', Request::url(null, 'notification', 'settings'));
		$templateMgr->display('notification/index.tpl');
	}
	
	/**
	 * Delete a notification
	 */
	function delete($args) {
		parent::validate();
		
		$user = Request::getUser();
		if(isset($user)) {
			$userId = $user->getUserId();
			$notificationDao = &DAORegistry::getDAO('NotificationDAO');
			$notifications = $notificationDao->deleteNotificationById($args[0], $userId);
		}
		
		Request::redirect(null, 'notification');
	}
	
	/**
	 * Delete a notification
	 */
	function deleteAjax($args) {
		parent::validate();
		
		$user = Request::getUser();
		if(isset($user)) {
			$userId = $user->getUserId();
			$notificationDao = &DAORegistry::getDAO('NotificationDAO');
			$notifications = $notificationDao->deleteNotificationById($args[0], $userId);
		}
	}
	
	/**
	 * View and modify notification settings
	 */
	function settings() {
		parent::validate();
				
		$user = Request::getUser();
		if(isset($user)) {
			$userId = $user->getUserId();
					
			$notificationSettingsDao = &DAORegistry::getDAO('NotificationSettingsDAO');
			$notificationSettings = $notificationSettingsDao->getNotificationSettings($userId);
			$emailSettings = $notificationSettingsDao->getNotificationEmailSettings($userId);

			$templateMgr = &TemplateManager::getManager();
			$templateMgr->assign('notificationSettings', $notificationSettings);
			$templateMgr->assign('emailSettings', $emailSettings);
			$templateMgr->assign('titleVar', Locale::translate('common.title'));
			$templateMgr->assign('userVar', Locale::translate('common.user'));
			$templateMgr->display('notification/settings.tpl');
		} else Request::redirect(null, 'notification');
	}
	
	/**
	 * Save user notification settings
	 */
	function saveSettings() {
		parent::validate();
		
		$settings = array();
		
		$user = Request::getUser();
		if(isset($user)) {
			$userId = $user->getUserId();
			$notificationSettingsDao = &DAORegistry::getDAO('NotificationSettingsDAO');
			
			// Notification settings
			$settings = array();
			if(!Request::getUserVar('notificationArticleSubmitted')) $settings[] = NOTIFICATION_TYPE_ARTICLE_SUBMITTED;
			if(!Request::getUserVar('notificationMetadataModified')) $settings[] = NOTIFICATION_TYPE_METADATA_MODIFIED;
			if(!Request::getUserVar('notificationSuppFileAdded')) $settings[] = NOTIFICATION_TYPE_SUPP_FILE_ADDED;
			if(!Request::getUserVar('notificationSuppFileModified')) $settings[] = NOTIFICATION_TYPE_SUPP_FILE_MODIFIED;
			if(!Request::getUserVar('notificationGalleyAdded')) $settings[] = NOTIFICATION_TYPE_GALLEY_ADDED;
			if(!Request::getUserVar('notificationGalleyModified')) $settings[] = NOTIFICATION_TYPE_GALLEY_MODIFIED;
			if(!Request::getUserVar('notificationSubmissionComment')) $settings[] = NOTIFICATION_TYPE_SUBMISSION_COMMENT;
			if(!Request::getUserVar('notificationLayoutComment')) $settings[] = NOTIFICATION_TYPE_LAYOUT_COMMENT;
			if(!Request::getUserVar('notificationCopyeditComment')) $settings[] = NOTIFICATION_TYPE_COPYEDIT_COMMENT;
			if(!Request::getUserVar('notificationProofreadComment')) $settings[] = NOTIFICATION_TYPE_PROOFREAD_COMMENT;
			if(!Request::getUserVar('notificationReviewerComment')) $settings[] = NOTIFICATION_TYPE_REVIEWER_COMMENT;
			if(!Request::getUserVar('notificationReviewerFormComment')) $settings[] = NOTIFICATION_TYPE_REVIEWER_FORM_COMMENT;
			if(!Request::getUserVar('notificationEditorDecisionComment')) $settings[] = NOTIFICATION_TYPE_EDITOR_DECISION_COMMENT; 
			if(!Request::getUserVar('notificationPublishedIssue')) $settings[] = NOTIFICATION_TYPE_PUBLISHED_ISSUE;
			if(!Request::getUserVar('notificationUserComment')) $settings[] = NOTIFICATION_TYPE_USER_COMMENT;
			
			// Email settings
			$emailSettings = array();
			if(Request::getUserVar('emailNotificationArticleSubmitted')) $emailSettings[] = NOTIFICATION_TYPE_ARTICLE_SUBMITTED;
			if(Request::getUserVar('emailNotificationMetadataModified')) $emailSettings[] = NOTIFICATION_TYPE_METADATA_MODIFIED;
			if(Request::getUserVar('emailNotificationSuppFileAdded')) $emailSettings[] = NOTIFICATION_TYPE_SUPP_FILE_ADDED;
			if(Request::getUserVar('emailNotificationSuppFileModified')) $emailSettings[] = NOTIFICATION_TYPE_SUPP_FILE_MODIFIED;
			if(Request::getUserVar('emailNotificationGalleyAdded')) $emailSettings[] = NOTIFICATION_TYPE_GALLEY_ADDED;
			if(Request::getUserVar('emailNotificationGalleyModified')) $emailSettings[] = NOTIFICATION_TYPE_GALLEY_MODIFIED;
			if(Request::getUserVar('emailNotificationSubmissionComment')) $emailSettings[] = NOTIFICATION_TYPE_SUBMISSION_COMMENT;
			if(Request::getUserVar('emailNotificationLayoutComment')) $emailSettings[] = NOTIFICATION_TYPE_LAYOUT_COMMENT;
			if(Request::getUserVar('emailNotificationCopyeditComment')) $emailSettings[] = NOTIFICATION_TYPE_COPYEDIT_COMMENT;
			if(Request::getUserVar('emailNotificationProofreadComment')) $emailSettings[] = NOTIFICATION_TYPE_PROOFREAD_COMMENT;
			if(Request::getUserVar('emailNotificationReviewerComment')) $emailSettings[] = NOTIFICATION_TYPE_REVIEWER_COMMENT;
			if(Request::getUserVar('emailNotificationReviewerFormComment')) $emailSettings[] = NOTIFICATION_TYPE_REVIEWER_FORM_COMMENT;
			if(Request::getUserVar('emailNotificationEditorDecisionComment')) $emailSettings[] = NOTIFICATION_TYPE_EDITOR_DECISION_COMMENT; 
			if(Request::getUserVar('emailNotificationPublishedIssue')) $emailSettings[] = NOTIFICATION_TYPE_PUBLISHED_ISSUE;
			if(Request::getUserVar('emailNotificationUserComment')) $emailSettings[] = NOTIFICATION_TYPE_USER_COMMENT;
			
			$notificationSettingsDao->updateNotificationSettings($settings, $userId);
			$notificationSettingsDao->updateNotificationEmailSettings($emailSettings, $userId);
			Request::redirect(null, 'notification');
		} else Request::redirect(null, 'notification');
	}
	
	/**
	 * Fetch the existing or create a new URL for the user's RSS feed
	 */
	function getNotificationFeedUrl($args) {
		$user = Request::getUser();
		if(isset($user)) {
			$userId = $user->getUserId();
			$notificationSettingsDao = &DAORegistry::getDAO('NotificationSettingsDAO');
			$feedType = $args[0];

			$token = $notificationSettingsDao->getRSSTokenByUserId($userId);
			
			if ($token) {
				Request::redirect(null, 'notification', 'notificationFeed', array($feedType, $token));
			} else {
				$token = $notificationSettingsDao->insertNewRSSToken($userId);
				Request::redirect(null, 'notification', 'notificationFeed', $feedType, $token);
			}
		} else Request::redirect(null, 'notification');
	}
	
	/**
	 * Fetch the actual RSS feed
	 */
	function notificationFeed($args) {
		if(isset($args[0]) && isset($args[1])) {
			$type = $args[0];
			$token = $args[1];
		} else return false;

		$application = PKPApplication::getApplication();
		$appName = $application->getNameKey();
		
		$site =& Request::getSite();
		$siteTitle = $site->getSiteTitle();
	
		$notificationDao = &DAORegistry::getDAO('NotificationDAO');
		$notificationSettingsDao = &DAORegistry::getDAO('NotificationSettingsDAO');
		
		$userId = $notificationSettingsDao->getUserIdByRSSToken($token);
		$notifications = $notificationDao->getNotificationsByUserId($userId);

		// Make sure the feed type is specified and valid
		$typeMap = array(
			'rss' => 'rss.tpl',
			'rss2' => 'rss2.tpl',
			'atom' => 'atom.tpl'
		);
		$mimeTypeMap = array(
			'rss' => 'application/rdf+xml',
			'rss2' => 'application/rss+xml',
			'atom' => 'application/atom+xml'
		);
		if (!isset($typeMap[$type])) return false;

		$versionDao =& DAORegistry::getDAO('VersionDAO');
		$version = $versionDao->getCurrentVersion();

		$templateMgr = &TemplateManager::getManager();
		$templateMgr->assign('version', $version->getVersionString());
		$templateMgr->assign('selfUrl', Request::getCompleteUrl()); 
		$templateMgr->assign('locale', Locale::getPrimaryLocale()); 
		$templateMgr->assign('appName', $appName);
		$templateMgr->assign('siteTitle', $siteTitle);
		$templateMgr->assign_by_ref('notifications', $notifications->toArray());

		$templateMgr->display(Core::getBaseDir() . DIRECTORY_SEPARATOR . 'lib' . DIRECTORY_SEPARATOR . 
			'pkp' . DIRECTORY_SEPARATOR . 'templates' . DIRECTORY_SEPARATOR . 'notification' . DIRECTORY_SEPARATOR . $typeMap[$type], $mimeTypeMap[$type]);

		return true;
	}
	

	/**
	 * Display the public notification email subscription form
	 */
	function subscribeMailList() {
		$templateMgr = &TemplateManager::getManager();
		$templateMgr->assign('new', true);

		$user = Request::getUser();
	//	FIXME: Need to abstract subscription enabled check
	//	import('payment.PaymentManager');
	//	$subscriptionEnabled = PaymentManager::isConfigured();
				
		if(!isset($user)) {
			// $templateMgr->assign('subscriptionEnabled', $subscriptionEnabled);
			
			if($userEmail = Request::getUserVar('email')) {
				$notificationSettingsDao = &DAORegistry::getDAO('NotificationSettingsDAO');
				if($password = $notificationSettingsDao->subscribeGuest($userEmail)) {
					NotificationHandler::sendMailingListEmail($userEmail, $password, 'NOTIFICATION_MAILLIST_WELCOME');
					$templateMgr->assign('success', "notification.subscribeSuccess");
					$templateMgr->display('notification/maillist.tpl');
				} else {
					$templateMgr->assign('error', "notification.subscribeError");
					$templateMgr->display('notification/maillist.tpl');
				
				}
			} else {
				$templateMgr->display('notification/maillist.tpl');
			}
		} else Request::redirect(null, 'notification');
	}

	/**
	 * Display the public notification email subscription form
	 */
	function unsubscribeMailList() {
		$templateMgr = &TemplateManager::getManager();
		$templateMgr->assign('remove', true);
		
		$user = Request::getUser();
		if(!isset($user)) {
			$userEmail = Request::getUserVar('email');
			$userPassword = Request::getUserVar('password');
			
			if($userEmail != '' && $userPassword != '') {
				$notificationSettingsDao = &DAORegistry::getDAO('NotificationSettingsDAO');
				if($notificationSettingsDao->unsubscribeGuest($userEmail, $userPassword)) {
					$templateMgr->assign('success', "notification.unsubscribeSuccess");
					$templateMgr->display('notification/maillist.tpl');
				} else {
					$templateMgr->assign('error', "notification.unsubscribeError");
					$templateMgr->display('notification/maillist.tpl');
				}
			} else if($userEmail != '' && $userPassword == '') {
				$notificationSettingsDao = &DAORegistry::getDAO('NotificationSettingsDAO');
				if($newPassword = $notificationSettingsDao->resetPassword($userEmail)) {
					NotificationHandler::sendMailingListEmail($userEmail, $userPassword, 'NOTIFICATION_MAILLIST_PASSWORD');
					$templateMgr->assign('success', "notification.reminderSent");
					$templateMgr->display('notification/maillist.tpl');
				} else {
					$templateMgr->assign('error', "notification.reminderError");
					$templateMgr->display('notification/maillist.tpl');
				}
			} else {		
				$templateMgr->assign('remove', true);
				$templateMgr->display('notification/maillist.tpl');
			}
		} else Request::redirect(null, 'notification');
	}
	
	/**
	 * Send an email to a mailing list user regarding signup or a lost password
	 */
	function sendMailingListEmail($email, $password, $template) {
		import('mail.MailTemplate');
		$journal = Request::getJournal();
		$site = Request::getSite();
		
		$mail = new MailTemplate($template);
		$mail->setFrom($site->getSiteContactEmail(), $site->getSiteContactName());
		$mail->assignParams(array(
			'password' => $password,
			'siteTitle' => $journal->getJournalTitle(),
			'unsubscribeLink' => Request::url(null, 'notification', 'unsubscribeMailList')
		));
		$mail->addRecipient($email);
		$mail->send();
	}	
}

?>




<?php

/**
 * @defgroup pages_notification
 */
 
/**
 * @file pages/notification/index.php
 *
 * Copyright (c) 2000-2008 John Willinsky
 * Distributed under the GNU GPL v2. For full terms see the file docs/COPYING.
 *
 * @ingroup pages_notification
 * @brief Handle requests for viewing notifications. 
 *
 */


define('HANDLER_CLASS', 'NotificationHandler');

import('pages.notification.NotificationHandler');

?>




{**
 * atom.tpl
 *
 * Copyright (c) 2003-2008 John Willinsky
 * Distributed under the GNU GPL v2. For full terms see the file docs/COPYING.
 *
 * Atom feed template
 *
 * $Id: atom.tpl,v 1.3 2008/06/11 21:52:26 asmecher Exp $
 *}
<?xml version="1.0" encoding="{$defaultCharset|escape}"?>
<feed xmlns="http://www.w3.org/2005/Atom">
	<id>{$selfUrl}</id>
	<title>{$siteTitle} {translate key="notification.notifications"}</title>

	<link rel="self" type="application/atom+xml" href="{$selfUrl}" />

	<generator uri="http://pkp.sfu.ca/ojs/" version="{$version|escape}">{translate key=$appName}</generator>

{foreach from=$notifications item=notification}
	<entry>
		<id>$notification->getNotificationId()</id>
		<title>{translate key="notification.notification"} : {$notification->getDateCreated()|date_format:"%a, %d %b %Y %T %z"}</title>
		{if $notification->getLocation() != null}
			<link rel="alternate" href="{$notification->getLocation()}" />					
		{else}
			<link rel="alternate" href="{url page="notification"}" />					
		{/if}

		<summary type="html" xml:base="{if $notification->getLocation() != null}{$notification->getLocation()}{else}{url page="notification"}{/if}">
			{if $notification->getIsLocalized()}
				{translate key=$notification->getContents() param=$notification->getParam()}
			{else}
				{$notification->getContents()}
			{/if}
		</summary>

		<published>{$notification->getDateCreated()|date_format:"%Y-%m-%dT%T%z"|regex_replace:"/00$/":":00"}</published>
	</entry>
{/foreach}
</feed>






{**
 * index.tpl
 *
 * Copyright (c) 2000-2008 John Willinsky
 * Distributed under the GNU GPL v2. For full terms see the file docs/COPYING.
 *
 * Display list of notifications. 
 *
 *}
{strip}
{assign var="pageTitle" value="notification.notifications"}
{include file="common/header.tpl"}
{/strip}

<table width="100%">
	<tr>
		<td>{if $isUserLoggedIn}
				<p>{translate key="notification.notificationsDescription" unreadCount=$unread readCount=$read settingsUrl=$url}</p>
			{else}
				<p>{translate key="notification.notificationsPublicDescription" emailUrl=$emailUrl}</p>
			{/if}
		</td>
		<td><ul class="plain">
			<li><a href="{url op="getNotificationFeedUrl" path="rss"}" class="icon"><img src="{$baseUrl}/lib/pkp/templates/images/rss10_logo.png" alt="RSS 1.0"/></a></li>
			<li><a href="{url op="getNotificationFeedUrl" path="rss2"}" class="icon"><img src="{$baseUrl}/lib/pkp/templates/images/rss20_logo.png" alt="RSS 2.0"/></a></li>
			<li><a href="{url op="getNotificationFeedUrl" path="atom"}" class="icon"><img src="{$baseUrl}/lib/pkp/templates/images/atom10_logo.png" alt="Atom 1.0"/></a></li>
		</ul></td>
	</tr>
</table>

<br/>

<div id="notifications">
{iterate from=notifications item=notification}
	<table width="100%" class="notifications">
		<tr>
			<td width="25"><img src="{$notification->getIconLocation()}" alt="&#187"/></td>
			<td class="notificationContent" colspan="2" width="80%">
				{$notification->getDateCreated()}
			</td>
			{if $notification->getLocation() != null}
				<td id="notificationLink" class="notificationFunction" style="min-width:60px"><a href="{$notification->getLocation()}">{translate key="notification.location"}</a></td>
			{else}
				<td id="notificationLink" class="notificationFunction"></td>
			{/if}
			<td id="notificationDelete" class="notificationFunction"><a id="notificationDeleteLink" href="{url op="delete" path=$notification->getNotificationId()}">{translate key="common.delete"}</a></td>
		</tr>
		<tr>
			<td width="25">&nbsp;</td>
			<td class="notificationContent">
				{if $notification->getIsUnread()}
					{if $notification->getIsLocalized()}<p style="font-weight: bold">{translate key=$notification->getContents() param=$notification->getParam()}</p>
					{else}<p style="font-weight: bold">{$notification->getContents()}{/if}
				{else}
					{if $notification->getIsLocalized()}<p>{translate key=$notification->getContents() param=$notification->getParam()}</p>
					{else}<p>{$notification->getContents()}</p>{/if}	
				{/if}
			</td>
		</tr>
	</table>
	<div class="separator" style="margin-left:25px"></div>
{/iterate}
{if $notifications->wasEmpty()}
	<table class="notifications">
		<tr>
			<td colspan="2" class="nodata"><h5>{translate key="notification.noneExist"}</h5></td>
		</tr>
		<tr>
			<td colspan="2" class="endseparator">&nbsp;</td>
		</tr>
	</table>
{else}
	<table class="notifications">
		<tr>
			<td align="left">{page_info iterator=$notifications}</td>
			<td align="right">{page_links anchor="notifications" name="notifications" iterator=$notifications}</td>
		</tr>
	</table>
{/if}

</div>

{include file="common/footer.tpl"}




{**
 * index.tpl
 *
 * Copyright (c) 2000-2008 John Willinsky
 * Distributed under the GNU GPL v2. For full terms see the file docs/COPYING.
 *
 * Displays the notification settings page and unchecks  
 *
 *}
{strip}
{assign var="pageTitle" value="notification.mailList"}
{include file="common/header.tpl"}
{/strip}

{if $new}
	<p><span class="instruct">{translate key="notification.mailListDescription"}</span></p>
	<br />

	{if $error}
		<p><span class="formError">{translate key="$error"}</span></p>
	{/if}
	
	{if $success}
		<p><span class="formSuccess">{translate key="$success"}</span></p>
	{/if}

	<form id="notificationSettings" method="post" action="{url op="subscribeMailList"}">
	
	<table class="data" width="100%">
		<tr valign="top">
			<td class="label" width="5%">{translate key="email.email"}</td>
			<td class="value" width="45%"><input type="text" name="email" size="30" maxlength="90" class="textField" /></td>
		</tr>
		<tr valign="top">
			<td width="5%">&nbsp;</td>
			<td><p><input type="submit" value="{translate key="form.submit"}" class="button defaultButton" /></p></td>
		</tr>
	</table>
	</form>
	
	<ul class="plain" style="margin-left:10%">
		{url|assign:"url" page="user" op="register"}
		<li>&#187; {translate key="notification.mailList.review" reviewUrl=$url} </li>
		{url|assign:"url" page="information" op="authors"}
		<li>&#187; {translate key="notification.mailList.submit" submitUrl=$url} </li>
		{** need to abstract subscription enabled check
		* assign var=subscribeUrl value="url op="subscriptions""
		* if $subscriptionEnabled <li>&#187; translate key="notification.mailList.protectedContent" subscribeUrl=$subscribeUrl
		*}
		<li>&#187; <a href="{url op="protectionPolicy"}">{translate key="notification.mailList.privacyProtection"}</a></li>
	<ul>
{else if $remove}
	<p><span class="instruct">{translate key="notification.unsubscribeDescription"}</span></p>
	<br />

	{if $error}
		<p><span class="formError">{translate key="$error"}</span></p>
	{/if}
	
	{if $success}
		<p><span class="formSuccess">{translate key="$success"}</span></p>
	{/if}
	
	<form id="notificationSettings" method="post" action="{url op="unsubscribeMailList"}">
	<table class="data" width="100%">
		<tr valign="top">
			<td class="label" width="5%">{translate key="email.email"}</td>
			<td class="value" width="45%"><input type="text" name="email" size="30" maxlength="90" class="textField" /></td>
		</tr>
		<tr valign="top">
			<td class="label" width="5%">{translate key="user.password"}</td>
			<td class="value" width="45%"><input type="text" name="password" size="30" maxlength="90" class="textField" /></td>
		</tr>
		<tr valign="top">
			<td width="5%">&nbsp;</td>
			<td><p><input type="submit" value="{translate key="form.submit"}" class="button defaultButton" /></p></td>
		</tr>
	</table>
	
	</form>
{/if}

</form>

{include file="common/footer.tpl"}




{**
 * rss.tpl
 *
 * Copyright (c) 2003-2008 John Willinsky
 * Distributed under the GNU GPL v2. For full terms see the file docs/COPYING.
 *
 * RSS feed template
 *
 * $Id: rss.tpl,v 1.3 2008/06/11 21:52:26 asmecher Exp $
 *}
<?xml version="1.0" encoding="{$defaultCharset|escape}"?>
<rdf:RDF
	xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
	xmlns="http://purl.org/rss/1.0/"
	xmlns:dc="http://purl.org/dc/elements/1.1/"
	xmlns:prism="http://prismstandard.org/namespaces/1.2/basic/">
    
	<channel rdf:about="{$baseUrl}">
		<title>{$siteTitle} {translate key="notification.notifications"}</title>
		<link>{$selfUrl}</link>
		<language>{$locale|replace:'_':'-'|strip|escape:"html"}</language>
		<items>
			{foreach from=$notifications item=notification}
			<rdf:Seq>
				<rdf:li rdf:resource="{url page="notification"}"/>
			</rdf:Seq>
			{/foreach}
		</items>
	</channel>

	{foreach from=$notifications item=notification}
	<item rdf:about="{url page="notification"}">
		<title>{translate key="notification.notification"} : {$notification->getDateCreated()|date_format:"%a, %d %b %Y %T %z"}</title>
		<link>
			{if $notification->getLocation() != null}
				{$notification->getLocation()}
			{else}
				{url page="notification"}
			{/if}
		</link>
		<description>
			{if $notification->getIsLocalized()}
				{translate key=$notification->getContents() param=$notification->getParam()}
			{else}
				{$notification->getContents()}
			{/if}
		</description>	
		<dc:creator>{$siteTitle|strip|escape:"html"}</dc:creator>
		<dc:date>{$notification->getDateCreated()|date_format:"%Y-%m-%d"}</dc:date>
	</item>
	{/foreach}

</rdf:RDF>




{**
 * rss2.tpl
 *
 * Copyright (c) 2003-2008 John Willinsky
 * Distributed under the GNU GPL v2. For full terms see the file docs/COPYING.
 *
 * RSS 2 feed template
 *
 * $Id: rss2.tpl,v 1.3 2008/06/11 21:52:26 asmecher Exp $
 *}
<?xml version="1.0" encoding="{$defaultCharset|escape}"?>
<rss version="2.0">
	<channel>
		{* required elements *}
		<title>{$siteTitle} {translate key="notification.notifications"}</title>
		<link>{$selfUrl}</link>

		{* optional elements *}
	    <language>{$locale|replace:'_':'-'|strip|escape:"html"}</language>
		<generator>{translate key=$appName} {$version|escape}</generator>
		<docs>http://blogs.law.harvard.edu/tech/rss</docs>
		<ttl>60</ttl>

		{foreach from=$notifications item=notification}
			<item>
				<title>{translate key="notification.notification"} : {$notification->getDateCreated()|date_format:"%a, %d %b %Y %T %z"}</title>
				<link>
					{if $notification->getLocation() != null}
						{$notification->getLocation()}
					{else}
						{url page="notification"}
					{/if}
				</link>
				<description>
					{if $notification->getIsLocalized()}
						{translate key=$notification->getContents() param=$notification->getParam()}
					{else}
						{$notification->getContents()}
					{/if}
				</description>		
				<pubDate>{$notification->getDateCreated()|date_format:"%a, %d %b %Y %T %z"}</pubDate>
			</item>
		{/foreach}
	</channel>
</rss>




{**
 * index.tpl
 *
 * Copyright (c) 2000-2008 John Willinsky
 * Distributed under the GNU GPL v2. For full terms see the file docs/COPYING.
 *
 * Displays the notification settings page and unchecks  
 *
 *}
{strip}
{assign var="pageTitle" value="notification.settings"}
{include file="common/header.tpl"}
{/strip}

<p>{translate key="notification.settingsDescription"}</p>

<form id="notificationSettings" method="post" action="{url op="saveSettings"}">


<h4>{translate key="notification.type.submissions"}</h4>

<ul>
	<li>{translate key="notification.type.articleSubmitted" param=$titleVar}</li>
	<ul class="plain">
		<li><span>
				<input type="checkbox" name="notificationArticleSubmitted"{if !$smarty.const.NOTIFICATION_TYPE_ARTICLE_SUBMITTED|in_array:$notificationSettings} checked="checked"{/if} />
				{translate key="notification.allow"}
			</span></li>
		<li><span>
				<input type="checkbox" name="emailNotificationArticleSubmitted"{if $smarty.const.NOTIFICATION_TYPE_ARTICLE_SUBMITTED|in_array:$emailSettings} checked="checked"{/if} />
				{translate key="notification.email"}
			</span></li>
	</ul>
</ul>
			
<ul>
	<li>{translate key="notification.type.metadataModified" param=$titleVar}</li>
	<ul class="plain">
		<li><span>
				<input type="checkbox" name="notificationMetadataModified"{if !$smarty.const.NOTIFICATION_TYPE_METADATA_MODIFIED|in_array:$notificationSettings} checked="checked"{/if} />
				{translate key="notification.allow"}
			</span></li>
		<li><span>
				<input type="checkbox" name="emailNotificationMetadataModified"{if $smarty.const.NOTIFICATION_TYPE_METADATA_MODIFIED|in_array:$emailSettings} checked="checked"{/if} />
				{translate key="notification.email"}
			</span></li>
	</ul>
</ul>	

<ul>
	<li>{translate key="notification.type.suppFileAdded" param=$titleVar}</li>
	<ul class="plain">
		<li><span>
				<input type="checkbox" name="notificationSuppFileAdded"{if !$smarty.const.NOTIFICATION_TYPE_SUPP_FILE_ADDED|in_array:$notificationSettings} checked="checked"{/if} />
				{translate key="notification.allow"}
			</span></li>
		<li><span>
				<input type="checkbox" name="emailNotificationSuppFileAdded"{if $smarty.const.NOTIFICATION_TYPE_SUPP_FILE_ADDED|in_array:$emailSettings} checked="checked"{/if} />
				{translate key="notification.email"}
			</span></li>
	</ul>
</ul>

<ul>
	<li>{translate key="notification.type.suppFileModified" param=$titleVar}</li>
	<ul class="plain">
		<li><span>
				<input type="checkbox" name="notificationSuppFileModified"{if !$smarty.const.NOTIFICATION_TYPE_SUPP_FILE_MODIFIED|in_array:$notificationSettings} checked="checked"{/if} />
				{translate key="notification.allow"}
			</span></li>
		<li><span>
				<input type="checkbox" name="emailNotificationSuppFileModified"{if $smarty.const.NOTIFICATION_TYPE_SUPP_FILE_MODIFIED|in_array:$emailSettings} checked="checked"{/if} />
				{translate key="notification.email"}
			</span></li>
	</ul>
</ul>

<ul>
	<li>{translate key="notification.type.galleyAdded" param=$titleVar}</li>
	<ul class="plain">
		<li><span>
				<input type="checkbox" name="notificationGalleyAdded"{if !$smarty.const.NOTIFICATION_TYPE_GALLEY_ADDED|in_array:$notificationSettings} checked="checked"{/if} />
				{translate key="notification.allow"}
			</span></li>
		<li><span>
				<input type="checkbox" name="emailNotificationGalleyAdded"{if $smarty.const.NOTIFICATION_TYPE_GALLEY_ADDED|in_array:$emailSettings} checked="checked"{/if} />
				{translate key="notification.email"}
			</span></li>
	</ul>
</ul>

<ul>
	<li>{translate key="notification.type.galleyModified" param=$titleVar}</li>
	<ul class="plain">
		<li><span>
				<input type="checkbox" name="notificationGalleyModified"{if !$smarty.const.NOTIFICATION_TYPE_GALLEY_MODIFIED|in_array:$notificationSettings} checked="checked"{/if} />
				{translate key="notification.allow"}
			</span></li>
		<li><span>
				<input type="checkbox" name="emailNotificationGalleyModified"{if $smarty.const.NOTIFICATION_TYPE_GALLEY_MODIFIED|in_array:$emailSettings} checked="checked"{/if} />
				{translate key="notification.email"}
			</span></li>
	</ul>
</ul>

<ul>
	<li>{translate key="notification.type.submissionComment" param=$titleVar}</li>
	<ul class="plain">
		<li><span>
				<input type="checkbox" name="notificationSubmissionComment"{if !$smarty.const.NOTIFICATION_TYPE_SUBMISSION_COMMENT|in_array:$notificationSettings} checked="checked"{/if} />
				{translate key="notification.allow"}
			</span></li>
		<li><span>
				<input type="checkbox" name="emailNotificationSubmissionComment"{if $smarty.const.NOTIFICATION_TYPE_SUBMISSION_COMMENT|in_array:$emailSettings} checked="checked"{/if} />
				{translate key="notification.email"}
			</span></li>
	</ul>
</ul>

<ul>
	<li>{translate key="notification.type.layoutComment" param=$titleVar}</li>
	<ul class="plain">
		<li><span>
				<input type="checkbox" name="notificationLayoutComment"{if !$smarty.const.NOTIFICATION_TYPE_LAYOUT_COMMENT|in_array:$notificationSettings} checked="checked"{/if} />
				{translate key="notification.allow"}
			</span></li>
		<li><span>
				<input type="checkbox" name="emailNotificationLayoutComment"{if $smarty.const.NOTIFICATION_TYPE_LAYOUT_COMMENT|in_array:$emailSettings} checked="checked"{/if} />
				{translate key="notification.email"}
			</span></li>
	</ul>
</ul>

<ul>
	<li>{translate key="notification.type.copyeditComment" param=$titleVar}</li>
	<ul class="plain">
		<li><span>
				<input type="checkbox" name="notificationCopyeditComment"{if !$smarty.const.NOTIFICATION_TYPE_COPYEDIT_COMMENT|in_array:$notificationSettings} checked="checked"{/if} />
				{translate key="notification.allow"}
			</span></li>
		<li><span>
				<input type="checkbox" name="emailNotificationCopyeditComment"{if $smarty.const.NOTIFICATION_TYPE_COPYEDIT_COMMENT|in_array:$emailSettings} checked="checked"{/if} />
				{translate key="notification.email"}
			</span></li>
	</ul>
</ul>

<ul>
	<li>{translate key="notification.type.proofreadComment" param=$titleVar}</li>
	<ul class="plain">
		<li><span>
				<input type="checkbox" name="notificationProofreadComment"{if !$smarty.const.NOTIFICATION_TYPE_PROOFREAD_COMMENT|in_array:$notificationSettings} checked="checked"{/if} />
				{translate key="notification.allow"}
			</span></li>
		<li><span>
				<input type="checkbox" name="emailNotificationProofreadComment"{if $smarty.const.NOTIFICATION_TYPE_PROOFREAD_COMMENT|in_array:$emailSettings} checked="checked"{/if} />
				{translate key="notification.email"}
			</span></li>
	</ul>
</ul>

<ul>
	<li>{translate key="notification.type.reviewerComment" param=$titleVar}</li>
	<ul class="plain">
		<li><span>
				<input type="checkbox" name="notificationReviewerComment"{if !$smarty.const.NOTIFICATION_TYPE_REVIEWER_COMMENT|in_array:$notificationSettings} checked="checked"{/if} />
				{translate key="notification.allow"}
			</span></li>
		<li><span>
				<input type="checkbox" name="emailNotificationReviewerComment"{if $smarty.const.NOTIFICATION_TYPE_REVIEWER_COMMENT|in_array:$emailSettings} checked="checked"{/if} />
				{translate key="notification.email"}
			</span></li>
	</ul>
</ul>

<ul>
	<li>{translate key="notification.type.reviewerFormComment" param=$titleVar}</li>
	<ul class="plain">
		<li><span>
				<input type="checkbox" name="notificationReviewerFormComment"{if !$smarty.const.NOTIFICATION_TYPE_REVIEWER_FORM_COMMENT|in_array:$notificationSettings} checked="checked"{/if} />
				{translate key="notification.allow"}
			</span></li>
		<li><span>
				<input type="checkbox" name="emailNotificationReviewerFormComment"{if $smarty.const.NOTIFICATION_TYPE_REVIEWER_FORM_COMMENT|in_array:$emailSettings} checked="checked"{/if} />
				{translate key="notification.email"}
			</span></li>
	</ul>
</ul>

<ul>
	<li>{translate key="notification.type.editorDecisionComment" param=$titleVar}</li>
	<ul class="plain">
		<li><span>
				<input type="checkbox" name="notificationEditorDecisionComment"{if !$smarty.const.NOTIFICATION_TYPE_EDITOR_DECISION_COMMENT|in_array:$notificationSettings} checked="checked"{/if} />
				{translate key="notification.allow"}
			</span></li>
		<li><span>
				<input type="checkbox" name="emailNotificationEditorDecisionComment"{if $smarty.const.NOTIFICATION_TYPE_EDITOR_DECISION_COMMENT|in_array:$emailSettings} checked="checked"{/if} />
				{translate key="notification.email"}
			</span></li>
	</ul>
</ul>
	
<br />

<!-- Other events -->
<h4>{translate key="notification.type.other"}</h4>

<ul>
	<li>{translate key="notification.type.userComment" param=$titleVar}</li>
	<ul class="plain">
		<li><span>
				<input type="checkbox" name="notificationUserComment"{if !$smarty.const.NOTIFICATION_TYPE_USER_COMMENT|in_array:$notificationSettings} checked="checked"{/if} />
				{translate key="notification.allow"}
			</span></li>
		<li><span>
				<input type="checkbox" name="emailNotificationUserComment"{if $smarty.const.NOTIFICATION_TYPE_USER_COMMENT|in_array:$emailSettings} checked="checked"{/if} />
				{translate key="notification.email"}
			</span></li>
	</ul>
</ul>

<ul>
	<li>{translate key="notification.type.issuePublished" param=$userVar}</li>
	<ul class="plain">
		<li><span>
				<input type="checkbox" name="notificationPublishedIssue"{if !$smarty.const.NOTIFICATION_TYPE_PUBLISHED_ISSUE|in_array:$notificationSettings} checked="checked"{/if} />
				{translate key="notification.allow"}
			</span></li>
		<li><span>
				<input type="checkbox" name="emailNotificationPublishedIssue"{if $smarty.const.NOTIFICATION_TYPE_PUBLISHED_ISSUE|in_array:$emailSettings} checked="checked"{/if} />
				{translate key="notification.email"}
			</span></li>
	</ul>
</ul>

<p><input type="submit" value="{translate key="form.submit"}" class="button defaultButton" />  <input type="button" value="{translate key="common.cancel"}" class="button" onclick="document.location.href='{url op="notification" escape=false}'" /></p>

</form>

{include file="common/footer.tpl"}




		</index>
	</table>

	<!--
	  *
	  * TABLE notifications
	  *
	  -->
	<table name="notifications">
		<field name="notification_id" type="I8">
			<KEY />
			<AUTOINCREMENT />
		</field>
		<field name="user_id" type="I8">
			<NOTNULL/>
		</field>
		<field name="date_created" type="T">
			<NOTNULL/>
		</field>
		<field name="date_read" type="T" />
		<field name="contents" type="C2" size="255" >
			<NOTNULL/>
		</field>
		<field name="param" type="C2" size="255" />
		<field name="location" type="C2" size="255" />
		<field name="is_localized" type="I1" >
			<NOTNULL/>
			<DEFAULT VALUE="1"/>
		</field>
		<field name="product" type="C2" size="20" />
		<field name="context" type="I8">
			<NOTNULL/>
		</field>
		<field name="assoc_type" type="I8">
			<NOTNULL/>
		</field>
		<descr>Stores notifications for users as created by the system after certain operations.</descr>
	</table>
	
	<!--
	  *
	  * TABLE notification_settings
	  *
	  -->
	<table name="notification_settings">
		<field name="setting_id" type="I8">
			<KEY />
			<AUTOINCREMENT />
		</field>
		<field name="setting_name" type="C2" size="64">
			<NOTNULL/>
		</field>
		<field name="setting_value" type="X">
			<NOTNULL/>
		</field>
		<field name="user_id" type="I8">
			<NOTNULL/>
		</field>
		<field name="product" type="C2" size="20" />
		<field name="context" type="I8">
			<NOTNULL/>
		</field>
		<descr>Lists all notifications types for each user that they do NOT want to be informed of, and also contains a list of RSS feed tokens for each user.</descr>
	</table>
	
	<!-- OAI Tables -->
	
	<!--

Return to bug 3922