waaaaaaaaaaaaaw 100%

it's working good

**BUT**

i need to fix and Replace many Word

Is it possible to add many Word

some of my attachment showing wierd character is it going to work on attachment?

One question: will this avoid characters breaking again? I mean, if it's something is causing all new posts to break, will this just fix the characters or is there any bug-fix inside the plugin?

Thanks.

I am trying to change ' to an apostrophe ' but it makes my page display a database error:

Database error in vBulletin 4.0.6:
Invalid SQL:
UPDATE thppost
SET pagetext = replace(pagetext, 'I'', ''');
MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '''')' at line 2
Error Number : 1064
Request Date : Saturday, September 11th 2010 @ 12:34:43 PM
Error Date : Saturday, September 11th 2010 @ 12:34:43 PM
Script : http://www.threepwud.com/vb/showthre...ndings?p=46049
Referrer : http://www.threepwud.com/vb/forum.php
IP Address : 94.170.240.143
Username : Threepwud
Classname : vB_Database
MySQL Version : 5.1.41

Any ideas?
Thanks mate

Can you tell me what test/character you want to replace and what with?

I mentioned that my apostrophes are showing as & # 0 3 9 ; (without the spaces, here it changes to an apostrophe!) so I want to change ' into an apostrophe.

Is this mod able to do that? Cheers mate

Yes, that is able to do it. It can replace any text and character.

Anyway, you are using a single quote and as such you should escape it with the backslash character \

i.e. you should enter the character like this: at Wierd Symbol & the Replaced Text. I just tried it at my test site and it worked fine.

Alright, I changed it so my replaced text said \' and it didn't work - then also tried it with \**** and that didn't work.

I'm thinking maybe because it is between other characters. ie i****m has the characters between the I and M characters.

After you ran it, did you update the counters as well as mentioned in bold at the bottom of the first post here :)

Note: After doing the replacement, go to: Admin CP -> Maintenance -> Update Counters and run Rebuild Post Cache.

HA! I did indeed miss that counter update. You sir are a genius.

The only thing I've noticed is that the forum slows down after I've enabled the mod. I'll look into that.

Thanks very much!

edit: after running your brilliant mod and then updating the counters, I simply disabled it and the place went faster again. Awesome stuff.

Could this mod be used to fix my quoting issues too?
[quote author=Jer link=topic=1118.msg46798#msg46798 date=1284059913]
comes from the SMF import and maybe if I can change them all...?