UBB.threads PHP Forum Software Community Forums UBB.threads 7 Version 7 Support Purging Welcome Messages

When importing your old forum to your test forum you'll notice that some pm's you've deleted in the past have come back, this is because they are linked from the other user involved in the message's inbox.

You'll find that a lot of these are the "Welcome to our forums" pm's that many of you have enabled; in larger forums you'll have quite the bombardement...

Well, just load up your control panel and run the follwoing SQL Query (Tools -> Database Tools -> SQL Command):

Now, you'll want to make sure that you replace "welcome to our" with the subject line of your welcome message. There are two queries because of the two sql tables used.

Since I have used several similar but not exact lines I am using a wildcard search to nuke old pm's.

danke

will probably want to remove from PRIVATE_MESSAGE_USERS as well, since it's 2 rows per pm

removing from PRIVATE_MESSAGE_USERS will be a smidge harder, as theres not really anything to search by lol.

any automagic way of getting rid of the hundreds now in my inbox?

:shrug: dont' feel like doing another importer to see why it woudln't work :x...