Posts of the Week 1.0.10

[JohnLogar]

Why does the plugin degrade users' avatars so much? It feels like it reduces them to half their size and applies the maximum JPEG compression possible.
Why does the plugin override the display of avatars at all and interfere with how they are rendered?

Please send me Dm with details your XF versions. I will look into in.

 

[USCSS_Nostromo]

Does this plugin count all reactions, or only “likes” and “laugh” reactions?

A person passed away, and a post about their death is receiving a large number of sad reactions. I suspect that based on the total number of reactions, it will end up in the “Posts of the Week” section - but I’d rather avoid that.

Maybe it would make sense to add an optional setting so that only “positive posts” appear in “Posts of the Week,” for example, posts where more than >50% of the reactions are “likes” or “laughing” emojis?

 

[neon tetra]

Looks like a solid addon. Does it sort and show the posts in a descending order if e.g. the reaction score is set to 10?

I would be very interested in this if it can keep a record of how many times a user has won the POTW and if that counter can be shown in the user postbit and member profiles e.g:

Joined: Jan 01, 2020
Messages: 500
POTW: 3

Thank you for the kind words and great feedback!

Yes, the add-on sorts posts in descending order based on the selected metric—so if you set the reaction score threshold to 10, it will show the top posts meeting or exceeding that score, with the highest at the top.

As for your suggestion regarding tracking how many times a user has won POTW and displaying it in their postbit and member profile—this is a fantastic idea! It’s not currently built-in, but it’s on my roadmap as a potential feature in an upcoming release. We’ll make sure to explore this and keep you updated.

Really appreciate your interest—stay tuned!

Just waiting on this feature to be added, then I’ll be ready to roll it out on my live site!

Also, I really like the idea mentioned above about allowing admins and moderators to manually assign POTW. Sometimes the number of reactions doesn’t truly reflect the quality or effort behind a post, so having the option for a subjective decision makes a lot of sense.

Thanks so much for the feedback and enthusiasm!

I’m really glad to hear you're planning to roll it out on your live site once that feature is added. Tracking how many times a user has won POTW and showing it in the postbit/profile is still on my roadmap—it’s definitely something I want to implement in a meaningful and flexible way.

As for manual POTW selection by admins or moderators—completely agree with your point. Quality often goes beyond reactions, and I’m exploring ways to allow that functionality while keeping the experience intuitive. This one might land as a configurable permission or action—stay tuned!

Appreciate your continued interest and support.

Been over a year since I am waiting to implement this plugin on my website. Your roadmap is quite long

 

[JohnLogar]

Been over a year since I am waiting to implement this plugin on my website. Your roadmap is quite long

First off — thank you for hanging in there, seriously. A year is a long time and i totally get why you're feeling the wait.

Our roadmap is packed, no denying that But your feedback genuinely helps me figure out what to push up the list. This one is on my radar and I'm working toward it.

I'll give you a heads up as soon as it's closer to ready. Really appreciate your patience with me!

 

[JohnLogar]

Does this plugin count all reactions, or only “likes” and “laugh” reactions?

it counts all reactions.

 

[JohnLogar]

JohnLogar updated Posts of the Week with a new update entry:

New Features and performance improvement

What's New in 1.0.10:

This major update brings recognition, moderation, and performance improvements:

• POTW Win Counter: The add-on now automatically records the winner of each week (the most reacted post) and keeps a full win history. Each user's total wins are displayed as a "POTW" counter in the message user info (postbit) and on member profiles — permanent recognition for your best contributors.
• Promote to POTW: A new "Can promote POTW?" permission lets...

Read the rest of this update entry...

 

[JohnLogar]

Can you make this instead admin selectable? For example any post we click ... dots and select "Make it POTW" or "Add to POTW"

Added in the new release.

Looks like a solid addon. Does it sort and show the posts in a descending order if e.g. the reaction score is set to 10?

I would be very interested in this if it can keep a record of how many times a user has won the POTW and if that counter can be shown in the user postbit and member profiles e.g:

Joined: Jan 01, 2020
Messages: 500
POTW: 3

Added in the new release.

 

[JohnLogar]

JohnLogar updated Posts of the Week with a new update entry:

Version Name correction

Version Name correction

Read the rest of this update entry...

 

[dutchbb]

Update not working.

Edit: after a rebuild it worked.

One or more add-ons currently have actions pending and may be in an inconsistent state. Because of this, some errors may be suppressed and unexpected behavior may occur. If this does not change shortly, please contact the add-on author for guidance.

XF\Db\InvalidQueryException: xf_post: MySQL query error [1061]: Duplicate key name 'cb_potw_date_reaction' src/XF/Db/AbstractStatement.php:225

Stack trace
ALTER TABLE `xf_post`
ADD KEY `cb_potw_date_reaction` (`post_date`, `reaction_score`)
------------

#0 src/XF/Db/Mysqli/Statement.php(207): XF\Db\AbstractStatement->getException('MySQL query err...', 1061, '42000')
#1 src/XF/Db/Mysqli/Statement.php(83): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1061, '42000')
#2 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Db/Schema/AbstractDdl.php(158): XF\Db\AbstractAdapter->query('ALTER TABLE `xf...')
#4 src/XF/Db/SchemaManager.php(157): XF\Db\Schema\AbstractDdl->apply()
#5 src/addons/CoderBeams/POTW/Setup.php(103): XF\Db\SchemaManager->alterTable('xf_post', Object(Closure))
#6 src/addons/CoderBeams/POTW/Setup.php(155): CoderBeams\POTW\Setup->installStep4()
#7 src/XF/AddOn/StepRunnerUpgradeTrait.php(124): CoderBeams\POTW\Setup->upgrade19Step1(Array)
#8 src/XF/AddOn/StepRunnerUpgradeTrait.php(73): CoderBeams\POTW\Setup->upgradeStepRunner(19, 1, Array, 20)
#9 src/XF/Admin/Controller/AddOnController.php(612): CoderBeams\POTW\Setup->upgrade(Array)
#10 src/XF/Mvc/Dispatcher.php(364): XF\Admin\Controller\AddOnController->actionUpgrade(Object(XF\Mvc\ParameterBag))
#11 src/XF/Mvc/Dispatcher.php(266): XF\Mvc\Dispatcher->dispatchClass('XF:AddOn', 'Upgrade', Object(XF\Mvc\RouteMatch), Object(Bespoke\SequentialStickies\XF\Admin\Controller\AddOn), NULL)
#12 src/XF/Mvc/Dispatcher.php(121): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(Bespoke\SequentialStickies\XF\Admin\Controller\AddOn), NULL)
#13 src/XF/Mvc/Dispatcher.php(63): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#14 src/XF/App.php(2830): XF\Mvc\Dispatcher->run()
#15 src/XF.php(844): XF\App->run()
#16 admin.php(15): XF::runApp('XF\\Admin\\App')
#17 {main}

Request state
array(4) {
  ["url"] => string(42) "/admin.php?add-ons/CoderBeams-POTW/upgrade"
  ["referrer"] => string(71) "/admin.php?add-ons/CoderBeams-POTW/upgrade"
  ["_GET"] => array(1) {
    ["add-ons/CoderBeams-POTW/upgrade"] => string(0) ""
  }
  ["_POST"] => array(7) {
    ["_xfProcessing"] => string(1) "1"
    ["continue"] => string(1) "1"
    ["confirm"] => string(1) "1"
    ["params"] => string(2) "[]"
    ["count"] => string(1) "1"
    ["finished"] => string(1) "0"
    ["_xfToken"] => string(8) "********"
  }
}

 

[JohnLogar]

@dutchbb
Thanks for the report, and glad it's resolved — your board is in a fully correct state, no action needed. Here's what happened for anyone else who hits this:

Version 1.0.10 adds a database index to the post table to speed up POTW queries. On larger forums that single step can take a while, and in your case the first upgrade attempt was interrupted (that's what the "actions pending" notice was about) — most commonly a PHP or proxy timeout — after MySQL had already created the index but before XenForo could mark the step finished. When the upgrade was retried, it attempted to create the same index again and MySQL correctly refused with "Duplicate key name".

Running Rebuild was exactly the right fix: it completes the remaining data import and finalizes the version, and since the index already existed, everything is now in place. You can verify under Admin CP → Add-ons that Posts of the Week shows 1.0.10 with no pending actions.

Two notes going forward:

1. If you run a large board, upgrading add-ons from the command line avoids web timeouts entirely: php cmd.php xf-addon:upgrade CoderBeams/POTW
2. The next release will handle an interrupted-and-retried upgrade of this step gracefully, so this error can't appear even in that scenario.

Thanks again for including the full stack trace — it made the diagnosis straightforward.

 

[DigitalME]

Just played with this, awesome app. I'd love the ability for this to post in a thread or update a thread every week instead of a custom page.

 

[JohnLogar]

Just played with this, awesome app. I'd love the ability for this to post in a thread or update a thread every week instead of a custom page.

Glad you enjoyed playing with it! I really appreciate the feedback and the suggestion about posting/updating a thread weekly — that’s definitely something I can consider for a future update.


If you have a moment, I’d really appreciate it if you could leave a review for the add-on. Your feedback would help others know what to expect and would mean a lot to me as the developer.