Merhaba, Hoşgeldin!

VSRO.org, Silkroad Online, Knight Online, Metin2 ve diğer çevrimiçi oyunlar için öncü bir yardım ve geliştirme platformudur. Misyonumuz, bilgi ve deneyim sahibi bireyleri, bilgiye ihtiyaç duyanlarla bir araya getirerek, zengin bir etkileşim ortamı yaratmak ve farklı bakış açılarını birleştirmektir. Topluluğumuzda güçlü bir işbirliği ve öğrenme kültürü oluşturarak, herkesin değerli katkılarda bulunmasını sağlıyoruz.

vSRO Çözüldü Query den anlayan bir bakabilir mi?

S

snayls

Silkroad Manager
.
Katılım
23 Ocak 2019
Mesajlar
591
Çözümler
1
Tepkime puanı
636
Puanları
93
Konum
kahramanmaras
Türk Lirası
0.00₺
kodlar bunlar nerede hata var bakabilir misiniz itemi 1. slota bırakıyorum scrollu kullanıyorum ama item değişmiyor gereksinimleri de karşılıyorum hiç bir yerinde problem bulamadım item idlerini tek tek kontrol ettim ama yok hala aynı




1643747781331.png


1643747715441.png

1643747682112.png
 
Tarihe göre sırala Oylara göre sırala
item ıd lerini doğru yapman gerekiyor
Üst üste post gönderildiği için tek mesajda birleştirildi:

USE [SRO_VT_LOG]
GO

/****** Object: StoredProcedure [dbo].[_BLUE] Script Date: 04.02.2022 21:28:53 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO





CREATE procedure [dbo].[_BLUE]
@CharID int,
@Slot int

AS
SET NOCOUNT ON;
DECLARE @ItemID int = (Select ItemID from SRO_VT_SHARD.dbo._Inventory where CharID=@CharID and Slot=@Slot and ItemID > 0)
DECLARE @OLDITEMID int = (select RefItemID from SRO_VT_SHARD.dbo._Items where ID64=@ItemID)
UPDATE [SRO_VT_SHARD].[dbo].[_Items] SET
RefItemID = (select NewItemID from [__BLUE] where OldItemID=@OldItemID), CreaterName = 'Switcher'
Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @Slot and ItemID > 0) and RefItemID = @OLDITEMID



GO
Üst üste post gönderildiği için tek mesajda birleştirildi:

bunu yapıştır
Üst üste post gönderildiği için tek mesajda birleştirildi:

add log item bunu yapıştır
Üst üste post gönderildiği için tek mesajda birleştirildi:

/*GLOW SWITCHERS*/
if (@ItemRefID = 41872 and @Operation = 16) begin exec SRO_VT_LOG.._BLUE @CharID,13 end---blue
if (@ItemRefID = 41889 and @Operation = 16) begin exec SRO_VT_LOG.._RED @CharID,13 end--red
if (@ItemRefID = 41906 and @Operation = 16) begin exec SRO_VT_LOG.._YELLOW @CharID,13 end---yellow
if (@ItemRefID = 41923 and @Operation = 16) begin exec SRO_VT_LOG.._GREEN @CharID,13 end---green
if (@ItemRefID = 41940 and @Operation = 16) begin exec SRO_VT_LOG.._PURB @CharID,13 end---purb
if (@ItemRefID = 41957 and @Operation = 16) begin exec SRO_VT_LOG.._RAINBOW @CharID,13 end---Reinbow
Üst üste post gönderildiği için tek mesajda birleştirildi:

bunuda log iteme okut


USE [SRO_VT_LOG]
GO

/****** Object: Table [dbo].[__BLUE] Script Date: 04.02.2022 21:30:21 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[__BLUE](
[OldItemID] [int] NOT NULL,
[Old_Codename] [varchar](50) NOT NULL,
[NewItemID] [int] NULL,
[New_Codename] [varchar](50) NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO
Üst üste post gönderildiği için tek mesajda birleştirildi:

sonra new item ve old itemleri düzgüb bir şekilde yarla
sorun düzelecektir başarılar
 
Oyla 0
By_SagarD' Alıntı:
item ıd lerini doğru yapman gerekiyor
Üst üste post gönderildiği için tek mesajda birleştirildi:

USE [SRO_VT_LOG]
GO

/****** Object: StoredProcedure [dbo].[_BLUE] Script Date: 04.02.2022 21:28:53 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO





CREATE procedure [dbo].[_BLUE]
@CharID int,
@Slot int

AS
SET NOCOUNT ON;
DECLARE @ItemID int = (Select ItemID from SRO_VT_SHARD.dbo._Inventory where CharID=@CharID and Slot=@Slot and ItemID > 0)
DECLARE @OLDITEMID int = (select RefItemID from SRO_VT_SHARD.dbo._Items where ID64=@ItemID)
UPDATE [SRO_VT_SHARD].[dbo].[_Items] SET
RefItemID = (select NewItemID from [__BLUE] where OldItemID=@OldItemID), CreaterName = 'Switcher'
Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @Slot and ItemID > 0) and RefItemID = @OLDITEMID



GO
Üst üste post gönderildiği için tek mesajda birleştirildi:

bunu yapıştır
Üst üste post gönderildiği için tek mesajda birleştirildi:

add log item bunu yapıştır
Üst üste post gönderildiği için tek mesajda birleştirildi:

/*GLOW SWITCHERS*/
if (@ItemRefID = 41872 and @Operation = 16) begin exec SRO_VT_LOG.._BLUE @CharID,13 end---blue
if (@ItemRefID = 41889 and @Operation = 16) begin exec SRO_VT_LOG.._RED @CharID,13 end--red
if (@ItemRefID = 41906 and @Operation = 16) begin exec SRO_VT_LOG.._YELLOW @CharID,13 end---yellow
if (@ItemRefID = 41923 and @Operation = 16) begin exec SRO_VT_LOG.._GREEN @CharID,13 end---green
if (@ItemRefID = 41940 and @Operation = 16) begin exec SRO_VT_LOG.._PURB @CharID,13 end---purb
if (@ItemRefID = 41957 and @Operation = 16) begin exec SRO_VT_LOG.._RAINBOW @CharID,13 end---Reinbow
Üst üste post gönderildiği için tek mesajda birleştirildi:

bunuda log iteme okut


USE [SRO_VT_LOG]
GO

/****** Object: Table [dbo].[__BLUE] Script Date: 04.02.2022 21:30:21 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[__BLUE](
[OldItemID] [int] NOT NULL,
[Old_Codename] [varchar](50) NOT NULL,
[NewItemID] [int] NULL,
[New_Codename] [varchar](50) NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO
Üst üste post gönderildiği için tek mesajda birleştirildi:

sonra new item ve old itemleri düzgüb bir şekilde yarla
sorun düzelecektir başarılar
Genişletmek için tıkla ...
reis +7 ve +10 dan sonra dönüşmesini istiyorum o yüzden switcher kodlarını kullanamıyorum
teşekkür ederim ilgin için
eğer benim kodları düzenleme şansın varsa on numara olur


Kod:
İçeriği görebilmek için Giriş yap ya da üye ol.

Kod:
İçeriği görebilmek için Giriş yap ya da üye ol.
 
Oyla 0
dostum sana verdiğim koddan yapsana
Üst üste post gönderildiği için tek mesajda birleştirildi:

benim verdiğim kod dügün olanı
Üst üste post gönderildiği için tek mesajda birleştirildi:

1643750075041.png
Üst üste post gönderildiği için tek mesajda birleştirildi:

mantık bu dostum old ıd normal item old code name old itemin kodu new ıtem ıd item hangisine dönüşecekse new code name ise yeni itemin kodu bukadar
Üst üste post gönderildiği için tek mesajda birleştirildi:

IF (@Operation = 41) -- If item used!
Begin
IF (@ItemRefID = 45865) -- RefObjCommon ID
Begin
Execute [SRO_VT_LOG].[dbo].[_UpgradeSystem] @CharID
End
End
Üst üste post gönderildiği için tek mesajda birleştirildi:

IF (@Operation = 41) -- If item used!
Begin
IF (@ItemRefID = 45865) -- RefObjCommon ID
Begin
Execute [SRO_VT_LOG].[dbo].[_UpgradeSystem] @CharID
End
End
Üst üste post gönderildiği için tek mesajda birleştirildi:

USE [SRO_VT_LOG]
GO

/****** Object: StoredProcedure [dbo].[_UpgradeSystem] Script Date: 3.02.2022 02:01:00 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO


CREATE PROCEDURE [dbo].[_UpgradeSystem]
@CharID Int
As

-- Declare expression.
Declare @CreaterName Varchar(60) = 'Lee' , -- Creater Name
@WeaponSlot Int = 6 , -- char inventory weapon slot
@ShieldSlot Int = 7 , -- char inventory shield slot
@ReqOptLevel Int = 10 , -- Change old item requiared plus for upgrade.
@NewOptLevel Int = 0 , -- Change new item plus after upgrade
-- Set Old and New Weapons RefObjCommon ID below
-- Use This Query to get each item ID by Codename128
-- Select ID From [SRO_VT_SHARD].[dbo].[_RefObjCommon] Where CodeName128 Like 'Item Code Name'

---> Old weapon ID's ---> New weapons ID's
@Old_CH_SWORD_ID Int = 4042 , @New_CH_SWORD_ID Int = 4043 , --@New Chinese Sword
@Old_CH_BLADE_ID Int = 4078 , @New_CH_BLADE_ID Int = 4079 , --@Chinese Blade
@Old_CH_SPEAR_ID Int = 4114 , @New_CH_SPEAR_ID Int = 4115 , --@Chinese Spear
@Old_CH_TBLADE_ID Int = 4150 , @New_CH_TBLADE_ID Int = 4151 , --@Chinese Glaive
@Old_CH_BOW_ID Int = 4186 , @New_CH_BOW_ID Int = 4187 , --@Chinese Bow
@Old_CH_SHIELD_ID Int = 4222 , @New_CH_SHIELD_ID Int = 4223 , --@Chinese Shield
@Old_EU_DAGGER_ID Int = 25623 , @New_EU_DAGGER_ID Int = 25681 , --@European Dagger
@Old_EU_XBOW_ID Int = 25624 , @New_EU_XBOW_ID Int = 25682 , --@European CrossBow
@Old_EU_AXE_ID Int = 25622 , @New_EU_AXE_ID Int = 25680 , --@European Axe
@Old_EU_SWORD_ID Int = 25620 , @New_EU_SWORD_ID Int = 25678 , --@European One Hand Sword
@Old_EU_TSWORD_ID Int = 25621 , @New_EU_TSWORD_ID Int = 25679 , --@European Two Hand Sword
@Old_EU_TSTAFF_ID Int = 25625 , @New_EU_TSTAFF_ID Int = 25683 , --@European Two Hand Staff
@Old_EU_STAFF_ID Int = 25627 , @New_EU_STAFF_ID Int = 25685 , --@European Claric Rod
@Old_EU_DSTAFF_ID Int = 25626 , @New_EU_DSTAFF_ID Int = 25684 , --@European Warlock Rod
@Old_EU_HARP_ID Int = 25628 , @New_EU_HARP_ID Int = 25686 , --@European Harp
@Old_EU_SHIELD_ID Int = 25629 , @New_EU_SHIELD_ID Int = 25687 --@European Shield

--------------------------------------------------------------------------------------------
-- Start Upgrade system :

-- CH Weapons Upgrade.
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SWORD_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_CH_SWORD_ID and (OptLevel >= @ReqOptLevel) --@sword
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_BLADE_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_CH_BLADE_ID and (OptLevel >= @ReqOptLevel) --@Blade
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SPEAR_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_CH_SPEAR_ID and (OptLevel >= @ReqOptLevel) --@Spear
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_TBLADE_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_CH_TBLADE_ID and (OptLevel >= @ReqOptLevel) --@T-Blade
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_BOW_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_CH_BOW_ID and (OptLevel >= @ReqOptLevel) --@Bow
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SHIELD_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @ShieldSlot and ItemID> 0) and RefItemID = @Old_CH_SHIELD_ID and (OptLevel >= @ReqOptLevel) --@ShieldHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @ShieldSlot and ItemID> 0) and RefItemID = @Old_EU_SHIELD_ID and (OptLevel >= @ReqOptLevel) --@Shield
GO
Üst üste post gönderildiği için tek mesajda birleştirildi:

USE [SRO_VT_LOG]
GO

/****** Object: StoredProcedure [dbo].[_UpgradeSystem] Script Date: 3.02.2022 02:01:00 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO


CREATE PROCEDURE [dbo].[_UpgradeSystem]
@CharID Int
As

-- Declare expression.
Declare @CreaterName Varchar(60) = 'Lee' , -- Creater Name
@WeaponSlot Int = 6 , -- char inventory weapon slot
@ShieldSlot Int = 7 , -- char inventory shield slot
@ReqOptLevel Int = 10 , -- Change old item requiared plus for upgrade.
@NewOptLevel Int = 0 , -- Change new item plus after upgrade
-- Set Old and New Weapons RefObjCommon ID below
-- Use This Query to get each item ID by Codename128
-- Select ID From [SRO_VT_SHARD].[dbo].[_RefObjCommon] Where CodeName128 Like 'Item Code Name'

---> Old weapon ID's ---> New weapons ID's
@Old_CH_SWORD_ID Int = 4042 , @New_CH_SWORD_ID Int = 4043 , --@New Chinese Sword
@Old_CH_BLADE_ID Int = 4078 , @New_CH_BLADE_ID Int = 4079 , --@Chinese Blade
@Old_CH_SPEAR_ID Int = 4114 , @New_CH_SPEAR_ID Int = 4115 , --@Chinese Spear
@Old_CH_TBLADE_ID Int = 4150 , @New_CH_TBLADE_ID Int = 4151 , --@Chinese Glaive
@Old_CH_BOW_ID Int = 4186 , @New_CH_BOW_ID Int = 4187 , --@Chinese Bow
@Old_CH_SHIELD_ID Int = 4222 , @New_CH_SHIELD_ID Int = 4223 , --@Chinese Shield
@Old_EU_DAGGER_ID Int = 25623 , @New_EU_DAGGER_ID Int = 25681 , --@European Dagger
@Old_EU_XBOW_ID Int = 25624 , @New_EU_XBOW_ID Int = 25682 , --@European CrossBow
@Old_EU_AXE_ID Int = 25622 , @New_EU_AXE_ID Int = 25680 , --@European Axe
@Old_EU_SWORD_ID Int = 25620 , @New_EU_SWORD_ID Int = 25678 , --@European One Hand Sword
@Old_EU_TSWORD_ID Int = 25621 , @New_EU_TSWORD_ID Int = 25679 , --@European Two Hand Sword
@Old_EU_TSTAFF_ID Int = 25625 , @New_EU_TSTAFF_ID Int = 25683 , --@European Two Hand Staff
@Old_EU_STAFF_ID Int = 25627 , @New_EU_STAFF_ID Int = 25685 , --@European Claric Rod
@Old_EU_DSTAFF_ID Int = 25626 , @New_EU_DSTAFF_ID Int = 25684 , --@European Warlock Rod
@Old_EU_HARP_ID Int = 25628 , @New_EU_HARP_ID Int = 25686 , --@European Harp
@Old_EU_SHIELD_ID Int = 25629 , @New_EU_SHIELD_ID Int = 25687 --@European Shield

--------------------------------------------------------------------------------------------
-- Start Upgrade system :

-- CH Weapons Upgrade.
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SWORD_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_CH_SWORD_ID and (OptLevel >= @ReqOptLevel) --@sword
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_BLADE_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_CH_BLADE_ID and (OptLevel >= @ReqOptLevel) --@Blade
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SPEAR_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_CH_SPEAR_ID and (OptLevel >= @ReqOptLevel) --@Spear
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_TBLADE_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_CH_TBLADE_ID and (OptLevel >= @ReqOptLevel) --@T-Blade
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_BOW_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_CH_BOW_ID and (OptLevel >= @ReqOptLevel) --@Bow
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SHIELD_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @ShieldSlot and ItemID> 0) and RefItemID = @Old_CH_SHIELD_ID and (OptLevel >= @ReqOptLevel) --@ShieldHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @ShieldSlot and ItemID> 0) and RefItemID = @Old_EU_SHIELD_ID and (OptLevel >= @ReqOptLevel) --@Shield
GO
Üst üste post gönderildiği için tek mesajda birleştirildi:

USE [SRO_VT_LOG]
GO

/****** Object: StoredProcedure [dbo].[_UpgradeSystem] Script Date: 3.02.2022 02:01:00 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO


CREATE PROCEDURE [dbo].[_UpgradeSystem]
@CharID Int
As

-- Declare expression.
Declare @CreaterName Varchar(60) = 'Lee' , -- Creater Name
@WeaponSlot Int = 6 , -- char inventory weapon slot
@ShieldSlot Int = 7 , -- char inventory shield slot
@ReqOptLevel Int = 10 , -- Change old item requiared plus for upgrade.
@NewOptLevel Int = 0 , -- Change new item plus after upgrade
-- Set Old and New Weapons RefObjCommon ID below
-- Use This Query to get each item ID by Codename128
-- Select ID From [SRO_VT_SHARD].[dbo].[_RefObjCommon] Where CodeName128 Like 'Item Code Name'

---> Old weapon ID's ---> New weapons ID's
@Old_CH_SWORD_ID Int = 4042 , @New_CH_SWORD_ID Int = 4043 , --@New Chinese Sword
@Old_CH_BLADE_ID Int = 4078 , @New_CH_BLADE_ID Int = 4079 , --@Chinese Blade
@Old_CH_SPEAR_ID Int = 4114 , @New_CH_SPEAR_ID Int = 4115 , --@Chinese Spear
@Old_CH_TBLADE_ID Int = 4150 , @New_CH_TBLADE_ID Int = 4151 , --@Chinese Glaive
@Old_CH_BOW_ID Int = 4186 , @New_CH_BOW_ID Int = 4187 , --@Chinese Bow
@Old_CH_SHIELD_ID Int = 4222 , @New_CH_SHIELD_ID Int = 4223 , --@Chinese Shield
@Old_EU_DAGGER_ID Int = 25623 , @New_EU_DAGGER_ID Int = 25681 , --@European Dagger
@Old_EU_XBOW_ID Int = 25624 , @New_EU_XBOW_ID Int = 25682 , --@European CrossBow
@Old_EU_AXE_ID Int = 25622 , @New_EU_AXE_ID Int = 25680 , --@European Axe
@Old_EU_SWORD_ID Int = 25620 , @New_EU_SWORD_ID Int = 25678 , --@European One Hand Sword
@Old_EU_TSWORD_ID Int = 25621 , @New_EU_TSWORD_ID Int = 25679 , --@European Two Hand Sword
@Old_EU_TSTAFF_ID Int = 25625 , @New_EU_TSTAFF_ID Int = 25683 , --@European Two Hand Staff
@Old_EU_STAFF_ID Int = 25627 , @New_EU_STAFF_ID Int = 25685 , --@European Claric Rod
@Old_EU_DSTAFF_ID Int = 25626 , @New_EU_DSTAFF_ID Int = 25684 , --@European Warlock Rod
@Old_EU_HARP_ID Int = 25628 , @New_EU_HARP_ID Int = 25686 , --@European Harp
@Old_EU_SHIELD_ID Int = 25629 , @New_EU_SHIELD_ID Int = 25687 --@European Shield

--------------------------------------------------------------------------------------------
-- Start Upgrade system :

-- CH Weapons Upgrade.
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SWORD_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_CH_SWORD_ID and (OptLevel >= @ReqOptLevel) --@sword
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_BLADE_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_CH_BLADE_ID and (OptLevel >= @ReqOptLevel) --@Blade
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SPEAR_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_CH_SPEAR_ID and (OptLevel >= @ReqOptLevel) --@Spear
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_TBLADE_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_CH_TBLADE_ID and (OptLevel >= @ReqOptLevel) --@T-Blade
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_BOW_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_CH_BOW_ID and (OptLevel >= @ReqOptLevel) --@Bow
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SHIELD_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @ShieldSlot and ItemID> 0) and RefItemID = @Old_CH_SHIELD_ID and (OptLevel >= @ReqOptLevel) --@ShieldHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @ShieldSlot and ItemID> 0) and RefItemID = @Old_EU_SHIELD_ID and (OptLevel >= @ReqOptLevel) --@Shield
GO
 
Oyla 0
By_SagarD' Alıntı:
dostum sana verdiğim koddan yapsana
Üst üste post gönderildiği için tek mesajda birleştirildi:

benim verdiğim kod dügün olanı
Üst üste post gönderildiği için tek mesajda birleştirildi:

Ekli dosyayı görüntüle 12766
Üst üste post gönderildiği için tek mesajda birleştirildi:

mantık bu dostum old ıd normal item old code name old itemin kodu new ıtem ıd item hangisine dönüşecekse new code name ise yeni itemin kodu bukadar
Üst üste post gönderildiği için tek mesajda birleştirildi:

IF (@Operation = 41) -- If item used!
Begin
IF (@ItemRefID = 45865) -- RefObjCommon ID
Begin
Execute [SRO_VT_LOG].[dbo].[_UpgradeSystem] @CharID
End
End
Üst üste post gönderildiği için tek mesajda birleştirildi:

IF (@Operation = 41) -- If item used!
Begin
IF (@ItemRefID = 45865) -- RefObjCommon ID
Begin
Execute [SRO_VT_LOG].[dbo].[_UpgradeSystem] @CharID
End
End
Üst üste post gönderildiği için tek mesajda birleştirildi:

USE [SRO_VT_LOG]
GO

/****** Object: StoredProcedure [dbo].[_UpgradeSystem] Script Date: 3.02.2022 02:01:00 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO


CREATE PROCEDURE [dbo].[_UpgradeSystem]
@CharID Int
As

-- Declare expression.
Declare @CreaterName Varchar(60) = 'Lee' , -- Creater Name
@WeaponSlot Int = 6 , -- char inventory weapon slot
@ShieldSlot Int = 7 , -- char inventory shield slot
@ReqOptLevel Int = 10 , -- Change old item requiared plus for upgrade.
@NewOptLevel Int = 0 , -- Change new item plus after upgrade
-- Set Old and New Weapons RefObjCommon ID below
-- Use This Query to get each item ID by Codename128
-- Select ID From [SRO_VT_SHARD].[dbo].[_RefObjCommon] Where CodeName128 Like 'Item Code Name'

---> Old weapon ID's ---> New weapons ID's
@Old_CH_SWORD_ID Int = 4042 , @New_CH_SWORD_ID Int = 4043 , --@New Chinese Sword
@Old_CH_BLADE_ID Int = 4078 , @New_CH_BLADE_ID Int = 4079 , --@Chinese Blade
@Old_CH_SPEAR_ID Int = 4114 , @New_CH_SPEAR_ID Int = 4115 , --@Chinese Spear
@Old_CH_TBLADE_ID Int = 4150 , @New_CH_TBLADE_ID Int = 4151 , --@Chinese Glaive
@Old_CH_BOW_ID Int = 4186 , @New_CH_BOW_ID Int = 4187 , --@Chinese Bow
@Old_CH_SHIELD_ID Int = 4222 , @New_CH_SHIELD_ID Int = 4223 , --@Chinese Shield
@Old_EU_DAGGER_ID Int = 25623 , @New_EU_DAGGER_ID Int = 25681 , --@European Dagger
@Old_EU_XBOW_ID Int = 25624 , @New_EU_XBOW_ID Int = 25682 , --@European CrossBow
@Old_EU_AXE_ID Int = 25622 , @New_EU_AXE_ID Int = 25680 , --@European Axe
@Old_EU_SWORD_ID Int = 25620 , @New_EU_SWORD_ID Int = 25678 , --@European One Hand Sword
@Old_EU_TSWORD_ID Int = 25621 , @New_EU_TSWORD_ID Int = 25679 , --@European Two Hand Sword
@Old_EU_TSTAFF_ID Int = 25625 , @New_EU_TSTAFF_ID Int = 25683 , --@European Two Hand Staff
@Old_EU_STAFF_ID Int = 25627 , @New_EU_STAFF_ID Int = 25685 , --@European Claric Rod
@Old_EU_DSTAFF_ID Int = 25626 , @New_EU_DSTAFF_ID Int = 25684 , --@European Warlock Rod
@Old_EU_HARP_ID Int = 25628 , @New_EU_HARP_ID Int = 25686 , --@European Harp
@Old_EU_SHIELD_ID Int = 25629 , @New_EU_SHIELD_ID Int = 25687 --@European Shield

--------------------------------------------------------------------------------------------
-- Start Upgrade system :

-- CH Weapons Upgrade.
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SWORD_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_CH_SWORD_ID and (OptLevel >= @ReqOptLevel) --@sword
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_BLADE_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_CH_BLADE_ID and (OptLevel >= @ReqOptLevel) --@Blade
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SPEAR_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_CH_SPEAR_ID and (OptLevel >= @ReqOptLevel) --@Spear
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_TBLADE_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_CH_TBLADE_ID and (OptLevel >= @ReqOptLevel) --@T-Blade
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_BOW_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_CH_BOW_ID and (OptLevel >= @ReqOptLevel) --@Bow
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SHIELD_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @ShieldSlot and ItemID> 0) and RefItemID = @Old_CH_SHIELD_ID and (OptLevel >= @ReqOptLevel) --@ShieldHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @ShieldSlot and ItemID> 0) and RefItemID = @Old_EU_SHIELD_ID and (OptLevel >= @ReqOptLevel) --@Shield
GO
Üst üste post gönderildiği için tek mesajda birleştirildi:

USE [SRO_VT_LOG]
GO

/****** Object: StoredProcedure [dbo].[_UpgradeSystem] Script Date: 3.02.2022 02:01:00 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO


CREATE PROCEDURE [dbo].[_UpgradeSystem]
@CharID Int
As

-- Declare expression.
Declare @CreaterName Varchar(60) = 'Lee' , -- Creater Name
@WeaponSlot Int = 6 , -- char inventory weapon slot
@ShieldSlot Int = 7 , -- char inventory shield slot
@ReqOptLevel Int = 10 , -- Change old item requiared plus for upgrade.
@NewOptLevel Int = 0 , -- Change new item plus after upgrade
-- Set Old and New Weapons RefObjCommon ID below
-- Use This Query to get each item ID by Codename128
-- Select ID From [SRO_VT_SHARD].[dbo].[_RefObjCommon] Where CodeName128 Like 'Item Code Name'

---> Old weapon ID's ---> New weapons ID's
@Old_CH_SWORD_ID Int = 4042 , @New_CH_SWORD_ID Int = 4043 , --@New Chinese Sword
@Old_CH_BLADE_ID Int = 4078 , @New_CH_BLADE_ID Int = 4079 , --@Chinese Blade
@Old_CH_SPEAR_ID Int = 4114 , @New_CH_SPEAR_ID Int = 4115 , --@Chinese Spear
@Old_CH_TBLADE_ID Int = 4150 , @New_CH_TBLADE_ID Int = 4151 , --@Chinese Glaive
@Old_CH_BOW_ID Int = 4186 , @New_CH_BOW_ID Int = 4187 , --@Chinese Bow
@Old_CH_SHIELD_ID Int = 4222 , @New_CH_SHIELD_ID Int = 4223 , --@Chinese Shield
@Old_EU_DAGGER_ID Int = 25623 , @New_EU_DAGGER_ID Int = 25681 , --@European Dagger
@Old_EU_XBOW_ID Int = 25624 , @New_EU_XBOW_ID Int = 25682 , --@European CrossBow
@Old_EU_AXE_ID Int = 25622 , @New_EU_AXE_ID Int = 25680 , --@European Axe
@Old_EU_SWORD_ID Int = 25620 , @New_EU_SWORD_ID Int = 25678 , --@European One Hand Sword
@Old_EU_TSWORD_ID Int = 25621 , @New_EU_TSWORD_ID Int = 25679 , --@European Two Hand Sword
@Old_EU_TSTAFF_ID Int = 25625 , @New_EU_TSTAFF_ID Int = 25683 , --@European Two Hand Staff
@Old_EU_STAFF_ID Int = 25627 , @New_EU_STAFF_ID Int = 25685 , --@European Claric Rod
@Old_EU_DSTAFF_ID Int = 25626 , @New_EU_DSTAFF_ID Int = 25684 , --@European Warlock Rod
@Old_EU_HARP_ID Int = 25628 , @New_EU_HARP_ID Int = 25686 , --@European Harp
@Old_EU_SHIELD_ID Int = 25629 , @New_EU_SHIELD_ID Int = 25687 --@European Shield

--------------------------------------------------------------------------------------------
-- Start Upgrade system :

-- CH Weapons Upgrade.
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SWORD_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_CH_SWORD_ID and (OptLevel >= @ReqOptLevel) --@sword
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_BLADE_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_CH_BLADE_ID and (OptLevel >= @ReqOptLevel) --@Blade
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SPEAR_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_CH_SPEAR_ID and (OptLevel >= @ReqOptLevel) --@Spear
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_TBLADE_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_CH_TBLADE_ID and (OptLevel >= @ReqOptLevel) --@T-Blade
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_BOW_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_CH_BOW_ID and (OptLevel >= @ReqOptLevel) --@Bow
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SHIELD_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @ShieldSlot and ItemID> 0) and RefItemID = @Old_CH_SHIELD_ID and (OptLevel >= @ReqOptLevel) --@ShieldHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @ShieldSlot and ItemID> 0) and RefItemID = @Old_EU_SHIELD_ID and (OptLevel >= @ReqOptLevel) --@Shield
GO
Üst üste post gönderildiği için tek mesajda birleştirildi:

USE [SRO_VT_LOG]
GO

/****** Object: StoredProcedure [dbo].[_UpgradeSystem] Script Date: 3.02.2022 02:01:00 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO


CREATE PROCEDURE [dbo].[_UpgradeSystem]
@CharID Int
As

-- Declare expression.
Declare @CreaterName Varchar(60) = 'Lee' , -- Creater Name
@WeaponSlot Int = 6 , -- char inventory weapon slot
@ShieldSlot Int = 7 , -- char inventory shield slot
@ReqOptLevel Int = 10 , -- Change old item requiared plus for upgrade.
@NewOptLevel Int = 0 , -- Change new item plus after upgrade
-- Set Old and New Weapons RefObjCommon ID below
-- Use This Query to get each item ID by Codename128
-- Select ID From [SRO_VT_SHARD].[dbo].[_RefObjCommon] Where CodeName128 Like 'Item Code Name'

---> Old weapon ID's ---> New weapons ID's
@Old_CH_SWORD_ID Int = 4042 , @New_CH_SWORD_ID Int = 4043 , --@New Chinese Sword
@Old_CH_BLADE_ID Int = 4078 , @New_CH_BLADE_ID Int = 4079 , --@Chinese Blade
@Old_CH_SPEAR_ID Int = 4114 , @New_CH_SPEAR_ID Int = 4115 , --@Chinese Spear
@Old_CH_TBLADE_ID Int = 4150 , @New_CH_TBLADE_ID Int = 4151 , --@Chinese Glaive
@Old_CH_BOW_ID Int = 4186 , @New_CH_BOW_ID Int = 4187 , --@Chinese Bow
@Old_CH_SHIELD_ID Int = 4222 , @New_CH_SHIELD_ID Int = 4223 , --@Chinese Shield
@Old_EU_DAGGER_ID Int = 25623 , @New_EU_DAGGER_ID Int = 25681 , --@European Dagger
@Old_EU_XBOW_ID Int = 25624 , @New_EU_XBOW_ID Int = 25682 , --@European CrossBow
@Old_EU_AXE_ID Int = 25622 , @New_EU_AXE_ID Int = 25680 , --@European Axe
@Old_EU_SWORD_ID Int = 25620 , @New_EU_SWORD_ID Int = 25678 , --@European One Hand Sword
@Old_EU_TSWORD_ID Int = 25621 , @New_EU_TSWORD_ID Int = 25679 , --@European Two Hand Sword
@Old_EU_TSTAFF_ID Int = 25625 , @New_EU_TSTAFF_ID Int = 25683 , --@European Two Hand Staff
@Old_EU_STAFF_ID Int = 25627 , @New_EU_STAFF_ID Int = 25685 , --@European Claric Rod
@Old_EU_DSTAFF_ID Int = 25626 , @New_EU_DSTAFF_ID Int = 25684 , --@European Warlock Rod
@Old_EU_HARP_ID Int = 25628 , @New_EU_HARP_ID Int = 25686 , --@European Harp
@Old_EU_SHIELD_ID Int = 25629 , @New_EU_SHIELD_ID Int = 25687 --@European Shield

--------------------------------------------------------------------------------------------
-- Start Upgrade system :

-- CH Weapons Upgrade.
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SWORD_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_CH_SWORD_ID and (OptLevel >= @ReqOptLevel) --@sword
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_BLADE_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_CH_BLADE_ID and (OptLevel >= @ReqOptLevel) --@Blade
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SPEAR_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_CH_SPEAR_ID and (OptLevel >= @ReqOptLevel) --@Spear
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_TBLADE_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_CH_TBLADE_ID and (OptLevel >= @ReqOptLevel) --@T-Blade
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_BOW_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_CH_BOW_ID and (OptLevel >= @ReqOptLevel) --@Bow
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SHIELD_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @ShieldSlot and ItemID> 0) and RefItemID = @Old_CH_SHIELD_ID and (OptLevel >= @ReqOptLevel) --@ShieldHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @ShieldSlot and ItemID> 0) and RefItemID = @Old_EU_SHIELD_ID and (OptLevel >= @ReqOptLevel) --@Shield
GO
Genişletmek için tıkla ...
teşekkürler bu işime yarar
 
Oyla 0
Cevap yazmak için giriş yap yada kayıt ol.

Benzer konular

MrStrelitzia
iSRO-R Paylaşım [DB To Media]DB den TXT ve Excel Tablosu olarak belirli tabloları çekmek için Query, DB to media kullanamayanlar içindir.
2
Cevaplar
12
Görüntüleme
1K
johnnydung
J
MrStrelitzia
vSRO Paylaşım [DB To Media]DB den TXT ve Excel Tablosu olarak belirli tabloları çekmek için Query, DB to media kullanamayanlar içindir.
Cevaplar
3
Görüntüleme
389
omar125
omar125
karpuzcilek35
  • Çözüldü
vSRO Çözüldü Mob Level ve Defanslarını ayarlamak için query
2 3
Cevaplar
21
Görüntüleme
151
karpuzcilek35
karpuzcilek35
iMonarch
vSRO Paylaşım VSRO | Fortress Schedule Time Query
2
Cevaplar
11
Görüntüleme
114
SametFB
SametFB
Thor
vSRO Paylaşım Oyundaki İtemlerin Stack Değerini Değiştirme Query
Cevaplar
3
Görüntüleme
175
iMonarch
iMonarch
Geri
Üst Alt