Tranquility

Yes I am aware of it, seeing that I have the following query prepared: ALTER TABLE `item_db` MODIFY `price_buy` MEDIUMINT(10) DEFAULT NULL, MODIFY `price_sell` MEDIUMINT(10) DEFAULT NULL, MODIFY `weight` smallint(5) UNSIGNED DEFAULT NULL, CHANGE `attack` `atk` SMALLINT(5) UNSIGNED DEFAULT NULL, ADD `matk` smallint(5) UNSIGNED DEFAULT NULL AFTER `atk`, MODIFY `equip_jobs` int(12) UNSIGNED DEFAULT NULL, MODIFY `equip_upper` tinyint(8) UNSIGNED DEFAULT NULL, MODIFY `equip_genders` tinyint(2) UNSIGNED DEFAULT NULL, CHANGE `equip_locations` `equip_locations` smallint(4) UNSIGNED DEFAULT NULL; MODIFY `weapon_level` tinyint(2) UNSIGNED DEFAULT NULL, CHANGE `equip_level` `equip_level_min` smallint(5) UNSIGNED DEFAULT NULL, ADD `equip_level_max` smallint(5) UNSIGNED DEFAULT NULL AFTER `equip_level_min`, MODIFY `view` smallint(3) UNSIGNED DEFAULT NULL, ADD `bindonequip` tinyint(1) UNSIGNED DEFAULT NULL, ADD `buyingstore` tinyint(1) UNSIGNED DEFAULT NULL, ADD `delay` mediumint(9) UNSIGNED DEFAULT NULL, ADD `trade_flag` smallint(4) UNSIGNED DEFAULT NULL, ADD `trade_group` smallint(3) UNSIGNED DEFAULT NULL, ADD `nouse_flag` smallint(4) UNSIGNED DEFAULT NULL, ADD `nouse_group` smallint(4) UNSIGNED DEFAULT NULL, ADD `stack_amount` mediumint(6) UNSIGNED DEFAULT NULL, ADD `stack_flag` tinyint(2) UNSIGNED DEFAULT NULL, ADD `sprite` mediumint(6) UNSIGNED DEFAULT NULL; There are indeed quite some differences and it amazes me, because it's focussed around the same game. However, since Herc seems to be a tad bit more up-to-date with clients and have a plugin system, they now have a slight preferrence. Which is why this conversion tool has to be upgraded and modified accordingly.

1) Had to use CHANGE instead of MODIFY and re-state the column name. 2) Ended up a bit problematic for me, but the following did work (so far): UPDATE item_db2 SET type = CASE WHEN type = 4 THEN 5 WHEN type = 5 THEN 4 ELSE type END Basically changing your INSERT INTO > UPDATE. When trying with REPLACE INTO it'll create NULL'd fields for the other columns. Thanks for the insight to the solution! EDIT: Once I've updated rA and Herc again I'll double-check all the data & fields for conversion and aks for feedback here. Since the idea is to maintain the current database, I'd like the process to go smooth for other persons interested in doing the emulator conversion.

In that case I'll have to duplicate my item_db / item_db2 first to be able to apply this method I guess. And I'll have to think of something not to erase the existing data in the other columns. I'll give this a try again this way soon, thanks.

Yes something like that is what I came up with, however, since it doesn't store the variables, it'll end up with the same values after the query. Since 4 > 5 and then afterwards 5 > 4 again, resulting in a loop. Which is why I was looking for a way to store it in a table or array so they could be converted individually. Since I'm not an expert on this and (re-)learn programming and database management from the start all over again I fail to correct my mistakes so far. Thanks for the effort though, you're thinking in the right direction!

In my attempt to gain a grasp on SQL a question arrised. Is it possible to store all values of a certain column in an array or table, which then can be converted accordingly to the right values for the type of items? If it is, how can I achieve this? Because that would almost finalise the issues I have so far (exception being shadow gears).

After some more searching using a few search engines I'm still stuck with this issue. I admit my knowledge on SQL manipulation is very basic, but a push in the right direction is appreciated. Not expecting the whole solution to be brought to me, but if that's done anyhow, it'll be appreciated. Thus shameless bump.

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

In that case, there's data in market that might need to be transferred: rAthena's market table: CREATE TABLE IF NOT EXISTS `market` ( `name` varchar(32) NOT NULL DEFAULT '', `nameid` SMALLINT(5) UNSIGNED NOT NULL, `price` INT(11) UNSIGNED NOT NULL, `amount` SMALLINT(5) UNSIGNED NOT NULL, `flag` TINYINT(2) UNSIGNED NOT NULL DEFAULT '0', PRIMARY KEY (`name`,`nameid`)) ENGINE = MyISAM; Hercules' npc_market_data table: CREATE TABLE IF NOT EXISTS `npc_market_data` ( `name` VARCHAR(24) NOT NULL DEFAULT '', `itemid` INT(11) UNSIGNED NOT NULL DEFAULT '0', `amount` INT(11) UNSIGNED NOT NULL DEFAULT '0', PRIMARY KEY (`name`,`itemid`)) ENGINE=MyISAM; The question will be then, is it used for similar purposes (which I assume it does), or will a simple drop table suffice? Merely asking for future orientation of the convertor and since I don't personally need it, might be a little bit redundant currently =P Thanks again for the swift reply!

Hello everyone, I'm currently revising jaBote's rAthena > Hercules (main) database convertor and so far I've got it working without any errors. However, I was wondering something about the rAthena table market, can we just drop it, or does it's data need to be migrated to an existing Hercules table? I noticed my own server doesn't have the table (probably since it's recently added in the updates), but I am just wondering since I'm revising the current convertor anyway. Thanks in advance, Tranquility

This still is slightly confusing to me as I'm attempting the same. What do you mean with "login-server" and which part of the database did you modify? According to the slightly outdated database convertor, several tables have to be modified to achieve the desired result. However, that version doesn't work (properly) anymore, of which I already notified jaBote about. If you have an elaborate description, I'm willing to look into making this easier to be applied for future usage as more people might be interested in migrating from rAthena>Hercules. Thanks in advance.

You might need the file: ½ºÅ²Á¦À۸Ŵº¾ó.txt (probably could just make an empty text file named like that, if not see attachment) And/or replace your skin folder with a working one. I thought that was the issue with NickyZai's corrupt download. ½ºÅ²Á¦À۸Ŵº¾ó.txt

Got it working now. I've tried 3998 and it worked. I suppose your suggestion would work as well. Thanks for letting me know the maximum range is 3999. But I wonder why I can't use 25000 as you and @@Dastgir have mentioned. Thanks for your help <3Its for extremely new clients 2014-10++And currently source doesn't support 25000 mob id,thus you cannot use it xD Im using 2013-08-07 it's work the same way ? Yes it does, I use 2013-08-07 too and have a similar setup.

Yes, I have done the server side configs as well and used weemapcache to update my mapcache.dat I found that there are some .rsm files that have this error Are those from the new Prontera? Or the custom map you're referring to? Kindly contact the creator of that program with the exception error, which you can copy with the lower left button. It probably has issues reading the file, but shouldn't affect you in-game. Personally I remove my old mapcache.dat files and recreate it through recompiling/opening mapcache.dat. Make sure you've added the right GRF and data folder paths in your configuration files.

Have you rebuild your mapcache and added it the appropriate manner in your server files? Couldn't directly find a Hercules source, but do it accordingly to this: https://rathena.org/wiki/Custom_Maps#Adding_Custom_Maps Use mapcache.exe and/or recompile server after backing up mapcache.dat in your database (db) directory and renaming/removing it.

Yes it's possible. In Browedit, create a new map with the dimensions you want it to have. Lets say you had 100x100 and now you want it to be 150x150, you'll create a new map with that size. Next you open the original map of 100x100, you can then select the whole map after pressing F2 (just drag from top-left to lower right). You might want to use View > Top Camera for this to make it easier. To reduce the strain, you can toggle lightmaps and objects by pressing "l" and "o". Then press CTRL + C to copy (you should see the map 'stuck' to your mouse movements), TAB to your other map and then place it on the right spot accordingly. Instead of click dragging just hit f2 and then hit ctrl + a then ctrl + c then tab over to the new larger sized map and place it. But this was answered by me on the other forums regardless. Just thought id also let you know ctrl + a is easier. =] Thanks, it is easier

Yes it's possible. In Browedit, create a new map with the dimensions you want it to have. Lets say you had 100x100 and now you want it to be 150x150, you'll create a new map with that size. Next you open the original map of 100x100, you can then select the whole map after pressing F2 (just drag from top-left to lower right). You might want to use View > Top Camera for this to make it easier. To reduce the strain, you can toggle lightmaps and objects by pressing "l" and "o". Then press CTRL + C to copy (you should see the map 'stuck' to your mouse movements), TAB to your other map and then place it on the right spot accordingly.

Don't change your mobID from 3500 in your mob_db2. Change your clientside files, namely the NPCIdentity.lua mob_db2.txt3500,ADDAX,ADDAX,ADDAX,1,50,0,2,1,1,7,10,0,5,1,1,1,1,6,30,10,12,1,3,21,0x131,400,1872,672,480,0,0,0,0,0,0,0,909,7000,1202,100,938,400,512,1000,713,1500,741,5,619,20,0,0,0,0,4001,20 NPCIdentity.lubJT_ADDAX = 3500 jobname.lub[jobtbl.JT_ADDAX] = "ADDAX"

He mentioned that your client and server side ID's don't match. Looking at your NPCidentity.lua you see that the number there isn't equal to what you have in mob_db2. Change the value in your lua files to what you have in your mob_db2. The maximum mob_id you can use is 3999 from your current range, if you need more ID's, you'll need to continue from 25000

With the latest Maxwell GPU's you have this issue. I have come across this too and the few workarounds that are available don't work for me any more. One thing that does work, but doesn't enhance the graphical quality is using /lightmap but all the textures and sprites are still horrible compared to your previous graphic card. If your client crashes on full-screen notifications/programs, then the following won't work: - Enable/Use the UAC pop-up with screen dimming to refresh your client's interface, just open your game client a second time and press no instead of yes. - Lock windows and log back in (Windows + L), same effect as above. If you client crashes, it doesn't work for it. Previously I was able to do it with my client that way, but that suddenly stopped for some reason. Could be driver update or an alteration to the client. A thorough solution for this issue with new graphic cards has yet to be found, even on the iRO forums no real solution is given and people downgraded their hardware to play RO decently again (quite silly). EDIT: Forgot to mention, enable NVidia's Shadowplay before you launch the client if the above doesn't work, that helped me a little, but still isn't as it previously was.

Temporary disable avast or add an exception for the folder you're creating clients in.

it's all right, however I'm having this error, what might be happening? It means that specific file cannot be found in any of your data files, whether it is a grf file or data folder. Try looking at the translation project and get the full-data folder with all required files. If you're using custom files pointing towards that file, make sure it's named correctly.

I've been working with 2012 and 2013 clients and both work. Just be sure to strictly follow the guides for adding mobs and to make sure that your lua files are working well. If the monster works server-side, it's purely client side (jobname.lua/lub and npcidentity.lua/lub) that will cause an issue. Since it works in 2012 client for you I think the fault is in the lua-files.