[Release] Simple "Random" Procedures

[Syloxx]

Random Silk:

 Spoiler

PHP Code:

USE SRO_VT_SHARD
Go

--//////////AddRandomSilk V1.0 By Syloxx\\\\\\\\\
CREATE PROCEDURE _AddRandomSilk
@CharID                    INT
AS

    DECLARE @MinSilk    INT = 100,
            @MaxSilk    INT = 100000,
            @RandomSilk    INT,
            @JID        INT

    SELECT @RandomSilk = ROUND(((@MaxSilk - @MinSilk -1) * RAND() + @MinSilk), 0)
        
    SELECT    @JID = UserJID
    FROM    SRO_VT_SHARD.._User
    WHERE    CharID = @CharID
        
        
    IF NOT EXISTS (SELECT @JID FROM SRO_VT_ACCOUNT..SK_Silk)
        BEGIN
            INSERT INTO SRO_VT_ACCOUNT..SK_Silk
            VALUES    (
                    @JID,
                    @RandomSilk,
                    0,
                    0
                    )
        END
        ELSE
        BEGIN
            UPDATE    SRO_VT_ACCOUNT..SK_Silk
            SET        silk_gift += @RandomSilk
            WHERE    JID = @JID
        END 


Random SP:

 Spoiler

PHP Code:

USE SRO_VT_SHARD
Go

--//////////AddRandomSP V1.0 By Syloxx\\\\\\\\\
CREATE PROCEDURE _AddRandomSP
@CharID                INT
AS

    DECLARE @MinSP INT = 100,
            @MaxSP INT = 100000,
            @RandomSP INT

    SELECT @RandomSP = ROUND(((@MaxSP - @MinSP -1) * RAND() + @MinSP), 0)
            
    UPDATE    _Char
    SET        RemainSkillPoint += @RandomSP
    WHERE    CharID = @CharID 


Random Gold:

 Spoiler

PHP Code:

USE SRO_VT_SHARD
Go

--//////////AddRandomGold V1.0 By Syloxx\\\\\\\\\
CREATE PROCEDURE _AddRandomGold
@CharID                INT
AS

    DECLARE @MinGold INT = 100,
            @MaxGold INT = 100000,
            @RandomGold INT

    SELECT @RandomGold = ROUND(((@MaxGold - @MinGold -1) * RAND() + @MinGold), 0)
            
    UPDATE    _Char
    SET        RemainGold += @RandomGold
    WHERE    CharID = @CharID 


[_Joe]

thank you.

[Pure3viL]

thank you <3