Ranking Snitz sites - Not really a mod - نوشته شده در (8353 Views)
Development Team Member
-gary
مطلب: 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.<
 پیش‌فرض مرتب‌سازی برای تاریخ DESC به معنی جدیدترین است  
 تعداد در صفحه 
نوشته شده در
Senior Member
muzishun
مطلب: 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)
نوشته شده در
Development Team Member
-gary
مطلب: 406
406
I saw the missing AS after I posted. Thought I caught it before anyone downloaded.<
نوشته شده در
Senior Member
sr_erick
مطلب: 1318
1318
Kawiforums will be on top. Wait until this winter though and let the war begin. wink<
نوشته شده در
Support Moderator
Shaggy
مطلب: 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.”
نوشته شده در
Retired Support Moderator
MarcelG
مطلب: 2625
2625
Nice thought! bigsmile Submitted oxle.com right away!<
نوشته شده در
Development Team Member
-gary
مطلب: 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.<
نوشته شده در
Support Moderator
Shaggy
مطلب: 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.”
نوشته شده در
Development Team Member
-gary
مطلب: 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<
نوشته شده در
Support Moderator
Shaggy
مطلب: 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.”
نوشته شده در
Junior Member
Davecl
مطلب: 105
105
wondered why it hadn't been picked up.
got new version now, thanks<
Dave
شما باید یک متن وارد کنید