Several forums - one memberbase
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=11602
Printed Date: 13 April 2026 at 9:53pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Several forums - one memberbase
Posted By: FreeMen
Subject: Several forums - one memberbase
Date Posted: 23 August 2004 at 5:27am
|
Let's see if I can explain this right... I want to run multiple forums for different kinds of people, but with just one memberdatabase. Is this possible and if so, how? Example: When you sign up, you sign up to all subsites, but they still run seperately, with categories. Help! |
Replies:
Posted By: MadDog
Date Posted: 23 August 2004 at 2:34pm
|
Its possible, but would require some modification and hard code. I did it between http://www.aspinvision.com/forum - http://www.aspinvision.com/forum and http://www.invisionportal.com/forum - http://www.invisionportal.com/forum ------------- http://www.iportalx.net" rel="nofollow"> 
|
Posted By: MadDog
Date Posted: 23 August 2004 at 7:06pm
|
Maybe i should explain how lol .... Make a new category for each "forum" you are setting up. Then add the forums you want. Then for each copy of the forum you have to edit default.asp and in the SQL statements you have to do a WHERE statement on Cat_ID = (ID of the category for that forum). Basically i have http://www.aspinvision.com/forum - http://www.aspinvision.com/forum to show only a single category, but on http://www.invisionportal.com/forum - http://www.invisionportal.com/forum i have it set to display all the categories. So the two websites share the same table and members. ------------- http://www.iportalx.net" rel="nofollow">
|
Posted By: FreeMen
Date Posted: 24 August 2004 at 7:52am
|
Oh, I see... I'll give at try! Thanks for your help, MadDog... I might return with some ???? |
Posted By: FreeMen
Date Posted: 24 August 2004 at 7:55am
|
Btw... Is it possible to have different desig on each forum this way? |
Posted By: dpyers
Date Posted: 24 August 2004 at 11:13am
|
I think If you'll look at the links MadDog posted, you'll answer your own question. ------------- 
Lead me not into temptation... I know the short cut, follow me. |
Posted By: MadDog
Date Posted: 24 August 2004 at 2:47pm
Of course. The websites are using completly different code. The only thing they share is a DB. ------------- http://www.iportalx.net" rel="nofollow">
|
FreeMen wrote:Posted By: FreeMen
Date Posted: 26 August 2004 at 4:38am
|
Sorry... I see now... Thanks!!! ------------- http://www.tomtom-user.dk - TomTom-User.dk Running WWF SQL with more than 32.000 members... |
Posted By: FreeMen
Date Posted: 01 September 2004 at 9:05am
|
Got a problem. Now I've switched to SQL... How is this done here? Not the same I found out... ------------- http://www.tomtom-user.dk - TomTom-User.dk Running WWF SQL with more than 32.000 members... |
Posted By: FreeMen
Date Posted: 01 September 2004 at 9:23am
|
Sorry... Found out. Never worked with SQL before, but found a StoredProcedure... Thanks! ------------- http://www.tomtom-user.dk - TomTom-User.dk Running WWF SQL with more than 32.000 members... |
Posted By: FreeMen
Date Posted: 06 October 2004 at 3:57am
|
This thing works like a charm... But when I make an announcement in one section, I just want it to show there an not in alle the other sections!? Can this be done!? ------------- http://www.tomtom-user.dk - TomTom-User.dk Running WWF SQL with more than 32.000 members... |
Posted By: WebWiz-Bruce
Date Posted: 06 October 2004 at 4:10am
|
There are two types of Announcements you need to sellect:- Announcement (this forum) and not:- Announcement (all forums) ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: FreeMen
Date Posted: 06 October 2004 at 4:20am
|
I know, but I want to set All forums and then only get it to show in the 10 categories assignet to that section... I have devided my database into 9 sections, where if you enter section A on my website you only see cat id 1-10, Section B = cat id 11-20 and so on... So I want to make an announcement in all forums in Section A but not in section B... Hope you get this!? To do so I used StoredProcedures to devide... ------------- http://www.tomtom-user.dk - TomTom-User.dk Running WWF SQL with more than 32.000 members... |
Posted By: DiffToRegister
Date Posted: 29 March 2005 at 12:23pm
|
Well thanks to all of the contributers, above. I've got the forums filtered by category. Using the same skin, though.
My version of WWF is 7.9, using MSAccess.
My process was:
1. Add the new Categories to the Categories table.
1.5 Oh, and add forums to those Categories.
2. Create a cookie in my own application saving the Category number that the user is going to use. This will be our filter Response.Cookies("COG")("C") = "4", for example
3. As mentioned many times above, changed Default.asp:
intCatShow = Request.Cookies("COG")("C")
strSQL = "SELECT " & strDbTable & "Category.Cat_name, " & strDbTable & "Category.Cat_ID FROM " & strDbTable & "Category WHERE " & strDbTable & "Category.Cat_ID = " & intCatShow & " ORDER BY " & strDbTable & "Category.Cat_order ASC;" 4. Oh, had to change the search function too! See search_form.asp:
strSQL = "SELECT " & strDbTable & "Forum.* FROM " & strDbTable & "Forum WHERE " & strDbTable & "Forum.Cat_ID = " & Request.Cookies("COG")("C") & " ORDER BY " & strDbTable & "Forum.Cat_ID ASC, " & strDbTable & "Forum.Forum_Order ASC;"
(Better not paste html in here)
Well that's all folks!
ian_scho
|
Posted By: fathom
Date Posted: 29 November 2005 at 11:16am
|
Hi Maddog, can you please send me an example of your default.asp file so I can see exactly where to edit the CAT=ID bit? |
Posted By: DiffToRegister
Date Posted: 14 December 2005 at 5:11am
|
I told you I'd forgotten something: 4. Change the search engine to filter by category.
5. Change Active Topics to filter by category.
ian_scho |
Posted By: jeffdaro
Date Posted: 14 December 2005 at 4:09pm
|
I am working on this very same issue right now. I plan to set up another forum, and I want it to share the same user base. I have a future plan for a site to use the same topic table, etc. What I am doing is this...Instead of custom coding each page, I am in the process of stripping out the use of strDbTable variable. I am replacing the strDBTable prefix, and updating it to hold the actual table name. I am doing the same for stored procedures. These table name s are then stored in a config file. This way I can have two forums set up, and tell each to hit MainAuthor as the author table. Admittedly this is taking a lot of changes to the code, which prevents me from ever upgrading, and I have to make changes in the SP's, but that's OK with me, as I am also converting much of the embedded SQL to SP's anyway. |