create DRAGONKNIGHT for elitepvpers

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

Quote:

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

All is cristmas so help people to create server DRAGONKNIGHT

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

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

Fail thread :D