[ Mo siang ] add gift to all character create

id09318 · Dec 1, 2013

create character + gift
add table ? SQL SERVER

add gift to all character create
add table ? SQL SERVER

Help me

KaiyMso · Dec 1, 2013

id09318 said:
create character + gift
add table ? SQL SERVER

add gift to all character create
add table ? SQL SERVER

Help me

see on database MHGAME

insert tb_item(character_idx, item_idx, item_position, item_qposition, item_durability)
values(@Character_idx, 63325, 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

See this picture i hope this can help u thanks

nbT7lPA - [ Mo siang ] add gift to all character create - RaGEZONE Forums

id09318 · Dec 2, 2013

KaiyMso said:
see on database MHGAME

See this picture i hope this can help u thanks

Thank you KaiyMso

I'm trying to raise money to buy server files mo siang thai from KaiyMso

id09318 - [ Mo siang ] add gift to all character create - RaGEZONE Forums

KaiyMso · Dec 2, 2013

Copy this

PHP:

USE [MHGAME]
GO
/****** Object:  StoredProcedure [dbo].[MP_CHARACTER_CreateCharacter]    Script Date: 12/02/2013 10:54:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO



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
			,	0
			, 	@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)
    --- Item Add for first Character edit here
		insert tb_item(character_idx, item_idx, item_position, item_qposition, item_durability)
		values(@Character_idx, 63325, 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
	-- For Add item second Character!
		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

id09318 said:
Thank you KaiyMso

I'm trying to raise money to buy server files mo siang thai from KaiyMso

id09318 · Dec 2, 2013

new code Bug create character

Creating a new character is not

KaiyMso · Dec 2, 2013

bug? where the bug can show picture the bug on create character.

id09318 · Dec 2, 2013

no error

Creating a new character is not

id09318 · Dec 2, 2013

KaiyMso said:
bug? where the bug can show picture the bug on create character.

Click to create characters not

Database :

You must be registered to see links

KaiyMso · Dec 2, 2013

id09318 said:
Click to create characters not

Database :

You must be registered to see links

check CharMake_SelectOption.bin not same with your sql produce create characters

id09318 · Dec 2, 2013

KaiyMso said:
check CharMake_SelectOption.bin not same with your sql produce create characters

Before the code can create a character normally

After inserting the code can not build character

KaiyMso · Dec 2, 2013

id09318 said:
Before the code can create a character normally

After inserting the code can not build character

Try this Produce Sql MP_CHARACTER_CreateCharacter

PHP:

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

And Bin CharMake_SelectOption.bin

PHP:

5 CMID_AttribType	È 0 0	¼ö 1 0	¸ñ 2 0	±Ý 3 0	Åä 4 0
2 CMID_SexType		Male 0 0	Female 1 0
5 CMID_ManHairType	Brown 0 0 Blue 1 0 Long 2 0 Black 3 0 Green 4 0
5 CMID_WomanHairType 	Brown 0 0 Violet 1 0 Blue 2 0 Green 3 0 Black 4 0
5 CMID_ManFaceType 	Ego 0 0 Mercy 1 0 Fierce 2 0 Macho 3 0 Scar 4 0
5 CMID_WomanFaceType 	Cute 0 0 Elegent 1 0 Gentle 2 0 Funky 3 0 Pityful 4 0
2 CMID_ClothType 	Simple^sDress 23000 0 		Flax^sVest 23010 0
2 CMID_BootType 	Simple^sShoe 27000 0 		Flax^sShoe 27010 0
6 CMID_WeaponType 	Sword 11000 2 Fist 13000 4 Katana 15000 3 Spear 17000 5 Bow 19000 6 Dart 21000 7
1 CMID_StartArea 	Äõ¦{ 17 0

id09318 · Dec 2, 2013

id09318 · Dec 3, 2013

see TB_CHARACTER

PHP:

USE [mhgame]GO/****** Object:  Table [dbo].[TB_CHARACTER]    Script Date: 12/03/2013 08:43:28 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[TB_CHARACTER](	[CHARACTER_IDX] [int] IDENTITY(100,1) NOT NULL,	[USER_IDX] [int] NOT NULL,	[CHARACTER_STANDINDEX] [int] NOT NULL CONSTRAINT [DF_TB_CHARACTER_CHARACTER_STANDINDEX]  DEFAULT ((0)),	[CHARACTER_PARTYIDX] [int] NOT NULL CONSTRAINT [DF_TB_CHARACTER_CHARACTER_PARTYIDX]  DEFAULT ((0)),	[CHARACTER_GENDER] [tinyint] NOT NULL CONSTRAINT [DF_TB_CHARACTER_CHARACTER_GENDER]  DEFAULT ((0)),	[CHARACTER_GENGOAL] [int] NOT NULL CONSTRAINT [DF__TB_CHARAC__CHARA__2A4B4B5E]  DEFAULT ((0)),	[CHARACTER_LIFE] [int] NOT NULL CONSTRAINT [DF_TB_CHARACTER_CHARACTER_LIFE]  DEFAULT ((130)),	[CHARACTER_MAXLIFE] [int] NOT NULL CONSTRAINT [DF_TB_CHARACTER_CHARACTER_MAXLIFE]  DEFAULT ((0)),	[CHARACTER_ENERGE] [int] NOT NULL CONSTRAINT [DF_TB_CHARACTER_CHARACTER_ENERGE]  DEFAULT ((999999)),	[CHARACTER_DEX] [int] NOT NULL CONSTRAINT [DF__TB_CHARAC__CHARA__2B3F6F97]  DEFAULT ((0)),	[CHARACTER_STA] [int] NOT NULL CONSTRAINT [DF__TB_CHARAC__CHARA__2C3393D0]  DEFAULT ((0)),	[CHARACTER_SIMMAK] [int] NOT NULL CONSTRAINT [DF__TB_CHARAC__CHARA__2D27B809]  DEFAULT ((0)),	[CHARACTER_FAME] [int] NOT NULL CONSTRAINT [DF__TB_CHARAC__CHARA__2E1BDC42]  DEFAULT ((0)),	[CHARACTER_KARMA] [tinyint] NOT NULL CONSTRAINT [DF__TB_CHARAC__CHARA__2F10007B]  DEFAULT ((0)),	[CHARACTER_NAME] [varchar](max) COLLATE Chinese_PRC_CI_AS NOT NULL,	[CHARACTER_REPUTE] [varchar](16) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF__TB_CHARAC__CHARA__300424B4]  DEFAULT ('-'),	[CHARACTER_JOB] [tinyint] NOT NULL CONSTRAINT [DF__TB_CHARAC__CHARA__30F848ED]  DEFAULT ((0)),	[CHARACTER_STAGE] [tinyint] NOT NULL CONSTRAINT [DF__TB_CHARAC__CHARA__31EC6D26]  DEFAULT ((129)),	[CHARACTER_GRADE] [tinyint] NOT NULL CONSTRAINT [DF__TB_CHARAC__CHARA__32E0915F]  DEFAULT ((1)),	[CHARACTER_MAXGRADE] [tinyint] NOT NULL CONSTRAINT [DF_TB_CHARACTER_CHARACTER_MAXGRADE]  DEFAULT ((1)),	[CHARACTER_EXPOINT] [bigint] NULL CONSTRAINT [DF__TB_CHARAC__CHARA__33D4B598]  DEFAULT ((0)),	[CHARACTER_GRADEUPPOINT] [smallint] NOT NULL CONSTRAINT [DF__TB_CHARAC__CHARA__34C8D9D1]  DEFAULT ((0)),	[CHARACTER_MONEY] [bigint] NOT NULL CONSTRAINT [DF__TB_CHARAC__CHARA__35BCFE0A]  DEFAULT ((0)),	[CHARACTER_QUICKPACE] [int] NOT NULL CONSTRAINT [DF__TB_CHARAC__CHARA__36B12243]  DEFAULT ((0)),	[CHARACTER_VITALITY] [tinyint] NOT NULL CONSTRAINT [DF__TB_CHARAC__CHARA__37A5467C]  DEFAULT ((0)),	[CHARACTER_MAP] [tinyint] NOT NULL CONSTRAINT [DF__TB_CHARAC__CHARA__38996AB5]  DEFAULT ((18)),	[CHARACTER_FACETYPE] [tinyint] NOT NULL CONSTRAINT [DF__TB_CHARAC__CHARA__398D8EEE]  DEFAULT ((0)),	[CHARACTER_HEADTYPE] [tinyint] NOT NULL CONSTRAINT [DF__TB_CHARAC__CHARA__3A81B327]  DEFAULT ((0)),	[CHARACTER_HAT] [int] NOT NULL CONSTRAINT [DF__TB_CHARAC__CHARA__3E52440B]  DEFAULT ((0)),	[CHARACTER_WEAPON] [int] NOT NULL CONSTRAINT [DF__TB_CHARAC__CHARA__3B75D760]  DEFAULT ((0)),	[CHARACTER_DRESS] [int] NOT NULL CONSTRAINT [DF__TB_CHARAC__CHARA__3C69FB99]  DEFAULT ((0)),	[CHARACTER_SHOES] [int] NOT NULL CONSTRAINT [DF__TB_CHARAC__CHARA__3D5E1FD2]  DEFAULT ((0)),	[CHARACTER_RING1] [int] NOT NULL CONSTRAINT [DF__TB_CHARAC__CHARA__3F466844]  DEFAULT ((0)),	[CHARACTER_RING2] [int] NOT NULL CONSTRAINT [DF__TB_CHARAC__CHARA__403A8C7D]  DEFAULT ((0)),	[CHARACTER_CAPE] [int] NOT NULL CONSTRAINT [DF__TB_CHARAC__CHARA__412EB0B6]  DEFAULT ((0)),	[CHARACTER_NECKLACE] [int] NOT NULL CONSTRAINT [DF__TB_CHARAC__CHARA__4222D4EF]  DEFAULT ((0)),	[CHARACTER_ARMLET] [int] NOT NULL CONSTRAINT [DF_TB_CHARACTER_CHARACTER_ARMLET]  DEFAULT ((0)),	[CHARACTER_BELT] [int] NOT NULL CONSTRAINT [DF_TB_CHARACTER_CHARACTER_BELT]  DEFAULT ((0)),	[CHARACTER_MUNPAIDX] [int] NOT NULL CONSTRAINT [DF__TB_CHARAC__CHARA__4316F928]  DEFAULT ((0)),	[CHARACTER_MUNPAJIKCHEK] [tinyint] NOT NULL CONSTRAINT [DF_TB_CHARACTER_CHARACTER_MUNPAJIKCHEK]  DEFAULT ((0)),	[CHARACTER_MUNPAENTRYDATE] [smalldatetime] NOT NULL CONSTRAINT [DF_TB_CHARACTER_CHARACTER_MUNPAENTRYDATE]  DEFAULT ((0)),	[CHARACTER_MUNPACANENTRYDATE] [smalldatetime] NOT NULL CONSTRAINT [DF_TB_CHARACTER_CHARACTER_MUNPALASTVISITDATE]  DEFAULT ((0)),	[CHARACTER_MUNPANAME] [varchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF__TB_CHARAC__CHARA__440B1D61]  DEFAULT (''),	[CHARACTER_MUNPAMARKIDX] [int] NOT NULL CONSTRAINT [DF_TB_CHARACTER_CHARACTER_MUNPAMARKIDX]  DEFAULT ((0)),	[CHARACTER_SKININFO] [int] NOT NULL CONSTRAINT [DF_TB_CHARACTER_CHARACTER_SKININFO]  DEFAULT ((0)),	[CHARACTER_ABILITY2] [tinyint] NOT NULL CONSTRAINT [DF__TB_CHARAC__CHARA__47DBAE45]  DEFAULT ((0)),	[CHARACTER_ABILITY3] [tinyint] NOT NULL CONSTRAINT [DF__TB_CHARAC__CHARA__48CFD27E]  DEFAULT ((0)),	[CHARACTER_ABILITY4] [tinyint] NOT NULL CONSTRAINT [DF__TB_CHARAC__CHARA__49C3F6B7]  DEFAULT ((0)),	[CHARACTER_ABILITY5] [tinyint] NOT NULL CONSTRAINT [DF__TB_CHARAC__CHARA__4AB81AF0]  DEFAULT ((0)),	[CHARACTER_ABILITY6] [tinyint] NOT NULL CONSTRAINT [DF__TB_CHARAC__CHARA__4BAC3F29]  DEFAULT ((0)),	[CHARACTER_ABILITY7] [tinyint] NOT NULL CONSTRAINT [DF__TB_CHARAC__CHARA__4CA06362]  DEFAULT ((0)),	[CHARACTER_BIRTH] [smalldatetime] NOT NULL CONSTRAINT [DF__TB_CHARAC__CHARA__5165187F]  DEFAULT (getdate()),	[CHARACTER_LASTMODIFIED] [smalldatetime] NOT NULL CONSTRAINT [DF__TB_CHARAC__CHARA__52593CB8]  DEFAULT (getdate()),	[CHARACTER_STATE] [tinyint] NOT NULL CONSTRAINT [DF__TB_CHARAC__CHARA__534D60F1]  DEFAULT ((0)),	[Character_MapChangePoint] [int] NOT NULL CONSTRAINT [DF_TB_CHARACTER_Character_MapChangePoint]  DEFAULT ((0)),	[Character_LoginPoint] [int] NOT NULL CONSTRAINT [DF_TB_CHARACTER_Character_LoginPoint]  DEFAULT ((2018)),	[CHARACTER_SHIELD] [int] NOT NULL CONSTRAINT [DF_TB_CHARACTER_CHARACTER_SHIELD]  DEFAULT ((125)),	[CHARACTER_ABILITYEXP] [int] NOT NULL CONSTRAINT [DF_TB_CHARACTER_CHARACTER_ABILITYEXP]  DEFAULT ((99999999)),	[CHARACTER_CURRENTMAP] [tinyint] NOT NULL CONSTRAINT [DF_TB_CHARACTER_CHARACTER_MAPNUM]  DEFAULT ((0)),	[CHARACTER_BADFAME] [int] NOT NULL CONSTRAINT [DF_TB_CHARACTER_CHARACTER_BADFAME]  DEFAULT ((0)),	[CHARACTER_Height] [float] NOT NULL CONSTRAINT [DF_TB_CHARACTER_CHARACTER_Height]  DEFAULT ((1)),	[CHARACTER_WIDTH] [float] NOT NULL CONSTRAINT [DF_TB_CHARACTER_CHARACTER_WIDTH]  DEFAULT ((1)),	[CHARACTER_PLAYTIME] [int] NOT NULL CONSTRAINT [DF_TB_CHARACTER_CHARACTER_PLAYTIME]  DEFAULT ((0)),	[CHARACTER_LASTPKENDTIME] [int] NOT NULL CONSTRAINT [DF_TB_CHARACTER_CHARACTER_LASTPKENDTIME]  DEFAULT ((0)),	[CHARACTER_NICKNAME] [varchar](20) COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT [DF_TB_CHARACTER_CHARACTER_NICKNAME]  DEFAULT (''),	[CHARACTER_ATTR] [int] NOT NULL CONSTRAINT [DF__TB_Charac__CHARA__133E942B]  DEFAULT ((0)),	[CHARACTER_EXPFLAG] [int] NOT NULL CONSTRAINT [DF__tb_charac__CHARA__75441CF0]  DEFAULT ((0)),	[zhuansheng] [int] NULL,	[zstime] [datetime] NULL,	[XDTIME] [datetime] NULL, CONSTRAINT [PK_CHARACTER_IDX] PRIMARY KEY NONCLUSTERED (	[CHARACTER_IDX] ASC)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF, FILLFACTOR = 90) ON [PRIMARY]) ON [PRIMARY]
GOSET ANSI_PADDING OFF

And Bin CharMake_SelectOption.bin

use PHP Code: Kaiymso
Creating a new character is not

I found a bug in AgentServer

KaiyMso · Dec 3, 2013

id09318 said:

see TB_CHARACTER

PHP:

USE [mhgame]GO/****** Object:  Table [dbo].[TB_CHARACTER]    Script Date: 12/03/2013 08:43:28 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[TB_CHARACTER](	[CHARACTER_IDX] [int] IDENTITY(100,1) NOT NULL,	[USER_IDX] [int] NOT NULL,	[CHARACTER_STANDINDEX] [int] NOT NULL CONSTRAINT [DF_TB_CHARACTER_CHARACTER_STANDINDEX]  DEFAULT ((0)),	[CHARACTER_PARTYIDX] [int] NOT NULL CONSTRAINT [DF_TB_CHARACTER_CHARACTER_PARTYIDX]  DEFAULT ((0)),	[CHARACTER_GENDER] [tinyint] NOT NULL CONSTRAINT [DF_TB_CHARACTER_CHARACTER_GENDER]  DEFAULT ((0)),	[CHARACTER_GENGOAL] [int] NOT NULL CONSTRAINT [DF__TB_CHARAC__CHARA__2A4B4B5E]  DEFAULT ((0)),	[CHARACTER_LIFE] [int] NOT NULL CONSTRAINT [DF_TB_CHARACTER_CHARACTER_LIFE]  DEFAULT ((130)),	[CHARACTER_MAXLIFE] [int] NOT NULL CONSTRAINT [DF_TB_CHARACTER_CHARACTER_MAXLIFE]  DEFAULT ((0)),	[CHARACTER_ENERGE] [int] NOT NULL CONSTRAINT [DF_TB_CHARACTER_CHARACTER_ENERGE]  DEFAULT ((999999)),	[CHARACTER_DEX] [int] NOT NULL CONSTRAINT [DF__TB_CHARAC__CHARA__2B3F6F97]  DEFAULT ((0)),	[CHARACTER_STA] [int] NOT NULL CONSTRAINT [DF__TB_CHARAC__CHARA__2C3393D0]  DEFAULT ((0)),	[CHARACTER_SIMMAK] [int] NOT NULL CONSTRAINT [DF__TB_CHARAC__CHARA__2D27B809]  DEFAULT ((0)),	[CHARACTER_FAME] [int] NOT NULL CONSTRAINT [DF__TB_CHARAC__CHARA__2E1BDC42]  DEFAULT ((0)),	[CHARACTER_KARMA] [tinyint] NOT NULL CONSTRAINT [DF__TB_CHARAC__CHARA__2F10007B]  DEFAULT ((0)),	[CHARACTER_NAME] [varchar](max) COLLATE Chinese_PRC_CI_AS NOT NULL,	[CHARACTER_REPUTE] [varchar](16) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF__TB_CHARAC__CHARA__300424B4]  DEFAULT ('-'),	[CHARACTER_JOB] [tinyint] NOT NULL CONSTRAINT [DF__TB_CHARAC__CHARA__30F848ED]  DEFAULT ((0)),	[CHARACTER_STAGE] [tinyint] NOT NULL CONSTRAINT [DF__TB_CHARAC__CHARA__31EC6D26]  DEFAULT ((129)),	[CHARACTER_GRADE] [tinyint] NOT NULL CONSTRAINT [DF__TB_CHARAC__CHARA__32E0915F]  DEFAULT ((1)),	[CHARACTER_MAXGRADE] [tinyint] NOT NULL CONSTRAINT [DF_TB_CHARACTER_CHARACTER_MAXGRADE]  DEFAULT ((1)),	[CHARACTER_EXPOINT] [bigint] NULL CONSTRAINT [DF__TB_CHARAC__CHARA__33D4B598]  DEFAULT ((0)),	[CHARACTER_GRADEUPPOINT] [smallint] NOT NULL CONSTRAINT [DF__TB_CHARAC__CHARA__34C8D9D1]  DEFAULT ((0)),	[CHARACTER_MONEY] [bigint] NOT NULL CONSTRAINT [DF__TB_CHARAC__CHARA__35BCFE0A]  DEFAULT ((0)),	[CHARACTER_QUICKPACE] [int] NOT NULL CONSTRAINT [DF__TB_CHARAC__CHARA__36B12243]  DEFAULT ((0)),	[CHARACTER_VITALITY] [tinyint] NOT NULL CONSTRAINT [DF__TB_CHARAC__CHARA__37A5467C]  DEFAULT ((0)),	[CHARACTER_MAP] [tinyint] NOT NULL CONSTRAINT [DF__TB_CHARAC__CHARA__38996AB5]  DEFAULT ((18)),	[CHARACTER_FACETYPE] [tinyint] NOT NULL CONSTRAINT [DF__TB_CHARAC__CHARA__398D8EEE]  DEFAULT ((0)),	[CHARACTER_HEADTYPE] [tinyint] NOT NULL CONSTRAINT [DF__TB_CHARAC__CHARA__3A81B327]  DEFAULT ((0)),	[CHARACTER_HAT] [int] NOT NULL CONSTRAINT [DF__TB_CHARAC__CHARA__3E52440B]  DEFAULT ((0)),	[CHARACTER_WEAPON] [int] NOT NULL CONSTRAINT [DF__TB_CHARAC__CHARA__3B75D760]  DEFAULT ((0)),	[CHARACTER_DRESS] [int] NOT NULL CONSTRAINT [DF__TB_CHARAC__CHARA__3C69FB99]  DEFAULT ((0)),	[CHARACTER_SHOES] [int] NOT NULL CONSTRAINT [DF__TB_CHARAC__CHARA__3D5E1FD2]  DEFAULT ((0)),	[CHARACTER_RING1] [int] NOT NULL CONSTRAINT [DF__TB_CHARAC__CHARA__3F466844]  DEFAULT ((0)),	[CHARACTER_RING2] [int] NOT NULL CONSTRAINT [DF__TB_CHARAC__CHARA__403A8C7D]  DEFAULT ((0)),	[CHARACTER_CAPE] [int] NOT NULL CONSTRAINT [DF__TB_CHARAC__CHARA__412EB0B6]  DEFAULT ((0)),	[CHARACTER_NECKLACE] [int] NOT NULL CONSTRAINT [DF__TB_CHARAC__CHARA__4222D4EF]  DEFAULT ((0)),	[CHARACTER_ARMLET] [int] NOT NULL CONSTRAINT [DF_TB_CHARACTER_CHARACTER_ARMLET]  DEFAULT ((0)),	[CHARACTER_BELT] [int] NOT NULL CONSTRAINT [DF_TB_CHARACTER_CHARACTER_BELT]  DEFAULT ((0)),	[CHARACTER_MUNPAIDX] [int] NOT NULL CONSTRAINT [DF__TB_CHARAC__CHARA__4316F928]  DEFAULT ((0)),	[CHARACTER_MUNPAJIKCHEK] [tinyint] NOT NULL CONSTRAINT [DF_TB_CHARACTER_CHARACTER_MUNPAJIKCHEK]  DEFAULT ((0)),	[CHARACTER_MUNPAENTRYDATE] [smalldatetime] NOT NULL CONSTRAINT [DF_TB_CHARACTER_CHARACTER_MUNPAENTRYDATE]  DEFAULT ((0)),	[CHARACTER_MUNPACANENTRYDATE] [smalldatetime] NOT NULL CONSTRAINT [DF_TB_CHARACTER_CHARACTER_MUNPALASTVISITDATE]  DEFAULT ((0)),	[CHARACTER_MUNPANAME] [varchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF__TB_CHARAC__CHARA__440B1D61]  DEFAULT (''),	[CHARACTER_MUNPAMARKIDX] [int] NOT NULL CONSTRAINT [DF_TB_CHARACTER_CHARACTER_MUNPAMARKIDX]  DEFAULT ((0)),	[CHARACTER_SKININFO] [int] NOT NULL CONSTRAINT [DF_TB_CHARACTER_CHARACTER_SKININFO]  DEFAULT ((0)),	[CHARACTER_ABILITY2] [tinyint] NOT NULL CONSTRAINT [DF__TB_CHARAC__CHARA__47DBAE45]  DEFAULT ((0)),	[CHARACTER_ABILITY3] [tinyint] NOT NULL CONSTRAINT [DF__TB_CHARAC__CHARA__48CFD27E]  DEFAULT ((0)),	[CHARACTER_ABILITY4] [tinyint] NOT NULL CONSTRAINT [DF__TB_CHARAC__CHARA__49C3F6B7]  DEFAULT ((0)),	[CHARACTER_ABILITY5] [tinyint] NOT NULL CONSTRAINT [DF__TB_CHARAC__CHARA__4AB81AF0]  DEFAULT ((0)),	[CHARACTER_ABILITY6] [tinyint] NOT NULL CONSTRAINT [DF__TB_CHARAC__CHARA__4BAC3F29]  DEFAULT ((0)),	[CHARACTER_ABILITY7] [tinyint] NOT NULL CONSTRAINT [DF__TB_CHARAC__CHARA__4CA06362]  DEFAULT ((0)),	[CHARACTER_BIRTH] [smalldatetime] NOT NULL CONSTRAINT [DF__TB_CHARAC__CHARA__5165187F]  DEFAULT (getdate()),	[CHARACTER_LASTMODIFIED] [smalldatetime] NOT NULL CONSTRAINT [DF__TB_CHARAC__CHARA__52593CB8]  DEFAULT (getdate()),	[CHARACTER_STATE] [tinyint] NOT NULL CONSTRAINT [DF__TB_CHARAC__CHARA__534D60F1]  DEFAULT ((0)),	[Character_MapChangePoint] [int] NOT NULL CONSTRAINT [DF_TB_CHARACTER_Character_MapChangePoint]  DEFAULT ((0)),	[Character_LoginPoint] [int] NOT NULL CONSTRAINT [DF_TB_CHARACTER_Character_LoginPoint]  DEFAULT ((2018)),	[CHARACTER_SHIELD] [int] NOT NULL CONSTRAINT [DF_TB_CHARACTER_CHARACTER_SHIELD]  DEFAULT ((125)),	[CHARACTER_ABILITYEXP] [int] NOT NULL CONSTRAINT [DF_TB_CHARACTER_CHARACTER_ABILITYEXP]  DEFAULT ((99999999)),	[CHARACTER_CURRENTMAP] [tinyint] NOT NULL CONSTRAINT [DF_TB_CHARACTER_CHARACTER_MAPNUM]  DEFAULT ((0)),	[CHARACTER_BADFAME] [int] NOT NULL CONSTRAINT [DF_TB_CHARACTER_CHARACTER_BADFAME]  DEFAULT ((0)),	[CHARACTER_Height] [float] NOT NULL CONSTRAINT [DF_TB_CHARACTER_CHARACTER_Height]  DEFAULT ((1)),	[CHARACTER_WIDTH] [float] NOT NULL CONSTRAINT [DF_TB_CHARACTER_CHARACTER_WIDTH]  DEFAULT ((1)),	[CHARACTER_PLAYTIME] [int] NOT NULL CONSTRAINT [DF_TB_CHARACTER_CHARACTER_PLAYTIME]  DEFAULT ((0)),	[CHARACTER_LASTPKENDTIME] [int] NOT NULL CONSTRAINT [DF_TB_CHARACTER_CHARACTER_LASTPKENDTIME]  DEFAULT ((0)),	[CHARACTER_NICKNAME] [varchar](20) COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT [DF_TB_CHARACTER_CHARACTER_NICKNAME]  DEFAULT (''),	[CHARACTER_ATTR] [int] NOT NULL CONSTRAINT [DF__TB_Charac__CHARA__133E942B]  DEFAULT ((0)),	[CHARACTER_EXPFLAG] [int] NOT NULL CONSTRAINT [DF__tb_charac__CHARA__75441CF0]  DEFAULT ((0)),	[zhuansheng] [int] NULL,	[zstime] [datetime] NULL,	[XDTIME] [datetime] NULL, CONSTRAINT [PK_CHARACTER_IDX] PRIMARY KEY NONCLUSTERED (	[CHARACTER_IDX] ASC)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF, FILLFACTOR = 90) ON [PRIMARY]) ON [PRIMARY]
GOSET ANSI_PADDING OFF

use PHP Code: Kaiymso
Creating a new character is not

I found a bug in AgentServer

I think your db table & Produce not same with my db

because mso all not same! the db just other say all same.
i get db release with other forum i can't in my client.

try check your error on log

id09318 · Dec 3, 2013

Thanks for all the comments

I would find another way

prasert457589 · Jan 2, 2014

id09318

i need data source code mosiang For Help You

now I dont Have fire

plz Upload for me plz

Welcome!

[ Mo siang ] add gift to all character create

Newbie Spellweaver

Junior Spellweaver

Attachments

Newbie Spellweaver

Attachments

Junior Spellweaver

Newbie Spellweaver

Junior Spellweaver

Newbie Spellweaver

Newbie Spellweaver

Junior Spellweaver

Newbie Spellweaver

Junior Spellweaver

Newbie Spellweaver

Newbie Spellweaver

Junior Spellweaver

Newbie Spellweaver

Newbie Spellweaver

Similar threads

About Us

Online statistics

Forum statistics

RaGEZONE Sponsor