[SQL, PERFORMANCE] Add Equip to a char 80x faster!

[dafuq99]

Royal can you give me Tip
i want to make this script from 1 til 8 Sun FB MAX 61% AND D9 items Seal oF moon

 

[lemoniscool]

Royal can you give me Tip
i want to make this script from 1 til 8 Sun FB MAX 61% AND D9 items Seal oF moon

thanks for this post, really!
you made my day a bit better today .. had a good laugh =)

 

[Royalblade]

Royal can you give me Tip
i want to make this script from 1 til 8 Sun FB MAX 61% AND D9 items Seal oF moon

Yes, i can give you a tip. However, first complete this:

You must be registered to see links

After passing it with a positive result, you can ask again. Oh, I might ask you to visit another test page to check your english before I do actually help you.

In case you don't pass, there are multiple mental institutions in your city, just checked, those will take you in just after a quick look. There are many retards there, you can join em officially. At least, then I'll feel pity instead of disgust.

 

[dafuq99]

Yes, i can give you a tip. However, first complete this:

You must be registered to see links

After passing it with a positive result, you can ask again. Oh, I might ask you to visit another test page to check your english before I do actually help you.

In case you don't pass, there are multiple mental institutions in your city, just checked, those will take you in just after a quick look. There are many retards there, you can join em officially. At least, then I'll feel pity instead of disgust.

i quit vSRO developeing

 

[manoo92]

hey guys.
this release work or no ?

 

[lemoniscool]

of course it works Oo

 

[Ahmed ElSafty]

thanks royal for that one really nice work you done there ...
i did fix it alil to work with all items since it was only working with only Clothes and Weapons and accessory's
here we go

USE [SRO_VT_SHARD]GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE _RoyalAddEquipment @CharID INT,
@ItemID INT, @Amount INT, @optLvl INT
AS
SET XACT_ABORT ON
DECLARE @FreeSlot TINYINT,
@link INT,
@TiD1 TINYINT,
@TiD2 TINYINT;

SELECT @link = Link,
@TiD1 = TypeID1,
@TiD2 = TypeID2
FROM _RefObjCommon
WHERE ID = @ItemID




IF @link IS NULL
BEGIN
PRINT 'Item doesn''t exist'
RETURN
END

IF NOT EXISTS(SELECT * FROM _Char WITH (NOLOCK) WHERE CharID = @CharID)
BEGIN
PRINT 'Char doesn''t exist'
RETURN
END




SELECT TOP 1 @FreeSlot = Slot
FROM _Inventory
WHERE CharID = @CharID
AND Slot > 12
AND ItemID = 0




IF @FreeSlot IS NULL
BEGIN
PRINT 'Inventory is full'
RETURN
END




DECLARE @NewItemID BIGINT = 0;

BEGIN TRAN
IF @TiD1 = 3 AND @TiD2 = 1
BEGIN
SELECT @Amount = Dur_L
FROM _RefObjItem
WHERE ID = @link

DECLARE @LatestItemSN BIGINT




UPDATE _LatestItemSerial SET LatestItemSerial += 1;

SELECT @LatestItemSN = LatestItemSerial
FROM _LatestItemSerial
WITH (UPDLOCK)




INSERT INTO _Items (RefItemID, OptLevel, Data, MagParamNum, Serial64)
VALUES (@ItemID, @optLvl, @Amount, 0, @LatestItemSN)
SELECT @NewItemID = @@IDENTITY




UPDATE _Inventory SET ItemID = @NewItemID WHERE CharID = @CharID AND Slot = @FreeSlot
END
ELSE
BEGIN
SELECT @Amount = MaxStack
FROM _RefObjItem
WHERE ID = @link

DECLARE @LatestItemSN_2 BIGINT




UPDATE _LatestItemSerial SET LatestItemSerial += 1;

SELECT @LatestItemSN_2 = LatestItemSerial
FROM _LatestItemSerial
WITH (UPDLOCK)




INSERT INTO _Items (RefItemID, OptLevel, Data, MagParamNum, Serial64)
VALUES (@ItemID, @optLvl, @Amount, 0, @LatestItemSN_2)
SELECT @NewItemID = @@IDENTITY




UPDATE _Inventory SET ItemID = @NewItemID WHERE CharID = @CharID AND Slot = @FreeSlot
END

IF @NewItemID = 0
BEGIN
ROLLBACK TRAN
PRINT 'Huge Error'
RETURN
END

COMMIT TRAN

Greeting
Divntos



But you will be dced if you sell that item to any npc.

 

[Royalblade]

Updated. DC Selling fixed.

Cause: Forgot to input shiz @ Itempool