quote:

---

1.In EM, right click over the database where the tables you want, exist. In the popup menu, choose, Generate SQL Script~;
2. In the dialog that shows, on the General tab, click Show All. Then click to check All tables. or click individually in the forum tables you want;
3. Click the Options tab. In the table scripting options group, check "script indexes" and then check "script Primary Keys, Foreign keys...";
4. Click the Ok button, pick a file name and location. The script will be generated;

5. Open Query Analizer and connect to the server;
6. Using File -> Open, open the script created in 4 in Query Analizer;
7. Using Edit->Replace, replace all the occurrances of FORUM_ by FORUM2_ in the script;
8. Make sure the database name for the database where you want to create the tables is shown in the dropdown above the SQL editing window in Query Analizer.
9. Execute the script.

The new tables with the proper indexes should have been created by now... but you will have a blank database...

---

if (strShowModerators = "1") then
	'## Forum_SQL
	strSql = "SELECT MO.FORUM_ID, ME.MEMBER_ID, ME.M_NAME " & _
		 " FROM " & strTablePrefix & "MODERATOR MO" & _
		 " , " & strMemberTablePrefix & "MEMBERS ME"  & _
		 " WHERE (MO.MEMBER_ID = ME.MEMBER_ID )" & _
		 " ORDER BY MO.FORUM_ID, ME.M_NAME"

	Set rsChk = Server.CreateObject("ADODB.Recordset")
	rsChk.open strSql, my_Conn, adOpenForwardOnly, adLockReadOnly, adCmdText

	if rsChk.EOF then
		recModeratorCount = ""
	else
		allModeratorData = rsChk.GetRows(adGetRowsRest)
		recModeratorCount = UBound(allModeratorData,2)
	end if

	rsChk.close
	set rsChk = nothing

	if recModeratorCount = "" then
		fMods = " "
	else
		mFORUM_ID = 0
		mMEMBER_ID = 1
		mM_NAME = 2

		for iModerator = 0 to recModeratorCount
			ModForumID = allModeratorData(mFORUM_ID, iModerator)
			ModMemID = allModeratorData(mMEMBER_ID, iModerator)
			ModMemName = replace(allModeratorData(mM_NAME, iModerator),"|","#124")

			if iModerator = 0 then
				strForumMods = ModForumID & "," & ModMemID & "," & ModMemName
			else
				strForumMods = strForumMods & "|" & ModForumID & "," & ModMemID & "," & ModMemName
			end if
		next
	end if
end if