[@ganzua Member 15 years, 10 months ago]

and remember to use $wpdb on WordPress pages, vs $bbdb on bbPress pages

I want to query $bbdb from a wp page. In particular, I want to fetch the total amount of views from your bb Topic Views plugin. This code didn’t work;

<?php

global $bbdb;

$results=$bbdb->get_results("SELECT SUM(meta_value) FROM bb_meta WHERE object_type='bb_topic' AND meta_key='views'");

$results=$bbdb->get_results($query);

?>

WordPress is installed in /wordpress/ and bbpress in /wordpress/bbpress/ both deep integrated. What’s missing?