Hi, I have lots of spammers on my site and I am using wp-ban plugin to ban them all individually. For this, i need to know the IP of spammers which wassup already tracks.
Now the problem is I dont know how to get all IP addresses of some date. I see the column timestamp in wassup table structure, but not sure how it is calculated.
I would be great if somebody would give me a SQL query to get all visitors IP addresses of some date X, or atleast todays visitors.
Thanks,
EnLi
Why was my previous account was deleted for no reason?
I just need to know how to get date from wassup table.
All i am trying to achieve is, make a query to MY OWN sql database and get the count of pagevisits of some visitor. The purpose is to ban abuser after looking for entry in http://www.projecthoneypot.org/. Whats wrong in that?
Anyways, so far i have this query that will tell me number of hits by certain IP.
SELECT count(timestamp) from wp_wassup where ip="XYZ";
I just need to add condition that will specify to get only TODAYS hits.
Nope. Nothing wrong with accessing your own data.
The timestamp value for 24 hours ago is time()-24*60*60. If you set a variable in PHP $yesterday=time()-24*60*60; you can use it to build your Mysql query.
ex: $query = "SELECT...WHERE...AND timestamp >$yesterday";
If you are working directly in MySql, the syntax is:
SELECT...WHERE...AND timestamp>(UNIX_TIMESTAMP()-24*60*60);
There are some timezone issues that I am ignoring here, but I will leave it up to you to add or subtract more seconds from "unix_timestamp()" to get exactly 24 hours worth of data.
Good luck with your banning effort. I found it to be a lot of hard work for little gain, myself. Spammers learned years ago to quickly rotate their IP addresses and domains to get around IP and domain blocking.
Might I suggest that in addition to WP-Ban, you add an anti-spam plugin like Akismet, add a security question or captcha to your comments via a comment or contact plugin, and possibly install another gatekeeper plugin like Bad Behavior that uses a more heuristic method to find and block spammers before they get to your blog. This "triple-block" method is very effective on my own site.
You must log in to post.
