Account transfers

[Helvis]

Hello people! I have a question for you.

How can I spread the character of the account to another?

Example: deleted account, the character remained. How do I set it to another account?

Sorry for bad English​

 

[chumpywumpy]

Just change the usernum to one from another account. Remember you must do the same with the char's quest data, inventory, skill slot data and anything else the char has in the db as well.

Character numbers are always usernum * 4. For example, if my usernum is 4 my chars are 32-37 (4 * 4 = 32).

 

[Helvis]

Thank you. How do I change usernum? When you try to change this value in database account / table cabal_auth_table - gives an error "cannot edit this cell"

I need to stop the server?

I use the default manager for MSSQL2000sp4



Sorry for bad English

 

[chumpywumpy]

Yes stop the server or do it with a query is you know query clanguage well enough.

update account.dbo.cabal_auth_table set usernum='new number' where usernum='old number'.

You need to change the characteridx not the usernum though as you are moving the char not the account

 

[Helvis]

I tried to do as you say, but the query analyzer that is issued:

Server: Msg 8102, Level 16, State 1, Line 1
Cannot update identity column 'usernum'.

Or do I have to do like this?

update gamedb.dbo.cabal_character_table set characteridx='new number' where characteridx='old number'

Sorry for bad English

 

[chumpywumpy]

As i said in my last post, you are updating the characteridx not the usernum to move the char, not the whole login account. You cannot change the usernum because it is a special type of column that numbers itself.

My example was a bad one as you mentioned cabal_auth_table, you need to run the query on characteridx in the cabal_character_table in the gamedb.

 

[Helvis]

How do I change characteridx all the necessary tables in one query?

.....


this clear.

How do I change usernum table cabal_warehouse_table? Or - to propose an alternative

 

[chumpywumpy]

You can't change them all with one query, you have to do them individually.

update gamedb.dbo.cabal_warehouse_table set usernum='new user' where usernum='old user'

 

[Helvis]

If this value exists - will be a duplication. How to do it with replacement strings?

Sorry for bad English

 

[chumpywumpy]

You can't as sql will not accept duplicates. You will have to tweak some values if an identical set of data exists.