mido22421
18-09-2016, 11:12 PM
Auto Events party number :-
http://i.epvpimg.com/LJvXe.png
http://i.epvpimg.com/lutfg.png
https://files.fm/u/eqvgde7r
https://www.virustotal.com/en/file/0eba63da286cdde0ded268f19ead3ae8ad578bc8f50f941af9 5965a3fcf1fc8e/analysis/1474197921/
CREATE PROCEDURE _ADD_Reward
-- =============================================
/*
ADD Silk Procedure --khaleed2010
*/
-- =============================================
@NumberReward INT,
@CharName16 VARCHAR(512),
@RewardName
AS
if (@RewardName = 'Silk')
BEGIN
Declare @UserID int = (select UserJID from SRO_VT_SHARD.dbo._User where CharID = (SELECT CharID FROM SRO_VT_SHARD.dbo._Char where CharName16 = @CharName16))
IF EXISTS (Select * From SRO_VT_ACCOUNT.dbo.SK_Silk Where JID = @UserID)
BEGIN
UPDATE SRO_VT_ACCOUNT.dbo.SK_Silk set silk_own = silk_own + @NumberReward where JID = @UserID
END
ELSE
BEGIN
INSERT SRO_VT_ACCOUNT.dbo.SK_Silk (JID,silk_own,silk_gift,silk_point) Values (@UserID,@NumberReward,0,0)
END
END
if (@RewardName = 'Arena')
BEGIN
EXEC SRO_VT_SHARD.._ADD_ITEM_EXTERN @CharName16,'ITEM_ETC_ARENA_COIN',@NumberReward,0
END
http://i.epvpimg.com/LJvXe.png
http://i.epvpimg.com/lutfg.png
https://files.fm/u/eqvgde7r
https://www.virustotal.com/en/file/0eba63da286cdde0ded268f19ead3ae8ad578bc8f50f941af9 5965a3fcf1fc8e/analysis/1474197921/
CREATE PROCEDURE _ADD_Reward
-- =============================================
/*
ADD Silk Procedure --khaleed2010
*/
-- =============================================
@NumberReward INT,
@CharName16 VARCHAR(512),
@RewardName
AS
if (@RewardName = 'Silk')
BEGIN
Declare @UserID int = (select UserJID from SRO_VT_SHARD.dbo._User where CharID = (SELECT CharID FROM SRO_VT_SHARD.dbo._Char where CharName16 = @CharName16))
IF EXISTS (Select * From SRO_VT_ACCOUNT.dbo.SK_Silk Where JID = @UserID)
BEGIN
UPDATE SRO_VT_ACCOUNT.dbo.SK_Silk set silk_own = silk_own + @NumberReward where JID = @UserID
END
ELSE
BEGIN
INSERT SRO_VT_ACCOUNT.dbo.SK_Silk (JID,silk_own,silk_gift,silk_point) Values (@UserID,@NumberReward,0,0)
END
END
if (@RewardName = 'Arena')
BEGIN
EXEC SRO_VT_SHARD.._ADD_ITEM_EXTERN @CharName16,'ITEM_ETC_ARENA_COIN',@NumberReward,0
END