[SOLVED] Two database one pilot table

[OmerAslan]

Hello,

I want to make two different virtual airlines in same hosting with different database. Which is i already have. Only pilot table i want to use together. I have phpmyadmin. Can someone explain to me how can i do that? Thanks. Only the pilot table. 

Edited December 17, 2016 by OmerAslan

[Parkho]

That requires a major core file change to read from the same table meaning you'll need to change all the functions that uses pilots table to read from the first DB table. Are you sure you want to do this?

I suggest you update both tables manually then read them separately that's a lot easier to deal with. All you need to do is to import pilot's table from your first DB into the second one and whenever a new pilot is added to any tables, you update the other one accordingly. Another problem you'll face is the PIREPS which also needs to be updated since they use pilot id to save records. Like I said pretty much any module or function that uses pilot's table needs to be altered and that's gonna be a pain for you.

[OmerAslan]

Hi Parkho,

Thanks for your answer. I was thinking maybe there is an easy way to do this from phpmyadmin panel. But the way you explain then i will pass this option  No need this headache. Thanks a lot my friend.

[Parkho]

Yeah! It's easy in mind but hard in reality . You're welcome.