What's The Prob?

[That Rob Guy]

It's a problem in the profile.php file when you go to change your avatar, sig, etc...

Parse error: parse error, expecting `')'' in /home/httpd/vhosts/ewnweb.net/subdomains/community/httpdocs/profile.php on line 111

Line 111 specifically is...

		WHERE pm.userid = $bbuserinfo[userid]

The surrounding code is below...help would be appreciated.

// ###################### Start pm update counters #######################
// update the pm counters for $bbuserinfo
function build_pm_counters()
{
	global $DB_site, $bbuserinfo;

	$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]
		");
	}
}