Create char query

Hi guys,

Is there any query allow me can create a new character without login into game client?

Thanks so much.

There are 4 tables, at least, which are linked to each other (FKs), which will need your attention.

Simply create a new character, call it something unique, like "pcmasterrace1". Create a query searching every table for that character name, corresponding ID (which you can take from the respective _Char table) and find all related tables.

Found all of em? The next step is making a final INSERT INTO query with some ez pz declaration and customization.

Quote:

Originally Posted by blapanda There are 4 tables, at least, which are linked to each other (FKs), which will need your attention. Simply create a new character, call it something unique, like "pcmasterrace1". Create a query searching every table for that character name, corresponding ID (which you can take from the respective _Char table) and find all related tables. Found all of em? The next step is making a final INSERT INTO query with some ez pz declaration and customization.

I use profiler of SQL server to listen query when char created but no success :( always getting error when exec _AddNewChar

One thing you could do is, doing something in the _AddNewChar so it can show up an error in SR_ShardManager and then you can just copy the line it was going to use to EXEC _AddNewChar and use it to create a new char.

TLDR; _AddNewChar

you can use this
[Only registered and activated users can see links. Click Here To Register...]

Quote:

Originally Posted by blapanda There are 4 tables, at least, which are linked to each other (FKs), which will need your attention. Simply create a new character, call it something unique, like "pcmasterrace1". Create a query searching every table for that character name, corresponding ID (which you can take from the respective _Char table) and find all related tables. Found all of em? The next step is making a final INSERT INTO query with some ez pz declaration and customization.

Quote:

Originally Posted by Alexiuns* you can use this [Only registered and activated users can see links. Click Here To Register...]

You saved my life, I don't know why I can't found this on google.

^
#Closed