<% if strDBNTUserName <> "" then ' Get Private Message count for display on Default.asp if strDBType = "access" then strSqL = "SELECT count(M_TO) as [pmcount] " else strSqL = "SELECT count(M_TO) as pmcount " end if strSql = strSql & " FROM " & strMemberTablePrefix & "MEMBERS , " & strTablePrefix & "PM " strSql = strSql & " WHERE " & strMemberTablePrefix & "MEMBERS.M_NAME = '" & strDBNTUserName & "'" strSql = strSql & " AND " & strMemberTablePrefix & "MEMBERS.MEMBER_ID = " & strTablePrefix & "PM.M_TO " strSql = strSql & " AND " & strTablePrefix & "PM.M_READ = 0 "
Set rsPM = my_Conn.Execute(strSql) pmcount = rsPM("pmcount")
rsPM.close set rsPM = nothing
if strDBNTUserName = "" then Response.Write "" else if pmcount = 0 then Response.Write "" end if if pmcount >= 1 then Response.Write "<table width=""97%"" border=""0"" cellspacing=""0"" cellpadding=""0"" align=""center"">" Response.Write "<tr>" Response.Write "<td><a href=""pm_view.asp""><img src=""icon_pm_new_big.gif"" alt=""You got a new Private Message!"" border=""0""></a></td>" Response.Write "</tr>" Response.Write "</table>" end if end if end if %>
This code makes a image apare when a new PM is in the inbox. Place the code in inc_top.asp, perhaps below the forumlogo. When it is placed in inc_top.asp the image will apare on every page in the forums. You must make or find a image simular to this one
This code can be found in the includefile that you use on default.asp (privatemess2.asp), I have just done some adjustments to it.
If you dont like the table that the image is inside, it should not be a problem removeing the Response.Write "<tab... lines in the code.