[AccessD] OT(kinda): Crack Code

Mark A Matte markamatte at hotmail.com
Thu Mar 22 14:22:52 CDT 2007


Tha might be what the guy meant by 'shift a bit or 2'.

I'm running frequency distribution on each char...and 7th char is 0 
everytime except for 2 times out of 500K...

Thanks for the 'shift'  I'll move all calcs over to spaces...and see what I 
get.

Thanks,

Mark A. Matte



>From: "Gary Kjos" <garykjos 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: Thu, 22 Mar 2007 13:57:32 -0500
>
>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.
> > > >
> > > >

> > > > >
> > > > >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

> > > > >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: "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

_________________________________________________________________
It’s tax season, make sure to follow these few simple tips 
http://articles.moneycentral.msn.com/Taxes/PreparationTips/PreparationTips.aspx?icid=HMMartagline




More information about the AccessD mailing list