vSRO Çözüldü does anyone have the _AddNewChar star lvl 110

xXxGhostSpitiXxX · 6 Eki 2019

does anyone have the _AddNewChar star lvl 110 ?

ZaKuRa · 6 Eki 2019

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_11_AA_A_RARE')

SET @RefMailID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_CLOTHES_11_BA_A_RARE')

SET @RefBootsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_CLOTHES_11_FA_A_RARE')

SET @RefHatID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_CLOTHES_11_HA_A_RARE')

SET @RefPantsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_CLOTHES_11_LA_A_RARE')

SET @RefShoulderID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_CLOTHES_11_SA_A_RARE')

SET @RefEarringID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_EARRING_11_A_RARE')

SET @RefNeckID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_NECKLACE_11_A_RARE')

SET @RefRingID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_RING_11_A_RARE')

END

--Male Heavy Armor Chinese

IF (@RefMailID = 3637) BEGIN

SET @RefHandID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_HEAVY_11_AA_A_RARE')

SET @RefMailID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_HEAVY_11_BA_A_RARE')

SET @RefBootsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_HEAVY_11_FA_A_RARE')

SET @RefHatID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_HEAVY_11_HA_A_RARE')

SET @RefPantsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_HEAVY_11_LA_A_RARE')

SET @RefShoulderID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_HEAVY_11_SA_A_RARE')

SET @RefEarringID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_EARRING_11_A_RARE')

SET @RefNeckID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_NECKLACE_11_A_RARE')

SET @RefRingID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_RING_11_A_RARE')

END

--Male Light Armor Chinese

IF (@RefMailID = 3640) BEGIN

SET @RefHandID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_LIGHT_11_AA_A_RARE')

SET @RefMailID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_LIGHT_11_BA_A_RARE')

SET @RefBootsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_LIGHT_11_FA_A_RARE')

SET @RefHatID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_LIGHT_11_HA_A_RARE')

SET @RefPantsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_LIGHT_11_LA_A_RARE')

SET @RefShoulderID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_LIGHT_11_SA_A_RARE')

SET @RefEarringID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_EARRING_11_A_RARE')

SET @RefNeckID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_NECKLACE_11_A_RARE')

SET @RefRingID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_RING_11_A_RARE')

END

--Female Clothes Chinese

IF (@RefMailID = 3652) BEGIN

SET @RefHandID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_CLOTHES_11_AA_A_RARE')

SET @RefMailID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_CLOTHES_11_BA_A_RARE')

SET @RefBootsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_CLOTHES_11_FA_A_RARE')

SET @RefHatID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_CLOTHES_11_HA_A_RARE')

SET @RefPantsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_CLOTHES_11_LA_A_RARE')

SET @RefShoulderID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_CLOTHES_11_SA_A_RARE')

SET @RefEarringID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_EARRING_11_A_RARE')

SET @RefNeckID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_NECKLACE_11_A_RARE')

SET @RefRingID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_RING_11_A_RARE')

END

--Female Heavy Armor Chinese

IF (@RefMailID = 3646) BEGIN

SET @RefHandID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_HEAVY_11_AA_A_RARE')

SET @RefMailID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_HEAVY_11_BA_A_RARE')

SET @RefBootsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_HEAVY_11_FA_A_RARE')

SET @RefHatID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_HEAVY_11_HA_A_RARE')

SET @RefPantsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_HEAVY_11_LA_A_RARE')

SET @RefShoulderID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_HEAVY_11_SA_A_RARE')

SET @RefEarringID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_EARRING_11_A_RARE')

SET @RefNeckID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_NECKLACE_11_A_RARE')

SET @RefRingID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_RING_11_A_RARE')

END

--Female Light Armor Chinese

IF (@RefMailID = 3649) BEGIN

SET @RefHandID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_LIGHT_11_AA_A_RARE')

SET @RefMailID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_LIGHT_11_BA_A_RARE')

SET @RefBootsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_LIGHT_11_FA_A_RARE')

SET @RefHatID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_LIGHT_11_HA_A_RARE')

SET @RefPantsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_LIGHT_11_LA_A_RARE')

SET @RefShoulderID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_LIGHT_11_SA_A_RARE')

SET @RefEarringID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_EARRING_11_A_RARE')

SET @RefNeckID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_NECKLACE_11_A_RARE')

SET @RefRingID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_RING_11_A_RARE')

END

--Male Clothes Europe

IF (@RefMailID = 11623) BEGIN

SET @RefHandID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_CLOTHES_11_AA_A_RARE')

SET @RefMailID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_CLOTHES_11_BA_A_RARE')

SET @RefBootsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_CLOTHES_11_FA_A_RARE')

SET @RefHatID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_CLOTHES_11_HA_A_RARE')

SET @RefPantsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_CLOTHES_11_LA_A_RARE')

SET @RefShoulderID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_CLOTHES_11_SA_A_RARE')

SET @RefEarringID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_EARRING_11_A_RARE')

SET @RefNeckID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_NECKLACE_11_A_RARE')

SET @RefRingID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_RING_11_A_RARE')

END

--Male Heavy Armor Europe

IF (@RefMailID = 11617) BEGIN

SET @RefHandID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_HEAVY_11_AA_A_RARE')

SET @RefMailID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_HEAVY_11_BA_A_RARE')

SET @RefBootsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_HEAVY_11_FA_A_RARE')

SET @RefHatID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_HEAVY_11_HA_A_RARE')

SET @RefPantsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_HEAVY_11_LA_A_RARE')

SET @RefShoulderID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_HEAVY_11_SA_A_RARE')

SET @RefEarringID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_EARRING_11_A_RARE')

SET @RefNeckID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_NECKLACE_11_A_RARE')

SET @RefRingID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_RING_11_A_RARE')

END

--Male Light Armor Europe

IF (@RefMailID = 11620) BEGIN

SET @RefHandID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_LIGHT_11_AA_A_RARE')

SET @RefMailID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_LIGHT_11_BA_A_RARE')

SET @RefBootsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_LIGHT_11_FA_A_RARE')

SET @RefHatID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_LIGHT_11_HA_A_RARE')

SET @RefPantsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_LIGHT_11_LA_A_RARE')

SET @RefShoulderID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_LIGHT_11_SA_A_RARE')

SET @RefEarringID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_EARRING_11_A_RARE')

SET @RefNeckID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_NECKLACE_11_A_RARE')

SET @RefRingID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_RING_11_A_RARE')

END

--Female Clothes Europe

IF (@RefMailID = 11632) BEGIN

SET @RefHandID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_CLOTHES_11_AA_A_RARE')

SET @RefMailID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_CLOTHES_11_BA_A_RARE')

SET @RefBootsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_CLOTHES_11_FA_A_RARE')

SET @RefHatID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_CLOTHES_11_HA_A_RARE')

SET @RefPantsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_CLOTHES_11_LA_A_RARE')

SET @RefShoulderID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_CLOTHES_11_SA_A_RARE')

SET @RefEarringID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_EARRING_11_A_RARE')

SET @RefNeckID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_NECKLACE_11_A_RARE')

SET @RefRingID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_RING_11_A_RARE')

END

--Female Heavy Armor Europe

IF (@RefMailID = 11626) BEGIN

SET @RefHandID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_HEAVY_11_AA_A_RARE')

SET @RefMailID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_HEAVY_11_BA_A_RARE')

SET @RefBootsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_HEAVY_11_FA_A_RARE')

SET @RefHatID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_HEAVY_11_HA_A_RARE')

SET @RefPantsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_HEAVY_11_LA_A_RARE')

SET @RefShoulderID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_HEAVY_11_SA_A_RARE')

SET @RefEarringID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_EARRING_11_A_RARE')

SET @RefNeckID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_NECKLACE_11_A_RARE')

SET @RefRingID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_RING_11_A_RARE')

END

--Female Light Armor Europe

IF (@RefMailID = 11629) BEGIN

SET @RefHandID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_LIGHT_11_AA_A_RARE')

SET @RefMailID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_LIGHT_11_BA_A_RARE')

SET @RefBootsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_LIGHT_11_FA_A_RARE')

SET @RefHatID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_LIGHT_11_HA_A_RARE')

SET @RefPantsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_LIGHT_11_LA_A_RARE')

SET @RefShoulderID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_LIGHT_11_SA_A_RARE')

SET @RefEarringID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_EARRING_11_A_RARE')

SET @RefNeckID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_NECKLACE_11_A_RARE')

SET @RefRingID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_RING_11_A_RARE')

END

--Shield Chinese

IF (@RefShield = 10886) BEGIN

SET @RefShield = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_SHIELD_11_A_RARE')

END

--Shield Europe

IF (@RefShield = 10896) BEGIN

SET @RefShield = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_SHIELD_11_A_RARE')

END

--Blade Chinese

IF (@RefWeaponID = 3633) BEGIN

SET @RefWeaponID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_BLADE_11_A_RARE')

END

--Bow Chinese

IF (@RefWeaponID = 3636) BEGIN

SET @RefWeaponID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_BOW_11_A_RARE')

END

--Spear Chinese

IF (@RefWeaponID = 3634) BEGIN

SET @RefWeaponID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_SPEAR_11_A_RARE')

END

--Sword Chinese

IF (@RefWeaponID = 3632) BEGIN

SET @RefWeaponID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_SWORD_11_A_RARE')

END

--Glavie Chinese

IF (@RefWeaponID = 3635) BEGIN

SET @RefWeaponID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_TBLADE_11_A_RARE')

END

--Axe Europe

IF (@RefWeaponID = 10890) BEGIN

SET @RefWeaponID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_AXE_11_A_RARE')

END

--XBow Europe

IF (@RefWeaponID = 10891) BEGIN

SET @RefWeaponID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_CROSSBOW_11_A_RARE')

END

--Dagger Europe

IF (@RefWeaponID = 10887) BEGIN

SET @RefWeaponID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_DAGGER_11_A_RARE')

END

--Darkstaff Europe

IF (@RefWeaponID = 10892) BEGIN

SET @RefWeaponID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_DARKSTAFF_11_A_RARE')

END

--Harp Europe

IF (@RefWeaponID = 10894) BEGIN

SET @RefWeaponID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_HARP_11_A_RARE')

END

--Cleric Rod Europe

IF (@RefWeaponID = 10895) BEGIN

SET @RefWeaponID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_STAFF_11_A_RARE')

END

--Sword Europe

IF (@RefWeaponID = 10888) BEGIN

SET @RefWeaponID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_SWORD_11_A_RARE')

END

--Staff Europe

IF (@RefWeaponID = 10893) BEGIN

SET @RefWeaponID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_TSTAFF_11_A_RARE')

END

--Twohand Sword Europe

IF (@RefWeaponID = 10889) BEGIN

SET @RefWeaponID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_TSWORD_11_A_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. Ä³¸¯ÅÍ Ãß°¡ÇÏ±â

-----------------------------------------------------------------------------

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, 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

-- Ä³¸¯ÅÍ »ý¼º ½ÇÆÐ!

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 = 110, MaxLevel = 110, Strength = 147, Intellect= 147, RemainStatPoint= 330, 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

edit this scoundrel

UPDATE _Char SET CurLevel = 110, MaxLevel = 110, Strength = 147, Intellect= 147, RemainStatPoint= 330, ExpOffset = 0, RemainGold = 5000000, RemainSkillPoint = 5000000, InventorySize = 109 WHERE _Char.CharID = @NewCharID

vSRO Çözüldü does anyone have the _AddNewChar star lvl 110

Bu konuyu görüntüleyen kullanıcılar

Benzer konular

Yasal Uyarı

Soru vSRO Çözüldü does anyone have the _AddNewChar star lvl 110

Bu konuyu görüntüleyen kullanıcılar

Benzer konular

Yasal Uyarı

vSRO Çözüldü does anyone have the _AddNewChar star lvl 110