Modules system » History » Version 5
Valérie Isaksen, 09/22/2011 12:48 PM
| 1 | 1 | Max Milbers | h1. Modules system |
|---|---|---|---|
| 2 | |||
| 3 | Use this sql (assuming you use jos_) to add the modules of the svn to the joomla installation |
||
| 4 | |||
| 5 | For j1.5: |
||
| 6 | |||
| 7 | 2 | Christopher Roussel | <pre>INSERT INTO `jos_modules` (`title`, `content`, `ordering`, `position`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`, `control`) |
| 8 | 1 | Max Milbers | VALUES ( 'currencies selector' , '' , 5, 'left', 1, 'mod_virtuemart_currencies', 0, 0, 1, 'text_before=\nproduct_currency=\ncache=1\nmoduleclass_sfx=\nclass_sfx=\n\n', 0, 0, '');# 1 Zeile(n) betroffen. |
| 9 | |||
| 10 | INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES( LAST_INSERT_ID() , '0');# 1 Zeile(n) betroffen. |
||
| 11 | |||
| 12 | |||
| 13 | INSERT INTO `jos_modules` (`title`, `content`, `ordering`, `position`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`, `control`) |
||
| 14 | VALUES ( 'Featured', '', 3, 'left', 1, 'mod_virtuemart_product', 0, 0, 1, 'product_group=featured\nmax_items=2\nproducts_per_row=\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\n', 0, 0, '');# 1 Zeile(n) betroffen. |
||
| 15 | |||
| 16 | INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES( LAST_INSERT_ID() , '0');# 1 Zeile(n) betroffen. |
||
| 17 | |||
| 18 | |||
| 19 | INSERT INTO `jos_modules` (`title`, `content`, `ordering`, `position`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`, `control`) |
||
| 20 | 4 | Valérie Isaksen | VALUES ( 'VirtueMart Category', '', 0, 'left', 1, 'mod_virtuemart_category', 0, 0, 1, '', 0, 0, ''); |
| 21 | 1 | Max Milbers | |
| 22 | INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES( LAST_INSERT_ID() , '0'); |
||
| 23 | |||
| 24 | |||
| 25 | INSERT INTO `jos_modules` (`title`, `content`, `ordering`, `position`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`, `control`) |
||
| 26 | 4 | Valérie Isaksen | VALUES ( 'Best Sales', '', 0, 'left', 1, 'mod_virtuemart_product', 0, 0, 1, 'product_group=topten\nmax_items=3\nproducts_per_row=\ndisplay_style=list\nshow_price=1\nshow_addtocart=1\nheaderText=\nfooterText=\nfilter_category=0\ncategory_id=1\ncache=0\nmoduleclass_sfx=\nclass_sfx=\n\n', 0, 0, ''); |
| 27 | |||
| 28 | INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES( LAST_INSERT_ID() , '0'); |
||
| 29 | |||
| 30 | |||
| 31 | INSERT INTO `jos_modules` (`title`, `content`, `ordering`, `position`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`, `control`) |
||
| 32 | 1 | Max Milbers | VALUES ( 'Search in Shop', '', 4, 'left', 1, 'mod_virtuemart_search', 0, 0, 1, 'width=20\ntext=\nbutton=\nbutton_pos=right\nimagebutton=\nbutton_text=\nmoduleclass_sfx=\ncache=1\ncache_time=900\n\n', 0, 0, '');# 1 Zeile(n) betroffen. |
| 33 | |||
| 34 | INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES( LAST_INSERT_ID() , '0'); |
||
| 35 | |||
| 36 | |||
| 37 | INSERT INTO `jos_modules` (`title`, `content`, `ordering`, `position`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`, `control`) |
||
| 38 | 5 | Valérie Isaksen | VALUES ( 'Manufacturer', '', 4, 'left', 1, 'mod_virtuemart_manufacturer', 0, 0, 1, '{"show":"all","display_style":"list","manufacturers_per_row":"","headerText":"","footerText":""}', 0, 0, ''); |
| 39 | 1 | Max Milbers | |
| 40 | INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES( LAST_INSERT_ID() , '0'); |
||
| 41 | |||
| 42 | |||
| 43 | INSERT INTO `jos_modules` (`title`, `content`, `ordering`, `position`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`, `control`) |
||
| 44 | VALUES ( 'shopping cart', '', 4, 'left', 1, 'mod_virtuemart_cart', 0, 0, 1, 'moduleclass_sfx=\nshow_price=1\nshow_product_list=1\n\n', 0, 0, '');# 1 Zeile(n) betroffen. |
||
| 45 | 2 | Christopher Roussel | |
| 46 | 1 | Max Milbers | INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES( LAST_INSERT_ID() , '0');</pre> |
| 47 | |||
| 48 | 4 | Valérie Isaksen | and for j1.7 |
| 49 | 1 | Max Milbers | |
| 50 | 2 | Christopher Roussel | <pre>INSERT INTO `jos_extensions` (`extension_id`, `name`, `type`, `element`, `folder`, `client_id`, `enabled`, `access`, `protected`, `manifest_cache`, `params`, `custom_data`, `system_data`, `checked_out`, `checked_out_time`, `ordering`, `state`) |
| 51 | 1 | Max Milbers | VALUES (NULL, 'mod_virtuemart_currencies', 'module', 'mod_virtuemart_currencies', '', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', '0', '0'), |
| 52 | (NULL, 'mod_virtuemart_product', 'module', 'mod_virtuemart_product', '', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', '0', '0'), |
||
| 53 | 4 | Valérie Isaksen | (NULL, 'mod_virtuemart_category', 'module', 'mod_virtuemart_category', '', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', '0', '0'), |
| 54 | 1 | Max Milbers | (NULL, 'mod_virtuemart_search', 'module', 'mod_virtuemart_search', '', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', '0', '0'), |
| 55 | (NULL, 'mod_virtuemart_manufacturers', 'module', 'mod_virtuemart_manufacturers', '', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', '0', '0'); |
||
| 56 | |||
| 57 | INSERT INTO `jos_modules` (`id`, `title`, `note`,`content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `publish_up`, `publish_down`, `published`, `module`, `access`, `showtitle`, `params`, `client_id`, `language`) |
||
| 58 | VALUES (NULL, 'currencies selector' , '', '' , 5, 'left', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 'mod_virtuemart_currencies', 0, 1, 'text_before=\nproduct_currency=\ncache=1\nmoduleclass_sfx=\nclass_sfx=\n\n', 0, '*'); |
||
| 59 | INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES( LAST_INSERT_ID() , '0'); |
||
| 60 | |||
| 61 | INSERT INTO `jos_modules` (`id`, `title`, `note`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `publish_up`, `publish_down`, `published`, `module`, `access`, `showtitle`, `params`, `client_id`, `language`) |
||
| 62 | VALUES (NULL, 'Featured', '', '', 3, 'left', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 'mod_virtuemart_product', 0, 1, 'product_group=featured\nmax_items=2\nproducts_per_row=\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\n', 0, '*'); |
||
| 63 | INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES( LAST_INSERT_ID() , '0'); |
||
| 64 | |||
| 65 | INSERT INTO `jos_modules` (`id`, `title`, `note`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `publish_up`, `publish_down`, `published`, `module`, `access`, `showtitle`, `params`, `client_id`, `language`) |
||
| 66 | VALUES (NULL, 'Best Sales', '', '', 0, 'left', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 'mod_virtuemart_product', 0, 1, 'product_group=topten\nmax_items=3\nproducts_per_row=\ndisplay_style=list\nshow_price=1\nshow_addtocart=1\nheaderText=\nfooterText=\nfilter_category=0\ncategory_id=1\ncache=0\nmoduleclass_sfx=\nclass_sfx=\n\n', 0, '*'); |
||
| 67 | INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES( LAST_INSERT_ID() , '0'); |
||
| 68 | 4 | Valérie Isaksen | |
| 69 | |||
| 70 | INSERT INTO `jos_modules` (`id`, `title`, `note`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `publish_up`, `publish_down`, `published`, `module`, `access`, `showtitle`, `params`, `client_id`, `language`) |
||
| 71 | VALUES (NULL, 'VirtueMart Category', '', '', 0, 'left', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 'mod_virtuemart_product', 0, 1, '', 0, '*'); |
||
| 72 | INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES( LAST_INSERT_ID() , '0'); |
||
| 73 | |||
| 74 | 1 | Max Milbers | |
| 75 | INSERT INTO `jos_modules` (`id`, `title`, `note`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `publish_up`, `publish_down`, `published`, `module`, `access`, `showtitle`, `params`, `client_id`, `language`) |
||
| 76 | VALUES (NULL, 'Search in Shop', '', '', 4, 'left', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 'mod_virtuemart_search', 0, 1, 'width=20\ntext=\nbutton=\nbutton_pos=right\nimagebutton=\nbutton_text=\nmoduleclass_sfx=\ncache=1\ncache_time=900\n\n', 0, '*'); |
||
| 77 | INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES( LAST_INSERT_ID() , '0'); |
||
| 78 | |||
| 79 | INSERT INTO `jos_modules` (`id`, `title`, `note`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `publish_up`, `publish_down`, `published`, `module`, `access`, `showtitle`, `params`, `client_id`, `language`) |
||
| 80 | 3 | Valérie Isaksen | VALUES (NULL, 'Manufacturers', '', '', 4, 'left', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 'mod_virtuemart_manufacturer', 0, 1, 'show=all\ndisplay_style=div\nmanufacturers_per_row=\nheaderText=\nfooterText=\ncache=0\nmoduleclass_sfx=\nclass_sfx=', 0, '*'); |
| 81 | 1 | Max Milbers | INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES( LAST_INSERT_ID() , '0'); |
| 82 | |||
| 83 | INSERT INTO `jos_modules` (`id`, `title`, `note`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `publish_up`, `publish_down`, `published`, `module`, `access`, `showtitle`, `params`, `client_id`, `language`) |
||
| 84 | VALUES (NULL, 'shopping cart', '', '', 4, 'left', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 'mod_virtuemart_cart', 0, 1, 'moduleclass_sfx=\nshow_price=1\nshow_product_list=1\n\n', 0, '*'); |
||
| 85 | 2 | Christopher Roussel | INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES( LAST_INSERT_ID() , '0');</pre> |