How to add JUPITER Map.

[sladlejrhfpq]

Hi guys!
Finally, after weeks of trying i could make it work. Yes it caused me lots of headache, but it is working, and i am not selfish, i will share it with everybody, because i've received so much help with silkroad server here, and i want to give something for it.

Who helped me: TryToMakeServer,Nah001,mariustopor,Kemo,asderdd


-JUPITER FIELD WORKING
-HALL OF WORSHIP WORKING
-ZEALOTS HIDEOUT WORKING

- Download KSRO
- After the download finished, start it, and let it update.
- Download PK2Tools, and extract ksro's Data.pk2 somewhere.
- Go to your server's directory, delete "Data" folder, and copy the one you extracted.

Editing the database:

!!!I USE SRO_VT_SHARD_INIT AT MY QUERIES, IF YOUR DATABASE NAME IS DIFFERENT DONT FORGET TO EDIT IT!!!

-You have to add some missing lines to it.
-Missing lines from _RefRegion table:

24009	201	93	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
24010	202	93	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
24011	203	93	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
24012	204	93	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
24013	205	93	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
24014	206	93	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
24015	207	93	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
24016	208	93	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
24017	209	93	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
24265	201	94	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
24266	202	94	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
24267	203	94	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
24268	204	94	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
24269	205	94	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
24270	206	94	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
24271	207	94	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
24521	201	95	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
24522	202	95	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
24523	203	95	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
24524	204	95	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
24525	205	95	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
24526	206	95	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
24527	207	95	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
24777	201	96	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
24778	202	96	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
24779	203	96	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
24780	204	96	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
24781	205	96	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
24782	206	96	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
24783	207	96	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
25033	201	97	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
25034	202	97	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
25035	203	97	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
25036	204	97	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
25037	205	97	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
25038	206	97	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
25039	207	97	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
25289	201	98	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
25290	202	98	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
25291	203	98	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
25292	204	98	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
25293	205	98	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
25294	206	98	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
25295	207	98	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
25545	201	99	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
25546	202	99	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
25547	203	99	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
25548	204	99	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
25549	205	99	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
25550	206	99	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
25551	207	99	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
31723	235	123	JUPITER	???? A??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
31724	236	123	JUPITER	???? A??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
31725	237	123	JUPITER	???? A??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
31979	235	124	JUPITER	???? A??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
31980	236	124	JUPITER	???? A??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
31981	237	124	JUPITER	???? A??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
32235	235	125	JUPITER	???? A??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
32236	236	125	JUPITER	???? A??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
32237	237	125	JUPITER	???? A??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-32749	0	0	JUPITER	???? A??_???	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-32748	0	0	JUPITER	???? A??_??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-32747	0	0	JUPITER	???? A??_????	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-32746	0	0	JUPITER	???? B??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
21707	203	84	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
21708	204	84	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
21962	202	85	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
21963	203	85	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
21964	204	85	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
21965	205	85	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
21966	206	85	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
21967	207	85	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
22217	201	86	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
22218	202	86	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
22219	203	86	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
22220	204	86	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
22221	205	86	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
22222	206	86	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
22223	207	86	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
22224	208	86	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
22473	201	87	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
22474	202	87	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
22475	203	87	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
22476	204	87	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
22477	205	87	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
22478	206	87	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
22479	207	87	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
22480	208	87	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
22481	209	87	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
22482	210	87	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
22729	201	88	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
22730	202	88	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
22731	203	88	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
22732	204	88	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
22733	205	88	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
22734	206	88	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
22735	207	88	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
22736	208	88	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
22737	209	88	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
22738	210	88	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
22985	201	89	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
22986	202	89	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
22987	203	89	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
22988	204	89	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
22989	205	89	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
22990	206	89	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
22991	207	89	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
22992	208	89	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
22993	209	89	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
22994	210	89	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
23241	201	90	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
23242	202	90	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
23243	203	90	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
23244	204	90	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
23245	205	90	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
23246	206	90	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
23247	207	90	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
23248	208	90	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
23249	209	90	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
23250	210	90	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
23497	201	91	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
23498	202	91	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
23499	203	91	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
23500	204	91	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
23501	205	91	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
23502	206	91	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
23503	207	91	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
23504	208	91	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
23505	209	91	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
23506	210	91	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
23753	201	92	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
23754	202	92	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
23755	203	92	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
23756	204	92	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
23757	205	92	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
23758	206	92	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
23759	207	92	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
23760	208	92	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
23761	209	92	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
23762	210	92	JUPITER	???? ?? ??	1	3001	-1	0	0	xxx	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL

-Missing lines from _RefTeleLink table:

1	206	207	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
1	207	206	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
1	208	219	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
1	208	209	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
1	208	210	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
1	208	220	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
1	208	211	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
1	208	213	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
1	209	208	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
1	210	208	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
1	211	208	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
1	212	208	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
1	213	208	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
1	214	208	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
1	215	208	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
1	216	208	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
1	217	208	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
1	218	208	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
1	219	208	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
1	220	208	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
1	221	208	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
1	222	208	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
1	223	208	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0

Download RefTeleLink and RefRegion missing lines in txt: http://www.mediafire.com/?277w1tut9n2u1dc

-You have to enable the teleports at the _RefTeleport table, to do this, just execute this query:

USE [SRO_VT_SHARD_INIT]
UPDATE dbo._RefTeleport SET Service=1 WHERE CodeName128 LIKE '%JUPITER%' 

-You have to enable the teleports at _RefObjCommon table
-Do this with this query:

USE [SRO_VT_SHARD_INIT]
UPDATE dbo._RefObjCommon SET Service=1 WHERE CodeName128 LIKE '%JUPITER%GATE%'
UPDATE dbo._RefObjCommon SET Service=1 WHERE CodeName128='STORE_JUPITER_B1_2_TO_JUPITER' 

-You have to enable some JUPITER related stuff at _RefGame_World_Config
-Use this query:

USE [SRO_VT_SHARD_INIT]
UPDATE dbo._RefGame_World_Config SET Service=1 WHERE GroupCodeName128 LIKE '%JUPITER%' 

-You have to edit the stored procedure called "_LinkRefRegions"

set ANSI_NULLS OFF
set QUOTED_IDENTIFIER ON
GO


ALTER PROCEDURE [dbo].[_LinkRefRegions]
AS

--- Blow Query is Each Area and FORT matching ---
declare @China         int    
declare @West_China    int
declare @Oasis_Kingdom    int
declare @Eu        int
declare @Am        int
declare @Ca        int
declare @JUPITER int

select @China        = AssocServer from _RefRegionBindAssocServer where AreaName = 'CHINA'
select @West_China    = AssocServer from _RefRegionBindAssocServer where AreaName = 'West_China'
select @Oasis_Kingdom     = AssocServer from _RefRegionBindAssocServer where AreaName = 'Oasis_Kingdom'
select @Eu        = AssocServer from _RefRegionBindAssocServer where AreaName = 'Eu'
select @Am        = AssocServer from _RefRegionBindAssocServer where AreaName = 'Am'
select @Ca        = AssocServer from _RefRegionBindAssocServer where AreaName = 'Ca'
select @JUPITER = AssocServer from _RefRegionBindAssocServer where AreaName = 'JUPITER'

update _RefRegionBindAssocServer set AssocServer = @China         where AreaName = 'FORT_JA_AREA'
update _RefRegionBindAssocServer set AssocServer = @China         where AreaName = 'FORT_BJ_AREA'
update _RefRegionBindAssocServer set AssocServer = @West_China         where AreaName = 'FORT_DW_AREA'
update _RefRegionBindAssocServer set AssocServer = @West_China         where AreaName = 'FORT_HM_AREA'
update _RefRegionBindAssocServer set AssocServer = @Oasis_Kingdom     where AreaName = 'FORT_HT_AREA'
update _RefRegionBindAssocServer set AssocServer = @Eu             where AreaName = 'FORT_CT_AREA'
update _RefRegionBindAssocServer set AssocServer = @Am             where AreaName = 'FORT_ER_AREA'
update _RefRegionBindAssocServer set AssocServer = @Ca            where AreaName = 'FORT_SK_AREA'
update _RefRegionBindAssocServer set AssocServer = @JUPITER where AreaName = 'JUPITER' 

begin TRANSACTION
begin    
    declare @LinkNum        int
    declare @this_region    int
    declare @region_x        int
    declare @region_z        int
    declare @wRegionID    smallint
    declare @wTempRID    smallint
    declare @col_link        varchar(256)
    declare @query            varchar(256)
    declare @db_id_to_link    smallint
    
    -- clear all existing region link
    set @LinkNum = 1
    while (@LinkNum <= 10)
    begin
        set @query = 'update _RefRegion set LinkedRegion_' + cast(@LinkNum as varchar(10)) + ' = 0'
        execute (@query)
        
        set @LinkNum = @LinkNum + 1
    end
    -- loop all region
    declare region_cursor CURSOR FOR
    select     wRegionID
    from    _RefRegion
    OPEN region_cursor
    FETCH NEXT FROM region_cursor INTO @wRegionID
    WHILE @@FETCH_STATUS = 0
    begin        
        if (@@error = 0 and @wRegionID <> 0)
        begin
            -- ´øÀüÀº ½ºÅµ!
            if (@wRegionID > 0)
            begin
                set @LinkNum = 8
                while (@LinkNum >= 0)
                begin
                    set @region_z = (@wRegionID & 0xff00) / 256
                    set @region_x = (@wRegionID & 0x0ff)
                    set @wTempRID = 0;
                                    
                    if (@LinkNum = 0)
                    begin
                        set @region_x = @region_x - 1
                        set @col_link = 'LinkedRegion_1'
                    end
                    else if (@LinkNum = 1)
                    begin
                        set @region_x = @region_x - 1
                        set @region_z = @region_z + 1
                        set @col_link = 'LinkedRegion_2'
                    end
                    else if (@LinkNum = 2)
                    begin
                        set @region_z = @region_z + 1
                        set @col_link = 'LinkedRegion_3'
                    end
                    else if (@LinkNum = 3)
                    begin
                        set @region_x = @region_x + 1
                        set @region_z = @region_z + 1
                        set @col_link = 'LinkedRegion_4'
                    end
                    else if (@LinkNum = 4)
                    begin
                        set @region_x = @region_x + 1
                        set @col_link = 'LinkedRegion_5'
                    end
                    else if (@LinkNum = 5)
                    begin
                        set @region_x = @region_x + 1
                        set @region_z = @region_z - 1
                        set @col_link = 'LinkedRegion_6'
                    end
                    else if (@LinkNum = 6)
                    begin
                        set @region_z = @region_z - 1
                        set @col_link = 'LinkedRegion_7'
                    end
                    else if (@LinkNum = 7)
                    begin
                        set @region_x = @region_x - 1
                        set @region_z = @region_z - 1
                        set @col_link = 'LinkedRegion_8'
                    end
    
                    set @wTempRID = (@region_z & 0x00ff) * 256
                    set @wTempRID = @wTempRID + (@region_x & 0x00ff)
    
                    select @db_id_to_link = wRegionID
                    from _RefRegion
                    where wRegionID = @wTempRID
    
                    if (@@ROWCOUNT <> 0)
                    begin
                        set @query = 'update _RefRegion set  ' + @col_link + ' = ' + cast(@db_id_to_link as varchar(10)) + ' where wRegionID = ' + cast(@wRegionID as varchar(10))
                    end
                    else    -- Á¸ÀçÇÏÁö ¾Ê´Â region link ´Â 0À¸·Î ä¿î´Ù
                    begin
                        set @query = 'update _RefRegion set  ' + @col_link + ' = 0 where wRegionID = ' + cast(@wRegionID as varchar(10))
                    end
    
                    execute(@query)
                set @LinkNum = @LinkNum - 1
                end
            end
        end
    FETCH NEXT FROM region_cursor INTO @wRegionID
    end
    
    CLOSE region_cursor
    DEALLOCATE region_cursor
    COMMIT TRANSACTION
end 

-After you edited it, you have to execute.

USE [SRO_VT_SHARD_INIT]
exec _LinkRefRegions 

-You have to put some lines to _RefInstance_World_Region table.
RefInstance_World_Region created by Nah001
Download it and execute: http://www.multiupload.com/CT9W6DAS1P

Add these lines to _RefInstance_World_Start_Pos table:

90	23498	253	-204	1519	0
90	22219	837	475	1901	0
86	32236	950	880	900	0
88	32236	830	880	900	0
87	-32746	-2	1	-137	0
89	-32746	-3	1	-131	0
89	-32746	1080	1	630	0
87	-32746	1700	1	900	0
87	-32746	-1423	1	839	0
87	-32746	46	1	-1697	0
89	-32746	-1418	1	838	0
89	-32746	48	1	-1698	0
93	32236	950	880	900	0
94	-32746	-2	1	-137	0
94	-32746	46	1	-1697	0
94	-32746	-1423	1	839	0
94	-32746	1700	1	900	0

Execute this query, so the Hall of Worship and Zealots Hideout will work like a normal region:

USE [SRO_VT_SHARD_INIT]
UPDATE dbo._RefGame_World SET Type=0 WHERE WorldCodeName128 LIKE '%JUPITER%' 

You are done with JUPITER.

Now, you just need a client. I recommend you to use Violent Online Client: Violent Online::Home

You have to use IPInput to change the version of the client, because it will not connect to your server, it has ver 1.005.
you can find a post about it here: http://forum.ragezone.com/f722/tool-ipinput-780264/
unless you change the blowfish key, it will not open your media.pk2, read the comments and you will find what you have to do.

Copy KSRO's data.pk2 and particles.pk2 to this client, and you can start.

GUIDE CREATED BY SLADLEJRHFPQ
THANKS FOR HELPING ME Nah001, Kemo, mariustopor AND asderdd.

Press Thanks if i helped you.

[MentaL]

[Nah001]

lol Kemo ? and funny stuff this kid edit it with RefInstance World Region by Kemo.rar
i dumped this table and attached it here
this my Source Server : 85.65.37.242
lol

[sladlejrhfpq]

lol Kemo ? and funny stuff this kid edit it with RefInstance World Region by Kemo.rar
i dumped this table and attached it here
this my Source Server : 85.65.37.242
lol

And i was the one who edited the name, because i didnt want to act like i made it.
i said i dont know who made this file, i got it from him, so thanks to you, it is working.

Sorry for that, the post edited. I didnt know it made by you.

[olumculnuke]

_RefInstance_World_Region_by_Kemo.rar Dont work please reupload

Very thanks very fast :D

[sladlejrhfpq]

_RefInstance_World_Region_by_Kemo.rar Dont work please reupload

Very thanks very fast :D

Multiupload.com - upload your files to multiple file hosting sites!

It created by Nah001.

[mariustopor]

ill release tomorrow a fully working version of refinstance_world_region..still working on it...
Posted via Mobile Device

[sladlejrhfpq]

ill release tomorrow a fully working version of refinstance_world_region..still working on it...
Posted via Mobile Device

good ^^
btw, when i try to teleport to 111 instance, my client crashes, but the gameserver does not give any errors, so maybe there is a problem with the client.

[Nubwaffle]

Thanks alot for this thread but i'm getting this error:

REGIONMGR failed to load 32787(x:19, z:128) region
Create Game World Map Failed!!! GAMEWORLDID[1]
Failed to initialize Map
Failed To Load Initial Resource
Failed To Init Local Data
SR_GameServer is initialized successfully

And it is kinda weird cause 32767 is the maximum value and i cannot find anywhere 32787

[Nah001]

extract Data.pk2 from ksro to server Data folder and it will load

in this table some regions was not right i will attach txt which is with right world and region
you can import this to original table


it load dungeon data but, when i tried teleport to Hall of Worship client crashed
so if you have any idea why client crash lol
post here

[Frezze1]

Anyone have a working PK2tool for ksro files?

When i try it with my currently one, i got an C#Runtime Error or it says "Out of Memory" lol i got 16GB Ram xD

best regards

nvm: i have found one ;)

EDIT: After i added all, my SR_GameServer closed instantly after Connection lol -.-

[Kemo]

Here u go This One Working Fine

PK2Tools_0_1.zip

[sladlejrhfpq]

extract Data.pk2 from ksro to server Data folder and it will load

in this table some regions was not right i will attach txt which is with right world and region
you can import this to original table


it load dungeon data but, when i tried teleport to Hall of Worship client crashed
so if you have any idea why client crash lol
post here

is it from regioncode.txt?

[Nah001]

no,it's from refhive refnest..
i don't know with which world those
1 32787 디어스의 방
1 32788 유노의 방
1 32789 유피테르의 방
1 32790 광신도의 은신처
any idea?

[Frezze1]

Load Real Region 90% than the GameServer Close Instantly :F

Iam doing all from post 1



any tips?

EDIT: i think i am doing something wrong in refregion table...need to create it again....took my 1 hour to import them all..omg

[sladlejrhfpq]

Load Real Region 90% than the GameServer Close Instantly :F

Iam doing all from post 1



any tips?

EDIT: i think i am doing something wrong in refregion table...need to create it again....took my 1 hour to import them all..omg

lol, sorry, i will upload the txt files, cuz it would take ages to copy one by one :D

First post updated, now you can download the missing lines for RefTeleLink and RefRegion.

extract Data.pk2 from ksro to server Data folder and it will load

in this table some regions was not right i will attach txt which is with right world and region
you can import this to original table


it load dungeon data but, when i tried teleport to Hall of Worship client crashed
so if you have any idea why client crash lol
post here

I think, something is missing from the media.pk2, i remember, i had the same thing, when i didnt add the EU_TO_JUPITER_FIELD teleport, before i could see it, i got crash, maybe Violent Client have someting missing.