XF 2.2 Extract certain content from threads into csv?

[Static-Xbox]

Hi,

I realize this isn't built-in functionality, but I was wondering if there was a way to extract certain content from threads into a csv format? A member of mine wants to gather analytical information from a wolf game that's being played, it gets rather large daily threads, so simply scouring the pages is proving too difficult. He wants to, and I'll go ahead and use his own words here:

export TIMESTAMP; USERNAME; POST_NUMBER; POST in a CSV format

Is there a way to achieve this?

 

[Paul B]

Phpmyadmin would do that easily.

 

[Static-Xbox]

Phpmyadmin would do that easily.

Would there be a way without phpMyAdmin access?

 

[Paul B]

Yes, there are various ways to do it using mysql.

You will have to query the database so you will need server access via shell.

 

[Static-Xbox]

Thanks @Brogan, I'll see what I can do. I have access to shell and phpMyAdmin, the member asking for this does not, so need to sort that out.

 

[Paul B]

If you're going to provide access to them, I recommend you create a new DB user account with read only access so they can't do any damage.

Or create a simple PHP script which they can trigger which would pull the data.

 

[Static-Xbox]

Thanks @Brogan, that's what I'm going to look to do, a simple script the can be run to query for data from certain threads.

Edit -- done, thanks so much for the advice