Fortress bug gate

Page 2 of 3 1 2 3
10/14/2011 22:00 3lyka#16
Gates is like npc\mob right? and maybe the fortress npc\mobs with service 0? mean disable..? What you think?
10/14/2011 22:19 unkwerless#17
tell me what table it is in sql and I will check if is working
10/15/2011 11:18 CrystalCoder#18
i guess npc act like mobs in FW since i never joined this i cant tell execly
morever i check his all ref tables and no disbled service any idea?
10/22/2011 19:14 unkwerless#19
still nobody know?
10/22/2011 20:50 DaxterSoul#20
@unkwerless: Those who know won't share this^^

The Gates are closed because there is no Gate defined.
Look at the mini map (M) and you will see that there is no heart, tower or gate.

You have to insert the basic structure into "SiegeFortressStruct" (Heart, Gates, Towers)
The server is only going to update those but he isn't inserting it.

There is a buggy stored produce. You can fix it with a little knowledge of SQL

Because I hate lazy people I wont share my table but I'll tell you how you can do it yourself (without fixing the produce).

1. Copy the original SiegeFortressStruct data from the original backup into the table.

2. Create a guild with 7 players (They don't have to be online)

3. Attack the Fortress. You have to destroy everything and after you won, you got the basic structure.

4. You have to do this for every Fortress.

5. Don't forget to set the OwnerGuildID to 0 in the SiegeFortressStruct.
10/22/2011 21:49 sbhtkvnkl34#21
you cant fix FW becose you need some files thet no 1 will relase(i dont :))
10/22/2011 23:27 unkwerless#22
anyone have a query for the fortress structure "original backup" ? cuz my original backup its empty

thanks
10/23/2011 00:42 3lyka#23
_SiegeFortressStruct

Quote:
1 384 84 19538 1170000 22.08.2009 11:00:00 0
1 384 85 19521 580000 22.08.2009 11:00:00 0
1 384 86 19521 580000 22.08.2009 11:00:00 0
1 384 87 19521 580000 22.08.2009 11:00:00 0
1 384 88 19504 1170000 22.08.2009 11:00:00 0
1 384 89 19504 1170000 22.08.2009 11:00:00 0
1 384 90 19504 1170000 22.08.2009 11:00:00 0
1 384 91 19509 0 22.08.2009 11:00:00 0
1 384 92 19509 0 22.08.2009 11:00:00 0
1 384 93 19509 0 22.08.2009 11:00:00 0
1 384 94 19509 0 22.08.2009 11:00:00 0
1 384 95 19509 0 22.08.2009 11:00:00 0
1 384 96 19509 0 22.08.2009 11:00:00 0
1 384 97 19515 0 22.08.2009 11:00:00 0
1 384 98 19515 0 22.08.2009 11:00:00 0
1 384 99 19515 0 22.08.2009 11:00:00 0
1 384 100 19515 0 22.08.2009 11:00:00 0
1 384 101 19515 0 22.08.2009 11:00:00 0
1 384 102 19515 0 22.08.2009 11:00:00 0
1 384 103 19515 0 22.08.2009 11:00:00 0
1 384 104 19515 0 22.08.2009 11:00:00 0
1 384 105 19515 0 22.08.2009 11:00:00 0
1 384 106 19515 0 22.08.2009 11:00:00 0
1 384 107 19515 0 22.08.2009 11:00:00 0
1 384 108 19515 0 22.08.2009 11:00:00 0
6 863 137 19628 1024000 17.08.2011 12:44:42 0
6 863 138 19532 1024000 17.08.2011 12:42:48 0
6 863 139 19532 1024000 17.08.2011 12:43:59 0
6 863 140 19593 1024000 17.08.2011 12:43:01 0
6 863 141 19593 1024000 17.08.2011 12:43:31 0
6 863 142 19513 416000 17.08.2011 12:43:05 0
6 863 143 19513 416000 17.08.2011 12:43:08 0
6 863 144 19513 416000 17.08.2011 12:43:25 0
6 863 145 19513 416000 17.08.2011 12:43:37 0
6 863 146 19519 416000 17.08.2011 12:42:58 0
6 863 147 19519 416000 17.08.2011 12:43:19 0
6 863 148 19519 416000 17.08.2011 12:44:06 0
6 863 149 19519 416000 17.08.2011 12:43:53 0
6 863 150 19519 416000 17.08.2011 12:42:37 0
6 863 151 19519 416000 17.08.2011 12:42:45 0
6 863 152 19519 416000 17.08.2011 12:44:32 0
6 863 153 19519 416000 17.08.2011 12:44:37 0
6 863 154 19519 416000 17.08.2011 12:44:19 0
1 0 127 19543 0 20.08.2011 15:30:00 0
1 0 128 19543 0 20.08.2011 15:30:00 0
1 0 129 19543 0 20.08.2011 15:30:00 0
1 0 130 19543 0 20.08.2011 15:30:00 0
1 0 131 19543 0 20.08.2011 15:30:00 0
1 0 132 19543 0 20.08.2011 15:30:00 0
1 0 133 19543 0 20.08.2011 15:30:00 0
1 0 134 19543 0 20.08.2011 15:30:00 0
1 0 135 19543 0 20.08.2011 15:30:00 0
1 0 136 19543 0 20.08.2011 15:30:00 0
6 863 155 19519 416000 17.08.2011 12:44:12 0
3 848 180 19613 1632000 16.08.2011 10:25:04 0
3 848 181 19532 1024000 16.08.2011 10:24:03 0
3 848 182 19524 1024000 16.08.2011 10:24:55 0
3 848 183 19528 1024000 16.08.2011 10:24:45 0
3 848 184 19578 1632000 16.08.2011 10:23:33 0
3 848 185 19578 1632000 16.08.2011 10:24:18 0
3 848 186 19578 1632000 16.08.2011 10:23:41 0
3 848 187 19513 416000 16.08.2011 10:23:23 0
3 848 188 19513 416000 16.08.2011 10:23:13 0
3 848 189 19513 416000 16.08.2011 10:24:13 0
3 848 190 19513 416000 16.08.2011 10:24:23 0
3 848 191 19513 416000 16.08.2011 10:23:46 0
3 848 192 19513 416000 16.08.2011 10:23:52 0
3 848 193 19519 416000 16.08.2011 10:23:58 0
3 848 194 19519 416000 16.08.2011 10:24:07 0
3 848 195 19519 416000 16.08.2011 10:24:40 0
6 0 172 19543 0 20.08.2011 15:30:00 0
6 0 173 19543 0 20.08.2011 15:30:00 0
6 0 174 19543 0 20.08.2011 15:30:00 0
6 0 175 19543 0 20.08.2011 15:30:00 0
6 0 176 19543 0 20.08.2011 15:30:00 0
6 0 177 19543 0 20.08.2011 15:30:00 0
6 0 178 19543 0 20.08.2011 15:30:00 0
6 0 179 19543 0 20.08.2011 15:30:00 0
3 848 196 19519 416000 16.08.2011 10:24:35 0
3 848 197 19519 416000 16.08.2011 10:24:31 0
3 848 198 19519 416000 16.08.2011 10:24:48 0
3 848 199 19519 416000 16.08.2011 10:25:00 0
3 848 200 19517 256000 16.08.2011 10:25:25 0
3 848 201 19517 256000 16.08.2011 10:25:16 0
3 848 202 19519 416000 16.08.2011 10:25:07 0
3 0 224 19543 0 20.08.2011 15:30:00 0
3 0 225 19543 0 20.08.2011 15:30:00 0
3 0 226 19543 0 20.08.2011 15:30:00 0
3 0 227 19543 0 20.08.2011 15:30:00 0
3 0 228 19543 0 20.08.2011 15:30:00 0
3 0 229 19543 0 20.08.2011 15:30:00 0
3 0 230 19543 0 20.08.2011 15:30:00 0
3 0 231 19543 0 20.08.2011 15:30:00 0
NULL NULL NULL NULL NULL NULL NULL
10/23/2011 01:00 unkwerless#24
can u do it in a query?:D it will take me ages to write all these manually
thanks for this also ^^
10/23/2011 01:11 3lyka#25
Quote:
Originally Posted by unkwerless View Post
can u do it in a query?:D it will take me ages to write all these manually
thanks for this also ^^
U can take it from original db..who have clean db the person who did it just removed it be mistake

btw the owned guild must be 0
10/23/2011 01:20 unkwerless#26
I will give it a shot ^^
thanks for the advice
10/23/2011 02:17 DaxterSoul#27
Here is the SQL Fix

Code:
set ANSI_NULLS ON
set QUOTED_IDENTIFIER OFF
GO

ALTER PROCEDURE [dbo].[_InsertSiegeFortressStruct]
	@FortressID		INT
AS
	DECLARE @RefEventStructID	INT
	DECLARE @StructCodeName    	VARCHAR(129)
	DECLARE @FortressName		VARCHAR(129)
	
	IF @FortressID <= 0
	BEGIN
		RETURN -1
	END

	-- Get the FortressName (FORTRESS_JANGAN)
	SELECT @FortressName = CodeName128 FROM _RefSiegeFortress WITH (NOLOCK) WHERE FortressID = @FortressID
	--print(@FortressName)
	
	-- Get the GroupCodeName (GROUP_FORTRESS_JANGAN)
	DECLARE @FortressGroupCodeName VARCHAR(129)
	SELECT @FortressGroupCodeName = GroupCodeName128 FROM _RefGame_World_Config WHERE [Value] = @FortressName
	--print(@FortressGroupCodeName)

	-- Get the WorldCodeName (INS_FORT_JA)
	DECLARE @FortressWorldCodeName VARCHAR(129)
	SELECT @FortressWorldCodeName = WorldCodeName128 FROM _RefGame_World WHERE ConfigGroupCodeName128 = @FortressGroupCodeName
	--print(@FortressWorldCodeName)

	DECLARE FortressStructCursor CURSOR  FOR
	SELECT [ID],strParam1  FROM _RefEventZone WITH (NOLOCK) WHERE Service = 1 AND strParam2 = @FortressWorldCodeName

	OPEN FortressStructCursor
	FETCH NEXT FROM FortressStructCursor INTO @RefEventStructID, @StructCodeName
	WHILE (@@fetch_status = 0)
	BEGIN	
		DECLARE @RefObjID   	INT
		DECLARE @Link	INT
		
		SET @RefObjID = 0
		SET @Link = 0

		SELECT @RefObjID = [ID], @Link = Link FROM _RefObjCommon WITH (NOLOCK) WHERE CodeName128 = @StructCodeName
		IF @RefObjID <= 0
		BEGIN
			FETCH NEXT FROM FortressStructCursor INTO @RefEventStructID, @StructCodeName
			CONTINUE
		END

		DECLARE @MaxHP   INT
		SELECT @MaxHP = MaxHP FROM _RefObjChar WITH (NOLOCK) WHERE [ID] = @Link
		IF @MaxHP < 0
		BEGIN
			FETCH NEXT FROM FortressStructCursor INTO @RefEventStructID, @StructCodeName
			CONTINUE
		END

		IF NOT EXISTS (SELECT * FROM _SiegeFortressStruct  WITH (NOLOCK)  WHERE RefEventStructID = @RefEventStructID)
		BEGIN
			-- ·¹ÆÛ·±½º Å×ÀÌºí¿¡¼* Æ÷Æ®¸®½º ÀνºÅϽº¸¦ ¹Ì¸® ¸¸µç´Ù. °ªÀº ¸ðµÎ default·Î ¼¼ÆÃ!
			-- Translation: Create a table in advance on the fortress instance reference. All values ​​are set to default!
			INSERT INTO [dbo]._SiegeFortressStruct VALUES ( @FortressID, 0, @RefEventStructID, @RefObjID, @MaxHP, GetDate(), 0)
		END

		FETCH NEXT FROM FortressStructCursor INTO @RefEventStructID, @StructCodeName
	END

	CLOSE FortressStructCursor
	DEALLOCATE FortressStructCursor	

	RETURN 0	
	-- by Daxter
And execute for each fortress

Code:
-- Jangan
EXEC	[dbo].[_InsertSiegeFortressStruct]
		@FortressID = 1
-- Hotan
EXEC	[dbo].[_InsertSiegeFortressStruct]
		@FortressID = 3
-- Bandit
EXEC	[dbo].[_InsertSiegeFortressStruct]
		@FortressID = 6
10/23/2011 03:23 unkwerless#28
working thanks ^^
10/23/2011 13:47 alger#29
Quote:
Originally Posted by DaxterSoul View Post
Here is the SQL Fix


And execute for each fortress

Code:
-- Jangan
EXEC	[dbo].[_InsertSiegeFortressStruct]
		@FortressID = 1
-- Hotan
EXEC	[dbo].[_InsertSiegeFortressStruct]
		@FortressID = 3
-- Bandit
EXEC	[dbo].[_InsertSiegeFortressStruct]
		@FortressID = 6
The only time excute?
10/24/2011 03:10 kobi92#30
Well, just used yours @DaxterSoul... but have some issues:

1st Gameserver - invalid Register Siege Struct gen position is designated! [structure_pos_ja_defensive_17] : [65535, 0.000000, 0.000000, 0.000000]
Picture for the view: [Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]


2nd Gameserver spamming with - invalid Register Siege Struct gen position is designated! [structure_pos_bj_barricade_11] : [17486, 1410.040161, 1461.596191, 803.926208]
Picture for the view: [Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]


Really wierd ><
Page 2 of 3 1 2 3