Linking Tables

[cap97]

I've got two shareware scripts that tie into a MySQL database. One script is a family tree script called TNG, that turns my exported software file into a php and MySQL web site (as opposed to most software exports, which generate 2100 static html pages - ack!). The other script is a bulletin board system called PHPBB.

Both of these scripts make use of username/passwords.

TNG requires that I manually set-up whatever additional users I want, which kind've blows 'cause that means I have to deal with issuing out / editing any passwords I want associated with the site. TNG handles passwords with a table called "tng_users".

PHPBB, on the other hand, allows users to register and edit their own password and info, and has a system for mailing people forgotten passwords, etc. Basically takes me out of the loop unles I need to ban/delete a user. PHPBB also has a "phpbb_users" table.

What I'm wondering is if there's a way to link the username and password fields in "tng_users" to the username and password fields in "phpbb_users". That way, when people register or edit their username / passwords in PHPBB, it automatically reflects in TNG. Get me? Aside from the linking part, the only other snafu I see is that the password field in "phpbb_users" is encrypted, whereas in "tng_users", it is not.

So uh...any ideas?

Mike....

[edwardsbc]

The 'simplest' way I can think of to fix this (and it isn't THAT simple) is to create trigger procedures in the phpbb user table that syncronizes the tng user table whenever there is a change. I'm not a MySQL expert (I use MS-SQL and PostgreSQL mostly), so I don't even know if MySQL can support triggers.

You could also write/append a php script to the phpbb code which creates/alters/deletes accounts in the tng user table when the phpbb table is changed.

Finally, you just alter the tng scripts to use the phpbb user table.

(I'm assuming you have access to all of the source.)

Hope these ideas are useful!

[trooper]

PHPBB is quite a large app and so its best to try and get the other script to fit in with that rather than the other way around

Be very very careful when doing this

If you make any mistakes then you will be in trouble.

Take your time and be careful - i too have to do a similar action

HTH

GM