[Help] Accounts & Chars Transfer

[lgpastana]

I use arcemu core, But I was wanting to switch to mangos ...

How could I transfer the accounts and the chars to mangos db...

Has some way to transfer without losing chares, itens and accounts ???

[hikikomori18]

try searching, there's already scripts and a few pdumps in this forum as well as many helpful threads that have all the info you need

[lgpastana]

try searching, there's already scripts and a few pdumps in this forum as well as many helpful threads that have all the info you need

my problem is the pass, what i need make for convert to mangos pass

[themegaman]

Does arcemu enrypt passwords in database? If yes, you have a problem, if they use another mechanism.

[Shin Darth]

i know that game masters in arcemu servers have not problems to know the players' password, so I think that it is not encrypted such as mangos

[kamir86]

if in arcemu pass is encrypted you can do a php script for password recovery. Request could be sent to user's mail with an ack link to complete che password recovery...

[vanguard]

If the passwords are not encrypted you can use this php function to convert them:

function sha_password($user,$pass){
 $user = strtoupper($user);
 $pass = strtoupper($pass);
 return SHA1($user.':'.$pass);
}

[brunogcar]

IF its not encrypted u can do that directly with mysql, no need to use php for that

it would be something like:

UPDATE `account` SET `sha_pass_hash`=SHA1(CONCAT(UPPER(`username`),':',UPPER(`sha_pass_hash`)));

if its encrypted and its not SHA1, forget it not possible AFAIK, u would to force ppl to reset passwords