Author Topic: search clients by IP (Read 2624 times)

bookup · « **on:** May 24, 2004, 02:09:44 pm »

We recenly blocked all 202.* and 203.* IP's from our site due to a bunch of fraudulant credit card orders.

How can I get a list of customers by range of IP address so I can see who is affected?

DW · « **Reply #1 on:** May 24, 2004, 02:27:48 pm »

With PhpMyAdmin you can select these users, if stored in ListMail, with the following command:

select * from lm_users where ipaddr = '203.%' or ipaddr = '202.%'

bookup · « **Reply #2 on:** May 24, 2004, 07:36:34 pm »

Quote from: "DW"

With PhpMyAdmin you can select these users, if stored in ListMail, with the following command:

select * from lm_users where ipaddr = '203.%' or ipaddr = '202.%'

Okay, what is "PhpMyAdmin?" :lol:

DW · « **Reply #3 on:** May 25, 2004, 04:04:02 pm »

PhpMyAdmin is a tool to manually view and modify your MySQL databases. It is accessible from your control panel. Since you're hosted with me, login to Plesk, click your domain, click on Databases, click your ListMail database., click the link "PhpMyAdmin". A new window will open up. Click the database name again in the left frame, then click the link "SQL" in the right frame and enter the custom MySQL query in the box provided.