Register for your free account! | Forgot your password?

You last visited: Today at 14:55

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement


Advertise with us!

Fortress bug gate

Discussion on Fortress bug gate within the SRO Private Server forum part of the Silkroad Online category.

Reply
Page 2 of 3 1 2 3
 
Old 10/14/2011, 22:00   #16
 
3lyka's Avatar
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Feb 2008
Posts: 649
Received Thanks: 320
Gates is like npc\mob right? and maybe the fortress npc\mobs with service 0? mean disable..? What you think?
3lyka is offline  
Old 10/14/2011, 22:19   #17
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jun 2011
Posts: 31
Received Thanks: 4
tell me what table it is in sql and I will check if is working
unkwerless is offline  
Old 10/15/2011, 11:18   #18
 
CrystalCoder's Avatar
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Mar 2008
Posts: 1,138
Received Thanks: 252
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?
CrystalCoder is offline  
Old 10/22/2011, 19:14   #19
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jun 2011
Posts: 31
Received Thanks: 4
still nobody know?
unkwerless is offline  
Old 10/22/2011, 20:50   #20
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jan 2009
Posts: 314
Received Thanks: 686
@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.
DaxterSoul is offline  
Thanks
1 User
Old 10/22/2011, 21:49   #21
 
elite*gold: 0
The Black Market: 1/0/0
Join Date: Sep 2011
Posts: 121
Received Thanks: 8
you cant fix FW becose you need some files thet no 1 will relase(i dont )
sbhtkvnkl34 is offline  
Old 10/22/2011, 23:27   #22
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jun 2011
Posts: 31
Received Thanks: 4
anyone have a query for the fortress structure "original backup" ? cuz my original backup its empty

thanks
unkwerless is offline  
Old 10/23/2011, 00:42   #23
 
3lyka's Avatar
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Feb 2008
Posts: 649
Received Thanks: 320
_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
3lyka is offline  
Old 10/23/2011, 01:00   #24
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jun 2011
Posts: 31
Received Thanks: 4
can u do it in a query? it will take me ages to write all these manually
thanks for this also ^^
unkwerless is offline  
Old 10/23/2011, 01:11   #25
 
3lyka's Avatar
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Feb 2008
Posts: 649
Received Thanks: 320
Quote:
Originally Posted by unkwerless View Post
can u do it in a query? 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
3lyka is offline  
Old 10/23/2011, 01:20   #26
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jun 2011
Posts: 31
Received Thanks: 4
I will give it a shot ^^
thanks for the advice
unkwerless is offline  
Old 10/23/2011, 02:17   #27
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jan 2009
Posts: 314
Received Thanks: 686
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
DaxterSoul is offline  
Thanks
1 User
Old 10/23/2011, 03:23   #28
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jun 2011
Posts: 31
Received Thanks: 4
working thanks ^^
unkwerless is offline  
Old 10/23/2011, 13:47   #29
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Sep 2009
Posts: 137
Received Thanks: 14
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?
alger is offline  
Old 10/24/2011, 03:10   #30
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jan 2008
Posts: 204
Received Thanks: 82
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:



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:



Really wierd ><
kobi92 is offline  
Reply
Page 2 of 3 1 2 3

« FallenAngels recruiting/Info | Crash at Behemoth and Dark Lizard Pet »

Similar Threads Similar Threads
[Energy Gate Clicker] Dark Galaxy Gate :) V. 1.6.5
12/23/2011 - DarkOrbit - 12 Replies
Hello, becouse this Thread -> http://www.elitepvpers.com/forum/darkorbit/782730- dark-galaxy-gate-energie-klicker.html <- isn't going to be updated anymore (the user is banned) i thought i will just upload the newest version of it :) DarkGalaxyGate http://i54.tinypic.com/2nc0846.jpg http://i52.tinypic.com/2jhyxc.jpg



All times are GMT +1. The time now is 14:56.

elitepvpers - play less, get more - Top

Powered by vBulletin®
Copyright ©2000 - 2026, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2026 elitepvpers All Rights Reserved.