[tian94]

Hi guys my website has a forum called. “Characters and creatures”, at the moment when I post the short code to display the forum the default is “Forum” how can I get it to grab what the forum category is use that as the name instead. Thanks!

http://postimg.org/image/xa5mh7z9d/

[Schoelje]

[Warning]: DO NOT DO THIS ON A PRODUCTION DATABASE!
My apologies for the caps, but this is really important 😉

[Assumptions]: Debian/Ubuntu developmachine with phpMyAdmin.

[Note]: Obviously I haven’t tested all Apache/MySql versions. This was done on SolydK (Debian Jessie). It is also not perfect. So, if somebody can improve on the code. Please, let me know.

After you’ve setup a development machine, imported the phpBB data and checked that everything is working fine, you still need to convert the phpBB internal links like “viewtopic.php?p=####” or “viewtopic.php?t=####” to the slugs that are being used by bbPress.

Let’s start!

1) First you’ll need to install and compile lib_mysqludf_preg.
Create a bash file install_preg.sh with this content:

#!/bin/bash
apt-get update
apt-get install libpcre3-dev libmysqlclient-dev build-essential libmysqld-dev libpcre3-dev
wget https://github.com/mysqludf/lib_mysqludf_preg/archive/testing.zip
unzip testing.zip
cd lib_mysqludf_preg-testing
./configure
make  install
make MYSQL="mysql -p" installdb
service mysql restart

Make it executable:
chmod +x install_preg.sh

And run it:
./install_preg.sh

2) Install the stored procedures.
In phpMyAdmin, select the database and the SQL tab.
Paste the following codes separately, creating three stored procedures on your database:

DELIMITER $$
CREATE PROCEDURE sp_cleanup_replies()
BEGIN
  -- declare cursor for reply url change
  DECLARE reply_cursor CURSOR FOR 
  SELECT DISTINCT old_post_id, REPLACE(<code>xkcom_posts</code>.<code>guid</code>, 'http://yoursite.com', '') AS new_url
  FROM (SELECT CAST(CONVERT(PREG_CAPTURE('/#p([0-9]+)/i', <code>post_content</code>, 1) USING UTF8) AS UNSIGNED) AS old_post_id FROM <code>xkcom_posts</code>) AS t1
  INNER JOIN <code>xkcom_postmeta</code> ON <code>xkcom_postmeta</code>.<code>meta_value</code> = old_post_id
  INNER JOIN <code>xkcom_posts</code> ON <code>xkcom_posts</code>.<code>ID</code> = <code>xkcom_postmeta</code>.<code>post_id</code>
  WHERE <code>xkcom_postmeta</code>.<code>meta_key</code> = '_bbp_old_reply_id'
  AND old_post_id IS NOT NULL
  ORDER BY old_post_id DESC;
  
  SELECT 'sp_cleanup_replies: START';
  
  -- Change posts
  OPEN reply_cursor;
  BEGIN
    DECLARE old_reply_id MEDIUMINT;
    DECLARE new_url VARCHAR(255);
    DECLARE search_string VARCHAR(255);
    DECLARE done INT DEFAULT FALSE;
    DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;

    read_loop: LOOP
      FETCH reply_cursor INTO old_reply_id, new_url;
      IF done THEN
	LEAVE read_loop;
      END IF;
      
      SET search_string = CONCAT('|[a-z0-9\.\-:\/&=\?\+]+#p', old_reply_id, '|i');
      SELECT CONCAT('sp_cleanup_replies: replace ', search_string, CONCAT(' with ', new_url));
      
      -- Uncomment the following line if you want to test the regexp
      -- SELECT CONVERT(PREG_REPLACE(search_string, new_url, <code>post_content</code>) USING UTF8) FROM <code>xkcom_posts</code> WHERE INSTR(<code>post_content</code>, CONCAT('#p', old_reply_id)) > 0; LEAVE read_loop;
      
      UPDATE <code>xkcom_posts</code> SET <code>post_content</code>= CONVERT(PREG_REPLACE(search_string, new_url, <code>post_content</code>) USING UTF8) WHERE INSTR(<code>post_content</code>, CONCAT('#p', old_reply_id)) > 0;
    
    END LOOP;
  END;
  CLOSE reply_cursor;
  
  SELECT 'sp_cleanup_replies: DONE';
  
END$$
DELIMITER ;

DELIMITER $$
CREATE PROCEDURE sp_cleanup_topics()
BEGIN 
  -- declare cursor for topic url change
  DECLARE topic_cursor CURSOR FOR 
  SELECT DISTINCT old_topic_id, REPLACE(<code>xkcom_posts</code>.<code>guid</code>, 'http://yoursite.com', '') AS new_url
  FROM (SELECT CAST(CONVERT(PREG_CAPTURE('/t=([0-9]+)/i', <code>post_content</code>, 1) USING UTF8) AS UNSIGNED) AS old_topic_id FROM <code>xkcom_posts</code>) AS t1
  INNER JOIN <code>xkcom_postmeta</code> ON <code>xkcom_postmeta</code>.<code>meta_value</code> = old_topic_id
  INNER JOIN <code>xkcom_posts</code> ON <code>xkcom_posts</code>.<code>ID</code> = <code>xkcom_postmeta</code>.<code>post_id</code>
  WHERE <code>xkcom_postmeta</code>.<code>meta_key</code> = '_bbp_old_topic_id'
  AND old_topic_id IS NOT NULL
  ORDER BY old_topic_id DESC;
  
  SELECT 'sp_cleanup_topics: START';
  
  -- Change topics
  OPEN topic_cursor;
  BEGIN
    DECLARE old_topic_id MEDIUMINT;
    DECLARE new_url VARCHAR(255);
    DECLARE search_string VARCHAR(255);
    DECLARE done INT DEFAULT FALSE;
    DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;

    read_loop: LOOP
      FETCH topic_cursor INTO old_topic_id, new_url;
      IF done THEN
	LEAVE read_loop;
      END IF;
      
      SET search_string = CONCAT('|[a-z0-9\.\-:\/&=\?\+]+t=', old_topic_id, '|i');
      SELECT CONCAT('sp_cleanup_topics: replace ', search_string, CONCAT(' with ', new_url));
      
      -- Uncomment the following line if you want to test the regexp
      -- SELECT CONVERT(PREG_REPLACE(search_string, new_url, <code>post_content</code>) USING UTF8) FROM <code>xkcom_posts</code> WHERE INSTR(<code>post_content</code>, CONCAT('t=', old_topic_id)) > 0; LEAVE read_loop;
      
      UPDATE <code>xkcom_posts</code> SET <code>post_content</code>= CONVERT(PREG_REPLACE(search_string, new_url, <code>post_content</code>) USING UTF8) WHERE INSTR(<code>post_content</code>, CONCAT('t=', old_topic_id)) > 0;

    END LOOP;
  END;
  CLOSE topic_cursor;
  
  SELECT 'sp_cleanup_topics: DONE';
  
END$$
DELIMITER ;

DELIMITER $$
CREATE PROCEDURE sp_cleanup_missing()
BEGIN
  -- declare cursor for reply url change
  DECLARE missing_cursor CURSOR FOR 
  SELECT DISTINCT old_post_id
  FROM (SELECT CAST(CONVERT(PREG_CAPTURE('|/&[a-z0-9=\+]+#p([0-9]+)|i', <code>post_content</code>, 1) USING UTF8) AS UNSIGNED) AS old_post_id FROM <code>xkcom_posts</code>) AS t1
  WHERE old_post_id IS NOT NULL
  ORDER BY old_post_id DESC;
  
  SELECT 'sp_cleanup_missing: START';
  
  -- Change posts
  OPEN missing_cursor;
  BEGIN
    DECLARE missing_reply_id MEDIUMINT;
    DECLARE search_string VARCHAR(255);
    DECLARE done INT DEFAULT FALSE;
    DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;

    read_loop: LOOP
      FETCH missing_cursor INTO missing_reply_id;
      IF done THEN
	LEAVE read_loop;
      END IF;
      
      SET search_string = CONCAT('|[a-z0-9&=\+]+#p', missing_reply_id, '|i');
      SELECT CONCAT('sp_cleanup_missing: remove ', search_string);
      
      -- Uncomment the following line if you want to test the regexp
      -- SELECT CONVERT(PREG_REPLACE(search_string, '#', <code>post_content</code>) USING UTF8) FROM <code>xkcom_posts</code> WHERE INSTR(<code>post_content</code>, CONCAT('#p', missing_reply_id)) > 0; LEAVE read_loop;
      
      UPDATE <code>xkcom_posts</code> SET <code>post_content</code>= CONVERT(PREG_REPLACE(search_string, '#', <code>post_content</code>) USING UTF8) WHERE INSTR(<code>post_content</code>, CONCAT('#p', missing_reply_id)) > 0;
    
    END LOOP;
  END;
  CLOSE missing_cursor;
  
  SELECT 'sp_cleanup_missing: DONE';
  
END$$
DELIMITER ;

3) Run the stored procedures from terminal.
It is important that you check some example posts with links that need to change. First the post links like “viewtopic.php?some_parameters#p#####”, then topic links like “viewtopic.php?some_parameters&t=#####” and lastly the links to missing posts are removed.

mysql -u root -p -e 'CALL sp_cleanup_replies()' my_database

mysql -u root -p -e 'CALL sp_cleanup_topics()' my_database

mysql -u root -p -e 'CALL sp_cleanup_missing()' my_database

Now, check your posts and when you’re happy you can drop the stored procedures:

DROP PROCEDURE IF EXISTS sp_cleanup_replies;
DROP PROCEDURE IF EXISTS sp_cleanup_topics;
DROP PROCEDURE IF EXISTS sp_cleanup_missing;

Mod note: edited and changed dev site from contributer to yoursite.com

[Robkk]

The files from the bbpress folder can work in a theme folder called bbpress, and also could be at the root of the theme, its just recommended to keep things neat.

It should be any bbP Default theme package template files in the “bbpress” folder that should also be in a “bbpress” folder, 1 css file should go in a css folder or 2 if you read right to left, and you can customize the javascript files in the js folder by putting it in a js folder in your child theme.

The files in the extras folder (they are examples for other themes, but should work for some WordPress default theme, I think Twentytwelve?) and these should be in the root of your theme, with the bbpress.php file.

[blinkix]

Hello guys
I work on a wp website with Avada themes and in a part a the website i using a forum with BBpress and BuddyPress.
But i’m using category in a other part of the website and when i fix permalink in other things than default setting the categoy don’t work…
What could i do ?

[Robkk]

THe edit link goes away for participants after the alotted time in Settings > Forums.

Other than that, there might be a php function that could filter the admin links for it to not appear at all, maybe check your theme for that if possible, by switching to a default theme temporarily.

[Robkk]

@mica123

I already replied to your topic here about the bbpress.php file in your theme. As for the bbP Default theme package template files in bbPress, there were no changes from 2.5.8 to 2.5.9, 2.5.9 was mainly an update to a security issue involving at-mention functionality.

In the future when the release of 2.6 happens, you would have to edit some files. It would be quite easy to

1. compare the new 2.6 templates and compare them to your modified files
2. make those changes to a copy of the 2.6 templates
3. test them to see if everything is in working order in a testing environment
4. update to bbPress 2.6 on your main production site (after taking a backup of course)
5. and then push the template files to your child theme using FTP

As for the text editor issue above from the other user, I think they just modified their footer.php file in their theme and accidentally removed <?php wp_footer(); ?>, and then that screwed up all the scripts and styles hooked into the footer.

[rblea24]

Thanks Robin! I did it all at one time time so maybe that’s why it didnt work. Which ones should I do and in what order?

Recalculate the parent topic for each post
Recalculate the parent forum for each post
Recalculate private and hidden forums
Recalculate last activity in each topic and forum
Recalculate the sticky relationship of each topic
Recalculate the position of each reply
Repair BuddyPress Group Forum relationships
Count topics in each forum
Count replies in each forum
Count replies in each topic
Count voices in each topic
Count spammed & trashed replies in each topic
Count topics for each user
Count replies for each user
Remove trashed topics from user favorites
Remove trashed topics from user subscriptions
Remove trashed forums from user subscriptions
Remap existing users to default forum roles

Thanks again!
Blake

[jamesburden]

Thanks for your answer Robin. Maybe I wasn’t clear enough though. I’m fully aware how to enforce strong passwords. I’ve got force-strong-passwords installed as a default plugin (I host with WPEngine and it’s an MU plugin). The issue is that these solutions don’t seem to work within the bbPress environment. Or at least in the configuration that I’m running (using WOffice to facilitate an extranet).

I’ve also tried enforcing strong passwords by using iThemes security options (both in conjunction and separately from force-strong-passwords). And that doesn’t work either.

I’m wondering if someone else has had a similar problem and can point me towards a possible solution.

Thanks

[Robin W]

bbPress is tested with wordpress default themes. It maybe a conflict – you need to check plugins and themes

It could be a theme or plugin issue

Plugins

Deactivate all but bbpress and see if this fixes. if it does, re-enable one at a time to see which is causing the error.

Themes

If plugins don’t pinpoint the problem, as a test switch to a default theme such as twentyfifteen, and see if this fixes.

Then come back

[Robin W]

ok, so you don’t have private groups and the error is not the same error as the issue above apart from the first 9 words which are generic 🙂

sorry this is a totally different issue.

bbPress is tested with wordpress default themes. It maybe a conflict – you need to check plugins and themes

It could be a theme or plugin issue

Plugins

Deactivate all but bbpress and see if this fixes. if it does, re-enable one at a time to see which is causing the error.

Themes

If plugins don’t pinpoint the problem, as a test switch to a default theme such as twentyfifteen, and see if this fixes.

[giobby]

After further investigations I’ve found a workaround that should work.

Just to recap on the error: it seems like several posts are left with the old phpBB poster id rather than using the new wordpress user_id (which really makes me think that somewhere in the converter code a wrong reference has been used).

The best way to work around the issue is the following (assuming a fresh installation):

1) before migration
– check what is the highest user_id in your phpBB installation (e.g.: 6235)
– insert a dummy row in wp_users with id grater than that (e.g.: 6236, or even better, round it up to 10000). In this way all the converted users will have their IDs starting from a higher value (e.g.: 10001, 10002, …) and it will be easy to spot the posts with wrong author (e.g. post_author < 10000).

2) launch migration as usual
3) after migration, create a temporary table that lists all the bbpress posts with wrong author

/* Get all posts with wrong author and correspondent right author from bbpress translator table */
create table TMP_ORPHANS as
select 
wp_posts.ID, 
wp_posts.post_author,
wp_bbp_converter_translator.value_id real_author, 
IFNULL(wp_posts.post_date, NULL) post_date,
IFNULL(wp_posts.post_date_gmt, NULL) post_date_gmt,
wp_posts.post_content, 
CASE 
	WHEN wp_posts.post_type = 'reply'
    THEN (SELECT tmposts.post_title from wp_posts as tmposts where tmposts.id = wp_posts.post_parent)
    ELSE wp_posts.post_title
END post_title, 
wp_posts.post_excerpt, 
pescasubac, 
wp_posts.quea.wp_posts.post_status, 
wp_posts.comment_status, 
wp_posts.ping_status, 
wp_posts.post_password, 
wp_posts.post_name, 
wp_posts.to_ping, 
wp_posts.pinged, 
IFNULL(wp_posts.post_modified, NULL) post_modified,
IFNULL(wp_posts.post_modified_gmt, NULL) post_modified_gmt,
wp_posts.post_content_filtered, 
wp_posts.post_parent, 
wp_posts.guid, 
wp_posts.menu_order, 
wp_posts.post_type, 
wp_posts.post_mime_type, 
wp_posts.comment_count,
	(	select wp_postmeta.meta_value 
		from wp_postmeta 
		where 
			wp_postmeta.meta_key = '_bbp_author_ip' and 
			wp_postmeta.post_id = wp_posts.id
	) user_ip
from wp_posts 
left join wp_users on wp_posts.post_author = wp_users.id
left join wp_bbp_converter_translator on wp_posts.post_author = wp_bbp_converter_translator.meta_value
where 
wp_posts.post_type in ('forum', 'reply', 'topic') and
(wp_users.id is null or 
wp_users.id = 1) and /* all posts of type forum looks to be assigned to the site admin (id=1 in my case)*/
wp_bbp_converter_translator.value_type = 'user' and 
wp_bbp_converter_translator.meta_key = '_bbp_old_user_id';

/* this is to be able to create indexes later */
ALTER TABLE TMP_ORPHANS modify column post_date datetime default NULL;
ALTER TABLE TMP_ORPHANS modify column post_date_gmt datetime default NULL;
ALTER TABLE TMP_ORPHANS modify column post_modified datetime default NULL;
ALTER TABLE TMP_ORPHANS modify column post_modified_gmt datetime default NULL;
ALTER TABLE TMP_ORPHANS modify column user_ip varchar(40);
ALTER TABLE TMP_ORPHANS modify column post_title varchar(255);

/* indexes to speed up access to the table (some are useless) */
ALTER TABLE TMP_ORPHANS ADD INDEX(post_date);
ALTER TABLE TMP_ORPHANS ADD INDEX(post_author);
ALTER TABLE TMP_ORPHANS ADD INDEX(real_author);
ALTER TABLE TMP_ORPHANS ADD INDEX(user_ip);
ALTER TABLE TMP_ORPHANS ADD INDEX(post_title);

4) Now that you’ve got the list of posts with wrong authors, you can update your wp_posts table accordingly

/* Revert bad authors to good authors */
UPDATE 
wp_postsINNER JOIN TMP_ORPHANS 
ON wp_posts.id = TMP_ORPHANS.id
set wp_posts.post_author = TMP_ORPHANS.real_author 
where wp_posts.post_type in ('reply', 'topic') ;

Final consideration:
– this workaround seems to be working for me, but of course I don’t assume any responsibility in case it doesn’t work for you. The update trusts the converter table generated by the bbpress forum converter and assumes that a wrong author id matches the original author id of phpBB forum (I executed some checks and it seems like the problem is always the same = phpBB author id rather than new wordpress author id).
– the update doesn’t fix posts of type ‘forum’ because by default these are assigned to the wordpress site administrator. If you wish to assign them to the original phpBB author, just modify the where condition:
where wp_posts.post_type in ('forum','reply', 'topic') ;

message to the developers: I truly believe somewhere in the converter code a wrong reference is used under certain conditions. The pattern of the error is always the same: when the author doesn’t match it’s because the author id of the phpBB forum rather than the new converted author id.

@netweb

[Robin W]

ok, thanks – sorry it’s sometimes hard to understand the obvious until you see it !

so I’m presuming that there should be some content to that post?!

bbPress is tested with wordpress default themes. It maybe a conflict – you need to check plugins and themes

It could be a theme or plugin issue

Plugins

Deactivate all but bbpress and see if this fixes. if it does, re-enable one at a time to see which is causing the error.

Themes

If plugins don’t pinpoint the problem, as a test switch to a default theme such as twentyfifteen, and see if this fixes.

[Robin W]

bbPress is tested with wordpress default themes. It maybe a conflict – you need to check plugins and themes

It could be a theme or plugin issue

Plugins

Deactivate all but bbpress and see if this fixes. if it does, re-enable one at a time to see which is causing the error.

Themes

If plugins don’t pinpoint the problem, as a test switch to a default theme such as twentyfifteen, and see if this fixes.

[Robkk]

1. Its the WordPress Toolbar, used on all WordPress sites by default.

2. This plugin adds avatar suggestions, it might not be presented easily for users, but he expains it in this video.

3. bbPress by default doesn’t have the ability to upload files, for avatars that plugin I mentioned allows avatar upload.

4. You can filter the default wordPress smilies and use custom ones, their is emoji to use because of WordPress, also there a good plugin that has a feature to import phpBB smilies call WP-Monalisa.

[Robkk]

Also, even after the plug in is deleted the roles (Keymaster and Participant) still appear in the user list under the “Role” column, but I thought they were only associated with bbpress. Is that correct?

This is a known bug, there is some code in the codex here to use to remove the user roles whenever you are resetting your user roles. Removing the roles and reinstalling bbPress might fix this issue, if it does not, you can use this plugin to switch to another Admin temporarily and then edit your user and switch its forum role. Make sure to edit the user by clicking the edit link by the users avatar. I think there is still an issue bulk changing a users forum role from the users list.

https://wordpress.org/plugins/user-switching/

Make sure that your default role for users are Participant in Settings > Forums. Also make sure that the default blog role for your users is Subscriber in Settings > General.

If this developer only did a short job and is done, I recommend not keeping their account as Admin/Keymaster. If they are hired for a project that is not finished or is like say doing maintenance for your site for awhile, okay keep them, but you know just be cautious since this happened to your site.

Just to be sure, make sure to check out this link for more help.
https://codex.wordpress.org/FAQ_My_site_was_hacked

[kavehmovahedi]

Hi,
I have the latest version of wordpress running (4.5.2) and latest version of bbPress.
Everything was working just fine before i moved my host from windows to Linux server.
Now i can see the forums and topics in each forum. but when i open a topic the content and replies are not shown in the pages, only the reply form shows up.
I can see the replies in the admin panel but clicking view from back end opens the front end reply to … without the reply content.

I have already tried these :
1) disabling all other plugins
2) switching to wordpress default themes
3) creating a new page with bbPress shortcode
4) copying the php code provided in other forums
5) removing and re-installing bbPress

it’s driving me crazy ! i have tried all 2 links on google’s 2 first pages for search results of “bbPress content not showing up”, “bbPress topic content not showing”, “bbPress replies not shown”,…

Best Regards,
Kaveh

[Robkk]

Where exactly in the forums do you want to display this.

In the default description area this might be a little too much for the default layout in bbPress. I say hire a designer and make the forum page title for each forum display nice and gold like how it is displayed, use the same font you chose to style the forum titles in bbPress (maybe in topic titles too for consistency), and keep the description similar to how you have it and just style it in bbPress using CSS. You might have to have heavily style and customize the bbPress templates to achieve a good looking layout like this. Place any bbPress templates in your child theme or custom made theme so they can easily be customized.

https://codex.bbpress.org/themes/theme-compatibility/

[Yossi Aharon]

Hello,
I want to migrate phpBB forum to bbPress. I use the default import tool of bbPress, I was able to migrate it successfully but the only problem is the author name shown as Anonymous in almost all topics. When I chose to import the users, the topics shown with the correct users besides the users in Hebrew that converted automatically to numbers and shown as Anonymous and that’s because WordPress doesn’t support Hebrew characters in the username.

I would like to convert it without the users but still keep the author name, as in archive forum. It’s also make sense to keep the original name of user who post even the user doesn’t exist in system. Any suggestions? Thanks.

[akira010203]

I found out where is the problem.

It is due to the language translation file, If I put the default language back in english there is no problems.

To the french users if you get this issue try :

#bbpress-forums .administrateur .bbp-author-role {
  background-color: blue;

It will wrk but when it comes to the french translation of moderator : modérateur it will be harder due to the special character on it.

You will have to rename it before being able to change color.

[Robin W]

bbPress is tested with wordpress default themes. It maybe a conflict – you need to check plugins and themes

It could be a theme or plugin issue

Plugins

Deactivate all but bbpress and see if this fixes. if it does, re-enable one at a time to see which is causing the error.

Themes

If plugins don’t pinpoint the problem, as a test switch to a default theme such as twentyfifteen, and see if this fixes.

[alzaran]

I followed through that link as well, and though I don’t like modifying core, I did go through with it to get the ideal notification behavior. Any progress on a solid fix on that? Would it be possible to add that sort of thing as an option in bbpress-core? Just ridiculous that the default behavior doesn’t do it.

[alzaran]

So Buddypress, by default, has a nifty @function that allows you to look up users by username. As I understand it, bbpress works with this out of the box, in the reply boxes. However, when I enable TinyMCE using the tutorial above (https://codex.bbpress.org/enable-visual-editor/), Buddypress autocomplete goes away completely. We’d rather not have to choose between these two features, is there a way to restore autocomplete even with TinyMCE enabled?

[Schoelje]

It took some time to make this topic visible on the forum. So, I’ve solved my own problem.

Instead of writing an htacces file I chose to write an alternative viewtopic.php script that collects the appropriate new bbPress URL from the database.

If your new bbPress forum is online, you place the following script in your old phpBB domain and save it as viewtopic.php (exactly where the old viewtopic.php used to be located) and don’t forget to replace the “my_xxxx” values with your information:

<?php
  // If all else fails, use this url.
  $defaulturl = "http://my_domain/forums/";
  
  // Your new bbPress database credentials.
  $host = "my_host";
  $db = "my_database";
  $dbuser ="my_database_user";
  $userpwd = "my_database_user_password";
  
  // Build the query according to url parameters p or t.
  $query = '';
  if (!empty($_GET['p'])) {
      $query = "SELECT xkcom_posts.guid FROM xkcom_postmeta 
                INNER JOIN xkcom_posts ON xkcom_posts.ID = xkcom_postmeta.post_id 
                WHERE xkcom_postmeta.meta_key = '_bbp_old_reply_id' 
                AND xkcom_postmeta.meta_value = '" . $_GET['p'] . "';";
  }else if (!empty($_GET['t'])) {
      $query = "SELECT xkcom_posts.guid FROM xkcom_postmeta 
                INNER JOIN xkcom_posts ON xkcom_posts.ID = xkcom_postmeta.post_id 
                WHERE xkcom_postmeta.meta_key = '_bbp_old_topic_id' 
                AND xkcom_postmeta.meta_value = '" . $_GET['t'] . "';";
  }
  
  // Set the new url to the default url
  $url = $defaulturl;
  
  // Check if we need to make a database connection.
  if (!empty($query)) {
    // Make a connection
    $mysqli = new mysqli($host, $dbuser, $userpwd, $db);
    
    // Check the connection.
    if (!$mysqli->connect_errno) {
      // Run the query.
      $result = $mysqli->query($query);
      
      // Get the new URL.
      if ($result) {
	$row = $result->fetch_array(MYSQLI_ASSOC);
	$guid = trim($row["guid"]);
	if (!empty($guid)) {
	  $url = $guid;
	}
      }

      // Free the result set.
      $result->free();

      // Close the connection.
      $mysqli->close();
    }
  }
  
  //var_dump($url);
  
  // Write the header.
  header("Location: " . $url, true, 301);
?>

[sharmavishal]

Hi @johnjamesjacoby

the codex mentions this for Allow Global Access
In a WordPress Multisite install bbPress is activated on individual sites. Allowing global access will permit all users from across the network to post topics and replies on the forums for this particular site.

i activated bbpress per site on my 3 network sites. still i dont see any setings for global access? does global access happen by default?

Also is there some similar setting for bbpress like buddypress’s define(‘BP_ENABLE_MULTIBLOG’, true);?

i got define(‘BP_ENABLE_MULTIBLOG’, true); enabled for my wp+bp multinetwork. But forums on the root site dont show up on the sub sites like groups/members do with that setting enabled.

Thanks in advance.

[u_Oi]

Thanks @Casiepa

But I don’t want count the replies, I just wanna add a Label to Topics with 0 replies, and hide it if somebody reply the topic.

I found the info here:

24. Show status labels for bbPress Topics

Any other suggestion?

I think the label (no replies) should be on the documentation by default.