[curvemeister]

Hi again,

Here is an improved version of the SMF to bbPress script. This version supports additional, non-image filetypes, and has more safeguards against inserting attachments multiple times if the script is interrupted and restarted. Since I am not yet savvy in the ways of submitting source code to the forum, I am cutting and pasting, which seems to butcher the syntax horribly…

Many thanks, again, to Stephen.

================================================================
<?php
//Standalone script to import smf attachments for the GD bbPress Attachments plugin
//Mike Russell, April 4, 2015
//Execute after you have imported smf into bbPress.
//Run this from the command line, not the web (it will timeout)

require( ‘wp-load.php’ );
require( ‘wp-admin/includes/image.php’ );
global $wpdb;

$verbose = false;
$force_attachment_update = false; //normally false. set true to re-write existing attachments
//$limit = ” LIMIT 0,1″;
$limit = ” LIMIT 0,99999″;

// source database connection
$host=”localhost”;
$uname=”xxx”;
$pass=”xxx”;
$database = “xxx”;
$site_url = ‘http://www.xxx.com/forum&#8217;;
$forum_path = ‘forum/attachments/’;

echo “start smf_attachments-to-bbpress v1.2\n”; flush();

//get the attachment rows from SMF
$smf_db = new wpdb($uname, $pass, $database, $host);
$smf_rows = $smf_db->get_results(”
SELECT * FROM smf_attachments
WHERE file_hash != ”
AND filename NOT LIKE ‘%thumb’
ORDER BY id_attach”
.$limit);

echo “processing “.$smf_db->num_rows.” rows total\n”;

// process each row
$count = 0;
foreach ($smf_rows as $smf_attachment_row) {
if($verbose) { echo ‘next row, id_attach = ‘.$smf_attachment_row->id_attach.”\n”; flush(); }

//look for both a new and old style filename to copy. If neither exists, skip this attachment
$smf_filename = $forum_path.$smf_attachment_row->id_attach.’_’.$smf_attachment_row->file_hash;
if(!file_exists($smf_filename))
$smf_filename = $forum_path.$smf_attachment_row->id_attach.’_’.$smf_attachment_row->filename.$smf_attachment_row->file_hash;

if(!file_exists($smf_filename))
{
echo “no file, skipping attachment for SMF attachment “.$smf_attachment_row->id_attach.”, missing SMF file: “.$smf_filename.”\n”; flush();
continue;
}

$uploads = wp_upload_dir(‘SMF’);
$new_upload_dir = $uploads[‘path’];
$new_full_filename = $new_upload_dir.’/’.$smf_attachment_row->filename;
if($verbose) { echo(‘old->new = ‘.$smf_filename.’ -> ‘.$new_full_filename.”\n”); flush(); }

//copy the enclosed file from SMF to the upload dir if necessary
if(!file_exists($new_full_filename) && !copy($smf_filename, $new_full_filename) ) {
echo “cannot copy: “.$smf_filename.”->”.$new_full_filename.”\n”;
} else {
//look for a reference to the bbPress-imported parent post for the current attachment
$parent_args = array(
‘post_type’ => array(‘topic’, ‘reply’),
‘meta_key’ => ‘_bbp_post_id’,
‘meta_value’ => $smf_attachment_row->id_msg
);
//echo “$parent_args = “.print_r($parent_args).”\n”;

$parent_query = new WP_Query($parent_args);
$parent_query->get_posts();
if($verbose || $parent_query->post_count > 1) {
echo $parent_query->post_count.” posts found for smf_post id “.$smf_attachment_row->id_msg.”\n”; flush();
}

//add the attachment if there is exactly one parent referencing it
if($parent_query->have_posts() && $parent_query->post_count == 1) {
$guid = $uploads[‘url’] . ‘/’ . basename( $new_full_filename );
$parent_query->the_post();
$post_id = get_the_ID();

//if force option is not specified, skip updating an already existing attachment
if(!$force_attachment_update) {
$q = $wpdb->prepare(
”
SELECT COUNT(*)
FROM $wpdb->posts
WHERE guid = %s AND post_parent = %d
“,
$guid,
$post_id);

$nrefs = $wpdb->get_var($q);
if($nrefs > 0) {
if($verbose) { echo “skip existing attachment: “.$guid.”\n”; flush(); }
wp_reset_postdata(); //reset post info
goto done;
}
}

$attachment_data = array(
‘guid’ => $guid,
‘post_mime_type’ => ‘image/’.$smf_attachment_row->fileext,
‘post_title’ => $smf_attachment_row->filename,
‘post_status’ => null,
‘post_content’ => ”,
);
if($verbose) { echo “attachment_data = “.print_r($attachment_data).”\n”; flush(); }

$attach_id = wp_insert_attachment($attachment_data, $new_full_filename, $post_id);

//echo “attach_id = “.$attach_id.”\n”; flush();
if($attach_id) {
//update_post_meta($attach_id, ‘_bbp_attachment’, 1);
if($attach_metadata = wp_generate_attachment_metadata($attach_id, $new_full_filename)) {
//echo ‘attach_metadata = ‘.print_r($attach_metadata).”\n”; flush();
wp_update_attachment_metadata( $attach_id, $attach_metadata );
set_post_thumbnail( $post_id, $attach_id );
} else {
echo ‘wp_generate_attachment_metadata failed, fname = ‘.$new_full_filename.”\n”; flush();
}
}
wp_reset_postdata();
}
}
done:
$count++;
if($count%100 == 0)
{
echo $count.” attachments processed\r”;
flush();
}
}
echo “Done, processed “.$count.” records\n\n”;

//clean up message body text
//convert <tt> -> <br />
mysql_query(“UPDATE wp_posts SET post_content = REPLACE (post_content, \'<tt>\’, \'<br />\’) WHERE post_content LIKE \’%<tt>%\'”);

mysql_close($connection);
exit;
?>

[Robkk]

I did open Filezilla and I searched for “cache” — I found a cache.php file, but I didn’t even attempt to go mucking about in there!

yep , dont edit files or delete any files you might cause another issue with your site.

I’m a little glad to hear that you’ve possibly had a similar problem; maybe I can ask some other people on the site to try out different browsers and see if I need to go clean out my CPU cache.

something like it , im sure its common too , like i said i dont remember 100%

If you have a chance to add more classes to the CSS code, I would be extremely grateful. I really appreciate the time and effort you’ve spent on my issues.

i tested with your theme and this seemed to work.

.bbpress span#favorite-toggle a,
.bbpress span#subscription-toggle a {
	color: #000;
}

.bbpress span#favorite-toggle a:hover,
.bbpress span#subscription-toggle a:hover {
	color: #707070;
}

[DanaJoy2008]

I could certainly contact the host and see if it’s something they did. I’m 100% positive I don’t have Wordfence, and I don’t *think* I have anything like it, but I will go double-check. I did open Filezilla and I searched for “cache” — I found a cache.php file, but I didn’t even attempt to go mucking about in there!

I’m a little glad to hear that you’ve possibly had a similar problem; maybe I can ask some other people on the site to try out different browsers and see if I need to go clean out my CPU cache.

If you have a chance to add more classes to the CSS code, I would be extremely grateful. I really appreciate the time and effort you’ve spent on my issues.

[Robkk]

@danajoy2008

I’m really not sure — I have no record of installing a cache plugin, and I can’t recall when I noticed that button up there. I’m totally confused.

can it be your host?? or you could be using something like Wordfence that also has caching in it??

I’ve put the code your posted above into the Simple Custom CSS, but the Favorite and Subscribe buttons are still blue. Was there something I was supposed to do besides just cutting and pasting?

i probably need to add more classes to the CSS code.

Also, this is strange: After I clicked on “flush cache,” I could immediately see the blue links when I had the site open in Chrome. When I open Firefox and pull up the site, I can’t see any blue — it’s all gray again.

it might also be collected browser cache on your CPU, not 100% sure though.
i think i had that problem before.

[Robkk]

@davidnsfw

alright since i think your site has jetpack installed

make sure you have the custom css module activated in jetpack .

now go to appearance > edit css

copy this code into your custom css editor.

.bbpress .post-section {
  margin: 0 2% 20px 2%;
  width: 96%;
}

.bbpress #content-main {
  width: 100%;
  margin-right: 0;
}

hit save

check and see if it works

if the code does work, reply back on here that it works now.

if the code doesnt work i need to see if any Custom CSS on bbPress would show . so copy and replace my old CSS code that you just previously pasted

with this code

.bbpress a {
  color: red;
}

now see if your links on your forum are red

if it turns red, reply back here that your links are red and that i need to add more classes to your original CSS so i could make your forum full width.

[Robkk]

@davidnsfw

yeah , a place where you can drop CSS code snippets

[mel77]

Hi Robin, thanks for your help.

It turned out to be a theme issue. I managed to fix it by using the 2nd option in part 3 of your guide “Creating a forum page”: https://codex.bbpress.org/step-by-step-guide-to-setting-up-a-bbpress-forum/

[DanaJoy2008]

I’m really not sure — I have no record of installing a cache plugin, and I can’t recall when I noticed that button up there. I’m totally confused.

I’ve put the code your posted above into the Simple Custom CSS, but the Favorite and Subscribe buttons are still blue. Was there something I was supposed to do besides just cutting and pasting?

Also, this is strange: After I clicked on “flush cache,” I could immediately see the blue links when I had the site open in Chrome. When I open Firefox and pull up the site, I can’t see any blue — it’s all gray again.

[Svend Rugaard]

Now it just give my the seperator code but you can see it on a random pages wit 404 but see as in this random created page it is showing correct name in the browser top – http://www.playstationforum.dk/just-just-test/

but now i actually manage to get the archive remove but doesent show “Debat” as it should be but i think its som tag / slugs i have mess up in the backbone of the theme, i fix it nothing to do with this topic i think but i was just wondering it only was the forum there do it.

[Robkk]

These two Custom CSS rules should help.

put them anywhere you can put custom CSS

child themes style.css file
jetpacks custom CSS module
a standalone custom css plugin.

.bbpress .post-section {
  margin: 0 2% 20px 2%;
  width: 96%;
}

.bbpress #content-main {
  width: 100%;
  margin-right: 0;
}

if this does not work try this CSS for a test

if the links in your forum turn red the CSS is working.

.bbpress a {
  color: red;
}

if the links are red and my above CSS rules for full width arent working i probably have to redo the CSS rules i gave you above to include more div classes which will be super annoying.

[Robin W]

You are not understanding the problem.

spot on !

the code you gave is an action, so would not contain the breadcrumb unless some other code outside bbpress is actioning it.

can you give us a link/url to a page and tell us what you want moved/added/changed

[DanaJoy2008]

That is an excellent question — I don’t have any cache plugin listed, as being either activated or deactivated. That’s part of what’s confusing the daylights out of me. I have a “flush cache” option at the top on the admin page, and when I clicked that, I was able to see the blue links.

Thanks so much for the extra code! You’re brilliant!

[Robkk]

I’m still working on how to disable caching for logged in users.

what cache plugin are you using??

Is there a way to make it so that the Favorite and Subscribe buttons aren’t blue too?

here i think i copied how the sidebar links are shown.

.bbpress a.favorite-toggle,
.bbpress a.subscription-toggle {
    color: #000;
}

.bbpress a.favorite-toggle:hover,
.bbpress a.subscription-toggle:hover {
    color: #707070;
}

[Robkk]

Slightly NSFW

i laughed at this.

@davidnsfw add !important after 96% like this

.bbpress #content-main {
width: 96% !important;
}

and see if that works.

[Jake Hall]

You are not understanding the problem.

There is a hardcoded breadcrumb within what I seem to think is within this line of code:

<?php do_action( 'bbp_template_before_forums_loop' ); ?>

I am essentially stuck with the breadcrumb only in the forum root page, I have been able to move it via the user of template files in every other part of the forum. It seems to be impossible to remove the breadcrumb from the homepage using templates.

[davidnsfw]

I have added this code but it does not help.

[Robin W]

try adding

.bbpress #content-main {
width: 96%;
}

to your style.css

Functions files and child themes – explained !

[Robkk]

@pazzaglia1

you are running into a couple issues.

As for some users i can see their profile leads to a 404 too.

create me an Admin account and send me the login details by email so i can see what plugins you are using , if there is a code snippet causing an issue, your theme , or something else.

when im done helping you , you can delete the account.

Contact

[Robin W]

bit of a difference between

and wanted it removed completely

and

I merely want to move it.

🙂

but it doesn’t seem as if that’s possible.

um, yes it is, you just hadn’t asked !

just use

<?php bbp_breadcrumb(); ?>

in the code

there are many template files that use this

just look in

templates\default\bbpress\

and you’ll find all the templates

tell us where you want it, and we’ll try to help further

[Robin W]

see

Step by step guide to setting up a bbPress forum – Part 1

[Robkk]

this should do it, place in child theme functions.php or a functionality plugin

function bm_bbp_no_breadcrumb ($param) {
	
	if (bbp_is_forum_archive()) {

		return true;

	}

}

add_filter ('bbp_no_breadcrumb', 'bm_bbp_no_breadcrumb');

[gezginrocker]

My final update about this topic, in case it helps some one.

Putting the value at the style.css as not working, because there was a missing “}” at the code. I found it and corrected it, now everything works properly.

Although, I have found out that putting a fixed value like “width: 720px” is not a very good idea, because it breaks the mobile display.

Because of that, I put “width: 120%”, and now both desktop and mobile display works properly.

[Svend Rugaard]

actually it should be activated because the theme has it coded in and i have change it on other types og posts, game archives etc , but i found the “archive” was actually blank with note keyword

so i try to se ikke i use the same i use for game info is gonna work.

%%title%% | %%category_description%%

[Jake Hall]

Hey Rob,

That came out a little rude, I didn’t mean it like that. I was just trying to say I wasn’t interested in hiding it with a CSS Rule, and wanted it removed completely. You say it is a perfectly valid way of removing things, but since when is having duplicate content and useless elements on a page a good thing?

Secondly, the codex page tells you how to completely disable breadcrumbs, I merely want to move it. I was hoping there was a template file I could edit to remove it, and then manually place it elsewhere on the page – but it doesn’t seem as if that’s possible.

Either way, CSS hide or Functions edit, neither will work in my case since I still want to make use of Breadcrumbs, I just want to change the DOM location

[DanaJoy2008]

Rob,

I cut and pasted the code from your last reply to me into the Simple Custom CSS, saved it, and then opened a new browser and checked the site. Still no change.

Should I post a brand new topic post here with the links and whatnot? Or put the links in a reply here? I’m sorry I’m not sure – I don’t want to make a new post if that’s not what you are asking me to do.

Thank you all both for being so patient and helpful. I really, really appreciate it.