Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 17 Jan 2017, 07:41
tischtelefon2 tischtelefon2 is offline
 
Join Date: Jan 2017
Export threads from a single user / Query modification

Hi all,

I need a bit support. A good friend of mine died and he actively posted in my forum and started several threads. So I would like to export all threads my friend started including the first post he wrote. I'd like to use this as a kind of memorial for all of his friends.

The following query does a good job to get all of his postings, but I only want to export the threads including the first post. Could anyone help me how to modify the query?


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Thanks so much.

Michael
Reply With Quote
  #2  
Old 17 Jan 2017, 07:49
MarkFL's Avatar
MarkFL MarkFL is offline
 
Join Date: Feb 2014
Real name: Mark
Try changing:


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

to:


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

__________________
Former vBulletin.org Staff Member



Support for my products (as well as updates/new product publishing) has been moved to MHB - vBulletin Products and TAZ - Add-ons
Reply With Quote
  #3  
Old 17 Jan 2017, 07:52
tischtelefon2 tischtelefon2 is offline
 
Join Date: Jan 2017
Thanks so much, Mark. Thanks so much.

--------------- Added 17 Jan 2017 at 08:10 ---------------

Mark, I hope it's okay that I ask another question. How do I need to modify the query if I want to extract all threads my friend started including all other postings(I mean replies) of theses threads? So I export the complete thread?

Thanks so much.

Michael

Last edited by tischtelefon2; 17 Jan 2017 at 08:15.
Reply With Quote
  #4  
Old 19 Jan 2017, 12:18
André Noberto André Noberto is offline
 
Join Date: Feb 2011
Location: Brazil
Real name: André Noberto
I think would be easier if you do another query to only get the secondary posts.

If you agree with me you can try something like this:

1 - Store threadid and firstpostid into variables.
2 - Query.


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Reply With Quote
  #5  
Old 19 Jan 2017, 13:47
MarkFL's Avatar
MarkFL MarkFL is offline
 
Join Date: Feb 2014
Real name: Mark
Originally Posted by tischtelefon2 View Post
--------------- Added 17 Jan 2017 at 08:10 ---------------

Mark, I hope it's okay that I ask another question. How do I need to modify the query if I want to extract all threads my friend started including all other postings(I mean replies) of theses threads? So I export the complete thread?

Thanks so much.

Michael
Sorry, I didn't know you had posted another question since the posts were merged. For this, I would run a sub-query, like so:


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

__________________
Former vBulletin.org Staff Member



Support for my products (as well as updates/new product publishing) has been moved to MHB - vBulletin Products and TAZ - Add-ons
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 09:22.

Layout Options | Width: Wide Color: