Any Help About This query

[where_love2003]

Hello All Elitiepvpers
i want to query
to Update _items
Mean if slot 0 or 1 or 4
HelmItem,MailItem,PantsItem

Update _Items MagParam2=876173328830,MagParam3=283467841986

and if slot 2 or 3 or 5
ShoulderItem,GauntletItem,BootsItem

Update _Items MagParam2=283467841986,MagParam3=51539607997

and if slot 9 or 10 or 11 or 12
EarringItem,NecklaceItem,RingLItem,RingRItem

Update _Items MagParam2=51539607997,MagParam3=85899346375

that by all by char
someone give me query
but its for one slot only

Declare @ItemSlot int = 'itemslot'
Declare @CharName varchar(12) = 'charname'
UPDATE dbo._Items
set OptLevel='10',
Variance='3241771616',
MagParamNum='5 ',
MagParam1='858993459290',
MagParam2= '257698037862',
MagParam3='30064771150',
MagParam4= '30064771144',
MagParam5= '429496729714'
WHERE ID64 = (select ItemID from _Inventory where Slot = @ItemSlot and CharID = (select CharID from _Char where CharName16 = @CharName))

i hope any one help me for That
i have more char to edit stat and blue
and i cant found scroll add blue and stat items

[Muhab*]

so you want to update all chars items magParams?
if yes just remove 'and CharID = (select CharID from _Char where CharName16 = @CharName)'.

[TrypticoN]

For 1 specific Character
------------------------

 Spoiler

declare @charname varchar(128) = 'CHARNAME HERE'

BEGIN
Update _Items
SET MagParam2=876173328830, MagParam3=283467841986
WHERE ID64 IN (select ItemID from _Inventory where Slot IN (0,1,4) and CharID = (select CharID from _Char where CharName16 = @CharName))

Update _Items
SET MagParam2=283467841986,MagParam3=51539607997
WHERE ID64 IN (select ItemID from _Inventory where Slot IN (2,3,5) and CharID = (select CharID from _Char where CharName16 = @CharName))

Update _Items
SET MagParam2=51539607997,MagParam3=85899346375
WHERE ID64 IN (select ItemID from _Inventory where Slot IN (9,10,11,12) and CharID = (select CharID from _Char where CharName16 = @CharName))
END

All of the chars
--------------------

 Spoiler

BEGIN
Update _Items
SET MagParam2=876173328830, MagParam3=283467841986
WHERE ID64 IN (select ItemID from _Inventory where Slot IN (0,1,4))

Update _Items
SET MagParam2=283467841986,MagParam3=51539607997
WHERE ID64 IN (select ItemID from _Inventory where Slot IN (2,3,5))

Update _Items
SET MagParam2=51539607997,MagParam3=85899346375
WHERE ID64 IN (select ItemID from _Inventory where Slot IN (9,10,11,12))
END

[where_love2003]

Originally Posted by TrypticoN

For 1 specific Character
------------------------

 Spoiler

declare @charname varchar(128) = 'CHARNAME HERE'

BEGIN
Update _Items
SET MagParam2=876173328830, MagParam3=283467841986
WHERE ID64 = (select ItemID from _Inventory where Slot IN (0,1,4) and CharID = (select CharID from _Char where CharName16 = @CharName))

Update _Items
SET MagParam2=283467841986,MagParam3=51539607997
WHERE ID64 = (select ItemID from _Inventory where Slot IN (2,3,5) and CharID = (select CharID from _Char where CharName16 = @CharName))

Update _Items
SET MagParam2=51539607997,MagParam3=85899346375
WHERE ID64 = (select ItemID from _Inventory where Slot IN (9,10,11,12) and CharID = (select CharID from _Char where CharName16 = @CharName))
END

All of the chars
--------------------

 Spoiler

BEGIN
Update _Items
SET MagParam2=876173328830, MagParam3=283467841986
WHERE ID64 = (select ItemID from _Inventory where Slot IN (0,1,4))

Update _Items
SET MagParam2=283467841986,MagParam3=51539607997
WHERE ID64 = (select ItemID from _Inventory where Slot IN (2,3,5))

Update _Items
SET MagParam2=51539607997,MagParam3=85899346375
WHERE ID64 = (select ItemID from _Inventory where Slot IN (9,10,11,12))
END

Thanks so much Bro :*

Not Worked

if i use Execute got this problem
Msg 512, Level 16, State 1, Line 2
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

[Muhab*]

Originally Posted by where_love2003

Thanks so much Bro :*

Not Worked

if i use Execute got this problem
Msg 512, Level 16, State 1, Line 2
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

this will work.

 Spoiler

BEGIN
Update a
SET a.MagParam2=876173328830, a.MagParam3=283467841986 FROM _Items a JOIN _Inventory b on a.ID64 = b.ItemID and b.Slot in(0,1,4)

Update a
SET a.MagParam2=283467841986, a.MagParam3=51539607997 FROM _Items a JOIN _Inventory b on a.ID64 = b.ItemID and b.Slot in(2,3,5)

Update a
SET a.MagParam2=51539607997, a.MagParam3=85899346375 FROM _Items a JOIN _Inventory b on a.ID64 = b.ItemID and b.Slot in(9,10,11,12)

[TrypticoN]

Originally Posted by where_love2003

Thanks so much Bro :*

Not Worked

if i use Execute got this problem
Msg 512, Level 16, State 1, Line 2
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

Sorry my fault, i've edited the query above, try once more.

instead of
WHERE ID64 =
you have to use
WHERE ID64 IN

[​Exo]

Brother, learn before you start working on a server cuz actually this is way too easy to be asked.

[Trinity^]

Originally Posted by xExorcist

Brother, learn before you start working on a server cuz actually this is way too easy to be asked.

Are you saying you never asked any questions when you where learning?

[TrypticoN]

Originally Posted by xExorcist

Brother, learn before you start working on a server cuz actually this is way too easy to be asked.

If you got nothing to say, just shut up. It's a ask the experts section for a reason.

[where_love2003]

Originally Posted by xExorcist

Brother, learn before you start working on a server cuz actually this is way too easy to be asked.

if you see you are a professional ok, i`m a new and i want to learn and asked
if you not need answer you can stop speck

Originally Posted by TrypticoN

If you got nothing to say, just shut up. It's a ask the experts section for a reason.

TrypticoN Who Care

Last Question
Can i make it for scroll
and so sorry about bother any one

[​Exo]

Originally Posted by SixtyNine^

Are you saying you never asked any questions when you where learning?

You got me so wrong, the problem is not the 'Asking' part but asking for a ready stuff isn't actually learning, we can help him learn with hints tips few help on his stuff and so then he will get experience and then we 'Actually helped him'

[Trinity^]

Originally Posted by xExorcist

You got me so wrong, the problem is not the 'Asking' part but asking for a ready stuff isn't actually learning, we can help him learn with hints tips few help on his stuff and so then he will get experience and then we 'Actually helped him'

You do realize he attempted to do it himself first... couldn't... then asked...

He didnt ask for "ready stuff", he asked for help with his own attempt.

That in absolutely no way is like leaching...

[TrypticoN]

Originally Posted by where_love2003

Last Question
Can i make it for scroll
and so sorry about bother any one

Yes it's actually pretty simple, make a copy of any return scroll in DB and Media, once you've done that let me know, then i'll help you out.

[where_love2003]

Thanks so much sir

[​Exo]

Originally Posted by SixtyNine^

You do realize he attempted to do it himself first... couldn't... then asked...

He didnt ask for "ready stuff", he asked for help with his own attempt.

That in absolutely no way is like leaching...

I doubt he wrote that...