OpenOffice.Base Feld md5-Verschlüsseln

[Nemesis]

Hi,
weiss jemand, ob es eine Möglichkeit gibt, dass inOpenOffice.Base die Eingabe in ein Formular md5-verschlüsslt in der Datenbank gespeichert wird ?

ich habe einen Schnippsel Code gefunden, der ist aber wohl für M$ gedacht, und will nicht ganz.

Option Compare Database
Option Explicit

Private lngTrack As Long
Private arrLongConversion(4) As Long
Private arrSplit64(63) As Byte

Private Const OFFSET_4 = 4294967296#
Private Const MAXINT_4 = 2147483647

Private Const S11 = 7
Private Const S12 = 12
Private Const S13 = 17
Private Const S14 = 22
Private Const S21 = 5
Private Const S22 = 9
Private Const S23 = 14
Private Const S24 = 20
Private Const S31 = 4
Private Const S32 = 11
Private Const S33 = 16
Private Const S34 = 23
Private Const S41 = 6
Private Const S42 = 10
Private Const S43 = 15
Private Const S44 = 21

Private Function MD5Round(strRound As String, a As Long, b As Long, _
                          C As Long, d As Long, x As Long, S As Long, _
                          ac As Long) As Long
    Select Case strRound
      Case Is = "FF"
        a = MD5LongAdd4(a, (b And C) Or (Not (b) And d), x, ac)
        a = MD5Rotate(a, S)
        a = MD5LongAdd(a, b)
      Case Is = "GG"
        a = MD5LongAdd4(a, (b And d) Or (C And Not (d)), x, ac)
        a = MD5Rotate(a, S)
        a = MD5LongAdd(a, b)
      Case Is = "HH"
        a = MD5LongAdd4(a, b Xor C Xor d, x, ac)
        a = MD5Rotate(a, S)
        a = MD5LongAdd(a, b)
      Case Is = "II"
        a = MD5LongAdd4(a, C Xor (b Or Not (d)), x, ac)
        a = MD5Rotate(a, S)
        a = MD5LongAdd(a, b)
    End Select
End Function

Private Function MD5Rotate(lngValue As Long, lngBits As Long) As Long
    Dim lngSign As Long
    Dim lngI As Long
   
    lngBits = (lngBits Mod 32)
    If lngBits = 0 Then MD5Rotate = lngValue: Exit Function
    For lngI = 1 To lngBits
        lngSign = lngValue And &HC0000000
        lngValue = (lngValue And &H3FFFFFFF) * 2
        lngValue = lngValue Or ((lngSign < 0) And 1) Or _
                   (CBool(lngSign And &H40000000) And &H80000000)
    Next
    MD5Rotate = lngValue
End Function

Private Function TRID() As String
    Dim sngNum As Single, lngnum As Long
    Dim strResult As String
   
    sngNum = Rnd(2147483648#)
    strResult = CStr(sngNum)
    strResult = Replace(strResult, "0.", "")
    strResult = Replace(strResult, ".", "")
    strResult = Replace(strResult, "E-", "")
    TRID = strResult
End Function

Private Function MD564Split(lngLength As Long, bytBuffer() As Byte) As String
    Dim lngBytesTotal As Long, lngBytesToAdd As Long
    Dim intLoop As Integer, intLoop2 As Integer, lngTrace As Long
    Dim intInnerLoop As Integer, intLoop3 As Integer
   
    lngBytesTotal = lngTrack Mod 64
    lngBytesToAdd = 64 - lngBytesTotal
    lngTrack = (lngTrack + lngLength)
    If lngLength >= lngBytesToAdd Then
        For intLoop = 0 To lngBytesToAdd - 1
            arrSplit64(lngBytesTotal + intLoop) = bytBuffer(intLoop)
        Next intLoop
        MD5Conversion arrSplit64
        lngTrace = (lngLength) Mod 64
        For intLoop2 = lngBytesToAdd To lngLength - intLoop - lngTrace Step 64
            For intInnerLoop = 0 To 63
                arrSplit64(intInnerLoop) = bytBuffer(intLoop2 + intInnerLoop)
            Next intInnerLoop
            MD5Conversion arrSplit64
        Next intLoop2
        lngBytesTotal = 0
      Else
        intLoop2 = 0
    End If
    For intLoop3 = 0 To lngLength - intLoop2 - 1
        arrSplit64(lngBytesTotal + intLoop3) = bytBuffer(intLoop2 + intLoop3)
    Next intLoop3
End Function

Private Function MD5StringArray(strInput As String) As Byte()
    Dim intLoop As Integer
    Dim bytBuffer() As Byte
    ReDim bytBuffer(Len(strInput))
   
    For intLoop = 0 To Len(strInput) - 1
        bytBuffer(intLoop) = Asc(Mid(strInput, intLoop + 1, 1))
    Next intLoop
    MD5StringArray = bytBuffer
End Function

Private Sub MD5Conversion(bytBuffer() As Byte)
    Dim x(16) As Long, a As Long
    Dim b As Long, C As Long
    Dim d As Long
   
    a = arrLongConversion(1)
    b = arrLongConversion(2)
    C = arrLongConversion(3)
    d = arrLongConversion(4)
    MD5Decode 64, x, bytBuffer
    MD5Round "FF", a, b, C, d, x(0), S11, -680876936
    MD5Round "FF", d, a, b, C, x(1), S12, -389564586
    MD5Round "FF", C, d, a, b, x(2), S13, 606105819
    MD5Round "FF", b, C, d, a, x(3), S14, -1044525330
    MD5Round "FF", a, b, C, d, x(4), S11, -176418897
    MD5Round "FF", d, a, b, C, x(5), S12, 1200080426
    MD5Round "FF", C, d, a, b, x(6), S13, -1473231341
    MD5Round "FF", b, C, d, a, x(7), S14, -45705983
    MD5Round "FF", a, b, C, d, x(8), S11, 1770035416
    MD5Round "FF", d, a, b, C, x(9), S12, -1958414417
    MD5Round "FF", C, d, a, b, x(10), S13, -42063
    MD5Round "FF", b, C, d, a, x(11), S14, -1990404162
    MD5Round "FF", a, b, C, d, x(12), S11, 1804603682
    MD5Round "FF", d, a, b, C, x(13), S12, -40341101
    MD5Round "FF", C, d, a, b, x(14), S13, -1502002290
    MD5Round "FF", b, C, d, a, x(15), S14, 1236535329
    MD5Round "GG", a, b, C, d, x(1), S21, -165796510
    MD5Round "GG", d, a, b, C, x(6), S22, -1069501632
    MD5Round "GG", C, d, a, b, x(11), S23, 643717713
    MD5Round "GG", b, C, d, a, x(0), S24, -373897302
    MD5Round "GG", a, b, C, d, x(5), S21, -701558691
    MD5Round "GG", d, a, b, C, x(10), S22, 38016083
    MD5Round "GG", C, d, a, b, x(15), S23, -660478335
    MD5Round "GG", b, C, d, a, x(4), S24, -405537848
    MD5Round "GG", a, b, C, d, x(9), S21, 568446438
    MD5Round "GG", d, a, b, C, x(14), S22, -1019803690
    MD5Round "GG", C, d, a, b, x(3), S23, -187363961
    MD5Round "GG", b, C, d, a, x(8), S24, 1163531501
    MD5Round "GG", a, b, C, d, x(13), S21, -1444681467
    MD5Round "GG", d, a, b, C, x(2), S22, -51403784
    MD5Round "GG", C, d, a, b, x(7), S23, 1735328473
    MD5Round "GG", b, C, d, a, x(12), S24, -1926607734
    MD5Round "HH", a, b, C, d, x(5), S31, -378558
    MD5Round "HH", d, a, b, C, x(8), S32, -2022574463
    MD5Round "HH", C, d, a, b, x(11), S33, 1839030562
    MD5Round "HH", b, C, d, a, x(14), S34, -35309556
    MD5Round "HH", a, b, C, d, x(1), S31, -1530992060
    MD5Round "HH", d, a, b, C, x(4), S32, 1272893353
    MD5Round "HH", C, d, a, b, x(7), S33, -155497632
    MD5Round "HH", b, C, d, a, x(10), S34, -1094730640
    MD5Round "HH", a, b, C, d, x(13), S31, 681279174
    MD5Round "HH", d, a, b, C, x(0), S32, -358537222
    MD5Round "HH", C, d, a, b, x(3), S33, -722521979
    MD5Round "HH", b, C, d, a, x(6), S34, 76029189
    MD5Round "HH", a, b, C, d, x(9), S31, -640364487
    MD5Round "HH", d, a, b, C, x(12), S32, -421815835
    MD5Round "HH", C, d, a, b, x(15), S33, 530742520
    MD5Round "HH", b, C, d, a, x(2), S34, -995338651
    MD5Round "II", a, b, C, d, x(0), S41, -198630844
    MD5Round "II", d, a, b, C, x(7), S42, 1126891415
    MD5Round "II", C, d, a, b, x(14), S43, -1416354905
    MD5Round "II", b, C, d, a, x(5), S44, -57434055
    MD5Round "II", a, b, C, d, x(12), S41, 1700485571
    MD5Round "II", d, a, b, C, x(3), S42, -1894986606
    MD5Round "II", C, d, a, b, x(10), S43, -1051523
    MD5Round "II", b, C, d, a, x(1), S44, -2054922799
    MD5Round "II", a, b, C, d, x(8), S41, 1873313359
    MD5Round "II", d, a, b, C, x(15), S42, -30611744
    MD5Round "II", C, d, a, b, x(6), S43, -1560198380
    MD5Round "II", b, C, d, a, x(13), S44, 1309151649
    MD5Round "II", a, b, C, d, x(4), S41, -145523070
    MD5Round "II", d, a, b, C, x(11), S42, -1120210379
    MD5Round "II", C, d, a, b, x(2), S43, 718787259
    MD5Round "II", b, C, d, a, x(9), S44, -343485551
    arrLongConversion(1) = MD5LongAdd(arrLongConversion(1), a)
    arrLongConversion(2) = MD5LongAdd(arrLongConversion(2), b)
    arrLongConversion(3) = MD5LongAdd(arrLongConversion(3), C)
    arrLongConversion(4) = MD5LongAdd(arrLongConversion(4), d)
End Sub

Private Function MD5LongAdd(lngVal1 As Long, lngVal2 As Long) As Long
    Dim lngHighWord As Long
    Dim lngLowWord As Long
    Dim lngOverflow As Long

    lngLowWord = (lngVal1 And &HFFFF&) + (lngVal2 And &HFFFF&)
    lngOverflow = lngLowWord \ 65536
    lngHighWord = (((lngVal1 And &HFFFF0000) \ 65536) + _
                   ((lngVal2 And &HFFFF0000) \ 65536) + _
                   lngOverflow) And &HFFFF&
    MD5LongAdd = MD5LongConversion((lngHighWord * 65536#) + _
                                   (lngLowWord And &HFFFF&))
End Function

Private Function MD5LongAdd4(lngVal1 As Long, lngVal2 As Long, _
                             lngVal3 As Long, lngVal4 As Long) As Long
    Dim lngHighWord As Long
    Dim lngLowWord As Long
    Dim lngOverflow As Long

    lngLowWord = (lngVal1 And &HFFFF&) + (lngVal2 And &HFFFF&) + _
                 (lngVal3 And &HFFFF&) + (lngVal4 And &HFFFF&)
    lngOverflow = lngLowWord \ 65536
    lngHighWord = (((lngVal1 And &HFFFF0000) \ 65536) + _
                   ((lngVal2 And &HFFFF0000) \ 65536) + _
                   ((lngVal3 And &HFFFF0000) \ 65536) + _
                   ((lngVal4 And &HFFFF0000) \ 65536) + _
                   lngOverflow) And &HFFFF&
    MD5LongAdd4 = MD5LongConversion((lngHighWord * 65536#) + _
                                    (lngLowWord And &HFFFF&))
End Function

Private Sub MD5Decode(intLength As Integer, lngOutBuffer() As Long, _
                      bytInBuffer() As Byte)
    Dim intDblIndex As Integer
    Dim intByteIndex As Integer
    Dim dblSum As Double
   
    intDblIndex = 0
    For intByteIndex = 0 To intLength - 1 Step 4
        dblSum = bytInBuffer(intByteIndex) + _
                 bytInBuffer(intByteIndex + 1) * 256# + _
                 bytInBuffer(intByteIndex + 2) * 65536# + _
                 bytInBuffer(intByteIndex + 3) * 16777216#
        lngOutBuffer(intDblIndex) = MD5LongConversion(dblSum)
        intDblIndex = (intDblIndex + 1)
    Next intByteIndex
End Sub

Private Function MD5LongConversion(dblValue As Double) As Long
    If dblValue < 0 Or dblValue >= OFFSET_4 Then Error 6
    If dblValue <= MAXINT_4 Then
        MD5LongConversion = dblValue
      Else
        MD5LongConversion = dblValue - OFFSET_4
    End If
End Function

Private Sub MD5Finish()
    Dim dblBits As Double
    Dim arrPadding(72) As Byte
    Dim lngBytesBuffered As Long
   
    arrPadding(0) = &H80
    dblBits = lngTrack * 8
    lngBytesBuffered = lngTrack Mod 64
    If lngBytesBuffered <= 56 Then
        MD564Split (56 - lngBytesBuffered), arrPadding
      Else
        MD564Split (120 - lngTrack), arrPadding
    End If
    arrPadding(0) = MD5LongConversion(dblBits) And &HFF&
    arrPadding(1) = MD5LongConversion(dblBits) \ 256 And &HFF&
    arrPadding(2) = MD5LongConversion(dblBits) \ 65536 And &HFF&
    arrPadding(3) = MD5LongConversion(dblBits) \ 16777216 And &HFF&
    arrPadding(4) = 0
    arrPadding(5) = 0
    arrPadding(6) = 0
    arrPadding(7) = 0
    MD564Split 8, arrPadding
End Sub

Private Function MD5StringChange(lngnum As Long) As String
        Dim bytA As Byte
        Dim bytB As Byte
        Dim bytC As Byte
        Dim bytD As Byte
       
        bytA = lngnum And &HFF&
        If bytA < 16 Then
            MD5StringChange = "0" & Hex(bytA)
          Else
            MD5StringChange = Hex(bytA)
        End If
        bytB = (lngnum And &HFF00&) \ 256
        If bytB < 16 Then
            MD5StringChange = MD5StringChange & "0" & Hex(bytB)
          Else
            MD5StringChange = MD5StringChange & Hex(bytB)
        End If
        bytC = (lngnum And &HFF0000) \ 65536
        If bytC < 16 Then
            MD5StringChange = MD5StringChange & "0" & Hex(bytC)
          Else
            MD5StringChange = MD5StringChange & Hex(bytC)
        End If
        If lngnum < 0 Then
            bytD = ((lngnum And &H7F000000) \ 16777216) Or &H80&
          Else
            bytD = (lngnum And &HFF000000) \ 16777216
        End If
        If bytD < 16 Then
            MD5StringChange = MD5StringChange & "0" & Hex(bytD)
          Else
            MD5StringChange = MD5StringChange & Hex(bytD)
        End If
End Function

Private Function MD5Value() As String
    MD5Value = LCase(MD5StringChange(arrLongConversion(1)) & _
                     MD5StringChange(arrLongConversion(2)) & _
                     MD5StringChange(arrLongConversion(3)) & _
                     MD5StringChange(arrLongConversion(4)))
End Function

Public Function FnsCalculateMD5(strMessage As String) As String
    Dim bytBuffer() As Byte
   
    bytBuffer = MD5StringArray(strMessage)
    MD5Start
    MD564Split Len(strMessage), bytBuffer
    MD5Finish
    FnsCalculateMD5 = MD5Value 'Korrigiert by Willi Wipp
End Function

Private Sub MD5Start()
    lngTrack = 0
    arrLongConversion(1) = MD5LongConversion(1732584193#)
    arrLongConversion(2) = MD5LongConversion(4023233417#)
    arrLongConversion(3) = MD5LongConversion(2562383102#)
    arrLongConversion(4) = MD5LongConversion(271733878#)
End Sub

Gibts da ne Möglichkeit ?

danke !

edit:

weiss jemand, wie man dieses modul verwendet ? die doku ist doch recht spärlich, und aus der bsp. db krieg ich nicht viel raus
LINK