Administrative and Maintenance Tools - 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 .

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!

[uwebgg]

it does not work with 3.8.x :-(

[Mark.B]

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.

[pedroenf]

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

[pedroenf]

Updating:

It does work on 3.8.1.

[stamos2003]

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

[pedroenf]

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!!!

[masterme]

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.

[pedroenf]

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!

Stated above.

[masterme]

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...

[Artes_Marciales]

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

Thanks!!