Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Pages: 1
slimstat query
Can someone tell me of a mysql/php query for slimstat which will help me just get a page with IPs who visited a particular page in one of my sites?
The site is under attack for a few months now with ‘visitors’ from all over the place just visiting /id/title —-> /id/my-title.
I ignored this initially as I thought that it would die out but unfortunately the visits are relentless so now I’ll have to see how many times each IP has visited the page and block the most abusive ones with htaccess.
Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.
Offline
Re: slimstat query
Hey Yiannis – not to deliberately side-step your MySQL/PHP request, but do you have access to web server log files, and a UNIX/Linux-based shell? If so, this might be useful: www.bencarpenter.co.uk/awk-for-apache-nginx-logs
Offline
Re: slimstat query
Thanks pete
I’m looking for something less unixy… I found this which might dive me a kick start… or a gentle push.
Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.
Offline
Re: slimstat query
Ok…. That was more of a gentle push…. I am still trying to get up to speed.
Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.
Offline
Re: slimstat query
Hi Yiannis,
if your logs are in txp_log (or some other) table, why wouldn’t you proceed with a plain [smd|etc]_query?
Offline
Re: slimstat query
Hi Oleg
The logs are in a slimstat table outside the txp system. I am using wet_slimpattern to connect to the slimstat db.
Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.
Offline
Re: slimstat query
colak wrote #285942:
The logs are in a slimstat table outside the txp system. I am using wet_slimpattern to connect to the slimstat db.
Pity, I’ve got no idea of Slimstat db structure. You’ll probably have more chance on their forum.
Offline
Re: slimstat query
etc wrote #285943:
Pity, I’ve got no idea of Slimstat db structure. You’ll probably have more chance on their forum.
Would this possibly help?
https://github.com/stephenwettone/slimstat/blob/master/page/setup.php
Offline
Offline
Pages: 1