For those of you who've imported from another product and want to purge welcome messages, heres a quick addon for you.

Simply drop this file on your webserver and update your sql data, and edit the $welcome section, load the script in your browser, and any messages matching $welcome% will be purged.

$welcome is the string you want to match, and the script automatically links "like" topics (such as welcome to our forums, welcome to our site, etc. with the default match of "welcome".

This addon will purge from all pm tables, and not just the topics and posts table like prior mysql matches did, this will provide a CLEAN purge of welcome messages, versus only purging data from 2 of the 3 tables.

I will be working on a way to repair the users table for "botched" welcome message purges using the "alternate" means of just deleteing items from the database, not sure on an eta.

This should work anywhere UBB7 would work. If you have problems, let me know!

Cool, thanks

You're welcome hehe... I was meaning to get it out for the initial 7.0 beta but time didn't permit ... But I've got it now for everyone hehe...

I'm doing the one to fix the botched purges because I feel semi responsible since I was passing out the query lol... I haven't decided how to go about it yet though.

Wow , thank you very much.....
It helps me a lot....

I'm glad to hear it helped (and worked as intended); was it easy to follow/understand? I tried to make it fairly painless...

:bump: for AA ...

I get this error

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ''welcome%' USING latin1 )' at line 1

when do you get that error?

Have you edited the file at all, after adding your db information? I'm unsure as to why you'd get the error, it's a simple query...

I can't open the zip file. Not a valid archive!!

Can you help me out Gizmo?

It unzips without issues for me; what are you using to open the archive?

Gizmo I am getting the same error, I edited the file and added my DB info..

Ian

btw way I changed CONVERT( _utf8 '$subject%' USING latin1 ) to just '$subject%' and it ran, and cleared them all out. I verified it in phpadmin in my control panel.

Ian

Likely the cause may have een a syntax error with a version of mysql i was using vs what you're using... The change ofcoarse would be to do away with the convert line like you did.