Menu
Forums
All threads
Latest threads
New posts
Trending threads
New posts
Search forums
Trending
What's new
New posts
New profile posts
Latest activity
Members
Current visitors
New profile posts
Search profile posts
Upgrades
Log in
Register
What's new
Search
Search
Search titles only
By:
All threads
Latest threads
New posts
Trending threads
New posts
Search forums
Menu
Log in
Register
Navigation
Install the app
Install
More options
Contact us
Close Menu
Forums
Server Development
Habbo Retros
Habbo Releases
Furnidata parser for Plus-style DB
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="CosmoPeak" data-source="post: 386169" data-attributes="member: 68352"><p>After tirelessly entering furniture SQLs into the database by hand, I decided to create a quick program to generate basic SQLs for me.</p><p></p><p><strong>Features</strong></p><ul> <li data-xf-list-type="ul">Generates <strong>furniture </strong>and <strong>catalog_items </strong>SQL queries for PlusEMU's database structure</li> <li data-xf-list-type="ul">Generates the following:<ul> <li data-xf-list-type="ul">Item name</li> <li data-xf-list-type="ul">Public name</li> <li data-xf-list-type="ul">Width</li> <li data-xf-list-type="ul">Length</li> <li data-xf-list-type="ul">Can sit</li> <li data-xf-list-type="ul">Walkable</li> <li data-xf-list-type="ul">Beds</li> <li data-xf-list-type="ul">Catalog name</li> <li data-xf-list-type="ul">Catalog offer ID</li> </ul></li> </ul><p><strong>Notes</strong></p><ul> <li data-xf-list-type="ul"><strong>Not tested much!</strong></li> <li data-xf-list-type="ul">It does not generate anything else. Height, vending machines, etc still need extra configuration, but it does a lot of the work for you.</li> <li data-xf-list-type="ul">You will need to download/rip the SWFs yourself</li> <li data-xf-list-type="ul">Only works for floor items (there aren't many wall item releases, don't be so lazy!)</li> </ul><p><strong>Usage</strong></p><ol> <li data-xf-list-type="ol"><strong>Take a back up of your db - Just in case!</strong></li> <li data-xf-list-type="ol">Create a new folder</li> <li data-xf-list-type="ol">Download the jar</li> <li data-xf-list-type="ol">Download the latest furnidata.xml and productdata.txt from Habbo (or use your own)</li> <li data-xf-list-type="ol">Open command prompt/terminal</li> <li data-xf-list-type="ol">Navigate to your new folder</li> <li data-xf-list-type="ol">Run the command: java -jar FurniDataParser.jar <MIN ID> <MAX ID> <CATA PAGE ID><ul> <li data-xf-list-type="ul">MIN ID = The first ID of the furni line (I'd recommend doing 1 furni line/catalog page at a time)</li> <li data-xf-list-type="ul">MAX ID = The last ID of the furni line</li> <li data-xf-list-type="ul">CATA PAGE ID = The catalog page ID you want the furniture to go under</li> <li data-xf-list-type="ul">ex: `<strong>java -jar FurniDataParser.jar 9003 9048 whatever_page_id</strong>` for the new Olympic furni - You can see the item IDs in the furnidata.xml (eg. <furnitype id="9003" classname="olympics_c16_counter">...)</li> </ul></li> <li data-xf-list-type="ol">Copy the SQLs and run them on your database</li> </ol><p><strong>Download</strong></p><p><a href="http://www.mediafire.com/file/8q6gh8rba0l7e55/FurniDataParser.jar" target="_blank">http://www.mediafire.com/file/8q6gh8rba0l7e55/FurniDataParser.jar</a></p><p></p><p><strong>Source</strong></p><p>Probably messy, but it was a quick job and really isn't important.</p><p><a href="http://pastebin.com/4DY7RMGn" target="_blank">http://pastebin.com/4DY7RMGn</a></p></blockquote><p></p>
[QUOTE="CosmoPeak, post: 386169, member: 68352"] After tirelessly entering furniture SQLs into the database by hand, I decided to create a quick program to generate basic SQLs for me. [B]Features[/B] [LIST] [*]Generates [B]furniture [/B]and [B]catalog_items [/B]SQL queries for PlusEMU's database structure [*]Generates the following: [LIST] [*]Item name [*]Public name [*]Width [*]Length [*]Can sit [*]Walkable [*]Beds [*]Catalog name [*]Catalog offer ID [/LIST] [/LIST] [B]Notes[/B] [LIST] [*][B]Not tested much![/B] [*]It does not generate anything else. Height, vending machines, etc still need extra configuration, but it does a lot of the work for you. [*]You will need to download/rip the SWFs yourself [*]Only works for floor items (there aren't many wall item releases, don't be so lazy!) [/LIST] [B]Usage[/B] [LIST=1] [*][B]Take a back up of your db - Just in case![/B] [*]Create a new folder [*]Download the jar [*]Download the latest furnidata.xml and productdata.txt from Habbo (or use your own) [*]Open command prompt/terminal [*]Navigate to your new folder [*]Run the command: java -jar FurniDataParser.jar <MIN ID> <MAX ID> <CATA PAGE ID> [LIST] [*]MIN ID = The first ID of the furni line (I'd recommend doing 1 furni line/catalog page at a time) [*]MAX ID = The last ID of the furni line [*]CATA PAGE ID = The catalog page ID you want the furniture to go under [*]ex: `[B]java -jar FurniDataParser.jar 9003 9048 whatever_page_id[/B]` for the new Olympic furni - You can see the item IDs in the furnidata.xml (eg. <furnitype id="9003" classname="olympics_c16_counter">...) [/LIST] [*]Copy the SQLs and run them on your database [/LIST] [B]Download[/B] [URL]http://www.mediafire.com/file/8q6gh8rba0l7e55/FurniDataParser.jar[/URL] [B]Source[/B] Probably messy, but it was a quick job and really isn't important. [URL]http://pastebin.com/4DY7RMGn[/URL] [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
Server Development
Habbo Retros
Habbo Releases
Furnidata parser for Plus-style DB
Top