[Question]

[6shadow6]

I have a question for you. Regarding the addition of new characters.

I mean the frog in the SQL. Do you act in a similar way as when you add Aloken, I mean the character database. Table user_character, user_skill, user_slot, user_suit and strored procedure SP_CHAR_CREATE

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'
WHEN 7 THEN 'H'
WHEN 8 THEN 'I'


please answer.

[[DEV]DorianGray]

I don t understand exactly what you mean with your Question
but i think you mean this:


You can Use:

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'
WHEN 7 THEN 'H'
WHEN 8 THEN 'I'

or

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'
WHEN 10 THEN 'H'
WHEN 11 THEN 'I'

(Depending on which PCCLASS you use)
If your exe uses 0A and 0B you have them on class 10 & 11 !!
Concerra on Class 7 works fine for me :-)

and don t forget to add the [DEV]CONCERRA & [DEV]SEGEURIPER Chars
to you user_character.dbo

then it should work i think :-p

[6shadow6]

Thx Dorian i will try maybe i add this

If [DEV]Concerra = [DEV]Summoner then [DEV]Segnale = [DEV]SEGEURIPER