USE [SRO_FEIER_SHARDDB]GO
/****** Object: StoredProcedure [dbo].[_AddNewChar] Script Date: 01/05/2015 08:20:51 ******/
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, @temp INT, @NewCharID INT;
SET @NewCharID = 0;
-----------------------------------------------------------------------------
-- 1. ¼ valid , º .
-----------------------------------------------------------------------------
-- start by novice.
SELECT @temp = count(CharID) FROM _User WITH (NOLOCK) WHERE UserJID = @userJID
IF @temp >= 4) -- ID
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
select @NewCharID --HJ
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)
-----------------------------------------------------------------------------
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
-- ...
/* .
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
IF @refBootsID <> 0) -- Boots
BEGIN
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 5, @refBootsID, @DurBoots
IF (@ItemID <= 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -10
END
END
IF @refWeaponID <> 0) -- Weapon
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
IF (@DefaultArrow <> 0) -- default ® 250 . ?
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 Í
-----------------------------------------------------------------------------
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
-----------------------------------------------------------------------------
-- 3-3.
-- [ Í 50]
-- Define ADD_TRADE_BAG_INVENTORY Í
-----------------------------------------------------------------------------
-- PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!
INSERT INTO _TradeBagInventory(CharID, Slot, ItemID)
SELECT @NewCharID, cnt, 0
FROM _RefDummySlot with( nolock )
WHERE cnt < 50
IF (@@ERROR <> 0)
BEGIN
-- !
ROLLBACK TRANSACTION
RETURN -20
END
-- PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!
-----------------------------------------------------------------------------
-- 3-4.
-- [ Í 11]
-- Define ADD_TRADE_EQUIP_INVENTORY Í
-----------------------------------------------------------------------------
-- PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!
INSERT INTO _TradeEquipInventory(CharID, Slot, ItemID)
SELECT @NewCharID, cnt, 0
FROM _RefDummySlot with( nolock )
WHERE cnt < 11
IF (@@ERROR <> 0)
BEGIN
-- !
ROLLBACK TRANSACTION
RETURN -21
END
-----------------------------------------------------------------------------
-- default skill
-----------------------------------------------------------------------------
DECLARE @country tinyINT
EXEC @country = _GetObjCountry @refCharID
SELECT @NewCharID, MasteryID, 0 FROM _RefCharDefault_SkillMastery with(nolock) WHERE Race = @country or Race = 3; --HJ
select @NewCharID, @country
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
UPDATE _CharQuest set Status = 5 , QuestData1 = 77594711 where CharID = @NewCharID and QuestID = 1
UPDATE _CharQuest set Status = 5 where CharID = @NewCharID and QuestID = 2
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
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
-- Í
-----------------------------------------------------------------------------
INSERT _FriendGroup Values @NewCharID, 0, '') -- Í by bkh
IF (@@ERROR <> 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -20 -- Í !
END
-----------------------------------------------------------------------------
-- TradeConflictJob !!!!!
-----------------------------------------------------------------------------
INSERT INTO _CharTradeConflictJob VALUES @NewCharID, GetDate(), 1, 0, 0, 0, 0, 0 ,0)
IF (@@ERROR <> 0)
BEGIN
-- Å ...!
ROLLBACK TRANSACTION
RETURN -22
END
-----------------------------------------------------------------------------
-- NewTrade !!!!!
-----------------------------------------------------------------------------
INSERT INTO _CharNewTrade VALUES @NewCharID, 0, 0)
IF (@@ERROR <> 0)
BEGIN
-- Å ...!
ROLLBACK TRANSACTION
RETURN -23
END
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
-- Í
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
-- !!!
-----------------------------------------------------------------------------
-- ReqType 1
INSERT _CharAlchemy_MK_Recipe
SELECT @NewCharID, MR.RC_ID FROM _RefLearnRecipeByReqType AS LR
JOIN _RefAlchemy_MK_Recipe AS MR ON LR.RecipeCodeName = MR.RC_CodeName128
WHERE LR.ReqType = 1 AND LR.ReqValue = 1 AND LR.Service = 1
IF (@@ERROR <> 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -21 -- Í
END
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
-----------------------------------------------------------------------------
-- CharList ID
-----------------------------------------------------------------------------
INSERT _CharNameList VALUES @charname, @NewCharID);
COMMIT TRANSACTION
if @refCharID>=14961 and @refCharID<=14973)
begin
insert into _CharAlchemy_MK_Recipe select @NewCharID,b.RC_ID from _RefAlchemy_MK_Recipe as b
where b.RC_CodeName128 like 'MK[_]RC[_]CM[_]EU[_]W[_]%'
or (b.RC_CodeName128 like 'MK[_]RC[_]CM[_]EU[_]%'
and b.RC_CodeName128 not like '%[_]W[_]%'
and b.RC_CodeName128 not like '%[_]M[_]%')
or (b.RC_CodeName128 like 'MK[_]RC[_]CM[_]%'
and b.RC_CodeName128 not like '%[_]CH[_]%'
and b.RC_CodeName128 not like '%[_]EU[_]%')
end
if @refCharID>=14948 and @refCharID<=14960)
begin
insert into _CharAlchemy_MK_Recipe select @NewCharID,b.RC_ID from _RefAlchemy_MK_Recipe as b
where b.RC_CodeName128 like 'MK[_]RC[_]CM[_]EU[_]M[_]%'
or (b.RC_CodeName128 like 'MK[_]RC[_]CM[_]EU[_]%'
and b.RC_CodeName128 not like '%[_]W[_]%'
and b.RC_CodeName128 not like '%[_]M[_]%')
or (b.RC_CodeName128 like 'MK[_]RC[_]CM[_]%'
and b.RC_CodeName128 not like '%[_]CH[_]%'
and b.RC_CodeName128 not like '%[_]EU[_]%')
end
if @refCharID>=1920 and @refCharID<=1932)
begin
insert into _CharAlchemy_MK_Recipe select @NewCharID,b.RC_ID from _RefAlchemy_MK_Recipe as b
where b.RC_CodeName128 like 'MK[_]RC[_]CM[_]CH[_]W[_]%'
or (b.RC_CodeName128 like 'MK[_]RC[_]CM[_]CH[_]%'
and b.RC_CodeName128 not like '%[_]W[_]%'
and b.RC_CodeName128 not like '%[_]M[_]%')
or (b.RC_CodeName128 like 'MK[_]RC[_]CM[_]%'
and b.RC_CodeName128 not like '%[_]CH[_]%'
and b.RC_CodeName128 not like '%[_]EU[_]%')
end
if @refCharID>=1907 and @refCharID<=1919)
begin
insert into _CharAlchemy_MK_Recipe select @NewCharID,b.RC_ID from _RefAlchemy_MK_Recipe as b
where
b.RC_CodeName128 like 'MK[_]RC[_]CM[_]CH[_]M[_]%'
or (b.RC_CodeName128 like 'MK[_]RC[_]CM[_]CH[_]%'
and b.RC_CodeName128 not like '%[_]W[_]%'
and b.RC_CodeName128 not like '%[_]M[_]%')
or (b.RC_CodeName128 like 'MK[_]RC[_]CM[_]%'
and b.RC_CodeName128 not like '%[_]CH[_]%'
and b.RC_CodeName128 not like '%[_]EU[_]%')
end
IF @refShield <> 0)
begin
if @refShield=10927
begin
exec _ADD_ITEM_EXTERN @charname, 'ITEM_CH_SHIELD_12_A_RARE',1,0
end
else if @refShield=10937
begin
exec _ADD_ITEM_EXTERN @charname, 'ITEM_EU_SHIELD_12_A_RARE',1,0
end
end
if @refWeaponID=3632
begin
exec _ADD_ITEM_EXTERN @charname, 'ITEM_CH_SWORD_12_A_RARE',1,0
end
else if @refWeaponID=3633
begin
exec _ADD_ITEM_EXTERN @charname, 'ITEM_CH_BLADE_12_A_RARE',1,0
end
else if @refWeaponID=3636
begin
exec _ADD_ITEM_EXTERN @charname, 'ITEM_CH_BOW_12_A_RARE',1,0
end
else if @refWeaponID=3634
begin
exec _ADD_ITEM_EXTERN @charname, 'ITEM_CH_SPEAR_12_A_RARE',1,0
end
else if @refWeaponID=3635
begin
exec _ADD_ITEM_EXTERN @charname, 'ITEM_CH_TBLADE_12_A_RARE',1,0
end
else if @refWeaponID=10928
begin
exec _ADD_ITEM_EXTERN @charname, 'ITEM_EU_DAGGER_12_A_RARE',1,0
end
else if @refWeaponID=10929
begin
exec _ADD_ITEM_EXTERN @charname, 'ITEM_EU_SWORD_12_A_RARE',1,0
end
else if @refWeaponID=10930
begin
exec _ADD_ITEM_EXTERN @charname, 'ITEM_EU_TSWORD_12_A_RARE',1,0
end
else if @refWeaponID=10931
begin
exec _ADD_ITEM_EXTERN @charname, 'ITEM_EU_AXE_12_A_RARE',1,0
end
else if @refWeaponID=10932
begin
exec _ADD_ITEM_EXTERN @charname, 'ITEM_EU_CROSSBOW_12_A_RARE',1,0
end
else if @refWeaponID=10933
begin
exec _ADD_ITEM_EXTERN @charname, 'ITEM_EU_DARKSTAFF_12_A_RARE',1,0
end
else if @refWeaponID=10934
begin
exec _ADD_ITEM_EXTERN @charname, 'ITEM_EU_TSTAFF_12_A_RARE',1,0
end
else if @refWeaponID=10935
begin
exec _ADD_ITEM_EXTERN @charname, 'ITEM_EU_HARP_12_A_RARE',1,0
end
else if @refWeaponID=10936
begin
exec _ADD_ITEM_EXTERN @charname, 'ITEM_EU_STAFF_12_A_RARE',1,0
end
if @refCharID>=1907 and @refCharID<=1919--
begin
if @refMailID >=3637 and @refMailID <=3639--
begin
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_M_HEAVY_12_AA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_M_HEAVY_12_BA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_M_HEAVY_12_FA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_M_HEAVY_12_HA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_M_HEAVY_12_LA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_M_HEAVY_12_SA_A_RARE',1,0
end
if @refMailID >=3640 and @refMailID <=3642--
begin
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_M_LIGHT_12_AA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_M_LIGHT_12_BA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_M_LIGHT_12_FA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_M_LIGHT_12_HA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_M_LIGHT_12_LA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_M_LIGHT_12_SA_A_RARE',1,0
end
if @refMailID >=3643 and @refMailID <=3645--
begin
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_M_CLOTHES_12_AA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_M_CLOTHES_12_BA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_M_CLOTHES_12_FA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_M_CLOTHES_12_HA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_M_CLOTHES_12_LA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_M_CLOTHES_12_SA_A_RARE',1,0
end
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_EARRING_12_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_NECKLACE_12_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_RING_12_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_RING_12_A_RARE',1,0
end
if @refCharID>=1920 and @refCharID<=1932--
begin
if @refMailID >=3646 and @refMailID <=3648--
begin
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_W_HEAVY_12_AA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_W_HEAVY_12_BA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_W_HEAVY_12_FA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_W_HEAVY_12_HA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_W_HEAVY_12_LA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_W_HEAVY_12_SA_A_RARE',1,0
end
if @refMailID >=3649 and @refMailID <=3651--
begin
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_W_LIGHT_12_AA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_W_LIGHT_12_BA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_W_LIGHT_12_FA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_W_LIGHT_12_HA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_W_LIGHT_12_LA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_W_LIGHT_12_SA_A_RARE',1,0
end
if @refMailID >=3652 and @refMailID <=3654--
begin
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_W_CLOTHES_12_AA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_W_CLOTHES_12_BA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_W_CLOTHES_12_FA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_W_CLOTHES_12_HA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_W_CLOTHES_12_LA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_W_CLOTHES_12_SA_A_RARE',1,0
end
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_EARRING_12_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_NECKLACE_12_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_RING_12_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_RING_12_A_RARE',1,0
end
if @refCharID>=14948 and @refCharID<=14960--
begin
if @refMailID >=11658 and @refMailID <=11660--
begin
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_M_HEAVY_12_AA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_M_HEAVY_12_BA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_M_HEAVY_12_FA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_M_HEAVY_12_HA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_M_HEAVY_12_LA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_M_HEAVY_12_SA_A_RARE',1,0
end
if @refMailID >=11661 and @refMailID <=11663--
begin
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_M_LIGHT_12_AA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_M_LIGHT_12_BA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_M_LIGHT_12_FA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_M_LIGHT_12_HA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_M_LIGHT_12_LA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_M_LIGHT_12_SA_A_RARE',1,0
end
if @refMailID >=11664 and @refMailID <=11666--
begin
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_M_CLOTHES_12_AA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_M_CLOTHES_12_BA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_M_CLOTHES_12_FA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_M_CLOTHES_12_HA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_M_CLOTHES_12_LA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_M_CLOTHES_12_SA_A_RARE',1,0
end
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_EARRING_12_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_NECKLACE_12_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_RING_12_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_RING_12_A_RARE',1,0
end
if @refCharID>=14961 and @refCharID<=14973--
begin
if @refMailID >=11667 and @refMailID <=11669--
begin
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_W_HEAVY_12_AA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_W_HEAVY_12_BA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_W_HEAVY_12_FA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_W_HEAVY_12_HA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_W_HEAVY_12_LA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_W_HEAVY_12_SA_A_RARE',1,0
end
if @refMailID >=11670 and @refMailID <=11672--
begin
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_W_LIGHT_12_AA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_W_LIGHT_12_BA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_W_LIGHT_12_FA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_W_LIGHT_12_HA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_W_LIGHT_12_LA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_W_LIGHT_12_SA_A_RARE',1,0
end
if @refMailID >=11673 and @refMailID <=11675--
begin
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_W_CLOTHES_12_AA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_W_CLOTHES_12_BA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_W_CLOTHES_12_FA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_W_CLOTHES_12_HA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_W_CLOTHES_12_LA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_W_CLOTHES_12_SA_A_RARE',1,0
end
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_EARRING_12_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_NECKLACE_12_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_RING_12_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_RING_12_A_RARE',1,0
end
exec _ADD_ITEM_EXTERN @charname,'ITEM_ETC_LEVEL_TOKEN_02',1200,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_ETC_LEVEL_TOKEN_03',5600,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_ETC_LEVEL_TOKEN_01',750,0
declare @updateitemid int
declare cur cursor fast_forward for select itemid from dbo._Inventory with(nolock) where charid @NewCharID and slot in(6,7)
open cur
fetch next from cur into @updateitemid
while(@@fetch_status=0)
begin
if @updateitemid<>0
begin
update _items set optlevel=77 where id64=@updateitemid
end
fetch next from cur into @updateitemid
end
close cur
deallocate cur
-- Quick Slot !!!
exec _AddNewClientConfig @NewCharID -- by novice...... for saving client configurations...
RETURN @NewCharID
