/****** Object: StoredProcedure [dbo].[user_gametimecvt] Script Date: 6/18/2021 5:43:44 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[user_gametimecvt]
@szUserID varchar (33),
@nReturn int OUTPUT
AS
SET NOCOUNT ON
DECLARE
-- Declare variables used in error checking.
[USER=116066]ERROR[/USER]_var int,
[USER=349225]Row[/USER]count_var int,
[USER=77438]Nuser[/USER]Num int,
@nGameTime int,
@nGameTimeDiv int,
@nGameTimeRes int,
@vUserName varchar(33),
[USER=531890]Minute[/USER]s int,
@Total int,
@PMinutes int,
@PTotal int,
@wa int,
[USER=2000285344]sago[/USER]t int,
[USER=2000285344]sago[/USER]t1 int,
[USER=2000285344]sago[/USER]t2 int,
@after int,
@af1 int,
@af2 int,
@pafter int,
@BP int
--set your configuration here
SET @nGameTimeDiv = 60;
SET @nGameTimeRes = 2;
SELECT [USER=77438]Nuser[/USER]Num = UserNum , @vUserName = UserID , @nGameTime = PlayTime , @BP = UserPoint2 From UserInfo Where UserName = @szUserID
--calculate
SET [USER=531890]Minute[/USER]s = @nGameTime / @nGameTimeDiv;
SET @Total = [USER=531890]Minute[/USER]s
SET @PMinutes = @nGameTime/@nGameTimeDiv;
SET @PTotal = @PMinutes;
--conversion
SET @wa=@nGameTime/@nGameTimeDiv;
SET [USER=2000285344]sago[/USER]t=@wa;
SET [USER=2000285344]sago[/USER]t1 [USER=2000285344]sago[/USER]t*@nGameTimeDiv;
SET [USER=2000285344]sago[/USER]t2 [USER=2000285344]sago[/USER]t*@nGameTimeRes;
--FOR LOG
SET @after = @nGameTime - [USER=2000285344]sago[/USER]t1;
SET @af1=@after/@nGameTimeDiv
SET @af2=@af1;
SET @pafter = @BP + [USER=2000285344]sago[/USER]t2;
SELECT [USER=116066]ERROR[/USER]_var = [USER=116066]ERROR[/USER], [USER=349225]Row[/USER]count_var = [USER=349225]Row[/USER]COUNT
IF [USER=77438]Nuser[/USER]Num !=0
BEGIN
IF @nGameTime >= @nGameTimeDiv
BEGIN
-- update point
UPDATE dbo.UserInfo
SET UserPoint2 = UserPoint2 + [USER=2000285344]sago[/USER]t2 , PlayTime = PlayTime - [USER=2000285344]sago[/USER]t1 WHERE UserName = @szUserID
SET @nReturn = [USER=77438]Nuser[/USER]Num
RETURN @nReturn
END
ELSE
BEGIN
SET @nReturn = 0
RETURN @nReturn
END
END
ELSE
BEGIN
SET @nReturn = 0
RETURN @nReturn
END
SET NOCOUNT OFF
RETURN @nReturn
GO