[Siege]

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

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

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

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

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.

Ummmmmmm, Bump! Maybe?

Quote:

Originally Posted by Godricc Okay. I have been stuck with this Siege crap for the last 2 weeks. My siege wont work. [Only registered and activated users can see links. Click Here To Register...] I have no clue if that even means siege is not in my db. I have been following the guide here. [Only registered and activated users can see links. Click Here To Register...] 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.

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.

Quote:

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

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

Quote:

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.

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?

Quote:

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

You just use it:

Quote:

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

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 ass 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.
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]

It's normal for everything in siege to be fucked 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.

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.

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:

Quote:

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)

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.