XFileSharing Pro - Why IP address encrypted? How can search user by IP address?

Message
Author
qq_bbq
Posts: 122
Joined: Jul 05, 2009 11:33 pm

Why IP address encrypted? How can search user by IP address?

#1 Postby qq_bbq » Feb 26, 2012 4:46 pm

Why did you make the IP address encrypted?

admin
Site Admin
Posts: 1839
Joined: Mar 22, 2006 12:32 pm

#2 Postby admin » Feb 26, 2012 5:06 pm

What are you talking about?

qq_bbq
Posts: 122
Joined: Jul 05, 2009 11:33 pm

#3 Postby qq_bbq » Feb 26, 2012 5:11 pm

Admin user management, you cannot search by IP, enter it and always return no results.

If you go into phpmyadmin to search it, you can't because you can see the IP addresses stored in the database are encrypted/scambled.

qq_bbq
Posts: 122
Joined: Jul 05, 2009 11:33 pm

#4 Postby qq_bbq » Feb 26, 2012 5:20 pm

Please give decrypt code for IP address. It's very hard to manage users cheating, abuse, etc. without ability to search this.

admin
Site Admin
Posts: 1839
Joined: Mar 22, 2006 12:32 pm

#5 Postby admin » Feb 27, 2012 7:11 am

It's not encrypted, it's using inet_aton and inet_ntoa mysql functions:

http://dev.mysql.com/doc/refman/5.0/en/ ... _inet-aton

qq_bbq
Posts: 122
Joined: Jul 05, 2009 11:33 pm

#6 Postby qq_bbq » Feb 27, 2012 10:46 am

How do I search user by IP?

nyan
Posts: 163
Joined: Oct 28, 2010 8:01 pm

#7 Postby nyan » Feb 28, 2012 12:17 pm

qq_bbq wrote:How do I search user by IP?
He just said it
WHERE (name of ip field) = inet_aton(123.456.789.100)