Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Snitz Forums 2000 MOD-Group
 MOD Add-On Forum (W/O Code)
 Email link to last reply in topic		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

net83it
Starting Member

18 Posts
Posted - 11 January 2005 :  15:01:52  Show Profile  Visit net83it's Homepage
hi

how shall i modify inc_subscription.asp to send and email with link to last reply in topic??

on main page of the forum i found that the link should have to be

...topic.asp?whichpage=-1&TOPIC_ID=XXXXX&REPLY_ID=YYYYYY


but how can i exctract from the db the exact reply_id of the last reply?

line to be modified on inc_subscription.asp is

strMessage = strMessage & "Puoi vedere il messaggio qui... " & strForumURL & "topic.asp?TOPIC_ID=" & TopicId & vbNewline


and i'm able only to add

strMessage = strMessage & "Puoi vedere il messaggio qui... " & strForumURL & "topic.asp?whichpage=-1&TOPIC_ID=" & TopicId & "&REPLY_ID" & ?????? & vbNewline


what writes instead of ??????

thank you and sorry for my bad english

laser
Advanced Member

Australia
3859 Posts
Posted - 11 January 2005 :  16:07:23  Show Profile
Hehehe ... I've had this question as well, but never got to code it. I'm pretty sure the lastreplyid is actually a column in the TOPICS table isn't it ?
Go to Top of Page

net83it
Starting Member

18 Posts
Posted - 11 January 2005 :  16:32:04  Show Profile  Visit net83it's Homepage
yes, the column is

T_LAST_POST_REPLY_ID

but i'm not able to get the value of this field relatived to one determinated topic_id.
the code should have to work like "when the topic_id is XXXXX then T_LAST_POST_REPLY_ID is YYYYY"
Go to Top of Page

net83it
Starting Member

18 Posts
Posted - 11 January 2005 :  17:09:30  Show Profile  Visit net83it's Homepage
on source of active.asp page i found that T_LAST_POST_REPLY_ID field is called by Topic_Last_Post_Reply_ID, while on default.asp, forum.asp and search.asp it is called by Topic_LastPostReplyID.

i changed the line to

strMessage = strMessage & "Puoi vedere il messaggio qui... " & strForumURL & "topic.asp?whichpage=-1&TOPIC_ID=" & TopicId & "&REPLY_ID=" & Topic_Last_Post_Reply_ID & vbNewline

or
strMessage = strMessage & "Puoi vedere il messaggio qui... " & strForumURL & "topic.asp?whichpage=-1&TOPIC_ID=" & TopicId & "&REPLY_ID=" & Topic_LastPostReplyID & vbNewline


but the result is

quote:
Puoi vedere il messaggio qui... http://www.mydomain.it/forum/topic.asp?whichpage=-1&TOPIC_ID=3602&REPLY_ID=


reply_id is missing :(
Edited by - net83it on 11 January 2005 17:15:05
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.41 seconds. Powered By: Snitz Forums 2000 Version 3.4.07