واحد بيفهم اوي في الPRODUCERS و ياريت لو ILEGEND

[Dev.Ahmed_Elnashary]

الproduce دا عايزه لما اضرب السكرول ميشلش الfb و stats , plus يفضلوا زي ما هما ! ياريت لو حد يعرف يعدل عليه

Declare @CharName16 varchar(64)
DECLARE @OldItemCodeName varchar(128)
DECLARE @OldItemPlus int
DECLARE @NewItemCodeName varchar(128)
set @OldItemPlus = 0
DECLARE @NewItemPlus int
set @NewItemPlus = 0
DECLARE @ReplaceID int
SET @REPLACEID = (select top 1 ItemID from SRO_VT_SHARD_Tito.dbo._Inventory as inv inner join SRO_VT_SHARD_Tito.dbo._Items as itm on inv.ItemID = itm.ID64 inner join SRO_VT_SHARD_Tito.dbo._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_Tito.dbo._Inventory set ItemID = 0 where ItemID = @ReplaceID and CharID = @CharID
select @CharName16 =CharName16 from SRO_VT_SHARD_Tito.dbo._Char where CharID=@CharID
exec SRO_VT_SHARD_Tito.dbo._ADD_ITEM_EXTERN @CharName16,@NewItemCodeName,1,@NewItemPlus
end
IF (@Operation = 41)
begin
IF (@ItemRefID =41854)
BEGIN
declare @RefCharID1 int
DECLARE @OldItemCodeName1 varchar(128)
DECLARE @OldItemPlus1 int
DECLARE @NewItemCodeName1 varchar(128)
Declare @Var__ bigint
Declare @MN__ tinyint
Declare @MP1__ bigint
Declare @MP2__ bigint
Declare @MP3__ bigint
Declare @MP4__ bigint
Declare @MP5__ bigint
Declare @MP6__ bigint
Declare @MP7__ bigint
Declare @MP8__ bigint
Declare @MP9__ bigint
Declare @MP10__ bigint
Declare @MP11__ bigint
Declare @MP12__ bigint
Declare @RefMail1 INT = (Select ItemID From SRO_VT_SHARD_Tito.dbo._Inventory Where CharID=@CharID AND Slot ='13')
Declare @RefMailID1 INT = (Select RefItemID From SRO_VT_SHARD_Tito.dbo._Items Where ID64 = @RefMail1)
SET @Var__ = (SELECT Variance From SRO_VT_SHARD_Tito.dbo._Items Where ID64 = @RefMail1)
SET @MN__ = (SELECT MagParamNum From SRO_VT_SHARD_Tito.dbo._Items Where ID64 = @RefMail1)
SET @MP1__ = (SELECT MagParam1 From SRO_VT_SHARD_Tito.dbo._Items Where ID64 = @RefMail1)
SET @MP2__ = (SELECT MagParam2 From SRO_VT_SHARD_Tito.dbo._Items Where ID64 = @RefMail1)
SET @MP3__ = (SELECT MagParam3 From SRO_VT_SHARD_Tito.dbo._Items Where ID64 = @RefMail1)
SET @MP4__ = (SELECT MagParam4 From SRO_VT_SHARD_Tito.dbo._Items Where ID64 = @RefMail1)
SET @MP5__ = (SELECT MagParam5 From SRO_VT_SHARD_Tito.dbo._Items Where ID64 = @RefMail1)
SET @MP6__ = (SELECT MagParam6 From SRO_VT_SHARD_Tito.dbo._Items Where ID64 = @RefMail1)
SET @MP7__ = (SELECT MagParam7 From SRO_VT_SHARD_Tito.dbo._Items Where ID64 = @RefMail1)
SET @MP8__ = (SELECT MagParam8 From SRO_VT_SHARD_Tito.dbo._Items Where ID64 = @RefMail1)
SET @MP9__ = (SELECT MagParam9 From SRO_VT_SHARD_Tito.dbo._Items Where ID64 = @RefMail1)
SET @MP10__ = (SELECT MagParam10 From SRO_VT_SHARD_Tito.dbo._Items Where ID64 = @RefMail1)
SET @MP11__ = (SELECT MagParam11 From SRO_VT_SHARD_Tito.dbo._Items Where ID64 = @RefMail1)
SET @MP12__ = (SELECT MagParam12 From SRO_VT_SHARD_Tito.dbo._Items Where ID64 = @RefMail1)
select @OldItemCodeName1 = CodeName128 from SRO_VT_SHARD_Tito.dbo._RefObjCommon where ID = @RefMailID1
if(@OldItemCodeName1 = 'ITEM_CH_SWORD_11_SET_A_RARE')
begin
set @NewItemCodeName1 = 'ITEM_CH_SWORD_11_SET_B_RARE'
end
if(@OldItemCodeName1 = 'ITEM_CH_BOW_11_SET_A_RARE')
begin
set @NewItemCodeName1 = 'ITEM_CH_BOW_11_SET_B_RARE'
end
if(@OldItemCodeName1 = 'ITEM_CH_BLADE_11_SET_A_RARE')
begin
set @NewItemCodeName1 = 'ITEM_CH_BLADE_11_SET_B_RARE'
end
if(@OldItemCodeName1 = 'ITEM_CH_SPEAR_11_SET_A_RARE')
begin
set @NewItemCodeName1 = 'ITEM_CH_SPEAR_11_SET_B_RARE'
end
if(@OldItemCodeName1 = 'ITEM_CH_SHIELD_11_SET_A_RARE')
begin
set @NewItemCodeName1 = 'ITEM_CH_SHIELD_11_SET_B_RARE'
end
if(@OldItemCodeName1 = 'ITEM_CH_TBLADE_11_SET_A_RARE')
begin
set @NewItemCodeName1 = 'ITEM_CH_TBLADE_11_SET_B_RARE'
end
if(@OldItemCodeName1 = 'ITEM_EU_SWORD_11_SET_A_RARE')
begin
set @NewItemCodeName1 = 'ITEM_EU_SWORD_11_SET_B_RARE'
end
if(@OldItemCodeName1 = 'ITEM_EU_TSWORD_11_SET_A_RARE')
begin
set @NewItemCodeName1 = 'ITEM_EU_TSWORD_11_SET_B_RARE'
end
if(@OldItemCodeName1 = 'ITEM_EU_STAFF_11_SET_A_RARE')
begin
set @NewItemCodeName1 = 'ITEM_EU_STAFF_11_SET_B_RARE'
end
if(@OldItemCodeName1 = 'ITEM_EU_TSTAFF_11_SET_A_RARE')
begin
set @NewItemCodeName1 = 'ITEM_EU_TSTAFF_11_SET_B_RARE'
end
if(@OldItemCodeName1 = 'ITEM_EU_HARP_11_SET_A_RARE')
begin
set @NewItemCodeName1 = 'ITEM_EU_HARP_11_SET_B_RARE'
end
if(@OldItemCodeName1 = 'ITEM_EU_DAGGER_11_SET_A_RARE')
begin
set @NewItemCodeName1 = 'ITEM_EU_DAGGER_11_SET_B_RARE'
end
if(@OldItemCodeName1 = 'ITEM_EU_CROSSBOW_11_SET_A_RARE')
begin
set @NewItemCodeName1 = 'ITEM_EU_CROSSBOW_11_SET_B_RARE'
end
if(@OldItemCodeName1 = 'ITEM_EU_AXE_11_SET_A_RARE')
begin
set @NewItemCodeName1 = 'ITEM_EU_AXE_11_SET_B_RARE'
end
if(@OldItemCodeName1 = 'ITEM_EU_DARKSTAFF_11_SET_A_RARE')
begin
set @NewItemCodeName1 = 'ITEM_EU_DARKSTAFF_11_SET_B_RARE'
end
if(@OldItemCodeName1 = 'ITEM_EU_SHIELD_11_SET_A_RARE')
begin
set @NewItemCodeName1 = 'ITEM_EU_SHIELD_11_SET_B_RARE'
end
set @OldItemPlus1 = 0
DECLARE @NewItemPlus1 int
set @NewItemPlus1 = 0
DECLARE @ReplaceID1 int
SET @REPLACEID1 = (select top 1 ItemID from SRO_VT_SHARD_Tito.dbo._Inventory as inv inner join SRO_VT_SHARD_Tito.dbo._Items as itm on inv.ItemID = itm.ID64 inner join SRO_VT_SHARD_Tito.dbo._RefObjCommon as common on itm.RefItemID = common.ID where inv.CharID = @CharID and common.CodeName128 = @OldItemCodeName1 and itm.OptLevel >= @OldItemPlus1)
if (@ReplaceID1 > 0)
begin
Update SRO_VT_SHARD_Tito.dbo._Inventory set ItemID = 0 where ItemID = @ReplaceID1 and CharID = @CharID
select @CharName16 =CharName16 from SRO_VT_SHARD_Tito.dbo._Char where CharID=@CharID
exec SRO_VT_SHARD_Tito.dbo._ADD_ITEM_EXTERN @CharName16,@NewItemCodeName1,1,@NewItemPlus1
Declare @New2 INT = (Select ItemID From SRO_VT_SHARD_Tito.dbo._Inventory Where CharID=@CharID AND Slot ='13')
UPDATE SRO_VT_SHARD_Tito.dbo._Items SET MagParamNum=@MN__, Variance=@Var__, MagParam1=@MP1__, MagParam2=@MP2__, MagParam3=@MP3__, MagParam4=@MP4__, MagParam5=@MP5__, MagParam6=@MP6__, MagParam7=@MP7__, MagParam8=@MP8__, MagParam9=@MP9__, MagParam10=@MP10__, MagParam11=@MP11__, MagParam12=@MP12__ where ID64 =@New2
end
end
end