Kayıt Ol
[-]
monetization_on Reklam Alanı
Reklam vermek istiyorum?

Soru weapon upgrade hakkında!!


view_headline Konu
14.05.2016, Saat: 21:19
#1
musty10
musty10
Konuları:
4
Yorumları:
11
Kayıt Tarihi:
13.05.2016
verified_user M.Dumanlı
weapon upgrade hakkında!!
Ö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

15.05.2016, Saat: 07:42
#2
Nyrox
Nyrox
Konuları:
92
Yorumları:
249
Kayıt Tarihi:
18.08.2015
Rep Puanı:
21
verified_user Emektar
RE: weapon upgrade hakkında!!
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
15.05.2016, Saat: 10:44
#3
musty10
musty10
Konuları:
4
Yorumları:
11
Kayıt Tarihi:
13.05.2016
verified_user M.Dumanlı
Cvp: RE: weapon upgrade hakkında!!
(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
15.05.2016, Saat: 11:31
#4
Nyrox
Nyrox
Konuları:
92
Yorumları:
249
Kayıt Tarihi:
18.08.2015
Rep Puanı:
21
verified_user Emektar
Cvp: RE: weapon upgrade hakkında!!
(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
15.05.2016, Saat: 11:34
#5
musty10
musty10
Konuları:
4
Yorumları:
11
Kayıt Tarihi:
13.05.2016
verified_user M.Dumanlı
Cvp: RE: weapon upgrade hakkında!!
(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
15.05.2016, Saat: 12:08
#6
Nyrox
Nyrox
Konuları:
92
Yorumları:
249
Kayıt Tarihi:
18.08.2015
Rep Puanı:
21
verified_user Emektar
Cvp: RE: weapon upgrade hakkında!!
(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

15.05.2016, Saat: 12:23
#7
musty10
musty10
Konuları:
4
Yorumları:
11
Kayıt Tarihi:
13.05.2016
verified_user M.Dumanlı
RE: weapon upgrade hakkında!!
dedigin gibi yaptim butun prosedurleri degistirdim altta verdigin prosedurun silah idlerinide degistirdim kaydettim fakat yine ayni silah elinde olsada invantoryde olsada degisim gerceklesmiyor
Cevapla
15.05.2016, Saat: 13:18
#8
Nyrox
Nyrox
Konuları:
92
Yorumları:
249
Kayıt Tarihi:
18.08.2015
Rep Puanı:
21
verified_user Emektar
Cvp: RE: weapon upgrade hakkında!!
(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
15.05.2016, Saat: 13:19
#9
musty10
musty10
Konuları:
4
Yorumları:
11
Kayıt Tarihi:
13.05.2016
verified_user M.Dumanlı
Cvp: RE: weapon upgrade hakkında!!
(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
21.12.2016, Saat: 01:56
#10
cihan0539
cihan0539
Konuları:
14
Yorumları:
44
Kayıt Tarihi:
22.04.2016
verified_user Cezalı Üye
Cvp: RE: weapon upgrade hakkında!!
(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
  Unique Elite Kaldırma Hakkında codedbyrulez 3 61 16.06.2017, Saat: 07:37
Son Yorum: Burak BAYIR
  SORU Fortress Hakkında RaDiKaL 3 71 12.06.2017, Saat: 01:19
Son Yorum: RaDiKaL
  Upgrade sistem gameserver hata mamystall 1 30 22.05.2017, Saat: 17:36
Son Yorum: Burak BAYIR
  VSRO UPGRADE SYSTEM mamystall 0 30 21.05.2017, Saat: 01:25
Son Yorum: mamystall

Hızlı Menü:



[-]
monetization_on Reklam (728x90)
Reklam Ver
Reklam vermek istiyorum?