No announcement yet.

Attachment code user post cleanup

This topic is closed.
  • Filter
  • Time
  • Show
Clear All
new posts

  • Attachment code user post cleanup

    Hello Guys,

    Can you please help me come up with a sql query which will delete this sort of content from all user posts (entire forum)?

    [attachment=8:1xeksqq9]Autumn Ring Mini_1.jpg[/attachment:1xeksqq9]
    [attachment=7:1xeksqq9]Circuit de la Sarthe 2009_2.jpg[/attachment:1xeksqq9]
    [attachment=6:1xeksqq9]High Speed Ring_1.jpg[/attachment:1xeksqq9]
    [attachment=5:1xeksqq9]Lazurowe Wybrzeże.jpg[/attachment:1xeksqq9]
    [attachment=4:1xeksqq9]Lazurowe Wybrzeże_1.jpg[/attachment:1xeksqq9]
    [attachment=3:1xeksqq9]Nürburgring 24h_2.jpg[/attachment:1xeksqq9]
    [attachment=2:1xeksqq9]Odcinek Specjalny - Route 7.jpg[/attachment:1xeksqq9]
    [attachment=1:1xeksqq9]Odcinek Specjalny - Route 7_1.jpg[/attachment:1xeksqq9]

    For example:

    So basicly we need something that will find and delete content with the following data in it:

    I did a upgrade from phpbb3 and I would like to clean up this mess. I made all of the attachments show up as images and im unable to include them as inline images them so I want to remove all of it and keep all of my attachments at the bottom of my posts (the basic/typical way).

  • #2
    There's already a thread for this:


    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.