Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
stu2000
Perkone Caldari State
9
|
Posted - 2012.07.23 21:28:00 -
[1] - Quote
Dear all, I am confused by the static data. I discovered that if you run the query: SELECT * FROM `mapSolarSystemJumps` GROUP BY `toSolarSystemID` you discover there are just 5,428 systems according to that table. The same result occurs if you group by fromSolarSystemID
However, there are 7,929 systems in the mapSolarSystems table.
Also, whilst doing some breadth first searches on some systems, I am not getting up to 5,427 systems, though this could just be a bug in my code.
Are there some systems that have no stargates to jump in and out of?
Are some groups of systems separated by wormholes? or perhaps some of the systems form 'wormhole' space, and the other systems are the 'normal' systems?
Regards, Stu |
stu2000
Perkone Caldari State
9
|
Posted - 2012.07.23 22:00:00 -
[2] - Quote
continued.... 31000169 31000170 31000171 31000172 31000173 31000174 31000175 31000176 31000177 31000178 31000179 31000180 31000181 31000182 31000183 31000184 31000185 31000186 31000187 31000188 31000189 31000190 31000191 31000192 31000193 31000194 31000195 31000196 31000197 31000198 31000199 31000200 31000201 31000202 31000203 31000204 31000205 31000206 31000207 31000208 31000209 31000210 31000211 31000212 31000213 31000214 31000215 31000216 31000217 31000218 31000219 31000220 31000221 31000222 31000223 31000224 31000225 31000226 31000227 31000228 31000229 31000230 31000231 31000232 31000233 31000234 31000235 31000236 31000237 31000238 31000239 31000240 31000241 31000242 31000243 31000244 31000245 31000246 31000247 31000248 31000249 31000250 31000251 31000252 31000253 31000254 31000255 31000256 31000257 31000258 31000259 31000260 31000261 31000262 31000263 31000264 31000265 31000266 31000267 31000268 31000269 31000270 31000271 31000272 31000273 31000274 31000275 31000276 31000277 31000278 31000279 31000280 31000281 31000282 31000283 31000284 31000285 31000286 31000287 31000288 31000289 31000290 31000291 31000292 31000293 31000294 31000295 31000296 31000297 31000298 31000299 31000300 31000301 31000302 31000303 31000304 31000305 31000306 31000307 31000308 31000309 31000310 31000311 31000312 31000313 31000314 31000315 31000316 31000317 31000318 31000319 31000320 31000321 31000322 31000323 31000324 31000325 31000326 31000327 31000328 31000329 31000330 31000331 31000332 31000333 31000334 31000335 31000336 31000337 31000338 31000339 31000340 31000341 31000342 31000343 31000344 31000345 31000346 31000347 31000348 31000349 31000350 31000351 31000352 31000353 31000354 31000355 31000356 31000357 31000358 31000359 31000360 31000361 31000362 31000363 31000364 31000365 31000366 31000367 31000368 31000369 31000370 31000371 31000372 31000373 31000374 31000375 31000376 31000377 31000378 31000379 31000380 31000381 31000382 31000383 31000384 31000385 31000386 31000387 31000388 31000389 31000390 31000391 31000392 31000393 31000394 31000395 31000396 31000397 31000398 31000399 31000400 31000401 31000402 31000403 31000404 31000405 31000406 31000407 31000408 31000409 31000410 31000411 31000412 31000413 31000414 31000415 31000416 31000417 31000418 31000419 31000420 31000421 31000422 31000423 31000424 31000425 31000426 31000427 31000428 31000429 31000430 31000431 31000432 31000433 31000434 31000435 31000436 31000437 31000438 31000439 31000440 31000441 31000442 31000443 31000444 31000445 31000446 31000447 31000448 31000449 31000450 31000451 31000452 31000453 31000454 31000455 31000456 31000457 31000458 31000459 31000460 31000461 31000462 31000463 31000464 31000465 31000466 31000467 31000468 31000469 31000470 31000471 31000472 31000473 31000474 31000475 31000476 31000477 31000478 31000479 31000480 31000481 31000482 31000483 31000484 31000485 31000486 31000487 31000488 31000489 31000490 31000491 31000492 31000493 31000494 31000495 31000496 31000497 31000498 31000499 31000500 31000501 31000502 31000503 31000504 31000505 31000506 31000507 31000508 31000509 31000510 31000511 31000512 31000513 31000514 31000515 31000516 31000517 31000518 31000519 31000520 31000521 31000522 31000523 31000524 31000525 31000526 31000527 31000528 31000529 31000530 31000531 31000532 31000533 31000534 31000535 31000536 31000537 31000538 31000539 31000540 31000541 31000542 31000543 31000544 31000545 31000546 31000547 31000548 31000549 31000550 31000551 31000552 31000553 31000554 31000555 31000556 31000557 31000558 31000559 31000560 31000561 31000562 31000563 31000564 31000565 31000566 31000567 31000568 31000569 31000570 31000571 31000572 31000573 31000574 31000575 31000576 3100057 |
Cyerus
Galactic Dominion Eternal Strife
46
|
Posted - 2012.07.23 23:12:00 -
[3] - Quote
I didn't check the ids you mentioned, but wormhole systems are in the that table too. And as we all know, wormhole systems don't have gates. |
stu2000
Perkone Caldari State
9
|
Posted - 2012.07.24 06:59:00 -
[4] - Quote
I have never been in wormhole space and did not know this so thank you Im guessing all the systems that start with id 31xxxx are wormhole space and the others that start 30xxx are not. |
Desmont McCallock
194
|
Posted - 2012.07.24 07:04:00 -
[5] - Quote
There are no gates to the Jove (CCP) region. |
stu2000
Perkone Caldari State
9
|
Posted - 2012.07.24 08:00:00 -
[6] - Quote
Desmont McCallock wrote:There are no gates to the Jove (CCP) region. aha! this is probably the main thing I was looking for. I take it this region has gates within it though? |
Desmont McCallock
195
|
Posted - 2012.07.24 08:08:00 -
[7] - Quote
AFAIK, yes. |
stu2000
Perkone Caldari State
9
|
Posted - 2012.07.24 08:21:00 -
[8] - Quote
Im trying to look up Jove's region id (in order to find the matching solar system ids and exclude these systems) however I cannot find it in the mapRegions Table, but I do see: J7HZ-F this isnt it is it?
Stu |
Desmont McCallock
195
|
Posted - 2012.07.24 08:41:00 -
[9] - Quote
CCP Region: UUA-F4 ID: 10000004
Jove Empire Region: A821-A ID: 10000019 Region: J7HZ-F ID: 10000017 |
stu2000
Perkone Caldari State
9
|
Posted - 2012.07.24 19:15:00 -
[10] - Quote
thanks! after adding all of the systems tied to those regions to an ignore list I can see there is no 'bug' in my breadth first search and all remaining systems are connected. |
|
Helios Mech'ai
Shadowfire Enterprises Rura-Penthe
0
|
Posted - 2012.09.10 12:09:00 -
[11] - Quote
Yup, 2498 wormhole systems plus the 3 CCP ones mentioned above |
Seara Arrodan
Arrodan Commodities
0
|
Posted - 2012.09.10 15:39:00 -
[12] - Quote
3 Jove "Systems" or 3 Jove "Regions" if regions how many systems does that contain? |
Byteflux
Southern Cross Incorporated Flying Dangerous
18
|
Posted - 2012.09.10 19:48:00 -
[13] - Quote
Seara Arrodan wrote:3 Jove "Systems" or 3 Jove "Regions" if regions how many systems does that contain? They are regions, each with many systems:
http://evemaps.dotlan.net/map/UUA-F4 http://evemaps.dotlan.net/map/A821-A http://evemaps.dotlan.net/map/J7HZ-F |
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |