ELİTE vSRO Starter Pack Gold ve Bronz

GOLD OLAN STARTERPACK
[CLUB] USE [SRO_VT_LOG]
GO
/****** Object: StoredProcedure [dbo].[_StarterPackGold] Script Date: 11.09.2023 16:42:44 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER proc [dbo].[_StarterPackGold]
@CharID INT
as

BEGIN
DECLARE @CharName_SpecialPack VARCHAR(64)=
(SELECT CharName16 FROM [SRO_VT_SHARD].[dbo].[_Char] WITH (NOLOCK) WHERE CharID=@CharID);
DECLARE @CharType_SpecialPack INT=
(SELECT RefObjID FROM SRO_VT_SHARD.._Char WITH (NOLOCK) WHERE CharID=@CharID);

--exec MaxiGuard_User.._AddItemToChest @CharID, 'ITEM_MALL_PREMIUM_VIETNAM_GOLDTIME_PLUS', 1, 'StarterPackGold'
INSERT INTO SRO_VT_PROXY.._CharChest VALUES(@CharID,'35567','1',0,'0','StarterPackGold',GETDATE())
--exec MaxiGuard_User.._AddItemToChest @CharID, 'ITEM_MALL_GODBLESSS', 1, 'StarterPackGold'
INSERT INTO SRO_VT_PROXY.._CharChest VALUES(@CharID,'44424','1',0,'0','StarterPackGold',GETDATE())
--exec MaxiGuard_User.._AddItemToChest @CharID, 'ITEM_MALL_GLOBAL_CHATTING', 11, 'StarterPackGold'
INSERT INTO SRO_VT_PROXY.._CharChest VALUES(@CharID,'3851','1',0,'0','StarterPackGold',GETDATE())
--exec MaxiGuard_User.._AddItemToChest @CharID, 'ITEM_COS_T_YSKHORSE_A_SCROLL', 10, 'StarterPackGold'
INSERT INTO SRO_VT_PROXY.._CharChest VALUES(@CharID,'42119','1',0,'0','StarterPackGold',GETDATE())
--exec MaxiGuard_User.._AddItemToChest @CharID, 'ITEM_MALL_HONOR_RANK_CROWN', 1, 'StarterPackGold'
INSERT INTO SRO_VT_PROXY.._CharChest VALUES(@CharID,'41920','1',0,'0','StarterPackGold',GETDATE())
--exec MaxiGuard_User.._AddItemToChest @CharID, 'ITEM_MALL_HONOR_RANK_GOLD', 1, 'StarterPackGold'
INSERT INTO SRO_VT_PROXY.._CharChest VALUES(@CharID,'41919','1',0,'0','StarterPackGold',GETDATE())
--exec MaxiGuard_User.._AddItemToChest @CharID, 'ITEM_MALL_HONOR_RANK_SILVER', 1, 'StarterPackGold'
INSERT INTO SRO_VT_PROXY.._CharChest VALUES(@CharID,'41918','1',0,'0','StarterPackGold',GETDATE())
--exec MaxiGuard_User.._AddItemToChest @CharID, 'ITEM_MALL_HONOR_RANK_COPPER', 1, 'StarterPackGold'
INSERT INTO SRO_VT_PROXY.._CharChest VALUES(@CharID,'41917','1',0,'0','StarterPackGold',GETDATE())
--exec MaxiGuard_User.._AddItemToChest @CharID, 'ITEM_ETC_NASRUN_ARCHEMY_UPGRADE_STONE', 10, 'StarterPackGold'
INSERT INTO SRO_VT_PROXY.._CharChest VALUES(@CharID,'24417','1',0,'0','StarterPackGold',GETDATE())
--exec MaxiGuard_User.._AddItemToChest @CharID, 'ITEM_MALL_LUCK_5', 1, 'StarterPackGold'
INSERT INTO SRO_VT_PROXY.._CharChest VALUES(@CharID,'44547','1',0,'0','StarterPackGold',GETDATE())
--exec MaxiGuard_User.._AddItemToChest @CharID, 'ITEM_ETC_ARCHEMY_UPPER_REINFORCE_RECIPE_WE_RARE_B_11', 1, 'StarterPackGold'
INSERT INTO SRO_VT_PROXY.._CharChest VALUES(@CharID,'26027','1',0,'0','StarterPackGold',GETDATE())
--exec MaxiGuard_User.._AddItemToChest @CharID, 'ITEM_ETC_ARCHEMY_UPPER_REINFORCE_RECIPE_SH_RARE_B_11', 1, 'StarterPackGold'
INSERT INTO SRO_VT_PROXY.._CharChest VALUES(@CharID,'26039','1',0,'0','StarterPackGold',GETDATE())
--exec MaxiGuard_User.._AddItemToChest @CharID, 'ITEM_ETC_ARCHEMY_UPPER_REINFORCE_RECIPE_AR_RARE_B_11', 6, 'StarterPackGold'
INSERT INTO SRO_VT_PROXY.._CharChest VALUES(@CharID,'26051','1',0,'0','StarterPackGold',GETDATE())
--exec MaxiGuard_User.._AddItemToChest @CharID, 'ITEM_ETC_ARCHEMY_UPPER_REINFORCE_RECIPE_AC_RARE_B_11', 4, 'StarterPackGold'
INSERT INTO SRO_VT_PROXY.._CharChest VALUES(@CharID,'26063','1',0,'0','StarterPackGold',GETDATE())
--exec MaxiGuard_User.._AddItemToChest @CharID, 'ITEM_MALL_BLUEDEVIL', 1, 'StarterPackGold'
INSERT INTO SRO_VT_PROXY.._CharChest VALUES(@CharID,'43778','1',0,'0','StarterPackGold',GETDATE())

IF(@CharType_SpecialPack BETWEEN 1907 AND 1919) -->MALE CHINESE
BEGIN
--exec MaxiGuard_User.._AddItemToChest @CharID, 'ITEM_MALL_AVATAR_M_NASRUN', 1, 'StarterPackGold'
INSERT INTO SRO_VT_PROXY.._CharChest VALUES(@CharID,'24405','1',0,'0','StarterPackGold',GETDATE())
END
ELSE IF(@CharType_SpecialPack BETWEEN 1920 AND 1932) -->FEMALE CHINESE
BEGIN
--exec MaxiGuard_User.._AddItemToChest @CharID, 'ITEM_MALL_AVATAR_W_NASRUN', 1, 'StarterPackGold'
INSERT INTO SRO_VT_PROXY.._CharChest VALUES(@CharID,'24406','1',0,'0','StarterPackGold',GETDATE())
END
ELSE IF(@CharType_SpecialPack BETWEEN 14873 AND 14887) -->MALE EUROPEAN
BEGIN
--exec MaxiGuard_User.._AddItemToChest @CharID, 'ITEM_MALL_AVATAR_M_NASRUN', 1, 'StarterPackGold'
INSERT INTO SRO_VT_PROXY.._CharChest VALUES(@CharID,'24405','1',0,'0','StarterPackGold',GETDATE())
END
ELSE IF(@CharType_SpecialPack BETWEEN 14888 AND 14900) -->FEMALE EUROPEAN
BEGIN
--exec MaxiGuard_User.._AddItemToChest @CharID, 'ITEM_MALL_AVATAR_W_NASRUN', 1, 'StarterPackGold'
INSERT INTO SRO_VT_PROXY.._CharChest VALUES(@CharID,'24406','1',0,'0','StarterPackGold',GETDATE())
END
END [/CLUB]
BRONZ OLAN STARTERPACK
[CLUB] USE [SRO_VT_LOG]
GO
/****** Object: StoredProcedure [dbo].[_StarterPackBronz] Script Date: 11.09.2023 16:43:48 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER proc [dbo].[_StarterPackBronz]
@CharID INT
as

BEGIN
DECLARE @CharName_SpecialPack VARCHAR(64)=
(SELECT CharName16 FROM [SRO_VT_SHARD].[dbo].[_Char] WITH (NOLOCK) WHERE CharID=@CharID);
DECLARE @CharType_SpecialPack INT=
(SELECT RefObjID FROM SRO_VT_SHARD.._Char WITH (NOLOCK) WHERE CharID=@CharID);

--exec MaxiGuard_User.._AddItemToChest @CharID, 'ITEM_MALL_PREMIUM_VIETNAM_GOLDTIME_PLUS', 1, 'StarterPackBronz'
INSERT INTO SRO_VT_PROXY.._CharChest VALUES(@CharID,'35567','1',0,'0','StarterPackBronz',GETDATE())
--exec MaxiGuard_User.._AddItemToChest @CharID, 'ITEM_MALL_GODBLESSS', 1, 'StarterPackBronz'
INSERT INTO SRO_VT_PROXY.._CharChest VALUES(@CharID,'44424','1',0,'0','StarterPackBronz',GETDATE())
--exec MaxiGuard_User.._AddItemToChest @CharID, 'ITEM_MALL_GLOBAL_CHATTING', 11, 'StarterPackBronz'
INSERT INTO SRO_VT_PROXY.._CharChest VALUES(@CharID,'3851','1',0,'0','StarterPackBronz',GETDATE())
--exec MaxiGuard_User.._AddItemToChest @CharID, 'ITEM_COS_T_YSKHORSE_A_SCROLL', 10, 'StarterPackBronz'
INSERT INTO SRO_VT_PROXY.._CharChest VALUES(@CharID,'42119','1',0,'0','StarterPackBronz',GETDATE())

IF(@CharType_SpecialPack BETWEEN 1907 AND 1919) -->MALE CHINESE
BEGIN
--exec MaxiGuard_User.._AddItemToChest @CharID, 'ITEM_MALL_AVATAR_M_NASRUN', 1, 'StarterPackBronz'
INSERT INTO SRO_VT_PROXY.._CharChest VALUES(@CharID,'24405','1',0,'0','StarterPackBronz',GETDATE())
END
ELSE IF(@CharType_SpecialPack BETWEEN 1920 AND 1932) -->FEMALE CHINESE
BEGIN
--exec MaxiGuard_User.._AddItemToChest @CharID, 'ITEM_MALL_AVATAR_W_NASRUN', 1, 'StarterPackBronz'
INSERT INTO SRO_VT_PROXY.._CharChest VALUES(@CharID,'24406','1',0,'0','StarterPackBronz',GETDATE())
END
ELSE IF(@CharType_SpecialPack BETWEEN 14873 AND 14887) -->MALE EUROPEAN
BEGIN
--exec MaxiGuard_User.._AddItemToChest @CharID, 'ITEM_MALL_AVATAR_M_NASRUN', 1, 'StarterPackBronz'
INSERT INTO SRO_VT_PROXY.._CharChest VALUES(@CharID,'24405','1',0,'0','StarterPackBronz',GETDATE())
END
ELSE IF(@CharType_SpecialPack BETWEEN 14888 AND 14900) -->FEMALE EUROPEAN
BEGIN
--exec MaxiGuard_User.._AddItemToChest @CharID, 'ITEM_MALL_AVATAR_W_NASRUN', 1, 'StarterPackBronz'
INSERT INTO SRO_VT_PROXY.._CharChest VALUES(@CharID,'24406','1',0,'0','StarterPackBronz',GETDATE())
END
END [/CLUB]
_AddLogİtem'e Eklenicek Prosedür
[CLUB] -------------------------STARTER PACKLER-----------------------------------------
BEGIN
IF @Operation = '41' and (@ItemRefID = 44583) -- Starter Pack Bronz RefItemID
EXEC SRO_VT_LOG.._StarterPackBronz @CharID --1.Prosedürü hangi tabloya okuttuysanız onun adını yazın.
END

BEGIN
IF @Operation = '41' and (@ItemRefID = 44584) -- Starter Pack Gold RefItemID
EXEC SRO_VT_LOG.._StarterPackGold @CharID --1.Prosedürü hangi tabloya okuttuysanız onun adını yazın.
END
-------------------------STARTER PACKLER----------------------------------------- [/CLUB]

konuyu göremiyorum