Any Help About This query

09/20/2014 22:41 where_love2003#1

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

Code:

Update _Items MagParam2=876173328830,MagParam3=283467841986

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

Code:

Update _Items MagParam2=283467841986,MagParam3=51539607997

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

Code:

Update _Items MagParam2=51539607997,MagParam3=85899346375

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

Code:

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

09/22/2014 15:14 Muhab*#2

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

09/22/2014 15:58 TrypticoN#3

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

Spoiler

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

Spoiler

09/23/2014 08:38 where_love2003#4

Quote:

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.

09/23/2014 14:35 Muhab*#5

Quote:

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

09/23/2014 14:53 TrypticoN#6

Quote:

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

09/23/2014 17:57 Exo#7

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

09/23/2014 18:12 Trinity^#8

Quote:

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?

09/23/2014 18:19 TrypticoN#9

Quote:

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.

09/24/2014 02:31 where_love2003#10

Quote:

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

Quote:

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

09/26/2014 09:55 Exo#11

Quote:

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'

09/26/2014 15:54 Trinity^#12

Quote:

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...

09/26/2014 16:32 TrypticoN#13

Quote:

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.

09/26/2014 17:18 where_love2003#14

Thanks so much sir

09/27/2014 14:58 Exo#15

Quote:

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...