Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Arts Furni Furniture v26 SQL 2010 and V36

Status
Not open for further replies.
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



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




alex2717 - Arts Furni Furniture v26 SQL 2010 and V36 - RaGEZONE Forums




alex2717 - Arts Furni Furniture v26 SQL 2010 and V36 - RaGEZONE Forums
 
Newbie Spellweaver
Joined
Dec 19, 2007
Messages
79
Reaction score
7
I have released this before, but without the v36 sql. I should get some credits. Btw i will release the new garden/easter furnitures soon.
 
Newbie Spellweaver
Joined
Apr 25, 2009
Messages
26
Reaction score
5
I have released this before, but without the v36 sql. I should get some credits. Btw i will release the new garden/easter furnitures soon.


What is that new garden?
 
Initiate Mage
Joined
Aug 24, 2009
Messages
1
Reaction score
0
Me sale este problema en dynamic_items " #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '( 's', 'Black Chair', 'large and comfortable','', 'org_chrblk', 23,888, '2 ', '1' at line 3 " :S
 
Experienced Elementalist
Joined
Jul 14, 2008
Messages
203
Reaction score
20
Yeah, were are the DCR files, and Awsome release.
 
Status
Not open for further replies.
Back
Top