[Help]Need Correction If This Is Right.

[-ColdBloodShaiya-]

Anyone Wanna Tell Me If Its Correct For AP Per Min?

 Spoiler

USE [PS_UserData]
GO
/****** Object: StoredProcedure [dbo].[usp_Try_GameLogout_R] Script Date: 05/31/2012 13:04:51 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

/****** Object: Stored Procedure dbo.usp_Try_GameLogout_R Script Date: 2008-6-7 18:34:05 ******/
ALTER Proc [dbo].[usp_Try_GameLogout_R]

/*
Created by humanws, 2005-10-18
???? ?? ??
*/

@UserUID int,
@SessionID bigint,
@LogoutType smallint = 0,
@ErrType int = 0

AS

SET NOCOUNT ON

DECLARE @LogTime datetime
DECLARE @Sql nvarchar(4000)
DECLARE @yyyy varchar(4)
DECLARE @mm varchar(2)
DECLARE @dd varchar(2)
DECLARE @LogType bit -- Login:0, Logout:1

SET @LogType = 1
SET @LogTime = GETDATE()
SET @yyyy = DATEPART(yyyy, @LogTime)
SET @mm = DATEPART(mm, @LogTime)
SET @dd = DATEPART(dd, @LogTime)

IF( LEN(@mm) = 1 )
BEGIN
SET @mm = '0' + @mm
END

IF( LEN(@dd) = 1 )
BEGIN
SET @dd = '0' + @dd
END
UPDATE Users_Master SET Leave = 0, LeaveDate = GETDATE() WHERE UserUID = @UserUID

SET @Sql = N'
INSERT INTO PS_GameLog.dbo.UserLog
(SessionID, UserUID, LogType, LogTime, LogoutType, ErrType)
VALUES(@SessionID, @UserUID, @LogType, @LogTime, @LogoutType, @ErrType)'

EXEC sp_executesql @Sql,
N'@SessionID bigint, @UserUID int, @LogType bit, @LogTime datetime, @LogoutType smallint, @ErrType int',
@SessionID, @UserUID, @LogType, @LogTime, @LogoutType, @ErrType
update PS_userdata.dbo.UserLoginStatus
set loginstatus=0,LogoutTime=@LogTime,LogoutSession=@S essionID,LastPlayTime=datediff(minute,LoginTime,@L ogTime)
where useruid=@useruid

DECLARE @LoginTime datetime
DECLARE @LastPlayTime int
DECLARE @OldPoint int
DECLARE @LoginSession bigint
SET @LoginSession=(select LoginSession from PS_userdata.dbo.UserLoginStatus where useruid=@useruid)
SET @LastPlayTime=(select LastPlayTime from PS_userdata.dbo.UserLoginStatus where useruid=@useruid)
SET @LoginTime=(select LoginTime from PS_userdata.dbo.UserLoginStatus where useruid=@useruid)
SET @OldPoint=(select Point from PS_userdata.dbo.Users_Master where useruid=@useruid)
IF (@SessionID=@LoginSession)
BEGIN
Update PS_userdata.dbo.Users_Master
SET point=point +5
WHERE useruid=@useruid
INSERT INTO PS_userdata.dbo.UserOnlineTimeLog(UserUid,OldPoint ,Addpoint,LoginTime,LogoutTime,SessionID)
values(@UserUid,@OldPoint,@LastPlayTime,@LoginTime ,@LogTime,@SessionID)
end
SET NOCOUNT OFF

[R0CK7Y]

Update PS_userdata.dbo.Users_Master
SET point=point +5

its 5 points
you change it

[-ColdBloodShaiya-]

Originally Posted by R0CK7Y

its 5 points
you change it

yea but is it possible to have 5 instead of 1?
and the other looks fine or no?

[R0CK7Y]

why dont you use it and see ? ;0
its easy only wait for one minute and see if it increased by 5 or not

[-ColdBloodShaiya-]

Originally Posted by R0CK7Y

why dont you use it and see ? ;0
its easy only wait for one minute and see if it increased by 5 or not

ok so i have tryied +1 and +5 never wants to take effect something is wrong where it hates my server rofl wanna help me out ep 5database need this to work rofl

[R0CK7Y]

go PS_UserData > Programability > StoredProcedure > click right on USP_Try_GameLogout_R and "Modify" or "Design" (depends of your sql version) where is
Quote:
SET point=point
change with
Quote:
SET point=point +1
Next time use SEARCH BUTTON all is here.

but replace

SET point=point +1

with

SET point=point +5 +@LastPlayTime/2

and tell me if it worked <- i didn't try it btw

[-ColdBloodShaiya-]

Originally Posted by R0CK7Y

but replace

with

and tell me if it worked <- i didn't try it btw

no luck by doing that got cant force data login rofl bad mistake to edit and add that aha