Search the Community
Showing results for tags 'rA to Herc'.
Found 1 result
-
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
