Switching 3ceam to Rathena

[kickazz08]

Hi guys.. i want to switch my 3ceam to Rathena..

but there is a problem..

1: How do i transfer my 3ceam Database to Rathena...???

ive tried to restore database and put it into Rathena.. but to no avail..

if somebody can help me on this one..

[Jezu]

its not so hard to merge on rAthena..

1. Go to your SQL > Ragnarok database

2. find `login` table

3. on `login` table, change the `level` to `group_id`

import some sql updates on your rathena/sql-files folder

done ~

Edited August 20, 2012 by Jezu

[madtoyz]

is it the switching is successful without affecting the player database?

[Aleos]

The only SQL commands you should have to run are these two:

UPDATE `global_reg_value` SET `str` = 'jobchange_level_3rd' WHERE `str` = 'jobchange_level2';
DROP TABLE `skillcooldown`;

The rest of the stuff can be found in sql-files/updates. After that going straight from 3CeAM to rAthena works just fine.

[madtoyz]

its mean doesnt effected error on players database ?

[Mystery]

its mean doesnt effected error on players database ?

I highly recommend you BACKUP your files anyways. ALWAYS ALWAYS backup your files especially doing a major switch.. you never know what might happen. Following up to what Aleos has mentioned, follow what he has said and you'll be fine. Go to the updates folder: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk/sql-files/upgrades/ and upgrade your SQL with those files.. but again, BACKUP prior to doing any upgrading.

The only SQL commands you should have to run are these two:

UPDATE `global_reg_value` SET `str` = 'jobchange_level_3rd' WHERE `str` = 'jobchange_level2';
DROP TABLE `skillcooldown`;

The rest of the stuff can be found in sql-files/updates. After that going straight from 3CeAM to rAthena works just fine.

[madtoyz]

thanks for the information and i'll do the stuff