Previous Thread
Next Thread
Print Thread
Rate Thread
[7.x] [Beta] Purge Welcome Messages #312289
12/18/2006 8:55 PM
12/18/2006 8:55 PM
Joined: Jan 2000
Posts: 5,938
Portland, OR, USA
Gizmo Offline OP

UBB.Dev / UBB.Wiki Owner
Time Lord
Gizmo  Offline OP

UBB.Dev / UBB.Wiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,938
Portland, OR, USA
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 (82 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
12/19/2006 12:02 AM
Joined: Mar 2000
Posts: 25,587
Texas
AllenAyres Offline
I type Like navaho
AllenAyres  Offline
I type Like navaho
Joined: Mar 2000
Posts: 25,587
Texas
Cool, thanks laugh


- Allen wavey
- What Drives You?
Re: [7.x] Purge Welcome Messages [Re: AllenAyres] #312292
12/19/2006 3:18 AM
12/19/2006 3:18 AM
Joined: Jan 2000
Posts: 5,938
Portland, OR, USA
Gizmo Offline OP

UBB.Dev / UBB.Wiki Owner
Time Lord
Gizmo  Offline OP

UBB.Dev / UBB.Wiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,938
Portland, OR, USA
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
12/28/2006 3:09 AM
Joined: May 1999
Posts: 110
Taiwan
S
smallufo Offline
Journeyman
smallufo  Offline
Journeyman
S
Joined: May 1999
Posts: 110
Taiwan
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
12/28/2006 4:05 AM
Joined: Jan 2000
Posts: 5,938
Portland, OR, USA
Gizmo Offline OP

UBB.Dev / UBB.Wiki Owner
Time Lord
Gizmo  Offline OP

UBB.Dev / UBB.Wiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,938
Portland, OR, USA
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
08/20/2007 12:37 AM
Joined: Jan 2000
Posts: 5,938
Portland, OR, USA
Gizmo Offline OP

UBB.Dev / UBB.Wiki Owner
Time Lord
Gizmo  Offline OP

UBB.Dev / UBB.Wiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,938
Portland, OR, USA
: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
09/27/2007 5:52 AM
Joined: Nov 2001
Posts: 137
M
MattUK Offline
Journeyman
MattUK  Offline
Journeyman
M
Joined: Nov 2001
Posts: 137
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
09/29/2007 1:35 AM
Joined: Mar 2000
Posts: 25,587
Texas
AllenAyres Offline
I type Like navaho
AllenAyres  Offline
I type Like navaho
Joined: Mar 2000
Posts: 25,587
Texas
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
09/29/2007 4:35 AM
Joined: Jan 2000
Posts: 5,938
Portland, OR, USA
Gizmo Offline OP

UBB.Dev / UBB.Wiki Owner
Time Lord
Gizmo  Offline OP

UBB.Dev / UBB.Wiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,938
Portland, OR, USA
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
03/26/2008 1:01 PM
Joined: Feb 2008
Posts: 458
PA
JAISP Offline
Enthusiast
JAISP  Offline
Enthusiast
Joined: Feb 2008
Posts: 458
PA
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
03/26/2008 7:04 PM
Joined: Jan 2000
Posts: 5,938
Portland, OR, USA
Gizmo Offline OP

UBB.Dev / UBB.Wiki Owner
Time Lord
Gizmo  Offline OP

UBB.Dev / UBB.Wiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,938
Portland, OR, USA
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
07/23/2008 11:17 AM
Joined: May 2008
Posts: 18
I
Iann128 Offline
Newbie
Iann128  Offline
Newbie
I
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
07/23/2008 11:28 AM
Joined: May 2008
Posts: 18
I
Iann128 Offline
Newbie
Iann128  Offline
Newbie
I
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
07/23/2008 6:58 PM
Joined: Jan 2000
Posts: 5,938
Portland, OR, USA
Gizmo Offline OP

UBB.Dev / UBB.Wiki Owner
Time Lord
Gizmo  Offline OP

UBB.Dev / UBB.Wiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,938
Portland, OR, USA
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
07/28/2011 12:05 PM
Joined: Mar 2010
Posts: 1
C
Chosen Offline
Lurker
Chosen  Offline
Lurker
C
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
· Blue Host
· Interserver.net
Visit Us on Facebook
Member Spotlight
Gizmo
Gizmo
Portland, OR, USA
Posts: 5,938
Joined: January 2000
Show All Member Profiles 
Forum Statistics
Forums64
Topics37,448
Posts293,484
Members13,793
Most Online1,498
Mar 17th, 2017
Top Posters(All Time)
AllenAyres 25,587
JoshPet 11,330
Rick 8,373
LK 7,396
Lord Dexter 6,503
Gizmo 5,938
Greg Hard 5,533
Top Posters(30 Days)
isaac 4
Today's Statistics
Currently Online 685
Topics Created 0
Posts Made 0
Users Online 0
Birthdays 18
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2018 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 7.6.2
(Preview build 20180611.dev)
Page Time: 0.092s Queries: 16 (0.049s) Memory: 3.3450 MB (Peak: 3.5716 MB) Zlib enabled. Server Time: 2018-06-19 01:22:53 UTC