Add full equip +5 to new chars [VSRO 1.188]

[arabcart]

Credit for Original SP to : lemoniscool

All Edit for Me ^^
Fixed Now Work with all Race and Shield Problem Fixed ^^

USE [SRO_VT_SHARD]
GO
/****** Object:  StoredProcedure [dbo].[_AddNewChar]    Script Date: 11/27/2013 09:59:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
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        
 
 -- Initial Equip Edit by LemoniscooL
 DECLARE @RefHandID INT
 DECLARE @RefHatID INT
 DECLARE @RefShoulderID INT
 DECLARE @RefEarringID INT
 DECLARE @RefRingID INT
 DECLARE @RefNeckID INT
 DECLARE @DurHand INT
 DECLARE @DurHat INT
 DECLARE @DurShoulder INT
 DECLARE @DurEarring INT
 DECLARE @DurRing INT
 DECLARE @DurNeck INT
 
 --Male Clothes Chinese
 IF (@RefMailID = 3643) BEGIN
	SET @RefHandID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_CLOTHES_10_AA_C_RARE')
	SET @RefMailID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_CLOTHES_10_BA_C_RARE')
	SET @RefBootsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_CLOTHES_10_FA_C_RARE')
	SET @RefHatID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_CLOTHES_10_HA_C_RARE')
	SET @RefPantsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_CLOTHES_10_LA_C_RARE')
	SET @RefShoulderID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_CLOTHES_10_SA_C_RARE')
	SET @RefEarringID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_EARRING_10_C_RARE')
	SET @RefNeckID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_NECKLACE_10_C_RARE')
	SET @RefRingID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_RING_10_C_RARE')
 END
 
 --Male Heavy Armor Chinese
 IF (@RefMailID = 3637) BEGIN
	SET @RefHandID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_HEAVY_10_AA_C_RARE')
	SET @RefMailID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_HEAVY_10_BA_C_RARE')
	SET @RefBootsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_HEAVY_10_FA_C_RARE')
	SET @RefHatID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_HEAVY_10_HA_C_RARE')
	SET @RefPantsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_HEAVY_10_LA_C_RARE')
	SET @RefShoulderID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_HEAVY_10_SA_C_RARE')
	SET @RefEarringID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_EARRING_10_C_RARE')
	SET @RefNeckID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_NECKLACE_10_C_RARE')
	SET @RefRingID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_RING_10_C_RARE')
 END
 
 --Male Light Armor Chinese
 IF (@RefMailID = 3640) BEGIN
	SET @RefHandID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_LIGHT_10_AA_C_RARE')
	SET @RefMailID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_LIGHT_10_BA_C_RARE')
	SET @RefBootsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_LIGHT_10_FA_C_RARE')
	SET @RefHatID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_LIGHT_10_HA_C_RARE')
	SET @RefPantsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_LIGHT_10_LA_C_RARE')
	SET @RefShoulderID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_LIGHT_10_SA_C_RARE')
	SET @RefEarringID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_EARRING_10_C_RARE')
	SET @RefNeckID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_NECKLACE_10_C_RARE')
	SET @RefRingID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_RING_10_C_RARE')
 END
 
 --Female Clothes Chinese
 IF (@RefMailID = 3652) BEGIN
	SET @RefHandID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_CLOTHES_10_AA_C_RARE')
	SET @RefMailID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_CLOTHES_10_BA_C_RARE')
	SET @RefBootsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_CLOTHES_10_FA_C_RARE')
	SET @RefHatID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_CLOTHES_10_HA_C_RARE')
	SET @RefPantsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_CLOTHES_10_LA_C_RARE')
	SET @RefShoulderID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_CLOTHES_10_SA_C_RARE')
	SET @RefEarringID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_EARRING_10_C_RARE')
	SET @RefNeckID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_NECKLACE_10_C_RARE')
	SET @RefRingID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_RING_10_C_RARE')
 END
 
 --Female Heavy Armor Chinese
 IF (@RefMailID = 3646) BEGIN
	SET @RefHandID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_HEAVY_10_AA_C_RARE')
	SET @RefMailID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_HEAVY_10_BA_C_RARE')
	SET @RefBootsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_HEAVY_10_FA_C_RARE')
	SET @RefHatID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_HEAVY_10_HA_C_RARE')
	SET @RefPantsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_HEAVY_10_LA_C_RARE')
	SET @RefShoulderID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_HEAVY_10_SA_C_RARE')
	SET @RefEarringID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_EARRING_10_C_RARE')
	SET @RefNeckID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_NECKLACE_10_C_RARE')
	SET @RefRingID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_RING_10_C_RARE')
 END
 
 --Female Light Armor Chinese
 IF (@RefMailID = 3649) BEGIN
	SET @RefHandID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_LIGHT_10_AA_C_RARE')
	SET @RefMailID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_LIGHT_10_BA_C_RARE')
	SET @RefBootsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_LIGHT_10_FA_C_RARE')
	SET @RefHatID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_LIGHT_10_HA_C_RARE')
	SET @RefPantsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_LIGHT_10_LA_C_RARE')
	SET @RefShoulderID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_LIGHT_10_SA_C_RARE')
	SET @RefEarringID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_EARRING_10_C_RARE')
	SET @RefNeckID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_NECKLACE_10_C_RARE')
	SET @RefRingID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_RING_10_C_RARE')
 END
 
 --Male Clothes Europe
 IF (@RefMailID = 11623) BEGIN
	SET @RefHandID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_CLOTHES_10_AA_C_RARE')
	SET @RefMailID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_CLOTHES_10_BA_C_RARE')
	SET @RefBootsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_CLOTHES_10_FA_C_RARE')
	SET @RefHatID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_CLOTHES_10_HA_C_RARE')
	SET @RefPantsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_CLOTHES_10_LA_C_RARE')
	SET @RefShoulderID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_CLOTHES_10_SA_C_RARE')
	SET @RefEarringID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_EARRING_10_C_RARE')
	SET @RefNeckID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_NECKLACE_10_C_RARE')
	SET @RefRingID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_RING_10_C_RARE')
 END
 
 --Male Heavy Armor Europe
 IF (@RefMailID = 11617) BEGIN
	SET @RefHandID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_HEAVY_10_AA_C_RARE')
	SET @RefMailID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_HEAVY_10_BA_C_RARE')
	SET @RefBootsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_HEAVY_10_FA_C_RARE')
	SET @RefHatID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_HEAVY_10_HA_C_RARE')
	SET @RefPantsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_HEAVY_10_LA_C_RARE')
	SET @RefShoulderID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_HEAVY_10_SA_C_RARE')
	SET @RefEarringID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_EARRING_10_C_RARE')
	SET @RefNeckID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_NECKLACE_10_C_RARE')
	SET @RefRingID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_RING_10_C_RARE')
 END
 
 --Male Light Armor Europe
 IF (@RefMailID = 11620) BEGIN
	SET @RefHandID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_LIGHT_10_AA_C_RARE')
	SET @RefMailID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_LIGHT_10_BA_C_RARE')
	SET @RefBootsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_LIGHT_10_FA_C_RARE')
	SET @RefHatID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_LIGHT_10_HA_C_RARE')
	SET @RefPantsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_LIGHT_10_LA_C_RARE')
	SET @RefShoulderID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_LIGHT_10_SA_C_RARE')
	SET @RefEarringID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_EARRING_10_C_RARE')
	SET @RefNeckID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_NECKLACE_10_C_RARE')
	SET @RefRingID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_RING_10_C_RARE')
 END
 
 --Female Clothes Europe
 IF (@RefMailID = 11632) BEGIN
	SET @RefHandID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_CLOTHES_10_AA_C_RARE')
	SET @RefMailID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_CLOTHES_10_BA_C_RARE')
	SET @RefBootsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_CLOTHES_10_FA_C_RARE')
	SET @RefHatID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_CLOTHES_10_HA_C_RARE')
	SET @RefPantsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_CLOTHES_10_LA_C_RARE')
	SET @RefShoulderID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_CLOTHES_10_SA_C_RARE')
	SET @RefEarringID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_EARRING_10_C_RARE')
	SET @RefNeckID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_NECKLACE_10_C_RARE')
	SET @RefRingID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_RING_10_C_RARE')
 END
 
 --Female Heavy Armor Europe
 IF (@RefMailID = 11626) BEGIN
	SET @RefHandID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_HEAVY_10_AA_C_RARE')
	SET @RefMailID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_HEAVY_10_BA_C_RARE')
	SET @RefBootsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_HEAVY_10_FA_C_RARE')
	SET @RefHatID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_HEAVY_10_HA_C_RARE')
	SET @RefPantsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_HEAVY_10_LA_C_RARE')
	SET @RefShoulderID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_HEAVY_10_SA_C_RARE')
	SET @RefEarringID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_EARRING_10_C_RARE')
	SET @RefNeckID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_NECKLACE_10_C_RARE')
	SET @RefRingID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_RING_10_C_RARE')
 END
 
 --Female Light Armor Europe
 IF (@RefMailID = 11629) BEGIN
	SET @RefHandID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_LIGHT_10_AA_C_RARE')
	SET @RefMailID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_LIGHT_10_BA_C_RARE')
	SET @RefBootsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_LIGHT_10_FA_C_RARE')
	SET @RefHatID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_LIGHT_10_HA_C_RARE')
	SET @RefPantsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_LIGHT_10_LA_C_RARE')
	SET @RefShoulderID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_LIGHT_10_SA_C_RARE')
	SET @RefEarringID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_EARRING_10_C_RARE')
	SET @RefNeckID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_NECKLACE_10_C_RARE')
	SET @RefRingID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_RING_10_C_RARE')
 END
 
 --Shield Chinese
 IF (@RefShield = 10886) BEGIN
	SET @RefShield = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_SHIELD_10_C_RARE')
 END
 
 --Shield Europe
 IF (@RefShield = 10896) BEGIN
	SET @RefShield = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_SHIELD_10_C_RARE')
 END
 
 --Blade Chinese
 IF (@RefWeaponID = 3633) BEGIN
	SET @RefWeaponID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_BLADE_10_C_RARE')
 END
 
 --Bow Chinese
 IF (@RefWeaponID = 3636) BEGIN
	SET @RefWeaponID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_BOW_10_C_RARE')
 END
 
 --Spear Chinese
 IF (@RefWeaponID = 3634) BEGIN
	SET @RefWeaponID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_SPEAR_10_C_RARE')
 END
 
 --Sword Chinese
 IF (@RefWeaponID = 3632) BEGIN
	SET @RefWeaponID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_SWORD_10_C_RARE')
 END
 
 --Glavie Chinese
 IF (@RefWeaponID = 3635) BEGIN
	SET @RefWeaponID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_TBLADE_10_C_RARE')
 END
 
 --Axe Europe
 IF (@RefWeaponID = 10890) BEGIN
	SET @RefWeaponID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_AXE_10_C_RARE')
 END
 
 --XBow Europe
 IF (@RefWeaponID = 10891) BEGIN
	SET @RefWeaponID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_CROSSBOW_10_C_RARE')
 END
 
 --Dagger Europe
 IF (@RefWeaponID = 10887) BEGIN
	SET @RefWeaponID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_DAGGER_10_C_RARE')
 END
 
 --Darkstaff Europe
 IF (@RefWeaponID = 10892) BEGIN
	SET @RefWeaponID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_DARKSTAFF_10_C_RARE')
 END
 
 --Harp Europe
 IF (@RefWeaponID = 10894) BEGIN
	SET @RefWeaponID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_HARP_10_C_RARE')
 END
 
 --Cleric Rod Europe
 IF (@RefWeaponID = 10895) BEGIN
	SET @RefWeaponID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_STAFF_10_C_RARE')
 END
 
 --Sword Europe
 IF (@RefWeaponID = 10888) BEGIN
	SET @RefWeaponID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_SWORD_10_C_RARE')
 END
 
 --Staff Europe
 IF (@RefWeaponID = 10893) BEGIN
	SET @RefWeaponID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_TSTAFF_10_C_RARE')
 END
 
 --Twohand Sword Europe
 IF (@RefWeaponID = 10889) BEGIN
	SET @RefWeaponID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_TSWORD_10_C_RARE')
 END
 
 --Select Durability
 SET @DurHand = (Select Dur_L from _RefObjItem where ID in (Select Link from _RefObjCommon where ID = @RefHandID))
 SET @DurMail = (Select Dur_L from _RefObjItem where ID in (Select Link from _RefObjCommon where ID = @RefMailID))
 SET @DurBoots = (Select Dur_L from _RefObjItem where ID in (Select Link from _RefObjCommon where ID = @RefBootsID))
 SET @DurHat = (Select Dur_L from _RefObjItem where ID in (Select Link from _RefObjCommon where ID = @RefHatID))
 SET @DurPants = (Select Dur_L from _RefObjItem where ID in (Select Link from _RefObjCommon where ID = @RefPantsID))
 SET @DurShoulder = (Select Dur_L from _RefObjItem where ID in (Select Link from _RefObjCommon where ID = @RefShoulderID))
 SET @DurWeapon = (Select Dur_L from _RefObjItem where ID in (Select Link from _RefObjCommon where ID = @RefWeaponID))
 SET @DurShield = (Select Dur_L from _RefObjItem where ID in (Select Link from _RefObjCommon where ID = @RefShield))
 SET @DurEarring = (Select Dur_L from _RefObjItem where ID in (Select Link from _RefObjCommon where ID = @RefEarringID))
 SET @DurRing = (Select Dur_L from _RefObjItem where ID in (Select Link from _RefObjCommon where ID = @RefRingID))
 SET @DurNeck = (Select Dur_L from _RefObjItem where ID in (Select Link from _RefObjCommon where ID = @RefNeckID))
 -- Initial Equip Edit by LemoniscooL
 
 --set @StartRegionID=25000
 -----------------------------------------------------------------------------    
 -- 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. ij¸¯ÅÍ Ãß°¡Ç챉        
	-----------------------------------------------------------------------------        
	IF (@CharScale > 68) -- 0100 0100 --> 68 ÀÌ´Ù!        
	BEGIN        
		-- ij¸¯ÅÍ »ý¼º ½ÇÆÐ! ½ºÄÉÀÏ °ªÀÌ ÀÌ»óÇÏ´Ù!         
		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, DailyPK)      
	VALUES (@RefCharID, @CharName, @CharScale, 20, 20, @StartRegionID, @StartPos_X, @StartPos_Y, @StartPos_Z, @DefaultTeleport, 45,      
				GetDate(), 1, 1, 25000000, 0, 0, 200,200, 1, 1, 1, 1, 50)      
    
	SET @NewCharID = @@IDENTITY        
	IF (@@ERROR <> 0 OR @@ROWCOUNT = 0)        
	BEGIN        
		-- ij¸¯ÅÍ »ý¼º ½ÇÆÐ!        
		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,    
 */    

 -- Initial Equip Edit by LemoniscooL
 DECLARE @ItemID BIGINT    
 SET @ItemID = 0    
 -- Chest
 IF (@RefMailID <> 0) BEGIN
	EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 1, @RefMailID, @DurMail
	IF (@ItemID <= 0) BEGIN
		ROLLBACK TRANSACTION
		RETURN -8
	END
 END
 -- Hand
 IF (@RefHandID <> 0) BEGIN
	EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 3, @RefHandID, @DurHand
	IF (@ItemID <= 0) BEGIN
		ROLLBACK TRANSACTION
		RETURN -8
	END
 END
 -- Hat
 IF (@RefHatID <> 0) BEGIN
	EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 0, @RefHatID, @DurHat
	IF (@ItemID <= 0) BEGIN
		ROLLBACK TRANSACTION
		RETURN -8
	END
 END
 -- Shoulder
 IF (@RefShoulderID <> 0) BEGIN
	EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 2, @RefShoulderID, @DurShoulder
	IF (@ItemID <= 0) BEGIN
		ROLLBACK TRANSACTION
		RETURN -8
	END
 END
 -- Pants 
 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    
 -- Shield
 IF (@RefShield <> 0) BEGIN    
	EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 7, @RefShield, @DurShield
	IF (@ItemID <= 0) BEGIN    
		ROLLBACK TRANSACTION    
		RETURN -12    
	END    
 END    
 -- Arror/Bolt
 IF (@DefaultArrow <> 0) BEGIN    
	EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 7, @DefaultArrow, 250
	IF (@ItemID <= 0) BEGIN    
		ROLLBACK TRANSACTION    
		RETURN -13    
	END    
 END
 -- Earring
 IF (@RefEarringID <> 0) BEGIN
	EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 9, @RefEarringID, @DurEarring
	IF (@ItemID <= 0) BEGIN
		ROLLBACK TRANSACTION
		RETURN -8
	END
 END
 -- Ring 1
 IF (@RefRingID <> 0) BEGIN
	EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 11, @RefRingID, @DurRing
	IF (@ItemID <= 0) BEGIN
		ROLLBACK TRANSACTION
		RETURN -8
	END
 END
 -- Ring 2
 IF (@RefRingID <> 0) BEGIN
	EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 12, @RefRingID, @DurRing
	IF (@ItemID <= 0) BEGIN
		ROLLBACK TRANSACTION
		RETURN -8
	END
 END
 -- Necklace
 IF (@RefNeckID <> 0) BEGIN
	EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 10, @RefNeckID, @DurNeck
	IF (@ItemID <= 0) BEGIN
		ROLLBACK TRANSACTION
		RETURN -8
	END
 END
 -- Initial Equip Edit by LemoniscooL
     
	 -----------------------------------------------------------------------------        
	 -- 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)        
 UPDATE _Char SET CurLevel = 101, MaxLevel = 101, Strength = 120, Intellect= 120, RemainStatPoint= 300, ExpOffset = 0, RemainGold = 5000000, RemainSkillPoint = 5000000, InventorySize = 109 WHERE _Char.CharID = @NewCharID
 UPDATE _Items SET OptLevel=5 WHERE ID64 IN (SELECT ItemID FROM _Inventory WHERE Slot BETWEEN 0 AND 12 AND Slot Not LIKE '8' AND CharID=@NewCharID)
 exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_RENT_REVERSE_RETURN_SCROLL',50,1
 exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_RESURRECTION_SCROLL',50,1
 exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_GLOBAL_CHATTING',50,1
 exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_COS_P_MYOWON_SCROLL',1,0
	IF (@RefCharID >= 1907 AND @RefCharID <= 1919) -- MALE CH 
	BEGIN
	exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_AVATAR_M_NASRUN',1,0
 END
ELSE 	IF (@RefCharID >= 14875 AND @RefCharID <= 14887) -- MALE EU
	BEGIN
	exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_AVATAR_M_NASRUN',1,0
 END
ELSE 	IF (@RefCharID >= 1920 AND @RefCharID <= 1931) -- FEMALE CH 
	BEGIN
	exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_AVATAR_W_NASRUN',1,0
 END
ELSE 	IF (@RefCharID >= 14888 AND @RefCharID <= 14900) -- FEMALE EU 
	BEGIN
	exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_AVATAR_W_NASRUN',1,0
 END

 
            
	-- Quick Slot Á¤º¸ ÀúÀå¿ë!!!        
	exec _AddNewClientConfig @NewCharID  -- by novice...... for saving client configurations...        

COMMIT TRANSACTION        
	      
RETURN @NewCharID

to Edit Items
change Codename as Example

 --Female Clothes Europe
 IF (@RefMailID = 11632) BEGIN
	SET @RefHandID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='[COLOR="#FF0000"]ITEM_EU_W_CLOTHES_10_AA_C_RARE[/COLOR]')
	SET @RefMailID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='[COLOR="#FF0000"]ITEM_EU_W_CLOTHES_10_BA_C_RARE[/COLOR]')
	SET @RefBootsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='[COLOR="#FF0000"]ITEM_EU_W_CLOTHES_10_FA_C_RARE[/COLOR]')
	SET @RefHatID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='[COLOR="#FF0000"]ITEM_EU_W_CLOTHES_10_HA_C_RARE[/COLOR]')
	SET @RefPantsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='[COLOR="#FF0000"]ITEM_EU_W_CLOTHES_10_LA_C_RARE[/COLOR]')
	SET @RefShoulderID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='[COLOR="#FF0000"]ITEM_EU_W_CLOTHES_10_SA_C_RARE[/COLOR]')
	SET @RefEarringID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='[COLOR="#FF0000"]ITEM_EU_EARRING_10_C_RARE[/COLOR]')
	SET @RefNeckID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='[COLOR="#FF0000"]ITEM_EU_NECKLACE_10_C_RARE[/COLOR]')
	SET @RefRingID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='[COLOR="#FF0000"]ITEM_EU_RING_10_C_RARE[/COLOR]')
 END

to Edit Plus Change OptLevl

 UPDATE _Items SET OptLevel=5 WHERE ID64 IN (SELECT ItemID FROM _Inventory WHERE Slot BETWEEN 0 AND 12 AND Slot Not LIKE '8') AND CharID=@CharID

To Edit Start Level

 UPDATE _Char SET CurLevel = 101, MaxLevel = 101, Strength = 120, Intellect= 120, RemainStatPoint= 300, ExpOffset = 0, RemainGold = 5000000, RemainSkillPoint = 5000000, InventorySize = 109 WHERE _Char.CharID = @NewCharID

 

[B1QB0SS]

Nıce !

 

[Unrealx420]

I am getting this error when executing. Any suggestions?

Msg 137, Level 15, State 2, Procedure _AddNewChar, Line 575
Must declare the scalar variable "@CharID".

 

[arabcart]

I am getting this error when executing. Any suggestions?

Fixed try now

 

[Unrealx420]

Works better now. Only thing is when creating a character with a shield, it does not add the new shield. I think I can add it myself but I am just letting you know. Thanks for the reup of this.

 

[arabcart]

OK bro I'll check it

 

[arabcart]

this sp work for Chinese Only
any one can edit it ??

 

[arabcart]

Thread Updated
all Problem Fixed
now SP work full with VSRO 1.188
all Race Work and Shield Problem Fixed by me ^^

 

[acer20006]

it should be full of bugs simplify it

 

[lemoniscool]

my release will also work on vsro, i just tested it myself i just forgot the FN_ADD_INITIAL_EQUIP sp edit i made for the +5 opt level in the first post, its been added a while back and in that release there is also a video showing it work

 

[RenePunik]

Thanks alot, worked!

Indeed i need a query with a small thing , can you make all items degree 1 not degree 9? just for me!

like ( basic ) items

 

[arabcart]

my release will also work on vsro, i just tested it myself i just forgot the FN_ADD_INITIAL_EQUIP sp edit i made for the +5 opt level in the first post, its been added a while back and in that release there is also a video showing it work

first thanks for your release and i type your credit in thread
But
ID not Same in VSRO so will not Work only Chinese Race work fine and Shield not Work and Euro Race also not work you can test it
i Modified ID to work With VSRO and add 2 Edits line to Fix Start Level and + For Items

Thanks alot, worked!

Indeed i need a query with a small thing , can you make all items degree 1 not degree 9? just for me!

like ( basic ) items

thats Very easy bro
all you need to do use same SP but open it and Press Ctrl + H (Replace)
then Replace all _10_ to _01_ thats will add Items Degree 1 +5

it should be full of bugs simplify it

you can test it work Fine ^^

 

[RenePunik]

#Fixed , and worked now like a charm ^^ thank you

 

[arabcart]

you are welcome ^^

 

[Hady Prince]

But It Add To Char items lv 101 i need added items Lv 1 And When He Get Up Level Get Next Dg

 

[arabcart]

But It Add To Char items lv 101 i need added items Lv 1 And When He Get Up Level Get Next Dg

thats Very easy bro
all you need to do use same SP but open it and Press Ctrl + H (Replace)
then Replace all _10_ to _01_ thats will add Items Degree 1 +5

 

[Crue]

thats Very easy bro
all you need to do use same SP but open it and Press Ctrl + H (Replace)
then Replace all _10_ to _01_ thats will add Items Degree 1 +5

i think he mean auto equipment system

 

[bestprem]

i wanna add avatar any help !

 

[arabcart]

i wanna add avatar any help !

add my Skype: seller.services1
it's very easy to do

 

[[GM]Xia]

i using vsro193
and he tell me S1030 error