Search the Community

Greetings, Regarding Hercules' almost demanding way of using text-based database files. Having developed mainly item and mobs in SQL on rAthena, is there's no swift way to import SQL queries to convert them to text? Because of that I have been working on the database conversion, which I have said in the past and you can find the information in this topic. Getting stuck on two aspects so far in (successfully) converting the databases if I have to stick with SQL due to the above not being (currently) possible: equip_locations at rA is set to mediumint(7) and at Herc to smallint(4), which prevents conversion due to certain values being out of range, at least as far as I've researched. ✓ Solved this one, had to use CHANGE instead of MODIFY and re-state the column name. The type of item where rA and Herc have opposite values for Weapon and Armor/Garment/Boots/Headgear/Accessory, updating the query to switch them yields either all weapons or all armor/etc. Is anyone able and willing to push me in the right direction? Naturally I'll publish the modifications I've done to jaBote's rA > Herc convertor when I get things are working the way it is intended to. Finally, I still haven't solved/received the answer I wanted from the topic I quoted above. It doesn't affect me or the server I'm working on, but it is for the sake of completion for the convertor for those who are affected by that specific table. Kind regards, Tranquility

File Name: Item DB Converter File Submitter: Jhedzkie File Submitted: 22 Nov 2013 File Category: Client Resources A tool that converts the old Athena item_db format to the new Hercules format. [instructions] 1. Select item_db.txt or item_db2.txt file to convert. 2. Press 'Process' button. 3. You may Copy-Paste the output to your existing item_db/2.conf or you may choose to save the output as a file. [Requirements] * .net Framework 4.0 Click here to download this file