edit: i just figured a quicker and painless way of doing this... just resubmit the posts. edit + do nothing + submit = clean urls. i'll just do this as i come along them.

Yup, because preparse gets called on them

[ url=\"http:

with the extra backslash. i've tried to find and replace with the url structure in my first post but it found 0 instances of the wrong url. i tried with the url structure i just found and it found 1800+ of them. i'm going to try this on a test board either later tonight or tomorrow. i'll post the results.

edit: why does the urls in the sql file have that slash?

If the VB url's are like the top example you posted, the parser strips the ""'s by default.

It strips them in preparse, which gets applied to posts before they're put into the database. Hence my suggestion

why not download the sql and then open the sql and then replace [ url=" for [ url= and "] to ]
should that not be the easiest way?

sql is greek to me but i'll give it a shot. not right now but i'll post here the results... or progress rather.

thanks for the quick replies.

the vb urls look like this:

[ url="http://www.website.com"]text[ /url]

which produces a url like this:

http://"http//www.website.com

and as you know the PunBB ones look like this:

[ url=http://www.website.com]text[ /url]

without the quotes. so i'd imagine that the query would have to go through all the urls and remove the quotes ONLY in those kind of urls.

any help would be appreciated.

oh, forgot to post a link to an example.
http://theplatoon.com/viewtopic.php?id=27  first post by me.