if (!$gCurrentUser->editUsers() && !isMember($user->getValue('usr_id')) || $user->getValue('usr_id') === '') {
$gMessage->show($gL10n->get('SYS_USER_ID_NOT_FOUND'));
}
// check if receiver of message has valid login
if ($user->getValue('usr_login_name') === '') {
$gMessage->show($gL10n->get('SYS_FIELD_EMPTY', $gL10n->get('SYS_TO')));
}
// save page in navigation - to have a check for a navigation back.
$gNavigation->addUrl(CURRENT_URL);
if ($getMsgId == 0) {
$PMId2 = 1;
$sql = "INSERT INTO " . TBL_MESSAGES . " (msg_type, msg_subject, msg_usr_id_sender, msg_usr_id_receiver, msg_timestamp, msg_read)\n VALUES ('" . $getMsgType . "', '" . $postSubjectSQL . "', '" . $gCurrentUser->getValue('usr_id') . "', '" . $postTo[0] . "', CURRENT_TIMESTAMP, '1')";
$gDb->query($sql);
$getMsgId = $gDb->lastInsertId();
} else {
$PMId2 = $message->countMessageParts() + 1;
$sql = "UPDATE " . TBL_MESSAGES . " SET msg_read = '1', msg_timestamp = CURRENT_TIMESTAMP, msg_usr_id_sender = '" . $gCurrentUser->getValue('usr_id') . "', msg_usr_id_receiver = '" . $postTo[0] . "'\n WHERE msg_id = " . $getMsgId;
$gDb->query($sql);
}
$sql = "INSERT INTO " . TBL_MESSAGES_CONTENT . " (msc_msg_id, msc_part_id, msc_usr_id, msc_message, msc_timestamp)\n VALUES ('" . $getMsgId . "', '" . $PMId2 . "', '" . $gCurrentUser->getValue('usr_id') . "', '" . $postBodySQL . "', CURRENT_TIMESTAMP)";
if ($gDb->query($sql)) {
$sendResult = true;
}
}
// message if send/save is OK
// @ptabaden: update 3.1.3
if ($sendResult === true) {
// save mail also to database
if ($getMsgType !== 'PM' && $gValidLogin) {
$sql = "INSERT INTO " . TBL_MESSAGES . " (msg_type, msg_subject, msg_usr_id_sender, msg_usr_id_receiver, msg_timestamp, msg_read)\n VALUES ('" . $getMsgType . "', '" . $postSubjectSQL . "', " . $gCurrentUser->getValue('usr_id') . ", '" . $ReceiverString . "', CURRENT_TIMESTAMP, 0)";
$gDb->query($sql);
