How to add JUPITER Map.

sladlejrhfpq

sladlejrhfpq

Developer
500 Posts
Joined
Oct 12, 2011
Messages
554
Reaction score
321
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:
Code: 
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:

Code: 
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:
To view the content, you need to sign in or register


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

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

PHP: 
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:
To view the content, you need to sign in or register


Add these lines to _RefInstance_World_Start_Pos table:

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

PHP: 
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:
To view the content, you need to sign in or register


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.
 
Last edited:
Re: [RELEASE] How to add JUPITER Map.

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
 
Re: [RELEASE] How to add JUPITER Map.

Nah001 said:
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
Click to expand...

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.
 
Last edited:
Re: [RELEASE] How to add JUPITER Map.

ill release tomorrow a fully working version of refinstance_world_region..still working on it...
 
Re: [RELEASE] How to add JUPITER Map.

mariustopor said:
ill release tomorrow a fully working version of refinstance_world_region..still working on it...
Click to expand...

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.
 
Re: [RELEASE] How to add JUPITER Map.

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
Click to expand...
And it is kinda weird cause 32767 is the maximum value and i cannot find anywhere 32787
 
Re: [RELEASE] How to add JUPITER Map.

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

sladlejrhfpq - How to add JUPITER Map. - RaGEZONE Forums

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
 

Attachments

Last edited:
Re: [RELEASE] How to add JUPITER Map.

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 -.-
 
Last edited:
Re: [RELEASE] How to add JUPITER Map.

Nah001 said:
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

sladlejrhfpq - How to add JUPITER Map. - RaGEZONE Forums

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
Click to expand...

is it from regioncode.txt?
 
Re: [RELEASE] How to add JUPITER Map.

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

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

Iam doing all from post 1

sladlejrhfpq - How to add JUPITER Map. - RaGEZONE Forums


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
 
Last edited:
Re: [RELEASE] How to add JUPITER Map.

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

Iam doing all from post 1

sladlejrhfpq - How to add JUPITER Map. - RaGEZONE Forums


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
Click to expand...

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.

Nah001 said:
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

sladlejrhfpq - How to add JUPITER Map. - RaGEZONE Forums

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
Click to expand...

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.
 
Re: [RELEASE] How to add JUPITER Map.

Hey guys,

anyone can Upload the data folder from your gameserver?

All times iam trying with the KSro data.pk2 and i copy & paste it into the data folder my SR_gameserverexe close after 90% real world loading :S

best regards
 
Re: [RELEASE] How to add JUPITER Map.

I Still can't Teleport i click on Jupiter but nothing happen i do all this steps and i use Violent Client :(
 
Re: [RELEASE] How to add JUPITER Map.

Kemo said:
I Still can't Teleport i click on Jupiter but nothing happen i do all this steps and i use Violent Client :(
Click to expand...

do you see any errors at gameserver? did you add that line to RefInstance_World_Start_Pos?
 
Re: [RELEASE] How to add JUPITER Map.

no i don't add the world id on _RefInstance_World_Region and i teleport but i got dc now i add the new id's the gameserver is not lod the map...
 
Re: [RELEASE] How to add JUPITER Map.

i added the whole map..now i have another problem...some of the teleports are not working:)...and i added the start pos ...and the middle zelos chamber...took me somewhere... And bugged me:)
 
You must log in or register to reply here.

RaGEZONE Sponsor

    HyperFilter

About RaGEZONE

RaGEZONE® is a leading MMO and MMORPG development community offering source codes, server files, tutorials, tools, and private servers for developers and gamers.

Forum Statistics

Members online
2,768
Guests online
10,657
Total visitors
13,425
Totals may include hidden visitors.

RaGEZONE Partners

    non GamStop casinos
Back