| Author |
 Topic  |
|
-gary
Development Team Member
406 Posts |
 Posted - 13 July 2005 : 18:03:53
|
But, this would appear to be the best place for this.
I've never seen any sort of ranking site like big-boards.com specifically for Snitz and there's always questions here about what constitutes a "big" Snitz install. So, I threw this together a ranking site that will pull stats from your forum via XML, store and then rank them against other Snitz forums.
I didn't put a lot of time into this since I don't have a lot of time to waste if no one is going to use it, so it is quite bare at this point. If there seems to be some interest, I'll work on an interface and other features.
Each site only gets checked once per day so the processing needed is trivial. Polling runs are once per hour, so if you submit your site it'll show up at the top of the next hour if all is well. There is very little error checking on the submit side, so please make sure you enter the info correctly.
You'll need the get the stats client and register your forum for polling. http://snitzhcd.com/stats/register.asp
Extract the snitzstats.asp file to your forum directory.
I would assume it works on any DB unless MySQL uses a different max and count routine, but I didn't bother checking.< |
KawiForums.com
 |
Edited by - -gary on 17 September 2005 13:47:50 |
|
|
muzishun
Senior Member
United States
1079 Posts |
Posted - 13 July 2005 : 21:00:07
|
Sounds like a nice thing to get going. On putting the file up on my site I noticed you're missing an "AS" on line 30.
strSql = "SELECT MAX(REPLY_ID) AS R_MAX, COUNT(REPLY_ID) AS R_ACTIVE FROM " & strTablePrefix & "REPLY"
I'll be submitting my site within the hour. I'd like to see what sort of interest there could be in this.< |
Bill Parrott
Senior Web Programmer, University of Kansas
Co-Owner and Code Monkey, Eternal Second Designs (www.eternalsecond.com)
Personal Website (www.chimericdream.com) |
 |
|
|
-gary
Development Team Member
406 Posts |
Posted - 13 July 2005 : 21:19:47
|
| I saw the missing AS after I posted. Thought I caught it before anyone downloaded.< |
KawiForums.com
|
|
|
|
sr_erick
Senior Member
USA
1318 Posts |
Posted - 13 July 2005 : 23:13:35
|
Kawiforums will be on top. Wait until this winter though and let the war begin.  < |
Erick
Snowmobile Fanatics
|
Edited by - sr_erick on 13 July 2005 23:14:05 |
|
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 14 July 2005 : 04:47:17
|
Nicely done, Gary  Will be submitting Woo.ie in short order. An idea for a future addition: You could show the date a forum was started by grabbing the timestamp of the first post made.
< |
 Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
Edited by - Shaggy on 14 July 2005 04:49:01 |
|
|
|
MarcelG
Retired Support Moderator
Netherlands
2625 Posts |
|
|
-gary
Development Team Member
406 Posts |
Posted - 14 July 2005 : 08:06:59
|
quote:
Originally posted by Shaggy
An idea for a future addition: You could show the date a forum was started by grabbing the timestamp of the first post made.
It's already in the XML. If this does work out, I'll make an about page where you can add info about your forum and it will include things like the first post date.< |
KawiForums.com
|
|
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 14 July 2005 : 08:32:32
|
Ay, spotted that when I cracked open the file. Hopefully, it'll work out so - great idea Gary, man.
< |
Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
|
|
|
-gary
Development Team Member
406 Posts |
Posted - 14 July 2005 : 09:40:28
|
I've noticed a few got a version with a missing AS statement. If you replace the stats file with the copy now linked in the first post you should work. The version in the file should be .02 just to be sure. The problem domains are listed below.
oxle.com
parrotlinks.com
ratdaddyvince.com< |
KawiForums.com
|
|
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 14 July 2005 : 09:47:48
|
Was that the only change to .02? The copy I downloaded this morning was .01 but apparently it's working OK as Woo.ie has been picked up by your script.
< |
Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
|
|
|
Davecl
Junior Member
United Kingdom
105 Posts |
Posted - 14 July 2005 : 09:58:11
|
wondered why it hadn't been picked up.
got new version now, thanks< |
Dave |
|
|
|
-gary
Development Team Member
406 Posts |
Posted - 14 July 2005 : 10:49:00
|
| The missing as was the only change, but I wanted to make sure someone isn't getting a cached copy since I didn't change the file name.< |
KawiForums.com
|
|
|
|
-gary
Development Team Member
406 Posts |
Posted - 14 July 2005 : 10:51:51
|
quote:
Originally posted by Davecl
wondered why it hadn't been picked up.
got new version now, thanks
Your's has the following at the beginning of the file causing it's parse to fail.
<!--INCLUDE FILE="LangMODS_Ls3kAU4_1030.asp" --><!--INCLUDE FILE="LangMODS_Ls3kAU4_1033.asp" --><!--INCLUDE FILE="LangMODS_Ls3kAU4_1034.asp" --><!--INCLUDE FILE="LangMODS_Ls3kAU4_1036.asp" --><!--INCLUDE FILE="LangMODS_Ls3kAU4_1037.asp" --><!--INCLUDE FILE="LangMODS_Ls3kAU4_1041.asp" --><!--INCLUDE FILE="LangMODS_Ls3kAU4_1043.asp" --><!--INCLUDE FILE="LangMODS_Ls3kAU4_1046.asp" --><!--INCLUDE FILE="LangMODS_Ls3kAU4_1053.asp" --><!--INCLUDE FILE="LangMODS_Ls3kAU4_2070.asp" -->< |
KawiForums.com
|
|
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 14 July 2005 : 11:11:50
|
Dave, what I did, because I using a highly modified config.asp, was copy the connection string (you'd also need the table prefixes) into snitzstats.asp and remove the config.asp include.
< |
Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
|
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 14 July 2005 : 11:37:02
|
Forgot to ask, Gary, how often does your script visit our sites? Also, is there a reason why you're pulling the counts individually from the TOPIC and REPLY tables rather than all at once from the TOTALS table?
< |
Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
|
|
|
sr_erick
Senior Member
USA
1318 Posts |
Posted - 14 July 2005 : 12:06:34
|
The totals table may not always be correct. Also here's what gary said about how often the script runs.
quote:
Each site only gets checked once per day so the processing needed is trivial. Polling runs are once per hour, so if you submit your site it'll show up at the top of the next hour if all is well.
< |
Erick
Snowmobile Fanatics
|
|
|
|
Topic |
|
Ranking Snitz sites - Not really a mod
