| Author |
 Topic  |
|
Shaggy
Support Moderator
Ireland
6780 Posts |
 Posted - 14 July 2005 : 12:20:04
|
 Oopsie, brain's switched off now that I have a few days holiday to look forward to! London, beware! 
< |
 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.” |
 |
|
|
dabugster
Junior Member
USA
168 Posts |
Posted - 14 July 2005 : 12:28:15
|
I redownloaded then uploaded the new version and resubmitted my site.
This is an awesome mod Gary.
A little healthy compitition never hurt nobody!
LOL
< |
|
|
|
Podge
Support Moderator
Ireland
3775 Posts |
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 14 July 2005 : 12:41:03
|
Not necessarily Podge, the forum and, therefore, the super admin may be created a long time before the forum's doors were opened to the public. Of course, if the super admin leaves the default posting that setup.asp places in the database, those dates are going to be the same, anyway.
< |
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 : 12:41:26
|
quote:
Originally posted by Shaggy
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?
I wanted to get the actual counts without relying on the totals table being updated correctly. I don't even use it on my forum as I write stats out to a dedicated table much like I'm using here. I couldn't exclude myself.  < |
KawiForums.com
 |
|
|
|
Podge
Support Moderator
Ireland
3775 Posts |
|
|
Davecl
Junior Member
United Kingdom
105 Posts |
Posted - 14 July 2005 : 13:26:09
|
quote:
Originally posted by Shaggy
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.
well, that seems complicated to me with my limited knowledge but luckily since getting version.02 my forum has been picked up so maybe i dont need to make any changes?< |
Dave |
|
|
|
-gary
Development Team Member
406 Posts |
Posted - 14 July 2005 : 14:50:30
|
quote:
Originally posted by Podge
[suggestion]
-gary, you could also include the average no. of posts per member on each forum & average posts per day [/suggestion]
If it looks like a worthwhile project, I'll do many different statistics. Right now, all I'm showing is the last pull of raw data. If I can find a decent graph object, things really get interesting since I'm storing a snapshot of your forum's data daily. Membership increases, post increase, members vs posts increase, post to reply ratios. I can think up more than I care to write.
quote:
Originally posted by Davecl
well, that seems complicated to me with my limited knowledge but luckily since getting version.02 my forum has been picked up so maybe i dont need to make any changes?
I noticed your's was still being dropped so I went ahead and modified the script to trim everything before the first <?xml out before parsing. Prob a good idea anyway in case any of the includes throw out some junk like blank lines or errors before the XML starts.< |
KawiForums.com
|
|
|
|
sr_erick
Senior Member
USA
1318 Posts |
Posted - 14 July 2005 : 15:09:20
|
| A day to day graph print out (line graph) of post totals would be completely awesome. Like compare the top 10 with different colors on the same chart.< |
Erick
Snowmobile Fanatics
|
Edited by - sr_erick on 14 July 2005 15:09:49 |
|
|
|
Davecl
Junior Member
United Kingdom
105 Posts |
Posted - 14 July 2005 : 15:10:11
|
thanks gary, i doubt if i would have been capable of the changes shaggy suggested  < |
Dave |
|
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 18 July 2005 : 07:25:49
|
Gary, just spotted something, it may be by design but I thought I'd point it out, just in case: It appears that the figure for S_TotalPosts is as a reult of adding S_MaxTopics and S_MaxReplies rather than S_ActiveTopics and S_ActiveReplies which could inaccurate results for some sites which may have a lot of deleted (or achived, in this version) posts for whatever reason.
Maybe you could make it a configurable for those who do keep their TOTALS table updated to have the script pull the counts from that table to save a couple of queries?
< |
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 - 18 July 2005 : 11:34:12
|
It's by design. The Total Posts is a measure of how many posts you've gotten and Active of how many are currently in the DB. The same is true for the members queries.
Myself, I could care less about what's current other than 24 hour and 30 day login/posting stats and I don't archive anything, just lock what's older than 6 months. On a large site, it's hard to sell advertising if you keep lowering your post counts every month by archiving and deleting. Advertisers want to see growth, not stagnant numbers or even a decline and your competitiveness with other larger sites.
As for saving a couple of queries, I don't see a need to produce different versions for a few quick DB hits that occur once every 24 hours.< |
KawiForums.com
|
|
|
|
MarkJH
Senior Member
United Kingdom
1722 Posts |
Posted - 18 July 2005 : 16:29:11
|
quote:
Originally posted by sr_erick
Kawiforums will be on top. Wait until this winter though and let the war begin. 
You were saying?
Great idea this, Gary. I look forward to seeing what you'll do with it if things take off.< |
Bandlink.net - http://www.bandlink.net/
Bandlink Music Forums - http://www.bandlink.net/forum/ |
|
|
|
MarkJH
Senior Member
United Kingdom
1722 Posts |
|
|
MarkJH
Senior Member
United Kingdom
1722 Posts |
|
|
Topic |
|
Ranking Snitz sites - Not really a mod
