Register for your free account! | Forgot your password?

Go Back   elitepvpers > Popular Games > Silkroad Online > SRO Private Server
You last visited: Today at 10:36

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement



Somebody help me fix Silk system

Discussion on Somebody help me fix Silk system within the SRO Private Server forum part of the Silkroad Online category.

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Sep 2018
Posts: 38
Received Thanks: 0
Somebody help me fix Silk system

I used Athena filter. But Reward silk system per hour is not working..
https://i.imgur.com/VYJHLRM.jpg
https://i.imgur.com/vMLypmn.jpg
And procedure here


USE [ATHENA]
GO
/****** Object: StoredProcedure [dbo].[_RewardSystem] Script Date: 6/17/2019 1:20:38 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[_RewardSystem]
@erID varchar(64),
@_level int,
@ID varchar(64),
@Level int
AS

BEGIN
/*
EXAMPLE CODE, FOR REWARD LEVEL RESTRICT
IF @_level < 100)
BEGIN
RETURN;
END
*/


DECLARE @ bigint = (SELECT JID FROM [SRO_VT_ACCOUNT].[dbo].[TB_User] WITH(NOLOCK) WHERE StrUserID = @erID);


IF NOT EXISTS(SELECT JID FROM [SRO_VT_ACCOUNT].[dbo].[SK_silk] WITH(NOLOCK) WHERE JID = @)
BEGIN
--- INSERT THEIR SHIT
INSERT INTO [SRO_VT_ACCOUNT].[dbo].[SK_silk] (JID, silk_own, silk_gift, silk_point) VALUES @, 0, 0, 0);
END

/*
EXAMPLE CODE:
IF @level BETWEEN 0 AND 50)
BEGIN
-- Higher reward for level 0-50?
SET @Level = 32;
END
*/

IF @ID = 'silk')
BEGIN
UPDATE [SRO_VT_ACCOUNT].[dbo].[SK_silk] SET silk_own = (silk_own + @Level) WHERE JID = @;
END

ELSE IF @ID = 'gift')
BEGIN
--- fyll refund oqe?
UPDATE [SRO_VT_ACCOUNT].[dbo].[SK_silk] SET silk_gift = (silk_gift + @Level) WHERE JID = @;
END

ELSE IF @ID = 'point')
BEGIN
UPDATE [SRO_VT_ACCOUNT].[dbo].[SK_silk] SET silk_point = (silk_point + @Level) WHERE JID = @;
END

ELSE
BEGIN
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN_CHEST] @, @ID, 0, @Level;
END
END

Solved

Quote:
Originally Posted by ntabkpro View Post
I used Athena filter. But Reward silk system per hour is not working..
https://i.imgur.com/VYJHLRM.jpg
https://i.imgur.com/vMLypmn.jpg
And procedure here


USE [ATHENA]
GO
/****** Object: StoredProcedure [dbo].[_RewardSystem] Script Date: 6/17/2019 1:20:38 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[_RewardSystem]
@erID varchar(64),
@_level int,
@ID varchar(64),
@Level int
AS

BEGIN
/*
EXAMPLE CODE, FOR REWARD LEVEL RESTRICT
IF @_level < 100)
BEGIN
RETURN;
END
*/


DECLARE @ bigint = (SELECT JID FROM [SRO_VT_ACCOUNT].[dbo].[TB_User] WITH(NOLOCK) WHERE StrUserID = @erID);


IF NOT EXISTS(SELECT JID FROM [SRO_VT_ACCOUNT].[dbo].[SK_silk] WITH(NOLOCK) WHERE JID = @)
BEGIN
--- INSERT THEIR SHIT
INSERT INTO [SRO_VT_ACCOUNT].[dbo].[SK_silk] (JID, silk_own, silk_gift, silk_point) VALUES @, 0, 0, 0);
END

/*
EXAMPLE CODE:
IF @level BETWEEN 0 AND 50)
BEGIN
-- Higher reward for level 0-50?
SET @Level = 32;
END
*/

IF @ID = 'silk')
BEGIN
UPDATE [SRO_VT_ACCOUNT].[dbo].[SK_silk] SET silk_own = (silk_own + @Level) WHERE JID = @;
END

ELSE IF @ID = 'gift')
BEGIN
--- fyll refund oqe?
UPDATE [SRO_VT_ACCOUNT].[dbo].[SK_silk] SET silk_gift = (silk_gift + @Level) WHERE JID = @;
END

ELSE IF @ID = 'point')
BEGIN
UPDATE [SRO_VT_ACCOUNT].[dbo].[SK_silk] SET silk_point = (silk_point + @Level) WHERE JID = @;
END

ELSE
BEGIN
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN_CHEST] @, @ID, 0, @Level;
END
END



ntabkpro is offline  
Old 06/16/2019, 23:53   #2
 
elite*gold: 0
Join Date: Oct 2014
Posts: 200
Received Thanks: 27
bro you do every 1 mint give you 1 silk do the time every 60mint or 59 1=60 sec not 1h


revldo1 is offline  
Old 06/18/2019, 01:06   #3
 
elite*gold: 0
Join Date: Apr 2011
Posts: 22
Received Thanks: 4
Better use filter
arg3n7s is offline  
Old 06/25/2019, 22:27   #4



 
elite*gold: 586
Join Date: Mar 2010
Posts: 357
Received Thanks: 244
Quote:
Originally Posted by ntabkpro View Post
I used Athena filter. But Reward silk system per hour is not working..
https://i.imgur.com/VYJHLRM.jpg
https://i.imgur.com/vMLypmn.jpg
And procedure here


USE [ATHENA]
GO
/****** Object: StoredProcedure [dbo].[_RewardSystem] Script Date: 6/17/2019 1:20:38 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[_RewardSystem]
@erID varchar(64),
@_level int,
@ID varchar(64),
@Level int
AS

BEGIN
/*
EXAMPLE CODE, FOR REWARD LEVEL RESTRICT
IF @_level < 100)
BEGIN
RETURN;
END
*/


DECLARE @ bigint = (SELECT JID FROM [SRO_VT_ACCOUNT].[dbo].[TB_User] WITH(NOLOCK) WHERE StrUserID = @erID);


IF NOT EXISTS(SELECT JID FROM [SRO_VT_ACCOUNT].[dbo].[SK_silk] WITH(NOLOCK) WHERE JID = @)
BEGIN
--- INSERT THEIR SHIT
INSERT INTO [SRO_VT_ACCOUNT].[dbo].[SK_silk] (JID, silk_own, silk_gift, silk_point) VALUES @, 0, 0, 0);
END

/*
EXAMPLE CODE:
IF @level BETWEEN 0 AND 50)
BEGIN
-- Higher reward for level 0-50?
SET @Level = 32;
END
*/

IF @ID = 'silk')
BEGIN
UPDATE [SRO_VT_ACCOUNT].[dbo].[SK_silk] SET silk_own = (silk_own + @Level) WHERE JID = @;
END

ELSE IF @ID = 'gift')
BEGIN
--- fyll refund oqe?
UPDATE [SRO_VT_ACCOUNT].[dbo].[SK_silk] SET silk_gift = (silk_gift + @Level) WHERE JID = @;
END

ELSE IF @ID = 'point')
BEGIN
UPDATE [SRO_VT_ACCOUNT].[dbo].[SK_silk] SET silk_point = (silk_point + @Level) WHERE JID = @;
END

ELSE
BEGIN
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN_CHEST] @, @ID, 0, @Level;
END
END

Solved


use Silk/h program is good
Dryes* is offline  
Reply



« what a regionID of this pls ? | GrabPet Bug »

Similar Threads
Revive-SRO [Pve-Pvp] [Egy A System] [System Coin & Silk] [Hard exp] [Silk/Hour]
06/28/2016 - SRO PServer Advertising - 1 Replies
Revive-SRO Site: ReviveSRO Online | PVE Server Cap 110 http://i.epvpimg.com/QpDlc.png http://i.epvpimg.com/ElOHg.png http://i.epvpimg.com/55QDe.png
TheaSro 90 Cap PVE| New Silk System| Old Drop System|Play Win Silk
09/18/2014 - SRO PServer Advertising - 41 Replies
#delete
[04.09.13] GigaByte v2.6 [FIX, FIX, FIX, FIX AND FIX]
09/11/2013 - WarRock Hacks, Bots, Cheats & Exploits - 79 Replies
http://www.elitepvpers.com/forum/warrock-hacks-bot s-cheats-exploits/2843300-11-09-gigabyte-public-v2 -7-a.html
CAN ANYBODY GIVE ME SOMEBODY SOMEBODY TO DL
06/01/2010 - Grand Chase Philippines - 0 Replies
PAHINGE PO AKO NG SEASON 2 KASI I THINK AKO NA ALNG MAG UUPLOAD NG SEASON 3 SA MEDIA FIRE 3 LOPTOP NAMAN GAMIT KO EHH SO YUNG ISA SA UPLOAD YUNG ISA SA PLAY PERO WALA PA AKO SEASON 2 NAWALA EHH COULD ANYBODY GIVE ME???:mofo:;):pimp::p



All times are GMT +2. The time now is 10:36.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

BTC: 33E6kMtxYa7dApCFzrS3Jb7U3NrVvo8nsK
ETH: 0xc6ec801B7563A4376751F33b0573308aDa611E05

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2019 elitepvpers All Rights Reserved.