|
|
|
|
Joined: Aug 2002
Posts: 218
Member
|
|
Member
Joined: Aug 2002
Posts: 218 |
Hi,
I want to know if its possible to delete red/unread PMs with a special Subject via SQL Query?
I have several passive users which are not reading their PMs and over the month it got more and more.
Actually there are more then 7000PMs in the system and I bet that nearly 5000 are old crap.
1. How to delete PMs with a special subject via SQL query?
2. How to delete PMs older than X days via SQL query?
Thanks in advance
jluerken
|
|
|
|
|
Joined: Nov 2001
Posts: 10,369
I type Like navaho
|
|
I type Like navaho
Joined: Nov 2001
Posts: 10,369 |
It's best to delete them through the admin panel... you can delete messages X days old through the admin interface.
|
|
|
|
|
Joined: Aug 2000
Posts: 1,609
Addict
|
|
Addict
Joined: Aug 2000
Posts: 1,609 |
I made a copy of and edited admin/dopurgemessages.php so that I can run it as a cron to automatically delete all PMs older than 30 days. Sounds like it might be something you'd want to look into.
|
|
|
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.
|
|
|
Posts: 87
Joined: December 2001
|
|
|
Forums63
Topics37,573
Posts293,925
Members13,849
| |
Most Online5,166
Sep 15th, 2019
|
|
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
|
|
|
|
|
|
