| Author |
 Topic  |
|
Aaron S.
Average Member
USA
985 Posts |
 Posted - 15 May 2002 : 10:27:19
|
The Email/No Email seems to work fine for me.
There is one change to the CAT SQL query.
Around line 452 you will see:
elseif level="CAT" then
StrSql = "SELECT F_LAST_POST, F_LAST_POST_AUTHOR, SUB_EMAIL, S.TOPIC_ID, S.CAT_ID, S.FORUM_ID "
StrSql = StrSql & " FROM " & strTablePrefix & "FORUM F, " & strTablePrefix & "SUBSCRIPTIONS S" & _
" WHERE S.FORUM_ID = F.FORUM_ID " & _
" AND S.CAT_ID = " & CatID
if Mode = "" then
StrSql = StrSql & " AND S.MEMBER_ID = " & MemberID
end if
StrSql = StrSql & " ORDER BY F_ORDER, F_SUBJECT "
rsForumLoop2.Open StrSql, my_Conn, 3
if rsForumLoop2.EOF or rsForumLoop2.BOF then
' should not happen
else
if cint(rsCatLoop("SUB_EMAIL")) = 1 then
response.write "<a href=""javascript:subemail(0," & rsCatLoop2("CAT_ID") & "," & rsCatLoop2("FORUM_ID") & "," & rsCatLoop2("TOPIC_ID") & ");""><img src=""icon_email_no.gif"" alt=""Get no email on category"" border=0></a>"
else
response.write "<a href=""javascript:subemail(1," & rsCatLoop2("CAT_ID") & "," & rsCatLoop2("FORUM_ID") & "," & rsCatLoop2("TOPIC_ID") & ");""><img src=""icon_email.gif"" alt=""Get email on category"" border=0></a>"
end if
end if
rsForumLoop2.close
end if
Change it to:
elseif level="CAT" then
StrSql = "SELECT SUB_EMAIL, CAT_ID, FORUM_ID, TOPIC_ID "
StrSql = StrSql & " FROM " & strTablePrefix & "SUBSCRIPTIONS S" & _
" WHERE S.CAT_ID = " & CatID
if Mode = "" then
StrSql = StrSql & " AND S.MEMBER_ID = " & MemberID
end if
rsForumLoop2.Open StrSql, my_Conn, 3
if rsForumLoop2.EOF or rsForumLoop2.BOF then
' should not happen
else
if cint(rsForumLoop2("SUB_EMAIL")) = 1 then
response.write "<a href=""javascript:subemail(0," & rsForumLoop2("CAT_ID") & "," & rsForumLoop2("FORUM_ID") & "," & rsForumLoop2("TOPIC_ID") & ");""><img src=""icon_email_no.gif"" alt=""Get no email on category"" border=0></a>"
else
response.write "<a href=""javascript:subemail(1," & rsForumLoop2("CAT_ID") & "," & rsForumLoop2("FORUM_ID") & "," & rsForumLoop2("TOPIC_ID") & ");""><img src=""icon_email.gif"" alt=""Get email on category"" border=0></a>"
end if
end if
rsForumLoop2.close
end if
DOWNLOAD GREAT NEW MODS HERE |
 |
|
|
martinkl
Starting Member
25 Posts |
Posted - 16 May 2002 : 07:43:39
|
Hi Aaron,
Has this last change also been incorporated into the download files?
BTW, thanks for this Mod!
"The day we stop developing is the day we all die!" |
|
|
|
Aaron S.
Average Member
USA
985 Posts |
|
|
DoraMoon
Average Member
Taiwan
661 Posts |
Posted - 21 May 2002 : 11:11:25
|
Hi,Aaron
i installed ur great MOD, everything look just be fine.
but some questions may i ask ..
1. the Topic link seem not appear.
i saw above the keston's picture, it seem have the topic hyperlink,
but it just topic text (no link) for me ? if i missed something ?
2. i can't understand the "Receive Email(default setting)" very well.
what difference whith user check or uncheck it ?
it will change ALL subscriptions setting at a time, right ?
sorry i'm not very familar with program, hope someone can explain for me. thx ! 
~~ ¡¹ ¡¸ ¡¸¡¹ ¡¸ ¡¹ ~~ |
|
|
|
Aaron S.
Average Member
USA
985 Posts |
Posted - 21 May 2002 : 11:50:37
|
Originally, the deafult email setting would apply automatically to any new subscription request.
Instead, it now prompts you whether or not to receive email... and uses the default setting as the deafult radio button selected when that window pops up.
--Aaron
DOWNLOAD GREAT NEW MODS HERE |
|
|
|
DoraMoon
Average Member
Taiwan
661 Posts |
Posted - 21 May 2002 : 12:42:59
|
thx Aaron's explanation for me ..
i think i got it, the subscripton and receive email or not now just different function.
u can choice toggle on/off email when subcription popup windows, or u also can change it in my subscription list. right ?
and about the first question ...(topic link..)
i found this in subscription_list.asp
(about line 256)
'########## MySubs MOD ###########
StrSql = "SELECT DISTINCT S.TOPIC_ID, T.T_SUBJECT,T_LAST_POST,T_LAST_POST_AUTHOR, SUB_EMAIL, S.FORUM_ID, S.CAT_ID " &_
" FROM " & strTablePrefix & "TOPICS T, " & _
" " & strTablePrefix & "SUBSCRIPTIONS S" & _
" WHERE S.TOPIC_ID = T.TOPIC_ID " & _
" AND S.FORUM_ID = " & ForumID & _
" AND S.CAT_ID = " & CatID
'################################
if Mode = "" then
StrSql = StrSql & " AND S.MEMBER_ID = " & MemberID
end if
StrSql = StrSql & " ORDER BY T_SUBJECT "
rsTopicLoop.Open StrSql, my_Conn, 3
if rsTopicLoop.EOF or rsTopicLoop.BOF then
' Do Nothing -- No Topic Level Subscriptions found for this category/forum
else
Do until (rsTopicLoop.EOF or rsTopicLoop.BOF)
TopicID = rsTopicLoop("TOPIC_ID")
Response.Write vbNewline & "<tr>" & vbNewline & _
" <td " & CellBg
if Mode <> "" then
Response.write " colspan=""2"" "
end if
Response.Write ">" & CellFont & _
" <b>Subject: </b>" & _
rsTopicLoop("T_Subject") & "</font></td>" & vbNewline
LookForSubscriptions CatID, ForumID, TopicID
Response.Write " </tr>" & vbNewline
rsTopicLoop.MoveNext
loop
end if
rsTopicLoop.close
end if
so it seem just no topic link in original Snitz file..
can someone tell me how to add link to Topic Subject ?? if we can do it.
thanks !
~~ ¡¹ ¡¸ ¡¸¡¹ ¡¸ ¡¹ ~~ |
|
|
|
skip
Starting Member
Canada
7 Posts |
Posted - 22 May 2002 : 02:13:23
|
Sorry to sound dense, but exactly what does the "receive email" setting do?
Does it send a notification when a new msg is added to the thread, or does it echo the message to you via email directly? And can you reply to it?
Reason I ask is that I'm trying to locate the necessary software to migrate/merge a 600+ member mailing list to a combo listserv / forums software, so members can either participate via email OR web forum.
Ideas?
|
|
|
|
Aaron S.
Average Member
USA
985 Posts |
Posted - 22 May 2002 : 07:48:24
|
Snitz had a subscription function built in that sends a user an email notifying them that there has been a reply to a topic / forum / category that they have subscribed to.
The message is not in the notification.
The problem is that the volume of emails can be quite high... hence the MOD to give the user the choice on whether or not to receive the email... and the ability to get more information on the My Subscriptions page.
If you search this forum... you should be able to find code to change the email message from a notification to something that shows what the user posted.
I will also try and find that code later on.
--Aaron
DOWNLOAD GREAT NEW MODS HERE |
|
|
|
Dan Martin
Average Member
USA
528 Posts |
Posted - 30 June 2002 : 18:20:06
|
I've installed this mod, thinking I wanted it. And it certainly is kind of cool. But now, I'm wondering a couple of things:
1) Everyone in my database now has a new field, M_MYSUBS which is set to 0. Now, does this mean now that none of them that subscribed prior to the mod will receive email?
2) What does subscribing, but saying No to receiving emails do? Just simply puts it in the subscription list without actually subscribing?
Thanks,
Dan
|
|
|
|
Aaron S.
Average Member
USA
985 Posts |
Posted - 01 July 2002 : 10:10:01
|
Hi Dan:
quote:
1) Everyone in my database now has a new field, M_MYSUBS which is set to 0. Now, does this mean now that none of them that subscribed prior to the mod will receive email?
All your current subscriptions (prior to the MOD) should be unchanged.
The field simply tracks the default setting to prompt members when they choose a new subscription.
quote:
2) What does subscribing, but saying No to receiving emails do? Just simply puts it in the subscription list without actually subscribing?
It adds it to the MySubs page. The MySubs page now has useful information and can be used like Active.asp.
DOWNLOAD GREAT NEW MODS HERE |
|
|
|
Dan Martin
Average Member
USA
528 Posts |
Posted - 01 July 2002 : 13:03:40
|
Okay, I understand now. What this means to me is that I don't have the MOD installed right, because I'm not seeing the information in the the My Subscriptions page. Can anyone link to or email me a correctly modified inc_subscription.asp and subscription_list.asp
Lastly, your readme refers to inc_subscriptions.asp where it should refer to inc_subscription.asp. No big deal, but I thought you might want to know.
Thanks for the MOD!
-Dan
|
|
|
|
Aaron S.
Average Member
USA
985 Posts |
Posted - 01 July 2002 : 13:39:44
|
Can you post a link to your inc_subscription page as a text file.
Thanks,
--Aaron
DOWNLOAD GREAT NEW MODS HERE |
|
|
|
Dan Martin
Average Member
USA
528 Posts |
Posted - 01 July 2002 : 21:17:45
|
http://www.councilofgrey.com/temp/inc_subscription.txt
I've got a few issues with it. I kind of wish your mod came with the post-moded files like other mods, because I just have nothing to compare what I ended up with to.
I'm not sure what it should look like. One issue I know for sure, the information for every forum within a Category is the same. Here's an image 
Note that the information is the same for both forums under the Private category...and trust me, he can't post that fast, LOL.
Ideas?
|
|
|
|
Dan Martin
Average Member
USA
528 Posts |
Posted - 04 July 2002 : 03:49:07
|
Aaron? I know you're around, I've seen your other posts. 
|
|
|
|
Aaron S.
Average Member
USA
985 Posts |
Posted - 04 July 2002 : 10:49:53
|
With the long weekend... I should have time to look at this.
Alternatively, I'll just send you the file post MOD.
--Aaron
DOWNLOAD GREAT NEW MODS HERE |
|
|
|
Topic |
|
Topic Locked
