DRAGONKNIGHT error
-- 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 haskoman FOR DRAGON KNIGHT
WHEN 13 THEN 'L' -- ADDED BY TORRASKE 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', Knight(13)-'L'
---------------------------------------------------------------------------------------------------------------------
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()) + 2 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(2))+'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
share\pc\pcclass
class,0,1,2,3,4,5,6,9,10,11,12,13
size,1,1,1,1,1,2,1,1,1,1,2,1
name_eng,SWORDMAN,ARCHER,SORCER,SUMMON,SEGNALLE,WA RRIOR,ALLOKEN,WIZARD,CONCERRA,Segeuriper,HALFBAGI, DRAGONKNIGHT
I would like to modify Dragon Knight 13. T.T
Please help T.T
WHEN 13 THEN 'L' -- ADDED BY TORRASKE FOR DRAGON KNIGHT
class,0,1,2,3,4,5,6,9,10,11,12,> 13 <
name_eng,SWORDMAN,ARCHER,SORCER,SUMMON,SEGNALLE,WA RRIOR,ALLOKEN,WIZARD,CONCERRA,Segeuriper,HALFBAGI, > DRAGONKNIGHT <
 |
