Topic: SQL Mission Ideas....  (Read 2190 times)

0 Members and 1 Guest are viewing this topic.

DarkElf

  • Guest
SQL Mission Ideas....
« on: April 05, 2003, 02:59:28 am »
Missions utilizing SQL will be written soon...

List your ideas here. Feel free to throw out all your ideas...I can tell you if they are possible are not.

There is a myriad of things that we can do, and the sky's the limit.  I'd like to hear some ideas before coding begins.

You thought Dave was evil?  Wait 'til you see what we can do now...

<insert manical evil laugh>
« Last Edit: December 31, 1969, 06:00:00 pm by DarkElf »

Maxillius

  • Guest
Re: SQL Mission Ideas....
« Reply #1 on: April 05, 2003, 08:03:32 am »
moving planets?  asteroid ships?  ambush missions where Romulans spawn with one unsloaked Snipe and after you close in for the kill six K7R's decloak at range 18 or so... long enough for you to not notice they're there, but not quite far enough to run.    

SPQR Renegade001

  • Guest
Re: SQL Mission Ideas....
« Reply #2 on: April 05, 2003, 08:13:26 pm »
Break the Convoy Raid and Escort in two seperate mission pairs, 1 that is a military supply raid/escort that will take down the DV as normal, and a trade interdiction/escort that will shift the Econ value of a hex by a point.

Maybe raids where you need to kill a well escorted convoy before it reaches a heavily armed planet or starbase for a real hit in the wallet. 5 Econ dropped for a sucessfull raid? If we can make some missions optional only, then make this one a high risk mission with high PP and stratigic reward.

How about a mission for the deep strikers; Re-supply. Only avail in enemy hexes. Meet with a freighter and transport [x] cargo from it for a full re-supply at mission end; all before the larger opponent kills it. Another candidate for the optional missions. No base PP or DV shift, but bonus/penalty points as normal for a patrol vs. a larger opponent.

... and one more I'm still hoping to see (non-SQL)... A merge between the patrol and the scout missions. If you are close to the same size as your opponent or larger, then it's a patrol for you; engage and destroy. If you are vastly out matched, it's a scout for you; close and scan, then run and live.  

DarkElf

  • Guest
Re: SQL Mission Ideas....
« Reply #3 on: April 06, 2003, 07:17:07 am »
Quote:

moving planets?  asteroid ships?  ambush missions where Romulans spawn with one unsloaked Snipe and after you close in for the kill six K7R's decloak at range 18 or so... long enough for you to not notice they're there, but not quite far enough to run.    




You must like being invincible, LOL.  I shutter with fear dealing with a moving planet or asteroid ship --- ouch!  Six K7R's?  What could survive that?

Moving planets are already possible, just have to make some changes to the shiplist.  I would assume the same thing with the Asteroids.  

DarkElf

  • Guest
Re: SQL Mission Ideas....
« Reply #4 on: April 06, 2003, 07:19:03 am »
Quote:

Break the Convoy Raid and Escort in two seperate mission pairs, 1 that is a military supply raid/escort that will take down the DV as normal, and a trade interdiction/escort that will shift the Econ value of a hex by a point.

Maybe raids where you need to kill a well escorted convoy before it reaches a heavily armed planet or starbase for a real hit in the wallet. 5 Econ dropped for a sucessfull raid? If we can make some missions optional only, then make this one a high risk mission with high PP and stratigic reward.

How about a mission for the deep strikers; Re-supply. Only avail in enemy hexes. Meet with a freighter and transport [x] cargo from it for a full re-supply at mission end; all before the larger opponent kills it. Another candidate for the optional missions. No base PP or DV shift, but bonus/penalty points as normal for a patrol vs. a larger opponent.

... and one more I'm still hoping to see (non-SQL)... A merge between the patrol and the scout missions. If you are close to the same size as your opponent or larger, then it's a patrol for you; engage and destroy. If you are vastly out matched, it's a scout for you; close and scan, then run and live.    




We have a mission being planned that will affect EV.

The resupply mission sounds intriging as well.

FireSoul

  • Guest
Re: SQL Mission Ideas....
« Reply #5 on: April 06, 2003, 01:31:39 pm »
Implement refits via a web interface.
Implement hex location detection, so that we can have LDR or WYN scenarios.
Implement DV detection of the hex, to implement proper difficulty settings.
Implement a 'garage' on this web interface, for those who like to have many ships, but fly only one at a time.
Implement unique ships roaming around.. and when they're encountered, generate them under special circumstances.
etc..?

-- Luc

IndyShark

  • Guest
Re: SQL Mission Ideas....
« Reply #6 on: April 06, 2003, 02:29:34 pm »
I would like to see the Doomsday device brought back with a vengence. Give it some decent weapons and speed so it's a real threat. Can you put a derelict CA in the game that you can board and control to fight the DD?

How about a mission where you find a derelict and have to defend it while it limps off the map (with a max speed of perhaps 15 or so)

How about a mission where you and an enemy vessel are stuck in a wormhole where the first ship off the map escapes and the second is destroyed.  The closer you get to the map edge the more power it takes to move. (leaving you vulnerable!)

How about a battle against a fleet from the past? Give the other fleet superior numbers, but they can't raise their sheilds above nebula levels. Give your ship +4 ECM and you have to beat all of the enemy to win.  

KATChuutRitt

  • Guest
Re: SQL Mission Ideas....
« Reply #7 on: April 06, 2003, 11:51:06 pm »
Planetary Assault missions involving placing an operative on a planet, beaming off an operative, smuggling arms to rebels etc.

These missions would add variety to the Planetary assault mission and give races that have difficulty on assaults a more equal footing.

Also use messages in mission to convey strategic inteelligence on base assaults if the bases are captured.  Say 1 time in 10 or 1 in 20.  This informations could vary in clarity but relate to opposition VCs.  For example:  The Coalition is massing planetary invasion forses for a strike in the eastern sector of federation space.  This info wouldn't be exact but would provide clues.

Just some ideas for thought.

KATChuutRitt

  • Guest
Re: SQL Mission Ideas....
« Reply #8 on: April 07, 2003, 05:54:04 am »
Another thought......

Would it be possible to make certain missions with varying levels of sucess? and differing dv shifts depending on results?

A basic mission that isnt too hard but will get you a 1 dv swing,  an extra more difficult assignment that would get you a 2 dv swing, and an extremely hard to achieve objective that would make the mission worth a 3 dv shift, unless you died trying and lost a dv point that is....

This might make the newer players and vets alike  enjoy the same missions.  They could try their hands at the levels they felt comfortable with.

Say for example a very hard planetary assault:

Take out outter defenses (defense platforms) 1 dv shift

Take out bases and defending ships as well 2 dv shift

Destroy platforms and defending ships capture all  bases and homeworld planet  3 dv shift and chance (1 in 20?) of getting an intell message

Just more food for thought

KATChuutRitt

  • Guest
Re: SQL Mission Ideas....
« Reply #9 on: April 07, 2003, 06:06:42 am »
More thoughts....

Could missions be cued to ship types?

For example special missions for scouts?  or for carriers?  Perhaps even some special missions for freighters just in case a player might find himself stuck in one....

Maybe a mission like the training one on AOTK, but with a slight twist, have the pilot place in a Q ship in the middle of a convoy and have Orions attack the convoy.  Only in friendly spce of course.

A run the gauntlet mission where you pick up a passenger or supplies from one friendly base and transport it to another on the other side of the map, of course multiple enemies start in between.

Mutiny, one of your races ships has mutinied and must be destroyed before reaching enemy space, this would give pilots the chance to fight vs their own or allied race ships for a change.

Time to get breakfast all this food for thought is making me hungry....

TOCXOBearslayer

  • Guest
Re: SQL Mission Ideas....
« Reply #10 on: April 07, 2003, 06:31:36 am »
Hmmm....... can wormholes be used?

Certain hexes would have a wormhole in them... you enter the wormhole and are sent to another (possibly random) wormhole on the map.

Time delay for repairs!!!!

If the ship is damaged less than 15% of the base BPV, then it is pretty instantaneous.  But if 15-30% there is a turn delay.  30%-45% two turn delay.  45-60% three turn delay on repairs.  60%+ four turns for repairs.

Make is so up to 15 % BPV can be repaired per turn....  This will allow the ship to provide base/shipyard defense (using repair parts to bring up BPV) while waiting for repairs to be done.

Or maybe give the captain a 'rental' to use while the normal ship is under repairs.  Call it a shakedown cruise of a newly commissioned ship.

Something at lesser BPV then the damaged ship.

Karnak

  • Guest
Re: SQL Mission Ideas....
« Reply #11 on: April 07, 2003, 10:00:24 am »
Quote:

Maybe a mission like the training one on AOTK, but with a slight twist, have the pilot place in a Q ship in the middle of a convoy and have Orions attack the convoy. Only in friendly spce of course.




Hmmm....Miraki intelligence must have penetrated ISC HQ because I am writing up a similar scenario, not quite the same, but close, right now.

  It will run in Neutral (ie. any thanks to D2 bugs) hexes.

Quote:

Certain hexes would have a wormhole in them... you enter the wormhole and are sent to another (possibly random) wormhole on the map.




This idea I really like. I don't have the server data model in front of me but I am pretty sure that the table governing server characters has X,Y co-ordinate fields.  I would like putting in a secret wormhole passage into enemy territory that only one or two races know about thereby given those races an "surprise" card that could be dealt at the appropriate time.  I will definitely see if this idea can be implemented.

DarkElf

  • Guest
Re: SQL Mission Ideas....
« Reply #12 on: April 07, 2003, 10:01:01 am »
Quote:

Another thought......

Would it be possible to make certain missions with varying levels of sucess? and differing dv shifts depending on results?
[
A basic mission that isnt too hard but will get you a 1 dv swing,  an extra more difficult assignment that would get you a 2 dv swing, and an extremely hard to achieve objective that would make the mission worth a 3 dv shift, unless you died trying and lost a dv point that is....

This might make the newer players and vets alike  enjoy the same missions.  They could try their hands at the levels they felt comfortable with.

Say for example a very hard planetary assault:

Take out outter defenses (defense platforms) 1 dv shift

Take out bases and defending ships as well 2 dv shift

Destroy platforms and defending ships capture all  bases and homeworld planet  3 dv shift and chance (1 in 20?) of getting an intell message

Just more food for thought  




Yes, with SQL, its entirely possible.

**DONOTDELETE**

  • Guest
Re: SQL Mission Ideas....
« Reply #13 on: April 09, 2003, 05:25:41 am »
Quote:

Hmmm....... can wormholes be used?

Certain hexes would have a wormhole in them... you enter the wormhole and are sent to another (possibly random) wormhole on the map.

 




- I believe that UDF_Intruder intends to implement a "wormhole" script in more than
one way. I'm not sure if he's started it yet or how long it might take... Intruder - you out there?
(I don't think OP 2.5.3.8 will support the SQL server and the OP D2 bugs are not patched yet.)
 UDF_Intruder's Virtual Galaxy



Quote:

Implement refits via a web interface.
Implement hex location detection, so that we can have LDR or WYN scenarios.
Implement DV detection of the hex, to implement proper difficulty settings.
Implement a 'garage' on this web interface, for those who like to have many ships, but fly only one at a time.
-- Luc  




Implement refits via a web interface.
- This is next on my To Do list for the SQL EAW D2 php scripts I've been working on
(rudimentary shipyard is done...)

Implement hex location detection, so that we can have LDR or WYN scenarios.
- I think DarkElf has implemented hex location detection, but how will this help with LDR or WYN scenarios?

Implement DV detection of the hex, to implement proper difficulty settings.
- Again, I think DarkElf has implemented DV detection of the hex (or can easily
considering what I've seen of the SQL mission tests so far...)

Implement a 'garage' on this web interface, for those who like to have many ships, but fly only one at a time.
- Interesting idea, I may be able to implement this once I figure out the role and structure of the ShipCacheVector
blob in the servcharacter table.

I'll work on coming up with some good ideas for missions...
This is gonna be cool!
 

Karnak

  • Guest
Re: SQL Mission Ideas....
« Reply #14 on: April 09, 2003, 09:31:27 am »
Quote:

Quote:

Hmmm....... can wormholes be used?

Certain hexes would have a wormhole in them... you enter the wormhole and are sent to another (possibly random) wormhole on the map.

 




- I believe that UDF_Intruder intends to implement a "wormhole" script in more than
one way. I'm not sure if he's started it yet or how long it might take... Intruder - you out there?
(I don't think OP 2.5.3.8 will support the SQL server and the OP D2 bugs are not patched yet.)
 UDF_Intruder's Virtual Galaxy



Quote:

Implement refits via a web interface.
Implement hex location detection, so that we can have LDR or WYN scenarios.
Implement DV detection of the hex, to implement proper difficulty settings.
Implement a 'garage' on this web interface, for those who like to have many ships, but fly only one at a time.
-- Luc  




Implement refits via a web interface.
- This is next on my To Do list for the SQL EAW D2 php scripts I've been working on
(rudimentary shipyard is done...)

Implement hex location detection, so that we can have LDR or WYN scenarios.
- I think DarkElf has implemented hex location detection, but how will this help with LDR or WYN scenarios?

Implement DV detection of the hex, to implement proper difficulty settings.
- Again, I think DarkElf has implemented DV detection of the hex (or can easily
considering what I've seen of the SQL mission tests so far...)

Implement a 'garage' on this web interface, for those who like to have many ships, but fly only one at a time.
- Interesting idea, I may be able to implement this once I figure out the role and structure of the ShipCacheVector
blob in the servcharacter table.

I'll work on coming up with some good ideas for missions...
This is gonna be cool!
   




Awesome, rajnsaj.  

 I can't wait to see some more of your php wizardry.
« Last Edit: December 31, 1969, 06:00:00 pm by Karnak »

NuclearWessels

  • Guest
Re: SQL Mission Ideas....
« Reply #15 on: April 09, 2003, 09:42:27 am »
All very extremely cool  - awesome job folks!

I can't wait to see this stuff in action - it's a huge leap forward for the dyna!

dave