PHP Code:
USE SRO_VT_SHARD
declare @CharName varchar (64)
set @CharName = 'ActOfDark'
declare @CharID INT = ( select CharID from _Char where CharName16 = @CharName )
--(Str/Int 8, Parry 60%, Durability 200%, HP 100% , MP 100% for custom)
UPDATE _Items SET Variance = 34359738336,OptLevel='20', MagParamNum='6',MagParam1='858993459290',MagParam2= '257698037898',MagParam3='30064771150',MagParam4= '30064771144',MagParam5 ='858993459290',MagParam6 ='4294967494' WHERE ID64 = (select ItemID from SRO_VT_SHARD.dbo._Inventory where CharID = @CharID and Slot = '0')
UPDATE _Items SET Variance = 34359738336,OptLevel='20', MagParamNum='6',MagParam1='858993459290',MagParam2= '257698037898',MagParam3='30064771150',MagParam4= '30064771144',MagParam5 ='858993459290',MagParam6 ='4294967494' WHERE ID64 = (select ItemID from SRO_VT_SHARD.dbo._Inventory where CharID = @CharID and Slot = '1')
UPDATE _Items SET Variance = 34359738336,OptLevel='20', MagParamNum='4',MagParam1='858993459290',MagParam2= '257698037898',MagParam3='30064771150',MagParam4= '30064771144' WHERE ID64 = (select ItemID from SRO_VT_SHARD.dbo._Inventory where CharID = @CharID and Slot = '2')
UPDATE _Items SET Variance = 34359738336,OptLevel='20', MagParamNum='4',MagParam1='858993459290',MagParam2= '257698037898',MagParam3='30064771150',MagParam4= '30064771144' WHERE ID64 = (select ItemID from SRO_VT_SHARD.dbo._Inventory where CharID = @CharID and Slot = '3')
UPDATE _Items SET Variance = 34359738336,OptLevel='20', MagParamNum='6',MagParam1='858993459290',MagParam2= '257698037898',MagParam3='30064771150',MagParam4= '30064771144',MagParam5 ='858993459290',MagParam6 ='4294967494' WHERE ID64 = (select ItemID from SRO_VT_SHARD.dbo._Inventory where CharID = @CharID and Slot = '4')
UPDATE _Items SET Variance = 34359738336,OptLevel='20', MagParamNum='4',MagParam1='858993459290',MagParam2= '257698037898',MagParam3='30064771150',MagParam4= '30064771144' WHERE ID64 = (select ItemID from SRO_VT_SHARD.dbo._Inventory where CharID = @CharID and Slot = '5')
--(Str/Int 8, Freeze 20%, Electric Shock 20%, Burn 20%, Poison 20%, Zombie 20%)
UPDATE _Items SET Variance = 1023,OptLevel='20', MagParamNum='7',MagParam1='30064771150',MagParam2= '30064771144',MagParam3='85899346100',MagParam4= '85899346094',MagParam5='85899346088',MagParam6='85899346106',MagParam7='85899346112' WHERE ID64 = (select ItemID from SRO_VT_SHARD.dbo._Inventory where CharID = @CharID and Slot = '9' )
UPDATE _Items SET Variance = 1023,OptLevel='20', MagParamNum='7',MagParam1='30064771150',MagParam2= '30064771144',MagParam3='85899346100',MagParam4= '85899346094',MagParam5='85899346088',MagParam6='85899346106',MagParam7='85899346112' WHERE ID64 = (select ItemID from SRO_VT_SHARD.dbo._Inventory where CharID = @CharID and Slot = '10' )
UPDATE _Items SET Variance = 1023,OptLevel='20', MagParamNum='7',MagParam1='30064771150',MagParam2= '30064771144',MagParam3='85899346100',MagParam4= '85899346094',MagParam5='85899346088',MagParam6='85899346106',MagParam7='85899346112' WHERE ID64 = (select ItemID from SRO_VT_SHARD.dbo._Inventory where CharID = @CharID and Slot = '11' )
UPDATE _Items SET Variance = 1023,OptLevel='20', MagParamNum='7',MagParam1='30064771150',MagParam2= '30064771144',MagParam3='85899346100',MagParam4= '85899346094',MagParam5='85899346088',MagParam6='85899346106',MagParam7='85899346112' WHERE ID64 = (select ItemID from SRO_VT_SHARD.dbo._Inventory where CharID = @CharID and Slot = '12' )
--
UPDATE _Items SET Variance = 34359738367,OptLevel='20', MagParamNum='5',MagParam1='858993459290',MagParam2= '257698037862',MagParam3='429496729714',MagParam4= '30064771150',MagParam5='30064771144' WHERE ID64 = (select ItemID from SRO_VT_SHARD.dbo._Inventory where CharID = @CharID and Slot = '6' )
UPDATE _Items SET Variance = 1073741823,OptLevel='20',MagParamNum='5',MagParam1='858993459290',MagParam2= '429496729714',MagParam3='257698037862',MagParam4= '30064771150',MagParam5='30064771144' WHERE ID64 = (select ItemID from SRO_VT_SHARD.dbo._Inventory where CharID = @CharID and Slot = '7' )