Make sure you have a copy of the DB prior to any changes.

I'm not sure if I understand precisely what you're attempting to accomplish.

Are you trying to alter the custom embed BBCode content in every current post/topic, alter the actual topic ID's or both?

Assuming this is just for altering what's within your custom BBCode tags for: messages -> body
You can use custom server side code to manipulate MySQL data (ie. PHP) or you can use regexp on a MySQL command line.

MySQL command line (assuming the prefix is "smf_") :
UPDATE `smf_messages` SET `body` = CONCAT(
    SUBSTRING_INDEX(body, '[embed]', 1),
    '[/embed]',
    CAST(REGEXP_SUBSTR(body, '(?<=[embed])[0-9]+') AS UNSIGNED) - 500,
    '[/embed]',
    SUBSTRING_INDEX(body, '[embed]', -1)
)
WHERE body REGEXP '[embed][0-9]+[/embed]';

I have no idea if the above will work but it might give you something to test on a copy of the database to make sure it works as intended. If you can't figure it out with the above then I can delve into it further by running some tests on a localhost.
If you're using PHPMyAdmin, keep in mind that it's written in PHP & will time out for long queries unless you increase some PHP limits. Another option is to use MySQL via Bash which should avoid any script timeouts.
 

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>