Help With Proc

09/02/2017 06:02 eiron2010#1

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

please i want proc Works on 10 scroll's

09/02/2017 10:06 KingDollar#2

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

Code:

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

Code:

 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

09/02/2017 15:17 eiron2010#3

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

09/03/2017 15:23 athena1410#4

edit sil k _Point = silk_Point

Spoiler