Previous Thread
Next Thread
Print Thread
Rate Thread
[7.x] [Beta] Purge Welcome Messages #312289 12/18/2006 8:55 PM
Joined: Jan 2000
Posts: 5,786
Gizmo Offline OP
UBB.Dev / UBB.Wiki Owner
Time Lord
OP Offline
UBB.Dev / UBB.Wiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,786
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!

Attached Files
2310-purgewelcomes.zip (952 Bytes, 83 downloads)

UBB.Dev - Putting Dev into UBB.threads
Company: VNC Web Services - UBB.threads Scripts and Scripting, Install and Upgrade Services, Site and Server Maintenance.
Forums: A Gardeners Forum, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, UBB.Sitemaps
Sponsored Links
Re: [7.x] Purge Welcome Messages [Re: Gizmo] #312290 12/19/2006 12:02 AM
Joined: Mar 2000
Posts: 21,079
AllenAyres Offline
I type Like navaho
Offline
I type Like navaho
Joined: Mar 2000
Posts: 21,079
Cool, thanks laugh


- Allen wavey
- What Drives You?
Re: [7.x] Purge Welcome Messages [Re: AllenAyres] #312292 12/19/2006 3:18 AM
Joined: Jan 2000
Posts: 5,786
Gizmo Offline OP
UBB.Dev / UBB.Wiki Owner
Time Lord
OP Offline
UBB.Dev / UBB.Wiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,786
You're welcome hehe... I was meaning to get it out for the initial 7.0 beta but time didn't permit frown... 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.


UBB.Dev - Putting Dev into UBB.threads
Company: VNC Web Services - UBB.threads Scripts and Scripting, Install and Upgrade Services, Site and Server Maintenance.
Forums: A Gardeners Forum, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, UBB.Sitemaps
Re: [7.x] Purge Welcome Messages [Re: Gizmo] #312397 12/28/2006 3:09 AM
Joined: May 1999
Posts: 39
smallufo Offline
Journeyman
Offline
Journeyman
Joined: May 1999
Posts: 39
Wow , thank you very much.....
It helps me a lot....

Re: [7.x] Purge Welcome Messages [Re: smallufo] #312398 12/28/2006 4:05 AM
Joined: Jan 2000
Posts: 5,786
Gizmo Offline OP
UBB.Dev / UBB.Wiki Owner
Time Lord
OP Offline
UBB.Dev / UBB.Wiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,786
I'm glad to hear it helped (and worked as intended); was it easy to follow/understand? I tried to make it fairly painless...


UBB.Dev - Putting Dev into UBB.threads
Company: VNC Web Services - UBB.threads Scripts and Scripting, Install and Upgrade Services, Site and Server Maintenance.
Forums: A Gardeners Forum, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, UBB.Sitemaps
Sponsored Links
Re: [7.x] Purge Welcome Messages [Re: Gizmo] #315300 08/20/2007 12:37 AM
Joined: Jan 2000
Posts: 5,786
Gizmo Offline OP
UBB.Dev / UBB.Wiki Owner
Time Lord
OP Offline
UBB.Dev / UBB.Wiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,786
:bump: for AA wink...


UBB.Dev - Putting Dev into UBB.threads
Company: VNC Web Services - UBB.threads Scripts and Scripting, Install and Upgrade Services, Site and Server Maintenance.
Forums: A Gardeners Forum, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, UBB.Sitemaps
Re: [7.x] Purge Welcome Messages [Re: Gizmo] #315877 09/27/2007 5:52 AM
Joined: Nov 2001
Posts: 134
MattUK Offline
Journeyman
Offline
Journeyman
Joined: Nov 2001
Posts: 134
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

Re: [7.x] Purge Welcome Messages [Re: MattUK] #315891 09/29/2007 1:35 AM
Joined: Mar 2000
Posts: 21,079
AllenAyres Offline
I type Like navaho
Offline
I type Like navaho
Joined: Mar 2000
Posts: 21,079
when do you get that error?


- Allen wavey
- What Drives You?
Re: [7.x] Purge Welcome Messages [Re: AllenAyres] #315892 09/29/2007 4:35 AM
Joined: Jan 2000
Posts: 5,786
Gizmo Offline OP
UBB.Dev / UBB.Wiki Owner
Time Lord
OP Offline
UBB.Dev / UBB.Wiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,786
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...


UBB.Dev - Putting Dev into UBB.threads
Company: VNC Web Services - UBB.threads Scripts and Scripting, Install and Upgrade Services, Site and Server Maintenance.
Forums: A Gardeners Forum, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, UBB.Sitemaps
Re: [7.x] Purge Welcome Messages [Re: Gizmo] #316812 03/26/2008 1:01 PM
Joined: Feb 2008
Posts: 448
JAISP Offline
Enthusiast
Offline
Enthusiast
Joined: Feb 2008
Posts: 448
I can't open the zip file. Not a valid archive!!

Can you help me out Gizmo?

Sponsored Links
Re: [7.x] Purge Welcome Messages [Re: JAISP] #316818 03/26/2008 7:04 PM
Joined: Jan 2000
Posts: 5,786
Gizmo Offline OP
UBB.Dev / UBB.Wiki Owner
Time Lord
OP Offline
UBB.Dev / UBB.Wiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,786
It unzips without issues for me; what are you using to open the archive?


UBB.Dev - Putting Dev into UBB.threads
Company: VNC Web Services - UBB.threads Scripts and Scripting, Install and Upgrade Services, Site and Server Maintenance.
Forums: A Gardeners Forum, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, UBB.Sitemaps
Re: [7.x] Purge Welcome Messages [Re: Gizmo] #317440 07/23/2008 11:17 AM
Joined: May 2008
Posts: 18
Iann128 Offline
Newbie
Offline
Newbie
Joined: May 2008
Posts: 18
Gizmo I am getting the same error, I edited the file and added my DB info.. frown

Ian

Re: [7.x] Purge Welcome Messages [Re: Iann128] #317441 07/23/2008 11:28 AM
Joined: May 2008
Posts: 18
Iann128 Offline
Newbie
Offline
Newbie
Joined: May 2008
Posts: 18
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

Re: [7.x] Purge Welcome Messages [Re: Iann128] #317446 07/23/2008 6:58 PM
Joined: Jan 2000
Posts: 5,786
Gizmo Offline OP
UBB.Dev / UBB.Wiki Owner
Time Lord
OP Offline
UBB.Dev / UBB.Wiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,786
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.


UBB.Dev - Putting Dev into UBB.threads
Company: VNC Web Services - UBB.threads Scripts and Scripting, Install and Upgrade Services, Site and Server Maintenance.
Forums: A Gardeners Forum, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, UBB.Sitemaps
Re: [7.x] Purge Welcome Messages [Re: Gizmo] #318864 07/28/2011 12:05 PM
Joined: Mar 2010
Posts: 1
Chosen Offline
Lurker
Offline
Lurker
Joined: Mar 2010
Posts: 1
I have been cleaning out some things on my forum and realized that I had a ton of welcome messages wasting space. Thanks for the file, even if it is 5 years later.


Donate Today!
Donate via PayPal

Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.

Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
Recommended Hosts
We have personally worked with and recommend the following Web Hosts:
Stable Host
bluehost
InterServer
Visit us on Facebook
Member Spotlight
Nettomo
Nettomo
Germany, Bremen
Posts: 417
Joined: November 2001
Forum Statistics
Forums63
Topics37,490
Posts293,665
Members13,828
Most Online5,166
Sep 15th, 2019
Top Posters(All Time)
AllenAyres 21,079
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,786
Greg Hard 4,625
Top Posters(30 Days)
isaac 4
Today's Statistics
Currently Online 1426
Topics Created 0
Posts Made 0
Users Online 0
Birthdays 21
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2019 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Snapshot build 20191013.dev)
Responsive Width:

PHP: 5.4.45 Page Time: 0.049s Queries: 16 (0.016s) Memory: 3.3176 MB (Peak: 3.5491 MB) Data Comp: Zlib Server Time: 2019-10-21 15:52:50 UTC
Valid HTML 5 and Valid CSS