Clean SRO_VT_SHARD_INIT with deafult fortress war structure

[sladlejrhfpq]

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:

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

[MentaL]

[hectormousa]

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

[sladlejrhfpq]

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 ^_^

[Artuuro_lv]

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

[sladlejrhfpq]

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

did you make it from my?

[hectormousa]

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..

[sladlejrhfpq]

: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.

[kobimodel]

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


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

[sladlejrhfpq]

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

[driver13]

have a clean db problem?

[Jenzo]

any way thx

[gloors]

i get the error saying its not hard coded?

[mariustopor]

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

[gloors]

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

[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