Welcome to Game Network Online
Today i will release some VSRO Scroll By SafyStar
That's have to add in [SRO_VT_LOG]
in [dbo].[_AddLogItem]
Today i will release some VSRO Scroll By SafyStar
That's have to add in [SRO_VT_LOG]
in [dbo].[_AddLogItem]
Useful Gold Scroll
- Code:
If (@Operation=41) and (@ItemRefID between 'ItemID' and 'ItemID')
begin
set @Gold = Case
when @ItemRefID= 42084
then 100000000 --1-100M
when @ItemRefID= 42085
then 500000000 --2-500M
When @ItemRefID= 42086
then 1000000000 --3-1B
When @ItemRefID= 42087
then 5000000000 --4-5B
When @ItemRefID= 42088
then 10000000000 --5-10B
When @ItemRefID= 42089
then 20000000000 --6-20B
When @ItemRefID= 42090
then 50000000000 --7-50B
When @ItemRefID= 42091
then 100000000000 --8-100B
When @ItemRefID= 42092
then 500000000000 --9-500B
end
UPDATE [SRO_VT_SHARD].dbo.[_Char] set RemainGold=RemainGold+@Gold where CharID=@CharID
end
Useful Silk Scroll
- Code:
If (@Operation=41) and (@ItemRefID between 'ItemID' and 'ItemID')
begin
Declare @Silk_Own INT
Declare @JID INT
set @Silk_Own = Case
when @ItemRefID= 42009
then 1 --1 Silk
when @ItemRefID= 42010
then 5 --5 Silk
When @ItemRefID= 42011
then 10 --10 Silk
When @ItemRefID= 42012
then 50 --50 Silk
When @ItemRefID= 42013
then 100 --100 Silk
When @ItemRefID= 42014
then 500 --500 Silk
When @ItemRefID= 42015
then 1000 --1000 Silk
end
SELECT @JID = UserJID from [SRO_VT_SHARD].dbo._User where CharID = @CharID
IF EXISTS (Select * from SRO_VT_ACCOUNT..SK_Silk where JID = @JID)
UPDATE [SRO_VT_ACCOUNT].dbo.[SK_Silk] set silk_own=silk_own+@Silk_Own where JID=@JID
END
IF not EXISTS (Select * from SRO_VT_ACCOUNT..SK_Silk where JID = @JID)
Begin
INSERT INTO SRO_VT_ACCOUNT..SK_Silk
SELECT @JID, @Silk_Own, 0, 0
end
Useful Title Scroll
- Code:
If ( @Operation = 41 and (@ItemRefID between '75023' and '75062'))
begin
Declare @HWAN INT
SET @Hwan = (select HwanLevel from SRO_VT_SHARD.._Char where HwanLevel = @Hwan and CharID = @CharID)
set @HWAN = Case
when @ItemRefID= 75023
then 7 --Zerk Level
when @ItemRefID= 75024
then 8 --Zerk Level
When @ItemRefID= 75025
then 9 --Zerk Level
When @ItemRefID= 75026
then 10 --Zerk Level
When @ItemRefID= 75027
then 11 --Zerk Level
When @ItemRefID= 75028
then 12 --Zerk Level
When @ItemRefID= 75029
then 13 --Zerk Level
When @ItemRefID= 75030
then 14 --Zerk Level
When @ItemRefID= 75031
then 15 --Zerk Level
When @ItemRefID= 75032
then 16 --Zerk Level
When @ItemRefID= 75033
then 17 --Zerk Level
When @ItemRefID= 75034
then 18 --Zerk Level
When @ItemRefID= 75035
then 19 --Zerk Level
When @ItemRefID= 75036
then 20 --Zerk Level
When @ItemRefID= 75037
then 21 --Zerk Level
When @ItemRefID= 75038
then 22 --Zerk Level
When @ItemRefID= 75039
then 23 --Zerk Level
When @ItemRefID= 75040
then 24 --Zerk Level
When @ItemRefID= 75041
then 25 --Zerk Level
When @ItemRefID= 75042
then 26 --Zerk Level
When @ItemRefID= 75043
then 27 --Zerk Level
When @ItemRefID= 75044
then 28 --Zerk Level
When @ItemRefID= 75045
then 29 --Zerk Level
When @ItemRefID= 75046
then 30 --Zerk Level
When @ItemRefID= 75047
then 31 --Zerk Level
When @ItemRefID= 75048
then 32 --Zerk Level
When @ItemRefID= 75049
then 33 --Zerk Level
When @ItemRefID= 75050
then 34 --Zerk Level
When @ItemRefID= 75051
then 35 --Zerk Level
When @ItemRefID= 75052
then 36 --Zerk Level
When @ItemRefID= 75053
then 37 --Zerk Level
When @ItemRefID= 75054
then 38 --Zerk Level
When @ItemRefID= 75055
then 39 --Zerk Level
When @ItemRefID= 75056
then 40 --Zerk Level
When @ItemRefID= 75057
then 41 --Zerk Level
When @ItemRefID= 75058
then 42 --Zerk Level
When @ItemRefID= 75059
then 43 --Zerk Level
When @ItemRefID= 75060
then 44 --Zerk Level
When @ItemRefID= 75061
then 45 --Zerk Level
When @ItemRefID= 75062
then 46 --Zerk Level
Else @CharID
end
begin
if exists (select HwanLevel from [SRO_VT_SHARD].._Char where CharID=@CharID and HwanLevel Like '2' or HwanLevel between '7' and '46' )
begin
Update SRO_VT_SHARD.._Char set HwanLevel = @HWAN where CharID = @CharID
END
END
end
Model Switcher Scroll
- Code:
USE [SRO_VT_LOG]
GO
/****** Object: StoredProcedure [dbo].[_Model_Switcher_D11_10] Script Date: 2/20/2018 7:53:40 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
/****** Object: StoredProcedure [dbo].[_NOVA_SWITCHER] Script Date: 6/6/2015 8:10:36 AM ******/
ALTER PROCEDURE [dbo].[_Model_Switcher_D11_10]
@CharID INT
AS
BEGIN
--//---------------------------------------------------------------
DECLARE @INVSIZE TINYINT,
@Top1Wep int,
@OldItm int
Set @InvSize = (select InventorySize from [SRO_VT_SHARD].._char where charid = @charid)
set @Top1Wep = (select top 1 inv.itemid from [SRO_VT_SHARD].._inventory inv inner join [SRO_VT_SHARD].._items itm on inv.itemid = itm.id64
where itm.refitemid in (select ItemID from _ModelSwitcher_D11_10) and itm.serial64 > 0 and inv.itemid <> 0 and inv.slot between 13 and @InvSize and inv.charid = @charid )
Set @OldItm = (select top 1 refitemid from [SRO_VT_SHARD].._items where id64 <> 0 and id64 = @Top1Wep and serial64 > 0)
if @Top1Wep > 0
Begin
Declare @NewItm int = case
When @olditm in (select ItemID from _ModelSwitcher_D11_10)
then (select top 1 Newitemid from _ModelSwitcher_D11_10 where ItemID = @olditm )
end /* will destroy any item that he tries to switch if he dont have required items */
update [SRO_VT_SHARD].._items set RefItemID = @NewItm where RefItemID = @OldItm and ID64 = @Top1Wep and Serial64 > 0
End
END
- Code:
USE [SRO_VT_LOG]
GO
/****** Object: Table [dbo].[_ModelSwitcher_D11_10] Script Date: 2/20/2018 7:56:00 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[_ModelSwitcher_D11_10](
[ItemID] [int] NOT NULL,
[ItemCode] [varchar](max) NOT NULL,
[NewitemID] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
- Code:
Add that in addlogitem
IF ((@Operation = 41 ) AND (@ItemRefID = 42073))
BEGIN
exec [SRO_VT_LOG].dbo.[_Model_Switcher_D11_10] @CharID
END