phpbb Import

[Lu Kas]

Hi,

i just importet from phpbb and now i have code like this everywhere someone inserted a picture:

[attachment=0:3nfyp8m6]IMG_1289.JPG[/attachment:3nfyp8m6]

is there a easy way to clean this up? i found kiers script http://xenforo.com/community/threads/post-content-find-replace.6548/ but i have no idea how to use it in my case.

hope you guys know the answer

 

[Lu Kas]

I think i found something, all the users (the first 4 are admins where in the db before the import so forget about them) have the "display_style_group_id" set to 1 while the are in "user_group_id" 2

 

[Paul B]

Yes, something clearly hasn't worked correctly with regards to the import.

You could run a query to update that, but it makes me wonder what else isn't correct.

Edit: The third row there shows correct, which account is that? Or did you manually change it?

 

[Digital Doctor]

ok, thank you for your quick answers .. it feels like a chat

Interesting Observation. Well put. The Quote Alert and Like Alert and Watch Alert notify everyone so effectively that it turns a typical forum discussion into more of a "Almost Real Time" chat.

 

[Lu Kas]

thats really the only problem i found so far, and its more or less a minor probler as all the users where in the right usergroup.

could you help me yout with the query:

UPDATE `d01144ba`.`xf_user` SET `display_style_group_id` = '2';


will this work or will it destroy?

 

[Paul B]

This should work: UPDATE xf_user SET display_style_group_id = 2 WHERE user_group_id = 2

You will then just have to manually change it back for the 4 admins.

Take a backup first though, just in case.

 

[Lu Kas]

just to inform any other phpbb users ... this worked. thank you brogan

 

[Lu Kas]

That is an inline attachment (as opposed to an IMG tag). In the case of a double import from phpBB to XenForo you lose the associations for inline attachments. That means you can't update that [attachment] tag to work in XenForo. But you can use Kier's addon to delete those tags from imported posts. Use these settings:

Quick Find:

[attachment​

Regular Expression:

#\[attachment=.+:.+\].+\[/attachment:.+\]#siU​

Replacement String:

<leave this blank>​

Here is a screenshot:

View attachment 16837

I tested this on my own forum and it worked.

together with this replacement code from your post here http://xenforo.com/community/threads/phpbb-import.17942/#post-233201 worked like a charm.

 

[Lu Kas]

I had an early night last night

I had to run over 100 queries using the tool and direct in the DB to tidy up everything after I imported (we had a lot of custom BB Code).

If you need any more, post here and I should have it already.

do you have replacement querys for the [size=x]Text[/size] code from phpbb

 

[Paul B]

I did it in phpBB before importing, like so:

UPDATE phpbb_posts SET post_text = REPLACE(post_text, '[size=200]', '[size=6]')

However, you should be able to do the same in XenForo:

UPDATE xf_post SET message = REPLACE(message, '[size=200]', '[size=6]')

Just change the sizes to suit and run the query for each different size value you have in the xf_post table.