[dphs]

Hi,

There is an answer to this question posted a year ago, but when I open the header.php file from my bb-templates/kakumei folder all that is there is “>”. I tried adding the code there, but it deleted the header. Is it located in another place?

I’m using bbpress 0.9.0.4 and wordpress 2.7.1.

Thanks!

[_ck_]

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

You get nothing using get_results because it returns an array – use get_var instead

<?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;

?>

[ganzua]

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.

[ganzua]

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?

[djeelo]

Thanx a lot for your help dragunoff !

It’s indeed an easy css basics I think I’ll learn it one day …

I just add the .view one width because other rules break my Tags position…

Everything is fine now !

Thank you and have a nice evening !

bye!

djeelo

[maharzan]

using alpha 1.0 v 6.. is that the issue? and I would love to know the solution if any…

thanks.

[deadlyhifi]

(profile.php in theme folder)

My users were asking for the ability to jump to the last post on the ‘User Activity’ area within their profile page. So I amended the page to use tables like the favorites listings do with two columns >

TOPIC > DETAILS

topic name > You replied 2 weeks ago. No replies since.

<?php bb_get_header(); ?>



<h3 class="bbcrumb"><a href="<?php bb_uri(); ?>"><?php bb_option('name'); ?></a> &raquo; <?php _e('Profile') ?></h3>



<div class="vcard">



<?php if ( $avatar = bb_get_avatar( $user->ID ) ) : ?>

<div id="useravatar"><?php echo $avatar; ?></div>

<?php unset($avatar); endif; ?>

<h2 id="userlogin"><span class="fn"><?php echo get_user_display_name( $user->ID ); ?></span> <small>(<span class="nickname"><?php echo get_user_name( $user->ID ); ?></span>)</small></h2>



<?php if ( $updated ) : ?>

<div class="notice">

<p><?php _e('Profile updated'); ?>. <a href="<?php profile_tab_link( $user_id, 'edit' ); ?>"><?php _e('Edit again &raquo;'); ?></a></p>

</div>

<?php elseif ( $user_id == bb_get_current_user_info( 'id' ) ) : ?>

<p>

<?php _e('This is how your profile appears to a logged in member.'); ?>



<?php if (bb_current_user_can( 'edit_user', $user->ID )) : ?>

<?php printf(__('You may <a href="%1$s">edit this information</a>.'), attribute_escape( get_profile_tab_link( $user_id, 'edit' ) ) ); ?>

<?php endif; ?>

</p>



<?php if (bb_current_user_can( 'edit_favorites_of', $user->ID )) : ?>

<p><?php printf(__('You can also <a href="%1$s">manage your favorites</a> and subscribe to your favorites’ <a href="%2$s"><abbr title="Really Simple Syndication">RSS</abbr> feed</a>.'), attribute_escape( get_favorites_link() ), attribute_escape( get_favorites_rss_link() )); ?></p>

<?php endif; ?>

<?php endif; ?>



<?php bb_profile_data(); ?>



</div>



<h3 id="useractivity"><?php _e('User Activity') ?></h3>



<div id="user-replies" class="user-recent">

<h4><?php _e('Recent Replies'); ?></h4>



<?php if ( $posts ) : ?>



<table id="favorites">

<tr>

<th><?php _e('Topic'); ?></th>

<th><?php _e('Details'); ?></th>

</tr>



<?php foreach ($posts as $bb_post) : $topic = get_topic( $bb_post->topic_id ) ?>

<tr<?php alt_class('replies'); ?>>

<td><a href="<?php topic_link(); ?>"><?php topic_title(); ?></a></td>

<td class="num">

<a href="<?php topic_last_post_link(); ?>">

<?php if ( $user->ID == bb_get_current_user_info( 'id' ) ) printf(__('You replied %s ago.'), bb_get_post_time()); else printf(__('Latest reply %s ago.'), bb_get_post_time()); ?>

<span class="freshness"><?php

if ( bb_get_post_time( 'timestamp' ) < get_topic_time( 'timestamp' ) )

printf(__('Latest reply %s ago'), get_topic_time());

else

_e('No replies since.');

?></span>

</a>

</td>

</tr>

<?php endforeach; ?>

</table>



<?php else : if ( $page ) : ?>

<p><?php _e('No more replies.') ?></p>

<?php else : ?>

<p><?php _e('No replies yet.') ?></p>

<?php endif; endif; ?>



</div>



<div id="user-threads" class="user-recent">



<h4><?php _e('Topics Started') ?></h4>

<?php if ( $topics ) : ?>



<table id="favorites">

<tr>

<th><?php _e('Topic'); ?></th>

<th><?php _e('Details'); ?></th>

</tr>



<?php foreach ($topics as $topic) : ?>

<tr<?php alt_class('topics'); ?>>

<td><a href="<?php topic_link(); ?>"><?php topic_title(); ?></a></td>

<td class="num">

<a href="<?php topic_last_post_link(); ?>">

<?php printf(__('Started: %s ago.'), get_topic_start_time()); ?>

<span class="freshness"><?php

if ( get_topic_start_time( 'timestamp' ) < get_topic_time( 'timestamp' ) )

printf(__('Recent reply: %s ago.'), get_topic_time());

else

_e('No replies.');

?></span>

</a>

</td>

</tr>

<?php endforeach; ?>

</table>



<?php else : if ( $page ) : ?>

<p><?php _e('No more topics posted.') ?></p>

<?php else : ?>

<p><?php _e('No topics posted yet.') ?></p>

<?php endif; endif;?>

</div>



<div class="nav">

<?php profile_pages(); ?>

</div>



<?php bb_get_footer(); ?>

[Ipstenu (Mika Epstein)]

Wait … I remember that issue. Or something like it… It was in 1.0alpha3 or 4 I think, around the time that quotes in links broke things.

[chrishajer]

What version bbPress are you using? Is it integrated with WordPress, and if so, what version? Are you using a language file other than English?

[maharzan]

Example, instead of this,

if($slideshow == "On" && $slideshow_status == "Static")

it renders this…

if($slideshow == "On" && $slideshow_status == "Static")

[maharzan]

Okay, have been searching google and this forum for long time and find there is no occurrences of it.. not even mention of it. So, wanted to ask everyone out here if they know what is happening..

I am using double quotes in the code and trying to paste the code within backticks and while everything looks okay few html characters are rendering their ASCII code or something (html escape characters ??)

For example,

double quotes ( ” ) are rendered as &q uot;

ampersands ( & ) are rendered as &a mp;

ignore the spaces. I have disabled all the plugins, switched themes and looked over everything, but I still can’t figure out what is causing this. I saw several forums including bbpressshowcase which suffers from same problem. I don’t see that problem here in this forum.

Can anyone shed some light for me?

Thanks for all your help.

[Thad Allender]

When I post code samples in my bbPress install, all quote marks show up like this:

"

This includes when I use backticks and/or buttons. Neither work.

For instance, when I post this code:

<div class="box">This is a box</div>

It becomes:

<div class=&quot;box&quot;>This is a box</div>

I am using the beta version of bbPress with WordPress integration. I have deactivate all plugins and switched themes, so I know it is a problem with my bbPress code.

Thoughts?

[code] buttons. Neither work.

For instance, when I post this code:

<div class="box">This is a box</div>

It becomes:

<div class=&quot;box&quot;>This is a box</div>

I am using the beta version of bbPress with WordPress integration. I have deactivate all plugins and switched themes, so I know it is a problem with my bbPress code.

Thoughts?

[_ck_]

I’ve never seen or even heard of a forum with reply by email.

In theory this could be done via a unique key sent with every message to the reader.

But writing code to download and process email replies would be tricky.

Since bbPress 1.0 will have trackbacks for topics, this might open another avenue.

This kinda defeats the whole idea of a forum though, allowing people to stay away from the site entirely.

[_ck_]

That’s a good hack Ann but keep in mind insert_id isn’t always reliable.

[Ivaylo Draganov]

Hello,

It is a pure CSS problem and very easy to fix – just add widths to the columns. And the problem is mostly in the column which holds the titles. So, try something like this:

td.text { width: 63%; padding-left: 2%; }

td.info { width: 20%; }

td.view { width: 15%; }

All the widths add up to 100%. You can also skip the last rule (for .view) as it will automatically fill the remaining space (in most browsers I believe).

and drop the first column altogether ( .watcher ) if you are using it only for spacing.

[anandsrinivasan]

Is there a ‘for dummies’ version of the same. I am programming-handicapped and can understand nothing of what is been discussed here, though I too want to achieve the same thing

Thanks

[david11]

WordPress

|—- BBpress

aka :-

massbase

|

---

/community

|

---

/bbpress inside here

|

---

/rest of wp’s files..

wordpress is on the root and bbpress isin a folder called /community

http://www.massbase.com/community

im resintalling it all now, all same versions.

[_ck_]

Yes you still need to fill the bbPress/WP user table (many plugins also refer to it directly).

All you are replacing is authentication.

You can write a plugin to auto-fill the user table when a newly authenticated user first tries to see a bbPress page. Actually it could go into the authentication code directly.

[ewonk]

if (file_exists(‘../wp-blog-header.php’))

require_once(‘../wp-blog-header.php’);

^That line of code causes a lot of stress on my bluehost site. With that code active, I get “This Account Has Exceeded Its CPU Quota” all the time, deeming my site unusable.

Is there another way to have the bb-config find the wp-blog-header? Everytime the server has to search for it, it takes fooooorever, which also slows down the rest of the site, then I get suspended by bluehost and can’t access anything.

It’s weird though, because this code will slow up the rest of the site that isn’t even using the bb-config. I’ll load up mydomain.com and it’ll go soooo slowly while that code is active – this, even though my bbpress config is way over there at mydomain.com/forums. If I comment that code out, everything is fast and zippy.

WP 2.7

BB 0.9

[Ivaylo Draganov]

Hello

I noticed that Bulgarian translation is quite out of date so with a friend we made an update. It is available here:

bbPress 0.9 in Bulgarian

[sumit1988]

On Linux, well, if you have that I don’t need to tell you what you have.

so true!

[_ck_]

View counts in the forum section require part of “my-views” plugin to be installed (my-views-most-least-views.php) or just make this a mini-plugin:

add_filter('get_forums','forums_views_append');

function forums_views_append($forums) {

if (is_front() || is_forum()) {

global $bbdb, $forums_views; $sum_meta_value="SUM(meta_value)";

if (!isset($forums_views)) {

$forums_views = $bbdb->get_results("SELECT DISTINCT forum_id, $sum_meta_value FROM $bbdb->topicmeta LEFT JOIN $bbdb->topics ON $bbdb->topicmeta.topic_id = $bbdb->topics.topic_id  WHERE $bbdb->topics.topic_status=0 AND $bbdb->topicmeta.meta_key='views'  GROUP BY $bbdb->topics.forum_id");

} foreach ($forums_views as $forum_views) {

if ($forum_views->forum_id) {$forums[$forum_views->forum_id]->views=$forum_views->$sum_meta_value;}

}

}

return $forums;

}

[Stefano Aglietti]

I soved the problem of logn request on paginated topics using the EWp plugin mentioned here:

https://bbpress.org/forums/topic/wordpress-and-bbpress-integration-101/page/5#post-24571

I can’t understand why with normal integration the whole system didn’t work… but I have no time to investigate for a non payed task The customer have the same problem of quote adn double-quote double escaping thamentioned in the same link…

This topic can be considered closed.

[patrick10128]

Unbelievable. I was able to figure out what the problem was. WP-Super-Cache plugin was screwing everything up. All I did was add /forum/ to the URI strings to be ignored and it worked fine.

Now it’s time to fix up the theme.

Thanks for all the responses

[Billy Wilcosky]

I hate it when something so easy is giving me problems. I have a link to my search page… mysite.com/myforum/search.php… like that. And it works fine, except the font color on the search form itself is a gray or reddish color and it doesn’t go with my dark blue layout… I need the font to be white. With CSS I’ve got the font set to white everywhere else, even the search results are white, but the form itself is not so you can barely read it.

I’ve tried editing the color with CSS, regular html, I’ve been in my search.php in my forum root and my search.php in my template, and I’ve been in my search-form.php file, and no matter what I do… I can only get the font to change in firefox… for some reason in ie6, which should be illegal to use, the font it not white.

I simply added <font color=”white”></font> to the form, and again, it works in firefox, but when I test it with ie6 it doesn’t work. Why?

I even tried adding a new div… I added <div id=”searchcolor”>search form code here</div> then in my CSS file I have #searchcolor {color:white;}, but even that doesn’t work. Nothing seems to change the form font color in ie6.

This is frustrating because it’s something SO simple! Font color!