Siege New year. Fixx

[Tony258]

On the new year of 2010, server get this error.

[CRITICAL ERROR] SP_SIEGE_INFO_R CALL FAIL

I looked through forum found fix to change the functions,
that are linked to stored procedure but still gives that error.

Can someone tell me what the entire process is to fix this?

[janvier123]

search !

[Tony258]

I did, and i find the script, i used that nothing.
I cannot find any other steps.
Could you please either, tell me the entire step, or send me the thread link

[daddycool.]

Run your siege script again.

[nobleman80]

yea search. I already got it fixed sometime ago. the script is here.

[Tony258]

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

I ran through sql query, and also tried editing the procedure manually.
Im still getting the error.
Is this the ONLY thing need change or more ???

[maleket-el-oloob]

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:

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

[Tony258]

and what am i supposed to do with those?
I know add the first one in sql query or manually change it.
But why are you posting gm commands :/ and the second part, put in sql query again?

[Tony258]

Darth Nerd can you help plz I did all steps.
Is it my db with the guild and siege info?

Maybe we can connect team viewer so you can see

EDIT: I think i fixed it with help from maleket-el-oloob.
I get the 408: NOT SIEGE INFO CHANNEL INDEX = [ 1 ]

I go to npc for siege, says no siege info.
So im playing with database hope i find somethin thanks


EDIT:

3520: NOT SIEGE INFO CHANNEL INDEX = [ 1 ]
3300: OnSuit : Item Open Fail
3300: FAIL - Not War Time ......
3300: FAIL - Not War Time ......
3300: [ STARTSIEGE ] NAME[ [GM]Test ] TIME[ 1 ]
3520: [FAIL ERROR] SP_SIEGE_DEFENDER_U [ RESULT : -2 ]
3520: >> [ 10B42B08 ][ 216.245.195.234 ]--- Server DisConnected ---
3520: >> [ 10B42B08 ][ 216.245.195.234 ] [ 1 ]--- Server DisConnected ---
2392: >> [ 10B41B48 ][ 216.245.195.234 ]--- Server DisConnected ---
2392: BroadCast : all game server is shutdown.

Ummm?
I get that when i go /gm siegestart 1

When i go to the Siege npc and click on siege info it says, no siege info exist.

[mcsamuraicz]

I have same problem

Please help

[daddycool.]

Originally Posted by Tony258

Darth Nerd can you help plz I did all steps.
Is it my db with the guild and siege info?

Maybe we can connect team viewer so you can see

EDIT: I think i fixed it with help from maleket-el-oloob.
I get the 408: NOT SIEGE INFO CHANNEL INDEX = [ 1 ]

I go to npc for siege, says no siege info.
So im playing with database hope i find somethin thanks


EDIT:

3520: NOT SIEGE INFO CHANNEL INDEX = [ 1 ]
3300: OnSuit : Item Open Fail
3300: FAIL - Not War Time ......
3300: FAIL - Not War Time ......
3300: [ STARTSIEGE ] NAME[ [GM]Test ] TIME[ 1 ]
3520: [FAIL ERROR] SP_SIEGE_DEFENDER_U [ RESULT : -2 ]
3520: >> [ 10B42B08 ][ 216.245.195.234 ]--- Server DisConnected ---
3520: >> [ 10B42B08 ][ 216.245.195.234 ] [ 1 ]--- Server DisConnected ---
2392: >> [ 10B41B48 ][ 216.245.195.234 ]--- Server DisConnected ---
2392: BroadCast : all game server is shutdown.

Ummm?
I get that when i go /gm siegestart 1

When i go to the Siege npc and click on siege info it says, no siege info exist.

You don't have registered the siege info in your database... run the siege script and start your server again, maybe it helps.

USE [Character];
GO

DECLARE @v_siege_no char(10)
DECLARE @guild_code varchar(10)
DECLARE @guild_name varchar(30)
DECLARE @v_strDate varchar(10)
DECLARE @v_regdate varchar(10)
DECLARE @v_strChannel varchar(2)
DECLARE @i_bychannel tinyint
DECLARE @o_dwDungeonRegistTime varbinary(4)
DECLARE @o_DeadFrontTimeInfo varbinary(1000)
DECLARE @o_sp_rtn int
DECLARE @o_dwRegistTimeStart varbinary(4)
DECLARE @o_dwRegistTimeEnd varbinary(4)
DECLARE @o_dwTaxRegistTime varbinary(4)
DECLARE @o_dwStartTime varbinary(4)
DECLARE @o_dwRegistTime varbinary(4)
DECLARE @v_strDate1 varchar(10)
DECLARE @i_GetDate datetime
DECLARE @v_siege_start_date varchar(14)
DECLARE @v_siege_start_time varbinary(4)

SET @i_GetDate=getdate()

-- Siege War Every Saturday:

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)

SET @guild_code = '001'
SET @guild_name = 'FIRSTGUILD'
SET @v_siege_no = SUBSTRING(dbo.FN_DateToShortStrDate(GetDate()), 3, 4) + '0001'
INSERT
INTO GUILD_INFO(guild_code, guild_name, guild_Level, bystate, bychannel)
VALUES (@guild_code, @guild_name, 3, 1, 1)
INSERT
INTO SIEGE_INFO(SIEGE_NO, CHANNEL_NO, GUILD_CODE, GUILD_NAME, DWSTARTTIME, BYREGISTTIMEFLAG, DEFENDER_INFO, SIEGE_TAG)
VALUES (@v_siege_no, 1, @guild_code, @guild_name,@v_siege_start_time, 1, 0X0000, 'Y')

EXEC SP_SIEGE_START_TIME_U @guild_code,1,0x01,@v_siege_start_time output,@o_dwRegistTime output,@o_sp_rtn output

SET @v_strDate1=dbo.FN_BinDateToDateTime(@v_siege_start_time)

DECLARE @P1 varchar(13)
SET @P1=NULL
DECLARE @P2 varchar(33)
SET @P2=NULL
DECLARE @P3 varchar(25)
SET @P3=NULL
DECLARE @P4 varbinary(4)
SET @P4=NULL
DECLARE @P5 varbinary(4)
SET @P5=NULL
DECLARE @P6 varbinary(4)
SET @P6=NULL
DECLARE @P7 varbinary(4)
SET @P7=NULL
DECLARE @P8 varbinary(4)
SET @P8=NULL
DECLARE @P9 varbinary(4)
SET @P9=NULL
DECLARE @P10 varbinary(4)
SET @P10=NULL
DECLARE @P11 varbinary(2)
SET @P11=NULL
DECLARE @P12 varbinary(2)
SET @P12=NULL
DECLARE @P13 varbinary(2)
SET @P13=NULL
DECLARE @P14 int
SET @P14=NULL
DECLARE @P15 int
SET @P15=NULL
DECLARE @P16 varbinary(4)
SET @P16=NULL
DECLARE @P17 varbinary(996)
SET @P17=NULL
DECLARE @P18 varbinary(996)
SET @P18=NULL
DECLARE @P19 varbinary(1000)
SET @P19=NULL
DECLARE @P20 int
SET @P20=NULL
EXEC SP_SIEGE_INFO_R 1, @P1 output, @P2 output, @P3 output, @P4 output, @P5 output, @P6 output, @P7 output, @P8 output, @P9 output, @P10 output, @P11 output, @P12 output, @P13 output, @P14 output, @P15 output, @P16 output, @P17 output, @P18 output, @P19 output, @P20 output
SELECT @P1, @P2, @P3, @P4, @P5, @P6,@v_strDate1

[maleket-el-oloob]

Originally Posted by mcsamuraicz

I have same problem

Please help


i help u By TeamViewer
just Don't forgot to leave "THANKS" To

Don't forgot

[janvier123]

Originally Posted by maleket-el-oloob

hi

Reported: Spam

[~Twister~]

I guess maleket-el-oloob fixed it.

[Tony258]

Server: Msg 2627, Level 14, State 1, Line 39
Violation of PRIMARY KEY constraint 'PK_GUILD_INFO'. Cannot insert duplicate key in object 'GUILD_INFO'.
The statement has been terminated.

(1 row(s) affected)


(1 row(s) affected)


Is this right?