cypher

[Trevor2007]

I would like to create a registration # for my db so after the trial period has expired the user must enter the registration #.
to do this I would like to get 2 unique values from the pc
posable the Mac address from the motherboard, and I think every processor has an adress or serial # that is uniqe to it(correct me if im wrong)
and with those 2 vaules perform a cypher on them and add the 2 cypers together.

so how to get those 2 values using VBA? and then how do I create my cypher (Ie: A cold = 1) ,(lower case e = capitale Z), in my example my cypher isn't realy thaught out as to the algarythem but you have the idea if you don't know what a cypher is. a cypher is an algarythm that when appied increment or dincremnets the origonal value to algarythm of the chyper
for the end user to get this registration code , I would have the generator that would then give me the correct values to tell the user to enter.
thanks for helping

[mshmyob]

Here is the code to get the MAC address. I would not suggest trying to get the CPU serial number only because you cannot get it from every machine (it can be disabled) so it would not be reliable.

You could get the MAC address and then do a CRC checksum on it and create a unique number and use that as your registration code.

I did that years ago in DOS Basic so I would need to take some time to work out the CRC in VBA.

Any ways here is the MAC address code.

Option Compare Database
Option Explicit
 
   Private Const NCBASTAT = &H33
   Private Const NCBNAMSZ = 16
   Private Const HEAP_ZERO_MEMORY = &H8
   Private Const HEAP_GENERATE_EXCEPTIONS = &H4
   Private Const NCBRESET = &H32
 
   Private Type NCB
        ncb_command As Byte 'Integer
        ncb_retcode As Byte 'Integer
        ncb_lsn As Byte 'Integer
        ncb_num As Byte ' Integer
        ncb_buffer As Long 'String
        ncb_length As Integer
        ncb_callname As String * NCBNAMSZ
        ncb_name As String * NCBNAMSZ
        ncb_rto As Byte 'Integer
        ncb_sto As Byte ' Integer
        ncb_post As Long
        ncb_lana_num As Byte 'Integer
        ncb_cmd_cplt As Byte  'Integer
        ncb_reserve(9) As Byte ' Reserved, must be 0
        ncb_event As Long
   End Type
   Private Type ADAPTER_STATUS
        adapter_address(5) As Byte 'As String * 6
        rev_major As Byte 'Integer
        reserved0 As Byte 'Integer
        adapter_type As Byte 'Integer
        rev_minor As Byte 'Integer
        duration As Integer
        frmr_recv As Integer
        frmr_xmit As Integer
        iframe_recv_err As Integer
        xmit_aborts As Integer
        xmit_success As Long
        recv_success As Long
        iframe_xmit_err As Integer
        recv_buff_unavail As Integer
        t1_timeouts As Integer
        ti_timeouts As Integer
        Reserved1 As Long
        free_ncbs As Integer
        max_cfg_ncbs As Integer
        max_ncbs As Integer
        xmit_buf_unavail As Integer
        max_dgram_size As Integer
        pending_sess As Integer
        max_cfg_sess As Integer
        max_sess As Integer
        max_sess_pkt_size As Integer
        name_count As Integer
   End Type
   Private Type NAME_BUFFER
        name  As String * NCBNAMSZ
        name_num As Integer
        name_flags As Integer
   End Type
   Private Type ASTAT
        adapt As ADAPTER_STATUS
        NameBuff(30) As NAME_BUFFER
   End Type
 
   Private Declare Function Netbios Lib "netapi32.dll" _
           (pncb As NCB) As Byte
   Private Declare Sub CopyMemory Lib "kernel32" Alias "RtlMoveMemory" ( _
           hpvDest As Any, ByVal hpvSource As Long, ByVal cbCopy As Long)
   Private Declare Function GetProcessHeap Lib "kernel32" () As Long
   Private Declare Function HeapAlloc Lib "kernel32" _
           (ByVal hHeap As Long, ByVal dwFlags As Long, _
           ByVal dwBytes As Long) As Long
   Private Declare Function HeapFree Lib "kernel32" (ByVal hHeap As Long, _
           ByVal dwFlags As Long, lpMem As Any) As Long
 
 
' button ONCLICK event
Private Sub cmdGetMAC_Click()
Dim myNcb As NCB
       Dim bRet As Byte
       myNcb.ncb_command = NCBRESET
       bRet = Netbios(myNcb)
 
       myNcb.ncb_command = NCBASTAT
       myNcb.ncb_lana_num = 0
       myNcb.ncb_callname = "*               "
 
       Dim myASTAT As ASTAT, tempASTAT As ASTAT
       Dim pASTAT As Long
       myNcb.ncb_length = Len(myASTAT)
       Debug.Print Err.LastDllError
       pASTAT = HeapAlloc(GetProcessHeap(), HEAP_GENERATE_EXCEPTIONS _
                Or HEAP_ZERO_MEMORY, myNcb.ncb_length)
       If pASTAT = 0 Then
          Debug.Print "memory allcoation failed!"
          Exit Sub
       End If
       myNcb.ncb_buffer = pASTAT
       bRet = Netbios(myNcb)
       Debug.Print Err.LastDllError
       CopyMemory myASTAT, myNcb.ncb_buffer, Len(myASTAT)
       MsgBox Hex(myASTAT.adapt.adapter_address(0)) & " " & _
              Hex(myASTAT.adapt.adapter_address(1)) _
              & " " & Hex(myASTAT.adapt.adapter_address(2)) & " " _
              & Hex(myASTAT.adapt.adapter_address(3)) _
              & " " & Hex(myASTAT.adapt.adapter_address(4)) & " " _
              & Hex(myASTAT.adapt.adapter_address(5))
       HeapFree GetProcessHeap(), 0, pASTAT
End Sub
 

Create a form with a button called 'cmdGetMac' and click on it.


cheers,

I would like to create a registration # for my db so after the trial period has expired the user must enter the registration #.
to do this I would like to get 2 unique values from the pc
posable the Mac address from the motherboard, and I think every processor has an adress or serial # that is uniqe to it(correct me if im wrong)
and with those 2 vaules perform a cypher on them and add the 2 cypers together.

so how to get those 2 values using VBA? and then how do I create my cypher (Ie: A cold = 1) ,(lower case e = capitale Z), in my example my cypher isn't realy thaught out as to the algarythem but you have the idea if you don't know what a cypher is. a cypher is an algarythm that when appied increment or dincremnets the origonal value to algarythm of the chyper
for the end user to get this registration code , I would have the generator that would then give me the correct values to tell the user to enter.
thanks for helping

[Trevor2007]

Thanks for the code, sorry it took me a while to get back to you,
I can't tell by looking at it if it gets the MAC addresss and performs the crc check, or if it just gets the Mac Address?
I would like to display the Mac in a textbox for testing, whet line of the core is the reulting Mac, it would be easyer for me if your code was commented :-p
The mesgbox is only displaying 6 0's
thanks.

[Trevor2007]

Im Always getting 6 0's in the messagebox , mnd does code perform a crc check or just return the MAC( getting lost reading the code)

[Trevor2007]

I was able to get Cpu ID and motherboard serial by re working some vbscripts I had so they would work in my access Db(not hard) but with out testing them in a corperate enviroment, I have 1 question( I'll be able to hopefully test them monday) how likly is it for 2 pcs in an office setting to have the same cpu ID and motherboard serial (knowing companies buy the same computer configuratian several times over (yes I know the #'s are suposedly uniqe but I've been reading and some manufacture don't have cpu ID's or they use the same ID # as a modle # and it will come up as an ID #)?

[mshmyob]

Could you post your complete code so I can see. this has always worked for me and still does.

It does not include the CRC check.

cheers,

Im Always getting 6 0's in the messagebox , mnd does code perform a crc check or just return the MAC( getting lost reading the code)