Prune PMs older than 30 days

These hack adds a cron job to prune old PMs for vBulletin 3.

======================
Upload the attached .php file
======================

includes/cron directory
cleanoldpm.php

========================
Make a vB-Cron entry
========================

Go to admin controlpanel

1) Scheduled Tasks
2) Add New Scheduled Task with the following data

Titel: Prune PMs older 30 days
weekday: *
day of month: *
hour: 0
minute: 0
enable log: no
filename: ./includes/cron/cleanoldpm.php


Thats all.

[Polo]

mmm.. this hack may come in handy thanks GenSec for sharing

[frankenberrie]

This hack will be great for the Arcade mod - Most members never delete their old challenge pms-

[dssstorm]

He rock's

[paulyy]

Nice hack

[alkahf]

Hello GenSec
Before install hack
Private Messages: 2 Unread, Total 280.
After installed hack:
The same numbers: Private Messages: 2 Unread, Total 280.
But I have now only 5 PMs.
How fix it ?

akahf

[GenSec]

Run the cron job

[alkahf]

Originally Posted by GenSec

Run the cron job

I run it.
It is deleted PMs but the PM numbers count in Nav Bar not change !!
Do you see?

Regards

[Vman]

This is great!.......Can't wait for more cron jobs to become available for download...

Thanks!

[allhandl]

if I PM a user and they dont logon on within the 30 days the PM is wiped off the server as the hack states. However when they logon the navbar states they have a message. When you go to inbox it says it is empty.

Whats worse is there is no way to delete it out of there?

Im a newbie but it almost looks like the PM is getting deleted however the 'messageread' table in db isnt being effected. This only happens when a user does not view the message within the 30 days. If I read a PM and leave in inbox it deletes with no problems.

Anyone having similar problem or has a solution?

[TTG]

Very useful .. thanks for the hack.
Clicked install

[wowthatnice]

Originally Posted by alkahf

I run it.
It is deleted PMs but the PM numbers count in Nav Bar not change !!
Do you see?

Regards

Do this, open cleanoldpm.php find

PHP Code:

$DB_site->free_result($oldpms); 


below add

PHP Code:

// update the pm counters for $bbuserinfo. Uha 12/10/2004
$bbuserinfo = $DB_site->query_first("
        SELECT userid, pmtotal, pmunread
            FROM " . TABLE_PREFIX . "user
        ");
            
    $bbuserinfo['userid'] = intval($bbuserinfo['userid']);
    $bbuserinfo['pmtotal'] = intval($bbuserinfo['pmtotal']);
    $bbuserinfo['pmunread'] = intval($bbuserinfo['pmunread']);
    
$pmcount = $DB_site->query_first("
        SELECT
            COUNT(pmid) AS pmtotal,
            SUM(IF(messageread = 0 AND folderid = 0, 1, 0)) AS pmunread
        FROM " . TABLE_PREFIX . "pm AS pm
        WHERE pm.userid = $bbuserinfo[userid]
    ");

    $pmcount['pmtotal'] = intval($pmcount['pmtotal']);
    $pmcount['pmunread'] = intval($pmcount['pmunread']);
    
if ($bbuserinfo['pmtotal'] != $pmcount['pmtotal'] OR $bbuserinfo['pmunread'] != $pmcount['pmunread'])
    {
        $DB_site->query("
            UPDATE " . TABLE_PREFIX . "user SET
                pmtotal = $pmcount[pmtotal],
                pmunread = $pmcount[pmunread]
            WHERE userid = $bbuserinfo[userid]
        ");
    }
    
$DB_site->free_result($bbuserinfo);
$DB_site->free_result($pmcount); 


My friend just fix that for me.

Have fun.

[alkahf]

Thankyou wowthatnice
I'll try this change.

Regards

[alkahf]

The same problem,
Not change PM's counters.
Is it working with you wowthatnice ?

[wowthatnice]

Yeah, I been test it out and it work great without any error. But what do you get? it not update at all? Let me ask him again becuase when I ask him he only take around 3 minutes to make it for me and he didn't even test it.