[Release] Silk Ruffle Scroll [Best Performance]

USE [SRO_VT_ERIUS]
GO
/****** Object:  StoredProcedure [dbo].[Ed_SilkRuffle]    Script Date: 7/29/2017 7:36:03 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[Ed_SilkRuffle]
@CharID INT
AS
DECLARE @CharName varchar(max)
SELECT @CharName = (SELECT CharName16 FROM SRO_VT_SHARD.._Char WHERE CharID=@CharID)
DECLARE @UserName varchar(max)
DECLARE @Min INT
DECLARE @Max INT
DECLARE @Random INT
DECLARE @Trick_Min INT = 1
DECLARE @Trick_Max INT = 100
DECLARE @Trick INT = (ROUND(((@Trick_Max - @Trick_Min -1) * RAND() + @Trick_Min), 0))
DECLARE @ID INT
if @ID = 1
begin
SELECT @Min = 1
SELECT @Max = CASE
WHEN @Trick between 1 and 70 THEN 30
WHEN @Trick between 71 and 90 THEN 40
WHEN @Trick between 91 and 100 THEN 50
END
SELECT @UserName = (SELECT StrUserID FROM SRO_VT_ACCOUNT..TB_User WHERE JID in (SELECT UserJID FROM SRO_VT_SHARD.._User WHERE CharID = @CharID))
SELECT @Random = (ROUND(((@Max - @Min -1) * RAND() + @Min), 0))
Exec SRO_VT_ACCOUNT.CGI.CGI_WebPurchaseSilk null,@UserName,null,@Random,null
insert into BOT_Default values (3,'You have Earned ['+(Cast(@Random as varchar))+'] Silks Randomly.',@CharName,0)
End

IF (@Operation = 41) and (@ItemRefID = 50235) 
   begin
   exec SRO_VT_ERIUS.dbo.Ed_SilkRuffle @CharId
   end