[RELEASE]TEMPORARY (MAYBE OFFICIAL) FIX FOR SIEGE/DF ERRORS

daddycool. · 01/12/2010, 23:31

Hello Epvpers,
to all who are having problems with the siege script and also
Deadfront not starting properly I have here a temporary fix.
Need more tests, as my time is short, i leave it here to all try
to improve it and also test it more.

Query:

Code:

USE [Character]
GO

/****** Object:  UserDefinedFunction [dbo].[FN_BinDateToDateTime]    Script Date: 01/10/2010 19:35:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO




/******************************************************************************
   이  름 : dbo.FN_BinDateToDateTime
   설  명 : Binary Date를 DateTime 형식으로 반환한다.
   반환값 : 
   수정내역:
   Ver        Date        Author           Description
   ---------  ----------  ---------------  ------------------------------------
   1.0        2006-05-05  Han Ji Wook      1. 초기생성
   2.0        2010-01-10  ADM-Cyrax/Darth Nerd
 ******************************************************************************/
ALTER  FUNCTION [dbo].[FN_BinDateToDateTime] (
	@i_bin_time	binary(4)
) RETURNS datetime
AS
BEGIN
	DECLARE @v_datetime	datetime
	DECLARE @v_strAux varchar(20)
	DECLARE @v_strtime	varchar(20)
	SET @v_strAux = CAST(CAST(@i_bin_time as int) as varchar(20))
	IF len(@v_strAux) = 7	
		SELECT	@v_strtime	= '20100' + CAST(CAST(@i_bin_time as int) as varchar(20))
	ELSE
		IF len(@v_strAux) = 8 
			SELECT	@v_strtime	= '2010' + CAST(CAST(@i_bin_time as int) as varchar(20))
		ELSE
				SELECT	@v_strtime	= '201' + CAST(CAST(@i_bin_time as int) as varchar(20))

	
	SELECT	@v_strtime	= SUBSTRING(@v_strtime,1,4)
						+'-'+SUBSTRING(@v_strtime,5,2)
						+'-'+SUBSTRING(@v_strtime,7,2)
						+' '+SUBSTRING(@v_strtime,9,2)
						+':'+SUBSTRING(@v_strtime,11,2)	
	SELECT	@v_datetime = CAST(@v_strtime as datetime)
	RETURN @v_datetime
END

Don't forgot to leave "THANKS" if i help.

l2zeo · 01/12/2010, 23:35

good job!
i heartily thank.

maleket-el-oloob · 01/12/2010, 23:38

daddycool. · 01/12/2010, 23:57

@maleket-el-oloob
Maybe u need to re-run the querys from SN.txt and the siege script.

EliteWarrior · 01/13/2010, 00:14

Any one verified this working on sql 2005? Im busy atm with some other things so cant do it if it not works i need to again restore database wich i dont want to .

Decima · 01/13/2010, 00:15

what are you going to do next year lol

l2zeo · 01/13/2010, 00:18

Quote:

Originally Posted by Decima

what are you going to do next year lol

well ..that seem to be true words .. lol

maleket-el-oloob · 01/13/2010, 00:38

Thank you

daddycool. · 01/13/2010, 00:45

Next year, the query will be the same... i don't remove the original statment i just add 2 more possibilities.

Sry my poor english.

maleket-el-oloob · 01/13/2010, 01:35

so if i Go to BACKUP Databases i will BACKUP Databases with u new Code ?

Quote:

Originally Posted by Darth Nerd

Hello Epvpers,
to all who are having problems with the siege script and also
Deadfront not starting properly I have here a temporary fix.
Need more tests, as my time is short, i leave it here to all try
to improve it and also test it more.

Query:

Code:

USE [Character]
GO

/****** Object:  UserDefinedFunction [dbo].[FN_BinDateToDateTime]    Script Date: 01/10/2010 19:35:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO




/******************************************************************************
   이  름 : dbo.FN_BinDateToDateTime
   설  명 : Binary Date를 DateTime 형식으로 반환한다.
   반환값 : 
   수정내역:
   Ver        Date        Author           Description
   ---------  ----------  ---------------  ------------------------------------
   1.0        2006-05-05  Han Ji Wook      1. 초기생성
   2.0        2010-01-10  ADM-Cyrax/Darth Nerd
 ******************************************************************************/
ALTER  FUNCTION [dbo].[FN_BinDateToDateTime] (
	@i_bin_time	binary(4)
) RETURNS datetime
AS
BEGIN
	DECLARE @v_datetime	datetime
	DECLARE @v_strAux varchar(20)
	DECLARE @v_strtime	varchar(20)
	SET @v_strAux = CAST(CAST(@i_bin_time as int) as varchar(20))
	IF len(@v_strAux) = 7	
		SELECT	@v_strtime	= '20100' + CAST(CAST(@i_bin_time as int) as varchar(20))
	ELSE
		IF len(@v_strAux) = 8 
			SELECT	@v_strtime	= '2010' + CAST(CAST(@i_bin_time as int) as varchar(20))
		ELSE
				SELECT	@v_strtime	= '200' + CAST(CAST(@i_bin_time as int) as varchar(20))

	
	SELECT	@v_strtime	= SUBSTRING(@v_strtime,1,4)
						+'-'+SUBSTRING(@v_strtime,5,2)
						+'-'+SUBSTRING(@v_strtime,7,2)
						+' '+SUBSTRING(@v_strtime,9,2)
						+':'+SUBSTRING(@v_strtime,11,2)	
	SELECT	@v_datetime = CAST(@v_strtime as datetime)
	RETURN @v_datetime
END

Don't forgot to leave "THANKS" if i help.

l2zeo · 01/13/2010, 02:15

Quote:

Originally Posted by Darth Nerd

Next year, the query will be the same... i don't remove the original statment i just add 2 more possibilities.

Sry my poor english.

next siege time, error seems to become. :0

Decima · 01/13/2010, 03:15

what i mean, is 2011 isnt one of the possibilites, if im looking at it right (even tho it is poorly coded, sorry) it looks like it can either be a year that starts with '200' (i.e. 2009, 2008, 2008) or it can be 2010, so next year, even tho this one doesnt work correctly now, its not going to work . . .

daddycool. · 01/13/2010, 13:39

Okay, as i have said previously... this script needs to be tested more times, and also improved. Just a temporary fix.

l2zeo · 01/13/2010, 13:48

Quote:

Originally Posted by Darth Nerd

Okay, as i have said previously... this script needs to be tested more times, and also improved. Just a temporary fix.

siege date, part is fixed by 2000.

come good result and cheers up together! lol

Decima · 01/13/2010, 13:49

Quote:

Originally Posted by Darth Nerd

Okay, as i have said previously... this script needs to be tested more times, and also improved. Just a temporary fix.

hey man, at least ur making a **** good attempt at learning how it works tho, u got the right idea, just need to apply it in a different way, think outside the box