2 forum - 1 user database

Post Reply

Page 12 3 >

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
Bubaz Members Profile Find Members Posts Newbie Joined: 08 February 2006 Location: Belgium Status: Offline Points: 1	Post Options Post Reply Quote Bubaz Report Post Thanks(0) Quote Reply Topic: 2 forum - 1 user database Posted: 08 February 2006 at 5:59pm
	Hi, I have 2 questions : - I would like create 2 forum (not sub forum) with 2 different database but with only 1 user database (for login / registration). Do you have a solution for that under SQL server - Is it possible to attribute a specific layout (header / footer) for a subforum? Thanks, Bubaz

wmeyers Members Profile Find Members Posts Newbie Joined: 11 February 2006 Location: United States Status: Offline Points: 15	Post Options Post Reply Quote wmeyers Report Post Thanks(0) Quote Reply Posted: 13 February 2006 at 9:51pm
	I am also interested in Question 1. I will have multiple subdomains, i.e. subdomain1.domain.org, subdomain2.domain.org, etc. Can I use the same SQL database for multiple sites as long as I change the table names? If so, in what file that runs the SQL script would I need to change the names? In doing so, it would be great if I could leave the members table alone and let people across multiple sites share it. Is this possible? Can the subdomains be virtual, or do they have to be real? I am worried about conflicting ASP sessions between the multiple forums. Any advice would be greatly appreciated! Thanks.

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply Posted: 14 February 2006 at 11:41am
	To use the same SQL Server database you need to change the database table prefix in the common.asp files and the SQL Server setup file. For multiple forums using the same members table would be allot harder and would require substantial code re-writing within many files of the forum.
	Web Wiz Forums Hosting ASP.NET Web Hosting

wmeyers Members Profile Find Members Posts Newbie Joined: 11 February 2006 Location: United States Status: Offline Points: 15	Post Options Post Reply Quote wmeyers Report Post Thanks(0) Quote Reply Posted: 14 February 2006 at 6:46pm
	Understood, thanks for your prompt response!

MarcusJS Members Profile Find Members Posts Newbie Joined: 15 February 2006 Status: Offline Points: 5	Post Options Post Reply Quote MarcusJS Report Post Thanks(0) Quote Reply Posted: 15 February 2006 at 4:25pm
	Just done this and it all seemed pretty easy (I'm using the SQL version) but hit a little glitch - the admin area seems to be pointing to the config table of my original forum. Have I missed something, can anyone help? Thanks in anticipation

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply Posted: 16 February 2006 at 10:31am
	There is also a common.asp file in the admin area, you need to update the table prefix, etc. in that file as well.
	Web Wiz Forums Hosting ASP.NET Web Hosting

MarcusJS Members Profile Find Members Posts Newbie Joined: 15 February 2006 Status: Offline Points: 5	Post Options Post Reply Quote MarcusJS Report Post Thanks(0) Quote Reply Posted: 20 February 2006 at 9:43am
	I admit I missed that one at first (between posting my question & getting the response) but I've also updated it and I've got a new problem now... Although I can get into the correct admin areas for each forum when I change the settings in one - like the logo - it applies the change to both forums. I'm guessing it's a connection string problem again or something similar.

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply Posted: 20 February 2006 at 10:16am
	For performance reasons Web Wiz Forums uses application level variables to cut down on database hits, these will effect other web wiz forums running in the same application. There are two ways to get around this, if you have access to the server you could place each forum in it's own application. If you don't have access to the server you will need to set the variable 'Const blnUseApplicationVariables = true' to false in one or both your forums in the common.asp file
	Web Wiz Forums Hosting ASP.NET Web Hosting

Post Reply	Page 12 3 >

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum