If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > MySQL > Linking 2 member tables as one

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 06-07-04, 18:38
RookOrn RookOrn is offline
Registered User
 
Join Date: Jun 2004
Posts: 3
Linking 2 member tables as one

Hi guys,

can;t get my head around this and have been trying for a while, however not knowing much doesnt help!

Basically i want to link 2 member tables (1 from PHP nuke and 1 from Invision forum) as one, so that if someone registers on one they are automatically registered for the other.

Anyone got any ideas how to do this?

Thanks
Reply With Quote
  #2 (permalink)  
Old 06-07-04, 18:56
Strikerz95 Strikerz95 is offline
Registered User
 
Join Date: May 2004
Posts: 28
Phpnuke already comes with a phpbb forum intregrated into. I assume you don't want to use that and you would rather use invision powerboard?

Well, install both portals to the same MySQL database. Then find the tables that contain each portals user information. Compare them and find the core common fields that both contain. Go through invision's code and see if you can edit it so that it looks at the user table for phpnuke. You will probably have to adjust the table structure and some code in invision in order to get it working properly. That is one way I know you could do it. That does however assume that you can successfully edit the invision code, which I have never tried.

Also, I think there might be some sort of mirroring command within MySQL that will mirror certain fields between tables, but I am not sure what it is.
Reply With Quote
  #3 (permalink)  
Old 06-07-04, 19:21
RookOrn RookOrn is offline
Registered User
 
Join Date: Jun 2004
Posts: 3
ah rite that mirroring thing would do just the trick...

Thanks for your help
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On