- Katılım
- 14 May 2019
- Mesajlar
- 912
- Çözümler
- 3
- Alınan Beğeni
- 1,035
- Ödül Puanları
- 93
- Konum
- Kahramanmaraş
Selamun Aleyküm Arkadaşlar Bu prosödürlerin 2 sinide aynı anda okutamıyorum DB ye Sorun Nedir sizce ?
Sadece Birini okuttuğumda çalışıyor ama 2 sini aynı anda okutamıyorum ?
Verdiği HATA İSE BU :
MALE STARTER PACK
if(@Operation = '41' and @ItemRefID = 4641921) -- STARTER PACKED [MALE]
begin
declare @RefObjID int
declare @charname varchar(64)
Set @charname = (Select CharName16 from SRO_VT_SHARD.dbo._Char where CharID = @CharID);
Select @RefObjID=RefObjID from SRO_VT_SHARD.dbo._Char where CharID = @CharID
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @charname,'ITEM_MALL_PREMIUM_VIETNAM_GOLDTIME_PLUS',1,0
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @charname,'ITEM_HGSUNUCULAR_GODBLESS4',1,0
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @charname,'ITEM_MALL_AVATAR_M_NASRUN',1,0
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @charname,'ITEM_MALL_GLOBAL_CHATTING',10,0
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @charname,'ITEM_ETC_E060529_GOLDDRAGONFLAG_M',10,0
END
FEMALE STARTER PACK
---------------------------------------------------------------------------
if(@Operation = '41' and @ItemRefID = 4641922) -- STARTER PACKED [FEMALE]
begin
declare @RefObjID2 int
declare @charname2 varchar(64)
Set @charname = (Select CharName16 from SRO_VT_SHARD.dbo._Char where CharID = @CharID);
Select @RefObjID=RefObjID from SRO_VT_SHARD.dbo._Char where CharID = @CharID
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @charname,'ITEM_MALL_PREMIUM_VIETNAM_GOLDTIME_PLUS',1,0
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @charname,'ITEM_HGSUNUCULAR_GODBLESS4',1,0
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @charname,'ITEM_MALL_AVATAR_W_NASRUN',1,0
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @charname,'ITEM_MALL_GLOBAL_CHATTING',10,0
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @charname,'ITEM_ETC_E060529_GOLDDRAGONFLAG_W',10,0
Sadece Birini okuttuğumda çalışıyor ama 2 sini aynı anda okutamıyorum ?
Verdiği HATA İSE BU :
MALE STARTER PACK
if(@Operation = '41' and @ItemRefID = 4641921) -- STARTER PACKED [MALE]
begin
declare @RefObjID int
declare @charname varchar(64)
Set @charname = (Select CharName16 from SRO_VT_SHARD.dbo._Char where CharID = @CharID);
Select @RefObjID=RefObjID from SRO_VT_SHARD.dbo._Char where CharID = @CharID
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @charname,'ITEM_MALL_PREMIUM_VIETNAM_GOLDTIME_PLUS',1,0
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @charname,'ITEM_HGSUNUCULAR_GODBLESS4',1,0
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @charname,'ITEM_MALL_AVATAR_M_NASRUN',1,0
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @charname,'ITEM_MALL_GLOBAL_CHATTING',10,0
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @charname,'ITEM_ETC_E060529_GOLDDRAGONFLAG_M',10,0
END
FEMALE STARTER PACK
---------------------------------------------------------------------------
if(@Operation = '41' and @ItemRefID = 4641922) -- STARTER PACKED [FEMALE]
begin
declare @RefObjID2 int
declare @charname2 varchar(64)
Set @charname = (Select CharName16 from SRO_VT_SHARD.dbo._Char where CharID = @CharID);
Select @RefObjID=RefObjID from SRO_VT_SHARD.dbo._Char where CharID = @CharID
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @charname,'ITEM_MALL_PREMIUM_VIETNAM_GOLDTIME_PLUS',1,0
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @charname,'ITEM_HGSUNUCULAR_GODBLESS4',1,0
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @charname,'ITEM_MALL_AVATAR_W_NASRUN',1,0
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @charname,'ITEM_MALL_GLOBAL_CHATTING',10,0
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @charname,'ITEM_ETC_E060529_GOLDDRAGONFLAG_W',10,0