XF 2.3 Add counts next to Watch button

[Andy.N]

What would be the easiest way to add a count next to the Watch button on resources/thread.
For resource, there is xf_rm_resource_watch table that keeps track of user ids that watch a resource.

Is there a variable that we can use in the template to show this count?

 

[Old Nick]

How many users watch the content?
You can dump vars to see if one of them store this count.

 

[Paul B]

This will help you achieve most things of this nature.

P

How To ...

Jul 10, 2015

A series of tips and guides covering the basics

• Paul B
• XenForo tips & guides [1.x]

P

Using variables in templates

Feb 2, 2016

$bro.guide

• Paul B
• XenForo tips & guides [1.x]

 

[Andy.N]

Thank you @Paul B
I find your How to guides extremely helpful and have you used them in the past.
Do you foresee any changes from the guide written for XF 1.x so I can apply to 2.3.x?

 

[Paul B]

The principles are the same.

 

[Andy.N]

The principles are the same.

Instead of {xen:helper dump, $forum} we have to {{ dump($forum) }}, correct?

 

[Andy.N]

How many users watch the content?
You can dump vars to see if one of them store this count.

Looks like there is no variable exposed to show the watch value.

 

[Paul B]

This XF2 guide may also help.

P

Identifying and using variables in templates, advertising positions, navigation entries, and widgets

Sep 24, 2020

$xf.bro_guide

• Paul B
• XenForo tips & guides [2.x]

 

[Old Nick]

Nothing here?

 

[Old Nick]

I don't think so...

 

[Andy.N]

I don't think so...

View attachment 312535

Yep, it shows values in the resource table but the watch values is in the resource_watch table.
I think that's why we have the _relations variable there. I don't know how we can get the values out of it because it seems to group by user id. We need a total watch count for each resource.

 

[Paul B]

From memory I don't believe it's exposed.

It would require development.

 

[Andy.N]

From memory I don't believe it's exposed.

It would require development.

Makes sense. If there is no _values in that array, then it's not exposed.

 

[Kirby]

Untested, but smth. like this should work

{{ $xf.app.get('em').getFinder('XFRM:ResourceWatch').where('resource_id', $resource.resource_id).total() }}

Keep in mind though that this causes an additional query for every resource so you might want to use a different approach if you need multiple watch counts on one page.

 

[Andy.N]

Untested, but smth. like this should work

{{ $xf.app.get('em').getFinder('XFRM:ResourceWatch').where('resource_id', $resource.resource_id).total() }}

Keep in mind though that this causes an additional query for every resource so you might want to use a different approach if you need multiple watch counts on one page.

The function where may not be called in a template. Only functions with whitelisted prefixes are allowed.

 

[Kirby]

Oops

Okay, different (lower level) approach

{{ $xf.app.get('db').fetchOne('SELECT COUNT(*) FROM xf_rm_resource_watch WHERE resource_id = ?', $resource.resource_id) }}

This idea does work (tested with thread watches), but the variable might not be correct.