Hi
First of all I hope this is posted in the appropriate forum. I have been searching for ages and cannot find something already discussed to help me.
Like so many folks that have migrated from another forum software phpbb3, I have an issue with getting attachments to appear inline.
I have walked through the issue I need to overcome and I think it boils down to an sql statement I need to run on the post table.
phpbb3 inserts attachments inline using (example) [attachment=0]someimagename.jpg[/attachment] where 0=the attachment order within the post - but that seems irrelevent now
When I import the attachments (successfully) into vBulletin 4.2 using Impex, the code from the phpbb3 post now shows something like [attachment=0:381rc3pg]someimagename.jpg[/attachment:381rc3pg]
The vBulletin attachment table holds the attachment.filename "someimageattachment.jpg" and also the attachment.attachmentid "3712" and if I manually edit the post to show [ATTACH]3712[/ATTACH] the image appears inline, just how it did on phpbb3.
The post table for the particular post containing the attachment holds post.pagetext with a story & the string [attachment=0:381rc3pg]someimagename.jpg[/attachment:381rc3pg]
I believe I need to run a query on the post table to find all instances of [attachment???] & [/attachment???] & replace both with [ATTACH]&[/ATTACH] and secondly find the attachment.attachmentid from the attachment.filename and replace that accordingly where it appears in the post.pagetext.
Hopefully some knowledgable folks here can advise me as to how I write the query.
Looking forward to your response.
Thanks very much
First of all I hope this is posted in the appropriate forum. I have been searching for ages and cannot find something already discussed to help me.
Like so many folks that have migrated from another forum software phpbb3, I have an issue with getting attachments to appear inline.
I have walked through the issue I need to overcome and I think it boils down to an sql statement I need to run on the post table.
phpbb3 inserts attachments inline using (example) [attachment=0]someimagename.jpg[/attachment] where 0=the attachment order within the post - but that seems irrelevent now
When I import the attachments (successfully) into vBulletin 4.2 using Impex, the code from the phpbb3 post now shows something like [attachment=0:381rc3pg]someimagename.jpg[/attachment:381rc3pg]
The vBulletin attachment table holds the attachment.filename "someimageattachment.jpg" and also the attachment.attachmentid "3712" and if I manually edit the post to show [ATTACH]3712[/ATTACH] the image appears inline, just how it did on phpbb3.
The post table for the particular post containing the attachment holds post.pagetext with a story & the string [attachment=0:381rc3pg]someimagename.jpg[/attachment:381rc3pg]
I believe I need to run a query on the post table to find all instances of [attachment???] & [/attachment???] & replace both with [ATTACH]&[/ATTACH] and secondly find the attachment.attachmentid from the attachment.filename and replace that accordingly where it appears in the post.pagetext.
Hopefully some knowledgable folks here can advise me as to how I write the query.
Looking forward to your response.
Thanks very much
Comment