I will have multiple subdomains, i.e. subdomain1.domain.org, subdomain2.domain.org, etc.

 

Can I use the same SQL database for multiple sites as long as I change the table names? If so, in what file that runs the SQL script would I need to change the names?

 

In doing so, it would be great if I could leave the members table alone and let people across multiple sites share it. Is this possible?

 

Can the subdomains be virtual, or do they have to be real? I am worried about conflicting ASP sessions between the multiple forums.

 

Any advice would be greatly appreciated!

 

Thanks.

 

Will this only work with 2 forums, or technically could I add 3 or 4 if I get to that point?

 

I have created a 2nd forum modifying the values in setup_options only - I couldn't find anything to change in the sql setup file, though the comments in setup_options says to change something there as well. Seems to work ok, at least so far. One file to modify is a nice feature!

 

Does anyone have a way to export and import forum settings so I don't have to recreate everything by hand again? I'm not good at SQL and using the export tool didn't work.

 

Edit - On further review it appears that the forum table that was upgraded to version 8 contains more fields than the new cleanly installed v8 forum.

 

Can I safely delete the fields that are no longer needed, and if so, do you think that will help with copying the data over?

 

I was able to go into SQL 2003 tables and do a copy and paste of the category table, worked very smoothly. Would love to do the same with the forums so I don't have to recreate all of them.

 

I was able to delete the extra fields in the first forum and successfully copy data to the new forum, which saved me from typing all my topics and forums over. The threads I don't want anyway. I did run into some permissions issues and had to reapply them group by group, but that is most likely from monkeying around with the SQL data.

 

I think it would be a lot smoother going from v8 to v8, which is how I will try it when I am ready to create another new forum. It may even make sense to create a set of template tables in SQL and use the export function to kick off a new forum in the future, something I will think about trying maybe. To be successful I need to be have the key fields retain their source data, and I'm not sure that is possible.

 

Oh well, I probably spent as much time trying this as it would have taken me to just type the darn things over again!

 

I really like the permissions grid, my only suggestion would be if its possible add a button that allows you to select and deselect an entire column or row at a time.

 

i think i am looking to do something similar but a bit different from the above. sorry if this has been answered b4 but i have searched high and low.

 

i have a forum running on my domain and i want to share that forum with another website (not owned by me) i actually want the forum to be the same, same users, same posts etc so users can login from either site.

 

the only difference i want is the look at feel around the forum, i have done that on my site by modifying the header and footer files to include the bits of my site top and bottom. on the other site i would like it to look as if it is a part of that site, (the forum/posts/members all the same.) i am thinking this is probably easiest done by copying the forum folder into a 2nd floder called forum2 for example, (so it speakes to the same databse.) framing a page from my new folder in the other site and just changing the header and footer files. am i right is i this simple or am i opening a can of worms?

 

any help much appreciated

 

JP

I used the same technique that Borg described and it worked like a charm.  Exactly what you need, Landlord-Forum. :)

 

For me, I'd actually like two different forums with one userbase.  I've seen this done on other forums, and one way to accomplish this is to modify one or both forum installations to point to the same member tables, but still have the rest of each forum point to different tables.  Both forums would need to use the same database, just with a different table prefix... except for the members tables which would have the same prefix.

 

If most of the membership / login / logout code is in one place, then this would actually be pretty easy to implement.  It will be a nightmare if the code is spread out throughout the forum code.

 

great forum code this, very simple to use/change etc

 

well done wwf and thanks to you all on the forum here!

 

** update-- eek, i can't login. say the capthcha code is wrong,

 

is this something to do with the forum running in an inline frame on another site? easy fix? or do i have to reverse the way i have the site framed i.e., frame the bits for the other site on my pages?? and host from my server?

 

thanks

 

JP

 

 

 

not sure how to do that.

 

basically the forum is on my site (site1) and i want to share it on another site not owned by me (site2) (i have ftp access to both sites and am modifying pages in both).

 

so, i am using an inline frame on the other site to call up the forum in the middle of the page, keeping the other sites look and feel top/side/bottom banner/ads in place.

 

i get the feeling this is a cookie issue with the forum trying to do a cookie while technically in another site (address bar reads for the other site.)

 

i would like ideaaly that users feel thay have not left site 2 but have access to the forum form there without coming to the forum site. i could take the pages from site 2 and host them on site1, just makes updating them a pain, or i suppose i could frame them up form my site, still got the address bar showng site1 though...