SQL Creating

[Mortzoo]

Hi DevBest.

Could anyone learn me how to do SQLs for furni?

Thanks!

 

[Zymf]

Depends entirely on what you want to do?

 

[Mortzoo]

Custom furnis.

 

[Zymf]

CATALOG_ITEMS

INSERT INTO `catalog_items` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `cost_snow`, `amount`, `vip`) VALUES
({id here}, {page_id here}, '{item_ids here}', '{name in catalog here}', {Credit cost here}, {pixel cost here}, {cost_snow here}, {amount here}, '{vip 0 = no 1 = yes here}');

FURNITURE

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`) VALUES
(651137051, 'namelol', 'namenamename', 's', 1, 1, 0.01, '0', '0', '0', 651137051, '1', '1', '1', '1', '1', 'default', 1, '0', '0');

For the first one you need to edit everything within the { }'s, for the second one I didn't bother adding them as it's the same thing but make sure you edit all of the figures.

It's all in order, for example:
(`id`, `public_name`, etc)
VALUES (`102390123 (the id)`, `publicnamehere`, etc)

//EDIT//
That's if your database has that structure.

 

[Mortzoo]

Thanks!