chamilo / chamilo-lms

     * @param string $type

     * @return bool

     */

    public static function update_message_status($user_id, $message_id, $type)

    {

        $type = intval($type);

        if ($message_id != strval(intval($message_id)) || $user_id != strval(intval($user_id))) {

            return false;

        }

        $table_message = Database::get_main_table(TABLE_MESSAGE);

        $sql = "UPDATE $table_message SET

                    msg_status = '$type'

                WHERE

                    user_receiver_id=" . intval($user_id) . " AND

                    id='" . intval($message_id) . "'";

        Database::query($sql);

    }

    /**

     * get messages by user id and message id

     * @param  int $message_id

     * @return array

     */

    public static function get_message_by_user($user_id, $message_id)

    {

        if ($message_id != strval(intval($message_id)) || $user_id != strval(intval($user_id)))

            return false;

        $table_message = Database::get_main_table(TABLE_MESSAGE);

        $query = "SELECT * FROM $table_message

                  WHERE user_receiver_id=" . intval($user_id) . " AND id='" . intval($message_id) . "'";

        $result = Database::query($query);

        return $row = Database::fetch_array($result);

    }

    /**