Silk Scroll - 1000

Page 1 of 5 1 23 Last »
06/16/2014 19:00 AceSpace#1
Hi,

I have decided to release this after seeing 3 members requesting it. Thread; [Only registered and activated users can see links. Click Here To Register...]

Whatever.

Database;

- RefObjCommon:
Code:
1	36790	ITEM_SILK_SCROLL_1000	?????	xxx	SN_ITEM_SILK_SCROLL_1000	SN_ITEM_SILK_SCROLL_1000_TT_DESC	1	0	3	3	3	1	180000	3	0	1	1	1	255	0	1	0	0	1	0	100	0	0	0	0	0	-1	0	-1	0	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	xxx	item\etc\drop_mall_scroll.bsr	item\etc\silk_scroll.ddj	xxx	xxx	26713
- RefObjItem:
Code:
26713	1	2	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1000	????	1	??????                                                                                                                           	-1	RESURRECT	1000	COOLTIME:0x00000000	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	0	0	0
- AddLogItem: "Put this at the end of the procedure"
Code:
IF @Operation = 16 AND @ItemRefID = 36790
BEGIN
DECLARE @JID INT,
        @Silk INT = 1000;
 
SET @JID = UserJID FROM SRO_VT_ACCOUNT.._User WHERE CharID = @CharID
 
IF EXISTS (SELECT JID FROM SRO_VT_ACCOUNT..SK_Silk WHERE JID = @JID)
BEGIN
UPDATE SRO_VT_ACCOUNT..SK_Silk
SET silk_own += @Silk
WHERE JID = @JID
END
ELSE
BEGIN
INSERT INTO SRO_VT_ACCOUNT..SK_Silk
SELECT @JID, @Silk, 0, 0
END
END
Multi scroll(100, 300, 500, 1000)

Code:
IF @Operation = 16 AND @ItemRefID IN (37666,37667,37668,37669)
BEGIN
DECLARE @JID INT,
        @Silk INT = 0;
 
SET @Silk = CASE
          WHEN @ItemRefID = 37666
          THEN 100
          WHEN @ItemRefID = 37667
          THEN 300
          WHEN @ItemRefID = 37668
          THEN 500
          WHEN @ItemRefID = 37669
          THEN 1000
          ELSE 0
END
SET @JID = UserJID FROM SRO_VT_ACCOUNT.._User WHERE CharID = @CharID
 
IF EXISTS (SELECT JID FROM SRO_VT_ACCOUNT..SK_Silk WHERE JID = @JID)
BEGIN
UPDATE SRO_VT_ACCOUNT..SK_Silk
SET silk_own += @Silk
WHERE JID = @JID
END
ELSE
BEGIN
INSERT INTO SRO_VT_ACCOUNT..SK_Silk
SELECT @JID, @Silk, 0, 0
END
END
__________________________________________________ ___

Media;

itemdata_45000:
Code:
1	36790	ITEM_SILK_SCROLL_1000	?????	xxx	SN_ITEM_SILK_SCROLL_1000	SN_ITEM_SILK_SCROLL_1000_TT_DESC	1	0	3	3	3	1	180000	3	0	1	1	1	255	0	1	0	0	1	0	1000	0	0	0	0	0	-1	0	-1	0	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	xxx	item\etc\drop_mall_scroll.bsr	item\etc\silk_scroll.ddj	xxx	xxx	1	2	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1000	????	1	??????                                                                                                                           	-1	RESURRECT	1000	COOLTIME:0x00000000	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	0	0
textdata_object:
Code:
1	SN_ITEM_SILK_SCROLL_1000								Silk Scroll
1	SN_ITEM_SILK_SCROLL_1000_TT_DESC								You will receive 1000 silks

~ I don't really know If this was released before. Just in case you say so.

Thank you!
06/18/2014 03:28 PortalDark#2
#Approved
06/18/2014 07:06 bares1993#3
ty bro

but it gives only 1000 Silk ?

Can you make a scroll like Lottery?

For exampel...If i click on scroll it gives (500 or 1000 or 10000 or 6000 or 700000 Silk)
(Depends on luck)

understand what i mean?
06/18/2014 09:50 omdaelnagy#4
i will release it for you lottery silk scroll
06/18/2014 11:16 Crue*#5
Quote:
Originally Posted by bares1993 View Post
ty bro

but it gives only 1000 Silk ?

Can you make a scroll like Lottery?

For exampel...If i click on scroll it gives (500 or 1000 or 10000 or 6000 or 700000 Silk)
(Depends on luck)

understand what i mean?
use your brain =)
06/18/2014 13:49 Ṃ„ŘέŦЏŔŊ®#6
ThX Bro
06/18/2014 22:19 TheRealHero#7
Quote:
Originally Posted by ²²Rock²² View Post
Hi,

I have decided to release this after seeing 3 members requesting it. Thread; [Only registered and activated users can see links. Click Here To Register...]

Whatever.

Database;

- RefObjCommon:
Code:
1	36790	ITEM_SILK_SCROLL_1000	?????	xxx	SN_ITEM_SILK_SCROLL_1000	SN_ITEM_SILK_SCROLL_1000_TT_DESC	1	0	3	3	3	1	180000	3	0	1	1	1	255	0	1	0	0	1	0	100	0	0	0	0	0	-1	0	-1	0	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	xxx	item\etc\drop_mall_scroll.bsr	item\etc\silk_scroll.ddj	xxx	xxx	26713
- RefObjItem:
Code:
26713	1	2	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1000	????	1	??????                                                                                                                           	-1	RESURRECT	1000	COOLTIME:0x00000000	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	0	0	0
- AddLogItem: "Put this at the end of the procedure"
Code:
IF @Operation = 41
BEGIN
IF @ItemRefID = 36790
BEGIN
declare @JID int,
@Silk int

Select @Silk = 1000
Select @JID = UserJID from SRO_VT_SHARD.._User where CharID = @CharID

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

Media;

itemdata_45000:
Code:
1	36790	ITEM_SILK_SCROLL_1000	?????	xxx	SN_ITEM_SILK_SCROLL_1000	SN_ITEM_SILK_SCROLL_1000_TT_DESC	1	0	3	3	3	1	180000	3	0	1	1	1	255	0	1	0	0	1	0	1000	0	0	0	0	0	-1	0	-1	0	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	xxx	item\etc\drop_mall_scroll.bsr	item\etc\silk_scroll.ddj	xxx	xxx	1	2	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1000	????	1	??????                                                                                                                           	-1	RESURRECT	1000	COOLTIME:0x00000000	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	0	0
textdata_object:
Code:
1	SN_ITEM_SILK_SCROLL_1000								Silk Scroll
1	SN_ITEM_SILK_SCROLL_1000_TT_DESC								You will receive 1000 silks

~ I don't really know If this was released before. Just in case you say so.

Thank you!
Thanks a lot.

Quote:
Originally Posted by Crue* View Post
use your brain =)
kids nowadays....
06/19/2014 03:14 Eslam Galull#8
Quote:
Originally Posted by bares1993 View Post
ty bro

but it gives only 1000 Silk ?

Can you make a scroll like Lottery?

For exampel...If i click on scroll it gives (500 or 1000 or 10000 or 6000 or 700000 Silk)
(Depends on luck)

understand what i mean?
use ur Brain.exe >> this comment i always get from Kids or Unknowers xD dont mind bro xD

Use if(Select bla bla )
and use the amout of silk as player lucky Day .. For Exampl if he have a 500 Silk Use The Update Link To Give Him a 1k
if he >500 give him ?? ,,, and what ever amounts you wanna

its Depends On the Current Silk amount ..


Another idea
You Can Make Luck of this Scroll Depends On hwanlvl Mode Number
Or Ranking Number From RankingTable

Or For Premium Lucky Number From TimeJob Table i dont remmber which line premium saves lucky

hope my ideas make a way To ur Target xd
06/19/2014 05:27 geomangy#9
Take It Easy Dude

Code:
IF ( @Operation = 41 and @ItemRefID = 36790 )
BEGIN
declare @JID int
Set @JID = UserJID from SRO_VT_SHARD.._User where CharID = @CharID
UPDATE SRO_VT_ACCOUNT..SK_Silk set silk_own = silk_own +1000 where JID = @JID
end
06/19/2014 12:07 Crue*#10
Quote:
Originally Posted by its.soul View Post
use ur Brain.exe >> this comment i always get from Kids or Unknowers xD dont mind bro xD

Use if(Select bla bla )
and use the amout of silk as player lucky Day .. For Exampl if he have a 500 Silk Use The Update Link To Give Him a 1k
if he >500 give him ?? ,,, and what ever amounts you wanna

its Depends On the Current Silk amount ..


Another idea
You Can Make Luck of this Scroll Depends On hwanlvl Mode Number
Or Ranking Number From RankingTable

Or For Premium Lucky Number From TimeJob Table i dont remmber which line premium saves lucky

hope my ideas make a way To ur Target xd
yes yes bro you're very prof
ignore the haters who like me
06/19/2014 12:59 @$$#11
Random SIlk

IF(@JobID= '787879')
BEGIN
DECLARE @USERJID int = (SELECT USERJID FROM SRO_VT_SHARD.dbo._USER WHERE CHARID = @CharID);
DECLARE @Random INT;
DECLARE @Upper INT;
DECLARE @Lower INT;

SET @Lower = 100 -- The lowest random number
SET @Upper = 10000 -- The highest random number
SET @Random = ROUND(((@Upper - @Lower -1) * RAND() + @Lower), 0)

IF (SELECT COUNT(*) FROM SRO_VT_ACCOUNT.dbo.SK_SILK WHERE JID = @USERJID) > 0
UPDATE SRO_VT_ACCOUNT.dbo.SK_Silk SET SILK_OWN = SILK_OWN + @Random WHERE JID = @USERJID;

IF (SELECT COUNT(*) FROM SRO_VT_ACCOUNT.dbo.SK_SILK WHERE JID = @USERJID) = 0
INSERT INTO SRO_VT_ACCOUNT.dbo.SK_Silk (JID,silk_gift,silk_own,silk_point)
values (@USERJID,0,@Random,0);
END
06/20/2014 03:06 Satanic Road Dev#12
good work
06/21/2014 21:57 Little Messi#13
well, added, but when i use it , it teleports me but no silks given !! can you tell me wats wrong ?
06/22/2014 00:56 @$$#14
Quote:
Originally Posted by Little Messi View Post
well, added, but when i use it , it teleports me but no silks given !! can you tell me wats wrong ?
Check addlogchar Proc
06/22/2014 01:06 Little Messi#15
Quote:
Originally Posted by @$$ View Post
Check addlogchar Proc
when i excute it , it said succ
Page 1 of 5 1 23 Last »