| Author |
 Topic  |
|
richfed
Average Member
United States
999 Posts |
 Posted - 02 February 2003 : 11:04:59
|
| Ever uncover the mysteries of the archives & this mod, Hamlin? |
 |
|
|
BitByter
New Member
Netherlands
53 Posts |
Posted - 02 February 2003 : 20:21:22
|
is it also possible to make this also for "read"
so u can see who read the topics how many times?
and ofcourse that is is visible only for moderators+administrators
in my old snitz forum i had a topic voyeur mod what did exactly this... |
___________________
creativity: look where everbody looks, see what nobody sees |
|
|
|
Hamlin
Advanced Member
United Kingdom
2386 Posts |
Posted - 03 February 2003 : 07:29:43
|
quote:
Ever uncover the mysteries of the archives & this mod, Hamlin?
Forgot to look, keep reminding me  |
|
|
|
richfed
Average Member
United States
999 Posts |
Posted - 04 February 2003 : 05:59:25
|
| Will do! |
|
|
|
Hamlin
Advanced Member
United Kingdom
2386 Posts |
Posted - 16 February 2003 : 11:49:18
|
quote:
Ever uncover the mysteries of the archives & this mod, Hamlin?
Sorry it took me so long to get round to this, my laziness got the better of me
Anyway here is the update so that the link works with archived topics.
Step 1 : Forum.asp
Find the code we added for this mod, around line 545 and add the red code.
if CLng(Topic_Replies) > 0 then
response.write " <td bgcolor=""" & strForumCellColor & """ valign=""middle"" align=""center""><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """ color=""" & strForumFontColor & """><span class=""spnMessageText""><acronym title=""Click here to see who has posted in this topic. (" & ChkString(Topic_Subject,"title") & ")""><a href=""JavaScript:openWindow3('pop_posted.asp?" & ArchiveLink & "Topic_ID=" & Topic_ID & "')""" & dWStatus("Who has posted?") & ">" & Topic_Replies & "</a></acronym></span></font></td>" & vbNewLine
else
response.write " <td bgcolor=""" & strForumCellColor & """ valign=""middle"" align=""center""><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """ color=""" & strForumFontColor & """>" & Topic_Replies & "</font></td>" & vbNewLine
end if
Step 2 : pop_posted.asp
Download the new pop_posted.asp file from Who Has Posted Mod for Snitz 3.4.x.x and put it in with your forum files.
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.
|
|
|
|
richfed
Average Member
United States
999 Posts |
|
|
Image
Average Member
Canada
574 Posts |
Posted - 17 February 2003 : 19:11:04
|
quote:
Originally posted by Hamlin
quote:
Originally posted by dayve
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.
Topic View and Reply Voyeur MOD for 3.3
Author: Da_Stimulator
http://forum.snitz.com/forum/topic.asp?ARCHIVE=true&TOPIC_ID=18014&SearchTerms=voyeur
Demo on 3.3 : http://www.efrance.fr/image2/image/forum.asp?FORUM_ID=1
Demo on 3.4.03 : http://www.3000fr.com/forumimage/forum.asp?FORUM_ID=1 |
|
|
|
Danomatic
Starting Member
16 Posts |
Posted - 17 February 2003 : 19:44:00
|
| 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. |
|
|
|
svx
Starting Member
USA
35 Posts |
Posted - 17 March 2003 : 02:13:52
|
/edit
Found WhoSeen for SH |
{ISV-K}SVX
"I'm on Fire!"
www.isv-knights.org |
Edited by - svx on 17 March 2003 02:27:13 |
|
|
|
svx
Starting Member
USA
35 Posts |
Posted - 17 March 2003 : 02:15:55
|
| btw, thanks for the mod. |
{ISV-K}SVX
"I'm on Fire!"
www.isv-knights.org |
|
|
|
Gargoyle
Junior Member
USA
280 Posts |
Posted - 19 March 2003 : 19:31:52
|
Thanks for the MOD Hamlin.. And your quote!! 
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.. |
Here is a link to my Snitz powered Drag Racing site. |
|
|
|
Hamlin
Advanced Member
United Kingdom
2386 Posts |
Posted - 20 March 2003 : 04:03:27
|
quote:
Originally posted by Gargoyle
Thanks for the MOD Hamlin.. And your quote!!
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..
Do what you want with it. |
|
|
|
Arne2
New Member
Denmark
51 Posts |
Posted - 21 March 2003 : 10:56:28
|
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;
+----------+-------------+----------+
| M_NAME | total_posts | R_AUTHOR |
+----------+-------------+----------+
|--Arne----|-----------4-|--------7-|
|--jor-----|-----------2-|--------9-|
|--shazamed|-----------2-|----- 568-|
+----------+-------------+----------+
3 rows in set (0.02 sec)
mysql>
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).
Any ideas, as I am almost giving up?
Regards
Arne 
Proxomitron Forum 2002
http://asp.flaaten.dk/proxo/ |
Edited by - Arne2 on 21 March 2003 10:57:28 |
|
|
|
Arne2
New Member
Denmark
51 Posts |
Posted - 22 March 2003 : 04:20:18
|
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.
|
|
|
|
Hamlin
Advanced Member
United Kingdom
2386 Posts |
Posted - 22 March 2003 : 05:13:28
|
| So the SQL query works fine? Just not on the ASP page...and you dont get any error messages using the original pop_posted.asp page? |
|
|
|
Topic |
|
Topic Locked
