Author |
Topic |
BritishAndy
Starting Member
United Kingdom
15 Posts |
Posted - 26 December 2002 : 07:40:35
|
I have a lot of members, but I am having difficulty getting them to come back after the initial enthusiasm wears off.
What I would like to do is send a monthly email summarising all activity over the previous month. Something like:
"Blah blah blah..........
Postings over last month: Category1 name User1 wrote 'This is a posting title which links to the topic' User2 wrote 'This is a posting title which links to the topic' User3 wrote 'This is a posting title which links to the topic'
Category2 name User1 wrote 'This is a posting title which links to the topic' User2 wrote 'This is a posting title which links to the topic' User3 wrote 'This is a posting title which links to the topic'
"Blah blah blah..........
This could also be expanded to send each user the postings since they last logged on to the forums...
I wish I had the knowledge to do this - but I don't.
Any bored asp'er fancy tackling this?
Andy.
|
|
potatohead
Starting Member
34 Posts |
|
Hamlin
Advanced Member
United Kingdom
2386 Posts |
Posted - 26 February 2003 : 14:40:37
|
I'm bored and this, for whatever reason, seems interesting. |
|
|
gelliott
Junior Member
USA
268 Posts |
Posted - 26 March 2003 : 12:34:59
|
Hamlin, are you still chewing on this one? I was interested too. I took a stab at it but got sucked into other things and haven't got back to it yet... |
* The optimist says the cup is half full. The pessimist says it's half empty. But the engineer knows the truth - the cup's design is incorrectly sized. |
|
|
Hamlin
Advanced Member
United Kingdom
2386 Posts |
Posted - 26 March 2003 : 12:43:13
|
I did start it yes, but got side tracked, I will get back to it at some point |
|
|
gelliott
Junior Member
USA
268 Posts |
Posted - 27 March 2003 : 23:20:49
|
Just checking... |
* The optimist says the cup is half full. The pessimist says it's half empty. But the engineer knows the truth - the cup's design is incorrectly sized. |
|
|
gelliott
Junior Member
USA
268 Posts |
Posted - 31 March 2003 : 13:42:42
|
Hamlin, I took another pass at it this weekend - I figured starting from the active.asp page and locking in the 30-day choice was the fastest way to get started. The next set of conditional statements in that file attempt to limit what topics are shown based on the access rights of the user i.e. - new topics in forums they are excluded from aren't shown. Initially, I had just planned to ignore this and only show the "visible to all" topics, but later wondered if I was stripping out too much functionality for some users. Yet if we tried to take the users into account, you'd end up making a pass through the topic list for each registered user with access to one or more private forums, plus a final additional pass for everyone else.
Had you thought of how to tackle this? |
* The optimist says the cup is half full. The pessimist says it's half empty. But the engineer knows the truth - the cup's design is incorrectly sized. |
|
|
Hamlin
Advanced Member
United Kingdom
2386 Posts |
Posted - 31 March 2003 : 14:15:48
|
I did not get very far,I had the query below to get a list of users who have not been seen in X days (shown below)
quote: Lists of users not seen since strLastVisit: strSQL ="SELECT M.MEMBER_ID, M.M_NAME, M.M_EMAIL FROM " &_ strMemberTablePrefix & "MEMBERS M " &_ "WHERE M_STATUS = 1 AND " &_ "M.M_LastHereDate <= '" & chkString(strLastVisit,"SQLString") & "'"
Then loop around those results, selecting all the topics posted since that date.
I had not really thought about how to restrict what is shown, take a look at inc_func_secure.asp, there are two functions there (chkForumAccessand chkDisplayForum) that can be used to check if a user should see/access a forum, so you could use them to check what topics to display, as you will know what forum the topic is in...
I hope that makes sense |
Edited by - Hamlin on 31 March 2003 14:16:49 |
|
|
GauravBhabu
Advanced Member
4288 Posts |
Posted - 31 March 2003 : 14:21:09
|
Why not send them a link to active.asp or a simple newsletter with some statistics and/or a message inspiring them to visit again? |
|
|
Hamlin
Advanced Member
United Kingdom
2386 Posts |
Posted - 31 March 2003 : 14:24:58
|
quote: Originally posted by GauravBhabu
Why not send them a link to active.asp or a simple newsletter with some statistics and/or a message inspiring them to visit again?
That would make it too easy |
|
|
GauravBhabu
Advanced Member
4288 Posts |
Posted - 31 March 2003 : 14:38:34
|
I know and will also mean 'No Hours/Days added to Coding Experience' |
Edited by - GauravBhabu on 31 March 2003 14:38:55 |
|
|
gelliott
Junior Member
USA
268 Posts |
Posted - 31 March 2003 : 19:40:21
|
I guess the intent was to inspire them with tastes of what they've been missing (i.e. - topic headings), rather than a simple reminder to check the forum. However, you make a good point - why complicate things further when existing code get's close. So, perhaps the best solution is a message based on Hamlin's query and a link to active.asp... If I get a chance this coming weekend, I'll try this approach... |
* The optimist says the cup is half full. The pessimist says it's half empty. But the engineer knows the truth - the cup's design is incorrectly sized. |
|
|
Lees List
Starting Member
Australia
6 Posts |
|
jeffery
Junior Member
USA
176 Posts |
|
mortioli
Average Member
United Kingdom
898 Posts |
Posted - 05 May 2003 : 07:22:25
|
Sounds cool! I've been trying to sort out the Content Display, but with no luck.
Would love to be able to have a page which generates all that info for you! |
|
|
Lees List
Starting Member
Australia
6 Posts |
Posted - 06 May 2003 : 07:17:05
|
OK, well let's say you have already installed Atomic's Content Display mod (3.4.03) - I downloaded it from www.snitzbitz.com
It comes with a bunch of "Display Modes" - templates for displaying content. I experimented with those and once I had successfully got content displayed on my site, I went into content.asp and had a bit of a play around with the subs to customise them.
This is the sub I made which returns the "Classified Ads" display:
Sub WriteBasic Response.Write "" & Topic_Subject & "" & vbNewLine & _ "<br>www.leeslist.com.au/forum/view.asp?TOPIC_ID=" target="_blank">http://www.leeslist.com.au/forum/view.asp?TOPIC_ID=" & T_Topic_ID & " " & vbNewLine & _ "<br>posted by - " & Member_Name & " - on " & ChkDate(Topic_Date, " " ,true) & "" & vbNewLine & _ "<hr>" & vbNewLine End Sub
You need to get the Content mod working first and understand what's going on there, then you'll know what I'm on about.
I use the Content mod on my sites homepage as well. The day I got my head around that mod was the start of a lot of fun for me! |
People to meet & places to go in Western Australia! www.leeslist.com.au
|
Edited by - Lees List on 06 May 2003 07:29:50 |
|
|
Topic |
|