Web Wiz - Green Windows Web Hosting - Celebrating 25 Years!

  New Posts New Posts RSS Feed - 2 forum - 1 user database
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

2 forum - 1 user database

 Post Reply Post Reply Page  <123>
Author
MarcusJS View Drop Down
Newbie
Newbie


Joined: 15 February 2006
Status: Offline
Points: 5
Post Options Post Options   Thanks (0) Thanks(0)   Quote MarcusJS Quote  Post ReplyReply Direct Link To This Post Posted: 20 February 2006 at 10:52am
Thanks, this has worked a treat. I don't have access to the server so I changed the variable to false.
Back to Top
wmeyers View Drop Down
Newbie
Newbie
Avatar

Joined: 11 February 2006
Location: United States
Status: Offline
Points: 15
Post Options Post Options   Thanks (0) Thanks(0)   Quote wmeyers Quote  Post ReplyReply Direct Link To This Post Posted: 25 March 2006 at 10:58pm
What is the downside to changing blnUseApplicationVariables to false?
 
Will this only work with 2 forums, or technically could I add 3 or 4 if I get to that point?
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 27 March 2006 at 12:43pm
The performance will not be as good as you will need more database hits and you can not use the active users feature.

However, in version 8 you can set the a prefix for the application variables which means you simply edit the setup_options.asp file for each forum to give them different prefixes for application variables and cookies.
Back to Top
wmeyers View Drop Down
Newbie
Newbie
Avatar

Joined: 11 February 2006
Location: United States
Status: Offline
Points: 15
Post Options Post Options   Thanks (0) Thanks(0)   Quote wmeyers Quote  Post ReplyReply Direct Link To This Post Posted: 27 March 2006 at 8:38pm
With version 8 is it still difficult to share the same member table using multiple forums on the same server?
 
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.


Edited by wmeyers - 27 March 2006 at 10:00pm
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
wmeyers View Drop Down
Newbie
Newbie
Avatar

Joined: 11 February 2006
Location: United States
Status: Offline
Points: 15
Post Options Post Options   Thanks (0) Thanks(0)   Quote wmeyers Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
wistex View Drop Down
Mod Builder Group
Mod Builder Group


Joined: 30 August 2003
Location: United States
Status: Offline
Points: 877
Post Options Post Options   Thanks (0) Thanks(0)   Quote wistex Quote  Post ReplyReply Direct Link To This Post Posted: 19 May 2006 at 9:52am
I have a similar need.   I have the main website which is for the general public and has public forums, and then I also want to have a website that for other businesses and webmasters who work with us in various ways.  I'd like so have one membership base, but completely different forums.


Back to Top
Landlord-Forum View Drop Down
Newbie
Newbie
Avatar

Joined: 11 January 2006
Location: United Kingdom
Status: Offline
Points: 19
Post Options Post Options   Thanks (0) Thanks(0)   Quote Landlord-Forum Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
 Post Reply Post Reply Page  <123>

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.