[Siege]

[Godricc]

Okay. I have been stuck with this Siege **** for the last 2 weeks. My siege wont work.



I have no clue if that even means siege is not in my db.
I have been following the guide here.



I am using Microsoft SQL Server 2008. I also have no clue if I may need a different script when using a different version. I would say no due to the fact that there aren't any posts with 2008 siege scripts. Bare with me please.
I also tried to use the siege start command in game and it's just crashing the whole game.
I had 2 different dekaron DEV's try and help me out. Neither of which knew what was going on...
Now i'm left with asking my fellow mate on ePvpers! Please help me if you know ANYTHING!

Thanks in advance.

[Godricc]

Ummmmmmm, Bump! Maybe?

[Ultimo ☼]

Originally Posted by Godricc

Okay. I have been stuck with this Siege **** for the last 2 weeks. My siege wont work.



I have no clue if that even means siege is not in my db.
I have been following the guide here.



I am using Microsoft SQL Server 2008. I also have no clue if I may need a different script when using a different version. I would say no due to the fact that there aren't any posts with 2008 siege scripts. Bare with me please.
I also tried to use the siege start command in game and it's just crashing the whole game.
I had 2 different dekaron DEV's try and help me out. Neither of which knew what was going on...
Now i'm left with asking my fellow mate on ePvpers! Please help me if you know ANYTHING!

Thanks in advance.

last time i tested sql 2012 siege was working fine, so its not about using a different version. i would suggest you to restore your character db using a working one that has also siege working.

[Godricc]

I have use this EXACT same DB for my test server and the siege works 100%.
How can I go about restoring my DB and SAVING every account and character due to the MANY players I have now.

[Ultimo ☼]

Originally Posted by Godricc

I have use this EXACT same DB for my test server and the siege works 100%.
How can I go about restoring my DB and SAVING every account and character due to the MANY players I have now.

nvm, didnt know that you had a public server

[Godricc]

Ugh so there is no way to backup my files to maybe a Bak. file?

[.Genome.]

Originally Posted by Godricc

Ugh so there is no way to backup my files to maybe a Bak. file?

There is..

But I'll say check google for those steps cause I dont remember them.

[Godricc]

Great! Got everything including the backup! Now to fix why I cant get my dshop wings to actually work. When I try to buy them they just give an error in numbers due to missing string. I would say because Im missing it from the itemcash. So how would I go about editing them into itemcash?

[Ultimo ☼]

Originally Posted by Godricc

Great! Got everything including the backup! Now to fix why I cant get my dshop wings to actually work. When I try to buy them they just give an error in numbers due to missing string. I would say because Im missing it from the itemcash. So how would I go about editing them into itemcash?

Check Data/Script/String/Stringtable_cash

[AntiHackPrivate]

You just use it:

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()
SELECT @v_siege_start_date = CONVERT(VARCHAR(10), DATEADD(d, 7-DATEPART(dw, @i_GetDate), @i_GetDate), 112) + '210000'

SELECT @v_siege_start_date = CONVERT(VARCHAR(10), DATEADD(d, 15-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 = 'ϵͳĬÈÏ'
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_star t_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

[Godricc]

Okay so i got siege working but for some reason after changing the script to make my staff guild castle leader, It kicked myself and everyone from the guild. I managed to get us all back in it and we have the siege castle, but NOW I can't even log onto the guild leader character. It gets to 99% loading of the map and poof. Everyone else and log on and they see that we are castle owners. Then when I go to the siege map and start siege its half *** working. The icons pop and show that we are holding all the pendents but then when I bring a random guild in they cant do anything. (Obviously because they didn't apply for siege.) Anyhow, after using siegeend now, we all get stuck and cant move, then the whole server crashes. I then have to reboot everything.

[.Genome.]

It's normal for everything in siege to be ****** up for a person or guild inside the map when they haven't done the ritual.

And it is also normal for no one except the castle owners to be able to move on the map when it isn't siege time.

However, the server crashing when it ends isn't normal.

[Godricc]

Kk so when I end the siege we are the siege owners and for the part with the dcing! How could I even fix something like that...

Thanks so much for you super fast response also.

[mcsamuraicz]

delete siege from tables: SIEGE_INFO, SIEGE_RESULT_LOG, GUILD_INFO (guild_code: 001), set in GUILD_INFO all bystate and bychannel to 0.

use this:

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 = '20130' + CAST(CAST(@i_bin_time as int) as varchar(20))
ELSE
IF len(@v_strAux) = 8
SELECT @v_strtime = '2013' + 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

and finally run your siege script
this should fix your problem (atleast it fixed mine)

[Godricc]

Okay, I fully understand I just want to be clear on a few things before attempting anything.

Delete old siege tables, Set ALL guild's channel's and states to 0 (which will remove siege castle owners) then Run your listed script above. After yours then run my scripts
Why would I be getting that [Fail Error]Siege_Tax_U.