Moving Vsro accounts to Tsro.

04/13/2013 09:00 keppel22#1
Hello, Epvp.

I wonder if I can pass the accounts of my old server to my new server?
I will explain better.
I changed my server from VSRO to TSRO, but would like to keep all the accounts created by players from my previous server.
I can do that?
any help? :confused:
04/13/2013 10:27 flozz#2
Quote:
Originally Posted by keppel22 View Post
Hello, Epvp.

I wonder if I can pass the accounts of my old server to my new server?
I will explain better.
I changed my server from VSRO to TSRO, but would like to keep all the accounts created by players from my previous server.
I can do that?
any help? :confused:
Only accounts or chars too?
04/13/2013 18:23 keppel22#3
Both Accounts and chars.. :D
04/13/2013 18:33 neisser1#4
also I have the same question. Possible?
04/13/2013 20:26 A new hope#5
It's possible, not that hard, but takes a few hours.
04/13/2013 20:41 Kape7#6
It's complicated, specially with the items, I think the TSRO and VSRO item IDs doesn't match.
04/13/2013 20:47 ZiCo*#7
Quote:
Originally Posted by A new hope View Post
It's possible, not that hard, but takes a few hours.
I think you never had a close look.
04/13/2013 21:03 A new hope#8
Quote:
Originally Posted by Synx7 View Post
It's complicated, specially with the items, I think the TSRO and VSRO item IDs doesn't match.
can be done with a simple query.
04/14/2013 00:25 royalblade#9
Yeah its actually not difficult at all :p

Hit me up on skype:Akasch93;

PS: Inside the CSRO db theres a stored procedure to move accounts,chars,items etc. It might be useable to a certain extent.
04/14/2013 11:19 IceAmStiel#10
Difficulty depends on whether the TSRO DB contains valid characters or not. If it's a clean database you want to move the accounts + characters to, it won't be time-consuming at all.
But if it does contain characters and accounts you want to keep, you'd have to loop through the vsro.dbo._Items table until the MAX(ID64) of tsro.dbo._Items is reached (afterwards identity insert), check if the RefItemID has the same CodeName128 at both databases, recreate the Item in the tsro.dbo._Items table and replace the old ID64 with the new ID64 at the vsro DB.

First case can be theoretically accomplished manually, second one definitely not. But if you once finished a proper procedure for the second case that does the job right, you will only have to wait until the (usually) millions of records of _Items got ran through.
04/14/2013 18:52 neisser1#11
and change the account + the char?, any item, guild nothing but char + lvl?