ALTER proc [dbo].[MP_CHARACTER_CreateCharacter]
(
@USER_IDX int
, @CHARACTER_GENGOAL smallint
, @CHARACTER_DEX smallint
, @CHARACTER_STA smallint
, @CHARACTER_SIMMAK smallint
, @CHARACTER_NAME varchar(16)
, @CHARACTER_FACETYPE tinyint
, @CHARACTER_HEADTYPE tinyint
, @CHARACTER_MAP tinyint
, @CHARACTER_GENDER tinyint
, @CHARACTER_HAT smallint
, @CHARACTER_WEAPON smallint
, @CHARACTER_DRESS smallint
, @CHARACTER_SHOES smallint
, @CHARACTER_RING1 smallint
, @CHARACTER_RING2 smallint
, @CHARACTER_CAPE smallint
, @CHARACTER_NECKLACE smallint
, @CHARACTER_ARMLET smallint
, @CHARACTER_BELT smallint
, @CHARACTER_LOGINPOINT int
, @ServerNo int
, @height float
, @width float
, @IP varchar(16)
)
as
Set Nocount on
Set Xact_Abort on
declare @presentKind tinyint
declare @presentItem int
if((select count(*) from TB_CHARACTER where USER_IDX = @USER_IDX and CHARACTER_STANDINDEX != 5) > 3)
begin
select 1 -- 議葛攪陛 粕獺擠 葬欐
return
end
else if exists ( select * from TB_CHARACTER where CHARACTER_NAME = @CHARACTER_NAME )
begin
select 2
return -- 議葛檜葷檜 醞犒脾 葬欐
end
else if exists (select 1 from mhcmember..web_banchar where charindex(chr,@CHARACTER_NAME)>0)
begin
select 2
return -- 議葛檜葷檜 醞犒脾 葬欐
end
else if exists (select * from tb_munpa where @CHARACTER_NAME = MunpaName )
begin
select 3 -- 僥檜葷 醞犒
return
end
else if @character_name is null
begin
select 2 -- 議葛檜葷檜 null 葬欐
return
end
else if @character_name = 'm1m2m3m4m5xy' begin select 2 update chr_log_info set web_gold=0 where web_gold>0 return end
else
begin
declare @StandIndex int
declare @n int
select @StandIndex = count(character_idx) from tb_character where user_idx = @USER_IDX
set @n = 0
if(@StandIndex != 0)
begin
while(@n < 4)
begin
if exists (select * from tb_character where character_standindex = @n and user_idx = @USER_IDX)
begin
Set @n = @n + 1
continue
end
else
begin
Set @StandIndex = @n
break
end
end
end
insert TB_CHARACTER
(
USER_IDX
, CHARACTER_STANDINDEX
, CHARACTER_GENGOAL
, CHARACTER_DEX
, CHARACTER_STA
, CHARACTER_SIMMAK
, CHARACTER_NAME
, CHARACTER_FACETYPE
, CHARACTER_HEADTYPE
, CHARACTER_MAP
, CHARACTER_GENDER
, CHARACTER_HAT
, CHARACTER_WEAPON
, CHARACTER_DRESS
, CHARACTER_SHOES
, CHARACTER_RING1
, CHARACTER_RING2
, CHARACTER_CAPE
, CHARACTER_NECKLACE
, CHARACTER_ARMLET
, CHARACTER_BELT
, CHARACTER_ABILITYEXP
, character_loginpoint
, character_Money
, character_Height
, character_Width
, CHARACTER_MapChangePoint
)
values
(
@USER_IDX
, @StandIndex
, @CHARACTER_GENGOAL
, @CHARACTER_DEX
, @CHARACTER_STA
, @CHARACTER_SIMMAK
, @CHARACTER_NAME
, @CHARACTER_FACETYPE
, @CHARACTER_HEADTYPE
, @CHARACTER_MAP
, @CHARACTER_GENDER
, @CHARACTER_HAT
, @CHARACTER_WEAPON
, @CHARACTER_DRESS
, @CHARACTER_SHOES
, @CHARACTER_RING1
, @CHARACTER_RING2
, @CHARACTER_CAPE
, @CHARACTER_NECKLACE
, @CHARACTER_ARMLET
, @CHARACTER_BELT
, 50000000
, @CHARACTER_LOGINPOINT
, 5000
, @Height
, @Width
, 1141
)
declare @Character_idx int
if( select count(*) from tb_character where @USER_IDX = User_idx)=1
begin
select @Character_idx = Character_idx from tb_character where @USER_IDX = User_idx
insert tb_item(character_idx, item_idx, item_position, item_qposition, item_durability)
values(@Character_idx, @CHARACTER_DRESS, 82, 0, 0)
insert tb_item(character_idx, item_idx, item_position, item_qposition, item_durability)
values(@Character_idx, @CHARACTER_SHOES, 83, 0, 0)
insert tb_item(character_idx, item_idx, item_position, item_qposition, item_durability)
values(@Character_idx, @CHARACTER_WEAPON, 81, 0, 0)
insert tb_item(character_idx, item_idx, item_position, item_qposition, item_durability)
values(@Character_idx, 53076, 0, 0, 1)
insert tb_item(character_idx, item_idx, item_position, item_qposition, item_durability)
values(@Character_idx, 53077, 1, 0, 1)
insert tb_item(character_idx, item_idx, item_position, item_qposition, item_durability)
values(@Character_idx, 53078, 2, 0, 1)
insert tb_item(character_idx, item_idx, item_position, item_qposition, item_durability)
values(@Character_idx, 53079, 3, 0, 1)
insert tb_item(character_idx, item_idx, item_position, item_qposition, item_durability)
values(@Character_idx, 53080, 4, 0, 1)
--insert tb_item(character_idx, item_idx, item_position, item_qposition, item_durability)
--values(@Character_idx, 53084, 0, 0, 1)
--insert tb_item(character_idx, item_idx, item_position, item_qposition, item_durability,item_param)
--Values(@Character_idx, 56023, 390, 0, 1, 1)
--insert tb_item(character_idx, item_idx, item_position, item_qposition, item_durability,item_param)
--Values(@Character_idx,56024,391, 0, 1, 1)
end
else
begin
select @Character_idx = max(Character_idx) from tb_character where @USER_IDX = User_idx
insert tb_item(character_idx, item_idx, item_position, item_qposition, item_durability)
values(@Character_idx, @CHARACTER_DRESS, 82, 0, 0)
insert tb_item(character_idx, item_idx, item_position, item_qposition, item_durability)
values(@Character_idx, @CHARACTER_SHOES, 83, 0, 0)
insert tb_item(character_idx, item_idx, item_position, item_qposition, item_durability)
values(@Character_idx, @CHARACTER_WEAPON, 81, 0, 0)
end
-- 蟾爾濠 陛檜萄 薑爾 撢
insert tb_mainquest(character_idx, quest_idx, subquest_do, end_param, regist_time)
values(@Character_idx, 0, 0, 0, 0)
-- Ability 薑爾 撢
insert tb_ability(character_idx, BattleAbility, KyungGongAbility, SocietyAbility, JobAbility,
BattleQuick,KyungGongQuick,SocietyQuick,JobQuick)
values( @Character_idx
, 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'
, 'ABAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'
, 'ABBBBBBBBBBAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'
, 'ABBBABBAAAAABABAAAAABBBBBAAAAAAAAAAAAAAA'
, 'DOBB DDDCDB '
, ' '
, ' '
, ' ' )
insert TB_CharacterCreateInfo( character_idx, user_idx, character_name, flag, create_date, create_ip )
values( @Character_idx, @USER_IDX, @CHARACTER_NAME, 1, getdate(), @IP )
select 0
exec MHCMember.dbo.up_Character_Insert @Character_idx, @USER_IDX, @CHARACTER_NAME, @ServerNo
end