Previous Thread
Next Thread
Print Thread
Rate Thread
Joined: Jan 2000
Posts: 5,819
Likes: 16
Gizmo Offline OP
UBBDev / UBBWiki Owner
Time Lord
OP Offline
UBBDev / UBBWiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,819
Likes: 16
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 Images
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, My UBB Scripts
Sponsored Links
Joined: Mar 2000
Posts: 21,079
Likes: 3
I type Like navaho
Offline
I type Like navaho
Joined: Mar 2000
Posts: 21,079
Likes: 3
Cool, thanks laugh


- Allen wavey
- What Drives You?
Joined: Jan 2000
Posts: 5,819
Likes: 16
Gizmo Offline OP
UBBDev / UBBWiki Owner
Time Lord
OP Offline
UBBDev / UBBWiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,819
Likes: 16
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, My UBB Scripts
Joined: May 1999
Posts: 39
S
Journeyman
Offline
Journeyman
S
Joined: May 1999
Posts: 39
Wow , thank you very much.....
It helps me a lot....

Joined: Jan 2000
Posts: 5,819
Likes: 16
Gizmo Offline OP
UBBDev / UBBWiki Owner
Time Lord
OP Offline
UBBDev / UBBWiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,819
Likes: 16
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, My UBB Scripts
Sponsored Links
Joined: Jan 2000
Posts: 5,819
Likes: 16
Gizmo Offline OP
UBBDev / UBBWiki Owner
Time Lord
OP Offline
UBBDev / UBBWiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,819
Likes: 16
: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, My UBB Scripts
Joined: Nov 2001
Posts: 134
M
Journeyman
Offline
Journeyman
M
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

Joined: Mar 2000
Posts: 21,079
Likes: 3
I type Like navaho
Offline
I type Like navaho
Joined: Mar 2000
Posts: 21,079
Likes: 3
when do you get that error?


- Allen wavey
- What Drives You?
Joined: Jan 2000
Posts: 5,819
Likes: 16
Gizmo Offline OP
UBBDev / UBBWiki Owner
Time Lord
OP Offline
UBBDev / UBBWiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,819
Likes: 16
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, My UBB Scripts
Joined: Feb 2008
Posts: 449
Enthusiast
Offline
Enthusiast
Joined: Feb 2008
Posts: 449
I can't open the zip file. Not a valid archive!!

Can you help me out Gizmo?

Sponsored Links
Joined: Jan 2000
Posts: 5,819
Likes: 16
Gizmo Offline OP
UBBDev / UBBWiki Owner
Time Lord
OP Offline
UBBDev / UBBWiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,819
Likes: 16
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, My UBB Scripts
Joined: May 2008
Posts: 18
I
Newbie
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

Joined: May 2008
Posts: 18
I
Newbie
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

Joined: Jan 2000
Posts: 5,819
Likes: 16
Gizmo Offline OP
UBBDev / UBBWiki Owner
Time Lord
OP Offline
UBBDev / UBBWiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,819
Likes: 16
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, My UBB Scripts
Joined: Mar 2010
Posts: 1
C
Lurker
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.


Link Copied to Clipboard
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
Bill B
Bill B
Issaquah, WA
Posts: 87
Joined: December 2001
Forum Statistics
Forums63
Topics37,557
Posts293,856
Members13,847
Most Online5,166
Sep 15th, 2019
Today's Statistics
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
Top Posters
AllenAyres 21,079
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,819
Greg Hard 4,625
Top Posters(30 Days)
Top Likes Received
isaac 70
Gizmo 16
Brett 7
WebGuy 2
Top Likes Received (30 Days)
None yet
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2021 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Snapshot build 20210915)
Responsive Width:

PHP: 7.3.29 Page Time: 0.033s Queries: 46 (0.017s) Memory: 0.8652 MB (Peak: 0.9667 MB) Data Comp: Zlib Server Time: 2021-10-20 20:18:42 UTC
Valid HTML 5 and Valid CSS