The new Kitchen Furnitures [SQL]

[taylan]

Hey Guys

Here is the new Kitchen Furniture !

put the sql into your database

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`)
VALUES ('178', '3', 'New Kitchen', '1', '51', '1', '1', '1', '0', '0', '4', 'default_3x3', '', '', '', 'The new Kitchen Furnitures...', '', '', '');

INSERT INTO `catalog_items` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `amount`) VALUES
('97419', '178', '97419', 'ktchn10_block', '5', '0', '1'),
('97420', '178', '97420', 'ktchn10_cabnt', '5', '0', '1'),
('97421', '178', '97421', 'ktchn10_pot', '5', '0', '1'),
('97422', '178', '97422', 'ktchn10_sink', '5', '0', '1'),
('97423', '178', '97423', 'ktchn10_stove', '5', '0', '1'),
('97424', '178', '97424', 'ktchn10_tea', '5', '0', '1');

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`, `foot_figure`) VALUES
('97419', 'ktchn10_block', 'ktchn10_block', 's', '1', '1', '1', '1', '0', '0', '3589', '1', '1', '1', '1', '1', 'default', '3', '0', ''),
('97420', 'ktchn10_cabnt', 'ktchn10_cabnt', 'i', '1', '1', '1', '1', '0', '0', '4338', '1', '1', '1', '1', '1', 'default', '1', '0', ''),
('97421', 'ktchn10_pot', 'ktchn10_pot', 's', '1', '1', '1', '1', '0', '0', '3580', '1', '1', '1', '1', '1', 'default', '2', '0', ''),
('97422', 'ktchn10_sink', 'ktchn10_sink', 's', '2', '1', '1', '1', '0', '0', '3612', '1', '1', '1', '1', '1', 'default', '3', '0', ''),
('97423', 'ktchn10_stove', 'ktchn10_stove', 's', '2', '1', '1.2', '1', '0', '0', '3581', '1', '1', '1', '1', '1', 'default', '2', '0', ''),
('97424', 'ktchn10_tea', 'ktchn10_tea', 's', '1', '1', '1', '1', '0', '0', '3592', '1', '1', '1', '1', '1', 'default', '2', '0', '');

Use the Variables from habbo.com if it dont work....

Image:

 

[Adde]

Lol. I was just going to release these, made by myself.. But u did it before me..

Anyways, give credits to the real creator.

 

[Rick3131]

SQL-query:

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` , `foot_figure` ) 
VALUES (

'97419',  'ktchn10_block',  'ktchn10_block',  's',  '1',  '1',  '1',  '1',  '0',  '0',  '3589',  '1',  '1',  '1',  '1',  '1',  'default',  '3',  '0',  ''
), (
'97420',  'ktchn10_cabnt',  'ktchn10_cabnt',  'i',  '1',  '1',  '1',  '1',  '0',  '0',  '4338',  '1',  '1',  '1',  '1',  '1',  'default',  '1',  '0',  ''
), (
'97421',  'ktchn10_pot',  'ktchn10_pot',  's',  '1',  '1',  '1',  '1',  '0',  '0',  '3580',  '1',  '1',  '1',  '1',  '1',  'default',  '2',  '0',  ''
), (
'97422',  'ktchn10_sink',  'ktchn10_sink',  's',  '2',  '1',  '1',  '1',  '0',  '0',  '3612',  '1',  '1',  '1',  '1',  '1',  'default',  '3',  '0',  ''
), (
'97423',  'ktchn10_stove',  'ktchn10_stove',  's',  '2',  '1',  '1.2',  '1',  '0',  '0',  '3581',  '1',  '1',  '1',  '1',  '1',  'default',  '2',  '0',  ''
), (
'97424',  'ktchn10_tea',  'ktchn10_tea',  's',  '1',  '1',  '1',  '1',  '0',  '0',  '3592',  '1',  '1',  '1',  '1',  '1',  'default',  '2',  '0',  ''
)
MySQL retourneerde: 

#1054 - Unknown column 'foot_figure' in 'field list'

His don't work:w00t:

 

[Adde]

SQL-query:

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` , `foot_figure` ) 
VALUES (

'97419',  'ktchn10_block',  'ktchn10_block',  's',  '1',  '1',  '1',  '1',  '0',  '0',  '3589',  '1',  '1',  '1',  '1',  '1',  'default',  '3',  '0',  ''
), (
'97420',  'ktchn10_cabnt',  'ktchn10_cabnt',  'i',  '1',  '1',  '1',  '1',  '0',  '0',  '4338',  '1',  '1',  '1',  '1',  '1',  'default',  '1',  '0',  ''
), (
'97421',  'ktchn10_pot',  'ktchn10_pot',  's',  '1',  '1',  '1',  '1',  '0',  '0',  '3580',  '1',  '1',  '1',  '1',  '1',  'default',  '2',  '0',  ''
), (
'97422',  'ktchn10_sink',  'ktchn10_sink',  's',  '2',  '1',  '1',  '1',  '0',  '0',  '3612',  '1',  '1',  '1',  '1',  '1',  'default',  '3',  '0',  ''
), (
'97423',  'ktchn10_stove',  'ktchn10_stove',  's',  '2',  '1',  '1.2',  '1',  '0',  '0',  '3581',  '1',  '1',  '1',  '1',  '1',  'default',  '2',  '0',  ''
), (
'97424',  'ktchn10_tea',  'ktchn10_tea',  's',  '1',  '1',  '1',  '1',  '0',  '0',  '3592',  '1',  '1',  '1',  '1',  '1',  'default',  '2',  '0',  ''
)
MySQL retourneerde: 

#1054 - Unknown column 'foot_figure' in 'field list'

His don't work:w00t:

It's because you dont have a column called foot_figure..
I'll release mine later that works good if u want.

 

[Rick3131]

But I can also Foot_figure Remove Column and it works?

 

[taylan]

go to furniture->struct->add foot_figure at type or delete foot_figure in the sql and the 0 for the foot_figure

 

[Sean]

Nice release, these are awesome, thank you.

 

[xxMandy]

can someone make cct's pleas :]