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)
|