Upgrade System By Scroll (Procedures) High Performance

Page 1 of 2

06/09/2021 17:39 Taut�#1

Hello Everyone,

Credits for @[Only registered and activated users can see links. Click Here To Register...]

I have a nice surprise today, many people told me about it, but it does some lags/delays if you have a large number of players, but no, today I solved this problem with a system that is very easy to control and it is done by HIGH PERFORMANCE and does not have any load on the CPU If you have any questions, just call me on the DISCORD Taut:#3258

Note: Create your own scroll, Use Your brain.exe

CREATE PROCEDURE

Code:

USE [YOUR_DATABASE]
GO
/****** Object:  StoredProcedure [dbo].[_TautUpgrade]    Script Date: 6/5/2021 5:05:35 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
--=============================================
--Credits For Taut�
--Discord:Taut#3258
--DM ME IF YOU HAVE ANY PROBLEM!
--=============================================
CREATE PROCEDURE [dbo].[_TautUpgrade]
	@RefItemID INT,
	@CharID INT
AS
BEGIN TRY
SET NOCOUNT ON;

DECLARE @CharName varchar(20)
SELECT @CharName=CharName16 FROM SRO_VT_SHARD.._Char WITH(NOLOCK) WHERE CharID=@CharID
--------------------------------------------
IF @RefItemID = 11111 -- (ScrollID) Seal of Star +9 -> Seal of Moon +0
BEGIN
	UPDATE	I Set RefItemID=M2.RefItemID,OptLevel = 0--,MagParamNum = 0 , Variance = 0,MagParam1=0,MagParam2=0,MagParam3=0,MagParam4=0,MagParam5=0,MagParam6=0,MagParam7=0,MagParam8=0,MagParam9=0,MagParam10=0,OptLevel =5
	FROM	SRO_VT_SHARD.._Inventory	Inv
	JOIN	SRO_VT_SHARD.._Items		I		ON Inv.ItemID=I.ID64 AND I.OptLevel >= 9 --Plus Here
	JOIN	_UpgradeItem						M1	ON I.RefItemID=M1.RefItemID 
	JOIN	_UpgradeItem						M2	ON M2.ItemType=M1.ItemType AND M2.Model = M1.Model AND M2.ItemGrade ='B_RARE'
	WHERE Inv.CharID=@CharID AND Inv.Slot=13 AND Inv.ItemID!=0 AND M1.ItemGrade = 'A_RARE'
	
	
	IF @@ROWCOUNT = 1
--You Can add your message here if success like it:
INSERT Tautbot_User.._TautCommands VALUES (1,'Congratulations! Your Seal Of Nova [Weapon] Have Been Upgraded To Seal Of Moon!','Notice','system',0,0,0,0,0,0)
	

	
	IF @@ROWCOUNT = 0
	BEGIN
--You Can add your message here if failed like it because items not in slot (13)
INSERT Tautbot_User.._TautCommands VALUES (1,'Please put a valid Seal Of Nova (+9 or more) item into the first slot of your inventory','Notice','system',0,0,0,0,0,0)
	END	
	END
END TRY
BEGIN CATCH
END CATCH

AddLogItem

Code:

IF @Operation = 41 AND @ItemRefID = 11111--(ScrollID)
BEGIN
	EXEC _TautUpgrade @ItemRefID,@CharID
END

CREATE UPGRADE TABLE

Code:

USE [YOUR_DATABASE]
GO

/****** Object:  Table [dbo].[_UpgradeItem]    Script Date: 6/9/2021 5:26:16 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[_UpgradeItem](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[RefItemID] [int] NOT NULL,
	[ItemType] [varchar](100) NOT NULL,
	[ItemGrade] [varchar](50) NOT NULL,
	[Model] [varchar](50) NOT NULL,
	[ScrollID] [int] NOT NULL,
	[GLOW] [varchar](50) NULL
) ON [PRIMARY]
GO

EXAMPLE FOR ADD ITEMS IN TABLE

Code:

RefItemID= ID From _Refobjcommon of each weapon
ItemType = Example: SWORD,BLADE Like ITEM_CH_BLADE_11_A_RARE
ItemGrade = A_RARE / B_RARE / C_RARE / SET_A_RARE / SET_B_RARE
Model = If you have model switcher, you can use it
ScrollID = ID Of scroll, like your (ScrollID) In Procederus.
GLOW = If you have Scroll change glow like model switcher.

[B]So, Let's See[/B]
6401	4044	SWORD	A_RARE	NONE	0	0
6402	4080	BLADE	A_RARE	NONE	0	0
6403	4116	SPEAR	A_RARE	NONE	0	0
6404	4152	TBLADE	A_RARE	NONE	0	0
6405	4188	BOW	A_RARE	NONE	0	0
6406	4224	SHIELD	A_RARE	NONE	0	0
6407	4045	SWORD	B_RARE	NONE	0	0
6408	4081	BLADE	B_RARE	NONE	0	0
6409	4117	SPEAR	B_RARE	NONE	0	0
6410	4153	TBLADE	B_RARE	NONE	0	0
6411	4189	BOW	B_RARE	NONE	0	0
6412	4225	SHIELD	B_RARE	NONE	0	0

PS:If Line have SWORD / A_RARE And another Line SWORD / B_RARE Your upgrade will be work fine from A_RARE TO B_RARE By same ItemType

Thanks everyone. Wait for new things and do not hesitate when you need anything. Just tell me via the discord: Taut#3258 24/7 Active

06/09/2021 18:59 denise456#2

thanks

06/10/2021 02:50 Rixy*#3

good but need query get all items Dg in 1 click insert to table ?

06/10/2021 04:00 Taut�#4

Quote:

Originally Posted by Rixy*

good but need query get all items Dg in 1 click insert to table ?

1-You Can select by this query and copy it to your table

Code:

SELECT id, codename128
FROM _RefObjCommon
WHERE CodeName128 like '%ITEM_CH_%_01_%'

Another way: without copy

Code:

INSERT INTO YourTable here (ID, Codename128)
SELECT ID, Codename128
FROM _RefObjCommon
WHERE CodeName128 like '%ITEM_CH_%_01_%'

06/10/2021 12:04 Rixy*#5

Quote:
Originally Posted by Taut�
1-You Can select by this query and copy it to your table
Code:
SELECT id, codename128
FROM _RefObjCommon
WHERE CodeName128 like '%ITEM_CH_%_01_%'
Another way: without copy
Code:
INSERT INTO YourTable here (ID, Codename128)
SELECT ID, Codename128
FROM _RefObjCommon
WHERE CodeName128 like '%ITEM_CH_%_01_%'

Nice query but where line 'Scroll'

06/10/2021 13:27 zilmamu#6

You topic not have line and What is the brain.exe

error

Msg 102, Level 15, State 1, Procedure _TautUpgrade, Line 38 [Batch Start Line 7]
Incorrect syntax near 'END'.

06/10/2021 14:41 Taut�#7

Quote:

Originally Posted by zilmamu

You topic not have line and What is the brain.exe

error

Msg 102, Level 15, State 1, Procedure _TautUpgrade, Line 38 [Batch Start Line 7]
Incorrect syntax near 'END'.

1-Use your brain to create scroll that's system not line for scroll.

2- Your error because you dont copy full proc, you dont copy END TRY BEGIN CATCH END CATCH, Check Procedure Again mate.

Quote:

Originally Posted by Rixy*

Nice query but where line 'Scroll'

Scroll for what mate?

You write need query to copy DG (1) Item Lines from _Refobjcommon to Insert in Specific table, I already add it in comment.

06/11/2021 14:39 Bastiras Online#8

Not bad, but useless, as there are already 2-3 options that work better and easier for beginners, but ty ;)

06/11/2021 14:45 Taut�#9

Quote:

Originally Posted by [GM]Darius

Not bad, but useless, as there are already 2-3 options that work better and easier for beginners, but ty ;)

Useless? Lol, Btw there are already 2~3 systems, but same performance? except #Syloxx System?, It's so funny

Quote:

Originally Posted by [GM]Darius

Not bad, but useless, as there are already 2-3 options that work better and easier for beginners, but ty ;)

I Think that you are one of the people. If it has an existing and working system, this is 100% fine, but there are very important things, such as this system, EX: performance and load, and does it have an effect on the CPU or not, and you did it by loop/fetch or not, but I see that you do not know All of these things are as I explain

06/11/2021 23:07 SubZero**#10

Quote:

Originally Posted by Taut�

Useless? Lol, Btw there are already 2~3 systems, but same performance? except #Syloxx System?, It's so funny

I Think that you are one of the people. If it has an existing and working system, this is 100% fine, but there are very important things, such as this system, EX: performance and load, and does it have an effect on the CPU or not, and you did it by loop/fetch or not, but I see that you do not know All of these things are as I explain

small note about performance you can use gs addon that allow you to the whole sys live like gander scroll.. (less sql query)

06/11/2021 23:56 Taut�#11

Quote:

Originally Posted by [GM]Darius

Not bad, but useless, as there are already 2-3 options that work better and easier for beginners, but ty ;)

Quote:

Originally Posted by SubZero**

small note about performance you can use gs addon that allow you to the whole sys live like gander scroll.. (less sql query)

GS For live item okay!!, but you'll use same system with sql, or you can do proc system via gameserver? xDD

06/12/2021 18:07 SubZero**#12

Quote:

Originally Posted by Taut�

GS For live item okay!!, but you'll use same system with sql, or you can do proc system via gameserver? xDD

btw gs will switch to the new item like gander scroll not live item
you just need to select the new codename and the current slot also CharID .

06/12/2021 23:32 Taut�#13

Quote:

Originally Posted by SubZero**

btw gs will switch to the new item like gander scroll not live item
you just need to select the new codename and the current slot also CharID .

Why i should to do that via gs-addon? lel xD

08/14/2021 04:07 -[Anxi]-#14

Exclant mate <3

01/30/2023 20:49 caner_tr#15

Quote:

Originally Posted by Taut�

Code:

USE [YOUR_DATABASE]
GO
/****** Object:  StoredProcedure [dbo].[_TautUpgrade]    Script Date: 6/5/2021 5:05:35 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
--=============================================
--Credits For Taut�
--Discord:Taut#3258
--DM ME IF YOU HAVE ANY PROBLEM!
--=============================================
CREATE PROCEDURE [dbo].[_TautUpgrade]
	@RefItemID INT,
	@CharID INT
AS
BEGIN TRY
SET NOCOUNT ON;

DECLARE @CharName varchar(20)
SELECT @CharName=CharName16 FROM SRO_VT_SHARD.._Char WITH(NOLOCK) WHERE CharID=@CharID
--------------------------------------------
IF @RefItemID = 11111 -- (ScrollID) Seal of Star +9 -> Seal of Moon +0
BEGIN
	UPDATE	I Set RefItemID=M2.RefItemID,OptLevel = 0--,MagParamNum = 0 , Variance = 0,MagParam1=0,MagParam2=0,MagParam3=0,MagParam4=0,MagParam5=0,MagParam6=0,MagParam7=0,MagParam8=0,MagParam9=0,MagParam10=0,OptLevel =5
	FROM	SRO_VT_SHARD.._Inventory	Inv
	JOIN	SRO_VT_SHARD.._Items		I		ON Inv.ItemID=I.ID64 AND I.OptLevel >= 9 --Plus Here
	JOIN	_UpgradeItem						M1	ON I.RefItemID=M1.RefItemID 
	JOIN	_UpgradeItem						M2	ON M2.ItemType=M1.ItemType AND M2.Model = M1.Model AND M2.ItemGrade ='B_RARE'
	WHERE Inv.CharID=@CharID AND Inv.Slot=13 AND Inv.ItemID!=0 AND M1.ItemGrade = 'A_RARE'
	
	
	IF @@ROWCOUNT = 1
--You Can add your message here if success like it:
INSERT Tautbot_User.._TautCommands VALUES (1,'Congratulations! Your Seal Of Nova [Weapon] Have Been Upgraded To Seal Of Moon!','Notice','system',0,0,0,0,0,0)
	

	
	IF @@ROWCOUNT = 0
	BEGIN
--You Can add your message here if failed like it because items not in slot (13)
INSERT Tautbot_User.._TautCommands VALUES (1,'Please put a valid Seal Of Nova (+9 or more) item into the first slot of your inventory','Notice','system',0,0,0,0,0,0)
	END	
	END
END TRY
BEGIN CATCH
END CATCH

AddLogItem

Code:

IF @Operation = 41 AND @ItemRefID = 11111--(ScrollID)
BEGIN
	EXEC _TautUpgrade @ItemRefID,@CharID
END

CREATE UPGRADE TABLE

Code:

USE [YOUR_DATABASE]
GO

/****** Object:  Table [dbo].[_UpgradeItem]    Script Date: 6/9/2021 5:26:16 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[_UpgradeItem](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[RefItemID] [int] NOT NULL,
	[ItemType] [varchar](100) NOT NULL,
	[ItemGrade] [varchar](50) NOT NULL,
	[Model] [varchar](50) NOT NULL,
	[ScrollID] [int] NOT NULL,
	[GLOW] [varchar](50) NULL
) ON [PRIMARY]
GO

EXAMPLE FOR ADD ITEMS IN TABLE

Code:

RefItemID= ID From _Refobjcommon of each weapon
ItemType = Example: SWORD,BLADE Like ITEM_CH_BLADE_11_A_RARE
ItemGrade = A_RARE / B_RARE / C_RARE / SET_A_RARE / SET_B_RARE
Model = If you have model switcher, you can use it
ScrollID = ID Of scroll, like your (ScrollID) In Procederus.
GLOW = If you have Scroll change glow like model switcher.

[B]So, Let's See[/B]
6401	4044	SWORD	A_RARE	NONE	0	0
6402	4080	BLADE	A_RARE	NONE	0	0
6403	4116	SPEAR	A_RARE	NONE	0	0
6404	4152	TBLADE	A_RARE	NONE	0	0
6405	4188	BOW	A_RARE	NONE	0	0
6406	4224	SHIELD	A_RARE	NONE	0	0
6407	4045	SWORD	B_RARE	NONE	0	0
6408	4081	BLADE	B_RARE	NONE	0	0
6409	4117	SPEAR	B_RARE	NONE	0	0
6410	4153	TBLADE	B_RARE	NONE	0	0
6411	4189	BOW	B_RARE	NONE	0	0
6412	4225	SHIELD	B_RARE	NONE	0	0

PS:If Line have SWORD / A_RARE And another Line SWORD / B_RARE Your upgrade will be work fine from A_RARE TO B_RARE By same ItemType

Thanks everyone. Wait for new things and do not hesitate when you need anything. Just tell me via the discord: Taut#3258 24/7 Active

Bro

IF @@ROWCOUNT = 1
--You Can add your message here if success like it:
INSERT Tautbot_User.._TautCommands VALUES (1,'Congratulations! Your Seal Of Nova [Weapon] Have Been Upgraded To Seal Of Moon!','Notice','system',0,0,0,0,0,0)

IF @@ROWCOUNT = 0
BEGIN
--You Can add your message here if failed like it because items not in slot (13)
INSERT Tautbot_User.._TautCommands VALUES (1,'Please put a valid Seal Of Nova (+9 or more) item into the first slot of your inventory','Notice','system',0,0,0,0,0,0)
END
END
END TRY
BEGIN CATCH
END CATCH

How to make this lines work? We don't have Tautbot_User.._TautCommands VALUES

Page 1 of 2