Retired
- Joined
- Apr 15, 2015
- Messages
- 715
- Reaction score
- 238
How to add furniture to your hotel?
The most common questions that are asked daily by members is "how do i add furni?", therefore I will be doing a detailed tutorial for you guys so you have the chance to make your own custom catalogue that you've always wanted to do, many cata's do not get released due to people keeping it private as after all that's one way to be different from the rest.
Note: This tool was created by @Spot Ify , so credits go to him.
Original Thread
In this tutorial I will be using a tool called "Automatic Furni Fixer", this tool is by far one of the best tools I've personally used because of the features it includes, it does everything for you such as generates the SQL, rips the furnidata from the specific link that you have inserted into the configuration file which I will explain below and can remove/add graphictags which is needed for r63b versions.
Requirements:
- Notepad ++ (Optional)
- Automatic Furni Fixer tool (
You must be registered to see links
)- Knowledge on how to use navicat.
Once you have the tool downloaded the last thing that you will need is the actual swfs that you want adding to your retro, when you have the swfs then you have the green light to proceed with the tutorial. Now lets begin....
Step 1 (Editing the configuration file)
Open up the tool folder and then go to your config file which is located in the settings folder.
Once you have located the file open up the config file and it will look like this...
Ok, now once your in your config file you will need to do some editing as this is the heart of the tool, it needs to be correct or it wont work and you will bump into problems.
Before editing have a good look before you do as you can get a some knowledge on whats happening.
DefaultCatalogItem= (This will be your catalog_items database structure, you will need to make sure this is correct. It's simple enough as you will just need to copy your table structure.)
DefaultCatalogFurniture= ( This is the same as above but instead it will be your other table which would be furniture table, same again copy the structure of that table and paste it there.)
HabboFurnidataXMLURL= (Copy this link -
You must be registered to see links
)HabboHofFurniURL= (Copy this link -
You must be registered to see links
)Ok, for these three what I normally do is get the last id in the furniture and items tables because having it the same id will make it a lot more easier to understand. so for example if my last id number in the furniture table was 2100 and the last id in the items table was 2120, I would put the id as 2122, to see if the id is in use you can just go in your furnidata and type the id and if it doesn't exist then your good. As you see from the image above my numbers are all the same.
StartCatalogItemID=
StartFurnitureID= [Read above to see how to set these three]
StartBaseID=
Step 2 (Generating the SQL and Furnidata)
Now that your config file is all setup correctly everything else will be straight forward and simple. So now you will need to move your swf's to the right place so it can generate everything that's needed.
Move your swfs that your adding into the 'furni' folder, to find this go to the 'sql' folder and then place the swfs inside the 'furni' folder.
Step 3
Once you have shoved the swfs inside the 'furni' folder its time to open up the CF_Fixer application. Once you have opened it, it will look like this...
As you see it displays all the commands that you can type, as we have moved the swfs to the 'furni' folder we have to generate the SQL and Furnidata, so if it isn't obvious already simply type 'generate' in the application, Now watch the magic happen.
Now as you can see it has generated everything such as the furnidata and the SQL, you can see it has made a txt file which will have this data in. To find the file you will need to go to the 'sql' folder and when you enter that folder you will see that there is a txt file, that's what we need!
Now open up the generated txt file and you will see it looks like this....
The table structure will look different of course as it depends what emulator your using, but its very similar.
Now you have everything that you need, just make sure you have a look in the txt file and make sure everything is correct. If you scroll down you will see that it has the xml furnidata and right at the bottom it will have the old furnidata that you need if you're using r63 and older versions.
Step 4 (Adding the SQL and Furnidata to your hotel)
This will be easy, all you need to do now is copy the sql that has been generated and run it in your database, like so..
When you have inserted the sql, its time to add the furnidata to your furnidata file, Now if your using r63b it can be different to r63 as it has to be in the right place, for azure the wall items was at the bottom and the floor items was at top. I wont be able to show you what i mean but its very straight forward, to find this out just explore in the furnidata file and check if walls are at bottom etc.
For r63 its simple, just copy and paste it. Should have no issues, if the furnidata is wrong then you will need to edit it in the same location as the config file.
Using Revision folders? Its simple, <revision></revision> all you will need to do is put the number that the swfs are gonna be in when you put them in your dcr, hof_furni folder.
Step 5 (Finishing touches)
You are pretty much done, all you need to do now is edit the new sql that u inserted into your tables and make sure they have the correct height, width etc. But before doing that when you enter your hotel type the commands such as 'refresh_catalogue' or whatever the command is on your emulator that you're using. Once you have refreshed the cata you will just need to clear your cache and hop back on and it should be there.
If I've missed something or haven't explain something correctly then please let me know, you can simply send me a private message and tell me. I hope this helped you guys.
Last edited by a moderator:
