| Author |
 Topic  |
|
xpumpa
Starting Member
Czech Republic
1 Posts |
 Posted - 18 January 2001 : 03:10:04
|
Hi all,
Here is my solution for Multiple forums with same Users.
1. Create directories
-
/forums/template-
/forums/forum1-
/forums/forum2
2. Copy all necessary forum files to directory /forums/template
3. Backup this config file /forums/template/config.asp
4. Edit this file /forums/template/config.asp, clear all and write this:
<%
' #### - PUT HERE ALL DIMs from orig config.asp
dim strDBType, strConnString, .....
dim strVersion, strForumTitle, .....
Dim ForumName
ForumName = Request.ServerVariables("SCRIPT_NAME")
ForumName = Mid(ForumName,Instr(ForumName,"/") + 1)
ForumName = Mid(ForumName,Instr(ForumName,"/") + 1)
ForumName = Mid(ForumName,1, Instr(ForumName,"/") - 1)
ForumName = LCase(ForumName)
SELECT CASE ForumName
CASE "forum1"
%><!--#INCLUDE FILE="../forum1/config.asp" --><%
CASE "forum2"
%><!--#INCLUDE FILE="../forum2/config.asp" --><%
END SELECT
%>
5. Copy your backup of config.sys to each directory /forums/forum1 and /forums/forum2
6. Clear ALL DIMs from both config.asp from directories forum1 and forum2 and define strTablePrefix.
7. In /forums/forum1 and /forums/forum1 create new forum files (active.asp, topic.asp, forum.asp, ....) without include files.
8. Edit these files and write this to all:
<!--#INCLUDE FILE="config.asp" -->
<%
Dim ScriptName
ScriptName = Request.ServerVariables("SCRIPT_NAME")
ScriptName = Mid(ScriptName,InstrRev(ScriptName,"/") + 1)
Server.Transfer(strPath & ScriptName)
%>
9. Thats All. Each new forum has about 74kb, Don't remember create new forum tables in DB.
10. Sorry my English 
Filip
|
|
|
John
Junior Member
USA
427 Posts |
Posted - 18 January 2001 : 13:02:19
|
Server.Transfer is only available in ASP 3.0, which is only in IIS 5, which is only in Windows 2000...
Actually all you have to do is:
upload copies of the files to two (or more) directories
set the database connstring to the same DB
set strTablePrefix to "FORUM#"
set strMemberTablePrefix to "FORUM".
then create copies of the FORUM_* tables calling them "FORUM#_*", except for the members table.
then just run setup.asp for each forum and you should be done!
John Miller
Snitz Moderator
Teach me good discernment and knowledge, For I believe in Your commandments.
- Psalms 119:66 |
 |
|
|
dreamcreator
Starting Member
USA
15 Posts |
Posted - 14 April 2001 : 14:15:12
|
I was reading over this and was kinda able to understand it, but was wondering if it could possibly go into detail with exacly what I need to change. I have two separate pages right now that I would like to share the same members database. One site is http://pso.cubicdreams.com and the other is http://daoc.cubicdreams.com  If it is really possible I would like to have the strTablePrefix to "FORUMpso" / "FORUMdaoc" and so on. What else would I have to change to do this. I wasn't sure how to make sure it won't mess anything up with creating new sections in each of the forums. Any help would really be appreciated.
-Dream 
http://www.cubicdreams.com
PSO Community ^ |
|
|
|
bjlt
Senior Member
1144 Posts |
Posted - 15 April 2001 : 00:10:50
|
me too want to know. a more detailed readme on this issue would be helpful.
I didn't know that it's already built into the code before reading this.
Edited by - bjlt on 15 April 2001 23:56:49 |
|
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 15 April 2001 : 15:06:39
|
Ehm...it might be that I didn't read this topic good enough, but you don't need a mod to have more than one forum use the same users...it is supported in the plain forum code.
Just create a new set of tables using i.e. FORUM2_ as prefix.
Do that for all tables except the FORUM_MEMBERS table.
Then in one config.asp set the strTablePrefix to FORUM2_ and in the other leave it to FORUM_ and make sure both forums have strMemberTablePrefix set to FORUM_
that is all there is to it...
Pierre
Join the Snitz WebRing |
|
|
|
davea
New Member
61 Posts |
Posted - 19 April 2001 : 06:03:57
|
This is something that interests me, multiple forums with the same uses base, but different forum names and different colour schemes, is there a sure fire way to do this?
|
|
|
|
James
Average Member
USA
539 Posts |
Posted - 19 April 2001 : 13:31:05
|
quote:
Just create a new set of tables using i.e. FORUM2_ as prefix.
Do that for all tables except the FORUM_MEMBERS table.
Pierre,
Is there an ASP script that can create the new tables needed?
-
*Interested in Radio Control*
*The RC Web Board - http://www.rcwebboard.com/* |
|
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 19 April 2001 : 16:33:05
|
quote:
quote:
Just create a new set of tables using i.e. FORUM2_ as prefix.
Do that for all tables except the FORUM_MEMBERS table.
Pierre,
Is there an ASP script that can create the new tables needed?
For Access: no, but there you can copy and rename the tables very easy.
For Sql Server and MySql: just change the strTablePrefix in config.asp and run setup.asp and the tables get created. You'll recieve an error because it tries to recreate FORUM_MEMBERS (since you didn't rename strMemberTablePrefix), but that is no problem.
So you could put all the forums in their own directory, change the config.asp so that strTablePrefix is unique on each of them and strMemberTablePrefix is the same on all of the forums and then run setup.asp one by one for all of them.
Pierre
Join the Snitz WebRing |
|
|
|
master of puppets
Junior Member
Canada
117 Posts |
Posted - 19 April 2001 : 22:40:30
|
Why change all the database tables? Why not just make FORUM2_CONFIG then change the admin_***.asp files to point to that one for configuration, that way both forums have all the same forums, and posts, but with different configurations. That is what we did
http://www.snowmobilefanatics.com/snofans/
and
http://www.snowmobilefanatics.com/polarisman/
"It's not how far you go, it's how go you far"
- Guy in Ski School |
|
|
|
speedway
New Member
88 Posts |
Posted - 20 April 2001 : 15:08:07
|
Any idea how have to Forums but one of the categorys not displayed in one forum.
|
|
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 05 May 2001 : 16:41:47
|
master of puppets, I get what you are saying but could you please elaborate, there is something missing from your master plan!
Dayve |
|
|
|
Dan03
Starting Member
Australia
17 Posts |
Posted - 12 May 2001 : 05:53:33
|
I don't have MS Access installed at the moment, so is there an SQL command to copy the tables and rename them?
- Dan.
_______________________________
http://www.zer03.com/ |
|
|
|
Matti-Mck
Starting Member
38 Posts |
Posted - 13 May 2001 : 07:25:14
|
dayve, what master of pupets is trying to say (or at least i think) is that if you have two forums wanting only the same config, or only the same members, or even only the same posts!, then you just configure all the admin_###.asp files to point to the same database, so that they get the same information. i did what master of pupets did. i wanted the same forum, but different config (different graphics and colours) but the same information and members.
http://apmessageboard.cjb.net
and
http://www.poc-network.com
it took me a while to do, but it's not that difficult.
-Matti
|
|
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 16 May 2001 : 14:20:42
|
thanks Matti-Mck, I have a good understanding of what needs to be done but I'd hate to really miss out on anything important. So a favor to ask of ANYONE... I was told to edit all the admin...asp files BUT I was also told to create a FORUM2_ table. Can someone properly outline the details here at the forum on how to successfully do this without missing any critical steps. I am going to have a stab at it right now but just in case I have to restart it would be nice to have a guideline.
My goal is to have the same exact members, categories, topics and mods but with a different color scheme running on the same server but different url's pointing to it.
For example, my forum exists here:
http://www.burningsouls.com/forum which I am hosting for this guy (if you look it's actually being cloaked and directed to http://www.nineinchnailz.com/forum).
I want to basically mirror the forum at my site too with different colors.
Hope that helps.. A MUCHO thanks in advance for anyone able to get me through this somewhat painlessly
Dayve |
|
|
|
Dan03
Starting Member
Australia
17 Posts |
Posted - 18 May 2001 : 08:03:15
|
So, theres no SQL command, would anybody be willing to copy the tables for me? I know that it is rather a big hassle to transfer the database, but I really need some help here 
- Dan.
_______________________________
http://www.zer03.com/ |
|
|
|
gwhit
Starting Member
5 Posts |
Posted - 18 May 2001 : 21:03:58
|
Try this it works on access2000 db not sure but it should also work on SQL. Mysql I have no clue if this works.
'******************************************
select * into [new_table] from [old_table}
'******************************************
Edited by - gwhit on 18 May 2001 21:05:30
Edited by - gwhit on 18 May 2001 21:07:24 |
|
|
|
Topic |
|
Topic Locked
