Project

General

Profile

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>