What does this mean

Precips1

Registered User.
Local time
Today, 17:22
Joined
Dec 28, 2010
Messages
35
Anybody know how this works out?

INSERT INTO `MyDatabase` VALUES (1, '3454', 'nneqinexdtdthkdse');

The answer = Aardvark

Its from a course a friends doing where It gets to inserted into mySQL database, 1 being the ID. Not sure what the other values will be but the text should then be scripted to = Aardvark.

Anyone know whats going on?

Cheers
M
 
Last edited:
It is some form of encryption but it wouldn't be very effective because it would be very easy to crack.

Look at the first eight characters "nneqinex". It is obvious that they are in the same pattern as "aardvark".

Simply count 13 letters either forwards or back and keep going around again if you reach the beginning or end of the alphabet.

"dtdt" converts to "qqqq" which is probably an end of string marker.

Without seeing more examples it would be impossible to determine anything more about the code.
 
Galaxiom,
Thanks for the reply. I so glad you know what your talking about. I kinda see what your saying but I'm still not with it.

I've posted a couple more examples below, I don't expect you to answer all but if you could give me a couple more examples would be great.

What do you mean counting 13 letters forward or back and how does "dtdt" converts to "qqqq"

Thanks again.
Mike

PS. Sorry I can't give you the answers to these... that's what we're trying to find out.

INSERT INTO `test` VALUES (2, '3567', 'nyyvtngbedtdthkdse');
INSERT INTO `test` VALUES (3, '4635', 'nycnpndtdthkdse');
INSERT INTO `test` VALUES (4, '5246', 'nagrngredtdthkdse');
INSERT INTO `test` VALUES (5, '6534', 'nagrybcrdtdthkdse');
INSERT INTO `test` VALUES (6, '7124', 'neznqvyybdtdthkdse');
INSERT INTO `test` VALUES (7, '8349', 'onobbadtdthkdse');
INSERT INTO `test` VALUES (8, '9316', 'onqtredtdthkdse');
INSERT INTO `test` VALUES (9, '7428', 'orniredtdthkdse');
INSERT INTO `test` VALUES (10, '8245', 'ovfbadtdthkdse')
 
Last edited:
Waw !! Thank you, Galaxiom. Never mind.

@Precips
I think (in fact I'm pretty sure) that the Galaxiom idea is:

nneqinexdtdthkdse = nneqinex + dtdthkdse = aardvark + dtdthkdse =>
nneqinex = aardvark =>
n = a, e = r, q = d, i = v, e = r, x = k
so, using ASCII table:
n - 13 = 110 - 13 = 97 = a
e - 13 = 101 - 13 = 88 < 97 (code for "a") => count "forward" => e + 13 = 101 + 13 = 114 = r

So, you can use this function to determine the not encrypted character:

Code:
Function RealChr(EncriptedChr As String) As String
Dim CodeRealChr As long
  CodeRealChr = Asc(EncriptedChr)  - 13
  If CodeRealChr < 97 Then
    CodeRealChr ASCII(EncriptedChr)  + 13
  End If

  RealChr = Chr(CodeRealCh)
End Function
Not sure if "aardvark" is a word in English (seems to be) so, using the previous function, you will obtain some words in English (with gaps, of course) for the strings from your last post.
You should "fill" this gaps from your brain in order to obtain real words.

Code:
... and how does "dtdt" converts to "qqqq"
I think that this is converted to "qgqg" but seems to have no importance because I think (unlike Galaxiom, I can see now your last post) that the end of string marker is "dtdthkds".
 

Users who are viewing this thread

Back
Top Bottom