I am getting SQL error on everything i removed root figure and all
This is a discussion on Beach Furni 2011 within the Habbo Releases forums, part of the Habbo Hotel category; Hi, Here are the new Beach Furni of 2011, enjoy :)! Coco furniture: http://forum.ragezone.com/f353/coco-furni-uber-762259/ (Jeanzinh0) Furniture Code: INSERT INTO `furniture` ...
Hi,
Here are the new Beach Furni of 2011, enjoy :)!
Coco furniture: http://forum.ragezone.com/f353/coco-furni-uber-762259/ (Jeanzinh0)
Furniture
Catalog ItemsCode: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`) VALUES (199868, 'qt_sum11_ictrolley', 'qt_sum11_ictrolley', 's', 1, 1, 1, '0', '0', '0', 4018, '1', '1', '1', '1', '1', 'default', 2, '0', '0', 0), (199869, 'qt_sum11_platfrm', 'qt_sum11_platfrm', 's', 2, 2, 1, '1', '0', '0', 4022, '1', '1', '1', '1', '1', 'default', 2, '0', '0', 1), (199870, 'qt_sum11_shell3', 'qt_sum11_shell3', 's', 1, 1, 1, '0', '0', '0', 4021, '1', '1', '1', '1', '1', 'default', 2, '0', '0', 0), (199871, 'qt_sum11_shell2', 'qt_sum11_shell2', 's', 1, 1, 1, '0', '0', '0', 4023, '1', '1', '1', '1', '1', 'default', 2, '0', '0', 0), (199872, 'qt_sum11_chair', 'qt_sum11_chair', 's', 1, 1, 1, '0', '1', '0', 4025, '1', '1', '1', '1', '1', 'default', 4, '0', '0', 0), (199873, 'qt_sum11_shell4', 'qt_sum11_shell4', 's', 1, 1, 1, '1', '0', '0', 4020, '1', '1', '1', '1', '1', 'default', 1, '0', '0', 0), (199874, 'qt_sum11_shell1', 'qt_sum11_shell1', 's', 1, 1, 1, '0', '0', '0', 4017, '1', '1', '1', '1', '1', 'default', 1, '0', '0', 0), (199875, 'qt_sum11_shell5', 'qt_sum11_shell5', 's', 1, 1, 1, '0', '0', '0', 4024, '1', '1', '1', '1', '1', 'default', 1, '0', '0', 0), (199876, 'qt_sum11_petfood', 'qt_sum11_petfood', 's', 1, 1, 1, '0', '0', '0', 4019, '1', '1', '1', '1', '1', 'default', 1, '0', '0', 0);
Catalog PageCode:INSERT INTO `catalog_items` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `cost_snow`, `amount`) VALUES (199868, 8765, '199868', 'qt_sum11_ictrolley', 0, 100, 0, 1), (199869, 8765, '199869', 'qt_sum11_platfrm', 8, 0, 0, 1), (199870, 8765, '199870', 'qt_sum11_shell3', 3, 0, 0, 1), (199871, 8765, '199871', 'qt_sum11_shell2', 3, 0, 0, 1), (199872, 8765, '199872', 'qt_sum11_chair', 4, 0, 0, 1), (199873, 8765, '199873', 'qt_sum11_shell4', 3, 0, 0, 1), (199874, 8765, '199874', 'qt_sum11_shell1', 3, 0, 0, 1), (199875, 8765, '199875', 'qt_sum11_shell5', 3, 0, 0, 1), (199876, 8765, '199876', 'qt_sum11_petfood', 2, 100, 0, 1);
FurnidataCode:INSERT INTO `catalog_pages` (`id`, `parent_id`, `caption`, `icon_color`, `icon_image`, `visible`, `enabled`, `min_rank`, `club_only`, `order_num`, `page_layout`, `page_headline`, `page_teaser`, `page_special`, `page_text1`, `page_text2`, `page_text_details`, `page_text_teaser`, `vip_only`, `coming_soon`) VALUES (8765, -3, 'Beach Shop', 1, 59, '1', '1', 1, '0', 1, 'default_3x3', 'head_shop', 'teas_shop', '', 'Welcome to the Beach Shop! Buy here some things, that come in handy when you are making a beach club, or something else. Don't have enough pixels? Then finish Quests!', '', '', '', '0', 0);
ScreenshotCode:["s","4017","qt_sum11_shell1","34362","0","1","1","","qt_sum11_shell1 name","qt_sum11_shell1 desc","","137786","10175"],["s","4018","qt_sum11_ictrolley","34362","4","1","1","","qt_sum11_ictrolley name","qt_sum11_ictrolley desc","","137786","10176"],["s","4019","qt_sum11_petfood","34362","2","1","1","","qt_sum11_petfood name","qt_sum11_petfood desc","","137786","10177"],["s","4020","qt_sum11_shell4","34362","0","1","1","","qt_sum11_shell4 name","qt_sum11_shell4 desc","","137786","10178"],["s","4021","qt_sum11_shell3","34362","0","1","1","","qt_sum11_shell3 name","qt_sum11_shell3 desc","","137786","10179"],["s","4022","qt_sum11_platfrm","34362","0","2","2","","qt_sum11_platfrm name","qt_sum11_platfrm desc","","137786","10180"],["s","4023","qt_sum11_shell2","34362","0","1","1","","qt_sum11_shell2 name","qt_sum11_shell2 desc","","137786","10181"],["s","4024","qt_sum11_shell5","34362","0","1","1","","qt_sum11_shell5 name","qt_sum11_shell5 desc","","137786","10182"],["s","4025","qt_sum11_chair","34362","4","1","1","","qt_sum11_chair name","qt_sum11_chair desc","","137786","10183"],
Catalog Images
SWF
http://www.mediafire.com/?22f9ghro72eme71
Didn't want to release this first, because people can't stop blaming about this stuff, but..
Press like if this helped!
Last edited by Hubbo-Hotel; 08-07-11 at 07:36 PM.
I am getting SQL error on everything i removed root figure and all
Last edited by jmandupree; 15-06-11 at 09:03 AM.
Jmandupree is back !!!
Thats the error i get from furni and Pages items worked..#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 'qt_sum11_platfrm', 'qt_sum11_platfrm', 's', 2, 2, 1, '1', '0', '0', 4022, '1', '' at line 2
Jmandupree is back !!!
Then you removed the foot_figure part wrong. Add the table, and try it again.
... Give me the query for it then....
Jmandupree is back !!!
Add this to your table structure..
ID: foot_figure
Type: ENUM
Length/Values: '0','1'
Default: As Defined 1
Collation: latin1_swedish_ci
can you remove coming_soon out the catalogue_pages and re post it please. thanks.!
thanks for this, works great!!
Is it for uber or phoenix?
Helping those who deserve to be helped.
Just because you can edit 2 lines of PHP code and change a variable does not mean you're a programmer. And just because you can follow a tutorial on how to set up IIS does not make you a server technician or manager.
#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 't have enough pixels? Then finish Quests!', '', '', '', '0', 0)' at line 2