<?php

defined('_JEXEC') or die('Direct Access to this location is not allowed.');

jimport('joomla.error.log');

class ModMyAlertsHelper
{
	public function getAlerts() {
		$user =& JFactory :: getUser();
		if ($user -> guest)
			return array();
		$db =& JFactory :: getDBO();
		$log = JLog :: getInstance();
		$db -> setQuery('SELECT `time`, `title`, `message`, `link` FROM `#__openaire_alerts` WHERE `username` = ' . $db -> quote($user -> username) . ' ORDER BY `time` DESC;');
		$alerts = $db -> loadAssocList();
		if ($alerts === NULL)
			$log -> addEntry(array('level' => 'error', 'comment' => ('Error retrieving alerts for user ' . $user -> username . ': ' . $db -> getErrorMsg() . ' (' . $db -> getErrorNum() . ')')));
		else
			$log -> addEntry(array('level' => 'info', 'comment' => ('Retrieved ' . count($alerts) . ' alerts for user ' . $user -> username)));
		return $alerts;
	}
}

?>