Clean SRO_VT_SHARD_INIT with deafult fortress war structure

Hi guys, yesterday i made the default fortress war structure with my brother. Lots of ppl have a problem that they can not attack the fortress gates etc.

What did i do?

-All Guard Towers are Phase 1
-All Fortress Hearts are Phase 1
-All Defense Camps are Phase Zero
-All Obstacles added

Download link:
www.megaupload.com/?d=G6NVWSWU
Just restore the database, and fortress problem gone ^^

Or if anybody needs only the table:
clean the dbo._SiegeFortressStruct table(if it contains anything)
and copy the following lines:

Code:

1 0 84 19538 936000 2011.10.20. 15:06:00 0 1 0 85 19521 464000 2011.10.20. 15:06:00 0 1 0 86 19521 464000 2011.10.20. 15:06:00 0 1 0 87 19521 464000 2011.10.20. 15:06:00 0 1 0 88 19504 936000 2011.10.20. 15:06:00 0 1 0 89 19504 936000 2011.10.20. 15:06:00 0 1 0 90 19504 936000 2011.10.20. 15:06:00 0 1 0 91 19509 0 2011.10.20. 15:06:00 0 1 0 92 19509 0 2011.10.20. 15:06:00 0 1 0 93 19509 0 2011.10.20. 15:06:00 0 1 0 94 19509 0 2011.10.20. 15:06:00 0 1 0 95 19509 0 2011.10.20. 15:06:00 0 1 0 96 19509 0 2011.10.20. 15:06:00 0 1 0 97 19515 0 2011.10.20. 15:06:00 0 1 0 98 19515 0 2011.10.20. 15:06:00 0 1 0 99 19515 0 2011.10.20. 15:06:00 0 1 0 100 19515 0 2011.10.20. 15:06:00 0 1 0 101 19515 0 2011.10.20. 15:06:00 0 1 0 102 19515 0 2011.10.20. 15:06:00 0 1 0 103 19515 0 2011.10.20. 15:06:00 0 1 0 104 19515 0 2011.10.20. 15:06:00 0 1 0 105 19515 0 2011.10.20. 15:06:00 0 1 0 106 19515 0 2011.10.20. 15:06:00 0 1 0 107 19515 0 2011.10.20. 15:06:00 0 1 0 108 19515 0 2011.10.20. 15:06:00 0 1 0 127 19543 0 2011.10.20. 16:25:00 0 1 0 128 19543 0 2011.10.20. 16:25:00 0 1 0 129 19543 0 2011.10.20. 16:25:00 0 1 0 130 19543 0 2011.10.20. 16:25:00 0 1 0 131 19543 0 2011.10.20. 16:25:00 0 1 0 132 19543 0 2011.10.20. 16:25:00 0 1 0 133 19543 0 2011.10.20. 16:25:00 0 1 0 134 19543 0 2011.10.20. 16:25:00 0 1 0 135 19543 0 2011.10.20. 16:25:00 0 1 0 136 19543 0 2011.10.20. 16:25:00 0 3 0 180 19610 936000 2011.10.19. 22:00:00 0 3 0 181 19521 464000 2011.10.19. 22:00:00 0 3 0 182 19521 464000 2011.10.19. 22:00:00 0 3 0 183 19521 464000 2011.10.19. 22:00:00 0 3 0 184 19575 936000 2011.10.19. 22:00:00 0 3 0 185 19575 936000 2011.10.19. 22:00:00 0 3 0 186 19575 936000 2011.10.19. 22:00:00 0 3 0 187 19509 0 2011.10.19. 22:00:00 0 3 0 188 19509 0 2011.10.19. 22:00:00 0 3 0 189 19509 0 2011.10.19. 22:00:00 0 3 0 190 19509 0 2011.10.19. 22:00:00 0 3 0 191 19509 0 2011.10.19. 22:00:00 0 3 0 192 19509 0 2011.10.19. 22:00:00 0 3 0 193 19515 0 2011.10.19. 22:00:00 0 3 0 194 19515 0 2011.10.19. 22:00:00 0 3 0 195 19515 0 2011.10.19. 22:00:00 0 3 0 196 19515 0 2011.10.19. 22:00:00 0 3 0 197 19515 0 2011.10.19. 22:00:00 0 3 0 198 19515 0 2011.10.19. 22:00:00 0 3 0 199 19515 0 2011.10.19. 22:00:00 0 3 0 200 19515 0 2011.10.19. 22:00:00 0 3 0 201 19515 0 2011.10.19. 22:00:00 0 3 0 202 19515 0 2011.10.19. 22:00:00 0 3 0 224 19543 0 2011.10.19. 22:00:00 0 3 0 225 19543 0 2011.10.19. 22:00:00 0 3 0 226 19543 0 2011.10.19. 22:00:00 0 3 0 227 19543 0 2011.10.19. 22:00:00 0 3 0 228 19543 0 2011.10.19. 22:00:00 0 3 0 229 19543 0 2011.10.19. 22:00:00 0 3 0 230 19543 0 2011.10.19. 22:00:00 0 3 0 231 19543 0 2011.10.19. 22:00:00 0 6 0 137 19625 464000 2011.10.19. 15:10:00 0 6 0 138 19521 464000 2011.10.19. 15:10:00 0 6 0 139 19521 464000 2011.10.19. 15:10:00 0 6 0 140 19590 464000 2011.10.19. 15:10:00 0 6 0 141 19590 464000 2011.10.19. 15:10:00 0 6 0 142 19509 0 2011.10.19. 15:10:00 0 6 0 143 19509 0 2011.10.19. 15:10:00 0 6 0 144 19509 0 2011.10.19. 15:10:00 0 6 0 145 19509 0 2011.10.19. 15:10:00 0 6 0 146 19515 0 2011.10.19. 15:10:00 0 6 0 147 19515 0 2011.10.19. 15:10:00 0 6 0 148 19515 0 2011.10.19. 15:10:00 0 6 0 149 19515 0 2011.10.19. 15:10:00 0 6 0 150 19515 0 2011.10.19. 15:10:00 0 6 0 151 19515 0 2011.10.19. 15:10:00 0 6 0 152 19515 0 2011.10.19. 15:10:00 0 6 0 153 19515 0 2011.10.19. 15:10:00 0 6 0 154 19515 0 2011.10.19. 15:10:00 0 6 0 155 19515 0 2011.10.19. 15:10:00 0 6 0 172 19543 0 2011.10.19. 15:10:00 0 6 0 173 19543 0 2011.10.19. 15:10:00 0 6 0 174 19543 0 2011.10.19. 15:10:00 0 6 0 175 19543 0 2011.10.19. 15:10:00 0 6 0 176 19543 0 2011.10.19. 15:10:00 0 6 0 177 19543 0 2011.10.19. 15:10:00 0 6 0 178 19543 0 2011.10.19. 15:10:00 0 6 0 179 19543 0 2011.10.19. 15:10:00 0 1 0 118 19641 80000 2011.10.20. 17:42:59 0 3 0 221 23934 80000 2011.10.20. 17:43:26 0 1 0 117 19641 80000 2011.10.20. 17:43:37 0 1 0 116 19642 80000 2011.10.20. 17:44:14 0 1 0 124 19642 80000 2011.10.20. 17:44:50 0 1 0 126 19550 80000 2011.10.20. 17:45:29 0 1 0 114 19641 80000 2011.10.20. 17:46:09 0 1 0 113 19641 80000 2011.10.20. 17:46:46 0 3 0 222 23934 80000 2011.10.20. 17:47:11 0 1 0 122 19643 80000 2011.10.20. 17:47:22 0 3 0 220 19640 80000 2011.10.20. 17:47:53 0 1 0 121 19643 80000 2011.10.20. 17:48:07 0 3 0 215 19640 80000 2011.10.20. 17:48:54 0 1 0 120 19643 80000 2011.10.20. 17:49:10 0 3 0 213 19640 80000 2011.10.20. 17:49:48 0 1 0 119 19643 80000 2011.10.20. 17:49:54 0 1 0 112 19641 80000 2011.10.20. 17:50:44 0 3 0 211 19640 80000 2011.10.20. 17:50:59 0 1 0 111 19641 80000 2011.10.20. 17:51:23 0 3 0 210 19640 80000 2011.10.20. 17:51:48 0 1 0 115 19642 80000 2011.10.20. 17:52:27 0 1 0 123 19642 80000 2011.10.20. 17:53:17 0 3 0 219 19640 80000 2011.10.20. 17:53:27 0 3 0 217 19640 80000 2011.10.20. 17:55:13 0 1 0 110 19643 80000 2011.10.20. 17:56:16 0 3 0 218 19640 80000 2011.10.20. 17:56:34 0 3 0 216 19640 80000 2011.10.20. 17:57:10 0 1 0 109 19643 80000 2011.10.20. 17:57:54 0 3 0 214 19640 80000 2011.10.20. 17:58:15 0 3 0 212 19640 80000 2011.10.20. 17:59:14 0 3 0 223 19640 80000 2011.10.20. 17:59:51 0 3 0 209 19640 80000 2011.10.20. 18:00:30 0 3 0 208 19640 80000 2011.10.20. 18:01:29 0 3 0 207 19640 80000 2011.10.20. 18:02:15 0 6 0 167 19640 80000 2011.10.20. 18:02:20 0 3 0 206 23933 80000 2011.10.20. 18:02:56 0 6 0 171 19640 80000 2011.10.20. 18:03:36 0 3 0 205 23933 80000 2011.10.20. 18:03:45 0 3 0 204 23933 80000 2011.10.20. 18:04:25 0 3 0 203 23933 80000 2011.10.20. 18:05:10 0 6 0 169 23932 80000 2011.10.20. 18:05:16 0 6 0 168 23932 80000 2011.10.20. 18:05:55 0 6 0 166 19640 80000 2011.10.20. 18:06:32 0 6 0 156 19640 80000 2011.10.20. 18:07:08 0 6 0 162 23932 80000 2011.10.20. 18:07:49 0 6 0 163 23932 80000 2011.10.20. 18:08:27 0 6 0 164 23932 80000 2011.10.20. 18:09:04 0 6 0 165 23932 80000 2011.10.20. 18:09:47 0 6 0 170 19640 80000 2011.10.20. 18:10:29 0 6 0 161 19640 80000 2011.10.20. 18:11:13 0 6 0 157 19640 80000 2011.10.20. 18:11:59 0 6 0 160 19640 80000 2011.10.20. 18:12:36 0 6 0 158 23932 80000 2011.10.20. 18:13:14 0 6 0 159 23932 80000 2011.10.20. 18:13:59 0

Re: [Release] Clean SRO_VT_SHARD_INIT with deafult fortress war structure

i was tring to dumb it but it was only dump the table so nice release this's will help people alot :D

Re: [Release] Clean SRO_VT_SHARD_INIT with deafult fortress war structure

Quote:

Originally Posted by hectormousa

i was tring to dumb it but it was only dump the table so nice release this's will help people alot :D

thank you, took me 3 days ^_^

Re: [Release] Clean SRO_VT_SHARD_INIT with deafult fortress war structure

http://sroparadise.org/dl/_SiegeFortressStruct.txt - CSV version.

Re: [Release] Clean SRO_VT_SHARD_INIT with deafult fortress war structure

Quote:

Originally Posted by Artuuro_lv

http://sroparadise.org/dl/_SiegeFortressStruct.txt - CSV version.

did you make it from my?

Re: [Release] Clean SRO_VT_SHARD_INIT with deafult fortress war structure

Quote:

Originally Posted by sladlejrhfpq

thank you, took me 3 days ^_^

:D it's already done but in the original database files i got it from there and just change the date etc..

Re: [Release] Clean SRO_VT_SHARD_INIT with deafult fortress war structure

Quote:

Originally Posted by hectormousa

:D it's already done but in the original database files i got it from there and just change the date etc..

but the obstacles are not added, because after fortress war, all existing obstacles deleted, and the level of each objects are not like it should be at a clean server.

Re: [Release] Clean SRO_VT_SHARD_INIT with deafult fortress war structure

Quote:

Originally Posted by Artuuro_lv

http://sroparadise.org/dl/_SiegeFortressStruct.txt - CSV version.

CSV ?

Anyways tried yours and the other one too.. two of them just corrupt i guess..

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: http://i53.tinypic.com/huli5u.jpg
http://i53.tinypic.com/huli5u.jpg

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: http://i53.tinypic.com/2q0u5ug.jpg
http://i53.tinypic.com/2q0u5ug.jpg

Re: [Release] Clean SRO_VT_SHARD_INIT with deafult fortress war structure

download the full database, and try with it
did you clean your table before adding this?

Re: [Release] Clean SRO_VT_SHARD_INIT with deafult fortress war structure

have a clean db problem?

Re: [Release] Clean SRO_VT_SHARD_INIT with deafult fortress war structure

any way thx

Re: [Release] Clean SRO_VT_SHARD_INIT with deafult fortress war structure

i get the error saying its not hard coded?

Re: [Release] Clean SRO_VT_SHARD_INIT with deafult fortress war structure

how should i execute it arturo...because its giving me headakes!!!..can you share the code..thanks

Re: [Release] Clean SRO_VT_SHARD_INIT with deafult fortress war structure

Can anyone help me :x lol. Just wanna know how to removed the not hardcoded error im getting =/

Re: [Release] Clean SRO_VT_SHARD_INIT with deafult fortress war structure

i am receiveing the same error as kobimodel
i also cleaned my table with cezeland query
and added the default structure u posted+ default _siege fortress data
1 0 0 0 0 0 NULL NULL 0 1
3 0 0 0 0 0 NULL NULL 0 1
6 0 0 0 0 0 NULL NULL 0 1
if i had it empty i couldnt port to forts at all
but there was no error msg...but when you put the above stats u can port to fort but u get those errors in gameservers

Re: [Release] Clean SRO_VT_SHARD_INIT with deafult fortress war structure

Quote:

Originally Posted by mariustopor

i am receiveing the same error as kobimodel
i also cleaned my table with cezeland query
and added the default structure u posted+ default _siege fortress data
1 0 0 0 0 0 NULL NULL 0 1
3 0 0 0 0 0 NULL NULL 0 1
6 0 0 0 0 0 NULL NULL 0 1
if i had it empty i couldnt port to forts at all
but there was no error msg...but when you put the above stats u can port to fort but u get those errors in gameservers

try to use the clean db i uploaded:

MEGAUPLOAD - The leading online storage and file delivery service

gameserver will give you error invalid register siege struct pos_ja_defensive_17, but it works anyway, just ja_defensive_17 is turned off(setvice 0) in the db.
or try this:

PHP Code:

1 0 0 0 0 0 This fortress is free! NULL 0 1 3 0 0 0 0 0 This fortress is free! NULL 0 1 6 0 0 0 0 0 This fortress is free! NULL 0 1

i use the same database as you, i know siegefortress is nearly the same, i think the easiest way to solve to download my db ^^

i will fix that error and update the first post soon.

Re: [Release] Clean SRO_VT_SHARD_INIT with deafult fortress war structure

and do i have to enable them from db?...i hope they wont result in game crashes!

Re: [Release] Clean SRO_VT_SHARD_INIT with deafult fortress war structure

Quote:

Originally Posted by mariustopor

and do i have to enable them from db?...i hope they wont result in game crashes!

if you use my db, just back it up, and fortress working

Re: [Release] Clean SRO_VT_SHARD_INIT with deafult fortress war structure

Quote:

Originally Posted by kobimodel

CSV ?

Anyways tried yours and the other one too.. two of them just corrupt i guess..

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: http://i53.tinypic.com/huli5u.jpg
http://i53.tinypic.com/huli5u.jpg

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: http://i53.tinypic.com/2q0u5ug.jpg
http://i53.tinypic.com/2q0u5ug.jpg

same here

Re: [Release] Clean SRO_VT_SHARD_INIT with deafult fortress war structure

Maybe the link is bad,I cant download.who can send me the database ?thank

minfanren2002@163.com

Re: [Release] Clean SRO_VT_SHARD_INIT with deafult fortress war structure

Yeh, a reupload to anybody that has it please?

Re: [Release] Clean SRO_VT_SHARD_INIT with deafult fortress war structure

The file you are trying to access is temporarily unavailable. Please try again later.

Re: [Release] Clean SRO_VT_SHARD_INIT with deafult fortress war structure

Quote:

Originally Posted by redster

The file you are trying to access is temporarily unavailable. Please try again later.

Badnit Fortress was the only one that 100% worked for me.
Jangan gives me hardcoded bug.
And Hotan dcs people on the Bridge near the gate.

Anyone want to help me fix them? I can pay if they aren't full of shit.

Uploaded again since his link is fail.
Download Clean Fortress Shard Database

Re: [Release] Clean SRO_VT_SHARD_INIT with deafult fortress war structure

i will upload it

SRO_VT_SHARD_INIT_fortress100.BAK new link for it

Re: [Release] Clean SRO_VT_SHARD_INIT with deafult fortress war structure

Quote:

Originally Posted by hectormousa

i will upload it

SRO_VT_SHARD_INIT_fortress100.BAK new link for it

Mine is better, if you compress it into a rar file, its only 5mb download....