|
You last visited: Today at 20:58
Advertisement
Can any Help me by A Query
Discussion on Can any Help me by A Query within the SRO Private Server forum part of the Silkroad Online category.
05/08/2015, 11:38
|
#1
|
elite*gold: 0
Join Date: Feb 2015
Posts: 166
Received Thanks: 42
|
Can any Help me by A Query
Can any Help Me
Need sql PROCEDURE query to add Arena Coin (Extern with a Programm)
I have add this he dont work -.
ALTER PROCEDURE [dbo].[_EventReward]
@CharName16 varchar(64)
AS
BEGIN
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @CharName16,ITEM_ETC_ARENA_COIN,20,1
END
|
|
|
05/08/2015, 12:10
|
#2
|
elite*gold: 56
Join Date: Oct 2013
Posts: 1,165
Received Thanks: 762
|
lol u wanna write a procedure to execute a procedure... thats stupid
|
|
|
05/08/2015, 12:26
|
#3
|
elite*gold: 0
Join Date: Feb 2015
Posts: 166
Received Thanks: 42
|
Quote:
Originally Posted by Syloxx
lol u wanna write a procedure to execute a procedure... thats stupid
|
sry i am not expert to make Procedure
|
|
|
05/08/2015, 12:56
|
#4
|
elite*gold: 87
Join Date: Apr 2015
Posts: 318
Received Thanks: 535
|
what's your problem ? exec it directly
PHP Code:
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @CharName16,ITEM_ETC_ARENA_COIN,20,1
|
|
|
05/08/2015, 13:37
|
#5
|
elite*gold: 0
Join Date: Feb 2015
Posts: 166
Received Thanks: 42
|
Quote:
Originally Posted by Xutan*
what's your problem ? exec it directly
PHP Code:
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @CharName16,ITEM_ETC_ARENA_COIN,20,1
|
he dont work more times tested after teleport nothing in inventar
|
|
|
05/08/2015, 14:49
|
#6
|
elite*gold: 28
Join Date: Aug 2014
Posts: 4,096
Received Thanks: 2,649
|
Quote:
Originally Posted by Andi_xBrainwash
he dont work more times tested after teleport nothing in inventar
|
Logically, this isn't possible. Try checking _ADD_ITEM_EXTERN maybe it's altered or something.
|
|
|
05/09/2015, 01:00
|
#7
|
elite*gold: 0
Join Date: Dec 2014
Posts: 435
Received Thanks: 353
|
Quote:
Originally Posted by Exo
Logically, this isn't possible. Try checking _ADD_ITEM_EXTERN maybe it's altered or something.
|
It is, I edited it once and I made it working by adding several items
|
|
|
05/09/2015, 01:58
|
#8
|
elite*gold: 28
Join Date: Aug 2014
Posts: 4,096
Received Thanks: 2,649
|
Quote:
Originally Posted by NotEvenMad
It is, I edited it once and I made it working by adding several items
|
And what does this have to do with the whole procedure being not working 'he said it's not working' and ofc it's possible to add more items.
|
|
|
05/09/2015, 09:23
|
#9
|
elite*gold: 0
Join Date: Dec 2014
Posts: 435
Received Thanks: 353
|
Quote:
Originally Posted by Exo
And what does this have to do with the whole procedure being not working 'he said it's not working' and ofc it's possible to add more items.
|
I stated its possible, you said its impossible.
|
|
|
05/09/2015, 14:12
|
#10
|
elite*gold: 28
Join Date: Aug 2014
Posts: 4,096
Received Thanks: 2,649
|
Quote:
Originally Posted by NotEvenMad
I stated its possible, you said its impossible.
|
Nah I just said it's impossible that it worked when he used another procedure to execute the ADD... procedure and didn't work when he executed the procedure itself.
|
|
|
|
Similar Threads
|
Any Help About This query
09/27/2014 - SRO Private Server - 14 Replies
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
|
[HELP]Query pet
01/30/2013 - EO PServer Hosting - 5 Replies
solved
|
Some Useful query
12/30/2011 - SRO Private Server - 5 Replies
Hello,
Let's Start
Some useful queries which could help u in edit the tables or databases data more fast and easier ,
UPDATE dbo._RefObjChar SET DefaultSkill_1=33266 WHERE CodeName128 LIKE '%P2SKILL_INNATE_ASS%'
this will update=edit at _RefObjChar table, the DefaultSkill_1 column to value 33266 WHERE=which CodeName123 this column LIKE=much the '%P2SKILL_INNATE_ASS%'=the column data which u need to edit DefaultSkill_1 at it's row
well %=accept any more work before P@SKILL and the one...
|
[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
|
All times are GMT +2. The time now is 20:58.
|
|