[Help] How to add new char to database

12/01/2012 19:14 AntiHackPrivate#1
Hi all.
I have a problem of database A12. (11PCclass).
I dont know how to add new character to character database.

user_character, char_mappos , user_bag , user_suit , user_skill , user_slot
of Black wizzard, Sequ, Con, hafbagi.

Please help me!
Thanks so much!
12/01/2012 19:30 ihatehacks#2
check your char create information and go into each section that it creates a spot for and add the [DEV] char information for each one manually.

thats the hard way.


pretty sure someone made a script to do it somewhere, but idr where
12/01/2012 20:03 alexmak96#3
But HB,Segu,Concerra doesn't work on me
12/02/2012 03:40 ariesmichael#4
new chars database here all be fake .
12/02/2012 05:43 AntiHackPrivate#5
Help me! Please !
12/03/2012 05:22 AntiHackPrivate#6
Quote:
Originally Posted by Cataracts View Post
LOL.

@Anti

There are only two things you need to do database wise for the new characters.

Add them to user_character, make sure all the DEV characters have
the correct character_no and pc class ID.

Ex: Concerra = 10
Seguriper = 11
Black Wizard = 9
Half Bagi = 12

and add the entries in sp_char_create.. there's been plenty
of examples in other topics so I'm not going to replicate it again.

Once you're done those two things, any other problems you are having are client sided.
What's DEV name char for 4 new class??
12/03/2012 09:15 imissblood#7
Quote:
Originally Posted by zeusbigz View Post
try use this
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:
	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)
	
	-- ????? ???? ???? ??
	SET @rand_no = CAST(3*Rand()+1 as INT)
	SET @wh_char_no = 'DEKARON'+CAST(@v_byPCClass as varchar(2))+'000001'
Thx to zeusbigz
12/03/2012 18:38 AntiHackPrivate#8
Thank you very much!