Periodic Prune Pms [ Cron Job - Fully Controlable ]
 

/*================================================* \
|| ################################################ ||
|| # Product Name: Periodic Prune Pms ......................... Version: 1.0.0 # ||
|| # Licence Number: Free License .................................................. .... # ||
|| # --------------------------------------------------------------------------------- # ||
|| # .................................................. .................................................. # ||
|| # ..... Copyright ?2005-2008 PHP KingDom. Some Rights Reserved. ...... # ||
|| # .... This file may be redistributed in whole or significant part under ..... # ||
|| # .. "Creative Commons - Attribution-Noncommercial-Share Alike 3.0" ... # ||
|| # .................................................. .................................................. # ||
|| # ---------------- 'Periodic Prune Pms' IS FREE SOFTWARE ---------------- # ||
|| # .... http://www.phpkd.net | http://www.phpkd.net/info/license/free .... # ||
|| ################################################ ||
\*================================================ */


Please remember to click Mark as Installed if you use this modification.
Support questions from members who have not marked this as installed will be considered low priority.


Many thanks:

• All vBulletin experts.
• vBulletin.com for their professional products and premium support.
• vBulletin.org for their articles, mods [Thanks also to articles' authors & mod coders].

Name: Periodic Prune Pms

Descreption: This mod allows forum administration to specify a period after which all pms of users will be deleted (Per Usergroup).

How it works:
Nothing complex, it's just a cronjob.

Features:

• Specific Features:
  • Can enable/disable mod globally. v1.0.0
  • Can specify which folders to be pruned (All Folders / Just Inbox / Just Outbox / All folders other that inbox & outbox). v1.0.0
  • Can specify which PMs to be deleted [Message Status] (Read / Unread / Both). v1.0.0
• Default Features:
  • Supported.
  • Fully phrased.
  • Uses Bitfields.
  • MD5 Hash checked.
  • Logging cronjob runs.
  • Fully controllable from AdminCP.
  • Doesn't require any manual edits.
  • Fully compatible with vBulletin 3.7.x series.
  • Will not alter environment of vb or other hacks.
  • cronjob controlled from Scheduled tasks as normal vB Crons.

Help Us:

• With your brilliant suggestions, ideas to develop this mod.
• With your appreciated translations (translation credits go to their owners).

Known Isues:

• None till now.

History:

• v1.0.0 20/5/2008 07:07 AM (EEST): First initial public release.

Notes:

1. Mod is disabled by default, you should enable it from AdminCP options.
2. cronjob run once daily (at midnight), you can configure it from 'Scheduled Task Manager'.
3. Supported languages of this mod is available as a translated product not as language files, each product has an attribution at it's end defines the it's language (ie: -[English]).
4. This mod is supposed to work with vBulletin 3.5.x & 3.6.x series, but we don't support versions prior 3.7.x series!

Files Tree:

• import
  • product-phpkd_periodic_prune_pms-[Lang Name].xml
• upload
  • includes
    • cron
      • prunepms.php
    • xml
      • bitfield_phpkd_periodic_prune_pms.xml
    • md5_sums_phpkd_periodic_prune_pms.php

Screen Shots:

• Available down there.

Technical Notes:

• Plugins: 0
• New Files: 3
• File Edits: 0
• New Templates: 0
• Template Edits: 0
• New Database Tables: 0
• Database Alterations: 1
• New Phrases: 19
• New Options: 3
• Cron Jops: 1

Installation Procedure:

• Import the product file from your AdminCP.
• Upload all the content of the upload folder to your forum ROOT.
• Done :cool: .

Control:

• AdminCP -> vbulletin options -> Periodic Prune PMs Settings
• AdminCP -> Usergroups -> Usergroup Manager -> Periodic Prune PMs Permissions
• AdminCP -> Scheduled Tasks -> Scheduled Task Manager -> Prune PMs

At the end:

• Thanks to all of you for supporting us by installing our products.

Other Products:

• Advanced Quick Reply - vB 3.7.x
• Advanced Quick Edit - vB 3.7.x

Keep Moving Forward!

If It will Send a PM Message to user to inform them we gone to delete there PM's Just to let them get copy of any messages ..

Thanks ..

Thanks for your suggestion.
I think it should be an administration notice shown per usergroup if that usergroup's PMs setup to be deleted, may be shown in all pages or in the PM system.

It will be implemented in the next version.

Any other suggestions ...?

Works great for me. :)

Nice! Installed :)

Genius idea actually should clear up some space on my MYSQL :)

Looks good thanks...

thanks

Great job, thankyou.

You are welcome :).

thanks & it in ARABIC

thanks

thanks

You are welcome.
There is two product in the 'import' folder, one in English & the other in Arabic.

product-phpkd_periodic_prune_pms-[English].xml
product-phpkd_periodic_prune_pms-[Arabic].xml

You can choose what you want.

Does this update the PM total counters afterwards?

Yes, It updates counters for every user undergo this process :).

Good idea... does it work on 3.7.0 or later version?

Hi!
I was looking for this but can you make a tiny modification?
You'll see, I dont want to empty all users inbox, I just want to prune PM whose date is > today+10 days for example, so every user know that any PM will be deleted when it reaches 10 days old, so I always free space from PM form active and inactive users but it wont prune todays PM.
Tnx!

Very nice - I suppose you can disable the automatic cron job via AdminCP and only run whenever you want to manually delete all PMs?

Nice hack though - I requested something like this a while ago - nice to see such a feature - should be good.

Thanx for sharing.

Jacquii.

ps - Install reserved for board upgrade.

ah ok, I thought it would prume all messages not x day ols msgs
Tnx

This is what I did. Works great. Nice product. installed :)

Thanx ;)

Jacquii.

Thanks for the good job.

It has been installed.

Q: Putting ZERO days at "Prune PMs X days" field of the usergroup settings, Does it disable the mod for a usergroup.


Thanks

great idea!
** install **

Just so other 3.6.4 users will know not to waste their time, this mod is not compatible with your version of vbulletin.

Thats sucks, I really need to flush the pm system on my board.

Works great for me , Installed :)

it does not work with 3.8.x :-(

To me there seems to be on flaw in this, and that's that it only prunes from the pm table. It needs to do pmtext as well, otherwise you're leaving the bulk of the data in the database.

Could it be re-made to work in 3.8.X? It would be great. I have tried in 3.8.1 and no luck :(

Updating:

It does work on 3.8.1.

it's not working on 3.8x
though the pmtext table is not pruned too, this lets a mass of dead text in the database :(

For me it is working fine. It takes a while to get the job done but it does!

My PM tables before pruned (older than 1 year):

VBPM 26,6MB
Format fixed
Collation latin1_swedish_ci
Rows 520,364
Row length ø 21
Row size ø 54 Bytes
Next Autoindex 806,562

VBPMReceipt 21,7KB
Format dynamic
Collation latin1_swedish_ci
Rows 189
Row length ø 58
Row size ø 118 Bytes

VBPMText 63,3MB
Format dynamic
Collation latin1_swedish_ci
Rows 142,364
Row length ø 441
Row size ø 466 Bytes
Next Autoindex 233,864

My tables after pruned:

VBPM 12,6MB
Format fixed
Collation latin1_swedish_ci
Rows 245,613
Row length ø 21
Row size ø 54 Bytes
Next Autoindex 811,408

VBPMReceipt 20,9KB
Format dynamic
Collation latin1_swedish_ci
Rows 173
Row length ø 58
Row size ø 123 Bytes

VBPMText 32,8MB
Format dynamic
Collation latin1_swedish_ci
Rows 55,058
Row length ø 599
Row size ø 624 Bytes
Next Autoindex 236,758

As you can see lots of Mb where gone from my PM tables, and i didn't hand deleted them!!!

Does it work on 3.6.5?
If not, why is there a redirect from the 3.6 mods to this one telling we must use this one instead the 3.6.x version.

Stated above.

And?
If you read the comments people who use it on older versions than 3.7 should work, but they often don't. And in the older versions of this mod they say we must use this version. So what is so strange about my question? If they say we must use this version, they must also give support. But he, that is my opinion...

Great Mod!!!
¿work with 3.8.3???

Thanks!!