SQL FIX for normal player authentication

09.07.2013, 15:29

Been seeing the same question asked over and over about people not being able to log their normal player in, this was a problem I had and Ron was nice enough to help me out so I decided to just make a script to share I hope this helps others out.

Code:

Цитата:

USE [RF_USER]
GO

/****** Object: StoredProcedure [dbo].[pSelect_AccountPass] Script Date: 02/05/2013 10:33:02 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[pSelect_AccountPass]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[pSelect_AccountPass]
GO

USE [RF_USER]
GO

/****** Object: StoredProcedure [dbo].[pSelect_AccountPass] Script Date: 02/05/2013 10:33:02 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER OFF
GO

CREATE PROCEDURE [dbo].[pSelect_AccountPass]
@id varchar(13)
AS

DECLARE @curdate DATETIME
DECLARE @birthdate DATETIME
DECLARE @plusdate DATETIME
DECLARE @AgeResult TINYINT

SET @curdate = GETDATE()
SET @birthdate = (SELECT birthdate FROM tbl_rfaccount WHERE ID = CONVERT(BINARY, @id))

IF(ISDATE(@birthdate) = 1)
BEGIN
SET @plusdate = DATEADD(yy, 18, CONVERT(DATETIME, @birthdate))
END

IF(ISDATE(@curdate) = 1) AND (@curdate >= @plusdate)
BEGIN
SET @AgeResult = 0
END
ELSE
BEGIN
SET @AgeResult = 1
END

SELECT RTRIM( CONVERT( VARCHAR(24), password) ), accounttype, AgeResult= @AgeResult FROM tbl_rfaccount WHERE ID = CONVERT(BINARY, @id)

SQL FIX for normal player authentication

Архив

SQL FIX for normal player authentication