AdminCP: search posts for user and ip.

[raywjohnson]

Greetings!

Looking for a mod the will add a new "search" feature to the "Threads & Posts" section of the AdminCP. Not really a search, but a simple query that finds all posts by user and filters for an IP address.

SELECT * FROM post WHERE userid=x and ipaddress=xx.xx.xx.xx

--RayJ

[Lynne]

Are you looking to find the IPs for that user? If that's all you are after, then go to Users > IPs and input the username and it will spit out all the IPs that user has posted under.

[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 (https://vborg.vbsupport.ru/showthread.php?t=117966) 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

[raywjohnson]

I have finally tried my hand at creating a mod.

I allows admins to search the post table for ip address and user id.

Once I get it debugged (and polished), I may post it!

--RayJ