[thincom2000]

Ah, I should have checked the PM table before writing that . It's not pmunread but messageread. That will require a slight code modification, but you shouldn't get a database error with this:

PHP Code:

<?php

// ####################### SET PHP ENVIRONMENT ###########################
error_reporting(E_ALL & ~E_NOTICE);

// ############# REQUIRE BACK-END #######################

require_once('./global.php');


// ############# UPDATE PM COUNTS IN USER TABLE #######################

if($vbulletin->userinfo['usergroupid'] != '6'){
        exit();
    }


// Get all users PMs
$pmdata = $db->query_first("
    SELECT user.userid, user.pmtotal, user.pmunread,
        pm.messageread, pm.pmid
    FROM " . TABLE_PREFIX . "user AS user
    LEFT JOIN " . TABLE_PREFIX . "pm AS pm ON(pm.userid = user.userid)
    WHERE user.userid != 0
    ORDER BY user.userid ASC
");

while ($pms = $db->fetch_array($pmdata))
{
    $lastuser = ($lastuser == $pms['userid']) ? true : false;
    $pmtotal = $lastuser ? $pmtotal : 0;
    $pmunread = $lastuser ? $pmunread : 0;

    if ($pms['pmid'])
    {
        $pmtotal++;

        if (!$pms['messageread'])
        {
            $pmunread++;
        }
    }

    $pmusers["$pms[userid]"] = array(
        'true_total'  => $pmtotal,
        'user_total'  => $pms['pmtotal'],
        'true_unread' => $pmunread,
        'user_unread' => $pms['pmunread']
    );
}
$db->free_result($pmdata);
unset($pms, $pmtotal, $pmunread, $lastuser);

foreach ($pmusers AS $pmuserid => $pminfo)
{
    if (($pminfo['true_total'] != $pminfo['user_total']) OR ($pminfo['true_unread'] != $pminfo['user_unread']))
    {
        $db->query_write("
            UPDATE " . TABLE_PREFIX . "user 
            SET pmtotal = $pminfo[true_total],
                pmunread = $pminfo[true_unread]
            WHERE userid = $pmuserid
        ");
        echo "USERID $pmuserid was updated!<br />";
    }
}
unset($pmuserid, $pminfo, $pmusers);

echo 'All Done!';
?>

The MySQL manuals didn't help me at all when I was trying to learn joins either. Eventually I just had to figure out why what vBulletin did worked.