(RESOLVED) Decoding IP Address Blocks
Hi,
I blocked a user account and I checked "also block the IP address used by this user". However the db row is in some format I can not decode. Can you help be find the ip address of this user?
(591, 0x36372e3135392e34342e3931, 0, 2, 0x4175746f626c6f636b6564206265636175736520796f7572204950206164647265737320686173206265656e20726563656e746c79207573656420627920225b5b557365723a446f75636865666167327c446f75636865666167325d5d222e0a54686520726561736f6e20676976656e20666f7220446f7563686566616732277320626c6f636b2069733a202241627573696e67206d756c7469706c65206163636f756e747322, '20101018055227', 1, 0, 1, '20101019055226', 0x3433394632433542, 0x3433394632433542, 0, 0, 0, 'ThePlaz', 0);
Its documented at Manual:Ipblocks table. The 0x<long string of numbers> is probably an ascii (or utf-8 if you want to be technical, although probably not too many special chars there) field encoded in hexadecimal. The fact your getting this instead of letters that normal people can read is due to how you're using whatever program you're using to access your db. You should be able to find a converter online somewhere. The numeric fields starting with 2010 are dates in YYYYMMDDHHMMSS format.
If you need to do this sort of thing, you should maybe check out extension:Checkuser
Thanks. I did see the ipbloocks table schema. I searched for "hexadecimal to ascii" and found this result which worked. I had thought I had tried hexadecimal to ascii, but I guess I messed something up. Thanks
