| zagorodnov |
10/29/2020 02:44 |
U can use my scroll for upgrate item by item id
Quote:
ELSE IF ((@Operation = 41) and (@ItemRefID = 44036)) -- RefObjCommon ID
Begin
Execute [SRO_VT_LOG].[dbo].[_UpgradeSystem] @CharID
End
|
Quote:
USE [SRO_VT_LOG]
GO
/****** Object: StoredProcedure [dbo].[_UpgradeSystem] Script Date: 27.10.2020 21:21:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[_UpgradeSystem]
@CharID Int
As
declare @ID64Wep int
declare @ID64Shd int
declare @OldItemWepID int
declare @OldItemShdID int
declare @NewItemWepID int
declare @NewItemShdID int
declare @SlotWep int
declare @SlotShd int
set @ID64Wep = (select ItemID from SRO_VT_SHARD.._Inventory where CharID = @CharID and slot ='6')
set @ID64Shd = (select ItemID from SRO_VT_SHARD.._Inventory where CharID = @CharID and slot ='7')
set @OldItemWepID =(select RefItemID from SRO_VT_SHARD.._Items where ID64 = @ID64Wep)
set @OldItemShdID =(select RefItemID from SRO_VT_SHARD.._Items where ID64 = @ID64Shd)
set @NewItemWepID = (select NewItemID from _UpgradeItemData where OldItemID = @OldItemWepID)
set @NewItemShdID = (select NewItemID from _UpgradeItemData where OldItemID = @OldItemShdID)
IF (EXISTS(select RefItemID from SRO_VT_SHARD.._Items where ID64 = @ID64Wep and RefItemID = @OldItemWepID and OptLevel >= 12 ))
begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @NewItemWepID , OptLevel = 0, MagParamNum = 0, MagParam1 = NULL, MagParam2 = NULL, MagParam3 = NULL, MagParam4 = NULL, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL, Variance = 0 Where ID64 = @ID64Wep
DELETE FROM SRO_VT_SHARD.dbo._BindingOptionWithItem where nItemDBID = @ID64Wep
end
IF (EXISTS(select RefItemID from SRO_VT_SHARD.._Items where ID64 = @ID64Shd and RefItemID = @OldItemShdID and OptLevel >= 12))
begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @NewItemShdID , OptLevel = 0, MagParamNum = 0, MagParam1 = NULL, MagParam2 = NULL, MagParam3 = NULL, MagParam4 = NULL, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL, Variance = 0 Where ID64 = @ID64Shd
DELETE FROM SRO_VT_SHARD.dbo._BindingOptionWithItem where nItemDBID = @ID64Shd
end
|
Quote:
USE [SRO_VT_LOG]
GO
/****** Object: Table [dbo].[_UpgradeItemData] Script Date: 29.10.2020 4:41:51 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[_UpgradeItemData](
[OldItemID] [int] NULL,
[NewItemId] [int] NULL,
[Slot] [int] NULL
) ON [PRIMARY]
GO
|
Quote:
_RefObjCommon
1 44036 ITEM_UPGRADE ????? xxx SN_ITEM_UPGRADE SN_ITEM_UPGRADE_TT_DESC 0 0 3 3 3 1 180000 3 0 1 1 1 255 0 1 0 0 128 0 100 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr skill\reflect_back.ddj xxx xxx 23356
|
Quote:
_RefObjItem
23356 1 2 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 ???? 1 ?????? -1 RESURRECT 5 COOLTIME:0x00000000 -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 0 0
|
|
