- Joined
- Apr 27, 2008
- Messages
- 330
- Reaction score
- 370
Automatic Furni SQL gen for Arcturus/Comet/Plus [Java]
Hi,
I 've coded automatic furniture sql generator for Arcturus/Comet/Plus emulator. Coded this few years ago with PHP but it was sloww but few days ago created Java version of it.
Features:
-------
- Automatic furnidata, missing swfs and icons downloader
- Compares furnidata.xml and hotel database and generate SQL for missing furnis
- Sets furni dimensions, height, modes count and interaction type automaticly
- Two methods to generate catalog deffs: all to one page or auto create catalog page for furniline.
Version 2:
- Support to Comet and Plus emulator database structures
- Ability run queries directly to database
- Ability set custom domain name, furnidata.xml, hof_furni path..
Usage:
--------------------
1. Open config file:
- Fill database details
- Change hotel.locale if you want
- Change export.create.catalogpages.auto from 0 to 1 if you want auto create pages for furnilines. export.catalog.pageid skipped if value is 1.
- Change export.autocreator.parentid to category where you want auto
- If you want all items to same page set export.catalog.pageid one catalogpage id and set export.create.catalogpages.auto to 0.
2. Click run.bat and wait.
3. Generated SQL on exports folder. And swfs + icons in swfs folder.
Download:
Compiled:
Source:
CATALOG_PAGES TABLE MUST USE AUTO_INCREMENT IF YOU WANT AUTO PAGE ADD!
Run this before importing Comet furni sql:
Please report to me if something fails! Tested only Comet and Plus sql queries import. Not with emulator.
Hi,
I 've coded automatic furniture sql generator for Arcturus/Comet/Plus emulator. Coded this few years ago with PHP but it was sloww but few days ago created Java version of it.
Features:
-------
- Automatic furnidata, missing swfs and icons downloader
- Compares furnidata.xml and hotel database and generate SQL for missing furnis
- Sets furni dimensions, height, modes count and interaction type automaticly
- Two methods to generate catalog deffs: all to one page or auto create catalog page for furniline.
Version 2:
- Support to Comet and Plus emulator database structures
- Ability run queries directly to database
- Ability set custom domain name, furnidata.xml, hof_furni path..
Usage:
--------------------
1. Open config file:
- Fill database details
- Change hotel.locale if you want
- Change export.create.catalogpages.auto from 0 to 1 if you want auto create pages for furnilines. export.catalog.pageid skipped if value is 1.
- Change export.autocreator.parentid to category where you want auto
- If you want all items to same page set export.catalog.pageid one catalogpage id and set export.create.catalogpages.auto to 0.
2. Click run.bat and wait.
3. Generated SQL on exports folder. And swfs + icons in swfs folder.
Download:
Compiled:
You must be registered to see links
Source:
You must be registered to see links
CATALOG_PAGES TABLE MUST USE AUTO_INCREMENT IF YOU WANT AUTO PAGE ADD!
Run this before importing Comet furni sql:
Strict SQL mode can cause errors when using auto import feature.DROP INDEX item_name ON furniture;
Please report to me if something fails! Tested only Comet and Plus sql queries import. Not with emulator.
Attachments
You must be registered for see attachments list
Last edited: