Notifications
Clear all

Where are the received upvotes of a user saved?

3 Posts
2 Users
1 Reactions
251 Views
Posts: 13
Topic starter
(@pablo)
Eminent Member
Joined: 11 months ago

I want to create a small plugin that shows the top 10 user with most received upvotes in the last 24h/7days an so on. But i dont know where those votes are saved in the database. Can someone help me?

btw. I just built a small plugin that shows the user who where most active within the last 24h/7days/alltime. If anyone wants it, i can upload it. Screen:

 

2 Replies
Sofy
Posts: 5391
 Sofy
Admin
(@sofy)
Support Team
Joined: 7 years ago

Hi,

You can find it in the wp_wpforo_reactions table. 

The wp_ is just a prefix. In your case, it may differ. 

Reply
Posts: 13
Topic starter
(@pablo)
Eminent Member
Joined: 11 months ago

Thank you, it works so far. But is it possible to sort the received likes by „In the last 7 days“ „24h“ and so on. as there is no date in the table i guess not?!

 

 

IMG-6230 IMG-6229

Reply