丕賱亘賯丕亍 賲爻噩賱 丿丕卅賲丌
丕賱廿毓賱丕賳丕鬲
尴磴 25-01-2014, 03:26 AM   #1

uleader2
谥 葳轻





轻卿苁苡芮 Dec 2012
艳茔 轻谲周骓苌 107823
轻阍苘芮堰芮 246
轻芟驷苌
轻苠苕琼苌
怯茔 轻苡茼苎蒈
轻芴茕苡
滢芮 轻兽眄 10
uleader2 哲勤芟

uleader2 垌 闶媲滔 颓犴丘



禽恃侵 阍哚 垩砣 茄烟 轻歪



卿 轻锨是软 仁谑 沩 沩 萏巧 添 勤汜 Char. 寝硎 软捩犴 Error s(1030 阙 卿 萸释 哚 轻阆 阢崾徭 秧邮嫜 爿碓 萸硐 阃显 磙驷 垌 轻锨是 崆漤 吾帐迩 钦崆 沅 擎徨 俏彦




严 阙 寝嗜怯
炮崆淝 google

尴磴 25-01-2014, 03:36 AM   #2

uleader2
谥 葳轻





轻卿苁苡芮 Dec 2012
艳茔 轻谲周骓苌 107823
轻阍苘芮堰芮 246
轻芟驷苌
轻苠苕琼苌
怯茔 轻苡茼苎蒈
轻芴茕苡
滢芮 轻兽眄 10
uleader2 哲勤芟

uleader2 垌 闶媲滔 颓犴丘



禽恃侵



咩卿 萄仁 芹硌 轻 Add new char




严 阙 寝嗜怯
尴磴 25-01-2014, 03:41 AM   #3

Yui
谥 葳轻





轻卿苁苡芮 Sep 2012
艳茔 轻谲周骓苌 105332
轻阍苘芮堰芮 319
轻芟驷苌
轻苠苕琼苌 Hex,PHP,C#,SQL
怯茔 轻苡茼苎蒈 No Server
轻芴茕苡 Male
滢芮 轻兽眄 43
Yui 哲勤芟

Yui 垌 闶媲滔 颓犴丘


叛忧 延轻 谌 Yahoo 裴 Yui

禽恃侵



show me StoredProcedure [dbo].[_AddNewChar] if need fixed ur error




严 阙 寝嗜怯
尴磴 25-01-2014, 03:45 AM   #4

uleader2
谥 葳轻





轻卿苁苡芮 Dec 2012
艳茔 轻谲周骓苌 107823
轻阍苘芮堰芮 246
轻芟驷苌
轻苠苕琼苌
怯茔 轻苡茼苎蒈
轻芴茕苡
滢芮 轻兽眄 10
uleader2 哲勤芟

uleader2 垌 闶媲滔 颓犴丘



禽恃侵



USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_AddNewChar] Script Date: 25/01/2014 02:44:41 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO




ALTER PROCEDURE [dbo].[_AddNewChar]
@UserJID INT,
--@CharSlot INT,
@RefCharID INT,
@CharName varchar (64),
@CharScale tinyINT,
@StartRegionID INT,
@StartPos_X real,
@StartPos_Y real,
@StartPos_Z real,
@DefaultTeleport INT,
@RefMailID INT,
@RefPantsID INT,
@RefBootsID INT,
@RefWeaponID INT,
@RefShield INT,
@DurMail tinyINT,
@DurPants tinyINT,
@DurBoots tinyINT,
@DurWeapon tinyINT,
@DurShield tinyINT,
@DefaultArrow INT
AS

SET NOCOUNT ON

DECLARE @Slot INT
DECLARE @temp INT

DECLARE @NewCharID INT
SET @NewCharID = 0


-----------------------------------------------------------------------------
-- 1. 脛掣吤 浇访 趁懝枚奥 valid脟脩 懊嵜脦脕枚, 弊府懊* 潞贸浇访斆脤 该偞脗脕枚 该暶煤 脙济叐脟脩疵.
-----------------------------------------------------------------------------

-- start by novice.
SELECT @temp = count(CharID) FROM _User WITH (NOLOCK) WHERE UserJID = @UserJID

IF (@temp >= 4)
BEGIN
-- 趁姽 腹脌脷陈
RETURN -2
END
-- finish by novice.

-----------------------------------------------------------------------------
-- 2. 脛掣吤 脙脽奥∶嚸彵
-----------------------------------------------------------------------------
IF (@CharScale > 68) -- 0100 0100 --> 68 脌脤疵!
BEGIN
-- 脛掣吤 幻郊潞 矫嚸喢! 铰好劽壝脧 奥脤 脌脤幻趁嚸彺脵!
RETURN -3
END

EXEC @temp = _IsExistingCharName @CharName
IF (@temp <> 0)
BEGIN
-- 脌脤姑 荤驴朊伱熋脦 脌脤抚脌脤睹炒脗单?
RETURN -4
END

BEGIN TRANSACTION

-- 脌脦疵附脙铰好吤浢脤 脌侩得嚫榧* 付脕枚阜驴隆 WorldID驴脥 1奥 疵 趁柧 脕脰久捍脵!
INSERT INTO _Char (RefObjID, CharName16, Scale, Strength, Intellect, LatestRegion,PosX, PosY, PosZ, AppointedTeleport, InventorySize,
LastLogout, CurLevel, MaxLevel, RemainGold, RemainStatPoint, RemainSkillPoint, HP, MP, JobLvl_Trader, JobLvl_Hunter, JobLvl_Robber, WorldID)
VALUES (@RefCharID, @CharName, @CharScale, 20, 20, @StartRegionID, @StartPos_X, @StartPos_Y, @StartPos_Z, @DefaultTeleport, 45,
GetDate(), 1, 1, 0, 0, 0, 200,200, 1, 1, 1, 1)

SET @NewCharID = @@IDENTITY
IF (@@ERROR <> 0 OR @@ROWCOUNT = 0)
BEGIN
-- 脛掣吤 幻郊潞 矫嚸喢!
ROLLBACK TRANSACTION
RETURN -5
END


-- start by novice.
-- 脌脤脕 Slot 久埦创脵.. 弊趁 Insert 父..
INSERT INTO _User VALUES (@UserJID, @NewCharID)
-- finish by novice.


-----------------------------------------------------------------------------
-- 3-1. 脌氓潞帽 浇访 脙ぢ棵
-- [脌脦潞ッ吤じ 浇访 96俺] + [脌氓潞帽浇访 13俺] <- 脌脦潞ッ吤じ 脠氓 *潞帽铰 脠脛 48俺驴隆* 96俺访 脕玫奥!!!(woos0)
-----------------------------------------------------------------------------
--PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!
INSERT INTO _Inventory(CharID, Slot, ItemID)
SELECT @NewCharID, cnt, 0
FROM _RefDummySlot with( nolock )
WHERE cnt < 109


IF (@@ERROR <> 0)
BEGIN
-- 脌脦潞ッ吤じ 幻郊潞 矫嚸喢!
ROLLBACK TRANSACTION
RETURN -7
END

--PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!

-- 得懊喢好啴访 急脜脙脟脩 久喢脤脜脹脌 疵櫧脙 趁柧蠲伱柮脷...
/* 驴盲繁 济讣*访 脕っ脟得嚲 脌脰疵.
0: EQUIP_SLOT_HELM
1: EQUIP_SLOT_MAIL,
2: EQUIP_SLOT_SHOULDERGUARD,
3: EQUIP_SLOT_GAUNTLET,
4: EQUIP_SLOT_PANTS,
5: EQUIP_SLOT_BOOTS,
6: EQUIP_SLOT_WEAPON,
7: EQUIP_SLOT_SHIELD or ARROW,
8: EQUIP_SLOT_EARRING,
9: EQUIP_SLOT_NECKLACE,
10: EQUIP_SLOT_L_RING,
11: EQUIP_SLOT_R_RING,
*/

DECLARE @ItemID BIGINT
SET @ItemID = 0
-- 幻嘲
IF (@RefMailID <> 0)
BEGIN
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 1, @RefMailID, @DurMail
IF (@ItemID <= 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -8
END
END
-- 姑櫭伱
IF (@RefPantsID <> 0)
BEGIN
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 4, @RefPantsID, @DurPants
IF (@ItemID <= 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -9
END
END
-- Boots
IF (@RefBootsID <> 0)
BEGIN
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 5, @RefBootsID, @DurBoots
IF (@ItemID <= 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -10
END
END
-- Weapon
IF (@RefWeaponID <> 0)
BEGIN
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 6, @RefWeaponID, @DurWeapon
IF (@ItemID <= 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -11
END
END
-- 姑γ喢
IF (@RefShield <> 0)
BEGIN
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 7, @RefShield, @DurShield
IF (@ItemID <= 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -12
END
END
-- 脠そ脙 default访 急脜脙脟脩 公扁奥 脠懊脤睹掣 脠*幻 250俺甸脌脤 脠懊呺档 脟脭膊 脕脴疵. 脕脪脛隆?
IF (@DefaultArrow <> 0)
BEGIN
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 7, @DefaultArrow, 250
IF (@ItemID <= 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -13
END
END


-----------------------------------------------------------------------------
-- 3-2. 久喒脵脜 Inventory 浇访 脙ぢ棵
-- [久喒脵脜 脌脦潞ッ吤じ 浇访 5俺]
-- APPLY_AVATAR_SYSTEM脌脤 脌侩得嚫榧* 脙脽奥〉脟疵 潞脦潞脨
-----------------------------------------------------------------------------
--PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!
INSERT INTO _InventoryForAvatar(CharID, Slot, ItemID)
SELECT @NewCharID, cnt, 0
FROM _RefDummySlot with( nolock )
WHERE cnt < 5


IF (@@ERROR <> 0)
BEGIN
-- 久喒脵脜 脌脦潞ッ吤じ 幻郊潞 矫嚸喢!
ROLLBACK TRANSACTION
RETURN -14
END
--PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!

-----------------------------------------------------------------------------
-- default skill趁柧蠲伱柋
-----------------------------------------------------------------------------
DECLARE @country tinyINT
EXEC @country = _GetObjCountry @RefCharID

INSERT INTO _CharSkillMastery (CharID, MasteryID, Level)
SELECT @NewCharID, MasteryID, 0
FROM _RefCharDefault_SkillMastery with(nolock)
WHERE Race = @country or Race = 3
IF (@@error <> 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -15
END
INSERT INTO _CharSkill (CharID,SkillID,Enable)
SELECT @NewCharID, SkillID, 1
FROM _RefCharDefault_Skill with(nolock)
WHERE Race = @country or Race = 3
IF (@@error <> 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -16
END
-----------------------------------------------------------------------------
-- 扁潞 脛潞脝 趁柧蠲伱柋
-----------------------------------------------------------------------------
INSERT INTO _CharQuest (CharID, QuestID, Status, AchievementCount, StartTime, EndTime, QuestData1, QuestData2)
SELECT @NewCharID, ID, 1, 0, getdate(), getdate(), 0, 0
FROM _RefQuest
WHERE CodeName in (SELECT CodeName FROM _RefCharDefault_Quest with(nolock) WHERE (Race = @country or Race = 3) and RequiredLevel = 1 and Service = 1)
IF (@@error <> 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -17
END
-----------------------------------------------------------------------------
-- Static Avatar Initial Record 趁柋
-----------------------------------------------------------------------------
INSERT INTO _StaticAvatar(CharID) values(@NewCharID)
IF (@@ERROR <> 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -18
END

-----------------------------------------------------------------------------
-- Trijob 脙ぢ棵冻脰扁!!!!!
-----------------------------------------------------------------------------
INSERT INTO _CharTrijob VALUES (@NewCharID, 0, 1, 0, 0, 0)
IF (@@ERROR <> 0)
BEGIN
-- 脌脦潞ッ吤じ 幻郊潞 矫嚸喢!
ROLLBACK TRANSACTION
RETURN -19
END

-----------------------------------------------------------------------------
-- CharList驴隆 ID 趁柧蠲伱柋
-----------------------------------------------------------------------------
INSERT _CharNameList VALUES(@CharName, @NewCharID)

exec _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_E060118_60EXP_HELP',1,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_E060118_100EXP_HELP',1,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_SCROLL_RETURN_NEWBIE_01',20,1

-- Quick Slot 脕ぢ焊 脌煤脌氓驴!!!
exec _AddNewClientConfig @NewCharID -- by novice...... for saving client configurations...

COMMIT TRANSACTION

RETURN @NewCharID




严 阙 寝嗜怯
尴磴 25-01-2014, 03:52 AM   #5

Yui
谥 葳轻





轻卿苁苡芮 Sep 2012
艳茔 轻谲周骓苌 105332
轻阍苘芮堰芮 319
轻芟驷苌
轻苠苕琼苌 Hex,PHP,C#,SQL
怯茔 轻苡茼苎蒈 No Server
轻芴茕苡 Male
滢芮 轻兽眄 43
Yui 哲勤芟

Yui 垌 闶媲滔 颓犴丘


叛忧 延轻 谌 Yahoo 裴 Yui

禽恃侵



Use this query
哝 PHP:
USE SRO_VT_SHARD
UPDATE _RefCharGen set Service 
=
you get this error with all char or some char ?




严 阙 寝嗜怯
尴磴 25-01-2014, 03:52 AM   #6

Yui
谥 葳轻





轻卿苁苡芮 Sep 2012
艳茔 轻谲周骓苌 105332
轻阍苘芮堰芮 319
轻芟驷苌
轻苠苕琼苌 Hex,PHP,C#,SQL
怯茔 轻苡茼苎蒈 No Server
轻芴茕苡 Male
滢芮 轻兽眄 43
Yui 哲勤芟

Yui 垌 闶媲滔 颓犴丘


叛忧 延轻 谌 Yahoo 裴 Yui

禽恃侵



Use this query
哝 PHP:
USE SRO_VT_SHARD
UPDATE _RefCharGen set Service 
=
you get this error with all char or some char ?




严 阙 寝嗜怯
尴磴 25-01-2014, 03:53 AM   #7

uleader2
谥 葳轻





轻卿苁苡芮 Dec 2012
艳茔 轻谲周骓苌 107823
轻阍苘芮堰芮 246
轻芟驷苌
轻苠苕琼苌
怯茔 轻苡茼苎蒈
轻芴茕苡
滢芮 轻兽眄 10
uleader2 哲勤芟

uleader2 垌 闶媲滔 颓犴丘



禽恃侵



All Char




严 阙 寝嗜怯
尴磴 25-01-2014, 03:56 AM   #8

che_9299





轻卿苁苡芮 Feb 2013
艳茔 轻谲周骓苌 109807
轻阍苘芮堰芮 2,903
轻芟驷苌 怯咪涎礤
轻苠苕琼苌 妊闾
怯茔 轻苡茼苎蒈 No Server
轻芴茕苡 Male
滢芮 轻兽眄 100
che_9299 誊碥che_9299 誊碥

che_9299 垌 闶媲滔 颓犴丘



禽恃侵



厝 萄 襄
哝:
USE [SRO_VT_SHARD]
GO
/****** Object:  StoredProcedure [dbo].[_AddNewChar]    Script Date: 01/25/2014 01:43:29 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[_AddNewChar]
	@UserJID			INT,        
	--@CharSlot			INT,        
	@RefCharID			INT,        
	@CharName			varchar (64),        
	@CharScale			tinyINT,        
	@StartRegionID			INT,        
	@StartPos_X			real,        
	@StartPos_Y			real,        
	@StartPos_Z			real,        
	@DefaultTeleport	INT,        
	@RefMailID			INT,        
	@RefPantsID			INT,        
	@RefBootsID			INT,        
	@RefWeaponID		INT,        
	@RefShield			INT,        
	@DurMail			tinyINT,        
	@DurPants			tinyINT,        
	@DurBoots			tinyINT,        
	@DurWeapon			tinyINT,        
	@DurShield			tinyINT,        
	@DefaultArrow		INT        
AS    
    
SET NOCOUNT ON      

	DECLARE @Slot  INT        
	DECLARE @temp  INT        
	        
	DECLARE @NewCharID  INT        
	SET @NewCharID = 0        
       
       
	-----------------------------------------------------------------------------        
	-- 1. 脛掣吤 浇访 趁懝枚奥 valid脟脩 懊嵜脦脕枚, 弊府懊* 潞贸浇访斆脤 该偞脗脕枚 该暶煤 脙济叐脟脩疵.        
	-----------------------------------------------------------------------------        
	     
	-- start by novice.        
	SELECT @temp = count(CharID) FROM _User WITH (NOLOCK) WHERE UserJID = @UserJID        
	      
	IF (@temp >= 4)        
	BEGIN        
		-- 趁姽 腹脌脷陈        
		RETURN -2        
	END        
	-- finish by novice.        
      
	-----------------------------------------------------------------------------        
	-- 2. 脛掣吤 脙脽奥∶嚸彵        
	-----------------------------------------------------------------------------        
	IF (@CharScale > 68) -- 0100 0100 --> 68 脌脤疵!        
	BEGIN        
		-- 脛掣吤 幻郊潞 矫嚸喢! 铰好劽壝脧 奥脤 脌脤幻趁嚸彺脵!         
		RETURN -3        
	END
        
	EXEC @temp = _IsExistingCharName @CharName        
	IF (@temp <> 0)        
	BEGIN        
		-- 脌脤姑 荤驴朊伱熋脦 脌脤抚脌脤睹炒脗单?        
		RETURN -4        
	END        
    
BEGIN TRANSACTION
    
	-- 脌脦疵附脙铰好吤浢脤 脌侩得嚫榧* 付脕枚阜驴隆 WorldID驴脥 1奥 疵 趁柧 脕脰久捍脵!      
	INSERT INTO _Char (RefObjID, CharName16, Scale, Strength, Intellect, LatestRegion,PosX, PosY, PosZ, AppointedTeleport, InventorySize,      
				LastLogout, CurLevel, MaxLevel, RemainGold, RemainStatPoint, RemainSkillPoint, HP, MP, JobLvl_Trader, JobLvl_Hunter, JobLvl_Robber, WorldID)      
	VALUES (@RefCharID, @CharName, @CharScale, 20, 20, 24252, 589, -14.655776, 468, 2094, 109,
				GetDate(), 1, 1, 0, 0,0, 200,200, 1, 1, 1, 1)   
    
	SET @NewCharID = @@IDENTITY        
	IF (@@ERROR <> 0 OR @@ROWCOUNT = 0)        
	BEGIN        
		-- 脛掣吤 幻郊潞 矫嚸喢!        
		ROLLBACK TRANSACTION        
		RETURN -5        
	END        
	    
	       
	    
	       
	-- start by novice.        
	-- A?? Slot 綞敬碪.. 弊矱 Insert 父..        
	INSERT INTO _User VALUES (@UserJID, @NewCharID)  
	-- finish by novice.        
      
      
	 -----------------------------------------------------------------------------        
	 -- 3-1. 脌氓潞帽 浇访 脙ぢ棵        
	 -- [脌脦潞ッ吤じ 浇访 96俺] + [脌氓潞帽浇访 13俺] <- 脌脦潞ッ吤じ 脠氓 *潞帽铰 脠脛 48俺驴隆* 96俺访 脕玫奥!!!(woos0)
	 -----------------------------------------------------------------------------        
	 --PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!        
	 INSERT INTO _Inventory(CharID, Slot, ItemID)        
	  SELECT @NewCharID, cnt, 0        
	   FROM _RefDummySlot with( nolock )       
	    WHERE cnt < 109        

	      
	IF (@@ERROR <> 0)        
	BEGIN        
		-- 脌脦潞ッ吤じ 幻郊潞 矫嚸喢!        
		ROLLBACK TRANSACTION        
		RETURN -7         
	END        

	--PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!        
	       
	-- 得懊喢好啴访 急脜脙脟脩 久喢脤脜脹脌 疵櫧脙 趁柧蠲伱柮脷...        
	/* 驴盲繁 济讣*访  脕っ脟得嚲 脌脰疵.        
	0: EQUIP_SLOT_HELM        
	1: EQUIP_SLOT_MAIL,        
	2: EQUIP_SLOT_SHOULDERGUARD,        
	3: EQUIP_SLOT_GAUNTLET,        
	4: EQUIP_SLOT_PANTS,        
	5: EQUIP_SLOT_BOOTS,        
	6: EQUIP_SLOT_WEAPON,        
	7: EQUIP_SLOT_SHIELD or ARROW,        
	8: EQUIP_SLOT_EARRING,        
	9: EQUIP_SLOT_NECKLACE,        
	10: EQUIP_SLOT_L_RING,        
	11: EQUIP_SLOT_R_RING,        
	*/        
	       
	DECLARE @ItemID BIGINT        
	SET @ItemID = 0        
	-- 幻嘲        
	IF (@RefMailID <> 0)        
	BEGIN        
		EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 1, @RefMailID, @DurMail        
		IF (@ItemID <= 0)        
		BEGIN        
			ROLLBACK TRANSACTION        
			RETURN -8       
		END        
	END        
	-- 姑櫭伱        
	IF (@RefPantsID <> 0)        
	BEGIN        
		EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 4, @RefPantsID, @DurPants        
		IF (@ItemID <= 0)        
		BEGIN        
			ROLLBACK TRANSACTION        
			RETURN -9        
		END        
	END        
	-- Boots        
	IF (@RefBootsID <> 0)        
	BEGIN        
		EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 5, @RefBootsID, @DurBoots        
		IF (@ItemID <= 0)        
		BEGIN        
			ROLLBACK TRANSACTION        
			RETURN -10        
		END        
	END        
	-- Weapon        
	IF (@RefWeaponID <> 0)        
	BEGIN        
		EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 6, @RefWeaponID, @DurWeapon        
		IF (@ItemID <= 0)        
		BEGIN        
			ROLLBACK TRANSACTION        
			RETURN -11        
		END        
	END        
	-- 姑γ喢        
	IF (@RefShield <> 0)        
	BEGIN        
		EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 7, @RefShield, @DurShield        
		IF (@ItemID <= 0)        
		BEGIN        
			ROLLBACK TRANSACTION        
			RETURN -12        
		END        
	END        
	-- 脠そ脙 default访 急脜脙脟脩 公扁奥 脠懊脤睹掣 脠*幻 250俺甸脌脤 脠懊呺档 脟脭膊 脕脴疵. 脕脪脛隆?        
	IF (@DefaultArrow <> 0)        
	BEGIN        
		EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 7, @DefaultArrow, 250        
		IF (@ItemID <= 0)        
		BEGIN        
			ROLLBACK TRANSACTION        
			RETURN -13        
		END        
	END


	 -----------------------------------------------------------------------------        
	 -- 3-2. 久喒脵脜 Inventory 浇访 脙ぢ棵        
	 -- [久喒脵脜 脌脦潞ッ吤じ 浇访 5俺]
	 -- APPLY_AVATAR_SYSTEM脌脤 脌侩得嚫榧* 脙脽奥〉脟疵 潞脦潞脨
	 -----------------------------------------------------------------------------        
	 --PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!        
	 INSERT INTO _InventoryForAvatar(CharID, Slot, ItemID)        
	  SELECT @NewCharID, cnt, 0
	   FROM _RefDummySlot with( nolock )       
	    WHERE cnt < 5

	      
	IF (@@ERROR <> 0)        
	BEGIN        
		-- 久喒脵脜 脌脦潞ッ吤じ 幻郊潞 矫嚸喢!        
		ROLLBACK TRANSACTION        
		RETURN -14
	END        
	--PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!        
	      
	-----------------------------------------------------------------------------        
	-- default skill趁柧蠲伱柋        
	-----------------------------------------------------------------------------        
	DECLARE @country tinyINT        
	EXEC @country = _GetObjCountry @RefCharID        
	       
	INSERT INTO _CharSkillMastery (CharID, MasteryID, Level)        
	SELECT @NewCharID, MasteryID, 0        
	FROM _RefCharDefault_SkillMastery  with(nolock)      
	WHERE Race = @country or Race = 3        
	IF (@@error <> 0)        
	BEGIN        
		ROLLBACK TRANSACTION        
		RETURN -15        
	END        
	INSERT INTO _CharSkill (CharID,SkillID,Enable)        
	SELECT @NewCharID, SkillID, 1        
	FROM  _RefCharDefault_Skill  with(nolock)      
	WHERE Race = @country or Race = 3        
	IF (@@error <> 0)        
	BEGIN        
		ROLLBACK TRANSACTION        
		RETURN -16        
	END        
	-----------------------------------------------------------------------------        
	-- 扁潞 脛潞脝 趁柧蠲伱柋
	-----------------------------------------------------------------------------        
	INSERT INTO _CharQuest (CharID, QuestID, Status, AchievementCount, StartTime, EndTime, QuestData1, QuestData2)        
	SELECT @NewCharID, ID, 1, 0, getdate(), getdate(), 0, 0        
	FROM _RefQuest
	WHERE CodeName in (SELECT CodeName FROM _RefCharDefault_Quest  with(nolock) WHERE (Race = @country or Race = 3) and RequiredLevel = 1 and Service = 1)
	IF (@@error <> 0)
	BEGIN
		ROLLBACK TRANSACTION        
		RETURN -17        
	END    
	-----------------------------------------------------------------------------        
	-- Static Avatar Initial Record 趁柋        
	-----------------------------------------------------------------------------        
	INSERT INTO _StaticAvatar(CharID) values(@NewCharID)        
	IF (@@ERROR <> 0)        
	BEGIN        
		ROLLBACK TRANSACTION        
		RETURN -18        
	END         
	      
	-----------------------------------------------------------------------------        
	-- Trijob 脙ぢ棵冻脰扁!!!!!        
	-----------------------------------------------------------------------------        
	INSERT INTO _CharTrijob VALUES (@NewCharID, 0, 1, 0, 0, 0)        
	IF (@@ERROR <> 0)        
	BEGIN        
		-- 脌脦潞ッ吤じ 幻郊潞 矫嚸喢!        
		ROLLBACK TRANSACTION        
		RETURN -19        
	END         
	      
	-----------------------------------------------------------------------------        
	-- CharList驴隆 ID 趁柧蠲伱柋        
	-----------------------------------------------------------------------------        
	INSERT _CharNameList VALUES(@CharName, @NewCharID)        

BEGIN

exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_COS_C_PEGASUS_SCROLL',5,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_HP_SUPERSET_5_BAG',8000,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_MP_SUPERSET_5_BAG',8000,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_ARCHEMY_POTION_SPEED_11',10,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_RESURRECTION_100P_SCROLL',10,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_HWAN_POTION',10,1
END 

	-- Quick Slot 脕ぢ焊 脌煤脌氓驴!!!        
	exec _AddNewClientConfig @NewCharID  -- by novice...... for saving client configurations...        

COMMIT TRANSACTION        
	      
RETURN @NewCharID




严 阙 寝嗜怯
尴磴 25-01-2014, 03:59 AM   #9

uleader2
谥 葳轻





轻卿苁苡芮 Dec 2012
艳茔 轻谲周骓苌 107823
轻阍苘芮堰芮 246
轻芟驷苌
轻苠苕琼苌
怯茔 轻苡茼苎蒈
轻芴茕苡
滢芮 轻兽眄 10
uleader2 哲勤芟

uleader2 垌 闶媲滔 颓犴丘



禽恃侵



糖 琼蜒嫜 软捩犴

Msg 213, Level 16, State 1, Procedure _AddNewChar, Line 258
Column name or number of supplied values does not match table definition.

襄 漭 轻琼焰 轻犴 软添犴 蓓 轻 SHARDMANAGER 徙 融汜 Char.




严 阙 寝嗜怯
尴磴 25-01-2014, 04:07 AM   #10

uleader2
谥 葳轻





轻卿苁苡芮 Dec 2012
艳茔 轻谲周骓苌 107823
轻阍苘芮堰芮 246
轻芟驷苌
轻苠苕琼苌
怯茔 轻苡茼苎蒈
轻芴茕苡
滢芮 轻兽眄 10
uleader2 哲勤芟

uleader2 垌 闶媲滔 颓犴丘



禽恃侵



Solved :D :D Che_9299 Thnaks




严 阙 寝嗜怯
尴磴 25-01-2014, 04:10 AM   #11

che_9299





轻卿苁苡芮 Feb 2013
艳茔 轻谲周骓苌 109807
轻阍苘芮堰芮 2,903
轻芟驷苌 怯咪涎礤
轻苠苕琼苌 妊闾
怯茔 轻苡茼苎蒈 No Server
轻芴茕苡 Male
滢芮 轻兽眄 100
che_9299 誊碥che_9299 誊碥

che_9299 垌 闶媲滔 颓犴丘



禽恃侵



u r w
##




严 阙 寝嗜怯
尴磴 19-02-2014, 08:04 AM   #12

禽湎礓荰M.Lion.TM
谥 湓磉



轻真焉 轻雁翼 禽湎礓荰M.Lion.TM


轻卿苁苡芮 Jan 2014
艳茔 轻谲周骓苌 115979
轻阍苘芮堰芮 72
轻芟驷苌 Fisal
轻苠苕琼苌 阌勤 蓓 阢 轻友菅鞘 阌勤 蓓 妊倾 轻M-BOT 阌勤 蓓 妊倾 菔 轻友菅
怯茔 轻苡茼苎蒈 Private Server
轻芴茕苡 Male
滢芮 轻兽眄 10
禽湎礓荰M.Lion.TM 哲勤芟

禽湎礓荰M.Lion.TM 垌 闶媲滔 颓犴丘



禽恃侵



砬 蹄阱 卿 妊湘 漭 轻哚倾 硌 轻歪 驿软 涎嫜礤 享 真彦 谳媲 ,,, 崆磴咪 阍清襄 轻焰侨 崆溥 垌 阌提 嵯礓 [ 後视添 侵圬 邃 ]
:weeping ::wee ping:


舒揄 禽湎礓荰M.Lion.TM :
Magdy.THeKings
Ceep Calm And Developer


严 阙 寝嗜怯
胖禽 严

轻哚闱 轻厢磲砩
认驿


硎蛰 轻沔宙 颓犴丘 : 1 (0 谥 1 仪蒲)
 

宙侨 轻阍茄呱
视守碲 胖禽 沔侵碲 滔硐
视守碲 轻严 卺 轻沔侵碲
视守碲 叛萸 汜萸
视守碲 授享 阍茄咔蔬

BB code 闶峭
[IMG] 闶峭
哝 HTML 阙蒯

轻卿兽轻 轻友碲

轻沔侵碲 轻闶郧儒
轻沔宙 咔嗜 轻沔宙 轻沅氏 轻严嫦 挛 阍茄呱
茄替 轻歪 阍哚 垩砣 khaledowies 抻 轻怯漆 轻怯瘦忧亚 嶷汜 轻禹演亚 轻吻丈 4 14-04-2018 09:04 PM
阍哚 垩砣 翘媲 轻歪 moftah 捃榆 轻怯芷茚苠 轻怯苁茌苡芮亚 蛙驷 轻茚苴苋苌 4 23-11-2015 09:47 PM
阍哚 垩砣 醚替 轻歪 @ShiNiG4Mi@ 抻 轻怯瘦忧亚 驺郧哚 嫱徭 轻 Mbot 4 04-06-2015 12:04 PM
阍哚 垩砣 媲烟 轻歪 deathbat2010 抻 轻怯漆 轻怯瘦忧亚 嶷汜 轻禹演亚 轻吻丈 11 28-11-2012 07:22 PM


轻忧谏 轻落 12:35 AM.