Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Dekaron > Dekaron Private Server
You last visited: Today at 21:37

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement



NEW ERROR SIEGE LOOK!

Discussion on NEW ERROR SIEGE LOOK! within the Dekaron Private Server forum part of the Dekaron category.

Reply
 
Old   #1
 
AngelOfFear's Avatar
 
elite*gold: 0
Join Date: Feb 2010
Posts: 69
Received Thanks: 13
Question NEW ERROR SIEGE LOOK!



yo guys can you help me ?? O.O idk how fix some ideas ??

thanks
AngelOfFear is offline  
Old 08/21/2010, 17:00   #2
 
Deadman88's Avatar
 
elite*gold: 20
Join Date: Aug 2008
Posts: 1,227
Received Thanks: 132
i dunt know much but try change you date now to 2009..
example = 2010 to 2009
Deadman88 is offline  
Old 08/21/2010, 17:13   #3
 
AngelOfFear's Avatar
 
elite*gold: 0
Join Date: Feb 2010
Posts: 69
Received Thanks: 13
Quote:
Originally Posted by hazwanking View Post
i dunt know much but try change you date now to 2009..
example = 2010 to 2009
i tried but same error... >.< idk how fix i need a expert of sql >.<
AngelOfFear is offline  
Old 08/21/2010, 17:21   #4
 
gedimazs's Avatar
 
elite*gold: 0
Join Date: May 2008
Posts: 863
Received Thanks: 197
Quote:
Originally Posted by AngelOfFear View Post


yo guys can you help me ?? O.O idk how fix some ideas ??

thanks
dude it is saying that out-of-range datatime value you don't need to be SQL expert to understand this. Try to remember what date/time values you have changed and change it back
gedimazs is offline  
Old 08/21/2010, 17:48   #5
 
AngelOfFear's Avatar
 
elite*gold: 0
Join Date: Feb 2010
Posts: 69
Received Thanks: 13
Quote:
Originally Posted by gedimazs View Post
dude it is saying that out-of-range datatime value you don't need to be SQL expert to understand this. Try to remember what date/time values you have changed and change it back
mmmm here there are things what i changed:

FN_BinDateToDateTime:
Code:


/******************************************************************************
   이  름 : 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
 ******************************************************************************/
CREATE  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
FN_GetSiegeStartBinTime:
Code:






/******************************************************************************
   이  름 : dbo.FN_GetSiegeStartBinTime
   설  명 : 다음 공성전 시작일자를 반환한다.
   예  제 : select dbo.FN_GetSiegeStartTime     --//반환값 : 0x23E52D6C
   수정내역:
   Ver        Date        Author			Description
   ---------  ----------  ---------------  	-----------------------------------
   1.0        2006-05-05  Han Ji Wook		1. 초기생성
   1.1        2006-05-11  Han Ji Wook		1. 다음공성전 시작시간 변경 >> 2주후 일요일
 ******************************************************************************/
CREATE   FUNCTION dbo.FN_GetSiegeStartBinTime
(
	@i_GetDate		datetime
) RETURNS varbinary(4)
AS
BEGIN
	DECLARE @v_siege_start_time	varbinary(4)
	DECLARE @v_siege_start_date	varchar(14)
	--// 다음공성전 시작시간 Default Setting : 일요일 9시
	SELECT	@v_siege_start_date 	= CONVERT(VARCHAR(10), DATEADD(d, 7-DATEPART(dw, @i_GetDate), @i_GetDate), 112) + '210000'
	SELECT	@v_siege_start_time	= SUBSTRING(@v_siege_start_date,4,1) * 100000000
								+ SUBSTRING(@v_siege_start_date,5,2) * 1000000
								+ SUBSTRING(@v_siege_start_date,7,2) * 10000
								+ SUBSTRING(@v_siege_start_date,9,2) * 100
								+ SUBSTRING(@v_siege_start_date,11,2)
	
	IF DATALENGTH(@v_siege_start_time) <> 4
		SELECT	@v_siege_start_time = 0x00000000
	
	RETURN 	@v_siege_start_time
END
or can you send me siege 2010 fixed and worked u.u

thanks
AngelOfFear is offline  
Old 08/21/2010, 19:56   #6
 
gedimazs's Avatar
 
elite*gold: 0
Join Date: May 2008
Posts: 863
Received Thanks: 197
why you changed FN_GetSiegeStartBinTime: ?? you dont have to
gedimazs is offline  
Old 08/21/2010, 20:42   #7
 
AngelOfFear's Avatar
 
elite*gold: 0
Join Date: Feb 2010
Posts: 69
Received Thanks: 13
Quote:
Originally Posted by gedimazs View Post
why you changed FN_GetSiegeStartBinTime: ?? you dont have to
for put every saturday siege u.u
AngelOfFear is offline  
Old 08/21/2010, 21:12   #8
 
gedimazs's Avatar
 
elite*gold: 0
Join Date: May 2008
Posts: 863
Received Thanks: 197
you change it in your siege query not seperate editing functions
gedimazs is offline  
Old 08/21/2010, 22:29   #9
 
gedimazs's Avatar
 
elite*gold: 0
Join Date: May 2008
Posts: 863
Received Thanks: 197
#reported advertising
gedimazs is offline  
Old 08/21/2010, 23:18   #10

 
elite*gold: 35
Join Date: Aug 2009
Posts: 5,822
Received Thanks: 1,958
#deleted
~Kakkarot~ is offline  
Reply


Similar Threads Similar Threads
Never seen siege error !!!
05/13/2020 - Dekaron Private Server - 5 Replies
http://img10.imageshack.us/img10/1224/siegeerror.j pg Anyone know what this mean ? and how to fix it, when i got this error i can't open siege information, if view siege information from NPC Bastain i'll got server disconnect. this is new problem for me please help. thank you.
Siege error
02/19/2010 - Dekaron Private Server - 4 Replies
http://www.imagesforme.com/upload/b48b9fa5.jpg i followed this tutorial http://www.elitepvpers.com/forum/2moons-pserver-ho sting/426175-release-temporary-maybe-official-fix- siege-df-errors.html
[HELP]Siege error
08/23/2009 - Dekaron Private Server - 11 Replies
well, i added the thing at query analyzer. into the server section/master. Then i go ingame and give in /gm siegestart 5:00 then i look to dbmon: http://i26.tinypic.com/i4n5ed.jpg
siege error
08/08/2009 - Dekaron Private Server - 1 Replies
SET @v_siege_no = SUBSTRING(dbo.FN_DateToShortStrDate(GetDate()), 3, 4) + '0001' Individual name 'dbo.FN_DateToShortStrDate' error
[HELP] Siege Error line
07/30/2009 - Dekaron Private Server - 2 Replies
I have a problem in the script when I run the Siege it appears that image below someone can help me solve this problem please thanks http://img195.imageshack.us/img195/5173/siege1a.j pg http://img30.imageshack.us/img30/4411/siege2u.jpg please help



All times are GMT +1. The time now is 21:37.


Powered by vBulletin®
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2024 elitepvpers All Rights Reserved.