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(222222221, 2512, '222222221', 'steampunk_chand', 5, 0, 0, 1, '0', 0),(222222222, 2512, '222222222', 'dimmer_steampunk', 5, 0, 0, 1, '0', 0),(222222223, 2512, '222222223', 'steampunk_arch', 5, 0, 0, 1, '0', 0),(222222224, 2512, '222222224', 'steampunk_carpet', 5, 0, 0, 1, '0', 0),(222222225, 2512, '222222225', 'steampunk_chair', 5, 0, 0, 1, '0', 0),(222222231, 2512, '222222231', 'steampunk_globe', 5, 0, 0, 1, '0', 0),(222222233, 2512, '222222233', 'steampunk_lamp', 5, 0, 0, 1, '0', 0),(222222234, 2512, '222222234', 'steampunk_map', 5, 0, 0, 1, '0', 0),(222222235, 2512, '222222235', 'steampunk_pillar_1', 5, 0, 0, 1, '0', 0);
INSERT INTO `catalog_items` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `cost_snow`, `amount`, `vip`, `achievement`) VALUES(222222226, 2512, '222222226', 'steampunk_computer', 5, 0, 0, 1, '0', 0),(222222227, 2512, '222222227', 'steampunk_floor1', 5, 0, 0, 1, '0', 0),(222222228, 2512, '222222228', 'steampunk_floor2', 5, 0, 0, 1, '0', 0),(222222229, 2512, '222222229', 'steampunk_gear1', 5, 0, 0, 1, '0', 0),(222222230, 2512, '222222230', 'steampunk_gear2', 5, 0, 0, 1, '0', 0),(222222236, 2512, '222222236', 'steampunk_pillar_2', 5, 0, 0, 1, '0', 0),(222222237, 2512, '222222237', 'steampunk_rack', 5, 0, 0, 1, '0', 0),(222222238, 2512, '222222238', 'steampunk_sofachair', 5, 0, 0, 1, '0', 0),(222222239, 2512, '222222239', 'steampunk_table_1', 5, 0, 0, 1, '0', 0),(222222240, 2512, '222222240', 'steampunk_table_2', 5, 0, 0, 1, '0', 0),(222222241, 2512, '222222241', 'steampunk_tele', 5, 0, 0, 1, '0', 0),(222222242, 2512, '222222242', 'steampunk_wall1', 5, 0, 0, 1, '0', 0),(222222243, 2512, '222222243', 'steampunk_wall2', 5, 0, 0, 1, '0', 0),(222222244, 2512, '222222244', 'steampunk_window', 5, 0, 0, 1, '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', 1, 3, 0, '0', '0', '0', 2223, '1', '1', '1', '1', '1', 'default', 3, '0', '0', NULL, '0', 0, 0),(222222241, 'steampunk_tele', 'steampunk_tele', 's', 2, 2, 0, '0', '0', '0', 2241, '1', '1', '1', '1', '1', 'default', 3, '0', '0', NULL, '0', 0, 0),(222222242, 'steampunk_wall1', 'steampunk_wall1', 'i', 2, 2, 0, '0', '0', '0', 2242, '1', '1', '1', '1', '1', 'default', 3, '0', '0', NULL, '0', 0, 0),(222222243, 'steampunk_wall2', 'steampunk_wall2', 'i', 2, 2, 0, '0', '0', '0', 2243, '1', '1', '1', '1', '1', 'default', 3, '0', '0', NULL, '0', 0, 0),(222222244, 'steampunk_window', 'steampunk_window', 'i', 2, 2, 0, '0', '0', '0', 2244, '1', '1', '1', '1', '1', 'default', 3, '0', '0', NULL, '0', 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(222222221, 'steampunk_chand', 'steampunk_chand', 's', 1, 1, 0, '0', '0', '0', 2221, '1', '1', '1', '1', '1', 'default', 1, '0', '0', NULL, '0', 0, 0),(222222222, 'dimmer_steampunk', 'dimmer_steampunk', 'i', 1, 1, 1, '0', '0', '0', 2222, '1', '1', '1', '1', '1', 'default', 2, '0', '0', NULL, '0', 0, 0),(222222224, 'steampunk_carpet', 'steampunk_carpet', 's', 1, 1, 0, '0', '0', '0', 2224, '1', '1', '1', '1', '1', 'default', 1, '0', '0', NULL, '0', 0, 0),(222222225, 'steampunk_chair', 'steampunk_chair', 's', 1, 1, 0, '0', '0', '0', 2225, '1', '1', '1', '1', '1', 'default', 1, '0', '0', NULL, '0', 0, 0),(222222226, 'steampunk_computer', 'steampunk_computer', 's', 1, 1, 0, '0', '0', '0', 2226, '1', '1', '1', '1', '1', 'default', 1, '0', '0', NULL, '0', 0, 0),(222222227, 'steampunk_floor1', 'steampunk_floor1', 's', 2, 2, 0, '0', '0', '0', 2227, '1', '1', '1', '1', '1', 'default', 3, '0', '0', NULL, '0', 0, 0),(222222228, 'steampunk_floor2', 'steampunk_floor2', 's', 2, 2, 0, '0', '0', '0', 2228, '1', '1', '1', '1', '1', 'default', 3, '0', '0', NULL, '0', 0, 0),(222222229, 'steampunk_gear1', 'steampunk_gear1', 's', 2, 2, 0, '0', '0', '0', 2229, '1', '1', '1', '1', '1', 'default', 3, '0', '0', NULL, '0', 0, 0),(222222230, 'steampunk_gear2', 'steampunk_gear2', 's', 2, 2, 0, '0', '0', '0', 2230, '1', '1', '1', '1', '1', 'default', 3, '0', '0', NULL, '0', 0, 0),(222222231, 'steampunk_globe', 'steampunk_globe', 's', 2, 2, 0, '0', '0', '0', 2231, '1', '1', '1', '1', '1', 'default', 3, '0', '0', NULL, '0', 0, 0),(222222233, 'steampunk_lamp', 'steampunk_lamp', 's', 2, 2, 0, '0', '0', '0', 2233, '1', '1', '1', '1', '1', 'default', 3, '0', '0', NULL, '0', 0, 0),(222222234, 'steampunk_map', 'steampunk_map', 'i', 2, 2, 0, '0', '0', '0', 2234, '1', '1', '1', '1', '1', 'default', 3, '0', '0', NULL, '0', 0, 0),(222222235, 'steampunk_pillar_1', 'steampunk_pillar_1', 's', 2, 2, 0, '0', '0', '0', 2235, '1', '1', '1', '1', '1', 'default', 3, '0', '0', NULL, '0', 0, 0),(222222236, 'steampunk_pillar_2', 'steampunk_pillar_2', 's', 2, 2, 0, '0', '0', '0', 2236, '1', '1', '1', '1', '1', 'default', 3, '0', '0', NULL, '0', 0, 0),(222222237, 'steampunk_rack', 'steampunk_rack', 's', 2, 2, 0, '0', '0', '0', 2237, '1', '1', '1', '1', '1', 'default', 3, '0', '0', NULL, '0', 0, 0),(222222238, 'steampunk_sofachair', 'steampunk_sofachair', 's', 2, 2, 0, '0', '0', '0', 2238, '1', '1', '1', '1', '1', 'default', 3, '0', '0', NULL, '0', 0, 0),(222222239, 'steampunk_table_1', 'steampunk_table_1', 's', 2, 2, 0, '0', '0', '0', 2239, '1', '1', '1', '1', '1', 'default', 3, '0', '0', NULL, '0', 0, 0),(222222240, 'steampunk_table_2', 'steampunk_table_2', 's', 2, 2, 0, '0', '0', '0', 2240, '1', '1', '1', '1', '1', 'default', 3, '0', '0', NULL, '0', 0, 0);
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?
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.
Re: Steampunk furniture error
Re: Steampunk furniture error [HELP]
[MYSQL] Steampunk furniture error
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 :)
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?
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...
Re: Steampunk furniture error [HELP]
Re: Steampunk furniture error [HELP]