With your example - you should run something like:
[sql]UPDATE post SET pagetext = REPLACE(pagetext, 'http://', '')[/sql]

And this replace also the other https?
example if i have normal working with one http on the from replace also this?

You can just change the query to change "https"...

sorry wronk typing..
I mean in my site i have some with double http on the front and some with one..
this query change both?

If the example you provided is accurate and correct, no, the query only changes the "bad" ones.

Doesnt help remove all the http exept the doubles.

Maybe we need to decode the links..

If you removed all the "http://", the link would point to the local host....

Once the URL and the syntax for calling this addOn is public, everybody can abuse this redirector. This addOn does not check if the user is a valid member of the board. Is there any option to verify the user rights before the redirect will start ?
So far I can see, a few "guests" start using the redirect plugin.
Give it a try:
1. log out from vbulletin
2. try YOUR VBULLETIN BOARD URL/redirector.php?url=YOUR TARGE URL

Even without being logged on, you can use and off course abuse the redirect plugin.

let me explain.

10% of my posts its look like..

http://and the encoded url...

when you click on it you get something like..

http://http://rapidshare%2ffiles%2f/...f/filename.htm

all the / on the url after click is still %2f% and the double http is there..

if there is no fix for me its ok byt for other future members maybe its not ok..

(also after unistall the links is still 2f%31%30%32%37%32%31%33%35%2f%41%6b%74%69%5f%50%65 %69%72%61%69%6f%73%5f%32%30% 30%36%5f%43%44%5f%31%2e%72%61%72) this is the biger problem because if you need edit the link its not possible.

This is a great mod, but is there a way to Anonymize links coming out of certain sections?

For example, www.google.com in the General area will go straight to google, but www.google.com in the Advertising area will go through vBAnonymizer...