script.j2migrationchecker.php

<?php
/*
* @package		Emailbasket Application
* @subpackage	J2Store
* @author    	Gokila Priya - Weblogicx India http://www.weblogicxindia.com
* @copyright	Copyright (c) 2014 Weblogicx India Ltd. All rights reserved.
* @license		GNU/GPL license: http://www.gnu.org/copyleft/gpl.html
* --------------------------------------------------------------------------------
*/

// no direct access
defined('_JEXEC') or die('Restricted access');
require_once(JPATH_ADMINISTRATOR . '/components/com_j2store/version.php');

class Com_J2MigrationCheckerInstallerScript
{
    function preflight($type, $parent)
    {
        jimport('joomla.filesystem.file');
        $app = JFactory::getApplication();
        $version_file = JPATH_ADMINISTRATOR . '/components/com_j2store/version.php';
        if (JFile::exists($version_file)) {
            require_once($version_file);
            // abort if the current J2Store release is older
            if (($type == 'install') && version_compare(J2STORE_VERSION, '3.99.99', 'ge')) {
                $app->enqueueMessage('You are using an latest version of J2Store. No need to migrate', 'warning');
                return false;
            }
        } else {
            $app->enqueueMessage('J2Store not found or the version file is not found. Make sure that you have installed J2Store before installing this plugin', 'warning');
            return false;
        }

        $db = JFactory::getDbo();
        // get the table list
        $tables = $db->getTableList();
        // get prefix
        $prefix = $db->getPrefix();
        if (!in_array($prefix . 'extension_check', $tables)) {
            $query = "CREATE TABLE IF NOT EXISTS `#__extension_check` (
                                  `extension_check_id` int(11) NOT NULL AUTO_INCREMENT,
                                  `component_status` varchar(50) NOT NULL,
                                  `plugins_status` varchar(50) NOT NULL,
                                  `modules_status` varchar(50) NOT NULL,
                                  `template_status` varchar(50) NOT NULL,
                                  `installation_status` int(11) NOT NULL,
                                  PRIMARY KEY (`extension_check_id`)
                                ) ENGINE=InnoDB  DEFAULT CHARSET=utf8;";
            $db->setQuery($query);
            $db->execute();
        }
        return true;
    }
}