- 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
- 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
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
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
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
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
Wts zszc char with 18 bil and 1000 silk 08/06/2011 - Silkroad Online Trading - 1 Replies Ok i wts an account with a Str bower ff....it had 1000 silk and 18 bil
Its clean thats mean no set or weapon
its on Zszc Water
for more infos and offers contact me here on elitepvpers or on [email protected]
(Explanation) Dont get tricked by the +3 (for 30minutes) silk scroll 12/19/2010 - SRO Guides & Templates - 2 Replies Read the guild notice in the screenshot below, it explains everything.
Not in the mood to type twice, typed once in the guild notice :P .
http://img3.imageshack.us/img3/2812/sro2010121814 453880.jpg
So people, always look at the bottom of the item for the timer before buying an item that you believe is super, otherwise you might regret it 30 minutes later.
Sadly i did not take a screen of the item with timer, but the next time i find another i will, and gonna post it here.
