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)) {