[bulbasnore]

Thanks for this hack. I have 3.6.7_pl1 at the moment. I would love to see this with no code edits... do you think the necessary hook will ever be available?

One thing that I like to have, is a report for me and our staff to see who has been using proxies lately.

Below I present a SQL query for such a report and an xml export of a report for those who are using Logician's excellent WebTemplates mod.

SELECT username, count( * ) 
FROM  `post` 
WHERE  `proxyip` REGEXP '[0-9].*'
GROUP BY username
ORDER BY  `username` ASC

The above query gives you how many posts by a proxy for each user, in total.

The attached XML file list username, proxy ip, real ip for the last 30 days in descending order of post date.