| Author |
 Topic  |
|
|
dayve
Forum Moderator
USA
5820 Posts |
 Posted - 24 May 2001 : 00:44:17
|
I've read through several open ended discussions on how to do this but I fail at every attempt to do it correctly. I would be extremely grateful if someone could layout specific directions (not suggestions please  ) on how to have 2 forums using the same database for topics and user base BUT different color schemes. The Forum scripts will be on the same server so I need to ensure every detail is discussed including config script changes, table additions/changes, cookie setup, the works.
I've come close to accomplishing this only to blow it so I am giving up for now hoping someone can get me back on track.
I am available for chat at ICQ 4014050 if you can help. Thanks to all the help I've received so far. This community is a great place to be..
Dayve
Dayve |
|
|
sr_erick
Senior Member
USA
1318 Posts |
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 24 May 2001 : 19:12:13
|
I'm kind of getting a handle on this but I am taking it extremely slow...
What I did so far was for the second forum I created a variable in the config.asp like so
dim strDBType, strConnString, strTablePrefix, strMemberTablePrefix, strTableTwoPrefix '## Do Not Edit
then I added this:
strTableTwoPrefix = "FORUM2_"
Then I copied the CONFIG table and named it FORUM2_CONFIG
As for the admin files I started with the most important one admin_config_colors.asp and I removed and replaced all strTablePrefix with strTableTwoPrefix. I am presently doing the same for admin_config_system.asp
Things are going the way I want but I am still reviewing things closely. I really need to identify any criticial issues I should be aware of before I go LIVE. I would continue to appreciate any info you can offer me while I am working through this but after hours of reviewing snitz code I think I am getting the hang of it.
One burning question is... what is the importance of this variable:
strMemberTablePrefix = "FORUM_"
Thanks...
Dayve |
 |
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 24 May 2001 : 20:34:46
|
I thought that all you need to do is upload another set of the snitz forum into another folder, edit the config.asp file to point to the same database and then edit the values of strTablePrefix and strMemberTablePrefix to something like FORUM2_. That would be all you need to do. So you would have 2 different Members info and Forum Config in the same database. one will be starting with FORUM_CONFIG, FORUM_TOPICS, FORUM_MEMBERS for example and the other will have FORUM2_CONFIG, FORUM2_TOPICS, FORUM2_MEMBERS and so forth.
You would need to be aware of some of the mods that don't code thier SQL statements with the strTablePrefix or the strMemberTablePrefix. Some of them forget them.
|
|
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 24 May 2001 : 22:52:43
|
quote:
I thought that all you need to do is upload another set of the snitz forum into another folder, edit the config.asp file to point to the same database and then edit the values of strTablePrefix and strMemberTablePrefix to something like FORUM2_. That would be all you need to do. So you would have 2 different Members info and Forum Config in the same database. one will be starting with FORUM_CONFIG, FORUM_TOPICS, FORUM_MEMBERS for example and the other will have FORUM2_CONFIG, FORUM2_TOPICS, FORUM2_MEMBERS and so forth.
You would need to be aware of some of the mods that don't code thier SQL statements with the strTablePrefix or the strMemberTablePrefix. Some of them forget them.
no I don't think so, I want to maintain the same exact user base and topics for both forums. this example would cause you to have double of ALL tables, I am pretty sure of this but by all means someone please correct me... I've successfully gotten on the right path for doing this. 2 forums, same members, same topics, different colors, different admin features... working good, should be done soon and I can document this for everyone because I know it will prove to be useful.
My intentions from the very beginning was to host a forum for someone on my server. He now has 300 members that I want to mirror on my website which is hosted on the same server so we will have www.burningsouls.com/forum with his red scheme and I will have www.nineinchnailz.com/forum with my color scheme. Then members can go to either site and utilize their accounts and see the same topics.
Dayve |
|
|
|
JGonier
Starting Member
USA
44 Posts |
Posted - 25 May 2001 : 01:38:59
|
I am just wondering, so don't mind me if I go off track here.
You want your members to see the same topic? Do you mean the main forum topics or the main forum topics and the posts inside them?
If its just the main forum topics and the users information, why don't you just use two databases, open up the empty one in Access and import the Forum_Members and Forum_Topics tables into it, overwriting the empty ones. This way both forums will have the same topics and users but different color scheme and topic posts.
It kinda seems reduntant to have two forums with everything the same, including the topic posts but just different color schemes. Your users would be seing the same posts in both forums. I don't think this is what you are trying to do, because it would be easier just to make one forum and both sites share it.
If what you are trying to do is what I think, I would just import the needed Tables from the one forum to the other and run two databases. Save you alot of time in re-writing the code....oh, I just thought about something. What I said wouldn't work. Your users would have to the register at both sites thereafter.
Like I said, I was just rambling.
I thought I had an idea, but it was just a brain fart. Sorry.
Keep working on it the way you are.
Sincerely,
JGonier
Edited by - JGonier on 25 May 2001 01:39:47 |
|
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 25 May 2001 : 03:29:07
|
quote:
Your users would have to the register at both sites thereafter
exactly what I don't want to do. I want registered members to be able to go to either forum without having 2 separate accounts. I pretty much have a handle on this. I just needed 1 new table with was a copy of FORUM_CONFIG so I can edit the color scheme. Everything appears to be working the way I want without as much file editing as I thought weeks ago. What I stated above should be able to help anyone else interested in doing this...
Here is what I've accomplished so far...
Burning Souls
Nine Inch Nailz
both forums use the same database for Categories, Topics, Replies, Members but have different SKINS...
Dayve
Edited by - dayve on 25 May 2001 03:40:25 |
|
|
| |
Topic |
|
Topic Locked
