ListMailPRO Email Marketing Software Forums

ListMailPRO Email Marketing Software Forums => General Help & How-To => Topic started by: bookup on May 24, 2004, 02:09:44 pm

Title: search clients by IP
Post by: 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?

Title: search clients by IP
Post by: DW 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.%'

Title: search clients by IP
Post by: bookup 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:

Title: search clients by IP
Post by: DW 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.