Skip to main content
Merhaba, Ziyaretçi!

Bizi ziyaret ettiğiniz için teşekkür ederiz!

Sitemizden daha iyi yararlanabilmek için "Giriş" yapmalı ya da "Kayıt" olmalısınız ;)

("vSro Forum - vSro Rehberi" ayrıcalıktır!)

vSro Forum - vSro Rehberi ve Paylaşımları
f8 filter
Sun World
Raymond

Konuyu Oyla:
  • Derecelendirme: 0/5 - 0 oy
  • 1
  • 2
  • 3
  • 4
  • 5

SORU weapon upgrade hakkında!!
weapon upgrade hakkında!!
#1
Öncelikle sa
0 dan bı database editlemeye basladım.
elımdekı weapon uprage prosedurlerını uyguladım
kodlardada bı hata cıkmadı upgrade ıcın scrool ekledım
return kullandıgımda ıtem degısmıyor
sanırım scroolu gormuyor yardımcı olabılırmısınız acaba...
Cevapla
RE: weapon upgrade hakkında!!
#2
Son Düzenleme: 15.05.2016, Saat: 07:43, Düzenleyen: Nyrox. Sebep: düzenleme
if(@Operation = 41 and @ItemRefID = 150002)
prosedürün scrollu bulması genel olarak böyle olur, scrollu görmüyo diyosan scrollun rebobjcommon tablosundaki id'sini "150002" yazan yere yazmalısın. denerken eşyayı envanterin 1. satırına koy olmadı eline takıp öyle dene.
Cevapla
Cvp: RE: weapon upgrade hakkında!!
#3
(15.05.2016, Saat: 07:42)Nyrox Adlı Kullanıcıdan Alıntı: if(@Operation = 41 and @ItemRefID = 150002)
prosedürün scrollu bulması genel olarak böyle olur, scrollu görmüyo diyosan scrollun rebobjcommon tablosundaki id'sini "150002" yazan yere yazmalısın. denerken eşyayı envanterin 1. satırına koy olmadı eline takıp öyle dene.

bılıyorum onu ınceledım fakat prosedurde bırden fazla refıtem ıd mevcut onu anlıyamadım kodlar sıkıntılı gbı sankı..yardımcı olursan sevınırım.


Kod:
--------------------------------------------------------------- UPGRADE
if (@ItemRefID = '47051')
begin
DECLARE @OldItemCodeName varchar(128)
DECLARE @OldItemPlus int
DECLARE @NewItemCodeName varchar(128)
DECLARE @NewItemPlus int
DECLARE @ReplaceID int
-------
set @OldItemCodeName= 'ITEM_CH_BLADE_08_B_RARE'
set @OldItemPlus =9
set @NewItemCodeName = 'ITEM_CH_BLADE_08_C_RARE'
set @NewItemPlus = 0
SET @REPLACEID = (select top 1 ItemID from SRO_VT_SHARD.._Inventory as inv inner join SRO_VT_SHARD.._Items as itm on inv.ItemID  = itm.ID64 inner join SRO_VT_SHARD.._RefObjCommon as common on itm.RefItemID = common.ID where inv.CharID = @CharID and common.CodeName128 = @olditemCodeName and itm.OptLevel >= @OldItemPlus)
if (@ReplaceID > 0)
begin
Update SRO_VT_SHARD.._Inventory set ItemID = 0 where ItemID = @ReplaceID and CharID = @CharID
select @CharName =CharName16  from SRO_VT_SHARD.._Char where CharID=@CharID
exec SRO_VT_SHARD.._ADD_ITEM_EXTERN @CharName,@NewItemCodeName,1,@NewItemPlus
end
end
----------------------------------------------------------------- UPGRADE
if (@ItemRefID = '47052')
begin

set @OldItemCodeName= 'ITEM_CH_BOW_08_B_RARE'
set @OldItemPlus =9
set @NewItemCodeName =  ('ITEM_CH_BOW_08_C_RARE')
set @NewItemPlus = 0
SET @REPLACEID = (select top 1 ItemID from SRO_VT_SHARD.._Inventory as inv inner join SRO_VT_SHARD.._Items as itm on inv.ItemID  = itm.ID64 inner join SRO_VT_SHARD.._RefObjCommon as common on itm.RefItemID = common.ID where inv.CharID = @CharID and common.CodeName128 = @olditemCodeName and itm.OptLevel >= @OldItemPlus)
if (@ReplaceID > 0)
begin
Update SRO_VT_SHARD.._Inventory set ItemID = 0 where ItemID = @ReplaceID and CharID = @CharID
select @CharName =CharName16  from SRO_VT_SHARD.._Char where CharID=@CharID
exec SRO_VT_SHARD.._ADD_ITEM_EXTERN @CharName,@NewItemCodeName,1,@NewItemPlus
end
end
----------------------------------------------------------------------- UPGRADE
if (@ItemRefID = '47053')
begin
 
set @OldItemCodeName= 'ITEM_CH_SPEAR_08_B_RARE'
set @OldItemPlus =9
set @NewItemCodeName =  ('ITEM_CH_SPEAR_08_C_RARE')
set @NewItemPlus = 0
SET @REPLACEID = (select top 1 ItemID from SRO_VT_SHARD.._Inventory as inv inner join SRO_VT_SHARD.._Items as itm on inv.ItemID  = itm.ID64 inner join SRO_VT_SHARD.._RefObjCommon as common on itm.RefItemID = common.ID where inv.CharID = @CharID and common.CodeName128 = @olditemCodeName and itm.OptLevel >= @OldItemPlus)
if (@ReplaceID > 0)
begin
Update SRO_VT_SHARD.._Inventory set ItemID = 0 where ItemID = @ReplaceID and CharID = @CharID
select @CharName =CharName16  from SRO_VT_SHARD.._Char where CharID=@CharID
exec SRO_VT_SHARD.._ADD_ITEM_EXTERN @CharName,@NewItemCodeName,1,@NewItemPlus
end
end
------------------------------------------------------------------------ UPGRADE
if (@ItemRefID = '47054')
begin

set @OldItemCodeName= 'ITEM_CH_SWORD_08_B_RARE'
set @OldItemPlus =9
set @NewItemCodeName =  ('ITEM_CH_SWORD_08_C_RARE')
set @NewItemPlus = 0
SET @REPLACEID = (select top 1 ItemID from SRO_VT_SHARD.._Inventory as inv inner join SRO_VT_SHARD.._Items as itm on inv.ItemID  = itm.ID64 inner join SRO_VT_SHARD.._RefObjCommon as common on itm.RefItemID = common.ID where inv.CharID = @CharID and common.CodeName128 = @olditemCodeName and itm.OptLevel >= @OldItemPlus)
if (@ReplaceID > 0)
begin
Update SRO_VT_SHARD.._Inventory set ItemID = 0 where ItemID = @ReplaceID and CharID = @CharID
select @CharName =CharName16  from SRO_VT_SHARD.._Char where CharID=@CharID
exec SRO_VT_SHARD.._ADD_ITEM_EXTERN @CharName,@NewItemCodeName,1,@NewItemPlus
end
end
------------------------------------------------------------------------ UPGRADE
if (@ItemRefID = '47055')
begin

set @OldItemCodeName= 'ITEM_CH_TBLADE_08_B_RARE'
set @OldItemPlus =9
set @NewItemCodeName =  ('ITEM_CH_TBLADE_08_C_RARE')
set @NewItemPlus = 0
SET @REPLACEID = (select top 1 ItemID from SRO_VT_SHARD.._Inventory as inv inner join SRO_VT_SHARD.._Items as itm on inv.ItemID  = itm.ID64 inner join SRO_VT_SHARD.._RefObjCommon as common on itm.RefItemID = common.ID where inv.CharID = @CharID and common.CodeName128 = @olditemCodeName and itm.OptLevel >= @OldItemPlus)
if (@ReplaceID > 0)
begin
Update SRO_VT_SHARD.._Inventory set ItemID = 0 where ItemID = @ReplaceID and CharID = @CharID
select @CharName =CharName16  from SRO_VT_SHARD.._Char where CharID=@CharID
exec SRO_VT_SHARD.._ADD_ITEM_EXTERN @CharName,@NewItemCodeName,1,@NewItemPlus
end
end
---------------------------------------------------------------------------
if (@ItemRefID = '47056')
begin
set @OldItemCodeName= 'ITEM_CH_SHIELD_08_B_RARE'
set @OldItemPlus =9
set @NewItemCodeName =  ('ITEM_CH_SHIELD_08_C_RARE')
set @NewItemPlus = 0
SET @REPLACEID = (select top 1 ItemID from SRO_VT_SHARD.._Inventory as inv inner join SRO_VT_SHARD.._Items as itm on inv.ItemID  = itm.ID64 inner join SRO_VT_SHARD.._RefObjCommon as common on itm.RefItemID = common.ID where inv.CharID = @CharID and common.CodeName128 = @olditemCodeName and itm.OptLevel >= @OldItemPlus)
if (@ReplaceID > 0)
begin
Update SRO_VT_SHARD.._Inventory set ItemID = 0 where ItemID = @ReplaceID and CharID = @CharID
select @CharName =CharName16  from SRO_VT_SHARD.._Char where CharID=@CharID
exec SRO_VT_SHARD.._ADD_ITEM_EXTERN @CharName,@NewItemCodeName,1,@NewItemPlus
end
end
----------------------------------------------------------------------------
if (@ItemRefID = '47057')
begin
set @OldItemCodeName= 'ITEM_EU_AXE_13_B_RARE'
set @OldItemPlus =15
set @NewItemCodeName =  ('ITEM_EU_AXE_13_C_RARE')
set @NewItemPlus = 0
SET @REPLACEID = (select top 1 ItemID from SRO_VT_SHARD.._Inventory as inv inner join SRO_VT_SHARD.._Items as itm on inv.ItemID  = itm.ID64 inner join SRO_VT_SHARD.._RefObjCommon as common on itm.RefItemID = common.ID where inv.CharID = @CharID and common.CodeName128 = @olditemCodeName and itm.OptLevel >= @OldItemPlus)
if (@ReplaceID > 0)
begin
Update SRO_VT_SHARD.._Inventory set ItemID = 0 where ItemID = @ReplaceID and CharID = @CharID
select @CharName =CharName16  from SRO_VT_SHARD.._Char where CharID=@CharID
exec SRO_VT_SHARD.._ADD_ITEM_EXTERN @CharName,@NewItemCodeName,1,@NewItemPlus
end
end
---------------------------------------------------------------------------
if (@ItemRefID = '47058')
begin
set @OldItemCodeName= 'ITEM_EU_CROSSBOW_13_B_RARE'
set @OldItemPlus =15
set @NewItemCodeName =  ('ITEM_EU_CROSSBOW_13_C_RARE')
set @NewItemPlus = 0
SET @REPLACEID = (select top 1 ItemID from SRO_VT_SHARD.._Inventory as inv inner join SRO_VT_SHARD.._Items as itm on inv.ItemID  = itm.ID64 inner join SRO_VT_SHARD.._RefObjCommon as common on itm.RefItemID = common.ID where inv.CharID = @CharID and common.CodeName128 = @olditemCodeName and itm.OptLevel >= @OldItemPlus)
if (@ReplaceID > 0)
begin
Update SRO_VT_SHARD.._Inventory set ItemID = 0 where ItemID = @ReplaceID and CharID = @CharID
select @CharName =CharName16  from SRO_VT_SHARD.._Char where CharID=@CharID
exec SRO_VT_SHARD.._ADD_ITEM_EXTERN @CharName,@NewItemCodeName,1,@NewItemPlus
end
end
----------------------------------------------------------------------------
if (@ItemRefID = '47059')
begin
set @OldItemCodeName= 'ITEM_EU_DAGGER_13_B_RARE'
set @OldItemPlus =15
set @NewItemCodeName =  ('ITEM_EU_DAGGER_13_C_RARE')
set @NewItemPlus = 0
SET @REPLACEID = (select top 1 ItemID from SRO_VT_SHARD.._Inventory as inv inner join SRO_VT_SHARD.._Items as itm on inv.ItemID  = itm.ID64 inner join SRO_VT_SHARD.._RefObjCommon as common on itm.RefItemID = common.ID where inv.CharID = @CharID and common.CodeName128 = @olditemCodeName and itm.OptLevel >= @OldItemPlus)
if (@ReplaceID > 0)
begin
Update SRO_VT_SHARD.._Inventory set ItemID = 0 where ItemID = @ReplaceID and CharID = @CharID
select @CharName =CharName16  from SRO_VT_SHARD.._Char where CharID=@CharID
exec SRO_VT_SHARD.._ADD_ITEM_EXTERN @CharName,@NewItemCodeName,1,@NewItemPlus
end
end
----------------------------------------------------------------------------
if (@ItemRefID = '47060')
begin
set @OldItemCodeName= 'ITEM_EU_DARKSTAFF_13_B_RARE'
set @OldItemPlus =15
set @NewItemCodeName =  ('ITEM_EU_DARKSTAFF_13_C_RARE')
set @NewItemPlus = 0
SET @REPLACEID = (select top 1 ItemID from SRO_VT_SHARD.._Inventory as inv inner join SRO_VT_SHARD.._Items as itm on inv.ItemID  = itm.ID64 inner join SRO_VT_SHARD.._RefObjCommon as common on itm.RefItemID = common.ID where inv.CharID = @CharID and common.CodeName128 = @olditemCodeName and itm.OptLevel >= @OldItemPlus)
if (@ReplaceID > 0)
begin
Update SRO_VT_SHARD.._Inventory set ItemID = 0 where ItemID = @ReplaceID and CharID = @CharID
select @CharName =CharName16  from SRO_VT_SHARD.._Char where CharID=@CharID
exec SRO_VT_SHARD.._ADD_ITEM_EXTERN @CharName,@NewItemCodeName,1,@NewItemPlus
end
end
----------------------------------------------------------------------------
if (@ItemRefID = '47061')
begin
set @OldItemCodeName= 'ITEM_EU_HARP_13_B_RARE'
set @OldItemPlus =15
set @NewItemCodeName =  ('ITEM_EU_HARP_13_C_RARE')
set @NewItemPlus = 0
SET @REPLACEID = (select top 1 ItemID from SRO_VT_SHARD.._Inventory as inv inner join SRO_VT_SHARD.._Items as itm on inv.ItemID  = itm.ID64 inner join SRO_VT_SHARD.._RefObjCommon as common on itm.RefItemID = common.ID where inv.CharID = @CharID and common.CodeName128 = @olditemCodeName and itm.OptLevel >= @OldItemPlus)
if (@ReplaceID > 0)
begin
Update SRO_VT_SHARD.._Inventory set ItemID = 0 where ItemID = @ReplaceID and CharID = @CharID
select @CharName =CharName16  from SRO_VT_SHARD.._Char where CharID=@CharID
exec SRO_VT_SHARD.._ADD_ITEM_EXTERN @CharName,@NewItemCodeName,1,@NewItemPlus
end
end
----------------------------------------------------------------------------
if (@ItemRefID = '47063')
begin
set @OldItemCodeName= 'ITEM_EU_SWORD_13_B_RARE'
set @OldItemPlus =15
set @NewItemCodeName =  ('ITEM_EU_SWORD_13_C_RARE')
set @NewItemPlus = 0
SET @REPLACEID = (select top 1 ItemID from SRO_VT_SHARD.._Inventory as inv inner join SRO_VT_SHARD.._Items as itm on inv.ItemID  = itm.ID64 inner join SRO_VT_SHARD.._RefObjCommon as common on itm.RefItemID = common.ID where inv.CharID = @CharID and common.CodeName128 = @olditemCodeName and itm.OptLevel >= @OldItemPlus)
if (@ReplaceID > 0)
begin
Update SRO_VT_SHARD.._Inventory set ItemID = 0 where ItemID = @ReplaceID and CharID = @CharID
select @CharName =CharName16  from SRO_VT_SHARD.._Char where CharID=@CharID
exec SRO_VT_SHARD.._ADD_ITEM_EXTERN @CharName,@NewItemCodeName,1,@NewItemPlus
end
end
----------------------------------------------------------------------------
if (@ItemRefID = '47064')
begin
set @OldItemCodeName= 'ITEM_EU_TSTAFF_13_B_RARE'
set @OldItemPlus =15
set @NewItemCodeName =  ('ITEM_EU_TSTAFF_13_C_RARE')
set @NewItemPlus = 0
SET @REPLACEID = (select top 1 ItemID from SRO_VT_SHARD.._Inventory as inv inner join SRO_VT_SHARD.._Items as itm on inv.ItemID  = itm.ID64 inner join SRO_VT_SHARD.._RefObjCommon as common on itm.RefItemID = common.ID where inv.CharID = @CharID and common.CodeName128 = @olditemCodeName and itm.OptLevel >= @OldItemPlus)
if (@ReplaceID > 0)
begin
Update SRO_VT_SHARD.._Inventory set ItemID = 0 where ItemID = @ReplaceID and CharID = @CharID
select @CharName =CharName16  from SRO_VT_SHARD.._Char where CharID=@CharID
exec SRO_VT_SHARD.._ADD_ITEM_EXTERN @CharName,@NewItemCodeName,1,@NewItemPlus
end
end
----------------------------------------------------------------------------
if (@ItemRefID = '47065')
begin
set @OldItemCodeName= 'ITEM_EU_SHIELD_13_B_RARE'
set @OldItemPlus =15
set @NewItemCodeName =  ('ITEM_EU_SHIELD_13_C_RARE')
set @NewItemPlus = 0
SET @REPLACEID = (select top 1 ItemID from SRO_VT_SHARD.._Inventory as inv inner join SRO_VT_SHARD.._Items as itm on inv.ItemID  = itm.ID64 inner join SRO_VT_SHARD.._RefObjCommon as common on itm.RefItemID = common.ID where inv.CharID = @CharID and common.CodeName128 = @olditemCodeName and itm.OptLevel >= @OldItemPlus)
if (@ReplaceID > 0)
begin
Update SRO_VT_SHARD.._Inventory set ItemID = 0 where ItemID = @ReplaceID and CharID = @CharID
select @CharName =CharName16  from SRO_VT_SHARD.._Char where CharID=@CharID
exec SRO_VT_SHARD.._ADD_ITEM_EXTERN @CharName,@NewItemCodeName,1,@NewItemPlus
end
end
----------------------------------------------------------------------------
if (@ItemRefID = '47070')
begin
set @OldItemCodeName= 'ITEM_EU_STAFF_13_B_RARE'
set @OldItemPlus =15
set @NewItemCodeName =  ('ITEM_EU_STAFF_13_C_RARE')
set @NewItemPlus = 0
SET @REPLACEID = (select top 1 ItemID from SRO_VT_SHARD.._Inventory as inv inner join SRO_VT_SHARD.._Items as itm on inv.ItemID  = itm.ID64 inner join SRO_VT_SHARD.._RefObjCommon as common on itm.RefItemID = common.ID where inv.CharID = @CharID and common.CodeName128 = @olditemCodeName and itm.OptLevel >= @OldItemPlus)
if (@ReplaceID > 0)
begin
Update SRO_VT_SHARD.._Inventory set ItemID = 0 where ItemID = @ReplaceID and CharID = @CharID
select @CharName =CharName16  from SRO_VT_SHARD.._Char where CharID=@CharID
exec SRO_VT_SHARD.._ADD_ITEM_EXTERN @CharName,@NewItemCodeName,1,@NewItemPlus
end
end
------------------------------------------------------------------------------
if (@ItemRefID = '47071')
begin
set @OldItemCodeName= 'ITEM_EU_TSWORD_13_B_RARE'
set @OldItemPlus =15
set @NewItemCodeName =  ('ITEM_EU_TSWORD_13_C_RARE')
set @NewItemPlus = 0
SET @REPLACEID = (select top 1 ItemID from SRO_VT_SHARD.._Inventory as inv inner join SRO_VT_SHARD.._Items as itm on inv.ItemID  = itm.ID64 inner join SRO_VT_SHARD.._RefObjCommon as common on itm.RefItemID = common.ID where inv.CharID = @CharID and common.CodeName128 = @olditemCodeName and itm.OptLevel >= @OldItemPlus)
if (@ReplaceID > 0)
begin
Update SRO_VT_SHARD.._Inventory set ItemID = 0 where ItemID = @ReplaceID and CharID = @CharID
select @CharName =CharName16  from SRO_VT_SHARD.._Char where CharID=@CharID
exec SRO_VT_SHARD.._ADD_ITEM_EXTERN @CharName,@NewItemCodeName,1,@NewItemPlus
end
end
----------------------------------------------------------------------------- Finished upgrading
Cevapla
Cvp: RE: weapon upgrade hakkında!!
#4
Son Düzenleme: 15.05.2016, Saat: 11:32, Düzenleyen: Nyrox.
(15.05.2016, Saat: 10:44)musty10 Adlı Kullanıcıdan Alıntı:
(15.05.2016, Saat: 07:42)Nyrox Adlı Kullanıcıdan Alıntı: if(@Operation = 41 and @ItemRefID = 150002)
prosedürün scrollu bulması genel olarak böyle olur, scrollu görmüyo diyosan scrollun rebobjcommon tablosundaki id'sini "150002" yazan yere yazmalısın. denerken eşyayı envanterin 1. satırına koy olmadı eline takıp öyle dene.

bılıyorum onu ınceledım fakat prosedurde bırden fazla refıtem ıd mevcut onu anlıyamadım kodlar sıkıntılı gbı sankı..yardımcı olursan sevınırım.

verdiğin kod hatalı hemde bir eşyayı upgrade yapmak için yazılmış, elimden geldiğince güncelledim.
birden fazla refitemid olması başka silahlarıda değiştirmek istemiş kodları yazan kişi, ayrı ayrı olarak refitemid vermelisin bunların scrolluda ayrı olması lazım biri sword u değiştircek biri bow u. avrupanın silahları 13dg olarak gözüküyor onlarıda düzenlemelisin.
Kod:
DECLARE @OldItemCodeName varchar(128)
DECLARE @OldItemPlus int
DECLARE @NewItemCodeName varchar(128)
DECLARE @NewItemPlus int
DECLARE @ReplaceID int
DECLARE @CharName varchar(128)
--------------------------------------------------------------- UPGRADE
if (@ItemRefID = '47051')
begin
-------
set @OldItemCodeName= 'ITEM_CH_BLADE_08_B_RARE' --Şuanki silahın kod adı
set @OldItemPlus =9 --Şuanki silahın +(plus) durumu
set @NewItemCodeName = 'ITEM_CH_BLADE_08_C_RARE' --Değiştireceğin silah
set @NewItemPlus = 0
SET @REPLACEID = (select top 1 ItemID from SRO_VT_SHARD.._Inventory as inv inner join SRO_VT_SHARD.._Items as itm on inv.ItemID  = itm.ID64 inner join SRO_VT_SHARD.._RefObjCommon as common on itm.RefItemID = common.ID where inv.CharID = @CharID and common.CodeName128 = @oldItemCodeName and itm.OptLevel >= @OldItemPlus)
if (@ReplaceID > 0)
begin
Update SRO_VT_SHARD.._Inventory set ItemID = 0 where ItemID = @ReplaceID and CharID = @CharID
select @CharName =CharName16  from SRO_VT_SHARD.._Char where CharID=@CharID
exec SRO_VT_SHARD.._ADD_ITEM_EXTERN @CharName,@NewItemCodeName,1,@NewItemPlus
end
end
----------------------------------------------------------------- UPGRADE
if (@ItemRefID = '47052')
begin

set @OldItemCodeName= 'ITEM_CH_BOW_08_B_RARE'
set @OldItemPlus =9
set @NewItemCodeName =  ('ITEM_CH_BOW_08_C_RARE')
set @NewItemPlus = 0
SET @REPLACEID = (select top 1 ItemID from SRO_VT_SHARD.._Inventory as inv inner join SRO_VT_SHARD.._Items as itm on inv.ItemID  = itm.ID64 inner join SRO_VT_SHARD.._RefObjCommon as common on itm.RefItemID = common.ID where inv.CharID = @CharID and common.CodeName128 = @oldItemCodeName and itm.OptLevel >= @OldItemPlus)
if (@ReplaceID > 0)
begin
Update SRO_VT_SHARD.._Inventory set ItemID = 0 where ItemID = @ReplaceID and CharID = @CharID
select @CharName =CharName16  from SRO_VT_SHARD.._Char where CharID=@CharID
exec SRO_VT_SHARD.._ADD_ITEM_EXTERN @CharName,@NewItemCodeName,1,@NewItemPlus
end
end
----------------------------------------------------------------------- UPGRADE
if (@ItemRefID = '47053')
begin

set @OldItemCodeName= 'ITEM_CH_SPEAR_08_B_RARE'
set @OldItemPlus =9
set @NewItemCodeName =  ('ITEM_CH_SPEAR_08_C_RARE')
set @NewItemPlus = 0
SET @REPLACEID = (select top 1 ItemID from SRO_VT_SHARD.._Inventory as inv inner join SRO_VT_SHARD.._Items as itm on inv.ItemID  = itm.ID64 inner join SRO_VT_SHARD.._RefObjCommon as common on itm.RefItemID = common.ID where inv.CharID = @CharID and common.CodeName128 = @oldItemCodeName and itm.OptLevel >= @OldItemPlus)
if (@ReplaceID > 0)
begin
Update SRO_VT_SHARD.._Inventory set ItemID = 0 where ItemID = @ReplaceID and CharID = @CharID
select @CharName =CharName16  from SRO_VT_SHARD.._Char where CharID=@CharID
exec SRO_VT_SHARD.._ADD_ITEM_EXTERN @CharName,@NewItemCodeName,1,@NewItemPlus
end
end
------------------------------------------------------------------------ UPGRADE
if (@ItemRefID = '47054')
begin

set @OldItemCodeName= 'ITEM_CH_SWORD_08_B_RARE'
set @OldItemPlus =9
set @NewItemCodeName =  ('ITEM_CH_SWORD_08_C_RARE')
set @NewItemPlus = 0
SET @REPLACEID = (select top 1 ItemID from SRO_VT_SHARD.._Inventory as inv inner join SRO_VT_SHARD.._Items as itm on inv.ItemID  = itm.ID64 inner join SRO_VT_SHARD.._RefObjCommon as common on itm.RefItemID = common.ID where inv.CharID = @CharID and common.CodeName128 = @oldItemCodeName and itm.OptLevel >= @OldItemPlus)
if (@ReplaceID > 0)
begin
Update SRO_VT_SHARD.._Inventory set ItemID = 0 where ItemID = @ReplaceID and CharID = @CharID
select @CharName =CharName16  from SRO_VT_SHARD.._Char where CharID=@CharID
exec SRO_VT_SHARD.._ADD_ITEM_EXTERN @CharName,@NewItemCodeName,1,@NewItemPlus
end
end
------------------------------------------------------------------------ UPGRADE
if (@ItemRefID = '47055')
begin

set @OldItemCodeName= 'ITEM_CH_TBLADE_08_B_RARE'
set @OldItemPlus =9
set @NewItemCodeName =  ('ITEM_CH_TBLADE_08_C_RARE')
set @NewItemPlus = 0
SET @REPLACEID = (select top 1 ItemID from SRO_VT_SHARD.._Inventory as inv inner join SRO_VT_SHARD.._Items as itm on inv.ItemID  = itm.ID64 inner join SRO_VT_SHARD.._RefObjCommon as common on itm.RefItemID = common.ID where inv.CharID = @CharID and common.CodeName128 = @oldItemCodeName and itm.OptLevel >= @OldItemPlus)
if (@ReplaceID > 0)
begin
Update SRO_VT_SHARD.._Inventory set ItemID = 0 where ItemID = @ReplaceID and CharID = @CharID
select @CharName =CharName16  from SRO_VT_SHARD.._Char where CharID=@CharID
exec SRO_VT_SHARD.._ADD_ITEM_EXTERN @CharName,@NewItemCodeName,1,@NewItemPlus
end
end
---------------------------------------------------------------------------
if (@ItemRefID = '47056')
begin
set @OldItemCodeName= 'ITEM_CH_SHIELD_08_B_RARE'
set @OldItemPlus =9
set @NewItemCodeName =  ('ITEM_CH_SHIELD_08_C_RARE')
set @NewItemPlus = 0
SET @REPLACEID = (select top 1 ItemID from SRO_VT_SHARD.._Inventory as inv inner join SRO_VT_SHARD.._Items as itm on inv.ItemID  = itm.ID64 inner join SRO_VT_SHARD.._RefObjCommon as common on itm.RefItemID = common.ID where inv.CharID = @CharID and common.CodeName128 = @oldItemCodeName and itm.OptLevel >= @OldItemPlus)
if (@ReplaceID > 0)
begin
Update SRO_VT_SHARD.._Inventory set ItemID = 0 where ItemID = @ReplaceID and CharID = @CharID
select @CharName =CharName16  from SRO_VT_SHARD.._Char where CharID=@CharID
exec SRO_VT_SHARD.._ADD_ITEM_EXTERN @CharName,@NewItemCodeName,1,@NewItemPlus
end
end
----------------------------------------------------------------------------
if (@ItemRefID = '47057')
begin
set @OldItemCodeName= 'ITEM_EU_AXE_13_B_RARE'
set @OldItemPlus =15
set @NewItemCodeName =  ('ITEM_EU_AXE_13_C_RARE')
set @NewItemPlus = 0
SET @REPLACEID = (select top 1 ItemID from SRO_VT_SHARD.._Inventory as inv inner join SRO_VT_SHARD.._Items as itm on inv.ItemID  = itm.ID64 inner join SRO_VT_SHARD.._RefObjCommon as common on itm.RefItemID = common.ID where inv.CharID = @CharID and common.CodeName128 = @oldItemCodeName and itm.OptLevel >= @OldItemPlus)
if (@ReplaceID > 0)
begin
Update SRO_VT_SHARD.._Inventory set ItemID = 0 where ItemID = @ReplaceID and CharID = @CharID
select @CharName =CharName16  from SRO_VT_SHARD.._Char where CharID=@CharID
exec SRO_VT_SHARD.._ADD_ITEM_EXTERN @CharName,@NewItemCodeName,1,@NewItemPlus
end
end
---------------------------------------------------------------------------
if (@ItemRefID = '47058')
begin
set @OldItemCodeName= 'ITEM_EU_CROSSBOW_13_B_RARE'
set @OldItemPlus =15
set @NewItemCodeName =  ('ITEM_EU_CROSSBOW_13_C_RARE')
set @NewItemPlus = 0
SET @REPLACEID = (select top 1 ItemID from SRO_VT_SHARD.._Inventory as inv inner join SRO_VT_SHARD.._Items as itm on inv.ItemID  = itm.ID64 inner join SRO_VT_SHARD.._RefObjCommon as common on itm.RefItemID = common.ID where inv.CharID = @CharID and common.CodeName128 = @oldItemCodeName and itm.OptLevel >= @OldItemPlus)
if (@ReplaceID > 0)
begin
Update SRO_VT_SHARD.._Inventory set ItemID = 0 where ItemID = @ReplaceID and CharID = @CharID
select @CharName =CharName16  from SRO_VT_SHARD.._Char where CharID=@CharID
exec SRO_VT_SHARD.._ADD_ITEM_EXTERN @CharName,@NewItemCodeName,1,@NewItemPlus
end
end
----------------------------------------------------------------------------
if (@ItemRefID = '47059')
begin
set @OldItemCodeName= 'ITEM_EU_DAGGER_13_B_RARE'
set @OldItemPlus =15
set @NewItemCodeName =  ('ITEM_EU_DAGGER_13_C_RARE')
set @NewItemPlus = 0
SET @REPLACEID = (select top 1 ItemID from SRO_VT_SHARD.._Inventory as inv inner join SRO_VT_SHARD.._Items as itm on inv.ItemID  = itm.ID64 inner join SRO_VT_SHARD.._RefObjCommon as common on itm.RefItemID = common.ID where inv.CharID = @CharID and common.CodeName128 = @oldItemCodeName and itm.OptLevel >= @OldItemPlus)
if (@ReplaceID > 0)
begin
Update SRO_VT_SHARD.._Inventory set ItemID = 0 where ItemID = @ReplaceID and CharID = @CharID
select @CharName =CharName16  from SRO_VT_SHARD.._Char where CharID=@CharID
exec SRO_VT_SHARD.._ADD_ITEM_EXTERN @CharName,@NewItemCodeName,1,@NewItemPlus
end
end
----------------------------------------------------------------------------
if (@ItemRefID = '47060')
begin
set @OldItemCodeName= 'ITEM_EU_DARKSTAFF_13_B_RARE'
set @OldItemPlus =15
set @NewItemCodeName =  ('ITEM_EU_DARKSTAFF_13_C_RARE')
set @NewItemPlus = 0
SET @REPLACEID = (select top 1 ItemID from SRO_VT_SHARD.._Inventory as inv inner join SRO_VT_SHARD.._Items as itm on inv.ItemID  = itm.ID64 inner join SRO_VT_SHARD.._RefObjCommon as common on itm.RefItemID = common.ID where inv.CharID = @CharID and common.CodeName128 = @oldItemCodeName and itm.OptLevel >= @OldItemPlus)
if (@ReplaceID > 0)
begin
Update SRO_VT_SHARD.._Inventory set ItemID = 0 where ItemID = @ReplaceID and CharID = @CharID
select @CharName =CharName16  from SRO_VT_SHARD.._Char where CharID=@CharID
exec SRO_VT_SHARD.._ADD_ITEM_EXTERN @CharName,@NewItemCodeName,1,@NewItemPlus
end
end
----------------------------------------------------------------------------
if (@ItemRefID = '47061')
begin
set @OldItemCodeName= 'ITEM_EU_HARP_13_B_RARE'
set @OldItemPlus =15
set @NewItemCodeName =  ('ITEM_EU_HARP_13_C_RARE')
set @NewItemPlus = 0
SET @REPLACEID = (select top 1 ItemID from SRO_VT_SHARD.._Inventory as inv inner join SRO_VT_SHARD.._Items as itm on inv.ItemID  = itm.ID64 inner join SRO_VT_SHARD.._RefObjCommon as common on itm.RefItemID = common.ID where inv.CharID = @CharID and common.CodeName128 = @oldItemCodeName and itm.OptLevel >= @OldItemPlus)
if (@ReplaceID > 0)
begin
Update SRO_VT_SHARD.._Inventory set ItemID = 0 where ItemID = @ReplaceID and CharID = @CharID
select @CharName =CharName16  from SRO_VT_SHARD.._Char where CharID=@CharID
exec SRO_VT_SHARD.._ADD_ITEM_EXTERN @CharName,@NewItemCodeName,1,@NewItemPlus
end
end
----------------------------------------------------------------------------
if (@ItemRefID = '47063')
begin
set @OldItemCodeName= 'ITEM_EU_SWORD_13_B_RARE'
set @OldItemPlus =15
set @NewItemCodeName =  ('ITEM_EU_SWORD_13_C_RARE')
set @NewItemPlus = 0
SET @REPLACEID = (select top 1 ItemID from SRO_VT_SHARD.._Inventory as inv inner join SRO_VT_SHARD.._Items as itm on inv.ItemID  = itm.ID64 inner join SRO_VT_SHARD.._RefObjCommon as common on itm.RefItemID = common.ID where inv.CharID = @CharID and common.CodeName128 = @oldItemCodeName and itm.OptLevel >= @OldItemPlus)
if (@ReplaceID > 0)
begin
Update SRO_VT_SHARD.._Inventory set ItemID = 0 where ItemID = @ReplaceID and CharID = @CharID
select @CharName =CharName16  from SRO_VT_SHARD.._Char where CharID=@CharID
exec SRO_VT_SHARD.._ADD_ITEM_EXTERN @CharName,@NewItemCodeName,1,@NewItemPlus
end
end
----------------------------------------------------------------------------
if (@ItemRefID = '47064')
begin
set @OldItemCodeName= 'ITEM_EU_TSTAFF_13_B_RARE'
set @OldItemPlus =15
set @NewItemCodeName =  ('ITEM_EU_TSTAFF_13_C_RARE')
set @NewItemPlus = 0
SET @REPLACEID = (select top 1 ItemID from SRO_VT_SHARD.._Inventory as inv inner join SRO_VT_SHARD.._Items as itm on inv.ItemID  = itm.ID64 inner join SRO_VT_SHARD.._RefObjCommon as common on itm.RefItemID = common.ID where inv.CharID = @CharID and common.CodeName128 = @oldItemCodeName and itm.OptLevel >= @OldItemPlus)
if (@ReplaceID > 0)
begin
Update SRO_VT_SHARD.._Inventory set ItemID = 0 where ItemID = @ReplaceID and CharID = @CharID
select @CharName =CharName16  from SRO_VT_SHARD.._Char where CharID=@CharID
exec SRO_VT_SHARD.._ADD_ITEM_EXTERN @CharName,@NewItemCodeName,1,@NewItemPlus
end
end
----------------------------------------------------------------------------
if (@ItemRefID = '47065')
begin
set @OldItemCodeName= 'ITEM_EU_SHIELD_13_B_RARE'
set @OldItemPlus =15
set @NewItemCodeName =  ('ITEM_EU_SHIELD_13_C_RARE')
set @NewItemPlus = 0
SET @REPLACEID = (select top 1 ItemID from SRO_VT_SHARD.._Inventory as inv inner join SRO_VT_SHARD.._Items as itm on inv.ItemID  = itm.ID64 inner join SRO_VT_SHARD.._RefObjCommon as common on itm.RefItemID = common.ID where inv.CharID = @CharID and common.CodeName128 = @oldItemCodeName and itm.OptLevel >= @OldItemPlus)
if (@ReplaceID > 0)
begin
Update SRO_VT_SHARD.._Inventory set ItemID = 0 where ItemID = @ReplaceID and CharID = @CharID
select @CharName =CharName16  from SRO_VT_SHARD.._Char where CharID=@CharID
exec SRO_VT_SHARD.._ADD_ITEM_EXTERN @CharName,@NewItemCodeName,1,@NewItemPlus
end
end
----------------------------------------------------------------------------
if (@ItemRefID = '47070')
begin
set @OldItemCodeName= 'ITEM_EU_STAFF_13_B_RARE'
set @OldItemPlus =15
set @NewItemCodeName =  ('ITEM_EU_STAFF_13_C_RARE')
set @NewItemPlus = 0
SET @REPLACEID = (select top 1 ItemID from SRO_VT_SHARD.._Inventory as inv inner join SRO_VT_SHARD.._Items as itm on inv.ItemID  = itm.ID64 inner join SRO_VT_SHARD.._RefObjCommon as common on itm.RefItemID = common.ID where inv.CharID = @CharID and common.CodeName128 = @oldItemCodeName and itm.OptLevel >= @OldItemPlus)
if (@ReplaceID > 0)
begin
Update SRO_VT_SHARD.._Inventory set ItemID = 0 where ItemID = @ReplaceID and CharID = @CharID
select @CharName =CharName16  from SRO_VT_SHARD.._Char where CharID=@CharID
exec SRO_VT_SHARD.._ADD_ITEM_EXTERN @CharName,@NewItemCodeName,1,@NewItemPlus
end
end
------------------------------------------------------------------------------
if (@ItemRefID = '47071')
begin
set @OldItemCodeName= 'ITEM_EU_TSWORD_13_B_RARE'
set @OldItemPlus =15
set @NewItemCodeName =  ('ITEM_EU_TSWORD_13_C_RARE')
set @NewItemPlus = 0
SET @REPLACEID = (select top 1 ItemID from SRO_VT_SHARD.._Inventory as inv inner join SRO_VT_SHARD.._Items as itm on inv.ItemID  = itm.ID64 inner join SRO_VT_SHARD.._RefObjCommon as common on itm.RefItemID = common.ID where inv.CharID = @CharID and common.CodeName128 = @oldItemCodeName and itm.OptLevel >= @OldItemPlus)
if (@ReplaceID > 0)
begin
Update SRO_VT_SHARD.._Inventory set ItemID = 0 where ItemID = @ReplaceID and CharID = @CharID
select @CharName =CharName16  from SRO_VT_SHARD.._Char where CharID=@CharID
exec SRO_VT_SHARD.._ADD_ITEM_EXTERN @CharName,@NewItemCodeName,1,@NewItemPlus
end
end
----------------------------------------------------------------------------- Finished upgrading
Cevapla
Cvp: RE: weapon upgrade hakkında!!
#5
(15.05.2016, Saat: 11:31)Nyrox Adlı Kullanıcıdan Alıntı:
(15.05.2016, Saat: 10:44)musty10 Adlı Kullanıcıdan Alıntı:
(15.05.2016, Saat: 07:42)Nyrox Adlı Kullanıcıdan Alıntı: if(@Operation = 41 and @ItemRefID = 150002)
prosedürün scrollu bulması genel olarak böyle olur, scrollu görmüyo diyosan scrollun rebobjcommon tablosundaki id'sini "150002" yazan yere yazmalısın. denerken eşyayı envanterin 1. satırına koy olmadı eline takıp öyle dene.

bılıyorum onu ınceledım fakat prosedurde bırden fazla refıtem ıd mevcut onu anlıyamadım kodlar sıkıntılı gbı sankı..yardımcı olursan sevınırım.

verdiğin kod hatalı hemde bir eşyayı upgrade yapmak için yazılmış, elimden geldiğince güncelledim.
birden fazla refitemid olması başka silahlarıda değiştirmek istemiş kodları yazan kişi, ayrı ayrı olarak refitemid vermelisin bunların scrolluda ayrı olması lazım biri sword u değiştircek biri bow u. avrupanın silahları 13dg olarak gözüküyor onlarıda düzenlemelisin.
Kod:
DECLARE @OldItemCodeName varchar(128)
DECLARE @OldItemPlus int
DECLARE @NewItemCodeName varchar(128)
DECLARE @NewItemPlus int
DECLARE @ReplaceID int
DECLARE @CharName varchar(128)
--------------------------------------------------------------- UPGRADE
if (@ItemRefID = '47051')
begin
-------
set @OldItemCodeName= 'ITEM_CH_BLADE_08_B_RARE' --Şuanki silahın kod adı
set @OldItemPlus =9 --Şuanki silahın +(plus) durumu
set @NewItemCodeName = 'ITEM_CH_BLADE_08_C_RARE' --Değiştireceğin silah
set @NewItemPlus = 0
SET @REPLACEID = (select top 1 ItemID from SRO_VT_SHARD.._Inventory as inv inner join SRO_VT_SHARD.._Items as itm on inv.ItemID  = itm.ID64 inner join SRO_VT_SHARD.._RefObjCommon as common on itm.RefItemID = common.ID where inv.CharID = @CharID and common.CodeName128 = @oldItemCodeName and itm.OptLevel >= @OldItemPlus)
if (@ReplaceID > 0)
begin
Update SRO_VT_SHARD.._Inventory set ItemID = 0 where ItemID = @ReplaceID and CharID = @CharID
select @CharName =CharName16  from SRO_VT_SHARD.._Char where CharID=@CharID
exec SRO_VT_SHARD.._ADD_ITEM_EXTERN @CharName,@NewItemCodeName,1,@NewItemPlus
end
end
----------------------------------------------------------------- UPGRADE
if (@ItemRefID = '47052')
begin

set @OldItemCodeName= 'ITEM_CH_BOW_08_B_RARE'
set @OldItemPlus =9
set @NewItemCodeName =  ('ITEM_CH_BOW_08_C_RARE')
set @NewItemPlus = 0
SET @REPLACEID = (select top 1 ItemID from SRO_VT_SHARD.._Inventory as inv inner join SRO_VT_SHARD.._Items as itm on inv.ItemID  = itm.ID64 inner join SRO_VT_SHARD.._RefObjCommon as common on itm.RefItemID = common.ID where inv.CharID = @CharID and common.CodeName128 = @oldItemCodeName and itm.OptLevel >= @OldItemPlus)
if (@ReplaceID > 0)
begin
Update SRO_VT_SHARD.._Inventory set ItemID = 0 where ItemID = @ReplaceID and CharID = @CharID
select @CharName =CharName16  from SRO_VT_SHARD.._Char where CharID=@CharID
exec SRO_VT_SHARD.._ADD_ITEM_EXTERN @CharName,@NewItemCodeName,1,@NewItemPlus
end
end
----------------------------------------------------------------------- UPGRADE
if (@ItemRefID = '47053')
begin

set @OldItemCodeName= 'ITEM_CH_SPEAR_08_B_RARE'
set @OldItemPlus =9
set @NewItemCodeName =  ('ITEM_CH_SPEAR_08_C_RARE')
set @NewItemPlus = 0
SET @REPLACEID = (select top 1 ItemID from SRO_VT_SHARD.._Inventory as inv inner join SRO_VT_SHARD.._Items as itm on inv.ItemID  = itm.ID64 inner join SRO_VT_SHARD.._RefObjCommon as common on itm.RefItemID = common.ID where inv.CharID = @CharID and common.CodeName128 = @oldItemCodeName and itm.OptLevel >= @OldItemPlus)
if (@ReplaceID > 0)
begin
Update SRO_VT_SHARD.._Inventory set ItemID = 0 where ItemID = @ReplaceID and CharID = @CharID
select @CharName =CharName16  from SRO_VT_SHARD.._Char where CharID=@CharID
exec SRO_VT_SHARD.._ADD_ITEM_EXTERN @CharName,@NewItemCodeName,1,@NewItemPlus
end
end
------------------------------------------------------------------------ UPGRADE
if (@ItemRefID = '47054')
begin

set @OldItemCodeName= 'ITEM_CH_SWORD_08_B_RARE'
set @OldItemPlus =9
set @NewItemCodeName =  ('ITEM_CH_SWORD_08_C_RARE')
set @NewItemPlus = 0
SET @REPLACEID = (select top 1 ItemID from SRO_VT_SHARD.._Inventory as inv inner join SRO_VT_SHARD.._Items as itm on inv.ItemID  = itm.ID64 inner join SRO_VT_SHARD.._RefObjCommon as common on itm.RefItemID = common.ID where inv.CharID = @CharID and common.CodeName128 = @oldItemCodeName and itm.OptLevel >= @OldItemPlus)
if (@ReplaceID > 0)
begin
Update SRO_VT_SHARD.._Inventory set ItemID = 0 where ItemID = @ReplaceID and CharID = @CharID
select @CharName =CharName16  from SRO_VT_SHARD.._Char where CharID=@CharID
exec SRO_VT_SHARD.._ADD_ITEM_EXTERN @CharName,@NewItemCodeName,1,@NewItemPlus
end
end
------------------------------------------------------------------------ UPGRADE
if (@ItemRefID = '47055')
begin

set @OldItemCodeName= 'ITEM_CH_TBLADE_08_B_RARE'
set @OldItemPlus =9
set @NewItemCodeName =  ('ITEM_CH_TBLADE_08_C_RARE')
set @NewItemPlus = 0
SET @REPLACEID = (select top 1 ItemID from SRO_VT_SHARD.._Inventory as inv inner join SRO_VT_SHARD.._Items as itm on inv.ItemID  = itm.ID64 inner join SRO_VT_SHARD.._RefObjCommon as common on itm.RefItemID = common.ID where inv.CharID = @CharID and common.CodeName128 = @oldItemCodeName and itm.OptLevel >= @OldItemPlus)
if (@ReplaceID > 0)
begin
Update SRO_VT_SHARD.._Inventory set ItemID = 0 where ItemID = @ReplaceID and CharID = @CharID
select @CharName =CharName16  from SRO_VT_SHARD.._Char where CharID=@CharID
exec SRO_VT_SHARD.._ADD_ITEM_EXTERN @CharName,@NewItemCodeName,1,@NewItemPlus
end
end
---------------------------------------------------------------------------
if (@ItemRefID = '47056')
begin
set @OldItemCodeName= 'ITEM_CH_SHIELD_08_B_RARE'
set @OldItemPlus =9
set @NewItemCodeName =  ('ITEM_CH_SHIELD_08_C_RARE')
set @NewItemPlus = 0
SET @REPLACEID = (select top 1 ItemID from SRO_VT_SHARD.._Inventory as inv inner join SRO_VT_SHARD.._Items as itm on inv.ItemID  = itm.ID64 inner join SRO_VT_SHARD.._RefObjCommon as common on itm.RefItemID = common.ID where inv.CharID = @CharID and common.CodeName128 = @oldItemCodeName and itm.OptLevel >= @OldItemPlus)
if (@ReplaceID > 0)
begin
Update SRO_VT_SHARD.._Inventory set ItemID = 0 where ItemID = @ReplaceID and CharID = @CharID
select @CharName =CharName16  from SRO_VT_SHARD.._Char where CharID=@CharID
exec SRO_VT_SHARD.._ADD_ITEM_EXTERN @CharName,@NewItemCodeName,1,@NewItemPlus
end
end
----------------------------------------------------------------------------
if (@ItemRefID = '47057')
begin
set @OldItemCodeName= 'ITEM_EU_AXE_13_B_RARE'
set @OldItemPlus =15
set @NewItemCodeName =  ('ITEM_EU_AXE_13_C_RARE')
set @NewItemPlus = 0
SET @REPLACEID = (select top 1 ItemID from SRO_VT_SHARD.._Inventory as inv inner join SRO_VT_SHARD.._Items as itm on inv.ItemID  = itm.ID64 inner join SRO_VT_SHARD.._RefObjCommon as common on itm.RefItemID = common.ID where inv.CharID = @CharID and common.CodeName128 = @oldItemCodeName and itm.OptLevel >= @OldItemPlus)
if (@ReplaceID > 0)
begin
Update SRO_VT_SHARD.._Inventory set ItemID = 0 where ItemID = @ReplaceID and CharID = @CharID
select @CharName =CharName16  from SRO_VT_SHARD.._Char where CharID=@CharID
exec SRO_VT_SHARD.._ADD_ITEM_EXTERN @CharName,@NewItemCodeName,1,@NewItemPlus
end
end
---------------------------------------------------------------------------
if (@ItemRefID = '47058')
begin
set @OldItemCodeName= 'ITEM_EU_CROSSBOW_13_B_RARE'
set @OldItemPlus =15
set @NewItemCodeName =  ('ITEM_EU_CROSSBOW_13_C_RARE')
set @NewItemPlus = 0
SET @REPLACEID = (select top 1 ItemID from SRO_VT_SHARD.._Inventory as inv inner join SRO_VT_SHARD.._Items as itm on inv.ItemID  = itm.ID64 inner join SRO_VT_SHARD.._RefObjCommon as common on itm.RefItemID = common.ID where inv.CharID = @CharID and common.CodeName128 = @oldItemCodeName and itm.OptLevel >= @OldItemPlus)
if (@ReplaceID > 0)
begin
Update SRO_VT_SHARD.._Inventory set ItemID = 0 where ItemID = @ReplaceID and CharID = @CharID
select @CharName =CharName16  from SRO_VT_SHARD.._Char where CharID=@CharID
exec SRO_VT_SHARD.._ADD_ITEM_EXTERN @CharName,@NewItemCodeName,1,@NewItemPlus
end
end
----------------------------------------------------------------------------
if (@ItemRefID = '47059')
begin
set @OldItemCodeName= 'ITEM_EU_DAGGER_13_B_RARE'
set @OldItemPlus =15
set @NewItemCodeName =  ('ITEM_EU_DAGGER_13_C_RARE')
set @NewItemPlus = 0
SET @REPLACEID = (select top 1 ItemID from SRO_VT_SHARD.._Inventory as inv inner join SRO_VT_SHARD.._Items as itm on inv.ItemID  = itm.ID64 inner join SRO_VT_SHARD.._RefObjCommon as common on itm.RefItemID = common.ID where inv.CharID = @CharID and common.CodeName128 = @oldItemCodeName and itm.OptLevel >= @OldItemPlus)
if (@ReplaceID > 0)
begin
Update SRO_VT_SHARD.._Inventory set ItemID = 0 where ItemID = @ReplaceID and CharID = @CharID
select @CharName =CharName16  from SRO_VT_SHARD.._Char where CharID=@CharID
exec SRO_VT_SHARD.._ADD_ITEM_EXTERN @CharName,@NewItemCodeName,1,@NewItemPlus
end
end
----------------------------------------------------------------------------
if (@ItemRefID = '47060')
begin
set @OldItemCodeName= 'ITEM_EU_DARKSTAFF_13_B_RARE'
set @OldItemPlus =15
set @NewItemCodeName =  ('ITEM_EU_DARKSTAFF_13_C_RARE')
set @NewItemPlus = 0
SET @REPLACEID = (select top 1 ItemID from SRO_VT_SHARD.._Inventory as inv inner join SRO_VT_SHARD.._Items as itm on inv.ItemID  = itm.ID64 inner join SRO_VT_SHARD.._RefObjCommon as common on itm.RefItemID = common.ID where inv.CharID = @CharID and common.CodeName128 = @oldItemCodeName and itm.OptLevel >= @OldItemPlus)
if (@ReplaceID > 0)
begin
Update SRO_VT_SHARD.._Inventory set ItemID = 0 where ItemID = @ReplaceID and CharID = @CharID
select @CharName =CharName16  from SRO_VT_SHARD.._Char where CharID=@CharID
exec SRO_VT_SHARD.._ADD_ITEM_EXTERN @CharName,@NewItemCodeName,1,@NewItemPlus
end
end
----------------------------------------------------------------------------
if (@ItemRefID = '47061')
begin
set @OldItemCodeName= 'ITEM_EU_HARP_13_B_RARE'
set @OldItemPlus =15
set @NewItemCodeName =  ('ITEM_EU_HARP_13_C_RARE')
set @NewItemPlus = 0
SET @REPLACEID = (select top 1 ItemID from SRO_VT_SHARD.._Inventory as inv inner join SRO_VT_SHARD.._Items as itm on inv.ItemID  = itm.ID64 inner join SRO_VT_SHARD.._RefObjCommon as common on itm.RefItemID = common.ID where inv.CharID = @CharID and common.CodeName128 = @oldItemCodeName and itm.OptLevel >= @OldItemPlus)
if (@ReplaceID > 0)
begin
Update SRO_VT_SHARD.._Inventory set ItemID = 0 where ItemID = @ReplaceID and CharID = @CharID
select @CharName =CharName16  from SRO_VT_SHARD.._Char where CharID=@CharID
exec SRO_VT_SHARD.._ADD_ITEM_EXTERN @CharName,@NewItemCodeName,1,@NewItemPlus
end
end
----------------------------------------------------------------------------
if (@ItemRefID = '47063')
begin
set @OldItemCodeName= 'ITEM_EU_SWORD_13_B_RARE'
set @OldItemPlus =15
set @NewItemCodeName =  ('ITEM_EU_SWORD_13_C_RARE')
set @NewItemPlus = 0
SET @REPLACEID = (select top 1 ItemID from SRO_VT_SHARD.._Inventory as inv inner join SRO_VT_SHARD.._Items as itm on inv.ItemID  = itm.ID64 inner join SRO_VT_SHARD.._RefObjCommon as common on itm.RefItemID = common.ID where inv.CharID = @CharID and common.CodeName128 = @oldItemCodeName and itm.OptLevel >= @OldItemPlus)
if (@ReplaceID > 0)
begin
Update SRO_VT_SHARD.._Inventory set ItemID = 0 where ItemID = @ReplaceID and CharID = @CharID
select @CharName =CharName16  from SRO_VT_SHARD.._Char where CharID=@CharID
exec SRO_VT_SHARD.._ADD_ITEM_EXTERN @CharName,@NewItemCodeName,1,@NewItemPlus
end
end
----------------------------------------------------------------------------
if (@ItemRefID = '47064')
begin
set @OldItemCodeName= 'ITEM_EU_TSTAFF_13_B_RARE'
set @OldItemPlus =15
set @NewItemCodeName =  ('ITEM_EU_TSTAFF_13_C_RARE')
set @NewItemPlus = 0
SET @REPLACEID = (select top 1 ItemID from SRO_VT_SHARD.._Inventory as inv inner join SRO_VT_SHARD.._Items as itm on inv.ItemID  = itm.ID64 inner join SRO_VT_SHARD.._RefObjCommon as common on itm.RefItemID = common.ID where inv.CharID = @CharID and common.CodeName128 = @oldItemCodeName and itm.OptLevel >= @OldItemPlus)
if (@ReplaceID > 0)
begin
Update SRO_VT_SHARD.._Inventory set ItemID = 0 where ItemID = @ReplaceID and CharID = @CharID
select @CharName =CharName16  from SRO_VT_SHARD.._Char where CharID=@CharID
exec SRO_VT_SHARD.._ADD_ITEM_EXTERN @CharName,@NewItemCodeName,1,@NewItemPlus
end
end
----------------------------------------------------------------------------
if (@ItemRefID = '47065')
begin
set @OldItemCodeName= 'ITEM_EU_SHIELD_13_B_RARE'
set @OldItemPlus =15
set @NewItemCodeName =  ('ITEM_EU_SHIELD_13_C_RARE')
set @NewItemPlus = 0
SET @REPLACEID = (select top 1 ItemID from SRO_VT_SHARD.._Inventory as inv inner join SRO_VT_SHARD.._Items as itm on inv.ItemID  = itm.ID64 inner join SRO_VT_SHARD.._RefObjCommon as common on itm.RefItemID = common.ID where inv.CharID = @CharID and common.CodeName128 = @oldItemCodeName and itm.OptLevel >= @OldItemPlus)
if (@ReplaceID > 0)
begin
Update SRO_VT_SHARD.._Inventory set ItemID = 0 where ItemID = @ReplaceID and CharID = @CharID
select @CharName =CharName16  from SRO_VT_SHARD.._Char where CharID=@CharID
exec SRO_VT_SHARD.._ADD_ITEM_EXTERN @CharName,@NewItemCodeName,1,@NewItemPlus
end
end
----------------------------------------------------------------------------
if (@ItemRefID = '47070')
begin
set @OldItemCodeName= 'ITEM_EU_STAFF_13_B_RARE'
set @OldItemPlus =15
set @NewItemCodeName =  ('ITEM_EU_STAFF_13_C_RARE')
set @NewItemPlus = 0
SET @REPLACEID = (select top 1 ItemID from SRO_VT_SHARD.._Inventory as inv inner join SRO_VT_SHARD.._Items as itm on inv.ItemID  = itm.ID64 inner join SRO_VT_SHARD.._RefObjCommon as common on itm.RefItemID = common.ID where inv.CharID = @CharID and common.CodeName128 = @oldItemCodeName and itm.OptLevel >= @OldItemPlus)
if (@ReplaceID > 0)
begin
Update SRO_VT_SHARD.._Inventory set ItemID = 0 where ItemID = @ReplaceID and CharID = @CharID
select @CharName =CharName16  from SRO_VT_SHARD.._Char where CharID=@CharID
exec SRO_VT_SHARD.._ADD_ITEM_EXTERN @CharName,@NewItemCodeName,1,@NewItemPlus
end
end
------------------------------------------------------------------------------
if (@ItemRefID = '47071')
begin
set @OldItemCodeName= 'ITEM_EU_TSWORD_13_B_RARE'
set @OldItemPlus =15
set @NewItemCodeName =  ('ITEM_EU_TSWORD_13_C_RARE')
set @NewItemPlus = 0
SET @REPLACEID = (select top 1 ItemID from SRO_VT_SHARD.._Inventory as inv inner join SRO_VT_SHARD.._Items as itm on inv.ItemID  = itm.ID64 inner join SRO_VT_SHARD.._RefObjCommon as common on itm.RefItemID = common.ID where inv.CharID = @CharID and common.CodeName128 = @oldItemCodeName and itm.OptLevel >= @OldItemPlus)
if (@ReplaceID > 0)
begin
Update SRO_VT_SHARD.._Inventory set ItemID = 0 where ItemID = @ReplaceID and CharID = @CharID
select @CharName =CharName16  from SRO_VT_SHARD.._Char where CharID=@CharID
exec SRO_VT_SHARD.._ADD_ITEM_EXTERN @CharName,@NewItemCodeName,1,@NewItemPlus
end
end
----------------------------------------------------------------------------- Finished upgrading

pekı tek bı scrool ıle hepsını cevırme ıhtımalımız yokmu ben bı serverda gormustum ztn bana sadece 8 dg chn weaponlar lazım
Cevapla
Cvp: RE: weapon upgrade hakkında!!
#6
(15.05.2016, Saat: 11:34)musty10 Adlı Kullanıcıdan Alıntı:
(15.05.2016, Saat: 11:31)Nyrox Adlı Kullanıcıdan Alıntı:
(15.05.2016, Saat: 10:44)musty10 Adlı Kullanıcıdan Alıntı:
(15.05.2016, Saat: 07:42)Nyrox Adlı Kullanıcıdan Alıntı: if(@Operation = 41 and @ItemRefID = 150002)
prosedürün scrollu bulması genel olarak böyle olur, scrollu görmüyo diyosan scrollun rebobjcommon tablosundaki id'sini "150002" yazan yere yazmalısın. denerken eşyayı envanterin 1. satırına koy olmadı eline takıp öyle dene.

bılıyorum onu ınceledım fakat prosedurde bırden fazla refıtem ıd mevcut onu anlıyamadım kodlar sıkıntılı gbı sankı..yardımcı olursan sevınırım.

verdiğin kod hatalı hemde bir eşyayı upgrade yapmak için yazılmış, elimden geldiğince güncelledim.
birden fazla refitemid olması başka silahlarıda değiştirmek istemiş kodları yazan kişi, ayrı ayrı olarak refitemid vermelisin bunların scrolluda ayrı olması lazım biri sword u değiştircek biri bow u. avrupanın silahları 13dg olarak gözüküyor onlarıda düzenlemelisin.

pekı tek bı scrool ıle hepsını cevırme ıhtımalımız yokmu ben bı serverda gormustum ztn bana sadece 8 dg chn weaponlar lazım
SRO_VT_LOG > Programmability > Stored Procedures > dbo._AddLogItem aşadaki verdiğim kodu ekle

Kod:
IF (@Operation = 41) -- If item used!
   Begin
     IF (@ItemRefID = 42161) -- Scrollun RefObjCommon tablosundaki ID'si
      Begin
       Execute [SRO_VT_LOG].[dbo].[_UpgradeSystem] @CharID
      End
   End

Şimdi prosedürü oluşturalım
Kod:
USE [SRO_VT_LOG]
GO
/****** Object:  StoredProcedure [dbo].[_UpgradeSystem]    Script Date: 02/20/2015 08:35:45 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

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

-- Declare expression.
  Declare @CreaterName Varchar(60) = 'iLegend' , -- Creater Name
  @WeaponSlot Int = 6 , -- char inventory weapon slot
  @ShieldSlot Int = 7 , -- char inventory shield slot
  @ReqOptLevel Int = 7    , -- Eski itemin artı durumu.
  @NewOptLevel Int = 0    , -- Yeni gelicek eşyanın artu durumu
  -- Aşağıdaki yerlere eski silahların id'sini ve yeni silahların id'sini ayarla
  -- Use This Query to get each item ID by Codename128
  -- Select ID From [SRO_VT_SHARD].[dbo].[_RefObjCommon] Where CodeName128 Like 'Item Code Name'
 
  ---> Eski silahlar ID's                  ---> Yeni silahlar ID's
  @Old_CH_SWORD_ID Int  = 25611    , @New_CH_SWORD_ID Int  = 25669  ,    --@New Chinese Sword
  @Old_CH_BLADE_ID Int  = 25612    , @New_CH_BLADE_ID Int  = 25670  ,    --@Chinese Blade
  @Old_CH_SPEAR_ID Int  = 25613    , @New_CH_SPEAR_ID Int  = 25671  ,    --@Chinese Spear
  @Old_CH_TBLADE_ID Int = 25614    , @New_CH_TBLADE_ID Int = 25672  ,    --@Chinese Glaive
  @Old_CH_BOW_ID Int    = 25615    , @New_CH_BOW_ID Int    = 25673  ,    --@Chinese Bow
  @Old_CH_SHIELD_ID Int = 25616    , @New_CH_SHIELD_ID Int = 25674  ,    --@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 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 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 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 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 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 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)    --@Shield

*prosedürün çalışabilmesi için silahı ve kalkanı elinde bulunması gerek.
Cevapla
RE: weapon upgrade hakkında!!
#7
Son Düzenleme: 15.05.2016, Saat: 12:23, Düzenleyen: musty10.
dedigin gibi yaptim butun prosedurleri degistirdim altta verdigin prosedurun silah idlerinide degistirdim kaydettim fakat yine ayni silah elinde olsada invantoryde olsada degisim gerceklesmiyor
Cevapla
Cvp: RE: weapon upgrade hakkında!!
#8
(15.05.2016, Saat: 12:23)musty10 Adlı Kullanıcıdan Alıntı: dedigin gibi yaptim butun prosedurleri degistirdim altta verdigin prosedurun silah idlerinide degistirdim kaydettim fakat yine ayni silah elinde olsada invantoryde olsada degisim gerceklesmiyor
eşyanın artı durumuna baktınmı 7 veya 8 olarak denermisin.
Cevapla
Cvp: RE: weapon upgrade hakkında!!
#9
(15.05.2016, Saat: 13:18)Nyrox Adlı Kullanıcıdan Alıntı:
(15.05.2016, Saat: 12:23)musty10 Adlı Kullanıcıdan Alıntı: dedigin gibi yaptim butun prosedurleri degistirdim altta verdigin prosedurun silah idlerinide degistirdim kaydettim fakat yine ayni silah elinde olsada invantoryde olsada degisim gerceklesmiyor
eşyanın artı durumuna baktınmı 7 veya 8 olarak denermisin.

hepsını degıstırdım kardesımsonuc aynı bı yerde hata var ama bulamadım
Cevapla
Cvp: RE: weapon upgrade hakkında!!
#10
(15.05.2016, Saat: 13:19)musty10 Adlı Kullanıcıdan Alıntı:
(15.05.2016, Saat: 13:18)Nyrox Adlı Kullanıcıdan Alıntı:
(15.05.2016, Saat: 12:23)musty10 Adlı Kullanıcıdan Alıntı: dedigin gibi yaptim butun prosedurleri degistirdim altta verdigin prosedurun silah idlerinide degistirdim kaydettim fakat yine ayni silah elinde olsada invantoryde olsada degisim gerceklesmiyor
eşyanın artı durumuna baktınmı 7 veya 8 olarak denermisin.

hepsını degıstırdım kardesımsonuc aynı bı yerde hata var ama bulamadım

Facebook adresimden ulas sana guncel weapon prosudurunu ayarliyalim weapon set fulfb/cihan.onar.1
Cevapla


Konu ile Alakalı Benzer Konular
Konular Yazar Yorumlar Okunma Son Yorum
  SORU Gameserver Ram kullanımı hakkında Dream592 8 87 11.11.2017, Saat: 18:04
Son Yorum: Dream592
  SORU Client Login Port ve srNodeData.ini Hakkında CapScroLL 5 158 08.11.2017, Saat: 14:49
Son Yorum: TRNaX
  jop ceza hakkında cottbus 3 78 03.11.2017, Saat: 05:49
Son Yorum: cottbus
  jop reset scroll hakkında cottbus 1 67 01.11.2017, Saat: 06:23
Son Yorum: BURAKSERIT - Killa

Hızlı Menü:


Konuyu Okuyanlar: 1 Ziyaretçi