Topic: ATTN people who know more about SQL than I do . . .  (Read 1651 times)

0 Members and 1 Guest are viewing this topic.

Offline FPF-DieHard

  • DDO Junkie
  • Captain
  • *
  • Posts: 9461
ATTN people who know more about SQL than I do . . .
« on: July 02, 2008, 03:15:35 pm »
I've kind a whacky idea for a PvP war are attrition server/ISC invasion.

1.   Is there anyway to Create a "pool" of ships that a Race leader can pull from to assign to players?

2.   Can a ship be assigned to a player via the OCI while they are signed on?

Who'd thunk that Star-castling was the root of all evil . . .


Offline FCM_SFHQ_XC

  • There is life outside of Windows..
  • Administrator
  • Lt. Commander
  • *
  • Posts: 2267
  • Gender: Male
  • Starbase Atlantis [X-refit]
    • 9th Fleet
Re: ATTN people who know more about SQL than I do . . .
« Reply #1 on: July 02, 2008, 05:15:52 pm »
1. If you create ships in the shiplist and restrict those to not be avaliable (not going to show up in the shipyards normally), then yes
2. NOT while they are on, they must not be on the server at the time
Starfleet Headquarters out.

Fleet Commodore, XenoCorp, ISC Fleet.

Offline FPF-DieHard

  • DDO Junkie
  • Captain
  • *
  • Posts: 9461
Re: ATTN people who know more about SQL than I do . . .
« Reply #2 on: July 02, 2008, 05:30:04 pm »
1. If you create ships in the shiplist and restrict those to not be avaliable (not going to show up in the shipyards normally), then yes

The Server shipyards can be handled by setting prohibitively high prices.  I'll hunt you down on TS to elaborate more on what I'm asking.


2. NOT while they are on, they must not be on the server at the time

No problem, i can work around that.
Who'd thunk that Star-castling was the root of all evil . . .