in phpmyadmin or whatever you use, go to the post table and run:
SELECT * FROM `post` WHERE `userid` = X
Where X is his userid (not username, but id number)
If it's only 19 records it will return them all, in phpmyadmin there is a print view option, print full text fields... it will contain all data recorded by the forum from each post.
The only other thing you might need is the 1 entry from the user table for his userid as well, which will contain the registration ip address, email address, and other info.
If you use a table prefix, you need to use that in the sql statement... for example your post table might be called: vb_post instead of just: post.
--------------- Added [DATE]1299435659[/DATE] at [TIME]1299435659[/TIME] ---------------
Oh, and pms... Well assuming he didn't delete them, that is a tougher query but it would be the pm_text table with the data you need.
Or much easier would probably be to use the "login as user" mod and just print the PMs from his account directly. PMs don't contain any IP addresses so there is nothing else there really besides the "To", "From", date, the text of the PM, and some useless fields with no personal data.
|