+- LCKB (https://lckb.dev/forum)
+-- Forum: ** OLD LCKB DATABASE ** (https://lckb.dev/forum/forumdisplay.php?fid=109)
+--- Forum: Guides & Help Section (https://lckb.dev/forum/forumdisplay.php?fid=193)
+---- Forum: Help & Support (https://lckb.dev/forum/forumdisplay.php?fid=157)
+----- Forum: Ep3 Support (https://lckb.dev/forum/forumdisplay.php?fid=150)
+------ Forum: Solved topics (https://lckb.dev/forum/forumdisplay.php?fid=151)
+------ Thread: Transfer accounts and characters to ep3? (/showthread.php?tid=2610)
- Walletman987 - 12-13-2013
I was wondering how I could transfer all of the accounts from my ep2 server to the ep3 server Im making? Is there anyway to do this?
Thanks in advance,
Walletman987
- kixtzz - 12-13-2013
i think u just need to look in all tables if have the same column and then u paste ur table from db ep2, and be careful to edit the newproject_data
u can use this SQL code i think its will work
INSERT INTO tableEP3 (SELECT * FROM tableEP2 WHERE condition)
/*or*/
INSERT INTO tableEP3 (SELECT * FROM tableEP2)
- Gambit - 12-13-2013
simply transfer bg_user, and open its design, rename truepasswd to passwd, and delete original passwd which has the sha256.....
Then run this query
UPDATE bg_user SET passwd = MD5(passwd);
It will convert all normal passwords into md5
- camaro2683 - 12-13-2013
so will the db and db_auth from ep2 work on ep3
- Gambit - 12-13-2013
they should, just check the design table for missing columns etc.
I know ep3 bg_user is smaller than the ep2 so that isnt an issue, my t_characters fromep2 work on ep3 but not sure if its missing columns
- camaro2683 - 12-13-2013
@2 what about the items that characters have in the inventorys and the storekeeper bianca wherehouse is that transferable too?
- Wrong - 12-13-2013
I think you can transfer all items without a problem except gold that is now in t_characters and a_nas field
- Gambit - 12-16-2013
Hi.
As you got your answer, and your problem is solved, I am gonna move that topic to Solved section and mark it as solved.
Thanks,
-LCKB Staff