Query D14 Max Plus & Stats & Blue

[mhmmoudelemam]

Hello Kings
The topic may be recurring, but I tried,
i have few days Searching for Query to make all suits Max plus & Stats & Blue but i didn't find any of this,
so, i tried yesterday to made one of this thing then Worked fine with me.
you need to Wear it the Equipments First then use the Query
This query working for D14 items only!
Thanks.

how to use it?

 Spoiler

USE SRO_VT_SHARD

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 = 'your character name' --Query Make Stat's&Blue&Plus By Malvado
SET @PLUS = '16'
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=6,
optlevel=@PLUS,
MagParam1 =34359738807,
MagParam2 =34359738808,
MagParam3 =7301444403646,
MagParam4=7301444403647,
MagParam5=858993459641,
MagParam6=257698038205,
Variance=1073741823
where ID64 =@Head
---------------

update _Items
set MagParamNum=6,
optlevel=@PLUS,
MagParam1 =34359738807,
MagParam2 =34359738808,
MagParam3 =7301444403646,
MagParam4=7301444403647,
MagParam5=858993459641,
MagParam6=257698038205,
Variance=1073741823
where ID64 =@CHEST

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

update _Items
set MagParamNum=4,
optlevel=@PLUS,
MagParam1 =34359738807,
MagParam2 =34359738808,
MagParam3 =858993459641,
MagParam4=257698038205,
Variance=1073741823
where ID64 =@SHOULDER

----------------------
update _Items
set MagParamNum=4,
optlevel=@PLUS,
MagParam1 =34359738807,
MagParam2 =34359738808,
MagParam3 =858993459641,
MagParam4=257698038205,
Variance=1073741823
where ID64 =@HAND


update _Items
set MagParamNum=6,
optlevel=@PLUS,
MagParam1 =34359738807,
MagParam2 =34359738808,
MagParam3 =7301444403646,
MagParam4=7301444403647,
MagParam5=858993459641,
MagParam6=257698038205,
Variance=1073741823
where ID64 =@LEGS

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

update _Items
set MagParamNum=4,
optlevel=@PLUS,
MagParam1 =34359738807,
MagParam2 =34359738808,
MagParam3 =858993459641,
MagParam4=257698038205,
Variance=1073741823
where ID64 =@FOOT

update _Items
set MagParamNum=6,
optlevel=@PLUS,
MagParam1 =34359738807,
MagParam2 =34359738808,
MagParam3 =85899346100,
MagParam4 =85899346094,
MagParam5 =85899346112,
MagParam6 =85899346106,
Variance=1023
where ID64 =@RING1



update _Items
set MagParamNum=6,
optlevel=@PLUS,
MagParam1 =34359738807,
MagParam2 =34359738808,
MagParam3 =85899346100,
MagParam4 =85899346094,
MagParam5 =85899346112,
MagParam6 =85899346106,
Variance=1023
where ID64 =@RING2

update _Items
set MagParamNum=6,
optlevel=@PLUS,
MagParam1 =34359738807,
MagParam2 =34359738808,
MagParam3 =85899346100,
MagParam4 =85899346094,
MagParam5 =85899346112,
MagParam6 =85899346106,
Variance=1023
where ID64 =@NECK


update _Items
set MagParamNum=6,
optlevel=@PLUS,
MagParam1 =85899346347,
MagParam2 =85899346349,
MagParam3 =85899346346,
MagParam4=85899346348,
MagParam5=34359738785,
MagParam6=34359738786,
Variance=1023
where ID64 =@ERRING

update _Items
set MagParamNum=7,
optlevel=@PLUS,
MagParam1 =4294967758,
MagParam2 =4294967762,
MagParam3=429496730043,
MagParam4=858993459641,
MagParam5=34359738808,
MagParam6 =34359738807,
MagParam7=257698038202
where ID64 =@WEP


update _Items
set MagParamNum=3,
optlevel=@PLUS,
MagParam1 =30064771150,
MagParam2 =30064771144,
MagParam3 =858993459290,
Variance=1073741823
where ID64 =@SHIELD


select * from _Inventory where CharID=@Charid and Slot between 0 and 12

[irockalone]

i have few days Searching for Query to make all suits Max plus & Stats & Blue but i didn't find any of this,

Have you ever heard about something called SMC?
anyway thanks for sharing this maybe useful for sql beginners

[devdash]

Nice release you have my Like, i am sure it will help a lot of members here in the field.

Don't give much attention to the guy with the negative comment, he's a special case, we all learned to say mama first, but he's not, he's first word was

If (@Holder = 'Mama')
begin exec sro_vt_language.dbo._words end
else if (@Holder = 'babysitter')
begin exec sro_vt_emotions.dbo._cry end

so he will never know that some of us still need this, share as much as you can as it helps the community <3

[irockalone]

Originally Posted by alydandy

Don't give much attention to the guy with the negative comment, he's a special case, we all learned to say mama first, but he's not, he's first word was

where is the negativity in my post? atleast i gave him a hint.

[devdash]

Originally Posted by irockalone

where is the negativity in my post? atleast i gave him a hint.

We can not replace query tasks with SMC, Query is a lot faster and can be a lot useful for multi cases, no to mention that some edits can not be done in SMc when the character is logged, so SMC is something and Query is something else

So that release still useful for some people, i am sure, i didn't test it my self to be honest with you, but if he tested it as he said and it works, then i am sure it will help others, if not by using it, then by learn how the mechanic of it works.

I apology for my wrong assume then <3

[irockalone]

Originally Posted by alydandy

So that release still useful for some people,

Originally Posted by irockalone

anyway thanks for sharing this maybe useful for sql beginners

Originally Posted by alydandy

I apology for my wrong assume then <3

its all okay bruh have a good night

[borsi9795]

Originally Posted by alydandy

Nice release you have my Like, i am sure it will help a lot of members here in the field.

Don't give much attention to the guy with the negative comment, he's a special case, we all learned to say mama first, but he's not, he's first word was

If (@Holder = 'Mama')
begin exec sro_vt_language.dbo._words end
else if (@Holder = 'babysitter')
begin exec sro_vt_emotions.dbo._cry end

so he will never know that some of us still need this, share as much as you can as it helps the community <3

You won the internet today. Killed me

[arg3n7s]

In my opinion, this type of query only damages the servers.
But good contribution.

[Devsome]

#close