<%
on error resume next
Response.Buffer = true

'#################################################################################
'## SELECT YOUR DATABASE  CONNECTION TYPE (access, sqlserver or mysql)
'#################################################################################

strNEW_TABLE_PREFIX = "FORUM_"'Table we are copying'sPrefix
strOLD_TABLE_PREFIX = "NEW_"'NEW Table Prefix
'#############################################3
'Change strTables to a list of table names minus the prefix. ie in standard snitz install prefix will be FORUM_
'so you would look at FORUM_MEMBERS and just add MEMBERS. and seperate each name by a comma(,)
strTables = "ALLOWED_MEMBERS,anc,anc_comments,AVATAR,AVATAR2,BOOKMARKS,CATEGORY,COMPLAINTS,CONFIG,email_config,EVENTS,Events_Members,FORUM,MEMBERFIELDS,MEMBERS,MODERATOR,MODS,ONLINE,PM,POLL,REPLY,smile_cat,smiles,TOPICS,TOTALS,USERFIELDS,USERFILES,VOTELOG"
'## Make sure to uncomment one of the strConnString lines!
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=c:\inetpub\dbroot\snitz_forums_2000.mdb" '## MS Access 97
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("tools/snitz2000.mdb")  '## MS Access 97 using virtual path
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("tools/snitz2000.mdb") '## MS Access 2000 using virtual path
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Inetpub\wwwroot\residential\eastpasco_com\fpdb\eastpasco_com.mdb;" '## MS Access 2000
'strConnString = "driver={SQL Server};server=SERVER_NAME;uid=SQL_USER;pwd=PARRWORD;database=DATABASE_NAME"" '## MS SQL Server 7
'strConnString = "driver=MySQL;server=SERVER_NAME;uid=MYSQL_USER;pwd=PARRWORD;database=DATABASE_NAME" '## MySQL
set my_Conn = Server.CreateObject("ADODB.Connection")
my_Conn.Open strConnString
strNewID = "DEV"
AryTables = Split(strTables, ",", -1, 1)
For Each Table in AryTables
	If Table <> "" THEN
	SQL = "select * into " & strNewID & "_" & Table & " from MULTI_" & Table
	SQL = "SELECT * INTO "& strNEW_TABLE_PREFIX & Table & " FROM " strOLD_TABLE_PREFIX & Table
	Response.Write "NEW TALBE " & strNEW_TABLE_PREFIX & Table & " Created from " & strOLD_TABLE_PREFIX & Table
	my_Conn.Execute (SQL)
	END IF
NEXT
my_Conn.Close
set my_Conn = nothing
%>

quote:

---

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

---

select * into [new_FORUM_ALLOWED_MEMBERS] from [FORUM_ALLOWED_MEMBERS]
select * into [new_FORUM_CATEGORY] from [FORUM_CATEGORY]
select * into [new_FORUM_CONFIG] from [FORUM_CONFIG]
select * into [new_FORUM_FORUM] from [FORUM_FORUM]
select * into [new_FORUM_MEMBERS] from [FORUM_MEMBERS]
select * into [new_FORUM_MODERATOR] from [FORUM_MODERATOR]
select * into [new_FORUM_REPLY] from [FORUM_REPLY]
select * into [new_FORUM_TOPICS] from [FORUM_TOPICS]
select * into [new_FORUM_TOTALS] from [FORUM_TOTALS]

quote:

---

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

---

quote:

---

Dear fellow members

I want to make a kind of community where people can communicate, find information, do transactions, follow education and (like Snitz) produce togheter. I want to use snitz for this community with different forums. I want to make a hompage were you can choose to go to a forum who is based on a Library, a forum based a meetingpoint, a forum based on a school, a forum based on a developer group, etc. Every forum must have its own possibilities, but with the same members. I read that you can do this by copying every file and almost every database table and give it a new name (forum2-, forum3-, etc). I was wondering if their is for my case a better way. Because I want to use the forum of www.eastpasco.com the database of this forum is already very big. And I am thinking to use at least 8 different forums.
Also I want to ask if anybody have an idea how to make from the forum a kind of meetingpoint.
I will explane:
The meetingpoint that i want to make is a kind of chatroom, with many possibilities to have a good professional meeting. For example a developer has made an apportment in the meetingpoint with an other developer on 10 june at 11 pm. One of them is a sort of meeting leader who makes a new topic with information about the meeting so that other people can join the meetinggroup. On 10 june at 11 pm the meeting is open and there appears in the map of the topic a link to a chatroom (meetingroom). Clicking of this link will direct them to the chatroom. Every meeting has a start time and a finish time. For example when the meeting leader has sad that the meeting ends on 10 june at 12 pm, automaticaly on that time the meeting stops.
If somebody have a kind of idea how to make this let me know! If somebody in The Netherlands want to help to make the first really (efficent) good business to business community let me also know. Maybe we can do togheter good business. So when you want to help to make a commercial standard business to business community, please e-mail me at: stephenbouman@hotmail.com


[quote]
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
[/quote

---