[CEPNİ]

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

  set point + ? idediginiz rakamla degiş

git PS_UserData > Programability > StoredProcedure > click sag aç USP_Try_GameLogout_R and "Modify" türkçe olarak anlamayana bu işlemleri slq database üzerinden yapınız

[admin]

Yararlı bir paylaşım, teşekkürler.

[yokboy]

Üstteki vermiş oldugun kodu burada hangi bölgeye yazmam gerek ? @CEPNİ

Kod: Tümünü Seç Tümünü Kopyala

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO


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

SET @LogTime = GETDATE()

UPDATE dbo.UserLoginLog SET LogoutTime=@LogTime WHERE UserUID=@UserUID AND SessionID=@SessionID;

/*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

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
*/
SET NOCOUNT OFF

[CEPNİ]

Üstteki vermiş oldugun kodu burada hangi bölgeye yazmam gerek ? @CEPNİ

Kod: Tümünü Seç Tümünü Kopyala

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO


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

SET @LogTime = GETDATE()

UPDATE dbo.UserLoginLog SET LogoutTime=@LogTime WHERE UserUID=@UserUID AND SessionID=@SessionID;

/*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

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
*/
SET NOCOUNT OFF

set yazan bölüme keleyiniz