Fix the weird characters/symbols in posts.

[borbole]

This mod will allow you to fix the weird characters/symbols that appear at your forum when you move hosts and/or reatore a database due to the coallition characters conflict in the db.
For ex when all your posts appear with a bunch of ÂÂ@@ or whatever characters. All you have to do is enter those weird characters at the mod settings and then enter the right symbols that you want to replace and all your problems will be solved.

It can aslo be used to replace text. It can be whatever text you want.

Installation:

To install the mod, upload the includes folder to your forum root folder and then import the wierd_symbol_fix.xml file inside the mod package to Plugins&Products in the acp of your forum. Then go to the mod setting option: Fix Wierd Symbols. It can be found on the left side of the Admin Panel, right above the Maintenace section. And enter the information accordingly.

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

[Juggernaut]

tagged for later :D

[ProFifaLeagues]

Tagged as will come in handy!Great work.

[Professional2]

tagged

[steve1966]

it worked once then if i deleted the thread and tried agin it did not work but showed as working in the thread in editing mode

[borbole]

it worked once then if i deleted the thread and tried agin it did not work but showed as working in the thread in editing mode

If you deleted the thread it is normal that it won''t work as the posts for that thread will be gone. But it will work on all the other posts at your forum.

[steve1966]

thanks for informing

[borbole]

No problem.

[Manoel J?nior]

Great man!!!!

Thanks

[Blooded]

Tagged maybe in the future i will need it, hope not.

[alhindasi]

waaaaaaaaaaaaaw 100%

it's working good

**BUT**

i need to fix and Replace many Word

Is it possible to add many Word

[rajubd]

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

[gusfune]

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.

[Threepwud]

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

[borbole]

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?

[Threepwud]

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

[borbole]

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.

[Threepwud]

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.

[borbole]

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.

[Threepwud]

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...?

[borbole]

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!

You are welcome. Glad to see that you got it solved :)

After you use the mod you can disable it. And re-enable it again when you want to perform similiar tasks.

[Threepwud]

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...?

LOL, one step ahead of you. Did you note the quote issue?

[borbole]

LOL, one step ahead of you. Did you note the quote issue?

I had quoted your post before you added the part about the quote. Can you post a link to how it is displayed after the conversion? Or a screenshot.

[Threepwud]

<a href="http://www.threepwud.com/vb/showthread.php/3157-Freaky-speed-bump" target="_blank">http://www.threepwud.com/vb/showthre...aky-speed-bump</a>

There are plenty of quotes there. It slightly differs from VB quotes and I'll understand if it isn't as straight forward as the apostrophe matter!

Kind regards,
Threep

[borbole]

http://www.threepwud.com/vb/showthread.php/3157-Freaky-speed-bump

There are plenty of quotes there. It slightly differs from VB quotes and I'll understand if it isn't as straight forward as the apostrophe matter!

Kind regards,
Threep

I have converted seevral smf forums to vB and I never experienced that with the quotes. Anyway, that is outside of this mod funcionality. Try to ask it at the Impex forum over at vb.com.

[Threepwud]

Thanks mate, I've asked and a couple have had the issue. Seems you need to tweak impex before the import. Ah wells.

I used your mod to change \[quote author= to \[quote= and whilst the links don't work the threads look amazingly better.

Thanks for your effort - I must point out for your next release that it is WEIRD and not WIERD!

[borbole]

Thanks mate, I've asked and a couple have had the issue. Seems you need to tweak impex before the import. Ah wells.

I used your mod to change \[quote author= to \[quote= and whilst the links don't work the threads look amazingly better.

Thanks for your effort - I must point out for your next release that it is WEIRD and not WIERD!

Thank you for the correcting my typo :) English is not my first language so my grammer is not very good.

I can''t believe it that no one else caught on it before and it has been up for months now :D

[CrystaStarLight]

This mod made my showthread.php load very slowly. Perhaps this could use some optimization?

This is what my debug said when the mod was turned on:

# 18.41910 seconds
# Memory Usage 9,335KB
# Queries Executed 25 (?)

This is after I disabled the mod:

# 0.59638 seconds
# Memory Usage 9,335KB
# Queries Executed 14 (?)

It also depended on how many replies were in the thread. If the thread had around 2 replies the thread page loaded okay, but if it had 12 replies it would load like it is shown above. That debug was shown on a thread with 12 replies.

[Threepwud]

I had the same; I changed what I needed then refreshed the post cache in the update counters section. Then I turned it off straight after - the changes had been made and the mod was switched off.

Good stuff.

[borbole]

Indeed. After the mod does its thing then you can disable or even uninstall it.

[CrystaStarLight]

Oh, you don't need to keep the mod on after it's run? Awesome thanks. =)

[borbole]

Oh, you don't need to keep the mod on after it's run? Awesome thanks. =)

No, that is not needed.

[Rafa-el]

Question, it works only for one char each time? I mean, add the char, and then update the message cache?

[1hko]

Does this work for usernames too? I switched over yesterday and have a BUNCH of weird usernames now.

[Blooded]

Does this work for usernames too? I switched over yesterday and have a BUNCH of weird usernames now.

i think you should make a db query to do that

UPDATE user SET username='changedusername' WHERE username='originalusername'

This mod only work with post table not user and that is what you need

[OldSchoolDSL]

not installed, but tagged for possible later use

Thank you.

[amorosso]

Can you update this for 4.0.7 or 4.0.8

[DocZaius]

I'm having the same problem that Threepwud had.

Quotation marks got changed to &quot;
Apostrophes got changed to& # 3 9 ; (without the spaces)
Colons got changed to & # 5 8 ; (without the spaces) which really messes up URLs.
Periods got changed to & # 4 6 ; (without the spaces) which also messes up URLs.

And, of course there's the problem with the quotes.

However, your mod doesn't seem to fix this on my forum, which is running vB 4.1.3. It's making me a sad panda. Any tips?

[un? in?]

Thank for mod
Thank for share

[danswano]

Hello borbole,

can you tell me how this mod works exactly, is it like variable replacement in template or like banned words that replaces bad word with *
i mean it just convert them for users view or it replaces them permanently in the database?

Thanks. :)

[adwade]

Could this be made to work with vB 3.8.6, or is there any reason it won't as-is?

[keteflips]

Hi.

¿Works in 4.1.12?
I'm trying but I see no posts are corrected.

Thanks.

[GONUMBER6]

This worked great, although I only let it work for about 10 mins.... then disabled it. It made the forum so slow, but it did change all the <3 symbols to :heart: which is what I wanted it to do! Thanks!

[borbole]

This worked great, although I only let it work for about 10 mins.... then disabled it. It made the forum so slow, but it did change all the <3 symbols to :heart: which is what I wanted it to do! Thanks!

Glad to hear that it worked for you. I plan to fix the slow issue soon.

[nodofollow]

Developer please update this for latest vb version

[Craigr]

Works great on vb4.2.0 PL 2. Thanks.

[Disco_Dave]

Hi Borbole

I've tried running this mod on 4.2 and Rebuilding Post Cache

I have these symbols: ¢â‚¬â„¢ all over the oldest parts of our forum. I'm trying to replace the text with nothing, is this possible?

Dave

[kartheekb]

does this works for 4.2 ???

[Grimster]

Ignore, fixed by escaping the character I wanted to replace. Great mod, thanks.

[markoroots]

I'm running the 4.2.3 and work well.

[markoroots]

Glad to hear that it worked for you. I plan to fix the slow issue soon.


Hi Borbole, I have tried to run the mod this morning but my site crash after I run the rebuild of the posts cache. I don't know if was depended from this. Do you know if the mod work also for the Vb 4.2.5?
Or also if some one use it with this version I ask if can please let me know.
Thanks in advance