100% All Stats / Ring 99%
PHP Code:
USE SRO_VT_SHARD
GO
DECLARE @Charid int
DECLARE @ItemID int
Declare @Charname VarChar(50)
Declare @PLUS int
DECLARE @Head int
Declare @CHEST int
DECLARE @LEGS int
DECLARE @SHOULDER int
DECLARE @HAND int
DECLARE @FOOT int
DECLARE @RING1 int
DECLARE @RING2 int
DECLARE @NECK int
DECLARE @ERRING int
DECLARE @WEP int
DECLARE @SHIELD int
SET @Charname = 'Kazuyax' --Name del character--
SET @PLUS = '12' --plus del item--
SET @Charid = (select CharID from _Char where CharName16=@Charname)
SET @Head = (Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=0 and CharID=@Charid)
SET @CHEST = (Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=1 and CharID=@Charid)
SET @LEGS = (Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=4 and CharID=@Charid)
SET @SHOULDER = (Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=2 and CharID=@Charid)
SET @HAND = (Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=3 and CharID=@Charid)
SET @FOOT = (Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=5 and CharID=@Charid)
SET @RING1 = (Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=11 and CharID=@Charid)
SET @RING2 = (Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=12 and CharID=@Charid)
SET @NECK = (Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=10 and CharID=@Charid)
SET @ERRING = (Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=9 and CharID=@Charid)
SET @WEP =(Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=6 and CharID=@Charid)
SET @SHIELD =(Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=7 and CharID=@Charid)
update _Items
set MagParamNum=9,
optlevel=@PLUS,
MagParam1 =858993459290,
MagParam2 =7301444403351,
MagParam3 =34359738441,
MagParam4=257698037899,
MagParam5=7301444403363,
MagParam6=34359738447,
MagParam7=25769804242,
MagParam8=25769804238,
MagParam9=25769804240,
Variance=34359738367
where ID64 =@Head
---------------
update _Items
set MagParamNum=9,
optlevel=@PLUS,
MagParam1 =858993459290,
MagParam2 =257698037898,
MagParam3 =7301444403351,
MagParam4=7301444403363,
MagParam5=34359738441,
MagParam6=34359738447,
MagParam7=25769804242,
MagParam8=25769804238,
MagParam9=25769804240,
Variance=34359738367
where ID64 =@CHEST
----------------------
update _Items
set MagParamNum=8,
optlevel=@PLUS,
MagParam1 =858993459290,
MagParam2 =257698037898,
MagParam3 =34359738447,
MagParam4=34359738441,
MagParam5=25769804244,
MagParam6=25769804242,
MagParam7=25769804238,
MagParam8=25769804240,
Variance=34359738367
where ID64 =@SHOULDER
----------------------
update _Items
set MagParamNum=8,
optlevel=@PLUS,
MagParam1 =858993459290,
MagParam2 =257698037898,
MagParam3 =34359738447,
MagParam4=34359738441,
MagParam5=25769804244,
MagParam6=25769804242,
MagParam7=25769804238,
MagParam8=25769804240,
Variance=34359738367
where ID64 =@HAND
update _Items
set MagParamNum=9,
optlevel=@PLUS,
MagParam1 =858993459290,
MagParam2 =257698037898,
MagParam3 =7301444403351,
MagParam4=34359738447,
MagParam5=7301444403363,
MagParam6=34359738441,
MagParam7=25769804242,
MagParam8=25769804238,
MagParam9=25769804240,
Variance=34359738367
where ID64 =@LEGS
-----------------------
update _Items
set MagParamNum=8,
optlevel=@PLUS,
MagParam1 =858993459290,
MagParam2 =257698037898,
MagParam3 =34359738447,
MagParam4=34359738441,
MagParam5=25769804244,
MagParam6=25769804242,
MagParam7=25769804238,
MagParam8=25769804240,
Variance=34359738367
where ID64 =@FOOT
update _Items
set MagParamNum=9,
optlevel=@PLUS,
MagParam1 =34359738447,
MagParam2 =85899346101,
MagParam3 =85899346095,
MagParam4 =85899346089,
MagParam5 =85899346107,
MagParam6 =34359738441,
MagParam7=25769804242,
MagParam8=25769804238,
MagParam9=25769804240,
Variance=34359738367
where ID64 =@RING1
update _Items
set MagParamNum=9,
optlevel=@PLUS,
MagParam1 =34359738447,
MagParam2 =85899346101,
MagParam3 =85899346095,
MagParam4 =85899346089,
MagParam5 =85899346113,
MagParam6 =34359738441,
MagParam7=25769804242,
MagParam8=25769804238,
MagParam9=25769804240,
Variance=34359738367
where ID64 =@RING2
update _Items
set MagParamNum=9,
optlevel=@PLUS,
MagParam1 =34359738447,
MagParam2 =34359738441,
MagParam3 =85899346113,
MagParam4 =85899346107,
MagParam5 =85899346089,
MagParam6 =85899346101,
MagParam7=25769804242,
MagParam8=25769804238,
MagParam9=25769804240,
Variance=34359738367
where ID64 =@NECK
update _Items
set MagParamNum=9,
optlevel=@PLUS,
MagParam1 =34359738447,
MagParam2 =34359738441,
MagParam3 =85899346113,
MagParam4 =85899346107,
MagParam5 =85899346095,
MagParam6 =85899346089,
MagParam7=25769804242,
MagParam8=25769804238,
MagParam9=25769804240,
Variance=34359738367
where ID64 =@ERRING
update _Items
set MagParamNum=9,
optlevel=@PLUS,
MagParam1 =34359738447,
MagParam2 =34359738441,
MagParam3 =858993459291,
MagParam4 =429496729715,
MagParam5 =25769804244,
MagParam6 =25769804238,
MagParam7 =25769804240,
MagParam8 =257698038202,
MagParam9 =25769804242,
Variance=34359738367
where ID64 =@WEP
update _Items
set MagParamNum=8,
optlevel=@PLUS,
MagParam1 =858993459291,
MagParam2 =34359738441,
MagParam3 =34359738447,
MagParam4 =429496730044,
MagParam5 =25769804242,
MagParam6 =25769804244,
MagParam7 =25769804238,
MagParam8 =25769804240,
Variance=34359738367
where ID64 =@SHIELD
select * from _Inventory where CharID=@Charid and Slot between 0 and 12