Steampunk furniture error [HELP]

Results 1 to 9 of 9
  1. #1
    Member Pancake Face is offline
    MemberRank
    Jul 2013 Join Date
    United KingdomLocation
    27Posts

    note Steampunk furniture error [HELP]

    Hey there, well I did have another post but it was deleted for not having enough information?

    Well, I added steampunk furniture to my catalogue, I used my own sqls and furni data and i'm pretty sure they're correct. The furniture doesn't load in the catalogue nor in rooms, it's just black boxes. I've cleared my cache and updated the catalogue.

    Heres my sqls;
    PHP Code:

    INSERT INTO 
    `catalog_items` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `cost_snow`, `amount`, `vip`, `achievement`) VALUES(2222222212512'222222221''steampunk_chand'5001'0'0),(2222222222512'222222222''dimmer_steampunk'5001'0'0),(2222222232512'222222223''steampunk_arch'5001'0'0),(2222222242512'222222224''steampunk_carpet'5001'0'0),(2222222252512'222222225''steampunk_chair'5001'0'0),(2222222312512'222222231''steampunk_globe'5001'0'0),(2222222332512'222222233''steampunk_lamp'5001'0'0),(2222222342512'222222234''steampunk_map'5001'0'0),(2222222352512'222222235''steampunk_pillar_1'5001'0'0);
    INSERT INTO `catalog_items` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `cost_snow`, `amount`, `vip`, `achievement`) VALUES(2222222262512'222222226''steampunk_computer'5001'0'0),(2222222272512'222222227''steampunk_floor1'5001'0'0),(2222222282512'222222228''steampunk_floor2'5001'0'0),(2222222292512'222222229''steampunk_gear1'5001'0'0),(2222222302512'222222230''steampunk_gear2'5001'0'0),(2222222362512'222222236''steampunk_pillar_2'5001'0'0),(2222222372512'222222237''steampunk_rack'5001'0'0),(2222222382512'222222238''steampunk_sofachair'5001'0'0),(2222222392512'222222239''steampunk_table_1'5001'0'0),(2222222402512'222222240''steampunk_table_2'5001'0'0),(2222222412512'222222241''steampunk_tele'5001'0'0),(2222222422512'222222242''steampunk_wall1'5001'0'0),(2222222432512'222222243''steampunk_wall2'5001'0'0),(2222222442512'222222244''steampunk_window'5001'0'0);




    INSERT INTO `furniture` (`id`, `public_name`, `item_name`, `type`, `width`, `length`, `stack_height`, `can_stack`, `can_sit`, `is_walkable`, `sprite_id`, `allow_recycle`, `allow_trade`, `allow_marketplace_sell`, `allow_gift`, `allow_inventory_stack`, `interaction_type`, `interaction_modes_count`, `vending_ids`, `is_arrow`, `foot_figure`, `height_adjustable`, `effectM`, `effectF`) VALUES(222222223'steampunk_arch''steampunk_arch''s'130'0''0''0'2223'1''1''1''1''1''default'3'0''0'NULL'0'00),(222222241'steampunk_tele''steampunk_tele''s'220'0''0''0'2241'1''1''1''1''1''default'3'0''0'NULL'0'00),(222222242'steampunk_wall1''steampunk_wall1''i'220'0''0''0'2242'1''1''1''1''1''default'3'0''0'NULL'0'00),(222222243'steampunk_wall2''steampunk_wall2''i'220'0''0''0'2243'1''1''1''1''1''default'3'0''0'NULL'0'00),(222222244'steampunk_window''steampunk_window''i'220'0''0''0'2244'1''1''1''1''1''default'3'0''0'NULL'0'00);




    INSERT INTO `furniture` (`id`, `public_name`, `item_name`, `type`, `width`, `length`, `stack_height`, `can_stack`, `can_sit`, `is_walkable`, `sprite_id`, `allow_recycle`, `allow_trade`, `allow_marketplace_sell`, `allow_gift`, `allow_inventory_stack`, `interaction_type`, `interaction_modes_count`, `vending_ids`, `is_arrow`, `foot_figure`, `height_adjustable`, `effectM`, `effectF`) VALUES(222222221'steampunk_chand''steampunk_chand''s'110'0''0''0'2221'1''1''1''1''1''default'1'0''0'NULL'0'00),(222222222'dimmer_steampunk''dimmer_steampunk''i'111'0''0''0'2222'1''1''1''1''1''default'2'0''0'NULL'0'00),(222222224'steampunk_carpet''steampunk_carpet''s'110'0''0''0'2224'1''1''1''1''1''default'1'0''0'NULL'0'00),(222222225'steampunk_chair''steampunk_chair''s'110'0''0''0'2225'1''1''1''1''1''default'1'0''0'NULL'0'00),(222222226'steampunk_computer''steampunk_computer''s'110'0''0''0'2226'1''1''1''1''1''default'1'0''0'NULL'0'00),(222222227'steampunk_floor1''steampunk_floor1''s'220'0''0''0'2227'1''1''1''1''1''default'3'0''0'NULL'0'00),(222222228'steampunk_floor2''steampunk_floor2''s'220'0''0''0'2228'1''1''1''1''1''default'3'0''0'NULL'0'00),(222222229'steampunk_gear1''steampunk_gear1''s'220'0''0''0'2229'1''1''1''1''1''default'3'0''0'NULL'0'00),(222222230'steampunk_gear2''steampunk_gear2''s'220'0''0''0'2230'1''1''1''1''1''default'3'0''0'NULL'0'00),(222222231'steampunk_globe''steampunk_globe''s'220'0''0''0'2231'1''1''1''1''1''default'3'0''0'NULL'0'00),(222222233'steampunk_lamp''steampunk_lamp''s'220'0''0''0'2233'1''1''1''1''1''default'3'0''0'NULL'0'00),(222222234'steampunk_map''steampunk_map''i'220'0''0''0'2234'1''1''1''1''1''default'3'0''0'NULL'0'00),(222222235'steampunk_pillar_1''steampunk_pillar_1''s'220'0''0''0'2235'1''1''1''1''1''default'3'0''0'NULL'0'00),(222222236'steampunk_pillar_2''steampunk_pillar_2''s'220'0''0''0'2236'1''1''1''1''1''default'3'0''0'NULL'0'00),(222222237'steampunk_rack''steampunk_rack''s'220'0''0''0'2237'1''1''1''1''1''default'3'0''0'NULL'0'00),(222222238'steampunk_sofachair''steampunk_sofachair''s'220'0''0''0'2238'1''1''1''1''1''default'3'0''0'NULL'0'00),(222222239'steampunk_table_1''steampunk_table_1''s'220'0''0''0'2239'1''1''1''1''1''default'3'0''0'NULL'0'00),(222222240'steampunk_table_2''steampunk_table_2''s'220'0''0''0'2240'1''1''1''1''1''default'3'0''0'NULL'0'00); 
    Furnidata:
    PHP Code:
    ["I","2222","dimmer_steampunk","222222","0","1","1","dimmer_steampunk","Steampunk Dimmer",","-1,"-1"],["S","2223","steampunk_arch","222223","0","1","1","steampunk_arch","Steampunk Arch",","-1,"-1"],["S","2224","steampunk_carpet","222224","0","1","1","steampunk_carpet","Steampunk Carpet",","-1,"-1"],["S","2225","steampunk_chair","222225","0","1","1","steampunk_chair","Steampunk Chair",","-1,"-1"],["S","2221","steampunk_chand","222221","0","1","1","steampunk_chand","Steampunk Chand",","-1,"-1"],["S","2226","steampunk_computer","222226","0","1","1","steampunk_computer","Steampunk Computer",","-1,"-1"],["S","2227","steampunk_floor1","222227","0","1","1","steampunk_floor1","Steampunk Floor",","-1,"-1"],["S","2228","steampunk_floor2","222228","0","1","1","steampunk_floor2","Steampunk Floor",","-1,"-1"],["S","2229","steampunk_gear1","222229","0","1","1","steampunk_gear1","Steampunk Gear",","-1,"-1"],["S","2230","steampunk_gear2","222230","0","1","1","steampunk_gear2","Steampunk Gear",","-1,"-1"],["S","2231","steampunk_globe","222231","0","1","1","steampunk_globe","Steampunk Globe",","-1,"-1"],["S","2233","steampunk_lamp","222233","0","1","1","steampunk_lamp","Steampunk Lamp",","-1,"-1"],["I","2234","steampunk_map","222234","0","1","1","steampunk_map","Steampunk Map",","-1,"-1"],["S","2235","steampunk_pillar_1","222235","0","1","1","steampunk_pillar_1","Steampunk Pillar",","-1,"-1"],["S","2236","steampunk_pillar_2","222236","0","1","1","steampunk_pillar_2","Steampunk Pillar",","-1,"-1"],["S","2237","steampunk_rack","222237","0","1","1","steampunk_rack","Steampunk Rack",","-1,"-1"],["S","2238","steampunk_sofachair","222238","0","1","1","steampunk_sofachair","Steampunk Sofa",","-1,"-1"],["S","2239","steampunk_table_1","222239","0","1","1","steampunk_table_1","Steampunk Table",","-1,"-1"],["S","2240","steampunk_table_2","222240","0","1","1","steampunk_table_2","Steampunk Table",","-1,"-1"],["S","2241","steampunk_tele","222241","0","1","1","steampunk_tele","Steampunk Teleporter",","-1,"-1"],["I","2242","steampunk_wall1","222242","0","1","1","steampunk_wall1","Steampunk Wall",","-1,"-1"],["I","2243","steampunk_wall2","222243","0","1","1","steampunk_wall2","Steampunk Wall",","-1,"-1"],["I","2244","steampunk_window","222244","0","1","1","steampunk_window","Steampunk Window",","-1,"-1"], 
    I hope this thread doesn't get deleted as this is all the information I can add?
    Last edited by Pancake Face; 05-08-13 at 07:02 AM. Reason: Adding tags?


  2. #2
    idk what to put here Joseph is offline
    Grand MasterRank
    Oct 2007 Join Date
    CanehdaLocation
    1,315Posts

    Re: Steampunk furniture error

    I told you to add the correct tags and you still haven't, do it before I close your thread please.

  3. #3
    Member Pancake Face is offline
    MemberRank
    Jul 2013 Join Date
    United KingdomLocation
    27Posts

    Re: Steampunk furniture error

    How do you add tags?

  4. #4
    idk what to put here Joseph is offline
    Grand MasterRank
    Oct 2007 Join Date
    CanehdaLocation
    1,315Posts

    Re: Steampunk furniture error [HELP]

    [MYSQL] Steampunk furniture error


  5. #5
    Not so spooky... MrSpooks is offline
    Grand MasterRank
    May 2010 Join Date
    Under a rockLocation
    1,068Posts

    Re: Steampunk furniture error [HELP]

    You might want to take a look at your furnidata...

    ["I","222222222","dimmer_steampunk","22222","0","1","1","dimmer_steampunk","Steampunk Dimmer",","-1,"-1"],
    ["S","222222223","steampunk_arch","22222","0","1","1","steampunk_arch","Steampunk Arch",","-1,"-1"],
    ["S","222222224","steampunk_carpet","22222","0","1","1","steampunk_carpet","Steampunk Carpet",","-1,"-1"],
    ["S","222222225","steampunk_chair","22222","0","1","1","steampunk_chair","Steampunk Chair",","-1,"-1"],
    ["S","222222221","steampunk_chand","22222","0","1","1","steampunk_chand","Steampunk Chand",","-1,"-1"],
    ["S","222222226","steampunk_computer","22222","0","1","1","steampunk_computer","Steampunk Computer",","-1,"-1"],
    ["S","222222227","steampunk_floor1","22222","0","1","1","steampunk_floor1","Steampunk Floor",","-1,"-1"],
    ["S","222222228","steampunk_floor2","22222","0","1","1","steampunk_floor2","Steampunk Floor",","-1,"-1"],
    ["S","222222229","steampunk_gear1","22222","0","1","1","steampunk_gear1","Steampunk Gear",","-1,"-1"],
    ["S","222222230","steampunk_gear2","22222","0","1","1","steampunk_gear2","Steampunk Gear",","-1,"-1"],
    ["S","222222231","steampunk_globe","22222","0","1","1","steampunk_globe","Steampunk Globe",","-1,"-1"],
    ["S","222222233","steampunk_lamp","22222","0","1","1","steampunk_lamp","Steampunk Lamp",","-1,"-1"],
    ["I","222222234","steampunk_map","22222","0","1","1","steampunk_map","Steampunk Map",","-1,"-1"],
    ["S","222222235","steampunk_pillar_1","22222","0","1","1","steampunk_pillar_1","Steampunk Pillar",","-1,"-1"],
    ["S","222222236","steampunk_pillar_2","22222","0","1","1","steampunk_pillar_2","Steampunk Pillar",","-1,"-1"],
    ["S","222222237","steampunk_rack","22222","0","1","1","steampunk_rack","Steampunk Rack",","-1,"-1"],
    ["S","222222238","steampunk_sofachair","22222","0","1","1","steampunk_sofachair","Steampunk Sofa",","-1,"-1"],
    ["S","222222239","steampunk_table_1","22222","0","1","1","steampunk_table_1","Steampunk Table",","-1,"-1"],
    ["S","222222240","steampunk_table_2","22222","0","1","1","steampunk_table_2","Steampunk Table",","-1,"-1"],
    ["S","222222241","steampunk_tele","22222","0","1","1","steampunk_tele","Steampunk Teleporter",","-1,"-1"],
    ["I","222222242","steampunk_wall1","22222","0","1","1","steampunk_wall1","Steampunk Wall",","-1,"-1"],
    ["I","222222243","steampunk_wall2","22222","0","1","1","steampunk_wall2","Steampunk Wall",","-1,"-1"],
    ["I","222222244","steampunk_window","22222","0","1","1","steampunk_window","Steampunk Window",","-1,"-1"],

    That should work, Add the swfs in to a folder in your "hof_furni" folder with the name 22222
    Then replace the furnidata you added with that.

    @Joseph - I know your trying to clean up the section mate, but you may want to add in the rules that you need to add the correct tags to your problem, as I've just looked and there is nothing that says you need to do so, And maybe be a little less harsh on the noobs? there only looking for help.

    Anyway hope it helps :)

  6. #6
    Check http://arcturus.pw The General is offline
    DeveloperRank
    Aug 2011 Join Date
    7,613Posts

    Re: Steampunk furniture error [HELP]

    I -> i
    S -> s

    ['type', 'id', 'swf_name', 'revision*', 'unimportant', 'unimportant', 'unimportant', 'name', 'desc']

    type ->
    s: solid
    i: wallitem
    e: effect (Only in database)
    id ->
    same number as item_ids
    swf_name->
    without .swf
    * = revision only used on habbo. For retro's all furniture goes in a single folder.

    name->
    Furniture Name in the hotel.

    desc ->
    Furniture Description in the hotel.

    @Joseph, problem is not his [MySQL] but his [furnidata]. And if someone knows the problem he would be able to fix it right?

  7. #7
    Member Pancake Face is offline
    MemberRank
    Jul 2013 Join Date
    United KingdomLocation
    27Posts

    Re: Steampunk furniture error [HELP]

    Alright thanks, I used some program that I found on here to make the MySQL and furnidata, it worked with other furniture just not this I guess. Yes, I am a noob... I know that very well but by asking for help I hope to improve that by seeing where I went wrong.

    I did what you told me to do yet it still doesn't load...

  8. #8
    Member Pancake Face is offline
    MemberRank
    Jul 2013 Join Date
    United KingdomLocation
    27Posts

    Re: Steampunk furniture error [HELP]

    Any ideas?

  9. #9
    Member Pancake Face is offline
    MemberRank
    Jul 2013 Join Date
    United KingdomLocation
    27Posts

    Re: Steampunk furniture error [HELP]

    Bump!



Advertisement