[HELP]Server crashes

01/26/2010 22:45 grazzv1#1
Hello,
I get this message after started the server and viewed the Debugger.

[Only registered and activated users can see links. Click Here To Register...]


Can somebody help me? What could be the source? SQL? I don't have a clue.

Kind regards,
Grazz
01/26/2010 23:09 maleket-el-oloob#2
Quote:
Originally Posted by Darth Nerd View Post
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




/******************************************************************************
   The Name : dbo.FN_BinDateToDateTime
   Description : Binary Date The DateTime Returns in the form of.
   Returns : 
   History:
   Ver        Date        Author           Description
   ---------  ----------  ---------------  ------------------------------------
   1.0        2006-05-05  Han Ji Wook      1. Initial creation
   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

[CENTER][COLOR="Red"]and[/COLOR][/CENTER]

EXEC sp_addlinkedserver 'LSV_GHBILL','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRACNT','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'DKRCASH','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRHELION','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRNUNVICE','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRQUNE','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRRONDOW','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRSIZ','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRTEST','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRZUTO','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRSTA','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'DKRACCOUNT01','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'

[CENTER][COLOR="Red"]and[/COLOR][/CENTER]

exec sp_serveroption 'LSV_GHBILL','rpc out','true' 
exec sp_serveroption 'LSV_GHBILL','rpc','true' 
exec sp_serveroption 'LSV_DKRACNT','rpc out','true' 
exec sp_serveroption 'LSV_DKRACNT','rpc','true' 
exec sp_serveroption 'DKRCASH','rpc out','true' 
exec sp_serveroption 'DKRCASH','rpc','true' 
exec sp_serveroption 'LSV_DKRHELION','rpc out','true' 
exec sp_serveroption 'LSV_DKRHELION','rpc','true' 
exec sp_serveroption 'LSV_DKRNUNVICE','rpc out','true' 
exec sp_serveroption 'LSV_DKRNUNVICE','rpc','true' 
exec sp_serveroption 'LSV_DKRQUNE','rpc out','true' 
exec sp_serveroption 'LSV_DKRQUNE','rpc','true' 
exec sp_serveroption 'LSV_DKRRONDOW','rpc out','true' 
exec sp_serveroption 'LSV_DKRRONDOW','rpc','true' 
exec sp_serveroption 'LSV_DKRSIZ','rpc out','true' 
exec sp_serveroption 'LSV_DKRSIZ','rpc','true' 
exec sp_serveroption 'LSV_DKRTEST','rpc out','true' 
exec sp_serveroption 'LSV_DKRTEST','rpc','true' 
exec sp_serveroption 'LSV_DKRZUTO','rpc out','true' 
exec sp_serveroption 'LSV_DKRZUTO','rpc','true' 
exec sp_serveroption 'LSV_DKRSTA','rpc out','true' 
exec sp_serveroption 'LSV_DKRSTA','rpc','true' 
exec sp_serveroption 'DKRACCOUNT01','rpc out','true' 
exec sp_serveroption 'DKRACCOUNT01','rpc','true' 

[CENTER][COLOR="Red"]and[/COLOR][/CENTER]

/GM DISTRIBUTE
/GM PLAYERCOUNT
/GM SUMMON [PC ID]
/GM RETURN [PC ID]
/GM ITEMDROPRATIO [ItemDropRatio(1.0)]
/GM MONEYDROPRATIO [MoneyDropRatio(1.0)]
/GM MOVEMAP [MAPINDEX] [X] [Y]
/GM RESET_ALLMONSTER
/GM RESETMONSTER [MONSTERINDEX]
/GM ghostmode [on/off]
/GM observermode [on/off]
/GM callmonster [MonsterIndex]
/GM callmonsters [index] [count]
/GM kick [PC ID]
/GM revive [PC ID]
/GM heal [PC ID]
/GM find [PC ID]
/GM chase [PC ID]
/GM dummycount
/GM damage [on/off]
/GM createbrick [BrickID]
/GM destroybrick [BrickID]
/GM guildheal [pc name]
/GM fieldheal [map index]
/GM guildreturn [pc name]
/GM fieldreturn [map index]
/GM siegereset
/GM siegestop
/GM siegestart [time]
/GM siegeend [time]
/GM guildwarstart [time]
/GM guildwarend [time]
/GM open_teleport
/GM close_teleport
/GM resetcooltime
/GM resetcooltime_map
/GM partywarstart [time]
/GM partywarend
/GM observermode [on/off]
/GM call [PC ID]
/GM callmonster [MonsterIndex]
/GM callmonsters [index] [count]
/GM chase [PC ID]
/GM close_teleport
/GM createbrick [BrickID]
/GM damage [on/off]
/GM destroybrick [BrickID]
/GM DISTRIBUTE
/GM dummycount
/GM EXPRATIO [percentage]
/GM fieldheal [map index]
/GM fieldreturn [map index]
/GM find [PC ID]
/GM FINISH [Kick Time] ([end time])
/GM ghostmode [on/off]
/GM guildheal [pc name]
/GM guildreturn [pc name]
/GM guildwarend [time]
/GM guildwarstart [time]
/GM heal [PC ID]
/GM ITEMDROPRATIO [ItemDropRatio(1.0)]
/GM kick [PC ID]
/GM MAXPC [Max Player number on the map]
/GM MAXPLAYER [Max Player Figures (including the standby)]
/GM MONEYDROPRATIO [MoneyDropRatio(1.0)]
/GM MOVEMAP [MAPINDEX] [X] [Y]
/GM NOTICE \[Notice Content]\
/GM observermode [on/off]
/GM open_teleport
/GM partywarend
/GM partywarstart [time]
/GM PLAYERCOUNT
/GM REGEN [Monster resurrection speed (percentage)]
/GM RESET_ALLMONSTER
/GM resetcooltime
/GM RESETMONSTER [MONSTERINDEX]
/GM RETURN [PC ID]
/GM revive [PC ID]
/GM siegeend [time]
/GM siegereset
/GM siegestart [time]
/GM siegestop
/GM SUMMON [PC ID]
Don't forgot to leave "THANKS" To [Only registered and activated users can see links. Click Here To Register...]

[Only registered and activated users can see links. Click Here To Register...]
01/27/2010 07:48 grazzv1#3
Thank you I will try it later when VPS is back online :)
01/27/2010 08:48 janvier123#4
post your whole screenshot
your giving us a little bit of info
01/27/2010 20:13 grazzv1#5
that's all of the error message :S the Debuggers stops because of memory overload and then this part of the debugger pops up.
01/27/2010 21:35 NicoBlacktir#6
:D

next time copy all that we see what it load and where come the problem ;)
01/27/2010 21:49 grazzv1#7
this is all of the Dbugger what is useful because it loads properly until somewhere then the Dbugger crashes because of 90% memory use and then this part of the Dbugger pops up.
01/27/2010 23:44 Decima#8
how much ram do u have?
01/28/2010 07:53 grazzv1#9
3Gb of ram on the VPS.
01/28/2010 08:04 =Warmonger=#10
Try running it through a real debugger like Ollydbg. And post back where it crashs.
01/28/2010 08:12 Nosferatu.#11
Quote:
Originally Posted by maleket-el-oloob View Post
Don't forgot to leave "THANKS" To [Only registered and activated users can see links. Click Here To Register...]

[Only registered and activated users can see links. Click Here To Register...]

Fail.

That is sure not the Error, i can see Only a Disconnect from Server no Database Error.
01/29/2010 03:11 [DEV]Sukey#12
It could be missing Share File ... Because if a File is missing as you can see in the Screen that he wanted to load up Mapredcell/Deadfront didnt poped up any msg ... so it could be missing ^^ Try to find the File, which the server wanted to load up at last ...