11 classes database

09/13/2013 03:28 occulttime#1
Hi Guyz!

I've created a Private server dekaron right now. In almost 3 weeks of decoding im still in great condition(im noob sorry). i just want to ask your knowledge about the 11 classes database coz im stock in here for the last 2 weeks. i cant find in my own solution(coz im noob in this) please could someone help me to do this. this is my last problem "11 classes database" so that i can up my server.

Could anyone know this please answer me. your response is a great help for me.
Thanks in advaced for those who have heart in game and also in me. Please need help!.

God bless
09/13/2013 04:01 Hesorio1u#2
please search omg
09/13/2013 04:13 occulttime#3
I already did. but icant find it. please help
09/13/2013 05:06 Zet ♔#4
Quote:
Originally Posted by zeusbigz View Post

try use this
Code:
Code:
DEKARON0000001  	[DEV]KNIGHT	19999999999991  0       0       0       999750040       0       0       1000    1000    6000    6000    6000    6000    336     363     336     366     7       7       0       4000    200     0       10      0       0       0       0       0       0       0       0       20050325        2008-05-31 01:13:15.060 NULL    2008-05-31 01:13:15.060 NULL    <Binary data>   0       0       0       0       0
DEKARON10000001 	[DEV]CONCERRA	19999999999991  0       0       0       999750040       0       0       1000    1000    6000    6000    6000    6000    354     146     354     146     7       7       0       4000    200     10      0       0       0       0       0       0       0       0       0       20050325        2008-05-31 01:13:15.000 NULL    2008-05-31 01:13:15.000 NULL    NULL    0       0       0       0       0
DEKARON1000001  	[DEV]HUNTER	19999999999991  0       0       0       999750040       0       0       1000    1000    6000    6000    6000    6000    336     215     336     216     7       7       0       4000    200     1       0       0       0       0       0       0       0       0       0       20050325        2008-05-31 01:13:15.060 NULL    2008-05-31 01:13:15.060 NULL    <Binary data>   0       0       0       0       0
DEKARON11000001 	[DEV]SEGURIPER	19999999999991  0       0       0       999750040       0       0       1000    1000    6000    6000    6000    6000    378     146     354     146     7       7       0       4000    200     11      0       0       0       0       0       0       0       0       0       20050325        2008-05-31 01:13:15.000 NULL    2008-05-31 01:13:15.000 NULL    NULL    0       0       0       0       0
DEKARON12000001 	[DEV]HALFBAGI	19999999999991  0       0       0       999750040       0       0       1000    1000    6000    6000    6000    6000    378     146     354     146     7       7       0       4000    200     12      0       0       0       0       0       0       0       0       0       20050325        2008-05-31 01:13:15.000 NULL    2008-05-31 01:13:15.000 NULL    NULL    0       0       0       0       0
DEKARON2000001  	[DEV]MAGICIAN	19999999999991  0       0       0       999750040       0       0       1000    1000    6000    6000    6000    6000    378     146     354     146     7       7       0       4000    200     2       0       0       0       0       0       0       0       0       0       20050325        2008-05-31 01:13:15.060 NULL    2008-05-31 01:13:15.060 NULL    <Binary data>   0       0       0       0       0
DEKARON3000001  	[DEV]SUMMONER	19999999999991  0       0       0       999750040       0       0       1000    1000    6000    6000    6000    6000    378     146     232     158     7       7       0       4000    200     3       117     0       0       0       0       0       0       0       0       20050325        2008-05-31 01:13:15.060 NULL    2008-05-31 01:13:15.060 NULL    <Binary data>   0       0       0       0       0
DEKARON4000001  	[DEV]SEGNALLE	19999999999991  0       0       0       999750040       0       0       1000    1000    6000    6000    6000    6000    378     146     354     146     7       7       0       4000    200     4       0       0       0       0       0       0       0       0       0       20050325        2008-05-31 01:13:15.060 NULL    2008-05-31 01:13:15.060 NULL    <Binary data>   0       0       0       0       0
DEKARON5000001  	[DEV]WARRIOR	19999999999991  0       0       0       999750040       0       0       1000    1000    6000    6000    6000    6000    378     146     354     146     7       7       0       4000    200     5       0       0       0       0       0       0       0       0       0       20050325        2008-05-31 01:13:15.060 NULL    2008-05-31 01:13:15.060 NULL    <Binary data>   0       0       0       0       0
DEKARON6000001  	[DEV]ALLOKEN	19999999999991  0       0       0       999750040       0       0       1000    1000    6000    6000    6000    6000    378     146     354     146     7       7       0       4000    200     6       0       0       0       0       0       0       0       0       0       20050325        2008-05-31 01:13:15.000 NULL    2008-05-31 01:13:15.000 NULL    NULL    0       0       0       0       0
DEKARON9000001  	[DEV]DARKWIZARD	19999999999991  0       0       0       999750040       0       0       1000    1000    6000    6000    6000    6000    378     146     354     146     7       7       0       4000    200     9       0       0       0       0       0       0       0       0       0       20050325        2008-05-31 01:13:15.000 NULL    2008-05-31 01:13:15.000 NULL    NULL    0       0       0       0       0
and in SP_CHAR_CREATE

Code:
Code:
	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 9 THEN 'J'
							WHEN 10 THEN 'K'
							WHEN 11 THEN 'L'
							WHEN 12 THEN 'M'
							ELSE 'Z'
						 END
	
	-- ???? ????? ?? (????_?????)
	SET @tab_nm = 'USER_CHARACTER'+'_'+@char_gubun
	SET @regdate = SUBSTRING(CONVERT(varchar(10),@ipt_time,112),1,6)+'01'
	
	-- ??? ???? ??
	EXEC sp_com_seqno @tab_nm, @regdate, @seq_no OUTPUT
	
	IF @seq_no < 1 			-- ???? ????
		BEGIN
			SET @sp_rtn = @seq_no
			RETURN
		END	
	
	-- character_no ??
	SET @m_date = SUBSTRING(CONVERT(varchar(10),@ipt_time,112),3,4)
	SET @character_no = @char_gubun + @m_date + @spid + dbo.FN_GetAutoNo(@seq_no,10)
Credits goes to zeusbigz.
09/13/2013 06:26 occulttime#5
Thanks :D

btw, why is it i cant learn skills on new char...HB,DW,segu,concera and aloken this is my last problem. can u please help me with this last question that i encounter now..

youre response is a great help to us.. Thanks

pleaes help me why I cant Learn skills on HB,DW,Segu,Concera and aloken... please!!!
09/13/2013 13:30 Zet ♔#6
Quote:
Originally Posted by occulttime View Post
Thanks :D

btw, why is it i cant learn skills on new char...HB,DW,segu,concera and aloken this is my last problem. can u please help me with this last question that i encounter now..

youre response is a great help to us.. Thanks

pleaes help me why I cant Learn skills on HB,DW,Segu,Concera and aloken... please!!!
Sorry i'm not familiar with skills yet, but i guess the problem could be in share/skill folder.. or share/item/itemetc.csv (where the skillbooks are located)

I think i saw a tutorial somewhere that explain how to add a skill to our client. Search it, it might help ya.
09/13/2013 16:13 conquer93#7
U cant learn the skills ? It does say the correct class in the skillbook? Are u using sephs 11 class exes? Do u even have skillpoints ? Are the levels of the books correct in the itemetc file and skillfile itself ? And if u got sephs exe u must use old weap namea and indexes in the files cus he didnt add new ones. Example concerra uses twin_sword in the skillfile