4 CommentsThe Chawlk Talk community. Come talk with us.
Chawlk Sponsors Get in touch if you want in.
bbPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND forum_level = 0 AND site_id = 2 AND post_time <= DATE_ADD(now(), INTERVAL 5 ' at line 1]
SELECT topic_id, COUNT(post_id) FROM bb_posts WHERE post_status = 0 AND forum_id = AND forum_level = 0 AND site_id = 2 AND post_time <= DATE_ADD(now(), INTERVAL 5 HOUR) AND post_time >= DATE_SUB(now(), INTERVAL 1 MONTH) GROUP BY topic_id ORDER BY COUNT(post_id) DESC LIMIT 10
Oli
Written Apr. 17, 2008 / Report /
Thanks for that Paul. I had no idea but having read that post, I'm still not sure what they're doing other than adding more "sources" to dilute down their toolbar results.
Popularity statistics are always flawed in some respect as everybody wants to outwardly seem successful and some are more than happy to abuse the data collection methods to appear more popular.
So while I can see the increase of data being an improvement, it also introduces more points of weakness and once people figure out where they're collecting this data from, it increases the scope for being able to game it.
Ollie
Written Apr. 17, 2008 / Report /
I jumped up 20k places 'overnight'. I guess that's a good thing, but as Oli says, these tools will always have some kind of flaw and therefore inaccuracy. Nice to see overall trends though, if you're going up anyway.
Ozone42
Written May. 2, 2008 / Report /
I just noticed a couple of my domains jumped way up in Alexa rankings.
What are these good for? One of the same domains lost 2 spots in google pagerank, but is now getting double the traffic it had (PR5 -> PR3).
superrats
Written May. 2, 2008 / Report /
Mine didn't change.
Hopefully their changes makes it a little more accurate.