Problem with showing album link in postbit

[Mark.B]

I am using THIS mod to try and get a link to show in postbit/postbit legacy if a user has any albums. However, as written the mod does not work for me (3.8.1 PL1). The mod author is not about so I am trying to fix it myself.

The problem is that this conditional is always returning false:

if (!empty($post['hasalbum']))

So the code does not show up. I can remove the conditional and the code will show fine, but obviously for everyone, even if they have no album.

The sub query being used at hook location showthread_query is this:

$hook_query_fields .= ",album.userid as hasalbum";

$hook_query_joins .= "LEFT JOIN (SELECT state, userid, MAX(albumid) AS hasalbum FROM " . TABLE_PREFIX . "album GROUP BY userid) album ON(user.userid = album.userid AND album.state = 'public')";

I can't work out why this isn't working for me....looking at the thread it works for some and not others. What's wrong? What other conditional could I replace that conditional with to try and make it work?

[Lynne]

Try looking at your error_logs and seeing if there is something in there about the query.

[Mark.B]

Thanks Lynne, no, nothing at all in there.

[Lynne]

Where are you doing the condition? Are you sure the query is done before that plugin?

[Mark.B]

Originally Posted by Lynne

Where are you doing the condition? Are you sure the query is done before that plugin?

I think so....it's showthread_query for the query, followed by postbit_display_start for the conditional.

[Lynne]

I believe in postbit_display_start you need to use $this->post, not $post.

[Dismounted]

Either will work, they are one and the same (by-ref).

[Mark.B]

Thanks...but still not working.

Got me baffled this...

[Lynne]

I just tested this on my test site and it works just fine. Are you sure you have an up-to-date postbit (or postbit_legacy) template that has the correct template_hook for it to show?

[Mark.B]

Thanks Lynne....Yes, definitely. I know this because I have removed the conditional so that the code shows up for everyone, and it's appearing ok.

There are others in the mod thread saying it isn't working for them....I wonder if it's one of those mods that only works under certain server configurations.