Attachment BB code help

[gullbird]

i have some threads where attachments were added as

[attachment=223]tigeraugusta.jpg[/attachment]

223 is threads id which do not exist any more as ids got changed during a custom made database import
files are hosted on server
is there a way to replace "=123]" with "]" as we used in vb4 cleaner.php
or any other mean creating bbcode based on above so it become an IMG bb code

[Lynne]

Even if you could change it to

[attachment]tigeraugusta.jpg[/attachment]

That isn't going to link to anything. In fact, that isn't even valid BBCODE in vbulletin. vbulletin would use [ATTACH], not [ATTACHMENT] and it would use a number that identifies a specific attachment in the database table. So really, if that is what you have in the posts, you will want to remove the whole thing, not change it.

[gullbird]

[attachment]tigeraugusta.jpg[/attachment]

if i can have something like above and able to remove IDs so i can make a custom BBCODE
Files are located on server and file names are under bbcode
so with custom bbcode it could be

[IMG] <server URL>/bbcode-filename[/IMG]

is it not possible ?

--------------- Added [DATE]1410730780[/DATE] at [TIME]1410730780[/TIME] ---------------

any help how i can remove or change this bbcode

[gullbird]

i found a query from vb3 this is and i edited it with vb5 table name

UPDATE text SET rawtext = replace(rawtext,  '=223]', ']');

it will work ?
if so how i can setup this to find numbers because my 223 represents post ID of my old table

[gullbird]

Originally Posted by Lynne

Even if you..

wondering what are you doing here how much your 40k posts helped??
that's why i usually do not recommend vbulletin

regarding my question [tag=123] =123 will not create any problem if we set options to YES in custom BB Code

[ozzy47]

Originally Posted by gullbird

wondering what are you doing here how much your 40k posts helped??
that's why i usually do not recommend vbulletin

regarding my question [tag=123] =123 will not create any problem if we set options to YES in custom BB Code

That's not a very nice response, and not the best way to get someone to help you in their spare time, on a voluntary basis.

[Lynne]

I don't know the answer to your question off the top of my head. I would need to google it. I was hoping someone who is better at writing queries would be able to help you.

You do realize that vbulletin.org is run by volunteers, don't you? We aren't required to be here to help people. We do this in our spare time.

[gullbird]

Ahh yes i am sorry Lynne really it was not a nice response by me