This'll give you the posts from a given IP - same as above, replace # with your UBBT table prefix, and ### with the IP number you're interested in.

Code
SELECT `#_POSTS`.`POST_ID`, `#_POSTS`.`POST_SUBJECT`, `#_POSTS`.`POST_POSTER_IP`, `#_USERS`.`USER_DISPLAY_NAME`
FROM `#_POSTS`,
`#_USERS`
WHERE `#_POSTS`.`POST_POSTER_IP` = "###"

These aren't perfect - they need work! smile

PCTechGuide