PHPBB Popular Posts

This is an mysql query to get a list of the popular posts in phpbb. Created Because of http://communityadmins.com/activity-streams-on-your-community-vt3374.html

Version #1

SELECT * FROM `phpbb_topics` ORDER BY ABS( ( ( `phpbb_topics`.`topic_views` *-1 ) - (`phpbb_topics`.`topic_replies` *5 ) ) / ( `phpbb_topics`.`topic_time`) )

NOTE: replace

phpbb_topics

with your topics table.
NOTE To WordPress.Com: You should make it so that the sourcecode shortcode supports mysql 🙂

Advertisements