[Question]

01/13/2012 17:06 6shadow6#1
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.
01/15/2012 00:53 [DEV]DorianGray#2
I don t understand exactly what you mean with your Question :D
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
01/15/2012 01:42 6shadow6#3
Thx Dorian i will try maybe i add this :)

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