[@robin-w Moderator 11 years, 3 months ago]

This does presume that you’ll be doing a manual re-register – ie that the users will send you a name and email and you’ll just amend the username created in the conversion. If you want an automatic registration, then come back as that may be really complicated !

[@robin-w Moderator 11 years, 3 months ago]

I imported from an access database (ditto conversion to sql) so know what you’re going through! see https://bbpress.org/forums/topic/documented-import-from-snitz-access-database/ for a blow by blow of how I did this and presume you’re already well into using custom importer https://codex.bbpress.org/import-forums/custom-import/

Now given that you’re going to re-register users, then we only need the topics to be assigned to a user which exists, which then when they re-register you can set up properly.

So for instance if you have a topic with the author name of “fred” – then you need a user fred to exist. This needs to be at ID level.

So in essence you’ll need to import

topic with author ID
User with same ID

Minimum info to create a user is (in theory – it may be less) ID, username, email and password.

In my case they mapped from a snitz access forum (via sql) as follows

MEMBER_ID _bbp_user_id
M_NAME user_login
M_PASSWORD _bbp_password
M_EMAIL user_email

So I would go about it this way.

What we need to end up with is a topics/replies table that has a author ID (number) against each topic/reply.
In a user table, we then need that same ID, together with name, password and email.

So first I’d go back to my lotus notes and see if topics has an author ID. If not we’ll need to create one (we’ll do that in a minute).

Then from the topics and replies lists create a set of autor names and (if it has them) ID’s

Create a user table (in my case in excel, but presume you’re familiar with creating in lotus notes) with the following headings

ID NAME PASSWORD EMAIL

If your topics/replies doesn’t have user ID’s then you just need to populate this table with unique ones, I’m pretty sure that you can just start with 1 and increment them – wordpress will assign new ID numbers as they come across starting with the next number that wordpress is not using.

For password, just put anything – and they can all be the same

Emails must be unique in theory, but don’t need to exist so abc@def.com is fine (you’ll be fixing these as they register, so doesn’t matter). But as you’re importing directly into the database, I reckon you could get away with them all being a single fictitious one. But if you have the skills, I’d create them as increments eg abc1@def.com, abc2@def.com just in case

so now you have a user table to import.

If you topics and replies don’t have author ID’s, then now go back to the topics and replies tables and run macro to populate a new column using name against the user table you’ve just created to populate with id.

Now we have topics with ID’s an da user table to import. Just check that column names match the importer, convert it all to sql, and off you go !

[@robin-w Moderator 11 years, 3 months ago]

you’re welcome !

[@robin-w Moderator 11 years, 3 months ago]

This comes from your theme’s main style, in my case

a:link { 
color : #EEEEEE !important ; 
}

if you want to change this throughout your site, then drop this into your style.css (or amend the current setting)

If you just want it in bbpress

#bbpress-forums .bbp-author-name a:link { 
color : #EEEEEE !important ; 
}

should work

[@robin-w Moderator 11 years, 3 months ago]

No, nothing you can do, but I’ve just made an error in my plugin, and I think I have solved the problem above by chance !!

The plugin will let you do this, but you’ll have to wait for the plugin though as it is still in dev – expect a week !

I should be able to get content in as well with luck !

Sorry can’t be sooner, but a lot of code to write properly now I know it works !

and of course no guarantee that I won’t find some major flaw !

[@robin-w Moderator 11 years, 3 months ago]

No problem, not an area I’m any good at, but maybe someone else reading may have the knowledge !

Hope you get fixed !

[@robin-w Moderator 11 years, 3 months ago]

Yes, it is in the long list I have, and I have failed you !

As per your other post, this is all in related area, and I’ll try and have a look at this also !

[@robin-w Moderator 11 years, 3 months ago]

ok, so that two posts I haven’t come back to you on !

I had a dig, and this one is not a two minute answer, and I may not be able to solve it for you.

However, I am working on a plugin for an entirely different use, but it is in the same code/function area, so as I am digging I try to see if I can work a fix for you.

BUT, I may not within time available to me

[@robin-w Moderator 11 years, 3 months ago]

do you mean no. 8 in the attached?

bbPress Styling Crib

[@robin-w Moderator 11 years, 3 months ago]

“I asked on another forum and had no luck.”

If this wasn’t

Support Forums

then post it there, you’ll more likely get someone who knows

[@robin-w Moderator 11 years, 3 months ago]

In the spirit of free community software – if/when you work a solution out, do post it here, so that others following along in a few months/years can see how it was done !

Thanks

[@robin-w Moderator 11 years, 3 months ago]

it means that someone has gained access to your site, and put some code into it.

You really need to go through all of these to fully clean up the site and make sure any “backdoors” have been closed:
https://wordpress.org/support/topic/268083#post-1065779

How To Completely Clean Your Hacked WordPress Installation

http://ottopress.com/2009/hacked-wordpress-backdoors/
Additional Resources:
http://sitecheck.sucuri.net/scanner/
http://www.unmaskparasites.com/
http://blog.sucuri.net/2012/03/wordpress-understanding-its-true-vulnerability.html

or you can pay securi to fix it for you – see the link above !

[@robin-w Moderator 11 years, 3 months ago]

There aren’t currently any plugins I know of that do this

[@robin-w Moderator 11 years, 3 months ago]

You’re welcome !

[@robin-w Moderator 11 years, 3 months ago]

do you have a root page as such?

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

Step 3 method 2

[@robin-w Moderator 11 years, 3 months ago]

you seem to have malware on your site

http://sitecheck2.sucuri.net/results/digiscrapper.co.za/

[@robin-w Moderator 11 years, 3 months ago]

Suggest you contact the theme author to see if they can resolve.

Which theme are you using?

[@robin-w Moderator 11 years, 3 months ago]

put this code into your style.css in your theme

#bbpress-forums li.bbp-header {
	background: #dc9e5a !important ;
}

You should select the color you want

[@robin-w Moderator 11 years, 3 months ago]

sorry, but is this within a forum, or just a blog?

[@robin-w Moderator 11 years, 3 months ago]

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

[@robin-w Moderator 11 years, 3 months ago]

Great, glad you’re fixed !

[@robin-w Moderator 11 years, 3 months ago]

Thank you for the correction – I obviously wrote it too fast !

Great, glad that you are working!

[@robin-w Moderator 11 years, 3 months ago]

Without spending time going back through this thread, I presume you have tried all the bits of code above. The fact that they didn’t work for the OP whose site we couldn’t see doesn’t mean they won’t work for you.

If you have done all that, come back with a link and I’ll take a look.

[@robin-w Moderator 11 years, 3 months ago]

ok, before looking at anything else, try running all the forum repairs

Dashboard>tools>forums>repair and run one at a time

[@robin-w Moderator 11 years, 3 months ago]

Check other plugins

Check that no other plugins are affecting this.

Turn off all other plugins apart from bbpress, and see if that fixes the problem. If the problem is resolved, add back one at a time to see which is causing the conflict.

Check themes

If plugins are not the cause, then it may be a theme issue. Switch to a default theme, such as twentytwelve, and test.