create DRAGONKNIGHT for elitepvpers

[Haskoman]

Hi all so lets go add DRAGONKNIGHT IN DATABASE.



MERRY CHRISTMAS ALL


1 -first you need client have DRAGONKNIGHT + dekaron.exe for listen DRAGONKNIGHT

2- DATABASE

GO ADD [DEV]DRAGONKNIGHT in USER_CHARACTER

DEKARON7000001 [DEV]DRAGONKNIGHT 19999999999991 0 0 0 5000 0 0 169 69 5 4 2 6 349 129 349 129 150 150 0 0 1 7 0 0 0 0 0 0 2776 2 0 20050325 2008-05-31 01:13:15.060 2013-05-17 04:14:20.517 2013-05-17 04:13:59.947 2013-05-17 04:13:55.113 NULL 0 0 0 0 0 2 1 0 0 0 0 0 1 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1 1 0 NULL 0 0 0


3- DATABASE - SP_CHAR_CREATE


IN SP_CHAR_CREATE ADD THIS

-- Character Class Parsing
SELECT @char_gubun = CASE @v_byPCClass
WHEN 0 THEN 'A'
WHEN 1 THEN 'B'
WHEN 2 THEN 'C'
WHEN 3 THEN 'D'
WHEN 4 THEN 'E'
WHEN 5 THEN 'F'
WHEN 6 THEN 'G' -- ADDED BY TORRASKE FOR ALOKEN
WHEN 10 THEN 'H' -- ADDED BY TORRASKE FOR CONCENNA
WHEN 11 THEN 'I' -- ADDED BY TORRASKE FOR SEGU
WHEN 9 THEN 'J' -- ADDED BY TORRASKE FOR BLACK WIZARD
WHEN 12 THEN 'K' -- ADDED BY TORRASKE FOR HALF BAGI
WHEN 7 THEN 'L' -- ADDED BY haskoman FOR DRAGON KNIGHT
ELSE 'Z'
END

--// Setting Administrative_Code_Table's Name [ USER_CHARACTER_ClassCode ex) Knight -> USER_CHARACTER_A ]
SELECT @tab_nm = 'USER_CHARACTER' + '_' + @char_gubun
SELECT @regdate = SUBSTRING( CONVERT( VARCHAR(10), @ipt_time, 112 ), 1, 6 ) + '01'

-- Get Sequence Number
EXEC dbo.SP_COM_SEQNO @tab_nm, @regdate, @seq_no OUTPUT

IF (@seq_no < 1) -- Error (Has failed to generate a sequence number.)
BEGIN
--SELECT @sp_rtn = @seq_no
SELECT @sp_rtn = -1
RETURN
END

---------------------------------------------------------------------------------------------------------------------
-- Character Number Generation rules
-- Format [ CHAR(18) ] : Character Class [CHAR(1)] + YYMM [CHAR(4)] + SP_ID [CHAR(3)] + seq_no [ CHAR(10) ]
-- Character Class [CHAR(1)] : Knight(0)-'A', Hunter(1)-'B', Magician(2)-'C', Summoner(3)-'D',
-- Segnale(4)-'E', Warrior(5)-'F', Aloken(6)-'G'
---------------------------------------------------------------------------------------------------------------------
SELECT @m_date = SUBSTRING( CONVERT( VARCHAR(10), @ipt_time, 112 ), 3, 4 )
SELECT @character_no = @char_gubun + @m_date + @spid + dbo.FN_GetAutoNo(@seq_no, 10)

-- Generate Search Condtion
SELECT @rand_no = CAST( (3 * RAND()) + 1 AS INT)
-- SELECT @wh_char_no = 'DEKARON' + CAST( @v_byPCClass AS VARCHAR(1) ) + '000001'


IF @v_byPCClass <= 9
BEGIN
SET @wh_char_no = 'DEKARON'+CAST(@v_byPCClass as varchar(1))+'000001'
END
ELSE
BEGIN
if @v_byPCClass = 10
BEGIN
SET @wh_char_no = 'DEKARON'+'A'+'000001'
END
if @v_byPCClass = 11
BEGIN
SET @wh_char_no = 'DEKARON'+'B'+'000001'
END
if @v_byPCClass = 12
BEGIN
SET @wh_char_no = 'DEKARON'+'C'+'000001'

END
END

you have this error? you dont have enough play time

Go to USER_UPKEEPSTATUS -

And ADD DEKARON7000001

ADD Null in upt_time and you dont have more erreur

[Haskoman]

All is cristmas so help people to create server DRAGONKNIGHT

[Dezeiver]

Dekaron community is greedy community. Dont expect someone will share or help you much with that. This is correct database info with little tips from me, but since you cant understand basic things, i am 100% sure even with proper db you dont even know where or how to start with exe.

1. DEKAROND000001 --> DEKARON7000001

- dragon knight have pc class = 7, you already set it in table, why its 1 here then?

2. if @v_byPCClass = 7
BEGIN
SET @wh_char_no = 'DEKARON'+'D'+'000001'
END

- in hex 10 is A, 11 is B and so on, so why you added D for 7? 7 is 7, remove that lines.

If you correct this errors and somehow you get server+client exes you will end with "you dont have enough play time" error. I am leaving that error to you. Good luck

[Haskoman]

Thank you for your reply, yes I understand that they do not share everything I know I am still learning a can, thank you to you to have help understand my mistake, I'll try to see if I can with this if Advanced the result is positive I will share to the forum

1. DEKAROND000001 --> DEKARON0000007

And remove ligne

2. if @v_byPCClass = 7
BEGIN
SET @wh_char_no = 'DEKARON'+'D'+'000001'
END

so i have try and no good, so i have put DEKARON7000001 and good DRAGONKNIGHT as create thanks for your help man Merry cristmas Sorry for my english

you have this error? you dont have enough play time

Go to USER_UPKEEPSTATUS -

And ADD DEKARON7000001

ADD Null in upt_time and you dont have more erreur

[d0s3]

Fail thread