| Author |
 Topic  |
|
|
tribaliztic
Senior Member
Sweden
1532 Posts |
 Posted - 14 March 2006 : 05:29:35
|
I'd like to have this functionality:
When I click the flashing "PM Messages" that tell me I have unread PM:s I would like to automatically open the new message IF there is only one unread message.
I suppose I could "count pm_message_unread" or something, but how? =)
< |
/Tribaliztic
- www.gotlandrace.se -
|
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 14 March 2006 : 07:06:36
|
Should be easy enough to do, in the SQL query that determines whether or not to show the flashing "PM Messages" (I assume this is another mod you have installed?), retrieve the ID of the message(s). Then, when writing the link, check to see if the count is greater than one (in which case, link to the inbox) or not (in which case, link to the message directly using the ID you now have).
< |
 Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
 |
|
|
tribaliztic
Senior Member
Sweden
1532 Posts |
Posted - 14 March 2006 : 07:19:58
|
It's this part I'm asking about:
quote:
Originally posted by Shaggy
check to see if the count is greater than one
=)< |
/Tribaliztic
- www.gotlandrace.se -
|
|
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 14 March 2006 : 07:27:19
|
So's I can properly point you in the right direction, can you post a link to a *.txt copy of the file in question?
< |
Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
|
|
|
tribaliztic
Senior Member
Sweden
1532 Posts |
|
|
tribaliztic
Senior Member
Sweden
1532 Posts |
Posted - 14 March 2006 : 08:10:08
|
I'm sorry, now that I actually looked at the code, the count is already done =)
< |
/Tribaliztic
- www.gotlandrace.se -
|
|
|
|
tribaliztic
Senior Member
Sweden
1532 Posts |
Posted - 14 March 2006 : 08:26:42
|
I solved it by making the link like this:
Response.Write "<font face=""" & strDefaultFontFace & """ size=""" & strFooterFontSize & """ color=""" & strForumFontColor & """><b><span class=""spnMessageText""><a href=""privateread.asp?id=" & pmid & """>PM Inkorg</a></span>" & vbNewLine
after inserting this little sql thingy:
if pmcount = 1 then
strSqL2 = "SELECT M_ID as pmid "
strSql2 = strSql2 & " FROM " & strMemberTablePrefix & "MEMBERS , " & strTablePrefix & "PM "
strSql2 = strSql2 & " WHERE " & strMemberTablePrefix & "MEMBERS.M_NAME = '" & strDBNTUserName & "'"
strSql2 = strSql2 & " AND " & strMemberTablePrefix & "MEMBERS.MEMBER_ID = " & strTablePrefix & "PM.M_TO "
strSql2 = strSql2 & " AND " & strTablePrefix & "PM.M_READ = 0 "
Set rsPM2 = my_Conn.Execute(strSql2)
pmid = rsPM2("pmid")
rsPM2.close
set rsPM2 = nothing
end if
Seems like it's working but I haven't tested it with more than one PM yet =)
< |
/Tribaliztic
- www.gotlandrace.se -
|
|
|
|
tribaliztic
Senior Member
Sweden
1532 Posts |
Posted - 14 March 2006 : 08:29:52
|
w00t!
I forgot to do this with the link:
if pmcount = 1 then
Response.Write "<font face=""" & strDefaultFontFace & """ size=""" & strFooterFontSize & """ color=""" & strForumFontColor & """><b><span class=""spnMessageText""><a href=""privateread.asp?id=" & pmid & """>PM Inkorg</a></span>" & vbNewLine
else
Response.Write "<font face=""" & strDefaultFontFace & """ size=""" & strFooterFontSize & """ color=""" & strForumFontColor & """><b><span class=""spnMessageText""><a href=""pm_view.asp"">PM Inkorg</a></span>" & vbNewLine
end if
But now everything's working as I want!
Removes one step when wanting to read a pm and it's only one unread pm in the inbox. You have to think about the ergonomy you know ;)
< |
/Tribaliztic
- www.gotlandrace.se -
|
|
|
| |
Topic |
|
PM Mod addon
