[3.3][DEV] phpBB Topic/Post Reactions, Thanks, Like

[Steve]

Extension Name: phpBB3 Topic/Post Reactions, Thanks, Like
Author: Steve
Emoji credits: https://twemoji.twitter.com/
Credits: To those who helped test this extension.

Extension Description:
Allows users to add image reactions, thanks and likes to, topics and posts.

Reaction Types: Thanks, no thanks, like, dislike, love, LOL, happy, neutral, angry etc... or add your own!!
Thanks/Like: Ability to show one button for this option.

Extension Version: 0.9.2-dev

Requirements:

• phpBB 3.3.5 >=
• PHP 7.4 >=
• Styles: Prosilver based (no support for custom paid for styles)

Features:

1. View Topic Page:
   • Add/Change/Delete Reaction.
   • Show Topic/Post Reactions types list, count, and total reaction count.
   • Link to pop up list containing reactions by users.
   • Re-sync.
2. User Profile:
   • Total Reactions count.
   • View received and reacted images with count. Clicking the reaction Image will generate a list of users gave the reaction.
3. User Control Panel:
   • Enable/disable Reactions to your Topic/Posts.
   • Enable/disable certain Reaction types to your Topic/Post (sensitive Souls )
   • Prevent Foes from reacting to your Topics/Posts.
   • Enable/disable notifications.
   • Enable/disable reaction.
4. User Notifications:
   • Notifications sent via the board or email, upon receiving reactions, containing username who reacted, reaction type image, post subject and post link.
5. Pages:
   • Statistics per Reaction type.
   • Post reactions page: A list of users who have reacted to that post, clicking the reaction image will show a list of users who reacted with that reaction type.
   • View reactions, a page displaying users with the most reactions. View received reaction images with count. Clicking the reaction Image will generate a list of users gave the reaction.
6. Admin Control Panel:
   • General settings.
   • Add/Edit/Delete/Order Reaction types.
   • Group and user permissions.

Screenshots: here: https://steven-clark.tech/phpBB3/viewtopic.php?t=4

Demo Reactions page: coming soon.

Donations: I accept gifts and donations, keep the beer coming …

Permissions need to be set for this extension: coming soon.

FAQ's: coming soon.

Extension Download: Here

To enable the traffic light system: Please Read

[bennybernaer]

Great extension! Everything works as it should.

[dbrewood]

Looks good, on my list to try out! I hope that when upgrading to v0.8 that any used reactions will not be lost?

[Steve]

No data will be lost.

[dbrewood]

Brilliant, I'll look to try it out next week then!

[bennybernaer]

Excellent!

[dbrewood]

And it is installed. I'll have to see how it goes. The forum is run on my NAS and it does seem slower since installing the Extension. However, I've been doing a lot of work on the NAS today so it may be coincidental.

I know clicking on a reaction shows who has posted it etc, but how are the other reaction pages accessed?

[Steve]

You can see reactions in members page and the reactions page link is found in the navbar.

[dbrewood]

Right, I can see the reactions in members' pages but don't see any link in the navbar at all. Could this be because I'm not using the standard ProSilver style, but a third party one (Flat Style modified to give grey colour), or have I missed turning something on?

Aha it looks to be there in Quick Links?

It'd be very useful if that reactions page could show the articles reacted to?

I'm also trying to work out what the orange icons next to the reaction mean? The first looks to be a count, but the other?

Screenshot 2022-03-05 at 09.03.06.jpg

[Steve]

If you click on the reaction image it direct you to the post.

[dbrewood]

Yep I just worked that one out

[dbrewood]

I've had to disable the extension alas as it slowed down the forum too much and the users were complaining about the loss in speed. I'll try it again when the next version comes out to see if that is any better.

[Steve]

I've had to disable the extension, alas, as it slowed down the forum too much and the users were complaining about the loss in speed. I'll try it again when the next version comes out to see if that is any better.

What pages are slowed down?

In view topic page, I only add one database query and call a very small amount of text data from one row in the posts table.

At the bottom of your website page, you will find "SQL Explain" link, click on that to generate a report and look for in the pic below the query from the reactions table. This will show if it's the reaction's table slowing view topic, for example.

SQL-Report.png

Adding a reaction requests 3 queries from the database and updates only 3 tables and one other row, which is very small data. and they very simple requests etc.

//edit

The only thing I can think of that is slowing down your server with reactions enabled is you server has some sort of cache running behind the scenes for example varnish e cache etc …

[dbrewood]

Thanks for that, that SQL table showed:

Screenshot 2022-03-06 at 14.27.19.jpg

It seemed the high loading only happened when it was used in conjunction with the 'Who Visited This Topic', I've now disabled that and we're seeing how it goes.

[Steve]

High load is general from an sql query that is looped with in a foreach statement … I know it’s not my extension as I’ve worked on this for years and I never encountered any issues on any server I’ve ever been on…

Regards and have fun.