D-Net

<?php

defined('_JEXEC') or die('Access denied');

jimport('joomla.log.log');

class com_openaireInstallerScript {

	private $parameters = array(

		'alertsAtomUrn' => 'urn:uuid:afdb7560-8ff4-4a6d-a9f1-6acb55269134',

		'alertsJdbcUri' => 'jdbc:mysql://localhost:3306/joomla-2.5.3?user=joomla&password=aighe6Ba',

		'alertsNewsCategory' => 8,

		'alertsNewsUser' => 42,

		'alertsPageSize' => 100,

		'alertsTwitterAccessToken' => '292267214-mvvJnhkzBtZ4xWv3DTCiAAO1ZRKf3TkULWG2hUMN',

		'alertsTwitterAccessTokenSecret' => 'qqojkHjZInqOX1ZMUYPn2owEONj4qptNjOywSLha4k',

		'invenioPassword' => 'password',

		'invenioUrl' => 'https://openaire.cern.ch/',

		'searchServiceUrl' => 'http://beta.services.openaire.eu:8480/search/',

		'statisticsDocumentChartUrl' => 'http://www.openaire.eu:18080/stats/pubchart?pubdrid=',

		'statisticsDocumentExistUrl' => 'http://www.openaire.eu:18080/stats/exist?pubdrid=',

		'statisticsRepositoryChartUrl' => 'http://www.openaire.eu:18080/stats/repchart?replink=',

		'statisticsRepositoryChartUrl' => 'http://www.openaire.eu:18080/stats/repchart?replink=',

		'statisticsProjectChartUrl' => 'http://dl114.madgik.di.uoa.gr/stats/',

		'statisticsRepositoryExistUrl' => 'http://www.openaire.eu:18080/stats/exist?replink=',

		'thriftHost' => 'rudie.di.uoa.gr',

		'thriftPort' => 7911,

		'thriftTimeout' => 1500,

		'validatorPassword' => 'password',

		'validatorUrl' => 'http://test.openaire.eu:8380/dnet-validator-openaire/portalLogin.action',

		'validatorPassword' => '568345',

		'piwikUrl' => 'http://vatopedi.di.uoa.gr/piwik/',

		'piwikSiteId' => 1,

                'addThisPubId' => 'ra-55a0e50aaa63d56f',

                'addThisUrl' => '//s7.addthis.com/js/300/addthis_widget.js#pubid='

	);

	public function postflight($type, $parent) {

		if ($type != 'install')

			return;

		JLog :: addLogger(array('text_file' => 'openaire.log'), JLog :: ALL, array('openaire'));

		try {

			$db = JFactory :: getDBO();

			$query = $db -> getQuery(TRUE);

			$query -> update('#__extensions');

			$query -> set('params = \'' . json_encode($this -> parameters) . '\'');

			$query -> where('name = \'openaire\'');

			$db -> setQuery($query);

			if ($db -> query() === FALSE)

				throw new Exception($db -> getErrorMsg() . ' (' . $db -> getErrorNum() . ')');

			$this -> populateAlertModes($db);

			$this -> populateTopics($db);

			JLog :: add('OpenAIRE installation completed successfully', JLog :: INFO, 'openaire');

		} catch (Exception $e) {

			JLog :: add('Error installing OpenAIRE: ' . $e -> getMessage(), JLog :: ERROR, 'openaire');

		}

	}

	private function populateAlertModes($db) {

		$db -> setQuery('DROP TABLE IF EXISTS `#__openaire_alert_modes`;');

		if ($db -> query() === FALSE)

			throw new Exception('Error populating alert modes: ' . $db -> getErrorMsg() . ' (' . $db -> getErrorNum() . ')');

		$db -> setQuery('CREATE TABLE `#__openaire_alert_modes` (`id` VARCHAR (16) NOT NULL PRIMARY KEY, `name` VARCHAR (32) NOT NULL, `description` TEXT NOT NULL, `batch` BOOLEAN NOT NULL, `adminOnly` BOOLEAN NOT NULL);');

		if ($db -> query() === FALSE)

			throw new Exception('Error populating alert modes: ' . $db -> getErrorMsg() . ' (' . $db -> getErrorNum() . ')');

		$db -> setQuery('INSERT INTO `#__openaire_alert_modes` (`id`, `name`, `description`, `batch`, `adminOnly`) VALUES (\'Atom\', \'Atom Feed (RSS)\', \'Post alert in OpenAIRE Atom feed.\', FALSE, TRUE), (\'JDBC\', \'OpenAIRE Portal - My Alerts\', \'Post alert in My Alerts.\', FALSE, FALSE), (\'Joomla!\', \'OpenAIRE News\', \'Post alert in OpenAIRE News.\', FALSE, TRUE), (\'SMTP\', \'Email\', \'Send alert by email.\', TRUE, FALSE), (\'twitter\', \'twitter\', \'Post alert to OpenAIRE twitter account.\', FALSE, TRUE);');	

		if ($db -> query() === FALSE)

			throw new Exception('Error populating alert modes: ' . $db -> getErrorMsg() . ' (' . $db -> getErrorNum() . ')');

	}

	private function populateTopics($db) {

		$db -> setQuery('DROP TABLE IF EXISTS `#__openaire_topic_hierarchy`;');

		if ($db -> query() === FALSE)

			throw new Exception('Error populating topics: ' . $db -> getErrorMsg() . ' (' . $db -> getErrorNum() . ')');

		$db -> setQuery('CREATE TABLE `#__openaire_topic_hierarchy` (`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY, `parent` INT, `name` TEXT NOT NULL, `description` TEXT NOT NULL, `templateId` VARCHAR (36), `notificationService` VARCHAR (255), `queryId` VARCHAR (36), `resultId` VARCHAR (36), FOREIGN KEY (`parent`) REFERENCES `#__openaire_topic_hierarchy` (`id`) ON UPDATE CASCADE ON DELETE CASCADE);');

		if ($db -> query() === FALSE)

			throw new Exception('Error populating topics: ' . $db -> getErrorMsg() . ' (' . $db -> getErrorNum() . ')');

	}

	/*

	DROP TABLE IF EXISTS `#__openaire_alerts`;

	CREATE TABLE `#__openaire_alerts` (`username` VARCHAR (150) NOT NULL, `time` TIMESTAMP NOT NULL, `title` VARCHAR (255) NOT NULL, `message` TEXT NOT NULL, `link` TEXT, PRIMARY KEY (`username`, `time`, `title`));

	*/	

}