File manager

File manager - Edit - /home/jardides/www/Jardi-design/ZZZ/tmp/install_583c0a3d724dd/script.vmallinone.php

Back
<?php defined ('_JEXEC') or die('Restricted access'); /** * * VirtueMart script file * * This file is executed during install/upgrade and uninstall * * @author Patrick Kohl, Max Milbers, Valérie Isaksen * @package VirtueMart / defined ('DS') or define('DS', DIRECTORY_SEPARATOR); //Update Tables if (!class_exists ('VmConfig')) { if(file_exists(JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_virtuemart' . DS . 'helpers' . DS . 'config.php')){ require(JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_virtuemart' . DS . 'helpers' . DS . 'config.php'); } else { jExit('Install the virtuemart Core first '); } } if(!method_exists('vRequest','vmSpecialChars')) jExit('Install the virtuemart Core first '); $max_execution_time = ini_get ('max_execution_time'); if ((int)$max_execution_time < 120) { @ini_set ('max_execution_time', '120'); } $memory_limit = (int)substr (ini_get ('memory_limit'), 0, -1); if ($memory_limit < 128) { @ini_set ('memory_limit', '128M'); } // hack to prevent defining these twice in 1.6 installation if (!defined ('_VM_AIO_SCRIPT_INCLUDED')) { define('_VM_AIO_SCRIPT_INCLUDED', TRUE); class com_virtuemart_allinoneInstallerScript { public function preflight () { //$this->vmInstall(); } public function install () { //$this->vmInstall(); } public function discover_install () { //$this->vmInstall(); } public function postflight () { $this->vmInstall (); } public function vmInstall ($dontMove=0) { jimport ('joomla.filesystem.file'); jimport ('joomla.installer.installer'); VmConfig::loadJLang('com_virtuemart'); $this->createIndexFolder (JPATH_ROOT . DS . 'plugins' . DS . 'vmcalculation'); $this->createIndexFolder (JPATH_ROOT . DS . 'plugins' . DS . 'vmcustom'); $this->createIndexFolder (JPATH_ROOT . DS . 'plugins' . DS . 'vmpayment'); $this->createIndexFolder (JPATH_ROOT . DS . 'plugins' . DS . 'vmshipment'); $this->createIndexFolder (JPATH_ROOT . DS . 'plugins' . DS . 'vmuserfield'); if(empty($dontMove)){ $this->path = JInstaller::getInstance ()->getPath ('extension_administrator'); } else { $this->path = JPATH_ROOT; } $this->dontMove = $dontMove; echo '<a href="http://virtuemart.net" target="_blank"> <img border="0" align="left" style="margin-right: 20px" src="components/com_virtuemart/assets/images/vm_menulogo.png" alt="Cart" /> </a>'; echo '<h3 style="clear: both;">Installing VirtueMart Plugins and Modules</h3>'; echo "<p>The AIO component (com_virtuemart_aio) is used to install or update all the plugins and modules essential to VirtueMart in one go.</p>"; echo "<p>Do not uninstall it.</p>"; //We do this dirty here, is just the finish page for installation, we must know if we are allowed to add sample data $db = JFactory::getDbo(); $q = 'SELECT count() FROM `#__virtuemart_products` WHERE `virtuemart_product_id`!="0" '; $db->setQuery($q); $productsExists = $db->loadResult(); if (!$productsExists) { $file = 'components/com_virtuemart/assets/css/toolbar_images.css'; $document = JFactory::getDocument(); $document->addStyleSheet($file.'?vmver='.VM_REV); ?> <p><strong> <?php echo JText::_('COM_VIRTUEMART_INSTALL_SAMPLE_DATA_OPTION') . ' ' . JText::_('COM_VIRTUEMART_INSTALL_SAMPLE_DATA'); ?> </strong> <?php echo JText::_('COM_VIRTUEMART_INSTALL_SAMPLE_DATA_TIP'); ?> </p> <div id="cpanel"> <?php if (JVM_VERSION < 3) { $class="button"; } else { $class="btn btn-primary"; } ?> <div class="icon"> <a class="<?php echo $class ?>" href="<?php echo JROUTE::_('index.php?option=com_virtuemart&view=updatesmigration&task=installSampleData&' . JSession::getFormToken() . '=1') ?>"> <?php echo JText::_('COM_VIRTUEMART_INSTALL_SAMPLE_DATA'); ?> </a> <span class="vmicon48"></span> </div> </div> <div style="clear: both;"></div> <?php } echo "<table><tr><th>Plugins</th><td></td></tr>"; if(!class_exists('VirtueMartModelUpdatesMigration')) require(VMPATH_ADMIN . DS . 'models' . DS . 'updatesmigration.php'); $this->installPlugin ('VM Payment - Standard', 'plugin', 'standard', 'vmpayment',1); $this->installPlugin ('VM Payment - Klarna', 'plugin', 'klarna', 'vmpayment'); $this->installPlugin ('VM Payment - KlarnaCheckout', 'plugin', 'klarnacheckout', 'vmpayment'); $this->installPlugin ('VM Payment - Sofort Banking/Überweisung', 'plugin', 'sofort', 'vmpayment'); $this->installPlugin ('VM Payment - PayPal', 'plugin', 'paypal', 'vmpayment'); $this->installPlugin ('VM Payment - Heidelpay', 'plugin', 'heidelpay', 'vmpayment'); $this->installPlugin ('VM Payment - Paybox', 'plugin', 'paybox', 'vmpayment'); $this->installPlugin ('VM Payment - 2Checkout', 'plugin', 'tco', 'vmpayment'); $this->installPlugin ('VM Payment - Pay with Amazon', 'plugin', 'amazon', 'vmpayment'); $this->installPlugin ('System - Pay with Amazon', 'plugin', 'amazon', 'system'); $this->installPlugin ('VM Payment - Realex HPP & API', 'plugin', 'realex_hpp_api', 'vmpayment'); $this->installPlugin ('VM UserField - Realex HPP & API', 'plugin', 'realex_hpp_api', 'vmuserfield'); $this->installPlugin ('VM Payment - Skrill', 'plugin', 'skrill', 'vmpayment'); $this->installPlugin ('VM Payment - Authorize.net', 'plugin', 'authorizenet', 'vmpayment'); $this->installPlugin ('VM Payment - Sofort iDeal', 'plugin', 'sofort_ideal', 'vmpayment'); $this->installPlugin ('VM Payment - Klikandpay', 'plugin', 'klikandpay', 'vmpayment'); $this->installPlugin ('VM Shipment - By weight, ZIP and countries', 'plugin', 'weight_countries', 'vmshipment', 1); $this->installPlugin ('VM Custom - Customer text input', 'plugin', 'textinput', 'vmcustom', 1); $this->installPlugin ('VM Custom - Product specification', 'plugin', 'specification', 'vmcustom', 1); //$this->installPlugin ('VM Custom - Stockable variants', 'plugin', 'stockable', 'vmcustom', 1); $this->installPlugin ('VM Calculation - Avalara Tax', 'plugin', 'avalara', 'vmcalculation' ); // $table = '#__virtuemart_customs'; // $fieldname = 'field_type'; // $fieldvalue = 'G'; // $this->addToRequired($table,$fieldname,$fieldvalue,"INSERT INTO `#__virtuemart_customs` // (`custom_parent_id`, `admin_only`, `custom_title`, `custom_tip`, `custom_value`, `custom_field_desc`, // `field_type`, `is_list`, `is_hidden`, `is_cart_attribute`, `published`) VALUES // (0, 0, 'COM_VIRTUEMART_STOCKABLE_PRODUCT', 'COM_VIRTUEMART_STOCKABLE_PRODUCT_TIP', NULL, // 'COM_VIRTUEMART_STOCKABLE_PRODUCT_DESC', 'G', 0, 0, 0, 1 );"); $this->installPlugin ('VirtueMart Product', 'plugin', 'virtuemart', 'search'); $this->updateMoneyBookersToSkrill(); $task = vRequest::getCmd ('task'); if ($task != 'updateDatabase') { echo "<tr><th>Modules</th><td></td></tr>"; // modules auto move $src = $this->path . DS . "modulesBE"; $dst = JPATH_ROOT . DS."administrator". DS . "modules"; $this->recurse_copy ($src, $dst); $alreadyInstalled = $this->VmModulesAlreadyInstalled(); //echo "Checking VirtueMart modules..."; $defaultParams = '{"show_vmmenu":"1"}'; $this->installModule ('VM - Administrator Module', 'mod_vmmenu', 5, $defaultParams, $dst,1,'menu',3,$alreadyInstalled); $umimodel = VmModel::getModel('updatesmigration');//$model = new VirtueMartModelUpdatesMigration(); $umimodel->updateJoomlaUpdateServer( 'module', 'mod_vmmenu', $dst ); // modules auto move $src = $this->path . DS . "modules"; $dst = JPATH_ROOT . DS . "modules"; $this->recurse_copy ($src, $dst); $alreadyInstalled = $this->VmModulesAlreadyInstalled(); if (version_compare (JVERSION, '1.6.0', 'ge')) { $defaultParams = '{"text_before":"","product_currency":"","cache":"1","moduleclass_sfx":"","class_sfx":""}'; } else { $defaultParams = "text_before=\nproduct_currency=\ncache=1\nmoduleclass_sfx=\nclass_sfx=\n"; } $this->installModule ('VM - Currencies Selector', 'mod_virtuemart_currencies', 5, $defaultParams, $dst, 0,'position-4',1,$alreadyInstalled); if (version_compare (JVERSION, '1.6.0', 'ge')) { $defaultParams = '{"product_group":"featured","max_items":"1","products_per_row":"1","display_style":"list","show_price":"1","show_addtocart":"1","headerText":"Best products","footerText":"","filter_category":"0","virtuemart_category_id":"0","cache":"0","moduleclass_sfx":"","class_sfx":""}'; } else { $defaultParams = "product_group=featured\nmax_items=1\nproducts_per_row=1\ndisplay_style=list\nshow_price=1\nshow_addtocart=1\nheaderText=Best products\nfooterText=\nfilter_category=0\ncategory_id=1\ncache=0\nmoduleclass_sfx=\nclass_sfx=\n"; } $this->installModule ('VM - Featured products', 'mod_virtuemart_product', 3, $defaultParams, $dst, 0,'position-4',1,$alreadyInstalled); if (version_compare (JVERSION, '1.6.0', 'ge')) { $defaultParams = '{"product_group":"topten","max_items":"1","products_per_row":"1","display_style":"list","show_price":"1","show_addtocart":"1","headerText":"","footerText":"","filter_category":"0","virtuemart_category_id":"0","cache":"0","moduleclass_sfx":"","class_sfx":""}'; } else { $defaultParams = "product_group=topten\nmax_items=1\nproducts_per_row=1\ndisplay_style=list\nshow_price=1\nshow_addtocart=1\nheaderText=\nfooterText=\nfilter_category=0\ncategory_id=1\ncache=0\nmoduleclass_sfx=\nclass_sfx=\n"; } $this->installModule ('VM - Best Sales', 'mod_virtuemart_product', 1, $defaultParams, $dst, 0,'position-4',1,$alreadyInstalled); if (version_compare (JVERSION, '1.6.0', 'ge')) { $defaultParams = '{"width":"20","text":"","button":"","button_pos":"right","imagebutton":"","button_text":""}'; } else { $defaultParams = "width=20\ntext=\nbutton=\nbutton_pos=right\nimagebutton=\nbutton_text=\nmoduleclass_sfx=\ncache=1\ncache_time=900\n"; } $this->installModule ('VM - Search in Shop', 'mod_virtuemart_search', 2, $defaultParams, $dst, 0,'position-4',1,$alreadyInstalled); if (version_compare (JVERSION, '1.6.0', 'ge')) { $defaultParams = '{"show":"all","display_style":"list","manufacturers_per_row":"1","headerText":"","footerText":""}'; } else { $defaultParams = "show=all\ndisplay_style=div\nmanufacturers_per_row=1\nheaderText=\nfooterText=\ncache=0\nmoduleclass_sfx=\nclass_sfx="; } $this->installModule ('VM - Manufacturer', 'mod_virtuemart_manufacturer', 8, $defaultParams, $dst, 0,'position-4',1,$alreadyInstalled); if (version_compare (JVERSION, '1.6.0', 'ge')) { $defaultParams = '{"moduleclass_sfx":"","show_price":"1","show_product_list":"1"}'; } else { $defaultParams = "moduleclass_sfx=\nshow_price=1\nshow_product_list=1\n"; } $this->installModule ('VM - Shopping cart', 'mod_virtuemart_cart', 0, $defaultParams, $dst, 0,'position-4',1,$alreadyInstalled); if (version_compare (JVERSION, '1.6.0', 'ge')) { $defaultParams = '{"Parent_Category_id":"0","layout":"default","cache":"0","moduleclass_sfx":"","class_sfx":""}'; } else { $defaultParams = "moduleclass_sfx=\nclass_sfx=\ncategory_name=default\ncache=no\n"; } $this->installModule ('VM - Category', 'mod_virtuemart_category', 4, $defaultParams, $dst, 0,'position-4',1,$alreadyInstalled); $modules = array( 'mod_virtuemart_currencies', 'mod_virtuemart_product', 'mod_virtuemart_search', 'mod_virtuemart_manufacturer', 'mod_virtuemart_cart', 'mod_virtuemart_category' ); foreach ($modules as $module) { $umimodel = VmModel::getModel('updatesmigration'); $umimodel->updateJoomlaUpdateServer( 'module', $module, $dst ); } // libraries auto move $src = $this->path . DS . "libraries"; $dst = JPATH_ROOT . DS . "libraries"; $this->recurse_copy ($src, $dst); echo "<tr><th>libraries moved to the joomla libraries folder</th><td></td></tr>"; echo "</table>"; } else { echo "<h3>Updated VirtueMart Plugin tables</h3>"; } $this->updateOrderingExtensions(); $this->replaceStockableByDynamicChilds(); echo "<h3>Installation Successful.</h3>"; return TRUE; } /** * Replaces the old stockable plugin by the native method of vm / public function replaceStockableByDynamicChilds(){ $db = JFactory::getDbo(); $db->setQuery('SELECT `extension_id` FROM `#__extensions` WHERE `type` = "plugin" AND `folder` = "vmcustom" AND `element`="stockable"'); $jId = $db->loadResult(); if($jId){ $db->setQuery('SELECT `virtuemart_custom_id` FROM #__virtuemart_customs WHERE `custom_jplugin_id` = "'.$jId.'" '); $cId = $db->loadResult(); $db->setQuery('SELECT `virtuemart_custom_id` FROM #__virtuemart_customs WHERE `field_type` = "A" '); $acId = $db->loadResult(); if($cId){ $db->setQuery('UPDATE #__virtuemart_product_customfields SET `virtuemart_custom_id` = "'.$acId.'" WHERE `virtuemart_custom_id` = "'.$cId.'" '); $db->execute(); } } $db->setQuery('UPDATE #__extensions SET `enabled` = "0" WHERE `extension_id` = "'.$jId.'" '); } private function updateMoneyBookersToSkrill() { $db = JFactory::getDBO (); $q="SELECT `extension_id` FROM `#__extensions` WHERE `#__extensions`.`folder` = 'vmpayment' AND `#__extensions`.`element` LIKE 'skrill'"; $db->setQuery ($q); $skrill_jplugin_id = $db->loadResult() ; $app = JFactory::getApplication (); $q="SELECT FROM `#__virtuemart_paymentmethods` JOIN `#__extensions` ON `#__extensions`.`extension_id` = `#__virtuemart_paymentmethods`.`payment_jplugin_id` WHERE `#__extensions`.`folder` = 'vmpayment' AND `#__extensions`.`element` LIKE 'moneybookers_%'"; $db->setQuery ($q); $moneybookers = $db->loadObjectList() ; if ($moneybookers) { echo "<h3>Updating MoneyBookers plugin to Skrill</h3>"; foreach ($moneybookers as $moneybooker) { $payment_params=$moneybooker->payment_params; $mb_element=str_replace('moneybookers_', '',$moneybooker->element); $payment_params='product='.$mb_element.'\|'.$payment_params; $q = 'UPDATE `#__virtuemart_paymentmethods` SET `payment_params`= "'.$payment_params.'" , `payment_jplugin_id` = '.$skrill_jplugin_id.' , `payment_element`= "skrill" WHERE `virtuemart_paymentmethod_id` ='.$moneybooker->virtuemart_paymentmethod_id; $db->setQuery($q); $db->query(); $app->enqueueMessage ("Updated payment method: ".$moneybooker->payment_element.". Uses skrill now"); } } $q="DELETE FROM `#__extensions` WHERE `#__extensions`.`folder` = 'vmpayment' AND `#__extensions`.`element` LIKE 'moneybookers%'"; $db->setQuery($q); $db->query(); $path =JPATH_ROOT . DS . 'plugins' . DS . 'vmpayment'; $moneybookers_variants=array('', '_acc', '_did','_gir','_idl','_obt', '_pwy','_sft', '_wlt'); foreach ($moneybookers_variants as $moneybookers_variant) { $folder=$path.DS.'moneybookers'.$moneybookers_variant; if (JFolder::exists($folder) ) { if (!JFolder::delete($folder)) { $app->enqueueMessage ("Failed to delete ". $folder." folder"); } } $lang_file= JPATH_ROOT . DS."administrator". DS . "language". DS. 'en-GB'. DS.'en-GB.plg_vmpayment_moneybookers'.$moneybookers_variant."ini"; if (JFile::exists ($lang_file) ){ if (!JFile::delete ($lang_file)) { $app->enqueueMessage ('Couldnt delete ' . $lang_file); return false; } } } } private function updateOrderingExtensions(){ $db = JFactory::getDBO (); $q = 'UPDATE `#__extensions` SET `ordering`= 20 WHERE `folder` ="vmpayment"'; $db->setQuery($q); $db->query(); $order = array('paypal','tco','amazon','realex_hpp_api','sofort','sofort_ideal','klarna','paybox','heidelpay','skrill','klikandpay'); foreach($order as $o=>$el){ $q = 'UPDATE `#__extensions` SET `ordering`= "'.$o.'" WHERE `element` ="'.$el.'"'; $db->setQuery($q); $db->query(); } $q = 'UPDATE `#__extensions` SET `ordering`= 100 WHERE `element` ="payzen"'; $db->setQuery($q); $db->query(); $q = 'UPDATE `#__extensions` SET `ordering`= 100 WHERE `element` ="systempay"'; $db->setQuery($q); $db->query(); } /** * Installs a vm plugin into the database * / private function installPlugin ($name, $type, $element, $group, $published = 0, $createJPluginTable = 1) { $task = vRequest::getCmd ('task'); if ($task != 'updateDatabase') { $data = array(); $src = $this->path . DS . 'plugins' . DS . $group . DS . $element; if ($createJPluginTable) { if (version_compare(JVERSION, '1.7.0', 'ge')) { // Joomla! 1.7 code here $table = JTable::getInstance('extension'); $data['enabled'] = $published; $data['access'] = 1; $tableName = '#__extensions'; $idfield = 'extension_id'; } else { // Joomla! 1.5 code here $table = JTable::getInstance('plugin'); $data['published'] = $published; $data['access'] = 0; $tableName = '#__plugins'; $idfield = 'id'; } $data['name'] = $name; $data['type'] = $type; $data['element'] = $element; $data['folder'] = $group; $data['client_id'] = 0; $db = JFactory::getDBO(); $q = 'SELECT COUNT() FROM `' . $tableName . '` WHERE `element` = "' . $element . '" and folder = "' . $group . '" '; $db->setQuery($q); $count = $db->loadResult(); if ($count == 2) { $q = 'SELECT ' . $idfield . ' FROM `' . $tableName . '` WHERE `element` = "' . $element . '" and folder = "' . $group . '" ORDER BY `' . $idfield . '` DESC LIMIT 0,1'; $db->setQuery($q); $duplicatedPlugin = $db->loadResult(); $q = 'DELETE FROM `' . $tableName . '` WHERE ' . $idfield . ' = ' . $duplicatedPlugin; $db->setQuery($q); $db->query(); } //We write ALWAYS in the table,like this the version number is updated if (version_compare(JVERSION, '1.6.0', 'ge')) { $data['manifest_cache'] = json_encode(JInstaller::parseXMLInstallFile($src . DS . $element . '.xml')); } if ($count == 1) { $q = 'SELECT ' . $idfield . ' FROM `' . $tableName . '` WHERE `element` = "' . $element . '" and folder = "' . $group . '" ORDER BY `' . $idfield . '`'; $db->setQuery($q); $ext_id = $db->loadResult(); $q = 'UPDATE `#__extensions` SET `manifest_cache` ="' . $db->escape($data['manifest_cache']) . '" WHERE extension_id=' . $ext_id . ';'; $db->setQuery($q); if (!$db->query()) { $app = JFactory::getApplication(); $app->enqueueMessage(get_class($this) . ':: ' . $db->getErrorMsg()); } } else { if (!$table->bind($data)) { $app = JFactory::getApplication(); $app->enqueueMessage('VMInstaller table->bind throws error for ' . $name . ' ' . $type . ' ' . $element . ' ' . $group); } if (!$table->check($data)) { $app = JFactory::getApplication(); $app->enqueueMessage('VMInstaller table->check throws error for ' . $name . ' ' . $type . ' ' . $element . ' ' . $group); } if (!$table->store($data)) { $app = JFactory::getApplication(); $app->enqueueMessage('VMInstaller table->store throws error for ' . $name . ' ' . $type . ' ' . $element . ' ' . $group); } $errors = $table->getErrors(); foreach ($errors as $error) { $app = JFactory::getApplication(); $app->enqueueMessage(get_class($this) . '::store ' . $error); } } } } if (version_compare (JVERSION, '1.7.0', 'ge')) { // Joomla! 1.7 code here $dst = JPATH_ROOT . DS . 'plugins' . DS . $group . DS . $element; } elseif (version_compare (JVERSION, '1.6.0', 'ge')) { // Joomla! 1.6 code here $dst = JPATH_ROOT . DS . 'plugins' . DS . $group . DS . $element; } else { // Joomla! 1.5 code here $dst = JPATH_ROOT . DS . 'plugins' . DS . $group; } $success = true; if ($task != 'updateDatabase') { $success =$this->recurse_copy ($src, $dst); } if ($success) { $this->updatePluginTable ($name, $type, $element, $group, $dst); } $umimodel = VmModel::getModel('updatesmigration'); $umimodel->updateJoomlaUpdateServer( $type, $element, $dst , $group ); $installTask= $count==0 ? 'installed':'updated'; echo '<tr><td>' . $name . '</td><td> '.$installTask.'</td></tr>'; } public function updatePluginTable ($name, $type, $element, $group, $dst) { $app = JFactory::getApplication (); //Update Tables if (!class_exists ('VmConfig')) { require(JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_virtuemart' . DS . 'helpers' . DS . 'config.php'); } if (class_exists ('VmConfig')) { $pluginfilename = $dst . DS . $element . '.php'; if(file_exists($pluginfilename)){ require_once ($pluginfilename); //require_once cause is more failproof and is just for install } else { $app = JFactory::getApplication (); $app->enqueueMessage (get_class ($this) . ':: VirtueMart3 could not find file '.$pluginfilename); return false; } //plgVmpaymentPaypal $pluginClassname = 'plg' . ucfirst ($group) . ucfirst ($element); //Let's get the global dispatcher $dispatcher = JDispatcher::getInstance (); $config = array('type' => $group, 'name' => $element, 'params' => ''); $plugin = new $pluginClassname($dispatcher, $config); $_psType = substr ($group, 2); $tablename = '#__virtuemart_' . $_psType . '_plg_' . $element; $db = JFactory::getDBO (); $prefix = $db->getPrefix (); $query = 'SHOW TABLES LIKE "' . str_replace ('#__', $prefix, $tablename) . '"'; $db->setQuery ($query); $result = $db->loadResult (); if ($result) { $SQLfields = $plugin->getTableSQLFields (); $loggablefields = $plugin->getTableSQLLoggablefields (); $tablesFields = array_merge ($SQLfields, $loggablefields); $update[$tablename] = array($tablesFields, array(), array()); vmdebug ('install plugin', $update); $app->enqueueMessage (get_class ($this) . ':: VirtueMart2 update ' . $tablename); if (!class_exists ('GenericTableUpdater')) { require(JPATH_VM_ADMINISTRATOR . DS . 'helpers' . DS . 'tableupdater.php'); } $updater = new GenericTableUpdater(); $updater->updateMyVmTables ($update); } } else { $app = JFactory::getApplication (); $app->enqueueMessage (get_class ($this) . ':: VirtueMart2 must be installed, or the tables cant be updated '); } } public function installModule ($title, $module, $ordering, $params, $src, $client_id = 0, $position = 'position-4', $access = 1, $alreadyInstalled = true) { $table = JTable::getInstance('module'); $db = $table->getDBO(); $src .= DS . $module; if (!$alreadyInstalled) { $params = ''; $q = 'SELECT id FROM `#__modules` WHERE `module` = "' . $module . '" '; $db->setQuery($q); $id = $db->loadResult(); if (!empty($id)) { return; } $table->load(); if (empty($table->title)) { $table->title = $title; } if (empty($table->ordering)) { $table->ordering = $ordering; } if (empty($table->published)) { $table->published = 1; } if (empty($table->module)) { $table->module = $module; } if (empty($table->params)) { $table->params = $params; } // table is loaded with access=1 $table->access = $access; if (empty($table->position)) { $table->position = $position; } if (empty($table->client_id)) { $table->client_id = $client_id; } $table->language = ''; if (!$table->check()) { $app = JFactory::getApplication(); $app->enqueueMessage('VMInstaller table->check throws error for ' . $title . ' ' . $module . ' ' . $params); } if (!$table->store()) { $app = JFactory::getApplication(); $app->enqueueMessage('VMInstaller table->store throws error for for ' . $title . ' ' . $module . ' ' . $params); } $errors = $table->getErrors(); foreach ($errors as $error) { $app = JFactory::getApplication(); $app->enqueueMessage(get_class($this) . '::store ' . $error); } // } $lastUsedId = $table->id; $q = 'SELECT moduleid FROM `#__modules_menu` WHERE `moduleid` = "' . $lastUsedId . '" '; $db->setQuery($q); $moduleid = $db->loadResult(); $action = ''; if (empty($moduleid)) { $q = 'INSERT INTO `#__modules_menu` (`moduleid`, `menuid`) VALUES( "' . $lastUsedId . '" , "0");'; } else { //$q = 'UPDATE `#__modules_menu` SET `menuid`= "0" WHERE `moduleid`= "'.$moduleid.'" '; } $db->setQuery($q); $db->query(); } if (version_compare(JVERSION, '1.6.0', 'ge')) { $q = 'SELECT extension_id FROM `#__extensions` WHERE `element` = "' . $module . '" '; $db->setQuery($q); $ext_id = $db->loadResult(); // $manifestCache = str_replace('"', '\'', $data["manifest_cache"]); $action = ''; $manifest_cache = json_encode(JInstaller::parseXMLInstallFile($src . DS . $module . '.xml')); if (empty($ext_id)) { $q = 'INSERT INTO `#__extensions` (`name`, `type`, `element`, `folder`, `client_id`, `enabled`, `access`, `protected`, `manifest_cache`, `params`, `ordering`) VALUES ( "' . $module . '" , "module", "' . $module . '", "", "' . $client_id . '", "1","' . $access . '", "0", "' . $db->escape($manifest_cache) . '", "' . $db->escape($params) . '","' . $ordering . '");'; } else { $q = 'UPDATE `#__extensions` SET `manifest_cache` ="' . $db->escape($manifest_cache) . '", state=0 WHERE extension_id='.$ext_id.';'; } $db->setQuery($q); if (!$db->query()) { $app = JFactory::getApplication(); $app->enqueueMessage(get_class($this) . ':: ' . $db->getErrorMsg()); } $installTask = empty($ext_id) ? 'installed' : 'updated'; echo '<tr><td>' . $title . '</td><td> '.$installTask.'</td></tr>'; } //$this->updateJoomlaUpdateServer( 'module', $module, $dst ); } public function VmModulesAlreadyInstalled () { // when the modules are already installed publish=-2 $table = JTable::getInstance ('module'); $db = $table->getDBO (); $q = 'SELECT count() FROM `#__modules` WHERE `module` LIKE "mod_virtuemart_%"'; $db->setQuery ($q); $count = $db->loadResult (); return $count; } public function VmAdminModulesAlreadyInstalled () { // when the modules are already installed publish=-2 $table = JTable::getInstance ('module'); $db = $table->getDBO (); $q = 'SELECT count() FROM `#__modules` WHERE `module` LIKE "mod_vmmenu"'; $db->setQuery ($q); $count = $db->loadResult (); return $count; } /* * @author Max Milbers * @param string $tablename * @param string $fields * @param string $command / private function alterTable ($tablename, $fields, $command = 'CHANGE') { 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); $this->db->query (); } } } /* * * @author Max Milbers * @param string $table * @param string $field * @param string $fieldType * @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); if (!$this->db->query ()) { $app = JFactory::getApplication (); $app->enqueueMessage ('Install checkAddFieldToTable ' . $this->db->getErrorMsg ()); return FALSE; } else { return TRUE; } } return FALSE; } /* * copy all $src to $dst folder and remove it * * @author Max Milbers * @param String $src path * @param String $dst path * @param String $type modulesBE, modules, plugins, languageBE, languageFE / private function recurse_copy ($src, $dst) { if($this->dontMove) return true; $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 (JFile::exists ($dst . DS . $file)) { if (!JFile::delete ($dst . DS . $file)) { $app = JFactory::getApplication (); $app->enqueueMessage ('Couldnt delete ' . $dst . DS . $file); return false; } } if (!JFile::move ($src . DS . $file, $dst . DS . $file)) { $app = JFactory::getApplication (); $app->enqueueMessage ('Couldnt move ' . $src . DS . $file . ' to ' . $dst . DS . $file); return false; } } } } closedir ($dir); if (is_dir ($src)) { JFolder::delete ($src); } } else { $app = JFactory::getApplication (); $app->enqueueMessage ('Couldnt read dir ' . $dir . ' source ' . $src); return false; } return true; } public function uninstall () { return TRUE; } /* * creates a folder with empty html file * * @author Max Milbers * / public function createIndexFolder ($path) { if (JFolder::create ($path)) { /if (!JFile::exists ($path . DS . 'index.html')) { JFile::copy (JPATH_ROOT . DS . 'components' . DS . 'index.html', $path . DS . 'index.html'); }*/ return TRUE; } return FALSE; } } if (!defined ('_VM_SCRIPT_INCLUDED')) { // PLZ look in #vminstall.php# to add your plugin and module function com_install () { if (!version_compare (JVERSION, '1.6.0', 'ge')) { $vmInstall = new com_virtuemart_allinoneInstallerScript(); $vmInstall->vmInstall (); } return TRUE; } function com_uninstall () { return TRUE; } } } //if defined // pure php no tag

| ver. 1.4 | Github | . | PHP 7.4.33 | Generation time: 0 | proxy | phpinfo | Settings