I also added the tool tip text DJBBIZ wanted, and added notes on where to edit active.asp for the links to show up there, as suggested by Neil Washbrook.
There was originally a mod for this on 3.1 and 3.3 and it not only incorporated Who Replied, but Who Viewed. I believe the mod was called Who Viewed or something like that. You may want to check it out so the new 3.4 version you have released can include the Who Viewed portion. This is a valuable mod and nice to see that someone took it upon themselves to get it working with 3.4
I was un-aware of a previous version, do you know who authored it? I should really add them to the readme.txt I suppose.
I know there is a Who Viewed This mod by Kal Korp, but I did not think of adding that option here.
I've been looking for the Who's Posted/Who's Viewed type mod for 3.4.x. I had it on 3.3.05 and my members loved it. Hope this puppy can end up serving the same function.
I edited the readme file and posted this mod on the SH forum. I hope you don't mind ??? I loved it so much I thought it would be cool for them to be able to use it as well..
I edited the readme file and posted this mod on the SH forum. I hope you don't mind ??? I loved it so much I thought it would be cool for them to be able to use it as well..
I have been sitting with this code for 3 days now, and I am lost. Snitz v.3.4 mySQL IIS
When I do the sql directly on my mySQL I get it nice and clear:
mysql> SELECT M.M_NAME,Count(M.M_NAME) AS total_posts,R.R_AUTHOR FROM XX_MEBERS M, XX_REPLY R WHERE M.MEMBER_ID = R.R_AUTHOR AND R.TOPIC_ID = 653 GROUP BY M.M_NAME, R.R_AUTHOR;
I have used a fixed topic_id to experiment on. But getting this written out in the popup has not succeeded yet. And the original asp code does not work for me. I just get the popup saying "There Was A Problem With Your Details" and "There are no replies to this topic!" And I am using the same fixed sql sentence for the request together with the original (both).
Just to make sure it works, I made a simplyfied version using PHP in my forum like this:
<?php
...
$result = mysql_query("SELECT M.M_NAME, Count(M.M_NAME) AS total_posts,
R.R_AUTHOR FROM xx_MEMBERS M, xx_REPLY R WHERE M.MEMBER_ID = R.R_AUTHOR AND
R.TOPIC_ID =".$Topic_ID. " GROUP BY M.M_NAME, R.R_AUTHOR");
while ($row = mysql_fetch_array($result,MYSQL_ASSOC)) {
$total = $row['total_posts'];
print "<b>".$row{'M_NAME'}. "</b> has posted <b>" . $total . "</b> time(s).<br>";
}
...
And it has no problems at all. So I assume that there is something about the total_posts in the asp code that is not working for me. But I can't see what is wrong. I have put up this php experimental popup on my forum, so you can see it works.
Topic Locked
Posted - 02 February 2003 : 11:04:59
