File Source for function.pncountnewmessages.php

<?php
/**
* Zikula Application Framework
*
* @copyright (c) 2004, Zikula Development Team
* @link http://www.zikula.org
* @version $Id: function.pncountnewmessages.php 24342 2008-06-06 12:03:14Z markwest $
* @license GNU/GPL - http://www.gnu.org/copyleft/gpl.html
* @package Zikula_Template_Plugins
* @subpackage Functions
*/
/**
* Smarty function to get the number of new messages for the user currently logged in
*
*
* Available parameters:
* - assign: If set, the results are assigned to the corresponding variable instead of printed out
*
* Example
* !
*
*
* @author Frank Schummertz
* @since 03/19/2004
* @param array $params All attributes passed to this function from the template
* @param object &$smarty Reference to the Smarty object
*/
function smarty_function_pncountnewmessages ($params, &$smarty)
{
extract($params);
unset($params);
$newmessages = 0;
if (pnUserLoggedIn()) {
if (pnModAvailable('Messages')) {
$dbconn = pnDBGetConn(true);
$pntable = pnDBGetTables();
$column = &$pntable['priv_msgs_column'];
// get unread messages
$result = $dbconn->Execute("SELECT count(*) FROM $pntable[priv_msgs] WHERE $column[to_userid]='" . DataUtil::formatForStore(pnUserGetVar('uid')) . "' AND $column[read_msg]='0'");
list($newmessages) = $result->fields; // new messages
$result->Close();
}
}
if (isset($assign)) {
$smarty->assign($assign, $newmessages);
} else {
return $newmessages;
}
}

Source for file function.pncountnewmessages.php