AdminCP: search posts for user and ip.

[raywjohnson]

Actually I am looking for posts by a user that matches both the userid and an ip address. I already have the Ipinfo mod installed. I have bungled a few queries on the post table ( causing the server to be overloaded for 10+ minutes!), so I hunted through the vB code to find the query they use and modified it thus:

SELECT postid
FROM post AS post
INNER JOIN thread AS thread ON(thread.threadid = post.threadid)
WHERE post.userid = '' and ipaddress = ''
ORDER BY post.dateline DESC

or for fewer ip octets : ipaddress like '127.0.0%'

Which works well. I would like to have a function in the admincp so that the other admins can do the same search with out me giving them access to the SQL Query section.

--RayJ