Avatar billede duno Nybegynder
15. marts 2004 - 23:51 Der er 7 kommentarer og
2 løsninger

Hvad betyder det her? og hvad skal der rettes

og hvor skal jeg rette for at få det til at virke (langt)


dette er fejlmeddelelsen

Microsoft OLE DB Provider for ODBC Drivers error '80040e10'

[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 5.

/forum3/topic2a.asp, line 117


og dette er linie 116 og 117

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


dette er koden


%>
<!--#INCLUDE FILE="config.asp"-->
<%

if (Request.QueryString("TOPIC_ID") = "" or IsNumeric(Request.QueryString("TOPIC_ID")) = False) and Request.Form("Method_Type") <> "login" and Request.Form("Method_Type") <> "logout" then
    Response.Redirect "default.asp"
    Response.End
else
    Topic_ID = cLng(Request.QueryString("TOPIC_ID"))
end if
Dim ArchiveView, ArchiveLink, CColor
if request("ARCHIVE") = "true" then
    strActivePrefix = strTablePrefix & "A_"
    ArchiveView = "true"
    ArchiveLink = "ARCHIVE=true&"
else
    strActivePrefix = strTablePrefix
    ArchiveView = ""
    ArchiveLink = ""
end if

%>
<!--#INCLUDE FILE="inc_sha256.asp"-->
<!--#INCLUDE FILE="inc_header.asp" -->
<!--#INCLUDE FILE="inc_func_secure.asp" -->
<!--#INCLUDE FILE="inc_func_member.asp" -->
<!--#INCLUDE FILE="inc_subscription.asp" -->
<!--#INCLUDE FILE="inc_moderation.asp" -->
<!--#INCLUDE FILE="cal_functions.asp" -->
<!-- #include file="../conquerchat/inc.classes.asp" -->
<!-- #include file="../conquerchat/inc.utilities.asp" -->

<%
Response.Write    "    <script language=""JavaScript"" type=""text/javascript"">" & vbNewLine & _
        "    function ChangePage(fnum){" & vbNewLine & _
        "        if (fnum == 1) {" & vbNewLine & _
        "            document.PageNum1.submit();" & vbNewLine & _
        "        }" & vbNewLine & _
        "        else {" & vbNewLine & _
        "            document.PageNum2.submit();" & vbNewLine & _
        "        }" & vbNewLine & _
        "    }" & vbNewLine & _
        "    </script>" & vbNewLine

mypage = request("whichpage")
if ((Trim(mypage) = "") or (IsNumeric(mypage) = False)) then mypage = 1
mypage = cLng(mypage)

if Request("SearchTerms") <> "" then
    SearchLink = "&SearchTerms=" & Request("SearchTerms")
else
    SearchLink = ""
end if

if strSignatures = "1" and strDSignatures = "1" then
    if ViewSig(MemberID) <> "0" then
        CanShowSignature = 1
    end if
end if

'## Forum_SQL - Get original topic and check for the Category, Forum or Topic Status and existence
strSql = "SELECT M.M_NAME, M.M_RECEIVE_EMAIL, M.M_AIM, M.M_ICQ, M.M_MSN, M.M_YAHOO" & _
    ", M.M_TITLE, M.M_HOMEPAGE, M.MEMBER_ID, M.M_LEVEL, M.M_POSTS, M.M_COUNTRY, M.M_AWARD_PORTAL, M.M_AWARD_TITLE, M.M_AWARD_POST, M.M_AWARD_PROFILE, M.M_AWARD_IMAGE, M.M_AVATAR_URL" & _
    ", T.T_DATE, T.T_SUBJECT, T.T_AUTHOR, T.TOPIC_ID, T.T_STATUS, T.T_LAST_EDIT" & _
    ", T.T_LAST_EDITBY, T.T_LAST_POST, T.T_SIG, T.T_REPLIES, T.T_ISEVENT" & _
    ", C.CAT_STATUS, C.CAT_ID, C.CAT_NAME, C.CAT_SUBSCRIPTION, C.CAT_MODERATION" & _
    ", F.F_STATUS, F.FORUM_ID, F.F_SUBSCRIPTION, F.F_SUBJECT, F.F_MODERATION, T.T_MESSAGE"
if CanShowSignature = 1 then
    strSql = strSql & ", M.M_SIG"
end if
strSql = strSql & " FROM " & strActivePrefix & "TOPICS T, " & strTablePrefix & "FORUM F, " & _
    strTablePrefix & "CATEGORY C, " & strMemberTablePrefix & "MEMBERS M " & _
    " WHERE T.TOPIC_ID = " & Topic_ID & _
    " AND F.FORUM_ID = T.FORUM_ID " & _
    " AND C.CAT_ID = T.CAT_ID " & _
    " AND M.MEMBER_ID = T.T_AUTHOR "

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

if rsTopic.EOF then
    recTopicCount = ""
else
    recTopicCount = 1
    Member_Name = rsTopic("M_NAME")
    Member_ReceiveMail = rsTopic("M_RECEIVE_EMAIL")
    Member_AIM = rsTopic("M_AIM")
    Member_ICQ = rsTopic("M_ICQ")
    Member_MSN = rsTopic("M_MSN")
    Member_YAHOO = rsTopic("M_YAHOO")
    Member_Title = rsTopic("M_TITLE")
    Member_Homepage = rsTopic("M_HOMEPAGE")
    TMember_ID = rsTopic("MEMBER_ID")
    Member_Level = rsTopic("M_LEVEL")
    Member_Posts = rsTopic("M_POSTS")
    Member_Country = rsTopic("M_COUNTRY")
    Member_Avatar = rsTopic("M_AVATAR_URL")
    Topic_Date = rsTopic("T_DATE")
    Topic_Subject = rsTopic("T_SUBJECT")
    Topic_Author = rsTopic("T_AUTHOR")
    TopicID = rsTopic("TOPIC_ID")
    Topic_Status = rsTopic("T_STATUS")
    Topic_LastEdit = rsTopic("T_LAST_EDIT")
    Topic_LastEditby = rsTopic("T_LAST_EDITBY")
    Topic_LastPost = rsTopic("T_LAST_POST")
    Topic_Sig = rsTopic("T_SIG")
    Topic_Replies = rsTopic("T_REPLIES")
    IsEvent = rsTopic("T_ISEVENT")
    Cat_Status = rsTopic("CAT_STATUS")
    Cat_ID = rsTopic("CAT_ID")
    Cat_Name = rsTopic("CAT_NAME")
    Cat_Subscription = rsTopic("CAT_SUBSCRIPTION")
    Cat_Moderation = rsTopic("CAT_MODERATION")
    Forum_Status = rsTopic("F_STATUS")
    Forum_ID = rsTopic("FORUM_ID")
    Forum_Subject = rsTopic("F_SUBJECT")
    Forum_Subscription = rsTopic("F_SUBSCRIPTION")
    Forum_Moderation = rsTopic("F_MODERATION")
    Topic_Message = rsTopic("T_MESSAGE")
    if CanShowSignature = 1 then
        Topic_MemberSig = trim(rsTopic("M_SIG"))
    end if
end if

rsTopic.close
set rsTopic = nothing

if recTopicCount = "" then
    if ArchiveView <> "true" then
        Response.Redirect("topic.asp?ARCHIVE=true&" & Request.QueryString)
    else
        Response.Redirect("default.asp")
    end if
end if

if mLev = 4 then
    AdminAllowed = 1
    ForumChkSkipAllowed = 1
elseif mLev = 3 then
    if chkForumModerator(Forum_ID, chkString(strDBNTUserName,"decode")) = "1" then
        AdminAllowed = 1
        ForumChkSkipAllowed = 1
    else
        if lcase(strNoCookies) = "1" then
            AdminAllowed = 1
            ForumChkSkipAllowed = 0
        else
            AdminAllowed = 0
            ForumChkSkipAllowed = 0
        end if
    end if
elseif lcase(strNoCookies) = "1" then
    AdminAllowed = 1
    ForumChkSkipAllowed = 0
else 
    AdminAllowed = 0
    ForumChkSkipAllowed = 0
end if

if strPrivateForums = "1" and (Request.Form("Method_Type") <> "login") and (Request.Form("Method_Type") <> "logout") and ForumChkSkipAllowed = 0 then
    result = ChkForumAccess(Forum_ID, MemberID, true)
end if

if strModeration > 0 and Cat_Moderation > 0 and Forum_Moderation > 0 and AdminAllowed = 0 then
        Moderation = "Y"
else
        Moderation = "N"
end if

if mypage = -1 and Request.QueryString("REPLY_ID") <> "" then
    strSql1 = "SELECT REPLY_ID "
    strSql2 = "FROM " & strActivePrefix & "REPLY "
    strSql3 = "WHERE TOPIC_ID = " & Topic_ID & " "
    ' DEM --> if not a Moderator, all unapproved posts should not be viewed.
    if AdminAllowed = 0 then
        strSql3 = strSql3 & "AND (R_STATUS < "
        if Moderation = "Y" then
            ' Ignore unapproved/rejected posts
            strSql3 = strSql3 & "2 "
        else
            ' Ignore any previously rejected topic
            strSql3 = strSql3 & "3 "
        end if
        strSql3 = strSql3 & "OR R_AUTHOR = " & MemberID & ") "
    end if
    strSql4 = "ORDER BY R_DATE ASC "

    if strDBType = "mysql" then
        set rsReplies = Server.CreateObject("ADODB.Recordset")

        rsReplies.open strSql1 & strSql2 & strSql3 & strSql4, my_Conn, adOpenForwardOnly, adLockReadOnly, adCmdText

        if rsReplies.EOF then
            iReplyCount = ""
        else
            arrReplyData = rsReplies.GetRows(adGetRowsRest)
            iReplyCount = UBound(arrReplyData, 2)
            rREPLY_ID = 0
        end if

        LastPostReplyID = cLng(Request.QueryString("REPLY_ID"))

        if iReplyCount <> "" then
            for iReply = 0 to iReplyCount
                intReplyID = arrReplyData(rREPLY_ID,iReply)
                if LastPostReplyID = intReplyID then
                    intPageNumber = ((iReply+1)/strPageSize)
                    if intPageNumber > cLng(intPageNumber) then
                        intPageNumber = cLng(intPageNumber) + 1
                    end if
                    strwhichpage = "whichpage=" & intPageNumber & "&"
                    exit for
                end if
            next
        else
            strwhichpage = ""
        end if

        rsReplies.Close
        set rsReplies = nothing
    else
        set rsReplies = Server.CreateObject("ADODB.Recordset")
        rsReplies.cachesize = strPageSize
        rsReplies.pagesize = strPageSize

        rsReplies.open strSql1 & strSql2 & strSql3 & strSql4, my_Conn, adOpenStatic, adLockReadOnly, adCmdText

        LastPostReplyID = cLng(Request.QueryString("REPLY_ID"))
        rsReplies.Find = "REPLY_ID=" & LastPostReplyID & ""

        if not (rsReplies.EOF or rsReplies.BOF) then
            if rsReplies.absolutepage > 1 then strwhichpage = "whichpage=" & rsReplies.absolutepage & "&"
        else
            strwhichpage = ""
        end if

        rsReplies.Close
        set rsReplies = nothing
    end if

    Response.Redirect("topic.asp?" & strwhichpage & "TOPIC_ID=" & Topic_ID & "&#" & LastPostReplyID & "")
    Response.End
end if

' -- Get all the high level(board, category, forum) subscriptions being held by the user
Dim strSubString, strSubArray, strBoardSubs, strCatSubs, strForumSubs, strTopicSubs
if MySubCount > 0 then
    strSubString = PullSubscriptions(0, 0, 0)
    strSubArray  = Split(strSubString,";")
    if uBound(strSubArray) < 0 then
        strBoardSubs = ""
        strCatSubs = ""
        strForumSubs = ""
        strTopicSubs = ""
    else
        strBoardSubs = strSubArray(0)
        strCatSubs = strSubArray(1)
        strForumSubs = strSubArray(2)
        strTopicSubs = strSubArray(3)
    end if
end If

if (Moderation = "Y" and Topic_Status > 1 and Topic_Author <> MemberID) then
    Response.write  "<p align=""center""><font face=""" & strDefaultFontFace & """ size=""" & strHeaderFontSize & """><br />Viewing of this Topic is not permitted until it has been moderated.<br />Please try again later</font></p>" & vbNewLine & _
            "<p align=""center""><font face=""" & strDefaultFontFace & """ size=""" & strHeaderFontSize & """><a href=""java script:history.go(-1)"">Gå tilbage</a></font></p><br />" & vbNewLine
    WriteFooter
    Response.end
else
    Response.Write    "    <script language=""JavaScript"" type=""text/javascript"">" & vbNewLine & _
            "    <!--" & vbNewLine & _
            "    function jumpTo(s) {if (s.selectedIndex != 0) location.href = s.options[s.selectedIndex].value;return 1;}" & vbNewLine & _
            "    // -->" & vbNewLine & _
            "    </script>" & vbNewLine

    '## Forum_SQL
    strSql = "SELECT M.M_NAME, M.M_RECEIVE_EMAIL, M.M_AIM, M.M_ICQ, M.M_MSN, M.M_YAHOO"
    strSql = strSql & ", M.M_TITLE, M.MEMBER_ID, M.M_HOMEPAGE, M.M_LEVEL, M.M_POSTS, M.M_COUNTRY, M.M_AWARD_PORTAL, M.M_AWARD_TITLE, M.M_AWARD_POST, M.M_AWARD_PROFILE, M.M_AWARD_IMAGE, M.M_AVATAR_URL"
    strSql = strSql & ", R.REPLY_ID, R.FORUM_ID, R.R_AUTHOR, R.TOPIC_ID, R.R_MESSAGE, R.R_LAST_EDIT"
    strSql = strSql & ", R.R_LAST_EDITBY, R.R_SIG, R.R_STATUS, R.R_DATE"
    if CanShowSignature = 1 then
        strSql = strSql & ", M.M_SIG"
    end if
    strSql2 = " FROM " & strMemberTablePrefix & "MEMBERS M, " & strActivePrefix & "REPLY R "
    strSql3 = " WHERE M.MEMBER_ID = R.R_AUTHOR "
    strSql3 = strSql3 & " AND R.TOPIC_ID = " & Topic_ID & " "
        ' DEM --> if not a Moderator, all unapproved posts should not be viewed.
        if AdminAllowed = 0 then
            strSql3 = strSql3 & " AND (R.R_STATUS < "
            if Moderation = "Y" then
                ' Ignore unapproved/rejected posts
                strSql3 = strSql3 & "2"
            else
                ' Ignore any previously rejected topic
                strSql3 = strSql3 & "3"
            end if
        strSql3 = strSql3 & " OR R.R_AUTHOR = " & MemberID & ")"
    end if
    strSql4 = " ORDER BY R.R_DATE ASC"

    if strDBType = "mysql" then 'MySql specific code
        if mypage > 1 then
            intOffset = cLng((mypage-1) * strPageSize)
            strSql5 = " LIMIT " & intOffset & ", " & strPageSize & " "
        end if

        '## Forum_SQL - Get the total pagecount
        strSql1 = "SELECT COUNT(R.TOPIC_ID) AS REPLYCOUNT "
       
        set rsCount = my_Conn.Execute(strSql1 & strSql2 & strSql3)
        iPageTotal = rsCount(0).value
        rsCount.close
        set rsCount = nothing

        if iPageTotal > 0 then
            maxpages = (iPageTotal  \ strPageSize )
            if iPageTotal mod strPageSize <> 0 then
                maxpages = maxpages + 1
            end if
            if iPageTotal < (strPageSize + 1) then
                intGetRows = iPageTotal
            elseif (mypage * strPageSize) > iPageTotal then
                intGetRows = strPageSize - ((mypage * strPageSize) - iPageTotal)
            else
                intGetRows = strPageSize
            end if
        else
            iPageTotal = 0
            maxpages = 0
        end if
   
        if iPageTotal > 0 then
            set rsReplies = Server.CreateObject("ADODB.Recordset")
            rsReplies.Open strSql & strSql2 & strSql3 & strSql4 & strSql5, my_Conn, adOpenForwardOnly, adLockReadOnly, adCmdText
                arrReplyData = rsReplies.GetRows(intGetRows)
                iReplyCount = UBound(arrReplyData, 2)
            rsReplies.Close
            set rsReplies = nothing
        else
            iReplyCount = ""
        end if
       
    else 'end MySql specific code
   
        set rsReplies = Server.CreateObject("ADODB.Recordset")
        rsReplies.cachesize = strPageSize
        rsReplies.open strSql & strSql2 & strSql3 & strSql4, my_Conn, adOpenStatic, adLockReadOnly, adCmdText

            if not (rsReplies.EOF or rsReplies.BOF) then
                rsReplies.pagesize = strPageSize
                rsReplies.absolutepage = mypage '**
                maxpages = cLng(rsReplies.pagecount)
                if maxpages >= mypage then
                    arrReplyData = rsReplies.GetRows(strPageSize)
                    iReplyCount = UBound(arrReplyData, 2)
                else
                    iReplyCount = ""
                end if
            else  '## No replies found in DB
                iReplyCount = ""
            end if

        rsReplies.Close
        set rsReplies = nothing
    end if

    Response.Write    "      <table border=""0"" width=""100%"">" & vbNewLine & _
            "        <tr>" & vbNewLine & _
            "          <td width=""50%"" align=""left"" nowrap><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """>" & vbNewLine & _
            "          " & getCurrentIcon(strIconFolderOpen,"","align=""absmiddle""") & "&nbsp;<a href=""default.asp"">Alle fora</a><br />" & vbNewLine & _
            "          " & getCurrentIcon(strIconBar,"","align=""absmiddle""")
    if Cat_Status <> 0 then
        Response.Write    getCurrentIcon(strIconFolderOpen,"","align=""absmiddle""")
    else
        Response.Write    getCurrentIcon(strIconFolderClosed,"","align=""absmiddle""")
    end if
    Response.Write    "&nbsp;<a href=""default.asp?CAT_ID=" & Cat_ID & """>" & ChkString(Cat_Name,"display") & "</a><br />" & vbNewLine & _
            "          " & getCurrentIcon(strIconBlank,"","align=""absmiddle""") & getCurrentIcon(strIconBar,"","align=""absmiddle""")
    if ArchiveView = "true" then
        Response.Write    getCurrentIcon(strIconFolderArchived,"","align=""absmiddle""")
    else
        if Forum_Status <> 0 and Cat_Status <> 0 then
            Response.Write    getCurrentIcon(strIconFolderOpen,"","align=""absmiddle""")
        else
            Response.Write    getCurrentIcon(strIconFolderClosed,"","align=""absmiddle""")
        end if
    end if
    Response.Write    "&nbsp;<a href=""forum.asp?" & ArchiveLink & "FORUM_ID=" & Forum_ID & """>" & ChkString(Forum_Subject,"display") & "</a><br />" & vbNewLine
    if ArchiveView = "true" then
        Response.Write    "          " & getCurrentIcon(strIconBlank,"","align=""absmiddle""") & getCurrentIcon(strIconBlank,"","align=""absmiddle""") & getCurrentIcon(strIconBar,"","align=""absmiddle""") & getCurrentIcon(strIconFolderArchived,"","align=""absmiddle""") & "&nbsp;"

    elseif IsEvent="1" then
        Response.Write    "          " & getCurrentIcon(strIconBlank,"","align=""absmiddle""") & getCurrentIcon(strIconBlank,"","align=""absmiddle""") & getCurrentIcon(strIconBar,"","align=""absmiddle""") & getCurrentIcon(strCalIconEvent,"","align=""absmiddle""") & "&nbsp;" & strCalEvent & ": "
    elseif Cat_Status <> 0 and Forum_Status <> 0 and Topic_Status <> 0 then
        Response.Write    "          " & getCurrentIcon(strIconBlank,"","align=""absmiddle""") & getCurrentIcon(strIconBlank,"","align=""absmiddle""") & getCurrentIcon(strIconBar,"","align=""absmiddle""") & getCurrentIcon(strIconFolderOpenTopic,"","align=""absmiddle""") & "&nbsp;"
    else
        Response.Write    "          " & getCurrentIcon(strIconBlank,"","align=""absmiddle""") & getCurrentIcon(strIconBlank,"","align=""absmiddle""") & getCurrentIcon(strIconBar,"","align=""absmiddle""") & getCurrentIcon(strIconFolderClosedTopic,"","align=""absmiddle""") & "&nbsp;"
    end if
    if Request.QueryString("SearchTerms") <> "" then
        Response.Write    SearchHiLite(ChkString(Topic_Subject,"title"))
    else
        Response.Write    ChkString(Topic_Subject,"title")
    end if
    Response.Write    "</font></td>" & vbNewLine & _
            "          <td align=""center"" width=""50%"">" & vbNewLine
    call PostingOptions()
    Response.Write    "</td>" & vbNewLine & _
            "        </tr>" & vbNewLine & _
            "      </table>" & vbNewLine & _
            "    </td>" & vbNewLine & _
            "  </tr>" & vbNewLine & _
            "</table>" & vbNewLine
    if maxpages > 1 then
        Response.Write    "<table align=""center"" border=""0"" cellPadding=""0"" cellSpacing=""1"" width=""95%"">" & vbNewLine & _
                "  <tr>" & vbNewLine & _
                "    <td align=""right"" valign=""top""><font face=""" & strDefaultFontFace & """ size=""" & strFooterFontSize & """>"
        if mypage > 1 then Response.Write("<a href=""topic.asp?" & ArchiveLink & "TOPIC_ID=" & Topic_ID & "&whichpage=" & mypage-1 & SearchLink & """ title=""Gå til forrige side i dette indlæg""" & dWStatus("Gå til forrige side i dette indlæg") & ">Forrige side</a>")
        'if mypage > 1 then Response.Write("<a href=""java script: onclick=document.PageNum1.whichpage.value=" & mypage-1 & ";document.PageNum1.submit();"" title=""Gå til forrige side i dette indlæg""" & dWStatus("Gå til forrige side i dette indlæg") & ">Forrige side</a>")
        if mypage > 1 and mypage < maxpages then Response.Write(" | ")
        if mypage < maxpages then Response.Write("<a href=""topic.asp?" & ArchiveLink & "TOPIC_ID=" & Topic_ID & "&whichpage=" & mypage+1 & SearchLink & """ title=""Gå til næste side i dette indlæg""" & dWStatus("GGå til næste side i dette indlæg") & ">Næste side</a>")
        'if mypage < maxpages then Response.Write("<a href=""java script: onclick=document.PageNum1.whichpage.value=" & mypage+1 & ";document.PageNum1.submit();"" title=""Gå til næste side i dette indlæg""" & dWStatus("Gå til næste side i dette indlæg") & ">Næste side</a>")
        Response.Write    "</td>" & vbNewLine & _
            "  </tr>" & vbNewLine & _
            "</table>" & vbNewLine
    end if
    Response.Write    "<table align=""center"" border=""0"" cellPadding=""0"" cellSpacing=""0"" width=""95%"">" & vbNewLine & _
            "  <tr>" & vbNewLine & _
            "    <td>" & vbNewLine & _
              "      <table border=""0"" width=""100%"" cellspacing=""0"" cellpadding=""0"" align=""center"">" & vbNewLine & _
            "        <tr>" & vbNewLine & _
            "          <td bgcolor=""" & strTableBorderColor & """>" & vbNewLine & _
            "            <table border=""0"" width=""100%"" cellspacing=""1"" cellpadding=""4"">" & vbNewLine & _
            "              <tr>" & vbNewLine & _
            "                <td align=""center"" bgcolor=""" & strHeadCellColor & """ width=""" & strTopicWidthLeft & """"
    if lcase(strTopicNoWrapLeft) = "1" then Response.Write(" nowrap")
    Response.Write    "><b><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """ color=""" & strHeadFontColor & """>Forfatter</font></b></td>" & vbNewLine & _
            "                <td align=""center"" bgcolor=""" & strHeadCellColor & """ width=""" & strTopicWidthRight & """"
    if lcase(strTopicNoWrapRight) = "1" then Response.Write(" nowrap")
    Response.Write    "><b><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """ color=""" & strHeadFontColor & """>" & vbNewLine
    if strShowTopicNav = "1" then
        Call Topic_nav()
    else
        Response.Write("Indlæg")
    end if
    Response.Write    "</font></b></td>" & vbNewLine
    if (AdminAllowed = 1) then
        if maxpages > 1 then
            Call DropDownPaging(1)
            Response.Write    "                <td align=""right"" bgcolor=""" & strHeadCellColor & """ nowrap>" & vbNewLine
            call AdminOptions()
            Response.Write    "                </td>" & vbNewLine
        else
            Response.Write    "                <td align=""right"" bgcolor=""" & strHeadCellColor & """ nowrap>" & vbNewLine
            call AdminOptions()
            Response.Write    "                </td>" & vbNewLine
        end if
    else
        if maxpages > 1 then
            Call DropDownPaging(1)
        else
                Response.Write    "                <td align=""right"" bgcolor=""" & strHeadCellColor & """ nowrap><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """>&nbsp;</font></td>" & vbNewLine
        end if
    end if
    Response.Write    "              </tr>" & vbNewLine

    if mypage = 1 then
        Call GetFirst()
    end if
   
    '## Forum_SQL
    strSql = "UPDATE " & strActivePrefix & "TOPICS "
    strSql = strSql & " SET T_VIEW_COUNT = (T_VIEW_COUNT + 1) "
    strSql = strSql & " WHERE (TOPIC_ID = " & Topic_ID & ")"

    my_conn.Execute (strSql),,adCmdText + adExecuteNoRecords

    if iReplyCount = "" then  '## No replies found in DB
        ' Nothing
    else
        intI = 0
   
        rM_NAME = 0
        rM_RECEIVE_EMAIL = 1
        rM_AIM = 2
        rM_ICQ = 3
        rM_MSN = 4
        rM_YAHOO = 5
        rM_TITLE = 6
        rMEMBER_ID = 7
        rM_HOMEPAGE = 8
        rM_LEVEL = 9
        rM_POSTS = 10
        rM_COUNTRY = 11
        rM_Avatar = 12
        rREPLY_ID = 13
        rFORUM_ID = 14
        rR_AUTHOR = 15
        rTOPIC_ID = 16
        rR_MESSAGE = 17
        rR_LAST_EDIT = 18
        rR_LAST_EDITBY = 19
        rR_SIG = 20
        rR_STATUS = 21
        rR_DATE = 22
        if CanShowSignature = 1 then
            rM_SIG = 23
        end if
       
        for iForum = 0 to iReplyCount

            Reply_MemberName = arrReplyData(rM_NAME, iForum)
            Reply_MemberReceiveEmail = arrReplyData(rM_RECEIVE_EMAIL, iForum)
            Reply_MemberAIM = arrReplyData(rM_AIM, iForum)
            Reply_MemberICQ = arrReplyData(rM_ICQ, iForum)
            Reply_MemberMSN = arrReplyData(rM_MSN, iForum)
            Reply_MemberYAHOO = arrReplyData(rM_YAHOO, iForum)
            Reply_MemberTitle = arrReplyData(rM_TITLE, iForum)
            Reply_MemberID = arrReplyData(rMEMBER_ID, iForum)
            Reply_MemberHomepage = arrReplyData(rM_HOMEPAGE, iForum)
            Reply_MemberLevel = arrReplyData(rM_LEVEL, iForum)
            Reply_MemberPosts = arrReplyData(rM_POSTS, iForum)
            Reply_MemberCountry = arrReplyData(rM_COUNTRY, iForum)
            Reply_MemberAvatar = arrReplyData(rM_Avatar, iForum)
            Reply_ReplyID = arrReplyData(rREPLY_ID, iForum)
            Reply_ForumID = arrReplyData(rFORUM_ID, iForum)
            Reply_Author = arrReplyData(rR_AUTHOR, iForum)
            Reply_TopicID = arrReplyData(rTOPIC_ID, iForum)
            Reply_Content = arrReplyData(rR_MESSAGE, iForum)
            Reply_LastEdit = arrReplyData(rR_LAST_EDIT, iForum)
            Reply_LastEditBy = arrReplyData(rR_LAST_EDITBY, iForum)
            Reply_Sig = arrReplyData(rR_SIG, iForum)
            Reply_Status = arrReplyData(rR_STATUS, iForum)
            Reply_Date = arrReplyData(rR_DATE, iForum)
            if CanShowSignature = 1 then
                Reply_MemberSig = trim(arrReplyData(rM_SIG, iForum))
            end if

            if intI = 0 then
                CColor = strAltForumCellColor
            else
                CColor = strForumCellColor
            end if

            Response.Write    "              <tr>" & vbNewLine & _
                    "                <td bgcolor=""" & CColor & """ valign=""top"" width=""" & strTopicWidthLeft & """"
            if lcase(strTopicNoWrapLeft) = "1" then Response.Write(" nowrap")
            Response.Write    ">" & vbNewLine & _
                    "                <p><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """><b><span class=""spnMessageText"">" & profileLink(ChkString(Reply_MemberName,"display"),Reply_Author) & "</span></b></font><br />" & vbNewLine
            if strShowRank = 1 or strShowRank = 3 then
                Response.Write    "                <font color=""" & strForumFontColor & """ face=""" & strDefaultFontFace & """ size=""" & strFooterFontSize & """><small>" & ChkString(getMember_Level(Reply_MemberTitle, Reply_MemberLevel, Reply_MemberPosts),"display") & "</small></font><br />" & vbNewLine
            end if
            if strShowRank = 2 or strShowRank = 3 then
                Response.Write    "                " & getStar_Level(Reply_MemberLevel, Reply_MemberPosts) & "<br />" & vbNewLine
            end if

If rsReplies("M_AWARD_POST") = "1" Then %>
        <br><br><img src="<% =strAwardImageDir %>/award_<% =rsReplies("M_AWARD_IMAGE") %>.gif" border="0">
        <font color="<% =strForumFontColor %>" face="<% =strDefaultFontFace %>" size="<% =strFooterFontSize %>"><small><% =rsReplies("M_AWARD_TITLE") %></small></font>
        <br>
    <% Else
        'do nothing %>
    <% End If %>

<%            if Reply_MemberAvatar <> "noavatar.gif" then
'                    response.write"        <img src=""" & Reply_MemberAvatar & """ width=""" & intAvatarWidth & """ height=""" & intAvatarHeight & """ border=""" & intAvatarBorder & """><br /><br />"
'##### My Avatar addon 1-1 : replace above line with below 5 lines
                if (strMyAvatarLink + strMyAvatarTooltip) > 0 then
                    Response.Write    getMyAvatar(Reply_MemberAvatar,Reply_Author,Reply_MemberName,Reply_MemberHomepage) & "<br />" & vbNewLine
                else
                    Response.Write    "<img src=""" & Reply_MemberAvatar & """ width=""" & intAvatarWidth & """ height=""" & intAvatarHeight & """ border=""" & intAvatarBorder & """><br />"
                end if
'########## My Avatar addon ##########
            end if
            Response.Write    "                </p>" & vbNewLine & _
                    "                <p>" & vbNewLine
            if strCountry = "1" and trim(Reply_MemberCountry) <> "" then
                Response.Write    "                <font color=""" & strForumFontColor & """ face=""" & strDefaultFontFace & """ size=""" & strFooterFontSize & """><small>" & Reply_MemberCountry & "</small></font><br />" & vbNewLine
            end if
            Response.Write    "                <font color=""" & strForumFontColor & """ face=""" & strDefaultFontFace & """ size=""" & strFooterFontSize & """><small>" & Reply_MemberPosts & " Indlæg</small></font></p>" & vbNewLine
'#### Check if there is a photo album

            if Reply_MemberName <> "" then
                strSql = "SELECT MEMBER_ID"
                strSql = strSql & " FROM " & strMemberTablePrefix & "ALBUM_USERS "
                strSql = strSql & " WHERE M_Name = '" &Reply_MemberName& "'"

            set M_ID = my_Conn.Execute(strSql)
       
            if M_ID.BOF or M_ID.EOF then                   
                dont_display = 1
            end if
       
            if dont_display = 0 then

                photo_id = M_ID("MEMBER_ID")

                ref = "<a href=photo_album_cat.asp?sqldtl="
                ref = ref &    Server.URLEncode(photo_id)
                ref = ref &">"
                ref = ref & "<font color=""" & strForumFontColor & """ face=""" & strDefaultFontFace & """ size=""" & strFooterFontSize  & """>Billeder</font></a>"
                response.write ref
            end if
            end if
            dont_display = 0

'### END CHECK IF THERE IS PHOTO ALBUM
            Response.Write    "                </td><td bgcolor=""" & CColor & """ height=""100%"" width=""" & strTopicWidthRight & """"




            if lcase(strTopicNoWrapRight) = "1" then Response.Write(" nowrap")
            if (AdminAllowed = 1) and (maxpages > 1) then
                Response.Write    (" colspan=""3"" ")
            else
                Response.Write    (" colspan=""2"" ")
            end if
            Response.Write    "valign=""top""><a name=""" & Reply_ReplyID & """></a>" & vbNewLine & _
                    "                  <table width=""100%"" height=""100%"" border=""0"" cellspacing=""0"" cellpadding=""0"">" & vbNewLine & _
                    "                    <tr>" & vbNewLine & _
                    "                      <td valign=""top"">" & vbNewLine
            ' DEM --> Start of Code altered for moderation
            if Reply_Status < 2 then
                Response.Write  "                      " & getCurrentIcon(strIconPosticon,"","hspace=""3""") & "<font color=""" & strForumFontColor & """ face=""" & strDefaultFontFace & """ size=""" & strFooterFontSize  & """>Skrevet&nbsp;-&nbsp;" & ChkDate(Reply_Date, "&nbsp;:&nbsp;" ,true) & "</font>" & vbNewline
            elseif Reply_Status = 2 then
                Response.Write  "                      <font color=""" & strForumFontColor & """ face=""" & strDefaultFontFace & """ size=""" & strFooterFontSize  & """>NOT MODERATED!!!</font>" & vbNewline
            elseif Reply_Status = 3 then
                Response.Write  "                      " & getCurrentIcon(strIconPosticonHold,"","hspace=""3""") & "<font color=""" & strForumFontColor & """ face=""" & strDefaultFontFace & """ size=""" & strFooterFontSize  & """>ON HOLD</font>" & vbNewline
            end if
            ' DEM --> End of Code added for moderation.
            Response.Write    "                      &nbsp;" & profileLink(getCurrentIcon(strIconProfile,"Vis profil","align=""absmiddle"" hspace=""6"""),Reply_MemberID) & vbNewLine
            if mLev > 2 or Reply_MemberReceiveEmail = "1" then
                if (mlev <> 0) or (mlev = 0 and  strLogonForMail <> "1") then
                    Response.Write    "                      &nbsp;<a href=""java script:openWindow('pop_mail.asp?id=" & Reply_MemberID & "')"">" & getCurrentIcon(strIconEmail,"Send email","align=""absmiddle"" hspace=""6""") & "</a>" & vbNewLine
                end if
            end if
            if strHomepage = "1" then
                if Reply_MemberHomepage <> " " then
                    Response.Write    "                      &nbsp;<a href=""" & Reply_MemberHomepage & """ target=""_blank"">" & getCurrentIcon(strIconHomepage,"Åben " & ChkString(Reply_MemberName,"display") & "'s Hjemmeside","align=""absmiddle"" hspace=""6""") & "</a>" & vbNewLine
                end if
            end if
            if (AdminAllowed = 1 or Reply_MemberID = MemberID) then
                if (Cat_Status <> 0 and Forum_Status <> 0 and Topic_Status <> 0) or (AdminAllowed = 1) then
                    Response.Write    "                      &nbsp;<a href=""post.asp?" & ArchiveLink & "method=Edit&REPLY_ID=" & Reply_ReplyID & "&TOPIC_ID=" & Topic_ID & "&FORUM_ID=" & Forum_ID & """>" & getCurrentIcon(strIconEditTopic,"Ret svar","align=""absmiddle"" hspace=""6""") & "</a>" & vbNewLine
                end if
            end if

            if ((Cat_Status <> 0 and Forum_Status <> 0 and Topic_Status = 1) or (AdminAllowed = 1 and Topic_Status <= 1)) and ArchiveView = "" then
                Response.Write    "                      &nbsp;<a href=""post.asp?" & ArchiveLink & "method=ReplyQuote&REPLY_ID=" & Reply_ReplyID & "&TOPIC_ID=" & Topic_ID & "&FORUM_ID=" & Forum_ID & """>" & getCurrentIcon(strIconReplyTopicq,"Svar med citat","align=""absmiddle"" hspace=""6""") & "</a>" & vbNewLine
            end if
            if (strIPLogging = "1") then
                if (AdminAllowed = 1) then
                    Response.Write    "                      &nbsp;<a href=""java script:openWindow('pop_viewip.asp?" & ArchiveLink & "mode=getIP&REPLY_ID=" & Reply_ReplyID & "&FORUM_ID=" & Forum_ID & "')"">" & getCurrentIcon(strIconIP,"Se brugers IP adresse","align=""absmiddle"" hspace=""6""") & "</a>" & vbNewLine
                end if
            end if
            if (AdminAllowed = 1 or Reply_MemberID = MemberID) then
                if (Cat_Status <> 0 and Forum_Status <> 0 and Topic_Status <> 0) or (AdminAllowed = 1) then
                    Response.Write    "                      &nbsp;<a href=""java script:openWindow('pop_delete.asp?" & ArchiveLink & "mode=Reply&REPLY_ID=" & Reply_ReplyID & "&TOPIC_ID=" & Topic_ID & "&FORUM_ID=" & Forum_ID & "')"">" & getCurrentIcon(strIconDeleteReply,"Delete Reply","align=""absmiddle"" hspace=""6""") & "</a>" & vbNewLine
                end if
                        ' DEM --> Start of Code added for Full Moderation
                if (AdminAllowed = 1 and Reply_Status > 1) then
                    ReplyString = "REPLY_ID=" & Reply_ReplyID & "&CAT_ID=" & Cat_ID & "&FORUM_ID=" & Forum_ID & "&TOPIC_ID=" & Topic_ID
                    Response.Write "                      &nbsp;<a href=""java script:openWindow('pop_moderate.asp?" & ReplyString & "')"">" & getCurrentIcon(strIconFolderModerate,"Approve/Hold/Reject this Reply","align=""absmiddle"" hspace=""6""") & "</a>" & vbNewline
                end if
                ' DEM --> End of Code added for Full Moderation
            end if
            Response.Write    "                      <hr noshade size=""" & strFooterFontSize & """></td>" & vbNewLine & _
                    "                    </tr>" & vbNewLine & _
                    "                    <tr>" & vbNewLine & _
                    "                      <td valign=""top"" height=""100%""><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """ color=""" & strForumFontColor & """><span class=""spnMessageText"" id=""msg"">"
            if Request.QueryString("SearchTerms") <> "" then
                Response.Write    SearchHiLite(formatStr(Reply_Content))
            else
                Response.Write    formatStr(Reply_Content)
            end if
            Response.Write    "</span id=""msg""></font></td>" & vbNewLine & _
                    "                    </tr>" & vbNewLine
            if CanShowSignature = 1 and Reply_Sig = 1 and Reply_MemberSig <> "" then
                Response.Write    "                    <tr>" & vbNewLine & _
                        "                      <td valign=""bottom""><hr noshade size=""" & strFooterFontSize & """><font color=""" & strForumFontColor & """ face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """><span class=""spnMessageText"">" & formatStr(Reply_MemberSig) & "</span></font></td>" & vbNewLine & _
                        "                    </tr>" & vbNewLine
            end if
            if strEditedByDate = "1" and Reply_LastEditBy <> "" then
                if Reply_LastEditBy <> Reply_Author then
                    Reply_LastEditByName = getMemberName(Reply_LastEditBy)
                else
                    Reply_LastEditByName = chkString(Reply_MemberName,"display")
                end if
                Response.Write    "                    <tr>" & vbNewLine & _
                        "                      <td valign=""bottom""><hr noshade size=""" & strFooterFontSize & """ color=""" & CColor & """><font face=""" & strDefaultFontFace & """ size=""" & strFooterFontSize & """ color=""" & strForumFontColor & """>" & _
                        "Edited by - " & Reply_LastEditByName & " on " & chkDate(Reply_LastEdit, " " ,true) & "</font></td>" & vbNewLine & _
                        "                    </tr>" & vbNewLine
            end if
            Response.Write    "                    <tr>" & vbNewLine & _
                    "                      <td valign=""bottom"" align=""right"" height=""20""><a href=""#top"">" & getCurrentIcon(strIconGoUp,"Til toppen af siden","align=""right""") & "</a></td>" & vbNewLine & _
                    "                    </tr>" & vbNewLine & _
                    "                  </table>" & vbNewLine & _
                    "                </td>" & vbNewLine & _
                    "              </tr>" & vbNewLine
            intI  = intI + 1
            if intI = 2 then
                intI = 0
            end if
        next
    end if

If conquerChatUsers.Count > 0 Then

    Response.Write "      " & VBNewLine & _
                "<font face=""" & strDefaultFontFace & """ size=""" & strFooterFontSize & """ color=""" & strForumFontColor & """>" & _
              "          <span class=""spnMessageText"" >" & VBNewLine & _
              "            Følgende er på chatten: "
        Dim user
        strActiveMemberList = ""
    For Each userId In conquerChatUsers
        Set user = getUser(userId)
        strActiveMemberList = strActiveMemberList & user.name & ", "
    Next
    'strip off trailing comma and space
    strActiveMemberList = left(strActiveMemberList, Len(strActiveMemberList)-2)
    Response.Write "            " & strActiveMemberList & "</span></font>"
   
    End If    'conquerChatUsers.count

    Response.Write    "              <tr>" & vbNewLine
    if maxpages > 1 then
        Call DropDownPaging(2)
    else
        Response.Write    "                <td align=""center"" bgcolor=""" & strHeadCellColor & """ width=""" & strTopicWidthLeft & """"
        if lcase(strTopicNoWrapLeft) = "1" then Response.Write(" nowrap")
        Response.Write    "><b><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """ color=""" & strHeadFontColor & """>&nbsp;</font></b></td>" & vbNewLine
    end if
    Response.Write    "                <td align=""center"" bgcolor=""" & strHeadCellColor & """ width=""" & strTopicWidthRight & """"
    if lcase(strTopicNoWrapRight) = "1" then Response.Write(" nowrap")
    'if maxpages > 1 and (AdminAllowed = 1) then Response.Write(" colspan=""2""")
    Response.Write    "><b><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """ color=""" & strHeadFontColor & """>" & vbNewLine
    if strShowTopicNav = "1" then
        Call Topic_nav()
    else
        Response.Write("Indlæg")
    end if
    Response.Write    "</font></b></td>" & vbNewLine
    if (AdminAllowed = 1) then
        if maxpages > 1 then
                Response.Write    "                <td align=""right"" bgcolor=""" & strHeadCellColor & """ nowrap><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """>&nbsp;</font></td>" & vbNewLine
        end if
        Response.Write    "                <td align=""right"" bgcolor=""" & strHeadCellColor & """ nowrap>" & vbNewLine
        call AdminOptions()
        Response.Write    "</td>" & vbNewLine
    else
            Response.Write    "                <td align=""right"" bgcolor=""" & strHeadCellColor & """ nowrap><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """>&nbsp;</font></td>" & vbNewLine
    end if
    Response.Write    "              </tr>" & vbNewLine & _
            "            </table>" & vbNewLine & _
            "          </td>" & vbNewLine & _
            "        </tr>" & vbNewLine & _
            "      </table>" & vbNewLine & _
            "    </td>" & vbNewLine & _
            "  </tr>" & vbNewLine & _
            "</table>" & vbNewLine
    if maxpages > 1 then
        Response.Write    "<table align=""center"" border=""0"" cellPadding=""0"" cellSpacing=""1"" width=""95%"">" & vbNewLine & _
                "  <tr>" & vbNewLine & _
                "    <td align=""left"" valign=""top""><font face=""" & strDefaultFontFace & """ size=""" & strFooterFontSize & """>"
        if mypage > 1 then Response.Write("<a href=""topic.asp?" & ArchiveLink & "TOPIC_ID=" & Topic_ID & "&whichpage=" & mypage-1 & SearchLink & """ title=""Gå til forrige side i dette emne""" & dWStatus("Goto the Previous page in this Topic") & ">Forrige side</a>")
        'if mypage > 1 then Response.Write("<a href=""java script: onclick=document.PageNum1.whichpage.value=" & mypage-1 & ";document.PageNum1.submit();"" title=""Gå til forrige side i dette emne""" & dWStatus("Gå til forrige side i dette emne") & ">Forrige side</a>")
        if mypage > 1 and mypage < maxpages then Response.Write(" | ")
        if mypage < maxpages then Response.Write("<a href=""topic.asp?" & ArchiveLink & "TOPIC_ID=" & Topic_ID & "&whichpage=" & mypage+1 & SearchLink & """ title=""Gå til næste side i dette indlæg""" & dWStatus("Gå til næste side i dette indlæg") & ">Næste side</a>")
        'if mypage < maxpages then Response.Write("<a href=""java script: onclick=document.PageNum1.whichpage.value=" & mypage+1 & ";document.PageNum1.submit();"" title=""Gå til næste side i dette indlæg""" & dWStatus("Gå til næste side i dette indlæg") & ">Næste side</a>")
        Response.Write    "</td>" & vbNewLine & _
            "  </tr>" & vbNewLine & _
            "</table>" & vbNewLine
    end if
    Response.Write    "<table align=""center"" border=""0"" cellPadding=""0"" cellSpacing=""0"" width=""95%"">" & vbNewLine & _
            "  <tr>" & vbNewLine & _
            "    <td>" & vbNewLine & _
            "      <table width=""100%"">" & vbNewLine & _
            "        <tr>" & vbNewLine & _
            "          <td align=""center"" valign=""top"" width=""50%"">" & vbNewLine
    Call PostingOptions()
    Response.Write    "</td>" & vbNewLine & _
            "          <td align=""right"" valign=""top"" width=""50%"" nowrap>" & vbNewLine
%>
    <!--#INCLUDE FILE="inc_jump_to.asp" -->
<%
    Response.Write    "          </td>" & vbNewLine & _
            "        </tr>" & vbNewLine & _
            "      </table>" & vbNewLine

    if strShowQuickReply = "1" and strDBNTUserName <> "" and ((Cat_Status = 1) and (Forum_Status = 1) and (Topic_Status = 1)) and ArchiveView = "" then
        call QuickReply()
    end if

        WriteFooter
end if

sub GetFirst()
    CColor = strForumFirstCellColor
    Response.Write    "              <tr>" & vbNewLine & _
            "                <td bgcolor=""" & strForumFirstCellColor & """ valign=""top"" width=""" & strTopicWidthLeft & """"
    if lcase(strTopicNoWrapLeft) = "1" then Response.Write(" nowrap")
    Response.Write    ">" & vbNewLine & _
            "                <p><font color=""" & strForumFontColor & """ face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """><b><span class=""spnMessageText"">" & profileLink(ChkString(Member_Name,"display"),TMember_ID) & "</span></b></font><br />" & vbNewLine
    if strShowRank = 1 or strShowRank = 3 then
        Response.Write    "                <font color=""" & strForumFontColor & """ face=""" & strDefaultFontFace & """ size=""" & strFooterFontSize & """><small>" & ChkString(getMember_Level(Member_Title, Member_Level, Member_Posts),"display") & "</small></font><br />" & vbNewLine
    end if
    if strShowRank = 2 or strShowRank = 3 then
        Response.Write    "                " & getStar_Level(Member_Level, Member_Posts) & "<br />" & vbNewLine
    end if


If rsReplies("M_AWARD_POST") = "1" Then %>
        <br><br><img src="<% =strAwardImageDir %>/award_<% =rsReplies("M_AWARD_IMAGE") %>.gif" border="0">
        <font color="<% =strForumFontColor %>" face="<% =strDefaultFontFace %>" size="<% =strFooterFontSize %>"><small><% =rsReplies("M_AWARD_TITLE") %></small></font>
        <br>
    <% Else
        'do nothing %>
    <% End If %>



        if Member_Avatar <> "noavatar.gif" then
'                    response.write"        <img src=""" & Member_Avatar & """ width=""" & intAvatarWidth & """ height=""" & intAvatarHeight & """ border=""" & intAvatarBorder & """><br /><br />"
'##### My Avatar addon 1-2 : replace above line with below 5 lines
            if (strMyAvatarLink + strMyAvatarTooltip) > 0 then
                Response.Write    getMyAvatar(Member_Avatar,TMember_ID,Member_Name,Member_Homepage) & "<br />" & vbNewLine
            else
                Response.Write    "<img src=""" & Member_Avatar & """ width=""" & intAvatarWidth & """ height=""" & intAvatarHeight & """ border=""" & intAvatarBorder & """><br />"
            end if
'########## My Avatar addon ##########
        end if
    Response.Write    "                </p>" & vbNewLine & _
            "                <p>" & vbNewLine
    if strCountry = "1" and trim(Member_Country) <> "" then
        Response.Write    "                <font color=""" & strForumFontColor & """ face=""" & strDefaultFontFace & """ size=""" & strFooterFontSize & """><small>" & Member_Country & "</small></font><br />" & vbNewLine
    end if
    Response.Write    "                <font color=""" & strForumFontColor & """ face=""" & strDefaultFontFace & """ size=""" & strFooterFontSize & """><small>" & Member_Posts & " Indlæg</small></font></p>" & vbNewLine

'#### Check if there is a photo album

            if Member_Name <> "" then
                strSql = "SELECT MEMBER_ID"
                strSql = strSql & " FROM " & strMemberTablePrefix & "ALBUM_USERS "
                strSql = strSql & " WHERE M_Name = '" &Member_Name& "'"

            set M_ID = my_Conn.Execute(strSql)
       
            if M_ID.BOF or M_ID.EOF then                   
                dont_display = 1
            end if
       
            if dont_display = 0 then

                photo_id = M_ID("MEMBER_ID")

                ref = "<a href=photo_album_cat.asp?sqldtl="
                ref = ref &    Server.URLEncode(photo_id)
                ref = ref &">"
                ref = ref & "<font color=""" & strForumFontColor & """ face=""" & strDefaultFontFace & """ size=""" & strFooterFontSize  & """>Billeder" & ChkDate(Reply_Date, "&nbsp;:&nbsp;" ,true) & "</font></a>"
                response.write ref
            end if
            end if
            dont_display = 0

'### END CHECK IF THERE IS PHOTO ALBUM
    Response.Write    "                </td><td bgcolor=""" & strForumFirstCellColor & """ width=""" & strTopicWidthRight & """"

    if lcase(strTopicNoWrapRight) = "1" then Response.Write(" nowrap")
    if (AdminAllowed = 1) and (maxpages > 1) then
        Response.Write    (" colspan=""3"" ")
    else
        Response.Write    (" colspan=""2"" ")
    end if
    Response.Write    "valign=""top"">" & vbNewLine & _
            "                  <table width=""100%"" height=""100%"" border=""0"" cellspacing=""0"" cellpadding=""0"">" & vbNewLine & _
            "                    <tr>" & vbNewLine & _
            "                      <td valign=""top"">" & vbNewLine
    if Topic_Status < 2 then
        Response.Write  "                      " & getCurrentIcon(strIconPosticon,"","hspace=""3""") & "<font color=""" & strForumFontColor & """ face=""" & strDefaultFontFace & """ size=""" & strFooterFontSize & """>Skrevet&nbsp;-&nbsp;" & ChkDate(Topic_Date, "&nbsp;:&nbsp;" ,true) & "</font>" & vbNewline
    elseif Topic_Status = 2 then
        Response.Write  "                      <font color=""" & strForumFontColor & """ face=""" & strDefaultFontFace & """ size=""" & strFooterFontSize  & """>NOT MODERATED!!!</font>" & vbNewline
    elseif Topic_Status = 3 then
        Response.Write  "                      " & getCurrentIcon(strIconPosticonHold,"","hspace=""3""") & "<font color=""" & strForumFontColor & """ face=""" & strDefaultFontFace & """ size=""" & strFooterFontSize & """>ON HOLD</font>" & vbNewline
    end if
    Response.Write    "                      &nbsp;" & profileLink(getCurrentIcon(strIconProfile,"Vis profil","align=""absmiddle"" hspace=""6"""),TMember_ID) & vbNewLine
    if mLev > 2 or Member_ReceiveMail = "1" then
        if (mlev <> 0) or (mlev = 0 and  strLogonForMail <> "1") then
            Response.Write    "                      &nbsp;<a href=""java script:openWindow('pop_mail.asp?id=" & TMember_ID & "')"">" & getCurrentIcon(strIconEmail,"Send email","align=""absmiddle"" hspace=""6""") & "</a>" & vbNewLine
        end if
    end if
    if (strHomepage = "1") then
        if Member_Homepage <> " " then
            Response.Write    "                      &nbsp;<a href=""" & Member_Homepage & """ target=""_blank"">" & getCurrentIcon(strIconHomepage,"Åben " & ChkString(Member_Name,"display") & "'s Hjemmeside","align=""absmiddle"" hspace=""6""") & "</a>" & vbNewLine
        end if
    end if
    if (AdminAllowed = 1 or TMember_ID = MemberID) then
        if ((Cat_Status <> 0) and (Forum_Status <> 0) and (Topic_Status <> 0)) or (AdminAllowed = 1) then
            Response.Write    "                      &nbsp;<a href=""post.asp?" & ArchiveLink & "method=EditTopic&REPLY_ID=" & Topic_ID & "&TOPIC_ID=" & Topic_ID & "&FORUM_ID=" & Forum_ID & """>" & getCurrentIcon(strIconEditTopic,"Ret indlæg","align=""absmiddle"" hspace=""6""") & "</a>" & vbNewLine
        end if
    end if
    if ((Cat_Status <> 0 and Forum_Status <> 0 and Topic_Status = 1) or (AdminAllowed = 1 and Topic_Status <= 1) and ArchiveView = "" ) then
        Response.Write    "                      &nbsp;<a href=""post.asp?" & ArchiveLink & "method=TopicQuote&TOPIC_ID=" & Topic_ID & "&FORUM_ID=" & Forum_ID & """>" & getCurrentIcon(strIconReplyTopicq,"Svar med citat","align=""absmiddle"" hspace=""6""") & "</a>" & vbNewLine
    end if
    if (strIPLogging = "1") then
        if (AdminAllowed = 1) then
            Response.Write    "                      &nbsp;<a href=""java script:openWindow('pop_viewip.asp?" & ArchiveLink & "mode=getIP&TOPIC_ID=" & TopicID & "&FORUM_ID=" & Forum_ID & "')"">" & getCurrentIcon(strIconIP,"Se brugers IP adresse","align=""absmiddle"" hspace=""6""") & "</a>" & vbNewLine
        end if
    end if
    if (AdminAllowed = 1) or (TMember_ID = MemberID and Topic_Replies < 1) then
        Response.Write    "                      &nbsp;<a href=""java script:openWindow('pop_delete.asp?" & ArchiveLink & "mode=Topic&TOPIC_ID=" & Topic_ID & "&FORUM_ID=" & Forum_ID & "&CAT_ID=" & Cat_ID & "')"">" & getCurrentIcon(strIconDeleteReply,"Slet indlæg","align=""absmiddle"" hspace=""6""") & "</a>" & vbNewLine
    end if
    ' DEM --> Start of Code added for Full Moderation
    if (AdminAllowed = 1 and Topic_Status > 1) then
        TopicString = "TOPIC_ID=" & Topic_ID & "&FORUM_ID=" & Forum_ID & "&CAT_ID=" & Cat_ID
        Response.Write  "                      &nbsp;<a href=""java script:openWindow('pop_moderate.asp?" & TopicString & "')"">" & getCurrentIcon(strIconFolderModerate,"Approve/Hold/Reject this Topic","align=""absmiddle"" hspace=""6""") & "</a>" & vbNewline
    End if
    ' End of Code added for Full Moderation
    Response.Write    "                      <hr noshade size=""" & strFooterFontSize & """></td>" & vbNewLine & _
            "                    </tr>" & vbNewLine & _
            "                    <tr>" & vbNewLine & _
            "                      <td valign=""top"" height=""100%""><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """ color=""" & strForumFontColor & """><span class=""spnMessageText"" id=""msg"">"
    If IsEvent = "1" Then
        <!-- #include file="cal_topic.asp" --> <%
end sub

    if Request.QueryString("SearchTerms") <> "" then
        Response.Write    SearchHiLite(formatStr(Topic_Message))
    else
        Response.Write    formatStr(Topic_Message)
    end if
    Response.Write    "</span id=""msg""></font></td>" & vbNewLine & _
            "                    </tr>" & vbNewLine
    if CanShowSignature = 1 and Topic_Sig = 1 and Topic_MemberSig <> "" then
        Response.Write    "                    <tr>" & vbNewLine & _
                "                      <td valign=""bottom""><hr noshade size=""" & strFooterFontSize & """><font color=""" & strForumFontColor & """ face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """><span class=""spnMessageText"">" & formatStr(Topic_MemberSig) & "</span></font></td>" & vbNewLine & _
                "                    </tr>" & vbNewLine
    end if
    if strEditedByDate = "1" and Topic_LastEditBy <> "" then
        if Topic_LastEditBy <> Topic_Author then
            Topic_LastEditByName = getMemberName(Topic_LastEditBy)
        else
            Topic_LastEditByName = chkString(Member_Name,"display")
        end if
        Response.Write    "                    <tr>" & vbNewLine & _
                "                      <td valign=""bottom""><hr noshade size=""" & strFooterFontSize & """ color=""" & strForumFirstCellColor & """><font face=""" & strDefaultFontFace & """ size=""" & strFooterFontSize & """ color=""" & strForumFontColor & """>" &_
                "Edited by - " & Topic_LastEditByName & " on " & chkDate(Topic_LastEdit, " ", true) & "</font>" & vbNewLine & _
                "                    </tr>" & vbNewLine
    end if
    Response.Write    "                  </table>" & vbNewLine & _
            "                </td>" & vbNewLine & _
            "              </tr>" & vbNewLine

sub PostingOptions()
    Response.Write    "          <font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """>" & vbNewLine
    if (mlev = 4 or mlev = 3 or mlev = 2 or mlev = 1) or (lcase(strNoCookies) = "1") or (strDBNTUserName = "") then
        if ((Cat_Status = 1) and (Forum_Status = 1)) then
            Response.Write    AddEventLink(Forum_ID) & "          <a href=""post.asp?" & ArchiveLink & "method=Topic&FORUM_ID=" & Forum_ID & """>" & getCurrentIcon(strIconFolderNewTopic,"","align=""absmiddle""") & "</a>&nbsp;<a href=""post.asp?" & ArchiveLink & "method=Topic&FORUM_ID=" & Forum_ID & """>Nyt indlæg</a>" & vbNewLine
        else
            if (AdminAllowed = 1) then
                Response.Write    AddEventLink(Forum_ID) & "          <a href=""post.asp?" & ArchiveLink & "method=Topic&FORUM_ID=" & Forum_ID & """>" & getCurrentIcon(strIconFolderLocked,"","align=""absmiddle""") & "</a>&nbsp;<a href=""post.asp?" & ArchiveLink & "method=Topic&FORUM_ID=" & Forum_ID & """>Nyt indlæg</a>" & vbNewLine
            else
                Response.Write    "          " & getCurrentIcon(strIconFolderLocked,"","align=""absmiddle""") & "&nbsp;Forum Locked" & vbNewLine
            end if
        end if
        if ((Cat_Status = 1) and (Forum_Status = 1) and (Topic_Status = 1)) and ArchiveView = "" then
            Response.Write    "          <a href=""post.asp?" & ArchiveLink & "method=Reply&TOPIC_ID=" & Topic_ID & "&FORUM_ID=" & Forum_ID & """>" & getCurrentIcon(strIconReplyTopic,"","align=""absmiddle""") & "</a>&nbsp;<a href=""post.asp?" & ArchiveLink & "method=Reply&TOPIC_ID=" & Topic_ID & "&FORUM_ID=" & Forum_ID & """>Svar på indlæg</a>" & vbNewLine
        else
            if ((AdminAllowed = 1 and Topic_Status <= 1) and ArchiveView = "")  then
                Response.Write    "          <a href=""post.asp?" & ArchiveLink & "method=Reply&TOPIC_ID=" & Topic_ID & "&FORUM_ID=" & Forum_ID & """>"
                ' DEM --> Added if statement to show normal icon for unmoderated posts.
                if Topic_Status = 1 and Cat_Status <> 0 and Forum_Status <> 0 then
                    Response.Write    getCurrentIcon(strIconReplyTopic,"","align=""absmiddle""") & "</a>&nbsp;"
                else
                    Response.Write    getCurrentIcon(strIconClosedTopic,"","align=""absmiddle""") & "</a>&nbsp;"
                end if
                Response.Write    "<a href=""post.asp?" & ArchiveLink & "method=Reply&TOPIC_ID=" & Topic_ID & "&FORUM_ID=" & Forum_ID & """>Svar på indlæg</a>" & vbNewLine
            else
                if Topic_Status = 0 then
                    Response.Write    getCurrentIcon(strIconClosedTopic,"","align=""absmiddle""") & "&nbsp;Topic Locked" & vbNewline
                end if
            end if
        end if
        if lcase(strEmail) = "1" and Topic_Status < 2 then
            if Cat_Status <> 0 and Forum_Status <> 0 and Topic_Status <> 0 and mLev > 0 then
                if strSubscription > 0 and Cat_Subscription > 0 and Forum_Subscription > 0 then
                    if InArray(strTopicSubs, Topic_ID) then
                        Response.Write "          <br />" & ShowSubLink ("U", Cat_ID, Forum_ID, Topic_ID, "Y") & vbNewLine
                    elseif strBoardSubs <> "Y" and not(InArray(strForumSubs,Forum_ID) or InArray(strCatSubs,Cat_ID)) then
                        Response.Write "          <br />" & ShowSubLink ("S", Cat_ID, Forum_ID, Topic_ID, "Y") & vbNewLine
                    end if
                end if
            end if
            if ((mlev <> 0) or (mlev = 0 and strLogonForMail <> "1")) and lcase(strShowSendToFriend) = "1" then
                Response.Write    "          <br /><a href=""java script:openWindow('pop_send_to_friend.asp?url=" & strForumURL & "topic.asp?TOPIC_ID=" & Topic_ID & "')"">" & getCurrentIcon(strIconSendTopic,"","align=""absmiddle""") & "</a>&nbsp;<a href=""java script:openWindow('pop_send_to_friend.asp?url=" & strForumURL & "topic.asp?TOPIC_ID=" & Topic_ID & "')"">Send indlæg til en ven</a>" & vbNewLine
            end if
        end if
        if lcase(strShowPrinterFriendly) = "1" and Topic_Status < 2 then
            Response.Write    "          <br /><a href=""java script:openWindow5('pop_printer_friendly.asp?" & ArchiveLink & "TOPIC_ID=" & Topic_ID & "')"">" & getCurrentIcon(strIconPrint,"","align=""absmiddle""") & "</a>&nbsp;<a href=""java script:openWindow5('pop_printer_friendly.asp?" & ArchiveLink & "TOPIC_ID=" & Topic_ID & "')"">Printer venlig</a>" & vbNewLine
        end if
    end if
    Response.Write    "          </font>"
end sub

Function AddEventLink(F_ID)
    For each iForum in arrCalForumID
        If cLng(iForum) = cLng(F_ID) then
            blnCalAllowed = TRUE
            Exit For
        End If
    Next
    if mlev < intCalMLev or not blnCalAllowed then Exit Function
    AddEventLink = "<a href=""post.asp?method=Topic&event=1&FORUM_ID=" & F_ID & """>" & getCurrentIcon(strCalIconEvent,strCalNewEvent,"align=""absmiddle""") & "</a>&nbsp;<a href=""post.asp?method=Topic&event=1&FORUM_ID=" & F_ID& """>" & strCalNewEvent & "</a>&nbsp;" & vbNewLine
End Function


sub AdminOptions()
    Response.Write    "                <font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """>" & vbNewLine
    if (AdminAllowed = 1) or (lcase(strNoCookies) = "1") then
        if (Cat_Status = 0) then
            if (mlev = 4) then
                Response.Write    "                <a href=""java script:openWindow('pop_open.asp?mode=Category&CAT_ID=" & Cat_ID & "')"">" & getCurrentIcon(strIconFolderUnlocked,"Åben katagori","") & "</a>" & vbNewLine
            else
                Response.Write    "                " & getCurrentIcon(strIconFolderUnlocked,"Category Locked","") & vbNewLine
            end if
        else
            if (Forum_Status = 0) then
                Response.Write    "                <a href=""java script:openWindow('pop_open.asp?mode=Forum&FORUM_ID=" & Forum_ID & "&CAT_ID=" & Cat_ID & "')"">" & getCurrentIcon(strIconFolderUnlocked,"Åben fora","") & "</a>" & vbNewLine
            else
                if (Topic_Status <> 0) then
                    Response.Write    "                <a href=""java script:openWindow('pop_lock.asp?mode=Topic&TOPIC_ID=" & Topic_ID & "&FORUM_ID=" & Forum_ID & "&CAT_ID=" & Cat_ID & "')"">" & getCurrentIcon(strIconFolderLocked,"Lås fora","") & "</a>" & vbNewLine
                else
                    Response.Write    "                <a href=""java script:openWindow('pop_open.asp?mode=Topic&TOPIC_ID=" & Topic_ID & "&FORUM_ID=" & Forum_ID & "&CAT_ID=" & Cat_ID & "')"">" & getCurrentIcon(strIconFolderUnlocked,"Åben fora","") & "</a>" & vbNewLine
                end if
            end if
        end if
        if ((Cat_Status <> 0) and (Forum_Status <> 0) and (Topic_Status <> 0)) or (AdminAllowed = 1) then
            Response.Write    "                <a href=""post.asp?" & ArchiveLink & "method=EditTopic&REPLY_ID=" & Topic_ID & "&TOPIC_ID=" & Topic_ID & "&FORUM_ID=" & Forum_ID & """>" & getCurrentIcon(strIconFolderPencil,"Ret indlæg","hspace=""0""") & "</a>" & vbNewLine
        end if
        Response.Write    "                <a href=""java script:openWindow('pop_delete.asp?" & ArchiveLink & "mode=Topic&TOPIC_ID=" & Topic_ID & "&FORUM_ID=" & Forum_ID & "&CAT_ID=" & Cat_ID & "')"">" & getCurrentIcon(strIconFolderDelete,"Slet indlæg","") & "</a>" & vbNewLine & _
                "                <a href=""post.asp?" & ArchiveLink & "method=Topic&FORUM_ID=" & Forum_ID & """>" & getCurrentIcon(strIconFolderNewTopic,"Nyt indlæg","") & "</a>" & vbNewLine
        if Topic_Status <= 1 and ArchiveView = "" then
            Response.Write    "                <a href=""post.asp?" & ArchiveLink & "method=Reply&TOPIC_ID=" & Topic_ID & "&FORUM_ID=" & Forum_ID & """>" & getCurrentIcon(strIconReplyTopic,"Svar på indlæg","") & "</a>" & vbNewLine
        end if
    end if
    ' DEM --> Start of Code added for Full Moderation
    if (AdminAllowed = 1 and CheckForUnModeratedPosts("Indlæg", Cat_ID, Forum_ID, Topic_ID) > 0) then
        TopicString = "TOPIC_ID=" & Topic_ID & "&FORUM_ID=" & Forum_ID & "&CAT_ID=" & Cat_ID & "&REPLY_ID=X"
        Response.Write "                <a href=""java script:openWindow('pop_moderate.asp?" & TopicString & "')"">" & getCurrentIcon(strIconFolderModerate,"Approve/Hold/Reject all posts for this Topic","") & "</a>" & vbNewline
    end if
    ' DEM --> End of Code added for Full Moderation
    Response.Write "                </font>"
end sub

sub DropDownPaging(fnum)
    if maxpages > 1 then
        if mypage = "" then
            pge = 1
        else
            pge = mypage
        end if
        scriptname = request.servervariables("script_name")
        Response.Write("                <form name=""PageNum" & fnum & """ action=""topic.asp"">" & vbNewLine)
        Response.Write("                <td bgcolor=""" & strHeadCellColor & """ nowrap><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """ color=""" & strHeadFontColor & """>" & vbNewLine)
        if Archiveview = "true" then Response.Write("                <input type=""hidden"" name=""ARCHIVE"" value=""" & ArchiveView & """>" & vbNewLine)
        Response.Write("                <input type=""hidden"" name=""TOPIC_ID"" value=""" & Request("TOPIC_ID") & """>" & vbNewLine)
        Response.Write("                <b>Page: </b><select name=""whichpage"" size=""1"" onchange=""ChangePage(" & fnum & ");"">" & vbNewLine)
        for counter = 1 to maxpages
            if counter <> cLng(pge) then 
                Response.Write "                    <option value=""" & counter &  """>" & counter & "</option>" & vbNewLine
            else
                Response.Write "                    <option selected value=""" & counter &  """>" & counter & "</option>" & vbNewLine
            end if
        next
        Response.Write("                </select><b> of " & maxpages & "</b>" & vbNewLine)
        if Request.QueryString("SearchTerms") <> "" then Response.Write("                <input type=""hidden"" name=""SearchTerms"" value=""" & Request.QueryString("SearchTerms") & """>" & vbNewLine)
        Response.Write("                </font></td>" & vbNewLine)
        Response.Write("                </form>" & vbNewLine)
    end if
    top = "0"
end sub

Sub Topic_nav()   

    if prevTopic = "" then
        strSQL = "SELECT T_SUBJECT, TOPIC_ID "
        strSql = strSql & "FROM " & strActivePrefix & "TOPICS "
        strSql = strSql & "WHERE T_LAST_POST > '" & Topic_LastPost
        strSql = strSql & "' AND FORUM_ID = " & Forum_ID
        strSql = strSql & " AND T_STATUS < 2"  ' Ignore unapproved/held posts
        strSql = strSql & " ORDER BY T_LAST_POST;"

        set rsPrevTopic = my_conn.Execute(TopSQL(strSql,1))

        if rsPrevTopic.EOF then
            prevTopic = getCurrentIcon(strIconBlank,"","align=""top"" hspace=""6""")
        else
            prevTopic = "<a href=""topic.asp?" & ArchiveLink & "TOPIC_ID=" & rsPrevTopic("TOPIC_ID") & """>" & getCurrentIcon(strIconGoLeft,"Gå til orrige emne","align=""top"" hspace=""6""") & "</a>"
        end if

        rsPrevTopic.close
        set rsPrevTopic = nothing
    else
        prevTopic = prevTopic
    end if

    if NextTopic = "" then
        strSQL = "SELECT T_SUBJECT, TOPIC_ID "
        strSql = strSql & "FROM " & strActivePrefix & "TOPICS "
        strSql = strSql & "WHERE T_LAST_POST < '" & Topic_LastPost
        strSql = strSql & "' AND FORUM_ID = " & Forum_ID
        strSql = strSql & " AND T_STATUS < 2"  ' Ignore unapproved/held posts
        strSql = strSql & " ORDER BY T_LAST_POST DESC;"

        set rsNextTopic = my_conn.Execute(TopSQL(strSql,1))

        if rsNextTopic.EOF then
            nextTopic = getCurrentIcon(strIconBlank,"","align=""top"" hspace=""6""")
        else
            nextTopic = "<a href=""topic.asp?" & ArchiveLink & "TOPIC_ID=" & rsNextTopic("TOPIC_ID") & """>" & getCurrentIcon(strIconGoRight,"Gå til næste emne","align=""top"" hspace=""6""") & "</a>"
        end if

        rsNextTopic.close
        set rsNextTopic = nothing
    else
        nextTopic = nextTopic
    end if

    Response.Write ("                " & prevTopic & "<b><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """ color=""" & strHeadFontColor & """>&nbsp;Emne&nbsp;</font></b>" & nextTopic)

end sub

function SearchHiLite(fStrMessage)
    'function derived from HiLiTeR by 2eNetWorX
    fArr = split(replace(Request.QueryString("SearchTerms"),";",""), ",")
    strBuffer = ""
    for iPos = 1 to len(fStrMessage)
        bChange = False
        'Looks for html tags
        if mid(fStrMessage, iPos, 1) = "<" then
            bInHTML = True
        end if
        'Looks for End of html tags
        if bInHTML = True then
            if mid(fStrMessage, iPos, 1) = ">" then
                bInHTML = False
            end if
        end if
        if bInHTML <> True then 
            for i = 0 to UBound(fArr)
                if fArr(i) <> "" then
                    if lcase(mid(fStrMessage, iPos, len(fArr(i)))) = lcase(fArr(i)) then
                        bChange = True
                        strBuffer = strBuffer & "<span class=""spnSearchHighlight"" id=""hilite"">" & _
                        mid(fStrMessage, iPos, len(fArr(i))) & "</span id=""hilite"">"
                        iPos = iPos + len(fArr(i)) - 1
                    end if
                end if
            next
        end if
        if Not bChange then
            strBuffer = strBuffer & mid(fStrMessage, iPos, 1)
        end if
    next
    SearchHiLite = strBuffer
end function

Sub QuickReply()
    intSigDefault = getSigDefault(MemberID)
    Response.Write    "    <script language=""JavaScript"" type=""text/javascript"" src=""inc_code.js""></script>" & vbNewLine & _
            "      <table width=""100%"" border=""0"" cellspacing=""0"" cellpadding=""0"" align=""center"">" & vbNewLine & _
            "        <tr>" & vbNewLine & _
            "          <td bgcolor=""" & strPopUpBorderColor & """>" & vbNewLine & _
            "            <table width=""100%"" border=""0"" cellspacing=""1"" cellpadding=""1"">" & vbNewLine & _
            "              <form name=""PostTopic"" method=""post"" action=""post_info.asp"" onSubmit=""return validate();"">" & vbNewLine & _
            "              <input name=""ARCHIVE"" type=""hidden"" value=""" & ArchiveView & """>" & vbNewLine & _
            "              <input name=""Method_Type"" type=""hidden"" value=""Reply"">" & vbNewLine & _
            "              <input name=""TOPIC_ID"" type=""hidden"" value=""" & Topic_ID & """>" & vbNewLine & _
            "              <input name=""FORUM_ID"" type=""hidden"" value=""" & Forum_ID & """> " & vbNewLine & _
            "              <input name=""CAT_ID"" type=""hidden"" value=""" & Cat_ID & """>" & vbNewLine & _
            "              <input name=""Refer"" type=""hidden"" value=""" & request.servervariables("SCRIPT_NAME") & "?" & replace(Request.QueryString,"&#","#") & """>" & vbNewLine & _
            "              <input name=""UserName"" type=""hidden"" value=""" & strDBNTUserName & """>" & vbNewLine & _
            "              <input name=""Password"" type=""hidden"" value=""" & Request.Cookies(strUniqueID & "User")("Pword") & """>" & vbNewLine & _
            "              <tr>" & vbNewLine & _
            "                <td bgColor=""" & strHeadCellColor & """ noWrap vAlign=""top"" colspan=""2""><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """ color=""" & strHeadFontColor & """><b>Quick Reply</b></font></td>" & vbNewLine & _
            "              </tr>" & vbNewLine & _
            "              <tr>" & vbNewLine & _
            "                <td bgColor=""" & strForumCellColor & """ noWrap vAlign=""top"" align=""right""><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """ color=""" & strForumFontColor & """><span class=""spnMessageText""><b>Message:&nbsp;</b><br />" & vbNewLine & _
            "                <br />" & vbNewLine & _
            "                  <table border=""0"">" & vbNewLine & _
            "                    <tr>" & vbNewLine & _
            "                      <td align=""left"" nowrap><font face=""" & strDefaultFontFace & """ size=""" & strFooterFontSize & """ color=""" & strForumFontColor & """>" & vbNewLine
      '##### Super/Admin/Mod HTML Only Mod #####
    if strAllowHTML = "1" or chkSuperAdminModHtmlOk then
  '#########################################
        Response.Write    "                      * HTML is ON<br />" & vbNewLine
    else
        Response.Write    "                      * HTML is OFF<br />" & vbNewLine
    end if
    if strAllowForumCode = "1" then
        Response.Write    "                      * <a href=""java script:openWindow6('pop_forum_code.asp')"">Forum Code</a> is ON<br />" & vbNewLine
    else
        Response.Write    "                      * Forum Code is OFF<br />" & vbNewLine
    end if
    if strSignatures = "1" then
        Response.Write    "                      <br /><input name=""Sig"" type=""checkbox"" value=""yes""" & chkCheckbox(intSigDefault,1,true) & ">Include Signature<br />" & vbNewLine
    end if
    Response.Write    "                      </font></td>" & vbNewLine & _
            "                    </tr>" & vbNewLine & _
            "                  </table>" & vbNewLine & _
            "                </span></font></td>" & vbNewLine & _
            "                <td width=""" & strTopicWidthRight & """ bgColor=""" & strForumCellColor & """><textarea name=""Message"" cols=""50"" rows=""6"" wrap=""VIRTUAL"" style=""width:100%""></textarea><br /></td>" & vbNewLine & _
            "              </tr>" & vbNewLine & _
            "              <tr>" & vbNewLine & _
            "                <td bgColor=""" & strForumCellColor & """ noWrap align=""center"" colspan=""2""><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """ color=""" & strHeadFontColor & """><input name=""Submit"" type=""submit"
Avatar billede the_bma_man Nybegynder
16. marts 2004 - 07:10 #1
Det tyder på, at du har en karakterkonstant eller lignende, der ikke bliver afsluttet - eller du ganske enkelt har glemt en parameter et sted.
Prøv at lave en Response.Write strSQL lige inden dit kald til databasen - og check, at dit SQL-statement ser fornuftigt ud.
Avatar billede the_bma_man Nybegynder
16. marts 2004 - 07:10 #2
Post evt. outputtet her - så vi kan hjælpe dig.
Avatar billede duno Nybegynder
16. marts 2004 - 18:57 #3
Hvor er det du siger at jeg skal indsætte

Response.Write strSQL

er det lige inden linket til databasen (config.asp)
eller hvor??

Vil du ikke vise mig det??

jeg er lost !!

Takker
Avatar billede the_bma_man Nybegynder
16. marts 2004 - 19:24 #4
Det er lige inden linien
rsTopic.open strSql, my_Conn, adOpenForwardOnly, adLockReadOnly, adCmdText

- den du postede i dit oprindelige indlæg
Avatar billede duno Nybegynder
16. marts 2004 - 19:30 #5
SELECT M.M_NAME, M.M_RECEIVE_EMAIL, M.M_AIM, M.M_ICQ, M.M_MSN, M.M_YAHOO, M.M_TITLE, M.M_HOMEPAGE, M.MEMBER_ID, M.M_LEVEL, M.M_POSTS, M.M_COUNTRY, M.M_AWARD_PORTAL, M.M_AWARD_TITLE, M.M_AWARD_POST, M.M_AWARD_PROFILE, M.M_AWARD_IMAGE, M.M_AVATAR_URL, T.T_DATE, T.T_SUBJECT, T.T_AUTHOR, T.TOPIC_ID, T.T_STATUS, T.T_LAST_EDIT, T.T_LAST_EDITBY, T.T_LAST_POST, T.T_SIG, T.T_REPLIES, T.T_ISEVENT, C.CAT_STATUS, C.CAT_ID, C.CAT_NAME, C.CAT_SUBSCRIPTION, C.CAT_MODERATION, F.F_STATUS, F.FORUM_ID, F.F_SUBSCRIPTION, F.F_SUBJECT, F.F_MODERATION, T.T_MESSAGE, M.M_SIG FROM FORUM_TOPICS T, FORUM_FORUM F, FORUM_CATEGORY C, FORUM_MEMBERS M WHERE T.TOPIC_ID = 6820 AND F.FORUM_ID = T.FORUM_ID AND C.CAT_ID = T.CAT_ID AND M.MEMBER_ID = T.T_AUTHOR
Microsoft OLE DB Provider for ODBC Drivers error '80040e10'

[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 5.

/forum3/topic2a.asp, line 118
Avatar billede the_bma_man Nybegynder
16. marts 2004 - 19:44 #6
Hmm, den sql ser nu godt nok ud, synes jeg.
Hvilken datatype er T.TOPIC_ID? Hvis det er en streng, skal du lige have ' omkring de 6820.

Hvad er det i øvrigt - Oksbøl, Billum?
Avatar billede duno Nybegynder
16. marts 2004 - 20:03 #7
T.TOPIC_ID er et ID nummer på et indlæg

Det er snitz forum...

altså et debatfora.. hvor jeg vil tilføje en "lille" funktion...

...

...

det virkede altså perfekt før, mit site har kørt i et år nu.. uden problemer.. men så kom jeg til at tilføje 5 linier.. og så gik det helt galt... heldigt at jeg ikke overskrev originalen he he...

Jeg har tilføjet mange ting til originalen.. men nu.. nu er jeg sku gået kold!!

hvis du vil se originalfilerne altså de ting jeg prøver at få til at virke.. så send mig en mail på

bhn22@hotmail.com
Avatar billede eagleeye Praktikant
16. marts 2004 - 20:15 #8
Too few parameters. Expected 5. Betyder der mangler nogle parametre.

Er du sikker på alle de listede kolonnenavne findes i de tabeller der refereres?
Avatar billede duno Nybegynder
25. juli 2004 - 23:07 #9
Jeg giver op, jeg dropper den funktion og lukker spørgsmålet!!

Hvad siger du til at vi laver en deler????

50/50
Avatar billede Ny bruger Nybegynder

Din løsning...

Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.

Loading billede Opret Preview
Kategori
Kurser inden for grundlæggende programmering

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Du kan også logge ind via nedenstående tjenester