with stored procedure errors

[magraopb]

on three last week i'm have this errors in new accounts, you try loggin in game and receive this message already connected

Stored Procedure "cabal_sp_auth"
can't decript MD5 password i think

OBS:
The server is online for more than 1 year

[Mon Mar 29 2010 07:11:02.485610 3065895824]: [##ERROR##] OnIPCAuthAccount fail (usernum: 0)
[Mon Mar 29 2010 07:11:02.485667 3065895824]: [##ERROR##] DB ERROR(MSG) : [FreeTDS][SQL Server]The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
[Mon Mar 29 2010 07:11:02.485700 3065895824]: [##ERROR##] DB ERROR(CODE) : 242
[Mon Mar 29 2010 07:11:02.485729 3065895824]: [##ERROR##] DB ERROR(VAR_INFO) :
[Mon Mar 29 2010 07:11:02.485759 3065895824]: [##ERROR##] DB ERROR(SQLSTATE) : 22007
[Mon Mar 29 2010 07:11:02.485788 3065895824]: [##ERROR##] DB ERROR(STM_TEXT) : {call cabal_sp_auth( ? , ? , ? , ? )}
[Mon Mar 29 2010 07:11:02.495377 3065895824]: Database Connect success!
[Mon Mar 29 2010 07:11:02.495425 3065895824]: [##ERROR##] 'OnIPCAuthAccount' fail (Database/Auth.cpp:283)
[Mon Mar 29 2010 07:11:02.495480 3065895824]: [##ERROR##] UsrMap Fail : MainCmd(30) Ret(11B:0:283) Addr(127.0.0.1)

[MentaL]

[chumpywumpy]

Ah this problem again. It is because of the mssql server language and date formats.

Find:

	-- Free time (everyday PM 21~22)
	DECLARE @StartFreeTime as DATETIME, @EndFreeTime as DATETIME
	SET @StartFreeTime = CONVERT(VARCHAR(11), GETDATE(), 20) + '21:00:00'
	SET @EndFreeTime = CONVERT(VARCHAR(11), GETDATE(), 20) + '00:00:00'
	IF @rExpireDate < GETDATE() and @StartFreeTime < GETDATE() and GETDATE() < @EndFreeTime
	BEGIN
		SET @rType = 2
		SET @rExpireDate = @EndFreeTime
	END

Change to:

/*  ! WARNING ! Causes problems on some languages
	-- Free time (everyday PM 21~22)
	DECLARE @StartFreeTime as DATETIME, @EndFreeTime as DATETIME
	SET @StartFreeTime = CONVERT(VARCHAR(11), GETDATE(), 20) + '21:00:00'
	SET @EndFreeTime = CONVERT(VARCHAR(11), GETDATE(), 20) + '00:00:00'
	IF @rExpireDate < GETDATE() and @StartFreeTime < GETDATE() and GETDATE() < @EndFreeTime
	BEGIN
		SET @rType = 2
		SET @rExpireDate = @EndFreeTime
	END
*/

Unless you use the "free time" premium setting this isn't used anyway ;)

[magraopb]

yep, work fine, thanks one more time shumpy, but i have more one question

- i make a test her in my test server and this happens too, in a new server with clean DBs why?

[magraopb]

this problem return after a time :(