SQL FIX for normal player authentication

[Spikey]

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.

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)


GO

 

[xAlastor]

what the function of this?

 

[Spikey]

When setting up 2232 you will find that your GM's can connect but normal accounts can't unless you got a DB that has been fix already so if you are having trouble with normal accounts connecting then this is the fix.

 

[nenzynho]

how to run it?
I'm a little inexperienced in rf still ...

 

[Spikey]

Open your MSSQL start new querry copy and paste above code the click execute, if your running a server you should already know how to do this its MSSQL 101

 

[Saptago]

i try to use this query , but i still got errror " Not Subscribing Account "
I Use RU Nation Code For all

Any idea ?

 

[Tenma Pegasus]

That query only Chage Procedure rfccount if you Use DB RF_User CN and change to RU
Cek your DB Billing!!! If you use Nation RU you need Billing RU to ....