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

D

djbaxter

in memoriam 1947-2022
Licensed customer
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?
 
Sort by date Sort by votes
Hello, is the vote count stored somewhere by XenForo software knowing that it is not visible anywhere ?
 
Upvote 0 Downvote
Upvote 0 Downvote
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?
Click to expand...

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

In xf_user Table,

1605212871593.webp

Find vote_score

1605212834181.webp

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,

1605212606285.webp
 
Upvote 0 Downvote
You must log in or register to reply here.

Similar threads

marremp2
  • Question Question
XF 1.5 How to add number of likes in resource_header template ?
Replies
0
Views
1K
marremp2
marremp2
Back
Top Bottom