[SQL] Avatar MagicOpt Exploit Fix

USE SRO_VT_SHARD

CREATE TABLE #MagOpt (
	MagicOptValue BIGINT
)

SET NOCOUNT ON

/* ######## Inserting the Magic Opt Values ######## */
INSERT INTO #MagOpt VALUES (4294967542)
INSERT INTO #MagOpt VALUES (4294967660)
INSERT INTO #MagOpt VALUES (4294967661)
INSERT INTO #MagOpt VALUES (4294967662)
INSERT INTO #MagOpt VALUES (4294967543)
INSERT INTO #MagOpt VALUES (4294967663)
INSERT INTO #MagOpt VALUES (4294967664)
INSERT INTO #MagOpt VALUES (4294967665)
INSERT INTO #MagOpt VALUES (4294967669)
INSERT INTO #MagOpt VALUES (4294967670)
INSERT INTO #MagOpt VALUES (4294967671)
INSERT INTO #MagOpt VALUES (4294967672)
INSERT INTO #MagOpt VALUES (4294967550)
INSERT INTO #MagOpt VALUES (4294967666)
INSERT INTO #MagOpt VALUES (4294967667)
INSERT INTO #MagOpt VALUES (4294967668)
INSERT INTO #MagOpt VALUES (21474836728)
INSERT INTO #MagOpt VALUES (644245094650)
INSERT INTO #MagOpt VALUES (21474836732)
INSERT INTO #MagOpt VALUES (107374182655)
INSERT INTO #MagOpt VALUES (4294967542)
INSERT INTO #MagOpt VALUES (4294967543)
INSERT INTO #MagOpt VALUES (21474836729)
INSERT INTO #MagOpt VALUES (644245094651)
INSERT INTO #MagOpt VALUES (21474836733)
INSERT INTO #MagOpt VALUES (107374182656)
INSERT INTO #MagOpt VALUES (21474836728)
INSERT INTO #MagOpt VALUES (107374182655)

SET NOCOUNT OFF

DECLARE @i TINYINT = 1;

WHILE @i != 5
BEGIN
	DECLARE @Query VARCHAR(MAX) =  'UPDATE I 
									SET I.ItemID = 0
									FROM SRO_VT_SHARD.._Inventory I
									JOIN SRO_VT_SHARD.._Items IT
									ON I.ItemID = IT.ID64
									WHERE IT.RefItemID IN (SELECT ID FROM SRO_VT_SHARD.._RefObjCommon WHERE TypeID1 = 3 AND TypeID2 = 1 AND TypeID3 = 13 AND TypeID4 in (1,2,3) AND Country = 3)
									AND IT.MagParam' + cast(@i as varchar(5)) +  ' NOT IN (SELECT MagicOptValue FROM #MagOpt) AND IT.MagParam' + cast(@i as varchar(5)) + ' 
									IS NOT NULL AND IT.MagParam' + cast(@i as varchar(5)) + ' != 0'

	EXEC (@Query)

	PRINT 'User Inventory [' + cast(@i as varchar(5)) + '] Cleared!'

	SET @Query =   'UPDATE I 
					SET I.ItemID = 0
					FROM SRO_VT_SHARD.._InventoryForAvatar I
					JOIN SRO_VT_SHARD.._Items IT
					ON I.ItemID = IT.ID64
					WHERE IT.RefItemID IN (SELECT ID FROM SRO_VT_SHARD.._RefObjCommon WHERE TypeID1 = 3 AND TypeID2 = 1 AND TypeID3 = 13 AND TypeID4 in (1,2,3) AND Country = 3)
					AND IT.MagParam' + cast(@i as varchar(5)) + ' NOT IN (SELECT MagicOptValue FROM #MagOpt) AND IT.MagParam' + cast(@i as varchar(5)) + ' 
					IS NOT NULL AND IT.MagParam' + cast(@i as varchar(5)) + ' != 0'

	EXEC (@Query)

	PRINT 'Avatar Inventory [' + cast(@i as varchar(5)) + '] Cleared!'

	SET @Query =   'UPDATE I 
					SET I.ItemID = NULL
					FROM SRO_VT_SHARD.._Chest I
					JOIN SRO_VT_SHARD.._Items IT
					ON I.ItemID = IT.ID64
					WHERE IT.RefItemID IN (SELECT ID FROM SRO_VT_SHARD.._RefObjCommon WHERE TypeID1 = 3 AND TypeID2 = 1 AND TypeID3 = 13 AND TypeID4 in (1,2,3) AND Country = 3)
					AND IT.MagParam' + cast(@i as varchar(5)) + ' NOT IN (SELECT MagicOptValue FROM #MagOpt) AND IT.MagParam' + cast(@i as varchar(5)) + '
					 IS NOT NULL AND IT.MagParam' + cast(@i as varchar(5)) + ' != 0'

	EXEC (@Query)

	PRINT 'Storage [' + cast(@i as varchar(5)) + '] Cleared!'

	SET @i += 1;
END

DROP TABLE #MagOpt