USE SRO_VT_SHARD

DECLARE @CharID INT
DECLARE @ItemID INT
DECLARE @CharName VARCHAR(12)
DECLARE @PLUS TINYINT
DECLARE @HEAD INT
DECLARE @CHEST INT
DECLARE @LEGS INT
DECLARE @SHOULDER INT
DECLARE @HAND INT
DECLARE @FOOT INT
DECLARE @LRING INT
DECLARE @RRING INT
DECLARE @NECK INT
DECLARE @EARRING INT
DECLARE @WEAPON INT
DECLARE @SHIELD INT
DECLARE @VARIANCE BIGINT

SET @CharName = 'YourCharNameHere'
SET @PLUS = 7 -- Any plus FROM 0 to 255
SET @CharID = (SELECT CharID FROM _Char WHERE CharName16 = @CharName)
SET @HEAD = (SELECT ItemID FROM _Inventory WHERE Slot=0 AND CharID = @CharID)
SET @CHEST = (SELECT ItemID FROM _Inventory WHERE Slot=1 AND CharID = @CharID)
SET @LEGS = (SELECT ItemID FROM _Inventory WHERE Slot=4 AND CharID = @CharID)
SET @SHOULDER = (SELECT ItemID FROM _Inventory WHERE Slot=2 AND CharID = @CharID)
SET @HAND = (SELECT ItemID FROM _Inventory WHERE Slot=3 AND CharID = @CharID)
SET @FOOT = (SELECT ItemID FROM _Inventory WHERE Slot=5 AND CharID = @CharID)
SET @LRING = (SELECT ItemID FROM _Inventory WHERE Slot=11 AND CharID = @CharID)
SET @RRING = (SELECT ItemID FROM _Inventory WHERE Slot=12 AND CharID = @CharID)
SET @NECK = (SELECT ItemID FROM _Inventory WHERE Slot=10 AND CharID = @CharID)
SET @EARRING = (SELECT ItemID FROM _Inventory WHERE Slot=9 AND CharID = @CharID)
SET @WEAPON =(SELECT ItemID FROM _Inventory WHERE Slot=6 AND CharID = @CharID)
SET @SHIELD =(SELECT ItemID FROM _Inventory WHERE Slot=7 AND CharID = @CharID)

SET @VARIANCE = 34359738367
/*
Take this value: 1108378657
and multiply it from any number from 0 to 31, where:
31 = 100%,  25 = 80%, 19 = 61%, 13 = 41%, 7 = 22%, 0 = 0%
*/
UPDATE _Items
SET MagParamNum=6,
    optlevel=@PLUS,
    MagParam1 =5583457484950,
    MagParam2 =5583457484962,
    MagParam3 =30064771144,
    MagParam4=858993459290,
    MagParam5=30064771150,
    MagParam6=257698037898,
    Variance=@VARIANCE
WHERE ID64 IN (@HEAD, @CHEST, @LEGS)

----------------------

UPDATE _Items
SET MagParamNum=4,
    optlevel=@PLUS,
    MagParam1 =30064771150,
    MagParam2 =30064771144,
    MagParam3 =858993459290,
    MagParam4=257698037898,
    Variance=@VARIANCE
WHERE ID64 IN (@SHOULDER, @HAND, @FOOT)

UPDATE _Items
SET MagParamNum=6,
    optlevel=@PLUS,
    MagParam1 =30064771144,
    MagParam2 =30064771150,
    MagParam3 =85899346100,
    MagParam4 =85899346094,
    MagParam5 =85899346112,
    MagParam6 =85899346106,
    Variance=@VARIANCE
WHERE ID64 IN (@LRING, @RRING, @EARRING, @NECK)

UPDATE _Items
SET MagParamNum=4,
    optlevel=@PLUS,
    MagParam1 =30064771150,
    MagParam2 =30064771144,
    MagParam3 =858993459290,
    MagParam4 =257698037862,
    Variance=@VARIANCE
WHERE ID64 =@WEAPON


UPDATE _Items
SET MagParamNum=3,
    optlevel=@PLUS,
    MagParam1 =30064771150,
    MagParam2 =30064771144,
    MagParam3 =858993459290,
    Variance=@VARIANCE
WHERE ID64 =@SHIELD


SELECT * FROM _Inventory WHERE CharID = @CharID AND Slot BETWEEN 0 AND 12 AND Slot != 8