Is there any way to download in text format all threads ( only first post ) started by a user in a specific forum.
can this be done by running a mysql query?
can this be done by running a mysql query?
vBulletin 4.2.5 is end of life and will not be receiving any future development. Warning: vBulletin 4.2.5 is not compatible with PHP 7.2.0 or higher.
Welcome to the vBulletin support forums! In our community forums you can receive professional support and assistance with any issues you might have with your vBulletin Products.
Useful Links for Guests:
If you are having problems posting in the relevant areas for your software, please see this topic.
SELECT post.pagetext FROM thread LEFT JOIN post ON(post.postid = thread.firstpostid) WHERE thread.postuserid = 1 AND thread.forumid = 2
SELECT CONVERT(post.pagetext USING utf8) FROM thread LEFT JOIN post ON(post.postid = thread.firstpostid) WHERE thread.postuserid = 1 AND thread.forumid = 2
Comment