Post Content Find / Replace 1.0.0

[Thierry Martin]

No the edit created the same error code

ok maybe the problem is my XXXXX stuff

the first and second XXXXX is the same thing, the third XXXXX is something else

so for instance it could be

(<u><a href="http://insidestocks.com/chart.asp?sym=ACAD&code=BCMM" target="_blank">ACAD</a></u>) <i>(Lightning Round)</i>

which should turn into

the BB code for that

or it could be

(<u><a href="http://insidestocks.com/chart.asp?sym=RH&code=BCMM" target="_blank">RH</a></u>) <i>(discussed)</i>

which would turn into the BB code for that

I should have indicated XXXX1 - XXXX2 - XXXX3 where XXXX1 and XXXX2 is the same

I had thousand of posts in a forum (admin written only) in HTML which did not import correctly so now the posts have the HTML showing instead of the result.

example here
http://onlinetradersforum.com/threa...s-mad-money-stock-picks-recap-11-8-12.656429/

weird I opened the post, looked at the code, saved and the link part of the post turned into BB code.

Here is what a post looks like without opening in Xenforo for first time and saving:

http://onlinetradersforum.com/threa...-mad-money-stock-picks-recap-10-16-12.655415/

and here is what the post should look like with the proper BB code

http://onlinetradersforum.com/threa...s-mad-money-stock-picks-recap-3-20-14.675526/

 

[EQnoble]

No the edit created the same error code

ok maybe the problem is my XXXXX stuff

the first and second XXXXX is the same thing, the third XXXXX is something else

so for instance it could be

(<u><a href="http://insidestocks.com/chart.asp?sym=ACAD&code=BCMM" target="_blank">ACAD</a></u>) <i>(Lightning Round)</i>

which should turn into

the BB code for that

or it could be

(<u><a href="http://insidestocks.com/chart.asp?sym=RH&code=BCMM" target="_blank">RH</a></u>) <i>(discussed)</i>

which would turn into the BB code for that

I should have indicated XXXX1 - XXXX2 - XXXX3 where XXXX1 and XXXX2 is the same

I had thousand of posts in a forum (admin written only) in HTML which did not import correctly so now the posts have the HTML showing instead of the result.

example here
http://onlinetradersforum.com/threa...s-mad-money-stock-picks-recap-11-8-12.656429/

weird I opened the post, looked at the code, saved and the link part of the post turned into BB code.

Here is what a post looks like without opening in Xenforo for first time and saving:

http://onlinetradersforum.com/threa...-mad-money-stock-picks-recap-10-16-12.655415/

and here is what the post should look like with the proper BB code

http://onlinetradersforum.com/threa...s-mad-money-stock-picks-recap-3-20-14.675526/

I'm tired...going to sleep...always run tests before running with 'save changes' checked


Quick Find:

insidestocks

Regular expression:

#\(<u><a href="(http://insidestocks[^?]+\?sym=([^&]+)\&code=([^"]+))[^>]+>[^<]+</a></u>\)[^<]+<i>\(([^)]+)\)</i>#siu

Replacement String:

([u][url='\1']\2[/url][/u]) [i](\4)[/i]

 

[audiokid]

I have some more links to clean up that go back 12 years. I would like to either remove them completely or rewrite them to reflect today. Is it possible?

http://recording.org/ubb/ultimatebb.php?ubb=get_topic;f=6;t=002394;p=1#000005

 

[audiokid]

I managed to get my soundcloud url links to embed ( s9e Media BBCodes pack ) but they all need to be rebuilt . If I simply edit a post with a soundcloud url and save they will embed. But I have hundreds so what will do this for me now?

they are like this:

https://soundcloud.com/valentinobosi/nervine

 

[audiokid]

Could I need to rebuild the bbcode cache?
http://xenforo.com/community/resources/query-to-reset-bb-code-media-sites.2783/update?update=8096

Where do I add this?
DELETE FROM xf_data_registry WHERE data_key = 'bbCode'

 

[audiokid]

Sorry for pressing this over and over.

I see in phpmyadmin, a table called ( xf_bb_code_parse_cache) I'm thinking this has the url's cached in there which may be causing the soundcloud replacements to refresh embeded.

Can I empty this table without causing problems?

 

[Jake Bunce]

Sorry for pressing this over and over.

I see in phpmyadmin, a table called ( xf_bb_code_parse_cache) I'm thinking this has the url's cached in there which may be causing the soundcloud replacements to refresh embeded.

Can I empty this table without causing problems?

Yes.

 

[audiokid]

Thank you guys, I have it all sorted now!

 

[sami simo]

Replace in posts link in admin panel shows a blank page, is this mod working with XF 1.3 ?

 

[audiokid]

Replace in posts link in admin panel shows a blank page, is this mod working with XF 1.3 ?

If I'm correct, that is an indication you don't have something entered in correctly.

yes, with my system, this is working great in 1.3.

 

[sami simo]

Thanks, but I still didn't entered anything, I'm trying to access the tool options, but have only blank page.

 

[markku]

If I want to replace all mentions of violinplayer to Mr. Five, how would I enter the regular expression and replacement string?

I'm changing a person's username and would like to fix the quotes and other mentions of that nick to correlate with the new username (Mr. Five).

Any help highly appreciated.

 

[Jake Bunce]

Replace in posts link in admin panel shows a blank page, is this mod working with XF 1.3 ?

I am guessing it's not installed correctly.

This directory should exist on the server:

library/PostReplace

And inside should be this:

library/PostReplace/addon_PostReplace.xml

That XML file needs to be imported in the Admin CP:

Admin CP -> Home -> Install Add-on

 

[audiokid]

Jake,

I have my installed like this too, but I can't just do a search for something like " Mississippi "

 

[sami simo]

I am guessing it's not installed correctly.

This directory should exist on the server:

library/PostReplace

And inside should be this:

library/PostReplace/addon_PostReplace.xml

That XML file needs to be imported in the Admin CP:

Admin CP -> Home -> Install Add-on

Thanks jacke, this solved my problem.

 

[EQnoble]

Jake,

I have my installed like this too, but I can't just do a search for something like " Mississippi "

#Mississippi#

 

[audiokid]

Ha, you rock once again!

 

[audiokid]

noble, how would I search for a word like #Mississippi# and then remove it from the forum?

 

[sami simo]

Now I'm getting this error:

An exception occurred: Mysqli prepare error: MySQL server has gone away in /public_html/library/Zend/Db/Statement/Mysqli.php on line 77

 

[Jake Bunce]

@sami simo

Mysqli prepare error: MySQL server has gone away

That error is caused by one of these MySQL settings being exceeded:

wait_timeout
max_allowed_packet

Your host or server person needs to increase these settings in MySQL. There is more info here:

http://dev.mysql.com/doc/refman/5.1/en/gone-away.html