Create char query

[vietnguyen09]

Hi guys,

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

Thanks so much.

[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.

[vietnguyen09]

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

[AceSpace]

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

[KingDollar]

you can use this

[vietnguyen09]

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.

Originally Posted by Alexiuns*

you can use this

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

[Spidy.]

^
#Closed