Can't Create a new char Error(s1030) HELP

USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_AddNewChar] Script Date: 3/25/2015 6:09:14 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO




ALTER PROCEDURE [dbo].[_AddNewChar]
  [MENTION=292919]user[/MENTION]JID INT, 
--@CharSlot INT,  [MENTION=1326241]REF[/MENTION]CharID INT, 
@CharName varchar (64), 
@CharScale tinyINT, 
  [MENTION=351783]start[/MENTION]RegionID INT, 
  [MENTION=351783]start[/MENTION]Pos_X real, 
  [MENTION=351783]start[/MENTION]Pos_Y real, 
  [MENTION=351783]start[/MENTION]Pos_Z real, 
@DefaultTeleport INT,  [MENTION=1326241]REF[/MENTION]MailID INT,  [MENTION=1326241]REF[/MENTION]PantsID INT,  [MENTION=1326241]REF[/MENTION]BootsID INT,  [MENTION=1326241]REF[/MENTION]WeaponID INT, 
  [MENTION=1830489]refs[/MENTION]hield INT, 
@DurMail tinyINT,  [MENTION=822124]Durp[/MENTION]ants tinyINT, 
@DurBoots tinyINT, 
@DurWeapon tinyINT,  [MENTION=4821630]durs[/MENTION]hield tinyINT, 
@DefaultArrow INT 
AS 

SET NOCOUNT ON 

DECLARE  [MENTION=303108]slot[/MENTION] INT 
DECLARE  [MENTION=337901]temp[/MENTION] INT 

DECLARE [MENTION=993253]newchar[/MENTION]ID INT 
SET [MENTION=993253]newchar[/MENTION]ID = 0 


----------------------------------------------------------------------------- 
-- 1. ij¸¯ÅÍ ½½·Ô ³Ñ¹ö°¡ validÇÑ °ÍÀÎÁö, ±×¸®°í ºó½½·ÔÀÌ ¸Â´ÂÁö ¸ÕÀú üũÇÑ´Ù. 
----------------------------------------------------------------------------- 

-- start by novice. 
SELECT  [MENTION=337901]temp[/MENTION] = count(CharID) FROM _User WITH (NOLOCK) WHERE UserJID =  [MENTION=292919]user[/MENTION]JID 

IF   [MENTION=337901]temp[/MENTION] >= 4) 
BEGIN 
-- ³Ê¹« ¸¹ÀÚ³ª 
RETURN -2 
END 
-- finish by novice. 

----------------------------------------------------------------------------- 
-- 2. ij¸¯ÅÍ Ãß°¡Çϱâ 
----------------------------------------------------------------------------- 
IF (@CharScale > 68) -- 0100 0100 --> 68 ÀÌ´Ù! 
BEGIN 
-- ij¸¯ÅÍ »ý¼º ½ÇÆÐ! ½ºÄÉÀÏ °ªÀÌ ÀÌ»óÇÏ´Ù! 
RETURN -3 
END

EXEC  [MENTION=337901]temp[/MENTION] = _IsExistingCharName @CharName 
IF   [MENTION=337901]temp[/MENTION] <> 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  [MENTION=1326241]REF[/MENTION]CharID, @CharName, @CharScale, 20, 20,  [MENTION=351783]start[/MENTION]RegionID,  [MENTION=351783]start[/MENTION]Pos_X,  [MENTION=351783]start[/MENTION]Pos_Y,  [MENTION=351783]start[/MENTION]Pos_Z, @DefaultTeleport, 109, 
GetDate(), 1, 1, 100000, 0, 50000, 200,200, 1, 1, 1, 1) 

SET [MENTION=993253]newchar[/MENTION]ID = @@IDENTITY 
IF (@@ERROR <> 0 OR @@ROWCOUNT = 0) 
BEGIN 
-- ij¸¯ÅÍ »ý¼º ½ÇÆÐ! 
ROLLBACK TRANSACTION 
RETURN -5 
END 


-- start by novice. 
-- ÀÌÁ¦ Slot ¾È¾´´Ù.. ±×³É Insert ¸¸.. 
INSERT INTO _User VALUES   [MENTION=292919]user[/MENTION]JID, [MENTION=993253]newchar[/MENTION]ID) 
-- 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 [MENTION=993253]newchar[/MENTION]ID, 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 [MENTION=1134588]item[/MENTION]ID BIGINT 
SET [MENTION=1134588]item[/MENTION]ID = 0 
-- »ó°© 
IF  [MENTION=1326241]REF[/MENTION]MailID <> 0) 
BEGIN 
EXEC [MENTION=1134588]item[/MENTION]ID = _FN_ADD_INITIAL_EQUIP [MENTION=993253]newchar[/MENTION]ID, 1, [MENTION=1326241]REF[/MENTION]MailID, @DurMail 
IF  [MENTION=1134588]item[/MENTION]ID <= 0) 
BEGIN 
ROLLBACK TRANSACTION 
RETURN -8 
END 
END 
-- ¹ÙÁö 
IF  [MENTION=1326241]REF[/MENTION]PantsID <> 0) 
BEGIN 
EXEC [MENTION=1134588]item[/MENTION]ID = _FN_ADD_INITIAL_EQUIP [MENTION=993253]newchar[/MENTION]ID, 4, [MENTION=1326241]REF[/MENTION]PantsID, [MENTION=822124]Durp[/MENTION]ants 
IF  [MENTION=1134588]item[/MENTION]ID <= 0) 
BEGIN 
ROLLBACK TRANSACTION 
RETURN -9 
END 
END 
-- Boots 
IF  [MENTION=1326241]REF[/MENTION]BootsID <> 0) 
BEGIN 
EXEC [MENTION=1134588]item[/MENTION]ID = _FN_ADD_INITIAL_EQUIP [MENTION=993253]newchar[/MENTION]ID, 5, [MENTION=1326241]REF[/MENTION]BootsID, @DurBoots 
IF  [MENTION=1134588]item[/MENTION]ID <= 0) 
BEGIN 
ROLLBACK TRANSACTION 
RETURN -10 
END 
END 
-- Weapon 
IF  [MENTION=1326241]REF[/MENTION]WeaponID <> 0) 
BEGIN 
EXEC [MENTION=1134588]item[/MENTION]ID = _FN_ADD_INITIAL_EQUIP [MENTION=993253]newchar[/MENTION]ID, 6, [MENTION=1326241]REF[/MENTION]WeaponID, @DurWeapon 
IF  [MENTION=1134588]item[/MENTION]ID <= 0) 
BEGIN 
ROLLBACK TRANSACTION 
RETURN -11 
END 
END 
-- ¹æÆÐ 
IF   [MENTION=1830489]refs[/MENTION]hield <> 0) 
BEGIN 
EXEC [MENTION=1134588]item[/MENTION]ID = _FN_ADD_INITIAL_EQUIP [MENTION=993253]newchar[/MENTION]ID, 7,  [MENTION=1830489]refs[/MENTION]hield, [MENTION=4821630]durs[/MENTION]hield 
IF  [MENTION=1134588]item[/MENTION]ID <= 0) 
BEGIN 
ROLLBACK TRANSACTION 
RETURN -12 
END 
END 
-- Ȥ½Ã default·Î ¼±ÅÃÇÑ ¹«±â°¡ È°À̶ó¸é È*»ì 250°³µéÀÌ È°Åëµµ ÇÔ²² ÁØ´Ù. ÁÒÄ¡? 
IF (@DefaultArrow <> 0) 
BEGIN 
EXEC [MENTION=1134588]item[/MENTION]ID = _FN_ADD_INITIAL_EQUIP [MENTION=993253]newchar[/MENTION]ID, 7, @DefaultArrow, 250 
IF  [MENTION=1134588]item[/MENTION]ID <= 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 [MENTION=993253]newchar[/MENTION]ID, 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 [MENTION=1326241]REF[/MENTION]CharID 

INSERT INTO _CharSkillMastery (CharID, MasteryID, Level) 
SELECT [MENTION=993253]newchar[/MENTION]ID, 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 [MENTION=993253]newchar[/MENTION]ID, 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 [MENTION=993253]newchar[/MENTION]ID, 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 [MENTION=993253]newchar[/MENTION]ID) 
IF (@@ERROR <> 0) 
BEGIN 
ROLLBACK TRANSACTION 
RETURN -18 
END 

----------------------------------------------------------------------------- 
-- Trijob ä¿ö³Ö±â!!!!! 
----------------------------------------------------------------------------- 
INSERT INTO _CharTrijob VALUES  [MENTION=993253]newchar[/MENTION]ID, 0, 1, 0, 0, 0) 
IF (@@ERROR <> 0) 
BEGIN 
-- Àκ¥Å丮 »ý¼º ½ÇÆÐ! 
ROLLBACK TRANSACTION 
RETURN -19 
END 

----------------------------------------------------------------------------- 
-- CharList¿¡ ID ³Ö¾îÁÖ±â 
----------------------------------------------------------------------------- 
INSERT _CharNameList VALUES(@CharName, [MENTION=993253]newchar[/MENTION]ID) 
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_RENT_REVERSE_RETURN_SCROLL', 20000,1 
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_PREMIUM_GLOBAL_GOLDTIME',1,1 
exec _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_SCROLL_RETURN_03',20,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_SPEED_UP_BASIC',20,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_COS_P_GHOST_SCROLL',0,0

-- Quick Slot Á¤º¸ ÀúÀå¿ë!!! 
exec _AddNewClientConfig [MENTION=993253]newchar[/MENTION]ID -- by novice...... for saving client configurations... 

UPDATE _RefCharDefault_Quest SET Service = 1
delete from _CHARQUEST where QuestID = 1
INSERT INTO _CharQuest (CharID, QuestID, Status,AchievementCount,StartTime,EndTime,QuestDat a1,QuestData2) SELECT CharID, 1,5,0, '2012-04-13 20:44:00','2012-04-13 20:44:00',31458135,0 FROM _CHAR where CharID > 0 

COMMIT TRANSACTION 

RETURN [MENTION=993253]newchar[/MENTION]ID