- Joined
- Jul 18, 2009
- Messages
- 658
- Reaction score
- 75
anyone can share this stored procedure
user_gametimecvt
user_gametimecvt
Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!
Join Today!Function invisible in skill is not working, can please help me where can I find it in source to enable
Compiling LG-7 IN GAME RANKINGS. TO BE RELEASED SOON
LG-7 Source has no problem at all but the IP LOCK.
How to fix after an hour ranking gone? It will not show again, it needs to restart the server to show up again. Thanks.
share source of your ranking so maybe anyone can make it work.
/****** 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
no not the points i don't have a problem with it what imean is the item stock
like this one .
You must be registered to see links
do you still have this problem?
no not the points i don't have a problem with it what imean is the item stock
like this one .
You must be registered to see links
do you still have this problem?
yes sir