[SWF + SQL] Picknick - Public Furniture

Results 1 to 7 of 7
  1. #1
    1 + 3 + 3 = 7 EvilCoder is offline
    MemberRank
    Jul 2009 Join Date
    /home/mvdworpLocation
    334Posts

    [SWF + SQL] Picknick - Public Furniture


    Hello RaGEZONE!

    Today i'm going to release the public swf items of the picknick area. I hope you all will enjoy this.. I did my best on it to manually type the SQL's. These furniture SQL's are created for the Butterfly Emulator (OR THE bcstorm edit).

    -- FOR THE DUMBASSES THAT POSTED --
    ;; by saying (Butterfly Emulator (bcSTorm edit) i MEANT THAT THESE SQLS ARE MENT FOR THE BCSTORM EDIT OF BUTTERFLY. Don't be a prick and start anoying me with "IT AINT A BUTTERFLY EDIT, BUT BCSTORM IS AN EDIT OF BUTTERFLY)... I KNOW THAT.

    ;; Some of you guys make guys like me (Releasers) LEAVE.. Because of these prick actions. Shutup and continue your flame/annoyance in another damn thread. *YES RAGE*

    ;; Release stuff yourself... And let me FLAME/INSULT you :)...

    Furnidata part;
    Code:
    ["s","4243","pcnc_wood","45508","0","1","1","","pcnc_wood name","pcnc_wood desc","","-1","-1","false","-1","-1","false","","1"],
    ["s","4244","pcnc_door","45508","0","2","1","","pcnc_door name","pcnc_door desc","","-1","-1","false","-1","-1","false","","1"],
    ["s","4245","pcnc_fountain","45508","0","4","4","","pcnc_fountain name","pcnc_fountain desc","","-1","-1","false","-1","-1","false","","1"],
    ["s","4246","pcnc_gazebohack","45508","0","1","1","","pcnc_gazebohack name","pcnc_gazebohack desc","","-1","-1","false","-1","-1","false","","1"],
    ["s","4247","pcnc_wtable","45508","0","3","1","","pcnc_wtable name","pcnc_wtable desc","","-1","-1","false","-1","-1","false","","1"],
    ["s","4248","pcnc_tilestone","45508","0","1","1","","pcnc_tilestone name","pcnc_tilestone desc","","-1","-1","false","-1","-1","false","","1"],
    ["s","4249","pcnc_carp","45508","0","1","1","","pcnc_carp name","pcnc_carp desc","","-1","-1","false","-1","-1","false","","1"],
    ["s","4250","pcnc_bbq","45508","0","2","3","","pcnc_bbq name","pcnc_bbq desc","","-1","-1","false","-1","-1","false","","1"],
    ["s","4251","pcnc_gazebo","45508","0","5","5","","pcnc_gazebo name","pcnc_gazebo desc","","-1","-1","false","-1","-1","false","","1"],
    ["s","4252","pcnc_swing","45508","0","2","1","","pcnc_swing name","pcnc_swing desc","","-1","-1","false","-1","-1","false","","1"],
    ["s","4253","pcnc_wbench","45508","0","3","1","","pcnc_wbench name","pcnc_wbench desc","","-1","-1","false","-1","-1","false","","1"],
    ["s","4254","pcnc_tilegrass","45508","0","1","1","","pcnc_tilegrass name","pcnc_tilegrass desc","","-1","-1","false","-1","-1","false","","1"],
    ["s","4255","pcnc_carrot","45508","0","1","1","","pcnc_carrot name","pcnc_carrot desc","","-1","-1","false","-1","-1","false","","1"],
    ["s","4256","pcnc_wall1","45508","0","3","1","","pcnc_wall1 name","pcnc_wall1 desc","","-1","-1","false","-1","-1","false","","1"],
    ["s","4257","pcnc_redbench","45508","2","2","1","","pcnc_redbench name","pcnc_redbench desc","","-1","-1","false","-1","-1","false","","1"],
    ["s","4258","pcnc_wall2","45508","0","1","1","","pcnc_wall2 name","pcnc_wall2 desc","","-1","-1","false","-1","-1","false","","1"],
    ["s","4259","pcnc_tiledirt","45508","0","1","1","","pcnc_tiledirt name","pcnc_tiledirt desc","","-1","-1","false","-1","-1","false","","1"],
    ["s","4260","pcnc_dvdrtile","45508","0","1","1","","pcnc_dvdrtile name","pcnc_dvdrtile desc","","-1","-1","false","-1","-1","false","","1"],
    ["s","4261","pcnc_shrub","45508","0","1","1","","pcnc_shrub name","pcnc_shrub desc","","-1","-1","false","-1","-1","false","","1"],
    ["s","4262","pcnc_tree","45508","0","1","1","","pcnc_tree name","pcnc_tree desc","","-1","-1","false","-1","-1","false","","1"]
    items_base table;
    Code:
    INSERT INTO `items_base` (item_id,sprite_id,public_name,item_name,type,width,length,height,allow_stack,allow_walk,allow_sit,allow_recycle,allow_trade,allow_marketplace_sell,allow_gift,allow_inventory_stack,interaction_type,cycle_count,vending_ids) VALUES
    (4243, 4243, 'pcnc_wood', 'pcnc_wood', 's', 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 'default', 0, 0),
    (4244, 4244, 'pcnc_door', 'pcnc_door', 's', 2, 1, 0, 0, 1, 0, 0, 0, 0, 0, 1, 'default', 0, 0),
    (4245, 4245, 'pcnc_fountain', 'pcnc_fountain', 's', 4, 4, 0, 0, 0, 0, 0, 0, 0, 0, 1, 'default', 0, 0),
    (4246, 4246, 'pcnc_gazebohack', 'pcnc_gazebohack', 's', 1, 1, 0, 1, 0, 0, 0, 0, 0, 0, 1, 'default', 0, 0),
    (4247, 4247, 'pcnc_wtable', 'pcnc_wtable', 's', 3, 1, 0, 1, 0, 0, 0, 0, 0, 0, 1, 'default', 0, 0),
    (4248, 4248, 'pcnc_tilestone', 'pcnc_tilestone', 's', 1, 1, 0, 1, 1, 0, 0, 0, 0, 0, 1, 'default', 0, 0),
    (4249, 4249, 'pcnc_carp', 'pcnc_carp', 's', 1, 1, 0, 1, 1, 0, 0, 0, 0, 0, 1, 'default', 0, 0),
    (4250, 4250, 'pcnc_bbq', 'pcnc_bbq', 's', 2, 3, 0, 0, 0, 0, 0, 0, 0, 0, 1, 'default', 0, 0),
    (4251, 4251, 'pcnc_gazebo', 'pcnc_gazebo', 's', 5, 5, 0, 1, 1, 0, 0, 0, 0, 0, 1, 'default', 0, 0),
    (4252, 4252, 'pcnc_swing', 'pcnc_swing', 's', 2, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 'default', 0, 0),
    (4253, 4253, 'pcnc_wbench', 'pcnc_wbench', 's', 3, 1, 0, 0, 0, 1, 0, 0, 0, 0, 1, 'default', 0, 0),
    (4254, 4254, 'pcnc_tilegrass', 'pcnc_tilegrass', 's', 1, 1, 0, 1, 1, 0, 0, 0, 0, 0, 1, 'default', 0, 0),
    (4255, 4255, 'pcnc_carrot', 'pcnc_carrot', 's', 1, 1, 0, 1, 0, 0, 0, 0, 0, 0, 1, 'default', 0, 0),
    (4256, 4256, 'pcnc_wall1', 'pcnc_wall1', 's', 3, 1, 0, 1, 0, 0, 0, 0, 0, 0, 1, 'default', 0, 0),
    (4257, 4257, 'pcnc_redbench', 'pcnc_redbench', 's', 2, 1, 0, 1, 0, 1, 0, 0, 0, 0, 1, 'default', 0, 0),
    (4258, 4258, 'pcnc_wall2', 'pcnc_wall2', 's', 1, 1, 0, 1, 0, 0, 0, 0, 0, 0, 1, 'default', 0, 0),
    (4259, 4259, 'pcnc_tiledirt', 'pcnc_tiledirt', 's', 1, 1, 0, 1, 1, 0, 0, 0, 0, 0, 1, 'default', 0, 0),
    (4260, 4260, 'pcnc_dvdrtile', 'pcnc_dvdrtile', 's', 1, 1, 0, 1, 1, 0, 0, 0, 0, 0, 1, 'default', 0, 0),
    (4261, 4261, 'pcnc_shrub', 'pcnc_shrub', 's', 1, 1, 0, 1, 0, 0, 0, 0, 0, 0, 1, 'default', 0, 0),
    (4262, 4262, 'pcnc_tree', 'pcnc_tree', 's', 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 'default', 0, 0);
    Catalog_items_copy table (which it is in my case... cba to change =p)
    Code:
    INSERT INTO `catalog_items_copy` (id,page_id,item_ids,catalog_name,cost_credits,cost_pixels,amount,cost_crystal,cost_oude_belcredits,song_id,limited_stack,limited_sells,offer_active,extradata) VALUES
    (4243, 2053, 4243, 'pcnc_wood', 25, 0, 5, 0, 0, 0, 0, 0, 1, ''),
    (4244, 2053, 4244, 'pcnc_door', 25, 0, 5, 0, 0, 0, 0, 0, 1, ''),
    (4245, 2053, 4245, 'pcnc_fountain', 25, 0, 5, 0, 0, 0, 0, 0, 1, ''),
    (4246, 2053, 4246, 'pcnc_gazebohack', 25, 0, 5, 0, 0, 0, 0, 0, 1, ''),
    (4247, 2053, 4247, 'pcnc_wtable', 25, 0, 5, 0, 0, 0, 0, 0, 1, ''),
    (4248, 2053, 4248, 'pcnc_tilestone', 25, 0, 5, 0, 0, 0, 0, 0, 1, ''),
    (4249, 2053, 4249, 'pcnc_carp', 25, 0, 5, 0, 0, 0, 0, 0, 1, ''),
    (4250, 2053, 4250, 'pcnc_bbq', 25, 0, 5, 0, 0, 0, 0, 0, 1, ''),
    (4251, 2053, 4251, 'pcnc_gazebo', 25, 0, 5, 0, 0, 0, 0, 0, 1, ''),
    (4252, 2053, 4252, 'pcnc_swing', 25, 0, 5, 0, 0, 0, 0, 0, 1, ''),
    (4253, 2053, 4253, 'pcnc_wbench', 25, 0, 5, 0, 0, 0, 0, 0, 1, ''),
    (4254, 2053, 4254, 'pcnc_tilegrass', 25, 0, 5, 0, 0, 0, 0, 0, 1, ''),
    (4255, 2053, 4255, 'pcnc_carrot', 25, 0, 5, 0, 0, 0, 0, 0, 1, ''),
    (4256, 2053, 4256, 'pcnc_wall1', 25, 0, 5, 0, 0, 0, 0, 0, 1, ''),
    (4257, 2053, 4257, 'pcnc_redbench', 25, 0, 5, 0, 0, 0, 0, 0, 1, ''),
    (4258, 2053, 4258, 'pcnc_wall2', 25, 0, 5, 0, 0, 0, 0, 0, 1, ''),
    (4259, 2053, 4259, 'pcnc_tiledirt', 25, 0, 5, 0, 0, 0, 0, 0, 1, ''),
    (4260, 2053, 4260, 'pcnc_dvdrtile', 25, 0, 5, 0, 0, 0, 0, 0, 1, ''),
    (4261, 2053, 4261, 'pcnc_shrub', 25, 0, 5, 0, 0, 0, 0, 0, 1, ''),
    (4262, 2053, 4262, 'pcnc_tree', 25, 0, 5, 0, 0, 0, 0, 0, 1, '');
    Catalog_pages table ;

    ** Including the message that staff will get fired for sharing these furnitures **
    Code:
    INSERT INTO `catalog_pages` (`id`, `parent_id`, `caption`, `icon_color`, `icon_image`, `visible`, `enabled`, `min_rank`, `club_only`, `coming_soon`, `order_num`, `page_layout`, `page_headline`, `page_teaser`, `page_special`, `page_text1`, `page_text2`, `page_text_details`, `page_text_teaser`, `text3`, `link`, `mobile_frntpg`, `vip_only`, `page_link_description`, `page_link_pagename`) VALUES
    (2053, 91, 'Public Rooms', 1, 10, '1', '1', 7, '0', '0', 100, 'default_3x3', 'catalog_rares_headline1', 'catalog_limited_teaser_en', '', 'This page contains special rares available for staff. STAFF CAUGHT GIVING OUT THESE WITH NO REASON WILL BE DEMOTED.', '', 'Click on an item for more information.', '', '', '', '', '0', '', '');

    ;; Download : http://images.habbiehotel.com/swfs_pcnc.rar
    ;; Credits to Habbo =D
    ;; Credits to users of RaGEZONE =).

    ;; Rules? ;;
    ; Don't flame in this thread..

    ;; images?! ;;
    Look longer than your noose is... The header logo in this thread should be enough?!

    ;; Bugs? ;;
    ; Don't post them here.. Im also reading the HELP section.. So post it there..

    ;; Phoenix SQLs ;;
    They wishhh <33.

    Hope you all will enjoy it.. Took me about 10 minutes =p. Its just boring work.
    Like's are always welcome.. That gives me the "emotions" to continue this kind of work.

    ; Mikey
    Last edited by EvilCoder; 12-04-13 at 11:02 PM.


  2. #2
    Developer BurakDev is offline
    MemberRank
    Mar 2013 Join Date
    ParisLocation
    376Posts

    Re: [SWF + SQL] Picknick - Public Furniture

    Nice release, thanks !

  3. #3
    1 + 3 + 3 = 7 EvilCoder is offline
    MemberRank
    Jul 2009 Join Date
    /home/mvdworpLocation
    334Posts

    Re: [SWF + SQL] Picknick - Public Furniture

    Yeh, i've updated the catalog_items_copy structure as i forgot to put allow_inventory_stack at 1. So they wouldn't stack in your inventory.. Now they will =)!

    - Mikey

  4. #4
    Enthusiast mitchellas is offline
    MemberRank
    Jul 2012 Join Date
    33Posts

    Re: [SWF + SQL] Picknick - Public Furniture

    Are they clickable?

  5. #5
    Account Upgraded | Title Enabled! TardisHotel is offline
    MemberRank
    Mar 2013 Join Date
    404Posts

    Re: [SWF + SQL] Picknick - Public Furniture

    Are the swf's for this the clickable ones? or the swf's the ones where you need to use :furni to move them?

  6. #6
    idk what to put here Joseph is offline
    MemberRank
    Oct 2007 Join Date
    CanehdaLocation
    1,317Posts

    Re: [SWF + SQL] Picknick - Public Furniture

    sigh- all this section is now is flaming, nice release though..

  7. #7
    1 + 3 + 3 = 7 EvilCoder is offline
    MemberRank
    Jul 2009 Join Date
    /home/mvdworpLocation
    334Posts

    Re: [SWF + SQL] Picknick - Public Furniture

    Quote Originally Posted by Joseph View Post
    sigh- all this section is now is flaming, nice release though..
    Agreed.. And thanks :)!



Advertisement