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> |