| Author |
 Topic Search  Topic Options
|
KerryG 
Newbie
Joined: 28 December 2003
Location: United States
Status: Offline
Points: 6
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Multiple Sites - One Member DBase
Posted: 28 December 2003 at 1:35pm |
I currently have 4 websites running Snitz. They each have their own message forums but share a common member database. Although I have searched high and low through here, I don't see a way to migrate my users and messages between the current versions of both packages. However, I am still seriously considering a move to WWF.
One thing I need to know is if there is an easy way to recreate what I have with a common member database and multiple sites running off of it or if there is another way to accomplish the same thing. Thanks.
KerryG
http://www.wildhobbies.com
|
 |
india
Senior Member
Joined: 21 November 2003
Status: Offline
Points: 499
|
Post Options
Thanks(0)
Quote Reply
Posted: 28 December 2003 at 1:36pm |
|
Search the Forums
|
|
KerryG
Newbie
Joined: 28 December 2003
Location: United States
Status: Offline
Points: 6
|
Post Options
Thanks(0)
Quote Reply
Posted: 28 December 2003 at 1:46pm |
I did. I didn't find anything that was the same as what I was asking. The Snitz-to-WWF seems to be covered well (not gonna happen) but I couldn't find a good solution to my multiple sites question. In Snitz, it is very easy as the config file has a seperate line for the members table name, so you simply set them all to the same table.
KerryG
http://www.wildhobbies.com
|
|
michael
Senior Member
Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670
|
Post Options
Thanks(0)
Quote Reply
Posted: 29 December 2003 at 9:11am |
|
You would have to do some code changes, basically you could take the table prefix out of the _author table, then have a prefix for all other sites. This will mean you would have to go into pretty much every page to get that accomplished. An easier way, if you use SQL is to replicate that one table into the other created member tables, writing a trigger could do the trick.
|
|
|
|
KerryG
Newbie
Joined: 28 December 2003
Location: United States
Status: Offline
Points: 6
|
Post Options
Thanks(0)
Quote Reply
Posted: 29 December 2003 at 12:10pm |
Replication is certainly one way but is not effecient from a data point of view and creates needless redundant data. If all I have to worry about is the author table, I am thinking a global search and replace would be the easiest. Wouldn't this accomplish what I am looking for relativly easy:
Search: strDbTable & "Author.
Replace: strMemberTable & "Author.
Add to common.asp: Const strMemberTable = "Site1" ' eaxh site prefix
Assuming that is all I need to do, wouldn't ve easier than replication? Since I haven't been working with the code, I would appreciated anybody that knows it to tell me if this is a workable solution. Thanks.
KerryG
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 29 December 2003 at 12:31pm |
|
If you are running from one SQL server database, there is already a table pre-fix varaiable in the common.asp file.
The way to get them all then to use the same author table is to do as
you suggest and do a global search and replace on each of the forums
you instal to use the same Author table.
|
|
|
|
KerryG
Newbie
Joined: 28 December 2003
Location: United States
Status: Offline
Points: 6
|
Post Options
Thanks(0)
Quote Reply
Posted: 29 December 2003 at 12:39pm |
Great, thanks. I just wanted to verify that it was only the authors table. Too bad I can't convert from Snitz well, but I looked at phpBB too and there is no converter that works with the latest versions of either package eaither.
Now I just need to make a final decision between WWF and phpBB. Any feedback would be appreciated.
|
|
boomer
Newbie
Joined: 14 January 2004
Status: Offline
Points: 6
|
Post Options
Thanks(0)
Quote Reply
Posted: 14 January 2004 at 3:58pm |
I have a similar issue but don't know if the solution above applies. Basically, I have several sites each using WWF and would like them all to use one member table so that registered users of any of the sites will be able to log in to all of the sites. Can someone describe what code changes I would need to make to have this happen?
BTW, I am using the Access version of WWF...
|
|
