Jump to content

Two VA's Sharing Same Pilot Table


TennShadow

Recommended Posts

Is it possible for two VA's to share the same pilot table but nothing else?  

For example,  I have VA "A" with 20 pilots and I want to create a new VA "B".  I want the pilots from VA "A" to be able to login to VA "B" using the same pilotID and password they have in VA "A"..  Other then the same pilot ID and password I want them the be completely separate.    I'm basically wanting signal sign on between the two VA's.

 

Thanks!

Link to comment
Share on other sites

This is possible (I would think), but due to the nature of phpVMS it could prove to be a very hard task. If it was the same DB for both va's then that would be easy, just change the info, but for one pilot's table for both (might end up being easier to make them register for both).

You'd probably have to change the PilotsData.class.php and the Auth.class.php files (and any others that reference the _pilots table in a raw query, but these are usually in these data classes anyway) in order to connect to another DB first, then do the query it wants.

Link to comment
Share on other sites

  • Administrators

How about this? Works via a cron job to copy the pilot table from one DB to another.

https://www.sitekickr.com/blog/replicate-copy-database-table-php/

I personally haven't tried it. Found it via a Google search: https://www.google.com/#q=can+i+setup+a+cron+job+to+copy+a+database+table+to+another+location&spf=117

Edited by ProAvia
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...