Extract Just A Single User Data!

[garyopa]

I run a very very large forum, with tons of members and millions of posts, and recently one of the members on the forum have run into a large civic lawsuit, as such our forum going to shortly be subpoena by a Federal US Court to supply all the user's data, his IP records, signup date, and PM's he has, and the 19 posts he made.

I am looking for help or even possible paid, for the proper SQL query I can supply to the vbulletin v3.8.7 database to extract just this single user data in raw form, and or printable form without having to supply the whole 19gb of SQL database, etc.

Any suggestions you have or possible direction on what command to issue to give up just the users data would be most welcome.

Thanks in advance for your input.

[BirdOPrey5]

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.