Download wpForo 3.0

AI Search
Classic Search
 Search Phrase:
 Search Type:
Advanced search options
 Search in Forums:
 Search in date period:

 Sort Search Results by:

AI Assistant
Forums
wpForo Support Foru...
How-to and Troubles...
Where are the recei...
 
Notifications
Clear all

Where are the received upvotes of a user saved?

    Summarize Topic
How-to and Troubleshooting - wpForo 2.0
Last Post by Pablo 1 year ago
3 Posts
2 Users
1 Reactions
838 Views
RSS
Posts: 14
 Pablo
Topic starter
Translate ▼
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
Apr 06, 2025 3:41 pm
(@pablo)
Eminent Member
Joined: 2 years ago
[#62348]

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:

 

 IMG 6139

Topic Tags
upvotes database custom plugin
2 Replies
Sofy
Posts: 5774
 Sofy
Admin
Translate ▼
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
Apr 07, 2025 3:20 pm
(@sofy)
Support Team
Joined: 8 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. 


In case you want to say thank you 😊

We'd really appreciate and be thankful if you leave a good review on plugin page. This is the best way to say thank you to this project and support team.

Reply
Pablo reacted
Posts: 14
 Pablo
Topic starter
Translate ▼
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
Apr 09, 2025 11:54 am
(@pablo)
Eminent Member
Joined: 2 years 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
Forum Jump:
  Previous Topic
Next Topic  
Related Topics
Topic Tags:  upvotes (1) , database (33) , custom plugin (1) ,
Share: