[XB] User Reputation [Paid] 2.1.3

Painbaker · Nov 25, 2024

Painbaker submitted a new resource:

[XB] User Reputation - Enhance user interaction and recognize valuable community members

This add-on lets members rate each other based on their contributions, helping to highlight active and valuable users within the community.

Features:

BB-code support: Add formatted content like images or links to reputation ratings.

Attachment support: Attach files to reputation ratings for additional context or evidence.

Approval queue support: Admins can review and approve reputation ratings before they become visible.

...

Read more about this resource...

hakyangler · Feb 5, 2025

Macro public : b_ur_rating_macros :: user_rating_bar() error: Division by zero

3 dakika önce
src/addons/PB/UserReputation/XF/Entity/User.php:85

Code:

Sunucu hata günlüğü
DivisionByZeroError: Macro public:pb_ur_rating_macros :: user_rating_bar() error: Division by zero src/addons/PB/UserReputation/XF/Entity/User.php:85
Tarafından: OltaMisina 05.02.2025 11:14'de
Yığın izleme
#0 src/XF/Template/Templater.php(1283): PB\UserReputation\XF\Entity\User->getPositiveReputationPercentage()
#1 internal_data/code_cache/templates/l2/s3/public/pb_ur_rating_macros.php(473): XF\Template\Templater->method(Object(SV\AdvancedBbCodesPack\XF\Entity\User), 'getPositiveRepu...', Array)
#2 src/XF/Template/Templater.php(922): XF\Template\Templater->{closure}(Object(SV\StandardLib\XF\Template\Templater), Array, NULL)
#3 internal_data/code_cache/templates/l2/s3/public/pb_ur_rating_macros.php(448): XF\Template\Templater->callMacro('pb_ur_rating_ma...', 'user_rating_bar', Array, Array)
#4 src/XF/Template/Templater.php(922): XF\Template\Templater->{closure}(Object(SV\StandardLib\XF\Template\Templater), Array, NULL)
#5 internal_data/code_cache/templates/l2/s3/public/pb_ur_message_macros_score.php(10): XF\Template\Templater->callMacro('pb_ur_rating_ma...', 'user_rating', Array, Array)
#6 src/XF/Template/Templater.php(1800): XF\Template\Templater->{closure}(Object(SV\StandardLib\XF\Template\Templater), Array, NULL)
#7 src/XF/Template/Templater.php(1874): XF\Template\Templater->renderTemplate('pb_ur_message_m...', Array)
#8 internal_data/code_cache/templates/l2/s3/public/message_macros.php(126): XF\Template\Templater->includeTemplate('public:pb_ur_me...', Array)
#9 src/XF/Template/Templater.php(922): XF\Template\Templater->{closure}(Object(SV\StandardLib\XF\Template\Templater), Array, NULL)
#10 internal_data/code_cache/templates/l2/s3/public/post_macros.php(25): XF\Template\Templater->callMacro('message_macros', 'user_info', Array, Array)
#11 src/XF/Template/Templater.php(1093): XF\Template\Templater->{closure}(Object(SV\StandardLib\XF\Template\Templater), Array, Object(XF\Template\ExtensionSet))
#12 src/XF/Template/Templater.php(1029): XF\Template\Templater->renderExtensionInternal('user_cell', Array, Array, Object(XF\Template\ExtensionSet))
#13 internal_data/code_cache/templates/l2/s3/public/post_macros.php(156): XF\Template\Templater->renderExtension('user_cell', Array, Object(XF\Template\ExtensionSet))
#14 src/XF/Template/Templater.php(1093): XF\Template\Templater->{closure}(Object(SV\StandardLib\XF\Template\Templater), Array, Object(XF\Template\ExtensionSet))
#15 src/XF/Template/Templater.php(1029): XF\Template\Templater->renderExtensionInternal('full_body', Array, Array, Object(XF\Template\ExtensionSet))
#16 internal_data/code_cache/templates/l2/s3/public/post_macros.php(203): XF\Template\Templater->renderExtension('full_body', Array, Object(XF\Template\ExtensionSet))
#17 src/XF/Template/Templater.php(922): XF\Template\Templater->{closure}(Object(SV\StandardLib\XF\Template\Templater), Array, Object(XF\Template\ExtensionSet))
#18 internal_data/code_cache/templates/l2/s3/public/thread_view.php(1061): XF\Template\Templater->callMacro('post_macros', 'post', Array, Array)
#19 src/XF/Template/Templater.php(1800): XF\Template\Templater->{closure}(Object(SV\StandardLib\XF\Template\Templater), Array, Object(XF\Template\ExtensionSet))
#20 src/XF/Template/Template.php(24): XF\Template\Templater->renderTemplate('thread_view', Array)
#21 src/XF/Mvc/Renderer/Html.php(50): XF\Template\Template->render()
#22 src/XF/Mvc/Dispatcher.php(471): XF\Mvc\Renderer\Html->renderView('XF:Thread\\View', 'public:thread_v...', Array)
#23 src/XF/Mvc/Dispatcher.php(453): XF\Mvc\Dispatcher->renderView(Object(XF\Mvc\Renderer\Html), Object(XF\Mvc\Reply\View))
#24 src/XF/Mvc/Dispatcher.php(412): XF\Mvc\Dispatcher->renderReply(Object(XF\Mvc\Renderer\Html), Object(XF\Mvc\Reply\View))
#25 src/XF/Mvc/Dispatcher.php(66): XF\Mvc\Dispatcher->render(Object(XF\Mvc\Reply\View), 'html')
#26 src/XF/App.php(2826): XF\Mvc\Dispatcher->run()
#27 src/XF.php(806): XF\App->run()
#28 index.php(23): XF::runApp('XF\\Pub\\App')
#29 {main}
Durum isteği
array(4) {
  ["url"] => string(68) "/konular/yenilikler-ozeti-gunluk-haftalik-ve-ya-aylik-e-postalar.55/"
  ["referrer"] => string(90) "https://oltamisina.com/konular/yenilikler-ozeti-gunluk-haftalik-ve-ya-aylik-e-postalar.55/"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(0) {
  }
}

Painbaker · Feb 5, 2025

Painbaker updated [XB] User Reputation with a new update entry:

2.1.1 Patch Level 3

Feature: added option to allow rating with empty message
Fix: avoid division by zero error

Read the rest of this update entry...

Painbaker · Feb 5, 2025

hakyangler said:

Macro public : b_ur_rating_macros :: user_rating_bar() error: Division by zero

3 dakika önce
src/addons/PB/UserReputation/XF/Entity/User.php:85

Code:

Sunucu hata günlüğü
DivisionByZeroError: Macro public:pb_ur_rating_macros :: user_rating_bar() error: Division by zero src/addons/PB/UserReputation/XF/Entity/User.php:85
Tarafından: OltaMisina 05.02.2025 11:14'de
Yığın izleme
#0 src/XF/Template/Templater.php(1283): PB\UserReputation\XF\Entity\User->getPositiveReputationPercentage()
#1 internal_data/code_cache/templates/l2/s3/public/pb_ur_rating_macros.php(473): XF\Template\Templater->method(Object(SV\AdvancedBbCodesPack\XF\Entity\User), 'getPositiveRepu...', Array)
#2 src/XF/Template/Templater.php(922): XF\Template\Templater->{closure}(Object(SV\StandardLib\XF\Template\Templater), Array, NULL)
#3 internal_data/code_cache/templates/l2/s3/public/pb_ur_rating_macros.php(448): XF\Template\Templater->callMacro('pb_ur_rating_ma...', 'user_rating_bar', Array, Array)
#4 src/XF/Template/Templater.php(922): XF\Template\Templater->{closure}(Object(SV\StandardLib\XF\Template\Templater), Array, NULL)
#5 internal_data/code_cache/templates/l2/s3/public/pb_ur_message_macros_score.php(10): XF\Template\Templater->callMacro('pb_ur_rating_ma...', 'user_rating', Array, Array)
#6 src/XF/Template/Templater.php(1800): XF\Template\Templater->{closure}(Object(SV\StandardLib\XF\Template\Templater), Array, NULL)
#7 src/XF/Template/Templater.php(1874): XF\Template\Templater->renderTemplate('pb_ur_message_m...', Array)
#8 internal_data/code_cache/templates/l2/s3/public/message_macros.php(126): XF\Template\Templater->includeTemplate('public:pb_ur_me...', Array)
#9 src/XF/Template/Templater.php(922): XF\Template\Templater->{closure}(Object(SV\StandardLib\XF\Template\Templater), Array, NULL)
#10 internal_data/code_cache/templates/l2/s3/public/post_macros.php(25): XF\Template\Templater->callMacro('message_macros', 'user_info', Array, Array)
#11 src/XF/Template/Templater.php(1093): XF\Template\Templater->{closure}(Object(SV\StandardLib\XF\Template\Templater), Array, Object(XF\Template\ExtensionSet))
#12 src/XF/Template/Templater.php(1029): XF\Template\Templater->renderExtensionInternal('user_cell', Array, Array, Object(XF\Template\ExtensionSet))
#13 internal_data/code_cache/templates/l2/s3/public/post_macros.php(156): XF\Template\Templater->renderExtension('user_cell', Array, Object(XF\Template\ExtensionSet))
#14 src/XF/Template/Templater.php(1093): XF\Template\Templater->{closure}(Object(SV\StandardLib\XF\Template\Templater), Array, Object(XF\Template\ExtensionSet))
#15 src/XF/Template/Templater.php(1029): XF\Template\Templater->renderExtensionInternal('full_body', Array, Array, Object(XF\Template\ExtensionSet))
#16 internal_data/code_cache/templates/l2/s3/public/post_macros.php(203): XF\Template\Templater->renderExtension('full_body', Array, Object(XF\Template\ExtensionSet))
#17 src/XF/Template/Templater.php(922): XF\Template\Templater->{closure}(Object(SV\StandardLib\XF\Template\Templater), Array, Object(XF\Template\ExtensionSet))
#18 internal_data/code_cache/templates/l2/s3/public/thread_view.php(1061): XF\Template\Templater->callMacro('post_macros', 'post', Array, Array)
#19 src/XF/Template/Templater.php(1800): XF\Template\Templater->{closure}(Object(SV\StandardLib\XF\Template\Templater), Array, Object(XF\Template\ExtensionSet))
#20 src/XF/Template/Template.php(24): XF\Template\Templater->renderTemplate('thread_view', Array)
#21 src/XF/Mvc/Renderer/Html.php(50): XF\Template\Template->render()
#22 src/XF/Mvc/Dispatcher.php(471): XF\Mvc\Renderer\Html->renderView('XF:Thread\\View', 'public:thread_v...', Array)
#23 src/XF/Mvc/Dispatcher.php(453): XF\Mvc\Dispatcher->renderView(Object(XF\Mvc\Renderer\Html), Object(XF\Mvc\Reply\View))
#24 src/XF/Mvc/Dispatcher.php(412): XF\Mvc\Dispatcher->renderReply(Object(XF\Mvc\Renderer\Html), Object(XF\Mvc\Reply\View))
#25 src/XF/Mvc/Dispatcher.php(66): XF\Mvc\Dispatcher->render(Object(XF\Mvc\Reply\View), 'html')
#26 src/XF/App.php(2826): XF\Mvc\Dispatcher->run()
#27 src/XF.php(806): XF\App->run()
#28 index.php(23): XF::runApp('XF\\Pub\\App')
#29 {main}
Durum isteği
array(4) {
  ["url"] => string(68) "/konular/yenilikler-ozeti-gunluk-haftalik-ve-ya-aylik-e-postalar.55/"
  ["referrer"] => string(90) "https://oltamisina.com/konular/yenilikler-ozeti-gunluk-haftalik-ve-ya-aylik-e-postalar.55/"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(0) {
  }
}

Try latest patch please

Painbaker · Feb 17, 2025

Painbaker updated [XB] User Reputation with a new update entry:

2.1.2

Added an option to require users to rate X other users before submitting a repeated rating

Read the rest of this update entry...

Painbaker · Jun 4, 2025

Painbaker updated [XB] User Reputation with a new update entry:

2.1.3

Show content associated with user-submitted ratings

Read the rest of this update entry...

Gemma · Jun 5, 2025

I'm getting an error when trying to install this:

XF\Db\InvalidQueryException: Batch install error: xf_user: MySQL query error [1069]: Too many keys specified; max 64 keys allowed src/XF/Db/AbstractStatement.php:230

Stack trace

ALTER TABLE `xf_user`
ADD `pb_ur_score` INT NOT NULL DEFAULT '0',
ADD `pb_ur_count_total` INT UNSIGNED NOT NULL DEFAULT '0',
ADD `pb_ur_count_positive` INT UNSIGNED NOT NULL DEFAULT '0',
ADD `pb_ur_count_negative` INT UNSIGNED NOT NULL DEFAULT '0',
ADD KEY `pb_ur_score` (`pb_ur_score`),
ADD KEY `pb_ur_count_total` (`pb_ur_count_total`),
ADD KEY `pb_ur_count_positive` (`pb_ur_count_positive`),
ADD KEY `pb_ur_count_negative` (`pb_ur_count_negative`)
------------

#0 src/XF/Db/Mysqli/Statement.php(207): XF\Db\AbstractStatement->getException('MySQL query err...', 1069, '42000')
#1 src/XF/Db/Mysqli/Statement.php(83): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1069, '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/PB/UserReputation/Setup.php(39): XF\Db\SchemaManager->alterTable('xf_user', Object(Closure))
#6 src/XF/AddOn/StepRunnerInstallTrait.php(62): PB\UserReputation\Setup->installStep2(Array)
#7 src/XF/AddOn/StepRunnerInstallTrait.php(29): PB\UserReputation\Setup->installStepRunner(2, Array)
#8 src/XF/Job/AddOnInstallBatch.php(299): PB\UserReputation\Setup->install(Array)
#9 src/XF/Job/AddOnInstallBatch.php(95): XF\Job\AddOnInstallBatch->stepAction(Object(XF\Timer))
#10 src/XF/Job/Manager.php(275): XF\Job\AddOnInstallBatch->run(8)
#11 src/XF/Job/Manager.php(205): XF\Job\Manager->runJobInternal(Array, 8)
#12 src/XF/Job/Manager.php(121): XF\Job\Manager->runJobEntry(Array, 8)
#13 src/XF/Admin/Controller/ToolsController.php(146): XF\Job\Manager->runByIds(Array, 8)
#14 src/XF/Mvc/Dispatcher.php(362): XF\Admin\Controller\ToolsController->actionRunJob(Object(XF\Mvc\ParameterBag))
#15 src/XF/Mvc/Dispatcher.php(264): XF\Mvc\Dispatcher->dispatchClass('XF:Tools', 'RunJob', Object(XF\Mvc\RouteMatch), Object(ThemeHouse\UserCriteria\XF\Admin\Controller\Tools), NULL)
#16 src/XF/Mvc/Dispatcher.php(121): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(ThemeHouse\UserCriteria\XF\Admin\Controller\Tools), NULL)
#17 src/XF/Mvc/Dispatcher.php(63): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#18 src/XF/App.php(2826): XF\Mvc\Dispatcher->run()
#19 src/XF.php(806): XF\App->run()
#20 admin.php(15): XF::runApp('XF\\Admin\\App')
#21 {main}

Painbaker · Jun 5, 2025

Gemma said:
I'm getting an error when trying to install this:

It seems that you have installed so many add-ons that you have exceeded the MySQL table indexes limit which is hard-coded and cannot be increased.

You can comment out these lines in Setup.php

PHP:

    /**
     * @return array
     */
    protected function getAlters()
    {
        $alters = [];

        $alters['xf_user'] = function (Alter $table) {
            $table->addColumn('pb_ur_score', 'int')->unsigned(false)->setDefault(0);
            $table->addColumn('pb_ur_count_total', 'int')->setDefault(0);
            $table->addColumn('pb_ur_count_positive', 'int')->setDefault(0);
            $table->addColumn('pb_ur_count_negative', 'int')->setDefault(0);
            // $table->addKey('pb_ur_score');
            // $table->addKey('pb_ur_count_total');
            // $table->addKey('pb_ur_count_positive');
            // $table->addKey('pb_ur_count_negative');
        };

        return $alters;
    }

However, this may affect performance in places where users are sorted by rating.

Gemma · Jun 5, 2025

Painbaker said:
It seems that you have installed so many add-ons that you have exceeded the MySQL table indexes limit which is hard-coded and cannot be increased.

I've deleted some inactive addons, and it seems to have solved the problem.

[XB] User Reputation [Paid] 2.1.3

Features:​

Features: