My site already has a users database so they register to use other aspects of the site. I don't want them to have to re-register to use the forum. I don't want to combine the forum and the site databases yet I want to "feed" Tbl_users from site database into Forum users table ...or point forum users table to site database...does this make sense? If so...any ideas on how to do it?!! I am worried about "ruining" the forum Db so am being a bit tentative!
I too have a similar need. I was thinking that, when users register on the site (using the site database) another query runs and updates the Forum DB with the necessary info to create a forum account for them.
I thought this too - but it is getting it to update the other one automatically that I can't manage especially as it is in another database. Any thoughts? wanted to add another update behaviour onto my site reg page so both Db's were updated at once but can only have one of these behaviours per page...unless I add another page behind it saying "Your reg was successful" and add a hidden update behaviour there. It just seems a bit long winded although it would work.
I guess I would define two connection strings (one for each DB) and run one DBconnection for the site database changes, then open a new DB connection to the forum DB for the forum-based changes (Probably not the fastest way, but I'm no expert on databases yet)
As I wrote in the other post, login and authentication seem to produce good results. Restrict the search to the General Help Forum and search for any of the words. Many topics returned will be relevant.
Topic Locked
Posted - 14 August 2002 : 07:56:37
