I was subpoenad for a user's posts - how do you export a member's posts?

[beansbaxter]

I am running vb 3.8 and I was just served with a subpoena, signed by a judge, asking for the posts/communications of a particular user on my forum.

I know you can export Private Messages from within vb, but how can I export the user account's posts into a dump that I can email them?

The forum has nearly 2million posts, this particular user has around 2500 posts, is there a way to export out just his posts? And other communication? Into a TXT file?

Thanks in advance.

[Trevor Hannant]

You could try this in phpMyAdmin:

[COLOR=black]SELECT username, pagetext FROM `[COLOR=red]PREFIX[/COLOR]post` WHERE `userid` = [/COLOR][COLOR=red]x[/COLOR]

If you use a prefix for your tables, substitute this in for PREFIX and amend x to the relevant userid.

Once you get the results, there should be an 'Export' option there. I've just exported all posts by me on my forum into a PDF and it will create a document with two columns:

- Username
- Posts

Hopefully that should suffice

[Reeve of Shinra]

Can you just give him the private messages and tell them to use the publically available search option with instructions on how to do it? LOL

It also says communications -- does this mean you have to provide the entire thread he posted in?

[Zachery]

change their password, login to their account, download the xml backup of their PM's if they are still in your database.