**I'm currently working on this. It can break your furni so don't use it yet**
I used Nitro v2 and Arcturus database for this so it might not work for everyone or you might have to change some things
What is included? -Translate FurnitureData.json with any furnidata.xml
-Generate ProductData.json from FurnitureData.json
-Upload Furni names to catalog_name field in catalog_items table in database (possibility to use classnames too)
-Upload Furni names to public_name field in items_base table in database (possibility to use classnames too)
What is this?
With this you can translate your furni / FurnitureData.json / ProductData.json / catalog_items / items_base to any language if you have the furnidata.xml of the desired language.
This doesn't translate custom furni.
It replaces the names and descriptions from your FurnitureData.json with the names and descriptions from the furnidata.xml if the ids are matching. Therefore it doesn't delete anything from your FurnitureData.json.
Then you can generate a ProductData.json from the newly translated FurnitureData.json.
After that, running the php files will put the translations into the catalog_name of catalog_items and the public_name of items_base. If you have a different database than Arcturus you might have to change some tables in the code.
How to use it
Put the FurniTranslator folder somewhere on your server where you can access it with your browser.
After you have the furnidata.xml put the furnidata.xml and your FurnitureData.json in the FurniTranslator folder and run the FurnitureDataTranslator.py.
You will get a new file named FurnitureData_new that is translated.
Once that is complete rename your FurnitureData_new.json to FurnitureData.json.
Then run the ProductDataGenerator.py to generate a new ProductData.json.
Copy the new FurnitureData.json and ProductData.json into your nitro-assets/gamedata folder (create a backup of your old files before).
Close your emulator at this point, just to make sure it will actually update the database.
Open items_base.php and catalog_items.php in an editor such as notepad++ and change your (user,) database and password.
Save the files and open items_base.php in your browser (for example: https://your-hotel.domain/FurniTrans...items_base.php. It has to be on your server for it to work.
After that is complete you can open catalog_items.php in your browser. That might take ~5 minutes.
Once it stops you should be done and your furni and catalog should be translated!
Troubleshooting If you get a cloudflare timeout then use your IP instead of your domain.
If you get a FastCGI timeout error you have to increase activityTimeout. In IIS it's in IIS Manager => FastCGI settings.
Additional stuff (optional)
Edit: I also added now the possibility for you to put classnames instead of furni names into the catalog_name and public_name of your database. In that case use the php files in the classname folder instead of the ones in the main folder. You would have to move the FurnitureData.json to that folder then aswell. Else if you don't want to use classnames you don't need to pay attention to that folder.
I hope this helps so that people don't have to pay people for overpriced translations or catalogs anymore.
Have fun :D
Last edited by giu888; 1 Week Ago at 05:11 PM.
Reason: Added the possibility to use classnames