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