12-02-2014, 01:04 AM
|
#1
|
|
• الانـتـسـاب » Sep 2012
|
• رقـم العـضـويـة » 105332
|
• المشـــاركـات » 319
|
• الـدولـة »
|
• الـهـوايـة » Hex,PHP,C#,SQL
|
• اسـم الـسـيـرفـر » No Server
|
• الـجـنـس » Male
|
• نقـاط التقييم » 258
|
|
|
Change Silk system from Normal silk to Silk Gift or Silk Point
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
كود PHP:
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
كود PHP:
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
|
|
|