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.
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.
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
You saved my life, I don't know why I can't found this on google.
[RELEASE] Query to create a new non-player character (NPC) + shop 07/31/2015 - SRO PServer Guides & Releases - 8 Replies Hello,
i decided to release a part of my "create a new non-player character" query
till now i was too lazy to create comments and print messages and i also removed "create npc tab", "create npc group", "item mall support", "client support (export client files from sql)"
anyway here we go
/**
[QUERY] Create Instance / Dungeons 05/18/2015 - SRO PServer Guides & Releases - 35 Replies I rarely ever release shit. But hey, let's see how you guys make this work ;)
It's pretty simple actually and doesn't require much knowledge or work, however, it's still something that almost nobody can do properly.
Wrote this query when I was being lazy and didnt wanna do shit. I never tested it and never completed it.. BUT its gives you the basic idea of how dungeons and instances work.
Just so you know, the query probably doesnt work since I was under heavy alcohol abuse when i...
[SQL] Query to create HwanLevels in 3 seconds 04/29/2013 - SRO PServer Guides & Releases - 3 Replies so i made this quickly cuz i had to make some zerk levels.
its done pretty badly actually xD
however it works (it has a shitload of unnessesary code but who gives a shit)
Declare @1 varchar(max)
declare @2 varchar(max)
declare @3 varchar(max)
declare @4 varchar(max)
declare @5 int
Sql query for create character got lv 170 02/04/2012 - Dekaron Private Server - 21 Replies stop saying nonsense words to me , i need help with sql query of create new character and login game got lv 170 .
always getting error when exec _AddNewChar
