Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Linking different forums to same database
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Linking different forums to same database

 Post Reply Post Reply
Author
donhill View Drop Down
Groupie
Groupie
Avatar

Joined: 06 June 2003
Location: Australia
Status: Offline
Points: 66
Post Options Post Options   Thanks (0) Thanks(0)   Quote donhill Quote  Post ReplyReply Direct Link To This Post Topic: Linking different forums to same database
    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?

 

 

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: 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.

Back to Top
donhill View Drop Down
Groupie
Groupie
Avatar

Joined: 06 June 2003
Location: Australia
Status: Offline
Points: 66
Post Options Post Options   Thanks (0) Thanks(0)   Quote donhill Quote  Post ReplyReply Direct Link To This Post 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

Back to Top
abhinav View Drop Down
Groupie
Groupie


Joined: 13 May 2003
Location: India
Status: Offline
Points: 63
Post Options Post Options   Thanks (0) Thanks(0)   Quote abhinav Quote  Post ReplyReply Direct Link To This Post Posted: 19 June 2003 at 7:02am
I don't know the answer .. but this should be interesting
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: 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.

Back to Top
donhill View Drop Down
Groupie
Groupie
Avatar

Joined: 06 June 2003
Location: Australia
Status: Offline
Points: 66
Post Options Post Options   Thanks (0) Thanks(0)   Quote donhill Quote  Post ReplyReply Direct Link To This Post 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?

Back to Top
donhill View Drop Down
Groupie
Groupie
Avatar

Joined: 06 June 2003
Location: Australia
Status: Offline
Points: 66
Post Options Post Options   Thanks (0) Thanks(0)   Quote donhill Quote  Post ReplyReply Direct Link To This Post 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?

 

Back to Top
 Post Reply Post Reply

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.