[Help] How to add new char to database

[AntiHackPrivate]

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!

[ihatehacks]

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

[alexmak96]

But HB,Segu,Concerra doesn't work on me

[ariesmichael]

new chars database here all be fake .

[AntiHackPrivate]

Help me! Please !

[AntiHackPrivate]

Originally Posted by Cataracts

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??

[imissblood]

Originally Posted by zeusbigz

try use this

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

	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

[AntiHackPrivate]

Thank you very much!