Hello, on my SMF forum I have posts that are numbers within [embed][/embed] tags, example:

[embed]1[/embed]
[embed]2[/embed]
[embed]3[/embed]
[embed]4[/embed]

I have over 10,000 of these but need to remove some and need to decrement the numbers that are above this amount, such as 9001~9500, so that 9501 then becomes 9001 and 9502 becomes 9002 etc.

These are only in the smf_messages table of course.

Is it possible to do this in phpmyadmin with regex or would I need to download the .sql database and do it with something else?

Thanks.

Quote from: Dave on February 14, 2026, 02:31:37 AMThought it was just me at first.

Just tried with the post you deleted and now it's working OK

Not sure why but the newest post in the recycle board isn't removed again upon pressing the button again. Your post was removed fine but the latest one isn't

Version 1.8.1 has been released which includes membergroup allowance for viewing the Banner Bar.

Thought it was just me at first.

Just tried with the post you deleted and now it's working OK

Ya it's odd behavior...

It works fine for all boards except the recycle board where it leaves just the most recent topic as unread.
I will have to investigate as to why it's doing it.

I didn't realize exactly what you were referring to at first and clicked the button prior to focusing on the image/css.
Does this only occur for the recycle bin?
As soon as the next bot/spammer post gets tossed in there from my spam mod, I will test it.

Version 1.8 has been released which includes a toggle option to disable or enable Banner Bar for listed actions.

Not sure why but when I click on 'Mark all message read' it doesn't do it. Today I have clicked on the button 3 times and still the recycled post is showing unread

Use this code for .htaccess to host games from another domain:

You'll need to change the domain name(s) for these codes. These examples use example.com & exampletwo.com.

Multiple sites:
<IfModule mod_headers.c>
SetEnvIf Origin "http(s)?://(www\.)?(example.com|exampletwo.com)$" AccessControlAllowOrigin=$0
Header add Access-Control-Allow-Origin %{AccessControlAllowOrigin}e env=AccessControlAllowOrigin
Header merge Vary Origin
Header set Access-Control-Allow-Methods "GET, POST, OPTIONS"
Header set Access-Control-Allow-Headers "Content-Type, Authorization"
</IfModule>


---

Single site:
<IfModule mod_headers.c>   
    Header set Access-Control-Allow-Origin "https://example.com"   
    Header set Vary "Origin"
    Header set Access-Control-Allow-Methods "GET, POST, OPTIONS"
    Header set Access-Control-Allow-Headers "Content-Type, Authorization"
</IfModule>


Sorry that I missed this but Happy New Year.

Holidays always seem to be the busiest time for me.