Gary Kjos
garykjos at gmail.com
Thu Mar 22 13:57:32 CDT 2007
If you use that logic and you forget about the rightmost two positions
- maybe an occurance number or something, you can get close....
H = 1027924991 +
9 = 15116544
W = 1492992
D = 16848
H = 612
7 = 7
---------------------
1044551995
which translates to Thursday, February 06, 2003 11:19:55 AM
2 hours off?
I haven't tried it for any others but that one seems pretty scary
close for the first one I tried.
For example in your first example. H9WDH701 = 02/06/03 09:19:55 = that
translates to 1044523195 in UNIX time. According to the time
calculators I googled.
On 3/22/07, Mark A Matte <markamatte at hotmail.com> wrote:
> Rocky,
>
> I've actually made some progress. Last year I learned how to do Mayan Math
> and applied the logic as a counting system not 10 or 20 base...but 36...and
> after learning that this thing is counting seconds since 1/1/70 00:00:00...I
> assigned values to the numbers and letters. and started running some tests.
> 0=0,1=1,2=2...9=9,A=10,B=11...Z=35.
>
> This makes it a 36 base counting system...so you take the value of each
> position...calculate and add like below:
>
> 1st ???
> 2nd ???
> 3rd Value*60466176
> 4th Value*1679616
> 5th Value*46656
> 6th Value*1296
> 7th Value*36
> 8th Value
>
> So if you had 00bfk5t2...you math would be Value of third position
> ('B'11*60466176) added to each position calculated...so:
> 0's are 0...('B'11*60466176)
> +('F'15*1679616)+('K'20*46656)+('5'5*1296)+('T'29*36)+('2'2)
>
> Beginning of time for this count is 12/31/69 04:00:00 PM...if you do the
> calcs above you get 691262822...if you add this many seconds to the
> beginning time you get 11/27/91 9:27:02 AM...
>
> Which validates in the system. The guy I talked to that help create it over
> 12 years ago...said he remembered something about haveing to 'shift a bit or
> 2'...but I didn't get much more from him...he just didn't remember the
> specifics. The 1st and 2nd positions I am having issues with...if I try to
> calculate it out...I get crazy results...and also in the validation
> tool...with the above example it validated...but if I added a
> letter(00bfk5t2 changed to 0bbfk5t2)...just added value in second
> position...it would not accept it as valid??? This is probably what he was
> talking about"Shifting a bit or 2".
>
> Anyway...any thoughts?
>
> What info would your cousin need?
>
> Thanks,
>
> Mark A. Matte
>
>
>
> >From: "Rocky Smolin at Beach Access Software" <rockysmolin at bchacc.com>
> >Reply-To: Access Developers discussion and problem
> >solving<accessd at databaseadvisors.com>
> >To: "'Access Developers discussion and problem
> >solving'"<accessd at databaseadvisors.com>
> >Subject: Re: [AccessD] OT(kinda): Crack Code
> >Date: Thu, 22 Mar 2007 09:56:20 -0700
> >
> >If it takes less than about 6 minutes...:)
> >
> >I was going to send it to my cousin - a retired math prof. He likes that
> >sort of thing
> >
> >Rocky
> >
> >
> >
> >
> >
> >
> >
> >
> >-----Original Message-----
> >From: accessd-bounces at databaseadvisors.com
> >[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte
> >Sent: Thursday, March 22, 2007 7:17 AM
> >To: accessd at databaseadvisors.com
> >Subject: Re: [AccessD] OT(kinda): Crack Code
> >
> >The date is stored in the table...but not the time. If you want a
> >date/time...I have to plug the OBJID into the FE and it converts it for me.
> >
> >I can extract the date and the OBJID...but you can have up to 86400
> >different OBJIDs for 1 date. I can try to get about 100 if you like.
> >
> >Mark
> >
> >
> > >From: "Rocky Smolin at Beach Access Software" <rockysmolin at bchacc.com>
> > >Reply-To: Access Developers discussion and problem
> > >solving<accessd at databaseadvisors.com>
> > >To: "'Access Developers discussion and problem
> > >solving'"<accessd at databaseadvisors.com>
> > >Subject: Re: [AccessD] OT(kinda): Crack Code
> > >Date: Wed, 21 Mar 2007 15:50:57 -0700
> > >
> > >Oh. You can't extract them from the file?
> > >
> > >Rocky
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >-----Original Message-----
> > >From: accessd-bounces at databaseadvisors.com
> > >[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte
> > >Sent: Wednesday, March 21, 2007 2:03 PM
> > >To: accessd at databaseadvisors.com
> > >Subject: Re: [AccessD] OT(kinda): Crack Code
> > >
> > >lol...If you want to try just to do it...I will put something
> > >together...I have to go to a Win95 machine and enter 1 OBJID at a
> > >time...and write it down the DT. I probably have around 10
> > >million...I'll see if I can get a 100.
> > >
> > >
> > > >From: "Rocky Smolin at Beach Access Software"
> > > ><rockysmolin at bchacc.com>
> > > >Reply-To: Access Developers discussion and problem
> > > >solving<accessd at databaseadvisors.com>
> > > >To: "'Access Developers discussion and problem
> > > >solving'"<accessd at databaseadvisors.com>
> > > >Subject: Re: [AccessD] OT(kinda): Crack Code
> > > >Date: Wed, 21 Mar 2007 13:57:21 -0700
> > > >
> > > >Mark:
> > > >
> > > >Can you post maybe 100 or so to give us a little more sample to go on?
> > > >
> > > >Or send a spreadsheet to those of us who like these things with all
> > > >of the OBJIDs and dates (how many are there?)?
> > > >
> > > >Rocky
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >-----Original Message-----
> > > >From: accessd-bounces at databaseadvisors.com
> > > >[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A
> > > >Matte
> > > >Sent: Wednesday, March 21, 2007 12:26 PM
> > > >To: accessd at databaseadvisors.com
> > > >Subject: Re: [AccessD] OT(kinda): Crack Code
> > > >
> > > >This thing reminds me of the crypto toy at the end of the Davinci
> > > >Code(8 little wheels with letters and numbers).
> > > >
> > > >I think the sequence is jumbled as well. In trying to solve I
> > > >started dissecting a looking at individual characters. I looked at
> > > >the 8th(last
> > > >character) for frequency. The distribution didn't make much
> > > >sense(listed below). So I looked at the least, "C" to try and
> > > >isolate a pattern...and found it was only the last char on 9/12/2001
> > > >and 9/19/2001...and not for all of the records. I might pass it on
> > > >to the University...but I'll probably just let it die...like it
> > > >should have a long time ago. The only reason they are still using it
> > > >is that no one understood the relationships of the tables. After I
> > > >discovered that the fields OBJID in the different tables were not
> > > >necessarily related...and that the 1 table with 2 keys in it...was
> > > >actually related to itself 3 or more times...we made leaps and
> > > >bounds...for the first time they could say definitively that they were
> >missing records.
> > > >
> > > >Any way...thanks again everyone.
> > > >
> > > >Mar A. Matte
> > > >
> > > >
> > > >LastChar Count
> > > >1 151767
> > > >2 114816
> > > >3 88366
> > > >4 63108
> > > >5 33900
> > > >6 24099
> > > >7 14439
> > > >8 8886
> > > >9 5427
> > > >A 1743
> > > >B 634
> > > >C 115
> > > >
> > > > >From: "Dan Waters" <dwaters at usinternet.com>
> > > > >Reply-To: Access Developers discussion and problem
> > > > >solving<accessd at databaseadvisors.com>
> > > > >To: "'Access Developers discussion and problem
> > > > >solving'"<accessd at databaseadvisors.com>
> > > > >Subject: Re: [AccessD] OT(kinda): Crack Code
> > > > >Date: Wed, 21 Mar 2007 14:01:26 -0500
> > > > >
> > > > >Mark,
> > > > >
> > > > >Perhaps you could contact the math department at a nearby university.
> > > > >They may want to take a whack at this, or they may know someone who
> > > > >would think that solving this kind of puzzle is great fun!
> > > > >
> > > > >Dan Waters
> > > > >
> > > > >-----Original Message-----
> > > > >From: accessd-bounces at databaseadvisors.com
> > > > >[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A
> > > > >Matte
> > > > >Sent: Wednesday, March 21, 2007 1:36 PM
> > > > >To: accessd at databaseadvisors.com
> > > > >Subject: Re: [AccessD] OT(kinda): Crack Code
> > > > >
> > > > >I have found also that if I sort on the key...the corresponding
> > > > >times are also sorted correctly.
> > > > >
> > > > >
> > > > > >From: "Billy Pang" <tuxedoman888 at gmail.com>
> > > > > >Reply-To: Access Developers discussion and problem
> > > > > >solving<accessd at databaseadvisors.com>
> > > > > >To: "Access Developers discussion and problem
> > > > > >solving"<accessd at databaseadvisors.com>
> > > > > >Subject: Re: [AccessD] OT(kinda): Crack Code
> > > > > >Date: Wed, 21 Mar 2007 11:32:45 -0700
> > > > > >
> > > > > >good gravy those alphanumeric codes are indeed alphanumeric... I
> > > > > >thought maybe it was md5 hashed so you can do lookups to
> > > > > >determine original value but if there is a tool to reverse value
> > > > > >back to datetime maybe it is not
> > > > >a
> > > > > >hashed string.
> > > > > >
> > > > > >
> > > > > >On 3/21/07, Mark A Matte <markamatte at hotmail.com> wrote:
> > > > > > >
> > > > > > > The reason I need to convert back...is that I have about 40K
> > > > > > > orphaned records. There is no date or time stamp in this table.
> > > > > > > If I can
> > > > > >convert
> > > > > > > the OBJID back to a date/time...I might be able to
> > > > > > > re-establish some
> > > > >of
> > > > > > > the
> > > > > > > relationships by adjusting these times...or at least give an
> > > > > > > accurate timeline of when the relation ship was lost. Below
> > > > > > > are
> > > >some
> > > >examples.
> > > > > > >
> > > > > > > OBJID
> > > > > > > H9WDH701=02/06/03 09:19:55 AM
> > > > > > > H9WLA903=02/06/03 12:08:33 PM
> > > > > > > HLBDMS01=09/16/03 08:56:52 AM
> > > > > > > H0HEOO01=08/07/02 09:19:36 PM
> > > > > > > IYY5UQ01=05/08/06 05:40:02 AM
> > > > > > >
> > > > > > >
> > > > > > > >From: "Billy Pang" <tuxedoman888 at gmail.com>
> > > > > > > >Reply-To: Access Developers discussion and problem
> > > > > > > >solving<accessd at databaseadvisors.com>
> > > > > > > >To: "Access Developers discussion and problem
> > > > > > > >solving"<accessd at databaseadvisors.com>
> > > > > > > >Subject: Re: [AccessD] OT(kinda): Crack Code
> > > > > > > >Date: Wed, 21 Mar 2007 09:52:24 -0700
> > > > > > > >
> > > > > > > >can you post an example of a record with the key?
> > > > > > > >
> > > > > > > >also, why do you need to convert these keys back to datetime?
> > > > > > > >
> > > > > > > >
> > > > > > > >On 3/21/07, Mark A Matte <markamatte at hotmail.com> wrote:
> > > > > > > > >
> > > > > > > > > Hello All,
> > > > > > > > >
> > > > > > > > > I have a DB...just the data...no FE...all of the Keys are
> > > > > > > > > 8
> > > > > >character
> > > > > > > > > alpha-numeric. This key is generated from the date time.
> > > > > > > > > The
> > > > > >company
> > > > > > > > > that
> > > > > > > > > developed the app no longer exists. I need to figure out
> > > > > > > > > the
> > > > >logic
> > > > > > > >used,
> > > > > > > > > and convert these keys back to date time. I've searched
> > > > > > > > > online
> > > > >for
> > > > > > > any
> > > > > > > > > reference to the company/software...and no luck.
> > > > > > > > >
> > > > > > > > > Any ideas/directions...anything?
> > > > > > > > >
> > > > > > > > > Thanks,
> > > > > > > > >
> > > > > > > > > Mark A. Matte
> > > > > > > > >
> > > > > > > > > __________________________________________________________
> > > > > > > > > __ __ ___ It's tax season, make sure to follow these few
> > > > > > > > > simple tips
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > >
> > > >
> > >
> > >http://articles.moneycentral.msn.com/Taxes/PreparationTips/PreparationTips.
> > > > >aspx?icid=HMMartagline
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > --
> > > > > > > > > AccessD mailing list
> > > > > > > > > AccessD at databaseadvisors.com
> > > > > > > > > http://databaseadvisors.com/mailman/listinfo/accessd
> > > > > > > > > Website: http://www.databaseadvisors.com
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >--
> > > > > > > >Billy Pang
> > > > > > > >http://dbnotes.blogspot.com/
> > > > > > > >"Once the game is over, the King and the pawn go back in the
> > > > > > > >same
> > > > >box."
> > > > >
> > > > > >-
> > > > > > > >Italian proverb
> > > > > > > >--
> > > > > > > >AccessD mailing list
> > > > > > > >AccessD at databaseadvisors.com
> > > > > > > >http://databaseadvisors.com/mailman/listinfo/accessd
> > > > > > > >Website: http://www.databaseadvisors.com
> > > > > > >
> > > > > > > ______________________________________________________________
> > > > > > > __ _ Get a FREE Web site, company branded e-mail and more from
> > > > > > > Microsoft
> > > > > >Office
> > > > > > > Live!
> > > > > > > http://clk.atdmt.com/MRT/go/mcrssaub0050001411mrt/direct/01/
> > > > > > >
> > > > > > > --
> > > > > > > AccessD mailing list
> > > > > > > AccessD at databaseadvisors.com
> > > > > > > http://databaseadvisors.com/mailman/listinfo/accessd
> > > > > > > Website: http://www.databaseadvisors.com
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >--
> > > > > >Billy Pang
> > > > > >http://dbnotes.blogspot.com/
> > > > > >"Once the game is over, the King and the pawn go back in the same
> > > > > >box." - Italian proverb
> > > > > >--
> > > > > >AccessD mailing list
> > > > > >AccessD at databaseadvisors.com
> > > > > >http://databaseadvisors.com/mailman/listinfo/accessd
> > > > > >Website: http://www.databaseadvisors.com
> > > > >
> > > > >_________________________________________________________________
> > > > >Watch free concerts with Pink, Rod Stewart, Oasis and more. Visit
> > > > >MSN Presents today.
> > > > >http://music.msn.com/presents?icid=ncmsnpresentstagline&ocid=T002MS
> > > > >N0
> > > > >3A
> > > > >07001
> > > > >
> > > > >--
> > > > >AccessD mailing list
> > > > >AccessD at databaseadvisors.com
> > > > >http://databaseadvisors.com/mailman/listinfo/accessd
> > > > >Website: http://www.databaseadvisors.com
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >--
> > > > >AccessD mailing list
> > > > >AccessD at databaseadvisors.com
> > > > >http://databaseadvisors.com/mailman/listinfo/accessd
> > > > >Website: http://www.databaseadvisors.com
> > > >
> > > >_________________________________________________________________
> > > >Its tax season, make sure to follow these few simple tips
> > > >http://articles.moneycentral.msn.com/Taxes/PreparationTips/Preparatio
> > > >nT
> > > >ips.a
> > > >spx?icid=HMMartagline
> > > >
> > > >
> > > >--
> > > >No virus found in this incoming message.
> > > >Checked by AVG Free Edition.
> > > >Version: 7.5.446 / Virus Database: 268.18.15/728 - Release Date:
> > > >3/20/2007
> > > >8:07 AM
> > > >
> > > >
> > > >
> > > >--
> > > >AccessD mailing list
> > > >AccessD at databaseadvisors.com
> > > >http://databaseadvisors.com/mailman/listinfo/accessd
> > > >Website: http://www.databaseadvisors.com
> > >
> > >_________________________________________________________________
> > >Get a FREE Web site, company branded e-mail and more from Microsoft
> > >Office Live!
> > >http://clk.atdmt.com/MRT/go/mcrssaub0050001411mrt/direct/01/
> > >
> > >--
> > >AccessD mailing list
> > >AccessD at databaseadvisors.com
> > >http://databaseadvisors.com/mailman/listinfo/accessd
> > >Website: http://www.databaseadvisors.com
> > >
> > >--
> > >No virus found in this incoming message.
> > >Checked by AVG Free Edition.
> > >Version: 7.5.446 / Virus Database: 268.18.15/728 - Release Date:
> > >3/20/2007
> > >8:07 AM
> > >
> > >
> > >--
> > >AccessD mailing list
> > >AccessD at databaseadvisors.com
> > >http://databaseadvisors.com/mailman/listinfo/accessd
> > >Website: http://www.databaseadvisors.com
> >
> >_________________________________________________________________
> >Exercise your brain! Try Flexicon.
> >http://games.msn.com/en/flexicon/default.htm?icid=flexicon_hmemailtaglinemar
> >ch07
> >
> >--
> >AccessD mailing list
> >AccessD at databaseadvisors.com
> >http://databaseadvisors.com/mailman/listinfo/accessd
> >Website: http://www.databaseadvisors.com
> >
> >--
> >No virus found in this incoming message.
> >Checked by AVG Free Edition.
> >Version: 7.5.446 / Virus Database: 268.18.16/729 - Release Date: 3/21/2007
> >7:52 AM
> >
> >
> >--
> >AccessD mailing list
> >AccessD at databaseadvisors.com
> >http://databaseadvisors.com/mailman/listinfo/accessd
> >Website: http://www.databaseadvisors.com
>
> _________________________________________________________________
> The average US Credit Score is 675. The cost to see yours: $0 by Experian.
> http://www.freecreditreport.com/pm/default.aspx?sc=660600&bcd=EMAILFOOTERAVERAGE
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
--
Gary Kjos
garykjos at gmail.com