Yui
12-02-2014, 01:04 AM
Hello Silkroad4arab
Back again with small change in silk system per hour
some people ask me about how can change free silk = Normal silk to Silk Gift or Silk Point
for silk_gift Use
USE [SRO_VT_ACCOUNT]
GO
/****** Object: StoredProcedure [dbo].[_extraSilk] Script Date: 11/02/2014 11:42:55 م ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[_extraSilk] /*by Yui*/
@CharID int,
@Silk int
as
Declare @JID int, @Multiplier int = (SELECT [Silk/Hour] FROM SRO_VT_SHARDLOG.dbo._OnlineOffline WHERE CharID = @CharID);
SET @JID = (
SELECT usert.UserJID FROM SRO_VT_SHARD.dbo._User as usert
JOIN SRO_VT_SHARD.dbo._Char as chart on usert.CharID = chart.CharID
WHERE chart.CharID = @CharID
);
IF not exists (SELECT JID FROM SK_Silk WHERE JID = @JID)
BEGIN
INSERT INTO SK_Silk SELECT @JID, 0, 0, 0
END
UPDATE SK_Silk
SET silk_gift = silk_gift + (@Silk*@Multiplier)
WHERE JID = @JID
For silk_point Use
USE [SRO_VT_ACCOUNT]
GO
/****** Object: StoredProcedure [dbo].[_extraSilk] Script Date: 11/02/2014 11:42:55 م ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[_extraSilk] /*by Yuii*/
@CharID int,
@Silk int
as
Declare @JID int, @Multiplier int = (SELECT [Silk/Hour] FROM SRO_VT_SHARDLOG.dbo._OnlineOffline WHERE CharID = @CharID);
SET @JID = (
SELECT usert.UserJID FROM SRO_VT_SHARD.dbo._User as usert
JOIN SRO_VT_SHARD.dbo._Char as chart on usert.CharID = chart.CharID
WHERE chart.CharID = @CharID
);
IF not exists (SELECT JID FROM SK_Silk WHERE JID = @JID)
BEGIN
INSERT INTO SK_Silk SELECT @JID, 0, 0, 0
END
UPDATE SK_Silk
SET silk_point = silk_point + (@Silk*@Multiplier)
WHERE JID = @JID
New System free item per hour coming soon
Notice : This Query for unsing only for who use New silk System auto free Silk/Hour based on the Online time
Back again with small change in silk system per hour
some people ask me about how can change free silk = Normal silk to Silk Gift or Silk Point
for silk_gift Use
USE [SRO_VT_ACCOUNT]
GO
/****** Object: StoredProcedure [dbo].[_extraSilk] Script Date: 11/02/2014 11:42:55 م ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[_extraSilk] /*by Yui*/
@CharID int,
@Silk int
as
Declare @JID int, @Multiplier int = (SELECT [Silk/Hour] FROM SRO_VT_SHARDLOG.dbo._OnlineOffline WHERE CharID = @CharID);
SET @JID = (
SELECT usert.UserJID FROM SRO_VT_SHARD.dbo._User as usert
JOIN SRO_VT_SHARD.dbo._Char as chart on usert.CharID = chart.CharID
WHERE chart.CharID = @CharID
);
IF not exists (SELECT JID FROM SK_Silk WHERE JID = @JID)
BEGIN
INSERT INTO SK_Silk SELECT @JID, 0, 0, 0
END
UPDATE SK_Silk
SET silk_gift = silk_gift + (@Silk*@Multiplier)
WHERE JID = @JID
For silk_point Use
USE [SRO_VT_ACCOUNT]
GO
/****** Object: StoredProcedure [dbo].[_extraSilk] Script Date: 11/02/2014 11:42:55 م ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[_extraSilk] /*by Yuii*/
@CharID int,
@Silk int
as
Declare @JID int, @Multiplier int = (SELECT [Silk/Hour] FROM SRO_VT_SHARDLOG.dbo._OnlineOffline WHERE CharID = @CharID);
SET @JID = (
SELECT usert.UserJID FROM SRO_VT_SHARD.dbo._User as usert
JOIN SRO_VT_SHARD.dbo._Char as chart on usert.CharID = chart.CharID
WHERE chart.CharID = @CharID
);
IF not exists (SELECT JID FROM SK_Silk WHERE JID = @JID)
BEGIN
INSERT INTO SK_Silk SELECT @JID, 0, 0, 0
END
UPDATE SK_Silk
SET silk_point = silk_point + (@Silk*@Multiplier)
WHERE JID = @JID
New System free item per hour coming soon
Notice : This Query for unsing only for who use New silk System auto free Silk/Hour based on the Online time