<?php
defined('_VALID') or die('Restricted Access!');
function template_plugin_message()
{
if (!VAuth::loggedin()) {
return;
}
$db = VF::factory('database');
$db->query("
SELECT COUNT(DISTINCT sender_id) AS total_messages
FROM #__message
WHERE receiver_id = ".(int) $_SESSION['user_id']."
AND status = 1
");
return (int) $db->fetch_field('total_messages');
}