| Author |
Topic |
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
 Posted - 2007-09-14 : 03:54:17
|
I would like to have a "personal" page much like the "my subscriptions" link.This new link should contain "my replies" and generate a page link thisTopic started by Number of topics answered My replies Last reply---------------- ------------------------- ---------- -------------------Funketetun 3,052 45,457,457 15/09/2007 15:15:15oracle_corrgi 12,111 15,244 06/04/2007 01:37:49... ... ... ... 1) Two replies for same topic id counts as 2 replies.2) Sort by "My replies" descending, number of topics answered descendingIs it possible?
E 12°55'05.25"N 56°04'39.16" |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-09-14 : 04:02:54
|
It would be cool to have the column headers as links!Clicking a "new" header (different from last header click) renders an ascending sort for the header and changes the links for all other headers to ascending.Clicking same header link again changes the order of the current header, refreshes the page with new sort order and leave other headers still ascending.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-09-14 : 04:46:26
|
Any specific reason?  MadhivananFailing to plan is Planning to fail |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-09-14 : 05:08:23
|
Yes, of course. I have had a correspondance with a gut about "social networking" for same days now.I thought it would be nice to see if the replies I post are gone "unread" or you can see that the ratio between replies and topics are low.New functionality for the request above. A new column with RATIO (posts / topics) formatted as "#,##0.0000"I like to think of this like a "decision support page".1) Is it worth my effort to answer?2) Can I expect to get many follow-up questions? (high ratio)Of course my own topics are not counted.This request will not offend anyone, because it is for me only (as I am logged in). If anyone else click same "my replies" link, they got their statistics.
E 12°55'05.25"N 56°04'39.16" |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-09-14 : 05:18:53
|
When I come to think about it, maybe there is a businees for "reverse role"?A link for "my topics"People helping me Number of topics answered # Answers Last answer----------------- ------------------------- ---------- -------------------nr 3,052 45,457,457 15/09/2007 15:15:15Kristen 12,111 15,244 06/04/2007 01:37:49
E 12°55'05.25"N 56°04'39.16" |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-09-14 : 05:48:29
|
| Changing Snitz is a PITA for Graz, more particularly when a new version comes out and all the "specials"/"mods" have to be hand coded into the new version's source code.I reckon your need would be handled by my request for a Twit List where I could just hide threads from people I considered to be twits. Conversely a list of Friends would prevent me missing a new post from one of the regulars, which I might very well want to participate in. I mean, apart from Yak forum, the regulars only post once-in-a-blue-moon, so easy to miss a posting.Kristen |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-09-14 : 05:49:34
|
| Tell you what though ...... if you install Snitz on your dev machine, make a Bespoke Page (peso.asp for example), and send that to Graz he may be included to mount it, because its completely standalone.Kristen |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-09-14 : 07:32:15
|
Me and php? No, I don't think so.Something similar to this might do it? I can do without the sorting things.quote:
Originally posted by Kristen
SELECT TOP 10 M.MEMBER_ID, M.M_NAME, M.M_POSTS, M.M_DATE, MIN_T_DATE, MIN_R_DATE, [Type] = CASE WHEN MIN_T_DATE <= MIN_R_DATE THEN 'TOPIC' ELSE 'REPLY' END, [Topic] = (SELECT MIN(TOPIC_ID) FROM FORUM_TOPICS WHERE T_DATE = MIN_T_DATE), [ReplyTopic] = (SELECT TOP 1 TOPIC_ID FROM FORUM_REPLY WHERE R_DATE = MIN_R_DATE ORDER BY TOPIC_ID, REPLY_ID), [ReplyID] = (SELECT TOP 1 REPLY_ID FROM FORUM_REPLY WHERE R_DATE = MIN_R_DATE ORDER BY TOPIC_ID, REPLY_ID)FROM FORUM_MEMBERS AS M LEFT OUTER JOIN ( SELECT T_AUTHOR, [MIN_T_DATE] = MIN(T_DATE) FROM FORUM_TOPICS GROUP BY T_AUTHOR ) AS T ON T.T_AUTHOR = M.MEMBER_ID LEFT OUTER JOIN ( SELECT R_AUTHOR, [MIN_R_DATE] = MIN(R_DATE) FROM FORUM_REPLY GROUP BY R_AUTHOR ) AS R ON R.R_AUTHOR = M.MEMBER_IDWHERE M_POSTS >= 1000ORDER BY M_NAME
E 12°55'05.25"N 56°04'39.16" |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-09-14 : 08:43:49
|
| "Me and php? No, I don't think so"Snitz is ASP ... so you'll be fine!Kristen |
|
|
|
|
New feature