[Mystics]

Originally Posted by h75

i git an db error after i install that hack. :devious:

Replace:

// ###### MOD display user notes in postbit if user has notes MOD ###### 
$usernote = $DB_site->query_first(" 
SELECT MAX(dateline) AS lastpost, COUNT(*) AS total 
FROM " . TABLE_PREFIX . "usernote AS usernote 
WHERE userid = $post[userid] 
"); 
$show['hasusernote'] = iif($usernote['total'], true, false); 
$show['usernotetotal'] = $usernote['total'];

with:

// ###### MOD display user notes in postbit if user has notes MOD ######
if ($post['userid'])
{
	$usernote = $DB_site->query_first("
		SELECT MAX(dateline) AS lastpost, COUNT(*) AS total
		FROM " . TABLE_PREFIX . "usernote AS usernote
		WHERE userid = $post[userid] 
	");
	$show['hasusernote'] = iif($usernote['total'], true, false);
	$show['usernotetotal'] = $usernote['total'];
}
else
{
	$show['hasusernote'] = false;
	$show['usernotetotal'] = 0;
}