D
David M C
Does anyone have any experience with this sort of thing?
We have several offices each running their own version of the database. One
of the functions of the database is to handle purchase orders. For large
orders over £X we require Head Office authorisation. I would like to make
this a function of the database.
I would like to generate a code at head office, that is reversible at the
remote sites which is used to authorise the order. For example, using OrderID
and EmployeeID:
OrderID: 678
EmployeeID: 320
The authorisor inputs this detail (sent by email), along with their ID:
AuthorisedID: 303
OrderID: 678
EmployeeID: 320
into a keygen form, producing some code like:
2343-3456-2323
which can be emailed to the requester, input into the form, which then
allows the order number (required by all our suppliers) to be viewed, and the
order to be printed/faxed/emailed.
I know how to code all the forms, but what I don't know is how to generate a
seemingly random code from a given set of numbers. Nobody in the business is
a code breaker, so it doesn't need to be bulletproof, just create the
impression of being so. Are their algorithms out there already or am I going
to have to write my own?
Thanks,
Dave
We have several offices each running their own version of the database. One
of the functions of the database is to handle purchase orders. For large
orders over £X we require Head Office authorisation. I would like to make
this a function of the database.
I would like to generate a code at head office, that is reversible at the
remote sites which is used to authorise the order. For example, using OrderID
and EmployeeID:
OrderID: 678
EmployeeID: 320
The authorisor inputs this detail (sent by email), along with their ID:
AuthorisedID: 303
OrderID: 678
EmployeeID: 320
into a keygen form, producing some code like:
2343-3456-2323
which can be emailed to the requester, input into the form, which then
allows the order number (required by all our suppliers) to be viewed, and the
order to be printed/faxed/emailed.
I know how to code all the forms, but what I don't know is how to generate a
seemingly random code from a given set of numbers. Nobody in the business is
a code breaker, so it doesn't need to be bulletproof, just create the
impression of being so. Are their algorithms out there already or am I going
to have to write my own?
Thanks,
Dave