I've got intergration happening with shared login/registrations, tables in same DB.

Thanks for any help :)

<?php if ( $topic ) : ?>
    <h2>Forum List</h2>
    <ul>
    <?php
    global $bbdb;
    $query="SELECT * FROM bb_forums WHERE topics!=0 ORDER BY forum_order ASC LIMIT 10";
    $results=$bbdb->get_results($query);
    foreach ($results as $result) {
    echo "<li><a href='/forum.php?id=".$result->forum_id."'>".$result->forum_name."</a></li>";
    }
    ?>
    </ul>
    <?php endif; ?>

*post title*
Posted by: *user* in *forum*.

or send it to me - procka@tasty.sk

greets
Vlado

http://bbpress.org/forums/topic/wordpress-integration-login#post-55751

The correct way to do it directly would be to either use the topic table which has the topic_poster_name (not bb_posts) or to use a LEFT JOIN on the user table to fetch the user_login.

The LEFT JOIN will also get you the display name.

But there are several problems with your question.
First of all, you mean Display Name, not Nice Name, unless you are trying to use it in a way I don't understand.

Secondly 0.9 doesn't use Display Name.

Third,
"SELECT * FROM bb_posts WHERE topic_id=$topic_id AND post_id != $first_reply_id AND post_status=0 ORDER BY post_time DESC"

is a very inefficient query, there's no LIMIT, you are using *
what exactly are you trying to find?

get_post_author($result->post_id);

Could find in:

http://phpxref.ftwr.co.uk/bbpress/nav.html?_functions/index.html

Is this the right function for this version?


// REPLIES
$query_replies="SELECT * FROM bb_posts WHERE topic_id=$topic_id AND post_id != $first_reply_id AND post_status=0 ORDER BY post_time DESC";
$results_replies=$wpdb->get_results($query_replies);
$replies_text = "";

foreach ($results_replies as $result) {
echo $result->post_text;
echo $result->topic_poster_name;
}


The post_text works perfectly, but the poster_name returns me nothing. Any idea?

http://justinvincent.com/docs/ezsql/ez_sql_help.htm

I just realized I completely missed explaining how to get forum names via WordPress, I was telling people to use bbPress functions which is of course impossible from WordPress. Let me know if anyone still needs the help.

thanks in advance

ernesto

global $wpdb;
$result=$wpdb->get_var("SELECT COUNT(*) FROM bb_posts WHERE poster_id = $user_id AND post_status = 0");
echo $result;

No errors though. I tried replacing poster_id with wp comment_author_id but it didn't make it.

What I was trying to do is to put the the whole count of wp comments and bbpress posts all together.

The previous question was because I produced a hit counter that runs for both; wp and bbpress. I added the total hits of the bbpress post views plugin to the wp counterize plugin. It works but I think I did this by the hard way.

Must have something to do with backpress which re-uses wp functions.

That is with bbPress 1.0 right? the object_type is for 1.0

Yes, it is bb 1.06a with wp 2.7 :)

I tried with get_var and I get the same error for get_var;

Fatal error: Call to a member function get_var() on a non-object in....

but then I changed $bbdb for $wpdb and it works. Why? I don't understand this.

<?php
global $bbdb;
$result=$bbdb->get_var("SELECT SUM(meta_value) FROM bb_meta WHERE object_type='bb_topic' AND meta_key='views'");
echo $result;
?>

I need more info than "didn't work"

Fatal error: Call to a member function get_results() on a non-object in wordpress/wp-content/themes/mytheme/header.php on line 149 (line where I placed the code)

Try replacing $bbdb with $wpdb

no error but what I want is to query bbpress data base. Whenever I echo $results there is no answer.

Try replacing $bbdb with $wpdb