|
Rivelyn
Starting Member
1 Posts |
 Posted - 04 December 2005 : 18:56:36
|
INC_HEADER.ASP
Add the following: (about line 260)
This code needs to be after the connection is opened near the top of the page and after
strDBNTUserName is defined. It needs to be placed before sForumNavigation() is called.
' Get Private Message count for display
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
I have no idea where the heck I am supposed to put this I see that it says around 260 however I do not want to break it, and so far the "about line#" has not been that close. Everthing else is very easy with the setup telling me where to look and what to change, untill I hit the above point, now I am lost, I have no idea where to put it. This is from the latest ver of Snitz downloaded earlier this week and I have put no other MOD's into it.
MOD: private_messages-34-340301 downloaded from SnitzBitz.com
Could someone please tell me where to put it, in a little more clear way then above?
Thanks(yes I'm new  )
|
Edited by - Rivelyn on 04 December 2005 19:07:52 |
|
Topic Locked
