Ranking Snitz sites - Not really a mod - Postet den (8354 Views)
Development Team Member
-gary
Innlegg: 406
406
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.<
   
 Sidestørrelse 
Postet den
Senior Member
muzishun
Innlegg: 1079
1079
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.
Code:
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)
Postet den
Development Team Member
-gary
Innlegg: 406
406
I saw the missing AS after I posted. Thought I caught it before anyone downloaded.<
Postet den
Senior Member
sr_erick
Innlegg: 1318
1318
Kawiforums will be on top. Wait until this winter though and let the war begin. wink<
Postet den
Support Moderator
Shaggy
Innlegg: 6780
6780
Nicely done, Gary smile 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.”
Postet den
Retired Support Moderator
MarcelG
Innlegg: 2625
2625
Nice thought! bigsmile Submitted oxle.com right away!<
Postet den
Development Team Member
-gary
Innlegg: 406
406
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.<
Postet den
Support Moderator
Shaggy
Innlegg: 6780
6780
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.”
Postet den
Development Team Member
-gary
Innlegg: 406
406
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<
Postet den
Support Moderator
Shaggy
Innlegg: 6780
6780
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.”
Postet den
Junior Member
Davecl
Innlegg: 105
105
wondered why it hadn't been picked up.
got new version now, thanks<
Dave
Du må legge inn en melding