Topic: Mission Question

[Bonk]

I'll put it on my list...

Hang on, it will only take a second... one query - just need to backup the db before (and after) the edit, just in case...

Code: [Select]

UPDATE maphex SET TerrainType = 67108864 WHERE PlanetType <> 0 AND TerrainType IN (4096,8192,16384,32768,65536,131072);
This query will set all planet hexes with nebulas to normal space.

... done!  (hmm... 29 rows affected!  I guess I missed more than a few...  ) Hard to pick those out in Artifex.

edit: looks like we're due for the first db clean soon... not too bad for three weeks in.

edit2: I loaded the webmap in my browser before and after and I'm flipping back and forth between the copies...  sometimes small things amuse me a great deal. 

[NuclearWessels]

Is it possible (sans SQL) to have missions generated on a specific terrain type on the map?
I know base missions can (should) only be generated whwere's there's a base, but can any mission be set up the same way?
IE a mission with those ion storm things only shows up on Neb hexes, randomnly appearing black holes only appear on black hole hexes etc

Ion storms added to nebs (can't believe I forgot them first time round), I'll update the posted version shortly

I can spew out the combination in use (which are open to change if ya'd like) in case you want to think about maps:

Space1,3,5 hexes get small dust clouds generated
Space2,4,6 hexes get large dust clouds
space(any) in planet hexes get ion storms

asteroid1,3,5 get large asteroids generated
asteroid2,4,6 get small asteroids
asteroid(any) in planet hexes get ice asteroids

nebula1,3,5 get large dust clouds generated
nebula2,4,6 get ion storms
nebula(any) in planet hexes get small dust clouds

blackhole1,3,5 get large black holes generated
blackhole2,4,6 get small black holes
blackhole(any) in planet hexes get ... ummm ... I didn't write it down  I think it was ion storms

dave

[Bonk]

I think I'll give this a whirl for some testing on The Forge once Economic War starts winding down.

[GDA-S'Cipio]

Sigh. How quickly you forget. Do you know how many precious resources are WASTED because you can['t remember. I mean, instead of typing this to help you, I could be finding lock picks on Elder Scrolls Oblivion. Btw., does anyone know how to really work that convoluted lock picking mechanism manually?

I normally jussst point a plasssma-R at the door, then tell them to open up, "or elssse."

My resssults have been encouraging.

-S'Cipio