Item DB SQL

[DarkTakeshi]

I just recently made the switch from 3ceAM to rAthena. After figuring out some of the differences between the two, I was able to migrate all of my previous server data to the new emulator. My question is in regards to using a SQL item_db in rAthena. There are 2 SQL files, item_db.sql(old values) and item_db_re.sql(renewal values), but each creates a different table. Do both of these need to be uploaded and the server knows to either read item_db or item_db_re depending on the renewal option? Or do I just need to upload item_db_re and change the table name to item_db.

Thanks,

DT

[JoWei]

The server should detect which DB to read from the renewal.h settings. Rename shouldn't be needed.

[DarkTakeshi]

Thanks for the reply, I just wanted to grasp how how things worked in this matter. The map server looks for the regular item_db anyways and reports it missing, but it doesn't make any impact. This can be closed.

Thanks,

DT

Edited August 7, 2012 by DarkTakeshi

[zedrik04]

@DarkTakeshi

can you post what did you do on how to transfer from 3Ceam to rAthena?

Thanks.

[DarkTakeshi]

It's pretty simple really, for the most part rAthena and 3ceAM SQL tables are compatible with eachother. Just set up a fresh rAthena directory using the latest SVN and manually import any custom content you have added. You may want to search around the forums a bit for more information, there are some values in the SQL database that are different in rAthena. For example, the login table uses "group_id" rather than "level" to determine the GM level of the account.