Roleplay help.

[Gerald]

Hey there, I'm making a RP. I'm currently trying to learn how to add customs and trying to find the room_ads sql and swf.

 

[JayC]

How To Add Furniture/Customs to your hotel:

- View your database structure for furniture/catalog_items

The database structure is the column names

This is what a R63 SQL is for a normal hotel: DO NOT USE THIS!!
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`) VALUES
(CODE 1 (8), 'SWF Name', 'SWF Name', 's', 1, 1, 1, '1', '0', '0', CODE 2 (8), '1', '1', '1', '1', '1', 'default', 4, '0');
INSERT INTO `catalog_items` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `cost_snow`, `amount`) VALUES
(CODE 1 (8), 'PAGE ID', 'CODE 1 (8)', 'Catalog Name', '0', '0', '0', '1');

All sqls start with INSERT INTO

next would be the table name (catalog_items or furniture)

So far we are at INSERT INTO `furniture` or INSERT INTO `catalog_items` (table names might be different)

then you label all of your column names

Like This:
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`)

Then put VALUES and in order you put the values of each of the columns IN ORDER.

VALUES
(CODE 1 (8), 'SWF Name', 'SWF Name', 's', 1, 1, 1, '1', '0', '0', CODE 2 (8), '1', '1', '1', '1', '1', 'default', 4, '0');

Giving you this:
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`) VALUES
(CODE 1 (8), 'SWF Name', 'SWF Name', 's', 1, 1, 1, '1', '0', '0', CODE 2 (8), '1', '1', '1', '1', '1', 'default', 4, '0');