Random Silk script Based on Skill

[NorseGodTyr]

Hey Community
Some People ask me for help and if i share my Random Silk script ... based via a skill Lower INT = 1 is min 1 Silk and Upper INT = 999 is max silk ! if any Player using the skill he will get random silk 1-999

----NorseGodTyr Random Silk
		DECLARE @USERID varchar(64) = 
		(Select StrUserID from SRO_VT_ACCOUNT.dbo.TB_User U inner join SRO_VT_SHARD.dbo._User Z
		WITH(NOLOCK) ON Z.UserJID =  U.JID 
		WHERE  Z.CharID = @Charid)
		, @Charname varchar(52) = (SELECT CharName16 FROM _Char WITH(NOLOCK) WHERE CharID = @CharID)
		DECLARE   @Upper INT = 999
				, @Lower INT = 1 
				, @Random INT 
		SELECT @Random = ROUND(((@Upper - @Lower -1) * RAND() + @Lower), 0)
		if(@JobID = '50035') -- Skill Silk Scrolls Lotterys
		begin
		--1--
		EXEC SRO_VT_ACCOUNT.[CGI].[CGI_WebPurchaseSilk] 7,@UserID,7,@Random/*Silks Count*/,30
		END
---------------------------

@JobID = '50035' is SkillID

[Leodoom]

Thank you and add this to your subject if you notice
Random Gold

 Spoiler

IF (@Operation = 41) -- Procedure By LeoDoom
BEGIN
IF (@ItemRefID = 98456)
BEGIN
declare @Charname varchar(128)
declare @upper_RI3O int = '1000000' declare @lower_RI3O int = '100000000'
declare @random_RI3O int = ROUND(((@upper_RI3O - @lower_RI3O -1) * RAND() + @lower_RI3O), 0)
set @charname = (select CharName16 from SRO_VT_SHARD.dbo._Char where CharID=@CharID)
Update SRO_VT_SHARD.dbo._Char set RemainGold = RemainGold + @random_RI3O where CharName16 = @charname
end
end

[NorseGodTyr]

Originally Posted by Leodoom

Thank you and add this to your subject if you notice
Random Gold

 Spoiler

IF (@Operation = 41) -- Procedure By LeoDoom
BEGIN
IF (@ItemRefID = 98456)
BEGIN
declare @Charname varchar(128)
declare @upper_RI3O int = '1000000' declare @lower_RI3O int = '100000000'
declare @random_RI3O int = ROUND(((@upper_RI3O - @lower_RI3O -1) * RAND() + @lower_RI3O), 0)
set @charname = (select CharName16 from SRO_VT_SHARD.dbo._Char where CharID=@CharID)
Update SRO_VT_SHARD.dbo._Char set RemainGold = RemainGold + @random_RI3O where CharName16 = @charname
end
end

Random Gold script is *** times shared via a scroll


my script is based via a skill
and here is no People who share random silk script

[Ryotic]

Both of them in elyson db but thanks

Sent from my Redmi Note 5 using Tapatalk

[NorseGodTyr]

Originally Posted by legendworld

Both of them in elyson db but thanks

Sent from my Redmi Note 5 using Tapatalk

If it exists, why do many people ask for it? and i don't see a release about this script

[Klito*]

Nice dude

[Devsome]

Originally Posted by NorseGodTyr

If it exists, why do many people ask for it? and i don't see a release about this script

Because silkroad community is greedy.

[NorseGodTyr]

Originally Posted by Devsome

Because silkroad community is greedy.

Das wird es wohl sein
Gibt zu viele die dafür Geld haben wollen und deswegen nicht Sharen !!
Aber es gibt auch einige die freundlich sind

[Worshiper]

nice !!