<% '################################################################################# '## Copyright (C) 2000-01 Michael Anderson and Pierre Gorissen '## '## This program is free software; you can redistribute it and/or '## modify it under the terms of the GNU General Public License '## as published by the Free Software Foundation; either version 2 '## of the License, or any later version. '## '## All copyright notices regarding Snitz Forums 2000 '## must remain intact in the scripts and in the outputted HTML '## The "powered by" text/logo with a link back to '## http://forum.snitz.com in the footer of the pages MUST '## remain visible when the pages are viewed on the internet or intranet. '## '## This program is distributed in the hope that it will be useful, '## but WITHOUT ANY WARRANTY; without even the implied warranty of '## MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the '## GNU General Public License for more details. '## '## You should have received a copy of the GNU General Public License '## along with this program; if not, write to the Free Software '## Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. '## '## Support can be obtained from support forums at: '## http://forum.snitz.com '## '## Correspondence and Marketing Questions can be sent to: '## reinhold@bigfoot.com '## '## or '## '## Snitz Communications '## C/O: Michael Anderson '## PO Box 200 '## Harpswell, ME 04079 '################################################################################# Response.Write "" & vbNewline Response.Write "

" Response.Write " Jump To:" & vbNewline Response.Write " " & vbNewline & _ " Select Forum" & vbNewline '## Get all Forum Categories From DB strSql = "SELECT CAT_ID, CAT_NAME, CAT_ORDER " & _ " FROM " & strTablePrefix & "CATEGORY" & _ " ORDER BY CAT_ORDER ASC, CAT_NAME ASC" set rsCat = my_conn.Execute (strSql) do until rsCat.eof '## Grab the Categories. CatID = rsCat("CAT_ID") CatName = rsCat("CAT_NAME") '## Build SQL to get forums via category '## Forum_SQL strSql = "SELECT FORUM_ID, F_TYPE, F_SUBJECT, F_URL, CAT_ID, F_ORDER " & _ " FROM " & strTablePrefix & "FORUM " & _ " WHERE CAT_ID = " & CatID & _ " ORDER BY F_ORDER ASC, F_SUBJECT ASC;" set rsForum = my_Conn.Execute (StrSql) if rsForum.eof or rsForum.bof then 'nothing else iNewCat = rsForum("CAT_ID") iOldCat = 0 do until rsForum.Eof ForumCatID = rsForum("CAT_ID") ForumID = rsForum("FORUM_ID") ForumType = rsForum("F_TYPE") ForumURL = rsForum("F_URL") if ChkForumAccess(ForumID, getNewMemberNumber()) then if iNewCat <> iOldCat Then Response.Write " " & CatName & "" & vbNewline iOldCat = iNewCat end if if ForumType = 0 then Response.Write "       " & rsForum("F_SUBJECT")& "" & vbNewline end if rsForum.MoveNext loop end if rsCat.MoveNext loop Response.Write "  --------------------" & vbNewline & _ " Home" & vbNewline & _ " Active Topics" & vbNewline & _ " Frequently Asked Questions" & vbNewline & _ " Member Information" & vbNewline & _ " Search Page" & vbNewline & _ " " & vbNewline & _ "

" & vbNewline & _ "" & vbNewline %>