Arts Furni Furniture v26 SQL 2010 and V36

Results 1 to 11 of 11
  1. #1

    idea Arts Furni Furniture v26 SQL 2010 and V36

    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










  2. #2

    Re: Arts Furni Furniture v26 SQL 2010 and V36

    First post , I like it !
    5/5
    Last edited by superineshootin; 18-03-10 at 06:59 PM.

  3. #3

    Re: Arts Furni Furniture v26 SQL 2010 and V36

    Quote Originally Posted by superineshootin View Post
    First post , I like it !
    5/5
    Okay I'm glad you enjoyed my work in these furnis

  4. #4
    yerro Adde is offline
    Grand MasterRank
    Feb 2010 Join Date
    none ur bizzLocation
    2,731Posts

    Re: Arts Furni Furniture v26 SQL 2010 and V36

    Nice!

    But i hate those furnitures, They are so fcking ugly ^^

  5. #5
    Elite Member habrox is offline
    Member +Rank
    Dec 2007 Join Date
    NorwayLocation
    113Posts

    Re: Arts Furni Furniture v26 SQL 2010 and V36

    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.

  6. #6

    Re: Arts Furni Furniture v26 SQL 2010 and V36

    Quote Originally Posted by habrox View Post
    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?

  7. #7
    Elite Member habrox is offline
    Member +Rank
    Dec 2007 Join Date
    NorwayLocation
    113Posts

    Re: Arts Furni Furniture v26 SQL 2010 and V36

    Quote Originally Posted by alex2717 View Post
    What is that new garden?
    You can read about the new easter/garden furnitures HERE

  8. #8
    Newbie mickey1 is offline
    MemberRank
    Aug 2009 Join Date
    1Posts

    Re: Arts Furni Furniture v26 SQL 2010 and V36

    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

  9. #9
    Newbie ICHOTEL is offline
    MemberRank
    May 2010 Join Date
    17Posts

    Re: Arts Furni Furniture v26 SQL 2010 and V36

    CCT Files??

  10. #10
    Sorcerer Supreme Habblet is offline
    Member +Rank
    Jul 2008 Join Date
    The NetherlandsLocation
    324Posts

    Re: Arts Furni Furniture v26 SQL 2010 and V36

    Yeah, were are the DCR files, and Awsome release.

  11. #11
    Sorcerer Supreme GrandCoder is offline
    Member +Rank
    Jul 2010 Join Date
    BramptonLocation
    413Posts

    Re: Arts Furni Furniture v26 SQL 2010 and V36

    Wheres the CCT Link?



Advertisement