PageRenderTime 42ms CodeModel.GetById 16ms RepoModel.GetById 0ms app.codeStats 1ms

/administrator/components/com_virtuemart_allinone/script.vmallinone.php

https://github.com/srgg6701/auction-ruseasons
PHP | 706 lines | 454 code | 125 blank | 127 comment | 93 complexity | 8cac92b3a57bad9f8d488f4e72fa2fc6 MD5 | raw file
Possible License(s): GPL-2.0, LGPL-3.0, LGPL-2.1, BSD-3-Clause, JSON 
    

  1. <?php
    2. 

  2. defined ('_JEXEC') or die('Restricted access');
    3. 

  3. 

  4. /**
    5. 

  5.  * VirtueMart script file
    6. 

  6.  *
    7. 

  7.  * This file is executed during install/upgrade and uninstall
    8. 

  8.  *
    9. 

  9.  * @author Patrick Kohl, Max Milbers
    10. 

  10.  * @package VirtueMart
    11. 

  11.  */
    12. 

  12. 

  13. defined ('DS') or define('DS', DIRECTORY_SEPARATOR);
    14. 

  14. 

  15. $max_execution_time = ini_get('max_execution_time');
    16. 

  16. if((int)$max_execution_time<120) {
    17. 

  17. 	@ini_set( 'max_execution_time', '120' );
    18. 

  18. }
    19. 

  19. $memory_limit = (int) substr(ini_get('memory_limit'),0,-1);
    20. 

  20. if($memory_limit<128)  @ini_set( 'memory_limit', '128M' );
    21. 

  21. 

  22. // hack to prevent defining these twice in 1.6 installation
    23. 

  23. if (!defined ('_VM_SCRIPT_INCLUDED')) {
    24. 

  24. 

  25. 	define('_VM_SCRIPT_INCLUDED', TRUE);
    26. 

  26. 

  27. 	class com_virtuemart_allinoneInstallerScript {
    28. 

  28. 

  29. 		public function preflight () {
    30. 

  30. 			//$this->vmInstall();
    31. 

  31. 		}
    32. 

  32. 

  33. 		public function install () {
    34. 

  34. 			//$this->vmInstall();
    35. 

  35. 		}
    36. 

  36. 

  37. 		public function discover_install () {
    38. 

  38. 			//$this->vmInstall();
    39. 

  39. 		}
    40. 

  40. 

  41. 		public function postflight () {
    42. 

  42. 

  43. 			$this->vmInstall ();
    44. 

  44. 		}
    45. 

  45. 

  46. 		public function vmInstall () {
    47. 

  47. 

  48. 			jimport ('joomla.filesystem.file');
    49. 

  49. 			jimport ('joomla.installer.installer');
    50. 

  50. 

  51. 			$this->createIndexFolder (JPATH_ROOT . DS . 'plugins' . DS . 'vmcalculation');
    52. 

  52. 			$this->createIndexFolder (JPATH_ROOT . DS . 'plugins' . DS . 'vmcustom');
    53. 

  53. 			$this->createIndexFolder (JPATH_ROOT . DS . 'plugins' . DS . 'vmpayment');
    54. 

  54. 			$this->createIndexFolder (JPATH_ROOT . DS . 'plugins' . DS . 'vmshipment');
    55. 

  55. 

  56. 			$this->path = JInstaller::getInstance ()->getPath ('extension_administrator');
    57. 

  57. 

  58. 			$this->updateShipperToShipment ();
    59. 

  59. 			$this->installPlugin ('Standard', 'plugin',  'standard', 'vmpayment');
    60. 

  60. 			$this->installPlugin ('Paypal',    'plugin', 'paypal',    'vmpayment');
    61. 

  61. 			$this->installPlugin ('PayZen', 'plugin', 'payzen', 'vmpayment');
    62. 

  62. 			$this->installPlugin ('SystemPay', 'plugin', 'systempay', 'vmpayment');
    63. 

  63. 			//moneybookers
    64. 

  64. 			$src = $this->path . DS . 'plugins' . DS . 'vmpayment' . DS . 'moneybookers';
    65. 

  65. 			$dst = JPATH_ROOT . DS . 'plugins' . DS . 'vmpayment' . DS . 'moneybookers';
    66. 

  66. 			$this->recurse_copy ($src, $dst, 'plugins');
    67. 

  67. 			$this->installPlugin ('Moneybookers Credit Cards', 'plugin', 'moneybookers_acc', 'vmpayment');
    68. 

  68. 			$this->installPlugin ('Moneybookers Lastschrift', 'plugin', 'moneybookers_did', 'vmpayment');
    69. 

  69. 			$this->installPlugin ('Moneybookers iDeal', 'plugin', 'moneybookers_idl', 'vmpayment');
    70. 

  70. 			$this->installPlugin ('Moneybookers Giropay', 'plugin', 'moneybookers_gir', 'vmpayment');
    71. 

  71. 			$this->installPlugin ('Moneybookers Sofortueberweisung', 'plugin', 'moneybookers_sft', 'vmpayment');
    72. 

  72. 			$this->installPlugin ('Moneybookers Przelewy24', 'plugin', 'moneybookers_pwy', 'vmpayment');
    73. 

  73. 			$this->installPlugin ('Moneybookers Online Bank Transfer', 'plugin', 'moneybookers_obt', 'vmpayment');
    74. 

  74. 			$this->installPlugin ('Moneybookers Skrill Digital Wallet', 'plugin', 'moneybookers_wlt', 'vmpayment');
    75. 

  75. 			$this->installPlugin ('Authorize.net', 'plugin', 'authorizenet', 'vmpayment');
    76. 

  76. 			$this->installPlugin ('Klarna', 'plugin', 'klarna', 'vmpayment');
    77. 

  77. 			$this->installPlugin ('Heidelpay', 'plugin', 'heidelpay', 'vmpayment');
    78. 

  78. 

  79. 			$this->installPlugin ('By weight, ZIP and countries', 'plugin', 'weight_countries', 'vmshipment');
    80. 

  80. 

  81. 			$this->installPlugin ('Customer text input', 'plugin', 'textinput', 'vmcustom');
    82. 

  82. 			$this->installPlugin ('Product specification', 'plugin', 'specification', 'vmcustom');
    83. 

  83. 			$this->installPlugin ('Stockable variants', 'plugin', 'stockable', 'vmcustom');
    84. 

  84. 			$this->installPlugin ('Avalara Tax', 'plugin', 'avalara', 'vmcalculation', 0);
    85. 

  85. 

  86. 			// 			$table = '#__virtuemart_customs';
    87. 

  87. 			// 			$fieldname = 'field_type';
    88. 

  88. 			// 			$fieldvalue = 'G';
    89. 

  89. 			// 			$this->addToRequired($table,$fieldname,$fieldvalue,"INSERT INTO `#__virtuemart_customs`
    90. 

  90. 			// 					(`custom_parent_id`, `admin_only`, `custom_title`, `custom_tip`, `custom_value`, `custom_field_desc`,
    91. 

  91. 			// 					 `field_type`, `is_list`, `is_hidden`, `is_cart_attribute`, `published`) VALUES
    92. 

  92. 			// 						(0, 0, 'COM_VIRTUEMART_STOCKABLE_PRODUCT', 'COM_VIRTUEMART_STOCKABLE_PRODUCT_TIP', NULL,
    93. 

  93. 			// 					'COM_VIRTUEMART_STOCKABLE_PRODUCT_DESC', 'G', 0, 0, 0, 1 );");
    94. 

  94. 

  95. 			$this->installPlugin ('Virtuemart Product', 'plugin', 'virtuemart', 'search');
    96. 

  96. 

  97. 			$task = JRequest::getCmd ('task');
    98. 

  98. 			if ($task != 'updateDatabase') {
    99. 

  99. 

  100. 				// modules auto move
    101. 

  101. 				$src = $this->path . DS . "modules";
    102. 

  102. 				$dst = JPATH_ROOT . DS . "modules";
    103. 

  103. 				$this->recurse_copy ($src, $dst);
    104. 

  104. 

  105. 				echo "Checking VirtueMart2 modules...";
    106. 

  106. 				if (!$this->VmModulesAlreadyInstalled ()) {
    107. 

  107. 					echo "Installing VirtueMart2 modules<br/ >";
    108. 

  108. 					if (version_compare (JVERSION, '1.6.0', 'ge')) {
    109. 

  109. 						$defaultParams = '{"text_before":"","product_currency":"","cache":"1","moduleclass_sfx":"","class_sfx":""}';
    110. 

  110. 					} else {
    111. 

  111. 						$defaultParams = "text_before=\nproduct_currency=\ncache=1\nmoduleclass_sfx=\nclass_sfx=\n";
    112. 

  112. 					}
    113. 

  113. 					$this->installModule ('VM - Currencies Selector', 'mod_virtuemart_currencies', 4, $defaultParams);
    114. 

  114. 

  115. 					if (version_compare (JVERSION, '1.6.0', 'ge')) {
    116. 

  116. 						$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":""}';
    117. 

  117. 

  118. 					} else {
    119. 

  119. 						$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";
    120. 

  120. 					}
    121. 

  121. 					$this->installModule ('VM - Featured products', 'mod_virtuemart_product', 3, $defaultParams);
    122. 

  122. 

  123. 					if (version_compare (JVERSION, '1.6.0', 'ge')) {
    124. 

  124. 						$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":""}';
    125. 

  125. 					} else {
    126. 

  126. 						$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";
    127. 

  127. 					}
    128. 

  128. 					$this->installModule ('VM - Best Sales', 'mod_virtuemart_product', 1, $defaultParams);
    129. 

  129. 

  130. 					if (version_compare (JVERSION, '1.6.0', 'ge')) {
    131. 

  131. 

  132. 						$defaultParams = '{"width":"20","text":"","button":"","button_pos":"right","imagebutton":"","button_text":""}';
    133. 

  133. 					} else {
    134. 

  134. 						$defaultParams = "width=20\ntext=\nbutton=\nbutton_pos=right\nimagebutton=\nbutton_text=\nmoduleclass_sfx=\ncache=1\ncache_time=900\n";
    135. 

  135. 					}
    136. 

  136. 					$this->installModule ('VM - Search in Shop', 'mod_virtuemart_search', 2, $defaultParams);
    137. 

  137. 

  138. 					if (version_compare (JVERSION, '1.6.0', 'ge')) {
    139. 

  139. 						$defaultParams = '{"show":"all","display_style":"list","manufacturers_per_row":"1","headerText":"","footerText":""}';
    140. 

  140. 					} else {
    141. 

  141. 						$defaultParams = "show=all\ndisplay_style=div\nmanufacturers_per_row=1\nheaderText=\nfooterText=\ncache=0\nmoduleclass_sfx=\nclass_sfx=";
    142. 

  142. 					}
    143. 

  143. 					$this->installModule ('VM - Manufacturer', 'mod_virtuemart_manufacturer', 5, $defaultParams);
    144. 

  144. 

  145. 					if (version_compare (JVERSION, '1.6.0', 'ge')) {
    146. 

  146. 						$defaultParams = '{"moduleclass_sfx":"","show_price":"1","show_product_list":"1"}';
    147. 

  147. 					} else {
    148. 

  148. 						$defaultParams = "moduleclass_sfx=\nshow_price=1\nshow_product_list=1\n";
    149. 

  149. 					}
    150. 

  150. 					$this->installModule ('VM - Shopping cart', 'mod_virtuemart_cart', 0, $defaultParams);
    151. 

  151. 

  152. 					if (version_compare (JVERSION, '1.6.0', 'ge')) {
    153. 

  153. 						$defaultParams = '{"Parent_Category_id":"0","layout":"default","cache":"0","moduleclass_sfx":"","class_sfx":""}';
    154. 

  154. 					} else {
    155. 

  155. 						$defaultParams = "moduleclass_sfx=\nclass_sfx=\ncategory_name=default\ncache=no\n";
    156. 

  156. 					}
    157. 

  157. 					$this->installModule ('VM - Category', 'mod_virtuemart_category', 6, $defaultParams);
    158. 

  158. 				} else {
    159. 

  159. 					echo "VirtueMart2 modules already installed<br/ >";
    160. 

  160. 				}
    161. 

  161. 				// language auto move
    162. 

  162. 				$src = $this->path . DS . "languageFE";
    163. 

  163. 				$dst = JPATH_ROOT . DS . "language";
    164. 

  164. 				$this->recurse_copy ($src, $dst);
    165. 

  165. 				echo " VirtueMart2 language moved to the joomla language FE folder<br/ >";
    166. 

  166. 

  167. 				// language auto move
    168. 

  168. 				$src = $this->path . DS . "languageBE";
    169. 

  169. 				$dst = JPATH_ADMINISTRATOR . DS . "language";
    170. 

  170. 				$this->recurse_copy ($src, $dst);
    171. 

  171. 				echo " VirtueMart2 language moved to the joomla language BE folder<br/ >";
    172. 

  172. 

  173. 				// libraries auto move
    174. 

  174. 				$src = $this->path . DS . "libraries";
    175. 

  175. 				$dst = JPATH_ROOT . DS . "libraries";
    176. 

  176. 				$this->recurse_copy ($src, $dst);
    177. 

  177. 				echo " VirtueMart2 pdf moved to the joomla libraries folder<br/ >";
    178. 

  178. 

  179. 				//update plugins, make em loggable
    180. 

  180. 				/*			$loggables = array(	'created_on' => 'DATETIME NOT NULL DEFAULT "0000-00-00 00:00:00"',
    181. 

  181. 				'created_by' => 'INT(11) NOT NULL DEFAULT "0"',
    182. 

  182. 				'modified_on'=> 'DATETIME NOT NULL DEFAULT "0000-00-00 00:00:00"',
    183. 

  183. 				'modified_by'=> 'INT(11) NOT NULL DEFAULT "0"',
    184. 

  184. 				'locked_on' =>'DATETIME NOT NULL DEFAULT "0000-00-00 00:00:00"',
    185. 

  185. 				'locked_by' =>'INT(11) NOT NULL DEFAULT "0"'
    186. 

  186. 				);
    187. 

  187. 				foreach($loggables as $key => $value){
    188. 

  188. 				$this->checkAddFieldToTable('#__virtuemart_payment_paypal',$key,$value);
    189. 

  189. 				$this->checkAddFieldToTable('#__virtuemart_payment_standard',$key,$value);
    190. 

  190. 				$this->checkAddFieldToTable('#__virtuemart_shipment_weight_countries',$key,$value);
    191. 

  191. 				}*/
    192. 

  192. 

  193. 				echo "<H3>Installing Virtuemart Plugins and modules Success.</h3>";
    194. 

  194. 				echo "<H3>You may directly uninstall this component. Your plugins will remain</h3>";
    195. 

  195. 

  196. 				echo "<H3>Ignore the message " . JText::_ ('JLIB_INSTALLER_ABORT_COMP_BUILDADMINMENUS_FAILED') . "</h3>";
    197. 

  197. 			} else {
    198. 

  198. 				echo "<H3>Updated Virtuemart Plugin tables</h3>";
    199. 

  199. 			}
    200. 

  200. 			return TRUE;
    201. 

  201. 

  202. 		}
    203. 

  203. 

  204. 		/**
    205. 

  205. 		 * Installs a vm plugin into the database
    206. 

  206. 		 *
    207. 

  207. 		 */
    208. 

  208. 		private function installPlugin ($name, $type, $element, $group, $published=1) {
    209. 

  209. 

  210. 			$task = JRequest::getCmd ('task');
    211. 

  211. 

  212. 			if ($task != 'updateDatabase') {
    213. 

  213. 				$data = array();
    214. 

  214. 

  215. 				if (version_compare (JVERSION, '1.7.0', 'ge')) {
    216. 

  216. 

  217. 					// Joomla! 1.7 code here
    218. 

  218. 					$table = JTable::getInstance ('extension');
    219. 

  219. 					$data['enabled'] = $published;
    220. 

  220. 					$data['access'] = 1;
    221. 

  221. 					$tableName = '#__extensions';
    222. 

  222. 					$idfield = 'extension_id';
    223. 

  223. 				} elseif (version_compare (JVERSION, '1.6.0', 'ge')) {
    224. 

  224. 

  225. 					// Joomla! 1.6 code here
    226. 

  226. 					$table = JTable::getInstance ('extension');
    227. 

  227. 					$data['enabled'] = $published;
    228. 

  228. 					$data['access'] = 1;
    229. 

  229. 					$tableName = '#__extensions';
    230. 

  230. 					$idfield = 'extension_id';
    231. 

  231. 				} else {
    232. 

  232. 

  233. 					// Joomla! 1.5 code here
    234. 

  234. 					$table = JTable::getInstance ('plugin');
    235. 

  235. 					$data['published'] = $published;
    236. 

  236. 					$data['access'] = 0;
    237. 

  237. 					$tableName = '#__plugins';
    238. 

  238. 					$idfield = 'id';
    239. 

  239. 				}
    240. 

  240. 

  241. 				$data['name'] = $name;
    242. 

  242. 				$data['type'] = $type;
    243. 

  243. 				$data['element'] = $element;
    244. 

  244. 				$data['folder'] = $group;
    245. 

  245. 

  246. 				$data['client_id'] = 0;
    247. 

  247. 

  248. 				$src = $this->path . DS . 'plugins' . DS . $group . DS . $element;
    249. 

  249. 

  250. 				$db = JFactory::getDBO ();
    251. 

  251. 				$q = 'SELECT COUNT(*) FROM `' . $tableName . '` WHERE `element` = "' . $element . '" and folder = "' . $group . '" ';
    252. 

  252. 				$db->setQuery ($q);
    253. 

  253. 				$count = $db->loadResult ();
    254. 

  254. 

  255. 				//We write only in the table, when it is not installed already
    256. 

  256. 				if ($count == 0) {
    257. 

  257. 					// 				$table->load($count);
    258. 

  258. 					if (version_compare (JVERSION, '1.6.0', 'ge')) {
    259. 

  259. 						$data['manifest_cache'] = json_encode (JApplicationHelper::parseXMLInstallFile ($src . DS . $element . '.xml'));
    260. 

  260. 					}
    261. 

  261. 

  262. 					if (!$table->bind ($data)) {
    263. 

  263. 						$app = JFactory::getApplication ();
    264. 

  264. 						$app->enqueueMessage ('VMInstaller table->bind throws error for ' . $name . ' ' . $type . ' ' . $element . ' ' . $group);
    265. 

  265. 					}
    266. 

  266. 

  267. 					if (!$table->check ($data)) {
    268. 

  268. 						$app = JFactory::getApplication ();
    269. 

  269. 						$app->enqueueMessage ('VMInstaller table->check throws error for ' . $name . ' ' . $type . ' ' . $element . ' ' . $group);
    270. 

  270. 

  271. 					}
    272. 

  272. 

  273. 					if (!$table->store ($data)) {
    274. 

  274. 						$app = JFactory::getApplication ();
    275. 

  275. 						$app->enqueueMessage ('VMInstaller table->store throws error for ' . $name . ' ' . $type . ' ' . $element . ' ' . $group);
    276. 

  276. 					}
    277. 

  277. 

  278. 					$errors = $table->getErrors ();
    279. 

  279. 					foreach ($errors as $error) {
    280. 

  280. 						$app = JFactory::getApplication ();
    281. 

  281. 						$app->enqueueMessage (get_class ($this) . '::store ' . $error);
    282. 

  282. 					}
    283. 

  283. 					// remove duplicated
    284. 

  284. 				} elseif ($count == 2) {
    285. 

  285. 					$q = 'SELECT ' . $idfield . ' FROM `' . $tableName . '` WHERE `element` = "' . $element . '" ORDER BY  `' . $idfield . '` DESC  LIMIT 0,1';
    286. 

  286. 					$db->setQuery ($q);
    287. 

  287. 					$duplicatedPlugin = $db->loadResult ();
    288. 

  288. 					$q = 'DELETE FROM `' . $tableName . '` WHERE ' . $idfield . ' = ' . $duplicatedPlugin;
    289. 

  289. 					$db->setQuery ($q);
    290. 

  290. 					$db->query ();
    291. 

  291. 				}
    292. 

  292. 			}
    293. 

  293. 

  294. 			if (version_compare (JVERSION, '1.7.0', 'ge')) {
    295. 

  295. 				// Joomla! 1.7 code here
    296. 

  296. 				$dst = JPATH_ROOT . DS . 'plugins' . DS . $group . DS . $element;
    297. 

  297. 

  298. 			} elseif (version_compare (JVERSION, '1.6.0', 'ge')) {
    299. 

  299. 				// Joomla! 1.6 code here
    300. 

  300. 				$dst = JPATH_ROOT . DS . 'plugins' . DS . $group . DS . $element;
    301. 

  301. 			} else {
    302. 

  302. 				// Joomla! 1.5 code here
    303. 

  303. 				$dst = JPATH_ROOT . DS . 'plugins' . DS . $group;
    304. 

  304. 			}
    305. 

  305. 

  306. 			if ($task != 'updateDatabase') {
    307. 

  307. 				$this->recurse_copy ($src, $dst);
    308. 

  308. 			}
    309. 

  309. 

  310. 			if ($group != 'search') {
    311. 

  311. 				$this->updatePluginTable ($name, $type, $element, $group, $dst);
    312. 

  312. 			} else {
    313. 

  313. 				if (version_compare (JVERSION, '1.6.0', 'ge')) {
    314. 

  314. 					$this->updatePluginTable ($name, $type, $element, $group, $dst);
    315. 

  315. 				}
    316. 

  316. 			}
    317. 

  317. 

  318. 		}
    319. 

  319. 

  320. 

  321. 		public function updatePluginTable ($name, $type, $element, $group, $dst) {
    322. 

  322. 

  323. 			$app = JFactory::getApplication ();
    324. 

  324. 

  325. 			//Update Tables
    326. 

  326. 			if (!class_exists ('VmConfig')) {
    327. 

  327. 				require(JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_virtuemart' . DS . 'helpers' . DS . 'config.php');
    328. 

  328. 			}
    329. 

  329. 

  330. 			if (class_exists ('VmConfig')) {
    331. 

  331. 				$pluginfilename = $dst . DS . $element . '.php';
    332. 

  332. 				require ($pluginfilename);
    333. 

  333. 

  334. 				//plgVmpaymentPaypal
    335. 

  335. 				$pluginClassname = 'plg' . ucfirst ($group) . ucfirst ($element);
    336. 

  336. 

  337. 				//Let's get the global dispatcher
    338. 

  338. 				$dispatcher = JDispatcher::getInstance ();
    339. 

  339. 				$config = array('type'=> $group, 'name'=> $group, 'params'=> '');
    340. 

  340. 				$plugin = new $pluginClassname($dispatcher, $config);
    341. 

  341. 				;
    342. 

  342. 				// 				$updateString = $plugin->getVmPluginCreateTableSQL();
    343. 

  343. 				//if(function_exists($plugin->getTableSQLFields)){
    344. 

  344. 				$_psType = substr ($group, 2);
    345. 

  345. 

  346. 				$tablename = '#__virtuemart_' . $_psType . '_plg_' . $element;
    347. 

  347. 				$db = JFactory::getDBO ();
    348. 

  348. 				$prefix=$db->getPrefix();
    349. 

  349. 				$query = 'SHOW TABLES LIKE "' . str_replace ('#__', $prefix, $tablename) . '"';
    350. 

  350. 				$db->setQuery ($query);
    351. 

  351. 				$result = $db->loadResult ();
    352. 

  352. 				//$app -> enqueueMessage( get_class( $this ).'::  '.$query.' '.$result);
    353. 

  353. 				if ($result) {
    354. 

  354. 					$SQLfields = $plugin->getTableSQLFields ();
    355. 

  355. 					$loggablefields = $plugin->getTableSQLLoggablefields ();
    356. 

  356. 					$tablesFields = array_merge ($SQLfields, $loggablefields);
    357. 

  357. 					$update[$tablename] = array($tablesFields, array(), array());
    358. 

  358. vmdebug('install plugin',$update );
    359. 

  359. 					$app->enqueueMessage (get_class ($this) . ':: VirtueMart2 update ' . $tablename);
    360. 

  360. 

  361. 					if (!class_exists ('GenericTableUpdater')) {
    362. 

  362. 						require(JPATH_VM_ADMINISTRATOR . DS . 'helpers' . DS . 'tableupdater.php');
    363. 

  363. 					}
    364. 

  364. 					$updater = new GenericTableUpdater();
    365. 

  365. 

  366. 					$updater->updateMyVmTables ($update);
    367. 

  367. 				}
    368. 

  368. 				//}
    369. 

  369. 				// 				} else {
    370. 

  370. 

  371. 				// 					$app = JFactory::getApplication();
    372. 

  372. 				// 					$app -> enqueueMessage( get_class( $plugin ).':: VirtueMart2 function getTableSQLFields not found');
    373. 

  373. 

  374. 				// 				}
    375. 

  375. 

  376. 			} else {
    377. 

  377. 				$app = JFactory::getApplication ();
    378. 

  378. 				$app->enqueueMessage (get_class ($this) . ':: VirtueMart2 must be installed, or the tables cant be updated ' . $error);
    379. 

  379. 

  380. 			}
    381. 

  381. 

  382. 		}
    383. 

  383. 

  384. 		public function installModule ($title, $module, $ordering, $params) {
    385. 

  385. 

  386. 			$params = '';
    387. 

  387. 

  388. 			$table = JTable::getInstance ('module');
    389. 

  389. 

  390. 			$db = $table->getDBO ();
    391. 

  391. 			$q = 'SELECT id FROM `#__modules` WHERE `module` = "' . $module . '" ';
    392. 

  392. 			$db->setQuery ($q);
    393. 

  393. 			$id = $db->loadResult ();
    394. 

  394. 			$src = JPATH_ROOT . DS . 'modules' . DS . $module;
    395. 

  395. 

  396. 			if (!empty($id)) {
    397. 

  397. 				return;
    398. 

  398. 			}
    399. 

  399. 			$table->load ();
    400. 

  400. 			if (version_compare (JVERSION, '1.7.0', 'ge')) {
    401. 

  401. 				// Joomla! 1.7 code here
    402. 

  402. 				$position = 'position-4';
    403. 

  403. 				$access = 1;
    404. 

  404. 			} else {
    405. 

  405. 				if (version_compare (JVERSION, '1.6.0', 'ge')) {
    406. 

  406. 					// Joomla! 1.6 code here
    407. 

  407. 					$access = 1;
    408. 

  408. 				} else {
    409. 

  409. 					// Joomla! 1.5 code here
    410. 

  410. 					$position = 'left';
    411. 

  411. 					$access = 0;
    412. 

  412. 				}
    413. 

  413. 			}
    414. 

  414. 

  415. 			if (empty($table->title)) {
    416. 

  416. 				$table->title = $title;
    417. 

  417. 			}
    418. 

  418. 			if (empty($table->ordering)) {
    419. 

  419. 				$table->ordering = $ordering;
    420. 

  420. 			}
    421. 

  421. 			if (empty($table->published)) {
    422. 

  422. 				$table->published = 1;
    423. 

  423. 			}
    424. 

  424. 			if (empty($table->module)) {
    425. 

  425. 				$table->module = $module;
    426. 

  426. 			}
    427. 

  427. 			if (empty($table->params)) {
    428. 

  428. 				$table->params = $params;
    429. 

  429. 			}
    430. 

  430. 			if (empty($table->access)) {
    431. 

  431. 				$table->access = $access;
    432. 

  432. 			}
    433. 

  433. 			if (empty($table->position)) {
    434. 

  434. 				$table->position = $position;
    435. 

  435. 			}
    436. 

  436. 			if (empty($table->client_id)) {
    437. 

  437. 				$table->client_id = $client_id = 0;
    438. 

  438. 			}
    439. 

  439. 

  440. 			// 			$data['manifest_cache'] ='';
    441. 

  441. 			// 			if(!empty($id)){
    442. 

  442. 			// 				unset($data['manifest_cache']);
    443. 

  443. 			// 				$table->load($id);
    444. 

  444. 			// 				if(empty($table->manifest_cache)){
    445. 

  445. 			// 					if(version_compare(JVERSION,'1.6.0','ge')) {
    446. 

  446. 			// 						$data['manifest_cache'] = json_encode(JApplicationHelper::parseXMLInstallFile($src.DS.$module.'.xml'));
    447. 

  447. 			// 					}
    448. 

  448. 			// 				}
    449. 

  449. 			// 			}
    450. 

  450. 

  451. 			// 			if(empty($count)){
    452. 

  452. 			// 			if(!$table->bind($data)){
    453. 

  453. 			// 				$app = JFactory::getApplication();
    454. 

  454. 			// 				$app -> enqueueMessage('VMInstaller table->bind throws error for '.$title.' '.$module.' '.$params);
    455. 

  455. 			// 			}
    456. 

  456. 

  457. 			if (!$table->check ()) {
    458. 

  458. 				$app = JFactory::getApplication ();
    459. 

  459. 				$app->enqueueMessage ('VMInstaller table->check throws error for ' . $title . ' ' . $module . ' ' . $params);
    460. 

  460. 			}
    461. 

  461. 

  462. 			if (!$table->store ()) {
    463. 

  463. 				$app = JFactory::getApplication ();
    464. 

  464. 				$app->enqueueMessage ('VMInstaller table->store throws error for for ' . $title . ' ' . $module . ' ' . $params);
    465. 

  465. 			}
    466. 

  466. 

  467. 			$errors = $table->getErrors ();
    468. 

  468. 			foreach ($errors as $error) {
    469. 

  469. 				$app = JFactory::getApplication ();
    470. 

  470. 				$app->enqueueMessage (get_class ($this) . '::store ' . $error);
    471. 

  471. 			}
    472. 

  472. 			// 			}
    473. 

  473. 

  474. 			$lastUsedId = $table->id;
    475. 

  475. 

  476. 			$q = 'SELECT moduleid FROM `#__modules_menu` WHERE `moduleid` = "' . $lastUsedId . '" ';
    477. 

  477. 			$db->setQuery ($q);
    478. 

  478. 			$moduleid = $db->loadResult ();
    479. 

  479. 

  480. 			$action = '';
    481. 

  481. 			if (empty($moduleid)) {
    482. 

  482. 				$q = 'INSERT INTO `#__modules_menu` (`moduleid`, `menuid`) VALUES( "' . $lastUsedId . '" , "0");';
    483. 

  483. 			} else {
    484. 

  484. 				//$q = 'UPDATE `#__modules_menu` SET `menuid`= "0" WHERE `moduleid`= "'.$moduleid.'" ';
    485. 

  485. 			}
    486. 

  486. 			$db->setQuery ($q);
    487. 

  487. 			$db->query ();
    488. 

  488. 

  489. 			if (version_compare (JVERSION, '1.6.0', 'ge')) {
    490. 

  490. 

  491. 				$q = 'SELECT extension_id FROM `#__extensions` WHERE `element` = "' . $module . '" ';
    492. 

  492. 				$db->setQuery ($q);
    493. 

  493. 				$ext_id = $db->loadResult ();
    494. 

  494. 

  495. 				//				$manifestCache = str_replace('"', '\'', $data["manifest_cache"]);
    496. 

  496. 				$action = '';
    497. 

  497. 				if (empty($ext_id)) {
    498. 

  498. 					if (version_compare (JVERSION, '1.6.0', 'ge')) {
    499. 

  499. 						$manifest_cache = json_encode (JApplicationHelper::parseXMLInstallFile ($src . DS . $module . '.xml'));
    500. 

  500. 					}
    501. 

  501. 					$q = 'INSERT INTO `#__extensions` 	(`name`, `type`, `element`, `folder`, `client_id`, `enabled`, `access`, `protected`, `manifest_cache`, `params`, `ordering`) VALUES
    502. 

  502. 																	( "' . $module . '" , "module", "' . $module . '", "", "0", "1","' . $access . '", "0", "' . $db->getEscaped ($manifest_cache) . '", "' . $params . '","' . $ordering . '");';
    503. 

  503. 				} else {
    504. 

  504. 

  505. 					/*					$q = 'UPDATE `#__extensions` SET 	`name`= "'.$module.'",
    506. 

  506. 																						`type`= "module",
    507. 

  507. 																						`element`= "'.$module.'",
    508. 

  508. 																						`folder`= "",
    509. 

  509. 																						`client_id`= "'.$client_id.'",
    510. 

  510. 																						`enabled`= "1",
    511. 

  511. 																						`access`= "'.$access.'",
    512. 

  512. 																						`protected`= "0",
    513. 

  513. 																						`ordering`= "'.$ordering.'"
    514. 

    515. 

  515. 										WHERE `extension_id`= "'.$ext_id.'" ';*/
    516. 

  516. 				}
    517. 

  517. 				$db->setQuery ($q);
    518. 

  518. 				if (!$db->query ()) {
    519. 

  519. 					$app = JFactory::getApplication ();
    520. 

  520. 					$app->enqueueMessage (get_class ($this) . '::  ' . $db->getErrorMsg ());
    521. 

  521. 				}
    522. 

  522. 

  523. 			}
    524. 

  524. 		}
    525. 

  525. 

  526. 		public function VmModulesAlreadyInstalled () {
    527. 

  527. 

  528. 			// when the modules are already installed publish=-2
    529. 

  529. 			$table = JTable::getInstance ('module');
    530. 

  530. 			$db = $table->getDBO ();
    531. 

  531. 			$q = 'SELECT count(*) FROM `#__modules` WHERE `module` LIKE "mod_virtuemart_%"';
    532. 

  532. 			$db->setQuery ($q);
    533. 

  533. 			$count = $db->loadResult ();
    534. 

  534. 			return $count;
    535. 

  535. 		}
    536. 

  536. 

  537. 		/**
    538. 

  538. 		 * @author Max Milbers
    539. 

  539. 		 * @param string $tablename
    540. 

  540. 		 * @param string $fields
    541. 

  541. 		 * @param string $command
    542. 

  542. 		 */
    543. 

  543. 		private function alterTable ($tablename, $fields, $command = 'CHANGE') {
    544. 

  544. 

  545. 			if (empty($this->db)) {
    546. 

  546. 				$this->db = JFactory::getDBO ();
    547. 

  547. 			}
    548. 

  548. 

  549. 			$query = 'SHOW COLUMNS FROM `' . $tablename . '` ';
    550. 

  550. 			$this->db->setQuery ($query);
    551. 

  551. 			$columns = $this->db->loadResultArray (0);
    552. 

  552. 

  553. 			foreach ($fields as $fieldname => $alterCommand) {
    554. 

  554. 				if (in_array ($fieldname, $columns)) {
    555. 

  555. 					$query = 'ALTER TABLE `' . $tablename . '` ' . $command . ' COLUMN `' . $fieldname . '` ' . $alterCommand;
    556. 

  556. 

  557. 					$this->db->setQuery ($query);
    558. 

  558. 					$this->db->query ();
    559. 

  559. 				}
    560. 

  560. 			}
    561. 

  561. 

  562. 		}
    563. 

  563. 

  564. 		/**
    565. 

  565. 		 *
    566. 

  566. 		 * @author Max Milbers
    567. 

  567. 		 * @param string $table
    568. 

  568. 		 * @param string $field
    569. 

  569. 		 * @param string $fieldType
    570. 

  570. 		 * @return boolean This gives true back, WHEN it altered the table, you may use this information to decide for extra post actions
    571. 

  571. 		 */
    572. 

  572. 		private function checkAddFieldToTable ($table, $field, $fieldType) {
    573. 

  573. 

  574. 			$query = 'SHOW COLUMNS FROM `' . $table . '` ';
    575. 

  575. 			$this->db->setQuery ($query);
    576. 

  576. 			$columns = $this->db->loadResultArray (0);
    577. 

  577. 

  578. 			if (!in_array ($field, $columns)) {
    579. 

  579. 

  580. 				$query = 'ALTER TABLE `' . $table . '` ADD ' . $field . ' ' . $fieldType;
    581. 

  581. 				$this->db->setQuery ($query);
    582. 

  582. 				if (!$this->db->query ()) {
    583. 

  583. 					$app = JFactory::getApplication ();
    584. 

  584. 					$app->enqueueMessage ('Install checkAddFieldToTable ' . $this->db->getErrorMsg ());
    585. 

  585. 					return FALSE;
    586. 

  586. 				} else {
    587. 

  587. 					return TRUE;
    588. 

  588. 				}
    589. 

  589. 			}
    590. 

  590. 			return FALSE;
    591. 

  591. 		}
    592. 

  592. 

  593. 		private function updateShipperToShipment () {
    594. 

  594. 

  595. 			if (empty($this->db)) {
    596. 

  596. 				$this->db = JFactory::getDBO ();
    597. 

  597. 			}
    598. 

  598. 			if (version_compare (JVERSION, '1.6.0', 'ge')) {
    599. 

  599. 				// Joomla! 1.6 code here
    600. 

  600. 				$table = JTable::getInstance ('extension');
    601. 

  601. 				$tableName = '#__extensions';
    602. 

  602. 				$idfield = 'extension_id';
    603. 

  603. 			} else {
    604. 

  604. 

  605. 				// Joomla! 1.5 code here
    606. 

  606. 				$table = JTable::getInstance ('plugin');
    607. 

  607. 				$tableName = '#__plugins';
    608. 

  608. 				$idfield = 'id';
    609. 

  609. 			}
    610. 

  610. 

  611. 			$q = 'SELECT ' . $idfield . ' FROM ' . $tableName . ' WHERE `folder` = "vmshipper" ';
    612. 

  612. 			$this->db->setQuery ($q);
    613. 

  613. 			$result = $this->db->loadResult ();
    614. 

  614. 			if ($result) {
    615. 

  615. 				$q = 'UPDATE `' . $tableName . '` SET `folder`="vmshipment" WHERE `extension_id`= ' . $result;
    616. 

  616. 				$this->db->setQuery ($q);
    617. 

  617. 				$this->db->query ();
    618. 

  618. 			}
    619. 

  619. 		}
    620. 

  620. 

  621. 		/**
    622. 

  622. 		 * copy all $src to $dst folder and remove it
    623. 

  623. 		 *
    624. 

  624. 		 * @author Max Milbers
    625. 

  625. 		 * @param String $src path
    626. 

  626. 		 * @param String $dst path
    627. 

  627. 		 * @param String $type modules, plugins, languageBE, languageFE
    628. 

  628. 		 */
    629. 

  629. 		private function recurse_copy ($src, $dst) {
    630. 

  630. 

  631. 			$dir = opendir ($src);
    632. 

  632. 			$this->createIndexFolder ($dst);
    633. 

  633. 

  634. 			if (is_resource ($dir)) {
    635. 

  635. 				while (FALSE !== ($file = readdir ($dir))) {
    636. 

  636. 					if (($file != '.') && ($file != '..')) {
    637. 

  637. 						if (is_dir ($src . DS . $file)) {
    638. 

  638. 							$this->recurse_copy ($src . DS . $file, $dst . DS . $file);
    639. 

  639. 						} else {
    640. 

  640. 							if (JFile::exists ($dst . DS . $file)) {
    641. 

  641. 								if (!JFile::delete ($dst . DS . $file)) {
    642. 

  642. 									$app = JFactory::getApplication ();
    643. 

  643. 									$app->enqueueMessage ('Couldnt delete ' . $dst . DS . $file);
    644. 

  644. 								}
    645. 

  645. 							}
    646. 

  646. 							if (!JFile::move ($src . DS . $file, $dst . DS . $file)) {
    647. 

  647. 								$app = JFactory::getApplication ();
    648. 

  648. 								$app->enqueueMessage ('Couldnt move ' . $src . DS . $file . ' to ' . $dst . DS . $file);
    649. 

  649. 							}
    650. 

  650. 						}
    651. 

  651. 					}
    652. 

  652. 				}
    653. 

  653. 				closedir ($dir);
    654. 

  654. 				if (is_dir ($src)) {
    655. 

  655. 					JFolder::delete ($src);
    656. 

  656. 				}
    657. 

  657. 			} else {
    658. 

  658. 				$app = JFactory::getApplication ();
    659. 

  659. 				$app->enqueueMessage ('Couldnt read dir ' . $dir . ' source ' . $src);
    660. 

  660. 			}
    661. 

  661. 

  662. 		}
    663. 

  663. 

  664. 

  665. 		public function uninstall () {
    666. 

  666. 

  667. 			return TRUE;
    668. 

  668. 		}
    669. 

  669. 

  670. 		/**
    671. 

  671. 		 * creates a folder with empty html file
    672. 

  672. 		 *
    673. 

  673. 		 * @author Max Milbers
    674. 

  674. 		 *
    675. 

  675. 		 */
    676. 

  676. 		public function createIndexFolder ($path) {
    677. 

  677. 

  678. 			if (JFolder::create ($path)) {
    679. 

  679. 				if (!JFile::exists ($path . DS . 'index.html')) {
    680. 

  680. 					JFile::copy (JPATH_ROOT . DS . 'components' . DS . 'index.html', $path . DS . 'index.html');
    681. 

  681. 				}
    682. 

  682. 				return TRUE;
    683. 

  683. 			}
    684. 

  684. 			return FALSE;
    685. 

  685. 		}
    686. 

  686. 

  687. 	}
    688. 

  688. 

  689. 

  690. 	// PLZ look in #vminstall.php# to add your plugin and module
    691. 

  691. 	function com_install () {
    692. 

  692. 

  693. 		if (!version_compare (JVERSION, '1.6.0', 'ge')) {
    694. 

  694. 			$vmInstall = new com_virtuemart_allinoneInstallerScript();
    695. 

  695. 			$vmInstall->vmInstall ();
    696. 

  696. 		}
    697. 

  697. 		return TRUE;
    698. 

  698. 	}
    699. 

  699. 

  700. 	function com_uninstall () {
    701. 

  701. 

  702. 		return TRUE;
    703. 

  703. 	}
    704. 

  704. 

  705. } //if defined
    706. 

  706. // pure php no tag
    707. 

  707.