if ($gPreferences['enable_pm_module'] != 1 && $getMsgType == 'PM') {
// message if the sending of PM is not allowed
$gMessage->show($gL10n->get('SYS_MODULE_DISABLED'));
}
// check for valid login
if (!$gValidLogin && $getUserId == 0 && $getMsgType == 'PM') {
$gMessage->show($gL10n->get('SYS_INVALID_PAGE_VIEW'));
}
// check if user has email address for sending a email
if ($gValidLogin && $getMsgType != 'PM' && strlen($gCurrentUser->getValue('EMAIL')) == 0) {
$gMessage->show($gL10n->get('SYS_CURRENT_USER_NO_EMAIL', '<a href="' . $g_root_path . '/adm_program/modules/profile/profile.php">', '</a>'));
}
// Update the read status of the message
if ($getMsgId > 0) {
// update the read-status
$message->setReadValue($gCurrentUser->getValue('usr_id'));
$getSubject = $message->getValue('msg_subject');
$getUserId = $message->getConversationPartner($gCurrentUser->getValue('usr_id'));
$sql = "SELECT msc_usr_id, msc_message, msc_timestamp\r\n FROM " . TBL_MESSAGES_CONTENT . "\r\n WHERE msc_msg_id = " . $getMsgId . "\r\n ORDER BY msc_part_id DESC";
$message_result = $gDb->query($sql);
}
$recept_number = 1;
if ($gPreferences['mail_max_receiver'] > 0 and $getMsgType != 'PM') {
$recept_number = $gPreferences['mail_max_receiver'];
}
$list = array();
if ($getMsgType == 'PM') {
$sql = "SELECT usr_id, CONCAT(LAST_NAME.usd_value, ' ', FIRST_NAME.usd_value) as name, usr_login_name\r\n FROM " . TBL_ROLES . ", " . TBL_CATEGORIES . ", " . TBL_MEMBERS . ", " . TBL_USERS . "\r\n LEFT JOIN " . TBL_USER_DATA . " LAST_NAME\r\n ON LAST_NAME.usd_usr_id = usr_id\r\n AND LAST_NAME.usd_usf_id = 1 LEFT JOIN " . TBL_USER_DATA . " FIRST_NAME\r\n ON FIRST_NAME.usd_usr_id = usr_id\r\n AND FIRST_NAME.usd_usf_id = 2\r\n WHERE rol_id IN (2)\r\n AND rol_cat_id = cat_id\r\n AND ( cat_org_id = 1\r\n OR cat_org_id IS NULL )\r\n AND mem_rol_id = rol_id\r\n AND mem_usr_id = usr_id\r\n AND usr_id <> " . $gCurrentUser->getValue('usr_id') . "\r\n AND usr_valid = 1\r\n AND usr_login_name IS NOT NULL\r\n ORDER BY LAST_NAME.usd_value, FIRST_NAME.usd_value";
$drop_result = $gDb->query($sql);
if ($gValidLogin) {
while ($row = $gDb->fetch_array($drop_result)) {
