XF 1.5 Deleting an IP address from the DB

Alfa1

Well-known member
#1
During an import process, the admin IP address was erroneously added to the accounts of a number of users.
This would create significant problems as soon as a multiple accounts checker is activated.
How can I query the DB for this IP address and remove all instances of it?

I see the IPs are in binary format, but for soem reason when I search for the binary I get no results.
 

Alfa1

Well-known member
#3
How weird. I get this when running the select version:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM xf_ip WHERE ip = UNHEX(LPAD(HEX(INET_ATON('1.2.3.4')), 8, '0')) LIMIT' at line 1
 
Top