Print Page | Close Window

Linking different forums to same database

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=3664
Printed Date: 01 April 2026 at 7:42pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: Linking different forums to same database
Posted By: donhill
Subject: Linking different forums to same database
Date Posted: 19 June 2003 at 6:00am

Anyway to use the same database but to have Forum1draw up details from database from Webpage1 and Forum2 to draw up a different forum set from Webpage2?

 

 




Replies:
Posted By: WebWiz-Bruce
Date Posted: 19 June 2003 at 6:15am

Not really sure what you mean.

Do you mean can you run multiple instenses from the same database? If so yes, you just need to make multiple tables in the database and change the table prfix in the common.asp files.

If you mean can you make each forum on one board look different? The anwser is no.



-------------
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: donhill
Date Posted: 19 June 2003 at 6:32am
Originally posted by -boRg- -boRg- wrote:

Do you mean can you run multiple instenses from the same database? If so yes, you just need to make multiple tables in the database and change the table prfix in the common.asp files.

This is what I mean. I have three sections of the forum and each section I want to show access from a different page in my website.

For example I have a message forum, a news forum and a report forum which I dont want "mixed up" so if I am not wrong what I have to do is as follows?

Copy the database table and name it say forum 2 and then forum 3

Then make acopy of common asp and chnage the table prefxi s oit draws up say forum 2 and another common asp file to get forum3.

 

Then I must make a default.asp file for each which icnludes the particular common asp file that draws up the particular forum??

 

Is that correct? Thanks borg



Posted By: abhinav
Date Posted: 19 June 2003 at 7:02am
I don't know the answer .. but this should be interesting

-------------
http://www.sgkabra.com - Accountancy Firm | http://www.mp3oldies.com.ar - Mp3 Oldies | http://www.best-mp3software.com - Mp3 Software


Posted By: WebWiz-Bruce
Date Posted: 19 June 2003 at 8:31am

It's the table prefix that changes.

So for example in the database you have tblAuthor as one of the tables, the prfix is tbl so for example in another intence of the forum you copuld have tbl2Author with tbl2 being the prefix to the tables that would also need to be changed in both common.asp files.



-------------
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: donhill
Date Posted: 20 June 2003 at 2:38am

ok I am about to start on this.

One last question before I begin.

 

Do I need to make a duplicate table for every table in the database or can I just make duplicates for some of them?

 

ie Can I draw up the different forum but still access the same member passwords etc?



Posted By: donhill
Date Posted: 20 June 2003 at 3:49am

Starting my thinking again!

 

I have tow forums which have the same customers and I didnt want them to have to log into both forums.

So if both forums ran from teh same database I wanted to be able to look uup the memebr details from each forum from teh same table within the single combined database.

 

Looking at the tables and your comments it looks like it is possible to set up tw oforums from one databsae but both forums use differnet table prefix which emans the yare really separet even thouh contained within the same databse. ie they are not able to look uo the same member details etc and even the moderators will have to belisted in each table with teh different prefix.

 

If that is so, is it possible to hard code into common.asp and default.asp the actual table name to the member table details etc? If I wanted to set this up so that members did not need to log in to each forum what tables need to be hard coded and which files do I need to hard code thosetables into?

 




Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net