| Author |
 Topic  |
|
DoraMoon
Average Member
Taiwan
661 Posts |
 Posted - 19 November 2002 : 04:13:49
|
###################################
Top Poster MOD for Snitz v3.4.0.x
###################################
Feature:
show the top xx members list that have most posts in a given period.
Introduction:
this small "one file mod" base on a magic SQL statement by ruirib.
all my doing just put it into the members page, that's all....... 
(p.s. dayve already have done this for a long time.(pop_top_20..)
here also take a lots idea/code from him. thanks both of them.. ^^)
(More Info..)http://forum.snitz.com/forum/topic.asp?ARCHIVE=true&TOPIC_ID=28936
Test:
on Snitz v3.4.03 and Access db only.
Download:
http://www.snitzbitz.com/mods/details.asp?Version=All&mid=104
Updated/Fixed:
2002/11/19 first released by DoraMoon
2002/11/20 bug fixed - move some lines out of the main loop.
2002/11/20 bug fixed - add check to divide by 0, also correct the bad English. (Thank Carefree for this comment/fix.)
2002/11/20 bug fixed - big bug fixed the pagesize limit... (Thank OpenIntro for this comment.)
 |
~ . .. .. .~ .~~ |
Edited by - DoraMoon on 20 November 2002 03:15:37 |
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 19 November 2002 : 04:36:53
|
| Any Demo ? |
Kiwihosting.Net - The Forum Hosting Specialists
|
 |
|
|
DoraMoon
Average Member
Taiwan
661 Posts |
Posted - 19 November 2002 : 04:45:08
|
quote:
Originally posted by Gremlin
Any Demo ?
well~ coz it's a "one file mod", no need to anything code modified. so i think it's easy for testing, maybe i can omit the demo work...  
but if someone need it... here
http://c.1asphost.com/doramoon/forum/members_top_poster.asp
(Notice: super slow demo site with pop-up ad..) |
|
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 19 November 2002 : 05:33:31
|
| Always nice to see what your downloading before deciding whether to download it or not :) |
Kiwihosting.Net - The Forum Hosting Specialists
|
|
|
|
GauravBhabu
Advanced Member
4288 Posts |
Posted - 19 November 2002 : 06:54:54
|
| You can also see the top posters by clicking on Posts in the header row in members.asp |
Edited by - GauravBhabu on 19 November 2002 06:55:23 |
|
|
|
DoraMoon
Average Member
Taiwan
661 Posts |
Posted - 19 November 2002 : 11:46:41
|
<---- Updated/Bug Fixed the download link.... ---->
hi~ GauravBhabu,
if you take a look that file or demo, you'll know there are really different in posts counting. the main purpose of this mod is get the top poster IN A GIVEN PERIOD. so it did'nt use the M_POSTS date, instead of counting the posts from TOPIC & REPLY table.
so even you choose "All Forum Posts", the posts number still a little different with member's M_POSTS.
(i have a small remark line showing in below.. IMPORTANT: above ranking posts did'nt include archived, unapproved and deleted posts.)
my personal think this one is more useful infomation for a forum community. for example: maybe no one can exceed Richard's 13544 posts in this forum, but it's possible that a new member could be have more posts than Richard in last month.   it can be a useful rank/hit board if you want to encourage new coming member posting in forum. |
|
|
|
terryp
Junior Member
United Kingdom
174 Posts |
Posted - 19 November 2002 : 17:46:09
|
I've tried it Dora and am getting this error : 3016
Microsoft VBScript runtime error '800a01c2'
Wrong number of arguments or invalid property assignment: 'getStar_Level'
/forum/members_top_poster.asp, line 395
It's that added stars mod again.........I know it's probably a simple fix but this simple person doesn't know what. If you let me know what it is I'll post a demo. |
  |
|
|
|
DoraMoon
Average Member
Taiwan
661 Posts |
Posted - 19 November 2002 : 18:06:19
|
<---- Updated/Bug Fixed the download link again.... ---->
hi~ terryp,
it's the same fix, just remember add one more Member ID variable to the getStar_Level function..
about line.403
getStar_Level(Members_MemberLevel, Members_MemberPosts)
change to
getStar_Level(Members_MemberID, Members_MemberLevel, Members_MemberPosts)
and i update the zip again, you may want to download it again.. |
|
|
|
terryp
Junior Member
United Kingdom
174 Posts |
Posted - 19 November 2002 : 18:15:22
|
Thanks DoraMoon.
OK, to see a demo have a look here : http://www.d-c2.co.uk/forum
The easiest mod ever. |
|
|
|
|
PeeWee.Inc
Senior Member
United Kingdom
1893 Posts |
Posted - 19 November 2002 : 18:29:30
|
| cool, goin to have to add this one 2moro |
De Priofundus Calmo Ad Te Damine |
|
|
|
OpenIntro
Junior Member
USA
126 Posts |
Posted - 20 November 2002 : 01:34:45
|
I just added the mod to my forum and it is great! Wish they were all this easy! hehe....
One thing, when you sort by Top ?? Poster Members, there is the ability to select more than 15, but it only shows the Top 15 no matter what. Is there a way to make it show more?
Also, I see 2001 and 2002 on there, but will 2003 automatically be included on Jan.1 or will this take modifications? |
Let's All Do Kamikaze Shots!
http://www.kamikazeshots.com
http://www.kamikazeshots.com/forum
*DO YOUR CLICKS!*
http://dailyclicks.kamikazeshots.com |
Edited by - OpenIntro on 20 November 2002 01:35:28 |
|
|
|
DoraMoon
Average Member
Taiwan
661 Posts |
Posted - 20 November 2002 : 03:29:23
|
<---- Updated/Bug Fixed the download link again and again.... ----> 
hi~ OpenIntro,
thank you, you found a big bug...
in basically, this file just copy from members.asp page, but i removed a lots code to keep it simpler...
and i think i missing one line.. about line.291
for iMember = 0 to iMemberCount
if (rec = strPageSize + 1) then exit for
the line with strPageSize should be removed !!
thanks every guys for finding bugs for me..
please download the updated file again, thx!
p.s. almost forgot this... 
hi~ OpenIntro, yes, the year/month select options will auto change by your website date.(at least, i hope so....) i have no idea how to test this... but if run your test forum on a local server, you can try change the system date to 2003,2004... then the select options will show up. |
|
|
|
OpenIntro
Junior Member
USA
126 Posts |
Posted - 20 November 2002 : 03:33:39
|
Great! Thanks Glad I could help....do i get a cookie for finding a BIG bug?
I was also curious if it was possible to sort the top posters by week and by day? I know some people are very curious as to how much they have posted in one day....
Great mod! Keep up the good work :) |
Let's All Do Kamikaze Shots!
http://www.kamikazeshots.com
http://www.kamikazeshots.com/forum
*DO YOUR CLICKS!*
http://dailyclicks.kamikazeshots.com |
Edited by - OpenIntro on 20 November 2002 03:34:20 |
|
|
|
OpenIntro
Junior Member
USA
126 Posts |
|
|
Tyler M.
New Member
USA
82 Posts |
Posted - 28 November 2002 : 03:20:14
|
quote:
Microsoft JET Database Engine error '80004005'
Could not use ''; file already in use.
/forums/members_top_poster.asp, line 150
I just uploaded the file, and the avatar.gif and typed in the name of the file in browser. Nothing else going on.
line 150 is:
rs.Open TopSQL(strSql, intTop), strConnString, adOpenStatic
I am using Access 2000 databse, also tried the _na.asp file as well same problem. |
Edited by - Tyler M. on 28 November 2002 03:21:26 |
|
|
|
DoraMoon
Average Member
Taiwan
661 Posts |
Posted - 29 November 2002 : 12:56:37
|
hi~ Tayler,
i've never seen this error message before.... quote:
Microsoft JET Database Engine error '80004005'
Could not use ''; file already in use.
/forums/members_top_poster.asp, line 150
i think i'll need to ask for help to other snitz guys about this strange problem. H E L P ~~
above that line (line.149)
'response.write TopSQL(strSql,intTop)
can you un-comment/remove the ' and tell us what the Sql string showing ?? |
|
|
|
Topic |
|
Topic Locked
