Casting hexadecimal IPs to readable content

Поиск
Список
Период
Сортировка
От Jean-Michel Pouré
Тема Casting hexadecimal IPs to readable content
Дата
Msg-id 1195748002.7848.6.camel@debian
обсуждение исходный текст
Ответы Re: Casting hexadecimal IPs to readable content
Список pgsql-general
Dear Friends,

My PhpBB forum with 4000 users was hacked in Switzerland.

Enquirers (not my own idea) proposed that I look for certain IPs in my
PostgreSQL 8.2 database. The problem is that PhpBB stored IPs as
strings, which seem to be more or less encoded.

In PhpBB, IPs are stored as Hexa:
"54dc0636"
"52e1fcb6"

How to cast these values to readable content?
Any idea ? This is an important issue for me.
Thank you for any help.

Kind regards,
Jean-Michel


В списке pgsql-general по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: LIBPQ: Can we have buffered PGresult (i.e. a retreival bu chuncks?)
Следующее
От: "Harald Armin Massa"
Дата:
Сообщение: Re: Casting hexadecimal IPs to readable content