How to remove the vbet language code

[r.dziadusz]

Sorry for style but if i put it into [php] tag, & changes into & etc.

[norku]

Just tried the script and it doesn't remove the ascii html if it is joined onto a word. Here's an example: These are stunning. I can't help with an assessment...

Should I be seeing a results screen after I run the script?

[norku]

Oh great, at some stage of the uninstall http://&quot/;xxxxxxxxxxxxxxxx" has been added to a load of internal links in posts.... None of them now work of course. Not happy

[r.dziadusz]

some stage of the uninstall

While You are using second script yes? Also if something goes wrong just restore your database from backup, during using the code you forum should be shut down so you will have no losts.
Also I can esly chang second script to remove html code even if it is inside some words, sorry for this unonvinient

[norku]

Hi,

I have run all versions of the script on the same database (yes, with forum closed as per your instructions).

I spent 8 hours today going through hundreds of threads correcting internal links and &quot etc. I am seriously bored now so if you could do me a script which will remove #039; , " , & even if they are parts of words that would be absolutely great

Edit: Will the script also fix internal links like the one in post #43 above?

[r.dziadusz]

The script which now I write to you will change every #039; , " , & into ' etc. could you also PM me thread url with broken links appears

[r.dziadusz]

Code update : Click

[norku]

Hi and thanks for the update. I ran the script and got the folllowing error. Looks like one of the parameters might perhaps be wrong?

Database error in vBulletin 4.1.6:

Invalid SQL:
SELECT * FROM post WHERE pagetext LIKE '%>%' OR pagetext like '%<%' OR pagetext like '%&%' OR pagetext like '%'%' OR pagetext like '%"%' OR title LIKE '%&%' OR title LIKE '%'%' OR title LIKE '%<%' OR title LIKE '%>%';

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 '%' OR pagetext like '%"%' OR title LIKE '%&%' OR title LIKE '%'%' OR ti' at line 1
Error Number  : 1064
Request Date  : Monday, October 17th 2011 @ 01:57:46 PM
Error Date    : Monday, October 17th 2011 @ 01:57:46 PM
Script        : http://www.xxxx.com/forum/decode.php?do=execute
Referrer      : http://www.xxxx.com/forum/clearBB.php
IP Address    : 79.194.232.35
Username      : xxxx
Classname     : vB_Database
MySQL Version : 5.0.92-community 

[r.dziadusz]

Can you please one more time give me your error mesage without puting in it any BBcode tag - when you do this some html code is changed into signs ie.: %'% to %'% etc

[norku]

Database error in vBulletin 4.1.6:
Here you go:



Invalid SQL:
SELECT * FROM post WHERE pagetext LIKE '%>%' OR pagetext like '%<%' OR pagetext like '%&%' OR pagetext like '%'%' OR pagetext like '%"%' OR title LIKE '%&%' OR title LIKE '%'%' OR title LIKE '%<%' OR title LIKE '%>%';

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 '%' OR pagetext like '%"%' OR title LIKE '%&%' OR title LIKE '%'%' OR ti' at line 1
Error Number : 1064
Request Date : Monday, October 17th 2011 @ 01:57:46 PM
Error Date : Monday, October 17th 2011 @ 01:57:46 PM
Script : http://www.xxxxx.com/forum/decode.php?do=execute
Referrer : http://www.xxxx.com/forum/clearBB.php
IP Address : 79.194.232.35
Username : xxxx
Classname : vB_Database
MySQL Version : 5.0.92-community