db ye
bronz packet ekledim lakin
eu male char alinca female dewil veriyor ch charlarda sorun yok
USE [SRO_VT_LOG]
GO
/****** Object: StoredProcedure [dbo].[_PrimPackage] Script Date: 14.04.2020 22:39:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER proc [dbo].[_PrimPackage]
@CharID INT
as
BEGIN
DECLARE @RefObjID int
set @RefObjID = ( select RefObjID from SRO_VT_SHARD.._char where CharID = @CharID )
if @RefObjID in ( select RefObjID from SRO_VT_SHARD.._char where RefObjID<=1919 AND RefObjID>=1907 )
BEGIN
exec SRO_VT_SHARD.DBO._AddItemByCodeName @CharID,'ITEM_MALL_AVATAR_M_NASRUN_BLUE',1,5
exec SRO_VT_SHARD.DBO._AddItemByCodeName @CharID,'ITEM_MALL_HP_INC_4100_POTION',11,0
exec SRO_VT_SHARD.DBO._AddItemByCodeName @CharID,'ITEM_MALL_MP_INC_4100_POTION',11,0
exec SRO_VT_SHARD.DBO._AddItemByCodeName @CharID,'ITEM_EVENT_RENT_DAMAGE_ABS_20P_SCROLL',11,0
exec SRO_VT_SHARD.DBO._AddItemByCodeName @CharID,'ITEM_EVENT_RENT_DAMAGE_INC_20P_SCROLL',11,0
exec SRO_VT_SHARD.DBO._AddItemByCodeName @CharID,'ITEM_MALL_REVERSE_RETURN_SCROLL',11,0
exec SRO_VT_SHARD.DBO._AddItemByCodeName @CharID,'ITEM_MALL_NASRUN_ARCHEMY_MAGICSTONE_UMDU',10,0
exec SRO_VT_SHARD.DBO._AddItemByCodeName @CharID,'ITEM_MALL_GLOBAL_CHATTING',11,0
END
else
BEGIN
exec SRO_VT_SHARD.DBO._AddItemByCodeName @CharID,'ITEM_MALL_AVATAR_W_NASRUN_BLUE',1,5
exec SRO_VT_SHARD.DBO._AddItemByCodeName @CharID,'ITEM_MALL_HP_INC_4100_POTION',11,0
exec SRO_VT_SHARD.DBO._AddItemByCodeName @CharID,'ITEM_MALL_MP_INC_4100_POTION',11,0
exec SRO_VT_SHARD.DBO._AddItemByCodeName @CharID,'ITEM_EVENT_RENT_DAMAGE_ABS_20P_SCROLL',11,0
exec SRO_VT_SHARD.DBO._AddItemByCodeName @CharID,'ITEM_EVENT_RENT_DAMAGE_INC_20P_SCROLL',11,0
exec SRO_VT_SHARD.DBO._AddItemByCodeName @CharID,'ITEM_MALL_REVERSE_RETURN_SCROLL',11,0
exec SRO_VT_SHARD.DBO._AddItemByCodeName @CharID,'ITEM_MALL_NASRUN_ARCHEMY_MAGICSTONE_UMDU',10,0
exec SRO_VT_SHARD.DBO._AddItemByCodeName @CharID,'ITEM_MALL_GLOBAL_CHATTING',11,0
END
END
bronz packet ekledim lakin
eu male char alinca female dewil veriyor ch charlarda sorun yok
USE [SRO_VT_LOG]
GO
/****** Object: StoredProcedure [dbo].[_PrimPackage] Script Date: 14.04.2020 22:39:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER proc [dbo].[_PrimPackage]
@CharID INT
as
BEGIN
DECLARE @RefObjID int
set @RefObjID = ( select RefObjID from SRO_VT_SHARD.._char where CharID = @CharID )
if @RefObjID in ( select RefObjID from SRO_VT_SHARD.._char where RefObjID<=1919 AND RefObjID>=1907 )
BEGIN
exec SRO_VT_SHARD.DBO._AddItemByCodeName @CharID,'ITEM_MALL_AVATAR_M_NASRUN_BLUE',1,5
exec SRO_VT_SHARD.DBO._AddItemByCodeName @CharID,'ITEM_MALL_HP_INC_4100_POTION',11,0
exec SRO_VT_SHARD.DBO._AddItemByCodeName @CharID,'ITEM_MALL_MP_INC_4100_POTION',11,0
exec SRO_VT_SHARD.DBO._AddItemByCodeName @CharID,'ITEM_EVENT_RENT_DAMAGE_ABS_20P_SCROLL',11,0
exec SRO_VT_SHARD.DBO._AddItemByCodeName @CharID,'ITEM_EVENT_RENT_DAMAGE_INC_20P_SCROLL',11,0
exec SRO_VT_SHARD.DBO._AddItemByCodeName @CharID,'ITEM_MALL_REVERSE_RETURN_SCROLL',11,0
exec SRO_VT_SHARD.DBO._AddItemByCodeName @CharID,'ITEM_MALL_NASRUN_ARCHEMY_MAGICSTONE_UMDU',10,0
exec SRO_VT_SHARD.DBO._AddItemByCodeName @CharID,'ITEM_MALL_GLOBAL_CHATTING',11,0
END
else
BEGIN
exec SRO_VT_SHARD.DBO._AddItemByCodeName @CharID,'ITEM_MALL_AVATAR_W_NASRUN_BLUE',1,5
exec SRO_VT_SHARD.DBO._AddItemByCodeName @CharID,'ITEM_MALL_HP_INC_4100_POTION',11,0
exec SRO_VT_SHARD.DBO._AddItemByCodeName @CharID,'ITEM_MALL_MP_INC_4100_POTION',11,0
exec SRO_VT_SHARD.DBO._AddItemByCodeName @CharID,'ITEM_EVENT_RENT_DAMAGE_ABS_20P_SCROLL',11,0
exec SRO_VT_SHARD.DBO._AddItemByCodeName @CharID,'ITEM_EVENT_RENT_DAMAGE_INC_20P_SCROLL',11,0
exec SRO_VT_SHARD.DBO._AddItemByCodeName @CharID,'ITEM_MALL_REVERSE_RETURN_SCROLL',11,0
exec SRO_VT_SHARD.DBO._AddItemByCodeName @CharID,'ITEM_MALL_NASRUN_ARCHEMY_MAGICSTONE_UMDU',10,0
exec SRO_VT_SHARD.DBO._AddItemByCodeName @CharID,'ITEM_MALL_GLOBAL_CHATTING',11,0
END
END