Help With Proc

[eiron2010]

Hello Guys
i have problem with silk scroll
i have this proc work 100% When I do restart I can not find anything

 Spoiler

IF @ = 41
BEGIN
IF @RefID = 8000162
BEGIN
Select @ = 25
Select @ = UserJID from SRO_VT_SHARD.._User where CharID = @D

IF EXISTS (Select * from SRO_VT_ACCOUNT..SK_Silk where JID = @)
UPDATE SRO_VT_ACCOUNT..SK_Silk set silk_own = silk_own + @ where JID = @
ELSE
INSERT INTO SRO_VT_ACCOUNT..SK_Silk
SELECT @,25,0,0
END
END

please i want proc Works on 10 scroll's

[KingDollar]

simply you can add in the end of (scroll codename) amount of silk which this scroll will rewarded as example ->

ITEM_SILK_SCROLL_100 -> It would give 100 silk
ITEM_SILK_SCROLL_200 -> it would give 200 silk

then you could substring the code name to extract amount of silk only

as example

PHP Code:

DECLARE SilkAmount SMALLINT = SUBSTRING(CodeName,PATINDEX('%[0-9]%', CodeName), LEN(CodeName)) 


and also your add silk code is not working
use this one instead

 IF not exists(SELECT * from SRO_VT_ACCOUNT..SK_Silk where JID = UserJID)
 BEGIN
INSERT INTO SRO_VT_ACCOUNT..SK_Silk(JID,silk_own,silk_gift,silk_Point)VALUES(UserJID,SilkAmount,0,0)	
 end

 ELSE IF exists(SELECT * from SRO_VT_ACCOUNT..SK_Silk where JID =     [MENTION=292919]user[/MENTION]JID)
 BEGIN
UPDATE SRO_VT_ACCOUNT..SK_Silk set silk_own += SilkAmount WHERE JID = UserJID
 END

do not forgot to add @ i remove it because epvp mention system

[eiron2010]

give me prc works on 5 scroll's
10
50
100
500
1000
Because I do not know to use this

[athena1410]

edit sil k _Point = silk_Point

 Spoiler

IF @ = 41
BEGIN
Select @ = UserJID from SRO_VT_SHARD.._User where CharID = @D

IF (@ItemRefID = xxx) --itemRefID of scroll 10 silk
BEGIN
IF EXISTS (Select * from SRO_VT_ACCOUNT..SK_Silk where JID = @)
BEGIN
UPDATE SRO_VT_ACCOUNT..SK_Silk set silk_own = silk_own + 10 where JID = @
END
ELSE
BEGIN
INSERT INTO SRO_VT_ACCOUNT..SK_Silk(JID,silk_own,silk_gift,sil k_Point)VALUES(UserJID,10,0,0)
END
END

IF (@ItemRefID = xxx) --itemRefID of scroll 50 silk
BEGIN
IF EXISTS (Select * from SRO_VT_ACCOUNT..SK_Silk where JID = @)
BEGIN
UPDATE SRO_VT_ACCOUNT..SK_Silk set silk_own = silk_own + 50 where JID = @
END
ELSE
BEGIN
INSERT INTO SRO_VT_ACCOUNT..SK_Silk(JID,silk_own,silk_gift,sil k_Point)VALUES(UserJID,50,0,0)
END
END

IF (@ItemRefID = xxx) --itemRefID of scroll 100 silk
BEGIN
IF EXISTS (Select * from SRO_VT_ACCOUNT..SK_Silk where JID = @)
BEGIN
UPDATE SRO_VT_ACCOUNT..SK_Silk set silk_own = silk_own + 100 where JID = @
END
ELSE
BEGIN
INSERT INTO SRO_VT_ACCOUNT..SK_Silk(JID,silk_own,silk_gift,sil k_Point)VALUES(UserJID,100,0,0)
END
END

IF (@ItemRefID = xxx) --itemRefID of scroll 500 silk
BEGIN
IF EXISTS (Select * from SRO_VT_ACCOUNT..SK_Silk where JID = @)
BEGIN
UPDATE SRO_VT_ACCOUNT..SK_Silk set silk_own = silk_own + 500 where JID = @
END
ELSE
BEGIN
INSERT INTO SRO_VT_ACCOUNT..SK_Silk(JID,silk_own,silk_gift,sil k_Point)VALUES(UserJID,500,0,0)
END
END

IF (@ItemRefID = xxx) --itemRefID of scroll 1000 silk
BEGIN
IF EXISTS (Select * from SRO_VT_ACCOUNT..SK_Silk where JID = @)
BEGIN
UPDATE SRO_VT_ACCOUNT..SK_Silk set silk_own = silk_own + 1000 where JID = @
END
ELSE
BEGIN
INSERT INTO SRO_VT_ACCOUNT..SK_Silk(JID,silk_own,silk_gift,sil k_Point)VALUES(UserJID,1000,0,0)
END
END

END