how can I create database with the dark wizard characters etc begi half.
Either way for me to have the characters
thanks :)
Either way for me to have the characters
thanks :)
Thats what i fount in searchQuote:
Originally Posted by zeusbigz
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 0Code: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'