$step = CAppUI::pref("nbMailList"); $usermessage = new CUserMessage(); $group = null; $where = array(); $lj = array("usermessage_dest" => "usermessage.usermessage_id = usermessage_dest.user_message_id"); $order = "usermessage_dest.datetime_sent DESC"; $unread = 0; if ($mode == "inbox") { $where = array(); $where["usermessage_dest.to_user_id"] = " = '{$user->_id}'"; $where["datetime_sent"] = " IS NOT NULL"; $where["usermessage_dest.archived"] = " = '0'"; $where['usermessage_dest.deleted'] = " = '0'"; $order = "usermessage_dest.starred DESC, usermessage_dest.datetime_sent DESC"; $where["datetime_read"] = " IS NULL"; $unread = $usermessage->countList($where, $group, $lj); $unread = $unread ? $unread : 0; unset($where["datetime_read"]); $total_found = CUserMessageDest::countInboxFor($user); } if ($mode == "archive") { $where = array(); $where["usermessage_dest.to_user_id"] = " = '{$user->_id}'"; $where["usermessage_dest.archived"] = " = '1'"; $where['usermessage_dest.deleted'] = " = '0'"; $order = "usermessage_dest.starred DESC, usermessage_dest.datetime_sent DESC"; $total_found = CUserMessageDest::countArchivedFor($user); } if ($mode == "sentbox") { $where = array(); $where["from_user_id"] = " = '{$user->_id}'";