Previous Thread
Next Thread
Print Thread
Rate Thread
[7.x] [Beta] Purge Welcome Messages #312289
12/18/2006 7:55 PM
12/18/2006 7:55 PM
Joined: Jan 2000
Posts: 5,947
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,947
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.SitemapsJames Corthell
Sponsored Links
Re: [7.x] Purge Welcome Messages [Re: Gizmo] #312290
12/18/2006 11:02 PM
12/18/2006 11:02 PM
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 2:18 AM
12/19/2006 2:18 AM
Joined: Jan 2000
Posts: 5,947
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,947
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.SitemapsJames Corthell
Re: [7.x] Purge Welcome Messages [Re: Gizmo] #312397
12/28/2006 2:09 AM
12/28/2006 2: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 3:05 AM
12/28/2006 3:05 AM
Joined: Jan 2000
Posts: 5,947
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,947
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.SitemapsJames Corthell
Sponsored Links
Re: [7.x] Purge Welcome Messages [Re: Gizmo] #315300
08/19/2007 11:37 PM
08/19/2007 11:37 PM
Joined: Jan 2000
Posts: 5,947
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,947
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.SitemapsJames Corthell
Re: [7.x] Purge Welcome Messages [Re: Gizmo] #315877
09/27/2007 4:52 AM
09/27/2007 4: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 12:35 AM
09/29/2007 12: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 3:35 AM
09/29/2007 3:35 AM
Joined: Jan 2000
Posts: 5,947
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,947
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.SitemapsJames Corthell
Re: [7.x] Purge Welcome Messages [Re: Gizmo] #316812
03/26/2008 12:01 PM
03/26/2008 12: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 6:04 PM
03/26/2008 6:04 PM
Joined: Jan 2000
Posts: 5,947
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,947
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.SitemapsJames Corthell
Re: [7.x] Purge Welcome Messages [Re: Gizmo] #317440
07/23/2008 10:17 AM
07/23/2008 10: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 10:28 AM
07/23/2008 10: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 5:58 PM
07/23/2008 5:58 PM
Joined: Jan 2000
Posts: 5,947
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,947
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.SitemapsJames Corthell
Re: [7.x] Purge Welcome Messages [Re: Gizmo] #318864
07/28/2011 11:05 AM
07/28/2011 11:05 AM
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
Bill B
Bill B
Issaquah, WA
Posts: 84
Joined: December 2001
Show All Member Profiles 
Forum Statistics
Forums64
Topics37,466
Posts293,522
Members13,801
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,947
Greg Hard 5,533
Top Posters(30 Days)
isaac 1
Today's Statistics
Currently Online 811
Topics Created 0
Posts Made 0
Users Online 0
Birthdays 10
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2018 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 7.7.0
(Snapshot build 20181115.dev)
PHP: 5.4.45 Page Time: 0.043s Queries: 16 (0.012s) Memory: 3.2818 MB (Peak: 3.5084 MB) Data Comp: Zlib Server Time: 2018-12-11 05:40:59 UTC