Newbie Spellweaver
- Joined
- Apr 25, 2009
- Messages
- 26
- Reaction score
- 5
Furni Furniture Arts 2010 by alex27 are made to SQL V26 and V36
The V26 should only insert in your DB catalogue_pages says the V26 and V26 which says catalogues_items
The V36 should insert dynamic_items, furniture_data, catalogues_items says V36, V36 and catalogues_pages says you have to add the options DCRS own file Furnidata.txt
1.- Insert the SQL: dynamic_items
2.- Insert the SQL: furniture_data
3.- Insert the SQL: catalogue_items
V36
V26
4.- Insert the SQL: catalogue_pages
NOTE: If you use my prehosteadas DCRS will have the catalog of these Furni in Spanish in some of the pictures when they open the catalog, if you use other DCRS I suggest you use the other code catalogue_pagues DCRS are saying that it goes well for the images in their catalog.
Which Limited Edition pictures where it says if you look at the end of this Image take from my hotel and set as this in Spanish.
With my V36 DCRS prehosteadas
V36 DCRS Any Other
With my V26 DCRS prehosteadas
V26 DCRS Any Other
Furnidata.txt
NOTE: If you do not have DCRS own but use pre-hosted DCRS comunicate with the owner if you can contact him and tell him to paste the following code on your file furnidata.txt, so that you can see your Furni if you appear non-icon
If you have your own DCRS either locally or on a host must add at end of file furnidata.txt the following code.
If you look furnidata.txt end of file terminates a bracket closing "]", the brackets and add it to the end of this code.
Images
The V26 should only insert in your DB catalogue_pages says the V26 and V26 which says catalogues_items
The V36 should insert dynamic_items, furniture_data, catalogues_items says V36, V36 and catalogues_pages says you have to add the options DCRS own file Furnidata.txt
1.- Insert the SQL: dynamic_items
Code:
INSERT INTO `dynamic_items` (`type`, `name`, `description`, `extra_description`, `name_cct`, `revision`, `typeid`, `length`, `width`, `colour`) VALUES
( 's', 'Chair Pink', 'small, soft','', 'org_chairpnk', 23,888, '2 ', '1', '1 ', '0, 0,0')
( 's', 'Black Chair', 'large and comfortable','', 'org_chrblk', 23,888, '2 ', '1', '1 ', '0, 0,0'),
( 's', 'Chair Pink', 'large and comfortable','', 'org_chrpnk', 23,888, '2 ', '1', '1 ', '0, 0,0'),
( 's', 'Black Lamp', 'Light up your room with a fresh light','', 'org_lampblk', 23,888, '1 ', '1', '1 ', '0, 0,0'),
( 's', 'Pink Chandelier', 'Light up your room with a fresh light','', 'org_lamppnk', 23,888, '1 ', '1', '1 ', '0, 0,0'),
( 's', 'Table Rosada', 'Elegant glass table with its own light','', 'org_table', 23,888, '0 ', '2', '2 ', '0, 0,0'),
( 's', 'Black Mesa', 'Small and thin','', 'org_tblblk', 23,888, '0 ', '1', '3 ', '0, 0,0'),
( 's', 'Table Rosada', 'Elegant glass table with its own light','', 'org_table', 23,888, '0 ', '2', '2 ', '0, 0,0'),
( 's',' Black Chair ',' small, soft ','',' org_chairblk ', 16,268, '2', '1 ', '1', '0, 0,0');
2.- Insert the SQL: furniture_data
Code:
INSERT INTO `furniture_data` (`id`, `sprite`) VALUES
('4274', 'org_chairpnk'),
('4275', 'org_chrblk'),
('4276', 'org_chrpnk'),
('4277', 'org_lampblk'),
('4278', 'org_lamppnk'),
('4279', 'org_table'),
('4280', 'org_tblblk'),
('4281', 'org_tblpnk'),
('4282', 'org_chairblk');
3.- Insert the SQL: catalogue_items
V36
Code:
INSERT INTO `catalogue_items` (`tid`, `catalogue_cost_credits`, `catalogue_cost_pixels`, `typeid`, `top`, `name_cct`, `status_max`, `rights_required`, `next_to_required`, `drink_ids`, `catalogue_id_page`, `door`, `tradeable`, `recycleable`, `catalogue_id_index`) VALUES
(77079, 20, 0, 2, 1.20, 'org_chairpnk', 1, 1, 0, '', 31, '0', '1', '1', 77079),
(77080, 20, 0, 2, 1.20, 'org_chrblk', 1, 1, 0, '', 31, '0', '1', '1', 77080),
(77081, 20, 0, 2, 1.20, 'org_chrpnk', 1, 1, 0, '', 31, '0', '1', '1', 77081),
(77082, 20, 0, 1, 0.00, 'org_lampblk', 1, 1, 0, '', 31, '0', '1', '1', 77082),
(77083, 20, 0, 1, 0.00, 'org_lamppnk', 1, 1, 0, '', 31, '0', '1', '1', 77083),
(77084, 20, 0, 1, 0.00, 'org_table', 1, 1, 0, '', 31, '0', '1', '1', 77084),
(77085, 20, 0, 1, 0.00, 'org_tblblk', 1, 1, 0, '', 31, '0', '1', '1', 77085),
(77086, 20, 0, 1, 0.00, 'org_tblpnk', 1, 1, 0, '', 31, '0', '1', '1', 77086),
(77087, 20, 0, 2, 1.20, 'org_chairblk', 1, 1, 0, '', 31, '0', '1', '1', 77087);
V26
Code:
INSERT INTO `catalogue_items` ( `tid`, `catalogue_name`, `catalogue_description`, `catalogue_cost`, `typeid`, `length`, `width`, `top`, `name_cct`, `color`, ` catalogue_id_page `,` door `,` tradeable `,` recycleable `,` catalogue_id_index `) VALUES
(77079, 'Pink Chair', 'small, soft', 20, 2, 1, 1, 1.20, 'org_chairpnk', '0, 0,0 ', 31, '0', '1 ', '1', 77079),
(77080, 'Black Chair', 'large and comfortable', 20, 2, 1, 1, 1.20, 'org_chrblk', '0, 0,0 ', 31, '0', '1 ', '1', 77080),
(77081, 'Pink Chair', 'large and comfortable', 20, 2, 1, 1, 1.20, 'org_chrpnk', '0, 0,0 ', 31, '0', '1 ', '1', 77081),
(77082, 'Black Lamp', 'Light up your room with a fresh light', 20, 1, 1, 1, 0.00, 'org_lampblk', '0, 0,0 ', 31, '0', '1 ', '1 ', 77082),
(77083, 'Pink Chandelier', 'Light up your room with a fresh light', 20, 1, 1, 1, 0.00, 'org_lamppnk', '0, 0,0 ', 31, '0', '1 ', '1 ', 77083),
(77084, 'Table Rosada', 'Elegant glass table with its own light', 20, 1, 2, 2, 0.00, 'org_table', '0, 0,0 ', 31, '0', '1 ', '1 ', 77084),
(77085, 'black table', 'Small and thin', 20, 1, 1, 1, 0.00, 'org_tblblk', '0, 0,0 ', 31, '0', '1 ', '1', 77085),
(77086, 'Table Rosada', 'Small and thin', 20, 1, 1, 1, 0.00, 'org_tblpnk', '0, 0,0 ', 31, '0', '1 ', '1', 77086),
(77087, 'Black Chair', 'small, soft', 20, 2, 1, 1, 1.20, 'org_chairblk', '0, 0,0 ', 31, '0', '1 ', '1', 77087);
4.- Insert the SQL: catalogue_pages
NOTE: If you use my prehosteadas DCRS will have the catalog of these Furni in Spanish in some of the pictures when they open the catalog, if you use other DCRS I suggest you use the other code catalogue_pagues DCRS are saying that it goes well for the images in their catalog.
Which Limited Edition pictures where it says if you look at the end of this Image take from my hotel and set as this in Spanish.
With my V36 DCRS prehosteadas
Code:
INSERT INTO `catalogue_pages` (`indexid`, `minrank`, `indexname`, `displayname`, `style_layout`, `style_icon`, `style_colour`, `img_header`, `img_side`, `label_description`, `label_misc`, `label_moredetails`, `opt_bodyreplace`, `page_brother`, `incategory`, `header_else`, `content_else`) VALUES
(31, 2, 'Art Furniture', 'Art Furniture', 'default_3x3', 2, 0, 'catalog_spe_headline1_es', 'catalog_limited_teaser_es', 'The New Art Furniture 2010 and are here Limited Time only!', 'Furniture Art 2010!', 'Click on the item you want to view more information.', NULL, NULL, 1, '', NULL);
V36 DCRS Any Other
Code:
INSERT INTO `catalogue_pages` (`indexid`, `minrank`, `indexname`, `displayname`, `style_layout`, `style_icon`, `style_colour`, `img_header`, `img_side`, `label_description`, `label_misc`, `label_moredetails`, `opt_bodyreplace`, `page_brother`, `incategory`, `header_else`, `content_else`) VALUES
(31, 2, 'Art Furniture', 'Art Furniture', 'default_3x3', 2, 0, 'catalog_limited_headline1', 'catalog_limited_teaser1', 'The New Art Furniture 2010 and are here Limited Time only!', 'Furniture Art 2010!', 'Click on the item you want to view more information.', NULL, NULL, 1, '', NULL);
With my V26 DCRS prehosteadas
Code:
INSERT INTO `catalogue_pages` (`indexid`, `minrank`, `indexname`, `displayname`, `style_layout`, `img_header`, `img_side`, `label_description`, `label_misc`, `label_moredetails`, `opt_bodyreplace`) VALUES
(31, 2, 'Art Furniture', 'Art Furniture', 'ctlg_layout2', 'catalog_spe_headline1_es', 'catalog_limited_teaser_es', 'The New Art Furniture 2010 and are here Limited Time only!', ' ', '', NULL);
V26 DCRS Any Other
Code:
INSERT INTO `catalogue_pages` (`indexid`, `minrank`, `indexname`, `displayname`, `style_layout`, `img_header`, `img_side`, `label_description`, `label_misc`, `label_moredetails`, `opt_bodyreplace`) VALUES
(31, 2, 'Art Furniture', 'Art Furniture', 'ctlg_layout2', 'catalog_limited_headline1', 'catalog_limited_teaser1', 'The New Art Furniture 2010 and are here Limited Time only!', ' ', '', NULL);
Furnidata.txt
NOTE: If you do not have DCRS own but use pre-hosted DCRS comunicate with the owner if you can contact him and tell him to paste the following code on your file furnidata.txt, so that you can see your Furni if you appear non-icon
If you have your own DCRS either locally or on a host must add at end of file furnidata.txt the following code.
If you look furnidata.txt end of file terminates a bracket closing "]", the brackets and add it to the end of this code.
Code:
["s","77079","org_chairpnk","23888","0","1","1","","Pink Chair","small and soft",""],["s","77080","org_chrblk","23888","0","1","1","","Black Chair","large and commodious",""],["s","77081","org_chrpnk","23888","0","1","1","","Pink Chair","large and commodious",""],["s","77082","org_lampblk","23888","0","1","1","","Lamp Black","Light up your room with a light fresh",""],["s","77083","org_lamppnk","23888","0","1","1","","Lamp Pink","Light up your room with a light fresh",""],["s","77084","org_table","23888","0","2","2","","Table Pink","Elegant glass table with its own light",""],["s","77085","org_tblblk","23888","0","1","1","","Talbe Blank","Small and thin",""],["s","77086","org_tblpnk","23888","0","1","1","","Table Pink","Small and thin fine",""],["s","77087","org_chairblk","16268","2","1","1","","Black Chair","small and soft",""]]
Images