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