Would like to add a new parameter to cpm_formatStats.
How can we have it include total votes?
Quote from: Gephri on July 09, 2007, 11:03:15 PM
Would like to add a new parameter to cpm_formatStats.
How can we have it include total votes?
As in total votes in the entire system?
hi vuud:
Yes - as in 12,234 votes have been placed for all public images (not the average)
hi vuud - any thoughts on how to accomplish this...?
Quote from: Gephri on September 02, 2007, 07:24:31 PM
hi vuud - any thoughts on how to accomplish this...?
It would be pretty simple to craft your own SQL code to sum up the votes I think... Its not something cpmfetch will do - or at least not in an efficent way.
You could probably code it to return the data for every photo in the system, then go through and total up the votes and get your sum. But that would be so hideously bad that on a system with a good number of photos it would bog out.
Your best bet right now is to code your own sql call...
Thanks for giving this some thought vuud - I was thinking it might be as simple as getting Total Views or Total Comments.
But if your coding idea is the way to get the info - I'm with you on not wanting to bog down the system.