XF 2.2 How to add number of Q&A upvotes as a category for Notable Members?

djbaxter · Nov 9, 2020

In the Notable Members tabs, we can already include a list for most posts/threads and most reactions.

I would like to add a "most upvoted" list for Question and Answer threads.

How would I do this?

djbaxter · Nov 12, 2020

Bumping this.

Old Nick · Nov 12, 2020

Hello, is the vote count stored somewhere by XenForo software knowing that it is not visible anywhere ?

djbaxter · Nov 12, 2020

I don't know.

Paul B · Nov 12, 2020

Follow this guide to determine whether the variable you need is available in the template.

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

What are variables? In simple terms, variables are names which hold values. These values are stored in the database and are used in templates to evaluate and present the content and data. Using variables in templates opens up a lot of...

xenforo.com

djbaxter · Nov 12, 2020

@Brogan I don't even know what template it would be in.

Paul B · Nov 12, 2020

This guide explains how to identify the template.

How To ... - Updates

xenforo.com

XDinc · Nov 12, 2020

djbaxter said:
In the Notable Members tabs, we can already include a list for most posts/threads and most reactions.

I would like to add a "most upvoted" list for Question and Answer threads.

How would I do this?

@djbaxter
I can create a guide or add-on for you.

In xf_user Table,

Find vote_score

All you have to do is check the current structure of XF / Member Stats.

Like as,

PHP:

class YourClass
{
    public static function isVisible(\XF\Entity\MemberStat $memberStat): bool
    {
        return boolval(\XF::db()->fetchOne("
            SELECT user_id
            FROM xf_user
            WHERE vote_score > 0
            LIMIT 1
        "));
    }
}

Result,