Merhaba arkadaşlar, Pvp sistemlik oyun veritabanı hazırlıyorum içerisine bir sürü model ve glow eklendi sıra bunları scrola bağlama işi kaldı. Elimdeki prosedürleri ve tabloları ayarlamam rağmen çalıştıramadım. Elinde düzgün Model glow switch 1. slotta çalışabilcek prosedür olan paylaşabilirmi. Teşekkürlerimi sunuyorum.
Kullandıgım prosedürler:
Kullandıgım prosedürler:
| IF(@Operation = 41 AND @ItemRefID= 47191) -- 10 DG Begin Declare @refItemID int; Declare @ItemCode varchar(64); Declare @NewItemID varchar(64); SET @refItemID = (SELECT RefItemID From [SRO_VT_SHARD].[dbo].[_Items] Where ID64 = ( Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0 )); SET @ItemCode = (SELECT NameStrID128 From [SRO_VT_SHARD].[dbo].[_RefObjCommon] Where ID = @refItemID); SET @NewItemID = (SELECT ID From [SRO_VT_SHARD].[dbo].[_RefObjCommon] Where NameStrID128 = @ItemCode AND CodeName128 like '%ELYSON' ); Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @NewItemID Where ID64 = ( Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0 ); END /*MODEL SWITCHERS*/ if (@ItemRefID = 47191 and @Operation = 41) begin exec SRO_SYSTEM.._Switcher_8 @CharID,13 end if (@ItemRefID = 302036 and @Operation = 16) begin exec SRO_SYSTEM.._Switcher_9 @CharID,13 end if (@ItemRefID = 302037 and @Operation = 16) begin exec SRO_SYSTEM.._Switcher_10 @CharID,13 end if (@ItemRefID = 302038 and @Operation = 16) begin exec SRO_SYSTEM.._Switcher_11 @CharID,13 end if (@ItemRefID = 302039 and @Operation = 16) begin exec SRO_SYSTEM.._Switcher_11_A @CharID,13 end if (@ItemRefID = 302040 and @Operation = 16) begin exec SRO_SYSTEM.._Switcher_11_B @CharID,13 end if (@ItemRefID = 302041 and @Operation = 16) begin exec SRO_SYSTEM.._Switcher_12 @CharID,13 end if (@ItemRefID = 302042 and @Operation = 16) begin exec SRO_SYSTEM.._Switcher_13 @CharID,13 end if (@ItemRefID = 302043 and @Operation = 16) begin exec SRO_SYSTEM.._Switcher_14 @CharID,13 end if (@ItemRefID = 302044 and @Operation = 16) begin exec SRO_SYSTEM.._Switcher_15 @CharID,13 end if (@ItemRefID = 302045 and @Operation = 16) begin exec SRO_SYSTEM.._Switcher_16 @CharID,13 end if (@ItemRefID = 302046 and @Operation = 16) begin exec SRO_SYSTEM.._Switcher_17 @CharID,13 end /*GLOW SWITCHERS*/ if (@ItemRefID = 47191 and @Operation = 41) begin exec SRO_SYSTEM.._Glow_1 @CharID,13 end if (@ItemRefID = 302048 and @Operation = 16) begin exec SRO_SYSTEM.._Glow_2 @CharID,13 end if (@ItemRefID = 302049 and @Operation = 16) begin exec SRO_SYSTEM.._Glow_3 @CharID,13 end if (@ItemRefID = 302050 and @Operation = 16) begin exec SRO_SYSTEM.._Glow_4 @CharID,13 end if (@ItemRefID = 302051 and @Operation = 16) begin exec SRO_SYSTEM.._Glow_5 @CharID,13 end if (@ItemRefID = 302052 and @Operation = 16) begin exec SRO_SYSTEM.._Glow_6 @CharID,13 end if (@ItemRefID = 302053 and @Operation = 16) begin exec SRO_SYSTEM.._Glow_7 @CharID,13 end if (@ItemRefID = 302054 and @Operation = 16) begin exec SRO_SYSTEM.._Glow_8 @CharID,13 end if (@ItemRefID = 302057 and @Operation = 16) begin exec SRO_SYSTEM.._Glow_Reset @CharID,13 end |
