<?php
/**
 * VirtueMart script file
 *
 * This file is executed during install/upgrade and uninstall
 * @package VirtueMart
 * @author Max Milbers, RickG, impleri
 * @copyright Copyright (C) 2011- 2021 by the VirtueMart team - All rights reserved.
 * @license http://www.gnu.org/licenses/gpl-3.0.html GNU/GPL 3, or later see COPYRIGHT.php
 * VirtueMart is free software. This version may have been modified pursuant
 * to the GNU General Public License, and as distributed it includes or
 * is derivative of works licensed under the GNU General Public License or
 * other free or open source software licenses.

 */
defined('_JEXEC') or die('Restricted access');


/**
 * VirtueMart custom installer class
 */
class com_virtuemartInstallerScript {

	var $_db = null;
	var $path = null;

	/**
	 * method must be called after preflight
	 * Sets the paths and loads VMFramework config
	 */
	public function loadVm($fresh = true) {

		static $loaded = false;
		if($loaded) return true;
		$this->path = $this->getVMPathRoot();
		if(!class_exists('VmConfig')){
			require_once($this->path .'/administrator/components/com_virtuemart/helpers/config.php');
		} else {
			if(!defined('VMPATH_ROOT') or $this->path!=VMPATH_ROOT){

				//$app = JFactory::getApplication();
				//$app->enqueueMessage(JText::_('COM_VM_INSTALL_VMCONFIG_ALREADY_LOADED'),'warning');
				if(!class_exists('vmDefines') and file_exists($this->path.'/administrator/components/com_virtuemart/helpers/vmdefines.php')){
					require_once( $this->path.'/administrator/components/com_virtuemart/helpers/vmdefines.php');
				}
				if(class_exists('vmDefines') and method_exists('vmDefines','core')){
					vmDefines::core($this->path);
				} else {
					$this->registerCoreClasses($this->path);
					//return false;
				}
			}
		}

		VmConfig::loadConfig(true, $fresh, true, false);
		VmLanguage::loadJLang('com_virtuemart');
		if(!empty($this->path))vmdebug('com_virtuemartInstallerScript loadVm',$this->path);

		VmTable::addIncludePath($this->path .'/administrator/components/com_virtuemart/tables');
		VmModel::addIncludePath($this->path .'/administrator/components/com_virtuemart/models');

		//Maybe it is possible to set this within the xml file note by Max Milbers
		VmConfig::ensureMemoryLimit(256);
		VmConfig::ensureExecutionTime(300);

		$loaded = true;
		return true;
	}

	public function getVMPathRoot(){
		$source_path = dirname(__FILE__);//JInstaller::getInstance()->getPath('source');

		if(!empty($source_path)){
			$len = strlen($source_path);
			//We must remove the install folder to get the root
			$pos = strrpos($source_path, DIRECTORY_SEPARATOR.'install');

			if($pos>($len - 10)){	//Ensure that we just cut the trailing install
				$source_path = substr($source_path,0,$pos);
			}

			$len = strlen($source_path);
			$trail = DIRECTORY_SEPARATOR.'administrator'.DIRECTORY_SEPARATOR.'components'.DIRECTORY_SEPARATOR.'com_virtuemart';
			$lenTr = strlen($trail);
			$pos = strrpos($source_path, $trail);

			if( $pos > ($len - ($lenTr+4)) ){	//Ensure that we just cut the trailing install
				$source_path = substr($source_path,0,$pos);
			}
		} else {
			$source_path = JPATH_ROOT;
		}
		return $source_path;
	}

	public function checkIfUpdate(){

		$this->_db = JFactory::getDBO();
		$q = 'SHOW TABLES LIKE "'.$this->_db->getPrefix().'virtuemart_adminmenuentries"'; //=>jos_virtuemart_shipment_plg_weight_countries
		$this->_db->setQuery($q);
		$res = $this->_db->loadResult();
		if($res){

			$q = "SELECT count(id) AS idCount FROM `#__virtuemart_adminmenuentries`";
			$this->_db->setQuery($q);
			$result = $this->_db->loadResult();

			if (empty($result)) {
				$update = false;
			} else {
				$update = true;
			}
		} else {
			$update = false;
		}

		return $update;
	}


	/**
	 * Pre-process method (e.g. install/upgrade) and any header HTML
	 *
	 * @param string Process type (i.e. install, uninstall, update)
	 * @param object JInstallerComponent parent
	 * @return boolean True if VM exists, null otherwise
	 */
	public function preflight ($type, $parent=null) {

		$this->_db = JFactory::getDBO();

		$config = JFactory::getConfig();
		$type = $config->get( 'dbtype' );
		if ($type != 'mysqli' and $type!= 'Jdiction_mysqli') {
			JFactory::getApplication()->enqueueMessage('To ensure seemless working with Virtuemart please use MySQLi as database type in Joomla configuration', 'warning');
			return false;
		}
	}


	/**
	 * Install script
	 * Triggers after database processing
	 *
	 * @param object JInstallerComponent parent
	 * @return boolean True on success
	 */
	public function install ($loadVm = true) {

		if($this->checkIfUpdate()){
			return $this->update($loadVm);
		}

		$this->loadVm(true);

		$_REQUEST['install'] = 1;

		$this -> joomlaSessionDBToMediumText();

		// install essential and required data
		// should this be covered in install.sql (or 1.6's JInstaller::parseSchemaUpdates)?
		$params = JComponentHelper::getParams('com_languages');
		$lang = $params->get('site', 'en-GB');//use default joomla
		$lang = strtolower(strtr($lang,'-','_'));

		$model = VmModel::getModel('updatesmigration');
		$model->execSQLFile($this->path .'/administrator/components/com_virtuemart/install/install.sql');
		$model->execSQLFile($this->path .'/administrator/components/com_virtuemart/install/install_essential_data.sql');
		$model->execSQLFile($this->path .'/administrator/components/com_virtuemart/install/install_required_data.sql');
		$model->execSQLFile($this->path .'/administrator/components/com_virtuemart/install/install_country_data.sql');

		$this->createFolders();

		$model->setStoreOwner();
		$this->setVmLanguages();
		$this->installLanguageTables();


		$this->checkAddDefaultShoppergroups();

		$xmlFile = false;
		if(JFile::exists(VMPATH_ROOT .'/virtuemart.xml')){
			$xmlFile = VMPATH_ROOT .'/virtuemart.xml';
		} else if(JFile::exists(VMPATH_ADMIN .'/virtuemart.xml')){
			$xmlFile = VMPATH_ADMIN .'/virtuemart.xml';
		}

		if($xmlFile)$model->updateJoomlaUpdateServer('component','com_virtuemart',$xmlFile);

		$this->deleteSwfUploader();

		if(JFolder::exists($this->path .'/administrator/templates/vmadmin') and $this->path!=VMPATH_ROOT){
			$this->recurse_copy($this->path .'/administrator/templates/vmadmin',VMPATH_ROOT .'/administrator/templates/vmadmin');
		}

		$this->addActionLogEntry();

		$this->displayFinished(false);

		//include($this->path .'/install/install.virtuemart.html.php');

		// perhaps a redirect to updatesMigration here rather than the html file?
		//			$parent->getParent()->setRedirectURL('index.php?option=com_virtuemart&view=updatesMigration');

		return true;
	}

	function createFolders(){
		$this->createIndexFolder(JPATH_ROOT .'/images');
		$this->createIndexFolder(JPATH_ROOT .'/images/virtuemart');
		$this->createIndexFolder(JPATH_ROOT .'/images/virtuemart/shipment');
		$this->createIndexFolder(JPATH_ROOT .'/images/virtuemart/payment');
		$this->createIndexFolder(JPATH_ROOT .'/images/virtuemart/category');
		$this->createIndexFolder(JPATH_ROOT .'/images/virtuemart/category/resized');
		$this->createIndexFolder(JPATH_ROOT .'/images/virtuemart/manufacturer');
		$this->createIndexFolder(JPATH_ROOT .'/images/virtuemart/manufacturer/resized');
		$this->createIndexFolder(JPATH_ROOT .'/images/virtuemart/product');
		$this->createIndexFolder(JPATH_ROOT .'/images/virtuemart/product/resized');
		$this->createIndexFolder(JPATH_ROOT .'/images/virtuemart/forSale');
		$this->createIndexFolder(JPATH_ROOT .'/images/virtuemart/forSale/invoices');
		$this->createIndexFolder(JPATH_ROOT .'/images/virtuemart/forSale/resized');
		$this->createIndexFolder(JPATH_ROOT .'/images/virtuemart/typeless');
		$this->createIndexFolder(JPATH_ROOT .'/images/virtuemart/vendor');
		$this->createIndexFolder(JPATH_ROOT .'/images/virtuemart/vendor/resized');
	}
	/**
	 * creates a folder with empty html file
	 *
	 * @author Max Milbers
	 *
	 */
	public function createIndexFolder($path){

		if(JFolder::create($path)) {
			return true;
		}
		return false;
	}

	/**
	 * Update script
	 * Triggers after database processing
	 *
	 * @param object JInstallerComponent parent
	 * @return boolean True on success
	 */
	public function update ($loadVm = true) {

		if(!$this->checkIfUpdate()){
			return $this->install($loadVm);
		}

		$loaded = $this->loadVm(false);
		if(!$loaded) {
			$app = JFactory::getApplication();
			$app->enqueueMessage(JText::_('COM_VM_INSTALL_DISABLE_PLUGINS_LOADING_VMCONFIG'),'warning');
			//return false;
		}

		$this->createFolders();

		//Delete Cache
		$cache = JFactory::getCache();
		$cache->clean();

		$params = JComponentHelper::getParams('com_languages');
		$lang = $params->get('site', 'en-GB');//use default joomla
		$lang = strtolower(strtr($lang,'-','_'));

		$model = VmModel::getModel('updatesmigration');
		//$model = new VirtueMartModelUpdatesMigration(); //JModel::getInstance('updatesmigration', 'VirtueMartModel');
		$model->execSQLFile($this->path .'/administrator/components/com_virtuemart/install/install.sql');


		$this -> joomlaSessionDBToMediumText();

		$this->updateToVm3 = $this->isUpdateToVm3();


		$this->alterTable('#__virtuemart_product_prices',
			array(
			'product_price_vdate' => '`product_price_publish_up` datetime AFTER `product_currency`',
			'product_price_edate' => '`product_price_publish_down` datetime AFTER `product_price_publish_up`'
		));
		$this->alterTable('#__virtuemart_customs',array(
			'custom_field_desc' => '`custom_desc` varchar(4095) COMMENT \'description or unit\'',
			'custom_params' => '`custom_params` text  NOT NULL'
		));
		$this->alterTable('#__virtuemart_product_customfields',array(
			'custom_value' => ' `customfield_value` varchar(2500) COMMENT \'field value\'',
			'custom_price' => ' `customfield_price` DECIMAL(15,6) COMMENT \'price\'',
			'custom_param' => ' `customfield_params` text COMMENT \'Param for Plugins\''
		));


		$this->alterTable('#__virtuemart_userfields',array(
			'params' => '`userfield_params` text',
		));

		$this->alterTable('#__virtuemart_orders',array(
			'customer_note' => '`oc_note` text COMMENT \'old customer notes\'',
		));

		$this->alterTable('#__virtuemart_orders',array(
			'oc_note' => '`oc_note` text COMMENT \'old customer notes\'',
		));

		$this->alterTable('#__virtuemart_vendor_users',array(
		'virtuemart_vendor_id' => '`virtuemart_vendor_user_id` int(1) UNSIGNED NOT NULL DEFAULT \'0\'',
		));

		$this->alterTable('#__virtuemart_countries',array(
			'country_code' => '`country_num_code` char(3)',
		));

		$this->moveEditorContentToCustomparams();

		JLoader::register('GenericTableUpdater', $this->path .'/administrator/components/com_virtuemart/helpers/tableupdater.php');
		$updater = new GenericTableUpdater();

		$updater->updateMyVmTables();
		$this->installLanguageTables();

		$this->checkAddDefaultShoppergroups();

		$this->addMissingOrderstati();
		$this->adjustMenuParamsCategoryView();
		$this->fixOrdersVendorId();

		$this->updateAdminMenuEntries();

		if($this->updateToVm3){
			$this->migrateCustoms();
			$this->checkUserfields();
		}

		//copy sampel media
		$src = $this->path .'/assets/images/vmsampleimages';
		if(JFolder::exists($src)){
			$dst = VMPATH_ROOT .'/images/virtuemart';
			$this->recurse_copy($src,$dst);
		}

		//copy payment/shipment logos to new directory
		$dest = JPATH_ROOT .'/images/virtuemart';
		$src = JPATH_ROOT .'/images/stories/virtuemart';
		if(JFolder::exists($src .'/payment') and !JFolder::exists($dest .'/payment')){
			$this->recurse_copy($src .'/payment',$dest .'/payment');
		}
		if(JFolder::exists($src .'/shipment') and !JFolder::exists($dest .'/shipment')){
			$this->recurse_copy($src .'/shipment',$dest .'/shipment');
		}

		$xmlFile = false;
		if(JFile::exists(VMPATH_ROOT .'/virtuemart.xml')){
			$xmlFile = VMPATH_ROOT .'/virtuemart.xml';
		} else if(JFile::exists(VMPATH_ADMIN .'/virtuemart.xml')){
			$xmlFile = VMPATH_ADMIN .'/virtuemart.xml';
		}
		if($xmlFile) $model->updateJoomlaUpdateServer('component','com_virtuemart', $xmlFile);

		//fix joomla BE menu
		if(version_compare(JVERSION,'3.7.0','ge')) {
			$this->removeOldMenuLinks();
		} else {
			$this->checkFixJoomlaBEMenuEntries();
		}

		$this->deleteSwfUploader();
		$this->deleteOverridenJoomlaFields();
		$this->updateOldConfigEntries();

		$model->updateCountryTableISONumbers(true, $this->path);

		VirtueMartModelCategory::updateCategories();

		if(JFolder::exists($this->path .'/administrator/templates/vmadmin') and $this->path .'/administrator/templates/vmadmin'!=VMPATH_ROOT .'/administrator/templates/vmadmin'){
			$this->recurse_copy($this->path .'/administrator/templates/vmadmin',VMPATH_ROOT .'/administrator/templates/vmadmin');
		}

		$this->addActionLogEntry();
		$this->removeMF_nameFromValidSearch();

		//$this->sortPDFInvoiceInYears();

		if($loadVm) $this->displayFinished(true);

		return true;
	}

	private function sortPDFInvoiceInYears(){

		$safePath = shopFunctions::getSafePathFor(1,'invoice');
		if( JFolder::exists($safePath) ){
			$dir = opendir($safePath);
			//$this->createIndexFolder($dst);

			if(is_resource($dir)) {
				while (false !== ($file = readdir($dir))) {
					if (( $file != '.' ) && ( $file != '..' )) {
						$mTime = filemtime($safePath.'/'.$file);    //z.B. 1695829067
						$date = date ("F d Y H:i:s.", $mTime);
						$year = floor($mTime/31556926) +1970;
						vmdebug('sortPDFInvoiceInYears $mTime ',$mTime,$date,$year,$file);
					}
				}
			} else {
				vmdebug('sortPDFInvoiceInYears safepath is not a ressource '.$safePath);
			}
		} else {
			vmdebug('sortPDFInvoiceInYears safepath folder does not exist '.$safePath);
		}
	}

	private function removeMF_nameFromValidSearch(){

		$valid_search_fields = VmConfig::get ('browse_search_fields',array());
		if( $key = array_search('mf_name', $valid_search_fields) ){
			unset($valid_search_fields[$key]);
			VmConfig::set('browse_search_fields',$valid_search_fields);
			VmConfig::updateDbEntry();
		}

	}


	private function moveEditorContentToCustomparams(){

		if(empty($this->_db)) {
			$this->_db = JFactory::getDBO();
		}
		$q = 'SELECT `virtuemart_customfield_id`, `customfield_value`
				FROM `#__virtuemart_product_customfields` as pc
				LEFT JOIN `#__virtuemart_customs` c ON pc.virtuemart_custom_id = c.virtuemart_custom_id
				WHERE `field_type` = "X" and customfield_value!=""';
		$this->_db->setQuery($q);
		$res = $this->_db->loadAssocList();
		foreach($res as $customfield){
			$q = 'UPDATE #__virtuemart_product_customfields SET `customfield_params`="'.$this->_db->escape($customfield['customfield_value']).'", customfield_value="" WHERE virtuemart_customfield_id = "'.$customfield['virtuemart_customfield_id'].'" ';
			$this->_db->setQuery($q);
			//vmdebug('my query here',$q);
			$res = $this->_db->execute();
		}

	}

	private function addActionLogEntry(){

		$extension = 'com_virtuemart';
		$this->_db = JFactory::getDbo();
		$this->_db->setQuery('SELECT `id` FROM #__action_logs_extensions Where extension="'.$extension.'"');
		$id = $this->_db->loadResult();
		if(!$id){
			$this->_db->setQuery(' INSERT into #__action_logs_extensions (extension) VALUES ('.$this->_db->Quote($extension).') ' );
			try {
				// If it fails, it will throw a RuntimeException
				$result = $this->_db->execute();
			} catch (RuntimeException $e) {
				JFactory::getApplication()->enqueueMessage($e->getMessage());
				return false;
			}
		}

/*		$extension = 'com_virtuemart';
		$this->_db = JFactory::getDbo();
		$this->_db->setQuery('SELECT `id` FROM #__action_log_config Where type_alias="'.$extension.'.product.added"');
		$id = $this->_db->loadResult();
		if(!$id){
			$logConf = new stdClass();
			$logConf->id = 0;
			$logConf->type_title = 'VM product.added';
			$logConf->type_alias = $extension.'.product.added';
			$logConf->id_holder = 'virtuemart_product_id';
			$logConf->title_holder = 'Für was ist das?';
			$logConf->table_name = '#__virtuemart_products';
			$logConf->text_prefix = 'COM_VM';

			try {
				// If it fails, it will throw a RuntimeException
				// Insert the object into the table.
				$result = $this->_db->insertObject('#__action_log_config', $logConf);
			} catch (RuntimeException $e) {
				JFactory::getApplication()->enqueueMessage($e->getMessage());
				return false;
			}
		}*/


	}

	private function installLanguageTables(){
		VmModel::getModel('config');
		VirtueMartModelConfig::installLanguageTables();
	}

	private function setVmLanguages(){
		$m = VmModel::getModel('config');
		$m->setVmLanguages();
	}

	private function updateOldConfigEntries(){

		$config = VmConfig::loadConfig(FALSE, FALSE, true, false);
		if(VmConfig::get('featured','none') == 'none'){
			$config->set('featured', $config->get('show_featured', 1));
			$config->set('discontinued', $config->get('show_discontinued', 0));
			$config->set('topten', $config->get('show_topTen', 0));
			$config->set('recent', $config->get('show_recent', 0));
			$config->set('latest', $config->get('show_latest', 0));

			$config->set('featured_rows', $config->get('featured_products_rows',1));
			$config->set('discontinued_rows', $config->get('discontinued_products_rows',1));
			$config->set('topten_rows', $config->get('topTen_products_rows',1));
			$config->set('recent_rows', $config->get('recent_products_rows',1));
			$config->set('latest_rows', $config->get('latest_products_rows',1));

			$config->set('omitLoaded_topten', $config->get('omitLoaded_topTen',1));
			$config->set('showcategory', $config->get('showCategory',1));

			$data['virtuemart_config_id'] = 1;
			$data['config'] = $config->toString();

			$confTable = VmModel::getModel('config')->getTable('configs');
			$confTable->bindChecknStore($data);

			VmConfig::loadConfig(FALSE, FALSE, true, false);
		}
	}

	private function deleteOverridenJoomlaFields(){
		if(JVM_VERSION>0){
			if( JFolder::exists(VMPATH_ADMIN .'/fields') ){
				if( JFolder::exists(VMPATH_ADMIN .'/fields/jfields') ){
					JFolder::delete(VMPATH_ADMIN .'/fields/jfields');
				}
				$oldJFields = array('filelist','list','radio','text','textarea');
				foreach($oldJFields as $field){
					$d = VMPATH_ADMIN .'/fields/'.$field.'.php';
					if( JFile::exists($d) ){
						JFile::delete($d);
					}
				}
			}
		}
	}

	private function deleteSwfUploader(){
		if(JVM_VERSION>0){
			if( JFolder::exists(VMPATH_ROOT .'/media/system/swf')){
				JFolder::delete(VMPATH_ROOT .'/media/system/swf');
			}
			if( JFile::exists(VMPATH_ROOT .'/administrator/language/en-GB/en-GB.com_virtuemart.sys.ini')){
				JFile::delete(VMPATH_ROOT .'/administrator/language/en-GB/en-GB.com_virtuemart.sys.ini');
			}
		}
	}

	private function isUpdateToVm3(){

		if(empty($this->_db)) {
			$this->_db = JFactory::getDBO();
		}

		$tablename = '#__virtuemart_product_customfields';
		$this->_db->setQuery('SHOW FULL COLUMNS  FROM `'.$tablename.'` ');
		//$fullColumns = $this->_db->loadObjectList();
		$columns = $this->_db->loadColumn(0);
		if(in_array('custom_value',$columns) or in_array('custom_price',$columns)){
			vmInfo('Upgrade of VM2 to VM3');
			return true;
		} else {
			vmdebug('Update of VM3');
			return false;
		}

	}

	private function fixOrdersVendorId(){

		$multix = Vmconfig::get('multix','none');

		if( $multix == 'none'){

			if(empty($this->_db)){
				$this->_db = JFactory::getDBO();
			}

			$q = 'SELECT `virtuemart_user_id` FROM #__virtuemart_orders WHERE virtuemart_vendor_id = "0" ';
			$this->_db->setQuery($q);
			$res = $this->_db->loadResult();

			if($res){
				//vmdebug('fixOrdersVendorId ',$res);
				$q = 'UPDATE #__virtuemart_orders SET `virtuemart_vendor_id`=1 WHERE virtuemart_vendor_id = "0" ';
				$this->_db->setQuery($q);
				$res = $this->_db->execute();

				$q = 'UPDATE #__virtuemart_order_items SET `virtuemart_vendor_id`=1 WHERE virtuemart_vendor_id = "0" ';
				$this->_db->setQuery($q);
				$res = $this->_db->execute();

			}

		}

	}

	private function addMissingOrderstati(){

		if(empty($this->_db)){
			$this->_db = JFactory::getDBO();
		}

		$q = '';

		$qc = 'SELECT * FROM `#__virtuemart_orderstates` WHERE `order_status_code`="F"';
		$this->_db->setQuery($qc);
		$f = $this->_db->loadResult();
		if(!$f) {
			$q .= "(null, 'F', 'COM_VIRTUEMART_ORDER_STATUS_COMPLETED', '', 'R',7, 1)";
		}

		$qc = 'SELECT * FROM `#__virtuemart_orderstates` WHERE `order_status_code`="D"';
		$this->_db->setQuery($qc);
		$d = $this->_db->loadResult();

		if(!$d) {
			if(!empty($q)) {
				$q .= ',';
			}
			$q .= "(null, 'D', 'COM_VIRTUEMART_ORDER_STATUS_DENIED', '', 'A',8, 1)";
		}

		if(!empty($q)) {
			$qi = "INSERT INTO `#__virtuemart_orderstates` (`virtuemart_orderstate_id`, `order_status_code`, `order_status_name`, `order_status_description`, `order_stock_handle`, `ordering`, `virtuemart_vendor_id`) VALUES ".$q.";";

			$this->_db->setQuery($qi);

			if(!$this->_db->execute()){
				$app = JFactory::getApplication();
				$app->enqueueMessage('Error: Insert Orderstati '.$qi );
				$ok = false;
			}
		}
	}

	private function adjustMenuParamsCategoryView(){

		if(empty($this->_db)) $this->_db = JFactory::getDBO();

		$this->_db->setQuery('SELECT `extension_id` FROM `#__extensions` WHERE `type` = "component" AND `element`="com_virtuemart" and state="0"');
		$jId = $this->_db->loadResult();

		if($jId){

			$q = 'SELECT * FROM #__menu WHERE component_id = "'.$jId.'" AND client_id="0" and link like "%view=category%" ';
			$this->_db->setQuery($q);
			$menues = $this->_db->loadAssocList();
			//vmdebug('my menues',$menues);

			foreach($menues as $menu){
				$linkOrig = $menu['link'];
				$menu['link'] = 'index.php?option=com_virtuemart&view=category';
				$link = str_replace('index.php?option=com_virtuemart&view=category','',$linkOrig);
				if(strlen($link)>1){
					$registry = new JRegistry;
					$registry->loadString($menu['params']);

					$paramsLink = explode('&',$link);
					foreach($paramsLink as $param){
						if(strpos($param,'=')!==FALSE){
							$spl = explode('=',$param);
							if(!empty($spl[0]) and isset($spl[1])){
								if($spl[0]!='virtuemart_category_id' and $spl[0]!='virtuemart_manufacturer_id'){
									$registry->set($spl[0], $spl[1]);
								} else {
									$menu['link'] .= '&'.$spl[0].'='.$spl[1];
								}
							} else {
								vmdebug('Key empty ',$spl);
							}
						}
					}
					$params = (string)$registry;
				} else {
					$params = $menu['params'];
				}

				if($linkOrig!=$menu['link'] and $menu['params']!=$params){
					$q = 'UPDATE #__menu' .
					' SET link = "'.$menu['link'].'", params = "'.$this->_db->escape($params).'"'.
					' WHERE id = '.(int) $menu['id'];
					$this->_db->setQuery( $q);

					if (!$this->_db->execute()) {
						$m = 'Updating vm category menu failed '.$q;
						vmError($m, $m);
					} else {
						vmdebug('Updated menu $menu '.$menu['id'],$linkOrig,$menu['link'],$param);
					}
				} else {
					//vmdebug('Menu dont need update '.$menu['id']);
				}

			}

			//For the moment, we do not convert old virtuemart views
			if(false){
				$q = 'SELECT * FROM #__menu WHERE component_id = "'.$jId.'" AND client_id="0" and link like "%view=virtuemart%" ';
				$this->_db->setQuery($q);
				$menues = $this->_db->loadAssocList();

				foreach($menues as $menu){
					$linkOrig = $menu['link'];
					$menu['link'] = 'index.php?option=com_virtuemart&view=category&virtuemart_category_id=0&virtuemart_manufacturer_id=0';

					$registry = new JRegistry;
					$registry->loadString($menu['params']);

					if(strpos($linkOrig,'productsublayout')){
						vmdebug('Found productsublayout in the link');
						$productsublayout = str_replace('index.php?option=com_virtuemart&view=virtuemart&productsublayout=','',$linkOrig);
					} else {
						$productsublayout = Vmconfig::get('productsublayout',0 );
					}

					$paramNames = array(
					'categorylayout' => VmConfig::get('vmlayout', 0),
					'show_store_desc' => VmConfig::get('show_store_desc',1),
					'showcategory_desc' => VmConfig::get('showcategory_desc', 1),
					'showcategory' => VmConfig::get('show_categories',1),
					'categories_per_row' => VmConfig::get('homepage_categories_per_row',3),
					'showproducts' => '1',
					'showsearch' => '0',
					'productsublayout' => $productsublayout,
					'products_per_row' => VmConfig::get('homepage_products_per_row', 3),
					'featured' => VmConfig::get('show_featured',1),
					'featured_rows' => VmConfig::get('featured_products_rows',1),
					'discontinued' => VmConfig::get('show_discontinued',0),
					'discontinued_rows' => VmConfig::get('discontinued_products_rows',1),
					'latest' => VmConfig::get('show_latest',1),
					'latest_rows' => VmConfig::get('latest_products_rows',1),
					'topten' => VmConfig::get('show_topTen',1),
					'topten_rows' => VmConfig::get('topTen_products_rows',1),
					'recent' => VmConfig::get('show_recent',0),
					'recent_rows' => VmConfig::get('recent_products_rows',1));

					foreach($paramNames as $key => $default){
						$registry->set($key, $default);
					}

					$params = (string)$registry;

					if($linkOrig!=$menu['link'] and $menu['params']!=$params){
						$q = 'UPDATE #__menu' .
						' SET link = "'.$menu['link'].'", params = "'.$this->_db->escape($params).'"'.
						' WHERE id = '.(int) $menu['id'];
						$this->_db->setQuery( $q);

						if (!$this->_db->query()) {
							$m = 'Updating vm category menu failed '.$q;
							vmError($m, $m);
						} else {
							vmdebug('Updated menu $menu '.$menu['id'],$menu['link'],$param);
						}
					} else {
						vmdebug('Menu dont need update '.$menu['id']);
					}
				}
			}

		}
	}


	public function removeOldMenuLinks(){

		$this->_db = JFactory::getDbo();
		$this->_db->setQuery('SELECT `extension_id` FROM `#__extensions` WHERE `type` = "component" AND `element`="com_virtuemart" and state="0"');
		$jId = $this->_db->loadResult();

		if($jId){
			$this->_db = JFactory::getDbo();
			$this->_db->setQuery('DELETE FROM `#__menu` WHERE `component_id` = "'.$jId.'" AND `type` = "component" AND `menutype`="vmadmin"');
			$this->_db->execute();
		}

	}

	/**
	 *
	 */
	public function checkFixJoomlaBEMenuEntries(){

		$this->_db = JFactory::getDbo();
		$this->_db->setQuery('SELECT `extension_id` FROM `#__extensions` WHERE `type` = "component" AND `element`="com_virtuemart" and state="0"');
		$jId = $this->_db->loadResult();

		if($jId){
			$mId = false;
			$qME = 'SELECT * FROM `#__menu` WHERE `component_id` = "'.$jId.'" AND `type` = "component" AND `parent_id` = "1" AND `client_id` = "1" AND id > 1';
			//now lets check if there are menue entries
			$this->_db->setQuery($qME);
			$mEntries = $this->_db->loadAssocList();

			if(!$mEntries){
				$this->_db->setQuery('SELECT `id` FROM `#__menu` WHERE `path`="com-virtuemart" AND `type` = "component" AND `parent_id` = "1" AND `client_id` = "1" AND id > 1');
				if($id = $this->_db->loadResult()){
					$this->_db->setQuery('UPDATE `#__menu` SET `component_id`="'.$jId.'", `language`="*" WHERE `id` = "'.$id.'" ');
					$this->_db->execute();

					$this->_db->setQuery($qME);
					$mEntries = $this->_db->loadAssocList();

				} else {
					vmError('Could not find VirtueMart submenues, please install VirtueMart again');
				}
			}

			if($mEntries){
				if(is_array($mEntries)){
					if(count($mEntries)>1){
						vmError('Multiple menues found');
					} else if(isset($mEntries[0])) {
						$mId = $mEntries[0]['id'];
					}
				}
			} else {
				vmError('Could not find VirtueMart submenues, please install VirtueMart again');
			}

			if($mId){
				$this->_db->setQuery('UPDATE `#__menu` SET `component_id`="'.$jId.'", `language`="*", `menutype`="vmadmin" WHERE `parent_id` = "'.$mId.'" ');
				$this->_db->execute();
				$this->_db->setQuery('UPDATE `#__menu` SET `language`="*", `menutype`="vmadmin" WHERE `id` = "'.$mId.'" ');
				$this->_db->execute();
			}

		}
	}

	private function updateAdminMenuEntries(){

		$sqlfile = VMPATH_ADMIN .'/install/install_essential_data.sql';

		$queries = $this->_db->splitSql(file_get_contents($sqlfile));

		if (count($queries) == 0) {
			vmError('SQL file has no queries!');
			return false;
		}
		$query = trim($queries[0]);

		$q = 'SELECT * FROM `#__virtuemart_adminmenuentries` ';
		$this->_db->setQuery($q);
		$existing = $this->_db->loadAssocList();

		if($existing){

			$queryLines = explode("\n",$query);
			$oldIds = array();
			foreach($queryLines as $n=>$line){
				if(empty($line)){
					unset($queryLines[$n]);
				} else {
					$line = trim($line);
					if(empty($line) or strpos($line, '--' )===0){
						unset($queryLines[$n]);
					}

					if(strpos($line, 'CREATE' )===0 or strpos( $line, 'INSERT')===0){
						$open = strpos($line,'(')+1;
						$close = strrpos($line,')') - $open;
						$keyLine = substr($line,$open,$close);
						//vmdebug('Update Admin menu entries define ',$length,$open,$close,$line,$keyLine);
						$keys = explode(',',$keyLine);

					} else if(strpos($line, '(' )===0){
						$open = strpos($line,'(')+1;
						$close = strrpos($line,')') - $open;
						$valueLine = substr($line,$open,$close);
						$values = explode(',',$valueLine);

						foreach($existing as $entry){
							$name = '\''.$entry['name'].'\'';
							if($name==trim($values[3])){
								//The entry exists, lets update it
								$oldIds[$entry['id']] = $values;
								unset($queryLines[$n]);
							}
						}
					}
				}
			}


			if(count($queryLines)>1){
				$query = trim(implode("\n",$queryLines));
				$query = substr($query,0,-1).';';
			} else {
				$query = false;
			}

			if(count($oldIds)>0){

				$updateBase = 'UPDATE `#__virtuemart_adminmenuentries` SET ';
				foreach($oldIds as $id=>$values){
					$updateQuery = '';
					foreach($keys as $index => $key){
						if($key=='`id`'){
							continue;
						}
						$value = trim($values[$index]);
						if(strpos($value,'\'')===0){
							$value = substr($value,1,-1);
						}
						$updateQuery .= $key . ' = "'.$value.'", ';
					}
					$updateQuery = substr($updateQuery,0,-2);
					$updateQuery .= ' WHERE `id` = '.$id.';';
					$this->_db->setQuery($updateBase.$updateQuery);
					if (!$this->_db->execute()) {
						vmWarn( 'JInstaller::install: '.$sqlfile.' '.vmText::_('COM_VIRTUEMART_SQL_ERROR')." ".$this->_db->stderr(true));
						$ok = false;
					}
					//vmdebug('Update Admin menu entries value $updateQuery',$updateBase.$updateQuery);
				}
			}

		}

		if(!empty($query)){
			$this->_db->setQuery($query);
			if (!$this->_db->execute()) {
				vmWarn( 'JInstaller::install: '.$sqlfile.' '.vmText::_('COM_VIRTUEMART_SQL_ERROR')." ".$this->_db->stderr(true));
			}
		}

	}

	private function checkUserfields(){

		$model = VmModel::getModel('userfields');
		$field = $model->getUserfield('customer_note','name');

		$data = array ('type' => 'textarea'
		, 'maxlength' => 2500
		, 'cols' => 60
		, 'rows' => 1
		, 'name' => 'customer_note'
		, 'title' => 'COM_VIRTUEMART_CNOTES_CART'
		, 'description' => ''
		, 'default' => ''
		, 'required' => 0
		, 'cart' => 1
		, 'account' => 0
		, 'shipment' => 0
		, 'readonly' => 0
		, 'published' => 1
		);

		if(!empty($field->virtuemart_userfield_id)) {
			if($field->published){
				$field->cart = 1;
				$id = $model->store((array)$field);
			}
		} else {
			$id = $model->store($data);
		}

		if($id)	vmInfo('Created shopperfield customer_note');


		$field = $model->getUserfield('tos','name');

		$data = array ('type' => 'custom'
		, 'name' => 'tos'
		, 'title' => 'COM_VIRTUEMART_STORE_FORM_TOS'
		, 'description' => ''
		, 'required' => 1
		, 'cart' => 1
		, 'account' => 0
		, 'shipment' => 0
		, 'readonly' => 0
		, 'published' => 1
		);

		if(!empty($field->virtuemart_userfield_id)) {
			if($field->published){
				$field->cart = 1;
				$field->required = 1;
				$id = $model->store((array)$field);
			}
		} else {
			$id = $model->store($data);
		}

		if($id)	vmInfo('Created shopperfield tos for cart and account');

		$field = $model->getUserfield('agreed','name');
		if($field){
			$field ->published = 0;
			$id = $model->store($field);
			if($id)	vmInfo('Disabled shopperfield agreed, replaced by tos');
		}

	}

	private function migrateCustoms(){


		$q = 'UPDATE `#__virtuemart_product_customfields` SET `published`= "1"  WHERE `published`="0" ';
		$this->_db->setQuery($q);
		try {
			$this->_db->execute();
		} catch (Exception $e) {
			vmError('updateCustomfieldsPublished update published '.$e->getMessage());
		}

		$q = "UPDATE `#__virtuemart_customs` SET `field_type`='S',`is_cart_attribute`=1,`is_input`=1,`is_list`='0' WHERE `field_type`='V'";
		$this->_db->setQuery($q);#		try {
		try {
			$this->_db->execute();
		} catch (Exception $e) {
			vmError('updateCustomfieldsPublished migrateCustoms '.$e->getMessage());
		}

		$q = "UPDATE `#__virtuemart_customs` SET `is_input`=1 WHERE `field_type`='M' AND `is_cart_attribute`=1";
		$this->_db->setQuery($q);
		try {
			$this->_db->execute();
		} catch (Exception $e) {
			vmError('updateCustomfieldsPublished migrateCustoms '.$e->getMessage());
		}

		$q = "UPDATE `#__virtuemart_customs` SET `field_type`='S' WHERE `field_type`='I'";
		$this->_db->setQuery($q);
		try {
			$this->_db->execute();
		} catch (Exception $e) {
			vmError('updateCustomfieldsPublished migrateCustoms '.$e->getMessage());
		}

		$q = "UPDATE `#__virtuemart_customs` SET `field_type`='S', `custom_value`='JYES;JNO',`is_list`='1' WHERE `field_type`='B'";
		$this->_db->setQuery($q);
		try {
			$this->_db->execute();
		} catch (Exception $e) {
			vmError('updateCustomfieldsPublished migrateCustoms '.$e->getMessage());
		}

		$q = "UPDATE `#__virtuemart_customs` SET `layout_pos`='addtocart' WHERE `is_input`='1'";
		$this->_db->setQuery($q);
		try {
			$this->_db->execute();
		} catch (Exception $e) {
			vmError('updateCustomfieldsPublished migrateCustoms '.$e->getMessage());
		}

		$q = "UPDATE `#__virtuemart_customs` SET `layout_pos`='ontop',`is_cart_attribute`=1 WHERE `field_type`='A'";
		$this->_db->setQuery($q);
		try {
			$this->_db->execute();
		} catch (Exception $e) {
			vmError('updateCustomfieldsPublished migrateCustoms '.$e->getMessage());
		}

		$q = "UPDATE `#__virtuemart_customs` SET `layout_pos`='related_products' WHERE `field_type`='R'";
		$this->_db->setQuery($q);
		try {
			$this->_db->execute();
		} catch (Exception $e) {
			vmError('updateCustomfieldsPublished migrateCustoms '.$e->getMessage());
		}

		$q = "UPDATE `#__virtuemart_customs` SET `layout_pos`='related_categories' WHERE `field_type`='Z'";
		$this->_db->setQuery($q);
		try {
			$this->_db->execute();
		} catch (Exception $e) {
			vmError('updateCustomfieldsPublished migrateCustoms '.$e->getMessage());
		}

		$q = "UPDATE `#__virtuemart_customs` SET `field_type`='G' WHERE `field_type`='P'";
		$this->_db->setQuery($q);
		try {
			$this->_db->execute();
		} catch (Exception $e) {
			vmError('updateCustomfieldsPublished migrateCustoms '.$e->getMessage());
		}

	}

	/**
	 * @author Max Milbers
	 * @param unknown_type $tablename
	 * @param unknown_type $fields
	 * @param unknown_type $command
	 */
	private function alterTable($tablename,$fields,$command='CHANGE'){

		$ok = true;

		if(empty($this->_db)){
			$this->_db = JFactory::getDBO();
		}

		$query = 'SHOW COLUMNS FROM `'.$tablename.'` ';
		$this->_db->setQuery($query);
		$columns = $this->_db->loadColumn(0);

		foreach($fields as $fieldname => $alterCommand){
			if(in_array($fieldname,$columns)){
				$query = 'ALTER TABLE `'.$tablename.'` '.$command.' COLUMN `'.$fieldname.'` '.$alterCommand;

				$this->_db->setQuery($query);
				try {
					$this->_db->execute();
				} catch (Exception $e) {
					$app = JFactory::getApplication();
					$app->enqueueMessage('Error: Install alterTable '.$e->getMessage() );
					$ok = false;
				}
			}
		}

		return $ok;
	}

	/**
	 *
	 * @author Max Milbers
	 * @param unknown_type $table
	 * @param unknown_type $field
	 * @param unknown_type $action
	 * @return boolean This gives true back, WHEN it altered the table, you may use this information to decide for extra post actions
	 */
	private function checkAddFieldToTable($table,$field,$fieldType){

		$query = 'SHOW COLUMNS FROM `'.$table.'` ';
		$this->_db->setQuery($query);
		$columns = $this->_db->loadColumn(0);

		if(!in_array($field,$columns)){
			
			$query = 'ALTER TABLE `'.$table.'` ADD '.$field.' '.$fieldType;
			$this->_db->setQuery($query);
			try{
				$this->_db->execute();
			} catch (Exception $e) {
				$app = JFactory::getApplication();
				$app->enqueueMessage('Error: Install checkAddFieldToTable '.$e->getMessage() );
				return false;
			}

			vmdebug('checkAddFieldToTable added '.$field);
			return true;
		}
		return false;
	}


	/**
	* Checks if both types of default shoppergroups are set
	* @author Max Milbers
	*/

	private function checkAddDefaultShoppergroups(){

		$q = 'SELECT `virtuemart_shoppergroup_id` FROM `#__virtuemart_shoppergroups` WHERE `default` = "1" ';

		$this->_db = JFactory::getDbo();
		$this->_db->setQuery($q);
		$res = $this->_db ->loadResult();

		if(empty($res)){
			$q = "INSERT INTO `#__virtuemart_shoppergroups` (`virtuemart_shoppergroup_id`, `virtuemart_vendor_id`, `shopper_group_name`, `shopper_group_desc`, `default`, `shared`) VALUES
							(NULL, 1, '-default-', 'This is the default shopper group.', 1, 1);";
			$this->_db->setQuery($q);
			$this->_db->execute();
		}

		$q = 'SELECT `virtuemart_shoppergroup_id` FROM `#__virtuemart_shoppergroups` WHERE `default` = "2" ';

		$this->_db->setQuery($q);
		$res = $this->_db ->loadResult();

		if(empty($res)){
			$q = "INSERT INTO `#__virtuemart_shoppergroups` (`virtuemart_shoppergroup_id`, `virtuemart_vendor_id`, `shopper_group_name`, `shopper_group_desc`, `default`, `shared`) VALUES
							(NULL, 1, '-anonymous-', 'Shopper group for anonymous shoppers', 2, 1);";
			$this->_db->setQuery($q);
			$this->_db->execute();
		}

	}


	private function joomlaSessionDBToMediumText(){

		if(version_compare(JVERSION,'1.6.0','ge')) {
			$fields = array('data'=>'`data` mediumtext NULL AFTER `time`');
			$this->alterTable('#__session',$fields);
		}
	}

	/**
	 * Uninstall script
	 * Triggers before database processing
	 *
	 * @param object JInstallerComponent parent
	 * @return boolean True on success
	 */
	public function uninstall ($parent=null) {

		/*if(empty($this->path)){
			$this->path = VMPATH_ADMIN;
		}*/
		//$this->loadVm();
		//include($this->path .'/install/uninstall.virtuemart.html.php');

		return true;
	}

	/**
	 * Post-process method (e.g. footer HTML, redirect, etc)
	 *
	 * @param string Process type (i.e. install, uninstall, update)
	 * @param object JInstallerComponent parent
	 */
	public function postflight ($type, $parent=null) {
		$_REQUEST['install'] = 0;
		if ($type != 'uninstall') {
			if(!class_exists('VmConfig')){
				$this->loadVm(false);
			}

			if(!class_exists('VirtueMartModelConfig')) require(VMPATH_ADMIN .'/models/config.php');
			$res  = VirtueMartModelConfig::checkConfigTableExists();

			if(!empty($res)){
				vRequest::setVar(JSession::getFormToken(), '1');
				$config = VmModel::getModel('config');
				$config->setDangerousToolsOff();
			}

		}


		return true;
	}

	/**
	 * copy all $src to $dst folder and remove it
	 *
	 * @author Max Milbers
	 * @param String $src path
	 * @param String $dst path
	 * @param String $type modules, plugins, languageBE, languageFE
	 */
	private function recurse_copy($src,$dst,$delete = true ) {

		$dir = '';
		if(JFolder::exists($src)){
			$dir = opendir($src);
			$this->createIndexFolder($dst);

			if(is_resource($dir)){
				while(false !== ( $file = readdir($dir)) ) {
					if (( $file != '.' ) && ( $file != '..' )) {
						if ( is_dir($src .DS. $file) ) {
							if(!JFolder::create($dst . DS . $file)){
								$app = JFactory::getApplication ();
								$app->enqueueMessage ('Couldnt create folder ' . $dst . DS . $file);
							}
							$this->recurse_copy($src .DS. $file,$dst .DS. $file);
						}
						else {
							if($delete and JFile::exists($dst .DS. $file)){
								if(!JFile::delete($dst .DS. $file)){
									$app = JFactory::getApplication();
									$app -> enqueueMessage('Couldnt delete '.$dst .DS. $file);
								}
							}
							if(!JFile::copy($src .DS. $file,$dst .DS. $file)){
								$app = JFactory::getApplication();
								$app -> enqueueMessage('Couldnt move '.$src .DS. $file.' to '.$dst .DS. $file);
							}
						}
					}
				}
				closedir($dir);
				//if (is_dir($src)) JFolder::delete($src);
				return true;
			}
		}

		$app = JFactory::getApplication();
		$app -> enqueueMessage('Virtuemart Installer recurse_copy; Couldnt read source directory '.$src);

	}

	public function displayFinished($update){
		require($this->path.'/administrator/components/com_virtuemart/views/updatesmigration/tmpl/insfinished.php');

	}

	static public function registerCoreClasses($rootPath = VMPATH_ROOT){

		$vmpath_admin = $rootPath.'/administrator/components/com_virtuemart';
		$vmpath_pluginlibs = $vmpath_admin.'/plugins';
		$vmpath_site = $rootPath.'/components/com_virtuemart';
		$libsPath = VMPATH_ROOT .'/libraries';

		JLoader::register('JFile', $libsPath .'/joomla/filesystem/file.php');
		JLoader::register('JFolder', $libsPath .'/joomla/filesystem/folder.php');

		JLoader::register('vmVersion', $vmpath_admin.'/version.php');
		JLoader::register('AdminUIHelper', $vmpath_admin.'/helpers/adminui.php');
		JLoader::register('calculationHelper', $vmpath_admin.'/helpers/calculationh.php');
		JLoader::register('VmConnector', $vmpath_admin.'/helpers/connection.php');
		JLoader::register('CurrencyDisplay', $vmpath_admin.'/helpers/currencydisplay.php');
		JLoader::register('VmHtml', $vmpath_admin.'/helpers/html.php');
		JLoader::register('VmImage', $vmpath_admin.'/helpers/image.php');
		JLoader::register('Img2Thumb', $vmpath_admin.'/helpers/img2thumb.php');
		JLoader::register('VmMediaHandler', $vmpath_admin.'/helpers/mediahandler.php');
		JLoader::register('vmFile', $vmpath_admin.'/helpers/mediahandler.php');
		JLoader::register('Migrator', $vmpath_admin.'/helpers/migrator.php');
		JLoader::register('ShopFunctions', $vmpath_admin.'/helpers/shopfunctions.php');
		JLoader::register('GenericTableUpdater', $vmpath_admin.'/helpers/tableupdater.php');
		JLoader::register('VmController', $vmpath_admin.'/helpers/vmcontroller.php');
		JLoader::register('vmCrypt', $vmpath_admin.'/helpers/vmcrypt.php');
		//JLoader::register('vmFilter', $vmpath_admin.'/helpers/vmfilter.php');
		JLoader::register('vmJsApi', $vmpath_admin.'/helpers/vmjsapi.php');
		JLoader::register('vmLanguage', $vmpath_admin.'/helpers/vmlanguage.php');
		JLoader::register('VmModel', $vmpath_admin.'/helpers/vmmodel.php');
		JLoader::register('VmPagination', $vmpath_admin.'/helpers/vmpagination.php');
		JLoader::register('vmRSS', $vmpath_admin.'/helpers/vmrss.php');
		JLoader::register('VmTable', $vmpath_admin.'/helpers/vmtable.php');
		JLoader::register('VmTableData', $vmpath_admin.'/helpers/vmtabledata.php');
		JLoader::register('VmTableXarray', $vmpath_admin.'/helpers/vmtablexarray.php');
		JLoader::register('vmText', $vmpath_admin.'/helpers/vmtext.php');
		JLoader::register('vmUploader', $vmpath_admin.'/helpers/vmuploader.php');
		JLoader::register('VmViewAdmin', $vmpath_admin.'/helpers/vmviewadmin.php');
		JLoader::register('vObject', $vmpath_admin.'/helpers/vobject.php');
		JLoader::register('vRequest', $vmpath_admin.'/helpers/vrequest.php');

		JLoader::register('VirtueMartModelCalc', $vmpath_admin.'/models/calc.php');
		JLoader::register('VirtueMartModelCategory', $vmpath_admin.'/models/category.php');
		JLoader::register('VirtueMartModelConfig', $vmpath_admin.'/models/config.php');
		JLoader::register('VirtueMartModelCountry', $vmpath_admin.'/models/country.php');
		JLoader::register('VirtueMartModelCoupon', $vmpath_admin.'/models/coupon.php');
		JLoader::register('VirtueMartModelCurrency', $vmpath_admin.'/models/currency.php');
		JLoader::register('VirtueMartModelCustom', $vmpath_admin.'/models/custom.php');
		JLoader::register('VirtueMartModelCustomfields', $vmpath_admin.'/models/customfields.php');
		JLoader::register('VirtueMartModelInventory', $vmpath_admin.'/models/inventory.php');
		JLoader::register('VirtueMartModelInvoice', $vmpath_admin.'/models/invoice.php');
		JLoader::register('VirtueMartModelManufacturer', $vmpath_admin.'/models/manufacturer.php');
		JLoader::register('VirtuemartModelManufacturercategories', $vmpath_admin.'/models/manufacturercategories.php');
		JLoader::register('VirtueMartModelMedia', $vmpath_admin.'/models/media.php');
		JLoader::register('VirtueMartModelOrders', $vmpath_admin.'/models/orders.php');
		JLoader::register('VirtueMartModelOrderstatus', $vmpath_admin.'/models/orderstatus.php');
		JLoader::register('VirtueMartModelPaymentmethod', $vmpath_admin.'/models/paymentmethod.php');
		JLoader::register('VirtueMartModelProduct', $vmpath_admin.'/models/product.php');
		JLoader::register('VirtueMartModelRatings', $vmpath_admin.'/models/ratings.php');
		JLoader::register('VirtuemartModelReport', $vmpath_admin.'/models/report.php');
		JLoader::register('VirtueMartModelShipmentmethod', $vmpath_admin.'/models/shipmentmethod.php');
		JLoader::register('VirtueMartModelShopperGroup', $vmpath_admin.'/models/shoppergroup.php');
		JLoader::register('VirtueMartModelUpdatesMigration', $vmpath_admin.'/models/updatesmigration.php');
		JLoader::register('VirtueMartModelState', $vmpath_admin.'/models/state.php');
		JLoader::register('VirtueMartModelUser', $vmpath_admin.'/models/user.php');
		JLoader::register('VirtueMartModelUserfields', $vmpath_admin.'/models/userfields.php');
		JLoader::register('VirtueMartModelVendor', $vmpath_admin.'/models/vendor.php');

		JLoader::register('vmCalculationPlugin', $vmpath_pluginlibs.'/vmcalculationplugin.php');
		JLoader::register('vmCouponPlugin', $vmpath_pluginlibs.'/vmcouponplugin.php');
		JLoader::register('vmCurrencyPlugin', $vmpath_pluginlibs.'/vmcurrencyplugin.php');
		JLoader::register('vmCustomPlugin', $vmpath_pluginlibs.'/vmcustomplugin.php');
		JLoader::register('vmExtendedPlugin', $vmpath_pluginlibs.'/vmextendedplugin.php');
		JLoader::register('vmPlugin', $vmpath_pluginlibs.'/vmplugin.php');
		JLoader::register('vmPSPlugin', $vmpath_pluginlibs.'/vmpsplugin.php');
		JLoader::register('vmShopperPlugin', $vmpath_pluginlibs.'/vmshopperplugin.php');
		JLoader::register('vmUserfieldPlugin', $vmpath_pluginlibs.'/vmuserfieldtypeplugin.php');

		JLoader::register('TableCalcs', $vmpath_admin.'/tables/calcs.php');
		JLoader::register('TableCategories', $vmpath_admin.'/tables/categories.php');
		JLoader::register('TableCategory_medias', $vmpath_admin.'/tables/category_medias.php');
		JLoader::register('TableManufacturers', $vmpath_admin.'/tables/manufacturers.php');
		JLoader::register('TableMedias', $vmpath_admin.'/tables/medias.php');
		JLoader::register('TableUserinfos', $vmpath_admin.'/tables/userinfos.php');
		JLoader::register('TableVendors', $vmpath_admin.'/tables/TableVendors.php');

		JLoader::register('shopFunctionsF', $vmpath_site.'/helpers/shopfunctionsf.php');
		JLoader::register('VmView', $vmpath_site.'/helpers/vmview.php');

	}

}

// pure php no tag