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