Random Silk script Based on Skill

01/25/2019 11:02 NorseGodTyr#1

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

HTML Code:

----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

01/25/2019 14:30 Leodoom#2

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

Spoiler

01/25/2019 14:33 NorseGodTyr#3

Quote:

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 xXx times shared via a scroll

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

01/25/2019 14:51 Ryotic#4

Both of them in elyson db but thanks

Sent from my Redmi Note 5 using Tapatalk

01/25/2019 15:01 NorseGodTyr#5

Quote:

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

01/25/2019 19:14 Klito*#6

Nice dude

01/25/2019 19:22 Devsome#7

Quote:

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.

01/25/2019 19:33 NorseGodTyr#8

Quote:

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 :)

01/25/2019 20:39 Worshiper#9

nice !!