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.

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

[T3MEDIA]

Please let us know. I would like to install this as well.

[trackpads]

Great work!! Thanks!!

[T3MEDIA]

Originally Posted by T3MEDIA

Please let us know. I would like to install this as well.

::bump:: polite.

[trackpads]

Originally Posted by T3MEDIA

::bump:: polite.

Any have any idea how to change it from 30 days? I want them pruned after 180 days for example.

thanks again,

-Jason

[GenSec]

Originally Posted by trackpads

Any have any idea how to change it from 30 days? I want them pruned after 180 days for example.

thanks again,

-Jason

In cleanoldpm.php change

PHP Code:

        WHERE pmtext.dateline < " . (TIMENOW - 2592000) . " 


to

PHP Code:

        WHERE pmtext.dateline < " . (TIMENOW - 15552000) . "