Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 08 Dec 2008, 05:13
h2ojunkie h2ojunkie is offline
 
Join Date: Sep 2004
limit left join to 1 record

Maybe I'm going about this all wrong, but basically I'm trying to add to showthread_query to check if the user has any public albums so I can check for the albums using a conditional in the postbit.

I was trying to just LEFT JOIN, but if the user has more than one public album, I end up with too many results.

I need to limit the result to just the 1st public album for that user or else I end up with posts duplicating on showthread

This is far as I can get

For: showthread_query $hook_query_fields

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

And for: showthread_query $hook_query_joins

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

How would I limit the join to one result?

Or is there a better way to just fine out if the user has any public albums. I don't really need the albumid..i just need to establish if they have any public albums at all.
Reply With Quote
  #2  
Old 08 Dec 2008, 05:45
Adrian Schneider's Avatar
Adrian Schneider Adrian Schneider is offline
 
Join Date: Jul 2004
Use an aggregate function like count() instead of album.userid and then group by your primary recordid.
Reply With Quote
  #3  
Old 08 Dec 2008, 23:19
h2ojunkie h2ojunkie is offline
 
Join Date: Sep 2004
Ok, so I played around with the Group By and found something that does work as intended.

I thought I'd post it up here and see if anyone can think of a more efficient or cleaner way to do it.

Basically, I need a conditional to eval to true for use in the postbit template if the user has any public albums.

The conditional I'm using:

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


And the query I got to work:

Hook: showthread_query


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


As I said, I got this working as intended. But I'm not sure if this is the best/most efficient way to do things since I had to use MAX(albumid) to make sure it only returned on result no matter how many public albums they have.

Anyone have any input?
Reply With Quote
  #4  
Old 17 Dec 2008, 22:40
firstimecaller's Avatar
firstimecaller firstimecaller is offline
 
Join Date: Feb 2004
this is very useful and should, of course, be standard in vB to help support social and album use. If I had some time I'd play around with the query to help.
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 08:57.

Layout Options | Width: Wide Color: