|
You last visited: Today at 15:27
Advertisement
Any Help About This query
Discussion on Any Help About This query within the SRO Private Server forum part of the Silkroad Online category.
09/20/2014, 22:41
|
#1
|
elite*gold: 0
Join Date: Apr 2008
Posts: 190
Received Thanks: 27
|
Any Help About This query
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
|
#2
|
elite*gold: 0
Join Date: Feb 2014
Posts: 885
Received Thanks: 1,415
|
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
|
#3
|
elite*gold: 0
Join Date: Dec 2009
Posts: 65
Received Thanks: 30
|
For 1 specific Character
------------------------
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
--------------------
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
|
|
|
09/23/2014, 08:38
|
#4
|
elite*gold: 0
Join Date: Apr 2008
Posts: 190
Received Thanks: 27
|
Quote:
Originally Posted by TrypticoN
For 1 specific Character
------------------------
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
--------------------
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
|
#5
|
elite*gold: 0
Join Date: Feb 2014
Posts: 885
Received Thanks: 1,415
|
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.
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)
|
|
|
09/23/2014, 14:53
|
#6
|
elite*gold: 0
Join Date: Dec 2009
Posts: 65
Received Thanks: 30
|
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
|
#7
|
elite*gold: 28
Join Date: Aug 2014
Posts: 4,096
Received Thanks: 2,649
|
Brother, learn before you start working on a server cuz actually this is way too easy to be asked.
|
|
|
09/23/2014, 18:12
|
#8
|
elite*gold: 115
Join Date: Sep 2014
Posts: 134
Received Thanks: 201
|
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
|
#9
|
elite*gold: 0
Join Date: Dec 2009
Posts: 65
Received Thanks: 30
|
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
|
#10
|
elite*gold: 0
Join Date: Apr 2008
Posts: 190
Received Thanks: 27
|
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
|
#11
|
elite*gold: 28
Join Date: Aug 2014
Posts: 4,096
Received Thanks: 2,649
|
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
|
#12
|
elite*gold: 115
Join Date: Sep 2014
Posts: 134
Received Thanks: 201
|
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
|
#13
|
elite*gold: 0
Join Date: Dec 2009
Posts: 65
Received Thanks: 30
|
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
|
#14
|
elite*gold: 0
Join Date: Apr 2008
Posts: 190
Received Thanks: 27
|
Thanks so much sir
|
|
|
09/27/2014, 14:58
|
#15
|
elite*gold: 28
Join Date: Aug 2014
Posts: 4,096
Received Thanks: 2,649
|
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...
|
|
|
Similar Threads
|
[Help] My Pet Query -_-
11/09/2012 - EO PServer Hosting - 1 Replies
Ok i have no clue what im doing wrong can someone help me?
Query Before Entering it
Then After i enter it in console i get this
Error in console
# Nvm , fixed , was a space in the wrong spot XD
|
Some Query UseFul
04/11/2012 - SRO Private Server - 10 Replies
Some Query UseFul
Some One By Me And Some No :D
Download
Password:King$
Query
|
[Suche]Query für "Alteklinge, Reichsklinge" &' Stichdolche NUR QUERY!
08/18/2010 - Metin2 Private Server - 1 Replies
Ich weiß ich werd nervig aber ich suche die Query's
für Alteklinge, Reichsklinge &' Strichdolche
Why?
Naya, weil ich in der DB i-wie nur Drachenmaulglocke hab
... not more -.-
Auf jeden Fall Icon's etc. etc. etc. hab ich ich brauche nur die Query's
|
query
05/05/2010 - Metin2 Private Server - 0 Replies
So es gab mal ein ttut wie man query fur navicat usen kan nur ich finde in nicht mehr hat jemand den link?
|
All times are GMT +2. The time now is 15:27.
|
|