Web Wiz Support and Community Forums : 2 forum - 1 user database https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 11 Apr 2026 13:24:29 +0000 Tue, 06 Jun 2006 18:15:50 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=18323 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[2 forum - 1 user database : If you use mySQL or SQL Server...]]> https://forums.webwiz.net/2-forum-1-user-database_topic18323_post108510.html#108510 Author: WebWiz-Bruce
Subject: 18323
Posted: 06 June 2006 at 6:15pm

If you use mySQL or SQL Server you should be able to connect to the same database from 2 completely different sites.

Also as you are setting up a new forum you should consider using version 8 as it is a vast improvement over version 7 and uses a different login system that doesn't require cookies.
]]> Tue, 06 Jun 2006 18:15:50 +0000 https://forums.webwiz.net/2-forum-1-user-database_topic18323_post108510.html#108510 <![CDATA[2 forum - 1 user database : Hi Borg, not sure how...]]> https://forums.webwiz.net/2-forum-1-user-database_topic18323_post108509.html#108509 Author: Landlord-Forum
Subject: 18323
Posted: 06 June 2006 at 6:03pm

Hi Borg,
 
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...
]]> Tue, 06 Jun 2006 18:03:53 +0000 https://forums.webwiz.net/2-forum-1-user-database_topic18323_post108509.html#108509 <![CDATA[2 forum - 1 user database : Try connecting to the forum without...]]> https://forums.webwiz.net/2-forum-1-user-database_topic18323_post108503.html#108503 Author: WebWiz-Bruce
Subject: 18323
Posted: 06 June 2006 at 5:38pm

Try connecting to the forum without the Iframe and see if it works, if it does you know it's the Iframe coursing issues.

I would recommend staying clear of frames as they can course issues with browsers.
]]> Tue, 06 Jun 2006 17:38:25 +0000 https://forums.webwiz.net/2-forum-1-user-database_topic18323_post108503.html#108503 <![CDATA[2 forum - 1 user database : many thanks, it seems to work...]]> https://forums.webwiz.net/2-forum-1-user-database_topic18323_post108495.html#108495 Author: Landlord-Forum
Subject: 18323
Posted: 06 June 2006 at 3:23pm

many thanks, it seems to work a treat, did just that, a folder called forum2, i am now going to change the 3 files you mention.
 
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
 
 


Edited by Landlord-Forum - 06 June 2006 at 4:38pm]]> Tue, 06 Jun 2006 15:23:41 +0000 https://forums.webwiz.net/2-forum-1-user-database_topic18323_post108495.html#108495 <![CDATA[2 forum - 1 user database : I used the same technique that...]]> https://forums.webwiz.net/2-forum-1-user-database_topic18323_post108488.html#108488 Author: wistex
Subject: 18323
Posted: 06 June 2006 at 2:04pm

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.


Edited by wistex - 06 June 2006 at 2:04pm]]> Tue, 06 Jun 2006 14:04:03 +0000 https://forums.webwiz.net/2-forum-1-user-database_topic18323_post108488.html#108488 <![CDATA[2 forum - 1 user database : You are along the right lines.All...]]> https://forums.webwiz.net/2-forum-1-user-database_topic18323_post108458.html#108458 Author: WebWiz-Bruce
Subject: 18323
Posted: 06 June 2006 at 9:18am

You are along the right lines.

All you should need to do is make a second copy of Web Wiz Forums in another folder on the site, but have it linked to the same database. You can then change the header.asp and footer.asp as well as the CSS files for both forums to give them both different looks.
]]> Tue, 06 Jun 2006 09:18:54 +0000 https://forums.webwiz.net/2-forum-1-user-database_topic18323_post108458.html#108458 <![CDATA[2 forum - 1 user database : Hi, i think i am looking to...]]> https://forums.webwiz.net/2-forum-1-user-database_topic18323_post108430.html#108430 Author: Landlord-Forum
Subject: 18323
Posted: 05 June 2006 at 5:01pm

Hi,
 
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
]]> Mon, 05 Jun 2006 17:01:15 +0000 https://forums.webwiz.net/2-forum-1-user-database_topic18323_post108430.html#108430 <![CDATA[2 forum - 1 user database : I have a similar need. I have...]]> https://forums.webwiz.net/2-forum-1-user-database_topic18323_post107313.html#107313 Author: wistex
Subject: 18323
Posted: 19 May 2006 at 9:52am

I have a similar need.   I have the main website which is for thegeneral public and has public forums, and then I also want to have awebsite that for other businesses and webmasters who work with us invarious ways.  I'd like so have one membership base, but completelydifferent forums.


]]> Fri, 19 May 2006 09:52:49 +0000 https://forums.webwiz.net/2-forum-1-user-database_topic18323_post107313.html#107313 <![CDATA[2 forum - 1 user database : Thanks, borg. My two cents, having...]]> https://forums.webwiz.net/2-forum-1-user-database_topic18323_post102767.html#102767 Author: wmeyers
Subject: 18323
Posted: 28 March 2006 at 9:02pm

Thanks, borg. My two cents, having a common membership table would be a huge help to anyone who plans to portal with multiple forums.
 
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.
]]> Tue, 28 Mar 2006 21:02:12 +0000 https://forums.webwiz.net/2-forum-1-user-database_topic18323_post102767.html#102767 <![CDATA[2 forum - 1 user database : At the moment you can not use...]]> https://forums.webwiz.net/2-forum-1-user-database_topic18323_post102680.html#102680 Author: WebWiz-Bruce
Subject: 18323
Posted: 28 March 2006 at 11:25am

At the moment you can not use the same member table, but it is something I have considered, just not had time to implement and test.

Yes, you can delete fields that are no-longer required when upgrading to version 8, I would have made it so the upgrade tool did this, but as many are linked to indexes which have unique reference numbers I didn't find away to be able to delete these old fields so just left them.

If you can, start with a version 8 database, not an upgraded one as it will perform much better.
]]> Tue, 28 Mar 2006 11:25:52 +0000 https://forums.webwiz.net/2-forum-1-user-database_topic18323_post102680.html#102680